Explore BrainMass

Explore BrainMass

    Findind break even sales

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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).

    © BrainMass Inc. brainmass.com February 24, 2021, 5:15 pm ad1c9bdddf
    https://brainmass.com/business/revenue-recognition/findind-break-even-sales-208642

    Solution Preview

    Please refer attached solution for better clarity of formulas in MS Excel. Some of the formulas may not print here.

    Solution
    Problem 1

    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 ...

    Solution Summary

    There are two problems. Solutions explains the steps to determine break even sales and degree of operating leverage.

    $2.19

    ADVERTISEMENT