"Most energy companies and their marketing managers could draw great benefit from Invest for Excel®."
The aim of Kraftringen was to acquire a tool for contracting calculations. Kraftringen searched support for cash flow modeling of customer business - from the customer point of view.
The tool should have enabled comparison of various contracting alternatives and finally, selection of the optimum solution. After customer-driven studies, the sales department would involve and prepare offers. Invest for Excel® suited those requirements.
In Kraftringen group the competences in investment decisions are clearly defined. The decision is submitted to the Company Board if the value of the investment exceeds SEK 2 million and to an Group Investment Committee if the amount of work exceeds SEK 10 million.
The Required Return on Investments are defined annually. Some investments are made for strategic reasons and these have different profitability requirements. In certain large projects, other priorities may be defined but the decision is nevertheless backed up by calculations made with Invest for Excel®.
How did it all start?
Business Developer, Göran Strandberg: "The whole affair started by us downloading the trial version of the software. We had a project coming in just then and we wanted to check which method was used in Invest for Excel. It appeared interesting, so we contacted Datapartner for further presentations. Finally, we decided to purchase the software."
Applications of Invest for Excel®
Invest for Excel® does not only serve the purpose of in-house calculations, it also has an important role in a sales process and in discussions with customers.
Peter Jansson, Manager of Customer Projects and Investment: "Most energy companies and their marketing managers could draw great benefit from "Invest for Excel®, especially if their task is to provide profitability calculations for their customers, e.g. for joining the district heating network. Use of one and the same calculation tool is an advantage."
Göran Strandberg: "Before Invest for Excel®, we each used to make our own calculations around the company. These were then used to supplement the project calculation models. Now Invest for Excel® is used for every single business transaction and we no longer have to wonder, which discount method should be applied, for example. Invest for Excel® brought a standard approach in our calculations. Of course, when needed we can change our assumptions. Deep drilling site for a geothermal project. Everybody is now using the same principles. The use of Invest for Excel® ensures an error-free calculation method. The fact that the calculations can be saved as files is another advantage. In summary, we can state that Invest for Excel® performs very well."
Bruce Lillemor, Project Manager: "I am very pleased with Invest for Excel®, especially with the fact that everybody is calculating with the same tool that is easy to use. The calculations are consistent and error-free. Invest for Excel® is easy to use – all you need to do is type in the figures. The software and its calculation principles are well known. We use different Invest for Excel® models, which are retrieved form the server. The calculation models do not longer need checking."
Lars-Göran Nilsson, Sales Manager: "I make district heating calculations (e.g. when a customer wishes to connect his house to the district heating network) as well as calculations for gas distribution and district cooling customers. Invest for Excel® is used in the daily activities for customer projects. The input for the software includes e.g. the fees to be collected and the total costs for the customer."
Invest for Excel® is used for project calculations in projects worth more than SEK 250 thousand, when the calculations are reviewed by the Managing Director", Nilsson continues.
About the training
The training was considered useful and thorough. Complex examples were processed and tested during the sessions. Afterwards, a slightly simpler model was selected for the daily use. Especially the sales staff experienced the training as extremely useful. Contracting activities, which were in the focus at the beginning, have become the main area of Invest for Excel application.
Copyright Datapartner Oy Last update in 2020. All rights reserved.