90.2K

Verified Solution

Link Copied!

Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare an aggregate plan for the next six months using the following information:

	MONTH
	1	2	3	4	5	6
Demand	160	150	160	180	170	140
Capacity
Regular	150	150	150	150	160	160
Overtime	10	10	0	10	10	10

Cost Per Unit
Regular time	$	50
Overtime		75
Subcontract		80
Inventory, per period		4

Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero. Develop a plan that minimizes total cost. No back orders are allowed. Regular production and overtime production can be less than capacity in any month. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)

Period	1	2	3	4	5	6	Total
Forecast	160	150	160	180	170	140	960
Output
Regular
Overtime
Subcontract
Output- Forecast
Inventory
Beginning
Ending
Average
Backlog
Costs:
Regular	$						$
Overtime
Subcontract
Inventory
Backlog
Total	$						$

Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero. Develop a plan that minimizes total cost. No back orders are allowed. Regular production and overtime production can be less than capacity in any month. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.) 5 170 Total 960 160 150 160 180 140 Period Forecast Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs: Regular Overtime Subcontract Inventory Backlog Total

Answer & Explanation Solved by verified expert

See Answer