Analysis of Outpatient Waiting Times using Risk Solver on Excel

ENTERPRISE RISK AND
MODELLING

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.