# Raw Material Index Price Adjustment Clause Calculator

> Source: https://netray.co/tools/raw-material-index-price-adjustment-clause-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Test an index-linked price clause with a deadband, partial pass through and a cap before you agree to it.

## Category

compliance-legal

## Industry

Discrete Manufacturing

## Audience

- Buyer
- Procurement
- Sales manager
- Contracts manager

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Base unit price

**Key:** base_price

**Type:** number

**Default:** 48

**Min:** 0

**Step:** 0.5

**Unit:** $

#### Index value at base date

**Key:** base_index

**Type:** number

**Default:** 100

**Min:** 0

**Step:** 1

**Help:** Use the published index level the contract names at the base date.

#### Index value at adjustment date

**Key:** cur_index

**Type:** slider

**Default:** 118

**Min:** 60

**Max:** 160

**Step:** 1

#### Material share of price

**Key:** mat_share

**Type:** number

**Default:** 40

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

**Help:** Only this part of the price moves with the index.

#### Pass through of the move

**Key:** pass_through

**Type:** number

**Default:** 100

**Min:** 0

**Max:** 100

**Step:** 5

**Unit:** %

**Help:** Share of the indexed change that is actually passed on.

#### Deadband either side

**Key:** deadband

**Type:** number

**Default:** 3

**Min:** 0

**Max:** 30

**Step:** 1

**Unit:** %

**Help:** Index moves inside this band cause no adjustment.

#### Cap on price change

**Key:** cap_pct

**Type:** number

**Default:** 12

**Min:** 0

**Max:** 100

**Step:** 1

**Unit:** %

#### Annual volume

**Key:** annual_volume

**Type:** number

**Default:** 20000

**Min:** 0

**Step:** 500

**Unit:** units

**Outputs:**

#### Index change

**Key:** chg

**Expr:** (cur_index / base_index - 1) * 100

**Format:** percent

#### Change beyond the deadband

**Key:** excess

**Expr:** if(gt(chg, 0), 1, -1) * max(abs(chg) - deadband, 0)

**Format:** percent

**Description:** Assumes the adjustment applies only to the move outside the band.

#### Price adjustment

**Key:** adj_pct

**Expr:** clamp(excess * mat_share / 100 * pass_through / 100, 0 - cap_pct, cap_pct)

**Format:** percent

#### Adjusted unit price

**Key:** new_price

**Expr:** base_price * (1 + adj_pct / 100)

**Format:** currency

**Primary:** true

#### Annual cost impact

**Key:** annual_impact

**Expr:** (new_price - base_price) * annual_volume

**Format:** currency

**Primary:** true

**Chart:**

#### Adjusted unit price vs index level

**Type:** line

**X:** cur_index

**From:** 60

**To:** 160

**Steps:** 50

**Series:**

- new_price

**Disclaimer:** Clause mechanics vary. Some contracts apply the full change once the deadband is breached, use averaged index periods or lag the index by a month. Model the wording you actually have.

## Content

**Intro:** Index clauses are how most metal, resin and electronics contracts handle commodity swings. This calculator lets you vary the deadband, pass through and cap and see exactly what the clause does to unit price.

**Sections:**

#### How to use the calculator

**Body:** Enter the base price and the index level at the base date, then the level at the adjustment date. Set the share of price that is material, the pass through percentage, the deadband and the cap. The tool returns the adjusted price and the annual cost impact. Slide the current index up and down to see how a clause behaves in a spike and in a fall, because many clauses are written symmetrically but negotiated asymmetrically.

**Bullets:**

- Use the published index named in the contract and its exact base period.
- Set material share from your cost breakdown, not a rule of thumb.
- Test both a spike and a drop before agreeing to a cap.

#### The formula

**Body:** Index change equals current index divided by base index minus one. The excess beyond the deadband keeps the sign of the change and removes the band. The price adjustment equals the excess times the material share times the pass through, limited to the cap in both directions. The adjusted price equals base price times one plus the adjustment. This version applies the adjustment only to the move beyond the band; some contracts apply the whole move once the band is crossed.

#### Reading the result

**Body:** A deadband protects both sides from noise but delays adjustment in a steady drift. A cap protects the buyer in a spike but leaves the supplier with margin risk, which is why suppliers often ask for a shorter reset period instead. Compare the annual impact at a plausible high and a plausible low to see whether the clause is balanced. Also check whether index data is published in the same currency and unit as the part is priced.

#### Common mistakes

**Body:** The most common error is applying the index change to the whole price rather than the material share. Another is using a spot index when the supplier buys on contract with a lag, which causes disputes. Keep the index, base date and share in the item or contract record in your ERP, and apply the adjustment through a controlled price change rather than invoice by invoice.

**Cta:** If index adjustments are applied by hand across hundreds of part numbers, we can help automate the calculation and flag proposed price changes for approval in your ERP.

**Faq:**

#### What is a deadband in a price clause?

**Answer:** A deadband is a range around the base index inside which no adjustment occurs. It avoids frequent small price changes. Some clauses ignore the band once it is breached, others adjust only beyond it.

#### Which index should the contract use?

**Answer:** Use a published, independent index that matches the actual material grade and region as closely as possible, with a stated source, unit and currency. Mismatched indices are a frequent cause of disputes.

#### Should price adjust both up and down?

**Answer:** Balanced contracts adjust in both directions. If you accept upward adjustments, ask for the downward mirror, or at least a cap and a review date. Check how the clause is worded for decreases.

#### How often should the index be reset?

**Answer:** Monthly or quarterly resets are common. Shorter periods track the market closely but add administration. Choose a period close to the supplier's actual purchasing cycle.

## Search terms

price adjustment clause calculator, raw material index clause, metal surcharge calculator, index linked pricing contract, price escalation clause deadband, steel price pass through calculator, commodity index price adjustment

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