S&OP / Inventory Health Intern – U.S.… at U.S. AutoForce · Appleton

Summary: U.S. AutoForce is seeking an S&OP / Inventory Health Intern to support their Sales & Operations Planning team. The role involves inventory analysis, data validation, and reporting, while collaborating with various departments to drive insights into inventory health.

Responsibilities:
- Support weekly and monthly inventory health reviews across the DC network (Healthy / Watch / At-Risk / Critical categorization)
- Assist in pulling, cleaning, and validating Logility planning attribute snapshots and Power BI data extracts
- Conduct brand-level and SKU-level inventory deep dives (ABC/XYZ segmentation, service level targets vs. actuals)
- Help identify root causes of inventory imbalances and document findings for the Senior S&OP Planner's review
- Support development and maintenance of S&OP KPI scorecards (OTIF, service level, fill rate, inventory turns, forecast accuracy)
- Assist in preparing recurring reporting packages for bi-weekly S&OP check-ins and Executive S&OP forums
- Compile data for warehouse capacity-constrained sites, receiving backlogs, and past-due PO exposure
- Support validation of new reports built by the ISA / DNA team
- Help clean up and standardize SOPs for planning processes (delete record process, low volume process, buy-to-backorder logic, etc.)
- Support the SKU rationalization initiative through data gathering and item-level review
- Assist with maintenance of global filters and inventory parameters in Logility
- Contribute ideas for process improvements and automation opportunities
- Partner with Demand Planners, Supply Planners, Category Managers, and Replenishment Analysts on ad-hoc analysis
- Participate in S&OP process meetings (demand review, supply review, inventory reconciliation) to build understanding of the end-to-end process
- Support special projects tied to the Chainsight, Logility, and inventory optimization roadmap

Required Qualifications:
- Currently pursuing a Bachelor's degree in Supply Chain, Business, Analytics, Data Science, Operations, or a related field
- Strong analytical and problem-solving skills with attention to detail
- Proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, basic formulas) and PowerPoint
- Strong written and verbal communication skills
- Ability to manage multiple priorities and work both independently and cross-functionally

Preferred Qualifications:
- Coursework or prior internship experience in supply chain, inventory management, or data analytics
- Exposure to Power BI, SQL, or advanced planning tools (Logility, SAP, Oracle, D365)
- Interest in pursuing a career in supply chain planning, S&OP, or analytics

Required Skills: Inventory Analysis, Data Validation, Microsoft Excel, PowerPoint, Logility, D365, Power BI, SQL, S&OP Process, SKU Rationalization, KPI Scorecard Development, Root Cause Analysis