The railway operator needs to ensure that their trains run on time and that they minimize the number of cancelled services and late stops. Failure to do so will result in performance penalties that will impact their profitability.
This case focuses on comparing the actual running performance of a simple railway with a scheduled timetable running over a period of 3 months, and then calculating the performance penalties owed each month by the railway operator.
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. 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