Question

In: Operations Management

The S&OP team at Kansas Furniture, has received the following estimates of demand requirements Assuming one-time...

  1. The S&OP team at Kansas Furniture, has received the following estimates of demand requirements Assuming one-time stockout costs for lost sales of $100 per unit, inventory carrying costs of $25 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,000 units per month and subcontract additional units at a $60 per unit premium cost.
    • 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 $3,000 per 100 units produced. The cost of layoffs is $6,000 per 100 units cut back.

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 1,000 in August requires a layoff (and related costs) of 300 units in August, just as going from production of 1,000 in August to 1,200 in September requires hiring (and related costs) of 200 units in September).

Solutions

Expert Solution

To make a comparative analysis, we will do a comparative cost analysis :

Plan A:

Month Demand units Production units EOP Inventory SCU IC SC
June 1000
July 1000 1000 0 0 0 0
August 1200 1000 0 200 0 12000
September 1400 1000 0 400 0 24000
October 1800 1000 0 800 0 48000
November 1800 1000 0 800 0 48000
December 1600 1000 0 600 0 36000
Total Cost $ 168000

Total Cost = $ 168000

where EOP = End of Period

SCU =Sub Contract Units

IC = Inventory Cost

SC = SubContract Cost

Plan B:

Month Demand Units Production Units Hire Units Layoff Units Hire Cost Layoff Cost
June 1300
July 1000 1000 0 300 0 18000
August 1200 1200 200 0 6000 0
September 1400 1400 200 0 6000 0
October 1800 1800 400 0 12000 0
November 1800 1800 0 0 0 0
December 1600 1600 0 200 0 12000
Total Cost 24000 30000

Hence the Total Cost in case of Plan B = 24000+30000= 54000 $

As we can see the total cost is less in Plan B which is 54000 $ as to compared to Plan A where the total cost is 168000 $ . Hence Plan B is better as compared to Plan A.


Related Solutions

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 sales of $125125 per unit, inventory carrying costs of $2525 per unit per month, and zero beginning and ending inventory, evaluate the following plan on an incremental cost basis:Plan B: Vary the workforce to produce the prior month's demand. The firm produced 1 comma 3001,300 units in June. The cost of hiring additional workers is $3030 per...
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 sales of ​$100100 per​ unit, inventory carrying costs of ​$2525 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 comma 1001,100 units per month and subcontract additional units at a ​$7070 per unit premium cost....
The following CPM network has estimates of the normal time in weeks listed for the activities:...
The following CPM network has estimates of the normal time in weeks listed for the activities: Activity Immediate Pred Weeks A - 7 B A 2 C A 4 D B, C 5 E B, C 2 F D, E 4 G F 5 Activity Normal Time Crash Time Normal Cost Crash Cost A 7 6 $7,000 $8,000 B 2 1 5,000 7,000 C 4 3 9,000 10,200 D 5 4 3,000 4,500 E 2 1 2,000 3,000 F 4...
A project has the following activities, precedence relationships, and time estimates in weeks: ​ Activity Immediate...
A project has the following activities, precedence relationships, and time estimates in weeks: ​ Activity Immediate Predecessor Activities Optimistic Time (to) Most Likely Time (tm) Pessimistic Time (tp) A — 15 20 25 B — 8 10 12 C A 25 30 40 D B 15 15 15 E B 22 25 27 F E 15 20 22 G D 20 20 22 ​ a.   Compute the expected time and variance for each activity. b.   Determine the critical path and the expected...
Teloxy Engineering has received a one-time contract to design and build 10,000 units of a new...
Teloxy Engineering has received a one-time contract to design and build 10,000 units of a new product. During the proposal process, management felt that the new product could be designed and manufactured at a low cost. One of the ingredients necessary to build the product was a small component that could be purchased for $60 in the marketplace, including quantity dis- counts. Accordingly, management budgeted $650,000 for the purchasing and handling of 10,000 components plus scrap. During the design stage,...
Question One a) The Kenya National Bureau of statistics has made the following estimates for the...
Question One a) The Kenya National Bureau of statistics has made the following estimates for the Kenyan economy; - Marginal propensity to consume (MPC) = 0.25, Investment (I) = 5500, Government spending (G) = 12000, Autonomous consumption (α) = 1500, Net Exports (X-M) = 3500 Y= C+ I + G + X-M C= α + βY Required; - i) Calculate the equilibrium level of National Income. ii) Calculate the equilibrium consumption and savings. iii) Compute a simple investment multiplier and...
Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters....
Fred's Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 800 units 1 700 Beginning inventory 0 units 2 900 Stockout cost $100 per unit 3 1200 Inventory holding cost $10 per unit at end of quarter 4 600 Hiring workers $20 per unit Laying off workers $40 per unit Subcontracting cost $200 per unit Unit cost $100 per unit Which of the following production plans is better: Plan...
ABC Manufacturing has the following Aggregate Plan demand requirements and other data for the upcoming four...
ABC Manufacturing has the following Aggregate Plan demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1300 Beginning inventory 200 units 2 1400 Stockout cost $50 per unit 3 1500 Inventory holding cost $10 per unit at end of quarter 4 1300 Hiring workers $4 per unit Laying off workers $8 per unit Unit cost $30 per unit Overtime $10 extra per unit By utilizing the aggregate planning excel sheet, answer...
1) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four...
1) Eagle Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. Quarter Demand Previous quarter's output 1500 units 1 1400 Beginning inventory 200 units 2 1000 Stockout cost $50 per unit 3 1500 Inventory holding cost $8 per unit at end of quarter 4 1300 Hiring workers $5 per unit Laying off workers $10 per unit Unit cost $30 per unit Overtime $10 extra per unit Which of the following production plans is better:...
1. ABC Fabrication has the following aggregate demand requirements and other data for the upcoming four...
1. ABC Fabrication has the following aggregate demand requirements and other data for the upcoming four quarters. QUARTER DEMAND 1 1400 2 1200 3 1600 4 1500 Other information; Previous Quarter's output 1300 units Beginning Inventory 0 units Stock out cost $50 per unit Inventory holding cost $10 per unit at the end of the quarter Hiring workers $40 per unit Laying off workers $80 per unit Subcontracting Cost $60 per unit Unit Cost $30 per unit Overtime $15 extra...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT