Strategic Merchandise Planning & Inventory Analyst

Rustan Commercial Corporation; Manila; On-site; PHP 420,000 - 660,000; Full time

Job summary

Rustan Commercial Corporation is seeking an MPC Officer to support the MPC Manager in monitoring budget performance, sales plans, and inventory strategies to meet financial goals.

The role emphasizes business analysis, pricing and promotions, report generation, data accuracy with IS systems, and training for MPC analysts, requiring 3–5 years in merchandising analytics and strong Excel proficiency.

Qualifications

• College degree in Business, Economics, Finance or equivalent.
• 3–5 years of relevant merch planning/analysis or budget allocation experience.
• Excellent MS Excel and data analysis skills.

Responsibilities

• A. Business Analysis: Analyzes information for planning; recommends improvements in sales, gross margin, budget and inventory.
• Also analyzes Monthly Management Reports by brand and identifies top brands per division.
• Reviews pre-season plans and in-season trending analyses and adjustments.
• Monitors reorder system to optimize stock of best-sellers and prevent shortages.
• B. Pricing and Promotion: Ensures Sell Thru Policy compliance and markdown schemes; analyzes inventory and advises on sale items.
• C. Report Generation: Generates Gross Margins, rebates, and MGRs for contracts; reports sales to Finance; prepares top-management saleability reports.
• D. Technical: Coordinates with IS Division to ensure inventory data accuracy; ensures price events follow proposals; applies correct in-stores prices.
• E. Other Responsibilities: conducts trainings for MPC analysts and merchandising executives; ensures policy compliance; demonstrates organization, decisiveness, proactivity; praises Excel and communication skills.

Skills

Analytical thinking

Interpersonal skills

Communication skills

Detail-oriented

Education

College degree in Business/Economics/Finance or equivalent

Tools

Microsoft Excel

Job description

Rustan Commercial Corporation is seeking an MPC Officer to support the MPC Manager in monitoring budget performance, sales plans, and inventory strategies to meet financial goals.

The role emphasizes business analysis, pricing and promotions, report generation, data accuracy with IS systems, and training for MPC analysts, requiring 3–5 years in merchandising analytics and strong Excel proficiency.