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.

Details                                             April       May       June

Unit to be produced                        576        630        608

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