Projected Pace
$1,086,148
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 | $139,376 | $166,798 | -$27,422 | $7,582 | $0 | $166,798 | ON PACE |
| HVAC Install | $413,245 | $363,588 | $49,657 | $16,527 | $0 | $363,588 | BEHIND |
| Plumbing Service | $339,564 | $272,594 | $66,970 | $12,391 | $0 | $272,594 | BEHIND |
| Plumbing Install | $151,569 | $176,647 | -$25,078 | $8,029 | $0 | $176,647 | ON PACE |
| Electrical Service | $66,793 | $54,999 | $11,794 | $2,500 | $0 | $54,999 | BEHIND |
| Electrical Install | $34,020 | $51,522 | -$17,502 | $2,342 | $0 | $51,522 | ON PACE |
| TOTAL | $1,144,567 | $1,086,148 | $58,419 | | | $1,086,148 | BEHIND |
Opportunity Funnel — MTD (all workdays)
| Metric | HVAC | Plumbing | Electrical |
|---|
| TGL |
| Opps Booked | 161 / 159 | 352 / 145 | 135 / 50.8 |
| Opps Ran | 140 / 159 | 231 / 145 | 98 / 50.8 |
| Flips | 45 / 59 | 24 / 15 | 0 / 5 |
| TGL's Ran | 46 / 59 | 27 / 15 | 1 / 5.1 |
| Service Calls |
| Calls Booked | 536 / 484 | 586 / 440 | 171 / 154 |
| Calls Ran | 484 / 484 | 402 / 440 | 121 / 154 |
| Converted Calls | 157 / 173 | 228 / 275 | 52 / 79 |
| Conversion % | 32% / 36% | 57% / 63% | 43% / 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.