Question: It does not need to be correct, but show me reasonable solving steps with one table at least. The emergency room is open 24 hours


It does not need to be correct, but show me reasonable solving steps with one table at least.
The emergency room is open 24 hours a day and all week. A day is divided into three shifts for eight hours. The total number of nurses required for each day of the week is as follows. Sun Mon Tue Wed Thur Fri Sat Day Required 3 6 5 6 5 5 5 nurses The emergency room manager intends to develop a work schedule that can minimize the number of nurses to be placed in the emergency room. Nurses work five days a week and have to rest two consecutive days a week. The right-variant constant value of the constraint formula is (b1=3, b2=6, b3=5, b4=6, b5=5, b6=5, b7=5). When the integer planning model is created and a solution is obtained: x1=1, x2=1, X3=2, x4=0, x5=3, x6=0, and x7=1. Therefore, one worker will be off on Sundays and Mondays, one on Mondays and Tuesdays, two on Tuesdays and Wednesdays, three on Thursdays and Fridays, and one on Saturdays and Sundays. As shown in the table, the number of people in excess is generated only on Sundays and Saturdays. Nurse Sun Mon Tue Wed Thur Fri Sat B D E F G G H x x 6 5 6 5 5 7 Total 6 Requested 3 number of 6 5 6 5 5 5 nurses nurses in 3 0 0 0 0 0 1 excess Thus, we need 8 nurses. If the demand for weekly shift workers has changed as follows, determine if additional nurses are needed. Sun Mon Tue Wed Thur Fri Sat Day Required 3 6 5 6 6 6 5 nurses Prepare weekly work schedules for each nurse with two consecutive days off per week. Formula the problem with integer linear planning, minimize the number of nurses required, and use Excel's Solver to find a solution. If a nurse is needed more than the existing eight, a full-time nurse can be hiredStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
