Merchandise Planning and Control Officer

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

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/ Finance or equivalent

Minimum Work Experience:

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