📊 BDM Capstone Dashboard – Jai Maa Jhandewali Store
“Optimizing Inventory and Operations for Sustainable Growth”
| 🧾 Detail |
📍 Information |
| Store Name |
Jai Maa Jhandewali Store |
| Location |
VP Block, Pitampura, Delhi |
| Store Type |
🛒 Family-run B2C Grocery |
| Owner |
Mr. Satyam Prakash |
| Time Period |
📅 Jan 2024 – Jan 2025 |
| Team Member |
👤 Sumit (22f2000848@ds.study.iitm.ac.in) |
- ❌ Overstocking and Stockouts (especially perishables)
- 📦 Severe Space Constraints
- 📉 Manual Operations = Limited Scalability
- 📌 Source: Primary – Digitized Records & Interviews
- 📊 Scope: Daily SKU Sales (13 items), 398 days
- 🧹 Format: Cleaned Excel Data
- 📈 👉 View Dataset on Google Sheets
| 🧠 Method |
💡 Use Case |
| 📉 Descriptive Stats |
Understand baseline sales metrics (mean, std, median) |
| 📈 Trend Analysis |
Seasonal, weekly patterns using charts |
| ©️ ABC Segmentation |
Categorize SKUs by volume share |
| 🔗 Correlation Matrix |
Relationship between product categories |
| 🤖 Linear Regression |
Basic sales forecasting (e.g., Milk prediction) |
| 📌 Insight Type |
🖼️ Charts |
| Monthly Sales Distribution |
 |
| Category Trend Line Chart |
 |
| ABC Volume Segmentation |
 |
| Product Correlations |
 |
| Sales Forecast (Milk) |
 |
💡 Recommendations Summary
- ✅ Use ABC Classification to adjust stocking
- 🧊 Apply JIT for perishable items (Milk, Butter)
- 📈 Begin with simple forecasts (Excel/Linear Models)
- 📐 Invest in vertical shelves
- 🧮 Allocate space to high-selling SKUs (Cat A & B)
- 🔄 Reconfigure layout based on correlations (FMCG + Dairy)
- 💻 Adopt POS for sales tracking
- 🛵 Offer home delivery for nearby orders
- 🧠 Use promotions tied to seasonal demand
| 📊 Financial Gains |
⚙️ Operational Gains |
🧭 Strategic Benefits |
| 💵 Increased Revenue |
📉 Reduced Stockouts |
🚀 Improved Scalability |
| 🧊 Lower Wastage Cost |
📦 Optimized Space Usage |
🤝 Customer Satisfaction |
| 💰 Better Cash Flow |
⏱️ Reduced Manual Overload |
🏁 Competitive Readiness |
- 💻 Frontend: HTML5, Tailwind CSS
- 📊 Charts: Chart.js
- 🧠 Analysis: Excel, Python
- 📋 Data Source: Google Sheets
Sumit Kumar
📧 22f2000848@ds.study.iitm.ac.in
🎓 BDM Capstone Project – IIT Madras
MIT License – For educational and non-commercial use. Attribution encouraged 🙏