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

RouteAvg Cost/Kg (carriers with 80%+ OTD)Best 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.
📊 Delay Hotspot
Zone "North" has the highest delay rate: 27.0% of delivered shipments arrive late vs 20.6% network-wide. The most common causes are Customer Unavailable and Hub Capacity.
Recommendation: Add a lead-time safety buffer on North-zone lanes and review hub capacity at peak periods until the delay rate nears the network average.
✅ Carrier Consolidation
Zone "South" volume is split across 12 carriers, none above 10.2% of shipments, which limits volume-based negotiation leverage.
Recommendation: Consolidate South volume into fewer carriers, starting with BlueDart Express (100% OTD in this zone at ₹51/kg), and negotiate volume-tier rates.
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
In the 10 days after a promotion, Valves demand averages 10.2% below its non-promo baseline. Kits show no drop (+1.3%).
Recommendation: Align Valves production schedules to about 0.9x 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.