Richard Micheal Sharer

Excel applicatiokn assignment

3/21/2017

Keepin' Cool Ice Cream Sales 2016

Product January February March April May June July August September October November December Year Total percent of sales
Ninja turtle 20 21 20 20 30 60 70 90 110 15 10 5 471 7.81%
Sonic 15 14 15 16 15 20 75 105 135 15 25 5 455 7.55%
Pink Panther 10 11 10 12 30 65 100 135 170 15 10 15 583 9.67%
Power Puff Girl 10 11 11 12 19 25 31 37 43 15 10 5 229 3.80%

Spider-man 15 11 14 13 18 30 42 54 66 15 15 5 298 4.94%

Spongebob 15 11 15 15 26 15 4 15 25 15 10 10 176 2.92%

Tweety 20 5 19 21 28 30 32 34 36 15 10 5 255 4.23%

Original Bomb Pop 30 25 25 20 30 60 90 120 150 15 25 5 595 9.87%
Warhead Bomb Pop 30 20 25 23 50 70 90 110 130 15 10 5 578 9.59%

Watermelon Boomb Pop 35 16 17 19 45 45 45 45 45 15 10 15 352 5.84%

Orange dream Bar 40 30 35 20 30 60 90 120 150 15 10 5 605 10.04%

Star Bar 15 10 15 14 15 30 45 60 75 15 10 5 309 5.13%

Turtle Bar 12 5 7 6 20 59 98 137 176 15 30 5 570 9.46%
strawberry Frozfruit 5 2 3 5 15 45 75 105 135 15 10 5 420 6.97%
pineapple frozfruit 5 1 0 2 1 20 15 13 45 15 10 5 132 2.19%

monthly total 277 193 231 218 372 634 902 1180 1491 225 205 100 6028
monthly average 18 13 15 15 25 42 60 79 99 15 14 7

Top sellers 50
Needs work 5
 Sales per month

December 55
15510
5555
1555555

November 10
2510
10
15
10
10
2510
10
10
103010
10

October 15
15
15
15
15
15
15
15
15
15
15
15
15
15
15

September 110 135 170 43 66 2536 150 130 45 150 75 176 135 45

August 90 105 135 37 54 1534 120 110 45 120 60 137 105 13

July 70 75 100 31 42432 90 90 45 90 45 98 75 15

June 60 20 65 25301530 60 70 45 60 30 59 4520

May 30153019
18262830 50 45 3015
2015
1

April 20
16
12
12
13
15
21202319
2014
652

March 20
15
10
11
14
15
192525173515
73
0

February 21
14
11
11
11
11
52520
163010
52
1

20
15
10
10
15
1520303035 4015
12
55
January

0 200 400 600 800 1000 1200 1400 1600

Ninja turtle Sonic Pink Panther Power Puff Girl Spider-man

Spongebob Tweety Original Bomb Pop Warhead Bomb Pop Watermelon Boomb Pop
Orange dream Bar Star Bar Turtle Bar strawberry Frozfruit pineapple frozfruit
 $ amount January February
Product Amount $ Amount $
Ninja turtle $3 20 $60 21 $63
Sonic $3 15 $45 14 $42
Pink Panther $3 10 $30 11 $33
Power Puff Girl $3 10 $30 11 $33
Spider-man $3 15 $45 11 $33
Spongebob $3 15 $45 11 $33
Tweety $3 20 $60 5 $15
Original Bomb Pop $2 30 $60 25 $50
Warhead Bomb Pop $2 30 $60 20 $40
Watermelon Boomb Pop $2 35 $70 16 $32
Orange dream Bar $2 40 $80 30 $60
Star Bar $1 15 $15 10 $10
Turtle Bar $4 12 $48 5 $20
strawberry Frozfruit $2 5 $10 2 $4
pineapple frozfruit $2 5 $10 1 $2

Total Sales $668 $470

 March April May June
Amount $ Amount $ Amount $ Amount $
20 $60 20 $60 30 $90 50 $150
15 $45 16 $48 15 $45 45 $135
10 $30 12 $36 30 $90 65 $195
11 $33 12 $36 19 $57 25 $75
14 $42 13 $39 18 $54 30 $90
15 $45 15 $45 26 $78 15 $45
19 $57 21 $63 28 $84 30 $90
25 $50 20 $40 30 $60 60 $120
25 $50 23 $46 50 $100 70 $140
17 $34 19 $38 45 $90 45 $90
35 $70 20 $40 30 $60 60 $120
15 $15 14 $14 15 $15 30 $30
7 $28 6 $24 20 $80 59 $236
3 $6 5 $10 15 $30 45 $90
0 $0 2 $4 1 $2 20 $40

$565 $543 $845 $1,646

 July August September October
Amount $ Amount $ Amount $ Amount $
70 $210 90 $270 110 $330 15 $45
75 $225 105 $315 135 $405 15 $45
100 $300 135 $405 170 $510 15 $45
31 $93 37 $111 43 $129 15 $45
42 $126 54 $162 66 $198 15 $45
4 $12 15 $45 25 $75 15 $45
32 $96 34 $102 36 $108 15 $45
90 $180 120 $240 150 $300 15 $30
90 $180 110 $220 130 $260 15 $30
45 $90 45 $90 45 $90 15 $30
90 $180 120 $240 150 $300 15 $30
45 $45 60 $60 75 $75 15 $15
98 $392 137 $548 176 $704 15 $60
75 $150 105 $210 135 $270 15 $30
15 $30 13 $26 45 $90 15 $30

$2,309 $3,044 $3,844 $570

 November December Year Total
Amount $ Amount $ Amount $
10 $30 5 $15 461 $1,383
25 $75 5 $15 480 $1,440
10 $30 15 $45 583 $1,749
10 $30 5 $15 229 $687
15 $45 5 $15 298 $894
10 $30 10 $30 176 $528
10 $30 5 $15 255 $765
25 $50 5 $10 595 $1,190
10 $20 5 $10 578 $1,156
10 $20 15 $30 352 $704
10 $20 5 $10 605 $1,210
10 $10 5 $5 309 $309
30 $120 5 $20 570 $2,280
10 $20 5 $10 420 $840
10 $20 5 $10 132 $264

$550 $255 $15,399

 January Sales
Monday Tuesday Wednesday

Week 1

Bars sold

Bars sold LY
Sales

Sales LY

Week 2

Bars sold

Bars sold LY

Sales

Sales LY

Week 3

Bars sold

Bars sold LY

Sales

Sales LY

Week 4
Bars sold

Bars sold LY
Sales

Sales LY
uary Sales
Thursday Friday Saturday Sunday