Supply Chain Finished Goods Planner

Job Responsibilities

Customer Forecast Review & Analysis

• Collect and review the Annual Customer Forecast at the beginning of each calendar year.
• Receive and analyze the Rolling Forecast monthly or quarterly as per customer supplier agreement to ensure forecast stability and predictability.
• Submit forecast data for reporting, Forecast Fluctuation Metrics.
• Extract actual order data from the ERP system to compare against customer-provided forecasts.
• Evaluate forecast accuracy by comparing the Rolling Forecast against the baseline and identifying variances.
• Compare Rolling Forecasts with customer orders within the contracted lead times to assess short-term accuracy.
• Document deviations, categorize them (within or outside the tolerance window), and identify root causes (promotional activities, market shifts, new product launches, artwork delays).

Prepare a Forecast Accuracy Report that includes SKU-level data, forecast deviation percentages, impacted periods, risk to Aveva's projected volumes or revenue, and contributing factors to deviations.

Supplier Agreement Compliance & SI&OP Risk Management

• Ensure customer orders align with forecast as per the Supplier Agreement (SA).
• Analyze customer Purchase Orders against approved forecasts and Supplier Agreements; input approved POs into JDE and follow the established Escalation Model for exceptions or discrepancies.
• Review 120-day production volumes and schedules to assess if forecasted demand can be met through internal or subcontracted production.
• Lead a Monthly/weekly business review meeting with Customers.
• Perform Supply Interruption Risk Analysis by identifying material shortages, production capacity constraints, artwork or packaging component delays, and logistics issues or third-party constraints.
• Escalate critical supply risks to department or site leadership for immediate resolution.

Secondary Packaging Operations Management

• Maintain and update a 12-month rolling forecast for all secondary packaging operations, used for capacity planning and subcontracting alignment.
• Prepare and release monthly production schedules aligned with the customer's demand forecast and internal resource availability.
• Oversee order fulfillment for internal production and CPO-managed bulk packaging, including production scheduling, work order management, batch allocation, QA release status, and shipment execution.
• Issue Subcontracting Service Purchase Orders no later than the 15th of the month preceding the production start date, ensuring on-time execution by external packaging partners.
• Monitor and review 90-day material/component availability, ensuring that all packaging components (e.g., labels, cartons, leaflets) are in stock to support continuous operations.
• Monitor CPO inventory and batch status, including QA release timelines, and coordinate with external packaging partners to ensure alignment with customer forecasts and production requirements.
• Lead and facilitate daily and weekly business review meetings with internal and external stakeholders to monitor order status and production execution, material and capacity constraints, on-time delivery performance, and escalated issues and resolutions.
• Drive accountability and proactive problem-solving across planning, procurement, manufacturing, quality, and third-party teams.

General Responsibilities

• Maintain up-to-date shipment plan files and supply chain On Time and In Full KPI's.
• Collaborate cross-functionally with Commercial, Quality, Procurement, Manufacturing, Logistics, and Business Intelligence teams.
• Continuously improve planning processes, leveraging ERP data and business analytics to improve forecast accuracy and operational efficiency.
• Support internal and external audits by ensuring full compliance with SOPs, agreements, and documented planning procedures.
• Ensure compliance with all company policies, including safety, regulatory, and quality standards.
• Conduct all responsibilities following the company's Code of Conduct, Business Ethics, and core values: Innovate, Evolve & Excel.

Qualifications

Bachelor's degree in business or related discipline with 3 to 5 years of related experience. Additional years of job-related experience may be substituted for educational experience.

Knowledge, Skills, and Abilities

• 3+ years of progressive experience in the Supply Chain Planning Role.
• Preferably, experience with JDE Forecasting/Planning and customer service modules.
• Comfortable and capable of working in a complex or dynamic environment.
• Advanced knowledge of Microsoft Office software; demonstrated ability to utilize Excel in developing reports and analysis using pivot tables and charts, VLOOKUPs, and database functions.
• Knowledge of inventory management methodologies is an asset.
• Strong analytical/problem-solving skills demonstrating proactive initiative required to identify potential issues and lead to resolution.
• Ability to train/provide guidance to the more junior team members.
• Demonstrated a high level of self-sufficiency and ability to make independent decisions.
• Ability to develop strong internal relationships and partnerships with the ability to influence decisions.
• Demonstrated ability to coordinate and facilitate meetings with cross-functional teams to achieve a self-determined outcome.
• Seen as a "go to" resource at Aveva.
• Demonstrated ability to challenge the status quo where appropriate.