Please provide exact formula for constraint. This is all the information provided by the instructor. Sorry this is out of order. The scenario is the last picture. I just needed help with this question, but there are other instructions for the whole assignment and I have those done. If you would like me to upload those documents, I could but no need to solve them, unless it helps you with this! thank you.
Explore Create a Solver model that sets the value of cell D25 to 0 (indicating that all shifts are covered) by changing the values in the range D5:J19 under the following constraints: . Add a binary constraint to force every value in the range D5:J19 to be either a 0 or a 1. . Add a constraint to limit the total hours worked by each full-time employee to less than or equal to 40. . Add a constraint to limit the total hours worked by each part-time employee to less than or equal to 24. . Add a constraint to require that the difference values in the range D23:J23 all equal 0. . Based on the entries in the range C5:C19, add constraints so that employees are not scheduled to work shifts on days when they are unavailable to work.Crystal SCI'EEI'I Michael Boyle is a manager at the Crystal Screen movie theater in Dakland Park, Florida. ne of his jobs is to create the weekly work schedule for the movie ushers. The theater employs 16 ushersl4 are full-time and two are part-time. The theater needs eight ushers to work each weekday: 11 on Saturday, and ID on Sunday. Michael is currently working on the usher schedule for the second week in August. Michael tries to accommodate all time-off requests while maintaining the required staff. He has been developing a workbook to automatically generate the work schedule. The workbook already contains the names of the ushers and their time-off requests. He asks you to determine which ushers will he working which days. Complete the following: K B C D E F G H J L A Crystal Screen Movie Theater Schedule for the Week of August 7 to August 13, 2017 W N Employee Status Notes Mon Tue Wed Thu Fri Sat Sun Total Shifts Total Hours Bryant, Margaret Full Time 0 0 0 0 Can't work Wednesday through Saturday 0 O 0 0 Clark, Bonnie Full Time 0 0 O Full Time 0 0 0 0 0 Davis, Mark 0 8 Everett, Mary Full Time Can't work Wednesday 0 0 0 Garrison, John Full Time Can't work Thursday 0 9 10 Goodman, Iva Full Time Full Time Can't work Monday through Friday 0 11 Irvine, Jerry 03 00 00 03 00 00 03 00 00 03 00 03 00 03 00 12 Laird, Anita Full Time Can't work this week 13 Long, Charles Full Time poooooooooo 14 Miller, Heather Full Time Can't work Saturday 15 Miller, Helen Full Time 16 Patterson, Kelly Full Time 17 Rodriguez, Debbra Full Time Can't work Friday 0 0 0 0 18 Stuart, Monica Part Time Can't work Saturday 19 Williams, Jeff Part Time 20 21 Ushers Required 8 8 8 11 10 Ushers Scheduled 0 O 0 0 0 0 22 18 8 8 18 11) (10) 23 Difference 24 25 Total Shortfall in Shifts (61) 26 27 28 29 30 31 Schedule +
