A fixed price loses margin every year that costs rise. An indexation formula gives some of it back, but only as far as its weights match the supplier's real cost mix.
A supplier on a four-year fixed-price defence contract of £5.0 million a year, with an 85% cost base, sees its margin fall from 15.0% to 3.2% in year four when labour costs rise 4% a year and materials 6%. An indexation clause weighted 20% fixed, 50% labour and 30% materials restores it to 13.6%. Over four years the clause is worth £1.178 million of profit, 39.3% of the £3.000 million the contract was priced to earn.
| Item | Value |
|---|---|
| Annual price, fixed | 5.000 |
| Annual cost in year 1 (85%) | 4.250 |
| Cost mix: labour / materials / other | 60% / 30% / 10% |
| Annual inflation: labour / materials / other | 4% / 6% / 2% |
| Indexation formula: fixed / labour / materials | 20% / 50% / 30% |
The price in year t is P0 × (0.20 + 0.50 × Lt + 0.30 × Mt), where L and M are the labour and materials indices relative to year one. Year one is at base, so inflation starts to bite in year two. Taxes, overheads and the timing of index publication are left out.
Cost in year t = 4.250 × (0.60 Lt + 0.30 Mt + 0.10 Ot); price stays at 5.000
Excel: =4.25*(0.6*(1.04)^(A2-1)+0.3*(1.06)^(A2-1)+0.1*(1.02)^(A2-1))
| Price | Cost | Profit | Margin | |
|---|---|---|---|---|
| Year 1 | 5.000 | 4.250 | 0.750 | 15.0% |
| Year 2 | 5.000 | 4.437 | 0.563 | 11.3% |
| Year 3 | 5.000 | 4.633 | 0.367 | 7.3% |
| Year 4 | 5.000 | 4.838 | 0.162 | 3.2% |
| Four years | 20.000 | 18.158 | 1.842 | 9.2% |
Year four cost is 4.838, up 13.8%. Profit falls from 0.750 to 0.162.
Price in year t = 5.000 × (0.20 + 0.50 Lt + 0.30 Mt)
Excel: =5*(0.2+0.5*(1.04)^(A2-1)+0.3*(1.06)^(A2-1))
| Price | Cost | Profit | Margin | |
|---|---|---|---|---|
| Year 1 | 5.000 | 4.250 | 0.750 | 15.0% |
| Year 2 | 5.190 | 4.437 | 0.753 | 14.5% |
| Year 3 | 5.389 | 4.633 | 0.757 | 14.0% |
| Year 4 | 5.599 | 4.838 | 0.761 | 13.6% |
| Four years | 21.178 | 18.158 | 3.020 | 14.3% |
The price rises 12.0% by year four and the cost 13.8%, so the clause passes through 101.8% of the cost increase in money. The gap that remains comes from the weights: the formula keeps 20% of the price fixed against 10% of the cost, and its labour weight is 50% against 60% in the supplier’s costs.
Total profit over four years is 1.842 without the clause and 3.020 with it. The clause adds 1.178. Without it the contract earns 9.2% on revenue instead of the 15.0% it was priced at; with it, 14.3%.
With labour at 7% a year, year-four cost is 5.093 and the margin without a clause −1.9%. The clause lifts the price to 5.849 and the margin to 12.9%, passing through 100.7% of the cost increase. Four-year profit is 1.349 without the clause and 3.011 with it. A wage spike is only partly covered, because the formula carries 50% labour against 60% in the cost base.
On £5.0 million a year with labour at 4% and materials at 6%, it lifts the year-four margin from 3.2% to 13.6% and adds £1.178 million of profit over four years.
No. It passes through 101.8% of the money increase in cost in year four, because part of the price is fixed and the formula weights differ from the real cost mix.
At 7% labour inflation, the year-four margin is −1.9% without a clause and 12.9% with it.
The workbooks for this book cost a defence proposal on dated inputs, including what a proposal takes to write. The win-rate table in this article is a separate illustration and is not in them.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: regulation, compliance and banking → · All 1908 articles →