Exercise 20-12 Manufacturing: Preparing production budgets (for two periods) LO P1 Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 144,300 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 481,000 units; third quarter, 287,000 units; and fourth quarter, 391,500 units. Company policy calls for the ending finished goods inventory of a quarter to equal 30% of the next quarter's budgeted sales. Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture. ELECTRO COMPANY Production Budget Second and Third Quarters Second Quarter Third Quarter Budgeted unit sales for quarter 481,000 287,000 Budgeted ending inventory (units) Required units of available production Budgeted beginning inventory (units) Units to be produced 86,100 117,450 567,100 404,450 144,300