
SALES FORECAST FOR AGGREGATE PLANNING: CASE STUDY OF AN INDUSTRIAL PRODUCTS COMPANY IN MEXICO
Author(s) -
Ignacio Alvarez Placencia,
Diana SánchezPartida,
JoséLuis MartínezFlores,
Patricia CanoOlivos
Publication year - 2021
Publication title -
acta logistica
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.205
H-Index - 3
ISSN - 1339-5629
DOI - 10.22306/al.v8i4.240
Subject(s) - demand forecasting , aggregate planning , product (mathematics) , aggregate (composite) , supply chain , supply and demand , productivity , plan (archaeology) , operations research , operations management , business , computer science , economics , production planning , production (economics) , engineering , marketing , microeconomics , history , materials science , geometry , mathematics , archaeology , composite material , macroeconomics
This case study presents the analysis through the use of sales estimation tools for planning demand for aggregate level as a finished product in a leading industrial products company in the market in Mexico. First, it aligned the demand plan and the supply plan, recommending the best execution scenario to increase operational efficiency and reduce the cost of operating the supply chain to increase the company's productivity and stay competitive. Then, after analysing the behaviour of the demand for selected products, the authors determined as the main affectation the inadequate precision of the method forecasting and the lack of an aggregate forecasting strategy that allows reducing the variation. Due to this, the most significant effort was concentrated on determining a better-forecasting model and the decision to aggregate the demand based on three relevant criteria: the demand pattern based on the Soft, Intermittent, Erratic or Irregular quadrant, the best method of the forecast for each product and the time in quarters. As a result, a reduction between 20% and 46% in the forecast variation can be obtained from the above.