Consider the model below for scheduling postal workers to 5 day shifts:
Minimize z = MF + TS + WSu + ThM + FT + SW + SuTh
Subject to MF + ThM + FT + SW + SuTh = 17
MF + TS + FT + SW + SuTh = 13
MF + TS + WSu + SW + SuTh = 15
MF + TS + WSu + ThM + SuTh = 19
MF + TS + WSu + ThM + FT = 14
TS + WSu + ThM + FT + SW = 16
WSu + ThM + FT + SW + SuTh = 11
Non-negativity constraints:
Here, MF for example, is the number of workers assigned to the shift that starts on Monday and runs through Friday. Note that this model allows a worker to be assigned to a shift and only dedicate a fraction of his efforts to the tasks that make up the requirements. Workers like these dedicate the remainder of their efforts to, say, strategic projects. What is the minimum number of workers required? Must include all model and solver formulas in excel.