Help with Microsoft Excel 2013 Assignment!!!
camlle2
e04g_online_bracelet_revenue.xlsxFood Sales Data
| Jesse Jewelers | ||||||||||||
| Last Year: Online Bracelet Sales | Projected: Online Bracelet Sales | |||||||||||
| Product | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % | 1st Qtr | 2nd Qtr | 3rd Qtr | 4th Qtr | Total | % |
| Crystal Bracelets | 1,898 | 2,008 | 1,876 | 2,151 | 7,933 | 22% | 2,164 | 2,289 | 2,139 | 2,452 | 9,044 | 20% |
| Beaded Bracelets | 1,337 | 1,254 | 1,656 | 2,002 | 6,249 | 17% | 1,671 | 1,430 | 2,070 | 2,503 | 7,673 | 17% |
| ID Bracelets | 2,145 | 1,766 | 2,074 | 2,255 | 8,240 | 22% | 2,252 | 1,854 | 2,178 | 2,368 | 8,652 | ERROR:#DIV/0! |
| Ankle Bracelets | 2,371 | 2,151 | 2,206 | 2,085 | 6,728 | 18% | 2,798 | 2,538 | 2,603 | 2,460 | 10,399 | 23% |
| Mens Bracelets | 1,656 | 1,436 | 2,052 | 2,475 | 7,619 | 21% | 2,020 | 1,752 | 2,339 | 3,020 | 9,131 | 20% |
| Total | 9,407 | 8,615 | 9,864 | 10,968 | 36,769 | 10,905 | 9,863 | 11,329 | 12,802 | 44,899 | ||
| Assumptions | ||||||||||||
| Item | Growth | |||||||||||
| Crystal Bracelets | 14.0% | |||||||||||
| Beaded Bracelets | 25.0% | |||||||||||
| ID Bracelets | 5.0% | |||||||||||
| Ankle Bracelets | 18.0% | |||||||||||
| Mens Bracelets | 22.0% | |||||||||||
