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:
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.
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
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
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
Ocado adopted integrated planning, budgeting and forecasting solution covering finance, supply chain, and HR to support new business growth.Read case study