Fuel Profitability

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 percentage of the base rate. 

 

Use the checkbox Deduct DEF to remove this charge from the fuel cost calculations in the formula.

 

All information for this graphic originates from the Settlement. For Spot trips you simply utilize the amount of fuel purchase.The Fuel Purchase costs are calculated from the total amount spent on these acquisitions. One thing to be noted is that for Linehaul trips the fuel surcharge formula is as follows:

 

Fuel Surcharge = Quantity x (Fuel Cost + Fuel Surcharge Rate)

 

The final formula is as follows:

 

Fuel Profitability = Fuel Surcharge - Fuel Purchase.

 

The Y axis will display the profitability totals in both a gross number and percentage format, while the X axis displays the dates selected for sorting.

​
​

 

    • Related Articles

    • Wholesale Fuel Purchase (REL)

      This screen displays the Wholesale Fuel Purchase (REL) as a percentage of the total number of fuel transactions, based on the weekly settlement. By default, this dashboard presents all transactions as a percentage of the total number of fuel ...

    • Fuel Purchase by State

      The Fuel Purchase by State report shows you the fuel purchases from your FedEx Settlement. The Report also features the dropdowns Contract, Date (From / To), and State to filter the report's data.  You can use the buttons Excel, PDF, and Print to ...

    • Fuel Surcharge x Total Cost of Fuel

      The Fuel Surcharge x Total Cost of Fuel dashboard shows the total Fuel Surcharge divided by the Total Cost of Fuel from the FedEx Linehaul Settlement and Fuel Transactions listed on the Expenses Registry. The formula is: Total fuel surcharge / (Total ...

    • Profitability by Tractor

      This Dashboard is designed to provide you with key insights and metrics related to your business operations. Entity - The name of the Entity that was selected by the user when logging into the system. Contract - Combo with all contracts registered ...

    • Fuel Surcharge Exceptions Report

      The Fuel Surcharge Exceptions Report shows you the fuel transactions from your FedEx Settlement with 0 value for Fuel Surcharge so that you can review it and submit it to FedEx in case you find inconsistencies. The Report features the dropdown Week ...