Instructions You work for Abellio providing a Rail Replacement Service to Anywhere Railways. In order to complete the exercises on the following pages please carefully read and understand the question as well as the Anywhere Rate structure provided in the 'Rates' tab. "ARR' is Abellio Rail Replacement. Please spend a total of no more than 60 minutes on the task, including reading time. Leave any questions that you do not complete blank 3 Please highlight completed questions and ensure that any new columns added to the data are 4 highlighted. Any formulas used should be left within the cells for assessment. You may add 5 assumptions/addition tabs as necessary but only submit one excel document for review 6 17 18 19 20 21 22 23 24 25 26 27 Pre Planned: Standby: Emergency: Rates are paid to operators based on a journey from a start/end station. - Rates are paid to operators on a pre-planned hourly basis Rates are the same for running or standby Operator payments attract a minimum equivalent of 3 hours rate for pre planned work. - The 'running' rate attracts a higher hourly rate when standbys are used. Comment Hours Target Rate/hour Revenue to ARR Hours Target Comments Revenue to ARR Rate/hour Hours Target Rate/hour in Comments Revenue to ARR hours S 61.56 per 3 hours 30 162.99 for first 3 hours plus 42.38 per hour over 3 hours >3 hours hour 42.38 for each hour vehicle is in use >4 hours running/ standby 40 per hour 46.18 per hour E53.00 per 3 hours 25 147.33 for first 3 hours plus 37.10 per hour over 3 hours >3 hours hour 37.10 for each hour the vehicle is in use >4 hours running or standby 30 per hour 34.98 per hour 3 hour 72.26 per minimum of 180 hour. 216.78 minimum 33 per hours hour 216.78 minimum for the first three hours then 49.13 per hour beyond the first 3 hours hours Minimum 81.87 per 50 per hour E200 for 4 hour. Min 4 hours I hours Double Deck) coach/bus Double Deck coach/bus >4 hours running or standby Double Deck coach/bus >4 hours running or 216.78 for first three hours plus 56.37 per 533 per >3 hours 42 >3 hours hour 56.37 for each hour used 50 per hour 61.42 per hour Ticket Acceptance The below lines are Ticket Acceptance for Anywhere Railways. Add the following information to the data: Calculate the revenue and margin ARR will earn from Anywhere Railways by applying an uplift of 24% to the Final Price to Operator. Description Time started Time Finish Final Price To Operator Cost to Anywhere Railways 00:00 00:00 495.00 495.00 00:00 00:00 23:59 23:59 23:59 17:45 17:45 23:59 Norwich Yarmouth Lowestoft 3 Norwich Yarmouth Lowestoft Norwich - Sheringham o Norwich - Sheringham 1 Norwich - Sheringham 2 Yarmouth to Lowestoft 3 Yarmouth to Lowestoft 4 North Walsham to Sheringham 5 North Walsham to Sheringham 6 North Walsham to Sheringham 7 North Walsham to Sheringham 8 North Walsham to Sheringham 9 North Walsham to Sheringham o North Walsham to Sheringham 1 North Walsham to Sheringham 2 North Walsham to Sheringham 3 4 12:00 12:00 12:00 15:45 15:45 12:00 12:00 12:00 06:00 06:00 06:00 05:30 05:30 23:59 23:59 23:59 23:59 23:59 13:40 13:40 13:40 625.00 625.00 625.00 245.00 f245.00 625.00 625.00 625.00 625.00 625.00 625.00 375.00 375.00 375.00 8,230.00 05:30 0.00 Instructions You work for Abellio providing a Rail Replacement Service to Anywhere Railways. In order to complete the exercises on the following pages please carefully read and understand the question as well as the Anywhere Rate structure provided in the 'Rates' tab. "ARR' is Abellio Rail Replacement. Please spend a total of no more than 60 minutes on the task, including reading time. Leave any questions that you do not complete blank 3 Please highlight completed questions and ensure that any new columns added to the data are 4 highlighted. Any formulas used should be left within the cells for assessment. You may add 5 assumptions/addition tabs as necessary but only submit one excel document for review 6 17 18 19 20 21 22 23 24 25 26 27 Pre Planned: Standby: Emergency: Rates are paid to operators based on a journey from a start/end station. - Rates are paid to operators on a pre-planned hourly basis Rates are the same for running or standby Operator payments attract a minimum equivalent of 3 hours rate for pre planned work. - The 'running' rate attracts a higher hourly rate when standbys are used. Comment Hours Target Rate/hour Revenue to ARR Hours Target Comments Revenue to ARR Rate/hour Hours Target Rate/hour in Comments Revenue to ARR hours S 61.56 per 3 hours 30 162.99 for first 3 hours plus 42.38 per hour over 3 hours >3 hours hour 42.38 for each hour vehicle is in use >4 hours running/ standby 40 per hour 46.18 per hour E53.00 per 3 hours 25 147.33 for first 3 hours plus 37.10 per hour over 3 hours >3 hours hour 37.10 for each hour the vehicle is in use >4 hours running or standby 30 per hour 34.98 per hour 3 hour 72.26 per minimum of 180 hour. 216.78 minimum 33 per hours hour 216.78 minimum for the first three hours then 49.13 per hour beyond the first 3 hours hours Minimum 81.87 per 50 per hour E200 for 4 hour. Min 4 hours I hours Double Deck) coach/bus Double Deck coach/bus >4 hours running or standby Double Deck coach/bus >4 hours running or 216.78 for first three hours plus 56.37 per 533 per >3 hours 42 >3 hours hour 56.37 for each hour used 50 per hour 61.42 per hour Ticket Acceptance The below lines are Ticket Acceptance for Anywhere Railways. Add the following information to the data: Calculate the revenue and margin ARR will earn from Anywhere Railways by applying an uplift of 24% to the Final Price to Operator. Description Time started Time Finish Final Price To Operator Cost to Anywhere Railways 00:00 00:00 495.00 495.00 00:00 00:00 23:59 23:59 23:59 17:45 17:45 23:59 Norwich Yarmouth Lowestoft 3 Norwich Yarmouth Lowestoft Norwich - Sheringham o Norwich - Sheringham 1 Norwich - Sheringham 2 Yarmouth to Lowestoft 3 Yarmouth to Lowestoft 4 North Walsham to Sheringham 5 North Walsham to Sheringham 6 North Walsham to Sheringham 7 North Walsham to Sheringham 8 North Walsham to Sheringham 9 North Walsham to Sheringham o North Walsham to Sheringham 1 North Walsham to Sheringham 2 North Walsham to Sheringham 3 4 12:00 12:00 12:00 15:45 15:45 12:00 12:00 12:00 06:00 06:00 06:00 05:30 05:30 23:59 23:59 23:59 23:59 23:59 13:40 13:40 13:40 625.00 625.00 625.00 245.00 f245.00 625.00 625.00 625.00 625.00 625.00 625.00 375.00 375.00 375.00 8,230.00 05:30 0.00