Problem A:
EasyBake Company is able to produce two toy products, a Little Oven and a Big Oven, with the same machine in its factory. NOTE that only ONE Oven can be manufactured at a time using this machine. The Company currently makes both ovens, but management is concerned that this strategy is not providing maximum benefit. They are thinking of adding a second shift and have asked you to figure out their best course of action. The following information is available:
EasyBake Data:
|
Little Oven |
Big Oven |
| Selling price per unit |
110 |
150 |
| Variable costs per unit |
30 |
80 |
| Contribution margin per unit |
80 |
70 |
| Machine hours to produce ONE unit |
0.4 hours |
1.0 hours |
| Maximum customer demand for each Oven per month (max they can sell) |
550 units |
200 units |
The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is thinking about operating the machine for two shifts, which will increase its productivity by another eight hours per day for 22 days per month. This change would require $15,000 additional fixed costs per month.
Required (NOTE--show all calculations for full credit):
1 Determine the contribution margin per machine hour that each product generates.
2 How many units of the Little Oven and the Big Oven should the company produce if it continues to operate with only one shift? Assume all ovens produced are sold.
3 How much total contribution margin does this sales mix produce each month?
4 If the company adds another shift, how many units of the Little Oven and the Big Oven should it produce?
5 How much total contribution margin would this mix produce each month?
6 Should the company add the new shift?
7 Suppose that, based on market research, the company determines that it can increase the Little Oven's maximum sales to 650 units per month by spending $12,000 per month in marketing efforts, which is a fixed cost. Should the company pursue this strategy and the double shift? Provide support for your answer.
Problem B:
Weather-Tight sells windows and doors. The following data applies to the company's operating activities:
|
Windows |
Doors |
Total |
| Current sales mix in units percentage |
80.00% |
20.00% |
100.00% |
| Selling Price per Unit |
$200 |
$500 |
|
| Variable Cost per Unit |
$125 |
$350 |
|
| Fixed Costs |
$580,000 |
$320,000 |
$900,000 |
| Current Unit Volume |
64,000 |
16,000 |
80,000 |
Use the space provided below for organized calculations (including things like Current Unit Volume, Wtd CM, Wtd Average CM, Sales Mix, etc. See the narrated lectures for guidance. The detailed questions you are required to answer start on line 40 of this worksheet and are also listed briefly in the SOLUTION space provided starting in Column J of this worksheet:
Required:
1 What is the current break-even point in units for both products combined?
2 What is the number of units of each product that need to be sold at the current break-even point?
3 What is the current break-even point in sales dollars for both products combined?
4 How much, in sales dollars, of each product does the company currently need to sell at the break-even point?
5 Show the Current Contribution Margin Income Statement at Break-Even.
6 Show the Contribution Margin Income Statement at the Current Sales Level.
7 What is the Margin of Safety at the Current Sales Level?
The Company is working on budgets for next year and plans a 10% increase in Target Pretax Income; a 10% increase in both Selling Price and Variable Cost; and a 20% increase in Fixed Costs, keeping the Current Sales Mix in Dollars constant.
8 Show the Contribution Margin Income Statement at the Target Pretax Income Level. HINT--you need to start at the bottom of the Contribution Margin Income Statement and work your way up to the top to figure this out.
9 What is the Sales Unit Volume of each product needed to achieve the Target Level of Pretax Income?
10 What is the Margin of Safety at the Target Sales Level?
Attachment:- worksheet.xlsx