prepare a direct materials budget by quarters for the 6-month period ended June 30, 2020

On January 1, 2022, the Bramble Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022 Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,800; second quarter 6,960; third quarter 8,120. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 8,470 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound. Prepare a production budget by quarters for the 6-month period ended June 30, 2022. BRAMBLE COMPANY Production Budget For the Six Months Ending June 30, 2022 Quarter 2 Expected Unit Sales 5800 6960 Add : Desired Ending Finished Goods Units v 1740 2030 Total Required Units 7540 8990 Less : Beginning Finished Goods Units Required Production Units (1450) (1740) 6090 7250