Projected Pace
$1,025,313
below committed
New Daily Budget
$69,233
needed/day × 14 days left
Departments
| Department | Committed | MTD | Remaining | MTD Daily Avg | Need / Day | Pace | Status |
|---|
| HVAC Service | $163,332 | $24,616 | $138,716 | $3,077 | $9,908 | $67,694 | BEHIND |
| HVAC Install | $577,181 | $141,482 | $435,699 | $17,685 | $31,121 | $389,076 | BEHIND |
| Plumbing Service | $297,000 | $94,741 | $202,259 | $11,843 | $14,447 | $260,538 | BEHIND |
| Plumbing Install | $151,569 | $76,631 | $74,938 | $9,579 | $5,353 | $210,735 | ON PACE |
| Electrical Service | $89,000 | $20,574 | $68,426 | $2,572 | $4,888 | $56,579 | BEHIND |
| Electrical Install | $64,020 | $14,797 | $49,223 | $1,850 | $3,516 | $40,692 | BEHIND |
| TOTAL | $1,342,102 | $372,841 | $969,261 | | | $1,025,313 | BEHIND |
Opportunity Funnel — MTD (all workdays)
| Metric | HVAC | Plumbing | Electrical |
|---|
| TGL |
| Opps Booked | 33 / 173 | 116 / 145 | 63 / 51 |
| Opps Ran | 28 / 173 | 72 / 145 | 48 / 51 |
| Flips | 13 / 69 | 4 / 15 | 5 / 6 |
| TGL's Ran | 13 / 69 | 8 / 15 | 3 / 6 |
| Service Calls |
| Calls Booked | 138 / 528 | 208 / 440 | 72 / 186 |
| Calls Ran | 109 / 528 | 140 / 440 | 48 / 186 |
| Converted Calls | 47 / 202 | 79 / 241 | 21 / 87 |
| Conversion % | 43% / 38% | 56% / 55% | 44% / 47% |
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.