Skip to main content
All CollectionsReference GuidesQuick ReferenceReport References
Demand Supply Response Key Indicators Report QRG - Capacity IQ® Transport
Demand Supply Response Key Indicators Report QRG - Capacity IQ® Transport
William Pelino avatar
Written by William Pelino
Updated over 5 months ago

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.

image-20240422-173713.png

Output

  • Choose the format of the report data. Options include Adobe, Excel, or Excel Unformatted.

image-20240422-174225.png

Run Report

  • Click Run Report once all fields are populated.

image-20240410-174440.png

Analyzing The Demand, Supply, Response, Key Indicators Report

image-20240424-180743.png

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.


Did this answer your question?