Question

Ch 20 Homework i Savad Help Save & Exit Submit 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! X April 550 May 630 June 530 July 670 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 110 units. Assume July's budgeted production is 580 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 30% of next month's production needs. Beginning raw materials inventory for April was 849 pounds. Assure direct materials cost $4 per pound. Rotarences Exercise 20-3 Manufacturing: Production budget LO P1 Prepare a production budget for the months of April, May, and June. May June 580 870 RUIZ CO. Production Budget For April, May, and June April Next montre budgeted sales (units) 630 Ralio of inventory lolulure sales 20% Budguled ending invertory furis Dudpoled unil sales for month Required urils af available production Budgeted beginnirg inventory (units) Units to be producer

Answer 1

PRODUCTION BUDGET:
	April	May	June	July
Next month's budgeted sales (Units)	630	580	670
Ratio of inventory to future sales	20%	20%	20%
Budgeted ending inventory (Units)	126	116	134
Budgeted unit sales for the month	550	630	580
Required units of available production	676	746	714
Budgeted beginning inventory (Units)	110	126	116
Units to produce	566	620	598
MATERIAL PURCHASES BUDGET:
Budgeted production	566	620	598	580
Raw materials required for production [lbs]	2830	3100	2990	2900
Desired ending balance [lbs]	930	897	870
Total raw materials needed [lbs]	3760	3997	3860
Beginning inventory [lbs]	849	930	897
Purchases needed [lbs]	2911	3067	2963
Cost of purchases at $4/lb	$            11,644	$        12,268	$         11,852