
Total production possible = Regular + OT = 1600 + 20%*1600 = 1600 + 320 = 1920
Formulas:
OT production = Demand - Production - Ending inventory of previous month, if the value is negative then OT = 0, if positive the value can be maximum 320 (20%*1600)
Ending inventory = Regular production + OT production + Ending inventory of previous month - Demand. If the value is negative it means we are not able to meet demand and ending inventory is zero.
For Example in Jan = 1600+2000+0-1500 = 300
May Ending inventory = 1600+320+20 - 2300 = -360 (Means it will be zero)
Stockouts = Demand - (Regular production + OT production + Ending inventory of previous month). if the value is negative it means there are no stockouts and hence stockout = zero.
For Example in May = 2300 - (1600+320+20) = 2300 - 340 = 360
Please note - In july we have produced 300 OT units as required per demand instead of maximum 320 capacity.
| Plan D | Cost | ||||||||
| Month | Demand | Production | OT production | Ending inventory | Stockouts | Month | Inventory cost = Ending inventory * 20 | OT cost = 50*OT units | Stockout cost = Stockout units * 60 |
| December | 200 | December | |||||||
| January | 1,500 | 1600 | 0 | 300 | 0 | January | $ 6,000.00 | 0.0 | 0.0 |
| February | 1,700 | 1600 | 0 | 200 | 0 | February | $ 4,000.00 | 0.0 | 0.0 |
| March | 1,800 | 1600 | 0 | 0 | 0 | March | 0.0 | 0.0 | 0.0 |
| April | 1,900 | 1600 | 320 | 20 | 0 | April | $ 400.00 | $ 16,000.00 | 0.0 |
| May | 2,300 | 1600 | 320 | 0 | 360 | May | 0.0 | $ 16,000.00 | $ 21,600.00 |
| June | 2,200 | 1600 | 320 | 0 | 280 | June | 0.0 | $ 16,000.00 | $ 16,800.00 |
| July | 1,900 | 1600 | 300 | 0 | 0 | July | 0.0 | $ 15,000.00 | 0.0 |
| August | 1,400 | 1600 | 0 | 200 | 0 | August | $ 4,000.00 | 0.0 | 0.0 |
| 14,700 | 12,800 | 1,260 | Total | $ 14,400.00 | $ 63,000.00 | $ 38,400.00 | |||
| total overtime production cost | $ 63,000.00 |
| Total inventory | $ 14,400.00 |
| Total Stockout cost | $ 38,400.00 |
| total cost,excluding normal time labor cost for plan D | $ 115,800.00 |
A) total overtime production cost b)total inventory holding cost for January through August c)tot...
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 $125 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,400 units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75 per...
Please answer only the empty boxes (bottom table and the
questions below it)
The total subtracting cost= $_______
The total inventory holding cost for January through August=
$_____
The total cost, excluding normal time labor costs, for Plan E=
$_____
Will thumps up if answers is correct!
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 1,400 1,700 May 2,300 January February 2,300 June March 1,700 1,700 July April...
a) the total cost of hiring=$ (enter your
response as a whole number)
b)the total cost of layoffs=$?(enter your response as a whole
number)
c)the total inventory carrying cost =$?(enter your response as a
whole number)
d)the total stockout cost$?(enter your response as a whole
number)
e) the total cost, excluding normal time labor cost, is =$
?(enter your response as a whole number)
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next...
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,500 June 2,300 March 1,600 July 1,700 April 1,900 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is...
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,300 February 1,600 June 2,200 March 1,800 July 1,800 April 1,700 August 1,800 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is...
Refrigeration Corp. needs an aggregate plan for January through June for its refrigerator production. The company has developed the following data: a) Plan A: Vary the workforce so that production meets the forecasted demand (maintain inventory at 250 units). Bell had eight employees on staff in December. Part-time labor is available. Complete the following table (enter your responses as whole numbers). Costs Holding cost $8/ refrigerator/ month Subcontracting $80/ refrigerator Regular-time labor $12/ hour Overtime labor $18/ hour for hours...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. 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 C. Plan C: Keep a stable workforce by maintaining a constant production rate equal...
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,200 February 1,500 June 2,100 March 1,600 July 1,700 April 1,800 August 1,700 Her operations manager is considering a new plan, which begins in January with 200units of inventory on hand. Stockout cost of lost sales is $125 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called...
The president of Hill Enterprises, Terri Hil, projects the firm's aggregate demand requirements over the next 8 months as follows: May January February ,600 June March April 1.700 August 2,300 2,300 1,900 1,400 1,700July Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $60 per unit. Inventory holding cost is $20 per unit per month. Ignore any dle-time costs. Evaluate the following plans D...
USE LEVEL AGGREGATE PLAN: Cost data Regular time labor cost per hour $10 Overtime time labor cost per hour $15 Subcontracting cost per unit $80 Back order cost per unit per period $20 Inventory holding cost per unit per period $10 Hiring cost per employee $400 Firing cost per employee $500 Capacity data Beginning workforce 40 employees Beginning inventory 0 units Beginning backorders 0 units Production standard per unit (hours) 2 hours of labor per unit Regular time available per...