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...
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...
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...
Special Order Pope Company manufactures a variety of hiking boots and has received a special one-time-only...
Special Order Pope Company manufactures a variety of hiking boots and has received a special one-time-only order from a new customer. Pope has sufficient idle capacity to accept the special order to manufacture 1,000 pairs of boots at a price of $50.00 per pair. Pope’s normal selling price is $65.00 per pair of boots. Variable manufacturing costs are $35.00 per pair and fixed manufacturing costs are $12.00 a pair. Pope’s variable selling expense for its normal line of boots is...
Bluebird Mfg. has received a special one-time order for 15,000 bird feeders at $2.10 per unit....
Bluebird Mfg. has received a special one-time order for 15,000 bird feeders at $2.10 per unit. Bluebird currently produces and sells 75,000 units at $6.10 each. This level represents 80% of its capacity. These bird feeders would be marketed under the wholesaler’s name and would not affect Bluebird’s sales through its normal channels. Production costs for these units are $3.45 per unit, which includes $1.80 variable cost and $1.65 fixed cost. If Bluebird accepts this additional business, the effect on...
S Company has been investigating the time taken to produce one of its products, and found...
S Company has been investigating the time taken to produce one of its products, and found that a 90% learning curve appears to be applicable. The time taken for the first unit is 7 hours. What is the total time taken in hours for units 5 to 8 only?
Your firm is considering issuing​ one-year debt, and has come up with the following estimates of...
Your firm is considering issuing​ one-year debt, and has come up with the following estimates of the value of the interest tax shield and the probability of distress for different levels of​ debt: Debt Level​ (in $​ million) 0 40 50 60 70 80 90 PV​ (interest tax​ shield, $​ million) 0.00 0.76 0.95 1.14 1.33 1.52 1.71 Probability of Financial Distress 0% 0% 1% 2% 7% 16% 31% Suppose the firm has a beta of​ zero, so that the...
One of our dealerships has the following average unit sales per team member. We are concerned...
One of our dealerships has the following average unit sales per team member. We are concerned that the dealership variance and the population variance are different. We would like to be 95% confident about our findings. Historically the population variance has been about 390,000. Use the following data as a basis for making inferences about the population variance. Prepare the information about a Confidence Interval and Hypothesis Testing. Team Member Average Dollar Sale xbar x-xbar x-xbar^2 1 25000 2 25500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT