This is an actual case study that was presented to the participants of Microsoft Excel Collegiate Challenge, Round 1 (October 2022).

Case study description:

Cole and Joseph are consultants on EY’s Decision Modeling & Analysis (DMA) team. The DMA team sits within EY’s Strategy and Transactions (SaT) practice and is a provider of rigorous modeling and analytics solutions to clients and to help support the full spectrum of SaT’s offerings. This case is an example of a project that the DMA team worked on to help a client with their strategic decision-making.

The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

You can also sign-up for the future MECC here.