TM1 develops a business planning system for the TVEL TC of Rosatom

2021: Completion of the first phase of development and implementation of an automated business planning, budgeting and forecasting system

The working group consisting of experts of JSC TM1, Rosatom Fuel Company TVEL and JSC Greenatom completed the first stage of a large-scale project to develop and implement an automated business planning, budgeting and forecasting system for the Fuel Company TVEL. TM1 reported this on April 28, 2021.

The purpose of the project is to create a system that allows you to obtain complete information about the operational and financial indicators of the Fuel Company in the context of the plan, fact, forecast, and analysis of deviations, with details at the level of the group of companies, individual company and structural division.

At the prototyping stage, the working group examined and described the business planning processes of the Fuel Company "TVEL" and carried out functional testing of the prototype system at 10 pilot enterprises of the customer, which account for 80% of the budget of the group of companies.

Based on the results of the prototype testing, the working group agreed on a system configuration plan at 23 key enterprises of the Fuel Company. The implementation of the system is planned to be completed in 2022.

During the prototyping phase, the following functionality was configured and tested:

• consolidation of group enterprises data in a single format "on the fly," automatic calculation and coordination of intra-group turnover, decryption of summary indicators to the initial data of individual enterprises (drill down);
• reporting and analysis of sales data in different analytics with natural and financial scenario parameters, automatic factor analysis for implementation;
• planning and analysis of cost of sales by top-level items, highlighting change factors;
• Calculation of the unit of production by cost items and units;
• centralized entry of scenario conditions and recalculation of budget model according to selected perimeter of companies according to one or several scenarios;
• visualization of data in the form of information panels and interactive graphs, including with decoding of key indicators of the company's activity.

The system being implemented will allow us to move from the complex process of calculating and filling in data in Excel, which is a long-outdated model, to a single digital tool for entering and storing information. It will allow the enterprises of the Fuel Company to switch to a single structure of the budget model, end-to-end directories and "transparent" formulas of all budget indicators, "said Yevgeny Garanin, director of digitalization of TVEL JSC.

We chose Optimacros for such qualities as high reliability and performance in big data processing, our own database, integration with other systems and most operating systems, including Astra Linux, a multi-user interface and a role model of data management for implementing reconciliation processes, and business analysis functionality that meets the needs of large industrial customers, "explained Fedor Petrenko, CEO and founder of TM1 JSC.