Question

As Managerial Accountant of the company, you are well aware that Olsen Industries, Inc. has been in the business of crafting high-quality wooden desks for nearly 30 years. As CEO of the company, I am considering ways in which we might increase production efficiency in order to boost our bottom line and enable expansion into new product lines. One change I am considering is the movement from our current labor-intensive process of desk construction to an automated process that will require new machinery and equipment. If we were to move to an automated process, it is my belief that variable production costs will decrease due to improved efficiencies. Simultaneously, fixed production costs would naturally increase as a result of the additional depreciation costs. Below, I have pulled together estimated costs for fiscal 2020 under each scenario. We will keep our selling price at $900 per desk under either process.

Variable cost of goods sold Fixed cost of goods sold (annual) Variable selling and administrative costs Fixed selling and administrative costs (annual) Labor-Intensive Process (current) $490 per unit $1,000,000 $10 per unit $400,000 Automated Process (proposed) $290 per unit $2,600,000 $10 per unit $400,000

I need you to please pull together an analysis for me: How many desks would we need to sell in order to breakeven under each scenario? We plan to produce and sell 8,000 desks in fiscal 2020, and I am confident sales will grow by at least 10% annually beyond that. What kind of operating profit would I see in fiscal years 2020 and 2021 under each of these methods? What is our margin of safety?

Answer 1

Labour Intensive Process 900.00 Automated Process 900.00 $ Selling Price per unit Vairable Costs per unit COGS Selling & Admin Cost Total Variable cost per unit Contribution margin per unit 490.00 10.00 500.00 400.00 $ $ $ $ 290.00 10.00 300.00 600.00 Fixed costs COGS Selling & Admin Cost Total Fixed costs 10,00,000.00 $ 4,00,000.00 $ 14,00,000.00 $ 26,00,000.00 4,00,000.00 30,00,000.00 Breakeven Units = Fixed costs / Contribution per unit Breakeven units 3500 5000 Labour Intensive Process 2020 2021 I 8000 8800 900.00 $ 900.00 $ Automated Process 2020 2021 8000 8800 900.00 $ 900.00 $ Sales in units Revenue per unit Less: Variable cost per unit COGS Selling & Admin Cost Total Variable cost per unit Contribution margin per unit Total Contribution Margin Fixed costs COGS Selling & Admin Cost Total Fixed costs Operating Profit $ 490.00 490.00 $ 490.00 $ 290.00 $ 290.00 $ 10.00 $ 10.00 $ 10.00 $ 10.00 $ 500.00 $ 500.00 $ 300.00 $ 300.00 $ 400.00 $ 400.00 $ 600.00 $ 600.00 $ 32,00,000.00 $ 35,20,000.00 $ 48,00,000.00 $ 52,80,000.00 $ 10,00,000.00 $ 4,00,000.00 $ 14,00,000.00 $ 18,00,000.00 $ 10,00,000.00 $ 26,00,000.00 $ 26,00,000.00 $ 4,00,000.00 $ 4,00,000.00 $ 4,00,000.00 $ 14,00,000.00 $ 30,00,000.00 $ 30,00,000.00 $ 21,20,000.00 $ 18,00,000.00 $ 22,80,000.00 Margin of safety = {(Current sales - Breakeven sales) / current sales level} * 100 Labour Intensive Process Automated Process 2020 2021 2020 2021 Current sales 8000 8800 8000 8800 Breakeven sales 3500 3500 5000 5000 Margin of safety (units) 4500 5300 3000 3800 Margin of safety ($) $ 40,50,000.00 $ 47,70,000.00 $ 27,00,000.00 $ 34,20,000.00 Margin of safety (%) 56.25 60.22727273 37.5 43.18181818|