Explore BrainMass

Explore BrainMass

    Findind break even sales

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 15, 2022, 7:16 pm ad1c9bdddf

    Solution Preview

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

    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.