INCLUDE AN EXCEL SPREADSHEET FOR EACH QUESTION Chapter 7 Questions A local low-acuity emergency department wants to improve its patient flow. The facility has as its goal that 85 percent or more of the arriving patients will be seen by a doctor in 60 min or less. Currently, the facility is not meeting that goal. An initial, high-level process map has been developed (SEE FIGURE 7.5 BELOW), along with some observations from an outside team of analysts. Your task is to determine what else may be done to help this facility better understand the reasons it has been unable to meet its service-level goal. Specifically explain in detail how each of the eight approaches listed might help this facility in determining where it should focus its change efforts if it wants to meet its current service-level goal. Observations: 1. Time spent at registration is consistently less than 5 min. 2. Time spent in triage is consistently less than 5 min. 3. Time spent in the waiting room is highly variable (five min to 100 min) and depends on the patient's acuity (more severe patients are seen more quickly) 4. Time spent in examination room is highly variable (10 min to 100 min) and depends on availability of doctor and extent of testing required. 5. Time spent at discharge is consistently less than five min. 6. The facility operates 15 hours a day, seven days a week. 7. The facility has 10 patient examination rooms, two full-time doctors, one part-time doctor, two nurses, and one triage nurse. 8. All patient diagnoses must be entered into a computer system by the doctor at the conclusion of a patient's examination. Approaches to consider: -Process mapping (for sub-processes.) -Value stream mapping -Staffing and workload management -Productivity analysis -Analysis of data for key emergency department productivity measures Chapter 8 Question Use Solver to nd the optimal solution to the given integer programming problem. Consider the same operating room discussed in the Solver example in the chapter. Suppose that instead of maximizing prot from surgeries, our objective is to minimize the cost incurred due to surgeries. As before, we denote the number of major surgeries scheduled in a week using decision variable s1, the number of minor surgeries scheduled in a week using decision variable s2, and the number of elective surgeries scheduled in a week using decision variable s3. The relevant data for each type of surgery is: Surgery Type Cost Operating Room Time Labor Hours Major (s1) $5,500 4 hours 15 Minor (s2) $3,000 0.5 hour 10 Elective (s3) $4,000 2 hours 12 In addition, for this problem we will assume the facility has only one operating room, which is available 60 hours per week, and the facility has a total of 500 labor hours a week that can be devoted to surgeries. Prior to using Solver, you may want to formulate your problem (i.e, clearly identify decision variables, objective functions and constraints)