Sales analysis toolkit

Client Overview

Catermasters is one of the UK’s leading suppliers of catering services for the workplace, providing in-house catering to businesses across the UK. They required a till-capture system to replace their current Excel-based spreadsheet.

Requirements

Catermasters required a customised back-office system which would centralise sales data from on-site tills and produce reports measuring success indicators such as key buying trends, product sales and site profitability.

Issues

Catermasters were unable to extract the business data they required to measure company performance from existing Excel spreadsheets, and till data could only be analysed by a technical advisor.

Solution

MDB created a bespoke system to allow Catermasters to produce powerful business critical reports quickly and effectively as well as the ability to monitor each catering sites' performance as a whole, and in comparison to one another. 

The system gathered information from Catermasters canteens and restaurants across the UK, and translated it into valuable information on which Catermasters could highlight key areas for improvement.

Benefits

The system enabled Catermasters to improve customer service, highlight training requirements and effectively measure sales performance in its restaurants and canteens across the country. By accessing the system's reports Catermasters could analyse:
 

  • Sales trends
  • Success of promotions
  • Sales comparison across multiple sites
  • Product popularity across multiple sites and across time periods (e.g. number of coffees bought between 9am and 11.30am)
  • Performance comparison year to year
  • Most and least profitable products
  • Staff till usage (e.g. which staff members input products in the wrong category - highlighting training required)

The technology used by MDB to design the back office system was a .NET database with a SQL back-end using the latest releases from Microsoft.

http://www.catermasters.co.uk/

Skyron Ltd T/A MDB Consulting
The Bradshaw Suite, Paragon Business Park  Chorley New Road  Horwich  Bolton  UK  BL6 6HG
Registered Company No. 4856217 telephone: 01204 696506  email: mbell@mdbconsulting.co.uk

Powered by Kentico CMS for ASP.NET | A Skyron Solution