Data
One-year of the procedures scheduled in the OPS suite was obtained. The fields provided with each data record are: made date, scheduled date, scheduled time, appointment type, and room booked. There are 21 different appointment types that can be scheduled in OPS with varied lengths. The shortest appointment length is 15 minutes where the longest appointment length is 120 minutes. Therefore, the day in the calendar is divided in 15 minute time slots. The difference between the made and scheduled dates for each appointment type is studied and modeled in a statistical distribution for each day in the week. The statistical distributions are used to model the preference in how many days out the appointment is scheduled from the made date. In addition, the scheduled time is also studied to mimic the preferred time to book each type of the procedures. Finally, there are some rules for which each type of the procedures is preferred to be scheduled in the available rooms where some cannot be scheduled except in specific rooms due to space constraints.
Modeling in Simio
A snapshot of the model is shown in the figure below. The simulation clock starts running and each day presents a mix of requested appointments out of 21 possible procedures based on the historical data. A “Dummy Call” as an entity is generated each day of the week that reads different linked tables to scan the preferred scheduled day and time.
Simio would search for an available spot for each generated request in the available rooms based on the preferred day and time. A fractional example of an open calendar of a room modeled as a table in Simio is shown below.
The search algorithm preferences and rules are modeled as processes in Simio. The processes will try to find an available spot following the predefined sets of preferences and rules. There are 3 sinks that will destroy the generated requests after searching for an available spot:
- Scheduled: if the search algorithm finds a spot according to the preferences and rules. The cells booked in the table (calendar) for the scheduled appointments will change from zero to one.
- Blocked: if the search algorithm fails to find a spot. The objective is to keep the number of requests being destroyed in this sink to the minimum.
- NextYear: if the search happens to find the available spot in the following year again according to the preferences and rules.