Hi,

I'm trying to build a rotation schedule with 4 resources that need to cover 3 different job locations.

These is the restrictions I have:

Resource 1, will work in Location A, being 21 days in, 7 days off.
Resource 2, will work in Location B, bring 21 days in, 7 days off.
Resource 3, will work in Location C, being 14 days in, 14 days off.
Resource 4, will cover all locations, with the following restriction 5 days in Location A, 5 days in Location B, 5 days off, 5 days in Location C, 5 days off;

I'm looking for an optimized schedule for a 12 month period... trying to have the least number of days with any site uncovered.

I have some experience in resolving linear problems with Solver... but this one got me in a maze and honestly, couldn't figure out how to solve.

Any ideas?

Thank you!!