Sheet1

UASC costs monitoring template

	Number of days support	85,866		19,035	38,462	28,369

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

1) Direct costs:
	- Accommodation - Independent foster care	E29*	3,998,298	1,461,735	1,751,266	785,298	These are the total actual costs incurred by the Authority for the 2008/09 financial year for all eligible children.
	- Accommodation - in-house foster care	D50000	405,424	269,374	135,438	611
	- Accommodation - Residential Homes		0
	- Accommodation - Semi independent		0
	- Accommodation - independent rentals	B22000	266	0	0	266
	- Additional Fostering costs		0
	- Subsistence costs	D62000	561,416	15,650	308,621	237,144
	- Weekly Travel costs	C21000	99,416	24,867	39,562	34,988
	- Birthday Allowance		0
	- Religious Festival Allowance		0
	- Winter Fuel Allowance	D62500	575	0	0	575
	- Clothing Allowance	D91000	15,160	4,922	9,398	839
	- Interpreters costs	D51000	133,377	56,483	65,111	11,784
	- Official documents costs		0
	- Legal costs		0
	- School Dinners costs		0
	- School Trips / activities		0
	- Educational equipment		0
	- Setting Up costs - post 18s		0
	- Electricity bills		0
	- Gas bills		0
	- TV Licences		0
	- Recreational support costs (e.g. bikes, etc)	D10000	12,029	1,047	955	10,027
	Total Direct Costs		5,225,960	1,834,078	2,310,351	1,081,531

2) Direct Administration Costs (Asylum Team costs)

	Salary costs	A12, A2	772,122	270,980	341,348	159,793	The Team costs shown are total actual costs for the 2008/09 financial year and include all management and administration staff, social workers and support workers. Team costs have been apportioned across age groups on the basis of number of days support as the social work team is not structured according to age groups. There is no direct charge for rental/office accommodation as these costs are held centrally as part of the Authority's Strategic Land and Property division - shown below as Council Offices and Administrative Buildings. The office rental charge (£90) relates to the cost of hiring meeting rooms.
	Agency staff costs	A35000	452,861	158,934	200,206	93,721
	other employee costs (recruitment, insurance)	A34, A39	7,823	2,746	3,458	1,619
	NRUC subscription costs	D92000	24,494	8,596	10,829	5,069
	Office rental	H20904	90	32	40	19
	Council tax / Business rates	B20000	5,544	1,946	2,451	1,147
	- Electricity bills	B11000	1,794	630	793	371
	- Water bills	B12000	1,215	426	537	251
	- Gas bills	B10000	2,409	845	1,065	499
	- Staff travel	C	37,012	12,990	16,363	7,660
	- Staff Training	A32000	185	65	82	38
	- Staff subsistence	D61	323	113	143	67
	- Stationery costs	D41	3,967	1,392	1,754	821
	- Printing costs	H20900	135	47	60	28
	- cleaning, repairs, maintenance	B30, B40	18,138	6,366	8,019	3,754
	- Office equipment	D	25,576	8,976	11,307	5,293
	- Telephone costs	D30000	15,927	5,590	7,041	3,296
	- Other		9,876	3,466	4,366	2,044
	Total Admin Costs		1,379,491	484,140	609,861	285,491

3) Direct Support Costs
	A proportion of the following:						All direct support costs shown are total actual costs for the 2008/09 financial year. The notes below state how the total cost chargeable to UASC has been calculated. This total cost has then been apportioned across the age groups on the basis of number of days support.
	- Assessment Team costs		0	0	0	0	The costs for assessment are included within the costs of the social work team above.
	- Fostering Team costs	176,331	176,331	39,090	78,984	58,257	Apportioned on the basis of the number of weeks of foster care during the year (25.78%). Also includes cost of NVQ payments to foster carers.
	- Emergency Team costs	66,094	66,094	14,652	29,606	21,837	Equivalent to 1 FTE (average salary of a team of 4 social workers).
	- Duty Team		0	0	0	0	Included as Emergency Team costs.
	- Out of Hours Team		0	0	0	0	Included as Emergency Team costs.
	- Commissioning Team	107,005	107,005	23,721	47,931	35,353	Apportioned on the basis of the number of placement searches undertaken during the year (35.28%)
	- Child Protection Team	33,863	33,863	7,507	15,168	11,188	Cost of the Head of Child Protection and administrative support apportioned on the basis of the number of UASC as a percentage of the Authority's total number of looked after children (41.04%)
	- Child Management	5,597	5,597	1,241	2,507	1,849	The cost of senior management of Children's Services charged on the basis of time dedicated to UASC work/issues.
	- Provider Management (Specialist Sector)	22,313	22,313	4,946	9,995	7,372	Apportioned on the basis of the number of placement searches undertaken during the year (35.28%)
	- Child Welfare Service	24,131	24,131	5,349	10,809	7,973	Child Welfare team manager (30%) and Education Welfare Officer (5%) charged on the basis of time dedicated to UASC work/issues.
	- Research and Policy unit	20,047	20,047	4,444	8,980	6,623	2 Research/Policy officers charged on the basis of time dedicated to UASC work/issues.
	- Corporate Parenting Team	35,975	35,975	11,910	24,065		Cost of Corporate Parenting Team apportioned on the basis of the number of UASC as a percentage of the Authority's total number of looked after children (41.04%)
	- Education Induction Programme	280,000	280,000	92,697	187,303
	- Youth Service	21,000	21,000	6,952	14,048
	- English as a Second Language	50,000	50,000	16,553	33,447		Estimated at 30% of the total gross cost of the service.
	- Connexions/16+	16,000	16,000		9,208	6,792
	- Education Psychologists	10,000	10,000	3,311	6,689
	- Admission/Children Missing Education	4,000	4,000	1,324	2,676		Estimated at 15% of total CME caseload per annum
	- Direct Payments to Schools	10,000	10,000	3,311	6,689
	Total Direct Support Costs	882,357	882,357	237,008	488,105	157,244

4) Central/Departmental support costs							Unless otherwise stated all overhead costs have been apportioned on the basis of FTE - firstly to calculate the total charge to Children's Services (35.29%) and subsequently to charge these costs to individual Children's teams (6.61%)
	A proportion of the following:
	- P.A.s and Admin staff costs		0
	- I.T department costs	121,089	121,089	26,843	54,239	40,006
	- Human resources dept. costs	37,272	37,272	8,263	16,695	12,314
	- Payroll dept Costs		0				Payroll costs are included within the costs for HRE.
	- Legal dept costs	19,289	19,289	4,276	8,640	6,373	Based on actual costs for the Council's legal team and an apportionment of an Advocacy scheme based on activity in 2008/09 (47%)
	- Accountancy team costs	77,209	77,209	17,116	34,584	25,509	Including the cost of accountancy, accounts payable, and financial systems.
	- Finance management team costs		0
	- Contracts dept costs	8,576	8,576	1,901	3,841	2,833
	- Training dept costs	15,443	15,443	3,423	6,917	5,102	2 Social Worker Trainers charged on the basis of the number of UASC as a percentage of the Authority's total number of looked after children (41.04%). Other training costs available for all staff have been apportioned on the basis of FTE as stated above.
	- Insurance costs	222	222	49	99	73	The cost of the Authority's Insurance team - all direct insurance costs (apportionment of insurance premiums) are shown as part of the social work team costs.
	- Management	9,025	9,025	2,001	4,043	2,982
	- Customer Services	17,603	17,603	3,902	7,885	5,816	This relates to the cost of Solihull Connect - the Council's front line customer services team, who deal with all incoming queries to the Council.
	- Council Offices and Administrative Buildings	53,330	53,330	11,822	23,888	17,620	The cost of the Authority's Council offices and other administrative buildings for the above staff apportioned on the basis of FTE as stated above.
	- Communications	8,534	8,534	1,892	3,823	2,820	Including the cost of the Authority's complaints service, consultation, and Internet.
	- Corporate Performance, Policy and Information	43,251	43,251	9,588	19,373	14,290	This includes the cost of the Council's children's information management system (Carefirst) and the monitoring of Council performance data.
	Total Central Support Costs	410,843	410,843	91,077	184,029	135,737
	Total UASC Costs		7,898,651	2,646,303	3,592,346	1,660,003

Spreadsheet's Author: Smith
Last Updated with Excel 97

Created with xlhtml 0.5.1