A parts matrix is a table that turns a part's cost into its counter price without anybody deciding line by line. Cheap parts carry a high multiplier, expensive parts a low one, and the bands in between are set once and applied to everything. It exists because pricing 4,000 part numbers by judgement is not a job anybody can do, and because a flat markup across the whole shelf prices the cheap parts too low to be worth stocking and the expensive ones too high to sell. This page sets out how the bands work, what they do to the margin you actually keep once the counter gives its usual discount, and which free sheet here works the real figure from your own cost and price.
How the bands work
A matrix is a list of cost ranges, each with a multiplier or a target margin. A part costing $2 might be priced at three or four times cost; a part costing $400 might be priced at 1.25 times. The shape is deliberate: on a cheap part the absolute gross profit is tiny at any sensible margin, and the cost of stocking, counting and handling it is the same as for an expensive one, so the multiplier has to carry it. On an expensive part the customer is far more likely to price-check, and a high multiplier loses the sale rather than the margin. The bands should be set from what you actually stock, not copied from a vendor's default, because a default built for a dealership's mix will misprice an independent's shelf in both directions.
What the matrix says and what the counter takes
The matrix sets the list price. The counter sets the price actually charged, and the gap between them is where the margin goes. A trade discount given as a matter of habit, a price matched against an online seller, a fleet account's standing terms: each one takes a bite out of a number the matrix reported as achieved. This is the single most common way a parts operation believes it is holding a margin it is not. On the parts margin sheet here, $42 of cost against a $78 list looks like a 46% margin, and with the usual 10% off it sells at $70.20 for $28.20 of gross profit, which is a 40% margin and a 67% markup. Four points, on 180 lines a week, is real money: the same sheet puts that line at $5,076 a week and $263,952 a year.
Margin and markup are not the same number
A matrix is usually written in markup and reported in margin, and the two are routinely confused in a way that flatters the report. Markup is gross profit over cost; margin is gross profit over the price. The same $28.20 on a $42 part is a 67% markup and a 40% margin. Someone reading a 67% matrix multiplier as a 67% margin will believe the shelf is making two thirds of its selling price, which no parts operation does. Whichever your matrix is written in, check that the figure your system reports back is the other one converted, not the same number relabelled.
Reviewing the matrix against what actually sold
A matrix set once is a matrix that is now wrong, because supplier cost moves and the mix on your shelf moves with it. The review is not a re-guess: take the lines that actually sold in a period, work the real price charged and the real gross profit on each, and look at where the achieved margin sits against the band that was supposed to produce it. Bands that consistently come in low are being discounted away at the counter and either the band or the discount policy has to change. The margin sheet on this site works that line by line from your own cost, list, discount and volume, with no account.
Questions people ask about parts matrix
What is a parts matrix?
A pricing table that sets a part's counter price from its cost. Costs are grouped into bands, each band carries a multiplier or a target margin, and every part in the band is priced the same way. It replaces line-by-line pricing on a shelf of thousands of part numbers and stops a single flat markup from mispricing the cheap and the expensive ends of the shelf.
Why do cheap parts carry a higher multiplier?
Because the absolute gross profit on a cheap part is small at any sensible margin, while the cost of stocking, counting, binning and handling it is much the same as for an expensive one. A flat markup would make the cheap end of the shelf not worth carrying. The higher multiplier is paying for the handling, not gouging the customer.
Does the matrix tell me my real margin?
No. The matrix tells you the list price. Your real margin is worked from the price the counter actually charged after whatever discount it gives, and that is usually several points below what the matrix implies. The parts margin sheet here works the real one from your cost, your list, the discount you actually give and the lines you sell in a week.
Is a 40% margin the same as a 40% markup?
No, and the difference is large. Margin is gross profit as a share of the selling price; markup is gross profit as a share of cost. $28.20 of profit on a $42 part sold for $70.20 is a 40% margin and a 67% markup. Check which one your system is reporting before you compare it to a target.