Finance-Driven Supply Chain Intelligence
Executive overview · Flipkart SCFI Platform · FY 2024–25 · All Regions · Figures in ₹ Crores
GMV & Revenue Trend
Monthly performance · ₹ Crores · FY 2024–25
GMV
Net Revenue
Target
Region-wise Margin %
Contribution margin by geography
P&L Finance Waterfall
Revenue to Net Profit bridge · ₹ Crores
Supply Chain Cost Split
Cost component distribution · FY25
End-to-End Supply Chain Control Tower
Goods flow · Cost accumulation · Margin erosion at each stage
CFO War Room — Financial Intelligence Command
Cash blocked · Margin erosion · Cost leakage · Regional risk · Profitability drivers
💰 Cash Blocked in Supply Chain
₹1,240 Cr
Inventory + receivables + transit. Reducing DIO by 8 days could free ₹84 Cr.
⚠️ Margin Erosion YTD
-₹186 Cr
Returns ₹94Cr + operational leakage ₹62Cr + fraud/damage ₹30Cr.
📦 Inventory Carrying Cost
₹312 Cr
Dead stock at ₹312Cr. BLR-07 alone holds ₹31Cr idle inventory.
🚚 Logistics Cost Overrun
+₹48 Cr
Above budget. Air freight overuse driving 34% of freight spend.
🔄 Reverse Logistics Loss
₹94 Cr
9.4% return rate. South India returns highest at 14.2%.
🏆 Procurement Savings
₹186 Cr
8.8% of total spend. ₹156 Cr additional opportunity identified.
Quarterly P&L Performance
Revenue · Cost · EBITDA · ₹ Crores
Supply Chain Cost % of Revenue
Monthly trend vs industry benchmark
Category-wise Contribution Margin
Margin % by product category
Cost Reduction Opportunity Pipeline
Identified vs realized savings · ₹ Crores
Inventory Optimization Command Center
Stock health · Aging analysis · Turnover · Stockout risk · Overstock alerts
4.8x
Inventory Turnover
Target: 5.2x
76 days
Days Inventory Outstanding
Industry: 68 days
₹312 Cr
Dead Stock Value
3.7% of inventory
₹48 Cr
Stockout Lost Sales
↓ 12% MoM
Inventory Health by Category
Fast / Slow / Dead / Overstock split · ₹ Crores
Fast Moving
Slow Moving
Dead Stock
Overstock Risk
Demand Forecast — AI Model
Predicted demand with seasonal spikes · Units (M)
Actual
Forecast
Confidence Band
Warehouse Inventory Status
₹ Crores locked by distribution center
Logistics Cost Analytics
Freight cost · Mode mix · OTIF performance · Last-mile efficiency · Route optimization
₹348
Cost per Shipment
▲ 4.2% QoQ
91.4%
OTIF Rate
Target: 93%
2.4 days
Avg Delivery Time
Target: 2.0 days
₹672 Cr
Total Freight Spend
8% of GMV
Freight Mode Split
Cost share by transport mode · FY25
Monthly Freight Cost Trend
By transport mode · ₹ Crores
Region-wise Logistics Performance
OTIF · Avg Delay · Cost Index · Fill Rate · Radar view
North
South
East
West
Warehouse Operations Monitor
Utilization · Throughput · Picking accuracy · Labor efficiency · Financial health per DC
84.7%
Avg Fill Rate
Target: 88%
99.1%
Picking Accuracy
▲ 0.3pp MoM
3,240
Units/Hour Throughput
▲ 8.2% QoQ
₹18.4
Labor Cost / Unit
Industry: ₹16.2
Warehouse Utilization by DC
Capacity usage % across 8 distribution centers
Monthly Throughput Trend
Units processed per month · Millions
Warehouse KPI Scorecard — All DCs
Financial health · Utilization · Labor · Margin per distribution center
Procurement Finance Intelligence
Vendor performance · Spend analytics · Savings pipeline · Supplier risk matrix
₹186 Cr
Procurement Savings
8.8% of spend
₹2,100 Cr
Total Procurement Spend
25% of GMV
247
Active Vendors
18 high risk
42/100
Avg Supplier Risk
Target: <35
Supplier Risk Matrix
Spend vs Risk score · Quadrant analysis
🟢 Low Spend / Low Risk — Monitor
🔵 High Spend / Low Risk — Leverage
🟡 Low Spend / High Risk — Develop
🔴 High Spend / High Risk — Critical
Top Vendor OTIF Performance
On-time in-full delivery rate · Top 8 suppliers
Vendor Scorecard
Comprehensive supplier performance · FY 2024–25
Working Capital Intelligence Center
Cash conversion cycle · DPO · DSO · DIO · Unlock opportunities
38days
Days Sales Outstanding
Target: 32 days · Gap: 6 days
0Target 3260
76days
Days Inventory Outstanding
Target: 68 days · Gap: 8 days
0Target 68120
52days
Days Payable Outstanding
Target: 58 days · Short: 6 days
0Target 5890
Cash Conversion Cycle
62 days
DSO (38) + DIO (76) − DPO (52) = 62 days · Industry avg: 54 days
⚠ Reducing DIO by 8 days could unlock ₹42 Cr in working capital
CCC Monthly Trend
Cash conversion cycle vs target · days
Working Capital Components
DSO / DIO / DPO trend · FY 2024–25
Operational Risk Intelligence Monitor
Supplier risk · Geopolitical exposure · Concentration risk · Live disruption alerts
HIGH
Overall Risk Level
18 critical alerts
42/100
Supplier Risk Score
▲ 6pts QoQ
3
Disruption Events
Active incidents
68%
Single-Source %
Concentration risk
Risk Category Heatmap
Risk score by category & geography · 0–100
Supplier Risk Score Trend
Monthly risk index · Alert threshold 40
Active Risk Incidents
Real-time disruption monitoring
Scenario Simulation Engine
What-if analysis · Impact modeling · Financial projection · Leadership decision support
Fuel Cost Change (%)
0%
Delivery SLA Improvement (%)
0%
Return Rate Reduction (%)
0%
Inventory Reduction (%)
0%
Simulation Output
Adjust sliders and click Run Simulation to see financial impact.
Savings Opportunity Tracker
Identified vs realized · ₹ Crores
Scenario Impact Waterfall
Base margin vs optimized margin bridge
What the Finance Team Observes
Analyst-led strategic observations · ₹342 Cr identified opportunity pipeline · FY 2024–25
Strategic Recommendations for Flipkart Leadership
Consulting-level supply chain finance insights · FY 2024–25
Supply Chain Finance Control Tower
End-to-end goods flow · Cash blocked at each node · Margin erosion · Delay exposure · Finance condition per stage
Total Chain Value
₹8,420 Cr
GMV flowing through chain
Cash Blocked
₹1,240 Cr
Across inventory + transit
Margin After Chain
23.2%
Post all chain costs
Chain Cost %
15.8%
Of GMV (industry 14%)
Delay Risk Exposure
₹48 Cr
Annual SLA breach cost
Flow of Goods & Money
Click any node to view financial detail · Hover for quick metrics
Reverse Logistics — Return Flow
₹94 Cr reverse logistics cost · 9.4% return rate · South India highest at 14.2%
Customer
9.4% Return
₹94 Cr cost
Returns Centre
QC + Restock
₹28 Cr loss
Warehouse
Re-listed
What Finance Team Observes
Southern FCs — Elevated Reverse Pressure
Southern fulfilment centres indicate higher reverse logistics pressure due to elevated return volumes in Fashion and Electronics. Return rate of 14.2% vs. national 9.4% warrants a dedicated quality-at-dispatch initiative.
Transit Inventory — Hidden Working Capital
Approximately ₹186 Cr in goods currently in transit does not appear in either warehouse or revenue — representing unmonitored working capital exposure. A real-time transit finance dashboard is recommended for CFO visibility.
GST & Indirect Tax Intelligence
Input Tax Credit · ITC mismatch · Vendor reconciliation · Reverse charge risk · Interstate stock movement · Blocked credit analysis
Blocked ITC
₹4.6 Cr
ITC claimed but blocked — vendor mismatch
GST Leakage YTD
₹2.1 Cr
Unreconciled GSTR-2B vs GSTR-3B
Vendor Mismatch Cases
47
GSTIN mismatches under review
Reverse Charge Exposure
₹0.84 Cr
Unbooked RCM liability
GST Reconciliation Status — By Vendor Category
GSTR-2A vs GSTR-2B vs GSTR-3B · Q4 FY25
| Vendor Category | GSTR-2B Eligible ITC (₹ Cr) | ITC Claimed (₹ Cr) | Mismatch (₹ Cr) | Mismatch % | Status |
|---|---|---|---|---|---|
| Electronics Manufacturers | ₹186.4 | ₹184.2 | ₹2.2 | 1.18% | Under Review |
| 3PL Logistics Partners | ₹48.6 | ₹47.1 | ₹1.5 | 3.09% | Blocked |
| Packaging Vendors | ₹22.3 | ₹22.3 | ₹0.0 | 0.00% | Reconciled |
| Warehouse Service Providers | ₹31.8 | ₹31.0 | ₹0.8 | 2.52% | In Progress |
| Fashion & Apparel Vendors | ₹64.2 | ₹64.1 | ₹0.1 | 0.16% | Reconciled |
Interstate Stock Transfers
ITC impact on stock movement across state lines · IGST exposure
MH → KA Transfer
Electronics · 42,000 units
₹18% IGST
₹4.2 Cr ITC claimable
DL → RJ Transfer
Fashion · 28,000 units
₹12% IGST
₹1.8 Cr ITC claimable
TN → AP Transfer
Appliances · 8,400 units
Pending E-way
Risk: ₹0.6 Cr penalty
ITC Ageing Analysis
Blocked credit by age — recovery probability declines with time
< 30 days
₹1.8 Cr
30–90 days
₹1.4 Cr
90–180 days
₹0.9 Cr
> 180 days
₹0.5 Cr
Finance Team Note
₹0.5 Cr blocked beyond 180 days is likely irrecoverable under current GST rules. Immediate vendor reconciliation required to avoid further ITC loss.
Internal Audit & Risk Intelligence Engine
Fraud detection · Duplicate invoice analysis · Vendor overbilling · Inventory shrinkage · Abnormal freight · Dependency concentration
3 CRITICAL ALERTS ACTIVE
Warehouse BLR-09 shows abnormal inventory leakage · Vendor TechSource invoice duplication detected · Air freight spend 54% above benchmark — MUM zone
Critical · Inventory Leakage
Warehouse BLR-09
Inventory write-off rate at BLR-09 is 4.2% vs warehouse average of 0.8%. Discrepancy of ₹3.6 Cr detected over 90 days. Physical audit initiated.
Exposure: ₹3.6 Cr
Critical · Duplicate Invoice
Vendor: TechSource Pvt Ltd
4 duplicate invoices totalling ₹1.2 Cr identified in Q4. Invoice numbers INV-8841, INV-8842 duplicated across two payment cycles. Vendor notified; payment hold applied.
Exposure: ₹1.2 Cr
High · Freight Overbilling
Air Freight — MUM Zone
Air freight spend in MUM zone is ₹28 Cr YTD vs. budgeted ₹18 Cr. Analysis shows 34% of shipments were air-routed despite 72-hour acceptable delivery window — a surface freight case.
Overrun: ₹10 Cr
Vendor Concentration Risk — Audit View
Single-source dependency exceeding threshold · ₹ Crores at risk if vendor defaults
| Vendor | Category | Spend (₹ Cr) | Single-Source % | Risk Score | Backup Available | Audit Finding |
|---|---|---|---|---|---|---|
| TechSource Pvt Ltd | Electronics | ₹310 | 68% | 71/100 | No | Critical Risk |
| PrecisionMfg Ltd | Electronics | ₹186 | 52% | 64/100 | No | Escalate |
| FashionHub Co. | Apparel | ₹94 | 38% | 48/100 | Partial | Monitor |
| LogiFirst 3PL | Logistics | ₹142 | 44% | 52/100 | Partial | Monitor |
| PackagePro Inc. | Packaging | ₹48 | 22% | 28/100 | Yes | Low Risk |
Suspected Fake Returns — Pattern Analysis
High-frequency return accounts flagged for review
Electronics — PIN 400001 cluster₹0.48 Cr
Fashion — repeat-return accounts (18)₹0.22 Cr
High-value returns without packaging₹0.31 Cr
Inventory Shrinkage by Warehouse
Write-off rate vs acceptable threshold of 0.5%
BLR-09
4.2%
MUM-03
2.1%
DEL-01
1.1%
HYD-02
0.5%
CFO Board Presentation
Q4 FY25 · Supply Chain Finance Summary · For Board Review · Prepared by Finance Intelligence Team
Board Pack · Supply Chain Finance
Flipkart Supply Chain
Finance Review — Q4 FY25
Finance Review — Q4 FY25
Prepared by CFO Office · Finance Intelligence Team · May 2025
Net Revenue
₹5,876 Cr
↑ 18.4% YoY
GMV
₹8,420 Cr
EBITDA
₹1,364 Cr
Net Margin
23.2%
Cash Conversion
62 days
SC Cost %
15.8%
01 · Business Performance
Revenue grew 18.4% YoY — EBITDA under margin pressure
GMV expanded to ₹8,420 Cr driven by Electronics (+24%) and Fashion (+19%). However, EBITDA margin contracted 1.8pp QoQ due to freight cost overrun of ₹48 Cr and elevated return losses of ₹94 Cr.
GMV ↑18.4%
Margin ↓1.8pp
02 · Key Risks
₹1,240 Cr cash locked — working capital cycle elevated
Cash Conversion Cycle at 62 days exceeds industry average of 54 days. Single-vendor concentration of 68% in Electronics creates ₹86 Cr disruption exposure. Blocked GST ITC of ₹4.6 Cr requires immediate reconciliation.
CCC: 62 days
Conc. Risk: ₹86 Cr
03 · Recommendations
₹342 Cr opportunity pipeline — actionable in 2 quarters
Freight modal shift (₹48 Cr), inventory reduction (₹76 Cr), DPO extension (₹28 Cr), and South India returns program (₹34 Cr) represent the highest-priority levers. Board approval sought for cross-functional task force.
Opportunity: ₹342 Cr
Board-Level Strategic Recommendations
Ranked by financial impact · Cross-functional ownership required
| # | Initiative | Function | Annual Impact (₹ Cr) | Timeline | Priority |
|---|---|---|---|---|---|
| 01 | Inventory Reduction — BLR, KOL, MUM warehouses | Supply Chain | ₹76 Cr | Q1 FY26 | Board Action |
| 02 | Air-to-Surface Freight Modal Shift | Logistics | ₹48 Cr | Q1 FY26 | Board Action |
| 03 | South India Returns Reduction Program | Operations | ₹34 Cr | Q2 FY26 | High Priority |
| 04 | Vendor Payment Term Extension (DPO 52→58 days) | Finance | ₹28 Cr | Q1 FY26 | High Priority |
| 05 | Dual-Sourcing — Critical Electronics Vendors | Procurement | Risk ₹86 Cr | Q2 FY26 | Risk Control |
| 06 | GST ITC Reconciliation — Blocked ₹4.6 Cr | Finance / Tax | ₹4.6 Cr | Immediate | Immediate |
CFO Closing Remarks
The supply chain finance position for Q4 FY25 reflects a business scaling effectively — but carrying working capital inefficiencies that must be addressed to sustain margin health into FY26. The ₹342 Cr opportunity pipeline is executable within two quarters with cross-functional commitment. The Board's approval for the task force is requested at this session.
Supply Chain Finance Intelligence Platform · FY 2024–25 · Confidential
Route Optimization Intelligence
AI-driven delivery route planning · Cost vs speed tradeoffs · Modal efficiency · Live dispatch status · FY 2024–25
Live Route Network Map
Active delivery corridors · India logistics grid
Active Route Performance
Cost efficiency · On-time · Load factor per corridor
Cost per km by Mode
Freight modal cost comparison · ₹/km
On-Time Delivery Trend
Monthly OTD % · Optimized vs baseline routes
Load Factor Distribution
Vehicle utilization across route clusters
Savings from Optimization
Before vs after route AI deployment · ₹ Crores
Route Efficiency Score by Zone
Composite score: cost + time + load + OTD
AI Route Optimization Recommendations
Identified inefficiencies · Proposed actions · Estimated savings
Live Dispatch Status — Today
Active vehicles · Route progress · ETA deviation