DEF Analysis Dashboard

DEF Analysis Dashboard

The purpose of this dashboard is to provide users with insights into the average DEF (Diesel Exhaust Fluid) costs relative to the total number of miles recorded for their company. All calculations are based on data from the FedEx Linehaul settlement.

  • X-Axis: Displays the week ending.
  • Y-Axis: Shows the calculated DEF cost per mile driven, based on the formula:
    • Total DEF Costs (from settlement transactions with description "DEF-Retail") ÷ Total Miles (from the settlement, verified on the Miles Per Vehicle dashboard).

This calculation provides the DEF cost in USD per mile. By default, the dashboard presents the DEF cost per 1,000 miles by multiplying the result by 1,000.

  • User Customization:
    Users can adjust the dropdown menu to view DEF costs at different mile intervals:
    • Per 10,000 miles
    • Per 1,000 miles (default)
    • Per 100 miles
    • Per 10 miles
    • Per 1 mile

This flexibility allows users to analyze DEF costs at varying levels of granularity, helping them better understand and manage their operational expenses.

Example Calculation

For a settlement with a week ending where the company recorded:

  • Total Miles Driven: 26,866
  • Total DEF Costs: $327.76

The DEF cost per mile is calculated as:
$327.76 ÷ 26,866 = $0.0122 per mile

By default, the dashboard multiplies this result by 1,000 to display DEF costs per 1,000 miles:
$0.0122 × 1,000 = $12.20 per 1,000 miles.

    • Related Articles

    • Fuel Cost Per Mile

      The Fuel Cost per Mile Dashboard shows you the total fuel cost divided by the total miles from your Linehaul settlement. If no vehicles are selected on the dropdown, you will see data for all your vehicles grouped by week ending. To see data by ...

    • Managing Expense Categories for Dashboard and Report Calculations

      myGroundForce provides granular control over how your expense categories contribute to key dashboard metrics and reports, particularly those related to fuel and DEF analysis. This feature ensures that your financial reporting accurately reflects the ...

    • Net Revenue x Mile

      The Net Revenue x Mile Dashboard shows you the net revenue of your organization divided by the total of miles traveled registered in the settlement. This information can be sorted by Week Endings, Monthly and Quarterly periods as well as a specific ...

    • Fuel Profitability

      The Fuel Profitability Dashboard shows you the difference between fuel purchases and the fuel surcharge earned. A fuel surcharge is an extra fee that transportation companies add to account for the cost of fuel. It's usually calculated as a ...

    • Tractor Fuel Miles Per Gallon

      The tractor fuel miles per gallon dashboard shows you how many miles one or more vehicles has registered per gallon of fuel registered on the FedEx Settlement for a certain week ending settlement period. The formula used to calculate this dashboard ...