Costing & FinanceFree calculatorPDF, Excel, Word export

Supplier Price Increase Margin Impact Calculator

When a supplier announces a six percent increase, the real question is what it does to margin and what you must charge to stay whole. This calculator turns the increase into dollars, margin points and the customer price rise needed to hold your percentage.

Your numbers

$
32 %
$

Spend on items sold in the revenue above.

6 %
40 %

Portion of the added cost you can recover through price within the year.

Your results

Net gross profit lost
$64,800
New gross margin
30.4%
Added annual cost
$108,000
Recovered through price
$43,200
Margin points lost
1.559
Percentage points of gross margin.
Price rise needed to hold margin percent
3.2%
Average customer price increase that keeps gross margin percentage unchanged.

Assumes the supplier spend is fully inside the cost of goods sold of the stated revenue and that volumes do not change.

Save results:

New gross margin vs supplier increase

Sweeps Supplier price increase from 0 to 30, holding your other inputs fixed.

Price change impact by product in your ERP

Optional: discuss a read-only view that links supplier price updates to product margin.

Optional. The tool and every export work without this. No spam.

How to use it

Enter the annual revenue of the products that use this supplier's parts, your current gross margin, and the annual spend with the supplier on those products. Set the increase from the supplier's notice, then estimate what share you can pass on to customers within the year, based on contract clauses, index-linked pricing and your negotiating position. Read net profit lost first, then the price rise needed to hold margin percent.

  • Use spend that maps to the revenue you entered
  • Take the increase from the written notice, not a phone call
  • Be honest about pass-through: fixed-price contracts pass through zero
  • Run the chart to see sensitivity to larger increases

The math

Added cost is spend times the increase. Recovered revenue is added cost times the pass-through share. New gross profit is old gross profit minus added cost plus recovered revenue, and new revenue is old revenue plus recovered revenue. Dividing gives the new margin percentage. To hold the margin percentage exactly, price must rise by added cost divided by one minus margin, over revenue, which is larger than the cost increase itself because margin has to be earned on the extra cost too.

Using the result in a negotiation

In the default case, a 6 percent increase on $1.8M adds $108,000 of cost. With 40 percent recovered, the net loss is about $65,000 and margin falls by roughly one point. That figure is your walk-away benchmark: counter with an offer that costs the supplier less than the value of your volume, such as longer commitments, forecast sharing or a phased increase tied to a published index.

Common mistakes

People often compare the increase percentage to the margin percentage directly, which hides the dollar scale. Others forget that pass-through takes months, so the in-year recovery is less than the annual rate. Do not apply the rate to total revenue when only part of the product line uses this supplier. Update the model when you receive counter proposals, and keep a record of notices for audit and contract review.

Frequently Asked Questions

Why is the price rise to hold margin bigger than the cost increase?

Because margin percentage is a share of price. To keep the same share, the extra cost must be recovered plus the margin that would have been earned on it, so price rises by cost divided by one minus margin.

What is a realistic pass-through rate?

It depends on contracts. Index-linked or cost-plus customers can pass through most of an increase after a lag. Fixed-price or long-term agreements pass through little until renewal. Use your own contract terms, not a general average.

Should I include volume loss from higher prices?

This model keeps volume constant for clarity. If a price rise risks losing orders, run it again with lower revenue, or add the expected lost margin separately to the net hit.

Can I use it for freight or energy surcharges?

Yes. Enter the surcharge as an equivalent percent of annual spend. The math is the same for any supplier cost increase that flows into cost of goods sold.

Netray can help wire supplier price changes in your ERP to margin views by product, so impact is visible the day a new price is loaded.

Talk to an ExpertExplore More Free Tools

Related Tools

Supply Chain & Inventory

Supplier Total Cost of Ownership Comparison Calculator

Compares two suppliers on landed price plus the cost of rejects, and shows the reject rate at which the cheaper quote stops being cheaper.

Supply Chain & Inventory

Volume Discount Break-Even Order Quantity Calculator

Compares the annual cost at your normal EOQ with the cost of ordering at the supplier's price break quantity, so you know if the discount really pays.

Costing & Finance

Supplier Payment Terms Extension Cash Benefit Calculator

Shows the working capital released by moving a supplier from net 30 to net 60 or beyond, the value to you and the financing cost it pushes onto the supplier.

Quality & Inspection

Supplier Cost of Poor Quality Calculator

Turns a supplier's reject rate into an annual cost of poor quality, including handling, expedites and line-down time, with a what-if chart.

More Costing & Finance tools

See all
Back to All Tools