Explore BrainMass

Explore BrainMass

    Find cost behavior (fixed, variable, mixed) from budget

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

    For this year, production and sales are based on 4,000 units per year:
    Building depreciation $200,000/yr.
    Machine operators $100,000/yr.
    Management staff $400,000/yr.
    Direct materials $4,000,000/yr.
    Other expenses that seem to vary based on production levels $3,000,000/yr.
    Other expenses that don't seem to vary $1,300,000/yr.
    Selling price per unit $5,000/unit

    Some utilities relate to the heat and light of the building, but others are required during the manufacturing process only. Using the high-low method:
    When there is no production, utility costs are $20,000/month
    When production levels reached 4,000 units/month, utility costs totaled $40,000/month

    Which of these 8 cost categories above are fixed, mixed (semi-variable or semi-fixed) and which are variable? Why is this?
    Ignoring utility costs altogether, compute the contribution margin per unit, in dollars and in percentage and the break-even in sales.
    Ignoring utility costs altogether, how many units must be sold each month to achieve a target profit of $10,000? At what sales level do they achieve this target profit?

    In year 2, they will add $300,000/yr. in added administrative expenses. Ignoring utility costs, how many additional units must be sold just to pay for this added expense?

    © BrainMass Inc. brainmass.com June 4, 2020, 4:14 am ad1c9bdddf

    Solution Summary

    Your tutorial attached in Excel shows how to analyze these costs, which are variable, fixed and mixed and then creates a contribution margin analysis, breakeven, target profit and incremental fixed costs analysis.