Explore BrainMass

Explore BrainMass

    Pro Forma Sales and Revenue Goals for Leach Company

    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!

    Top executive officers of Leach Company, a merchandising firm, are preparing the next year's budget. The controller has provided everyone with the current year's projected income statement.

    CURRENT YEAR Sales revenue $2,600,000, cost of goods sold 1,690,000, Gross profit 910,000, Selling & Admin. expense 325,000, Net income $585,000. Cost of goods sold is usually 65 percent of sales revenue, and selling and administrative expenses are usually 10 percent of sales plus a fixed cost of $65,000. The president has announced that the company's goal is to increase net Income by 15 percent.

    a) What percentage increase in sales would enable the company to reach its goal? Support your answer with a pro forma income statement.
    b) The market may become stagnant next year, and the company does not expect an increase in sales revenue. The production manager believes that an improved production procedure can cut cost of goods sold by 2 percent. What else can the company do to reach its goal? Prepare a pro forma income statement illustrating your proposal.
    c) The company decides to escalate its advertising campaign to boost consumer recognition, which will increase selling and administrative expense to $405,000. With the increased advertising, the company expects sales revenue to increase by 15 percent. Assume that cost of goods sold remains a constant proportion of sales. Can the company reach its goal?

    © BrainMass Inc. brainmass.com March 4, 2021, 11:07 pm ad1c9bdddf

    Solution Preview


    Current net income $585,000
    Desired increase of 15% $87,750
    New required net income $672,750

    Total variable costs =
    0.65 of sales, .10 of sales = 75%

    X = 0.75X + $65,000 + $672,750

    0.25X = $737,750

    Total Sales = $2,951,000

    Percentage increase = ($2,951,000 - $2,600,000)/$2,600,000 =13.5%

    Proforma Income Statement

    Solution Summary

    The solution provides a financial breakdown of the sales levels and percentages required for Leach Company to reach their goals.