Download original attachment
(Excel spreadsheet)
This is an HTML version of an attachment to the Freedom of Information request
'Copy of UASC costs templates'.
(Excel spreadsheet)
| UASC Unit costs 2008/09 | |||||||||||
| Under 16 | 16 & 17 year olds | Post 18 | |||||||||
| L. After | External | Independent | L. After | External | Independent | L. After | External | Independent | |||
| 1) Direct costs: 2B40 | 17545.2419639749 | 50776.9378029633 | 0 | 14961.8118056049 | 38154.2468953281 | 4868.97679176075 | 155.78147566719 | ||||
| 2) Direct Administration Costs (Asylum Team costs) 2B41 | 2994.05388368719 | 2994.05388368719 | 0 | 2994.0538836872 | 2987.96130818937 | 2994.0538836872 | 374.053375196232 | ||||
| 3) Direct Support Costs | 4888.75251900405 | 4888.75251900405 | 0 | 4888.75251900406 | 4888.75251900406 | 1404.07432600767 | |||||
| 4) Central/Departmental support costs | 272.635727208819 | 272.635727208819 | 0 | 272.635727208819 | 272.635727208819 | 118.686535671898 | |||||
| UASC Cost | 25700.6840938749 | 58932.3799328633 | 0 | 23117.253935505 | 46303.5964497303 | 9385.79153712751 | 529.834850863422 | ||||
| Total Average UASC Numbers 2008/09 | 39.1333333333333 | 2.5 | 0 | 12 | 0.333333333333333 | 72.4166666666667 | 126.383333333333 | ||||
| UASC costs | monitoring template | 0809 | ||||||||||||||||
| - Cost currently not claimed in current year 08/09 UASC | ||||||||||||||||||
| Under 16 | 16 & 17 year olds | Post 18 | Status | Detailed Description | Basis of apportionment | |||||||||||||
| L. After | External | Independent | L. After | External | Independent | Total | L. After | External | Independent | |||||||||
| 1) Direct costs: 2B40 | Under 18's | N/A - these should all be actual costs | ||||||||||||||||
| 1 | - Accommodation - Independent foster care | 125922.472727273 | 12592.2472727273 | 138514.72 | 277029.44 | External agency foster care | ||||||||||||
| 2 | - Accommodation - in-house foster care | 642741.409258496 | 171567.680741504 | 814309.09 | 1628618.18 | Internal Foster care | ||||||||||||
| 3 | - Accommodation - Residential Homes | 0 | 0 | Council owned residential homes | ||||||||||||||
| 4 | - Accommodation - Semi independent | 175094.56 | 175094.56 | 4123.55 | 354312.67 | Clients independent accomodation where rent reimbursed by the council | ||||||||||||
| 5 | - Subsistence costs | 27898 | 3444 | 144034.85 | 175376.85 | 4145.85 | 354899.55 | Client subsistence includes clothing, food, leisure activities, shopping and travel. | ||||||||||
| 6 | -Transport Costs | 3662.78401160491 | 233.993867862324 | 0 | 1123.17056573915 | 31.1991823816431 | 6778.02237241197 | 11829.17 | 23658.34 | Vechicle Contract Hire (Hired cars for social workers to see clients in outter boroughs), Vechicle Fuel Costs (For social worker cars when visiting clients), Excess Travel Expenses (Public Transport Expenses) and Car Parking Fees for Social Workers. | ||||||||
| 7 | - Interpreters costs | 10781.3081629962 | 688.754780429909 | 3306.02294606356 | 91.8339707239879 | 19950.9301397864 | 34818.85 | 69637.7 | Translation and Interpretation cost. Social workers interpreting clients and translating into the English language. | |||||||||
| 8 | External Repairs and Decoration | Accomodation | 0 | 0 | Broken window patio by client, broken kitchen windows for client accomodation. | |||||||||||||
| 9 | Internal Repairs and Decoration | Accomodation | 0 | 0 | Carpet replacements, lock replacements and bed replacements for client accomodation. | |||||||||||||
| 10 | Council Tax | 1838 | 1838 | 3676 | For client occupied properties | |||||||||||||
| 11 | Fixtures and Fittings | 4290 | 4290 | 8580 | Removing and replacing damaged goods from client properties, checking and cleaning cookers for client accomodation. | |||||||||||||
| 12 | Books | 160.378029803508 | 10.2456151918766 | 49.1789529210075 | 1.36608202558354 | 296.781320058025 | 517.95 | 1035.9 | Books for clients | |||||||||
| 13 | Food purchase | subsistence 4 | 0 | 0 | Groceries for clients | |||||||||||||
| 14 | Meals | subsistence 4 | 0 | 0 | Cooked meals for clients | |||||||||||||
| 15 | Stationery | 0 | 0 | Expenditure on gift/card/novelty/souvenir shops. | ||||||||||||||
| 16 | Removal costs | 0 | 0 | For the removal of clients from their properties | ||||||||||||||
| 17 | Children Activities | 1191.36091273018 | 76.1090872698157 | 1267.47 | 2534.94 | Costs for leisure activities for clients. Days/Weekend out for clients | ||||||||||||
| 18 | Client Support | 168.561814585256 | 10.7684293815113 | 51.6884610312541 | 1.4357905842015 | 311.925504417777 | 544.38 | 1088.76 | Therapy sessions for clients. Stress/depression treatments for clients. | |||||||||
| 19 | Central Legal - Legal Time | 0 | 0 | Legal costs in relation to clients | ||||||||||||||
| 0 | ||||||||||||||||||
| 0 | ||||||||||||||||||
| Total Direct costs | 686603.802190216 | 126942.344507408 | 0 | 179541.741667259 | 12718.0822984427 | 352595.069336674 | 1358401.04 | 0 | 0 | 8269.4 | 2725071.48 | |||||||
| 0 | ||||||||||||||||||
| 2) Direct Administration Costs (Asylum Team costs) 2B41 | 0 | N/A - these should all be actual costs | ||||||||||||||||
| STAFFING COSTS | 0 | |||||||||||||||||
| 0 | ||||||||||||||||||
| 1 | Salary costs (General admin and finance) | 18878.604304365 | 1206.04371620731 | 5789.00983779507 | 160.805828827641 | 34935.066312805 | 60969.53 | 121939.06 | Salary costs for staff working at main asylum building including on-costs and car allowances. General admin and finance include Personal Assistants, Support Officers, Admin Assistants, Asylum Service Manager and Business Manager. | |||||||||
| 2 | Agency staff costs (General admin and Finance) | 17171.8129763946 | 1097.00679150732 | 5265.63259923513 | 146.267572200976 | 31776.630060662 | 55457.35 | 110914.7 | Agency costs for the above. | |||||||||
| 3 | Agency staff costs (Social Worker Costs) | -1616.65203217724 | -103.278451800079 | -495.73656864038 | -13.7704602400105 | -2991.63248714229 | -5221.07 | -10442.14 | Agency costs only for social workers in Asylum. | |||||||||
| 4 | Social Worker Salary Costs | 73545.7695476724 | 4698.40946854807 | 22552.3654490307 | 626.454595806409 | 136097.260938942 | 237520.26 | 19856 | 494896.52 | Permanent Social Worker Costs | ||||||||
| 5 | Professional Consultancy Fees | 0 | Costs for consultants employed within the Asylum Team. | |||||||||||||||
| 6 | Advertising | 0 | Advertising costs in relation to vacant posts | |||||||||||||||
| 7 | 0 | |||||||||||||||||
| PREMISES COSTS | 0 | ONLY APPLICABLE WHERE THE AUTHORITY HAS A SEPARATE BUILDING SOLELY FOR ASYLUM. Where part of a main building see 'Corporate Overheads' below. | ||||||||||||||||
| 8 | Staff travel | 0 | Includes staff travelling for meetings and conferences in outter boroughs. Includes car hire and vechicle hire for staff. | |||||||||||||||
| 9 | Public Transport | 16.1012791771067 | 1.02861664248978 | 4.93735988395094 | 0.137148885665304 | 29.7955954107873 | 52 | 104 | Tube and railway travel for staff travel in relation to clients. | |||||||||
| 10 | Non-Domestic Rates | 527.131109059739 | 33.6753263879731 | 161.641566662271 | 4.49004351839641 | 975.461954371621 | 1702.4 | 3404.8 | Business Rates for Main Asylum Building. | |||||||||
| 11 | Electricity bills | 161.214057760781 | 10.2990241329289 | 49.4353158380588 | 1.37320321772386 | 298.328399050508 | 520.65 | 1041.3 | Electricty consumed at Main Asylum Building. | |||||||||
| 12 | Gas bills | 244.727057892655 | 15.6341817222735 | 75.0440722669128 | 2.0845575629698 | 452.870130555189 | 790.36 | 1580.72 | Gas consumed at Main Asylum Building. | |||||||||
| 13 | Rents and Wayleaves | 19.2812818145853 | 1.23176842938151 | 5.91248846103125 | 0.164235790584201 | 35.6802255044178 | 62.27 | 124.54 | Rent for Main Asylum Building. | |||||||||
| 14 | Building Cleaning | 1742.86128972702 | 111.341223790057 | 534.437874192272 | 14.8454965053409 | 3225.18411578531 | 5628.67 | 11257.34 | Building cleaning costs for Main Asylum Building. | |||||||||
| 15 | Premises Insurance | 0 | 0 | Main Asylum Building buildings insurance premium | 0 | |||||||||||||
| 16 | Refuse Collection | 87.7612607147567 | 5.60655413424766 | 26.9114598443888 | 0.747540551233021 | 162.403184755374 | 283.43 | 566.86 | Refuse collection for Main Asylum Building. | |||||||||
| 17 | Water Rates and Sewerage | 335.990346828432 | 21.4644599762627 | 103.029407886061 | 2.86192799683503 | 621.753857312409 | 1085.1 | 2170.2 | For Main Asylum Building. | |||||||||
| 18 | Fixtures and Fittings | 30.9639984175129 | 1.97810892786496 | 9.49492285375181 | 0.263747857048661 | 57.2992219438217 | 100 | 200 | Installing smoke alarm, curtains fitted. | |||||||||
| 19 | Security Services | 166.895951470394 | 10.6620071211921 | 51.1776341817223 | 1.42160094949229 | 308.842806277199 | 539 | 1078 | Provided at Main Asylum Building. Security 24 hours. | |||||||||
| 20a | Building Maintenance | 1437.33642094158 | 91.8230251879203 | 440.750520902018 | 12.243070025056 | 2659.80696294343 | 4641.96 | 9283.92 | ||||||||||
| SUPPLIES & SERVICES | 0 | 0 | ||||||||||||||||
| 20 | Telephone costs | 667.5187814849 | 42.64387445602 | 204.690597388896 | 5.68584992746934 | 1235.25089674271 | 2155.79 | 4311.58 | Call costs for staff at Main Asylum Building. | |||||||||
| 21 | Other expenses | 226.269418435975 | 14.4550309903732 | 69.3841487537914 | 1.92733746538309 | 418.714064354477 | 730.75 | 1461.5 | Include appliance equipment purchases for Main Asylum Building., cleaning materials and ID passess for staff. | |||||||||
| 22 | Equipment Hire | 145.354297771331 | 9.28583674007649 | 44.5720163523671 | 1.23811156534353 | 268.979737570882 | 469.43 | 938.86 | Drinking water units at Main Asylum Building. | |||||||||
| 23 | Furniture Purchase | 96.6076750626401 | 6.17169985493868 | 29.6241593037057 | 0.822893313991824 | 178.773572464724 | 312 | 624 | New Office furniture for Main Asylum Building, installing security devices, burgular alarms. | |||||||||
| 24 | Materials Purchase | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Supplying and installing new window pane at Main Asylum Building. | |||||||||
| 25 | Food Purchase | 132.934638006066 | 8.49241724910985 | 40.7636027957273 | 1.13232229988131 | 245.997019649215 | 429.32 | 858.64 | Lunch and refreshments provided for meetings with clients | |||||||||
| 26 | Printing | 138.031312145589 | 8.81801397863642 | 42.3264670974548 | 1.17573519715152 | 255.428471581168 | 445.78 | 891.56 | Central recharges | |||||||||
| 27 | Stationary | 466.441672161414 | 29.7982328893578 | 143.031517868917 | 3.97309771858104 | 863.15547936173 | 1506.4 | 3012.8 | Stationary purchased at Main Asylum Building for staff costs | |||||||||
| 28 | Photocopying | 261.326857444283 | 16.6946459185019 | 80.1343004088092 | 2.22595278913359 | 483.588243439272 | 843.97 | 1687.94 | Central recharges | |||||||||
| 29 | Computer equipment | 1740.26341025979 | 111.175260451009 | 533.641250164842 | 14.8233680601345 | 3220.37671106422 | 5620.28 | 11240.56 | Purchase of desktops, Memory Pen Devices for staff.. | |||||||||
| 30 | Data communication | 0 | Internet service provider for staff usage. | |||||||||||||||
| 31 | Postages | 114.653493340367 | 7.32454173809838 | 35.1578003428722 | 0.976605565079784 | 212.167559013583 | 370.28 | 740.56 | Correspondence with Home Office, clients. | |||||||||
| 32 | Mobile telephones | 428.108242120533 | 27.3493340366609 | 131.276803375973 | 1.6157193722801 | 792.219042595279 | 1380.56914150073 | 2761.13828300145 | For staff at Main Asylum Building. | |||||||||
| 33 | Televisions | 0 | Supplying TV aerials for residential homes owned by the council. | |||||||||||||||
| 34 | Subscriptions | 0 | LASC (London Councils Business Consortium) Business plan and subscription request and invoice for subscription to refugee council | |||||||||||||||
| Total Admin costs | 117167.308648292 | 7485.13470921799 | 0 | 35928.6466042463 | 995.98710272979 | 216819.402077014 | 378396.479141501 | 0 | 0 | 19856 | 776648.958283002 | |||||||
| 0 | ||||||||||||||||||
| 3) Direct Support Costs | ||||||||||||||||||
| A proportion of the following: | ||||||||||||||||||
| 1 | Recharge | C & F DIV. DIRECTOR EXPENSES | 18098.9505075932 | 1156.23619085987 | 5549.93371612737 | 154.164825447983 | 33492.3083285742 | 58451.5935686026 | Done some not all some to Salaries | Deputy Director of Children services staffing costs (% agreed in relation to Asylum) | ||||||||
| 2 | C&F HEAD OF SAFEGUARDING | 99978.2991636447 | 6387.02933328224 | 30657.7407997548 | 851.603911104299 | 137874.673207786 | Head of Aslyum staffing costs (% agreed in relation to Asylum) | |||||||||||
| 3 | COUNCIL RESIDENTIAL HOME | 0 | n/a | n/a | n/a | Council owned residential home, depending on Asylum client occupation. | ||||||||||||
| 4 | CHILD PROTECTION | 12649.7805414634 | 808.12056269996 | 3878.97870095981 | 107.749408359995 | 17444.6292134831 | Child protection staffing costs (% agreed in relation to Asylum). | |||||||||||
| 5 | RFPT (Residential fostering and placement team)- PROVIDER MANAGEMENT | 0 | Residential fostering and placement management team cost (% agreed in relation to Asylum) | |||||||||||||||
| 6 | Recharge | RFPT (Residential fostering and placement team) - FOSTERING PROVIDER | 36847.1581168403 | 2353.9496241593 | 11298.9581959647 | 313.859949887907 | 68186.0741131478 | 119000 | recharged 120k last year | Residential fostering and placement team cost (% agreed in relation to Asylum) | ||||||||
| 7 | YOT (Youth Offending Team) | 20501.3466337245 | 1309.7112415071 | 6286.6139592341 | 174.62816553428 | 28272.3 | Asylum Youth Offending expenses- based on activity during the year | |||||||||||
| 8 | SIBS (Sexual Inappropraire Behaviour Service) | 3237.64694709261 | 206.834345001657 | 992.804856007955 | 27.5779126668876 | 4464.86406076911 | ||||||||||||
| Total direct support costs | 191313.181910359 | 12221.8812975101 | 0 | 58665.0302280487 | 1629.58417300135 | 101678.382441722 | 361043.195989872 | 0 | 0 | 0 | ||||||||
| 4) Central/Departmental support costs | ||||||||||||||||||
| A proportion of the following: | ||||||||||||||||||
| 1 | IT CAREFIRST | 6024.54502881151 | 384.872978842302 | 1847.39029844305 | 51.3163971789737 | 8308.12470327583 | Ruth | Asylum Client database system including maintenance costs | ||||||||||
| 2 | FINANCE | 0 | Ruth Part of Corporate | Finance staffing costs for Asylum work. | ||||||||||||||
| 3 | CORPORATE OVERHEADS | 4644.59976262693 | 296.716339179744 | 1424.23842806277 | 39.5621785572992 | 8594.88329157326 | 15000 | Ruth | Includes Human Resources, Legal, Emergency duty team, trade union expenses, finance service charges, facilities management | |||||||||
| Total central support costs | 10669.1447914384 | 681.589318022047 | 0 | 3271.62872650582 | 90.8785757362729 | 8594.88329157326 | 23308.1247032758 | |||||||||||
| Total UASC costs | 1005753.43754031 | 147330.949832158 | 0 | 277407.04722606 | 15434.5321499101 | 679687.737146984 | 2121148.83983465 | 0 | 0 | 28125.4 | ||||||||
| 5) Income | ||||||||||||||||||
| Less : Housing Benefit | Eligible Housing benefit received for Asylum clients | |||||||||||||||||
| Net UASC Cost | 1005753.43754031 | 147330.949832158 | 0 | 277407.04722606 | 15434.5321499101 | 679687.737146984 | 0 | 0 | 28125.4 | |||||||||
| Total Average UASC Numbers 2008/09 | 39.1333333333333 | 2.5 | 0 | 12 | 0.333333333333333 | 72.4166666666667 | 126.383333333333 | 53.0833333333333 | ||||||||||