S-curve and cash: the physical-financial programme
After this lecture you can
Build a cumulative S-curve from the corrected programme.
Separate the value measured from the contractor's cost by the BDI.
Find the lowest cash balance when payment comes a month after the work.
1 / 4
The S-curve accumulates value
The physical-financial schedule shows, month by month, the value planned and its running total. Plotted, the total makes an S: slow at mobilisation, steep in the main works, flat at finishing. A curve that rises in a straight line was spread by the calendar, not by the programme.
Month 1
R$160,000
Month 2, cumulative
R$400,000 (R$160,000 + R$240,000)
Month 3, cumulative
R$550,000 (R$160,000 + R$240,000 + R$150,000)
2 / 4
Price is cost plus BDI
Brazilian public works prices include the BDI (benefícios e despesas indiretas): overheads, taxes, risk and profit, as a percentage on direct cost. The TCU has published reference ranges for it. To find the contractor's cost behind a value, divide by (1 + BDI).
Example. With a BDI of 25 %, R$125 of value carries R$100 of cost.
3 / 4
Paid a month later
The contract sets how often work is measured and when it is paid. On this case work is measured on the last working day of the month and paid the following month, while the contractor pays its costs in the month. So the contractor finances at least a month of costs, and the balance dips before it recovers.
Cash out in month mValue of month m ÷ (1 + BDI)
Cash in in month mValue measured in month m − 1
4 / 4
No adjustment within a year
Brazilian law (Law 10.192/2001) voids price adjustment clauses with a period of less than a year. A job shorter than a year has no adjustment, so the cash plan uses contract prices throughout.
Example. A negative balance is entered with its minus sign: it is money the contractor is owed by its own bank account.
Find the lowest balance
Another job, three months of work. BDI 25 %. Type your answer first.