Difference between revisions of "Teppei Syokudo - Improving Store Performance"

From Analytics Practicum
Jump to navigation Jump to search
Line 29: Line 29:
 
<div style="margin:20px; padding: 10px; background: #ffffff; text-align:center; font-family: Trebuchet MS, sans-serif; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow:    7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 
<div style="margin:20px; padding: 10px; background: #ffffff; text-align:center; font-family: Trebuchet MS, sans-serif; font-size: 95%;-webkit-border-radius: 15px;-webkit-box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96); -moz-box-shadow:    7px 4px 14px rgba(176, 155, 121, 0.96);box-shadow: 7px 4px 14px rgba(176, 155, 121, 0.96);">
 
<font size =3 face=Georgia >
 
<font size =3 face=Georgia >
<p>Final Paper 1 - [[Media:ANLY482 Product_Portfolio_Management_in_F&B_using_Market_Basket_Analysis.docx ‎|Product Portfolio Management in F&B using Market Basket Analysis]] Submitted</p>
+
<p>Final Paper 1 - [[Media:Product_Portfolio_Management_in_F&B_using_Market_Basket_Analysis.docx ‎|Product Portfolio Management in F&B using Market Basket Analysis]] Submitted</p>
 
<br>
 
<br>
<p>Final Paper 2 - [[Media:ANLY482 Evaluating_and_Establishing_KPIs_and_Staff_Performance_in_F&B_store.docx ‎|Evaluating and Establishing KPIs and Staff Performance in F&B store]] Submitted</p>
+
<p>Final Paper 2 - [[media:Evaluating_and_Establishing_KPIs_and_Staff_Performance_in_F&B_store.docx ‎|Evaluating and Establishing KPIs and Staff Performance in F&B store]] Submitted</p>
 
<br>
 
<br>
 
<p>[[Media:ANLY482 Interim Report APSpoilMarket .pdf ‎|Interim Report]] Submitted</p>
 
<p>[[Media:ANLY482 Interim Report APSpoilMarket .pdf ‎|Interim Report]] Submitted</p>

Revision as of 17:08, 5 April 2016


Home   Product Portfolio Analysis   Evaluating Store KPIs   Project Management   Documentation   The Team

Current Progress

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


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 3 locations - Millenia Walk, Takashimaya, and Republic Plaza. The chain is planning to open another outlet in Ion Orchard soon.

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 5 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. Also, if they are the right ones, they are unsure as to what would be a good target to meet.

Another factor for driving store performance is through product portfolio mix. Even though the staff may be up-selling 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.

To top it off, with changes to staff, menu and seasons, Teppei Syokudo would like to know that this is not a one-off analysis and that this project can be sustainable with the input of new data.



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 staff KPIs, so as to ensure that they are the right KPIs
  2. To develop new staff KPIs, so as to have the right set of KPIs that would be relevant for evaluating both shop and staff performance (ideally separately between shop manager and staff)
  3. To come up with the numerical targets that would motivate staff performance
  4. To identify customer purchase trends so as to come up with a recommendation system that staff can use to cross-sell
  5. To come up with a workable spreadsheet, where analyses can be drawn from the input of new data - a sustainable system to ensure continuity in the project’s usefulness in the long run.