Homework Set 11: The following set of problems either taken from lecture notes or from the book: “SIMIO and Simulation: Modeling, Analysis and Application”, by Smith, Sturrock and Kelton, Kenneth N., 4th ed. 2017. Answer the questions below in MS Excel and SIMIO. Upload your MS Excel Workbooks (*.xlsx extension) and SIMIO Project Files (*.spfx extension) in Blackboard.

Homework 1: HW_7_06 in the book a) Develop the simulation model where staff scheduled patient arrivals once every 10 minutes.

Develop an experiment with response variables evaluating the number of patients seen, the average waiting time of patients and the total time the doctor has to stay. This problem is worth 2 points in terms of Effort.

b) Add a schedule to the patient arrival table in the simulation “HW_7_06.spfx” where (i) 2 patients are

scheduled every 20 minutes, (ii) another schedule where 3 patients are scheduled every 20 minutes and (iii) another schedule where 1 patient is scheduled every 9 minutes. Add a reference property “ArrivalTimeProperty” to the experiment and run 4 scenarios, the first one using the schedule under question (a) and the other three scenarios using the three scheduling methods (i), (ii) and (iii) above. Run the Experiment for 500 Replications. This problem is worth 2 point in terms of Effort.

c) What are your conclusions based on the analysis result under b? This problem is worth 1 point in terms of Effort.

Homework 2: HW_7_07 in the book a) Download the simulation “Model 7_2.spfx” and add a “Severe_to_Urgent” Patient to the “PatienData”

Table. Save the file as “HW_7_07.spfx”. Add a “Real” Column called “HW_7_07_MIX” and set the percentages to the percentages provided in Homework 7-07 from the book. Add to the Sequence Column the info for “Severe_To_Urgent” patients in the “Treatment_Table” while setting the treatment time distributions of the “Severe_To_Urgent” patients in the Trauma and Treatment Rooms equal to those of the “Urgent” patients. This problem is worth 1 points in terms of Effort.

b) Add reference property “Patient_Mix” to the Experiment of “Homewor_7_07.spfx” and add a Scenario to the experiment called “HW_7_07_Mix”, change the Patient Mix to that of HW_7_07. Add a Response Variable for the W (Time in System) and the Througput (Number of Patients server per hour) and rerun the experiment for 100 replications. Save the simulation model as “HW_7_07.spfx”. This problem is worth 1 point in terms of Effort.

c) Copy the workbook “Steady State Calculation Model 7_2.xlsx” and name it workbook “Steady State Calculation HW 7_07.xlsx . In this new workbook copy the worksheet “Model 7-2” and rename this sheet “HW_7_07”. Modify the worksheet HW_7_07 by setting the patient mix percentages to the percentages in HW_7_07 at each of the servers “SIGNIN”, “REGISTRATION”, ‘EXAM ROOM”, TRAUMA ROOM” and “TREATMENT ROOM and re-evaluate the Steady State Results for their utilizations. This problem is worth 1 point in terms of Effort.

d) Compare the steady results for the new patient mix in the worksheet “HW_7_07” to the scenario results in SIMIO using SMORE plots and also compare the results using the HW_7_07 patient mix to the original patient mix of Model 7-2. What are your conclusions? This problem is worth 1 point in terms of Effort.