CONSTRUCTION COST CONTROL - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.

The_Bridge_Blank.xlsx  (Chapters 1 to 11; column C is Case A, column D Case B)

   Inputs!C6           96            Units
   Inputs!C7           8640          Gross internal area, m2
   Inputs!C8           7344          Net internal area, m2
   Inputs!C9           6             Storeys
   Inputs!C10          94            Contract period, weeks
   Inputs!C13          2180          Measured works rate, per m2
   Inputs!D13          2330          Measured works rate, per m2
   Inputs!C14          1240000       External works and site
   Inputs!D14          1240000       External works and site
   Inputs!C15          0.15          Preliminaries, per cent of works
   Inputs!D15          0.15          Preliminaries, per cent of works
   Inputs!C16          0.06          Overheads and profit, per cent of works plus prelims
   Inputs!D16          0.06          Overheads and profit, per cent of works plus prelims
   Inputs!C17          0.02          Contractor's design development allowance, per cent
   Inputs!D17          0.005         Contractor's design development allowance, per cent
   Inputs!C18          1340000       Provisional sums
   Inputs!D18          210000        Provisional sums
   Inputs!C21          0.72          Design information issued at contract, per cent of Stage 4
   Inputs!D21          0.96          Design information issued at contract, per cent of Stage 4
   Inputs!C22          0.135         Premium on value priced after award
   Inputs!D22          0.135         Premium on value priced after award
   Inputs!C23          2150000       Provisional sums released
   Inputs!D23          243000        Provisional sums released
   Inputs!C24          742000        Client changes at contract rates
   Inputs!D24          742000        Client changes at contract rates
   Inputs!C25          0.142         Post-award pricing premium on client changes
   Inputs!D25          0.061         Post-award pricing premium on client changes
   Inputs!C26          14            Weeks late
   Inputs!D26          6             Weeks late
   Inputs!C27          11            Weeks carrying an extension of time
   Inputs!D27          5             Weeks carrying an extension of time
   Inputs!C28          0.72          Time-related share of preliminaries
   Inputs!D28          0.72          Time-related share of preliminaries
   Inputs!C29          11200000      Trade value exposed to disruption
   Inputs!D29          11200000      Trade value exposed to disruption
   Inputs!C30          22            Disrupted weeks
   Inputs!D30          9             Disrupted weeks
   Inputs!C31          0.11          Labor productivity loss
   Inputs!D31          0.045         Labor productivity loss
   Inputs!C32          310000        Statutory change, cost
   Inputs!D32          310000        Statutory change, cost
   Inputs!C33          8             Statutory change, weeks
   Inputs!D33          5             Statutory change, weeks
   Inputs!C34          0.041         Escalation index, per year
   Inputs!D34          0.041         Escalation index, per year
   Inputs!C35          19            Months from tender to midpoint of late-priced work
   Inputs!D35          11            Months from tender to midpoint of late-priced work
   Inputs!C36          96000         Contra-charges recovered by the client
   Inputs!D36          96000         Contra-charges recovered by the client
   Inputs!C37          14500         Liquidated damages per week
   Inputs!D37          14500         Liquidated damages per week
   Inputs!C38          0.05          Liquidated damages cap, per cent of contract sum
   Inputs!D38          0.05          Liquidated damages cap, per cent of contract sum
   Inputs!C39          0.03          Retention, per cent
   Inputs!D39          0.03          Retention, per cent
   Inputs!C40          0.115         Retention never released, per cent of retention held
   Inputs!D40          0.115         Retention never released, per cent of retention held
   Inputs!C41          0.079         Finance rate used for the time value of retention
   Inputs!D41          0.079         Finance rate used for the time value of retention

   Result: contract sums 26,301,102 and 26,391,750; final accounts 29,153,363 and 27,533,075; saving 1,620,289; the rate premium that erases it 302.82 per m2.

The_Appraisal_Blank.xlsx  (Chapters 12 and 13)

   Inputs!C5           96            Units
   Inputs!C6           472000        Revenue per unit
   Inputs!C7           7344          Net internal area, m2
   Inputs!C10          6200000       Land
   Inputs!C11          0.098         Professional fees, per cent of construction cost
   Inputs!C12          0.022         Sale costs, per cent of revenue
   Inputs!C15          0.65          Loan to cost
   Inputs!C16          0.6           Average drawn share over the period
   Inputs!C17          0.079         Interest rate a year
   Inputs!C18          2.4           Term, years
   Inputs!C21          0.15          Target profit on cost
   Inputs!C24          26301102      Case A contract sum
   Inputs!C25          29153363      Case A final account
   Inputs!C26          26391750      Case B contract sum
   Inputs!C27          27533075      Case B final account
   Inputs!C28          71923         Case A retention time value (credited against finance)
   Inputs!C29          72171         Case B retention time value (credited against finance)
   Solve!C6            96            Units
   Solve!C7            472000        Revenue per unit
   Solve!C8            6200000       Land
   Solve!C9            26301102      Contract sum
   Solve!C10           0.098         Professional fees, per cent of construction cost
   Solve!C11           0.022         Sale costs, per cent of revenue
   Solve!C12           0.65          Loan to cost
   Solve!C13           0.6           Average drawn share
   Solve!C14           0.079         Interest rate a year
   Solve!C15           2.4           Term, years
   Solve!C16           0.15          Target profit on cost
   Solve!C17           71923         Retention time value credited against finance

   Result: profit on cost 17.40 and 8.59 (7.99 stretched); break-even 27,033,648; headroom 732,546; the overrun that halves the return 2,812,970.

Sensitivities_Blank.xlsx  (Chapter 14)

   Inputs!C6           96            Units
   Inputs!C7           8640          Gross internal area, m2
   Inputs!C8           7344          Net internal area, m2
   Inputs!C10          94            Contract period, weeks
   Inputs!C13          2180          Measured works rate, per m2
   Inputs!C14          1240000       External works and site
   Inputs!C15          0.15          Preliminaries, per cent of works
   Inputs!C16          0.06          Overheads and profit, per cent
   Inputs!C17          0.02          Design development allowance, per cent
   Inputs!C18          1340000       Provisional sums
   Inputs!C21          0.72          Design information issued at contract
   Inputs!C22          0.135         Premium on value priced after award
   Inputs!C23          2150000       Provisional sums released
   Inputs!C24          742000        Client changes at contract rates
   Inputs!C25          0.142         Post-award pricing premium
   Inputs!C26          14            Weeks late
   Inputs!C27          11            Weeks carrying an extension of time
   Inputs!C28          0.72          Time-related share of preliminaries
   Inputs!C29          11200000      Trade value exposed to disruption
   Inputs!C30          22            Disrupted weeks
   Inputs!C31          0.11          Labor productivity loss
   Inputs!C32          310000        Statutory change, cost
   Inputs!C34          0.041         Escalation index, per year
   Inputs!C35          19            Months tender to midpoint of late work
   Inputs!C36          96000         Contra-charges
   Inputs!C37          14500         Liquidated damages per week
   Inputs!C38          0.05          Liquidated damages cap, per cent
   Inputs!C39          0.03          Retention, per cent
   Inputs!C40          0.115         Retention never released, per cent
   Inputs!C43          472000        Revenue per unit
   Inputs!C44          6200000       Land
   Inputs!C45          0.098         Professional fees, per cent of construction cost
   Inputs!C46          0.022         Sale costs, per cent of revenue
   Inputs!C47          0.65          Loan to cost
   Inputs!C48          0.6           Average drawn share
   Inputs!C49          0.079         Interest rate a year
   Inputs!C50          2.4           Term, years
   Inputs!C51          0.15          Target profit on cost
   Inputs!C52          71923         Retention time value credited against finance
   Ranking!C14         1620289       The joint move (Case B, Workbook 1): final account lower by

   Result: spans 1,342,767 (provisional sums), 1,062,726 (design), 572,042, 419,404, 340,921, 173,963; profit on cost 6.90 to 9.93 per cent.

Before_Signature_Blank.xlsx  (Chapter 15 and Appendix B)

   Your project!C6     96            Units
   Your project!C7     8640          Gross internal area, m2
   Your project!C8     7344          Net internal area, m2
   Your project!C9     94            Contract period, weeks
   Your project!C12    2180          Measured works rate, per m2
   Your project!C13    1240000       External works and site
   Your project!C14    0.15          Preliminaries, per cent of works
   Your project!C15    0.06          Overheads and profit, per cent of works plus prelims
   Your project!C16    0.02          Contractor's design development allowance, per cent
   Your project!C17    1340000       Provisional sums
   Your project!C20    0.72          Design information issued at contract
   Your project!C21    0.135         Premium on value priced after award
   Your project!C22    0.72          Time-related share of preliminaries
   Your project!C23    19            Months from tender to the midpoint of work that will be priced later
   Your project!C24    0.041         Escalation index a year
   Your project!C27    2150000       Provisional sums: the amount you expect them to release at
   Your project!C28    742000        Client changes you expect to instruct, at contract rates
   Your project!C29    0.142         Post-award pricing premium you expect to pay on them
   Your project!C30    11            Weeks of extension of time you expect to grant
   Your project!C33    472000        Revenue per unit
   Your project!C34    6200000       Land
   Your project!C35    0.098         Professional fees, per cent of construction cost
   Your project!C36    0.022         Sale costs, per cent of revenue
   Your project!C37    0.65          Loan to cost
   Your project!C38    0.6           Average drawn share
   Your project!C39    0.079         Interest rate a year
   Your project!C40    2.4           Term, years
   Your project!C41    0.15          Target profit on cost
   Your project!C42    71923         Retention time value credited against finance

   Result: knowable gap 1,742,160 against a headroom of 732,546.

