Sales Planning Analyst

Ford UK; Metro Manila; On-site; PHP 420,000 - 780,000; Full time

Job summary

Ford UK in Metro Manila is seeking an experienced logistics professional to oversee wholesale stock management, planning, and ordering activities for vehicle inventory. You will monitor daily arrivals, stockyard capacity, and PDI items while coordinating with IT on ERP systems and ensuring accurate data across reports.

Requirements include a Bachelor’s degree in Marketing or Business Admin and 4–5 years in automotive sales planning or distribution, with strong problem-solving and communication

Qualifications

• Bachelor degree or above in Marketing, Business Administration and/or equivalent.
• 4-5 years of work experience.
• Experience in automotive sales planning, distribution and 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.

Responsibilities

• Monitor daily stock, vehicle arrivals and PDI output focusing on new arrivals.
• Manage and update Wholesale (WS) line-up and related data files.
• Track stockyard capacity and utilization weekly and monthly.
• Monitor PDI items such as mats, warranty booklets, COCs and other materials.
• Coordinate with IT on QAD, VISTA and GOaLS issues.
• Conduct monthly reconciliation of wholesale plans vs dealer orders.
• Allocate additional vehicles per agreed methods with Sales and SP&D.
• Coordinate with stakeholders to update GDBP data monthly.
• Manage vehicle ordering by placing FGP orders or allocating units.
• Verify orders are processed and reflected in VISTA.
• Consolidate monthly Dealer/Company/Wholesale reports.
• Monitor daily arrivals of all vehicle units, including special units.
• Process CSR payments weekly.
• Support internal and external audits.

Skills

Inventory management

Warehouse operations

Stock planning

Data reporting

ERP systems

Communication

Education

Bachelor's degree in Marketing / Business Administration

Tools

QAD

VISTA

GOaLS

Excel

Job description

Responsible for monitoring company and dealer vehicle inventory, managing wholesale allocation processes, and supporting vehicle ordering and stock planning activities. The role ensures accurate tracking of vehicle arrivals, stockyard utilization, and ordering systems while maintaining updated records and reports to support sales operations and dealer requirements.

Wholesale & Stock Management

Monitor daily company stock, vehicle arrivals, and Pre-Delivery Inspection (PDI) output, with focus on newly arrived units.

Manage and update the Wholesale (WS) line-up and ensure 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.

Bachelor degree or above in Marketing, Business Administrationand/or equivalent

No. of Years of Experience: 4-5 years of work experience

Prior experience in automotive sales planning, distribution, ordealer network operations

Detail-oriented, proactive, and capable of problem-solving andeffective communication

Knowledge of automotive sales channels, inventory control(FIFO), and ERP/order management systems like QAD, VISTA,GOaLS or equivalent

Monitor daily arrival of all vehicle units, including special units