- 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
Online
₹ 449 3,199
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
certificate availability
certificate providing authority
The syllabus
Introduction
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
- Financial Model for a Retailer
- E-commerce business model - intro
- E-commerce business model - Excel example
- More on e-commerce
- More on marketplaces
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
- Overview of segmentation methods
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
- Measuring the capacity of Central Warehouse – Tips
- Measuring the capacity of Central Warehouse – Capacity in Excel
- Measuring the capacity of Central Warehouse – Cost in Excel
- Convenience stores - Analysis of tariffs – Introduction
- Convenience stores - Analysis of tariffs – Tips how to do it
- Convenience stores - Analysis of tariffs – Solution
- DIY - internal logistics optimization – Introduction
- DIY - internal logistics optimization – Solution
- DIY - internal logistics optimization – Solution in Excel
In-store engagement and productivity analysis
- Introduction to in-store engagement
- KPIs that you should follow - Retailnext
- Examples of engagement analyses that you can make - Part 1
- Examples of engagement analyses that you can make - Part 2
- Examples of engagement analyses that you can make - Part 3
- Examples of engagement analyses that you can make - Part 4
- Main rules according to which people behave
Additional Resources worth checking
- How to scale up a business – best practices from top firms
Conclusions
- Bonus Lecture
Instructors
Mr Asen Gyczew
Instructor
Freelancer