Required information Use the following information for the Exercises below Ruiz

Question

Required information Use the following information for the Exercises below Ruiz Co. provides the following sales forecast for the next four months: April MayJuneJuly Sales (units) 510 590 540 630 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 Apri 1 is 102 units. Assume July's budgeted production is 540 units. In addition, each finished unit requires five pounds (Ibs.) of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month's production needs. Beginning raw materials inventory for April was 789 pounds Assume direct materials cost $5 per pound Exercise 7-3 Manufacturing: Production budget LO P1 Prepare a production budget for the months of April, May, and June RUIZ CO Production Budget For April, May, and June April May June Next month's budgeted sales (units) Ratio of inventory to future sales 590 20% 118 510 628 102 526 540 20% 108 590 698 118 580 630 20% 126 540 udgeted ending inventory (units) udgeted unit sales for month Required units of available production 108 558 udgeted beginning inventory (units) Units to be produced

Explanation / Answer

Direct material budget :

April May June Budgeteted production (units) 526 580 558 units Material requirements per unit 5 5 5 lbs. Materials needed for production (lbs.) 2630 2900 2790 lbs. Budgeted ending inventory (lbs) 870 837 810 lbs. Total materials requirements (lbs) 3500 3737 3600 lbs. Beginning inventory (lbs) (789) (870) (837) lbs. Materials to be purchased (lbs) 2711 2867 2763 lbs. Cost per lbs 5 5 5 per lb Total budgeted direct material cost 13555 14335 13815

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.