Category: Parts

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.

Parts Application Measures

Below is a list of the measures available from the master library in the parts application

  • Counter Sale
  • Counter Sales 10-12 Months
  • Counter Sales 4 – 6 months
  • Counter Sales Cost
  • Counter Sales Gross Profit
  • Counter Sales Gross Profit Margin– Counter sale gross divided by counter sale total
  • Counter Sales Less 3 Months
  • Gross Profit Sales Margin Invoice & RO
  • Gross Profit Sales Margin ROs
  • Inventory Value
  • Invoice Line Unit Price
  • Last Sold 3 Years or Greater
  • Last Sold Greater than 1 Year
  • Last Sold Greater than 2 Years
  • Last Sold Greater than 6 Months
  • List Price
  • Negative OHQ Part Pieces-Total part numbers with an on hand quantity below zero
  • Negative OHQ Value-Total value of negative parts on hand
  • Negative Part Numbers– Count of negative part numbers
  • OHQ Pieces-Total number of part pieces on hand.
  • Part Invoice Lines Summary Of Extended Pirice
  • Part Number Count-Count of part pieces in stock
  • Part Number Count With BSL > 0– Total number of part numbers with a best stocking level above zero
  • Part On Hand Available
  • Part Price Core
  • Part Price Jobber
  • Part Price Original
  • Part Price Trade
  • Part Qty Sold 10-12 Months– both invoice and repair orders
  • Part Sales 13+ Months– both invoice and repair orders
  • Part Sales 4 – 6 Months– both invoice and repair orders
  • Part Sales 7 – 9 Months– both invoice and repair orders
  • Part Sales Less 3 Months– both invoice and repair orders
  • Parts Inventory Extended Cost
  • Parts On Hand -GP Margin– List price in relation to cost price
  • Parts That Match Best Stocking Level
  • Percentage of Parts OH matching BSL
  • Quantity On RO– Quantity Of The Part On The Repair Order Lines
  • RO Part Cost– Cost Of part on Repair Order Parts
  • RO Part Sales 4- 6 Months
  • RO Part Sales 7 – 9 Months
  • RO Part Sales 9-12 Months
  • RO Part Sales Less 3 Months
  • RO Parts Extended Price
  • RO Parts Gross Profit
  • RO Parts Gross Profit Margin– Ro gross profit divided by RO total part sales
  • RO Unit Price
  • Sales Hits Total
  • YTD Counter Sales-Counter Sales Year To Date
  • YTD Counter Sales Gross Profit-Gross Profit On Counter Sales Year To Date
  • YTD Part Sales Total-Parts sales Year To Date Total On Ro & Counter Sales
  • YTD RO Sales-Repair Order Sales Year To Date
  • YTD RO Sales Gross Profit-Gross Profit On RO Sales Year To Date
  • YTD Total Sales Gross Profit-Year To Date Part Sales Total Gross Profit For Counter & Repair Orders
  • YTD Total Sales Gross Profit Sales Margin-Year To Date Gross Profit Sales Margin For Counter & RO Sales

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.

Loading...
X