# Warehouse Leadership Dashboard Multi-level operational intelligence dashboard built with Streamlit + Plotly. ## Setup ### 1. Install dependencies ```bash pip install -r requirements.txt ``` ### 2. Add your data files Place all 4 Excel files inside the `data/` folder: ``` data/ ├── table1_shift_level.xlsx ├── table2_worker_level.xlsx ├── table3_weekly_warehouse.xlsx └── table4_cwm_cluster.xlsx ``` ### 3. Run the dashboard ```bash streamlit run app.py ``` The dashboard opens at http://localhost:8501 --- ## File Map (where to make changes) | What you want to change | File | |---|---| | Overall layout, CSS theme, tab names | `app.py` | | Shift Incharge visuals | `tabs/shift_incharge.py` | | Warehouse Manager visuals | `tabs/warehouse_manager.py` | | CWM visuals | `tabs/cwm.py` | | KPI formulas (SER, EMI, CES, IVV, etc.) | `utils/kpi_computations.py` | | Chart colors, card styles, Plotly theme | `utils/chart_helpers.py` | --- ## Novel KPIs Summary ### Tab 1 — Shift Incharge - **SER** — Shift Efficiency Ratio (actual vs target throughput) - **EMI** — Error Momentum Index (EWMA of pick error rate, λ=0.3) - **CES** — Crew Entropy Score (Shannon entropy of worker productivity) ### Tab 2 — Warehouse Manager - **IVV** — Inventory Velocity Volatility (rolling 8-week CV of turnover) - **Op-VaR** — Operational Value at Risk (µ + 1.645σ of delayed orders) - **WEDR** — Workforce Efficiency Decay Rate (OLS slope of productivity) ### Tab 3 — Cluster Warehouse Manager - **CPS** — Cluster Pulse Score (quadratic penalty on OTIF & accuracy gaps) - **NSI** — Network Stress Index (volume-weighted stress share per warehouse) - **WMS** — Warehouse Momentum Score (sigmoid of EWMA ROC of OTIF) # dash