Dalpromryba has automated budgeting on the Optimacros platform

2023: Completion of Budgeting Automation Project

On December 11, 2023, the company Dalpromfish"," one of the players in the fish conservation market, announced the completion of a project to automate budgeting. To solve the problem, a domestic platform was chosen. Optimacros The project was implemented by specialists of the company ATOMS Consulting"."

According to the company, Ecxel's capabilities were no longer enough to ensure the operational work of the financial service of the enterprise. The results of the Optimacros capabilities demonstration convinced the company of the correct choice of a tool for automating budgeting. Within the framework of the project, the employees of ATOMS Consulting solved several important tasks.

First of all, the Optimacros platform has become a single source of information that was originally provided in numerous disparate Excel files. Among the significant results of the project is the exclusion of manual labor for financial service specialists when processing and aggregating data, which reduced the risk of errors and optimized the efficiency of work.

Two budget models were also created: the first - combines the blocks of sales, costs and reporting, the second - the HR model. Data integration is configured between them. The revenue budget is based on indicators on sales volumes, prices and discounts in the sections of names (SKU) and counterparties, which in turn are grouped by responsible sales managers.

Budgeting of the expenditure part is carried out by cost items, each of which is distributed by names and counterparties in accordance with certain rules. The implemented HR model allows, in particular, to load the staffing table, revise accruals, calculate the USN, transfer data to the budget model and consolidate them into reports. The budget model provides for the possibility of implementing scenarios with different versions of data, which is especially important during the turbulence in the economy.

To obtain actual data, integration is set up with, accounting system 1C from where the created model automatically receives information items, price lists, (to sales base volumes/promos, volumes/discounts), cost prices, operating costs, etc. The import of data is also monitored automatically. The information received is used for the reporting fact plan.

The implemented solution allows you to generate different types of reports. Among them is a sales analysis report, which allows users to assess the situation in the sections of goods and counterparties from revenue to gross profit. Two P&L reports are also created: the first one is more detailed, analyzing the situation by names and counterparties. The second is more aggregated, showing the final financial result for the company as a whole.

The system also enables you to generate a Cash Flow report by month, using both direct and indirect methods.

For me, the main feature of the project is ensuring the integrity of data on a single platform, flexibility in the reporting system, transparency and speed. Literally in real time, I can answer the question of what income and expenses we had for a specific client, in a specific month, for a specific product name. When using Excel, it took 3 days to consolidate the revenue side of the budget: to calculate net revenue, data on sales volumes, prices, percentage discounts, which were stored in different files, are required. Thanks to the configured data export-import system, all the necessary calculations are carried out almost online. And instead of three days, we spend 4 hours calculating sales, i.e. reducing the time by 6 times. At the same time, time is spent mainly on reconciliation of input data, since all algorithms for their processing are already configured in Optimacros. noted Evgeny Goryachev, financial director of the Dalpromryba enterprise

It took us 3 months to automate budgeting. Taking into account the fact that during the implementation of the project we modernized part of the budget processes, this is a fairly short time. Time optimization has become possible due to the flexibility of the system and the ease of its implementation. I also consider it necessary to note the speed of calculations: users spend 2-2.5 seconds on data entry and recalculation of the entire model. noted Maxim Yurygin, project manager, partner of ATOMS Consulting

The company plans to further develop the created model. In particular, retail sales forecasting. Another step will be to work directly in the system of employees of other departments. The possibility of generating reports by users is also being considered, which will significantly save time for specialists in the financial unit. In addition, you plan to use Optimacros in interim calculations, for example, in the calculation of production costs, which depend on production volumes.