Total = Total charged to the customer. This isn't displayed in a column but is used for various calculations.
Column Name | Calculation |
Advisor | Advisor Name |
# of ROs | Total Number of ROs |
Average (Avg) Quote | Quoted parts + quoted labor / total ROs |
Average (Avg) RO | Total RO Sales / # of ROs (the RO Sale does not include tax) |
Gross Sales | Total - Tax |
Gross Profit | (Total - Tax) - (Parts Cost - Labor Cost - Sublet - Shop Supplies) |
Gross Profit (GP)% without Tire Sales | Gross Sales - Parts Cost - Labor Cost - Sublet - Tire Sales / Gross Sales - Tire Sales |
Close % | Gross Sales / Quoted Sales |
Tire Sales | The sum of parts and labor in the tire category |
Tire Units | The sum of qty for parts listed in the Tire category |
LOF | Total number of Oil changes based on the labor items with the LOF category |
Inspections | Total number of inspections based on items with the Inspection category |
Discounts | Total Discounts applied to repair orders |
Tracking | Gross Sales / Worked Days * Total Work Days |
Time | Hours clocked in (only visible with time clock integration) |
Cards | Number of timecard for the given period (only visible with time clock integration) |
This report is available for: RO Writer, Protractor, and Mitchell 1.
In order to match the numbers that are generated by Mitchells native reports some of these numbers are calculated differently.
Column Name | Calculation |
Advisor | Advisor Name |
# of ROs | Total Number of ROs |
Average (Avg) Quote | Quoted parts + quoted labor / total ROs |
Average (Avg) RO | Total RO Sales / # of ROs (the RO Sale does not include tax) |
Gross Sales | Total - Tax - Shop Supplies |
Gross Profit (Mitchell Integration) | (Total - Tax) - (Parts Cost - Labor Cost - Sublet) |
Gross Profit (GP)% without Tire Sales | Gross Profit - Tire Sales / Gross Sales - Tire Sales |
Close % | Gross Sales / Quoted Sales (quoted sales are based on the sub-estimates that were created and not sold/cleared out during the customer visit) |
Tire Sales | The sum of parts and labor in the tire category |
Tire Units | The sum of qty for parts listed in the Tire category |
LOF | Total number of Oil changes based on the labor items with the LOF category |
Inspections | Total number of inspections based on items with the Inspection category |
Discounts | Total Discounts applied to repair orders |
Tracking | Gross Sales / Worked Days * Total Work Days |
Time | Hours clocked in (only visible with time clock integration) |
Cards | Number of timecard for the given period (only visible with time clock integration) |