Merchandise Planning and Control Officer

RUSTAN COMMERCIAL CORPORATION; Makati; On-site; PHP 420,000 - 540,000; Full time

Job summary

Rustan Commercial Corporation in Makati seeks an MPC Officer to support budget performance monitoring, sales and inventory plans to hit financial targets. Responsibilities include business analysis, pricing, reporting, and coordination with IT for data accuracy.

Ideal candidates have 3–5 years in merchandise planning, strong Excel and analytical skills, and a degree in Business/Economics/Industrial Engineering. Excellent communication and organizational abilities are required.

Qualifications

• Bachelor's degree in Business, Economics, or Industrial Engineering or equivalent.
• 3–5 years of relevant experience in merchandise planning and analysis/budget allocation.
• Strong Excel and analytical skills; good written and verbal communication.

Responsibilities

• Analyze and review information for business planning to improve sales, gross margin, and inventory planning.
• Monitor and report on Monthly Management Performance Reports by brand; identify top brands per division.
• Ensure compliance with Sell Thru Policy and Markdown Scheme; analyze inventory for sale opportunities.
• Coordinate with IS Division to ensure data accuracy in inventory systems; verify price events.
• Train MPC analysts and merchandising executives; ensure adherence to policies and procedures.

Skills

Excel skills

Quantitative analysis

Written and verbal communication

Interpersonal skills

Detail-oriented

Education

Business/Economics/Industrial Engineering degree

Tools

MS Office

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

1. 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)




2. Analyzes Monthly Management Performance Reports by brand




3. Identifies and reports top brands per division




4. Reviews pre-season merchandise plans and in season trending analysis and adjustments




5. Monitors the reorder system to ensure the stock positioning of best-selling items




6. Monitors and reviews the inventory requirement and proactively prevents shortages at the store locations

B. Pricing and Promotion

1. Ensures that the sale proposals submitted by Merchandising strictly comply to the company’s Sell Thru Policy and Markdown Scheme




2. Analyzes the inventory (projected, stock on-hand, outstanding orders and actual purchases) and recommends merchandise to be put on sale

C. Report Generation

1. Reports accurate Gross Margins calculating rebates and MGRs for concessionaires based on contracts




2. Reports actual sales to Finance for commission calculation




3. Prepares Saleability Reports for top management and ensures accurate information




4. Calculates Merchandising’s incentives and recommends strategies in achieving the incentive plan

D. Technical

1. Coordinates with the Information Systems Division to ensure the accuracy of data in the company’s inventory system




2. Ensures that price events are in accordance with the approved sale proposals




3. Ensures the correctness of the prices that will take effect in the stores

E. Other Responsibilities

1. Schedules and conducts trainings for new MPC analysts and Merchandising executives




2. Ensures that activities within the department strictly comply with the company’s policies and procedures

Competencies:

Behavioral Competencies:

• 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

Technical Competencies:

• 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