RRBCs (N=6) in June of 2023 recorded their time spent completing a number of predetermined tasks daily for a total of 10 buisness days. The goal of this study was to gain a deeper understanding of the time required to participate in meetings, complete administrative tasks, and serve clients. In addition to the raw number of hours, RRBCs recorded the number of times the completed the task within a week, allowing us to determine the average hours necessary to serve our clients clinically.


Total hours recorded is the combination of hours recorded by each WC over the 10 day period. Hours of PTO is the number of hours of reported paid time off per WC. Adjusted Total Hours is the sum total of their recorded hours and PTO. Average Weekly Hours is calculated by taking the Adjusted Total Hours and dividing it by “2”. Proportion of HRC is reported in percentages, and was calculated by dividing the Number of HRCs by the Caseload.



Graphical Summary of Time Expendature






The above descriptive statistics were determined through a series of calculations in R. Data was binned into four main categories: Meetings, Administrative Tasks, Client Specific Tasks, and Preparatory Tasks. Within these main categories were a series of subcategories that were predetermined tasks that are expected to occur within a typical week.

“Average Total Hours” per day was calculated by taking the sum of all hours within a subcategory for each RRBC over the 10 day period, and calculating the average among the RRBC

“Average Weekly Hours” divides the “Average Total Hours” by 2, to estimate weekly time investment.

“Total Number of Events” is the total number of times that event occured over the 10 day assessment period, averaged across RRBCs

The “Hours per Event” was calculated by dividing the “Average Total Hours” over the 10 day period by the “Total Number of Events” per 10 day period.




Summary Data: Interactive Table




The data table below includes all data prior to summary statistics. Each WC name was removed and replaced with an alphanumeric identifier. This data is searchable and includes multi-level filtering to easily see the variance between WCs.




Complete June Data: Interactive Table

Comparison between time reported in March and the time reported in June.

This chart shows the total reported time spent within each category in March and June averaged across wellness coordinators. This can be used to make general conclusions, but note that categories were adjusted slightly between the two data collections.

comp.pl

Complete Time Series Data: Interactive Table

Change in Hours per RRBC from March to June

These graphs show the change in weekly hours logged per RRBC. Plot A shows the change in raw hours, while plot B shows the change prepresented by a percentage of change (ex. if total hours increased by 3 hours in June, this is calculated by taking the 3 hours of change divided by the total hours reported in March and multipled by 100 to convert the proportion to percentage). Plot B accounts for the variability per RRBC in total hours.