Sales Mix to Oil Change Mag 7 measures how often your oil changes turn into something more. It counts the oil changes you did, then for each of seven add-on items — cabin filter, lights, air filter, wipers, batteries, transmission service and tyre rotation — shows how many you sold, what proportion of your oil changes that represents, and what it earned. Use it to see which add-ons your team is actually offering, to set a target for the ones that are lagging, and to put a number on what a percentage point of attachment is worth.
Give it a long period. Attachment rates are only meaningful over a few hundred oil changes, so a quarter or a year tells you far more than a week.
The report gives one row per Store, so on a single site it is a one-row report and on a group it is one line each. The row opens with Total Oil Changes — the number you did in the period — and Oil Changes Sales, what they were worth. Everything after that comes in threes: for each add-on, how many were sold, the % to Oil Change, and the Sales it brought in.
% to Oil Change is the attachment rate — that item's count divided by your total oil changes. It is not a share of your sales and the seven percentages are not meant to add up to anything; each one answers its own question, "how often did an oil change also get one of these?"
Wipers is counted differently from the other six, and the headings tell you so. Its count column is headed Wipers (Part QTY) and gives the number of *blades* sold, while its percentage is headed % to Oil Change (Service Count) and is worked out from the number of *jobs*. Because wipers are usually sold in pairs, the blade count is roughly double the job count — in the example, 239 blades against a 2.76% rate, which is about 120 jobs out of 4,352 oil changes. For the other six items the count beside the percentage is the same count the percentage is built from.
An add-on you do not sell at all shows a count of 0, a rate of 0% and no sales, rather than being left off the report. If Total Oil Changes is zero for the period every rate reads 0% whatever else you sold, so always check that figure first.
One button to be careful with. In our build the SHOW ALL button points at a page that does not exist, so clicking it takes you away from the report rather than clearing the dates. To start again, set the date range you want instead.