Demand, Supply, Response, Key Indicators Report
The Demand, Supply, Response, Key Indicator report shows employee performance in conjunction with request volume. This report can assist Transport managers in making decisions regarding establishing performance criteria within their department. Unlike the more detailed Employee Performance report, this report will provide a quick snapshot of overall transporter performance if you are not looking for a specific transporter’s metrics.
Best Practice Metrics Captured in the Demand, Supply, Response, Key Indicators Report
Metric | Best Practice Goal |
Transport Response Time Pending to In-Progress | < 15 Minutes |
Transport Job Time Pending to Complete | < 30 Minutes |
% Of Transport Dispatches Cancelled or Rescheduled After Dispatch | < 10% |
Generating The Demand, Supply, Response, Key Indicators Report
Database - Where Your Facility's Data Is Stored
Production - Data that is stored in the production database (this is your current data).
Use when live up-to-the-minute data is needed.
Contains the data from the current time and for the past number of days as defined in Archive Management. This is typically 7 days but may range between 1 and 30 days. If you do not know the number of days, your TeleTracking System Administrator should be able to assist.
Archive - Data that is stored in the archive database (this is your older data).
Does not capture data for the current day.
Users can access reports as far back as the go-live date.
Campus
Campus Drop-Down
Defaults to your campus. The only exception is if you have access to multiple campuses. If you have membership in multiple campuses (for example, ABC Children's Hospital and ABC Women's Hospital), then in the Campus list, select the campus for which you wish to generate a report.
Date & Time
Date Time Range
Click on the Calendar Icon to select the needed dates.
The system defaults to the entire day however, you may want to isolate specific shifts if you are trying to investigate issues with not meeting metrics.
Output
Choose the format of the report data. Options include Adobe, Excel, or Excel Unformatted.
Run Report
Click Run Report once all fields are populated.
Analyzing The Demand, Supply, Response, Key Indicators Report
Above is an example of Demand, Supply, Response, and Key Indicators Report. We will now break down the information to learn how to read the data. The report is organized into Employee Dispatch Statistics and Trip Request Statistics. The Best Practice Metrics are denoted with an *.
Employee Dispatch Statistics
Total Number of Dispatches - Total number of times employees entered any Dispatched status for the selected date and time range.
# Dispatches Cancelled/Rescheduled - The total number of employees who were in any Dispatched status for jobs that were canceled or rescheduled during the selected date and time range.
Cancel/Reschedule % - Calculation: # Dispatches Canceled or Rescheduled/Total Number of Dispatches.
Average Number of Employees - Average number of employees logged in per day for date and time range.
Total Logged-in Hours - Total number of hours employees were signed in for the date and time range.
Productive Hours - Total number of hours employees were in any Dispatched or In Progress status for the date and time range.
Productive % - Calculation: Productive Hours / Total Logged in Hours.
Available Hours - Total time employees were in an Available status for date and time range.
Available % - Calculation: Avail Hours / Total Logged in Hours.
Break/Lunch Hours - Total time in hours employees were in Break, Unscheduled Break, or Lunch statuses during the selected date and time range.
Trip Request Statistics
Number of Valid Requests Completed - All jobs completed within the date and time range, excluding Completed and In Progress outliers.
# Requests Canceled/Rescheduled - Total number of transport job requests that were in a Cancelled or Rescheduled status during the selected date and time.
*Cancel/Reschedule % - Calculation: Number of Requests Cancelled or Rescheduled / Total Number of Valid Requests Completed.
Note: Best Practice Metric for % of Transport Dispatches Cancelled or Rescheduled After Dispatched.
Average Minutes to Dispatch - The average time in minutes from the start of Pending status to the start of Dispatched status for all transport jobs within the date and time range, excluding Completed and In Progress outliers.
*Average Response In Minutes - The average time in minutes from the start of Pending status to the start of In Progress status for all transport jobs within the date and time range, excluding Completed and In Progress outliers.
Note: Best Practice Metric for Transport Response Time Pending to In-Progress.
Standard Deviation (Average Response) - The standard deviation of Pending to In Progress average for all transport jobs within the date and time range, excluding Completed and In Progress outliers.
*Average Completed in Minutes - The average time in minutes from the start of Pending status to the start of Completed status for all transport jobs within the date and time range, excluding Completed and In Progress outliers and rescheduled and canceled transport jobs.
Note: Best Practice Metric for Transport Job Time Pending to Complete.
Standard Deviation (Average Completed) - The standard deviation of Pending-to-Completed status for all transport jobs within the date and time range, excluding Completed and In Progress outliers and rescheduled and canceled transport jobs.