MTI Melton Technologies - Fleet Management Solutions 800-888-1246


Trusted Partner for 25 Years
HomeAbout UsProductsSupportTrainingNewsPartnersContact Us
Horizon Services


Horizon Execview: Definable measurements for real-time reporting

Company Analysis
Monthly Revenue Goal User-defined monthly revenue goal. Use this to give your company a target goal to aim for every month.
Total Monthly Revenue Total revenue processed in the current month.
Line Haul Revenue This Month The total revenue that can be attributed to billing codes specified as Line Haul billing codes.
Fuel Surcharge Revenue This Month The total revenue that can be attributed to billing codes specified as Fuel Surcharge billing codes.
Accessorial Revenue This Month The total revenue that can be attributed to billing codes specified as Accessorial billing codes.
Avg Length of Haul The average length in miles of each shipment in the current month.
Revenue Per Mile This Month Revenue per total miles traveled this month (loaded and empty).
Total Loaded Miles This Month The total number of miles (both Empty and Loaded) for the current month.
Total Deadhead Miles This Month The total number of empty miles traveled for the current month. Goal: Keep this number as low as possible compared to previous months.
% of Empty Miles The percentage of empty miles from the total miles traveled in the current month. Goal: While it may be unrealistic to aim for 0%, single digit percentages are a good target.
Company Fleet % of Revenue This Month The % of revenue for the current month where the driver was active and not leased
O/O % of Revenue This Month The % of revenue for the current month for owner-operators.
Brokerage % of Revenue This Month The % of revenue for the current month where the load was completed by a carrier.
Line Haul % of Total Revenue The percentage of total revenue that can be attributed to billing codes specified as Line Haul billing codes.
Surcharge % of Total Revenue The percentage of total revenue that can be attributed to billing codes specified as Surcharge billing codes.
Accessorial % of Total Revenue The percentage of total revenue that can be attributed to billing codes specified as Accessorial billing codes.
Total Monthly Revenue Last Month Total monthly revenue processed in the previous month.
Line Haul Revenue Last Month The total revenue that can be attributed to billing codes specified as Line Haul billing codes for the previous month
Fuel Surcharge Revenue Last Month The total revenue that can be attributed to billing codes specified as Surcharge billing codes for the previous month
Accessorial Revenue Last Month The total revenue that can be attributed to billing codes specified as Accessorial billing codes for the previous month
Company Fleet % of Revenue Last Month The % of revenue for the previous month where the driver was active and not leased
O/O % of Revenue Last Month The % of revenue for the previous month where the driver was active and leased
Brokerage % of Revenue Last Month The % of revenue for the previous month where the load was completed by a carrier.
Freight % of Total Revenue Last Month The % of revenue for the previous month that is related to Line Haul charges
Surcharge % of Total Revenue Last Month The % of revenue for the previous month that is related to surcharges
Accessorial % of Total Revenue Last Month The % of revenue for the previous month that is related to accessorial charges
Delivered Shipments This Month Total number of shipments delivered in the current month.
Refused Shipments This Month Total number of shipments that were refused in the current month.
# of Accidents This Month Number of accidents logged in the current month.
# of Claims This Month Number of claims logged in the current month.
Total # of Drivers Hired This Year Total number of drivers hired this year.
Total # of Drivers Terminated This Year Number of drivers terminated in the current year.
Total Expenses This Month Total expenses logged in Settlements for the current month.
Driver Turnover % This Year Total number of drivers fired this year divided by total number of active drivers
Total Working Days This Month Total number of working (week) days in the current month.
Working Days Last Month Number of week days for the previous month
Working Days Gone By This Month Number of week days in current month already gone by
Daily Operations
Shipments still to be delivered today: The number of shipments marked as not delivered with a delivery date of today.
Shipments still to be delivered from yesterday: Number of shipments not delivered where the delivery date is older than a particular period.
# of Late Shipments The number of shipments not delivered that are past their scheduled delivery date.
Shipments Currently Assigned The number of shipments currently assigned to a truck but not delivered.
Shipments Currently Unassigned
Trucks Assigned to Loads The number of active trucks currently assigned to a load.
Trucks Not Assigned to Loads The number of active trucks currently not assigned to a load.
Drivers Assigned to Loads The number of active drivers currently assigned to a load.
Drivers Not Assigned to Loads The number of active drivers currently not assigned to a load.
Shipments Booked Today
# of Accidents Today
# of Claims Today
# of Brokered Loads Currently Assigned The number of loads currently assigned to a carrier.
# of Drivers With no recent Activity Number of active drivers who have not logged a checkcall in 4 days.
# of Active Drivers Total # of drivers marked active.
# of Active Trucks Total # of tractors marked active.
Driver Analysis
Total # of Active Drivers This Month
Number of Company Drivers This Month
Number of O/O Used This Month
Total # of Single Drivers This Month Total number of drivers who worked alone this month.
Total # of Team Drivers This Month Total number of drivers who worked as a team this month.
Total Revenue For Company Drivers
Total Revenue For O/O Drivers
Number of Idle Company Drivers This Month
Number of Loads Per Owner/Operator This Month
Number of Miles Per Company Driver This Month
Number of Loads Per Company Driver This Month
Total Miles For Company Drivers Total miles traveled by company drivers this month.
Total Fuel Costs per driver this month -Settlements
Avg Rev/Mile for Company Driver
Avg Rev/Mile for O/O Driver
Total # of Drivers Hired This Month
Total # of Drivers Terminated This Month
Average Company Driver Wages This Month
Avg Loaded Miles Per Company Driver
Avg Empty Miles Per Company Driver
Leased Driver Wages per Truck This Month
Avg Loaded Miles Per Owner/Operator
Avg Empty Miles Per Owner/Operator
Average Owner/Operator Wages This Month
Outstanding Driver Pay
Lane Analysis
Dest State With Most Revenue This Month
Destination City With Most Revenue This Month
Destination Zip Group With Most Revenue This Month
Destination City Revenue
Origin State With Most Revenue This Month
Origin City With Most Revenue This Month
Origin Zip Group With Most Revenue This Month
Most Profitable State Run This Month
Most Profitable State Run This Month
Most Profitable Zip Group Run This Month
Customer With Most Loads This Month
Customer With Most Revenue This Month
Mileage Analysis
Total Revenue Generating Miles The total number of loaded miles for the current month.
Total Deadhead Miles This Month The total number of empty miles (typically used for deadheading) for the current month.
% of Empty Miles The percentage of empty miles over total miles
Total Loaded Miles Last Month Total loaded miles from the previous month.
Total Revenue Generating Miles Last Month Total loaded miles from the previous month.
Total Deadhead Miles Last Month Total empty miles from the previous month.
% of Empty Miles Last Month Percentage of empty miles from the previous month.
Pay Carrier Analysis
Outstanding Carrier Pay
Revenue Analysis
Target Revenue Per Mile A target number entered by the user for comparison and goal purposes.
Operating Revenue This Month The sum of total charges for all processed invoices in the current month.
Operating Revenue Per Truck This Month The average total charges for all processed invoices based on individual trucks assigned to those invoices in the current month.
Operating Revenue Per Traveled Mile This Month Total revenue divided by total traveled mile in the current month.
Operating Revenue Per Driver This Month Total revenue divided by number of drivers for current month.
Total # of Trucks Running This Month The total number of trucks who logged checkcalls during the current month.
Revenue/Truck/Day This Month The total revenue divided by number of trucks divided by number of working days for the current month
Total # of Trucks Running Last Month Total number of trucks who logged checkcalls in the previous month.
Total # of Active Drivers Last Month
Revenue/Driver/Day This Month
Total Outstanding Receivables:
Total % Current The percentage of invoices that are currently less than 45 days old
% Receivables Over 45 The percentage of invoices that are currently older than 45 days.
Cash Posted Today:
# of Checks Posted Today: Number of checks that were posted for the current day.
Operating Revenue Per Calculated Mile This Month The total charges for all processed invoices divided by the calculated miles (in the invoice header) for those invoices in the current month.
Operating Revenue Per Calculated Mile Last Month
Operating Revenue Per Driver Last Month
# of Invoices Billed Today:
# of Invoices Billed Yesterday
Revenue Billed Today
Revenue Billed Yesterday
This Weeks Revenue Total revenue processed this week
Last Weeks Revenue Total revenue processed last week
Average Daily Revenue This Month
Average Daily Revenue Last Month
Unprocessed Pros Older Than 14 days Number of unprocessed pros where the load date is earlier than 14 days ago.
Operating Revenue Last Month
Operating Revenue Per Truck Last Month
Revenue/Truck/Day Last Month
Revenue/Driver/Day Last Month
Trailer Analysis
Number of Active Trailers This Month
Number of Rental Trailers This Month
Number of Trailers Last Month
Number of Rental Trailers Last Month
Number of Miles Per Trailer This Month
Number of Miles Per Trailer Last Month
Number of Loads Per Trailer
Company Driver Wages per Trailer This Month Total pay for the current month for Company Drivers (not leased)
Leased Driver Wages per Trailer This Month Total pay for the current month for Leased Drivers.
Total Maintenance Per Trailer This Month Average maintenance cost for trailers for the current month.
Avg Loaded Miles Per Trailer This Month
Avg Loaded Miles Per Trailer Last Month
Avg Empty Miles Per Trailer This Month
Avg Empty Miles Per Trailer Last Month
Truck Analysis
Number of Trucks This Month The total number of trucks who logged checkcalls during the current month.
Number of Trucks Last Month Total number of trucks who logged checkcalls in the previous month.
Number of Miles Per Truck This Month The average number of total miles based on the total number of trucks who logged miles in the current month.
Number of Miles Per Truck Last Month
Number of Loads Per Truck The average number of shipments per truck based on the total number of trucks who logged miles in the current month.
Number of Idle Trucks This Month Number of active trucks that did not log checkcalls in the current month.
Avg Loaded Miles Per Truck This Month The average number of loaded miles based on the total number of trucks who logged miles in the current month.
Avg Loaded Miles Per Truck Last Month
Avg Empty Miles Per Truck This Month The average number of empty miles based on the total number of trucks who logged miles in the current month.
Avg Empty Miles Per Truck Last Month
Total Fuel Costs per truck this month -Settlements Total expenses marked with the FU code for the current month.
Company Driver Wages per Truck This Month The average driver pay for non-leased drivers for the current month.
Leased Driver Wages per Truck This Month The average driver pay for leased drivers for the current month.
Avg Idle % Per Truck Last Month
Total Maintenance Per Truck This Month Average maintenance charges per truck for the current month

Return to ExecView



home | about us | products | support | training | news | partners | contact us
 
 

For assistance in navigating our website, please visit our site map.
©2006-2010 Melton Technologies. All rights reserved. Click here to view our privacy policy