Labor Forecaster · Labor view

"Can we afford this crew?" — three ways to show it

Same data in all three options. The math: projected burn = crew × weekdays × 8h × dept burdened rate. The HVAC rate here is $52.40/hr fully burdened — calculated automatically from your existing paycheck + burden data (field wages + taxes + comp + benefits ÷ field hours, per department, trailing 90 days — same data Labor Burn Analysis reads). September example: 4 guys × 22 weekdays × 8h × $52.40 = $36.9K projected vs $44.6K budgeted → room for almost one more guy.

fits — ≥½ guy of room tight — within ±½ guy busts — ≥½ guy over budget

ATraffic-light crew box — color only, hover for the math

The Labor view stays exactly as it is today — the crew box just picks up a feasibility color. Hovering (or tapping on mobile) shows the full math. Pro: zero added clutter, the page looks identical until something's wrong. Con: no magnitude at a glance — red tells you it busts, not by how much, until you hover.

▼ HVAC DEPARTMENTlabor $ over crew · crew color = budget feasibility

Project	Jul '2623 wkdays	Aug21	Sep22	Oct22	Nov21	Dec23
26110 Bixby Police	22.3K 2	22.3K 3	44.6K 4	44.6K 4	33.5K 3	18.6K 3
25248 Collinsville 5th Grade	31K 3	31K 3	22K 2	19K 2	13K 1	7K ·
HVAC Total	53.3K 5	53.3K 6	66.6K 6	63.6K 6	46.5K 4	25.6K 3

BDelta line — "+0.8 room" / "0.5 over" written under the crew box

Adds a third micro-line to each month cell saying the headroom in guys — your language: "room for one more" or "too many." Color matches the state. Pro: the answer is right there, no hovering; magnitude visible across the whole board at once. Con: rows get ~10px taller and there's more ink on screen — busiest of the three.

▼ HVAC DEPARTMENTlabor $ over crew · third line = headroom in guys

Project	Jul '2623 wkdays	Aug21	Sep22	Oct22	Nov21	Dec23
26110 Bixby Police	22.3K 2 +0.3 room	22.3K 3 0.5 over	44.6K 4 +0.8 room	44.6K 4 +0.8 room	33.5K 3 +0.8 room	18.6K 3 1.1 over
25248 Collinsville 5th Grade	31K 3 +0.2 room	31K 3 +0.5 room	22K 2 +0.4 room	19K 2 +0.1 room	13K 1 +0.5 room	7K · unstaffed
HVAC Total	53.3K 5 +0.5 room	53.3K 6 +0.1 room	66.6K 6 +1.2 room	63.6K 6 +0.9 room	46.5K 4 +1.3 room	25.6K 3 0.3 over

CPlanned / affordable — the crew box reads "3 / 2.5"

The crew box shows two numbers: what you planned, then what the budget can actually carry that month (budget ÷ per-guy month cost). "3 / 2.5" = planned 3, can afford 2.5. Box color still flags the state. Pro: answers both questions at once — am I over, AND what's the max crew I could run. Same row height as today. Con: two numbers in one box takes a beat to learn; needs a one-time legend read.

▼ HVAC DEPARTMENTlabor $ over crew · crew box = planned / affordable

Project	Jul '2623 wkdays	Aug21	Sep22	Oct22	Nov21	Dec23
26110 Bixby Police	22.3K 2 / 2.3	22.3K 3 / 2.5	44.6K 4 / 4.8	44.6K 4 / 4.8	33.5K 3 / 3.8	18.6K 3 / 1.9
25248 Collinsville 5th Grade	31K 3 / 3.2	31K 3 / 3.5	22K 2 / 2.4	19K 2 / 2.1	13K 1 / 1.5	7K · / 0.7
HVAC Total	53.3K 5 / 5.5	53.3K 6 / 6.1	66.6K 6 / 7.2	63.6K 6 / 6.9	46.5K 4 / 5.3	25.6K 3 / 2.7

Notes that apply to all three: the dept rate auto-refreshes from real payroll data, so it tracks raises and burden changes without anyone maintaining it. The same feasibility math could also run inside the project editor (live, as you type crew numbers) once you pick a representation here. Options can combine — e.g., A's coloring + C's affordable number is what C already shows; A now, B/C later is also a valid path. The "0.7 affordable on a $7K unstaffed month" case (Collinsville Dec) is shown gray on purpose: no crew planned means no projection, but the affordable number still tells you what the budget could carry.