MIS Executive

Job Description

Roles & Responsibilities:

• Receive orders from regional ASMs in excel + mails from Sales MIS & Orders from DMS for all Beverages Categories
• Order update in SO punching sheet (file with RCPL free stock) – Service Provider can automate the sheet/working etc
• Order Splitting
• Allocate stock from nearest WH/Plant based on customer's delivery location (Check for 2-3 nearest preferable location)
• In case stock unavailability co-ordinate Coordinate internally on cross-sourcing after exhausting local factory stocks;
• Dispatch Plan of the above processed orders - based on stock availability & cross-sourcing - Location remotely
• Dispatch Plan for leftover SO's based on the morning stock report and ledger balance;
• Production Planning + Deployment planning (within the RCPL factories) + Modern Trade (incl Internal Formats) Order allocation + Dispatch Planning
• Maximize the orders as much as possible in line with Stocks by discussing with Sales team
• Check production plan, based on stock availability, allocate it with future date with intimation to RCPL
• In case of no visibility of production date against stocked out SKUs, take ASMs approval & revise order as per available SKU & Qty
• Send LOT wise file to SO punching team

MIS updation:-

a. Order Allocation Summary

b. Inventory Aging file creation

c. Free Inventory File creation

d. Distributor order visibility report

e. Inputs to be shared for Stock summary

f. Input file creation for running the tool for optimizing order allocation

g. Consolidated stocks and sales performance report

h. Forecast accuracy report

i. Cross sourcing matrix