5 years of experience in an inventory management environment
• Highly analytical, flexible, action- and results-oriented, with strong written and verbal communication skills
• Excellent organization skills including prioritizing, scheduling, time management and meeting of deadlines
• High level of proficiency in MS Excel, MS Access preferred
• Experience working with Oracle
• Demonstrates progressive experience in forecasting
• Bachelor’s Degree
The Forecast Analyst is responsible for the monthly and annual forecast by item by customer for a specified product line and achieving forecast accuracy metrics. This position will analyze customer POS trends, customer inventory levels, and internal inventory levels to develop the forecast. The Forecast Analyst will monitor actual results vs. forecast to recommend changes and also perform post mortem analysis on forecast variances. In addition, this position works closely with sales and the overseas manufacturing team.
Participate in weekly and monthly business management meetings, presenting analysis, calling out issues, and identifying action items. Perform root cause month variance analysis on a customer by customer basis. Provide monthly variance analysis by item. Incorporate customer sales and inventory data into forecasting process and allocation decisions. Perform 30 day and 90 day POS trend analysis and recommend forecast adjustments. Identify trend variances at different customers to determine potential sales opportunities and risks. Track key customer in stock percents and TY/LY inventory levels on a weekly basis. Communicate flow issues to sales team to proactively identify potential in stock issues due to sales exceeding forecast or supply availability issues. Recommend forecast adjustments required to achieve customer in stock targets and minimize excess inventory risk. Incorporate customer promotion schedule into forecast and flow requirements. Determine breakdown of monthly forecast into regular/replenishment unit forecast vs. promo forecast. Perform post mortem analysis on promo and special program sales results. Ensure supply requirements and promotion requirements. Clearly communicate new item lead times to sales team and ensure compliance to forecast and item set up timelines. Improve forecast accuracy on new items by identifying similar historical items based on price point and functionality and utilize actual sales data to determine baseline forecast. Measure monthly forecast accuracy and analyze quantitative and qualitative reasons for forecast error.
Affinia Group Intermediate Holdings Inc. (Affinia) operates in the on- and off-highway replacement products and services industry. The...