Supply/Demand Planner

About the Role

ITW Car Care is hiring two Supply/Demand Planners. Opportunities are available at either the Planner I or Planner II level, determined by experience. These roles are responsible for balancing Finished Goods (FG), Semi-Finished Goods (SFG), and Raw Materials (RM) with customer demand through forecasting, supply planning, and cross-functional collaboration. The planners will partner with suppliers, manufacturing sites, and sales teams to achieve service, inventory, and MOH targets.

Planner II candidates will also take ownership of end-to-end material planning and provide guidance to less experienced planners.

Key Responsibilities

Demand Planning

• Build and maintain statistical demand forecasts.
• Track Point of Sale (POS) data and adjust the forecast to reflect changes in demand.
• Bring forecast inputs to demand planning meetings with Sales and Marketing.

Supply Planning & Purchasing

• Run long-term and short-term planning for Finished Goods (FG), Semi-Finished Goods (SFG/SM) and Raw Materials (RM).
• Purchase FG, SFG, and RM, and coordinate supplier deliveries so products arrive on time.
• Calculate Market Rate of Demand (MRD) requirements for suppliers. Maintain and update the MRD system using Run Rates (RR), Lead Times (LT), and batch sizes.
• Run Material Requirements Planning (MRP) in the Enterprise Resource Planning (ERP) system to plan material and production needs.
• Plan manufacturing production, working with the plants on schedules and capacity.

Inventory & Performance Management

• Calculate and report key planning metrics:
• Months on Hand (MOH)
• Obsolete and Slow-Moving Inventory (OSMI)
• On-Time In-Full (OTIF)
• Run Rate (RR) and Safety Stock (SS)
• Minimum Order Quantity (MOQ)
• Overall Equipment Effectiveness (OEE)
• Analyze inventory data and recommend actions to improve Months on Hand (MOH).
• Recommend and make planning parameter changes: Lead Times (LT), minimum inventory, lot sizes, and order policies.
• Build and maintain Power BI dashboards and Excel reports to track inventory and service performance.
• Take part in supplier and manufacturing site meetings, and support the monthly Inventory Management meeting.
• Apply 80/20 principles to focus planning effort on the products and customers that matter most.

Planner II Scope (in addition to the above)

• Independently own the full MRD and MRP process for an assigned product portfolio.
• Train and mentor Planner I team members.
• Lead small improvement projects in planning and sourcing.

Requirements & Tech Stack

Technical Skills

• Advanced Microsoft Excel: pivot tables, XLOOKUP/INDEX-MATCH, advanced formulas, and data modeling.
• Power BI: building dashboards and reports for inventory, forecast, and service metrics.
• MRP / ERP systems: running Material Requirements Planning and maintaining planning parameters.
• MRD: maintaining MRD calculations and system updates.
• Statistical forecasting methods and tools.

Key Competencies

• Analytical thinking and attention to detail.
• Clear communication with suppliers, manufacturing sites, and commercial teams.
• Takes ownership and follows through.
• Continuous improvement mindset.

Qualifications

Required

• Bachelor’s degree in Supply Chain Management, Operations, Business, or a related field.
• Planner I: 0–3 years of experience in supply chain, procurement, or supplier coordination.
• Planner II: 3–6 years of experience, including a track record of independently managing sourcing or planning projects.
• Strong analytical and problem-solving skills, with the ability to work effectively with large data sets.
• Experience with Enterprise Resource Planning (ERP) systems and Material Requirements Planning (MRP) processes.

Preferred

• Experience in manufacturing or production planning.
• Familiarity with Sales & Operations Planning (S&OP) / Integrated Business Planning (IBP) and 80/20 methodology.
• APICS/ASCM certification: Certified in Planning and Inventory Management (CPIM) or Certified Supply Chain Professional (CSCP).