Funding Source Productivity (FLEX) Report

The Funding Source Productivity report provides information such as customer counts, trip counts, and service vs. revenue hours and distance by funding source. The report also provides average trip lengths, distances, and passengers per trip.

Table 1. Funding Source Productivity (FLEX) Report Parameters
Parameter Description
Type Schedule type.
Date/Weekday Specifies whether the report is for specific dates or days of the week. Choose the option appropriate for the schedule type:
  • Date. Specify a From Date and To Date for the report (for example, 10/10/19 to 10/15/19).
  • Weekday. Specify a From Day and To Day for the report (for example, Monday to Friday).
From Route First route in the report.
To Route Last route in the report.
Max Dis/Rte Maximum distance for a single route. If the total distance of a route is greater than this value, it is considered an error and set to 0.
Service Select any of the following to remove from service hours and distances:
  • Exclude Lunches
  • Exclude Breaks
  • Exclude Auto Breaks
  • Exclude User Defined Breaks
  • Exclude Out of Service
  • Exclude Refuel
  • Exclude Depo To 1st Pick
  • Exclude Last Drop To Depo
  • Exclude Driver Relief
  • Exclude Driver Assist
  • Exclude Driver Return
Group By Date If selected, data is grouped by date.
Distance If Calculate is selected, distances are based on PASS calculated distances. If Full Odometers is selected, actual odometer readings are used. The Full Odometers option is not recommended unless you have mobile data to ensure complete odometer readings. If Partial Odometers is selected, the report uses odometer readings when they are available and calculated distances when odometer readings are not available.
Sort Time Sort order used in the report:
  • Est Time. Estimated time.
  • Est Time Lock. Est Time Lock is the Est Time (if any) that is manually typed into the Schedule Editor. The Schedule Editor tries to honor this time but cannot always do so. As a result, Est Time and Est Time Lock values can differ.
  • Actual Arrive Time. Actual arrival time.
  • Actual Depart Time. Actual departure time.
Note: The Sort Time should be set to the Est Time or the time that is entered in the Schedule Editor. For example, do not sort on actual arrive time if you have not entered these times.
Providers If All is selected, records for all providers appear in the report. If All is cleared, select individual providers from the list. The options available to you depend on provider security.

The Funding Source Productivity (FLEX) report.