Merchandise Planning & Control Analyst

The MPC Analyst shall provide assistance to the MPC Officer and Senior Analyst 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. Assists the MPC Senior Analyst in reviewing the inventory requirement and proactively prevents shortages at the store locations
2. Ensures that all sales reports are submitted with utmost accuracy
3. Provides assistance to the MPC Senior Analyst in monitoring inventory and sales reports

B. Report Generation

1. Reports actual sales to Finance for commission calculation
2. Prepares performance reports (i.e. Store Sales Quota, Management Performance Sales, etc.) on a monthly basis
3. Assists the MPC Senior Analyst in preparing inventory reports (projected, stock on-hand, outstanding orders and actual purchases) to be submitted to the MPC Officer

C. Technical

1. Assists the MPC Senior Analyst in coordinating with the Information Systems Division to ensure the accuracy of data in the company’s inventory system
2. Releases the price events created by Merchandising in the inventory system
3. Ensures that price events are in accordance with the approved sale proposals
4. Ensures the correctness of the prices that will take effect in the stores

D. Other Responsibilities

1. Assists the MPC Senior Analyst in preparing the training materials and equipment necessary for the trainings conducted by the department
2. Ensures that activities within the department strictly comply with the company’s policies and procedures

Behavioral Competencies

• Has unquestionable credibility and integrity
• Well-organized and detail-oriented
• Able to make timely decisions and anticipate problems
• Action-oriented
• Adapts well to change
• Has good Microsoft Excel skills including word processing applications
• Has good quantitative and analytical skills
• Has good written and verbal communication skills

Minimum Education: College graduate with a degree in Mathematics / Economics / Accountancy / Finance

Finance or equivalent Minimum Work Experience: At least 6 months to 1 year of relevant experience in merchandise planning and analysis/ budget allocation