# Commodity Index Price Adjustment Clause Calculator > Source: https://netray.co/tools/commodity-index-price-adjustment-clause-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Model how a raw material index change flows into the price of a purchased part under an index-linked clause with a dead band and partial pass-through. ## Category supply-chain ## Audience - Buyer - Commodity manager - Contract manager ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Contract unit price at base index **Key:** base_price **Type:** number **Default:** 18.5 **Min:** 0 **Step:** 0.1 **Unit:** $ #### Material share of the part price **Key:** material_share **Type:** slider **Default:** 45 **Min:** 0 **Max:** 100 **Step:** 1 **Unit:** % **Help:** Portion of the price that is the indexed raw material. #### Base index value **Key:** idx_base **Type:** number **Default:** 100 **Min:** 0 **Step:** 1 **Help:** Index level when the price was agreed. #### Current index value **Key:** idx_now **Type:** slider **Default:** 112 **Min:** 50 **Max:** 180 **Step:** 1 **Help:** Published index for the adjustment period. #### Share of material cost that is indexed **Key:** indexed_share **Type:** slider **Default:** 100 **Min:** 0 **Max:** 100 **Step:** 5 **Unit:** % **Help:** Some clauses index only part of the material cost. #### Dead band (no adjustment inside) **Key:** band_pct **Type:** number **Default:** 5 **Min:** 0 **Max:** 30 **Step:** 0.5 **Unit:** % **Help:** Index must move more than this before the price changes. #### Annual volume **Key:** volume **Type:** number **Default:** 40000 **Min:** 0 **Step:** 500 **Unit:** units **Outputs:** #### Index change **Key:** change_pct **Expr:** (idx_now / idx_base - 1) * 100 **Format:** percent #### Adjustment triggered (1 = yes) **Key:** applies **Expr:** if(gt(abs(change_pct), band_pct), 1, 0) **Format:** integer #### Price adjustment per unit **Key:** adj_unit **Expr:** base_price * material_share / 100 * change_pct / 100 * indexed_share / 100 * applies **Format:** currency **Primary:** true #### Adjusted unit price **Key:** new_price **Expr:** base_price + adj_unit **Format:** currency **Primary:** true #### Price change **Key:** adj_pct **Expr:** adj_unit / base_price * 100 **Format:** percent #### Annual cost impact **Key:** annual **Expr:** adj_unit * volume **Format:** currency **Chart:** #### Unit price adjustment vs current index **Type:** line **X:** idx_now **From:** 60 **To:** 160 **Steps:** 51 **Series:** - adj_unit **Disclaimer:** Illustrates a common structure only. Your contract may adjust on the excess beyond the band, use averages or lags, and cap increases. Follow the contract wording. ## Content **Intro:** Index-linked contracts move price with a published metal, resin or energy index. This calculator shows what a given index movement does to the price of one part under a dead band and a partial pass-through. **Sections:** #### How to use it **Body:** Enter the contract price, the share of that price that is the indexed material, and the base and current index values. Set the dead band, which is the move the index must exceed before any adjustment applies, and the share of the material that is indexed. The tool returns the index change, the adjusted unit price and the annual cost impact. Sweep the current index in the chart to see the full price curve, including the flat zone inside the band. #### The formula **Body:** Adjustment per unit equals base price times material share times the index change times the indexed share, applied only when the absolute change exceeds the band. A 45 percent material share on an 18.50 part means 8.33 of the price is exposed. A 12 percent index rise with a 5 percent band then adds about 1.00 per unit. Some clauses adjust only on the amount beyond the band, which would lower this figure. **Bullets:** - Exposed cost = price x material share - Index change = current / base - 1 - Adjustment triggers only outside the dead band - Annual impact = adjustment x volume #### Reading the result **Body:** The percent change in part price is always smaller than the index move because only part of the price is material. Use that ratio to decide whether to negotiate a narrower band, a cap, or a fixed-price period. Buyers dislike one-way clauses, so check that the same formula applies when the index falls. Compare the annual impact with the price premium a supplier would want for fixed pricing to see which is cheaper over a cycle. #### Common mistakes **Body:** Common errors are using the wrong index unit, such as dollars per tonne versus a cents per pound series, or mixing a lagged index with a spot price. Make sure the base index date matches the quote date. If the supplier buys in a different currency or region, a regional premium may matter more than the headline index. In ERPs, record the index and formula on the price agreement so the price update is traceable. **Cta:** If you want index-linked prices updated and checked against purchase orders in your ERP, Netray can build a controlled workflow with human approval. **Faq:** #### What is a dead band? **Answer:** A range around the base index inside which no price change occurs. It prevents constant small adjustments and shares the risk of minor volatility between buyer and supplier. #### Should the clause work both ways? **Answer:** Yes. A balanced clause adjusts down when the index falls, using the same formula. One-way clauses that only allow increases should be negotiated or priced accordingly. #### How often should prices adjust? **Answer:** Monthly or quarterly is common, often using an average of the prior period to reduce noise. Faster adjustment tracks cost more closely but adds administrative load. #### Which index should I choose? **Answer:** Pick a published index that matches what the supplier actually buys and that both sides can verify, such as an exchange or industry price series for the grade and region. ## Search terms commodity price adjustment calculator, index linked pricing clause, raw material surcharge calculator, metal price escalation clause, steel index price adjustment, aluminum surcharge calculator, material price pass through formula --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json