Index lookup · WPU101707
Producer Price Index for cold rolled steel sheet and strip, a narrower WPU product series than the WPU1017 steel mill products aggregate, tracking the finishing step that produces tighter tolerance, smoother surface steel than hot rolled stock. Index base: June 1982 = 100.
Latest value is 1 month old. Next update expected around Sep 2026.
Free, no account needed. Nothing you enter here leaves your browser.
Enter a base value, a current value, and a contract amount to see the adjustment.
Strongest average month-over-month move historically: April (+3.2% avg).
Automotive and appliance stamping supply agreements typically name this series rather than the broader steel mill products index, because cold rolled sheet carries a separate finishing premium over hot rolled that a blended index would understate.
A starting point citing this series by name and code. Replace the bracketed terms with your contract's actual scope before use.
The [affected portion] of the Contract Price shall be adjusted using US PPI — Cold Rolled Steel Sheet and Strip (BLS series WPU101707), published by BLS. Base Period: the index value published for August 2026 (or the month of contract signing, if different) is the Base Value. Adjustment: at each Adjustment Date, the Current Value is the most recently published three-month average of the index (the Averaging Window). The Escalation Factor equals Current Value divided by Base Value. Cap: the Escalation Factor applied under this clause shall not exceed 1.10 or fall below 0.90 (a 10% cap and floor) in any single Adjustment Date, regardless of the index's actual movement. [Replace bracketed terms with your contract's actual affected-portion definition and adjustment-date schedule before use. This is a drafting starting point, not legal advice.]
Want this in a spreadsheet instead? Use =ESCALAKE("wpu101707") in Google Sheets →
Free. One email per new value, unsubscribe anytime, no account needed.
Compare the current value of BLS series WPU101707 (Cold Rolled Steel Sheet and Strip) to its value at contract signing, turn that into a ratio, and apply the ratio to the cold rolled steel sheet-affected line items. A usable clause also names an averaging window, a publication-lag rule, and a cap.
Read more →Escalake tracks US PPI — Cold Rolled Steel Sheet and Strip, applies your formula, and gives both sides a number they can confirm, no spreadsheet required.
We use cookies to run Escalake and to understand site traffic. Choose Accept Minimum for essential cookies plus anonymous visit counting only, or Accept All to also let us link activity to your account. Read our Cookie Policy and Privacy Policy.