Simpson Corporation is developing a revised budget for the 4th quarter of 2024. For fiscal year 2024, below is the companys estimates of 4th quarter 2024 unit sales:

Month Unit Sales

October 80,000

November 140,000

December 100,000

Additionally, projected January 2025 sales are estimated at 120,000 units.

Assume that the company estimates 38,000 units of finished goods in inventory at the beginning of October and the company wants to maintain ending monthly finished goods inventory equal to 25% of the following months unit sales.

Five pounds of raw materials are required for each unit produced. Raw materials cost $10 per pound. Plans are to have inventory levels for raw materials equal to 30% of materials needed to satisfy next month's production.

Lastly, assume that: Raw materials inventory on October 1 will equal 120,000 pounds. Raw materials inventory should be 168,000 units at the end of December.

a. Prepare a production budget in units for October, November, and December.

b. Prepare a raw material purchases budget in pounds and in dollars for October, November, and December.

Note: For your analysis, use a columnar format with October, November, and December at the head of each column, as follows:

a. Budgeted production: October November December

b. Raw Materials Purchase Budget: October November December