Back to search

University of Kent,

Optimising supermarket promotions of fast moving consumer goods using disaggregated sales data: A case study of Tesco and their small and medium sized suppliers

Abstract

dc:description.abstract

The use of price promotions for fast moving consumer goods (FMCG’s) by supermarkets has increased substantially over the last decade, with significant implications for all stakeholders (suppliers, service providers & retailers) in terms of profitability and waste. The overall impact of price promotions depends on the complex interplay of demand and supply side factors, which has received limited attention in the academic literature. There is anecdotal evidence that in many cases, and particularly for products supplied by small and medium sized enterprises (SMEs), price promotions are implemented with limited understanding of these factors, resulting in missed opportunities for sales and the generation of avoidable promotional waste. This is particularly dangerous for SMEs who are often operating with tight margins and limited resources. A better understanding of consumer demand, through the use of disaggregated sales data (by shopper segment and store type) can facilitate more accurate forecasting of promotional uplifts and more effective allocation of stock, to maximise promotional sales and minimise promotional waste. However, there is little evidence that disaggregated data is widely or routinely used by supermarkets or their suppliers, particularly for those products supplied by SMEs. Moreover, the bulk of the published research regarding the impact of price promotions is either focussed on modelling consumer response, using claimed behaviour or highly aggregated scanner data or replenishment processes (frameworks and models) that bear little resemblance to the way in which the majority of food SMEs operate. This thesis explores the scope for improving the planning and execution of supermarket promotions, in the specific context of products supplied by SME, through the use of dis-aggregated sales data to forecast promotional sales and allocate promotional stock. An innovative case study methodology is used combining qualitative research to explore the promotional processes used by SMEs supplying the UK’s largest supermarket, Tesco, and simulation modelling, using supermarket loyalty card data and store level sales data, to estimate short term promotional impacts under different scenarios and derive optimize stock allocations using mixed integer linear programming (MILP). ii The results suggest that promotions are often designed, planned and executed with little formalised analysis or use of dis-aggregated sales data and with limited consideration of the interplay between supply and demand. The simulation modelling and MILP demonstrate the benefits of using supermarket loyalty card data and store level sales data to forecast demand and allocate stocks, through higher promotional uplifts and reduced levels of promotional waste

Degree

thesis:*
Name dc:type.qualificationname
phd
Level dc:type.qualificationlevel
doctoral
Grantor dc:publisher.institution
University of Kent,
Year dc:date.issued
2015

Author and committee

dc:creator, dc:contributor.*
Author dc:creator
  • Malik, Sheraz Alam
Advisors dc:contributor.advisor
  • Fearne, Andrew
  • O'Hanley, Jesse
  • Wu, Shaomin

Subjects

dc:subject × 2

Rights

Language dc:language
en

Chain of custody

source
Harvested from
University of Kent
Base URL
kar.kent.ac.uk/cgi/oai2
Last updated
2026-11-19
Source record
OAI-PMH GetRecord
citation

Malik, Sheraz Alam. Optimising supermarket promotions of fast moving consumer goods using disaggregated sales data: A case study of Tesco and their small and medium sized suppliers. doctoral thesis, University of Kent,, 2015.