Doing the parts profit math

Aug. 28, 2014
We have income for the parts sold and a cost for the parts purchased, but when looking at parts margins as a KPI, we often wonder why there is a fluctuation in the parts gross profit margin.

Every week I have the opportunity to look at several profit or loss statements for shops in different parts of the country. When we do a shop analysis, one of the areas that we look at is parts margin. Not only are shops dealing with one or more estimating systems and parts procurement methods, they also handle multiple types of parts, vendors and discounts or markups to determine the sale price or cost of the parts.

For most shop owners, parts seem pretty simple. We have income for the parts sold and a cost for the parts purchased. So when looking at parts margin as a key performance indicator (KPI), I am often asked, “Why is there a fluctuation in my parts gross profit margin?”

Gross profit margin
Gross profit margin is calculated by subtracting cost of goods sold (COGS) from total sales and dividing that number by total sales. For example, if a shop sells a part for $125 and has a cost of $80, the gross profit margin is 36 percent.

Discount from list price
When you calculate your parts margin you need to consider the discounts you are receiving from your vendors. For example, a shop may have negotiated different discounts off the list price with different dealerships.

If a shop purchased parts from three different dealerships and each had a different negotiated discount, the shop’s gross profit margin would fluctuate depending on the list price of the parts and the discounts used to determine the cost paid. 

  Sales Discount Cost Gross Profit Margin %
Dealership 1 $175 30% $122.50 30%
Dealership 2 $325 20% $260 20%
Dealership 3 $235 25% $176.25 25%
         
Total $735   $558.75 23.98%

Cost plus a markup
Is there a difference between margins and markup? Absolutely. More and more in today’s world, these two terms are being used interchangeably to mean gross margin, but that misunderstanding can have a drastic impact on the bottom line. Markup and gross profit margin are not the same! Shops must have a clear understanding of the two within a pricing model. The term markup refers to the percentage difference between the actual cost and the selling price. Many shop owners mistakenly believe that if a part is marked up, say 25 percent, the result will be a 25 percent gross profit margin on the income statement. But that’s wrong.

For example, when a shop buys a used part for $100 and marks it up 25 percent, the selling price is $125. When you calculate the gross profit percentage on that part [$125  (sale) - $100. (cost) divided by $125 (sale)] the gross profit margin percentage is only 20 percent.

Parts vendor volume
The number of parts purchased from each vendor will also cause a fluctuation in the gross profit margin. For example, if one week or month you purchase more OEM parts than you do LKQ (used) or aftermarket, the margin will increase or decrease depending on the discounts applied to each part.

Here is an example where a shop made six parts purchases and had a 23.7% profit margin for those purchases.

  List Price Discount Cost Markup Margin
OEM $175 30% $122.50   30%
OEM $100 20% $80   20%
LKQ (Used) $68.75   $55 25% 20%
LKQ (Used) $250   $200 25% 20%
Aftermarket $50 35% $32.50   35%
Parts Source $45 22% $35.10   22%
           
Total $688.75   $525.10   23.76%

Parts vs. materials
When you start analyzing your parts margin, you also need to consider how your estimating system is handing materials such as seam sealers. For example, if you charge seam sealer to a vehicle repair order, and the estimating system treats that material as a part, you may be impacting both your parts and paint margins. In this situation, it is not uncommon to have the sale of the seam sealer shown as part revenue and the cost applied to your paint and materials. While it may not be significant if you only consider that one vehicle, it can be important over a period of a month, quarter or year.

Markup vs. margin
When purchasing parts or other products or services on a cost plus a markup, you must understand the gross profit percentage you will make on that purchase. We have created a table for you that shows the gross profit you will make based on the markup percentage applied. Try it free for a limited time by going to www.ationlinetraining.com/abrn1409. It also makes a great tool for training and coaching your staff on how the work they do makes a difference to the business.

About the Author

Tom McGee | Director, ATI Collision

Tom McGee is Director of ATI Collision for the Automotive Training Institute, founded in 1974. ATI’s 99 associates train and coach more than 1,150 shops across North America to drive profits and dreams home to their families. You can contact Tom at [email protected] and visit their website at www.autotraining.net. Check out Profit Matters for Mechanical Repair Management tips in Motor Age by ATI’s CEO Chris “Chubby” Frederick.

Sponsored Recommendations

Learn how ADAS utilizes sensors such as radar, sonar, lidar and cameras to perceive the world around the vehicle, and either provide critical information to the driver or take...
Enhance your collision repair workflow with Autel’s IA900, a process-driven solution integrating precision alignment, bi-directional diagnostics, and ADAS calibration. Designed...
The Autel IA700 is a state-of-the-art and versatile wheel alignment pre-check and ADAS calibration system engineered for both in-shop and mobile applications...
Discover how the investment in an extended-height paint booth is a game-changer for most collision shops with this Free Guide.