Allocation & Replenishment Senior Planner
MAGRABI Retail
Total years of experience :14 years, 5 Months
Job Purpose:
Ensuring the best and most sustainable product availability across the operating regions (KSA, UAE, EGY, BAH, QAT, OMN, KWT, LEB, JOR, TUR) with the best possible quality and according to the planned time frame with the minimum stock levels aiming to achieve the annual sales plan.
Duties and Responsibilities:
Analyze past buying trends, sales records, price, and quality of merchandise to determine value and yield.
Analyze the selling rate for each SKU to determine the needed quantities for replenishing SKUs and ensuring the availability of the minimum stock levels.
Analyzing inventory related information to study how quickly certain products have turned in the past and identifying products that have not been successful for the store through pilots.
Replenishment of goods in the warehouse and stores; tracking the high demand models and ensuring that those models are properly sourced and available on demand.
Transferring the goods that were not successful in one store to another if the demand is higher at another store.
Planning the product purchasing for the new releases, based on the planned product profile.
Analyze stock levels and sales performance to specify inventory devaluation provisions and calculate the required quantities per country to reach the standard planned stock percentage per store according to store size and place (cluster).
Setting the right price points for various goods after the analysis of various goods and the margins needed.
Ensure healthy stock levels across the regions to prevent outdated products.
Coordination with the stores to fulfill customers’ demand.
Yearly budgeting and reallocations throughout the year to accommodate with the ever changing strategies and business needs.
Replenishment parameters update, MRP running, and follow up with the different distribution channels from the suppliers until reaching the stores’ floor.
New stores opening and closing support and execution.
Monthly Reports:
Ophthalmic Lenses Strategy Progress Report
Stores Incentive Scheme Report
Ophthalmic Lenses Sales Performance Report & Score Cards
Partner company “Transitions” Monthly Credit Note Report
Inventory Devaluation Provision Report
Own Brand’s Performance Report
Ad-Hoc Reports
SAP-Related Tasks:
Data Sources Extraction (BW-“Business Warehouse”, Discoverer & Business Objects 11 Web Intelligence) - Sales, Stocks, Purchases
SAP-specific “Item Creation Process” | BMC and SKUs creation ▪ Info record creation / update ▪ Sales prices creation / update ▪ Outbound to & mapping on POS (Point Of Sale) ▪ Lens Administration on POS ▪ SAP-related stores daily problems and requirements ▪ Managing technical inquiries through a ticketing-based portal ▪ Validations requirements (power ranges & services) ▪ Data maintenance requests/needs ▪ Stores’ profile data
Logistics Specialist
General logistics responsibilities includes:
- Freight budget monitor and definition of cost reduction/avoidance opportunities when prompted
- Packaging procurement process: includes the procurement cycle of the returnable packaging as well as expendable ones in parallel with the production daily outputs to prevent potential stoppages \[have already avoided a required air freight estimate of 20, 000 £ in Q4 of 2011 and 45, 000 £ in Q1 of 2012\].
- Stores and dispatch areas monitor and improvements (execution and planning)
- Local transportation’ monitoring of deliveries and pick-ups
- Courier companies accounts’
- Inventory monitoring (Excess and obsolete materials minimization)
- On-job analyses and studies (Determining improvement areas).
- Regular meetings and liaison with colleagues and related departments to ensure the smooth flow in achieving the set targets.
- Monitor & maintain key performance measures
- To create an environment which encourages the rest of the team development and maintains trust and honesty as well as participation in decision-making.
- To be a suitable role model and adhere to the company policies.
Inbound logistics responsibilities:
- Inbound and Return logistics coordination throughout the supply chain department (Procurement, Planning and Logistics departments).
- Containers booking plans (Inbound)
- Modeling routes for transport across Europe according to the best affordable services \[Have permanently helped save an average weekly estimate of 1200-2000 € per week\].
- Helped reduce the air freight costs through the development of an all-inclusive air freight cost calculator which helped decide the cheapest yet reliable options at all situations
Outbound logistics responsibilities:
- Containers booking plans (Outbound)
- Cost allocation and recharging customers and suppliers with the freight costs incurred on a monthly basis
- Containers delivery plans execution according to the customers’ needs