Please answer using excel format (no screenshot/image

a. BEP d. variable cost + 4 LO 2 10.32 Chloe Enterprises operates a single-product entity. Data relating to the BEP = fixed cost/CM Fixed cost decrease 80,000 become 400,00 0 product for 2015 were as follows. CM = selling price - variable cost 60-40 = 20 BEP = 400,000/44 Variable cost = 28+12 = 40 9,091 Annual volume 32 000 units Fixed cost = 120,000 + 360,000 Selling price per unit $60 480,000 e. Yes Variable manufacturing cost per unit 28 BEP 12,000 unit Annual fixed manufacturing costs 120 000 BEP in $ $ 720,000 Take a look on: Variable marketing and distribution costs per unit 12 ex. 10.26 and 10.28 Annual fixed non-manufacturing costs 360 000 b. Margin of Safety: annual volume - BEP in unit 32,000 - 12,000 20,000 unit Required $ 1,200,000 a. Calculate the break-even in both dollars and units for 2015. c. Profit? b. Calculate the margin of safety in both units and sales dollars. Sales Revenue 32,000 x $60 1,920,000 c. Calculate the profit achieved in 2015 given the annual volume of 32 000 units. Total cost = FC + VC d. Changes in marketing strategy are planned for 2016. This would increase variable marketing Fixed cost = 480,000 and distribution costs by $4 per unit, and reduce fixed non-manufacturing costs by $80 000 Var cost per unit 40 per year. Calculate the units that would need to be sold in 2016 to achieve the same profit as Total VC = 40x32,000 128,000 Total cost 608,000 in 2015. Profit = 1,312,000 e. Would you recommend the change? Explain