Getting Started
This dashboard helps you track inventory levels, sales velocity, and potential stock issues across all warehouses.
- Search: Use the top bar to filter by Artist, Title, UPC, or Format.
- Sort: Click any column header (e.g., "Velocity" or "Mo. Supply") to sort.
- PDF Export: Select a title from the "Title Report" section to generate an executive PDF.
Stock Alerts Logic
Items in the "Inventory Intelligence" sidebar are flagged based on specific logic:
Critical: < 3mo Supply
Trigger: When an item has less than 3 months of stock remaining based on its current sales velocity.
Calculation: (On Hand / Velocity) < 3
Catalog > 500
Trigger: When an older title (released > 18 months ago) has over 500 units sitting in stock.
Goal: Identify slow-moving catalog items incurring storage fees.
≤ 12mo > 750
Trigger: When a newer title (released within last year) has over 750 units.
Goal: Watchlist for potential overstock on recent releases.
Key Definitions
- Velocity: Average monthly sales volume (parsed from CSV).
- Mo. Supply: Estimated months until stock runs out at current velocity.
- On Hand: Total physical units available in the warehouse.
