Skip to content
Skip to content

Learn

How do you calculate a steel pipe price escalation clause using the PPI?

Divide the current value of BLS series WPU101706 (Steel Pipe and Tube) by its value at contract signing, then apply that ratio to the steel pipe part of the price. Over the 12 months to September 2026 the ratio was 1.132. A usable clause also names an averaging window, a rule for revised values and missing months, and a cap.

Latest · WPU101706
431.717
Sep 2026Revisable
Year on year
+13.2%
from 381.298
5 years
−1.5%
from Sep 2021
Peak
508.736
Jun 2022 · full history

The mechanism

A steel pipe escalation clause indexes the portion of the contract price tied to steel pipe to a published series instead of fixing it at signing. The benchmark is the BLS producer price index for Steel Pipe and Tube, series WPU101706.

Steel pipe is a real input cost in oil and gas gathering, plumbing and mechanical, and structural fabrication 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 steel pipe

This one series covers steel pipe and tube across several uses, from oilfield casing to plumbing and mechanical tube. Those uses have different demand cycles and can face different trade actions. A clause for energy-sector pipe may need a more specific benchmark next to this one.

Steel Pipe and Tube against the hot rolled steel price index, both set to 100 in the first month they share
Sep 2026WPU101706 188Hot rolled steel price index 186
10015020020182020202220242026

Sources: WPU101706 (Steel Pipe and Tube); 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 13.2%.

Same month
Lag behind the hot rolled steel price index. Monthly changes line up best in the same month.
−22.4% to +79.8%
Range of 12-month changes since 2017.
19%
Share of months that moved more than 3%. The median month moved 1.21%.

Pipe is made from hot rolled steel, and the index follows that mill series closely. A clause can treat a mill steel move as the main signal for this index.

The calculation, step by step

  1. Base index value. The index value at the base period, usually the month of contract signing or bid submission.
  2. Current index value. The index value at the adjustment date, usually the month of delivery or invoicing.
  3. Ratio. Current value divided by base value.
  4. Adjustment. Apply the ratio to the portion of the contract price tied to steel pipe only.

Take a contract signed in September 2025 with $500,000 of steel pipe scope, invoiced in September 2026.

Base index, Sep 2025381.298
Current index, Sep 2026 (revisable)431.717
Ratio, 431.717 ÷ 381.2981.1322
Amount at signing$500,000
Adjustment added to that amount+$66,115

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 steel pipe clause could be read against, and they do not move together. A clause that only says "the steel pipe index" leaves the two sides to pick different ones.

Over the 12 months to Sep 2026, these series moved differently. On the same $500,000, the gap between the highest and lowest is $99,627.

SeriesWhat it covers12 monthsOn $500,000
WPU101706Steel Pipe and Tube+13.2%+$66,115
WPU1017Steel Mill Products+27.6%+$137,897
WPU10170674Steel Pipe and Tube, Stainless Steel+7.7%+$38,270

Write the series code, WPU101706, 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.

The other gaps are the same as for any indexed input: no averaging window and no cap or floor.

Run this on your own numbers

Price history

Sep 2026 · latest431.717−1.5%since Sep 2021
30035040045050055020222023202420252026431.7
Move along the line to read any month

Track your contract

Pick the signing month and amount to see today's adjusted price.

Saved in this browser only. Come back after the next print to see what changed.

Related reading

What does publication lag mean for a price escalation clause?

Publication lag is the gap between the period an index measures and the date the statistics agency releases that number. BLS PPI data typically publishes within about two weeks of month end, commonly ten to fifteen days. If a clause does not name which release to use, both sides can end up applying different numbers on the same adjustment date.

Read more →

See this calculated automatically

Escalake tracks the index, applies the formula, and gives both sides a number they can confirm, no spreadsheet required.