Inventory Control Tower

Sign in to continue

← Hub

Inventory Control Tower

As-of —
Overview
Warehouses
Inbound / Landings
Assortment
Program SKUs
Inventory Health
Action Center

Inventory on Hand — Last 12 Months

reconstructed actual snapshot

Pre-today line is reconstructed from invoice outflows & PO receipts — best-effort, may be off ±5–10% (credit memos, inter-warehouse transfers, sample lines, and SAP adjustments are approximated). The solid segment is the actual nightly snapshot, captured starting today going forward and reconciled to SAP totals each run.

Inventory by Warehouse

4 markets · click to filter

Inbound Landing Calendar

Next 13 weeks

Top Brands by Value

Top 15

By Country

Top 15

Category Mix

Wine vs Spirits

What this shows

On Hand: physical cases in the warehouse.

Committed: allocated to open sales orders.

Available: on hand minus committed — what's truly sellable today.

On Order: inbound cases on open POs, not yet landed. Aggregate SAP figure — includes both supplier purchases and inter-warehouse transfers in flight.

Purchase vs Transfer: on Inbound / Landings, purchases are external-supplier POs; transfers are Massanois → Massanois (SBC1 → CAW1/ILW2/ICW1) rebalancing shipments.

Inventory Value: landed-cost × cases on hand, from SAP.

Totals match the Inventory & Purchasing app via SAP-canonical fields (Cases_On_Hand, Total_Committed_Cases, Total_Available_Cases, Total_Inv_Value). 4 operating warehouses: NY/NJ (SBC1), CA (CAW1), IL (ILW2), DC/VA (ICW1). Credit memos and sample invoices excluded from depletion math.

Warehouse Comparison

Current inventory + 30-day depletion + implied months-of-supply

Landing Timeline

—

By Destination Warehouse

By Supplier

Top 20

Inbound Detail

—
Delivery Dest Flow PO# Brand Product Vintage Country Supplier Cases Unit Value

Programs Overview

Sorted by placements · click to drill into SKUs
Status Program Placements Primary Wine Fams Vins Avail Wks On Order $ Value

All Program SKUs

—
No Action <4 wks supply AND nothing on order or in transfer — intervention needed Action Taken low or zero on-hand BUT PO/inbound/sibling vintage is in place Low 4–8 wks supply — watch Healthy >8 wks supply
Status SKU Brand Product Vin WH OH Cmt Avail On Ord T90 Wks $ Value
—
Status SKU Brand Product Vintage WH Program On Hand Cmt % Cmt Avail On Order T90 Dep Wks Supply Stockout Next Inb Gap $ Value

How these statuses are calculated

Every SKU × warehouse is placed into exactly one bucket
No Action
True stockout, nobody is fixing it yet. Less than 4 weeks of supply at this warehouse (or already at 0) AND nothing on the way: no open PO, no inbound transfer, and no other vintage of the same wine sitting in stock to bridge the gap. Programmed SKUs (WFM / AWAS) are excluded — those are handled on the Programs tab. Action: order, transfer, or sell something else.
Action Taken
Low or out of stock, but a fix is already in motion. Same <4 weeks / 0 on-hand trigger as above, but at least one of these is true: (a) there's an open PO with cases on order, (b) an inbound landing is scheduled, or (c) a different vintage of the same wine is in stock at another warehouse we could pull from. Action: watch the timing gap — flag only if the inbound slips.
Overstock
Too much inventory relative to the pace it's selling. More than 52 weeks of supply (over a year) based on the last 90 days of invoice sales. The wine is selling — just not fast enough to burn through what we're holding. Action: pause reorders, push to reps, consider programs or promo.
Slow Mover
Between 6 and 12 months of supply. Not yet an overstock, but the pace is light enough that it's worth watching before the next shipment lands. Action: monitor; slow down replenishment on the next round.
Dead Stock
Stock on hand, no sales in the last 6 months. On hand > 0, inventory value > $100, zero cases sold in the trailing 180 days, and nothing new landed in the last 180 days and no open PO. (Products we just received or have on order are excluded — they haven't had time to sell yet.) Action: markdown, close-out, or channel dump.
Healthy
Roughly 4–26 weeks of supply and no other red flag. Also catches newly-landed products that haven't sold yet — those aren't dead, they're ramping.

How "weeks of supply" is calculated: Available cases ÷ (last 90 days of case sales ÷ 13). So a SKU with 52 available cases that sold 26 cases over the last 90 days has a 90-day weekly pace of 2 cases/week, which is 26 weeks of supply. Velocity uses invoice data only — credit memos and sample lines are excluded so depletion reflects real sell-through. Bucketing is per SKU × warehouse, so the same wine can show up as Overstock in NY and No Action in CA.

Loading...
Brand

—

—
Loading…