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 customers 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 KPIs

- 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 companys Code of Conduct, Business Ethics, and core values: Innovate, Evolve & Excel

Qualifications

- Requirements

Education

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