Month | Demand | Production | Hire(Units) | Layoff(Units) | Ending Inventory | Stockouts(Units) | |
1 | July | 1200 | 1300 | 0 | 0 | 100 | 0 |
2 | August | 1300 | 1200 | 0 | 100 | 0 | 0 |
3 | September | 1200 | 1300 | 100 | 0 | 100 | 0 |
4 | October | 1700 | 1200 | 0 | 100 | 0 | 400 |
5 | November | 1650 | 1700 | 500 | 0 | 50 | 0 |
6 | December | 1650 | 1650 | 0 | 350 | 50 | 0 |
600 | 550 | 300 | 400 |
Total hiring cost = 600 units * $30 = $18000
The total layoff cost = 550 units *$65 = $35750
The total inventory carrying cost = 300 units * $ 30 = $9000
The total stockout cost = 400 units * $125 = $50000
The total cost, excluding the normal time labour cost for plan is $112750
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the...
The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time stockout costs for lost sale per unit, inventory carrying costs of $30 per unit per month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis: Plan A: Produce at a steady rate (equal to minimum requirements) of 1,100 units per month and subcontract additional units at a $60 per unit premium cost. Subcontracting capacity is...
Plan B: Vary the workforce to produce the prior month's demand. The firm produced 1,300 units in June. The cost of hiring additional workers is $35 per unit produced. The cost of layoffs is $60 per unit cut back. (Enter all responses as whole numbers.) Note: Both hiring and layoff costs are incurred in the month of the change (i.e., going from production of 1,300 in July to 1200 in August requires a layoff (and related costs) of 100 units...
CGA 9 (Aggregate Planning) The S&OP team at Kansas Furniture has received the following estimates of demand requirements Aug 1,200 Sept 400 1,800 Jul Oct Nov Dec ,800 1,800 a) Assuming one-time stockout costs for lost sales of $100 per uni, nventory carrying costs of $25 per unit er month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis Plan A: Produce at a steady rate (equal to minimum requirements) of 1,000 units per...
The S&OP team at Kansas Furniture, has received the following estimates of demand requirements: Complete the table The S&OP team at Kansas Furniture, has received the following estimates of demand requirements: July Aug. Sept. Dec. Oct. 1,900 Nov. 1,900 900 1,200 1,500 1,900 Assuming stockout costs for lost sales of $90 per unit, inventory carrying costs of $30 per unit per month, and zero beginning and ending inventory, evaluate these two plans on an incremental cost basis: Plan C: Keep...
Please help with the missing numbers above Also Total hiring cost $ _?(enter response as whole number) Total layoff cost $ _?(enter response as whole number) Total inventory carrying cost $ _?(enter response as whole number) Total stockout cost $ _?(enter response as whole number) Total cost, excluding normal time labor costs, for Plan B $ _?(enter response as whole number) The S&OP team at Kansas Furniture, has received estimates of demand requirements as shown in the table. Assuming one-time...
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,700 June 2,100 March 1,700 July 1,700 April 1,800 August 1,700 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 Hil, prajects the firm's aggregate demand requirements over the next 8 months as folows 200 1,600 1,700 1,700 May January February March Apri 2,100 1,900 1,900 July ust 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 called plan...
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,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 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...