• Twitter
  • Youtube
  • LinkedIn
  • Pinterest
  • Facebook
premier google partner agency microsoft partner advertising agency(234) 380-1650 Contact Us
Hedges & Company
  • Our Work
    • Case Studies
    • Blog Articles
    • About Us
    • Results
  • Digital Marketing
    • Digital Marketing Overview
    • Pay Per Click PPC
    • SEO Plans
    • Programmatic Advertising
    • Website Audit
    • Results
  • Research
    • Automotive Market Research
    • Vehicle Registration Statistics
    • Vehicle Registration FAQs
  • Mailing Lists
    • Automotive Mailing Lists
    • Buy a Motorcycle Mailing List
    • Automotive B2B Lists
    • Automotive SIC, NAICS Codes
    • Mailing List FAQs
    • Mailing Lists >
      • BMW Owners Mailing List
      • Camaro Mailing List
      • Corvette Owners List
      • Electric Car Companies and Hybrid EV Lists for Direct Mail
      • Ford F-Truck Mailing List
      • Ford Mustang List
      • Harley-Davidson Mailing List
      • Jeep Owners Mailing List
      • Volkswagen Audi Recall List
      • Dodge Chrysler Jeep Recall List
      • Kia Recall List
  • Email Services
    • Email Prospecting
    • Email Lists
  • Careers
  • Menu Menu

How An Increase in Sale Price or Decrease in Sale Price Affects Gross Profit vs. Unit Sales

Marketing Articles
4.6
(9)
Table of Contents hide
1) Calculate the impact of price increase on gross profit
2) How to find gross profit, with an increase in sale price and total unit sales
2.1) With an increase in sale price, how much can unit sales decrease and maintain the same gross profit dollars?
3) How to find gross profit, with a decrease in sale price and total unit sales
3.1) If you decrease your prices, how much must unit sales increase to maintain the same gross profit dollars?
4) Need to know how to find gross margin? Here’s how to calculate gross margin in Excel
5) Calculate gross margin or mark up?

Calculate the impact of price increase on gross profit

If you want to increase gross margin with an increase in sale price, you need to know how gross profit is calculated. Assuming a drop in unit sales, how many unit sales are needed to maintain the same gross profit.

On the other hand if you’re considering a sale, you should know how many additional unit sales are needed to maintain the same gross profit. You need to know how total unit sales can drop (for a price increase) or need to increase (for a price decrease) for gross profit dollars to remain the same.

We show all the calculations on how a price increase/decrease affects gross profit vs. unit sales.

How to find gross profit, with an increase in sale price and total unit sales

  Let’s look at an increase in sale price and gross profit margin. How many fewer units can you sell and keep gross profit dollars the same?

We’ve calculated the impact of an increase in sale price and profit in the chart below, in our gross profit Excel spreadsheet illustration. Find the current gross margin of your product in the left column, then find the column that shows your price increase. Where the two numbers intersect you’ll see how many fewer units are required for you to sell and maintain the same gross profit dollars.

How An Increase in Sale Price or Decrease in Sale Price Affects Gross Profit vs. Unit Sales Click To TweetFor example, if you currently have a 40% gross margin, and you are considering a 10% price increase, you can sell 20% fewer units and you will still have the same total gross profit dollars in the end.

You’d have to determine if the price elasticity in your market, or your competition, would allow you to have a 10% price increase. In today’s economy many owners and managers are looking for ways to increase revenue and this is one option to consider. You can also look at slower moving items or replacement items as opportunities to increase prices, while keeping your best selling items competitively priced.

With an increase in sale price, how much can unit sales decrease and maintain the same gross profit dollars?

Price Increase Percentage
Margin, before price increase +5%+10%+15%+20%
30% gross margin-14%-25%-33%-40%
35% gross margin-13%-22%-30%-36%
40% gross margin-11%-20%-27%-33%
45% gross margin-10%-18%-25%-31%
50% gross margin-9%-17%-23%-29%

How to find gross profit, with a decrease in sale price and total unit sales

With a decrease in sale price (a sale or discount coupons, for example), how many more units do you have to sell to keep gross profit dollars the same? A decrease in selling price will probably increase sales. So, what if you’re lowering prices to increase sales? We’ve calculated the impact of decrease in sale price on profit, in the Excel spreadsheet illustration below.

Find the gross margin of your product in the left column, then find the column that shows your price decrease. Where the two numbers intersect is a number that shows how many more units you have to sell as a result of a price decrease to maintain the same gross profit dollars.

For example, if you have a 35% margin, and you are considering a 10% price decrease, you must have a whopping 40% increase in unit sales to end up with the same total gross profit dollars. This is important to know if you are considering a sale in an attempt to increase unit sales of a product, especially if it has a low gross margin to begin with.

If you decrease your prices, how much must unit sales increase to maintain the same gross profit dollars?

Price Decrease Percentage
Margin, before price decrease -5%-10%-15%-20%
30% gross margin+20%+50%+100%+200%
35% gross margin+17%+40%+75%+133%
40% gross margin+14%+33%+60%+100%
45% gross margin+13%+29%+50%+80%
50% gross margin+11%+25%+43%+67%

As you can see, the free market blesses those with high margin. A decrease in selling price will probably increase unit sales. But, if you have a thin 30% gross margin and you drop your prices 20%, you must triple your unit sales (i.e., increase unit sales 200%) to have the same gross profit dollars. Keep this in mind if you’re lowering prices to increase sales.

Need to know how to find gross margin? Here’s how to calculate gross margin in Excel

The examples above assume you know how to find gross margin. In case you don’t know how to find gross margin, here’s the calculation. If you sell a widget for $100, and you had to pay $60 for it, your “cost of goods” is 60%, “gross margin” is 40% and you produce $40 in “gross profit dollars.” This is usually just called “gross profit.”

a decrease in sales price changes gross margin using ExcelThe Excel formula for calculating gross profit is this: (Selling Price) – (Cost of Goods) / (Selling Price). In other words, subtract cost of goods from your selling price, which results in gross profit. Then divide gross profit by the selling price.

Here’s an example to calculate gross profit. Let’s say you sell a product for $125.95 and your cost is $83.00. That means you generate $42.45 in gross profit for each product sold. $125.95 – $83.00 = $42.95 gross profit. So, $42.95 / $125.95 = 0.341 = 34.1% gross margin.

I found the formula to calculate gross margin in Excel! #GrossMargin = (Revenue – Cost of Goods Sold) / Revenue Click To TweetAnother way to look at it is this gross margin formula: Gross Margin = (Revenue – Cost of Goods Sold) / Revenue.

Gross margin can be reported on a single unit, or it can be reported on for an entire company. Gross margin for a company would be that company’s total sales, minus cost of goods sold, and divided by the total company sales revenue. In this case gross margin is usually expressed as a percentage.

If you want to reach a specific gross margin and you know the cost, the Excel formula is: (Cost of Goods) / 1 – (Gross Margin %) = (Selling Price).

In other words, if you pay $60 for a widget and want a 40% gross margin, subtract 40% from 1 to get .6, so $60 / 0.6 = $100 selling price.

Here’s an example using the same numbers as above. Let’s say your cost on a product is $83.00 and you want to make a 34.1% gross margin. Subtract 0.341 from 1 to get .659, and $83.00 / .659 = $125.95.

Calculate gross margin or mark up?

I found the formula to calculate mark up! Markup Percentage = #GrossProfit Margin/Unit Cost Click To TweetNote that mark up and gross margin are two different things. “Mark up” defines how much you’re going to add on to a product cost to reach a selling price. “Gross margin” defines how much you make in gross profit at a specific selling price.

As an example of mark up, if your cost for a widget is $60 and you want to sell it for $100, it requires a mark up of 166.66%, or $60 x 166.66% = $60 x 1.6666 = $99.99999 (or simply $100).

For more information see our related article on the Turn/Earn Index.

How An Increase in Sale Price or Decrease in Sale Price Affects Gross Profit vs. Unit Sales was last modified: January 2nd, 2021 by admin

How useful was this post?

Click on a star to rate it!

Average rating 4.6 / 5. Vote count: 9

No votes so far! Be the first to rate this post.

Since you thought this post was useful...

Follow us on social media!

We are sorry that this post wasn't useful for you!

Let us improve this post!

Tell us how we can improve this post?

October 15, 2010/10 Comments/by admin
Tags: Analysis and Statistics, Auto Parts Marketing Strategy, gross profit, Inventory management, Retail Sales Trends
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
  • Share by Mail
10 replies
  1. Mushero says:
    December 16, 2011 at 11:26 pm

    It is actually a nice and useful piece of info. I am glad that you shared this useful information with us. Please keep us informed like this. Thank you for sharing.

  2. Carrol Patchin says:
    December 30, 2011 at 10:41 am

    Great post. I am facing a couple of these problems.

  3. Paneto says:
    January 6, 2012 at 6:46 pm

    My brother suggested I might like this website. He was once entirely right. This truly made my day. You can’t consider simply how a lot time I had spent for this information! Thank you!

  4. Webenvios says:
    January 7, 2012 at 12:20 pm

    whoah this blog is magnificent i like reading your posts. Keep up the good work! You know, lots of individuals are hunting around for this information, you could help them greatly.

  5. Deane Schnieders says:
    January 16, 2012 at 1:28 pm

    Hello. I mainly would like to make a short commentary and let you know that I’ve been reading your personal site for quite some time. Keep up the extraordinary task and I will be returning back again once again.

  6. mhansen says:
    July 12, 2012 at 3:20 pm

    Great info – do you have the equation that helped you derive the table.

    Also I wanted to point out that in the text above you said you would need to double your unit sales with a 30% profit margin and a 20% decrease. Wouldn’t it actually be tripling your unit sales since 200% is 3x your original amount (like a 100% increase is 2x your current amount)?

    • hedgesandcompany says:
      August 23, 2012 at 10:14 pm

      Thanks for pointing that out. We’ve updated the article.

  7. Malachi says:
    November 8, 2012 at 6:43 am

    Love your site. My thanks for writing that. I’ll come to this site to find out more and recommend this site to my coworkers

  8. Brian Heredia says:
    June 11, 2013 at 4:01 am

    Heya i am for the first time here. I came across this board and I find It truly useful & it helped me out a lot. I hope to give something back and help others like you aided me.

Trackbacks & Pingbacks

  1. Turn/Earn Calculation and GMROI to Manage Inventory | Hedges & Company Automotive Marketing and Market Research Blog says:
    November 22, 2011 at 3:54 pm

    […] related article: read about how price increases/decreases and unit sales affect gross profit. Share this:ShareEmailFacebookDiggTags: auto aftermarket industry, automotive aftermarket, […]

Comments are closed.

Hedges & Company blog

BLOG HOME

Driven by results.
Powered by knowledge.

Blog Categories

  • Aftermarket Analysis (129)
  • Market Research (105)
  • Marketing Articles (113)

Our Latest Articles

  • In With Audience Buying, Out With Media Buying. In With Audience Planning, Out With Media PlanningJanuary 21, 2021 - 4:25 pm
  • Automotive Email Marketing Trends 2021January 14, 2021 - 4:11 pm
  • What is Programmatic Marketing?December 18, 2020 - 2:00 pm

Location

Hedges & Company
5603 Darrow Road, Suite 100
Hudson OH 44236-5015
(234) 380-1650
Hours: 8:30am-5:00pm EST Mon.-Fri.
All company names, brand names, trademarks and logos are the property of their respective owners. BuyerZoom™ and BrandZoom™ are trademarks of Hedges & Company. Copyright 2021 Hedges & Company.

Our Services

  • Digital Marketing
  • Research
  • Mailing Lists
  • Email Services
  • Vehicle Recall Lists
  • In-Market Lists
  • Automotive Direct Mail Advertising

About Us

  • About Us
  • Our Team
  • Careers
  • Case Studies
  • News
  • Privacy & Legal

Our Blog

  • Blog Home Page
  • Aftermarket Trends & Analysis
  • Automotive Market Research
  • Aftermarket Marketing Articles
What is the Rule of Three in Marketing: Market Share and Market Dynamics gmroi turn earn Hedges & Company focuses on automotive market research. Stages of Business Growth: Learn the Growth Stages of a Company
Scroll to top
Fast Quote


    Search Engine Optimization (SEO) on Google or BingPaid Search (PPC) on Google or BingDisplay ads & banner adsEmail marketingGoogle ShoppingNot sure (You can describe what you need at the bottom of the page)


    Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now


    Not being managed, or not doing online marketingManaging in-houseOutside agency


    Having positive ROI: sales vs. budgetIncreasing traffic to my websiteIncreasing brand awarenessCompeting with Amazon or eBayOther (please explain below)


    $5,000 or less$5,000 to $7,500$7,500 to $10,000$10,000 or more

    This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

    Website Audit


      Website SEO AuditDigital Marketing Audit


      Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

      This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

      SEO Quote


        Base SEO PlanSEO Leader Plan


        Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

        This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

        Mailing List Quote


          Postal listEmail listOnline digital audience

          This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.

          Paid Search


            Google Shopping PlanBasic Paid Search PlaneCommerce LeaderNative or Programmatic Advertising


            Immediate! Please get back to me right awayWithin a month1 or 2 monthsJust gathering information for now

            This form uses Akismet, reCAPTCHA and this quiz to prevent spam and bot submissions.