Index lookup · WPU101704
Producer Price Index for hot rolled steel bars, plates, and structural shapes, a finished steel mill product produced by hot rolling, contrasted with cold finished or cold rolled products such as WPU101707 (Cold Rolled Steel Sheet and Strip). 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: December (-1.5% avg).
Structural steel fabrication and building frame contracts escalate against this series since beams and plate stock ship hot rolled. A contract that cites the cold rolled series instead would track a finishing cost the structural buyer never pays for.
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 — Hot Rolled Steel Bars, Plates, and Structural Shapes (BLS series WPU101704), 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("wpu101704") in Google Sheets →
Free. One email per new value, unsubscribe anytime, no account needed.
Compare the current value of BLS series WPU101704 (Hot Rolled Steel Bars, Plates, and Structural Shapes) to its value at contract signing, turn that into a ratio, and apply the ratio to the structural steel-affected line items. A usable clause also names an averaging window, a publication-lag rule, and a cap.
Read more →Escalake tracks US PPI — Hot Rolled Steel Bars, Plates, and Structural Shapes, 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.