S Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon...

  

Transcribed Image Text:

S Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,800,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $24 per hour. Quarter 1 2 3 Demand 7,500,000 9,900,000 15,000,000 14,100,000 Current workforce Average output per worker. Inventory holding cost Regular wage rate Regular production hours Hiring cost Firing/layoff cost Beginning inventory Quarter Demand 1 2 3 4 Total 7,500,000 9,900,000 15,000,000 14,100,000 46,500,000 $ $ a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank- be certain to enter "0" wherever required.) Workers Required Regular Production $ $ 300 workers 25,000 jeans per quarter. 0.10 pair per quarter. 16.00 per hour 500 hours per quarter 490 per worker 400 per worker $1,800,000 Overtime Production Ending Inventory 0 Hire 0 Fire layoff 0 a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank - be certain to enter "0" wherever required.) Regular Production Overtime Production Ending Inventory Workers Required Quarter 1 2 3 4 Total Demand Total cost 7,500,000 9,900,000 15,000,000 14,100,000 46,500,000 0 0 b. Compute the cost of a chase plan using a stable workforce of 300 workers. Hire 0 Fire layoff 0 S Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,800,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $24 per hour. Quarter 1 2 3 Demand 7,500,000 9,900,000 15,000,000 14,100,000 Current workforce Average output per worker. Inventory holding cost Regular wage rate Regular production hours Hiring cost Firing/layoff cost Beginning inventory Quarter Demand 1 2 3 4 Total 7,500,000 9,900,000 15,000,000 14,100,000 46,500,000 $ $ a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank- be certain to enter "0" wherever required.) Workers Required Regular Production $ $ 300 workers 25,000 jeans per quarter. 0.10 pair per quarter. 16.00 per hour 500 hours per quarter 490 per worker 400 per worker $1,800,000 Overtime Production Ending Inventory 0 Hire 0 Fire layoff 0 a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank - be certain to enter "0" wherever required.) Regular Production Overtime Production Ending Inventory Workers Required Quarter 1 2 3 4 Total Demand Total cost 7,500,000 9,900,000 15,000,000 14,100,000 46,500,000 0 0 b. Compute the cost of a chase plan using a stable workforce of 300 workers. Hire 0 Fire layoff 0