FINANCIAL METRICS

FINANCIAL                OPERATIONAL                    SAFETY

 

All metrics calculated by inGauge are based on the monthly data survey provided by inGauge subscribers and TCA Best Practice Group Members. The current data survey for inGauge subscribers, is comprised of up to approximately 80 monthly data points (depending on their respective operating attributes). Data for Best Practice Group members is automatically imported into inGauge on a monthly basis.

 

To ensure data consistency and integrity, an hourly exception report is generated, and highlights any company specific metrics that fall outside a ‘normal range’ for that specific metric. These ranges can vary greatly depending on the operating model utilizied by the inGauge subscriber (for example: Dryvan versus Tanker). The normal ranges are adjusted regularly based on feedback and actual results from our subscribers.

 

Monthly Revenue per Employee (Total)

Description: This metric calculates the total amount of Linehaul & Accessorial (Company and Owner Operator Fleet) Revenue generated by the motor carrier divided by the total number of active Drivers and Non-Drivers (Company and Owner Operator Fleet). The acceptable range for this metric, for exception reporting purposes, is between $6,000 and $45,000.
Formula: (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)/(Driver Count_Total + Non-Drivers_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID #22 – Driver Count (Total), ID #34 Non-Drivers (No Shop) (Total)

 

Operating Ratio

Description: This metric calculates a motor carrier’s Operating Ratio combining both the revenue and operating profits of the Company and Owner Operator fleets. The acceptable range for this metric, for exception reporting purposes, is between 120% and 75%.
Formula: (Freight Revenue Linehaul_Total + Accessorial Revenue_Total – Operating Profit_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 14 – Operating Profit (Total)

 

Revenue per Truck per Week

Description: This metric calculates the average total revenue (Company and Owner Operator Fleet), for each active truck, on a weekly basis. The acceptable range for this metric, for exception reporting purposes, is between $2000 and $7500. Please note: Currently, for the denominator in this formula, we use 4.348 – the average # of weeks in a month over the course of a year. In October, we will be changing this to reflect the actual number of fiscal weeks in the reported month for each company.
Formula: ((Freight Revenue Linehaul_Total + Accessorial Revenue_Total) / (Truck Count_Total))/ 4.348
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 21 Truck Count (Total)

Insurance Expense (% of Revenue)

Description: This metric expresses total insurance expense as a percentage of revenue (Company and Owner Operator Fleet). The acceptable range for this metric, for exception reporting purposes, is between 12% and 0%.
Formula: ((Insurance Expense_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 13 Insurance Expense (Total)


Fuel Expense (% of Revenue)

Description: This metric calculates the total net fuel expense as a percentage of net revenue. As a reminder, inGauge subscribers report ‘net’ Fuel Expense, which is calculated as Gross Fuel Expense minus Fuel Surcharge Revenue. For this metric, we express this expense as a percentage of net revenue (Linehaul + Accessorial, not including Fuel Surcharge). This metric provides subscribers with the ability to measure their optimization of their fuel surcharge program versus their peers. The acceptable range for this metric, for exception reporting purposes, is between -5.00% and 21.00%. Please note, if a subscriber’s Fuel Surcharge Revenue exceeds their gross fuel expense for the month, a negative percentage is displayed. Although this happens infrequently, we have seen between 5 and 22 subscribers report a negative percentage in a given month.
Formula: (Fuel Expense_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 10 Fuel Expense (Total)


Total Personnel Expense (% of Revenue)

Description: This metric expresses Total Personnel Expense, as a percentage of revenue (Company and Owner Operator Fleet). Total personnel expense includes Driver Salaries, Wages and Benefits, as well a Non-Driver Salaries, Wages and Benefits, both of which are contained in the data point: Salaries, Wages & Benefits (Total). The acceptable range for this metric, for exception reporting purposes, is between 21% and 63%.
Formula: (Salaries, Waged & Benefits_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 3 Salaries, Wages & Benefits (Total)


Monthly Revenue per Non-Driver

Description: This metric calculates the average amount of monthly revenue (Company and Owner Operator Fleet) per non-driver (not including shop employees) each month. The acceptable range for this metric, for exception reporting purposes, is between $15,000 and $200,000.
Formula: (Freight Revenue Linehaul_Total + Accessorial Revenue_Total) / (Non-Drivers_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 34 – Non-Drivers (No Shop) (Total)


Fuel Expense per Mile ($)

Description: This metric calculates the total net fuel expense on a per mile basis. As a reminder, inGauge subscribers report ‘net’ Fuel Expense, which is calculated as Gross Fuel Expense minus Fuel Surcharge Revenue. The acceptable range for this metric, for exception reporting purposes, is between $0.50 and -$0.15. Please note, if a subscriber’s Fuel Surcharge Revenue exceeds their gross fuel expense for the month, a negative value will be displayed. Although this happens infrequently, we have seen between 5 and 22 subscribers report a negative value in a given month.
Formula: (Fuel Expense_Total) / (Total Miles Driven_Total)
Data Points Utilized: ID # 10 Fuel Expense (Total), ID # 20 Total Miles Driven (Total)


Insurance Expense per Mile ($)

Description: This metric expresses total insurance expense expressed on a per mile basis (Company and Owner Operator Fleet). The acceptable range for this metric, for exception reporting purposes, is between -$0.05 – $0.30.
Formula: ((Insurance Expense_Total) / (Total Miles Driven_Total)
Data Points Utilized: ID # 13 Insurance Expense (Total), ID # 20 Total Miles Driven (Total)


Personnel Expense per Mile ($)

Description: This metric expresses Total Personnel Expense, on a per mile basis (Company and Owner Operator Fleet). Total personnel expense includes Driver Salaries, Wages and Benefits, as well a Non-Driver Salaries, Wages and Benefits, both of which are contained in the data point: Salaries, Wages & Benefits (Total). The acceptable range for this metric, for exception reporting purposes, is between $1.50 and $0.25.
Formula: (Salaries, Waged & Benefits_Total) / (Total Miles Driven_Total)
Data Points Utilized: ID # 3 Salaries, Wages & Benefits (Total), ID # 20 Total Miles Driven (Total)


A/R Days Sales Outstanding

Description: Days Sales Outstanding (DSO) is a measure of the average number of days that a company takes to collect revenue after a sale has been made. The acceptable range for this metric, for exception reporting purposes, is between 64 and 20 Days.
Formula: (Accounts Receivable_Trade_Total) / ((Freight Revenue Linehaul_Total + Accessorial Revenue_Total)/30)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 37 Accounts Receivable (Trade) (Total)


Amort./Dep. (% of Revenue)

Description: This metric expresses the total amount of Amoritization, Depreciation, Lease, Rent and Interest Expense recorded for the month for all company owned equipment as a percentage of total revenue. The acceptable range for this metric, for exception reporting purposes, is between 35% (Example: Full Service Leases) and 3.00%.
Formula: (Dep/Amort/Rent/Lease/Interest_Total)/(Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 39 – Dep/Amort/Rent/Lease/Interest (Total)


Debt to Shareholder Equity

Description: This metric expresses the total amount of non-real estate debt on a company’s balance sheet divided by the total amount of shareholder equity as of end of month. The acceptable range for this metric, for exception reporting purposes, is between 4 and 0.25.
Formula: (Total Liabilities) / (Total Assets – Total Liabilities)
Data Points Utilized: ID # 42 – Total Liabilities, ID # 43 – Total Assets


Maintenance Expense (% of Revenue)

Description: This metric expresses the total amount of Maintenance Expense (includes Parts, Shop Labor, Supplies, and Outside Vendor Expense) recorded for the month, as a percentage of revenue. The acceptable range for this metric, for exception reporting purposes, is between 25% and 2.00%.
Formula: (Maintenance Expense_Total)/(Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 45 – Maintenance Expense (Total)


Maintenance Expense per Mile ($)

Description: This metric expresses the total amount of Maintenance Expense (includes Parts, Shop Labor, Supplies, and Outside Vendor Expense) recorded for the month, on a per mile basis. The acceptable range for this metric, for exception reporting purposes, is between $0.50 and $0.02.
Formula: (Maintenance Expense_Total)/ (Total Miles Driven_Total)
Data Points Utilized: ID # 20 Total Miles Driven (Total), ID # 45 – Maintenance Expense (Total)


Variable Driving Expense (% of Revenue)

Description: This metric expresses the total amount of Variable Driving expenses (includes Layover, Scales, Lumper, Travel, Tolls, Fines etc) recorded for the month, as a percentage of revenue. The acceptable range for this metric, for exception reporting purposes, is between 10% and 1.00%.
Formula: (Variable Driving Expense_Total)/(Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 46 – Variable Driving Expenses (Total)


EBITDA (% of Revenue)

Description: This metric calculates Earnings before Interest, Taxes, Depreciation and Amortization, as a percentage of revenue. The acceptable range for this metric, for exception reporting purposes, is between -30.00% and 30.00%.
Formula: (EBITDA)/(Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 44 – EBITDA


Tire Expense per Mile (Trailers and CF Trucks)

Description: This metric expresses the total amount of Tire Expense per Mile attributable to all Company Fleet equipment (Trucks and Trailers)recorded for the month. The acceptable range for this metric, for exception reporting purposes, is between $0.21 and $0.03.
Formula: (Tire Expense_Company Fleet)/(Total Miles Driven_Company Fleet)
Data Points Utilized: ID # 25 – Total Miles Driven (Company Fleet), ID # 48 – Tire Expense (Company Fleet)


Operating Ratio (Brokerage)

Description: This metric calculates a motor carrier’s Operating Ratio related to a subscriber’s Brokerage operations. The acceptable range for this metric, for exception reporting purposes, is between 105% and 80%.
Formula: (Freight Revenue_Brokerage – Operating Profit_Brokerage) / (Freight Revenue_Brokerage)
Data Points Utilized: ID # 47 – Freight Revenue (Brokerage), ID # 49 Operating Profit (Brokerage)


Purchased Transportation (% of OO Revenue)

Description: This metric expresses total Purchased Transportation (not including OO share of Fuel Surcharge revenue), as a percentage of revenue (Owner Operator Fleet). The acceptable range for this metric, for exception reporting purposes, is between 50% and 91%.
Formula: (Purchased Transportation_OwnerOp) / (Freight Revenue Linehaul_OwnerOp + Accessorial Revenue_OwnerOp)
Data Points Utilized: ID #7 – Freight Revenue – Linehaul (Owner Op), ID # 8 – Accessorial Revenue (Owner Op), ID # 9 – Purchased Transportation (Owner Op)


Non-Driver Personnel Expense (% of Revenue)

Description: This metric expresses Non-Driver Personnel Expense, as a percentage of revenue (Company and Owner Operator Fleet). The acceptable range for this metric, for exception reporting purposes, is between 18% and 3.00%.
Formula: (Salaries, Waged & Benefits_Non-Driver_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 63 Salaries, Wages & Benefits – Non Driver (Total)


Personnel Expense – Company (% of Revenue)

Description: This metric expresses Company Fleet Personnel Expense, as a percentage of Company Fleet Revenue. Personnel expense includes Driver Salaries, Wages and Benefits, as well a Non-Driver Salaries, Wages and Benefits, both of which are contained in the data point: Salaries, Wages & Benefits (Company Fleet). The acceptable range for this metric, for exception reporting purposes, is between 21% and 63%.
Formula: (Salaries, Waged & Benefits_CompanyFleet) / (Freight Revenue Linehaul_CompanyFleet + Accessorial Revenue_CompanyFleet)
Data Points Utilized: ID #4 – Freight Revenue – Linehaul (Company Fleet), ID # 5 – Accessorial Revenue (Company Fleet), ID # 6 Salaries, Wages & Benefits (Company Fleet)


Operating Ratio (Company Fleet)

Description: This metric the Operating Ratio attributable to the subscriber’s Company Fleet.The acceptable range for this metric, for exception reporting purposes, is between 120% and 75%.
Formula: (Freight Revenue Linehaul_CompanyFleet + Accessorial Revenue_CompanyFleet – Operating Profit_CompanyFleet) / (Freight Revenue Linehaul_CompanyFleet + Accessorial Revenue_CompanyFleet)
Data Points Utilized: ID #4 – Freight Revenue – Linehaul (Company Fleet), ID # 5 – Accessorial Revenue (Company Fleet), ID # 16 – Operating Profit (Company Fleet)


Tire Expense ($) per CF Equipment Count

Description: This metric expresses the total amount of Tire Expense attributable per Company Fleet equipment count. The acceptable range for this metric, for exception reporting purposes, is between $600 and $54.
Formula: (Tire Expense_Company Fleet)/(Truck Count_CompanyFleet, TrailerCount_CompanyFleet)
Data Points Utilized: ID # 26 – Truck Count (Company Fleet), ID # 48 – Tire Expense (Company Fleet), ID # 54 – Trailer Count (Total)


Tire Expense per Mile – CF

Description: This metric expresses the total amount of Company Fleet Tire Expense per Company Fleet Total Miles. The acceptable range for this metric, for exception reporting purposes, is between $0.19 and $0.02.
Formula: (Tire Expense_Company Fleet)/(Total Miles Driven_Company Fleet)
Data Points Utilized: ID # 25 – Total Miles Driven (Company Fleet), ID # 48 – Tire Expense (Company Fleet)


Gross Profit (%) – CF & OO

Description: This metric calculates a motor carrier’s Gross Profit for both the Company and Owner Operator Fleet as a percentage of revenue. The acceptable range for this metric, for exception reporting purposes, is between 0% and 30%.
Formula: (Operating Profit_Total + Salaries, Wages & Benefits Non-Driver_Total + Fixed Overhead Expense_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 14 – Operating Profit (Total), ID # 62 Fixed Overhead Expense (Total), ID #63 Salaries, Wages & Benefits – Non Drivers (Total)


Safe Operating Ratio (O.R. + Ins. Exp.)

Description: This metric calculates and combines a motor carrier’s Operating Ratio with Insurance Expense as a percentage of revenue. This metric rewards both profitability and low insurance expense (which is strongly correlated to a safe fleet). The acceptable range for this metric, for exception reporting purposes, is between 120% and 85%.
Formula: (Freight Revenue Linehaul_Total + Accessorial Revenue_Total – Operating Profit_Total + Insurance Expense_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID #13 – Insurance Expense (Total), ID # 14 – Operating Profit (Total)


Insurance Expense (% of Gross Revenue CF & OO)

Description: This metric expresses total insurance expense as a percentage of gross revenue (Company and Owner Operator Fleet), including Fuel Surcharge Revenue. The acceptable range for this metric, for exception reporting purposes, is between 12% and 0%.
Formula: ((Insurance Expense_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total + FuelSurchargeRevenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 13 Insurance Expense (Total), ID # 150 Fuel Surcharge Revenue (Total)


Maintenance Expense (% of Gross Revenue – CF)

Description: This metric expresses the total amount of Maintenance Expense (includes Parts, Shop Labor, Supplies, and Outside Vendor Expense) recorded for the month, as a percentage of gross revenue, including Fuel Surcharge Revenue. The acceptable range for this metric, for exception reporting purposes, is between 25% and 2.00%.
Formula: (Maintenance Expense_Total)/(Freight Revenue Linehaul_Total + Accessorial Revenue_Total + FuelSurchargeRevenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 45 – Maintenance Expense (Total), ID # 150 Fuel Surcharge Revenue (Total)


Gross Revenue per Truck per Week (CF)

Description: This metric calculates the average gross revenue (Company Fleet), for each active truck, on a weekly basis. The acceptable range for this metric, for exception reporting purposes, is between $2900 and $10,000. Please note: Currently, for the denominator in this formula, we use 4.348 – the average # of weeks in a month over the course of a year. In October, we will be changing this to reflect the actual number of fiscal weeks in the reported month for each company.
Formula: ((Freight Revenue Linehaul_CF + Accessorial Revenue_CF + FuelSurchargeRevenue_CF) / (Truck Count_CF))/ 4.348
Data Points Utilized: ID #4 – Freight Revenue – Linehaul (Company Fleet), ID # 5 – Accessorial Revenue (Company Fleet), ID # 26 Truck Count (Company Fleet), ID # 199 Fuel Surcharge Revenue (Company Fleet)


Gross Revenue per Truck per Week (OO)

Description: This metric calculates the average gross revenue (Owner Operator Fleet), for each active truck, on a weekly basis. The acceptable range for this metric, for exception reporting purposes, is between $2900 and $10,000. Please note: Currently, for the denominator in this formula, we use 4.348 – the average # of weeks in a month over the course of a year. In October, we will be changing this to reflect the actual number of fiscal weeks in the reported month for each company.
Formula: ((Freight Revenue Linehaul_OO + Accessorial Revenue_OO + FuelSurchargeRevenue_OO) / (Truck Count_))))/ 4.348
Data Points Utilized: ID #7 – Freight Revenue – Linehaul (Owner Op), ID # 8 – Accessorial Revenue (Owner Op), ID # 33 Truck Count (Owner Op), ID # 248 Fuel Surcharge Revenue (Owner Op)


Personnel Expense – CF (% of Gross Revenue)

Description: This metric expresses Personnel Expense (Company Fleet), as a percentage of gross revenue (Company Fleet). Personnel expense includes Driver Salaries, Wages and Benefits, as well a Non-Driver Salaries, Wages and Benefits, both of which are contained in the data point: Salaries, Wages & Benefits (Company Fleet). The acceptable range for this metric, for exception reporting purposes, is between 21% and 63%.
Formula: (Salaries, Waged & Benefits_CF) / (Freight Revenue Linehaul_CF + Accessorial Revenue_CF + FuelSurchargeRevenue_CF)
Data Points Utilized: ID #4 – Freight Revenue – Linehaul (Company Fleet), ID # 5 – Accessorial Revenue (Company Fleet), ID # 6 Salaries, Wages & Benefits (Company Fleet)


Gross Fuel Expense per Mile (CF)

Description: This metric calculates the gross fuel expense on a per mile basis. The acceptable range for this metric, for exception reporting purposes, is between $0.59 and $0.10 per mile.
Formula: (Fuel Expense_Total + FuelSurchargeRevenue_Total) / (Total Miles Driven_Total)
Data Points Utilized: ID # 10 Fuel Expense (Total), ID # 20 Total Miles Driven (Total), ID # 150 Fuel Surcharge Revenue (Total)


Gross Fuel Expense (CF) (% of Revenue)

Description: This metric calculates the gross fuel expense expressed as a percentage of Gross Revenue (including Fuel Surcharge). The acceptable range for this metric, for exception reporting purposes, is between 33% and 9%.
Formula: (Fuel Expense_Total + FuelSurchargeRevenue_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total + FuelSurchargeRevenue_Total)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 10 Fuel Expense (Total), ID # 150 Fuel Surcharge Revenue (Total)


Non-Driver Personnel Expense (% of Gross Revenue)

Description: This metric expresses Non-Driver Personnel Expense, as a percentage of gross revenue (including Fuel Surcharge). The acceptable range for this metric, for exception reporting purposes, is between 15% and 3.00%.
Formula: (Salaries, Waged & Benefits_Non-Driver_Total) / (Freight Revenue Linehaul_Total + Accessorial Revenue_Total + FuelSurchargeRevenue_Tota)
Data Points Utilized: ID #1 – Freight Revenue – Linehaul (Total), ID # 2 – Accessorial Revenue (Total), ID # 63 Salaries, Wages & Benefits – Non Driver (Total), ID # 150 Fuel Surcharge Revenue (Total)