4C
CFO Dashboard
Pacific Cold Logistics · National operations
⚡ Shortfall Watch 🪄AI brief
7-14 day labour forecast · generated 05:00 AEST today · 87.3% accuracy (30d backtest) · scoped to National operations
🔴 High
1
act within 24h
🟡 Medium
1
act this week
🟢 Low / FYI
1
cron handling
Revenue at risk
$51,200
if no action taken
Workers impacted
24
renewals + no-shows + gap
high
⏱ Action window closes 14h
Stapylton DC · QLD
4 forklift-licensed freezer workers short for Thursday AM
Thu 14 May, 06:00
3 forecast no-shows based on recent pattern (J.Wei, A.Patel, T.O'Brien), 2 HRWL expiries today (renewals not started), 1 unanticipated leave approved yesterday (S.Chen). Higher-than-normal Wed booking volume.
Confidence
78%
🪄 AI-suggested resolutions
medium
⏱ Action window closes 6 days
Minchinbury 1 · NSW
Frozen unpack demand forecast 23% above pool capacity
Week of 19 May
Booking pipeline (8 frozen unloads) vs available freezer-trained pool (only 14 with NSW + MIN induction). Pattern: customer Q3 ramp.
Confidence
84%
🪄 AI-suggested resolutions
low
⏱ Already in flight
National
14 HRWL renewals due · 4 critical for Stapylton Sat ops
Next 30 days
Auto-renewal workflow triggered 30/60/90d out. 4 are critical-path for STA Saturday operations. M7 OH&S cron handles.
Confidence
99%
🪄 AI-suggested resolutions
🔮 Brief generated by Claude · prompts versioned in bbn_ai_eval_case · last green-tested run 2026-05-10
✦Open full Shortfall Watch brief
Revenue YTD
$181,275
▲ 22.4% vs same period last year
12 jobs invoiced
Gross Margin
38.5%
▲ Above the 35% target
$69,732 indicative — pre-Xero actuals
Pipeline Value
$234,169
18 jobs in flight
Booked + crew-allocated + on-site + in progress
Last 30 Days
$181,275
▲ tracking +8.2% MoM
Trailing 30-day completed revenue
P&L by Site
Indicative — labour cached from Xero pay-item rates · variance to actuals tracked separately · green ≥35% target · amber 25-35% · red <25%
5 sites · 5 active rate cards · 80 priced lines
| Site | Jobs done | In flight | Revenue | Indic. margin | Margin % |
|---|---|---|---|---|---|
|
Stapylton DC
Freezer · QLD
|
4 | 5 | $89,603 | $34,655 | 38.7% |
|
Minchinbury 1
Chiller · NSW
|
3 | 4 | $59,212 | $22,633 | 38.2% |
|
Jandakot DC
Freezer · WA
|
2 | 2 | $15,925 | $5,624 | 35.3% |
|
Derrimut FC
Mixed · VIC
|
2 | 4 | $12,430 | $5,409 | 43.5% |
|
Regency Park
Ambient · SA
|
1 | 3 | $4,106 | $1,411 | 34.4% |
| TOTAL | 12 | 18 | $181,275 | $69,732 | 38.5% |
🪄 AI ready: ask "why is Stapylton's margin lagging?" — answers cite the underlying jobs & rate cards.
✦Explain margin variance
✦Forecast next-month margin per site
✦Identify under-priced rate-card lines
Cash, AR & Forecast
💰 Accounts Receivable
Total outstanding · DSO 38 days · target ≤ 35 (labour-hire industry)
$76,136
across all customers · top debtor: Pacific Cold Logistics
Current $47,204
1-30d $18,273
31-60d $6,852
61-90d $2,665
90+d $1,142
Wage % of revenue
61.5%
target ≤ 65% (indicative)
Forward AR
$234,169
pipeline → invoiced in 30-45d
📈 Revenue Forecast
Trailing run-rate + pipeline conversion · 75% close · 4-6 week lead
Next 30 days
$266,028
high confidence
Next 60 days
$518,535
mid confidence
Next 90 days
$755,707
pipeline-weighted
Open quotes
14
$387,500 value
Win rate (30d)
75.0%
6 won · 2 lost
Won last 30d
$142,800
avg cycle 23d
Customer concentration
100.0%
top customer · single-customer risk
Operational Health
👷 Workforce
Live deployable workforce · cert + induction state · pipeline
Deployable today
487
all clears ✓
Freezer-trained
142
29% of deployable
On shift now
23
across 4 sites
Certs expiring 30d
8
renewal cron fires today
In recruitment
31
11-stage pipeline
First-day-ready
12
all paperwork ✓
🦺 Safety & Compliance
OH&S / WHS / CoR · last 30 days
Open incidents
2
Days since LTI
137
LTIFR (12m)
1.4
Inductions due
4
📊 Jobs in Flight
Live operational pipeline
Booked
8
Crew Allocated
5
On Site
1
In Progress
4
Complete
4
Invoiced
8
4C Group ERP · Module 11 (BI) · all data live from bbndigital production database · INDICATIVE labour cost (Xero rate cache) · ACTUAL reconciliation post pay-run