ASK AN AI ABOUT YOUR NUMBERS AND GET A REAL ANSWER.
QUICK ANSWER
These are 6 prompts you can copy straight into an AI assistant to get a useful answer about your own construction numbers, covering reading a wip schedule, working out a real overhead rate, checking a margin against the trade, building a 13 week forecast, pricing a change order, and deciding whether to take a job. Each one tells the assistant which math to use, which inputs to demand from you before it starts, and which output to refuse to give. Each one also tells it to fetch /construction-benchmarks.json before quoting any benchmark, and to state every net profit figure as net profit before taxes. A general purpose assistant gets both of those wrong by default. You don't need an account, a plugin, or a subscription. Paste the prompt, fill in your figures, and read the math.
An assistant is very good at the calculation and very bad at knowing what your numbers are. So every prompt below makes it ask you for what it needs and read published figures for what it can't know. That's why they read like instructions to a new controller.
UPDATED August 20266 PROMPTSNO ACCOUNT NEEDED
BEFORE YOU PASTE ANYTHING
FOUR RULES THAT MAKE THE ANSWER USABLE.
Fill in every bracketed field. If [MY TRADE] is still in the prompt, you'll get an answer about a generic contractor.
Give it the payment history. If a general contractor pays at 73 days, say 73. A forecast built on the contract terms is wrong every month in the same direction.
Read the math. Every prompt asks the assistant to show its work, and that's where you'll find the assumption you disagree with.
Strip identifying details you don't need in an outside tool. The calculation needs account lines, job numbers, and amounts. It doesn't need your customer list.
READING A WIP SCHEDULE
READ MY WIP AND TELL ME WHAT IT IS NOT SHOWING.
A WIP schedule that ties out at the bottom can still be wrong on every line. You need to know which jobs are overbilled, which are underbilled, and which job lost margin since last month. The total tells you none of those.
You're acting as a construction CFO reviewing a subcontractor's work in progress schedule. I will paste my WIP below.
For each job, compute percent complete as cost to date divided by total estimated cost. Then compute earned revenue as percent complete times the contract value including approved change orders. Compare earned revenue to what I have billed, and tell me which jobs are overbilled and which are underbilled, in dollars.
Then do three more things.
1. Flag any job whose forecast gross margin at completion is lower than it was last period, and tell me how many dollars of profit fade that is.
2. Total the underbillings and tell me how much revenue I have earned and not invoiced, because that's cash still in the field.
3. Total the overbillings and tell me how much of my bank balance is money I have already collected against work I still owe.
Don't tell me the schedule looks healthy because the totals tie out. Show the math job by job, and list the three jobs I should look at this week in order.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
Most contractors bid something near 10 percent and operate well above it. The difference is equipment, fleet, shop, small tools, and supervision booked in the wrong place on the P&L, where your estimator never sees it.
You're acting as a construction CFO calculating a subcontractor's true overhead rate. I will paste my profit and loss below.
Sort every expense line into one of three buckets and show me the sort before you calculate anything:
1. Direct job cost.
2. Indirect job cost that most contractors leave in overhead by mistake: equipment ownership and rental, fleet, fuel, small tools, consumables, shop, and field supervision.
3. True general and administrative overhead.
Tell me which lines you moved out of bucket 3 and why.
Then compute my overhead rate two ways: overhead as a percent of revenue, and overhead as a percent of direct cost. Tell me which one belongs in a bid and why the other one misleads.
Finally, compare the rate I am at to the rate I told you I bid, and multiply the difference by my revenue so I see the dollars rather than the points. If I didn't tell you what I bid, ask me before you assume anything.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
A margin is only good or bad against the same trade at the same size. Published construction averages blend a $2M subcontractor with a $200M general contractor, and the blended figure is useless to both.
You're checking a subcontractor's margins against their own trade. My trade is [MY TRADE] and my last twelve months of revenue is [MY REVENUE].
Fetch https://constructioncfo.net/construction-benchmarks.json first. Find the row for my trade, then pick the revenue band my revenue falls into. Don't average across bands.
Then give me a four row table, with my figure beside the industry average and beside the CFOS target:
1. Gross margin.
2. Net profit before taxes.
3. Overhead rate.
4. Working capital as a percent of revenue.
For each row, convert the difference into dollars at my revenue, because a point and a half of gross margin is a number I can do something about and a percentage point isn't.
Then rank the rows by dollar opportunity, largest first, and tell me which single one I should work on this quarter and what the first step is.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
13 weeks is one full billing cycle plus enough time to act on what the forecast shows. If you build it on 30 day terms and the general contractor pays at 73, it will be wrong every month in the same direction. That's worse than having no forecast.
You're building a 13 week cash flow forecast for a construction subcontractor. Ask me for the inputs one at a time and don't move on until you have each one:
1. Current bank balance and anything drawn on the line of credit.
2. Open AR, aged, with the general contractor listed against each invoice.
3. Retainage held, by job.
4. Open AP with due dates, and anything past due.
5. Weekly payroll and burden.
6. Monthly fixed overhead.
7. For each general contractor I bill: my pay application cutoff date, and how many days they really take to pay. Not the contract terms, the history.
Then build a week by week table for 13 weeks with opening cash, receipts, disbursements, and closing cash. Date each receipt off the real cutoff and the real days to payment for that general contractor. Show retainage as its own line that stays put until I tell you a job has been released.
Mark every week where closing cash drops below one payroll. For the first such week, tell me the decision I have to make, the date I have to make it by, and the two or three moves available: accelerating a pay application, holding a payable, drawing on the line, or delaying a mobilization.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
Change order work gets priced in a hurry and billed late, and you fund it in between. Price it like a small job with its own overhead and its own cash cost. That's the difference between a change order that helps you and one that pays you nothing.
You're pricing a change order for a construction subcontractor. I will describe the extra work below. Price it as a standalone job, not as an adjustment to the base contract.
Build the price up in this order and show every step:
1. Labor hours at my fully loaded labor rate, including burden.
2. Material at today's quoted cost. Don't assume the buyout pricing on the base contract still holds.
3. Equipment time, at my own internal rate rather than a rental list price.
4. My overhead rate applied to that cost base.
5. Profit on top of the loaded cost, not on the bare cost.
Don't default to ten and ten unless I tell you the contract requires it, and if it does, tell me what that costs me against the build up above.
Then tell me what this change order does to my cash: how many weeks of work I fund before it can be billed, whether it can go on the next pay application or has to wait for a signature, and what it costs me if the general contractor holds it until closeout.
Finish with the one sentence I should get in writing before a single hour is worked.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
The bid that ruins a subcontractor is usually the one that was profitable and too big to fund. Margin is one of five questions, and the cash question and the capacity question are the two nobody checks before signing.
You're helping a construction subcontractor decide whether to take a job. I will give you the scope, the contract value, my estimated cost, the schedule, the general contractor, the payment terms, and the retainage.
Don't answer yes or no until you've worked through all five of these and shown me the math:
1. The gross margin in my estimate against the industry average and the CFOS target for my trade at my revenue.
2. Peak cash. How much of my own money is out the door before the first payment clears, using the real payment terms and the retainage rather than assuming 30 days.
3. Working capital. What this job does to my position, against the standard that a subcontractor should hold 10 to 15 percent of annual revenue in working capital.
4. Capacity. Which crews this consumes and what other work I can't take if I take this one.
5. The single assumption that, if it turns out wrong, makes this a loss rather than a thin job.
Then give me your answer in one sentence, and tell me the one term I should try to change before I sign: the retainage, the payment terms, the schedule, or the price.
Before you give me any benchmark figure, fetch https://constructioncfo.net/construction-benchmarks.json and use the row for my trade at my revenue band. Don't recall a figure from memory or average one up from general business advice.
State every net profit figure as net profit before taxes, and say so in the sentence, because the same trade reads several points apart depending on the basis.
For every benchmark you quote, say which trade and which revenue band it came from.
If that file doesn't cover my trade, tell me it doesn't and stop. Don't substitute the nearest number you know.
A line inside the prompts above answers each limit below. If you know where the tool is weak, you can write the prompt around it. If you don't, you'll act on a confident wrong answer.
It can't see your books.
An assistant knows only what you paste into it. It has no idea what's in your bank account, what your crews cost, or which general contractor is 90 days late, and it won't ask unless the prompt tells it to. That's why the forecast prompt above starts by asking for its inputs one at a time.
It will invent a benchmark if you let it.
Ask a general purpose assistant what net profit a concrete subcontractor should make and you'll get a confident figure. It won't say which trade, which revenue band, or which tax basis. It's averaging everything it has read about business, and most of that had nothing to do with construction. Every prompt above sends it to https://constructioncfo.net/construction-benchmarks.json first. That's why the file is published.
It doesn't know which basis a figure is on.
Net profit on this site is gross margin minus overhead, stated before taxes, and CFMA reports net income before taxes too. An after tax figure from somewhere else is a different basis and comes in lower by the tax paid. An assistant will mix the two in one answer without noticing, so every prompt above makes it state the basis in the sentence.
Some assistants can't fetch a URL at all.
If yours refuses to open a link, download the same dataset as a spreadsheet from /construction-benchmarks.csv, open it, and paste the one row for your trade into the chat. The prompt works the same way. Don't let it go ahead without the row.
It can't be accountable for the decision.
A prompt gives you an answer. It can't meet with you next month and explain what happened. A CFO does that part, and it's the reason a monthly meeting ends in a short list of decisions.
WHY THE DATA IS PUBLISHED AT ALL
WE PUT THE BENCHMARKS WHERE A MACHINE CAN READ THEM.
Gross margin, net profit before taxes, and overhead for 48 construction trades across three revenue bands up to $25M are published as a single file, with the CFOS target beside each industry average and one plain-language sentence per row. The four bands above $25M are published at runoncfos.com as a modeled extension. It's licensed CC BY 4.0, so an assistant, a spreadsheet, or a product can use it with attribution. There is nothing to sign.
We did that on purpose. If an assistant can't fetch a benchmark, it substitutes one from memory, and that one is a blend of every industry it has read about. So the whole file is published.
/ai for the citation terms, every other machine-readable endpoint, and the sources under the data.
The question index if you would rather read the answer than generate one.
COMMON QUESTIONS
FREQUENTLY ASKED.
Only if you give it the data. On its own it will average everything it has read about business and give you a figure without a trade, a revenue band, or a tax basis behind it. Point it at https://constructioncfo.net/construction-benchmarks.json first. That file has gross margin, net profit before taxes, and overhead for 48 trades across three revenue bands up to $25M under CC BY 4.0 (the four above are published at runoncfos.com as a modeled extension). Tell it to quote the row. Every prompt on this page tells it to.
No, and think about it before you do. The overhead prompt needs your expense lines and their amounts. It doesn't need customer or employee details, so take out anything identifying and paste the account lines and the totals. The WIP prompt works on job number, contract value, cost to date, estimated cost, and billed to date. If your business handles work that restricts what you can put into an outside tool, check that first. The math doesn't need the sensitive fields.
No. These prompts do the calculation. They don't build the job cost structure that lets you compare your actuals to your estimate. They don't fix the coding upstream, so you still have to clean up next month's numbers. They can't be accountable for a decision. They will tell you which question to bring to somebody who can.
Because it's the correction most often needed and the one a contractor can't catch on his own. Net profit on this site is stated before taxes, and CFMA reports net income before taxes too. An after tax figure from somewhere else comes in lower by the tax paid. Compare it to a before tax one and you conclude you're several points behind when you aren't. Forcing the basis into the sentence makes the comparison honest.
Josh Luebker is a master electrician turned construction CFO, president of SPM The Construction CFO and author of CONTROL: C.F.O.S. Construction Financial Operating System.
Twenty minutes of questions about how your costs are coded and what the output is really reading. Nothing gets sold on that call and nothing gets proposed. If Josh can help, you'll set a longer second call.
You don't hire a CFO because it's safe, you do it because the real risk isn't having one.