(Answered) : For this question, set up and solve the problem in Excel3. Please present the final schedule as a table in your write-up. (20 pt

For this question, set up and solve the problem in Excel3. Please present the final schedule as a table in your write-up. (20 pts)

the manager of Blank Slate, Hao, is looking to figure out the weekly schedule for his servers. Each server should work 4 time slots out of the 6 that he or she is available. There should be exactly 2 servers working in each time slot. Servers may not work time slots they are not available.

The formulation is as follows:

https://media.cheggcdn.com/media%2F80b%2F80b5ed42-0e32-43ce-b278-71eedd2b6821%2Fphp5cOkl5.png
Inputs Set of servers J Set of time slots djDemand (number of servers to schedule) in time slot j