In Excel format:
(Break-even point) You are a hard-working analyst in the office of financial operations for a manufacturing firm that produces a single product. You have developed the following cost structure information for this company. All of it pertains to an output level of 10 million units. Using this information, find the break-even point in units of output for the firm.
Return on operating assets = 25%
Operating asset turnover = 5 times
Operating assets = $20 million
Degree of operating leverage = 4 times
(Break-even point and operating leverage) Allison Radios manufactures a complete line of radio and communication equipment for law enforcement agencies. The average selling price of its finished product is $180 per unit. The variable cost for these same units is $126. Allison Radios incurs fixed costs of $540,000 per year.
1. What is the break-even point in units for the company?
2. What is the dollar sales volume the firm must achieve in order to reach the break-even point?
3. What would be the firm's profit or loss at the following units of production sold: 12,000 units? 15,000 units? 20,000 units?
4. Find the degree of operating leverage for the production and sales levels given in part (c).
Please refer attached solution for better clarity of formulas in MS Excel. Some of the formulas may not print here.
Return on operating assets=25.00%
Operating asset turnover=5
Operating assets=20 million
Degree of operating leverage=4
Units Sold=10 million
Sales = operating asset turnover*operating assets=100millions
Profit =operating assets*return=5 millions
Average Sale Price=Sales/Total units sold=10 dollars
DOL = Q*C/(Q*C-F)
Here DOL =4, Q=10million, C is contribution margin per unit, F is Fixed cost
Putting these values in formula, we get ...
There are two problems. Solutions explains the steps to determine break even sales and degree of operating leverage.