Exam Room Analysis

So now I'm playing with the data from those reports.

I hope to have visit (appointment) percentages equal room assignment percentages. In other words, if a clinic is conducting half of the total appointments in a day, then they should be assigned half of the total rooms. Something like that.

So far, the historic room assignments and the current volumes come pretty close to hitting this mark. This is heartening news.

I've discovered another challenge: a few of our clinics run into the evening. Since they start in the afternoon, they can't be entirely removed, but appointments starting at 4:30pm and 5pm aren't really a concern. At this point, the numbers of these are so small that it's not something I'm worried about. Room allocation is not a problem at 5:30 in the evening, just as it isn't a problem at 8:00 in the morning.