Kunde Case |
Tryg Group Forecasting – Rolling Forecast and Analysis Platform
SAP, Oracle, SAS Inst. and Excel
Tryg is the largest insurance company in Denmark, and the second largest in the Nordic region and with 3200 employees, they provide insurance for 2.55 million private individuals and 140,000 companies. One of Denmark's most modern and digitally controlled companies.
It is crucial for the executive board and the group
It was time consuming and resource-intensive
The challenge, however, was that the models required many manual processes. It took 6 weeks of work to collect and prepare a forecast, and at the same time it was technically difficult to show rolling forecasts – for the current year and 3 years ahead. It was on a close shave that Group Finance reached to deliver the forecast every quarter.
The Excel and Access model has, over time, become so large, complex, and personal dependent that the risk of errors, errors in business and inconsistent results is high. Furthermore, it was difficult and difficult to keep track of forecast versions, and control of the many explanations, as to who delivered what and when.
It was difficult to consolidate the many Excel sheets and models, and it was very time-consuming to check and validate the data and the consolidated versions, to be sure that the basis for the quarterly forecast was correct and of the right quality.
New digital and automated Rolling Forecast solution with Jedox, automates, streamlines the process and makes it easy for users
In autumn 2016, Tryg chose Jedox as a new platform to replace the running Excel / Access model, in a migration collaboration with Qbit.
With Jedox, Tryg gets an integrated and vibrant world, with rolling and dynamic forecasts from any start-up period, with automated data load, validation and direct consolidation of the reports and explanations.
What once took 6 weeks earlier now only takes 1
With Jedox, all data and business processes are digitized so that the solution guides the communication to the users in the business, and ensures that all input in the form of changes to forecasts, proposals for new initiatives, explanations are automatically collected and promptly consolidated. Instead of the cumbersome spreadsheets with many sub-sheets, the business now receives targeted, simple and easy-to-use forecasting tools, in a modern browser that makes it easy and fast for users to access up-to-date information and quickly and easily report to the Group Finance.
Users report expectations and initiatives with related business case
Users have to relate to a number of conditions. For example, if there is an increase in burglary, what do we do? – what initiatives do we put in place to either reduce the number or adjust in terms or price, and what financial impact will it have.
Rolling Forecast based on finances and initiatives for the next 3 years
Management reports to the Executive Board are done to provide a forecast of the development, and expectations of the Tryg Group’s performance in the short and long term, to ensure that the dialogue at management level supports ongoing and agile consideration of whether the Group’s efforts and initiatives bring Tryg in the right direction: In Tryg’s Group forecast, it measures various elements and inputs, which are calculated and delivered in an overall forecast and P&L.
Safe solution: State-of-the-art Forecast and consolidation engine
How is the process for Rolling forecast at Denmark’s largest insurance company?
With Jedox, Tryg Ensurence has an automated forecasting process that can produce a day-to-day expected forecast 3 years ahead with the fewest possible resources. In addition, the Group’s controllers in Denmark, Sweden and Norway now have a common toolbox for financial ad hoc analysis.
Step 1 – Baseline
The starting point of the forecast is created by entering:
Group Finance secures data entry and opens up for the forecast version to be used, and clears forecast with local deadlines controllers, across countries and business units.
Step 2 – Entering and updating
After this, the forecast is open to a number of input / updates that the local controllers carry out in the system. It applies;
Step 3 – Automatic calculation and consolidation engine
The system’s calculation and consolidation engine supports the local controllers at the push of a button to see the effects of entries and updates. The effects of initiatives, index, inflation, corrections and projections are easily and clearly illustrated as parts of layers in a “cake” that the controllers can use to analyze results and continuously fine-tune forecast.
Step 4 - Operating expenses
Group Finance excludes entry and allocates costs from cost centers to individual business units and products. The forecast version is then closed in the system and a report package forms the basis for the following:
In addition, the controllers with Jedox excel add-in, have free access to make their own ad hoc analyzes on the data, cubes, calculation rules, versions, etc. that make up the total solution.
Tryg plans to use Jedox for more areas in the future. Tryg today uses another application for sales management and forecasting, and will replace it with Jedox for a more modern, user-friendly and integrated application. Furthermore, Tryg will consider using Jedox Artificial Intelligence to better predict changes / trends based on a lot of data, among other, if customers are about to leave, thereby allowing them to respond before it’s too late.
Thousands of companies have already chosen Jedox!
We offer the opportunity to try Jedox for free – Our consultants are always ready with instructions for using the Jedox software or ready to answer any question you might have.