Explore BrainMass

Explore BrainMass

    Roehler Industrial Direct Materials Purchases Budget 2011

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

    Direct Materials Purchases Budget
    Roehler Industrial has estimated that production for the next five quarters will be:

    Production Information
    1st Quarter, 2011 51,000 units
    2nd Quarter, 2011 46,000 units
    3rd Quarter, 2011 55,000 units
    4th Quarter, 2011 44,000 units
    1st Quarter, 2012 53,000 units

    Finished units of production require 10 pounds of raw material per unit. The raw material cost is $6 per pound. There are 96,900 pounds of raw material on hand at the beginning of the first quarter, 2011. Roehler desires to have 19 percent of next quarter's material requirements on hand at the end of each quarter.

    Prepare quarterly direct materials purchases budgets for Roehler Industrial for 2011. (List multiple entries from largest to smallest amounts, e.g. 10, 5, 2. Enter all amounts as positive amounts and subtract where necessary.)

    Roehler Industrial
    Direct Materials Purchases Budget
    For the Year Ending December 31, 2011

    Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year

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

    Solution Summary

    Your tutorial is in excel, attached. Click in cells to see computations. You now have a template for other similar problems.