Parts Matrix maximization

I am looking to maximize my parts mark up and get everything out parts margin. Can we get reporting with parts purchases from different vendors or Aftermarket and dealer. I would like to see the % of parts purchased in different amounts like $1-5, 5-10, 11-20 ect so we can maximize the markups and keep on top of this. also gross profit in each group or average. I have been noticing parts margins decreasing because of increase of cost. Like Q1 we had a decrease of 7% in Gross profit of parts from the last year. For me if we had it in line with target would have generated additional $56,000 in gross profit. I would like to help make something that we would be able to pull our average purchases and figure a parts matrix to keep us at or above our target Gross profit % on parts.

1 Like

Totally agree, what I did in the meantime was export my last 9-12 months of parts sales / orders and analyzed it with Ai. We ran some simulations to see how we could land in the 43-44% parts margin vs our 34% (yea it was bad, but selling genuine parts) and since September of 2025 we are hitting that target month after month adding tons of GP every month compared to what we were missing before.

It would be very nice to have this stuff in SM, but like you found we can definitely figure it out with tools outside.