On January $1,2023,$ the Coronado Company budget committee reached agreement on the following data for the six months ending

June $30,2023$:

Sales units: First quarter $5,200$ ; second quarter $5,800$ ; third quarter $6,800$

Ending raw materials inventory: $40\%$ of the next quarter's production requirements

Ending finished goods inventory: $25\%$ of the next quarter's expected sales units

Third$-$quarter production: $7,000$ units

The ending raw materials and finished goods inventories at December $31,2022,$ had the same percentages for production and sales

that are budgeted for $2022.3$ kilograms of raw materials are needed to make each unit of finished goods. Raw materials purchased are

expected to cost $$4$ per kilogram.

$($a$)$

Prepare a production budget by quarters for the six$-$month period ended June $30,2023.$

CORONADO COMPANY

Production Budget

For the Six Months Ending June $30,2023$