Sheet1

UASC costs monitoring template

		Under 16	16 & 17 year olds	Post 18s	Basis of apportionment

1) Direct costs:					Based on 24xU16, 56x16&17's & 56 post 18's
	- Accommodation - Independent foster care
	- Accommodation - in-house foster care
	- Accommodation - Residential Homes
	- Accommodation - Semi independent
	- Accommodation - independent rentals		174,720	174,720	Based on 56 service users (average £60 per week)
	- Additional Fostering costs
	- Subsistence costs		101,920	148,366	Post 18 DWP rate £50.95 pw, 16-17's £35 pw.
	- Weekly Travel costs		12,656		No post 18 costs
	- Birthday Allowance	480	1,120		Allow £20 per child <18
	- Religious Festival Allowance	600	1,400		Allow £25 per child <18
	- Clothing Allowance		19,600		Allow £350 per child
	- Interpreters costs		72,800	36,400	26hrs per child per annum @£50 ph. (post 18's 13hrs)
	- Official documents costs		4,480	2,240	16-17's £80 per child, post 18's £40 per child
	- Legal costs			14,000	Est £250 per child
	- School Dinners costs
	- School Trips / activities		6,720		£120 per child pA
	- Educational equipment		2,800	20,000	16-17's £50 per child, post 18's assume £2,000 x 10 children
	- Setting Up costs - post 18s
	- Electricity bills		43,680		£15 pp pw
	- Gas bills		43,680		£15 pp pw
	- Water Rates		5,600		£100 per child
	- Council Tax		20,000	20,000	Based on 2008-09 expenditure
	- Repairs and Renewals		78,400		Est £1400 per bedspace
	- Client Support		11,200		To develop independent living skills - £200 per child
	- Property Insurance		1,560		Based on 2008-09 expenditure
	- TV Licences		7,980		Est £142.50 per child
	- Leaving Care Grant			42,000	Based on 28 post 18's @ £1500 per child
	- Recreational support costs (e.g. bikes, etc)
	*Total Direct costs*	** 1,080	** 610,316	** 457,726

2) Direct Administration Costs (Asylum Team costs)					N/A - these should all be actual costs

	Salary costs	130,938	305,524	67,281	Team Costs
	Agency staff costs		45,000		To cover sickness and holidays
	NRUC subscription costs		1,000		Based on 2008-09 expenditure
	Office rental
	Council tax / Business rates	2,545	5,939	1,310	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Public Transport	1,200	2,800	2,800	Based on 2008-09 expenditure - staff costs
	- Premises Insurance	600	1,400	700	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Refuse Collection	682	1,592	796	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Water Rates 7 Sewerage	642	1,500	750	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Fixture & Fittings	1,000	2,000	1,000	Based on 2008-09 expenditure
	- Security services	5,040	11,760	5,880	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Electricity bills	1,500	3,000	1,500	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Gas bills	2,250	4,500	2,250	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Staff travel	3,024	7,056	3,528	Est 200 miles per month
	- Staff Training	1,500	3,500	1,750	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Staff subsistence	1,000	2,000	1,000	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Stationery costs	800	1,200	600	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- Printing costs	100	200	100	Based on 2008-09 expenditure - Apportion costs of Belmont.
	- cleaning	780	1,820	910	Est 1hr @£10 per day for 5days a week
	- Office equipment	1,000	2,000	1,000	Based on 2008-09 expenditure
	- telephone costs	3,300	7,920	3,960	Based on 2008-09 expenditure
	- Equipment Hire	9,270	21,630	10,815	Includes Technical refresh
	- Food Purchase	200	300	150	Based on 2008-09 expenditure
	- Photocopying	200	300	150	Based on 2008-09 expenditure
	- Data Communications	1,742	4,065	2,032	Based on 2008-09 expenditure
	- Postages	50	100	50	Based on 2008-09 expenditure
	- Mobile Phones	2,000	3,000	1,500	Based on 2008-09 expenditure

	Total Admin costs	** 171,363	** 441,106	** 111,812

3) Direct Support Costs
	A proportion of the following:
	- Assessment Team costs	6,480	15,120		£90 per assessment x3 assessments per child
	- Fostering Team costs	126,909			No. of clients - based on 24 clients in independent foster care
	- Independent Fostering Agency costs	1,252,093
	- Emergency Team costs				No. of clients & initial assessments
	- Duty Team				No. of clients & initial assessments
	- Out of Hours Team	15000	20,000	5,000	No. of clients & initial assessments
	- Commissioning Team				No. of clients & Child placements
	- Child Protection Team				No. of clients & Reviews & visits
	Total direct support costs	** 1,400,482	** 35,120	** 5,000

4) Central/Departmental support costs
	A proportion of the following:
	- P.A.s and Admin staff costs				Services being supported
	- I.T department costs	927	2,164		No. of staff/PCs
	- Human resources dept. costs	636	1,484		No. of staff
	- Payroll dept Costs	547	1,275		No. of payslips
	- Legal dept costs				No. of cases / clients
	- Accountancy team costs	1,263	2,948		No of cost centres; journal entries, etc
	- Finance management team costs	645	1,504		No. of transactions & No of journals
	- Contracts dept costs				No. / Value / complexity of contracts
	- Training dept costs				No. of staff (weighted to allow for labour intensive services)
	- Insurance costs				No. of staff / properties
	- Other	1,785	4,165
	Total central support costs	** 5,803	** 13,540	** 0
	Total UASC costs	** 1,578,728	** 1,100,082	** 574,538

Spreadsheet's Author: Smith
Last Updated with Excel 97

** This cell's data may not be accurate.

Created with xlhtml 0.5.1