Source: https://www.quantsurv.com/library/tools/price-change-calculation
Content format: Markdown version of the public page.
Content reviewed: 2026-10-14

# Price change calculation

Compare baseline and current input prices and calculate an adjustment using the agreed eligible proportion.

by [Jack Butler-Kettle](<https://www.quantsurv.com/about#jack-butler-kettle>) · About 2 min readShare

## How to use it

Record the contract provision, base date, current date and comparable source. An observed price increase is not automatically recoverable.

### Price change calculation

Record the contract provision, base date, current date and comparable source. An observed price increase is not automatically recoverable.

[Download blank Excel workbook](<https://www.quantsurv.com/downloads/library/price-change-calculation.xlsx>)

Free blank template for your own project. The completed example is shown below. No email address required.

View the completed example

Completed fictional example

Westhaven refurbishment · 14 October 2026 · Version 1.0

#### Price change calculation

Scroll across if needed to read the whole record. A dash means no value has been entered.

Price change calculation: completed fictional example
| Item / source | Quantity | Base unit price (£) | Current unit price (£) | Eligible proportion | Calculated adjustment (£) | Contract basis / status |
| --- | --- | --- | --- | --- | --- | --- |
| Steel sections / supplier Q-01 and Q-18 | 10 | £800.00 | £920.00 | 100% | £1,200.00 | Illustrative agreed price adjustment for 10 tonnes |
| Board / supplier Q-02 and Q-19 | 500 | £8.00 | £9.00 | 0% | £0.00 | Fixed-price item; no adjustment basis identified |

Eligible proportion is 1 for 100% and 0 for none. The £1,200 example adjustment assumes an express agreed basis; it is not a statutory escalation entitlement.

## Understanding your results

Eligible proportion is 1 for 100% and 0 for none. The £1,200 example adjustment assumes an express agreed basis; it is not a statutory escalation entitlement.

## How it works

The workbook provides blank working records. Grey cells calculate from the entered inputs; yellow cells are for your information. The completed example stays on this page.

Read the [related guidance](<https://www.quantsurv.com/price-rises/tips/file-supplier-increase-notices>) for the context and checks behind this template.

If you need help preparing or reviewing the project records, our [quantity surveying services](<https://www.quantsurv.com/quantity-surveying>) explain the tasks available under a separate appointment. Agree the deliverable, responsibilities and required specialist input before work starts.

[Browse the Library](<https://www.quantsurv.com/library>)
