please add equations on how to do it

UPDATES AVAILABLE Updates for Office are ready to be installed, but filst We heed to close apps X ft CVP and Sensitivity Analysis, Resource Constraint (Multiple Products) A1 D E F G 1 CVP and Sensitivity Analysis, Resource Constraint (Multiple Products) 2 Hobby Shop Incorporated produces three different models with the following annual data (this is the base case) Plane * Total 4 Car oat Selling price per unit Variable cost per unit 5 14 24 6 7 8 7 Expected unit sales 30,000 50,000 20,000 100,000 8 Sales mix % 30% 50% 20% 100% 9 Fixed costs 650,000 10 11 Assume the sales mix remains the same at all levels of sales except for requirements i and j 12 13 Required: 14 a Calculate the weighted average contribution margin per unit How many units in total must be sold to break even? How many units of each product must be sold to break even? How many units in total must be sold to earn an annual profit of $500,000? How many units of each product must be sold to earn an annual profit of $500,000? Using the base case information, prepare a contribution margin income statement for the year Calculate the weighted average contribution margin ratio. Find the break-even point in sales dollars. What amount of sales dollars is required to earn an annual profit of $400,000? 15 b 16 17 c 18 19 d 20 e 21 f 22 g Go hack to the ha 20 Calculate the weighted average contribution margin ratio. Find the break-even point in sales dollars What amount of sales dollars is required to earn an annual profit of $400,000? Go back to the base case contribution margin income statement prepared in requirement d. What would the operating profit be if the Plane sales price (1) increases 10 percent, or (2) decreases 10 percent? (Assume total sales remains at 100,000 units.) Go back to the base case contribution margin income statement prepared in requirement d. If the sales mix shifts more toward the Car product than to the other two products, would the break-even point in units increase or decrease? (Detailed calculations are not necessary.) Explain. 0 e 1 f 22 g 23 24 25 i Assume the company has a limited number of labor hours available in production, and management would like to make efficient use of these labor hours. The Plane product requires 4 labor hours per unit, the Car product requires 3 labor hours per unit, and the Boat product requires 5 hours per unit. The company sells everything it produces. Based on this information, calculate the contribution margin per labor hour for each model (round to the nearest cent), and determine the top two models the company would prefer to sell to maximize overall company profit 27 28 26