please help ASAP production budget

Exercise 20-3 Manufacturing: Production budget LO P1 Ruiz Co provides the following sales forecast for the next four months. Sales (units) April 670 June May 750 700 July 790 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 201 units. Prepare a production budget for the months of April, May, and June. X Answer is complete but not entirely correct. RUIZ CO. Production Budget For April, May, and June April Next month's budgeted sales (units) 750 Ratio of inventory to future sales 30% Budgeted ending inventory (units) 225 Budgeted unit sales for month 670 Required units of available production 895 Budgeted beginning inventory (units) 201 Units to be produced 694 May 700 June 790 30% 210 30% 237 750 960 1,027 1,264 225 700 X 735 564