Answer question 17-21 as it is all part if the same proboem

11.6. Reconsider Example 11.2 (Hospital Emergency Room) to determine if additional nurses will be required to staff the revised daily shift requirements shown below: Day Sun. Mon. Tues Wed Thurs. Fri. Sat. Nurses 3 6 S 6 6 6 5 Pape 325 Develop a weekly workshift schedule providing 2 consecutive days off per week for each nurse. Formulate the problem as an integer linear programming model to minimize the number of nurses needed, and solve using Excel Solver. If more nurses are required than the existing staff of eight, suggest an alternative to hiring full-time nurses. Example 112 Marin County 911 Response Step 1 Forecast Demand Dally demand is forecast in half-hour intervals, as shown in Figure 11.3 and must account for both weekday and weekend variations as well as seasonal adjustments. The Saturday and Sunday call food was found to be approximately 55 percent of the typical weekday lond. Summer months were found to be generally lower in derrand Special high-demand days, such as Mother's Day and Christmas, were taken into account Step 2 Convert to Operator Requirements A profile of half hour operator requirements is developed on the basis of the forecast dolly demand and call distribution. The agreed service level requires that 89 percent of the time, an incoming call must be answered Within 10 seconds. The half-hour operator requirements are determined using a conventional queuing model found in Chapter 13. Capacity Planning and Queuing Models) to ensure that the service level is achieved for each hai hour. The result is a topine profile of operators required by the half hout, as shown in Figure 1146 Pepe 310 POURE 11.4 Profile Operator Requirements and Tour Assignments Topline profile 20 Number of operators Scheduler program assigns tours so that the number of operators present each half hour adds up to the number required (topline) Tour 0 12 AM 2 4 6 8 4 6 8 10 12 10 12 2 NOON Time PM Step 3. Schedule Shifts Tours, representing various start and end times of work, need to be assigned so that they aggregate to the topline profile, shown in Figure 1140 Each tour consists of two wording sessions separated by a rest pause or meal period leg. 9AM-1 PM. lunch break, 2 PM-6 PM The set of possible tours is defined by state and federal laws. union agreements, and company policy. A heuristic computer program prepared especially for this problem chooses tours from the permissible set such that the absolute difference between operator requirements and operators assigned is minimized when summed over all half hour periods. If R is the number of operators required in period and Wiis the number of operators assigned in period then the objective can be stated as follows Use your results for homework problem 11.6 to answer the following questions Question 17 12 points) Live How many nurses are staffed for Sunday? Your Answer: Answer Question 18 (2 points) ten How many nurses are staffed for Monday? Your Answer Answer Question 19 (2 points) 4 listen How many nurses are staffed for Tuesday? Your Answer: Answer Question 20 (2 points) Listen How many nurses are staffed for Wednesday? Your Answer: Answer Question 21 [2 points) Listen How many nurses are staffed for Thursday? Your