MGTSC 352. Lecture 10: Aggregate Planning Leduc Control Example: Complete post-optimality analysis Case 2: Mountain Wear Set up and use solver to find minimum cost plan. Announcements. HW 3 grading For next week read Air Alberta p. 72 Crazy Joey’s p. 77. More Post-Optimality Analysis.
Lecture 10: Aggregate Planning
Leduc Control Example:
Complete post-optimality analysis
Case 2: Mountain WearSet up and use solver to find minimum cost plan
Look at Nathan’s plans in Excel
Level and chase:
Air Alberta is doing aggregate planning of flight attendant staffing for the next 6 months. They have forecast the number of flight attendant hours needed per month for March to August, based on scheduled flights, and wish to determine how many new attendants to hire each month. Each trained attendant on staff supplies 150 hours per month. A newly hired attendant is called a trainee during the first month, and each trainee’s net contribution is negative (-100 hours) because (s)he requires supervision, which detracts from the productivity of other attendants. Each trained attendant costs $1500 in salary and benefits per month while each trainee costs $700 per month. Normal attrition (resignations and dismissals) in this occupation is high, 10% per month, so Air Alberta never has any planned layoffs. Trainees are hired on the first day of each month and become attendants on the first day of the next month (with no attrition). As of March 1, Air Alberta has 60 trained attendants.
Go to Excel
1. Solver settings to find a least cost staffing plan:
2. The least cost staffing plan:
3. The total cost of this plan is $
4. In which month does Air Alberta have the most excess attendant hours?
5. Air Alberta is considering running extra charter flights requiring 1000 flight attendant hours in either June or July. Which month would you choose to minimize total staffing costs? Why?