What is the minimum number of workers required and must


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.

Solution Preview :

Prepared by a verified Expert
Basic Statistics: What is the minimum number of workers required and must
Reference No:- TGS0585704

Now Priced at $20 (50% Discount)

Recommended (92%)

Rated (4.4/5)