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

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

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
The 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 The 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.
The 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.
Operational Impact
  • Improved reporting of daily and weekly data
  • Enabled faster, smarter decision making
  • Boosted sales revenue with availability of wraps in stores
Quantitative Benefit
  • On-shelf availability up by 20 per cent
  • Incremental sales of £300,000 for M&S
  • Waste reduction of 3 per cent

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.