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
• Contributing factors to deviations

Supplier Agreement Compliance & SI&OP Risk Management:

• Ensure customer orders aligns 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
  • 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 forecasts for all secondary packaging operations, which will be 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
  • 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

• Requirements

Education

• 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.