Hello Everyone,
I have never used Solver, but have a problem where I need to determine the number of workers required for a job scheduled over a period of +-3 months, with some constraints. Each day has a forecasted number of required workers for that day, with approximately 60% day shift and 40% night shift. Workers may only work 14 consecutive days of 12 hour shifts, after which they need to have a 7 day break. So the task need to determine the extra number of workers to employ, to be able to cover for the fatigue management constraint and complete the job.
I am attaching a spreadsheet and would appreciate if someone can point me in the right direction or any assistance, as I have no idea where to start and how to structure the data to be able to run solver.
Kind Regards
Coenie
Bookmarks