Category: Parts Visualizations

Service Parts Sales Details

This table displays results from parts sold on repair orders.  As a pivot table the columns can be reordered to allow you to view the information in your own way.  Clicking on the +s will allow you to drill down into information.  Columns include Part Number, Date Cashiered, Repair Order Number, Parts Line Advisor, Sales, Gross Profit, Gross Profit Margin.

Parts Invoice Sales Details

This table displays parts sales and gross profit information from parts invoice sales.  As a pivot table the columns can be rearranged to display results in your own personally preferred way.  Clicking on the +s will expand the columns to drill down into the data.  Columns include Part Number, Date Cashiered, Invoice Number, Advisor, Sales, Gross Profit and Gross Profit Margin.

Year Over Year Counter Invoice Parts Sales and Gross by Month

This chart shows year over year parts counter sales and gross profit trends by month.  Switch between parts counter sales and parts counter gross on the left side of the chart.

Year Over Year RO Parts Sales and Gross By Month

This chart shows year over year trends for parts sold on repair orders.  You can switch between parts sales and parts gross profit on the left side of the chart.

Possible Parts Return By Sales Hit Date

This table displays details of parts in inventory.  Columns include Part Number, Last Receipt Date, Last Sales Hit Date, Last Sold Date, OH Total, Package Quantity, Cost, YTD Sales, Returnable Packages, Quantity from Returnable Packages, Retained Units, Returnable Value, Value of Retained Units, Days Aged Based Off Last Sales Hit Date.

Possible Returns – Last Sold Date

This table displays details of parts in inventory.  Columns include Part Number, Last Receipt Date, Last Sales Hit Date, Last Sold Date, OH Total, Package Quantity, Cost, YTD Sales, Returnable Packages, Quantity from Returnable Packages, Retained Units, Returnable Value, Value of Retained Units, Days Aged Based Off Last Sold Date.

Possible Parts Return By Last Purchase Date

This table displays details of parts in inventory.  Columns include Part Number, Last Receipt Date, Last Sales Hit Date, Last Sold Date, OH Total, Package Quantity, Cost, YTD Sales, Returnable Packages, Quantity from Returnable Packages, Retained Units, Returnable Value, Value of Retained Units, Days Aged Based Off Last Purchased Date.

Parts On Repair Orders

This table shows details from parts sold on repair orders.  Columns include RO Number, Contact Name, Request Number, Technician, Part Number, Part Description, Price Code, Qty Sold, Sales, Cost, Gross Profit Margin and RO Status.

Parts on Hand Inventory

This table displays details of parts in the dealership’s inventory with an on hand quantity.  Columns include Part Number, Part Description, Bin1, OH Total, Cost, Core Cost, Extended Value and BSL.

Open Repair Order Parts Table

This table will display details of parts on open repair orders.  Columns include RO number, Date Opened, Contact Name, Advisor Name, Technician, Qty Sold, Part Number, Part Description, Price Code, Cost, Sales and Gross Profit Margin.

Negative On Hand Parts

This table is showing parts with a negative on hand.  Columns include:  Part #, Part Description, Bin1, On Hand Count, Cost, Extended Cost, Count of Part #s.

Counter Sales Table

This table is showing details from parts invoice transactions.  Columns include: Invoice #, Customer Name, Part #, Part Description, Price Code, Units Sold, Part’s Cost, Unit Price, Extended Price and CSR Name.

 

RO Gross Profit by Source

This doughnut chart displays the proportions of repair order parts gross profit grouped by the parts source.  By default the top 10 parts sources will display, select the others item to display the next group of parts sources.

RO Parts Sales By Price Code

This doughnut chart shows the proportions of repair order parts sales grouped by price code.  B default only the top 15 price codes will display, select the others item to view the next group of price codes.

Counter Sales By Price Code

This doughnut chart will show the proportions of part’s counter sales grouped by the price code.  by default the top 10 price codes will display, select others to display the next set of 10 price codes.

Sales Hits Based on Month/Year and Part Number

This line chart shows the hits for each part number grouped by the month and year of the hit.  Each line represents a different part number.  Only the top 10 part numbers based on your selections will display.

Daily RO Parts Sales & Gross Profit Chart

This line chart shows repair order parts sales and repair order parts gross profit group by the day of month.

Daily Counter Sales & Gross Profit Chart

This line chart displays part’s counter sales and part’s counter gross profit from the selected date range and is grouped by the day of the month.

Top 10 Contacts on Repair Orders

This bar chart shows the top 10 contacts from parts sales on repair orders.

Top 10 Counter Sale Customers

This bar chart shows total parts counter sales grouped by the top 10 customers.

Loading...
X