Determine the contribution margin per machine hour that each product generates. (4 points)

2 How many units of the Little Oven and the Big Oven should the company produce to

achieve the maximum CM if it continues to operate with only one shift? Assume all ovens

produced are sold. (4 points)

3 How much total contribution margin does this sales mix produce each month? (4 points)

4 If the company adds another shift, how many units of the Little Oven and the Big Oven

should it produce to achieve the maximum CM? (3 points)

5

How much total contribution margin would this mix produce each month? (3 points)

6

7 Should the company add the new shift? Why or why not? (3 points)

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 $10,000 per month in

marketing efforts. Should the company pursue this strategy and the double shift? Provide

support for your answer. (5 points)

NOTE that this problem is NOT asking you to calculate Break-Even.

Check Figures: Item 4: Big Ovens = 132 Units; No check figure provided for the Little.

Item 7: Little Ovens Contribution Margin = $52,000

Problem C. Problem D. Module 5 Excel Workbook Assignment MBA 6315 Problem C (26 points): 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 110 150 Selling price per unit Variable costs per unit 30 80 Contribution margin per unit 80 70 0.4 hours 1.0 hours Machine hours to produce ONE unit 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): Determine the contribution margin per machine hour that each product generates. (4 points) 2 How many units of the Little Oven and the Big Oven should the company produce to achieve the maximum CM if it continues to operate with only one shift? Assume all ovens produced are sold. (4 points) 3 How much total contribution margin does this sales mix produce each month? (4 points) 4 If the company adds another shift, how many units of the Little Oven and the Big Oven should it produce to achieve the maximum CM? (3 points) 5 How much total contribution margin would this mix produce each month? (3 points) 6 7 Should the company add the new shift? Why or why not? (3 points) 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 $10,000 per month in marketing efforts. Should the company pursue this strategy and the double shift? Provide support for your answer. (5 points) NOTE that this problem is NOT asking you to calculate Break-Even. Check Figures: Item 4: Big Ovens = 132 Units; No check figure provided for the Little... Item 7: Little Ovens Contribution Margin = $52,000 X Module 5 Part B Excel Workbook Problem C. Problem D. Solution: Please place your answer and supporting calculations in the space below and either highlight your final answer or surround it with a border so that it can be easily identified by the grader. 1 Contribution Margin by Machine Hour for each Oven: 2 Units of each Oven that company should produce to maximize Contribution Margin, assuming only one production shift: 3 Total Contribution Margin resulting from solution to Item 2: 4 Units of each Oven that company should produce to maximize Contribution Margin, assuming TWO production shifts: 5 Total Contribution Margin resulting from solution to Item 4: 6 Should the company add the second shift? Why or why not? 7 Should the company add the advertising campaign and the second shift? Why or why not? Show all relevant calculations