Matthieu Lair

Demand Planning Analyst @Graphic Packaging International

Planned the demand for the beverage portfolio, totaling about $1.3B of business, incorporating statistical analysis, historical data, customer input, and internal sales insights to develop a demand plan for supply and capacity planners - Lead 8 monthly meetings with sales and customer service to come to demand consensus before passing onto the rest of the business - Maintained an average mean absolute percentage error of 28.5% versus actual sales, which was 10% better than average error in the business - Improved the beverage demand planning process by going from a sales focused discussion to a units focused discussion leading to more predictable and accurate forecasts as increased pricing created challenges to analyze historical sales data - Improved the process for reporting tonnage, by switching from a method of calculating tons via sales to a method using product weights to get to tonnage, vastly limiting potential error due to price swings - Assisted the onboarding of a new ERP system and developing new business rules to operate effectively in a new planning environment, such as how to effectively manage product transitions and revamping our demand consensus calls