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
Image of page 1

Subscribe to view the full document.

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!
Image of page 2
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
Image of page 3

Subscribe to view the full document.

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
Image of page 4
Daily Total ($) Sales Goal Met? with Price Increase
Image of page 5

Subscribe to view the full document.

Image of page 6
  • Fall '16
  • Sales, Project, sea salt, Old Bay, Original Blend

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes