JUCS - Journal of Universal Computer Science 29(11): 1385-1403, doi: 10.3897/jucs.112556
Retail Indicators Forecasting and Planning
expand article infoNelson Baloian, Jonathan Frez§, José A. Pino, Cristóbal Fuenzalida§, Sergio Peñafiel|, Belisario Panay, Gustavo Zurita, Horacio Sanson
‡ Universidad de Chile, Santiago, Chile§ Universidad Diego Portales, Santiago, Chile| Fundación Arturo Lopez Perez (FALP), Santiago, Chile¶ Allm Inc., Tokyo, Japan
Open Access
Abstract
We present a methodology to handle the problem of planning sales goals. The methodology supports the retail manager to carry out simulations to find the most plausible goals for the future. One of the novel aspects of this methodology is that the analysis is based not on current sales levels, as most previous works do, but on those in the future, making a more precise and accurate analysis of the situation. The work presents the solution for a scenario using three sales performance indicators: foot traffic, conversion rate and ticket mean value for sales, but it explains how it can be generalized to more indicators. The contribution of this work is in the first place a framework, which consists of a methodology for performing sales planning, then, an algorithm, which finds the best prediction model for a particular store, and finally, a tool, which helps sales planners to set realistic sales goals based on the predicted sales.  First we present the method to choose the best indicator prediction model for each retail store and then we present a tool which allows the retail manager estimate the improvements on the indicators in order to attain a desired sales goal level; the managers may then perform several simulations for various scenarios in a fast and efficient way. The developed tool implementing this methodology was validated by experts in the subject of administration of retail stores yielding good results.
Keywords
Sales and Operation Planning, Sales Goal Planning, Machine Learning