How do you calculate a cold rolled steel sheet price escalation clause using the PPI?
Divide the current value of BLS series WPU101707 (Cold Rolled Steel Sheet and Strip) by its value at contract signing, then apply that ratio to the cold rolled steel sheet part of the price. Over the 12 months to September 2026 the ratio was 1.369. A usable clause also names an averaging window, a rule for revised values and missing months, and a cap.
A cold rolled steel sheet escalation clause indexes the portion of the contract price tied to cold rolled steel sheet to a published series instead of fixing it at signing. The benchmark is the BLS producer price index for Cold Rolled Steel Sheet and Strip, series WPU101707.
Cold rolled steel sheet is a real input cost in automotive stamping, appliance manufacturing, and HVAC ductwork work. Its price can move further over a contract term than a fixed-price contingency is built to absorb, so indexing it moves that risk onto the published series instead of onto one party.
What's specific to cold rolled steel sheet
Cold rolled sheet is hot rolled coil that has been processed further, so the price carries a processing margin on top of the hot rolled price. A clause tied to a hot rolled or general steel series misses that margin.
Cold Rolled Steel Sheet and Strip against the hot rolled steel price index, both set to 100 in the first month they share
Sep 2026WPU101707 234Hot rolled steel price index 186
Sources: WPU101707 (Cold Rolled Steel Sheet and Strip); BLS WPU101704.
Since 2017, this index has followed the hot rolled steel price index in the same month and moved further than it over a year.
Over the 12 months to Sep 2026, the hot rolled steel price index rose 15.0% and this index rose 36.9%.
Same month
Lag behind the hot rolled steel price index. Monthly changes line up best in the same month.
−53.0% to +256.5%
Range of 12-month changes since 2017.
46%
Share of months that moved more than 3%. The median month moved 2.65%.
Over the period the cold rolled index has moved by more than hot rolled in the same direction. A hot rolled clause would under-recover in a rising market.
The calculation, step by step
Base index value. The index value at the base period, usually the month of contract signing or bid submission.
Current index value. The index value at the adjustment date, usually the month of delivery or invoicing.
Ratio. Current value divided by base value.
Adjustment. Apply the ratio to the portion of the contract price tied to cold rolled steel sheet only.
Take a contract signed in September 2025 with $260,000 of cold rolled steel sheet scope, invoiced in September 2026.
Base index, Sep 2025
359.641
Current index, Sep 2026 (revisable)
492.454
Ratio, 492.454 ÷ 359.641
1.3693
Amount at signing
$260,000
Adjustment added to that amount
+$96,016
Live figures from the stored series, updated when the provider publishes. Sep 2026 can still be revised, so a clause should say whether the invoice uses the first published value or is trued up later.
Where clauses go wrong
BLS publishes other series a cold rolled steel sheet clause could be read against, and they do not move together. A clause that only says "the cold rolled steel sheet index" leaves the two sides to pick different ones.
Over the 12 months to Sep 2026, these series moved differently. On the same $260,000, the gap between the highest and lowest is $56,971.
Write the series code, WPU101707, into the contract text, with the BLS title next to it.
No rule for revised valuesBLS can revise each value for 4 months after it is first published. Right now that covers Jun 2026 to Sep 2026. Say whether the first published value is final for invoicing, or whether invoices are trued up once BLS revises it.
Divide the current value of BLS series WPU101705 (Steel Wire) by its value at contract signing, then apply that ratio to the steel wire part of the price. A usable clause also names an averaging window, a rule for revised values and missing months, and a cap.
PPI measures what producers receive for an input, close to the actual production cost of a purchased material or component. CPI measures what consumers pay at retail, which layers on distribution and retail markup that has nothing to do with the underlying production cost of the input. Most B2B materials and component contracts should index PPI. CPI fits labor-adjacent cost-of-living escalators and consumer-facing service contracts.
A prospective adjustment applies the new price only to work done after the adjustment date. A retroactive adjustment reaches back and reprices work already invoiced. Retroactive is fairer when publication lag is long, but harder to administer, because it means correcting invoices already sent.