Question

uizi Swed Help Save & Exit Submi Check my work Required information Use the following information for the Exercises below. Ruiz Co. provides the following sales forecast for the next four months: April May June July Sales (mits) 600 680 630 720 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 240 units. Assume July's budgeted production is 630 units. In addition, each finished unit requires five 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.264 pounds. Assume direct materials cost $3 per pound. Exercise 20-3 Manufacturing: Production budget LO P1 Prepare a production budget for the months of April, May, and June.

Answer 1

RUIZ CO.
Production Budget
For April, May, and June
	April	May	June
Next month's budgeted sales (units)	680	630	720
Ratio of inventory to future sales	40%	40%	40%
Budgeted ending inventory (units)	272	252	288
Budgeted unit sales for the month	600	680	630
Required units of available production	872	932	918
Budgeted beginning inventory (units)	240	272	252
Units to be produced	632	660	666
Note : Ending inventory of one month becomes the beginning inventory of the immediate next month