Explore BrainMass

Explore BrainMass

    Budgeted profit, what if analysis

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

    Monterio Mfg. Co. manufactures and sells folding umbrellas. 2006 Income Statement is:
    Sales (200000 units) $1000000
    Cost of goods sold $600000 Gross Margin=$400,000
    Selling expenses $150000
    Admin. expenses $100000 Net Profit (before income taxes) $150,000
    Monteiro's budget changes for 2007 are:
    30% increase in number of units sold
    20% increase in material cost per unit
    15% increase in direct labor cost per unit
    10% increase in variable indirect cost per unit
    5% increase in indirect capacity-related costs
    8% increase in selling expenses arising solely from increased volume
    6% increase in admin. expenses
    No change to admin. expenses caused solely by increase sales volume (considered immaterial).
    Any change in inventory valuation can be ignored. Finished product during 2006 for materials, direct labor, and mfg. support respectively was in the ratio of 3:2:1. In 2006, $40,000 of manufacturing support was for fixed costs. No changes in production methods or credit policies were contemplated for 2007.

    a) Compute unit sales price at which Monteiro must sell its umbrellas in 2007 in order to earn a budgeted profit of $200,000.
    b) Monteiro's sales mgr. is unhappy about increasing selling price. How many units must be sold at old price to earn $200,000 profit? Compute number of units which must be sold at old price to earn $200,000.
    c) 1 company director wants to know annual profit if selling price determined in a) is adopted but the increase in sales volume is only 10%. Compute budget profit in this case.

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

    Solution Summary

    Budgeted profits and what if analysis's are examined.