Question

Haggstrom, Inc., manufactures steel fittings. Each fitting requires both steel and an alloy that allows the fitting to be used under extreme conditions. The following data apply to the production of the fittings:

     

Direct materials per unit
3 pounds of steel at $0.55 per pound
0.5 pounds of alloy at $2.30 per pound
Direct labor per unit
0.02 hours at $27 per hour
Overhead per unit
Indirect materials	$	0.60
Indirect labor		0.70
Utilities		0.45
Plant and equipment depreciation		0.95
Miscellaneous		0.65
Total overhead per unit	$	3.35

The plant and equipment depreciation and miscellaneous costs are fixed and are based on production of 250,000 units annually. All other costs are variable. Plant capacity is 300,000 units annually. All other overhead costs are variable.

The following are forecast for year 2. Contract negotiations with the union are expected to lead to an increase in hourly direct labor costs of 4 percent, mostly in the form of additional benefits. Commodity prices, including steel, are expected to decline by 10 percent due to the economic slowdown. Alloy prices are expected to remain constant. Plant and equipment depreciation costs are expected to increase by 6 percent. All other unit overhead costs are expected to remain constant.

Haggstrom expects to sell 290,000 units in year 2. The current inventory of fittings is 20,000 units, and management would like to see a reduction of inventory of 10,000 units by the end of the year 2. Steel and alloy inventories will not change. Sales are approximately uniform over the year.

Required:

Prepare a production budget for the year 2.

expected sales

add: Desired ending inventory of finished goods

total needs

Less: Beginning inventory of finished goods

Units to be produced

Estimate the materials, labor, and overhead costs for year 2. (Do not round intermediate calculations.)

material costs

labor costs

overhead costs

Answer 1

Req a.
Production Budget
Estaimetd sales units			290000
Add: Ending Inventory of FG			10000
Total requirement			300000
Less: Beginning inventory of FG			20000
Units produced			280000
Req b:
Material Cost:
Steel
Units required (280000*3)			840000
Unit price			0.55
Steel cost				462000
Alloy:
Units required (280000*0.50)			140000
Unit price			2.3
Canvas cost				322000
Material cost				784000
Labour cost:
Hours required (280000*0.02)			5600
rate per hour			27
Direct labour cost				151200
Overheads cost:
Variable
Indirect labour (280000*0.7)			196000
Indirect material (280000*0.6)			168000
utilities (280000*0.45)			126000	490000
Fixed:
Depreciation (250000*0.95)			237500
Misc (250000*0.65)			162500	400000
Overheads cost:				890000