Projected Pace
$1,109,550
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 | $136,457 | $225,932 | -$89,475 | $10,270 | $0 | $225,932 | ON PACE |
| HVAC Install | $464,089 | $336,468 | $127,621 | $15,294 | $0 | $336,468 | BEHIND |
| Plumbing Service | $354,144 | $288,998 | $65,146 | $13,136 | $0 | $288,998 | BEHIND |
| Plumbing Install | $151,569 | $140,612 | $10,957 | $6,391 | $0 | $140,612 | BEHIND |
| Electrical Service | $66,793 | $64,956 | $1,837 | $2,953 | $0 | $64,956 | BEHIND |
| Electrical Install | $34,020 | $52,584 | -$18,564 | $2,390 | $0 | $52,584 | ON PACE |
| TOTAL | $1,207,072 | $1,109,550 | $97,522 | | | $1,109,550 | BEHIND |
Opportunity Funnel — MTD (all workdays)
| Metric | HVAC | Plumbing | Electrical |
|---|
| TGL |
| Opps Booked | 159 / 159 | 363 / 145 | 150 / 51 |
| Opps Ran | 136 / 159 | 257 / 145 | 99 / 51 |
| Flips | 57 / 57 | 26 / 15 | 2 / 5 |
| TGL's Ran | 45 / 57 | 24 / 15 | 1 / 5.1 |
| Service Calls |
| Calls Booked | 605 / 484 | 665 / 440 | 169 / 154 |
| Calls Ran | 514 / 484 | 456 / 440 | 112 / 154 |
| Converted Calls | 196 / 170 | 255 / 286 | 51 / 79 |
| Conversion % | 38% / 35% | 56% / 65% | 46% / 51% |
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.