Please complete in EXCEL showing formulas used. Utilize the check figures to check your work, Thanks!
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 1 Contribution Margin by Machine Hour for each Oven: 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 2 Units of each Oven that company should produce to maximize Contribution Margin, assuming only one 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 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 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 5 Total Contribution Margin resulting from solution to Item 4: Required (NOTE--show all calculations for full credit): 1 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 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 5 How much total contribution margin would this mix produce each 6 month? (3 points) 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 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 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
