The STAFF.xls Model

Staff Scheduling

View the model
Download the model

In staff scheduling problems, the goal is to meet specified manpower requirements at minimum cost. In general, the schedule must meet certain conditions, such as those imposed by regulations or union contracts, including minimum shift length, number of work breaks, or maximum overtime hours.

These models have applications in the scheduling of airline flight crews, hospital and office staffs, and restaurant personnel, to name just a few.

Objective of Optimization:
The objective is to cover staff needs with five-day shifts at minimum weekly payroll cost.

Keywords:

Scheduling | Staff Scheduling | Covering |