Excel assignment

profileWerwer227
Andrew.Koontz-EX2019-MOS-Capstone.xlsx
Home>Computer Science homework help>Excel assignment

MobileSales

Top’t Corn Mobile Sales (August)
Truck Location
Farragut Square George Washington Georgetown K Street
Old Bay 2500 800 600 900
Truffle 3200 600 1200 1500
Sea Salt and Caramel 4200 1500 1400 1200

TruckLoan

Price $55,000.00
Interest (annual) 3%
Loan term (months) 24
Monthly Payment $2,363.97
Total Payments $56,735.20
Interest Paid $1,735.20

OnlineSales

Online Sales During Buy 1 Get 1 Free Sale
Date Quantity Item State
7/30/19 13 Old Bay MD
7/30/19 9 Original Blend OH
7/30/19 28 Original Blend CA
7/30/19 9 Sea Salt and Caramel MO
7/30/19 21 Sea Salt and Caramel NJ
7/30/19 9 Truffle VA
7/30/19 29 Truffle DC
7/30/19 20 Original Blend AL
7/30/19 17 Old Bay MD
7/30/19 20 Truffle DC
7/30/19 16 Sea Salt and Caramel MS
7/30/19 24 Original Blend NC
7/30/19 14 Original Blend VA
7/30/19 24 Old Bay NJ
7/30/19 9 Old Bay NJ
7/30/19 32 Sea Salt and Caramel NY
7/31/19 11 Old Bay ID
7/31/19 12 Sea Salt and Caramel OH
7/31/19 33 Truffle NY
7/31/19 28 Original Blend AL
7/31/19 17 Old Bay MD
7/31/19 31 Original Blend NC
7/31/19 30 Sea Salt and Caramel MS
7/31/19 21 Original Blend VA
7/31/19 21 Old Bay MD
7/31/19 9 Old Bay MD
7/31/19 9 Old Bay VA
7/31/19 27 Original Blend WV
7/31/19 13 Sea Salt and Caramel CA
7/31/19 11 Sea Salt and Caramel MO
7/31/19 16 Sea Salt and Caramel MS
7/31/19 34 Truffle NY
7/31/19 35 Truffle NY
7/31/19 28 Original Blend OH
8/1/19 26 Truffle NY
8/1/19 31 Old Bay MD
8/1/19 9 Old Bay DC
8/1/19 12 Sea Salt and Caramel MS
8/1/19 21 Sea Salt and Caramel AL
8/1/19 15 Sea Salt and Caramel NC
8/1/19 25 Original Blend AL
8/1/19 16 Original Blend DC
8/1/19 30 Original Blend NY
8/1/19 17 Original Blend WV
8/1/19 25 Original Blend OH
8/1/19 22 Truffle VA
8/1/19 13 Old Bay VA
8/1/19 16 Sea Salt and Caramel DC
8/1/19 17 Old Bay MD
8/1/19 11 Old Bay WV
8/1/19 20 Original Blend AL
8/1/19 10 Original Blend SC
8/1/19 16 Truffle SC
8/2/19 33 Original Blend OH
8/2/19 33 Original Blend NY
8/2/19 16 Sea Salt and Caramel NJ
8/2/19 20 Sea Salt and Caramel NJ
8/2/19 13 Old Bay NY
8/2/19 24 Truffle NY
8/2/19 22 Old Bay OH
8/2/19 10 Truffle DC
8/2/19 16 Old Bay CA
8/3/19 25 Original Blend AL
8/3/19 24 Original Blend MS
8/3/19 34 Sea Salt and Caramel OH
8/3/19 11 Old Bay CA
8/3/19 34 Old Bay DC
8/3/19 22 Original Blend CA
8/3/19 29 Truffle VA
8/3/19 29 Sea Salt and Caramel NJ
8/3/19 23 Sea Salt and Caramel WV
8/4/19 28 Old Bay MD
8/4/19 31 Old Bay DC
8/4/19 34 Sea Salt and Caramel NJ
8/4/19 21 Sea Salt and Caramel NY
8/4/19 21 Original Blend MD
8/4/19 33 Original Blend AL
8/4/19 14 Truffle VA
8/4/19 12 Old Bay MD
8/4/19 32 Old Bay MD
8/4/19 20 Old Bay VA
8/4/19 9 Truffle NY
8/4/19 24 Original Blend OH
8/4/19 31 Sea Salt and Caramel CA
8/4/19 18 Original Blend CA
8/4/19 21 Truffle CA
8/4/19 35 Old Bay MD
8/4/19 26 Original Blend MD
8/4/19 16 Old Bay VA
8/4/19 32 Original Blend VA
8/4/19 32 Sea Salt and Caramel MS
8/4/19 22 Original Blend NC
8/4/19 14 Original Blend WV
8/4/19 23 Old Bay WV
8/4/19 16 Truffle OH
8/5/19 12 Old Bay MD
8/5/19 28 Truffle OH
8/5/19 21 Original Blend CA
8/5/19 10 Original Blend MD
8/5/19 17 Sea Salt and Caramel VA
8/5/19 24 Truffle MD
8/5/19 30 Truffle VA
8/5/19 31 Sea Salt and Caramel AL
8/5/19 13 Old Bay MD
8/5/19 34 Old Bay WV
8/5/19 11 Original Blend WV
8/5/19 24 Truffle CA
8/5/19 9 Truffle CA
8/5/19 14 Truffle MO
8/5/19 16 Original Blend WV
8/5/19 29 Sea Salt and Caramel DC
8/5/19 32 Old Bay DC
8/5/19 15 Sea Salt and Caramel MD
8/5/19 28 Sea Salt and Caramel VA
8/5/19 18 Truffle AL
8/5/19 35 Sea Salt and Caramel MS
8/5/19 9 Old Bay NC

BOGOSale2018

Online Sales During Buy 1 Get 1 Free Sale
Date Quantity Item State
7/30/18 21 Old Bay MD
7/30/18 16 Original Blend OH
7/30/18 25 Original Blend CA
7/30/18 19 Sea Salt and Caramel MO
7/30/18 14 Sea Salt and Caramel NJ
7/30/18 21 Truffle VA
7/30/18 5 Truffle DC
7/30/18 11 Original Blend AL
7/30/18 23 Old Bay MD
7/30/18 13 Truffle DC
7/30/18 10 Sea Salt and Caramel MS
7/30/18 11 Original Blend NC
7/30/18 6 Original Blend VA
7/30/18 18 Old Bay NJ
7/30/18 18 Old Bay NJ
7/30/18 20 Sea Salt and Caramel NY
7/31/18 18 Old Bay ID
7/31/18 24 Sea Salt and Caramel OH
7/31/18 11 Truffle NY
7/31/18 16 Original Blend AL
7/31/18 14 Old Bay MD
7/31/18 20 Original Blend NC
7/31/18 14 Sea Salt and Caramel MS
7/31/18 9 Original Blend VA
7/31/18 19 Old Bay MD
7/31/18 25 Old Bay MD
7/31/18 20 Old Bay VA
7/31/18 15 Original Blend WV
7/31/18 5 Sea Salt and Caramel CA
7/31/18 7 Sea Salt and Caramel MO
7/31/18 7 Sea Salt and Caramel MS
7/31/18 12 Truffle NY
7/31/18 11 Truffle NY
7/31/18 6 Original Blend OH
8/1/18 5 Truffle NY
8/1/18 12 Old Bay MD
8/1/18 8 Old Bay DC
8/1/18 20 Sea Salt and Caramel MS
8/1/18 13 Sea Salt and Caramel AL
8/1/18 23 Sea Salt and Caramel NC
8/1/18 12 Original Blend AL
8/1/18 9 Original Blend DC
8/1/18 20 Original Blend NY
8/1/18 7 Original Blend WV
8/1/18 21 Original Blend OH
8/1/18 16 Truffle VA
8/1/18 14 Old Bay VA
8/1/18 24 Sea Salt and Caramel DC
8/1/18 23 Old Bay MD
8/1/18 17 Old Bay WV
8/1/18 11 Original Blend AL
8/1/18 25 Original Blend SC
8/1/18 6 Truffle SC
8/2/18 19 Original Blend OH
8/2/18 22 Original Blend NY
8/2/18 25 Sea Salt and Caramel NJ
8/2/18 13 Sea Salt and Caramel NJ
8/2/18 22 Old Bay NY
8/2/18 18 Truffle NY
8/2/18 14 Old Bay OH
8/2/18 5 Truffle DC
8/2/18 5 Old Bay CA
8/3/18 10 Original Blend AL
8/3/18 12 Original Blend MS
8/3/18 11 Sea Salt and Caramel OH
8/3/18 22 Old Bay CA
8/3/18 11 Old Bay DC
8/3/18 18 Original Blend CA
8/3/18 22 Truffle VA
8/3/18 13 Sea Salt and Caramel NJ
8/3/18 21 Sea Salt and Caramel WV
8/4/18 5 Old Bay MD
8/4/18 5 Old Bay DC
8/4/18 14 Sea Salt and Caramel NJ
8/4/18 11 Sea Salt and Caramel NY
8/4/18 15 Original Blend MD
8/4/18 6 Original Blend AL
8/4/18 17 Truffle VA
8/4/18 20 Old Bay MD
8/4/18 7 Old Bay MD
8/4/18 17 Old Bay VA
8/4/18 19 Truffle NY
8/4/18 6 Original Blend OH
8/4/18 13 Sea Salt and Caramel CA
8/4/18 17 Original Blend CA
8/4/18 22 Truffle CA
8/4/18 18 Old Bay MD
8/4/18 17 Original Blend MD
8/4/18 12 Old Bay VA
8/4/18 13 Original Blend VA
8/4/18 21 Sea Salt and Caramel MS
8/4/18 6 Original Blend NC
8/4/18 24 Original Blend WV
8/4/18 17 Old Bay WV
8/4/18 18 Truffle OH
8/5/18 19 Old Bay MD
8/5/18 16 Truffle OH
8/5/18 17 Original Blend CA
8/5/18 10 Original Blend MD
8/5/18 16 Sea Salt and Caramel VA
8/5/18 22 Truffle MD
8/5/18 16 Truffle VA
8/5/18 23 Sea Salt and Caramel AL
8/5/18 12 Old Bay MD
8/5/18 21 Old Bay WV
8/5/18 8 Original Blend WV
8/5/18 22 Truffle CA
8/5/18 7 Truffle CA
8/5/18 19 Truffle MO
8/5/18 24 Original Blend WV
8/5/18 12 Sea Salt and Caramel DC
8/5/18 22 Old Bay DC
8/5/18 17 Sea Salt and Caramel MD
8/5/18 7 Sea Salt and Caramel VA
8/5/18 13 Truffle AL
8/5/18 22 Sea Salt and Caramel MS
8/5/18 21 Old Bay NC

TysonsStore2019

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) Daily Total ($) Sales Goal Met? with Price Increase Current price per box: $6
1-Aug 239 83 209 531 $ 3,186 Daily sales goal: $1,500
2-Aug 225 185 77 487 $ 2,922 Average daily sales:
3-Aug 45 165 156 366 $ 2,196 Lowest daily sales:
4-Aug 240 93 177 510 $ 3,060 Highest daily sales:
5-Aug 195 215 110 520 $ 3,120
6-Aug 25 133 251 409 $ 2,454 Average sales with price increase $ 2,762
7-Aug 126 53 196 375 $ 2,250 New price per box: $6
8-Aug 263 141 37 441 $ 2,646
9-Aug 26 174 204 404 $ 2,424
10-Aug 29 62 29 120 $ 720
11-Aug 210 238 98 546 $ 3,276
12-Aug 269 70 273 612 $ 3,672
13-Aug 150 86 224 460 $ 2,760
14-Aug 70 189 55 314 $ 1,884
15-Aug 221 182 240 643 $ 3,858
16-Aug 30 43 206 279 $ 1,674
17-Aug 53 143 259 455 $ 2,730
18-Aug 274 169 27 470 $ 2,820
19-Aug 166 121 101 388 $ 2,328
20-Aug 211 66 69 346 $ 2,076
21-Aug 114 240 72 426 $ 2,556
22-Aug 81 132 267 480 $ 2,880
23-Aug 273 241 194 708 $ 4,248
24-Aug 266 233 42 541 $ 3,246
25-Aug 168 237 273 678 $ 4,068
26-Aug 54 265 255 574 $ 3,444
27-Aug 165 85 189 439 $ 2,634
28-Aug 274 38 55 367 $ 2,202
29-Aug 25 222 188 435 $ 2,610
30-Aug 121 119 245 485 $ 2,910
31-Aug 114 91 257 462 $ 2,772

TysonsStore2018

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold)
8/1/18 42 115 92 249
8/2/18 42 42 117 201
8/3/18 105 124 64 293
8/4/18 141 83 76 300
8/5/18 137 73 109 319
8/6/18 68 44 60 172
8/7/18 82 58 145 285
8/8/18 125 96 92 313
8/9/18 20 26 39 85
8/10/18 67 38 21 126
8/11/18 121 124 132 377
8/12/18 140 76 25 241
8/13/18 147 77 77 301
8/14/18 86 128 59 273
8/15/18 50 122 96 268
8/16/18 80 92 139 311
8/17/18 41 69 59 169
8/18/18 26 38 125 189
8/19/18 93 41 133 267
8/20/18 84 144 146 374
8/21/18 25 124 145 294
8/22/18 107 60 142 309
8/23/18 116 115 128 359
8/24/18 46 129 145 320
8/25/18 44 112 99 255
8/26/18 112 96 31 239
8/27/18 73 102 97 272
8/28/18 100 89 109 298
8/29/18 55 30 75 160
8/30/18 137 117 97 351
8/31/18 125 39 80 244

OldTownStore

Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold)
8/1/19 140 49 110 299
8/2/19 141 100 133 375
8/3/19 32 68 35 135
8/4/19 130 35 34 199
8/5/19 104 124 93 321
8/6/19 43 135 117 295
8/7/19 61 9 62 132
8/8/19 16 68 93 177
8/9/19 8 70 19 97
8/10/19 145 9 114 275
8/11/19 94 14 148 256
8/12/19 50 59 87 196
8/13/19 92 110 65 267
8/14/19 64 140 63 267
8/15/19 40 46 12 98
8/16/19 136 50 128 314
8/17/19 21 34 55 110
8/18/19 32 122 133 287
8/19/19 57 144 12 213
8/20/19 36 98 107 241
8/21/19 122 140 44 306
8/22/19 53 76 97 226
8/23/19 96 122 48 266
8/24/19 96 100 43 239
8/25/19 118 106 30 251
8/26/19 115 61 47 223
8/27/19 29 53 133 215
8/28/19 20 124 10 154
8/29/19 66 73 130 269
8/30/19 73 78 124 275
8/31/19 93 42 76 205

Daily Total (# sold) 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 299 375 135 199 321 295 132 177 97 275 256 196 267 267 98 314 110 287 213 241 306 226 266 239 251 223 215 154 269 275 205 Old Bay 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 140 141 32 130 104 43 61 16 8 145 94 50 92 64 40 136 21 32 57 36 122 53 96 96 118 115 29 20 66 73 93 Black Truffle 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 49 100 68 35 124 135 9 68 70 9 14 59 110 140 46 50 34 122 144 98 140 76 122 100 106 61 53 124 73 78 42 Sea Salt and Caramel 43678 43679 43680 43681 43682 43683 43684 43685 43686 43687 43688 43689 43690 43691 43692 43693 43694 43695 43696 43697 43698 43699 43700 43701 43702 43703 43704 43705 43706 43707 43708 110 133 35 34 93 117 62 93 19 114 148 87 65 63 12 128 55 133 12 107 44 97 48 43 30 47 133 10 130 124 76

Customers