Objective:
To study the correlation between the average wait time for DOB customers and the leave time of front line workers.
Predict the increase in staffing during busy months (i.e. summer) required to maintain a wait time of ½ hour.
Average wait and total leave steadily increases throughout the year and peaks in June and July:
Data:
-
52 weeks of average wait time from QMATIC.
-
Leave time for each worker from City Time.
-
Data aggregated to the unit level (work group).
-
Each group categorized according to job function - Application processing, certificate of occupancy, records.
Methods:
Correlation analysis, linear regression
R, Python, Teableau
Correlation between average wait time and percent hours of leave per group:
Regression analysis is used to predict the average wait time with increased leave time.
More specifically, when leave increases we want to know the increase in the number of workers required to maintain an average wait time at or below ½ hour.
The dependent variable in our analysis is the average wait time and the independent variable is average hours of leave.
We focus on application processing only (low correlation for records and certificate of occupancy)
Regression results shows that percent leave must be kept to 2.5 hours a week for an average wait time of 30 minutes:
