Use the Equipment Profit Report to view equipment revenue and cost information. In addition, use the report to view monetary contributions made to your business by equipment and equipment operators.
Note: Monetary contribution = gross profit - (equipment expense + wage + overtime).
For a description of the report, see What the Report Shows at the end of the topic.
To report on equipment profit:
From the Warehouse Management > Equipment Maintenance menu, select Equipment Profit Report to display the Equipment Profit Report window.
In the As Of Date field, enter the end date of the period to include in the report. The date defaults to the current date.
In the Branch field, enter or select the branch to include in the report.
In the Equipment field, enter or select the equipment ID for which to run the report.
Select a piece of equipment from the list or use the Multiple Item button to create a list of multiple equipment IDs for which to run the report.
In the Report Type field, select Summary or Detail to indicate how much information you want to view on the report.
The Equipment Profit Report shows the following information:
|
Section |
Column |
Description |
|
MTD (Month to Date) Summary |
Branches |
Branches in which the equipment was used. |
|
Equip |
Piece of equipment used to make deliveries. |
|
|
Revenue |
Revenue generated by the deliveries made by the piece of equipment. |
|
|
Cost |
Cost associated with the deliveries made by the piece of equipment. |
|
|
Gross |
Gross profit associated with the deliveries made by the piece of equipment. |
|
|
Expenses |
Expenses associated with the deliveries made by the piece of equipment. |
|
|
Contribution |
Total monetary contribution associated with the deliveries made by the piece of equipment. |
|
|
Total Hours |
Total hours that the piece of equipment was used for deliveries. |
|
|
Contribution Per Hour |
Monetary contribution per hour associated with the deliveries made by the piece of equipment. |
|
|
Revenue Per Hour |
Revenue generated per hour by the deliveries made by the piece of equipment. |
|
|
Contribution Margin Pct |
Monetary contribution margin associated with the deliveries made by the piece of equipment. |
|
|
Total |
MTD totals for all pieces of equipment being reported on. |
|
|
YTD (Year to Date) Summary |
Branches |
Branches in which the equipment was used. |
|
Equip |
Piece of equipment used to make deliveries. |
|
|
Revenue |
Revenue generated by the deliveries made by the piece of equipment. |
|
|
Cost |
Cost associated with the deliveries made by the piece of equipment. |
|
|
Gross |
Gross profit associated with the deliveries made by the piece of equipment. |
|
|
Expenses |
Expenses associated with the deliveries made by the piece of equipment. |
|
|
Contribution |
Total monetary contribution associated with the deliveries made by the piece of equipment. |
|
|
Total Hours |
Total hours that the piece of equipment was used for deliveries. |
|
|
Contribution Per Hour |
Monetary contribution per hour associated with the deliveries made by the piece of equipment. |
|
|
Revenue Per Hour |
Revenue generated per hour by the deliveries made by the piece of equipment. |
|
|
Contribution Margin Pct |
Monetary contribution margin associated with the deliveries made by the piece of equipment. |
|
|
Total |
YTD totals for all pieces of equipment being reported on. |
|
|
Combined Totals For Truck Codes * |
Fuel |
MTD and YTD fuel totals for all pieces of equipment being reported on. |
|
Dist |
MTD and YTD distances for all pieces of equipment being reported on. |
|
|
mi/g |
MTD and YTD mileage for all pieces of equipment being reported on. |
|
|
Up |
MTD and YTD increases in equipment usage. |
|
|
Down |
MTD and YTD decreases in equipment usage. |
|
|
Sales Revenue * |
CAT |
Category to which equipment belongs. |
|
Description |
Equipment description. |
|
|
Revenue |
Revenue generated by the piece of equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
Cost |
Cost associated with the piece of equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
GP% |
Gross profit percentage associated with the piece of equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
Totals |
Fiscal MTD, fiscal YTD, and last fiscal YTD totals for all pieces of equipment being reported on. |
|
|
Gross |
Fiscal MTD, fiscal YTD, and last fiscal YTD gross profit for all pieces of equipment being reported on. |
|
|
Equip Expenses * |
CAT |
Category to which equipment belongs. |
|
Description |
Equipment description. |
|
|
Expense |
Regular labor and overtime labor expenses associated with the piece of equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
Totals |
Fiscal MTD, fiscal YTD, and last fiscal YTD totals for all pieces of equipment being reported on. |
|
|
Contribution |
Fiscal MTD, fiscal YTD, and last fiscal YTD monetary contributions for all pieces of equipment being reported on. |
|
|
Operator Summary * |
EmpID |
Employee ID of equipment operator. |
|
Employee Name |
Name of equipment operator. |
|
|
Reg Hrs |
Regular hours operator used equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
O/T Hrs |
Overtime hours operator used equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
Total |
Total hours operator used equipment for the fiscal MTD, fiscal YTD, and last fiscal YTD. |
|
|
Totals |
Fiscal MTD, fiscal YTD, and last fiscal YTD totals for all equipment operators being reported on. |
|
|
Contribution Per Hour |
Fiscal MTD, fiscal YTD, and last fiscal YTD monetary contribution per hour for all equipment operators being reported on. |
|
|
Revenue Per Hour |
Fiscal MTD, fiscal YTD, and last fiscal YTD revenue generated per hour for all equipment operators being reported on. |
|
|
Contribution Margin Pct |
Fiscal MTD, fiscal YTD, and last fiscal YTD monetary contribution margin for all equipment operators being reported on. |
* This data displays in detail mode only.
See Also: