NewPaste a contract clause and CPAM extracts the formula →

Price adjustments calculated, documented, and ready to defend.

When a supplier disputes your number, you need the index value, the formula version, and the exact calculation behind it — and if your escalation clauses live in Excel, you probably don't have all three. CPAM automates the full cycle for a whole portfolio of mechanisms — caps, floors, FX, and all — from live index data to an audit record you can put in front of anyone.

cpam.app/pams/national-linehaul-agreement
Home
Contracts
Index Library
Forecasts
Comparator
Providers
Settings
Contracts/Meridian Freight Lines/National Linehaul Agreement
National Linehaul Agreement
LiveAdj. in 19d
ShareExport PDF ▾
Overview
Adjustment History
Forecast
Weight Sensitivity
Formula
Cumulative
+3.51%
Since contract start
Last Adjustment
−0.20%
Apr 1, 2026
Next Due
Jul 1
19d away
Formula
55% WAGES
25% DIESEL · 20% TRUCK PPI
Quarterly
Performance
Baseline: Jan 2024Comparison: QuarterlyMechanism: Quarterly
Price Adjustment (Weighted)
+3.51%
Jan 2024 – Mar 2024  →  Apr 2026 – Jun 2026
Base Period
100.00
Current Period
103.51
Wages +10.0% offset by diesel −11.9% — weighted by component shares
Index Components
ComponentWeightCurrentvs Baselinevs Prev
EIA On-Highway Diesel
25%
3.42
-11.86%
-2.01%
BLS Driver Wages (ECI)
55%
133.50
+9.97%
+0.84%
FRED PPI Truck Transport
20%
177.30
+4.97%
+0.51%
01The Problem

Managing contract price formulas in Excel is a liability in disguise.

Most commercial teams manage price adjustment mechanisms in spreadsheets with no version control, no data provenance, and no audit trail. That works for five contracts. It breaks long before fifty. And the alternatives don't cover it either: your ERP knows your prices, but it doesn't know BLS publication schedules or preliminary-to-final revisions — and a dashboard can show the number, but it can't defend it.

FAILURE 01

Excel breaks at portfolio scale.

You have 40+ contracts. Each one has 2–4 index components. Quarterly reviews. Manual data gathering from multiple sources. One wrong cell propagates silently across every adjustment downstream — and nothing flags it until a dispute lands on your desk.

Silent errors at scale
FAILURE 02

Data collection kills days every cycle.

Gathering index values from BLS, EIA, World Bank, ECB, and the rest for every review cycle is a full day of copy-paste — at minimum. It's not the interesting part of the job. And one missed publication means the entire calculation is wrong.

Manual data bottleneck
FAILURE 03

Nothing to show in a dispute.

When a supplier challenges an adjustment — and they will — you need the exact index value, the formula version, and the calculation that produced the number. Spreadsheets keep none of that. Reconstructing it is the fastest way to lose a renegotiation.

No audit defence
02How It Works

From raw index data to a number you can defend.

CPAM replaces the entire workflow that procurement and commercial teams currently do in Excel: data gathering, formula calculation, period tracking, and audit documentation.

01

Pull live index data from the source.

Pull live index data from 12 built-in providers — BLS, FRED, EIA, World Bank, ECB, and more — or enter your own series. Every data point is versioned, timestamped, and tracked through preliminary to final.

BLS · FRED · EIA · World Bank · ECB · IMF · Eurostat · ONS · StatsCan · ABS · BIS · Nasdaq Data Link
02

Define your mechanism — exactly as written in the contract.

Weighted commodity baskets, CPI/PPI escalations, FX-adjusted pricing, caps and floors, trigger thresholds, fixed non-escalating portions — the wizard handles the structure, you define the logic. Period averaging and publication lag are built in.

Weighted baskets · CPI / PPI / ECI escalations · FX conversion · Caps & floors · Trigger thresholds · Fixed portions · Averaging windows · Lag periods
03

CPAM runs the calculation. You get the audit trail.

CPAM monitors every contract in your portfolio. When index data updates, calculations run automatically. Period changes, adjustment factors, and deviation alerts surface when they matter — not when you go looking.

Automated sync · Period calculations · Adjustment alerts · PDF & Excel export · Immutable audit trail · Read-only supplier access

Data you can defend

CPAM tracks index values across 12 official providers — including BLS preliminary and final releases, FRED revisions, and ECB publication schedules. Every value is timestamped at ingestion and version-tagged. When a supplier asks “which value did you use?”, the answer is in the audit trail.

Tenant-isolated · Encrypted in transit and at rest · Full audit logging · Security →

03Formula Builder

Build price formulas step by step.

Your contracts aren't simple weighted averages — they have averaging windows, publication lags, caps, floors, fixed portions, and currency exposure. The wizard builds all of it, exactly as written, with a live preview before you save.

  • 4-step wizard: Describe → Build Basket → Define Calculation → Review
  • Per-component weights, averaging windows (latest, 3m, 6m, 12m), and publication lag
  • Caps & floors, trigger thresholds, and fixed non-escalating portions
  • Currency conversion for components priced in another currency
  • Excel-style formula editor with inline validation and live preview
Formula Wizard — Build Basket
1 · Describe2 · Basket3 · Calculation4 · Review
Driver Wages (ECI)
BLS · BLS_ECI_WAGES · Monthly
55%
Averaging
3-month average
Lag
1 month
On-Highway Diesel
EIA · EIA_DIESEL · Monthly
25%
Averaging
Latest value
Lag
1 month
Truck Transport PPIFRED · Latest value · 1-month lag
20%
✓ Weights sum to 100%Next: Calculation →
04Audit-Ready Export

Every calculation is on the record.

When a supplier challenges your Q2 adjustment, you don't reconstruct it — you export it. One-page PDF or full Excel workbook: the index values used, the formula version applied, component contributions, and the output. This is what you put in front of your auditor. This is what you attach to the supplier email.

  • PDF: one-page layout with header, chart, component table, and key metrics
  • Excel: full workbook with raw values, formula metadata, and period history
  • Timestamped and formula-stamped, with prepared date and lineage
  • Read-only audit links for suppliers, counsel, and auditors — always free
  • Exports directly from the PAM detail page — no extra steps
Export Preview
PDF ReportExcel Workbook
CPAM
Contract Price Adjustment Manager
Contract
MFL-2024-001
Period
Q2 2026
Prepared
12 Jun 2026
Commercial in ConfidenceCPAM · Audit Grade Report
01Contract Details
Formula · Meridian Freight Lines
National Linehaul Agreement

Weighted freight rate adjustment covering driver labour, fuel, and transport costs. Baseline Jan 2024; comparison Q2 2026.

Active
RefMFL-2024-001-Q2
Baseline
100.00
Jan 2024
Current
103.51
Q2 2026
Adj. Factor
1.0351
ratio
Total Δ
+3.51%
vs base
Period Δ
−0.10%
Q1→Q2
Components
3
indices
02Composition0.55 × ECI + 0.25 × DIESEL + 0.20 × TRUCK PPI
55%
25%
20%
Driver Wages (ECI)BLS_ECI_WAGES
On-Highway DieselEIA_DIESEL
Truck Transport PPIFRED_PPI_TRUCK
03PerformanceNormalised Jan 2024 = 100
Jan '24Jul '24Jan '25Jul '25Q2 '26104102100
Composite Index
103.51
Q2 2026
Total Δ
+3.51%
vs Jan 2024
Period Δ
−0.10%
Q1 → Q2 2026
04Component Series
SeriesWtBaselineCurrentΔ Period
Driver Wages (ECI)
BLS
55%121.40133.50+9.97%
On-Highway Diesel
EIA
25%3.8803.420−11.86%
Truck Transport PPI
FRED
20%168.90177.30+4.97%
Composite Index100%100.00103.51+3.51%
CPAM · Contract Price Adjustment ManagerConfidentialRef MFL-2024-001-Q2 · Formula v3 · Page 1
05Complexity

The formulas Excel can't hold.

Real escalation clauses aren't weighted averages. They have averaging windows, publication lags, caps and floors, fixed portions, and currency exposure. CPAM runs all of them — the same way, every cycle.

Excel-easyA weighted basketP = 0.6 × Aₜ/A₀ + 0.4 × Bₜ/B₀Two indices, fixed weights. A SUMPRODUCT handles it. This is the only case Excel does well.
Excel-fragileAveraged, lagged, and cappedP = basket of 6-month averages, published 2 months in arrears, capped at ±5% / reviewNow you’re re-keying a 200-character array formula per supplier, hand-aligning publication lags, and praying the cap logic three columns over still fires. One wrong cell, silently.
Excel-impossibleFX-converted with a fixed floorP = (0.7 × indexed + 0.3 fixed) × FX₀/FXₜ, floored at 0%Two currency exposures, a non-escalating share, and a floor — recomputed every cycle and defensible to an auditor. This is where the workbook breaks and the disputes begin.

All three are authored in the same wizard and computed on the same audit trail. The hard ones aren't a different product — they're the same three clicks.

06Scope

If it's on a long-term contract, it has a mechanism.

CPAM isn't built for one sector. Every large company that buys or sells on long-term contracts has mechanisms to manage — whether that's five categories or five hundred. Below is what those mechanisms actually look like across the spectrum.

Producer-index basket
Construction materials supply
P = 0.45 × Steelₜ/Steel₀ + 0.30 × Cementₜ/Cement₀ + 0.10 × Dieselₜ/Diesel₀ + 0.15

Steel and cement PPIs move on different cycles — a fixed annual uplift always overpays one input and underpays the other.

BLS PPI SteelBLS PPI CementEIA Diesel
Basket with cap & floor
Mining tyre supply
P = 0.45 × Rubberₜ/Rubber₀ + 0.30 × Steelₜ/Steel₀ + 0.25 × Energyₜ/Energy₀, capped at ±8% / review

A collar protects both sides from a runaway period — but the cap and floor have to be applied to the adjustment, not the index, or one volatile month quietly breaches the contract.

Rubber (CSV)BLS PPI SteelEIA Diesel
Threshold-gated escalation
OEM spare parts
P = 0.40 × PPIₜ/PPI₀ + 0.40 × Labourₜ/Labour₀ + 0.20, applied only if move ≥ 2%

A deadband stops trivial sub-2% moves from triggering a re-paper every quarter — the kind of rule that lives as a forgotten IF() three columns to the right of the formula.

BLS PPI MachineryBLS ECI
FX-adjusted producer index
Imported components
P = (0.60 × PPIₜ/PPI₀ + 0.40) × FX₀/FXₜ

European-sourced parts carry two exposures: the producer index in euros and the exchange rate into dollars. Most spreadsheets handle one and silently ignore the other.

Eurostat PPIECB EUR/USD

The same primitives — index data, formula builder, period calculation, audit trail — work for every category in your portfolio.

07Pricing

Priced by formula count, not seats.

Three tiers, transparent pricing, monthly or annual. Read-only audit access for suppliers, counsel, and auditors is always free — they shouldn't have to be a paying user to see what they need to. And the maths is simple: one disputed adjustment costs more in legal review and management time than a year of CPAM.

MonthlyAnnual−20%
Starter
$290 / mo
For teams managing a handful of contracts.
  • Up to 5 active price formulas
  • All 12 data providers
  • 1-year audit log retention
  • Email support
Start free trial
Most chosen
Team
$890 / mo
For procurement & finance in production.
  • Up to 25 active price formulas
  • Forecasting & comparator
  • 7-year audit log retention
  • Webhooks & API access
  • Priority support
Start a Team trial
Enterprise
$1,999 / mo
SSO, customer-managed keys, dedicated infra.
  • Unlimited price formulas
  • SSO (SAML / OIDC)
  • Customer-managed keys (KMS)
  • Up to 15-year retention
  • Dedicated VPC / single-tenant
  • Named CSM
Talk to sales

Annual billing saves 20% · No card required for trials · Full pricing details →

Get Started

Stop reconciling mechanisms across spreadsheets.

Connect your first index, build your first PAM formula, and generate your first adjustment report — before end of day. Got the clause text? Paste it and CPAM extracts the mechanism for you.

What you ship in week one
First PAM live with real data from a built-in provider
Every category — spare parts, tyres, chemicals, fuel — in one place, not twelve tabs
Read-only audit link ready for legal or suppliers
One-page adjustment report for your next supplier review
No card required · Cancel any time