How to Calculate the Impact of a Supplier Price Increase on Gross Margin

A supplier sends a perfectly polite email announcing a 10% price increase. Naturally, everyone is delighted.

Purchasing wants to negotiate. Sales wants to know whether customers will notice. The business owner wants to know how much money this is going to cost. And somewhere in the conversation, someone suggests raising selling prices by 10% because that seems fair.

I understand the instinct. If our supplier raises prices by 10%, why shouldn’t we? Well, because the supplier’s price isn’t necessarily our entire cost. And our cost isn’t our selling price. And customers, inconveniently, are not required to appreciate the mathematical elegance of our pricing decisions.

Before changing prices, I’d want to calculate three things: how much the supplier increase actually costs us, what it does to gross margin, and whether the proposed response leaves us financially better off. That third question is where this gets interesting.

How to Calculate the Impact of a Supplier Price Increase

The basic calculation is straightforward:

Additional cost per unit = Affected supplier cost per unit × Supplier price increase percentage

Then:

Total additional cost = Additional cost per unit × Expected affected units

For example, suppose a supplier increases the price of a component from $30 to $33. That’s a 10% increase, or $3 per unit. If we expect to sell 1,000 finished products using one component each, our additional cost is $3,000. That’s the starting point. Not the conclusion.

I would also verify when the increase takes effect, whether it applies to existing purchase orders, and whether we have inventory purchased at the old price. Otherwise, we could end up forecasting the correct cost increase in the wrong month, which is a surprisingly efficient way to create confusion.

And I wouldn’t assume every supplier cost increase belongs entirely in cost of goods sold. The accounting treatment depends on what we’re purchasing and when the cost is recognized. For this example, we’re looking at a component included in the cost of products sold.

The 10% Supplier Increase That Doesn’t Increase Our Total Costs by 10%

Let’s imagine a hypothetical U.S. company selling a product for $100. Its current unit economics look like this:

Item	Amount per unit
Selling price	$100
Affected supplier component	$30
Other product costs	$30
Total cost of goods sold	$60
Gross profit	$40
Gross margin	40%

Our supplier raises the component price by 10%. The component now costs $33, increasing total product cost from $60 to $63. If we leave our selling price at $100, gross profit falls from $40 to $37 per unit. And gross margin falls from 40% to 37%.

Notice what didn’t happen. Our total product cost didn’t increase by 10%. It increased by 5%, from $60 to $63. The supplier’s increase applied to one component, not every dollar of our cost structure.

That distinction matters. A business that responds to every supplier announcement by applying the same percentage to its entire selling price may be making pricing decisions without understanding what actually changed. As any mom can tell you, just because one child needs new shoes doesn’t mean we’re replacing everyone’s entire wardrobe. Although I’m sure someone would be happy to make that argument.

Gross Margin Percentage and Gross Profit Dollars Are Two Different Decisions

Here’s where I often want the conversation to become more specific. When someone says, “We need to protect our margin,” what exactly are we protecting? Our gross profit dollars per unit? Our gross margin percentage? Our total gross profit for the month? Those are three different objectives. They can lead to three different pricing decisions.

Let’s use our $100 product with its new $63 cost.

Option 1: Keep the selling price at $100

At $100, we earn $37 per unit. Our gross margin is:

($100 − $63) ÷ $100 = 37%

If we sell 1,000 units, total gross profit is $37,000. Before the supplier increase, those same 1,000 units generated $40,000. So we’re giving up $3,000 in monthly gross profit, assuming volume and every other cost remain unchanged.

Option 2: Raise the price to $103

If we increase our selling price by $3, we recover the additional component cost dollar for dollar. Gross profit per unit returns to $40. But our gross margin percentage is now:

($103 − $63) ÷ $103 = 38.83%

We’re earning the same $40 per unit, but that profit represents a smaller percentage of the new selling price. There’s nothing inherently wrong with that. If the business cares primarily about preserving contribution dollars and the additional price doesn’t reduce sales volume, this may be a perfectly reasonable option. We just need to stop calling it preservation of the original 40% gross margin. It isn’t.

Option 3: Raise the price to $105

To preserve our original 40% gross margin, we use:

Required selling price = New unit cost ÷ (1 − Target gross margin)

So: $63 ÷ (1 − 0.40) = $105

At $105, gross profit is $42 per unit, which is exactly 40% of the selling price. In this particular example, the required selling-price increase is 5%, not 10%. We now have three financially different options.

Pricing decision	Selling price	Gross profit per unit	Gross margin
Absorb the supplier increase	$100	$37	37.00%
Preserve gross profit dollars per unit	$103	$40	38.83%
Preserve the original gross margin percentage	$105	$42	40.00%

These calculations assume our stated $63 unit cost includes all relevant costs for the gross-margin measure we’re using. They don’t include income taxes, operating expenses, or other costs below gross profit.

For a related pricing decision, I’ve also explained how to calculate whether a sales discount is worth it. Different direction, same underlying question: what happens to the economics when we change the price?

The Pricing Decision Looks Different When Customers Buy Less

Here’s the part I wouldn’t leave out of the management discussion. We can calculate the selling price required to preserve our margin percentage. Excel will do that quite happily. What Excel cannot promise is that customers will continue buying the same number of units at the higher price.

Let’s assume the company previously sold 1,000 units per month. Before the supplier increase, total gross profit was: 1,000 × $40 = $40,000.

Now suppose we raise the selling price to $105 to preserve our 40% gross margin. But monthly volume falls to 950 units. Our gross profit becomes: 950 × $42 = $39,900.

We successfully preserved the gross margin percentage. And earned $100 less gross profit. I can already imagine the presentation. A beautiful green arrow beside the margin percentage, followed by an uncomfortable silence when someone asks why gross profit dollars went down.

This isn’t an argument against raising prices. It’s an argument for understanding what we’re trying to accomplish. The percentage alone doesn’t tell us whether the decision worked.

How Much Sales Volume Can We Lose Before the Price Increase Stops Helping?

This is the calculation I’d put in front of management. We want to know how many units we need to sell at the new price to generate the same $40,000 of monthly gross profit we earned before the supplier increase.

Required units = Original total gross profit ÷ New gross profit per unit

At a $105 selling price: $40,000 ÷ $42 = 952.38 units. Since we sell whole units, we’d need at least 953 units to match or exceed the original $40,000 gross profit. That means we could lose up to 47 units from the original 1,000 and still meet the target. In percentage terms, the maximum whole-unit decline is 4.7%.

Monthly units sold at $105	Total gross profit	Difference vs. original $40,000
1,000	$42,000	+$2,000
975	$40,950	+$950
953	$40,026	+$26
950	$39,900	−$100
900	$37,800	−$2,200

Now we have something useful to discuss with Sales. Do we think a 5% price increase will reduce demand by more than roughly 4.7%? What evidence supports that expectation? Are customers locked into annual agreements? Are competing products readily available? Do some customers care more about service, reliability, or delivery times than a modest price difference?

I’d much rather hear a thoughtful answer to those questions than be told that the market should understand why we’re raising prices. The market has never shown much interest in attending our budget meetings.

Don’t Confuse the Customer Price Increase With the Supplier Cost Increase

There’s another subtle point worth making. A supplier increase of 10% does not automatically justify a 10% customer price increase. In our example, the supplier’s increase adds $3 to a product that sells for $100. A 10% customer price increase would move the selling price to $110.

At the new $63 unit cost, gross profit would become $47 per unit and gross margin would rise to approximately 42.73%. That’s higher than our original margin. Maybe the market supports $110. Maybe the product has been underpriced for years. Maybe we’ve improved its value and should charge more. Those are legitimate possibilities.

But I wouldn’t present a 10% customer price increase as mathematically necessary just because the supplier increased one component by 10%. It isn’t. And if we use a supplier notice to justify a larger commercial pricing decision, we should be prepared to explain the broader reasoning.

For a more complete look at the revenue side of pricing, see my article on price, volume, and mix analysis.

What I Would Check Before Approving a Price Increase

The math gives us a starting point. The decision still needs a little adult supervision.

First, I’d verify the actual affected cost. Does the supplier increase apply to every unit we buy, or only certain products, sizes, locations, or order quantities? Are freight charges, rebates, or purchasing discounts changing too?

Second, I’d look at the effective date. A price increase starting next quarter may affect products sold later than the purchase date, depending on inventory turnover and costing methods. We shouldn’t assume the accounting impact and cash payment happen simultaneously.

Third, I’d look at customer contracts. Some agreements allow price adjustments. Others require notice, negotiation, or a renewal date. An attractive pricing scenario isn’t much use if we can’t legally or commercially implement it.

Fourth, I’d separate customer segments. A 5% increase might barely affect one group while sending another directly to a competitor. Applying the same pricing assumption across the entire customer base can hide more than it reveals.

Finally, I’d check whether the business can reduce the cost another way. Different order quantities, alternative suppliers, product redesign, purchasing terms, or reduced waste may improve the economics without asking customers to absorb the entire increase.

None of these alternatives is automatically better. Each has its own costs, risks, and practical limitations. That’s why I’d evaluate them rather than assuming the answer must be a price increase.

A Simple Supplier Price Increase Analysis You Can Build in Excel

For a small number of products, you don’t need a particularly elaborate model. I’d begin with one row per product and use these columns:

Column	What to enter or calculate
A	Product
B	Current selling price
C	Current unit cost
D	Affected supplier cost per unit
E	Supplier increase percentage
F	New unit cost
G	Current gross margin
H	Gross margin if selling price stays unchanged
I	Selling price that preserves original gross profit per unit
J	Selling price that preserves original gross margin percentage
K	Forecast monthly unit volume

Assuming row 2 contains the first product, these are the core formulas:

New unit cost (F2): =C2+D2*E2

Current gross margin (G2): =(B2-C2)/B2

New gross margin at unchanged selling price (H2): =(B2-F2)/B2

Price to preserve gross profit dollars per unit (I2): =B2+(F2-C2)

Price to preserve gross margin percentage (J2): =F2/(1-G2)

These formulas assume a positive selling price, a valid margin below 100%, and that the supplier increase affects only the cost entered in column D. Enter the increase in E as a percentage, such as 10%, not the number 10.

For an actual business model, I’d add the effective date, customer pricing restrictions, inventory timing, volume scenarios, and a clear flag for products where the proposed selling price is below cost.

I would also distinguish gross margin from contribution margin. Gross margin uses the costs classified as cost of goods sold. Contribution margin subtracts the variable costs associated with a sale, which may include additional selling or fulfillment costs. The distinction can matter enormously when we’re evaluating whether more or fewer units will improve profit.

And I’d test the formulas before distributing the workbook. I have no interest in discovering during a pricing meeting that a 10% increase was entered as 10 and the model is now suggesting we charge $1,000 for something that sold yesterday for $100. That would certainly improve the theoretical margin. The customer reaction might be less enthusiastic.

Sometimes Absorbing a Supplier Increase Is the Right Decision

I don’t believe every cost increase needs to be passed through immediately. Suppose the supplier increase is temporary, the product is highly price-sensitive, and raising prices would put a valuable customer relationship at risk. Absorbing some of the increase may be reasonable.

But I’d want management to understand the cost of that choice. In our example, keeping the selling price at $100 reduces gross profit by $3 per unit. At 1,000 units a month, that’s $3,000 of monthly gross profit. If the higher supplier cost remains in effect for 12 months at the same sales volume, the illustrative annual impact is $36,000.

That’s not automatically a bad decision. It might be a worthwhile investment in customer retention or market position. But it should be recognized as a decision, with an expected benefit and a point at which we reconsider it.

The trouble starts when nobody makes the decision explicitly. Prices stay unchanged, costs rise, and three months later Finance is asked why margins have deteriorated. Well, I have a theory.

When the Problem Is Bigger Than One Supplier

For a company with hundreds of products, multiple vendors, negotiated customer contracts, and different inventory cycles, a simple per-unit calculation won’t be enough. I’d want to see which supplier increases have the greatest dollar impact, which customers or products are exposed, and how quickly the changes flow through the income statement and cash forecast.

Then I’d build scenarios around the available responses. One scenario might absorb the increase. Another might raise selected prices. A third could combine supplier negotiation, selective price adjustments, and changes to purchasing volume.

I’d compare gross profit, operating profit where relevant, cash requirements, and customer-volume assumptions. The right answer may be different across products and customer groups.

This is where driver-based forecasting becomes especially useful. We can connect supplier costs, selling prices, and expected unit volume rather than treating the entire business as one percentage. And if the current forecast can’t show those relationships, I would be interested in fixing that before the next supplier email arrives.

The Number I Want Before Anyone Changes a Price

A supplier’s 10% increase tells me what changed in the supplier’s pricing. It doesn’t tell me what our customer prices should be. For that, I need to know which costs are affected, how much gross profit we’re trying to protect, what customers might do, and whether we have better alternatives.

In our example, the same supplier increase gave us three possible selling prices: $100, $103, and $105. Each produced a different financial outcome. None was automatically the correct business decision.

That’s the distinction I want management to understand. Finance shouldn’t simply calculate the number that makes the margin percentage look better. We should help the business decide which tradeoff is worth making.

If supplier increases keep catching your forecast by surprise, or you’re making pricing decisions without a clear view of their financial impact, my Forecasting & Planning services may be a useful place to start.

I’m quite happy to help sort out the numbers before everyone starts changing price lists. It tends to be easier than explaining the results afterward.