The same arithmetic the dashboard applies to your live data, without connecting anything — from the forecast at completion and the WIP check to bid pricing, change orders and pay applications. Pick the question you have today.
Enter the budget, what you have spent and how far along the work is. You get the forecast two ways — performance-based and burn-based — and the verdict tells you when the two disagree, because that is usually the first sign of an overrun.
Earned value = BAC × % complete. CPI = EV ÷ AC (below 1 means you are paying more than the work is worth). EAC (performance) = BAC ÷ CPI. EAC (burn) = AC + (spend ÷ 3) × months remaining. VAC = BAC − EAC. TCPI = what the remaining work must achieve to still land on budget — above 1.1 is usually not going to happen. Months to exhaustion = (BAC − AC) ÷ monthly burn.
Over-billing improves cash and hides coming losses; under-billing starves the job of cash while the work is happening. This is the check a controller runs before agreeing the month.
% complete (cost method) = cost to date ÷ estimated cost at completion. Revenue earned = contract × % complete. Over/under billing = billed to date − revenue earned: positive is over-billed (cash ahead of the work), negative is under-billed. Retention held = billed × retention %. Cash position = billed to date − cost to date.
Upload the schedule you already have — PDF, Excel or CSV from Primavera P6, Microsoft Project, Smartsheet or Procore — or paste it in. The tool pulls the activity table out of the file and recognises the columns from their headers, so you do not have to rename anything. It then tells you which activities are behind, over budget, or both.
Recognised headers: activity / task / description · start · finish / end · % complete / percent
complete / progress · budget / cost / planned cost · actual / actual cost / cost to date. Dates can be
yyyy-mm-dd, dd/mm/yyyy or mm/dd/yyyy.
An activity is behind when its finish date is in the past and it is not 100% complete (drawn from the plan's own dates), over budget when actual cost exceeds its budget at completion, and at risk when it is both. Forecast cost at completion for the plan = actual to date + remaining budget on the unfinished activities.
A journeyman at $42 an hour does not cost $42 an hour. Burden, fringe and payroll taxes usually add thirty to forty percent, and overtime adds half again on top of that. This is the number to use when you price a change order or decide whether the weekend is worth it.
Loaded rate = base × (1 + burden%) + fringe. Straight-time cost = loaded × hours. Overtime premium = base × 0.5 × OT hours (the half again that overtime adds — the other half is the hour the crew would have worked anyway). Double-time premium = base × 1.0 × DT hours. True cost per hour = total ÷ hours, which is the figure to use when you compare it with a budget line that was priced at base rate.
Markup and margin are not the same number, and pricing a 20% margin with a 20% markup leaves money on the table on every job. Enter your costs and the margin you want to keep.
Cost basis = direct cost × (1 + overhead %). Bid price = cost basis ÷ (1 − margin % − bond %). Markup = (bid − direct cost) ÷ direct cost. Margin = profit ÷ bid. A 20% margin needs a 25% markup; a 20% markup is only a 16.7% margin.
Price the change the way the contract lets you: each cost type with its own markup, then bond and insurance on top. The breakdown is what the owner's rep will ask to see.
Self-performed = labor + material + equipment, marked up at the self-performed rate. Subcontract is marked up at its own (usually lower) rate. Bond and insurance apply to the subtotal. Check your contract's change-order clause for the markups it allows.
The arithmetic behind a G702-style pay application: work completed and stored to date, retainage held, what was already billed, and what is due this period.
Completed and stored = contract × % complete + stored materials. Retainage = completed work × retainage % + stored × stored-retainage %. Earned less retainage = completed and stored − retainage. Current payment due = earned less retainage − previous certificates. Balance to finish = contract − completed and stored, plus retainage.
Every job has to carry its share of the office, the yard and the trucks. This works out the markup your overhead needs, and the revenue where the company stops losing money.
Overhead rate = overhead ÷ revenue. Required gross margin = overhead rate + target net profit. Required markup on cost = required margin ÷ (1 − required margin). Break-even revenue = overhead ÷ gross margin — below it, jobs do not earn enough to pay for the office.
Yes, and they run entirely in your browser — nothing you type is sent anywhere. They are the same arithmetic the Constructelligence dashboard applies to your live data.
Two ways, shown side by side: budget ÷ cost performance index, and actual cost plus the remaining months at the recent burn rate. When the two disagree by more than ten percent, the job is worth looking at.
Paste or upload rows from a Primavera P6, Microsoft Project, Smartsheet or Procore activity export. The tool matches the column headers it finds, so the same sheet works without renaming anything.
These tools are manual. The dashboard does the same arithmetic across every job, every company and every week — plus the money-at-risk view, the audit findings and the overrun radar. Join the private beta and we will connect it to the systems you already run.