Scheduling Problem $-$ Airport Problem Description

What we have

Major airports around the world operate $24$ hours a day throughout the year.

$3$ shifts per day means a total of $21$ shifts per week.

Adjustments are in table $1.$ Staffing requirements are in table $2$

What we know

Table $1$

Days Off

Weekly Wage First Shift

Weekly Wage Second Shift

Weekly Wage Third Shift

M$,$ Tu

$1200$

$1300$

$1400$

Tu$,$ W

$1200$

$1300$

$1400$

W$,$Th

$1200$

$1300$

$1400$

Th$,$ F

$1150$

$1250$

$1350$

F$,$ Sa

$1100$

$1200$

$1300$

Sa$,$ Su

$1000$

$1100$

$1200$

Su$,$ M

$1080$

$1180$

$1280$

Table $2$

Days

Employees Required First Shift

Employees Required Second Shift

Employees Required Third Shift

M

$12$

$10$

$2$

Tu

$16$

$14$

$3$

W

$18$

$16$

$3$

Th

$15$

$13$

$2$

F

$19$

$25$

$3$

Sa

$10$

$4$

$2$

Su

$15$

$12$

$3$

Find out

How many workers get which days off?

How many people do we staff per day?

Why is there no sensitivity report?

Individual Thinking $(5$ min$)$

Concept Recall

Please recall the following concepts from online learning.

Objective Function

Decision Variables

Constraints

Problem Analysis

Think about the following questions while analyzing the problem. Take notes of your thoughts to share with your group in the next step.

What is the objective of this problem?

What decision variables do you have?

What is the objective function going to be$?$

What constraints or rules do you have to follow?

What is different in this problem as compared to the theme park problem?

Individual Work $/$ Optional Virtual Group Collaboration $(30$ mins$)$

Problem Solving

First, share your individual problem analysis with group members. Then, follow the steps below to solve the problem.

Step $1$

Set up the core problem.

Solve the problem using solver.

Compare your objective function value with your group.

Step $2$

Set up the constraints in the solver and run it$.$

Compare your objective function value with the group.

Step $3$

Read the sensitivity report and answer the following questions:

What is the total cost of hiring?

How many workers work on Monday?

Why is there no sensitivity report?

Step $4$

Submit your Excel file on Moodle individually after answering the questions in Step $3.$

Some Hints on the Next Page!