Do you have questions about Data Science?

We’d love to hear from you. 

Contact

Case study: Forecast of sales data

For retailers, previewing the daily and weekly sales volumes in the various stores is crucial for conducting purchasing and sales planning. Using structured data along with a forecast model, COSMO CONSULT succeeded in a project that aimed to detect and explain patterns and forecast sales figures.

Key facts

  • Enabling more accurate purchasing and sales planning
  • Avoiding out-of-stock situations
  • Learning from the past
  • Considering external influencing factors

Initial situation

Sales forecasts are among the most common parameters of advanced algorithms. In most cases, it is based on daily or weekly forecasts based on sales, store and special offer data. In order to take into account as many influencing factors as possible, weather data, holiday dates or information about competing locations are used.

For one of the projects, COSMO CONSULT developed a model that forecasts daily and weekly aggregate demand quantities in order to predict store-related sales.

Approach

In the retail industry, most of the sales data show direct dependence of the sales figures on the day of the week. Saturday stands out as the strongest selling day, with up to 70 percent of the total weekly sales. As for the weather data, precipitation has a higher influence than temperature fluctuations. The effect is different even for the different types of stores: For example, the effects are sometimes exactly the opposite between a shopping center and stores at greenfield sites. The same applies to public holidays and school holidays.

The first step was to analyze the past data and find out the factors that really matter. For the forecasting, a gradient boosting model (machine learning) was developed in the programming language R. Having a clean database was crucial for the success of the model. Otherwise false patterns would have been found throughout the data. The forecast can either be integrated into the existing infrastructure or used internally for further projects.

Additional benefit

Classical sales forecasts are often used as a subfunction of larger solutions. For example, for the dynamic pricing solution of COSMO CONSULT, forecasts of the sales data and price elasticities are first generated in order to carry out a well-founded optimization. Sales forecasts can also lead to important findings for stock planning. They help avoiding delivery bottlenecks or using discounts through early order transactions.

Do you have questions about Data Science?

We’d love to hear from you. 

Contact

Ask our experts

COSMO CONSULT has many years of experience in providing digital solutions in the field of data science. Our services are based on a clear approach, detailed knowledge of business processes, and excellent product expertise. Our experts will be happy to advise you on the unique possibilities available to you when you use modern software technologies. Please give us a call! We look forward to talking with you on how your business can enter the digital age.

Contact Us!

COSMO CONSULT International

COSMO CONSULT SI GmbH
Lothringerstraße 14
1030 Wien
E-Mail
COSMO CONSULT
201 rue Carnot
94120 Fontenay-sous-Bois
+33 1 83010360
E-Mail
COSMO CONSULT
Schoenebergerstr. 15
10963 Berlin
+49 30 343815-0
+49 30 343815-111
E-Mail
COSMO CONSULT KFT.
Rétköz utca 5. 1118 Budapest Magyarország
+36 1 899 9000
E-Mail
COSMO CONSULT Business Solutions SRL
Intrarea Gadinti nr. 1 Sector 1 RO-011066, Bucuresti
+40 21 224 5516
E-Mail
COSMO CONSULT SPAIN, S.A.U.
Vallespir, 19 4ª Módulo 2
08173 Sant Cugat del Vallès, Barcelona
+34 902820242
E-Mail
COSMO CONSULT AB
Ralambsvaegen 17
11259 Stockholm
+46 8 7998660
E-Mail
COSMO CONSULT
Ruetistrasse 13
8952 Schlieren
+41 44 8306465
E-Mail
COSMO CONSULT CHILE SaP
Mardoqueo Fernández 181
Providencia - Santiago de Chile
+562 2382 8050
E-Mail
COSMO CONSULT COLOMBIA SAS
We Work - Calle 26 # 92-32, Oficina 3-131
Bogotá - Colombia
+57 3004846267
E-Mail
COSMO CONSULT Business S.L
Checoslovaquia E10-105 y Eloy Alfaro
Quito, Ecuador
‪+593 99 608 4180
E-Mail
SOLUCIONES EMPRESARIALES COSMO CONSULT MÉXICO S.A.P.I de C.V
Arquímedes 15, Col. Polanco V Sección
Delegación Miguel Hidalgo
Ciudad de México C.P 11560
+521 55 83109660
E-Mail
COSMO CONSULT PANAMA & CENTRO AMERICA S.A.
Trump Tower, Piso 2, Oficina 210
Punta Pacífica
Ciudad de Panamá, República de Panamá
E-Mail
COSMO CONSULT PERÚ SAC
Avenida Javier Prado Oeste 757
Magdalena del Mar - Lima, Perú
+51940225294​​​​​​​
E-Mail