The Direct Materials Budget April May June Quarter Budgeted Sales 20,000 50,000 30,000 100,000 Add: Desired ending inventory 10,000 6,000 5,000 Total Needs 90,000- Less: Beginning inventory 4,000 10,000 6.000 Required production 26.000 46,000 29.000 Ele Edit View Insert Format Tools Data Window Help Adobe PDF Arial 10 BEE M48 T 28 April May June Quarter 29 Production 26.000 46.000 29.000 101.000 30 Materials per unit (pounds) 5 5 5 5 130,000 230,000 145,000 505,000 31 Production needs 32 Add: Desired ending inventory 33 Total needed Less: Beginning inventory 35 Materials to be purchased From production budget 2015 McGraw Hill Education Garison, Noreen, Brewer, Cheng The Direct Materials Budget At Royal Company. five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 10% of the following month's production. On March 31, 13,000 pounds of material are on hand. Material cost is $0.40 per pound. Let's prepare the direct Ele Edt Yew sert Format Tools Data Window Help Adobe PDF 12. CDEFGHI M48 A B 28 April May June Quarter 29 Production 26,000 46,000 29,000 101,000 30 Materials per unit (pounds) 31 Production needs 32 Add: Desired ending inventory 33 Total needed 34 Less: Beginning inventory 35 Materials to be purchased 36 130,000 230,000 145,000 505,000 materials budget.