Tryg – It‘s all about creating peace of mind
Tryg is the biggest insurance company in Denmark and the second biggest in Northern Europe with 3,200 employees taking care of 2,55 million private persons and 140,000 companies (listed on Nasdaq OMX Copenhagen). Tryg‘s insurances include workers‘ compensation, motor, building, contents, transport, house, personal accident and health care. They mainly offer insurances through own sales and service channels and through business partners such as Nordea and Axa Corporate Solutions.
Tryg group puts emphasis on recognizing and comprehending business development processes across a broad and diverse range of areas. To ensure that, Tryg builds and constantly improves advanced planning and reporting models in Microsoft Excel and Access.
Som det kendetegner mange Excel modeller, som anvendes til budget er det vanskeligt at konsolidere ark, det er meget arbejdskrævende, der er stor risiko for fejl og fejlindtastninger, inkonsistente resultater, vanskeligt at følge versioner, indberetninger, forklaringer og der er intet revisionsspor.
The challenge was to meet the models’ requirements by performing complex manual processes. It took more than 6 weeks of intensive work to collect and prepare all necessary forecast data, and was further complicated by technical di culties when trying to display current and future forecasts from three years ahead.
The deficits of Excel regarding budgeting and spreadsheet consolidation contained several risks that led to a bigger work load. Higher error ratio, inconsistent reports, non- transparent version tracking as well as missing accounts and audit trails profoundly complicated the enterprise planning process at Tryg. The spreadsheet-based system needed to be replaced with a professional software solution for planning, reporting, and analytics. In fall 2016, Tryg chose Jedox as their new enterprise planning platform to replace existing Excel/Access models. With the help of Jedox partner Qbit, they migrated all their data to the Jedox database.
Thanks to Jedox, Tryg now benefits from integrated and dynamic enterprise planning, including rolling forecasts and time-independent forecasts, automated data integration and validation, as well as real-time consolidation of all reports.
Due to the variety of different insurance clients and cases, there is a multitude of different scenarios Tryg needs to be able to adjust their business to. For example, what needs to be done when there is an increase of burglary? What measures does Tryg need to take – initiating measures to reduce the number of burglaries or adjust the pricing? Anticipating the economic impact of those strategic decision on the business is crucial.
The new Jedox system helps Tryg to forecast group performance by aligning management reporting with short and long-term business development and future- oriented strategic planning. This facilitates dialogue on the management level, supports confidence in the Group’s efforts and finally brings Tryg on the optimal path. Tryg’s planning and forecasting is measured using different KPI that are calculated and consolidated. The resulting unified forecast is fed by areas such as:
- Premium revenues
- Damage percentages
- Weather and climate conditions
- Initiatives and observations (expected developement of craftman prices; campaign efficiency & efficiency of investments and acquisitions in existing and new systems, products, and occupations)
- Forventet udvikling i håndværkerpriser
- Effekt af Kampagner
- Effekt af Anskaffelser og investeringer i fx. nye IT-systemer, produkter og bemanding
- Expenses such as salaries, IT, etc., prescribing rolling forecasts and adjusting initiatives
- Allocating expenses (distribution of administrative / indirect costs, such as rent, IT, management fee by product and profit center)
- Fordeling af administrative/indirekte omkostninger, som husleje, IT, management fee, fordelt ud på produkter og profit centre
