Forecast Analyst
VTech Electronics - Arlington Heights, IL

This job posting is no longer available on VTech Electronics. Find similar jobs: Forecast Analyst jobs - VTech Electronics jobs

DESCRIPTION

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. The Forecast Analyst reports to Forecast and Inventory Manager. In addition, this position works closely with sales, finance, marketing, and the overseas manufacturing team.

DUTIES

Responsibilities for our Forecast Analyst include:
  • Collaborate with field reps and internal Sales team to generate monthly unit and revenue forecast by customer.
  • Participates in weekly and monthly business management meetings, presenting analysis, calling out issues, and identifying action items
  • Perform root cause monthly variance analysis on a customer by customer basis. Provide monthly variance analysis by item for TY/LY, TY/budget, and TY/previous month
  • 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.
  • Identify special programs such as end cap items, out of aisle features, holiday catalog items, Thanksgiving weekend specials.
  • Perform post mortem analysis on promo and special program sales results.
  • Ensure supply requirements support customer modular reset requirements and promotion requirements.
  • Track changes in stores counts by customer by item to incorporate impact on sales.
  • 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
QUALIFICATIONS

Our ideal candidate will have the following experience:
  • 5 years of experience in an inventory management environment
  • Highly analytical, flexible, action- and results-oriented, with strong written and verbal communication skills.
  • Excellent organizational skills including prioritizing, scheduling, time management and meeting of deadlines.
  • High level of proficiency in MS Excel, MS Access preferred
  • Experience working with MAS 90 and Oracle
  • Demonstrates progressive experience in forecasting
  • Bachelors Degree
Responsibilities for our Forecast Analyst include:
  • Collaborate with field reps and internal Sales team to generate monthly unit and revenue forecast by customer.
  • Participates in weekly and monthly business management meetings, presenting analysis, calling out issues, and identifying action items
  • Perform root cause monthly variance analysis on a customer by customer basis. Provide monthly variance analysis by item for TY/LY, TY/budget, and TY/previous month
  • 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.
  • Identify special programs such as end cap items, out of aisle features, holiday catalog items, Thanksgiving weekend specials.
  • Perform post mortem analysis on promo and special program sales results.
  • Ensure supply requirements support customer modular reset requirements and promotion requirements.
  • Track changes in stores counts by customer by item to incorporate impact on sales.
  • 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

VTech Electronics - 19 months ago - save job - block
Recommended Jobs
Commercial Analyst
Planet Pharma - Northbrook, IL
Planet Pharma - 6 days ago
Easily apply

Supply Chain Analyst-Buyer
Anixter - Glenview, IL
Anixter - 8 hours ago

Sr. Financial Analyst
CVS Health - Northbrook, IL
CVS Health - 1 day ago
About this company
3 reviews