Introduction
- Introduction
- About me
- Main Topics in retail you have to know
- Structure of the course
- What to do if a blurry image appears
- How to find additional resources
Modeling Retail Business in Excel
- Introduction to retailer business model
- Main challenges in Retail
- Business model of Retail - main drivers
- Business model of Retailer in Excel - transaction version - 1 store
- Business model of Retailer in Excel - transaction version - retail chain
- Business model of Retailer in Excel - sq m version
- E-commerce business model - intro
- E-commerce business model - Excel example
Basic analyses that you should perform
- Basic analyses - Introduction
- Issue tree - introduction
- Issue tree example for a retailer
- Analyses of stores by cohorts - Introduction
- Analyses of stores by cohorts - Example
- Product range analysis - Introduction
- Product range analysis - Example
- Sales and margin efficiency of retail
- Inventory analysis - Introduction
- Inventory analysis - Excel
- Store checks - examples in retail
- Store checks - examples in restaurants
- How to use store checks to check a specific location?
Optimization of in-store processes – case study
- Optimization of in-store processes - Introduction
- Workshop - Introduction
- Workshop – the scope of the project
- Workshop – Tools overview
- Lean manufacturing - introduction
- Theory of constraints - introduction
- Queuing problem - introduction
- OEE - introduction
- Workshop – defining metrics and cost drivers
- Workshop – optimizing 1 process
- Workshop – optimizing 1 process - Excel file
- Workshop – timeline of the project
- Introduction to in-store process optimization case
- The store and the processes
- Price Change
- Price Change - calculation in Excel
- Shelf replenishment
- Shelf replenishment - calculation in Excel
- Advising customers - Introduction
- Advising customers - General solution
- Advising customers - Details and results
- Advising customers - calculation in Excel
- Cash till and info point
- Other potential improvements
- Process cost estimation by groups
- Summary of all costs and savings
Business Hacks used by Retailers
- IKEA - low cost retailer
- Biedronka - low cost retailer
- Showroom - leveraging via strategic partner
- Zappos - leveraging via strategic partner
- Cinema City - selling the unsued
Expansion strategy
- Introduction to Expansion
- Expansion of current model - options
- Saturating existing markets - intro
- Saturating existing markets – Introduction
- Saturating existing markets – Data for the case study
- Saturating existing markets – Number of Stores
- Saturating existing markets – Stores by concepts
- Saturating existing markets – Concept & Space
- Saturating existing markets – Solution in Power Point
- Saturating existing markets – WaterFall Graph
- Expansion strategy into other countries - introduction
- Expansion strategy into other countries – Case Introduction
- Expansion strategy into other countries – Data for the case study
- Expansion strategy into other countries – Which function to use
- Expansion strategy into other countries – Solution in Excel
- Expansion strategy into other countries – Solution in Power Point
Multichannel
- What is multichannel?
- Main problems with multichannels
- Pricing dilemma - case study - Problem
- Pricing dilemma - case study - Solution
- Cannibalization of sales by off-line - Introduction
- Cannibalization of sales by on-line – Introduction
- Cannibalization of sales - case study
- Canibalization - tips how to solve the case study
- Cannibalization of sales - case study - Calculation in Excel
Supply Chain in Retail
- Introduction to Retail Supply Chain
- Overview of Supply Chain in Retail
- Main challenges in Supply Chain in Retail
- Introduction to cases for Retail
- Groceries – warehouse optimization – Introduction
- Groceries – warehouse optimization – Current Cost estimation
- Groceries – warehouse optimization – Potential improvements
- Groceries – warehouse optimization – Estimation of savings in Excel
- Measuring the capacity of Central Warehouse – Introduction
