Merchandise Planning Analyst (Allocation)

Mini Depato Corp.; Pasay; On-site; PHP 420,000 - 780,000; Full time

Job summary

Mini Depato Corp. is seeking a Merchandise Planning Analyst (Allocation) to drive store-level sales and inventory productivity.

You will oversee stock allocation, replenishment strategies, and inter-branch transfers to ensure the right products reach the right stores when needed, while minimizing stock-outs. Key responsibilities include strategic allocation, data analysis, and coordinating stock movements across retail branches.

Qualifications

• Bachelor's degree in Business, Merchandising or similar field.
• Keen eye for detail with strong data analysis skills.
• Proficient in MS Excel and basic data interpretation.
• Numerical analysis, evaluation and judgement are essential.

Responsibilities

• Execute inventory allocation across branches based on sales velocity and store capacity.
• Monitor stock levels, DC stock, delivery frequencies, and inter-branch transfers.
• Plan inventory builds for major events and campaigns to maximize sell-through.
• Perform reporting and additional tasks to support merchandising, logistics, and store operations goals.

Skills

Data analysis

MS Excel

Attention to detail

Numerical analysis

Education

Bachelor's degree in Business/Merchandising

Job description

Job Purpose:

The Merchandise Planning Analyst (Allocation) is responsible for driving store-level sales, inventory productivity, and stock efficiency across retail branches. By leveraging data analysis and demand forecasting, this role oversees stock allocation, replenishment strategies, and inter-branch inventory movements to ensure the right products are in the right stores at the right time while minimizing stock-outs and aged inventory.

Responsibilities:

Strategic-Allocation and Data Analysis:

• Execute precise inventory allocation across branches based on sales velocity, store capacity, demographic demand, seasonal trends, and Store Tiering/Grading (e.g., A/B/C tier stores structured by square footage, sales volume, and target demographics).
• Regularly monitor and evaluate store-level sales performance, inventory turnover, and market trends to identify stocks gaps, demand spikes, and optimization opportunities.
• Plan and allocate specific inventory builds and stock buffers for major commercial events, campaigns, and key selling periods (e.g., Payday sales, Holiday campaigns, Back-to-School, and Christmas peaks).

Inventory and Stock Management:

• Closely track store deliveries, stock levels, and store supply to maintain optimal inventory thresholds and prevent out-of-stock scenarios.
• Monitor Distribution Center (DC) stock levels, warehouse release schedules, delivery frequencies, and logistics bottlenecks to maintain smooth stock flow from DC to branches.
• Coordinate timely product reorders and initiate strategic inter-branch transfers to balance inventory across the retail network and maximize sell-through.
• Minimize inventory aging by prioritizing the distribution of fresh, high-demand merchandise and driving promotional focus on fast-moving items.

Operational Support:

• Perform additional tasks, reporting, and operational projects as assigned by Management to support broader merchandising, logistics, and store operations goals.

Perform other related functions as may be assigned or necessary from time to time.

Key Qualifications (Background, Experience, etc.):

Essential:

• Bachelor's degree in Business, Merchandising or similar field
• Keen to details with strong data analysis skills
• Proficient in MS Excel.
• Essential Competencies: Numerical Analysis, Evaluation, and Judgement