NewAI Assistant — extract mechanisms directly from contract text →

Every escalation clause, executed on schedule.

Long-term supply agreements embed price adjustment mechanisms tied to commodity indices, labour costs, and foreign exchange — each running on a fixed calendar. Across a portfolio of contracts, managing review dates, applying formulas consistently, and maintaining an audit record is an operational burden that compounds with scale. CPAM automates the full cycle: live data from 14 index providers, formula execution on schedule, and complete documentation for every adjustment.

cpam.app/pams/fleet-supply-2026
Home
Contracts
Index Library
Forecasts
Comparator
Providers
Settings
Contracts/Apex Mining/Fleet Supply Agreement 2026
Fleet Supply Agreement 2026
LiveAdj. in 22d
ShareExport PDF ▾
Overview
Adjustment History
Forecast
Weight Sensitivity
Formula
Cumulative
+11.40%
Since contract start
Last Adjustment
+5.72%
Jan 1, 2026
Next Due
Jul 1
22d away
Formula
40% DIESEL
35% STEEL · 25% LABOUR
Quarterly
Performance
Baseline: Jan 2024Comparison: QuarterlyMechanism: Quarterly
Price Adjustment
+11.40%
Jan 2024 – Mar 2024  →  Apr 2026 – Jun 2026
Base Period
214.39
Current Period
238.82
Index Components
ComponentWeightCurrentvs Baselinevs Prev
EIA ULSD Diesel
40%
120.00
+20.00%
+2.14%
World Bank HRC Steel
35%
104.00
+4.00%
-0.38%
BLS Labour (ECI)
25%
108.00
+8.00%
+0.74%
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.

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 verified adjustment — in one platform.

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

01

Connect your data.

Pull live index data from 14 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 · OANDA · IMF · Eurostat · ONS · StatsCan · ABS · BIS · Alpha Vantage · USDA NASS
02

Build your formula.

Define any mechanism: weighted commodity baskets, CPI escalations, diesel + steel + labour blends, FX-adjusted pricing, or fully custom formulae. The wizard handles the structure — you define the logic.

Weighted baskets · CPI / PPI escalations · FX adjustments · Custom expressions · Averaging windows · Lag periods
03

Track everything automatically.

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
03aFormula Builder

Build PAM formulas step by step.

The PAM wizard walks you through selecting index components, configuring weights and averaging periods, and writing or editing the formula expression — with a live preview before you save.

  • 4-step wizard: Select Indices → Configure → Formula → Review
  • Per-component weights, averaging windows (latest, 3m, 6m, 12m), and lag
  • Excel-style formula editor with inline validation
  • Visual formula builder synced with the formula bar
  • Normalised performance chart from any baseline date
PAM Wizard — Configure Indices
1 · Select2 · Configure3 · Review
WTI Crude Oil
EIA · PETROLEUM · Monthly
70%
Averaging
3-month average
Lag
1 month
PPI Energy
BLS · Producer Price Index · Monthly
30%
Averaging
Latest value
Lag
2 months
✓ Weights sum to 100%Next: Review →
03dPDF & Excel Export

Export to PDF or Excel in one click.

Generate a polished PDF report or a full Excel workbook for any PAM — formula metadata, index performance chart, component breakdown, and period metrics. Ready to attach to supplier negotiations or internal sign-off.

  • PDF: one-page layout with header, chart, component table, and key metrics
  • Excel: full workbook with raw values, formula metadata, and period history
  • Includes baseline date, current index value, total and period change
  • AUDIT-GRADE stamp with prepared date and formula lineage
  • Exports directly from the PAM detail page — no extra steps
Export Preview
PDF ReportExcel Workbook
CPAM
Contract Price Adjustment Manager
Contract
HRFS-2024-001
Period
Q2 2026
Prepared
12 May 2026
Commercial in ConfidenceCPAM · Audit Grade Report
01Contract Details
PAM · Hard Rock Mining
Fleet Supply Agreement

Weighted index adjustment covering fuel, steel, and labour. Baseline Jan 2024; comparison Q2 2026.

Active
RefHRFS-2024-001-Q2
Baseline
100.00
Jan 2024
Current
111.84
Q2 2026
Adj. Factor
1.1184
ratio
Total Δ
+11.84%
vs base
Period Δ
+3.21%
Q1→Q2
Components
4
indices
02Composition0.35 × WTI + 0.25 × DIESEL + 0.20 × HRC + 0.20 × ECI
35%
25%
20%
20%
WTI Crude OilPETROLEUM.WTI
Diesel Fuel (US)PPI.DIESEL
Steel HRCSTEEL.HRC.US
Labour (Mining)ECI.MINING
03PerformanceNormalised Jan 2024 = 100
Jan '24Jul '24Jan '25Jul '25Q2 '26115108100
Composite Index
111.84
Q2 2026
Total Δ
+11.84%
vs Jan 2024
Period Δ
+3.21%
Q1 → Q2 2026
04Component Series
SeriesWtBaselineCurrentΔ Period
WTI Crude Oil
EIA
35%84.5098.30+16.3%
Diesel Fuel (US)
BLS
25%3.824.45+16.5%
Steel HRC
WB
20%720680−5.6%
Labour (Mining)
BLS
20%108.2118.4+9.4%
Composite Index100%100.00111.84+11.84%
CPAM · Contract Price Adjustment ManagerConfidentialRef HRFS-2024-001-Q2 · Page 1
04Scope

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.

Multi-input weighted basket
Explosives (ANFO)
P = 0.60 × ANₜ/AN₀ + 0.15 × Gasₜ/Gas₀ + 0.10 × Dieselₜ/Diesel₀ + 0.15

AN price tracks ammonia, which tracks natural gas. A gas spike hits your formula before your supplier invoices.

Argus AN IndexHenry Hub / TTFEIA ULSD
Natural chain basket
Giant off-road tyres
P = 0.35 × NR + 0.25 × Steel + 0.15 × SBR + 0.08 × CB + 0.17

Five inputs from five different markets. The basket moves daily even when your invoice is quarterly.

SICOM TSR20LME Wire RodICIS SBRArgus CBFS
Single-index pass-through
Copper wire & cables
P = 0.65 × LME_Cuₜ/LME_Cu₀ + 0.15 × PVCₜ/PVC₀ + 0.20

LME copper resets monthly. Most cable contracts carry a Cu adder per kg of conductor — pure LME pass-through.

LME Official SettlementICIS PVC Spot
Labour & services
Remote site catering
R = 0.40 × Foodₜ/Food₀ + 0.40 × Labourₜ/Labour₀ + 0.08 × Energyₜ/Energy₀ + 0.12

Labour often tracks minimum wage orders, not CPI — a common source of contract disputes at review time.

BLS CPI FoodUSDA NASSABS WPI

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

05Pricing

Priced by PAM 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.

MonthlyAnnual−20%
Starter
$290 / mo
For teams managing a handful of contracts.
  • Up to 5 active PAMs
  • All 14 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 PAMs
  • Forecasting & comparator
  • 7-year audit log retention
  • Webhooks & API access
  • Read-only audit links
Start a Team trial
Enterprise
$1,999 / mo
SSO, customer-managed keys, dedicated infra.
  • Unlimited PAMs
  • 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. No migrations. No implementation project. No professional services.

What you ship in week one
First PAM live with real data from a built-in provider
All your mechanisms in one place — not twelve spreadsheets
Read-only audit link ready for legal or suppliers
One-page adjustment report for your next supplier review
No card required · Cancel any time