Excel computer homework
garretmadisonnoah
go_ev1_grader_cap.xlsxQuarterly Sales Summary
| Ice Creamery Sales | ||||||
| 2016 Analysis | ||||||
| Projected Sales Growth | 35% | |||||
| Product | Q1 | Q2 | Q3 | Q4 | Total 2016 | Projected 2017 Sales |
| Ice cream bars - chocolate | $ 236,200 | $ 307,060 | $ 347,214 | $ 229,114 | $ 1,119,588 | |
| Ice cream bars - vanilla | 522,300 | 678,990 | 767,781 | 506,631 | $ 2,475,702 | |
| Ice cream cups - chocolate | 487,200 | 633,360 | 716,184 | 472,584 | $ 2,309,328 | |
| Ice cream cups - vanilla | 625,112 | 812,645 | 918,945 | 606,332 | $ 2,963,034 | |
| Ice cream cups - strawberry | 152,622 | 198,408 | 155,694 | 148,022 | $ 654,746 | |
| Ice cream sandwiches | 337,563 | 439,915 | 325,225 | 236,542 | $ 1,339,245 | |
| Ice cream cones | 121,200 | 157,560 | 178,164 | 117,564 | $ 574,488 |
Bonuses
| Ice Creamery Sales | |||||||||
| Bonus Summary | |||||||||
| First Name | Last Name | City | State | Q1 | Q2 | Q3 | Q4 | Total Sales | Bonus? |
| Trey | Beiter | Pratt | CT | $18,807 | $24,449 | $25,818 | $17,556 | $86,630 | |
| Sydney | Brenton | Pratt | CT | $18,748 | $24,372 | $25,737 | $17,501 | $86,359 | |
| Samuel | Cordell | Pratt | CT | $18,689 | $24,296 | $25,656 | $17,446 | $86,087 | |
| Lori | Kackowski | Pine Valley | NJ | $18,935 | $24,615 | $25,994 | $17,676 | $87,219 | |
| Lisa | Kaldahl | Pine Valley | NJ | $18,787 | $24,423 | $25,790 | $17,537 | $86,537 | |
| Lisa | Kennedy | Pine Valley | NJ | $18,638 | $24,230 | $25,587 | $17,399 | $85,854 | |
| Ted | Boberg | Hamton | NY | $26,636 | $34,627 | $36,566 | $24,865 | $122,694 | |
| Ryan | Day | Hamton | NY | $25,203 | $32,600 | $34,930 | $23,752 | $116,486 | |
| Morgan | Ford | Hamton | NY | $21,416 | $27,841 | $29,400 | $19,992 | $98,649 | |
| Emma | Replogle | Hamton | NY | $20,076 | $26,099 | $27,560 | $18,741 | $92,476 | |
| Summary Statistics | |||||||||
| Number of Salespeople – NY | |||||||||
| Number of Salespeople – NJ | |||||||||
| Number of Salespeople – CT | |||||||||
| Maximum Total Sales | |||||||||
| Minimum Total Sales | |||||||||
| Average Total Sales |
Sales Projections
| Ice Creamery Sales | |||||
| Sales Projections | |||||
| Projected Sales Growth | 30% | ||||
| Product | Total 2016 | Projected 2017 Sales | |||
| Ice cream bars - chocolate | $ 1,119,588 | $ 1,455,464 | |||
| Ice cream bars - vanilla | 2,475,702 | 3,218,413 | |||
| Ice cream cups - chocolate | 2,309,328 | 3,002,126 | |||
| Ice cream cups - vanilla | 2,963,034 | 3,851,944 | |||
| Ice cream cups - strawberry | 654,746 | 851,170 | |||
| Ice cream sandwiches | 1,339,245 | 1,741,019 | |||
| Ice cream cones | 574,488 | 746,834 | |||
| Total | $ 11,436,131 | $ 14,866,970 | |||
| Product | 12% | 20% | 25% | 30% | 35% |
| Ice cream bars - chocolate | |||||
| Ice cream bars - vanilla | |||||
| Ice cream cups - chocolate | |||||
| Ice cream cups - vanilla | |||||
| Ice cream cups - strawberry | |||||
| Ice cream sandwiches | |||||
| Ice cream cones | |||||
| Total | |||||
