Forecasting

Revenue Forecaster

Monthly revenue outlook, driven by the crew plan on the Labor Forecaster board →
Awards (not in QB)
Bid pipeline

Monthly revenue outlook

Trailing months show actual billing; forward months spread each job's remaining contract value across its planned crew-weeks.

How a cell is computed: a job's remaining revenue (contract − billed, from QuickBooks) is spread across future months in proportion to its crew-weeks on the Labor Forecaster board — a month with 3 guys for 4 weeks gets twice the revenue of a month with 3 guys for 2 weeks. Totals always tie back to remaining contract value. Awards not yet in QB use the value entered on their board row (e.g. Tulsa Classical $499.5K). Bids are shown only when toggled on, valued at the department's average revenue per crew-week, and are never counted in the committed backlog. Jobs with remaining revenue but no crew on the board are flagged No crew planned — their revenue has no month to land in until the board is updated.