Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments

image

2. Use Excel to simulate (Monte Carlo simulation) the below stated Hospital waiting time problem. A doctor schedules all his patients for 30-minute appointments in his hospital. Some of the patients take more or less than 30 minutes depending on the type of patient's health issue. The following summary shows the various types of health issues, their probabilities and time actually needed to complete the check up: Type of health issue (A-E) Time Required for check up Probability of patients' health issue type A 40 0.40 B 0.15 0.20 0.10 0.15 D E 15 25 60 30 Simulate the hospital for five hours and determine the average waiting time for the patients. Assume that all the patients show up at the hospital at exactly their scheduled arrival time starting at 7.00 a.m till 11:30 am. For patient arrival, use random numbers with a uniform distribution. Run ten or more experiments to estimate the average waiting time of hospital patients, and briefly comment on the efficiency of hospital operations given the waiting time.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Management Science A Modeling And Cases Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

5th Edition

978-0077825560, 78024064, 9780077498948, 007782556X, 77498941, 978-0078024061

More Books

Students also viewed these Mathematics questions

Question

What is the most common problem to avoid during interviewing?

Answered: 1 week ago