Qlik > Case Studies > Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView

Procurement Lincolnshire Saves £3 million in First Year with £24 million forecast over five years using QlikView

Customer Company Size

Large Corporate

Region

Europe

Country

United Kingdom

Product

QlikView

Tech Stack

SQL Server
MS Access
MS Excel

Implementation Scale

Enterprise-wide Deployment

Impact Metrics

Cost Savings
Productivity Improvements

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Functions

Procurement

Use Cases

Supply Chain Visibility

Services

Data Science Services

About The Customer

Procurement Lincolnshire in the United Kingdom is a shared service partnership between eight local authorities which together spend more than £600 million a year on purchasing of goods and services. The service is formally hosted by the largest authority Lincolnshire County Council on behalf of the other member partners. The other members are Boston Borough Council, City of Lincoln Council, East Lindsey District Council, North Kesteven District Council, South Holland District Council, South Kesteven District Council, and West Lindsey District Council. In the current climate of fiscal restraint in the UK, the partnership wanted to respond to the need for efficiency savings by analysing its expenditure in more detail than ever before.

The Challenge

Procurement Lincolnshire, a shared service partnership between eight local authorities in the East Midlands, wanted to respond to the need for efficiency savings by analysing its expenditure in more detail than ever before. They decided to improve its visibility over procurement activity with a new software platform to help meet the budget reduction targets posed by the government Comprehensive Spending Review in 2010. The procurement activities under scrutiny already cover around 30 categories. They range from reviews of high spending services, such as adult social care and children services, to outlays on photocopiers, pest control, and even dog kennelling. The challenge was finding a user friendly dashboard solution to access customised data mining reports for a more holistic view of the organisation spend.

The Solution

Procurement Lincolnshire chose QlikView as the dashboard solution for their custom-built spend analysis platform. QlikView provides users with an extremely simple but powerful means to analyse data and identify value from it. QlikView also delivers multiple benefits with its patented in-memory associative technology. The versatility and flexibility of QlikView is giving users immediate reports that previously would have been produced on an ad hoc basis by IT staff. With a single click of the mouse, it is possible to drill through to a particular category of spend and view the suppliers for that category, total spend, spend Pareto (a measure of efficiency), and supplier location.

Operational Impact

The versatility and flexibility of QlikView is giving users immediate reports that previously would have been produced on an ad hoc basis by IT staff.
With a single click of the mouse, it is possible to drill through to a particular category of spend and view the suppliers for that category, total spend, spend Pareto (a measure of efficiency), and supplier location.
The selection and de-selection of data takes seconds and has reduced the time for analysis from half a day to half an hour.
The new system has also saved Procurement Lincolnshire around £30,000 a year in reducing operating costs for reports and analysis, which means the partnership, is getting significantly more business value for less investment.

Quantitative Benefit

First year savings of £3 million
Estimated forecast savings from the project over the next five years amounts to more than £24 million.
Saved around £30,000 a year in reducing operating costs for reports and analysis