Professional Excel Templates for your Business
"On-Time Running" - FMWC Stage 3 (2022) & University Championship (Spring 2022)
This is an actual case study that was presented to the participants of both Financial Modeling University Championship (Spring 2022) Round 2 and Financial Modeling World Cup Stage 3.
Case study description:
The objective of this case is to compare the actual running performance of a railway with a scheduled timetable running over a period of 3 months. The focus is to calculate the performance penalties owed each month by the railway operator. There are three types of penalties: cancellation penalty, journey time penalty, and late stop penalty. The penalty regime is based on the number of canceled services, average late arrival time, and late stops.
The railway operator needs to ensure that their trains run on time and that they minimize the number of canceled services and late stops. Failure to do so will result in performance penalties that will impact their profitability.
The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold
You can also buy tickets to participate in the future FMWC Stages here.
There are no reviews yet.