Question

Ruiz Co. provides the following sales forecast for the next four months. Sales (units) April 560 May 640 June 590 July 680 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 112 units. Prepare a production budget for the months of April, May, and June.

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 112 units. Prepare a production budget for the months of April, May, and June. May June RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) Ratio of inventory to future sales Budgeted ending Inventory (units) Budgeted unit sales for month Required units of available production Budgeted beginning inventory (units) Units to be produced.

Answer 1

Details April May June

Unit to be produced 576 630 608

Step-by-step explanation:

The production budget For April, May, and June can be prepared as follows:

Ruiz Co.

Production Budget

For April, May, and June

Details April May June

Next month's budgeted sales (A) 640 590 680

Ratio of inventory to future sales (B) 20% 20% 20%

Budgeted ending inventory (C = A * B) 128 118 136

Budgeted unit sales for month (D) 560 640 590

Req'd units of avail. production (E = C + D) 688 758 726

Budgeted beginning inventory (F) 112 128 118

Unit to be produced (G = E - F) 576 630 608