Inventory Overview
▾Pipeline status
Units in production, in transit, and at supplier — the inbound pipeline behind sellable stock.
▾Stock status
SKUs by stock status — same buckets as the KPIs and the Demand & Forecast table
Inventory
Stock by warehouse and shipment pipeline.
Stock by warehouse
Where each SKU's units sit. Filter by location. Supplier stock and the transit local/intl split are filled in manually (raw/supplier-stock.json · raw/transit-split.json) — “—” = not entered yet.
| Product | Brand | Bol LVB | FFC | i4U | Transit · Local | Transit · Intl | Supplier | Total |
|---|
🚚 Shipment monitoring (in-transit pipeline)
In-transit & in-production volumes from the latest inventory value sheet (temporary source — flagged stale below). I4Y live
/shipments takes over for transit once shipment data flows; MatotZo "Inkoop" is the future live source for production.Issues & solutions tracker 🔜 Planned
Structured log of supply chain exceptions and resolutions
A running log of supply chain issues (stockouts, delayed POs, quality holds) with assigned owners and resolution status. Bridges operational decisions to the data layer.
Local Transfers
Recording and editing warehouse-to-warehouse transfers isn't available in this published snapshot. Non-delivered transfers are already reflected as Transit · Local in the numbers shown elsewhere in this dashboard.
Order Fulfillment
Open orders and at-risk-to-fulfil signals.
📋 Order Fulfillment
Open orders + at-risk to fulfil — ChannelDock
Reorder
What to reorder and when — plus the combined cash impact of committed PO payments and projected future reorders.
🛒 What to reorder
Urgency-sorted · reorder-by = supplier deadline (lead time + safety, closure-adjusted) · Jim approves all POs · 'overdue' can already be placed but not yet formalized — verify first.
| Product | Reorder by | Days | Qty (cartons) | Est. value | Status |
|---|
Reorder timeline — when to place each PO
Each marker = a SKU's reorder-by date (today + cover − lead time − 14d safety, closure-adjusted). Next 12 months.
overdue / ≤30d30–90d>90d⚠ closure-risk
⚠
Heads-up: 'overdue' items may already be processed (placed) but not yet formalized in our documentation — verify before acting.
🧭
How to read it. Two replenishment signals. Channel restock = sellable runway (Bol+FFC) is low but i4U warehouse stock is available → ship internally, fast. Supplier PO = total cover is running below the lead time (sea freight ~6–14 wks) + 2-week safety → reorder by the date shown (Jim approves, round to full cartons). 'Sellable runway' is days left at the marketplace; the reorder-by date is the supplier deadline.
→ Open source report
🛒 Supplier PO due — reorder by date (lead time + 2wk safety)
Sea freight 6–14 wks · Jim approves all POs · round up to full cartons
Twee hefbomen bij lage dekking: 🛒 bijbestellen óf 📈 prijs verhogen om de vraag te remmen tot een PO landt (elasticiteit-aanname e≈−1,5).
🔄 Channel restock — push i4U → Bol/FFC (internal, fast)
Sellable runway low but warehouse stock available
Purchase orders
💱 Landed cost · purchase orders
Bottom-up vs. sheet comparison
| Product | Bottom-up €/u | Sheet €/u | Diff |
|---|
Purchase Orders
The full PO cockpit — orders in progress, history, documents, suppliers, tensions. (Embedded; opens the same data as /po/.)
Suppliers
Per supplier: products, lead time, payment terms and inventory value.
| Supplier | Brands | SKUs | Lead time (assumed) | Actual lead time | Payment terms | Inventory value |
|---|
Products per supplier
Demand & Forecast
Full SKU table with run-out forecast, plus seasonality patterns. Default sort: soonest stock-out.
Full SKU forecast — 40 products
Default sort: soonest stock-out. Click a header to re-sort.
| Product ↕ | Seg | Brand | Status | Supplier | Sellable | Inventory | i4U | Transit | Plan/day · Peak | 30d sold | Sellable runway | Stock Days | OOS date | Lead | Reorder by | Rec. qty | Inv. value |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Critical <14d sellable
Reorder 14–29d
Watch 30–45d
Healthy 46–120d
Overstock >240d
Dormant / no sales
Plan/day = planning run-rate (the demand driver for safety stock & reorder math). Peak = recent realized peak; ⚡ = spike risk flagged. Seg = ABC/XYZ segment (A/B/C demand tier · X/Y/Z variability).
MAX ROD = total available stock ÷ peak velocity, the conservative run-out estimate.
"Reorder by" date comes from the report's reorder-summary tab (lead-time adjusted); OOS date is Jun 8 + MAX ROD.
Inventory value joined from the May 31 valuation sheet (blank for SKUs added after May, e.g. SOTSU/VAWVVA).
Demand Variance 🔜 Planned
Forecast vs actual — ingest Raghan's report
Side-by-side comparison of demand forecast against actual sales per SKU and month. Will highlight over/under-forecast items for procurement adjustments once Raghan's demand report is integrated.
Seasonality — units sold per month
Builds out as the sales-history cache fills (nightly). Travel products (packing cubes, WTA) typically peak in July.
Financial Supply Chain
Where your inventory cash is tied up, cashflow obligations, and monthly valuation history.
Where's my cash — by location
Inventory value distributed across stock locations (unit-proportional)
Where's my cash — by velocity band
Inventory value split by stock cover / days-of-supply
B2B / iBood liquidation candidates
| Product | Brand | Supplier | Cover | Value |
|---|
📚 Monthly valuation archive (month-end reporting)
Backward-looking valuation history — not a daily-decision surface.
Inventory value trend
On-hand stock value · Jan → May 2026 (EUR)
Units & expected revenue
Total units (bars) vs expected revenue excl. VAT (line)
Total units
Expected revenue (Mar→May)
Value by brand, per month
Stacked inventory value (EUR) — Remodius dominates by value
Remodius
Massagerr
ProtoArc
Nomadius
Jan & Feb use the older sheet format (no status split, no expected-revenue column) — those metrics start in March.
All sheets owned by ProActiveChain in Google Drive; access via [email protected].
Profit Forecasting & Calculator 🔜 Planned
Forward profit from demand × margin
Interactive calculator projecting gross profit from forecasted demand multiplied by per-SKU margin. Will integrate with the demand forecast tab once the sales-history cache is fully populated.
DIO = 365 ÷ turnover. Turnover/DIO need the full sales-history cache (populating nightly) — values settle once it's complete.
Margin, GMROI, Turnover & DIO by brand
Gross margin = (RRP excl VAT − buffered landed cost) ÷ RRP. Gross GMROI = annual gross profit ÷ inventory cost. Contribution GMROI = annual contribution profit (CM2: after channel commission, delivery & pick/pack fees — excludes ads) ÷ inventory cost. CM3 GMROI = CM2 minus Bol ad spend ÷ inventory cost (Bol ads only; Meta excluded). TACoS = Bol ad spend ÷ revenue. Landed costs: Master Product Sheet 2026 tab (+10% buffer) + SOTSU from the Launch Program. 34/40 SKUs costed; VAWVVA/SOTSU show — (no contribution data yet).
| Brand | Gross margin | Gross GMROI | Contribution margin | Contribution GMROI | CM3 GMROI (after Bol ads) | TACoS | Turnover | DIO |
|---|
Working Capital & Cash Conversion Cycle
Cash Conversion Cycle = days cash is tied up: inventory + receivables − payables.
Returns (portfolio-level)
Roadmap
What's not built yet — connections to make, data still to fill, and tabs/reports to add or optimise.
About this hub
Where every number comes from, and how often it refreshes.
Sources
Live connections and reference data
A live inventory & supply-chain cockpit for Brands Den — stock, replenishment, demand, finance and suppliers in one place. Live stock & sales refresh on demand; reference data refreshes monthly.
🔌 Live Connections live
- 📦 ChannelDock — stock per channel (LVB/FFC) + cartons
- 📈 FiveX — sales velocity (orders cache)
- 🗃️ PIM — product master (EAN/brand)
- 🏭 Import4you (i4U) — warehouse stock (fallback)
📄 Reference Data monthly
- Inventory Report — bi-weekly reorder overview
- Inventory Value Sheet — monthly valuation
- Master Product Sheet — landed costs (+10%)
- Supplier terms & POs — lead times
Reference data snapshot — not editable in this published view.
Valuation source:
Feed freshness
How old the live pulls are