Here's how I balance the number of days:

- Record the days worked in the previous year
- Record the wait times in the previous year
- Look up the organic growth (in our case the change in referrals but it could be total number of active patients
- Create a ratio of days between each of the offices (e.g. 5/2/2/1). The same ratio could be used between blocks of time for block booking in a single office
- Create a formula for the scheduler to use.

As the scheduler enters the actual days, Excel counts them and summarizes the number of days per office. A second formula then applies the ratio and creates a 'target' number of days to work.

For instance the total number of days that providers choose to work may be 200 which the scheduler distributes as 80/50/50/20. But if the ratio of 5/2/2/1 is applied to the total number of days (200) the ratio should be 100/40/40/10.

We do this calculation once when we create the schedule for the next year then again mid-year to balance the days a second time.

## No comments:

Post a Comment