Key Responsibilities
Receive and consolidate orders from:
Regional ASMs (Excel / email)
Sales MIS
DMS (all Beverages categories)
Update & maintain SO punching sheet (incl. RCPL free stock) and support automation of workings/templates.
Perform order splitting and:
Allocate stock from nearest WH/Plant based on customer delivery location (2–3 nearest options).
In case of stock shortage, coordinate internally for cross-sourcing after exhausting local factory stocks.
Prepare dispatch plans:
For all processed orders based on stock availability & cross-sourcing.
For leftover SOs based on morning stock report and ledger balances.
Support production & deployment planning within RCPL factories:
Align Modern Trade & internal format orders with available and planned stocks.
Maximize order servicing in line with stock by coordinating with Sales team.
Track production plan and:
Allocate orders with future delivery dates where applicable and inform RCPL stakeholders.
For SKUs with no production visibility, take ASM approval and revise orders as per available SKUs & quantities.
Share LOT-wise files with SO punching team for execution.
Required Skills & Qualifications
Graduate in Commerce/Science/Engineering or equivalent.
2–5 years’ experience in supply chain / sales operations / dispatch planning (FMCG/Beverages preferred).
Advanced Excel expertise
(VLOOKUP/XLOOKUP, INDEX-MATCH, SUMIFS, IF, Pivot Tables, basic automation using formulas & templates).
Strong understanding of
inventory & stock calculations
(free stock, blocked stock, in-transit, ageing, ledger reconciliation).
Good coordination & communication skills to work with Sales, Plants, Warehouses and MIS teams.
Detail-oriented, comfortable working with large data sets and tight timelines.
