Lifeguards are assigned to work 5 consecutive days a week and have 2 days off. They have to have this number daily, so how do I set this up on a spreadsheet?
sun 18 mon 17 tues 16 wed 16 thur 16 fri 14 sat 19
How do I find the optimal solution?© BrainMass Inc. brainmass.com December 20, 2018, 8:15 am ad1c9bdddf
Please see the attached file.
Day Lifeguards Needed
Sunday 18 You can see the set up in ...
Steps to find the optimal solution are embedded.