Simpson Corporation is developing a revised budget for the 4th quarter of 2024. For fiscal year 2024, below is the company’s 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 month’s 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

Answer rating: 100% (QA)

a Production Budget in units for October November and December Month Unit Sales Inventory Ending Inventory Production October 80000 38000 140000 25 Pr... View the full answer