Staffing Model

Scope

With hundreds of employees in each region, there is constant movement from internal transfers between locations, new hires, turnover, knowing the timing of each is important, start dates for new employees, and most importantly understanding what the ratios are for each discipline, how many people we have in those roles, are we currently understaffed or overstaffed in any each role at each location within a region.

Problem

The company did not possess any staffing software and regions had several hundred employees to keep track of.

Solution

The above tool allowed us to take our established staffing ratios and play them out in real time against current census. It also allowed for us to forecast what additional staffing increases or decreases would look like simply by changing a projected census per service line per location. It allowed us to visually see how many employees we had in each role, number of incoming employees per role, current open positions, tracking of internal transfers, and would show how many employees we were over staffed/under staffed per the established ratios.

Results

Effectively and efficiently ensured that each role was staffed appropriately according to staffing ratios. This efficiency resulted in regions staying within base salary budgets. Also allowed for forecasting staffing needs for de novo projects.