IMPORTANT: Show calculations for support (for last two rows: budgeted beginning inventory & units to be produced).

Ruiz Co. provides the following sales forecast for the next four months. 0.83 points Sales (units) April May 580 660 June July 610 700 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 232 units. Prepare a production budget for the months of April, May, and June. Answer is not complete. 660 610 RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) Ratio of inventory to future sales 40% Budgeted ending inventory (units) 264 Budgeted unit sales for month 580 Required units of available production 844 Budgeted beginning inventory (units) 232 Units to be produced May 610 40% 244 660 904 June 700 40% 280 610 890