Revenue x Payroll Cost

Revenue x Payroll Cost

The Revenue x Payroll Cost dashboard displays the total revenue of your company divided by the total payroll costs it accumulates, aiming to answer the question: how much revenue does a dollar of payroll generate? This information can be sorted by Week Endings, Monthly and Quarterly periods as well as a specific region.

 

Use the checkbox Deduct Fuel Surcharge to remove that value from the calculation.

 

The formula for the Net Revenue x Mile is as follows:

 

Revenue x Payroll Cost = Total Revenue / Total Payroll Cost

 

The Total Revenue is calculated through the sum of different sources of revenue such as the Linehaul Daily Gross Amount, the Shuttle Daily Gross Amount, the Spot and Other Settlement Adjustments total. All of these values come from the settlement. Meanwhile the Total Payroll Cost includes all approved payroll payments for both drivers and non-drivers included in the Payroll Report.

 

The Y axis displays the result of the formula, showing how much revenue you’re making in comparison to your payroll costs for each date displayed in the X axis.

 

Revenue x Labor Cost Per Driver

 

The Revenue x Labor Cost Per Driver dashboard displays the total revenue divided by the total payroll costs for a specific driver within your organization. This information can be sorted by Week Endings, Monthly and Quarterly periods, specific Regions and specific Drivers.

 

Use the checkbox Deduct Fuel Surcharge to remove that value from the calculation.

 

The formula for the Revenue x Labor Cost Per Driver is as follows:

 

Revenue x Labor Cost Per Driver = Total Revenue for the Driver / Total Payroll Cost for the Driver

 

The Total Revenue for the driver is calculated through the sum of all their different sources of revenue such as the Linehaul Daily Gross Amount, the Shuttle Daily Gross Amount, the Spot and Other Settlement Adjustments total. All of these values come from the settlement. Meanwhile the Total Payroll Cost for the driver includes all their approved payroll payments for both drivers and non-drivers included in the Payroll Report.

 

The Y axis displays the result of the formula, showing how much revenue the driver is generating in comparison to their payroll costs for each date displayed in the X axis.


Info
Only the approved payroll will be able included in the calculation.
Info
You can deduct the fuel surcharge by enabling the checkbox Deduct Fuel.

    • Related Articles

    • Revenue Generated x Payroll Costs Report

      On the left-side menu, click on Reports. In the Finance report group, click on Revenue Generated x Payroll Costs.        3. User the filter options Date (start date), to (end date), Contract ID, and Driver to refine your report data.       4. Use the ...
    • Revenue x Labor Cost Per Driver

      Revenue x Labor Cost Per Driver The Revenue x Labor Cost Per Driver dashboard displays the total revenue divided by the total payroll costs for a specific driver within your organization. This information can be sorted by Week Endings, Monthly and ...
    • 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 ...
    • 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 ...
    • 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 ...