Need assistance with a power point presentation that is due Wednesday

profileMsdillard82
FinalProjectData20162.xlsx
Home>Business & Finance homework help>Marketing homework help>Need assistance with a power point presentation that is due Wednesday

Trucks

Top't Corn Sales (July)
Truck Location
Farragut Square George Washington Georgetown K Street
Old Bay $ 2,100 $ 900 $ 800 $ 1,150
Truffle $ 2,510 $ 525 $ 1,005 $ 2,100
Sea Salt and Caramel $ 3,540 $ 1,660 $ 1,225 $ 2,010
Total $ 8,150 $ 3,085 $ 3,030 $ 5,260

July Sales by Location

Total

8150 3085 3030 5260

July Sales by Popcorn Type

Farragut Square Old Bay Truffle Sea Salt and Caramel 2100 2510 3540 George Washington Old Bay Truffle Sea Salt and Caramel 900 525 1660 Georgetown Old Bay Truffle Sea Salt and Caramel 800 1005 1225 K Street Old Bay Truffle Sea Salt and Caramel 1150 2100 2010

NewTruck

Price $42,000.00
Loan term (in months) 12
Interest (annual) 8%
Monthly Payment $3,653.51
Total Payments $43,842.17
Interest Paid $1,842.17
Average Sales $4,881.25
Buy new truck? Buy it!

TysonsStore

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) Daily Total ($) Sales Goal Met? Current price per box: $5
7/1/14 42 115 92 249 $1,245 no Daily sales goal: $1,250
7/2/14 42 42 117 201 $1,005 no Average daily sales: $1,325
7/3/14 105 124 64 293 $1,465 yes Lowest daily sales: $425
7/4/14 141 83 76 300 $1,500 yes Highest daily sales: $1,885
7/5/14 137 73 109 319 $1,595 yes
7/6/14 68 44 60 172 $860 no New target daily sales goal: $1,750
7/7/14 82 58 145 285 $1,425 yes New price per box: $7
7/8/14 125 96 92 313 $1,565 yes
7/9/14 20 26 39 85 $425 no
7/10/14 67 38 21 126 $630 no
7/11/14 121 124 132 377 $1,885 yes
7/12/14 140 76 25 241 $1,205 no
7/13/14 147 77 77 301 $1,505 yes
7/14/14 86 128 59 273 $1,365 yes
7/15/14 50 122 96 268 $1,340 yes
7/16/14 80 92 139 311 $1,555 yes
7/17/14 41 69 59 169 $845 no
7/18/14 26 38 125 189 $945 no
7/19/14 93 41 133 267 $1,335 yes
7/20/14 84 144 146 374 $1,870 yes
7/21/14 25 124 145 294 $1,470 yes
7/22/14 107 60 142 309 $1,545 yes
7/23/14 116 115 128 359 $1,795 yes
7/24/14 46 129 145 320 $1,600 yes
7/25/14 44 112 99 255 $1,275 yes
7/26/14 112 96 31 239 $1,195 no
7/27/14 73 102 97 272 $1,360 yes
7/28/14 100 89 109 298 $1,490 yes
7/29/14 55 30 75 160 $800 no
7/30/14 137 117 97 351 $1,755 yes
7/31/14 125 39 80 244 $1,220 no

OnlineSalesTable

Online Sales During Buy 1 Get 1 Free Sale
Date Quantity Item State
6/30/14 6 Old Bay MD
6/30/14 4 Old Bay MD
6/30/14 4 Old Bay NJ
6/30/14 2 Old Bay NJ
7/1/14 2 Old Bay ID
7/1/14 5 Old Bay MD
7/1/14 2 Old Bay MD
7/1/14 4 Old Bay MD
7/1/14 8 Old Bay VA
7/2/14 2 Old Bay MD
7/2/14 4 Old Bay DC
7/2/14 2 Old Bay VA
7/2/14 4 Old Bay MD
7/2/14 2 Old Bay WV
7/3/14 2 Old Bay NY
7/3/14 4 Old Bay OH
7/3/14 6 Old Bay CA
7/4/14 2 Old Bay CA
7/4/14 4 Old Bay DC
7/5/14 2 Old Bay MD
7/5/14 2 Old Bay DC
7/5/14 6 Old Bay MD
7/5/14 2 Old Bay MD
7/5/14 4 Old Bay VA
7/5/14 2 Old Bay MD
7/5/14 4 Old Bay VA
7/5/14 2 Old Bay WV
7/6/14 2 Old Bay MD
7/6/14 8 Old Bay MD
7/6/14 10 Old Bay WV
7/6/14 2 Old Bay DC
7/6/14 4 Old Bay NC
6/30/14 12 Original Blend OH
6/30/14 4 Original Blend CA
6/30/14 2 Original Blend AL
6/30/14 10 Original Blend NC
6/30/14 2 Original Blend VA
7/1/14 10 Original Blend AL
7/1/14 2 Original Blend NC
7/1/14 4 Original Blend VA
7/1/14 10 Original Blend WV
7/1/14 6 Original Blend OH
7/2/14 2 Original Blend AL
7/2/14 4 Original Blend DC
7/2/14 14 Original Blend NY
7/2/14 12 Original Blend WV
7/2/14 10 Original Blend OH
7/2/14 4 Original Blend AL
7/2/14 4 Original Blend SC
7/3/14 4 Original Blend OH
7/3/14 4 Original Blend NY
7/4/14 6 Original Blend AL
7/4/14 8 Original Blend MS
7/4/14 4 Original Blend CA
7/5/14 6 Original Blend MD
7/5/14 2 Original Blend AL
7/5/14 2 Original Blend OH
7/5/14 6 Original Blend CA
7/5/14 2 Original Blend MD
7/5/14 4 Original Blend VA
7/5/14 6 Original Blend NC
7/5/14 4 Original Blend WV
7/6/14 4 Original Blend CA
7/6/14 2 Original Blend MD
7/6/14 2 Original Blend WV
7/6/14 12 Original Blend WV
6/30/14 8 Sea Salt and Caramel MO
6/30/14 5 Sea Salt and Caramel NJ
6/30/14 8 Sea Salt and Caramel MS
6/30/14 4 Sea Salt and Caramel NY
7/1/14 2 Sea Salt and Caramel OH
7/1/14 2 Sea Salt and Caramel MS
7/1/14 6 Sea Salt and Caramel CA
7/1/14 4 Sea Salt and Caramel MO
7/1/14 2 Sea Salt and Caramel MS
7/2/14 6 Sea Salt and Caramel MS
7/2/14 10 Sea Salt and Caramel AL
7/2/14 2 Sea Salt and Caramel NC
7/2/14 2 Sea Salt and Caramel DC
7/3/14 2 Sea Salt and Caramel NJ
7/3/14 6 Sea Salt and Caramel NJ
7/4/14 2 Sea Salt and Caramel OH
7/4/14 12 Sea Salt and Caramel NJ
7/4/14 2 Sea Salt and Caramel WV
7/5/14 4 Sea Salt and Caramel NJ
7/5/14 2 Sea Salt and Caramel NY
7/5/14 6 Sea Salt and Caramel CA
7/5/14 2 Sea Salt and Caramel MS
7/6/14 6 Sea Salt and Caramel VA
7/6/14 4 Sea Salt and Caramel AL
7/6/14 2 Sea Salt and Caramel DC
7/6/14 4 Sea Salt and Caramel MD
7/6/14 2 Sea Salt and Caramel VA
7/6/14 10 Sea Salt and Caramel MS
6/30/14 8 Truffle VA
6/30/14 2 Truffle DC
6/30/14 14 Truffle DC
7/1/14 5 Truffle NY
7/1/14 6 Truffle NY
7/1/14 12 Truffle NY
7/2/14 2 Truffle NY
7/2/14 2 Truffle VA
7/2/14 2 Truffle SC
7/3/14 2 Truffle NY
7/3/14 2 Truffle DC
7/4/14 8 Truffle VA
7/5/14 4 Truffle VA
7/5/14 4 Truffle NY
7/5/14 8 Truffle CA
7/5/14 6 Truffle OH
7/6/14 2 Truffle OH
7/6/14 2 Truffle MD
7/6/14 2 Truffle VA
7/6/14 4 Truffle CA
7/6/14 10 Truffle CA
7/6/14 4 Truffle MO
7/6/14 6 Truffle AL
Total 553

PivotTable

Row Labels Sum of Quantity
Old Bay 119
Original Blend 190
Sea Salt and Caramel 127
Truffle 117
Grand Total 553

Sales by Flavor

Old Bay Original Blend Sea Salt and Caramel Truffle 119 190 127 117

PivotTable 2

Sum of Quantity Column Labels
Row Labels Old Bay Original Blend Sea Salt and Caramel Truffle Grand Total
6/30/14 4 4
CA 4 4
7/1/14 6 6
CA 6 6
7/3/14 6 6
CA 6 6
7/4/14 2 4 6
CA 2 4 6
7/5/14 6 6 8 20
CA 6 6 8 20
7/6/14 4 14 18
CA 4 14 18
Grand Total 8 18 12 22 60

PivotChart 2

Items by Date and State

Old Bay

CA CA CA CA CA CA 6/30/2014 7/1/2014 7/3/2014 7/4/2014 7/5/2014 7/6/2014 6 2 Original Blend

CA CA CA CA CA CA 6/30/2014 7/1/2014 7/3/2014 7/4/2014 7/5/2014 7/6/2014 4 4 6 4 Sea Salt and Caramel

CA CA CA CA CA CA 6/30/2014 7/1/2014 7/3/2014 7/4/2014 7/5/2014 7/6/2014 6 6 Truffle

CA CA CA CA CA CA 6/30/2014 7/1/2014 7/3/2014 7/4/2014 7/5/2014 7/6/2014 8 14

Data

Date Quantity Item State
6/30/14 6 Old Bay MD
6/30/14 12 Original Blend OH
6/30/14 4 Original Blend CA
6/30/14 8 Sea Salt and Caramel MO
6/30/14 5 Sea Salt and Caramel NJ
6/30/14 8 Truffle VA
6/30/14 2 Truffle DC
6/30/14 2 Original Blend AL
6/30/14 4 Old Bay MD
6/30/14 14 Truffle DC
6/30/14 8 Sea Salt and Caramel MS
6/30/14 10 Original Blend NC
6/30/14 2 Original Blend VA
6/30/14 4 Old Bay NJ
6/30/14 2 Old Bay NJ
6/30/14 4 Sea Salt and Caramel NY
7/1/14 2 Old Bay ID
7/1/14 2 Sea Salt and Caramel OH
7/1/14 5 Truffle NY
7/1/14 10 Original Blend AL
7/1/14 5 Old Bay MD
7/1/14 2 Original Blend NC
7/1/14 2 Sea Salt and Caramel MS
7/1/14 4 Original Blend VA
7/1/14 2 Old Bay MD
7/1/14 4 Old Bay MD
7/1/14 8 Old Bay VA
7/1/14 10 Original Blend WV
7/1/14 6 Sea Salt and Caramel CA
7/1/14 4 Sea Salt and Caramel MO
7/1/14 2 Sea Salt and Caramel MS
7/1/14 6 Truffle NY
7/1/14 12 Truffle NY
7/1/14 6 Original Blend OH
7/2/14 2 Truffle NY
7/2/14 2 Old Bay MD
7/2/14 4 Old Bay DC
7/2/14 6 Sea Salt and Caramel MS
7/2/14 10 Sea Salt and Caramel AL
7/2/14 2 Sea Salt and Caramel NC
7/2/14 2 Original Blend AL
7/2/14 4 Original Blend DC
7/2/14 14 Original Blend NY
7/2/14 12 Original Blend WV
7/2/14 10 Original Blend OH
7/2/14 2 Truffle VA
7/2/14 2 Old Bay VA
7/2/14 2 Sea Salt and Caramel DC
7/2/14 4 Old Bay MD
7/2/14 2 Old Bay WV
7/2/14 4 Original Blend AL
7/2/14 4 Original Blend SC
7/2/14 2 Truffle SC
7/3/14 4 Original Blend OH
7/3/14 4 Original Blend NY
7/3/14 2 Sea Salt and Caramel NJ
7/3/14 6 Sea Salt and Caramel NJ
7/3/14 2 Old Bay NY
7/3/14 2 Truffle NY
7/3/14 4 Old Bay OH
7/3/14 2 Truffle DC
7/3/14 6 Old Bay CA
7/4/14 6 Original Blend AL
7/4/14 8 Original Blend MS
7/4/14 2 Sea Salt and Caramel OH
7/4/14 2 Old Bay CA
7/4/14 4 Old Bay DC
7/4/14 4 Original Blend CA
7/4/14 8 Truffle VA
7/4/14 12 Sea Salt and Caramel NJ
7/4/14 2 Sea Salt and Caramel WV
7/5/14 2 Old Bay MD
7/5/14 2 Old Bay DC
7/5/14 4 Sea Salt and Caramel NJ
7/5/14 2 Sea Salt and Caramel NY
7/5/14 6 Original Blend MD
7/5/14 2 Original Blend AL
7/5/14 4 Truffle VA
7/5/14 6 Old Bay MD
7/5/14 2 Old Bay MD
7/5/14 4 Old Bay VA
7/5/14 4 Truffle NY
7/5/14 2 Original Blend OH
7/5/14 6 Sea Salt and Caramel CA
7/5/14 6 Original Blend CA
7/5/14 8 Truffle CA
7/5/14 2 Old Bay MD
7/5/14 2 Original Blend MD
7/5/14 4 Old Bay VA
7/5/14 4 Original Blend VA
7/5/14 2 Sea Salt and Caramel MS
7/5/14 6 Original Blend NC
7/5/14 4 Original Blend WV
7/5/14 2 Old Bay WV
7/5/14 6 Truffle OH
7/6/14 2 Old Bay MD
7/6/14 2 Truffle OH
7/6/14 4 Original Blend CA
7/6/14 2 Original Blend MD
7/6/14 6 Sea Salt and Caramel VA
7/6/14 2 Truffle MD
7/6/14 2 Truffle VA
7/6/14 4 Sea Salt and Caramel AL
7/6/14 8 Old Bay MD
7/6/14 10 Old Bay WV
7/6/14 2 Original Blend WV
7/6/14 4 Truffle CA
7/6/14 10 Truffle CA
7/6/14 4 Truffle MO
7/6/14 12 Original Blend WV
7/6/14 2 Sea Salt and Caramel DC
7/6/14 2 Old Bay DC
7/6/14 4 Sea Salt and Caramel MD
7/6/14 2 Sea Salt and Caramel VA
7/6/14 6 Truffle AL
7/6/14 10 Sea Salt and Caramel MS
7/6/14 4 Old Bay NC