Advisor Sales Tracker - Report Definitions

Advisor Sales Tracker - Report Definitions

Total = Total charged to the customer. This isn't displayed in a column but is used for various calculations.

Column NameCalculation
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 UnitsThe 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 NameCalculation
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 UnitsThe 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)

    • Related Articles

    • Tech Sales Tracker Definitions

      The tech tracker report is a great way to see each technicians productivity at a glance. Column Name Calculation Tech Technician Name Total Hours Sum of billed hours Total Cars Sum of vehicles the technician worked on Hrs Per/RO total hours / total ...
    • Average Daily Sales by Advisor / Site - Report Definition

      Total = Total charged to the customer. This isn't displayed in a column but is used for various calculations. Service Advisor Tracker: Column Name Calculation # The of closed repair orders for the range specified Gross Sales (GS) Goal Daily Gross ...
    • Site Comparison Tracker Definitions

      Total = Total charged to the customer. This isn't displayed in a column but is used for various calculations. Service Advisor Tracker: Column Name Calculation # The of closed repair orders for the range specified Avg Quote (Parts + Labor + Shop ...
    • RO Detail Report

      This report shows RO financial breakdown. The RO Detail Report can be filtered by Site, Advisor, DVI status, and Signature status. Date Date on the RO RO # Repair Order number Name Customer first name Tech Tech name Advisor Advisors name DVI DVI ...
    • Advisor IQ Dashboard

      This report gives information about calls and SMS conversations analyzed by Advisor IQ. Advisor IQ Required Site Manager Access Required Calls Inbound calls that go to voicemail or are disconnected in the menu will be listed as N/A User. For calls to ...