SleepyCat — S&OP Inventory Dashboard

Weeks of Stock by Product (sorted by category · all products)

Inventory Distribution by Category

Click a segment to filter

Current vs Projected WOS (at target date · all products)

Order Urgency Breakdown

Click a segment to filter

Product Inventory & Ordering Summary

Click headers to sort, use filter row below headers to search/filter. Click any product row to drill into its SKUs. Proj. WOS includes factory pending + vendor open POs (linear arrival). OOS Risk % = weeks with projected stockout ÷ total weeks to target date.

SKU-Level Detail — Fast Movers & OOS Risk

SKUs sorted by current WOS (most urgent first). Click headers to sort, use filter row to search. Open PO = vendor POs from OPEN_POS data. Thresholds inherit from product settings.

Required Orders vs Factory Capacity

Mattress: 1,800-2,100/week. Pillows/Toppers/Pet Beds: ~4,800/week.

Order Projection — Pending Production & Target Planning

Set target date & WOS per category below (applies to all products in that category). Override per-product in the detail table. Order estimates auto-calculate.

Product-Level Detail

Order Summary — Items Needing Orders

Order Qty = max(0, Desired Inventory − Projected Inventory at Target Date). Projected Inv = Current SI + Pending (if arriving before target) − Sales Burn.

SKU-Level Order Distribution

Product order qty distributed to SKUs proportionally by L4W sales share.

Filter by Product:

Regional WOS Heatmap — Product Stock Health by Location

Rows = products sorted by 4-week sales demand (L4W). Columns = regions. Green = healthy 2-5 weeks, Orange = low 1-2 weeks, Red = critical/OOS. Grey = excess >5 weeks.

Current Inventory + Inbound by Region

Select Region:

ABC Distribution by Category

ABC Analysis by Category

A = top 60% cumulative L4W sales, B = 60-80%, C = bottom 20%. Auto-classified based on category-wise sales volume. Flags: OOS = zero inventory, Critical = WOS < 1 week.

Min WOS: Max WOS: C-Class Gurgaon Cap: CDP Mattress Max: CDP Pillow Max:

Per-Region WOS Targets (click to expand)

Region	Transit	Effective Min (+ transit buffer)
Gurgaon	2d	2.3w
Mumbai	5d	2.7w
Hyderabad	5d	2.7w
Bangalore	7d	3.0w
Chennai	8d	3.1w

Leave blank to use global Min/Max. Transit buffer added automatically. Effective Min = your Min + transit days/7.

Container Replenishment Plan by Region

Sorted by urgency (lowest WOS first). Fill % = percentage of the LAST container only. GO = ≥90%, PARTIAL = 70-89%, WAIT = <70%.

Min WOS: Target WOS:

SKU-Level Order Plan — Min 5 WOS / Target 10 WOS

Eff WOS = (Stock + Pipeline Arriving − Sales Burn) ÷ Weekly Sales at projection date. If Eff WOS ≥ Min → no order. If Eff WOS < Min → order to reach Target WOS. Factory orders → CDP. Vendor POs → distributed by region.

Recommended Actions

Immediate action items based on live data — business risks and operational red flags that need attention.

Goal vs Achievement

Current performance against target WOS and weighted in-stock goals. Goals are managed in the Google Sheet "Goals" tab.

Usage Statistics

Dashboard usage analytics — admin only. Data retained for 100 days.

Loading usage data...

Missing Data & Data Quality Check

Identifies gaps and anomalies in your data that may indicate missing entries, broken mappings, or stale information. Review and take action to improve data completeness.

Data Sources & Configuration

All data feeding into this dashboard — live Google Sheet tabs and manual configuration. Refresh data or adjust settings below.

LIVE

Google Sheet — S&OP Master

Tab	Purpose	Feeds Into	Last Updated
Inventory-2	Regional inventory & L4W	Product Health, Regional Health, Container Plan	—
PO_Status	Open vendor POs by SKU	Order Plan, Container Plan	—
GRN_Status	Goods receipt tracking	Missing Data, Data Sources	—
SKU_Weights	Dead wt, vol wt, CBM per SKU	Container Plan, Weight Analysis	—

Open S&OP Sheet ↗

All five tabs are fetched in parallel via Google Sheets publish API. Sheet must be publicly accessible or you must be logged in.

PIPELINE

Snowflake Pipeline Health

L4W + Inventory

Snowflake Data

Demand Override

MANUAL

Chat Inputs & Manual Configuration

These values were provided during dashboard building via chat. Edit inline and click "Apply" to update the dashboard in real time.

SESSION

Session Settings (Adjustable via UI)

These are adjustable through the Settings modal and the global bar. They persist in session storage and reset when you close the browser.

Setting	Current Value	Where to Change

UPLOAD

EE Sales Data — L4W Computation

Manual override: Upload EE sales CSV to compute L4W from a specific period. L4W is now auto-refreshed daily from Snowflake pipeline — use this only to compare or override with a custom date range.

UPLOAD

Pincode → Warehouse Mapping

Session override: Upload Pincode-WH Priority XLSX to update mapping for this session. The daily pipeline uses its own static maps (heavy/light_p1_map.json) — this only affects manual EE Sales L4W computation above.

Current mapping: — pincodes (non-GGN). Fallback: GGN for unmapped pincodes.

Vendor Performance data not loaded yet.

TAT Distribution

Monthly TAT Trend

Internal vs External Split

Monthly GRN Volume

Vendor TAT Comparison

Vendor Reliability Score

Vendor Emergency PO %

Vendor Performance Matrix

Warehouse TAT

Warehouse Volume

Warehouse Summary

Category TAT

Category Volume

Subcategory TAT

Subcategory Volume

Product Category × Subcategory Summary

Procurement Type Breakdown

TAT Impact: Raw vs Adjusted

Emergency POs by Vendor

Allocation Shifts by Warehouse Pair

Formality PO Tracking

Internal factory same-day POs. Excluded from TAT averages and emergency rates.

Formality POs — Monthly Trend

Formality vs Real Production (Qty)

Emergency Procurement — Vendor × SKU

Flagged PO Details

PO Fulfillment Status

PO Age Distribution

PO Detail

Retail data not loaded yet.

City: Type: Category:

Fill Rate by City

Capacity Utilization Distribution

WOS by City (Current vs Projected)

SKUs Stocked by City

Store Health Summary

City: Store: Category:

Fulfillment Plan — City Summary

Fulfillment Plan — Store × SKU Detail

City:

S&OP Inventory Dashboard