📊 BDM Capstone Dashboard – Jai Maa Jhandewali Store

“Optimizing Inventory and Operations for Sustainable Growth”

---

Project Website :	https://repo-sumit.github.io/BDM_Project/
Viva PPT Slides :	https://rb.gy/vq3o72

🏪 Project Overview

🧾 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)

❓ Problem Statement

🔴 Key Challenges

• ❌ Overstocking and Stockouts (especially perishables)
• 📦 Severe Space Constraints
• 📉 Manual Operations = Limited Scalability

---

📁 Data Collection

• 📌 Source: Primary – Digitized Records & Interviews
• 📊 Scope: Daily SKU Sales (13 items), 398 days
• 🧹 Format: Cleaned Excel Data
• 📈 👉 View Dataset on Google Sheets

---

🔬 Analysis Techniques

🧠 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)

---

📊 Visual Insights

📌 Insight Type	🖼️ Charts
Monthly Sales Distribution
Category Trend Line Chart
ABC Volume Segmentation
Product Correlations
Sales Forecast (Milk)

---

💡 Recommendations Summary

📦 Inventory Management

• ✅ Use ABC Classification to adjust stocking
• 🧊 Apply JIT for perishable items (Milk, Butter)
• 📈 Begin with simple forecasts (Excel/Linear Models)

🧱 Space Optimization

• 📐 Invest in vertical shelves
• 🧮 Allocate space to high-selling SKUs (Cat A & B)
• 🔄 Reconfigure layout based on correlations (FMCG + Dairy)

🚀 Business Growth

• 💻 Adopt POS for sales tracking
• 🛵 Offer home delivery for nearby orders
• 🧠 Use promotions tied to seasonal demand

---

📈 Projected Impact

📊 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

---

🛠️ Tech Stack

• 💻 Frontend: HTML5, Tailwind CSS
• 📊 Charts: Chart.js
• 🧠 Analysis: Excel, Python
• 📋 Data Source: Google Sheets

---

🧠 Author

Sumit Kumar
📧 22f2000848@ds.study.iitm.ac.in
🎓 BDM Capstone Project – IIT Madras

---

🪪 License

MIT License – For educational and non-commercial use. Attribution encouraged 🙏

---