Explore BrainMass

Explore BrainMass

    5 Managerial Accounting Problems

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

    See attached file for clarity.

    1. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

    Estimated sales for January $ 100,000
    Sales increase by 5% for the coming three months
    Cost of goods sold (CGS) 60% of sales
    Beginning inventory $ 12,000
    Ending inventory equal to 20% 0f next month CGS
    Find the total purchases needed for February.

    1. between $60,000 and $61,000

    2. between $63,000 and $64,000

    3. between $66,000 and $67,000

    4. between $68,000 and $69,000

    2. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

    Estimated sales for January $ 100,000
    Sales increase by 5% for the coming three months
    Cost of goods sold (CGS) 60% of sales
    Beginning inventory $ 12,000
    Ending inventory equal to 20% 0f next month CGS
    Find the total purchases needed for March.

    1. between $60,000 and $61,000

    2. between $63,000 and $64,000

    3. between $66,000 and $67,000

    4. between $68,000 and $69,000

    3. The manager of MN Company give you the following data to prepare the required purchases for the coming three months (January, February and March)

    Estimated sales for January $ 100,000
    Sales increase by 5% for the coming three months
    Cost of goods sold (CGS) 60% of sales
    Beginning inventory $ 12,000
    Ending inventory equal to 20% 0f next month CGS
    Find the total purchases needed for January.

    1. between $60,000 and $61,000

    2. between $63,000 and $64,000

    3. between $66,000 and $67,000

    4. between $68,000 and $69,000

    4. Assume the following data pertains to ABC Company
    Estimated average selling price per unit $10.00
    Estimated units to be sold in 8-2009 1,000.00
    Estimated increase in unit sales 10%
    Month 8 9 10 11
    Units 1,000 1,100 1,210 1,331
    Selling price per unit $ 10.00 $ 10.00 $ 10.00 $ 10.00
    Total estimated sales $ 10,000.00 $ 11,000.00 $12,100.00 $13,310.00
    Assume
    Cost of goods sold (CGS) 65% of sales
    Month 8 9 10
    Estimated CGS $ 6,500.00 $ 7,150.00 $ 7,865.00 $ 8,651.50
    Assume
    Beginning inventory $ 2,100.00
    Ending inventory 20% next month CGS
    Find the purchases needed for September

    1. Between $5,200 and $5,300

    2. Between $7,200 and $7,300

    3. Between $5,800 and $5,900

    4. Between $8,00 and $8,100

    5. Assume the following data pertains to ABC Company
    Estimated average selling price per unit $10.00
    Estimated units to be sold in 8-2009 1,000.00
    Estimated increase in unit sales 10%
    Month 8 9 10 11
    Units 1,000 1,100 1,210 1,331
    Selling price per unit $ 10.00 $ 10.00 $ 10.00 $ 10.00
    Total estimated sales $ 10,000.00 $ 11,000.00 $12,100.00 $13,310.00
    Assume
    Cost of goods sold (CGS) 65% of sales
    Month 8 9 10
    Estimated CGS $ 6,500.00 $ 7,150.00 $ 7,865.00 $ 8,651.50
    Assume
    Beginning inventory $ 2,100.00
    Ending inventory 20% next month CGS
    Find the purchases needed for August

    1. Between $5,200 and $5,300

    2. Between $7,200 and $7,300

    3. Between $5,800 and $5,900

    4. Between $8,00 and $8,100

    © BrainMass Inc. brainmass.com June 4, 2020, 12:55 am ad1c9bdddf
    https://brainmass.com/business/management-accounting/5-managerial-accounting-problems-367754

    Attachments

    Solution Preview

    ** Please see the attached files for the complete solution response **

    Answer
    jan feb march april
    sales 100000 105000 105000 105000
    cost of goods sold 60000 63000 63000 63000
    opening inventory 12000 12600 12600
    ending ...

    Solution Summary

    This solution provides a complete computation of the given accounting problems in Excel format.

    $2.19

    ADVERTISEMENT