Optimizing Mahak Spices

A data-driven review of sales, transport, and inventory to improve profitability and reduce waste.

Explore Analysis

🚧 Operational Challenges

📦 Overdependence on Few Spices

Turmeric and Red Chilli contribute over 75% of the revenue. This concentration increases business risk if demand or supply falters for these two items.

🚚 Transport Cost Variability

Transport costs fluctuate due to inconsistent shipments and third-party pricing changes. The lack of batching causes inefficiencies and cost leaks.

🌡️ Summer Spoilage of Spices

Red Chilli sales dip in summer due to moisture loss, weight reduction, and reduced freshness — all pointing to spoilage without proper storage.

📊 Business Data Analysis

💰 Revenue Contribution
Revenue Pie Chart
  • Turmeric (42.4%) and Red Chilli (33.3%) make up ~76% of revenue.
  • Over-reliance on two spices increases business risk.
📦 ABC Classification
ABC Pareto
  • Category A → Turmeric & Red Chilli (high revenue).
  • Category B → Dhaniya (moderate performance).
  • Category C → Cumin, Ajwain, Fennel (low-performing).
🚚 Transport Cost Trend
Transport Line Chart
  • Transport costs peaked in March, signaling inefficiency.
  • Expenses fluctuated between ₹0–₹331, showing inconsistency.
📆 Monthly Spice Sales
Monthly Sales
  • Turmeric → Steady growth and stable demand.
  • Red Chilli → Strong till Feb, then declines in summer.
  • Dhaniya → Seasonal demand spike in Mar–Apr.
  • Ajwain & Fennel → Consistently weak sales.
📉 Quantity vs Transport Cost
Scatter Plot
  • Sales usually drive higher transport cost.
  • Outliers reveal overspending even on moderate-sale days.
🔥 Correlation Heatmap
Correlation Heatmap
  • Turmeric strongly correlated with transport cost (bulky loads).
  • Red Chilli & Dhaniya → moderate correlation.
  • Ajwain & Fennel → negligible correlation.

🔍 Key Recommendations

📦 Inventory Diversification

Reduce dependency on Turmeric and Red Chilli by promoting other spices via combos, bundles, and store promotions. This improves risk resilience and boosts underperforming SKUs.

🚚 Logistics Optimization

Plan deliveries in batches and use tools like Google Maps API to optimize routes. Fixed-rate contracts with local vendors can reduce cost volatility and streamline operations.

🌡️ Spoilage Control

Prevent spoilage in summer via shaded storage, FIFO systems, and smart pricing for near-expiry stock. Maintain profitability by reducing losses from seasonal dips.

💬 Ask Your Doubts

📁 About This Project

Built using Python (Pandas, Matplotlib, Seaborn), Excel, and Bootstrap.