a
Case Study Food Manufacturing SAP Planning Financial Consolidation

Decision Inc. UK Rebuilds
Poorly Configured SAP Consolidation Solution

Client
Greencore Group plc
Industry
Food Manufacturing
Location
United Kingdom and Scotland
Solution
Group Reporting and Financial Consolidation with SAP Planning

The Requirement

The group wanted to optimize the use of their SAP Planning for consolidation and financial reporting. Thus making the strategic decision to re-build the solution.

The Solution

A robust and performant financial reporting solution utilising SAP standard functionality, taking full advantage of the technology platform.

The Impact

The combination of a recognised consolidation technology platform (SAP Planning) and specialist SAP Planning partner, Decision Inc., resulted in a heavily improved solution in-line with best practices & robust governance standards.

01 · Client Overview

About Greencore

Greencore Group plc. is a leading manufacturer of convenience foods.

Greencore supplies a wide range of chilled, frozen, and ambient foods to some of the most successful retail and food service customers in the UK. Greencore is headquartered in Dublin and is listed on the London Stock Exchange. Their total revenues exceed £1.3billion. Greencore is an employer of 13,000 people.

Greencore
02 · The Requirement

The Requirement

To optimise the use of SAP Planning for consolidation & financial reporting, the group made a strategic decision to re-build the solution.

The key deliverables were identified as:

  • Optimised Consolidation and Translation calculations with native Planning functions
  • Simplify and better automate data integration from source systems
  • Streamlined business processes, utilising improved Input Forms with supporting calculations and informative In-Process Reports
  • Re-designed budget and forecast process and templates to reduce the risk of data loss
  • Reconfigured key dimensions, Flow, and Audit Trail and rationalised Scope and Currency
  • A new Intercompany Matching Process
  • Timely, easy to execute housekeeping tasks to optimise system performance without impacting system access and availability
  • Re-development of Formal Reports and Report Packs

"The Decision Inc. Project Team have excellent knowledge of the SAP Planning product and this experience was invaluable in terms of understanding and diagnosing the issues we faced along with gaining knowledge of our business processes and then proposing how to remedy these problems to deliver a workable solution fit for purpose. The project team were very flexible and adapted well to work with Greencore IT project team. This collaboration helped to deliver a successful project that has been received by the business users extremely well."

Rachel BondFinance Business Improvement Manager, Greencore plc
03 · The Solution

A Solution Built to Perform

A robust and performant financial reporting solution utilising SAP standard functionality, taking full advantage of the technology platform.

Tasks and processes can be executed in a timely fashion and users now have a high degree of trust in the system and the data.

The solution delivered the following benefits:

  • Optimisation of data-tables as required without taking the system offline
  • Reduced IT effort required to support the system
  • Reduced system down-time
  • Reduced time and effort in the production of month-end and year-end results. (Please refer to improved performance indicators below)
  • Improved user experience through direct use of system front-end and training
  • Reduced reliance on manual controls
  • Minimised housekeeping activities for business users
  • Aligned the system configuration to match Greencore's data requirements and utilise standard system functionality
04 · The Result

Measurable Performance Gains

The combination of a recognised consolidation technology platform (SAP Planning) and specialist SAP Planning partner, Decision Inc., resulted in a heavily improved solution in-line with best practices & robust governance standards.

Data Loading
Loads in 30 seconds as opposed to 5-6 minutes per site
Report Pack for Yearend Stats
Runs in 30 seconds as opposed to 15 minutes
Consolidation Calculation
Runs in 2 minutes as opposed to 10 – 15 minutes
System Down-Time & Database Compression
Optimises now run in 5 minutes as opposed to 35 – 40 minutes
Input Forms Selections
Runs in less than 5 seconds as opposed to 5 minutes
Consolidation of Plan X12 Periods
Runs in 2 – 10 minutes as opposed to 60 – 120 minutes
Budget Calculations X12 Periods
Runs in less than 30 seconds as opposed to 10 – 20 minutes

Elimination of system down-time – Database can now be compressed without taking the system off-line, due to the use of standard system calculations. Reduction in frequency of database compression, due to use of standard system calculations. Instances of system down-time are exceptional rather than routine.

"Overall, I would say that the user experience has massively improved with the performance changes especially the refresh rate on reports and Input schedules used by the wider finance team."

Paul BrennanGroup Consolidation Manager at Greencore plc

"Decision Inc. used their knowledge of the Greencore business and the legacy SAP Planning configuration to deliver a vastly improved Consolidation system and delivered improvements across a variety of areas:

Control: locking periods and data was not possible in the legacy system; this now works efficiently and includes auditability which supports our financial reporting processes.

Validation: with the new configuration the system is automatically validating data coming from the ERP's to ensure completeness and accuracy of mappings. This reduces the workload at period end. Users are guided, based on the error as to what the corrective actions are. This benefit allows business users to resolve issues with minimal input at Group Finance level.

Reporting: legacy reports have been written using smarter techniques which allow the business to analyse the reporting more efficiently.

Single Set-Up: Decision Inc. worked to reduce the administration of the system by leveraging SAP logic and standardising configuration such that we have a single set of rules for our Cashflow which can be followed more easily than the legacy system."

Paul Brennan
Paul Brennan
Group Consolidation Manager, Greencore plc