OpenConstruction Academy
Sign in / Register
EN

Theory before task 6 · 8 min

The S-curve and the contractor's cash

S-curve and cash: the physical-financial programme

After this lecture you can

  1. Build a cumulative S-curve from the corrected programme.
  2. Separate the value measured from the contractor's cost by the BDI.
  3. 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.

Not to scale
The problem
  • Planned value: month 1 R$160,000, month 2 R$240,000, month 3 R$150,000.
  • Cost paid in the month = value ÷ 1.25. Each month's measurement is paid the month after.
R$160,000R$240,000R$150,000
  • Month 1 R$160,000
  • Month 2 R$240,000
  • Month 3 R$150,000
R$160,000R$240,000R$150,000
  • Month 1 R$160,000
  • Month 2 R$240,000
  • Month 3 R$150,000
Step 1 of 2

S-curve at month 2

What share of the total value is planned by the end of month 2, in per cent?

(R$160,000 + R$240,000) ÷ (R$160,000 + R$240,000 + R$150,000) = 72.7273%.

−R$128,0001+R$160,0002−R$192,0003?4
  • 1 Cost, month 1
  • 2 Paid for month 1
  • 3 Cost, month 2
  • 4 Balance
−R$128,0001+R$160,0002−R$192,0003−R$160,0004
  • 1 Cost, month 1
  • 2 Paid for month 1
  • 3 Cost, month 2
  • 4 Balance
Step 2 of 2

Lowest balance

What is the lowest cumulative cash balance? Enter it with its sign.

Month 1: −R$160,000 ÷ 1.25. Month 2: + R$160,000 − R$240,000 ÷ 1.25. Balance −R$160,000.00, the lowest; month 3 brings it back up.

In short. Accumulate value by the programme, take cost off by the BDI in the month, bring payment in a month later, and read the deepest point.

Check yourself

Question 1 of 2

Value of the month R$150,000; BDI 25 %. What is the contractor's cost for the month?

R$150,000 ÷ 1.25 = R$120,000.
Question 2 of 2

An S-curve rises in a straight line over the three months of the term. What does that tell you?

  • Real programmes are slow at the start and the end.

  • Rebuild it from the corrected programme.