Weekly Profit Brief — Northwind Comfort Systems (fictional)
Week of Mon Nov 2 – Sun Nov 8, 2026 · Compared with prior week · As of Mon Nov 9, 06:00 CT
Sources: field-service export (jobs, estimates), QuickBooks export (invoices) · Metric definitions v1.0
Scorecard
- Invoiced revenue
- $48,920
- ▲ 6.1% vs prior week
- Job contribution margin
- 38.4%
- ▼ 3.2 pts vs prior week
- Overdue A/R
- $27,350
- ▲ $4,100 vs prior week
- Open estimate value
- $112,600
- 14 estimates open
- Completed jobs
- 41
- ▬ 0 vs prior week
This week's three priorities
-
Priority 1 Review the six open estimates older than 7 days
Six estimates totaling $41,200 have been open for more than seven days with no recorded follow-up. Open estimate value is not projected revenue, but these are the largest pending decisions in the pipeline this week.
Evidence: Estimates export — 6 records with status "Open", created on or before Oct 26, no activity logged since. Quoted total $41,200 (37% of open estimate value). Metric: Aging estimates, 7-day threshold.
-
Priority 2 Check job costs on the three install jobs that pulled margin down
Job contribution margin fell 3.2 points. Three residential install jobs completed this week recorded costs at 78–84% of invoiced amount; the remaining 38 jobs averaged 59%. Worth confirming whether costs were mis-allocated or whether the pricing needs a look.
Evidence: Jobs export joined to invoices — jobs J-2291, J-2297, J-2304: invoiced $23,400, attributable costs $19,100. Excludes unallocated overhead. Metric: Job contribution margin.
-
Priority 3 Follow up on two commercial invoices now 45+ days past due
Overdue receivables rose $4,100 this week. Two invoices to a single commercial account make up $11,800 (43%) of the overdue balance and crossed 45 days this week.
Evidence: Invoices export — INV-10422 ($6,900, due Sep 24) and INV-10431 ($4,900, due Sep 25), balance due in full, same customer ID. Metric: Overdue A/R, as of Nov 9.