Job Description
Long Description
Job Summary
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.
Job Responsibilities
- 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
Candidate Requirements
- 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
Education