Analysis of Outpatient Waiting Times for Penalty Points Accrued by Hospital

Enterprise Risk Modelling

Table of Contents
Project Description..............................................................................................................................1
Question 1............................................................................................................................................1
Question 2............................................................................................................................................2
Question 3............................................................................................................................................4
References............................................................................................................................................6

Project Description
This project is analysis the outpatient waiting times for provided quantitative data.
The provided data is based on the patients because basically patients are come to the local
hospital accidents and emergency department or treatment. But, the patients are wait until a
doctor or nurse is available to the treat them. Basically, the government has set the maximum
length of waiting time for each patient must been have treated. The maximum waiting time is
12o minutes. So, if patients are wait longer than this maximum, it will result in the hospital
being awarded penalty points at the rate of 10 points per minute over the maximum. So, this
project is needs to determine the total number of penalty points the hospital accrues over the
year by using the Risk solver on Excel. These are will be discussed and analysed in detail.
Question 1
First, we are determine the expected minimu, maximum and mean number of the
penalty points. It is represented as below.