Spreadsheet: 51fcb3d9-04d8-441a-af69-6172a9a97adb
Sheet: Central Support

 | This sheet provides a summary of the efficiency proposals identified in the Helios Central Services report.
 | [NAME]
 | [NAME] - central support costs by type
 |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR
 | £m 2011/12 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | FBP Central Service Cost
 | £m 2011/12 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Finance | 10.3 | 8.8 | 13.9 | 16.4 | 14.2 | 12.8 | 12 | 11.5 | 11.7 | 11.2 | 11.1
 | Legal | 2.4 | 2.4 | 2.6 | 2.3 | 2.9 | 3.6 | 2.5 | 2.5 | 2.5 | 2.5 | 2.4
 | TS&A | 14.4 | 11.2 | 13.9 | 14.2 | 16.4 | 21.2 | 9.6 | 9.3 | 9.1 | 8.8 | 8.7
 | Communications | 6.5 | 4.4 | 4.5 | 5.7 | 7.7 | 9.1 | 11.8 | 10.6 | 10 | 10 | 9.9
 | HR | 9.6 | 8.7 | 10.5 | 10.8 | 10.2 | 10.9 | 8.2 | 8.2 | 8.2 | 8.3 | 8.3
 | Economics and Regulation | 3.1 | 2.2 | 2.4 | 3.3 | 4.1 | 3.9 | 2.6 | 2.2 | 2.4 | 3 | 3
 | IT | 42.9 | 34 | 44.1 | 42.1 | 34.9 | 35.8 | 36.6 | 37.1 | 38 | 38.9 | 39.4
 | Capital | 15.7 | 9.9 | 9.8 | 8.1 | 12.2 | 2.7 | -0.5 | -4.3 | -4.6 | -5.8 | -6.3
 | Other | 25.8 | 31.9 | 28.9 | 25.3 | 42.5 | 12.9 | 25.2 | 25.4 | 25.8 | 25.9 | 26.7
 | Insurance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | na
 | Total Central Services Opex
 | [NAME] - central support costs by function
 |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR
 | £m 2011/12 | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Staff | 112.1 | 84.9 | 108.5 | 104.7 | 93.4 | 83.1 | 73.6 | 69.8 | 67.5 | 67 | 67.1
 | Technology | 23.9 | 25 | 30 | 32.5 | 37.6 | 25.2 | 38 | 36 | 37.1 | 38.4 | 38.9
 | Consultancy Fees | 16.4 | 15 | 18.4 | 25.5 | 23.8 | 30.3 | 21 | 18.7 | 18.7 | 18.3 | 18.3
 | Capitalised Costs | -63.4 | -53.4 | -70.2 | -64.4 | -59.4 | -54.9 | -57.6 | -55.1 | -53.7 | -54.6 | -55.2
 | Business Support Costs | 7.2 | 7.6 | 6.9 | 5.3 | 5.6 | 5.9 | 0 | 0 | 0 | 0 | 0
 | Inter-company charge | 0.3 | 2.3 | -1.3 | -5.3 | -0.7 | 0 | 2.4 | 2.4 | 2.4 | 2.4 | 2.4 |  |  | na
 | Insurance | 15.5 | 15.6 | 18.9 | 11.2 | 16.3 | 16.7 | 16.3 | 16.7 | 17.3 | 17.3 | 17.8
 | Other | 18.7 | 16.5 | 19.6 | 18.8 | 28.5 | 6.6 | 14.2 | 13.9 | 13.9 | 14 | 13.9
 | Total Central Services Opex
 | Total excluding non-capitalised costs
 | % Staff Costs
 | [NAME] - central support headcount
 |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR
 | Employees | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Heathrow Total Headcount | 5516 | 5407 | 5148 | 5265 | 5045 | 4862 | 4622 | 4488 | 4268 | 4129 | 4089
 | Finance | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | HR | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | IT | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | TS&A | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Development | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Communications | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Legal | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | E&R | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Other (Board and Exec) | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Central Service Total Headcount | 1392 | 1288 | 1214 | 902 | 845 |  | 736 | 724 | 713 | 721 | 717
 | % of Heathrow Total
 | [NAME] - central support staff costs by type
 |  | Q5 |  |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR
 | Staff costs | 2008/09 | 2009/10 | 2010/11 | 2011/12 | 2012/13 | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 | Heathrow Total Staff Costs
 | Finance | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | HR | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | IT | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | TS&A | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Development | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Communications | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Legal | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | E&R | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Other (Board and Exec) | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Central Service Total | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | Central Service Total (ex development) | " | " | " | " | " | " | " | " | " | " | " |  | " | "
 | % of Heathrow Total Staff Costs | 0.2825844782770145 | 0.2514361467079099 | 0.2941415785191213 | 0.2819534528805799 | 0.2001373154823206 | 0.1955469682746553 | 0.1895504587443146 | 0.1921697346774302 | 0.1953093131369885 | 0.1985947424104491 | 0.199390018733215 |  | 0.1948253927459665
 | Heathrow - Helios Efficiency
 | Central support efficiency proposals |  | Line / Saving |  |  |  | Q5+1 | Q6 |  |  |  |  |  | Q6 Total | CAGR
 |  | Risk (1 low, 2 mid, 3 high) | £m 2011/12 |  |  |  | 2013/14 | 2014/15 | 2015/16 | 2016/17 | 2017/18 | 2018/19
 |  | 1 | Finance - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Finance - Stretch |  |  |  | 0 | 3.4 | 3.3 | 3.4 | 3.4 | 3.4 |  |  | na
 |  | 1 | HR - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | HR - Stretch |  |  |  | 0 | 3.3 | 3.4 | 3.5 | 3.6 | 3.6 |  |  | na
 |  | 1 | IT - Core |  |  |  | 0 | 0.8 | 1.2 | 2.2 | 3.1 | 3.5 |  |  | na
 |  | 3 | IT - Stretch |  |  |  | 0 | 6.9 | 6.5 | 5.5 | 5.3 | 4.9 |  |  | na
 |  | 1 | Legal - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Legal - Stretch |  |  |  | 0 | 0.3 | 0.2 | 0.2 | 0.2 | 0.2 |  |  | na
 |  | 1 | Communications - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Communications - Stretch |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 1 | Strategy and Reg - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Strategy and Reg - Stretch |  |  |  | 0 | 0.4 | 0.3 | 0.1 | 0.2 | 0.2 |  |  | na
 |  | 1 | Airport Management - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Airport Management - Stretch |  |  |  | 0 | 1.6 | 1.6 | 1.6 | 1.6 | 1.8 |  |  | na
 |  | 1 | Insurance - Core |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  | na
 |  | 3 | Insurance - Stretch |  |  |  | 0 | 0.3 | 1.1 | 1 | 0.6 | 0.5 |  |  | na
 |  |  | Total Efficiency (Core) |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Total Efficiency (Mid) |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Total Efficiency (Stretch) |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Staff cost efficiency in central services |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Net Efficiency - Core |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Net Efficiency - Mid |  |  |  |  |  |  |  |  |  |  |  | na
 |  |  | Net Efficiency - Stretch |  |  |  |  |  |  |  |  |  |  |  | na
 | End