Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Open the Budget tab and create the following monthly cash-flow budget: Revenues: Caveman Cooking plans to sell, on average, $8,000 worth of cooked meat products

  1. Open the Budget tab and create the following monthly cash-flow budget:
    1. Revenues: Caveman Cooking plans to sell, on average, $8,000 worth of cooked meat products each month ($96,000 in sales/12 months). However, seasonal sales expectations are as follows:
      1. Jan and Feb 31% of average each month
      2. March 62% of average
      3. April 99% of average
      4. May and June 124% of average each month
      5. July through October 149% of average each month
      6. November 99% of average
      7. December 31% of average
    2. Expenses: Caveman Cooking has the following monthly expenses
      1. 20% of their monthly revenue is page out as wages.
      2. Rental fee on public parking lot where they set up their Food Truck is $150/month
      3. Operating loan: Caveman Cooking borrowed money to purchase their Food Truck and BBQ/Smoker equipment. The total amount borrowed was $25,000 and was financed over 7 years at a rate of 6.5%. They make monthly payments.
      4. Miscellaneous expenses: meat, sauces, smoking wood, lighters, gloves, fuel, and advertising are expected to be about 25% of monthly sales.
    3. Answer the following questions:
      1. Is Caveman Cooking able to cover all of their monthly expenses?
      2. What would happen if their average monthly sales estimate is wrong, and they are only averaging $6,000?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Geert Bekaert, Robert J. Hodrick

4th International Edition

013284298X, 9780132842983

More Books

Students also viewed these Finance questions

Question

Summarize the impact of a termination on the employee.

Answered: 1 week ago