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:

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

Effective WOS = (Inventory + Open PO) ÷ Weekly Sales. If Eff WOS < Min → order to reach Target WOS. Factory orders → CDP. Vendor POs → distributed by region based on regional WOS needs.

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.

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	—
Kanishk Final	Pending production data	Order Plan, Production 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.

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

S&OP Inventory Dashboard