Total Shipments
Total Logistics Cost
Avg Cost / Shipment
OTD Rate
Return Rate

Monthly Shipment & Cost Trend

OTD Rate by Carrier

Avg Cost/Kg by Carrier

Shipments by Zone

Delay Reasons

Carrier Performance Matrix — OTD vs Cost/Kg

Carrier Scorecard

CarrierShipmentsTotal Cost (₹)Avg Cost/KgOn-TimeDelayedOTD Rate

Route Performance

DestinationZoneDistance (km)ShipmentsTotal Cost (₹)Avg CostCost/KmOTD Rate

Delay Root Cause Analysis

Delay ReasonOccurrences% of DelaysAvg Delay Days

💡 Cost Optimization Opportunities

RouteCurrent Avg Cost/KgBest CarrierBest Cost/KgPotential Savings (%)

Logistics Strategic Recommendations

⚠️ Cost Leakage Alert
Analyzing carrier performance...
Recommendation: Re-route non-expedited heavy freight to optimize Cost-Per-Kg.
📊 Transit Variance Trend
Zone "East" shipments show a recurring 1.2-day transit variance during Hub Capacity spikes in Kolkata.
Recommendation: Increase lead-time safety buffer by 15% for Q4 regional distributions.
✅ Carrier Consolidation
Carrier fragmentation in Zone "South" is reducing volume-based negotiation leverage by approx. 8.5%.
Recommendation: Consolidate "Standard" tier volume into DTDC Courier to trigger Tier-2 rebate pricing.
Total Demand (24 mo)
Total Revenue
Avg Daily Demand
Peak Month
Promotion Lift

📈 Monthly Demand Trend — Actual + 3-Month Forecast

ActualForecast

🔄 Seasonality Index by Month

📅 Day of Week Pattern

📦 Demand by Category

🎯 Promotion vs Normal Demand

🎯 Forecast vs Actual — Last 3 Months (Test Set)

📊 Monthly Demand Summary

MonthUnits SoldRevenue (₹)Avg DailyPromo DaysMoM Change

📦 SKU Performance Ranking

SKUProductCategoryTotal UnitsRevenue (₹)Avg DailyTrend

🎯 Forecast Accuracy by SKU

SKUProductMAEMAPERMSEAccuracy

Demand Planning Insights

⚠️ Forecast Error Alert
SKU MOT-ELE-01HP (Electric Motor 1HP) exhibits high forecast error (84.8% MAPE) due to non-seasonal industrial spikes.
Recommendation: Shift from Make-to-Stock (MTS) to Make-to-Order (MTO) for this SKU to eliminate holding costs.
📈 Promo Cannibalization
Historical data confirms a recurring 22% demand drop in the 10-day post-promotion period for "Kits" category.
Recommendation: Align production schedules to 0.8x baseline immediately following scheduled promo bursts.
💡 Inventory Balancing
Stable demand on FLT-AIR-IND-10 (Filter Assembly Air) indicates excess safety stock levels beyond 95th percentile service levels.
Recommendation: Reduce Reorder Point (ROP) by 12% to free up working capital without risking stockouts.