Question

QUESTION 2: Kafue Steel has recorded the monthly forecast for one of its products, mild steel...

QUESTION 2:

Kafue Steel has recorded the monthly forecast for one of its products, mild steel grade AISI 1023 rods, for January, February, March and April as 1000, 1500, 1200, and 1400, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, 21 in March and 21 in April. Beginning inventory is 500 units.

Manufacturing cost is K1,000,000 per unit, storage cost is K15,000 per unit per month, standard pay rate is K30,000 per hour, overtime rate is K45,000 per hour, cost of stock out is K50,000 per unit per month, marginal cost of subcontracting is K50,000 per unit, hiring and training cost is K1,000,000 per worker, layoff cost is K1,500,000 per worker, and worker productivity is 0.1 unit per hour. Assume that Kafue Steel starts off with 50 workers working 8 hours per day.

Which of the following strategies would you recommend Kafue Steel use for its aggregate planning and why?

(a) Produce exactly to meet demand, vary the workforce

(b) Constant workforce of 80, vary inventory and stock outs

Homework Answers

Answer #1

Excel model was prepared and SOLVER was used to solve for the decision variables. Decision variables are highlighted in Orange/Red. Objective function in Yellow.

(a). Total cost as per "Meet Demand" strategy = $378,250,000 as shown below:

(b) Total cost as per "Constant Workforce" strategy = $6,414,900,000 as shown below:

The huge difference between these 2 strategies is because of sub-contracting cost which is substantially low, which is why under "Meet Demand" strategy, all employees get fired and all production is sub-contracted.

As per the above results, I would definitely recommend "Meet Demand" strategy, which is option (a) due to significantly lower total osts.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Develop a production schedule to produce the exact production requirements by varying the workforce size for...
Develop a production schedule to produce the exact production requirements by varying the workforce size for the following problem. The monthly forecasts for Product X for January, February, and March are 950, 1,510, and 1,220, respectively. Safety stock policy recommends that half of the forecast for that month be defined as safety stock. There are 22 working days in January, 19 in February, and 21 in March. Beginning inventory is 550 units. Storage cost is $4 per unit per month...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
Plan production for a four-month period: February through May. For February and March, you should produce...
Plan production for a four-month period: February through May. For February and March, you should produce to exact demand forecast. For April and May, you should use overtime and inventory with a stable workforce; stable means that the number of workers needed for March will be held constant through May. However, government constraints put a maximum of 5,000 hours of overtime labor per month in April and May (zero overtime in February and March). If demand exceeds supply, then backorders...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050...
The Ace Battery Company has forecast its sales in units as follows:   January 1,500 May 2,050   February 1,350 June 2,200   March 1,300 July 1,900   April 1,800 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 1,950 units, which is consistent with this policy. Materials cost $10 per unit and are paid for in the month after production. Labour cost is $3 per unit and...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750...
The Volt Battery Company has forecast its sales in units as follows: January 2,200 May 2,750 February 2,050 June 2,900 March 2,000 July 2,600 April 2,500 Volt Battery always keeps an ending inventory equal to 120% of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 2,640 units, which is consistent with this policy. Materials cost $11 per unit and are paid for in the month after purchase. Labor cost is $4 per unit and...
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,500 May February 1,700 June 2,200 March 1,600 July 1,700 April 1,900 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 ?$100per unit. Inventory holding cost is ?$20 per unit per month. Ignore any? idle-time costs. The plan is called plan...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore,...
Suppose you have been given responsibility for developing the six-month aggregate production plan at Soda Galore, a manufacturer of soft drinks. Your company makes three types of soft drinks: regular, diet, and super-caffeinated. Fortunately, all three types are made using the same production process, and the costs related to switching between the three types are so minimal that they can be ignored. Thus, you can treat your problem as an aggregate planning exercise where the planning unit is cases of...
6. Latrisa International Inc. manufactures outdoor clothing apparel. They have developed a forecast for their sandal...
6. Latrisa International Inc. manufactures outdoor clothing apparel. They have developed a forecast for their sandal Line. They have hired you to help them develop their production schedule for the next six months. Please use the information below to develop the production schedule and answer the questions below. (20 points) • Full time employee 10 employees • Hourly pay rate (8hrs) $ 8.00 • Labor-hours per unit 4 hours per unit • Subcontracting cost $ 20.00 • Inventory carrying cost...
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a...
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 Demand 1 7,500,000 2 8,300,000 3 15,000,000 4 12,500,000 Current workforce 300 workers Average output per worker 25,000 jeans per quarter Inventory...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT