文章基本信息

标题：Sales Forecasting System for Chemicals Supplying Enterprises
本地全文：下载
作者：Ma. Del Rocio Castillo E. ; Ma. Magdalena Chain Palavicini ; Roberto Del Rio Soto 等
期刊名称：International Journal of Business Administration
印刷版ISSN：1923-4007
电子版ISSN：1923-4015
出版年度：2015
卷号：6
期号：3
页码：p39
DOI：10.5430/ijba.v6n3p39
语种：English
出版社：Sciedu Press
摘要：In Mexico, the chemicals supplying enterprises have a hard job trying to make its operations planning. The difficulty is created by a combination of handling a large number of products and changeable consumption patterns of each customer. To simplify the operation planning task of those enterprises, a simplified system was envisaged and programmed. This free access and friendly software gives more accurate sales forecasts than the currently obtained by the chemicals suppliers. The developed software is written in PHP language (for web development dynamic content) and HTML (for making Web pages) and by the use of XAMPP software (Apache server module), runs on different operating systems. This program applies five quantitative sales forecasting techniques for each marketable product, with continuous error assessment, in order to select case by case, the monthly more accurate prediction method. The proposed system has been already applied in two companies; the first one used simple moving average, as a quantitative technique to predict its sales, and expert opinion as qualitative technique; the second company used trend projection as quantitative, and Delphi Method as qualitative techniques. Both companies consider that a suitable sales prediction is the starting point for good operations planning. For each product it is required to use a different technique, because the behavior of historical sales in each case is different. The proposed system allows identifying the lowest mistake technique to apply in the following sales monthly forecast, which is necessary to properly plan the operations in the companies under study. Based on the sales data of the last three years it is possible to make a yearly sales forecast, but each month, the monthly forecast should be updated with the last month data.
其他摘要：In Mexico, the chemicals supplying enterprises have a hard job trying to make its operations planning. The difficulty is created by a combination of handling a large number of products and changeable consumption patterns of each customer. To simplify the operation planning task of those enterprises, a simplified system was envisaged and programmed. This free access and friendly software gives more accurate sales forecasts than the currently obtained by the chemicals suppliers. The developed software is written in PHP language (for web development dynamic content) and HTML (for making Web pages) and by the use of XAMPP software (Apache server module), runs on different operating systems. This program applies five quantitative sales forecasting techniques for each marketable product, with continuous error assessment, in order to select case by case, the monthly more accurate prediction method. The proposed system has been already applied in two companies; the first one used simple moving average, as a quantitative technique to predict its sales, and expert opinion as qualitative technique; the second company used trend projection as quantitative, and Delphi Method as qualitative techniques. Both companies consider that a suitable sales prediction is the starting point for good operations planning. For each product it is required to use a different technique, because the behavior of historical sales in each case is different. The proposed system allows identifying the lowest mistake technique to apply in the following sales monthly forecast, which is necessary to properly plan the operations in the companies under study. Based on the sales data of the last three years it is possible to make a yearly sales forecast, but each month, the monthly forecast should be updated with the last month data.