Teppei Syokudo - Improving Store Performance

From Analytics Practicum
Revision as of 22:29, 17 April 2016 by Jessie.yap.2012 (talk | contribs)
Jump to navigation Jump to search


Home   Product Portfolio Analysis   Improving Store Performance   Project Management   Documentation   The Team

Current Progress

Undergraduate Conference for Data Analytics Paper 1 - Product Portfolio Management in F&B using Market Basket Analysis

Undergraduate Conference for Data Analytics Paper 2 - Improving Shop Productivity in F&B store using Regression Models

Final Paper 1 - Product Portfolio Management in F&B using Market Basket Analysis Submitted

Final Paper 2 - Evaluating and Establishing KPIs and Staff Performance in F&B store Submitted

Project Poster 1 - Product Portfolio Management in F&B using Market Basket Analysis Submitted

Project Poster 2 - Improving Shop Productivity in F&B store using Regression Models Submitted

Interim Report Submitted

Interim Wiki Updated

Teppei Syokudo is a Japanese Food and Beverage chain, under the umbrella of the famous Teppei Japanese Restaurant. Teppei Syokudo operates as a takeaway kiosk concept, and specializes in Kaisendon, a bowl of barachirashidon (rice with raw fish), that retails for SG$16. It offers other dons (rice bowls), tonkatsu cutlets (fried pork), tempura (fried dishes) and sashimi salads.

The takeaway kiosk mainly targets lunchtime crowds, especially upmarket businessmen and women who are looking to grab a quick, healthy, and quality lunch.

Teppei Syokudo currently has outlets in 4 locations - Millenia Walk, Takashimaya, Republic Plaza, and Ion Orchard.

Each outlet has its own shop manager, one full-time staff, some part-time staff, and chef. The staff include cashiering and assistant roles. During peak hours, the outlets may have up to 7 staff to manage demand.

Project Motivation

Most F&B businesses measure their overall performance through number of customers, sales and profits. Since opening almost a year ago, Teppei Syokudo has accumulated sales data and is looking at Key Performance Indicators (KPIs) such as

  • number of customers
  • average customer spend

However, these may be easily affected by external factors such as time period, location, and weather.

In order to drive store performance through controllable factors, Teppei Syokudo is looking at focusing on staff performance. Most F&B businesses, including Teppei Syokudo, do not set detailed KPIs to evaluate how their staff are performing. If Teppei Syokudo is able to track the performance of their staff through relevant KPIs, they will be able to motivate staff to meet these KPIs, which will in turn boost the business’ bottom line. Teppei Syokudo has identified the following KPIs to assess their staff:

  • Percentage of drinks sales (number of drinks sold / number of meals sold)
    • a measurement of how hard the staff are up-selling
  • Labour Productivity (sales $ / working hours)
    • a measurement of how effective the shop manager is in staffing the shop

However, the business is uncertain if these are the right KPIs to set.

Another factor for driving store performance is through product portfolio mix. Even though the staff may be upselling and cross-selling, they may not know the right products to cross-sell to increase the probability of the customer making additional purchases. For example, most customers may tend to purchase Drink X together with Don X. In this case, if a customer orders Don X and is about to make payment, the staff can suggest Drink X to the customer, hence prompting a higher probability for the customer to purchase Drink X.


Project Objectives

The aim of our project is to help Teppei Syokudo improve store performance through controllable factors such as staff performance and product portfolio mix.

Our project objectives are hence:

  1. To evaluate the effectiveness of existing KPIs, so as to ensure that they are the right KPIs
  2. To develop new KPIs, so as to have the right set of KPIs that would be relevant for evaluating both shop and staff performance
  3. To identify customer purchase trends so as to come up with a recommendation system that staff can use to cross-sell and upsell