Statistics homework help

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.