Client Case Study

Automotive Industry

European division of one of the largest automobile manufacturers in the world eliminates its Planning reliance on spreadsheets.

automotive

Enterprise Analytics

  • Industry

    Manufacturing

  • Employees

    50

  • HQ

    Slovenia

  • Website

    www.qubix.com

  • Product & Services used

    Oracle EPM Cloud, Oracle Smart View, Qubix Cloudbridge, Qubix "Journey to cloud" Methodology

Download case study

European division of one of the world's largest car manufacturers streamlines its planning process with automated data flows, financial and management consolidation.

 

Our client is part of the operating subsidiary that oversees research and development, manufacturing, sales, marketing, after-sales and corporate functions of the world-renowned car manufacturer in Europe and western Asia. They conduct sales, aftersales and distribution activities for the SEE (Southeast Europe or Adriatic) region.

Their planning activities were previously done on a series of spreadsheets, and due to the variety of activities and the diverse processes of the various business areas, there was very little standardization of the planning process. The gradual evolution of the business processes resulted in an extensive number (over 500) of spreadsheets integrated into the planning and consolidation activity, along with the inefficiency and likelihood of errors that this sort of arrangement incurs. The process was also unable to support “what-if” scenario modelling, thus hampering the organisation’s agility. 

Our client needed to shorten the planning process and automate inherent data flows. Simple reconciliation of intercompany transactions and data consolidation were also high on a priority list. Two consolidations, financial and management consolidation,  were planned to be automized. 

Qubix was engaged to design and deliver the project. Based on current state analysis and project requirements we proposed Oracle EPM Suite as the Planning, Budgeting and Reporting technology. We also recommended that the Close Manager module be used to introduce more automation and governance into the close process.

We used our “Journey to Cloud” Methodology, which is specifically designed to improve the outcomes from Cloud Projects. This best practice approach combines our deep industry and technical expertise to design, implement and manage the project. It features accelerators such as:

  • Needs Analysis Bot to collect and organise business requirements,
  • Templated plans and checklists,
  • Cloud Project Management tool that all project members can work on simultaneously.

The project fast-tracked the main functional area and data load, which meant system show and tells could occur very early in the cycle. This allowed our client to gain familiarity with the technology and allowed better compromises to be made when looking at the functionality/complexity balance.  Defects were isolated early allowing rectification in the initial build, improving the final testing cycles. 

Separate Cubes were established for Finance, Costs and Sales, thus providing a great deal of flexibility in analysing data in these areas, while also allowing coherent reporting over the entire data set. 

The client can now accomplish all major planning activities in the system, with no linked spreadsheets used.

Challenges

  • Replacement of a broad range of spreadsheets in the planning process.
  • Streamlining and speeding up the process of data consolidation.
  • Incorporation of standard processes across the group.
  • Need for easy access and analysis of the data.
  • Building a modular and scalable system.
  • Standardisation of reporting and automation of report generation across the group.
  • Improving efficiency while also incorporating increased governance in the crucial process stages.
  • Improved data management and data quality integrated into the systems from the outset.

Solution

  • Oracle EPM Suite was implemented as the Planning, Budgeting and Reporting solution.
  • Separate Cubes were established for Finance, Costs and Sales.
  • Qubix Cloudbridge was installed as a central hub for data integration and master data management.
  • Qubix “Journey to Cloud” Methodology was used to ensure the best outcome of this Cloud Project.
  • Sales (volume and prices) and Cost Planning for the Automotive industry.
  • Aftersales Planning by category (General repair, Body and Paint).
  • Balance Sheet and Profit&Loss Planning (Consolidation).
  • Multiple versions of the Forecast Planning.

Results

  • Eliminated reliance on spreadsheets and sending data around the business.
  • Considerably increased process stages efficiency with extra time available for data analysis.
  • All stakeholders have access to reporting with Smart View, which is used extensively to track the accuracy of forecasts.
  • Accurate modelling and predictions of product mix change, warranties, automotive market trends and other factors impact on Sales and Aftersales outcome.
  • The financial result of driver-based planning can be checked in seconds. 
  • Fast and transparent intercompany reconciliations.
  • A simple update of base values and examination of the change effect on the consolidated result.

Share

Why did the client choose Qubix?

" It was crucial for us to understand the impact of shifts in demand, the introduction of new operations into the region, and various other trends like the secular shift to electric vehicles on their operations. From the first meeting on, the Qubix team understood our challenges and offered the most comprehensive solutions. "

 Related case studies

How we create client success

Hero Image - AIB Lab 2 SEO
Finance Transformation

Moves to cloud planning for greater efficiency and insight

Allied Irish Bank (AIB) eliminates its reliance on large, complex and error-prone spreadsheets and Excel models for a connected, standardized cloud planning platform across business units.

Read case study
HS Featured Image - Hyde Housing
Finance Transformation

Streamlines their planning and budgeting processes in the cloud

London's largest housing association partners with Qubix to migrate their on-premises planning and budgeting application to Oracle EPM Planning Cloud in only 3 weeks for new efficiency, scale and insight.

Read case study
Case Study Page - Ocado SEO
Finance Transformation

Adopts planning and budgeting in the cloud to scale for hyper-growth

Ocado adopted integrated planning, budgeting and forecasting solution covering finance, supply chain, and HR to support new business growth.

Read case study

Get in touch with Qubix

Please share some details with us, and we'll get in touch as soon as we can.

Contact Us