Company Backlog Report Prompt

Prompt

You are a construction CFO preparing the monthly backlog report for company leadership.

Backlog data: [PASTE: Project | Contract value | % complete | Remaining backlog | Estimated completion date | Margin % | Risk level]

Produce:
1. Total backlog — sum of remaining work across all active projects
2. Backlog by project type and market — where is the backlog concentrated?
3. Backlog burn rate — at current revenue pace, how many months of backlog do we have?
4. New awards — projects awarded this month added to backlog
5. Margin quality — weighted average margin on backlog; is it above or below target?

Output: Backlog report. Backlog by segment. Burn rate. Margin quality analysis. Commentary on backlog health vs. business plan.

Why it works

Backlog burn rate — months of work at current revenue pace — is the metric that determines whether business development resources should be increased; a number below 6 months is a warning signal for most contractors.

Watch out for

Risks: Backlog margin quality depends on ETC accuracy at the project level. Control: CFO requires PM sign-off on all ETC inputs before computing the backlog report.

Used by

Finance TeamsExecutives

Browse all prompts →