Kimberly.White-EX2016-Capstone-Level3-Alternate (3).xlsx - Top't Corn Sales(August Truck Location Farragut Old Bay $ Truffle $ Sea Salt and Caramel $

Kimberly.White-EX2016-Capstone-Level3-Alternate (3).xlsx -...

This preview shows page 1 - 6 out of 14 pages.

Top't Corn Sales (August) Truck Location Farragut SquareGeorge WashingtonGeorgetownK Street Old Bay $ 2,500 $ 900 $ 800 $ 1,150 Truffle $ 2,760 $ 525 $ 1,005 $ 2,100 Sea Salt and Caramel $ 3,800 $ 1,800 $ 1,225 $ 2,010 Total $ 9,060 $ 3,225 $ 3,030 $5,260 Farragut Square; 44% George Washington; 16% Georgetown; 15% K Street; 26% August Sales by Location Farragut Square George Washington Georgetown K Street $- $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000 August Sales by Popcorn Type Old Bay Truffle Sea Salt and Caramel
Price $45,000.00 Interest (annual) 4% Loan Term (in months) 18 Monthly payment ($3,554.70) Total payments ($63,984.60) Interest paid ($108,984.60) Average Sales $5,143.75 Buy new truck? Buy it!
Online Sales During Buy 1 Get 1 Free Sale Date Quantity Item State 8/1/2016 4 Old Bay DC 8/3/2016 4 Old Bay DC 8/4/2016 2 Old Bay DC 8/5/2016 2 Old Bay DC 8/1/2016 4 Original Blend DC 8/1/2016 2 Sea Salt and Caramel DC 8/5/2016 2 Sea Salt and Caramel DC 7/30/2016 2 Truffle DC 7/30/2016 14 Truffle DC 8/2/2016 2 Truffle DC Total
Date Old Bay Black Truffle Sea Salt and Caramel Daily Total (# sold) 8/1/2016 42 115 92 249 8/2/2016 42 42 117 201 8/3/2016 105 124 64 293 8/4/2016 141 83 76 300 8/5/2016 137 73 109 319 8/6/2016 68 44 60 172 8/7/2016 82 58 145 285 8/8/2016 125 96 92 313 8/9/2016 20 26 39 85 8/10/2016 67 38 21 126 8/11/2016 121 124 132 377 8/12/2016 140 76 25 241 8/13/2016 147 77 77 301 8/14/2016 86 128 59 273 8/15/2016 50 122 96 268 8/16/2016 80 92 139 311 8/17/2016 41 69 59 169 8/18/2016 26 38 125 189 8/19/2016 93 41 133 267 8/20/2016 84 144 146 374 8/21/2016 25 124 145 294 8/22/2016 107 60 142 309 8/23/2016 116 115 128 359 8/24/2016 46 129 145 320 8/25/2016 44 112 99 255 8/26/2016 112 96 31 239 8/27/2016 73 102 97 272 8/28/2016 100 89 109 298 8/29/2016 55 30 75 160 8/30/2016 137 117 97 351 8/31/2016 125 39 80 244
Daily Total ($) Sales Goal Met? with Price Increase

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture