Smoothie Doozie A friend of yours wants to open a store that sells smoothies. Your friend tells you the following: Smoothies range in price from…

This assignment is for an Entrepreneurship course. Please see instructions below and attachments.

Instructions

1. Construct a monthly pro-forma cash budget for your friend for the first year of operations.

a. Place all your assumptions on one worksheet. Name the worksheet “Assumptions”

b. Place your start up costs on a second worksheet named “Startup Costs”

c. Place the cash proforma on another worksheet named “Cash Pro-forma Budget”

2. When is the dollar break even point? (Profits = zero). Use a text box to identify it.

3. Graph the Revenue and the Net Income after Taxes. Name this worksheet “Graph”

4. Double the marketing and advertising. Assume this increases the growth rate to a number that will be given to you in your email. Would this be a good business decision? Why or why not? Name your worksheet “Double”

5. Suggest two reasonable business recommendations to your friend. Show your friend how these recommendations would affect the cash budget. Use a text box to explain your changes. Name the worksheet “Recommendations”

No constant numbers should be used on the worksheets. All constants should be limited to the Assumptions worksheet or the Startup Costs worksheet. This will allow you to do “what-if” analysis.

Assume a 4.2 week month.

Use the Excel file in the assignment tool as a template to help you get started. Do not change the items in the file. Use the same labels so it is easy to identify all of the required items and values.

  • Attachment 1
  • Attachment 2
  • Attachment 3

Show more

Calculate Your Essay Price
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more