Flexibility of calculations

[sadiksojib35]

In addition to transparency, companies value flexibility. Usually, data for analysis and planning is obtained by summarizing primary data that enters the system in large volumes. However, companies do not afghanistan telegram number database always need to analyze all the data in detail.

In the case of manufacturing enterprises, the product part is planned very carefully: from sales volumes - to whom and how much, to production costs, including raw materials, energy and processing. At the same time, administrative costs can be planned by a coefficient: either a simple increase by the inflation percentage, or a more complex formula tied to production and sales volumes. In this case, the financial analyst does not need to collect costs for each item. Many systems do not allow this. The logic is simple: if the production and commercial part is planned at the lowest level of aggregation, then the calculation of, for example, administrative costs, should also be made for each item.

Solutions based on OLAP cubes (systems for storing and processing multidimensional data arrays), which are fully integrated into Excel, are more flexible. They take into account the costs of opening new outlets, potential revenue from them, as well as the operating prospects of existing stores. In this case, the financial department employee is only required to change the number of stores in these categories - the system will calculate everything itself.

On the topic: “Automate it now”, or what influences the automation of retail and FMCG