Explore BrainMass

Roehler Industrial Direct Materials Purchases Budget 2011

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

Solution Summary

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