EX2013-Capstone-Level3.xlsx - Top't Corn Sales(July Truck Location Farragut Sqaure $ $ $ $ Old Bay Truffle Sea Salt and Caramel Total 2,100 2,510 3,540

EX2013-Capstone-Level3.xlsx - Top't Corn Sales(July Truck...

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

Top't Corn Sales (July) Truck Location Farragut Sqaure 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 Truck Location Farragut Sqaure; 42% Truck Location George Washington; 16% Truck Location Georgetown; 16% Truck Location K Street; 27% July Sales by Location Old Bay Truffle Sea Salt and $- $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000 July Sales by Popcorn Type Truck Location Farragut Sqaure George Washington Georgetown K Street
Image of page 1

Subscribe to view the full document.

Caramel
Image of page 2
Price $42,000.00 Loan Term (in months) 12 Interest (annual) 8% Monthly Payment $5,573.19 Total Payments $66,878.29 Interest Paid $24,878.29 Average Sales $4,881.25 Buy new truck? Pass
Image of page 3

Subscribe to view the full document.

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

Subscribe to view the full document.

Image of page 6

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