Spreadsheet: 199170d1355131945-index-and-match-assistance-premises-cost
Sheet: Finance (3)

TSA No. | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday List For 2014
TSA | Finance Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2014-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good Friday | 2014-04-18 00:00:00
 | 2013 | 2014 | 2015
Salary Costs
Premises
Desktop
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 | 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 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Easter Monday | 2014-04-21 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Early May Bank Holiday | 2014-05-05 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spring Bank Holiday | 2014-05-26 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summer Bank Holiday | 2014-08-25 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2014-12-25 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boxing Day | 2014-12-26 00:00:00
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 |  | Existing |  | North West | Permanent | TSA Build Costs | Fixed | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1
 | Monthly Salary |  |  |  | Yearly Salary
 |  |  |  |  |  | 0.035 | 0.035 | 0.035
Monthly [NAME] by Grade | 2011 | 2012 | 2013 | 2014 | 2011 | 2012 | 2013 | 2014 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Property
Grade A | 2106.938873412525 | 2106.938873412525 | 2106.938873412525 | 2106.938873412525 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | £/mth/FTE |  | 2011 | 2012
[NAME] | 2408.309984960281 | 2408.309984960281 | 2408.309984960281 | 2408.309984960281
[NAME] | 3177.251775121511 | 3177.251775121511 | 3177.251775121511 | 3177.251775121511 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London |  | 756.33 | 808
[NAME] | 3790.009989925184 | 3790.009989925184 | 3790.009989925184 | 3790.009989925184
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North West | Chester | 318.08 | 261
[NAME] | 5926.188771021992 | 5926.188771021992 | 5926.188771021992 | 5926.188771021992
Grade EL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South West |  | 355.83 | 349.92
[NAME] | 9882.55645 | 9882.55645 | 9882.55645 | 9882.55645 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Edinburgh | Ettrick | 418.25 | 405.3
[NAME] | 14460.1082 | 14460.1082 | 14460.1082 | 14460.1082 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rosyth |  | 464.92 | 347.25
Grade H | 29789.763 | 29789.763 | 29789.763 | 29789.763 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dunfermline | Pitreavie
Property Costs £ mth/FTE
Location | 2011 | 2012 | 2013 | 2014
London | 756.33 | 808 | 808 | 808
North West | 318.08 | 261 | 261 | 261
South West | 355.83 | 349.92 | 349.92 | 349.92
Edinburgh | 418.25 | 405.3 | 405.3 | 405.3
Rosyth | 464.92 | 347.25 | 347.25 | 347.25
Dunfermline
West Yorkshire | 237.33 | 241.75 | 241.75 | 241.75
Desktop Costs
Assumption Per FTE | 208 | 208 | 208 | 208