LogoAlan Craig Data Science Portfolio Architecture

Intelligent Counting and Retail Waste units and optimisation: Marks and Spencers 2016

python logo

Developed analysis as part of the wider Intelligent Counting Projecto being conducted by the M&S Retail team .Identification of products within at store level where the product has been counted more within a 28 day period. The average Waste (units) and (£GBP) is then calculated between these count points for each of the 4 inaccuracy categories: Understated, Overstated, Critical, and Accurate. Identify opportunities the average waste (unit an GBP) for products that have counted more than once within a 28 day limit in order to explore the relationship between waste and inaccuracy.

To review all current store counting and identify how a more system lead approach can be used to identify and mitigate inaccuracy on at an individual store product bases
Measure of success
1.Sales – if overstated (potential lost sales) accuracy improves we would see sales increase. Understated, physically have more stock (waste). 2.Availability – if critical accuracy improves we would see availability increase 3.Waste – if understated accuracy improves we would see waste decrease 4.Total Count volumes reduces because the counts completed are more targeted 5.Count volume split by accurate, overstated, understated, critical – if counting is more targeted then accurate counts will reduce and overstated, understated and critical will increase 6.If counting is more targeted then there is less wasted effort for stores
In Scope
All counting in stores

View all the document and analysis on this project:


Lets get in touch and talk about your next project.