To run the Equipment Profit Report: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 run the Equipment Profit Report:From the Whse Mgt > Equipment Maintenance menu, select Equipment Profit Report to display the Equipment Profit screen.
In the As Of Date field, enter the end date of the period to include in this report. The date defaults to the current date.
In the Branch field, enter the branch to include in this report.
In the Equipment field, enter the equipment ID for which to run this report.
Press F10 to select a piece of equipment or use the Equip hot key to create a list of multiple equipment IDs for which to run this report.
In the Summary/Detail field, press F10 and select either Summary or Detail to indicate how much information you want to view on this 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: