Supply Base Cap Planning Analyst

Ford Motor Company

. Develop and maintain vehicle volumes and market allocations based on Final Program Volume (FPV) data .

Posted 10/28/2026full-timeAllen Park • Michigan • United StatesJuniorMid-Level💰 $84,480 - $162,120 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in capacity planning and supply chain analysis, with a strong ability to translate complex data into actionable strategies. Proficient in managing vehicle volumes and aligning market demand with manufacturing capabilities in the automotive sector.

Highest-signal resume keywords

Capacity PlanningData AnalysisBill Of Materials (BOM) ManagementMicrosoft Excel ProficiencyAutomotive Manufacturing Knowledge

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Capacity PlanningData AnalysisBill Of Materials (BOM) ManagementMarket AllocationForecastingSupply Chain StrategiesNegotiationPresentation SkillsERP/PLM SoftwareData Modeling

Soft Skills

Consensus BuildingCommunicationProblem SolvingAdaptabilityCollaboration

Tools & Technologies

Microsoft ExcelERP SoftwarePLM Software

Industry Keywords

AutomotiveManufacturing OperationsSupply Chain ManagementFinal Program Volume (FPV)Average Production Weekly (APW)Maximum Production Weekly (MPW)Vehicle Launch Processes

Tech Stack

Tools & technologies

ERP

About the role

Key responsibilities & impact

Develop and maintain vehicle volumes and market allocations based on Final Program Volume (FPV) data
Conduct comprehensive "Confirm" and "What-If" capacity studies
Communicate capacity requirements to the supply base and evaluate potential volume shifts
Identify commodity constraints and manufacturing gaps
Work cross-functionally to resolve issues affecting launch timelines or planned production mixes
Manage changes in vehicle volumes, feature rates, product definitions, and Bills of Materials (BOM)
Lead consensus meetings with Sales and Marketing teams
Align market demand requests with manufacturing capabilities
Analyze and bridge the gap between "Free Demand" and "Funded Supplier Capacity"
Ensure supplier investments align with long-term forecasted needs

Requirements

What you’ll need

Bachelor's degree in Supply Chain Management, Business Analytics, Industrial Engineering, or a related field
2-5 years of experience in capacity planning, supply chain analysis, or manufacturing operations
Automotive experience preferred
Strong proficiency in data analysis and modeling
Ability to translate complex data sets into actionable supply chain strategies
Excellent negotiation and presentation skills
Ability to drive consensus among Sales, Marketing, and Engineering stakeholders
Advanced knowledge of Microsoft Excel, including Pivot Tables and VLOOKUPs
Experience with ERP/PLM software
Familiarity with APW (Average Production Weekly) and MPW (Maximum Production Weekly) concepts
Experience with Bill of Materials (BOM) management and product definition logic
Knowledge of vehicle launch processes and automotive manufacturing constraints
Ability to thrive in a fast-paced environment with shifting priorities
Must be legally authorized to work in the United States
Visa sponsorship is not available

Benefits

Comp & perks

Immediate medical, dental, and prescription drug coverage
Flexible family care, parental leave, new parent ramp-up programs, subsidized back-up childcare and more
Family building benefits including adoption and surrogacy expense reimbursement, fertility treatments, and more
Vehicle discount program for employees and family members, and management leases
Tuition assistance
Established and active employee resource groups
Paid time off for individual and team community service
A generous schedule of paid holidays, including the week between Christmas and New Year’s Day
Paid time off and the option to purchase additional vacation time