Projected Pace
$982,879
below committed
New Daily Budget
$0
needed/day × 0 days left
Departments
| Department | Committed | MTD | Remaining | MTD Daily Avg | Need / Day | Pace | Status |
|---|
| HVAC Service | $230,672 | $141,768 | $88,904 | $7,088 | $0 | $141,768 | BEHIND |
| HVAC Install | $587,821 | $331,648 | $256,173 | $16,582 | $0 | $331,648 | BEHIND |
| Plumbing Service | $309,284 | $250,190 | $59,094 | $12,510 | $0 | $250,190 | BEHIND |
| Plumbing Install | $137,790 | $183,014 | -$45,224 | $9,151 | $0 | $183,014 | ON PACE |
| Electrical Service | $72,655 | $42,832 | $29,823 | $2,142 | $0 | $42,832 | BEHIND |
| Electrical Install | $30,927 | $33,426 | -$2,499 | $1,671 | $0 | $33,426 | ON PACE |
| TOTAL | $1,369,149 | $982,879 | $386,271 | | | $982,879 | BEHIND |
Opportunity Funnel — MTD (all workdays)
| Metric | HVAC | Plumbing | Electrical |
|---|
| TGL |
| Opps Booked | 140 / 180 | 355 / 132 | 125 / 46 |
| Opps Ran | 113 / 180 | 207 / 132 | 94 / 46 |
| Flips | 40 / 82 | 21 / 14 | 2 / 6 |
| TGL's Ran | 36 / 82 | 22 / 14 | 4 / 6 |
| Service Calls |
| Calls Booked | 450 / 550 | 564 / 400 | 163 / 141 |
| Calls Ran | 395 / 550 | 354 / 400 | 119 / 141 |
| Converted Calls | 131 / 240 | 214 / 250 | 49 / 104 |
| Conversion % | 33% / 44% | 60% / 63% | 41% / 74% |
Actual month-to-date / monthly budget (from the BPW). Every number here is computed live from the daily entries — no hand-linked cross-tab formulas, so it can't drift out of sync the way the workbook did.