The president of Hill Enterprises, Terri Hill, projects the firm\'s aggregate de
ID: 465338 • Letter: T
Question
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows:
January
1,200
May
2,100
February
1,600
June
2,200
March
1,800
July
1,900
April
1,700
August
1,400
Her operations manager is considering a new plan, which begins in January with 200 units on hand and ends with zero inventory. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $20 per unit per month. Ignore any idle-time costs. The plan is called plan B.
Plan B: Produce at a constant rate of 1,200 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75 per unit. Subcontracting capacity is limited to 1000 units per month. Evaluate this plan by computing the costs for January through August.
A) In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by filling in the table below (enter your responses as whole numbers).
Period----
Month
Demand-----
Production-------
Ending Inventory--------
Subcontract Units
0
December
200
1
January
1200
1200
?
?
2
February
1600
1200
?
?
3
March
1800
1200
?
?
4
April
1700
1200
?
?
5
May
2100
1200
?
?
6
June
2200
1200
?
?
7
July
1900
1200
?
?
8
August
1400
1200
?
?
B) The total subcontracting costequals= ? (Enter your response as a whole number.)
C) The total inventory carrying cost = ? (Enter your response as a whole number.)
The total cost, excluding normal time labor costs, is = ? (Enter your response as a whole number.
January
1,200
May
2,100
February
1,600
June
2,200
March
1,800
July
1,900
April
1,700
August
1,400
Explanation / Answer
B) The total subcontracting cost = $307,500
C) The total inventory carrying cost = $4,000
The total cost, excluding normal time labor costs = $311,500
Peri Period Month Demand Production Ending Inventory Subcontract Units Subcontracting Cost = subcontracting units *$75 Inventory carrying cost = inventory * $20 The total cost, excluding normal time labor costs 0 December 200 0 0 1 January 1200 1200 200 0 0 4000 4000 2 February 1600 1200 0 200 15000 0 15000 3 March 1800 1200 0 600 45000 0 45000 4 April 1700 1200 0 500 37500 0 37500 5 May 2100 1200 0 900 67500 0 67500 6 June 2200 1200 0 1000 75000 0 75000 7 July 1900 1200 0 700 52500 0 52500 8 August 1400 1200 0 200 15000 0 15000 Total 13900 9600 4100 307500 4000 311500Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.