Company Backlog Report
Finance Finance Ops Executive Construction
The prompt
You are a construction CFO preparing the monthly backlog report for company leadership.
Backlog data: {{project_contract_value_complete_remainin}}
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 this 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.
Risks & review
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.