A leading Slovak food manufacturer

A Slovak food manufacturer brought sales, purchasing and costs into one planned P&L

A leading Slovak food manufacturer moved from collecting Excel files to planning in a shared environment. EMARK carried over the existing calculations and connected sales, purchasing and cost plans. Teams spend less time preparing and collecting inputs and can see how changes flow through to the planned P&L.

3
planning areas linked in the planned P&L – sales, purchasing and costs

1
shared environment for entering and processing plans

Use cases

Technologies used

Qlik

Inphinity Planning Tools

Challenge

The company did much of its planning in Excel. Before each cycle, teams prepared historical data, split it according to planning rules and distributed files to individual users. Once users had entered their figures, the files had to be collected, consolidated and recalculated. This created recurring manual work before teams could review a consolidated plan.

Sales, purchasing and costs all fed into the same planned profit and loss statement. The company needed to retain the calculations embedded in its spreadsheets while making it easier for teams to enter their figures and reflect changes in the financial plan.

Solution

EMARK moved the planning calculations from Excel into Qlik with Inphinity planning tools. It linked sales, purchasing and cost inputs to the planned P&L and configured access according to users’ planning responsibilities. Teams work with historical data and enter their plans directly in the application, reducing the manual effort required to prepare and collect inputs.

When inputs change, teams can recalculate the P&L and see the effect on planned financial performance. The application breaks the plan down by day so users can track actuals against it throughout the period. It also records who changed each planned value and when.

Before