Eagle Pipe Mechanical · rolling windows anchored to America/Los_Angeles · refreshes on load
Completed job count and weekly revenue move independently. Non-install work produces a narrow, stable floor regardless of volume; installs account for nearly all the variance. A staffing decision keyed to job count will therefore read the wrong signal — the number that matters is installs closed and completed.
Last 12 completed weeks. Job count shown under each bar.
Enter the weekly payroll plus fixed overhead. The model holds the service floor at its trailing average and covers the remainder with installs at the trailing average ticket.
Margin defaults to 100%, which treats the figure as a revenue target rather than a contribution target. Set it to your true install gross margin to size the threshold against contribution instead.
Days with two or fewer technicians assigned are flagged. This is where hours are at risk.
Unsold open estimates created in the last 45 days, largest first.