Spreadsheet: 200085d1355411529-removing-n-a-errors-book2-tsa
Sheet: A

TSA No. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday List For 2014
TSA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good Friday | 2014-04-18 00:00:00
 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
FTE
Salary Costs
Premises
Desktop
Other Costs (Excl. [NAME])
Total
[NAME] | Role / Job Title | FTE Source | Business Unit Source | Location | Resource Type | Detailed Activity | Variable | Grade | Day Rate (Contractors) | Working Days | Start Date | End Date | # FTE | Premises | Desktop | Total FTE 2014 | Total FTE 2015 | Total FTE 2016 | Total FTE 2017 | Total FTE 2018 | Total FTE 2019 | Total FTE 2020 | Total FTE 2021 | Total FTE 2022 | Total FTE 2023 | Total FTE 2024 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Easter Monday | 2014-04-21 00:00:00
 | Content Management | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Early May Bank Holiday | 2014-05-05 00:00:00
 | Operations & Fraud | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring Bank Holiday | 2014-05-26 00:00:00
 | Operations & Fraud | Existing |  | North West | Permanent | TSA Build Costs | Fixed |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer Bank Holiday | 2014-08-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2014-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boxing Day | 2014-12-26 00:00:00
 | Monthly Salary |  |  |  | Yearly Salary
 |  |  |  |  |  | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035 | 0.035
Monthly [NAME] by Grade | 2011 | 2012 | 2013 | 2014 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
Grade A | 2106.938873412525
[NAME] | 2408.309984960281
[NAME] | 3177.251775121511
[NAME] | 3790.009989925184
[NAME]
[NAME] | 5926.188771021992
Grade EL
[NAME] | 9882.55645
[NAME] | 14460.1082
Grade H | 29789.763
Property Costs £ mth/FTE
Location |  |  |  |  | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024
London |  |  |  |  | 756.33 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808 | 808
North West |  |  |  |  | 318.08 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261 | 261
South West |  |  |  |  | 355.83 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92 | 349.92
Edinburgh |  |  |  |  | 418.25 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3 | 405.3
Rosyth |  |  |  |  | 464.92 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25 | 347.25
Dunfermline
West Yorkshire |  |  |  |  | 237.33 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75 | 241.75
Desktop Costs
Assumption Per FTE |  |  |  |  | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208 | 208
Other Costs
TSA Name | Cost Type | Cost Category | Assumption | [NAME] | Cost Driver