Data
How to adjust days sales outstanding for retainage and billing cycles, with a 51.6-day example
A contractor's DSO mixes retainage, bills not yet due and bills past due. This example splits a 51.6-day DSO into those pieces by owner.
Tag
WIP Schedule
Feature Data
How to track retainage aging by job and by owner, with a $1.35 million example
Retainage aging starts when the release comes due. This example sorts $1.35 million of retainage on six jobs by job, by owner and by days past due.
Data
How to measure change orders as a percent of original contract by cause, with a $100 million example
Change order rate divides approved change orders by the original contract. This example splits it by job and by cause across six jobs.
Data
How to compute backlog in months and compare it with ABC's 8.5-month August reading
Backlog in months divides signed, unearned work by annual revenue. Here is the formula ABC uses, a worked example, and how to read yours against its survey.
Data
How to measure gross margin fade across a portfolio of jobs
Fade compares each job's bid margin with its current estimate. Here is how to measure it by job, by estimator and across the portfolio.
Data
How to build a work-in-progress schedule from job cost data, column by column
A WIP schedule needs four inputs per job. Here is how each column is calculated and what it tells a CFO, with a four-job worked example.
All stories in WIP Schedule
| Date | Trend | Category | Title | Summary |
|---|---|---|---|---|
| Data | How to adjust days sales outstanding for retainage and billing cycles, with a 51.6-day example | A contractor's DSO mixes retainage, bills not yet due and bills past due. This example splits a 51.6-day DSO into those pieces by owner. | ||
| Data | How to track retainage aging by job and by owner, with a $1.35 million example Feature | Retainage aging starts when the release comes due. This example sorts $1.35 million of retainage on six jobs by job, by owner and by days past due. | ||
| Data | How to measure change orders as a percent of original contract by cause, with a $100 million example | Change order rate divides approved change orders by the original contract. This example splits it by job and by cause across six jobs. | ||
| Data | How to compute backlog in months and compare it with ABC's 8.5-month August reading | Backlog in months divides signed, unearned work by annual revenue. Here is the formula ABC uses, a worked example, and how to read yours against its survey. | ||
| Data | How to measure gross margin fade across a portfolio of jobs | Fade compares each job's bid margin with its current estimate. Here is how to measure it by job, by estimator and across the portfolio. | ||
| Data | How to build a work-in-progress schedule from job cost data, column by column | A WIP schedule needs four inputs per job. Here is how each column is calculated and what it tells a CFO, with a four-job worked example. | ||
| Accounting | Overbilling and underbilling in construction, with a worked example | Overbilling and underbilling compare what a contractor has billed with what it has earned on percentage of completion. This guide works through a $2 million job. |