Case Studies

Company

Contact Us

If you need more information on any of our products or would like to arrange a consultation, please feel free to email or call us and we will endeavour to respond to you as quickly as possible.

info@codec.ie

+353 (0)1 603 4300

UK Local Government Agency

Case Study

Local government agency serving a population of just under 1.4 million, which makes it one of the largest local authorities in England.

Company: UK-based local government agency
Industry: Local Government
Country: UK
Employees: 1,000+

Solution Featured

The Challenge

The UK-based local government agency had an urgent need to map their daily forecasts of actuals and forecasts (extending to up to 2 years into the future) onto their new Finance Transformation program. Essentially quite apart from creating and processing data they needed to be able to store it conveniently and access it promptly and efficiently.

The financials needed to take into account staff planning and costing, all project forecasting (from digging up roads to building new playgrounds), a waste module (to determine costs associated with a new bin route for example) and a care module (costs associated with looking after OAPs). The varying demands and complexities of their financial planning requirements had caused some miscommunication between departments, a disjointed data sharing processes and staff to do unnecessary manual updating of reports.

Background

As a non-metropolitan county council, responsibilities are shared between districts (including boroughs), and in many areas also between civil parish (including town) councils, so planning and reporting would have to take into account the disparate nature of the stakeholders, and pay particular attention to accessibility and permissions.

Births, marriages/civil partnerships and death registration, roads, libraries and archives, refuse disposal, most of state education, of social services and of transport are provided at the county level meaning that vast amounts of data would need to be processed and interpreted for EPM deployment.

The Solution

Codec’s deployment of Oracle’s EPM solution tidied up all these data requirements so that the process became more streamlined and completely automated. The data from various sources within the local government agency including the general ledgers, HR, refuse management, care systems and other projects was transferred to the newly-built and enhanced forecasting system, which then relayed financial actuals to pre-determined segmented locations such as “Projects” or “Ledger” or whatever was the appropriate category. The information was then passed to a data warehouse where it was repackaged and repurposed for individual dashboards or variant analysis.

The Results

As a result of the newly compartmentalized data streams every individual stakeholder need only access the EPM solution to get the specific information s/he needs in an instant. No more lengthy email trails or updating new versions of historic reports manually, massive time-saving and a whole new era in efficiency all signify investment in EPM paid off in a big way for this particular local government agency.