Exercise 20-3 (Algo) Manufacturing: Production budget LO P1 Ruiz Company provides the following budgeted sales for the next four months. The company wants to end each month with ending finished goods inventory equal to 30% of next month's budgeted unit sales. Finished goods inventory on April 1 is 186 units. Prepare a production budget for the months of April, May, and June. Budgeted sales units April 620 May June July 700 650 740 Budgeted sales units RUIZ COMPANY Production Budget April May June 620 700 650 Add: Desired ending inventory Next period budgeted sales units 700 650 740 Ratio of inventory to future sales 30% 30% 30% Desired ending inventory units Total required units Less: Beginning inventory units Units to produce 186