文章基本信息

标题：Assessment of the Sales Forecast Technique Double-Weighted Moving Average vs Other Widely Used Forecasting Techniques
本地全文：下载
作者：Ma. del Rocío Castillo Estrada ; Marco Edgar Gómez Camarillo ; Fernando Pérez Villaseñor 等
期刊名称：International Journal of Business Administration
印刷版ISSN：1923-4007
电子版ISSN：1923-4015
出版年度：2020
卷号：11
期号：2
页码：39-56
DOI：10.5430/ijba.v11n2p39
出版社：Sciedu Press
摘要：In order to improve the operations planning of two companies, whose main business is to be chemical products suppliers in Mexico, it was made the sales forecast of a fourth year of operations, using the monthly sales data information of the three previous years. The objective of the chemical suppliers forecast was to be in a better position to satisfy the multiple and varied needs of their clients, which demand different quantities of products and have different consumption patterns. The sales forecast was made by the next six techniques: Simple Moving Average (SMA), Weighted Moving Average (WMA), Trend Projection (TP), Exponential Smoothing (ES), Simple Linear Regression (SLR), and the recently proposed (Castillo, et al. 2016) technique called: Double-Weighted Moving Average (DWMA). The three years monthly sales data of 61 products, handled by the two companies, were processed in order to obtain the monthly forecast of the fourth year. After the fourth year, the forecasted data were compared with real monthly sales data. The analysis was made by the determination of the Symmetric Mean Absolute Percentage Error (SMAPE), which gave the next results: In the case of company 1, the average errors for the five reference techniques (SMA, WMA, TP, ES and SLR) was in the range 0.235 – 0.351] vs 0.249 for the DWMA. For company 2, the average error, of the same five reference techniques was in the range [0.292 – 0.467] vs 0.282 for the DWMA. WMA was the second technique in giving the least forecasting errors. In both companies, DWMA was the forecasting technique with one of the lowest average error and the lowest error in most of the products.
关键词：forecasting techniques; least error; suppliers of chemical products; consumption patterns; operational planning