CFO View — 13-Week Liquidity Forecast

LOC-first treasury model. JR&CO runs operating cash near $0 and uses the LOC as the working-capital instrument. Every positive cash week pays down the LOC; every negative week draws on it. LOC utilization is the metric to watch — not cash balance.

Loading CFO view…

LOC Runway

Weeks of headroom at avg weekly burn

First LOC Concern Week

First week LOC utilization ≥ 80%

Peak LOC Utilization

Coverage Backed by Live CE

LOC Headroom — 13 Week Curve

Each point shows end-of-week LOC headroom (cap minus drawn) after the model has applied projected draws and paydowns. Point color = forecast confidence for that week (green ≥ 75% backed by actual CE invoices / vouchers, amber 50–74%, red < 50% — weeks past day ~45 from now are mostly historical-pattern modeled). Shaded zone marks <20% headroom. Operating cash is held near $0 by design, so positive cash weeks pay down the LOC and negative cash weeks draw on it.

Healthy

Forecast confidence by week

Per-week net cash flow and how much of that flow is backed by live CE invoices/vouchers vs historical patterns.

Week	Net cash flow	Ending headroom	Live CE %	Confidence	Driver

Backlog → Cash Bridge

Future cash from current contracts split into work performed but not invoiced (WIP), invoiced but not collected (open AR), and contract work not yet performed (backlog).

Top 10 Jobs by Near-Term Cash Priority

Ranks open, real-revenue jobs (indirect/overhead jobs filtered out) by where the next dollars of cash are most likely to come from in the 13-week horizon. Priority = unbilled WIP (cost already incurred, typically billable next cycle) plus estimated open AR for the job. The AR figure is an approximation because CE stores AR at the customer level only; we allocate each customer's open AR to their open jobs proportionally by each job's share of that customer's billed-to-date.

Job	Customer	Unbilled WIP	Est. Open AR	Near-Term Priority	Contract	Billed-to-date Margin

Customer Concentration

Top customers by share of open AR and trailing-13-week collections. Rows are shaded red for concentration risk (> 15% of either pool) and amber for a collections gap (> $250K open AR with < 10% recovered in 91 days).

- -

Customer	Open AR	% of AR	Last 13w Collected	Recovery %	Last Payment

Job Margin Alerts

Open jobs flagged for cost-over-contract, over-budget cost, negative cash, or thin margin. Sorted by severity tier (Critical > High > Warn). Hover the tier badge for the full flag detail. Estimated loss = max(cost − contract, 0).

- -

Job	Customer	Contract	Billed	Cost	Est. Loss	Margin %	Severity

Top Movers Since Last Snapshot

Diagnostic. Largest week-by-week shifts in ending availability since the last captured snapshot.

No snapshot

Week	Prior Ending Availability	Current Ending Availability	Δ	Δ Net Cash Change

Working Capital Trend

Reference. DSO, DPO, and Cash Conversion Cycle across 4-week, 13-week, and 52-week windows. 52-week DPO/CCC suppressed today due to ce_raw.apcheck sparsity.

DSO

DPO

CCC

Forecast Accuracy

Reference. MAPE and bias of projected weekly net cash change vs actuals. Each pair uses the earliest snapshot taken at least one week before the week_start. Sparse until ≥5 qualifying weeks accumulate.

Retention Exposure

Reference. Estimated retention held against us vs retention we hold from subs. Net is what eventually flows back to cash. Low confidence today — see data-quality note inside.

Low confidence

Data quality limit. Today only a handful of open jobs have a non-zero retpcnt in CE, and zero open jobs have a non-zero subretpcnt. For a construction sub with ~$33M of in-flight work, industry-norm retention would be in the $1.6M–$3.3M range. The most likely cause is that the CE project-setup template does not populate retention percentages by default. Treat the figures below as a floor, not the full exposure, until jcjob.retpcnt / subretpcnt are confirmed with Lucas and any missing rows backfilled.

Held Against Us

From customer retention %

Held By Us

From sub retention %

Net Exposure

Positive = more inflow than outflow from retention

Jobs With Retention

Jobs contributing to the exposure

Top 10 Jobs by Net Retention Exposure

Job	Customer	Customer Ret %	Held Against Us	Sub Ret %	Held By Us	Net Exposure

Scenario Delta vs Base Phase 4 · deferred

Stress-scenario comparison (e.g., "AR collections 2 weeks late", "payroll +10%", "Top customer pays late") against the base forecast. Hidden until the scenario library and scenario-aware projection layer are built.

Not ready

Scenario library & scenario-aware projection layer required

Tracked as Phase 4 in the dashboard knowledge base. The widget structure remains in the code; once the scenario layer is built, removing the placeholder restores it.