Parts matrix

A parts matrix is a table that sets markup by parts cost, applying a big multiplier at the bottom of the range and a small one at the top. It exists because a single percentage across the whole shelf produces a price that is too thin on a $3 clip and too fat on a $1,400 turbocharger.

The table gets set up once and then quietly prices every part the shop sells until somebody opens it again.

How does a parts matrix set the price?

Cost goes in, a bracket catches it, a multiplier comes out. A $3 clip in the bottom bracket might sell at $9. A $60 sensor two brackets up sells at $120. A $1,400 turbocharger in the top bracket sells at $1,750.

The brackets are the shop's decision and nobody publishes a correct set. The shape is settled: the multiplier falls as cost climbs. Hold a single percentage across the whole range and one end of the shelf loses money while the other end loses jobs.

What breaks when a shop uses one flat markup?

Arithmetic. Take a flat 40 percent. On a $4 hose clamp the shop earns $1.60, which does not pay for the phone call that ordered it. On a $1,400 turbo the same 40 percent adds $560 to a line the customer can already price on a phone, and a big-ticket part is the line they will price.

Both ends fail for the same reason. The cost of handling a part is roughly flat and the markup is not. A matrix is how a shop makes the pricing follow the handling cost instead of following the invoice.

The customer sees that turbo line on its own. California puts the requirement in statute: "Service work and parts shall be listed separately on the invoice", with a subtotal stated for each. Whatever the table does to a big part arrives in front of the customer as its own number and gets read that way.

What do you type into the brackets?

Markup, because that is what the table multiplies cost by. The profit and loss statement then reports the result as margin, which is a different percentage for the same transaction, so a shop that types its margin target straight into the matrix ends up well under the number it wanted. Run the conversion once from the entry on markup and margin, write the answers on a card and tape it to the parts computer. Parts margin is what the result gets called on the report.

What breaks a parts matrix?

Bad cost. The matrix multiplies whatever the system holds as cost at the moment the part hits the line, and three things corrupt that figure. A core charge folded into cost gets marked up, so the customer pays a premium on a deposit. Freight rolled into cost does the same. A line typed by hand with the cost field left at zero sells for zero, because any multiplier times zero is still zero.

California states the shape of a core on the one every shop sells. A replacement lead-acid battery bought without a trade-in carries a refundable deposit, and the dealer has to "refund the deposit" once the used battery comes back within 45 days. Money the shop is going to hand back has no business running through a multiplier.

Freight lands in that field honestly, which is what makes it hard to see. A supplier bills the part and the delivery on one line, the system stores the total, and the matrix marks up the delivery along with the part. Settle which field the table reads before you spend an afternoon arguing about brackets.

That last one is the expensive one and it hides well. It looks like a normal line on the invoice with a normal price, right up until somebody reconciles the jobber price against what went out.

Where does a parts matrix cost a diesel shop money?

The top bracket, every time. Injector sets, turbochargers, particulate filters and long blocks all sit above wherever the table ends, so the matrix flattens out and hands the same thin multiplier to a $900 part and a $6,000 one.

Set an explicit rule above the top bracket instead of leaving it to the advisor. Some shops switch to a fixed dollar margin per part up there. Some hold a floor percentage and let the number be what it is. Either beats the alternative, which is an advisor discounting a $6,000 line by feel at four in the afternoon. Put the rule in the shop management system so the decision is already made, and the labor half of the same idea is the labor matrix.

How do you audit a parts matrix?

Export a month of parts lines with cost and selling price. Calculate margin per line, group the lines by the cost bracket the matrix assigns, then compare what each bracket produced against what the table promised. There is a shop-wide version of the same arithmetic and the IRS spells it out in Publication 334: "First, divide gross profit by net receipts. The resulting percentage measures the average spread between the merchandise cost of goods sold and the selling price." That single percentage is what your accountant works from. It cannot say which bracket is drifting, which is the reason this audit groups the lines before it divides.

The bracket that disagrees is where humans are intervening, and the top bracket is the usual answer, because that is where somebody knocks $200 off a $1,600 part to save an approval and logs nothing. That is a policy question and not a table question, and it stays invisible until the data gets grouped this way. Two more reports finish the job: parts lines with a cost of zero, and parts lines where price equals cost. Both go out the door looking completely normal on an invoice.

Back to the glossary, or read how an estimate gets priced.