The ASSIGNWB.xls Model

Assignment Problem

View the model
Download the model

Staff scheduling is usually a very costly and laborious job. In institutions where there are several daily shifts and the staff can rotate between shifts during the same period, the task is even more complicated. The scheduler must match the organization's requirements with the preferences of individual employees. Larger numbers of employees and longer time periods make the task more difficult.

This problem involves scheduling several staff members in an organization that operates in multiple time shifts each day, seven days a week.

Objective of Optimization:
The objective is to maximize overall staff preference by assigning employees to the shifts they deem most desirable.


Scheduling | Staff Scheduling |