We are now firmly in the driving seat. With better support for planing and analysis. 

Bilia chose Mercur Business Control as a group-wide solution for budgeting, forecasting and analysis for both the central functions and nearly 100 car dealers in Scandinavia. Bilia uses Mercur's functionality for multi step cost allocations and functionality to create logical relations between revenues and costs of various functions. The system is integrated with Bilia's data warehouse and has 530 users.

Bilia is Scandinavia's largest car retail chain, with a leading position in servicing and sales of cars and transport vehicles plus supplementary services. The Group has 100 retailers in Sweden, Norway and Denmark plus an online auction site in Sweden, Netbil. Bilia sells cars from Volvo, Renault, Ford, Hyundai, Dacia, Honda, BMW and Mini, as well as transport vehicles from Renault, Ford and Hyundai and motorcycles from BMW.

Background and goal 

Bilia's procurement of systems for business management and decision support was preceded by an internal process listing a number of requirements for  future solution.

It was important that the solution could handle both budget and forecasting and analysis within the framework of the same system.

In addition, there was an overall wish that Bilia could administer the solution on its own. This also included a dynamic report generator that would be so easy to use that Bilia's system administrators could create all input forms and reports on their own.

Furthers  requirements were set for the solution to be integrated with Bilia's data warehouse with data from, among other things, the financial system IFS and offer connection to the electronic invoice management systems Invoicia and IFS E-fact.

- Both controllers and managers at all levels, appreciate that so much is already prepared with built-in logic for different calculations.

Hans Bertéus, Group Controller, Bilia AB

A solution based on Mercur Business Control

Following an evaluation of different suppliers, the choice became Mercur Solutions, which was commissioned to initially implement the solution at the largest company in Sweden with 68 plants, in Norway with 20 plants and at the parent company Bilia AB.

The assignment included the standard Mercur Business Control application as well as consulting services for the implementation of a solution in a central Citrix environment for a total of 530 users who access the system through thin clients.

Integration with Bilia's data warehouse 

Mercur initiated the project with the integration against Bilia's data warehouse and created an interface for daily automatic updating of Mercur with both data and code plan. The various code sections, that is. account, cost center, product and brand, and their shadow codes, in the form of different groupings, are maintained outside Mercur but automatically updates Mercur's code plan and hierarchies automatically. This was important for Bilia when using these shadow codes to create the rows in their report package and thus simplify the design and maintenance of the reports.

With Mercur's dynamic reports, you can then "tease" from the total level via different hierarchical levels down to individual transactions, from where you can also directly view scanned invoices. This also requires that the solution is capable of handling Bilia's volumes with between 15 and 20 million transaction lines annually.

Start up according to plan 

After a brief training, Bilia's system administrators took over the responsibility for creating input forms for budget, forecasting and reports as well as key figures analyzes. The project began in May and the system could be used for the budget process starting in September the same year.

- Automatic consolidation and dynamic reports mean big time savings. Mercur really simplifies planning work. At all levels!

Hans Bertéus, Group Controller, Bilia AB

Mercur Business Control at Bilia today

Since the solution was launched, Bilia uses Mercur Business Control for budget and three forecasts as well as for continuous analysis and follow-up. The system also generates a structured output file as a basis for the Group's legal consolidation system.

By using Mercur's multi-company solution, you can work with different code plans in Sweden and Norway. At the same time as it is possible to share report and form templates, this also gives freedom to develop individual reports for the different markets as needed. The users also appreciate that the system's menus and texts are both in Swedish and Norwegian and that the system supports planning and analysis in local currencies.

Bilia has also benefited from Mercur's functionality to distribute common costs, such as central workshop costs, in several steps via regions down to individual workshops. The system's advanced calculation logic is also suitable for creating rules for how planned revenue within one function generates revenue for other functions, which can be illustrated, for example, by the relationship between new car sales, delivery workshop and accessories..

Future plans for Mercur at Bilia 

The next step with Bilia will be to roll out Mercur to its users in a number of new companies that have been acquired and in Denmark where it operates an additional 8 plants.

There are also plans to create a link to the payroll systems Vivaldi and Agda from where you will import detailed personnel data for budget and forecast. Bilia also evaluates the possibility of using Mercur for the ongoing reporting of financial outcomes and to create an investment module that is linked to the financial reporting.

Mercurs solution

System: Mercur Business Control
Users: 530
Processes: Budgeting, forecasting, monitoring and analysis

Other: Bilia uses Mercur's functionality for several cost distributions and to create logical relationships regarding revenue and costs between different functions. The system is integrated with Bilia's data warehouse.

The Group company Bilia AB has over 100 plants and is located in Sweden, Norway, Germany, Luxembourg and Belgium. In all markets, customers are offered car sales, financing, service and accessories and spare parts sales.. 

In Sweden, Bilia is an authorized dealer for Volvo, Renault, Dacia, BMW, MINI, Lexus and Toyota and has fuel and car wash stations.

Revenue: 2 584 MEUR (2019). 
Employees: ca 4 000  (2019)

Subscribe to our newsletter

Are you interested in news regarding trends, tips & inspiration within finance? Subscribe to our newsletter. We promise to respect your inbox.

Mercur Solutions

A Swedish company with over 40 years of experience, delivering solutions for performance management and business intelligence. 

 

Read Mercur Business Control Reviews on GetApp.com

Mercur Solutions (UK) Limited - UK office

Mercur Solutions Limited
Ocean House, The Ring, Bracknell RG12 1AX, United Kingdom
+44 (0) 1344 388 025

 

Mercur Solutions AB - head office in Sweden

Mercur Solutions AB
Vretenvägen 13, SE-171 54 Solna
+46 (0)-459 69 00

 

Malmo Office

Stortorget 3, SE-211 22 Malmö
 

Gothenburg

Östra Hamngatan 17, SE-411 10 Göteborg