Simulations & Forecasts

  1. Home
  2. CPM
  3. Simulations & Forecasts

Instantly find out the impact of your decisions

With the help of the CPM solutions you can quickly and easily create simulation models which accurately reflect the business challenges, because it provides the analytic intelligence needed for evaluating the potential impact of decisions before they are made.

In practice, users enter numeric data at any aggregation level (e.g., Sales per product line), and the changes are automatically allocated upwards (Total Sales) and down to the lowest level of detail (product code) to all correlated dimensions (once the user has updated the sales per product line, the changes will also be distributed across geographic regions, sales channels, customers, etc.).

A powerful combination of native features (real-time data aggregation, calculations and allocations, cells that process formulas and values simultaneously, business rules) make it easy to understand the potential outcomes generated by the KPI variation.

For instance, you can simulate how a change in the fixed cost allocations is immediately reflected in the gross profit calculation for the products, channels and customers, or vice versa.

Similar models can be built for both strategic purposes, such as adjusting the planning, generating scenarios and sensitivity analyzes, and for improving the accuracy and efficiency of the financial planning or the workforce processes.

Move past the limits of the Excel solutions

Any changes made to the data will be quickly propagated from top to bottom, from bottom to top or in the middle to any dimension. Furthermore, you will be able to analyze the data to the lowest level of detail with the drill-down functionality

In addition, a unique feature called Reverse Algorithm extends this capability to the calculated fields. As a result, if you change a percentage value, that change will automatically be reflected in the quantities from which the percentage was calculated

By enabling the same cells to be used for both input and output, the CPM system goes beyond one of the most obvious limits of the Excel solution, where a cell can handle a value or a formula, but not both simultaneously

Because it applies to any value in the CPM solution, including totals and subtotals, the reverse algorithm revolutionizes user experience during the simulation and planning processes

The data from different years or months can easily be compared, whether we’re talking about budgeted or actual amounts. More about the comparative analysis capabilities offered by the CPM solution in this video

Forecasts available to anyone

The CPM solution incorporates advanced analysis and data forecasting capabilities in your business processes, so you can keep up with today’s pace of business development

Users can discover trends, generate forecasts, create simulations, and easily make decisions

The automated predictive model of the CPM system can generate highly accurate forecasts in a fraction of the time and effort spent with the traditional systems

Starting from the forecast, by adding additional information to the scenario, the impact of the external variables on the forecast can be easily observed

Users choose the desired number of groups and observation sets (i.g. profitability and turnover), and the system creates instant clusters and makes them available as dimensions for analysis. This integration between the clustering capability and application environment allows not only the instant creation of cluster-based reports, graphs and self-service analyzes but also their use as forecasting or planning units


Do you need more information?

Download the full presentation of the CPM Solution!