Builds the 13-week forecast.
AR with collection probability by customer. Retention release tied to job completion. AP commitments by week. Backlog conversion off the WIP. Stated vs risk-weighted, side by side.
Forecasting Analyst
A 13-week cash forecast that updates itself. Every Monday.
Builds your rolling cash forecast from AR, retention timing, and AP commitments. Runs scenarios on collection risk and backlog burn. Flags the gap before it shows up in the bank account.
A cash forecast that moves with the work.
Runs the scenarios.
What if Cedar Grove pays 30 days late? What if the new MEP package lands a week behind? Sensitivity on each input. Top three drivers ranked.
Flags collection risk before it bites.
Customer aging plus payment history plus current sentiment from PM calls. The customer drifting from 45 days to 60 surfaces with a name, not a percentage.
Updates as the data moves.
New billing posted, new draw received, new PCO approved. The forecast moves. Controller sees the delta from last cycle without re-running anything.
13 weeks. 9 customers. $1.2M gap surfaced.
FORECASTING ANALYST · RUN #104 · MONDAY 6:45AMLive
Inputs collected
- AR aging$9.4M outstanding, weighted average DSO 47 days.
- Retention$1.6M held across 9 jobs, releases scheduled by completion %.
- AP commitments$7.2M in open POs, weekly payment schedule built.
- Backlog$42M signed, conversion modeled off the WIP.
Outputs produced
- 13-week forecastStated cash position vs risk-weighted. $1.2M gap in week 9.
- ScenariosThree runs: base, 30-day collection slip, MEP package delay.
- Risk register3 customers flagged for collection follow-up.
- DeliveredCash forecast to CFO, controller. Customer-specific notes to AR lead.
See the gap. Before it shows up in the bank.
A 20-minute walkthrough where we run the forecasting analyst on a sample of your jobs. You decide whether you'd want it running every Monday.