Question

Integrative Cases 3-72 (Algo) Financial Modeling (LO 3-1, 2, 3, 4, 5) Three entrepreneurs were looking...

Integrative Cases 3-72 (Algo) Financial Modeling (LO 3-1, 2, 3, 4, 5)

Three entrepreneurs were looking to start a new brewpub near Sacramento, California, called Roseville Brewing Company (RBC). Brewpubs provide two products to customers—food from the restaurant segment and freshly brewed beer from the beer production segment. Both segments are typically in the same building, which allows customers to see the beer-brewing process.

After months of research, the owners created a financial model that showed the following projections for the first year of operations.

Sales
Beer sales $ 842,800
Food sales 921,200
Other sales 196,000
Total sales $ 1,960,000
Less cost of sales 444,332
Gross margin $ 1,515,668
Less marketing and administrative expenses 1,009,200
Operating profit $ 506,468


In the process of pursuing capital through private investors and financial institutions, RBC was approached with several questions. The following represents a sample of the more common questions asked:

  • What is the break-even point?
  • What sales dollars will be required to make $170,000? To make $520,000?
  • Is the product mix reasonable? (Beer tends to have a higher contribution margin ratio than food, and therefore product mix assumptions are critical to profit projections.)
  • What happens to operating profit if the product mix shifts?
  • How will changes in price affect operating profit?
  • How much does a pint of beer cost to produce?


It became clear to the owners of RBC that the initial financial model was not adequate for answering these types of questions. After further research, RBC created another financial model that provided the following information for the first year of operations.


Sales
Beer sales (43% of total sales) $ 842,800
Food sales (47% of total sales) 921,200
Other sales (10% of total sales) 196,000
Total sales $ 1,960,000
Variable Costs
Beer (11% of beer sales) $ 92,708
Food (32% of food sales) 294,784
Other (29% of other sales) 56,840
Wages of employees (20% of sales) 392,000
Supplies (1% of sales) 19,600
Utilities (5% of sales) 98,000
Other: credit card, misc. (1% of sales) 19,600
Total variable costs $ 973,532
Contribution margin $ 986,468
Fixed Costs
Salaries: manager, chef, brewer $ 132,000
Maintenance 27,000
Advertising 18,000
Other: cleaning, menus, misc 40,000
Insurance and accounting 30,000
Property taxes 16,000
Depreciation 91,000
Debt service (interest on debt) 126,000
Total fixed costs $ 480,000
Operating profit $ 506,468


Required:

Perform a sensitivity analysis by answering the following questions:


a. What is the break-even point in sales dollars for RBC?

b. What is the margin of safety for RBC?

c. What sales dollars would be required to achieve an operating profit of $170,000? $520,000?

Homework Answers

Answer #1

a) break-even point in sale = fixed cost / contribution margin percentage

= 480,000 / 50%

= 960,000

contribution margin percentage = contribution margin / sale x 100

= 986,468 / 1,960,000 x 100

= 50.33%

b) margin of safety = actual sale - break even sale

= 1,960,000 - 960,000

= 1,000,000

c) required sale = fixed cost + targeted profit / contribution margin percentage

= 480,000 + 170,000 / 50.33%

= 1,291,476

required sale = fixed cost + targeted profit / contribution margin percentage

= 480,000 + 520,000 / 50.33%

= 1,986,887

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The Great Tamale Alternative 1- Food Truck After experiencing such great success with their food cart,...
The Great Tamale Alternative 1- Food Truck After experiencing such great success with their food cart, Nathan and Cody are considering purchasing a food truck to serve other communities. This would allow the Great Tamale, GT, to reach even more customers in different geographic locations. There would be an increase in the selling price per plate. There will also be an increase in the fixed costs of $30,000 for advertising to inform the public of this change (this amount is...
Integration Exercise 6 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 2-1, LO...
Integration Exercise 6 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 2-1, LO 2-2, LO 2-3, LO 2-4, LO 6-4, LO 6-5, LO 7-1, LO 7-3, LO 7-4] Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the...
Required information The Foundational 15 [LO6-1, LO6-2, LO6-3, LO6-4, LO6-5] [The following information applies to the questions displayed below.] Diego Company manufactures one product that is sold for $80 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 40,000 units and sold 35,000 units. Variable costs per unit: Manufacturing: Direct materials $ 24 Direct labor $ 14 Variable manufacturing overhead $ 2 Variable selling...
Nathan and Cody notice there is stiff competition in the food cart and food truck industries...
Nathan and Cody notice there is stiff competition in the food cart and food truck industries and therefore are considering opening a traditional restaurant. Opening a restaurant would have many advantages and disadvantages, the company can expect fixed costs to increase by $140,000 a year to cover rent, equipment, furniture, salaries and other costs. This alternative is exclusive of alternative 1 -so use the original financial information from page 1 (also shown below) to calculate the effects of opening a...
Problem 5-16 (Algo) Comparing Traditional and Activity-Based Product Margins [LO5-1, LO5-3, LO5-4, LO5-5] Hi-Tek Manufacturing, Inc.,...
Problem 5-16 (Algo) Comparing Traditional and Activity-Based Product Margins [LO5-1, LO5-3, LO5-4, LO5-5] Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,772,200 Cost of goods sold 1,229,050 Gross margin 543,150 Selling and administrative expenses 640,000 Net operating loss $ (96,850 ) Hi-Tek produced and sold 60,200 units of B300 at a price of $21 per...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...