Calculation guide
Apply target profit as markup on direct cost. Require positive net realization.
Inputs
Direct bid cost
Example entry 90000 (in the selected currency). Minimum 1e-06.
Target profit markup on cost (%)
Example entry 10 %. Allowed range 0.0 to 1000.0.
Bond premium on bid (%)
Example entry 1 %. Allowed range 0 to 100.
Bid retention (%)
Example entry 10 %. Allowed range 0 to 100.
Annual financing rate (%)
Example entry 10 %. Allowed range 0 to 100.
Years retention financed
Example entry 1. Allowed range 0.0 to 100.0.
Worked example
| Input | Value |
|---|---|
| Direct bid cost | 90,000 |
| Target profit markup on cost (%) | 10% |
| Bond premium on bid (%) | 1% |
| Bid retention (%) | 10% |
| Annual financing rate (%) | 10% |
| Years retention financed | 1 |
| Result | Value |
|---|---|
| Required gross bid | 101,020.408163 |
| Total markup on cost | 12.244898% |
Calculation steps
Required gross bid = ((Direct bid cost × (1 + (Target profit markup on cost (%) ÷ 100))) ÷ ((1 − (Bond premium on bid (%) ÷ 100)) − (((Bid retention (%) × Annual financing rate (%)) × Years retention financed) ÷ 10,000)))
((90,000 × (1 + (10 ÷ 100))) ÷ ((1 − (1 ÷ 100)) − (((10 × 10) × 1) ÷ 10,000))) = 101,020.408163
Total markup on cost = (100 × ((Required gross bid ÷ Direct bid cost) − 1))
(100 × ((101,020.408163 ÷ 90,000) − 1)) = 12.244898%
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 |
|---|---|---|---|---|---|
| Direct bid cost | 90,000 | 99,000 | Required gross bid | 101,020.408163 | 111,122.44898 |
| Target profit markup on cost (%) | 10% | 11% | Required gross bid | 101,020.408163 | 101,938.77551 |
| Bond premium on bid (%) | 1% | 2% | Required gross bid | 101,020.408163 | 102,061.85567 |
| Bid retention (%) | 10% | 11% | Required gross bid | 101,020.408163 | 101,123.595506 |
| Annual financing rate (%) | 10% | 11% | Required gross bid | 101,020.408163 | 101,123.595506 |
| Years retention financed | 1 | 2 | Required gross bid | 101,020.408163 | 102,061.85567 |
