Here is a comprehensive walkthrough guide for the Ticket Master Solution Model provided by one of our faculty fellows, Carolyn Hamilton (ActiveSheet). The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

TASK
The Story
You are a data analyst at a Matchpoint Event Consulting Company (which miraculously abbreviates as MECC), a company that helps high-profile sports companies to maximize their revenue. Your client looks for ways to increase ticket sales of their soccer team.
Tickets
The seat locations on the stadium are presented at the corresponding sheet. There are a total of 6 ticket pricing categories (see table to the right). Each seat has its own address that is the same as its cell address in Excel.
WALKTHROUGH VIDEO PROVIDED CAROLYN HAMILTON
MEWC
TAC
EEO