Qlik Case Studies Greencore Boosts Incremental Sales by £300,000 in Three Months with QlikView

Edit This Case Study Record

	Greencore Boosts Incremental Sales by £300,000 in Three Months with QlikView Qlik

Greencore Boosts Incremental Sales by £300,000 in Three Months with QlikView

Qlik

Technology Category	Analytics & Modeling - Real Time Analytics
Applicable Industries	Consumer Goods
Applicable Functions	Sales & Marketing
Use Cases	Inventory Management Supply Chain Visibility
Services	Data Science Services
Challenge	Greencore Northampton, part of the Greencore Group, was facing challenges in analyzing electronic point of sale (EPOS) data. The company was using Microsoft Excel reports to monitor sales performance, which involved complex pivot tables and took hours of work to produce. As a result, they were often slow to react if a particular product wasn’t selling well in a particular store. They had no real-time information on which were the best-selling lines, so stores in some areas ran out of stock and in others they had to throw away food. The aim was to reduce waste and improve the availability of sandwiches and wraps at M&S stores in the UK. Read More
About Customer	Greencore Northampton is part of Greencore Group—the largest maker of ready-to-go foods in the United Kingdom (UK). Greencore Group has 22 convenience food manufacturing sites in the UK and US, employing more than 11,000 people. Greencore Group is a leading international producer of prepared foods based in Dublin, Ireland. Greencore’s global annualised sales, including its US operations, amount to more than US$1.3 billion a year. In 2011, Greencore acquired convenience food supplier Uniq Prepared Foods. Uniq derived more than half its revenue from supplying leading retailer Marks & Spencer (M&S), with the Northampton site being lead supplier for sandwiches and wraps. Read More
Solution	Greencore Northampton deployed QlikView for its commercial and supply chain teams to monitor availability and wastage of food-on-the-move products at M&S stores in the UK. The initial project supported the commercial team with the replication of the existing Excel weekly reports and analysis completed on this data. Once the power of QlikView was outlined, the second stage involved moving the performance management of a relatively small segment of the category—wraps. Greencore Northampton’s finance team has just gone live with an analysis and reporting dashboard using QlikView. Integration of sales and financial dashboards will enable the commercial team to incorporate financial data into its sales performance figures, and help the finance team analyse profitability more effectively. Read More Log in to view content
Contents

Technology Category

Analytics & Modeling - Real Time Analytics

Applicable Industries

Consumer Goods

Applicable Functions

Sales & Marketing

Use Cases

Inventory Management

Supply Chain Visibility

Services

Data Science Services

Challenge

Greencore Northampton, part of the Greencore Group, was facing challenges in analyzing electronic point of sale (EPOS) data. The company was using Microsoft Excel reports to monitor sales performance, which involved complex pivot tables and took hours of work to produce. As a result, they were often slow to react if a particular product wasn’t selling well in a particular store. They had no real-time information on which were the best-selling lines, so stores in some areas ran out of stock and in others they had to throw away food. The aim was to reduce waste and improve the availability of sandwiches and wraps at M&S stores in the UK.

About Customer

Greencore Northampton is part of Greencore Group—the largest maker of ready-to-go foods in the United Kingdom (UK). Greencore Group has 22 convenience food manufacturing sites in the UK and US, employing more than 11,000 people. Greencore Group is a leading international producer of prepared foods based in Dublin, Ireland. Greencore’s global annualised sales, including its US operations, amount to more than US$1.3 billion a year. In 2011, Greencore acquired convenience food supplier Uniq Prepared Foods. Uniq derived more than half its revenue from supplying leading retailer Marks & Spencer (M&S), with the Northampton site being lead supplier for sandwiches and wraps.

Solution

Greencore Northampton deployed QlikView for its commercial and supply chain teams to monitor availability and wastage of food-on-the-move products at M&S stores in the UK. The initial project supported the commercial team with the replication of the existing Excel weekly reports and analysis completed on this data. Once the power of QlikView was outlined, the second stage involved moving the performance management of a relatively small segment of the category—wraps. Greencore Northampton’s finance team has just gone live with an analysis and reporting dashboard using QlikView. Integration of sales and financial dashboards will enable the commercial team to incorporate financial data into its sales performance figures, and help the finance team analyse profitability more effectively.

Impact #1	Improved reporting of daily and weekly data
Impact #2	Enabled faster, smarter decision making
Impact #3	Boosted sales revenue with availability of wraps in stores

Impact #1

Improved reporting of daily and weekly data

Impact #2

Enabled faster, smarter decision making

Impact #3

Boosted sales revenue with availability of wraps in stores

Benefit #1	On-shelf availability up by 20 per cent
Benefit #2	Incremental sales of £300,000 for M&S
Benefit #3	Waste reduction of 3 per cent

Benefit #1

On-shelf availability up by 20 per cent

Benefit #2

Incremental sales of £300,000 for M&S

Benefit #3

Waste reduction of 3 per cent

Download PDF Version

Overview

Greencore Boosts Incremental Sales by £300,000 in Three Months with QlikView

Operational Impact

Quantitative Benefit