014 XV fx B D F A E /15 points 1 Breakeven Analysis - Target Profit 2 Marshal is a multi-product company. Build a worksheet to calculate the level of sales needed to earn a target profit assuming the current sales mix remains constant. 3 4 5 Product A Product B Product C 6 Sales in units 1,000 2,000 7,000 7 Price per unit $ 150 $ 180 $ 200 8 Contribution Margin Ratio 35% 50% 40% 9 10 Tax rate 20% 11 Total fixed cost $ 40,000 12 Target Profit $ 20,000 13 14 Sales in units to reach target profit I 15 16 17 18 19 20 21 22 23 24 fe 25 26 M 27 Dift 28 29 est ot! Instructions Absorption vs Variable Costing Target Profit Regressio en! Submit Cancel 27 ty