Merchandise Planning and Control Specialist

Rustan Commercial Corporation; Manila; On-site; PHP 480,000 - 600,000; Full time

Job summary

Rustan Commercial Corporation is seeking an MPC Officer to support the MPC Manager in monitoring budget performance, sales and inventory plans to meet financial objectives. The role emphasizes analysis and proactive recommendations across merchandising, pricing and promotions.

You will collaborate with Finance, IS and Merchandising to ensure data accuracy in the inventory system, generate reports, and help optimize stock levels, margins and incentive strategies for top brands.

Qualifications

• College graduate with a degree in Business/ Economics/ Industrial Engineering or equivalent.
• At least 3-5 years of relevant experience in merchandise planning and analysis/ budget allocation.

Responsibilities

• Analyze and review information for business planning to improve sales, gross margin, and inventory management.
• Review monthly management performance reports by brand and identify top brands per division.
• Monitor stock positioning and prevent store shortages; manage reorders.
• Ensure pricing/proposals comply with Sell Thru Policy and Markdown Scheme.
• Generate reports on gross margins, sales, rebates, and merchandising incentives.
• Coordinate with IS to verify inventory data; ensure price events align with proposals.

Skills

Excel

Analytical skills

Interpersonal skills

Communication skills

Education

College degree in Business/Economics/Industrial Engineering

Job description

The MPC Officer shall provide assistance to the MPC Manager in monitoring the company’s budget performance/activities, sales and inventory plans in order to achieve the company’s financial objectives.

Duties & Responsibilities:

A. Business Analysis

• Analyzes and reviews all information for business planning and provides recommendations for the improvement of business performance relative to Sales, Gross Margin, Purchase Budget and Inventory Months To Carry (IMTC)
• Analyzes Monthly Management Performance Reports by brand
• Identifies and reports top brands per division
• Reviews pre-season merchandise plans and in season trending analysis and adjustments
• Monitors the reorder system to ensure the stock positioning of best-selling items
• Monitors and reviews the inventory requirement and proactively prevents shortages at the store locations

B. Pricing and Promotion

• Ensures that the sale proposals submitted by Merchandising strictly comply to the company’s Sell Thru Policy and Markdown Scheme
• Analyzes the inventory (projected, stock on-hand, outstanding orders and actual purchases) and recommends merchandise to be put on sale

C. Report Generation

• Reports accurate Gross Margins calculating rebates and MGRs for concessionaires based on contracts
• Reports actual sales to Finance for commission calculation
• Prepares Saleability Reports for top management and ensures accurate information
• Calculates Merchandising’s incentives and recommends strategies in achieving the incentive plan

D. Technical

• Coordinates with the Information Systems Division to ensure the accuracy of data in the company’s inventory system
• Ensures that price events are in accordance with the approved sale proposals
• Ensures the correctness of the prices that will take effect in the stores

E. Other Responsibilities

• Schedules and conducts trainings for new MPC analysts and Merchandising executives
• Ensures that activities within the department strictly comply with the company’s policies and procedures
• Well-organized and detail-oriented
• Able to make timely decisions and anticipate problems
• Action-oriented
• Able to deal with ambiguity and adapts well to change
• Has good interpersonal skills, assertive and energetic
• Has excellent Microsoft Excel skills including word processing applications
• Has excellent quantitative and analytical skills
• Has good written and verbal communication skills

Minimum Education: College graduate with a degree in Business/ Economics/ Industrial Engineering or equivalent

Minimum Work Experience: At least 3-5 years of relevant experience in merchandise planning and analysis/ budget allocation