Materials Planning Summer Intern
Core
Support material demand, supply, inventory, and open purchase order reviews; update planning parameters; build dashboards for inventory and supplier metrics; perform data quality checks; and support improvement projects.
Role type
Summer Intern, Materials Planning
Builds
Dashboards showing inventory levels, shortages, supplier performance, forecast accuracy, purchase-order aging, and service levels
Domain
Supply Chain / Materials Management
Deliverable
dashboards & analysis
Required skills
Excel (pivot tables, lookups, conditional formatting, charts, data cleansing, scenario analysis), Supply chain fundamentals (demand planning, inventory management, procurement, logistics, production planning, materials management), Data analysis (interpret data, identify trends, investigate variances), Cross-functional collaboration
Preferred skills
Power BI, Tableau, Python, SQL
Responsibilities
Review material demand, supply, inventory, and open purchase orders; Update planning parameters (lead times, minimum order quantities, safety stocks, reorder points, lot-sizing rules); Build or enhance dashboards for inventory and supplier metrics; Perform data-quality checks and reconcile discrepancies; Support defined improvement projects
Seniority
Intern, Summer