Download PDF
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
Quantitative Benefit
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.
