Journal of Applied Science, Engineering, Technology, and Education
Vol. 1 No. 1 (2019)

Marketing Research : The Application of Auto Sales Forecasting Software to Optimize Product Marketing Strategies

Bakri, Rizal (Unknown)
Data, Umar (Unknown)
Saputra, Andika (Unknown)



Article Info

Publish Date
03 Jul 2019

Abstract

The aims of this study is to apply the Auto Sales Forecasting software to predict sales transaction data. The Auto Sales Forecasting software consists of two main features namely descriptive analysis and forcasting features along with its visualization. Forecasting methods contained in the Auto Sales Forecasting application are forecasting methods of Simple Moving Average, Robust Exponantial Smoothing, Auto ARIMA, Artificial Neural Network, Holt-Winters, and Hybrid Forecast. The Auto Sales Forecasting software can intelligently choose the best forecasting method based on RMSE values. The results showed that the Auto Sales Forecasting software successfully analyzed the sales transaction data. From the analysis it was found that there were 43 types of products produced and sold by the Futry Bakery & Cake Store. Three of them are the types of products that are most in demand by consumers, namely Sweet Bread, Maros Bread, and Traditional Cakes 3500. The best selling product type, Sweet Bread, is used to build forecasting models. The best forecasting method is the Robust Exponential Smoothing method with the smallest RMSE value of 0.83 on the variable number of sold out products. Forecasting results using the Robust Exponantial Smoothing method show that the average number of products to sell for the next seven days ranges from 116 products with a certain confidence interval value.

Copyrights © 2019






Journal Info

Abbrev

asci

Publisher

Subject

Civil Engineering, Building, Construction & Architecture Computer Science & IT Electrical & Electronics Engineering Industrial & Manufacturing Engineering Other

Description

Journal of Applied Science, Engineering, Technology, and Education (ASCI) is an international wide scope, peer-reviewed open access journal for the publication of original papers concerned with diverse aspects of science application, technology and ...