Category: Service Visualizations

Deal Retention

This pivot table displays information from vehicles that have been sold at the dealership and displays calculations for the retention levels in service.  Columns include: Vehicle Model Year, Vehicle Make, Vehicle Model, Vehicle Trim, Stock Number, Repair Order Number, # of Deals Delivered, Number of Deals Returned for Service, % of Deals Returned for Service, Number of Deals Returned for Customer Pay Service, % of Deals Returned for Customer Pay Service, % of Deals Returned After Base Warranty.  Columns for the vehicle details can be drilled down from vehicle year to repair order number by selecting the circle with + in it beside the value.

Year Over Year Labour and Parts Sales and Gross By Month

This chart shows year over year trends for repair order labour and parts sales by month.  On the left side of the chart you can switch between labour and parts sales or labour and parts gross profit.

RO’s by Advisor

This chart shows a count of RO’s by Advisor

Work in progress under 90 days & over

Work in progress including total cost of parts, labour, sublets on open repair orders by age 90 days or less and over 90 days

Work in progress under 60 days & over

Work in progress including total cost of labour, parts, and sublets by age 60 days or less and over 60 days

Work in progress under 30 days & over

Work in progress with total cost of parts, labour & sublets on open repair orders by age 30 days or less and over 30 days

Top 10 part sale customers on ro’s

Top 10 part sale customers on repair orders

Top 10 labour sale customers

Technician Sold & actual hours

Sold and actual hours by technician. Sold hours in yellow and actual hours in blue with performance in the red line

Work in progress RO count 90 days & under

Count of open repair orders 90 days in age or less

Work in progress RO count 60 days & under

Count of open repair orders 60 days in age or less

Work in progress RO count 30 days & under

Count of open repair orders 30 days in age or less

Work in progress RO count by age

Count of open repair orders by date range interval at the bottom

Daily labour sales

Labour sales by day representing customer pay, internal and warranty

Count of RO’s by vehicle

Count of repair orders by vehicle make with the option at the bottom to switch to vehicle year if needed

Count of appointments by CSR

The number appointments is at the bottom and CSR on the left

Cumulative Labour Sales By Day

This chart will show the cumulative labour sales by day over a month to monitor an advisor’s or even the department’s progress.  Reference lines can be added to monitor how the advisor performs compared to the progress needed to reach their monthly goal.

Technician KPI V2

This Pivot Table shows technician KPIs broken down by pay type and includes part sales KPIs from the original Tech KPI chart.

Technician actual hours vs booked hours

This shows the total sold and actual hours booked on repair orders broken out by technician and pay type.  You can expand each technician to drill down to specific repair orders and even specific request lines.

 

Technician Clocked Hours By Day

This pivot table displays information from the dispatch time clock and shows the total hours clocked in time clock by technician and day of the month.

 

Loading...
X