Course Highlights
  • Make better decisions on the basis of data
  • Analyze fast problems in your private life and business
  • Master management consulting tools, techniques and frameworks
  • Apply the right elements from your management consulting toolbox
  • Find fast potential improvements your life and achieve your goals
  • Calculate in Excel the impact of your decision on your life
Curriculum

6 Topics
A little bit about me
How this course will be organized?
How to deal with Blurry image
How to reach additional resources
How to find information and ask questions
Why we have decided to create this course

38 Topics
Basic tools - Introduction
Bottom-up approach
What you can use the bottom-up approach
Estimating the costs of a wedding - case introduction
Estimating the costs of a wedding - partial solution
Estimating the costs of a wedding - Excel Part 1
Estimating the costs of a wedding - Excel Part 2
Top-down approach
Average salaries in other department – Case Introduction
Average salaries in other department – Solution
Average salaries in other department – Excel Basic
Average salaries in other department – Excel Go Seek function
Top-down approach used in Business
Chicken Producer - Top-down approach - Introduction
Chicken Producer - Top-down approach - Tips how to do it
Chicken Producer - Top-down approach - Solution
Backward logic
When can I retire - introduction
When can I retire – No passive income – Excel Basic
When can I retire – No passive income – Go seek function
When can I retire – With passive income
Backward logic based decisions – Case Introduction
Backward logic based decisions – Solution
Backward logic based decisions – When it makes sense to use it
Compounded effect
Reading skills – Introduction
Reading skills – End year
Reading skills – By weeks result
Issue tree - introduction
Issue tree – Overview of case studies
Issue tree – Logistics
Issue tree - Retail
Issue tree example for a FMCG firm
Issue tree for John's flat – Introduction
Issue tree for John's flat – Solution
Priorities
Benchmarks – external and internal
80/20 rule in practice

32 Topics
Low hanging fruits
Low hanging fruits used in Business
Quick wins for cost reduction
Quick wins for cost reduction – Remarks on Pontetial Savings
Quick wins in Drugstore – Case Introduction
Quick wins in Drugstore – Cost Structure
Quick wins in Drugstore – Cost Reduction
Quick wins in Drugstore – Summary
Set SMART goals
KPIs and business drivers – Introduction
KPIs for cinema – case to be solved
KPIs for cinema – solution
KPIs for cinema – Excel
KPIs for cinema – Power Point
KPIs for marketplace – Problem
KPIs for marketplace – Solution
KPIs for marketplace – Alternative Solution
KPIs for SaaS – Problem
Examples of SaaS businesses
KPIs for SaaS – Solution
Personal KPIs – Introduction
Personal KPIs – Solution Part 1
Personal KPIs – Solution Part 2
Opportunity Tree
Cost drivers
Total cost of ownership
Rent or buy a house – Introduction
Rent or buy a house – Rentig cost
Rent or buy a house – The loan
Rent or buy a house – Buying the apartment
Rent or buy a house – Comparison
Basic tools – Summary

9 Topics
Make it or buy it – Introduction
Delegating some work to others – Case Introduction
Delegating some work to others – Analysis of activities
Delegating some work to others – Summary
Make-or-buy courses - case introduction
Make-or-buy course - Make option
Make-or-buy course - Buy option
Make-or-buy course - Comparison
Make it or buy it – When to make even if it is more expensive

43 Topics
Introduction
Rankings Introduction
Rankings – Case studies
How to expand the brand – Introduction
How to expand the brand – Solution – Part 1
How to expand the brand – Solution – Part 2
Rankings used to select the potential targets for M&A
Milk Producer – Selecting Targets – Case Introduction
Milk Producer – Selecting Targets – Available Data
Milk Producer – Selecting Targets – Ranking Creation
Milk Producer – Selecting Targets – Ranking Analysis
Milk Producer – Selecting Targets – Threshold Analysis
Milk Producer – Selecting Targets – Threshold Analysis – Comments
Rankings – Other examples
Scenario analysis – Introduction
Scenario analysis – Case Studies
Car vs Uber – Introduction
Car vs Uber – Cost of own car basic
Car vs Uber – Uber
Car vs Uber – Comparison of costs
How to motivate not yours sales reps – Case Introduction
How to motivate not yours sales reps – Trainings
How to motivate not yours sales reps – Contests
How to motivate not yours sales reps – Incentive trips
How to motivate not yours sales reps – Loyalty program
How to motivate not yours sales reps – Summary and Comparison in Excel
How to motivate not yours sales reps – Solution in Power Point
How much is MBA worth – Introduction
How much is MBA worth – the Loan
How much is MBA worth – Pessimistic scenario
How much is MBA worth – Optimistic & Realistic
How much is MBA worth – Comparison
Scenario Analysis – Other Examples
Representative element analysis – Introduction
How long will it take to prepare the presentation – Introduction
How long will it take to prepare the presentation – Time needed
How long will it take to prepare the presentation – Deadline
Decision Tree Analysis – Introduction
Decision Tree Analysis – Solution
How big house should I build – Introduction
How big house should I build – Small House
How big house should I build – Big House
How big house should I build – Power Point

18 Topics
OEE and OLE
What happens with Jorge time – Introduction
What happens with Jorge time – Data for the case
What happens with Jorge time – Analysis of data
What happens with Jorge time – OLE & Improvements
Theory of constraints and bottlenecks
Content marketing agency – Introduction
Content marketing agency – Solution
Critical Chain
Decomposition of effects analysis – Introduction
LFL analysis – Introduction
LFL analysis – Solution – Part 1
LFL analysis – Solution – Part 2
LFL analysis – Solution – Power Point
Simulation analysis – Introduction
What will be the effect of the price increase – Introduction
What will be the effect of the price increase – Solution – Impact on coffee only
What will be the effect of the price increase – Solution – Full impact

14 Topics
10 x current solution using first principles – Introduction
10 x current solution using first principles
Reduce water using 10x framework – Case Introduction
Reduce water using 10x framework – Drivers
Reduce water using 10x framework – Current Consumption
Reduce water using 10x framework – Options
Reduce water using 10x framework – Summary
Decrease cost using 10x framework – Case Introduction
Decrease cost using 10x framework – Drivers
Decrease cost using 10x framework – Current Level
Decrease cost using 10x framework – Options
Decrease cost using 10x framework – Summary
What tool should you use?
How to scale up a business using theory of constraints - best practices

  Write a Review

Management Consulting Approach to Problem Solving

Go to Paid Course