Supply Status Control Tower

DC-Wise Supply Status

Loading… Loaded just now — POs
Live from your tracker. Every number is calculated in your browser from MT_PO_tracker.xlsx, so changing any filter recalculates the whole page. To refresh, click Import data and choose your latest export (.xlsx or .csv, same columns). New POs can be added straight from their PDF with Add PO PDF.

01Overview

Top-line KPIs for the current filters

02At a glance

The questions this dashboard answers, updated for the current filters

03Supply status value

Where the GMV sits right now · click a segment or card to drill the PO detail table

05Supply status summary

Account → State → Supplied From → ASM · sorted by highest pending value

PO value (GMV) by status

Click a row to expand · click an ASM row to drill the PO detail table

06ASM performance by region

PO value, supply value, pending value and fill rate per ASM

PO value by ASM

Split into supplied, pending and expired value · click a bar to drill

State → ASM

Click a state to expand into its ASMs · click an ASM row to drill

07DC-wise performance

Every DC ranked, plus the two lists that need attention first

All DCs

—

Highest pending value

Top 10 DCs · PO value not yet supplied or expired

Lowest fill rate

Bottom 10 DCs · supply value ÷ PO value

08Region-wise (state) rankings

Same pending-value and fill-rate logic, rolled up by state

Highest pending value

Top 10 states · PO value not yet supplied or expired

Lowest fill rate

Bottom 10 states · supply value ÷ PO value

09Ageing & expiry risk

Based on days remaining to expire · click a bucket to drill the PO detail table

POs needing immediate action

Expired, critical and urgent (≤5 days) · lowest days remaining first, then highest value

10PO-level detail

Every filtered record · click charts and tables above to narrow this further

—

Add POs from PDF

Read in your browser, nothing is uploaded. Check the highlighted fields before adding.

Drop PO PDFs here or
Reliance Retail and Avenue Supermarts (DMart) POs · several at once is fine

Location fields (Supplied From, City, ASM, State) fill in from existing rows with the same DC code. New POs start as FR Status “Open” and Supply Status “SO Pending”.

PDF text

The text the reader found, line by line