Sales Planning Analyst

We are seeking a Sales Planning Analyst to join our team in Manila, Philippines. As a Sales Planning Analyst, you will be responsible for monitoring company and dealer vehicle inventory, managing wholesale allocation processes, and supporting vehicle ordering and stock planning activities.

Responsibilities

Wholesale & Stock Management

• Monitor daily company stock, vehicle arrivals, and Pre-Delivery Inspection (PDI) output, focusing on newly arrived units.
• Manage and update the Wholesale (WS) line-up, ensuring all related files and data are properly maintained.
• Track stockyard capacity and utilization on a weekly and monthly basis.
• Monitor PDI loose items such as matting, warranty booklets, conduction stickers, Certificates of Conformity (COC), and other required materials.
• Tag and allocate additional dealer vehicle requirements when needed.
• Coordinate with the IT team regarding system issues involving QAD, VISTA, and GOaLS.

Planning & Allocation

• Conduct monthly reconciliation of wholesale plans against dealer confirmed orders.
• Allocate additional vehicles based on agreed methodologies with the Sales and SP&D teams.

Vehicle Ordering & Sales and Stock Run-Down (SSRD)

• Coordinate with stakeholders to ensure Global Dealer Business Planning (GDBP) data is updated monthly.
• Manage vehicle ordering by placing FGP orders or allocating units based on production allocation and dealer order levels.
• Verify that all orders are successfully processed and reflected in the VISTA system.

Reporting

• Consolidate and prepare monthly operational reports, including Dealer Sales Reports, Company Stock, Dealer Stock, and Wholesale reports.

Compliance & Others

• Monitor daily arrival of all vehicle units, including special units.
• Process payments for Certificate of Stock Reports (CSR) on a weekly basis.
• Support internal and external audits conducted by Ford.
• Address dealer concerns and provide support for documentation related to vehicle arrivals.

Qualifications

• Bachelor's degree or above in Marketing, Business Administration, and/or equivalent.
• 4-5 years of work experience.
• Prior experience in automotive sales planning, distribution, or dealer network operations.
• Detail-oriented, proactive, and capable of problem-solving and effective communication.
• Knowledge of automotive sales channels, inventory control (FIFO), and ERP/order management systems like QAD, VISTA, GOaLS, or equivalent.