Use the following information for the Exercises below. Ruiz Co. provides the fol

Question

Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months April May June July 640 720 670 760 Sales (units) The company wants to end each month with ending finished goods inventory equal to 20% of next month's forecasted sales. Finished goods inventory on April 1 is 128 units. Assume July's budgeted production is 670 units. In addition, each finished unit requires four pounds (lbs.) of raw materials and the company wants to end each month with raw materials inventory equal to 40% of next month's production needs. Beginning raw materials inventory for April was 1,050 pounds. Assume direct materials cost $5 per pound. Exercise 7-4 Manufacturing: Direct materials budget LO P Prepare a direct materials budget for April, May, and June. (Round your intermediate calculations and final answers to the nearest whole dollar amount.) Direct Materials Budget For April, May, and June April May June 656 730 670 units Budgeted production (units) Materials requirements per unit Materials needed for production (Ibs.) Budgeted ending inventory (Ibs.) Total materials requirements (Ibs.) 4 Ibs (ibs.) 1,050 lbs Materials to be purchased (ibs.) Cost per It. Total budgeted direct materials cost per lb.

Explanation / Answer

SOLUTION

RUIZ Co.

Direct Materials Budget

For April, May and June

*Budgeted ending inventory (lbs.) = 40% of next month's production needs.

April May June Budgeted production (units) 656 730 670 Materials requirements per unit 4 4 4 Materials needed for production (lbs.) 2,624 2,920 2,680 Budgeted ending inventory (lbs.)* 1,168 1,072 1,072 Total materials requirements(lbs.) 3,792 3,992 3,752 Beginning inventory (lbs.) (1,050) (1,168) (1,072) Materials to be purchased (lbs.) 2,742 2,824 2,680 Cost per lb. $2 $2 $2 Total budgeted direct materials cost $5,484 $5,648 $5,360

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---