Calculation guide
Include other uses at face value and subtract committed funding.
gap = max(0,build*(1+cont/100)+other-funds)
Inputs
Eligible construction budget
Example entry 1000000.0 (in the selected currency).
Contingency (%)
Example entry 10.0 %. Allowed range 0 to 100.
Other project uses
Example entry 50000.0 (in the selected currency).
Committed funding
Example entry 1000000.0 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Eligible construction budget | 1,000,000 |
| Contingency (%) | 10% |
| Other project uses | 50,000 |
| Committed funding | 1,000,000 |
| Result | Value |
|---|---|
| Additional funding needed | 150,000 |
Calculation steps
Additional funding needed = max(0, (((Eligible construction budget × (1 + (Contingency (%) ÷ 100))) + Other project uses) − Committed funding))
max(0, (((1,000,000 × (1 + (10 ÷ 100))) + 50,000) − 1,000,000)) = 150,000
Interpreting the result
A positive gap is the commitment still needed to fund both expected costs and contingency.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Eligible construction budget | 1,000,000 | 1,100,000 | Additional funding needed | 150,000 | 260,000 |
| Contingency (%) | 10% | 11% | Additional funding needed | 150,000 | 160,000 |
| Other project uses | 50,000 | 55,000 | Additional funding needed | 150,000 | 155,000 |
| Committed funding | 1,000,000 | 1,100,000 | Additional funding needed | 150,000 | 50,000 |
