UK Financial Plan & Risks RLSR 16/4/2015 Content Finances FY - PowerPoint PPT Presentation

UK Financial Plan & Risks RLSR 16/4/2015

Content • Finances – FY 2014/15 – Cost to Completion • Risks – Top level to completion – R9 working space – Summary OsC 13/5/2015 2

Finance OsC 13/5/2015 3

Additional Funds • Late December STFC asked could we make use of additional funds….usual caveats applied  Receipts must be in and paid before end of financial yr  Intended for capital items required out of next yrs budget • Amount available was not specified • Shopping list was submitted • Following list of components were approved out of additional funding OsC 13/5/2015 4

Finance Update FY14/15 – End March Figures FINANCE were using our December outturn figures • Capital project overspend of £55.8k • Resource project underspend of £32k • Overspend for FY14/15 is £23.83k…….1.03% Focus Coils contract receipted, negotiated a final payment of £ 10.5k……saving of £14.5k OsC 13/5/2015 5

Allocation FY15/16 Including OH Excluding OH OH to Finance in 2015/16 2015/16 2015/16 New Old Diff MICE Phase 2 (Capital) Reqns/M&O 520 excluding 80k contingency 520 STAK00058 Travel 0 0 RAL PPD 28 28 Pay 0 RAL TD 640 excluding 30k contingency 640 Pay 1,188 Provisional allocation 1470k. 1,188 RAL PPD FTE 0.50 0.50 RAL TD FTE 13.29 13.29 MICE Phase 2 (Resource) Reqns/M&O 100 excluding 50k contingency 100 STAK00061 Travel 0 0 RAL PPD 128 74 Pay 54 49 5 RAL TD 214 123 Pay 91 90 1 442 Provisional allocation 529k 297 RAL PPD FTE 1.50 1.50 RAL TD FTE 3.64 3.64 MICE Ops & Analysis Reqns/M&O 110 Allocation excludes Common Fund external income of 60k 110 STAK00051 Travel 15 15 RAL PPD 49 28 Pay 21 19 2 RAL TD/Other 486 Including ISIS 3 FTE 279 Pay 207 204 3 660 Provisional allocation 292k 432 RAL PPD FTE 0.50 0.50 RAL TD FTE 6.00 6.00 • Capital allocation including staff cost £1,188K • Resource allocation including staff costs £1,102k • Total allocation including o’heads £2,290k • PPD will provide a further 2.5 FTE in kind contribution…..not included in above • Allocation excludes external income £60k • Allocation excludes contingency £170k OsC 13/5/2015 6

Summary for Allocation Period Phase 2 Construction Actual Actual Actual Approved Total Approved FY 2012/13 FY 2013/14 FY 2014/15 FY 2015/16 (£k) (£k) (£k) (£k) (£k) MICE Phase IIa Construction Based on Projected to (excluding (2+3+4+5+6) and operations and analysis Spend to contingency) end FY March 2015 summary table (1) (2) (3) (4) (5) (6) (7) Staff (including Academics, estates and indirects) Universities IC CG 548.50 126.00 150.50 137.00 135.00 137.00 548.50 Project 548.50 126.00 150.50 137.00 135.00 137.00 548.50 Brunel CG 198.00 49.00 49.00 50.00 50.00 50.00 198.00 Project 198.00 49.00 49.00 50.00 50.00 50.00 198.00 Glasgow CG 166.04 30.00 42.00 47.04 47.00 47.04 166.04 Project 166.04 30.00 42.00 47.04 47.00 47.04 166.04 Oxford CG 124.11 49.00 50.00 25.11 25.11 124.11 Project 124.11 49.00 50.00 25.11 25.11 124.11 Sheffield CG 146.97 36.00 37.00 36.97 37.00 36.97 146.97 Project 146.97 36.00 37.00 36.97 37.00 36.97 146.97 Strathclyde CG 160.00 25.00 40.00 50.00 45.00 50.00 160.00 Project 160.00 25.00 40.00 50.00 45.00 50.00 160.00 Warwick CG 158.25 31.00 42.00 42.25 43.00 42.25 158.25 Project 158.25 31.00 42.00 42.25 43.00 42.25 158.25 Consolidated Grant Total 1,501.87 346.00 410.50 388.37 357.00 388.37 1,501.87 Project Staff Total 1,501.87 346.00 410.50 388.37 357.00 388.37 1,501.87 STFC laboratories staff 637.00 2,232.27 1,240.75 1,545.00 5,655.02 Spend to date 1,050.15 5,464.42 Requirement to end financial year Staff (spend to date) Total 8,658.75 1,329.00 3,053.27 2,017.48 2,259.00 1,826.88 8,468.15 Non-staff Capital 2,831.99 1,126.25 455.74 730.00 520.00 905.19 3,007.18 Resource 509.00 284.00 225.00 443.79 668.79 Travel Common Fund Non-staff Total 3,340.99 1,126.25 455.74 1,014.00 745.00 1,348.98 3,675.97 Total (excluding WA) 11,999.74 2,455.25 3,509.01 3,031.48 3,004.00 3,175.86 12,144.12 Working allowance Total (including WA) 11,999.74 2,455.25 3,509.01 3,031.48 3,004.00 3,175.86 12,144.12 Contingency (Held by STFC) Total Award 11,999.74 2,455.25 3,509.01 3,031.48 3,004.00 3,175.86 12,144.12 Replaces Table 2 in the report 7

UK Cost to completion Final Step • Construction complete – March 2017 MICE UK Cost to Complete 2015/16 2016/17 2017/18 2018/19 Total £k £k £k £k • Commissioning complete – May 2017 Staff effort MICE-UK • Data taking complete – March 2018 1 Project management and project office 411.45 402.36 355.52 1169.33 2 Mechanical integration 203.94 176.62 83.07 463.63 3 Electrical Integration 133.87 209.48 97.07 440.41 4 Focus-coil module 117.46 112.48 116.42 346.36 • 5 Hydrogn Delivery System 44.68 21.85 66.53 Analysis and paper submissions 6 RF power 400.55 373.27 302.13 1075.94 timescales and associated resource costs 7 Vacuum 29.48 30.51 31.58 91.57 8 Magnetic Mitigation 11.23 11.62 6.02 28.87 TBA beyond FY 2017/18 9 Software and computing 160.10 148.39 153.58 158.96 621.03 10 Operations and analysis 921.21 916.01 934.61 769.58 3541.42 Staff totals 2433.98 2402.59 2079.99 928.54 7845.10 Non-staff • Includes 3FTE of ISIS support staff each MICE-UK 1 Project management and project office 15.00 15.00 65.00 160.00 FY + MICE staff contributing to ISIS teams 2 Mechanical integration 258.32 173.27 155.80 743.69 3 Electrical Integration 96.48 182.63 125.93 760.00 (T Stanley, M Tucker, J Govans) 4 Focus-coil module 15.00 35.00 5.00 464.87 5 Hydrogn Delivery System 10.00 71.09 6 RF power 147.14 110.23 75.00 483.16 7 Vacuum 25.76 35.85 36.49 225.81 • Additional maintenance/service costs in 8 Magnetic Mitigation 107.53 55.00 369.12 9 Software and computing 15.00 15.00 15.00 15.00 70.38 2016/17 in O&A wp 10 Operations and analysis 153.68 224.67 171.95 87.93 894.22 Non-staff totals 843.90 846.64 650.17 102.93 2443.65 Total staff and non-staff MICE-UK • Ramping down of staff and non staff costs 1 Project management and project office 426.45 417.36 420.52 2249.08 4 Focus-coil module 132.46 147.48 121.42 1131.03 FY2017/18 5 Hydrogn Delivery System 54.68 21.85 187.34 6 RF power 547.68 483.50 377.13 2250.79 7 Vacuum 55.24 66.36 68.07 353.73 8 Magnetic Mitigation 118.76 66.62 6.02 416.70 • Mitigation costs predominantly 9 Software and computing 175.10 163.39 168.58 173.96 867.43 10 Operations and analysis 1074.90 1140.68 1106.56 857.52 5071.65  Additional Helium costs for magnet Sub-totals 3277.88 3249.24 2730.16 1031.47 10288.74 training runs Grand totals (Cost with time contingency and risk) 3277.88 3249.24 2730.16 1031.47 10288.74  Grand totals (Cost with time contingency) 3107.88 3069.24 2500.16 1031.47 9708.74 Additional shielding  RF crowbar switch & spares MICE-UK Cost of risk mitigation 170.00 180.00 230.00 580.00 Staff element 20.00 10.00 10.00 40.00  Electrical spares for system failures Non-staff element 150.00 170.00 220.00 540.00 8

UK Cost to completion Final Step MICE UK Costs (£k's) Allocation Period Phase 1 Construction Allocation Period Phase 2 Construction Allocation Period Phase 3 Spend Spend Spend Spend Spend Spend Spend Spend Allocation Requirement Requirement Requirement to 2008 2008/9 2009/10 2010/11 2011/12 2012/13 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 Total £10,100 £2,953 £3,064 £3,003 £3,129 £2,613 £3,509 £3,175 £3,278 £3,249 £2,730 £1,031 £41,834 Includes risk mitigation costs  Allocation approved to FY 15/16  Required allocation for phase 3 - FY 16/17, 17/18 & 18/19 • £7m  Total UK spend for MICE £41,8m OsC 13/5/2015 9

Final Step Risk OsC 13/5/2015 10