Employee Scheduling Using the Linear Program Solver Function in MS Excel

[@johndavidcastilloflores4423]

Thank you sooo muchhhh! You saved my life with this example!

[@TheOpenEducator]

You will find more here: www.theopeneducator.com/operations-and-supply-chain-management www.theopeneducator.com/home

[@baileyshen5249]

This is fantastic! The only problem is that the free Solver tool is limited in how many variables you can solve for. However, the company Frontline sells upgraded Solver versions that can take more variables.

[@cosmohj26]

hello, thank you for this video. How would i add an constraint that stops people working certain shifts? For example if a nurse works tuesday they cannot work thursday, or if a nurse works saturday they cannot work sunday? Thank you very much

[@baileyshen5249]

Hmm, you could make another cell/constraint so that Tuesday + Thursday is less than or equal to one.

[@SnehaK-hn2fw]

how is it that Mitchell chose NOT to work on Tuesday (with value 2) but chose to work on Saturday (with value 1)?

[@Waleed-el5zu]

How can i add a constrain that days off have to be consecutive?

[@TheOpenEducator]

You will find more here: www.theopeneducator.com/operations-and-supply-chain-management

[@uwadiegwuemmanuel8809]

Thanks