Russian software provides analysis of sales profitability of Belarusian beer producer

2022: Using Russian Sales Yield Analysis Software

On January 12, 2022, the company ATOMS Consulting"" announced that a major Belarusian producer beer and beverage "" Leeds beer uses profitability analysis the Russian the platform for. Optimacros The project was implemented by ATOMS specialists Consulting in less than 2 months.

Фото: nickobukhovich.livejournal.com

At the beginning of January 2022, the Lidsky Beer company supplies its products to more than 20 countries. One of the major export destinations is Russia. But the Belarusian company's products are also delivered to Poland, Israel, Germany, the USA, Greece, Korea, Singapore and other countries. Therefore, the task of determining the return on investment is non-trivial.

According to CFO Tatyana Ostrovskaya, attempts were made to use ON production and to solve it. Germany But Ukraine the results were not satisfied for several reasons. In products focused on planning tasks, it was difficult to report with the necessary, sufficiently high level of detail, while maintaining the flexibility of the structure. And in data developments designed for reporting, it was impossible to implement complex, multi-level algorithms allocations without losing speed.

As a result, the financial department of Leeds Beer drew attention to the Optimacros solution. To confirm its capabilities, ATOMS Consulting specialists implemented a pilot project to build a factor revenue analysis model in one week, after which a green light was given to the main project.

Each month, about 500 thousand records are uploaded to information cubes at the cost of delivery to each outlet, about 300 thousand sales records, more than 5,000 records - turnover on IFRS accounts, about 10 thousand customers and about 400 item items. The project of introducing a flexible analytics system was implemented by specialists of ATOMS Consulting.

Access to Optimacros will be provided by financial officers, marketers and regional sales managers.

Emerging reports allow you to assess how justified investments in different markets, sales channels, regions, brands, etc., as well as in discounts and promotion costs.

In addition, the reports demonstrate the economic feasibility of investing in promotion and sales, for example, you can see how investments in personnel pay off - in merchandisers, regional managers and sales agents, and in the organization as a whole.

Investments in promotions are also evaluated, in particular, additional discount in various channels, regions, networks, buyers, and in trading conditions resulting from agreements for representation in retail outlets in accordance with market share and agreed plans.

"So, thanks to the wide range of information being analyzed, we can see how effective any of our investments were, because scaling a business is always a matter of investment," believes Tatyana Ostrovskaya.

"This project allowed us to take a new look at the challenges being addressed by Optimacros. Initially, the software product was considered as a tool for corporate planning, modeling, scenario analysis and upper-level management reporting. As part of this project, Optimacros performed the task of preparing detailed data for customer reporting, which is usually the responsibility of the ETL system. Thus, we significantly expanded the boundaries of the application of the product, "- commented by Andrei Gvoskov, General Director of ATOMS Consulting.

The information is downloaded from two sources - import from the ERP system and information that users add themselves, for example, adjustments or additional detailing.

Reports are generated in the context of two main directories: goods (about 600 items) and payers/contracts (more than 5,000 contracts). The first guide groups products by brand, category, sub-brand, container type, and format. The second - by sales: by markets, countries, channels, regions and trade networks, and also gives details by regional representatives. Based on these directories, users have the opportunity to analyze the effectiveness of sales in the context of analysts of interest to them.

Leeds Beer, satisfied with the achieved result, plans to develop the project. In particular, the solution of tasks of the factorial analysis of revenue (for assessment of sources of formation of revenue from various factors - the volume of regular and promotional sales, the price, structure of grocery and client portfolios, regular and promotional trade conditions, influence of volatility of a rate of functional currency), logistics and prime cost in a section of finished goods, raw materials, materials, packings is discussed.

Optimization of distribution logistics tasks is also discussed.