Category Merchandising Manager

Ace Hardware Phils., Inc - Pasay; Pasay; On-site; PHP 334,800 - 446,400; Full time

Job summary

A leading retail company in Pasay is seeking a Demand Planner who will be responsible for conducting SKU performance reviews, ensuring optimal supply plans, and formulating forecasting algorithms. The ideal candidate will have a bachelor's degree in a related field and 1-3 years of experience in demand planning. Strong analytical capabilities and good communication skills are essential for this on-site role.

Qualifications

• At least 1-3 years of work experience in demand planning.
• Ability to work individually and in a team environment.
• Good interpersonal and communication skills.

Responsibilities

• Conduct SKU performance reviews and execute stock transfers.
• Ensure optimal supply plan and provide root cause analysis on supply issues.
• Formulate demand planning algorithms and make process improvement recommendations.

Skills

Quantitative and qualitative data analysis

Demand planning experience

Excel and Microsoft applications expertise

Critical thinking and analysis

Communication and collaboration skills

Education

Bachelor’s degree in Economics, Supply Chain Management, Industrial Engineering, or related field

Job description

Merchandising

• Buying of new items; preparation of new sku demand forecast based on market research or new sku
• Preparation of initial orders for new skus
• Analysis and planning of assortment per format
• Negotiation with vendors re; promotions, discounts, orders and sku count

Supply Planning

• Review assortment planning at store level planning.
• Conduct SKU performance reviews with pareto analysis
• Execute branch stock transfers to further improve store inventory health.
• Ensure optimal supply plan that will meet customer service levels, inventory and cost.
• Provide root cause analysis on supply issues and constraints.
• Calculation and analysis of orders per SKU per store based on historical sales and stock to sales ratio
• Setting parameters based on different factors; store size, store performance, SKU performance
• Allocation of stocks to store based on stock to sales ratio

Demand Planning

• Apply data management and data-driven analytics (historical cleansing, data extraction, baseline forecasting, market performance analysis, etc.). Able to provide value-adding analytics to enable guidance in critical decision making related to forecasts and planning.
• Formulate and maintain demand planning algorithms to create best forecast possible with assessments for impacts on market change or variances to recommend appropriate revisions and tactics.
• Make recommendations to enhance business processes and identify opportunities to improve operational effectiveness and efficiency.
• Regulate continuous SKU Rationalization (Product Lifecycle Management)
• Measure, analyze and community key process metrics and monitor adherence to key performance indicators (KPIs), while driving continuous improvement.

Skills and Competencies Required (For DSP)

• Experienced with quantitative and qualitative data analysis within the FMCG/retail industry.
• Hands‑on experience in demand planning or simulation systems or tools.
• Intermediate system expertise in Excel and other Microsoft applications.
• Critical thinking, analysis and decision‑making capabilities.
• Good communication and collaboration skills with stakeholders.

Education & Experience

• Bachelor’s degree in Economics, Supply Chain Management, Industrial Engineering, Manufacturing Engineering, or related business field.
• At least 1‑3 years of work in the related field is required.
• Able to work individually and in a team environment.
• Good interpersonal skills and communication skill.
• Willing to work on‑site in PASAY CITY (Monday to Friday – 8 AM to 5:30 PM).