# Supplier Price Increase Margin Impact Calculator

> Source: https://netray.co/tools/supplier-price-increase-margin-impact-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Quantifies the margin hit from a supplier price increase and the customer price rise needed to hold your gross margin percentage.

## Category

cost-finance

## Audience

- Buyer
- Finance controller
- Sourcing manager

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual revenue on affected products

**Key:** revenue

**Type:** number

**Default:** 5000000

**Min:** 0

**Step:** 100000

**Unit:** $

#### Current gross margin

**Key:** gm_pct

**Type:** slider

**Default:** 32

**Min:** 1

**Max:** 80

**Step:** 0.5

**Unit:** %

#### Annual spend with this supplier

**Key:** spend

**Type:** number

**Default:** 1800000

**Min:** 0

**Step:** 50000

**Unit:** $

**Help:** Spend on items sold in the revenue above.

#### Supplier price increase

**Key:** increase_pct

**Type:** slider

**Default:** 6

**Min:** 0

**Max:** 30

**Step:** 0.5

**Unit:** %

#### Share passed through to customers

**Key:** pass_pct

**Type:** slider

**Default:** 40

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

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

**Outputs:**

#### Added annual cost

**Key:** added_cost

**Expr:** spend * increase_pct / 100

**Format:** currency

#### Recovered through price

**Key:** recovered

**Expr:** added_cost * pass_pct / 100

**Format:** currency

#### Net gross profit lost

**Key:** net_hit

**Expr:** added_cost - recovered

**Format:** currency

**Primary:** true

#### New gross margin

**Key:** new_gm

**Expr:** (revenue * gm_pct / 100 - added_cost + recovered) / (revenue + recovered) * 100

**Format:** percent

**Primary:** true

#### Margin points lost

**Key:** points_lost

**Expr:** gm_pct - new_gm

**Format:** decimal

**Description:** Percentage points of gross margin.

#### Price rise needed to hold margin percent

**Key:** hold_pct

**Expr:** added_cost / (1 - gm_pct / 100) / revenue * 100

**Format:** percent

**Description:** Average customer price increase that keeps gross margin percentage unchanged.

**Chart:**

#### New gross margin vs supplier increase

**Type:** line

**X:** increase_pct

**From:** 0

**To:** 30

**Steps:** 30

**Series:**

- new_gm

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

## Content

**Intro:** 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.

**Sections:**

#### How to use it

**Body:** 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.

**Bullets:**

- 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

**Body:** 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

**Body:** 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

**Body:** 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.

**Cta:** 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.

**Faq:**

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

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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.

## Search terms

supplier price increase impact calculator, price increase pass through calculator, gross margin impact supplier increase, how to respond to supplier price increase, cost increase pass-through formula, price increase negotiation calculator, material cost increase margin, supplier surcharge impact

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json