“Optimizing Inventory and Operations for Sustainable Growth”
| Project Website : | https://repo-sumit.github.io/BDM_Project/ |
|---|---|
| Viva PPT Slides : | https://rb.gy/vq3o72 |
| 🧾 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 Kumar (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 | 🖼️ Chart Example |
|---|---|
| Monthly Sales Distribution |  |
| Category Trend Line Chart |  |
| ABC Volume Segmentation |  |
| Product Correlations |  |
| Sales Forecast (Milk) |  |
- ✅ 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 🙏