Help with Microsoft Excel 2013 Assignment!!!
camlle2
e04f_new_york_revenue.xlsxSales Data
| Jesses Jewelers | ||||||||||||
| Last Year: New York-Accessories Sales | Projected: New York-Accessories Sales | |||||||||||
| Product | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % |
| Key Chains | 1,548 | 1,638 | 1,530 | 1,755 | 6,471 | 22% | 1,765 | 1,867 | 1,744 | 2,001 | 7,377 | 20% |
| Belts | 1,089 | 1,026 | 1,350 | 1,638 | 5,103 | 17% | 1,361 | 1,170 | 1,688 | 2,048 | 6,266 | 17% |
| Scarves | 1,755 | 1,440 | 1,692 | 1,845 | 6,732 | 22% | 1,843 | 1,512 | 1,777 | 1,937 | 7,069 | ERROR:#DIV/0! |
| Wallets | 1,935 | 1,755 | 1,805 | 1,705 | 5,495 | 18% | 2,283 | 2,071 | 2,130 | 2,012 | 8,496 | 23% |
| Business Card Cases | 1,350 | 1,170 | 1,674 | 2,025 | 6,219 | 21% | 1,647 | 1,427 | 1,908 | 2,471 | 7,453 | 20% |
| Total | 7,677 | 7,029 | 8,051 | 8,968 | 30,020 | 8,899 | 8,047 | 9,247 | 10,468 | 36,661 | ||
| Assumptions | ||||||||||||
| Item | Growth | |||||||||||
| Key Chains | 14.0% | |||||||||||
| Belts | 25.0% | |||||||||||
| Scarves | 5.0% | |||||||||||
| Wallets | 18.0% | |||||||||||
| Business Card Cases | 22.0% | |||||||||||
