Sales Mix to Oil Change Report is the full picture of what your oil change business turns into. It opens with a summary of the period, breaks your oil changes down by the kind of oil that went in, and then runs through around twenty add-on services, showing for each one how many you sold, how often that happened per oil change, and what it earned. Use it to see your whole service mix on one line, to find which add-ons are being missed, and to compare oil types as customers move from conventional to synthetic.
This is a very wide report — around ninety columns — and it gives one row per Store, so on a single site it is a single very long line. Use a period of a quarter or a year: attachment rates over a week mean nothing.
The report opens with the summary. Total Sales and Total Customers are the whole period, Ticket Avg is one divided by the other, Oil Changes and Oil Changes Sales are the oil change business inside that, Avg Oil Change is a per-customer figure, and % Car Count is the share of your customers who had an oil change.
Take care with Avg Oil Change. It is not the average value of an oil change — it divides oil change sales by every customer in the period, including those who never had one. In the example, $924,771.70 of oil change sales across 11,021 customers gives the $83.91 shown, while the same sales across the 9,918 actual oil changes come to $93.24. If you want what an oil change is really worth, divide Oil Changes Sales by Oil Changes yourself.
Next comes the oil type breakdown — Conv Oil, High Mileage, Synthetic Blend, Synthetic Oil, Premium Synthetic Oil, Mobil 1 Synthetic Oil and Diesel Oil. These come as pairs, a count and a % to Oil Change, with no money column, and because every oil change uses exactly one kind of oil the seven counts add up to your Oil Changes total and the seven percentages come to 100%.
After that, every remaining service comes as a set of three — how many were sold, the % to Oil Change, and the Sales. The pattern repeats for around twenty services, from brakes and flushes through filters, tyres, inspections and batteries.
% to Oil Change is an attachment rate — that service's count divided by your oil changes. The add-on percentages are not shares of anything and are not meant to total 100%; each one answers "how often did an oil change also get this?" A service can also show a count with no sales, as a free brake inspection does.
Wiper Blade is counted differently, and its headings say so. The count is headed Wiper Blade (Part QTY) and gives blades sold, while the percentage is headed % to Oil Change (Service Count) and is worked out from jobs. Blades sell in pairs, so 361 blades in the example sits against a 1.91% rate — about 189 jobs out of 9,918 oil changes. Every other service on the report counts the same thing in both columns.
A word on the two similar reports. Sales Mix to Oil Change Mag 7 covers just seven headline add-ons on a much narrower table; this one covers the full service list, the oil types and the store summary as well. Use the Mag 7 report when you want the short version and this one when you want everything.