Labor + Revenue Forecast — Combined Forecast View (mockup)

expected spend expected revenue · Horizon: 30 months

each cell: spend $ over revenue $ — left columns follow the same pattern

▼ HVAC DEPARTMENT 5 active projects · $1.7M remaining cost · $2.2M remaining revenue

Project	Spent / Est Billed / Contract	Remaining	Jun '26	Jul	Aug	Sep	Oct	Nov	Dec	Total
24372 Rudisill Library HVAC ⚠	$1.1M / $1.1M101% spent $1.13M / $1.21M93% billed	-10K 80K	— —	— —	— —	— —	— —	— —	— —	$0 $0
25248 Collinsville 5th Grade Center ⚠	$333K / $1.2M28% spent $410K / $1.45M28% billed	856K 1.04M	128K 156K	154K 187K	171K 208K	154K 187K	128K 156K	86K 104K	35K 42K	856K 1.04M
26109 MK Tooling	$30K / $45K68% spent $35K / $52K67% billed	14K 17K	8K 9K	6K 8K	— —	— —	— —	— —	— —	14K 17K
26110 Bixby Police	$17K / $805K2% spent $21K / $958K2% billed	788K 937K	— —	— —	118K 140K	158K 187K	197K 234K	178K 211K	137K 165K	788K 937K
26154 Rogers Co Health Warehouse ⚠	$0 / $83K0% spent $0 / $97K0% billed	83K 97K	— —	— —	— —	— —	— —	— —	— —	$0 $0
HVAC Total		1.73M 2.17M	136K 165K	160K 195K	289K 348K	312K 374K	325K 390K	264K 315K	172K 207K	1.66M 1.99M

▼ PLUMBING DEPARTMENT 3 active projects · $1.15M remaining cost · $1.4M remaining revenue

Project	Spent / Est Billed / Contract	Remaining	Jun '26	Jul	Aug	Sep	Oct	Nov	Dec	Total
24373 Rudisill Library Plumbing	$467K / $522K89% spent $506K / $580K87% billed	55K 74K	28K 37K	27K 37K	— —	— —	— —	— —	— —	55K 74K
25249 Collinsville 5th Grade Plumbing	$198K / $890K22% spent $246K / $1.08M23% billed	692K 834K	69K 83K	104K 125K	138K 167K	138K 167K	104K 125K	87K 105K	52K 62K	692K 834K
26110 Bixby Police Plumbing	$9K / $410K2% spent $0 / $492K0% billed	401K 492K	— —	— —	40K 49K	60K 74K	100K 123K	100K 123K	101K 123K	401K 492K
Plumbing Total		1.15M 1.4M	97K 120K	131K 162K	178K 216K	198K 241K	204K 248K	187K 228K	153K 185K	1.15M 1.4M

COMBINED MONTHLY TOTALS HVAC + Plumbing · $2.88M remaining cost · $3.57M remaining revenue

Department	Remaining	Jun '26	Jul	Aug	Sep	Oct	Nov	Dec	Total
HVAC	1.73M 2.17M	136K 165K	160K 195K	289K 348K	312K 374K	325K 390K	264K 315K	172K 207K	1.66M 1.99M
Plumbing	1.15M 1.4M	97K 120K	131K 162K	178K 216K	198K 241K	204K 248K	187K 228K	153K 185K	1.15M 1.4M
Grand Total	2.88M 3.57M	233K 285K	291K 357K	467K 564K	510K 615K	529K 638K	451K 543K	325K 392K	2.81M 3.4M

Read-only view. Click any project row to open its allocation editor. Labor view unchanged (labor $ over crew).