AE10-8 Direct Materials Purchases Budget [LO 2] Roehler Industrial has estimated that production for the next five quarters will be: Production Information 1st Quarter, 2011 49,000 units 2nd Quarter, 2011 45,000 units 3rd Quarter, 2011 53,000 units 4th Quarter, 2011 43,000 units 1st Quarter, 2012 51,000 units Finished units of production require 7 pounds of raw material per unit. The raw material cost is $4 per pound. There are 65,170 pounds of raw material on hand at the beginning of the first quarter, 2011. Roehler desires to have 19 percent of next quarters 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 Units to be produced,Desired ending inventory of raw material,Cost of raw material per unit,Beginning inventory of raw material (select from dropdown box) Units to be produced,Cost of raw material per unit,Desired ending inventory of raw material,Beginning inventory of raw material (select from dropdown box) Qrt. 1= $ Qrt. 4 = $ Qrt.3 = $ Qrt.4 = $ yr= $ Cost of raw material needed for production Add: Cost of raw material per unit,Beginning inventory of raw material,Desired ending inventory of raw material,Units to be produced (select from dropdown box) Total material needed Less: Beginning inventory of raw material,Desired ending inventory of raw material,Units to be produced,Cost of raw material per unit (select from drop down box) Required raw material purchases Qrt 1= $ Qrt 2= $ Qrt 3= $ Qrt 4= $ Yr= $