Edgewell is a global team of over 6,000 visionaries, doers and makers. Our secret is people, and we have an inspiring and collaborative global force of them. Our portfolio of over 25 brands touches lives in more than 50 countries by making useful things joyful. Together, we reimagine good mornings and endless summers, strive for more sustainable ways to beautify and bond, and do it all with not only confidence but determination.
The Forecasting Planner is responsible for the total NA base forecast which is the basis of the Demand Consensus forecast. The position is accountable to develop and maintain all statistical type forecasts and system set ups and maintenance on JDA demand for their assigned items. The individual will collaborate with the demand planners to understand and align to sales and marketing promotional forecasts as well as understand any impacts to the historical and statistical forecasts. This role will drive suggestions for advanced analytics, exception-based forecasting, and system and database maintenance in order to achieve forecast accuracy targets and organizational objectives.
Accountabilities
Statistical Forecast
- Forecast Development: Generate & provide the unconstrained shipment forecast to Supply Planning/Operations for a rolling 36-month period in units and gross sales dollars with a focus on current fiscal year.
- Own the process of statistical reconciliation to ensure the best possible statistical modelling parameters and fair share forecast distributions to balance item and demand group level forecasts.
- Utilize all system functionality to drive the best baseline forecasts including Demand Classification, Seasonality curves, Product Family forecasting, NPI forecasting etc.
- Perform forecast modelling and tuning by adjusting forecasting parameters to ensure the best possible accuracy within forecast horizon in line with Lag timing and targets.
- Own the process to apply manual adjustments for OOS & consequent lost sales in line with best practice.
- Suggest and drive improved analytics based to drive improved base forecasts.
- Collaborate with Demand Planners to make recommendations and align on trend patterns, forecast change drivers, 3-year strategic view and gap closing actions needed to be reviewed with commercial teams
Analytics
- Ensure the best possible total volume forecast to support the Demand Planning team in gaining validation and IBP sign off
- Utilize exception-based analytics to identify and investigate root cause of forecast accuracy, bias, Coefficient of Variation (CoV), Forecast Value Add (FVA), Extreme Error, SKU segmentation, Service (UFR) out of stocks, SLOBs, inventory issues and drive metric improvements accordingly.
- Focus on improving forecast accuracy within the correct horizon with the aim of maximizing sales, minimize service issues and balance with working capital and margin targets.
- Leverage bias issues by Business Unit and guide demand planners on key focus areas to eradicate 3-month bias within their BU including review of Market Intelligence and impact on bias and top account bias and actions needed to eradicate bias.
- Understand the impact of supply constraints from global supply planning meetings and provide information to support delivery to customers.
- Suggest and drive improved forecast accuracy root cause analytics for accuracy, OTIF and inventory issues.
- Own Forecast Accuracy reporting for top accounts and provide comprehensive analytics for error drivers and actions and discussions to be addressed with commercial owners to drive SKU level accuracy improvement.
- Drive root cause and action-based discussion points for IBP based on metrics analytics.
History and Data management
- Apply manual adjustments to history for promos / pipe fill / exceptional events when needed to ensure the cleanest historical data
- Managing DFUs (Forecasting records): Items setups, maintenance and set up of base item history and base item forecasts, like item linkages, connections to external data and imports, effectivity and disco dates, exceptions
- Adjust and maintain item level customer history be incorporating service impact to history stream within forecasting tool (jda)
- Follow up and support all technical jda data issues related to batch processes, hierarchy, master data issues.
- Ensure the timely transfer of forecasts to supply planning through the forecasting tool and investigate and elevate root cause issues and solutions to correct batch process errors.
- Drive history management improvements in jda i.e. history cleansing functionality, and guidelines and rules for history adjustments i.e. loss of promo, out of stock inventory impact etc.
CoE / IBP:
- Attend Oliver Wight IBP training and support Demand Planning and IBP maturity improvements.
- Prepare all analytical materials for the NA demand reviews/Management Business Reviews for IBP cycle meetings. Provide base forecast change drivers, overall forecast, accuracy and analytical key issues, 3-year outlook key messages.
- Suggest and support Demand Planning of Best-in-Class practices to drive improvements in forecasting either within jda functionality, IBP and Demand Planning Market Intelligence needs.
- Support Demand CoE roadmap projects for forecast improvement, delivering required strategic improvements and maintaining and documenting aligned demand processes.
Required Skills and Experience
- 5+ years of experience in Demand Planning or Forecasting
- BA/BS required (Supply Chain, Mathematics, Statistics, Engineering)
- Number orientated analyst with strong mathematical, statistical and analytical skills.
- Key Competencies: Detail Orientation, Results Driven, Continuous Learning
- Technical aptitude and Forecasting and data software experience required (i.e. jda demand/Manugistics, SAP, PowerBI, etc.)
- Intermediate to advanced skills working in Excel and Microsoft Office
Preferred Skills and Experience
- MBA or MS a plus
- Professional Certifications a plus (IBP, APICS, IBF, SCOR etc.)
#LI-DR1
Edgewell is an equal opportunity employer. We do all we can to create a collaborative and diverse global team, where good ideas can thrive, and our colleagues can learn and lead. We prohibit discrimination based on age, color, disability, marital or parental status, national origin, race, religion, sex, sexual orientation, gender identity, veteran status or any legally protected status in accordance with applicable federal, state and local laws. We listen deeply and speak directly to create an environment that’s open to difference. We aim to bring joy to not only the products we create and the people we serve, but our colleagues across the globe too.
