Material price escalation clause calculator
Shows how much a price escalation clause adds to or takes off a contract when the agreed material index moves between the bid date and delivery.
Material price escalation clause calculator: run the calculator
Escalation clause calculator
Escalation result
Adjusted contract value $253,978.33
The clause adds $3,978.33 to the amount you invoice.
- Material value in the bid: $250,000.00 × 40% = $100,000.00.
- Index ratio: 281.6 ÷ 258.4 = 1.08978, a price change of +8.98%.
- Full change in material cost: $100,000.00 × +8.98% = +$8,978.33.
- Threshold: the contractor carries the first 5%, which leaves +3.98% to settle.
- Adjustment: $100,000.00 × +3.98% = +$3,978.33.
The escalation formula
- Price change = index at delivery ÷ index at the bid date − 1
- Material value = covered contract value × material share
- Full change = material value × price change
- Threshold clause: adjustment = material value × (price change − threshold), counted above the threshold only
- Formblatt 225: deductible = the larger of the agreed share of the change and the de minimis limit; adjustment = change − deductible, once the change passes that limit
- Fixed-part formula: revised price = contract value × (fixed part + revisable part × index at revision ÷ index at month zero)
Set the threshold to zero and the result shows the untrimmed index effect, which is what a clause without any deductible pays out.
Material price escalation clause calculator: what it answers
A price escalation clause turns an index reading into money. You bid steel, copper or asphalt at one index level, the mill invoices at another, and the contract decides who carries the gap. Type in the contract value the clause covers, the material share sitting inside that value, and the two index readings, and the result is the adjustment your own wording produces, including the slice the threshold leaves with you rather than the owner.
Three contract shapes turn up in practice and they do not agree, so all three are here as options. A US escalation amendment such as ConsensusDocs 200.1 fixes a trigger percentage and reimburses what lies above it. German federal work follows Formblatt 225, where a de minimis limit and a contractor deductible both bite. French public works revise the whole price through a coefficient built from a fixed part and an index ratio.
Material price escalation clause calculator: how the result is worked out
Divide the delivery-month index by the bid-month index. That ratio minus one is the price change as a percentage. Multiply the material value inside the contract, meaning the covered value times the material share, by that percentage, and you have the full change in material cost. What the clause actually settles is that figure after the threshold or the deductible written into your contract has come off it.
The index has to be the series your clause names, read for the month your clause names. A steel claim settled against a general construction index will not match the mill invoices. Escalation is also calculated on material cost alone, not on overhead and profit, and a properly drafted clause runs both ways: when the index falls, the owner is owed a deductive change order on the same terms.
Material price escalation clause calculator: what the result assumes
You supply the index readings. No index values are published on this page, because a stale PPI figure would mislead more than an empty field does.
The adjustment covers material cost only. Overhead, profit, freight surcharges and labor stay outside unless your clause says otherwise in writing.
One material per run. A contract with steel, copper and fuel each tied to its own series needs the calculation once per material, with the results added afterwards.
The threshold is applied to the covered quantity in one go. Clauses that settle delivery by delivery, or month by month, end up at a different total.
Material price escalation clause calculator: questions and answers
Which index should a US escalation clause name?
Most name a series from the Producer Price Index published by the Bureau of Labor Statistics, picked for the commodity itself: steel mill products, copper wire and cable, asphalt paving mixtures. The clause should quote the series identifier and the month used, so both sides read the same number a year later.
Does an escalation clause work when material prices fall?
It does when the wording is symmetrical, and standard amendments such as ConsensusDocs 200.1 are drafted that way. The owner then receives a deductive change order for the decrease. One-way clauses that only pay increases are common in subcontracts and worth spotting before signature.
Is escalation figured on the whole contract or on the material?
On the material. Covered value times material share gives the exposed amount, and the index moves that amount and nothing else. Applying the index percentage to the full contract sum overstates the claim, which is the quickest route to having it rejected outright.
Where does the threshold percentage come from?
It is negotiated, not standard. Five percent is a common opening position in US escalation amendments, while German Formblatt 225 sets a de minimis limit of 2 percent and a contractor deductible of 10 percent. Read your own contract before trusting any preset in this calculator.
Material price escalation clause calculator: use it on your own projects
Inside Home Builder Software the same calculation reads the project file, so the figure carries the budget, the awards and the invoices behind it instead of asking you to retype them.