McKinsey & Company interview question

the case is well structured with analytics, conceptual question and quantitative section.