FP&A Intern
About The Position
This project will design and implement a centralized Cost-Volume-Profit (CVP) analysis tool to support financial planning, pricing decisions, and profitability analysis across the organization. The tool will enable the finance team to consistently model the relationships between costs, volume, pricing, and margins, improving visibility into breakeven points and profit sensitivities under different business scenarios. The objectives include standardizing CVP analysis across products, customers, and business units, improving the speed and accuracy of profitability and breakeven analysis, enabling scenario modeling for pricing changes, volume shifts, and cost structures, and providing finance and leadership with clear, decision-ready insights.
Requirements
- Currently pursuing a degree in Business Administration, Accounting or Finance.
- Strong organizational skills and attention to detail.
- Ability to handle confidential information with professionalism.
- Strong communication and interpersonal skills.
- Ability to multitask and adapt in a fast-paced environment.
- Proficiency in Microsoft Office (Excel, Word, Outlook).
- Customer-focused with a professional and positive attitude.
- Ability to lift, move, and organize files and boxes (up to ~25 lbs).
- Ability to stand, bend, and move during organization projects.
- Self-motivated, detail-oriented, and capable of working independently.
Responsibilities
- Design and implement a centralized Cost-Volume-Profit (CVP) analysis tool.
- Model the relationships between costs, volume, pricing, and margins.
- Standardize CVP analysis across products, customers, and business units.
- Improve speed and accuracy of profitability and breakeven analysis.
- Enable scenario modeling for pricing changes, volume shifts, and cost structures.
- Provide finance and leadership with clear, decision-ready insights.
- Consolidate fixed and variable cost inputs in a structured, auditable format.
- Support multiple scenarios (base, upside, downside, what-if analyses).
- Calculate key metrics including contribution margin, breakeven volume, and target profit volumes.
- Allow analysis by product, customer, region, or business line.
- Provide clear visual outputs (charts, tables, and summaries) for management reporting.
- Build an Excel or Tableau tool and save it on a share drive for finance team to use for flux analysis monthly.
- Ensure the tool has appropriate slicers/filters that can be refreshed with JDE data.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Intern
Number of Employees
1-10 employees
