Novo Forecast Enterprise forecasting system integration into HATBER-M operational processes

Uvelka is one of the largest Russian companies in the cereals market. The company's brand is widely known not only in the Russian Federation but also in 25 countries around the world. Its products are sold in more than 96 thousand retail outlets across the country – super- and hypermarkets of national and regional retailers, as well as.

The company has been producing tasty and healthy cereal products that are easy in preparation for every day and provide families with good and healthy eating for more than 25 years.

"Our cooperation with Uvelka began with an interesting project – retail sales analysis based on the Qlik Sense platform," says Alexey Baturin, Novo BI CEO.

As a result, Uvelka employees received the opportunity to quickly monitor and thoroughly analyze large amounts of information on retail sales:

• Product range analysis, a ranking of products;
• Price and price brackets analysis, price elasticity estimation;
• Sales pattern and sales geography analysis;
• Promotion analysis and the impact of promotions on key sales metrics;
• Analysis of sales regularity, product life-cycle, retail outlets, retail chains.

"Then we came to understand that we need a more comprehensive view on sales and marketing, as well as their analysis," says Sergey Kirpichenko. "Novo BI specialists offered us a number of solutions:

• Secondary sales analysis
• Joint analysis of primary and secondary sales
• Growth potential estimation, automation of task assignment to sales staff, and recommendations on introducing new items at the level of distributors and outlets
• Expanded promotion analysis – trade and BTL
• Expanded analysis of retail sales taking into account promotions and loyalty cards data
• Expanded sales analysis – Nielsen solution for retail audit data processing, storage, and visual analysis" 

All solutions have been successfully implemented and today serve as one of the main tools for sales and marketing departments, as well as for Uvelka management.

Server Trading House supplies materials and components for modular furniture production. Throughout its existence, Server Trading House has become one of the largest suppliers for several hundred furniture manufacturers in most Russian regions.

The product range of the company consists of more than 5000 items, from chipboard to fasteners, and includes materials and components necessary for modular furniture production.

The company decided to adopt modern analytical technologies. Server Trading House opted for Novo BI company for two reasons: the company's specialists have extensive experience in the field and offer systems based on the Qlik Sense modern analytics platform.

The project meant to ensure: 

• The increase in sales planning accuracy;
• High level of product availability for customers, while controlling stocks and losses;
• The increase in logistics and procurement efficiency, with the increasing number of commodity items;
• Real-time data transparency across the supply chain.

The use of Qlik Sense allowed to merge data from different sources and create Decision-making Center, single analytics and monitoring center for all employees of Server Trading House.

Within the project, the following solutions have been implemented: 

• Sales plan analysis;
• ABC-analysis with the possibility to adjust parameters;
• Analysis and comparison of prices, goods in transit, future balances, and prices by item, supplier, warehouse and other available categories;
• Product profitability assessment by price;
• Current back up stock margin estimation;
• Analysis of indicators for order generation (analysis by product – price, cost, margin, logistics parameters, sales, stock balance, stock, overstock, payment, stock %);
• Regular customer analysis;
• Sales analysis;
• Highly detailed dynamic LFL analysis, which determines the reasons for the growth and fall in sales (by number of customers, by average order value, by average SKU per customer);
• Sales ratings by product, taking into account margin, working time, work regularity, number of regular customers, average order value by regular customers;
• Baseline reports on products, customers, employees;
• Automatic ordering – order calculation, taking into account the sales plans, logistics restrictions, stock balance, goods in transit for the selected period.

Generalskie kolbasy is one of the largest companies in the Volga Federal district of Russia. Over the years, the company has won many professional awards, earned the trust of partners, the respect of customers, and, most importantly, the love of millions of consumers. The company produces and sells a wide range of sausage products.  Today, the company's portfolio includes products of 3 brands: Generalskie kolbasy, Dym Dymych, Rossianka, traditional sausages, and meat delicacies. The company operates in 36 regions from the Crimea to the Urals.

After implementing the forecasting system, the Generalskie kolbasy company received a powerful tool for calculating current sales forecasts on a daily basis, as well as for automatically issuing production orders, taking into account the stock balance, forecasts, goods in transit, and remaining shelf-life requirements imposed by retailers

In the Nоvo Forecast Enterprise system, the Generalskie kolbasy company's employees plan and agree on factors affecting the forecast accuracy. Employees of different departments are involved in a single management planning network: sales, marketing, logistics, production, and finance. 

"We work in a highly competitive market of perishable products, where the accuracy of the sales forecast and the speed of its calculating are crucial," said Vladimir Akimenko, Deputy Director General of Logistics of the Generalskie kolbasy company.

Results