Exercise 20-5 (Algo) Manufacturing: Production budget LO P1 Tyler Company budgets the following unit sales for the next four months: April, 3,000 units; May, 4,900 units; June, 6,500 units; and July, 2,200 units. The company's policy is to maintain finished goods inventory equal to 40% of the next month's unit sales. At the end of March, the company had 1,200 finished units in inventory. Prepare a production budget for each of the months of April, May, and June. Budgeted sales units Add: Beginning inventory units Next period budgeted sales units Desired ending inventory units Total required units Units to produce TYLER COMPANY Production Budget April May June % % %