Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Extend SureStep's original (no backlogging) aggregate planning model from four to six months. Given the file P14_30.xlsx, add a forecasted demand of 4,000 units to
Extend SureStep's original (no backlogging) aggregate planning model from four to six months. Given the file P14_30.xlsx, add a forecasted demand of 4,000 units to Month 5, and of 5,000 units to Month 6. Is your optimal solution for the first four months of the extended model the same as it was for the original model? Enter all differences for workers hired, fired, overtime labor hours used, and shoes produced. Use negative quantities for decreases. If a quantity is unchanged, enter zero. Differences from Original model Workers hired Workers fired Overtime labor hours used Shoes produced Month 1 Month 2 Month 3 Month 4 0 0 0 0 0 0 0 0 0 0 0 0 A B C D E F 1 SureStep aggregate planning model 2 3 Input data 4 Initial inventory of shoes 500 5 Initial number of workers 100 6 Regular hours/worker/month 160 7 Maximum overtime hours/worker/month 20 8 Hiring cost/worker $1,600 9 Firing cost/worker $2,000 10 Regular wages/worker/month $1,500 11 Overtime wage rate/hour $13 12 Labor hours/pair of shoes 4 13 Raw material cost/pair of shoes 14 Holding cost/pair of shoes in inventory/month $15 $3 15 16 Worker plan 17 Workers from previous month 18 Workers hired 19 Workers fired 20 Workers available after hiring and firing Month 1 Month 2 Month 3 100 94 93 Month 4 50 0 0 0 0 6 1 43 0 94 93 50 50 21 22 Regular-time hours available 15040 14880 8000 8000 23 Overtime labor hours used 0 80 0 0 24 = Inventory after production 5 Forecasted demand 4260 5000 2000 1000 >= >= >= >= 3000 5000 2000 1000 Ending inventory 1260 0 0 0 Monetary outputs Month 1 Month 2 Hiring cost $0 Firing cost Regular-time wages Overtime wages Raw material cost Holding cost 5 Totals $12,000 $0 $2,000 Month 3 $0 Month 4 $0 Totals $0 $86,000 $0 $100,000 $141,000 $139,500 $75,000 $0 $1,040 $0 $75,000 $0 $430,500 $1,040 $56,400 $56,100 $3,780 $0 $30,000 $0 $213,180 $198,640 $191,000 $15,000 $0 $90,000 $157,500 $3,780 $692,820 Objective to minimize
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started