Compliance & ContractsFree calculatorPDF, Excel, Word exportDiscrete Manufacturing

Raw Material Index Price Adjustment Clause Calculator

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.

Your numbers

$

Use the published index level the contract names at the base date.

118
%

Only this part of the price moves with the index.

%

Share of the indexed change that is actually passed on.

%

Index moves inside this band cause no adjustment.

%
units

Your results

Adjusted unit price
$51
Annual cost impact
$57,600
Index change
18%
Change beyond the deadband
15%
Assumes the adjustment applies only to the move outside the band.
Price adjustment
6%

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.

Save results:

Adjusted unit price vs index level

Sweeps Index value at adjustment date from 60 to 160, holding your other inputs fixed.

Index driven price updates in your ERP

Optional: see how index adjustments can be proposed and approved from your ERP price data.

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

How to use the calculator

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.

  • 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

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

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

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.

Frequently Asked Questions

What is a deadband in a price clause?

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?

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?

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?

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.

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.