Operations & Fulfillment
O3: Ship every order right, on time, every time.
Operations · Lead: John Windham
Showing OKR-aligned content for O3, O1 — Fulfillment, inventory cover, OTIF, and Ops–Sales forecast handshake
Inventory Intelligence
Demand-supply intelligence from the BigQuery lakehouse — forecast vs. fulfilled vs. on-hand, forward SKU action queue, and supply-side PO receipts.
Showing mock data — BigQuery query failed for 5 sources
Live lakehouse marts could not be loaded. Values below may not reflect production data.
Forward Outlook — SKU Action Queue
O3·KR5SKUs needing action
0
< 60% of remaining 30d demand covered
SKUs on watch
1
60–99% of remaining 30d demand covered
Horizon
30-day forward forecast
3 inventory SKUs · click a row or RYG circle for details
| SKU | Category | Product | 30d Forecast | MTD Fulfilled | Remaining | On-hand | Short | Cover % | 30d RYG | Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| PC-MOCHA-14CT | Core | Protein Coffee Mocha 14ct | 14K | 4K | 10K | 8K | 2K | 84% | Watch | ||
| PC-VAN-14CT | Core | Protein Coffee Vanilla 14ct | 13K | 5K | 8K | 15K | 0 | 193% | On track | ||
| PC-ORIG-14CT | Non-Core | Protein Coffee Original 14ct | 12K | 4K | 8K | 22K | 0 | 282% | On track |
Monthly Forecast vs. Fulfilled
O3·KR5Monthly Shipped vs. Received (Actual PO Receipts)
O3·KR2Outbound ship vs. inbound ITEMRECEIPT only — not total business fill rate.
Total Demand vs. Fulfilled
O3·KR2Open Backlog — Unfilled Lines by Order Month
O3·KR2Not total business fill rate — see Total Demand vs. Fulfilled above for all-order volume.
Top SKUs by Units Short
O3·KR5Data Sources for Operations
O3 Key Results
Achieve 99% B&M on-time by Q4 from Q2 baseline.
Owner: John Windham, Jonathan Bradford | Data: Camelot, ShipStation
Prevent OOS instances by shipping 95%+ of orders in full.
Owner: Operations, Fulfillment | Data: Camelot, NetSuite
Reduce freight cost as a percent of net revenue by 2 points from Q2 baseline by Q4.
Owner: Jonathan Bradford, Finance | Data: ShipStation, NetSuite, WEX
Reduce fulfillment error cost by 50% from Q2 baseline by Q4. Tracked separately for DTC and B&M.
Owner: Jonathan Bradford | Data: Camelot, Confido
Maintain 5 weeks of inventory on core SKUs and 3 weeks on non-core by Q3. Stretch: 6 weeks core.
Owner: John Windham, Ops | Data: Camelot, NetSuite
Reduce standard order-ready lead time to 7–10 business days after PO receipt by Q4.
Owner: Operations, Sales | Data: Camelot, Production Schedule