OpenConstruction Academy
Нэвтрэх / Бүртгүүлэх
MN

1-р даалгаврын өмнөх онол · 10 мин

Cost to date, estimate at completion and percent complete

Өнөөдрийг хүртэлх зардал, дуусгалтын тооцоот зардал, гүйцэтгэлийн хувь

Сургалтын танилцуулга

Энэ лекцийн дараа та дараахыг хийж чадна

  1. Build cost to date from posted and accrued cost, and keep open commitments out of it.
  2. Build the estimate at completion from cost to date and the project manager's cost to complete, and tell it apart from the bid budget.
  3. Compute the cost-to-cost percent complete and say why it divides cost by cost.
1 / 3

One line per job: the WIP schedule

A contractor's work-in-progress (WIP) schedule has one line for every open job: contract value, estimated cost at completion, cost to date, percent complete, earned revenue, billed to date, and the difference between the last two. Banks and sureties read it with the quarterly statements. They want to see two things: whether each job still makes the margin the bid promised, and whether billing runs ahead of the work or behind it. Every column after cost to date is computed from the columns before it, so an error in cost carries all the way to the bottom line.

Жишээ. One line for a school addition. This course builds the same line for the mixed-use job, one column group per task.
Contract value$3,400,000
Estimated cost at completion$3,060,000
Cost to date$1,224,000
Percent complete40%
Earned revenue$1,360,000
Billed to date$1,410,000
Over billing$50,000
2 / 3

Cost to date: posted plus accrued

The job cost report shows posted cost: subcontractor and supplier invoices entered in payables, and payroll. It does not show cost that has happened but is not yet invoiced: lumber received on a delivery ticket, a subcontractor's work for the month before the pay request arrives. That cost is accrued at the close. Leave it out and cost to date is too low, so percent complete, earned revenue and gross profit are all too low. An open purchase order for goods not yet received is a commitment, not a cost: it belongs in the cost to complete.

Жишээ. A framing code with $286,400 posted and $13,600 of lumber received but not invoiced has $300,000 cost to date.
$286,400
  • Posted: invoices and payroll $286,400
  • Accrued: received, not yet invoiced $13,600
3 / 3

Estimate at completion and percent complete

Estimated cost at completion = cost to date + cost to complete. The cost to complete is the project manager's forecast of what is still to be spent, code by code, reviewed every month. The bid budget is history: once the job moves, it no longer tells you how big the job is. Percent complete = cost to date / estimate at completion. This is the cost-to-cost input method, the usual way contractors measure progress on a contract whose revenue ASC 606 recognizes over time. Cost is divided by cost. Contract value and billings never enter the percent.

Жишээ. $300,000 to date and $660,000 to complete is an estimate of $960,000 and 31.25% complete. Against the $940,000 bid budget the same cost reads 31.91%: too far along, because the job has grown since the bid.
Bid budget
$940,000
Estimate at completion
$960,000 ($300,000 + $660,000)

Close one month on a medical office job

Another job, totals for all cost codes. Work out cost to date, the estimate, and how complete the job is.

Масштабгүй
Бодлого
  • Posted cost $2,148,300.00; accrued cost $61,700.00 (received, not yet invoiced).
  • Project manager's cost to complete $1,590,000.00.
  • Original cost budget at bid $3,720,000.00.
Posted$2,148,300.00
Accrued$61,700.00
Cost to date?
Posted$2,148,300.00
Accrued$61,700.00
Cost to date$2,210,000.00
Алхам 1 / 4

Cost to date

Add posted and accrued cost. What is the cost to date?

$2,148,300.00 + $61,700.00 = $2,210,000.00.

Bid budget
$3,720,000.00
Estimate at completion
?
Bid budget
$3,720,000.00
Estimate at completion
$3,800,000.00
Алхам 2 / 4

Estimate at completion

Add the cost to complete. What is the estimated cost at completion?

$2,210,000.00 + $1,590,000.00 = $3,800,000.00, more than the bid budget of $3,720,000.00. The job has grown, and the estimate says so.

Cost to date$2,210,000.00
Estimate at completion$3,800,000.00
Percent complete?
Cost to date$2,210,000.00
Estimate at completion$3,800,000.00
Percent complete58.16%
Алхам 3 / 4

Percent complete

Divide cost to date by the estimate. What is the percent complete, to two decimals?

$2,210,000.00 / $3,800,000.00 = 58.16%.

Алхам 4 / 4

The same cost against the bid budget

Now divide by the bid budget instead. What percent would that show?

$2,210,000.00 / $3,720,000.00 = 59.41%, against 58.16% on the estimate. The old budget overstates progress, and every revenue figure built on it would be too high.

Товчхондоо. Cost to date includes the accruals. The estimate is cost to date plus the project manager's cost to complete. The percent is one cost divided by the other.

Өөрийгөө шалгах

Асуулт 1 / 3

Which amount belongs in this month's cost to date?

  • That is a commitment. It belongs in the cost to complete until the doors arrive.

  • The cost has happened. It is accrued at the close and counts as cost to date.

  • That is future cost. It goes into the estimate at completion, not into cost to date.

  • Retainage is part of billing, not cost. It never enters the cost columns.

Асуулт 2 / 3

The project manager raises the drywall cost to complete by $40,000. Nothing else changes this month. What happens to the percent complete?

  • A bigger job with the same cost spent is less complete, not more.

  • Same numerator, larger denominator.

  • The estimate moves the day the forecast moves, and the percent moves with it.

  • Billing never enters a cost-to-cost percent.

Асуулт 3 / 3

A job has $1,350,000 cost to date and $450,000 cost to complete. The contract value is $2,000,000. What is the percent complete, cost-to-cost?

Estimate at completion $1,350,000 + $450,000 = $1,800,000. Percent complete $1,350,000 / $1,800,000 = 75%.