# Supplier Price Increase Impact Calculator

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

## Short answer

Sizes the annual cost of a requested price increase and compares it with the increase justified by a material index.

## Category

cost-finance

## Audience

- Buyer
- Category manager
- Cost analyst

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual quantity

**Key:** annual_qty

**Type:** number

**Default:** 24000

**Min:** 0

**Step:** 500

**Unit:** units

#### Current unit price

**Key:** current_price

**Type:** number

**Default:** 12.5

**Min:** 0

**Step:** 0.1

**Unit:** per unit

#### Increase requested

**Key:** request_pct

**Type:** slider

**Default:** 9

**Min:** 0

**Max:** 30

**Step:** 0.5

**Unit:** %

#### Material share of price

**Key:** material_share

**Type:** slider

**Default:** 45

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

**Help:** Portion of the unit price that is the indexed raw material

#### Index change since last price

**Key:** index_change

**Type:** number

**Default:** 6

**Min:** -50

**Max:** 100

**Step:** 0.5

**Unit:** %

**Help:** Change in the published material index

**Outputs:**

#### Requested new price

**Key:** new_price

**Expr:** current_price * (1 + request_pct / 100)

**Format:** currency

#### Annual cost of requested rise

**Key:** requested_cost

**Expr:** annual_qty * current_price * request_pct / 100

**Format:** currency

**Primary:** true

#### Index-justified increase

**Key:** justified_pct

**Expr:** material_share * index_change / 100

**Format:** percent

**Description:** Material share multiplied by the index change

#### Annual cost of justified rise

**Key:** justified_cost

**Expr:** annual_qty * current_price * justified_pct / 100

**Format:** currency

#### Negotiation gap per year

**Key:** gap

**Expr:** requested_cost - justified_cost

**Format:** currency

**Primary:** true

#### Counter price on index basis

**Key:** counter_price

**Expr:** current_price * (1 + justified_pct / 100)

**Format:** currency

**Chart:**

#### Annual cost by requested increase

**Type:** line

**X:** request_pct

**From:** 0

**To:** 30

**Steps:** 30

**Series:**

- requested_cost
- justified_cost

**Disclaimer:** The index formula covers material only. Labor, energy and freight changes may also be legitimate; ask the supplier for a cost breakdown and test each element.

## Content

**Intro:** A supplier asks for nine percent. Is that fair? This calculator sizes the cost of the request and compares it with the increase justified by the material index, so you enter the conversation with a number.

**Sections:**

#### How to use it

**Body:** Enter your annual quantity and current unit price, the increase requested, the share of the price that is the indexed raw material and the change in the published index since the last price was set. The calculator returns the cost of the request, the justified increase, the gap and a counter price. The chart shows the annual cost across a range of requested percentages.

#### The formula behind it

**Body:** The justified increase equals material share times index change. If material is 45 percent of the price and the index rose 6 percent, the price should rise about 2.7 percent, not 6 and not 9. The annual cost is quantity times current price times the percent. This is the standard approach in index-linked contracts for metals, resins and similar commodities.

**Bullets:**

- Justified % = material share x index change
- Annual cost = quantity x price x percent
- Gap = requested cost - justified cost

#### Reading the gap

**Body:** The gap is the annual value in dispute. If it is small, accept and move on. If it is large, ask for the cost breakdown behind the other elements. Remember that an index can fall as well as rise: build a symmetrical formula into the contract so you receive reductions too.

#### Common mistakes

**Body:** Using the headline index instead of the one that matches the supplier's grade and region, applying the index change to the whole price, ignoring the lag between index and purchase date and forgetting that the supplier may have bought material earlier at a different price. Agree the index, the base date and the lag in writing.

**Cta:** Netray can calculate the exposure across all open and forecast purchases from your ERP, so you see the full impact of each request.

**Faq:**

#### What is a material index clause?

**Answer:** A contract term that adjusts the price by a formula tied to a published index, usually for a stated material share, with a base date, a review interval and often a collar so small moves do not trigger changes.

#### Should material share be based on weight or cost?

**Answer:** Use the share of the price that is the raw material, ideally taken from a supplier cost breakdown. Part weight times material price per kilogram gives a good starting estimate.

#### What if the supplier's cost rose for other reasons?

**Answer:** Ask for evidence per element: labor, energy, freight, overhead. Accept what is documented and reasonable, and consider offsetting with volume, term or process improvements.

#### Does this work for services?

**Answer:** Partly. Replace the material index with a labor or wage index and the material share with the labor share of the price.

## Search terms

supplier price increase calculator, price increase impact calculator, index based price adjustment calculator, justified price increase, material surcharge calculator, price escalation calculator, negotiate supplier price increase

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