Sr. Planning Officer

Manage the demand planning process by Bonus group/Item Level by creating & maintaining accurate Open to Buy (OTB) data to be used by departments to maximize sales while maintaining planned stock/inventory.

To ensure that the order is within OTB at overall level and at item level during the PO release process.

Important to maintain a neutral perspective & no affiliation to individual buying departments.

• Maintain accurate monthly OTB reports by Bonus group, available to the business by 3rd working day of each month, incorporating actual data from previous month.
• Plan & facilitate monthly departmental OTB meetings. Ensure agreed bonus group sales re-forecasts are incorporated into future OTB re-calculations. 
• Review every PO after its release from Buying Manager and attach relevant documents
•    To check if the order value is within OTB at Bonus Group level for every PO

   Furniture & Kids PO – PO quantities to be as per item wise planning file

   Accessories & Tiles – If reorders, to check historical sales data of these items (historical data sheet)

   Sanitary – To manage orders at item level (high level planning file to be developed)

 Attach OTB summary sheet in the PO after incorporating current order value in OTB file

• Proactively alert buying team and department heads if orders are not placed on time, overstock/OOS situation etc. with the help of OTB file
• Conduct monthly planning meetings with the Buying team to plan for future orders using the planning file
• Ensure stock availability on classified core and continuity lines and maintain options to spot ratio in the planning file
• Create summary reports from planning file

    Orders planned during planning meeting to be shared with buyers

    Forecast Dash Board 

    Forecast Accuracy by Item

• Manage prioritization of shipments and interact with SCM team to prioritize clearance from port
• Monthly report preparation on the expected container volume - current month + future 3 months
   

• Minimum 3 to 5 years’ experience of stock management and sales forecasting preferably in a retail merchandising environment.
• Thorough working knowledge of retail procurement in both local and overseas markets.
• Good proficiency in developing reports and providing insights to the business
• Positive attitude with a ‘can do’ approach when working under pressure or to tight deadlines.
• Able to work with other support functions, being a team player
• Excellent communication skills 
• Well-developed analytical, reasoning and data interpretation skills
• Strong skills in Business Objects, SAP and MS office