Sales Planning Analyst

Lincoln Motor Company; Philippines; On-site; PHP 700,000 - 1,100,000; Full time

Job summary

Lincoln Motor Company in the Philippines is seeking an experienced Wholesale & Stock Management professional to oversee vehicle inventory, wholesale allocation, and planning processes.

You will coordinate stock accuracy, PDI items, data integrity across QAD, VISTA, and GOaLS, and ensure timely reporting to support sales operations and dealer requirements. The role demands 4–5 years in automotive planning, with strong attention to detail and proactive communication.

Qualifications

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

Responsibilities

• Monitor daily company stock, vehicle arrivals, and PDI outputs focusing on newly arrived units.
• Manage and update the Wholesale line-up and ensure all related files and data are properly maintained.
• Track stockyard capacity and utilization on a weekly and monthly basis.
• Coordinate with IT regarding system issues involving QAD, VISTA, and GOaLS.
• Conduct monthly reconciliation of wholesale plans against dealer confirmed orders.
• Allocate additional vehicles based on agreed methodologies with Sales and SP&D teams.
• Verify orders are processed and reflected in the VISTA system.
• Consolidate and prepare monthly operational reports (Dealer Sales, Company Stock, Dealer Stock, Wholesale).
• Support audits conducted by Ford and address dealer documentation for vehicle arrivals.

Skills

Detail-oriented

Proactive

Effective communication

Problem-solving

Education

Bachelor's degree in Marketing or Business Administration

Tools

QAD

VISTA

GOaLS

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 Administration and/or equivalent
• No. of Years of Experience: 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
• Monitor daily arrival of all vehicle units, including special units