FULLY Populated DTF FY12 with Cohort Reset v8.xls

	A	B	F	G	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1		NASD School Board Data Task Force - file is: FULLY Populated DTF FY12 with Cohort Reset V8.xls
2	1			SPENT	BUDGETED	8
3	2	Official DOE Fiscal Year /Results:		FY11-12	FY12-13		FY11-12		FY11-12		FY11-12		FY11-12		FY11-12		FY11-12
4	3	District Name:		Newfound	Newfound		Farmington		Hillsbr-Deering		Inter-Lakes		Mascenic		White Mtn		Winnisquam
5	4	Total Student Count:	1	1228	1259	1	1303	4	1298		1081	4	1097		1252	4	1448
6	5	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
7	6							6		6		6		6		6		6
8	7	Fund 10 General Fund		$ 21,742,398	$ 20,234,671		$ 16,252,693		$ 20,018,625		$ 19,307,899		$ 16,187,097		$ 17,221,028		$ 22,341,661

9	8	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
10	9	Annual rate of incr in Fund 10		5.2%	-6.9%		#REF!		#REF!		1.0%		#REF!		#REF!		#REF!
11	10	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
12	11	Fund 21 Food Service		$ 634,266	$ 574,906		$ 536,746		$ 613,076		$ 417,718		$ 431,008		$ 540,617		$ 619,203
13	12	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
14	13	Fund 22 Federal Grants		$ 1,590,100	$ 1,356,505		$ 1,863,620		$ 1,845,420		$ 572,388		$ 689,886		$ 1,160,391		$ 1,063,982
15	14	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
16	15	Gross Expenditures		$ 23,966,764	$ 22,166,082		$ 18,653,058		$ 22,477,121		$ 20,298,005		$ 17,307,991		$ 18,922,036		$ 24,024,845
17	16	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
18	17
19	18	State Defined Costs	2			2
20	19	High School		$ 6,747,577	$ 6,312,629		$ 4,839,902		$ 6,479,115		$ 5,862,207		$ 4,277,002		$ 5,997,976		$ 6,170,181
21	20	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
22	21	Middle School		$ 4,689,801	$ 4,552,412		$ -		$ 4,494,188		$ -		$ 3,960,789		$ -		$ 4,681,981
23	22	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
24	23	Elementary School		$ 9,056,289	$ 7,251,483		$ 10,617,624		$ 8,182,576		$ 12,462,753		$ 4,259,740		$ 10,487,064		$ 7,872,449
25	24	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
26	25	TOT (State Defined Costs)		#ERROR!	$ 18,116,524		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
27	26	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
28	27
29	28	TOT Teachers (FTE) Per State		112	103.6		103		109.3		90.6		82.9		112.7		115
30	29	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
31	30	Guidance Counselors		7.8	6.8		6		4.5		5.1		5		6		6
32	31	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
33	32	Nurses		6	6		3		4		3		3		4		5
34	33	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
35	34	Administrators		10.6	9.6		12		17		13		13		9		13
36	35	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
37	36	Support Staff		155	144		219		61		121	*	58.6		60		136.8		*=Food Service Contracted, Not Counted
38	37	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
39	38
40	39	TOT Employees		#ERROR!	284		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
41	40	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
42	41
43	42
44	43	TOT Cost of Benefits-Fund 10		$ 5,698,406	$ 4,490,996		$ 2,867,548		$ 4,544,555		$ 4,997,389		$ 3,055,326		$ 4,355,474		$ 4,501,727
45	44	(Obj 200) rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
46	45
47	46	Number of Buildings		6	6		4		4		4		3		5		5
48	47
49	48	TOT Physical Plant Costs (Fund 10)		$ 1,472,780	$ 1,502,827		$ 1,419,223		$ 1,913,650		$ 1,958,204		$ 1,516,913		$ 1,888,796		$ 2,229,518
50	49	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
51	50
52	51	TOT Transport Costs (Fund 10)		$ 1,440,384	$ 1,273,634		$ 556,829		$ 751,412		$ 855,013		$ 749,221		$ 1,027,240		$ 916,540
53	52	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
54	53
55	54	No. of SpEd STDT (504's, IEP's)		188	186		263		215		212		198		168		209
56	55	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
57	56
58	57
59	58	TOT SpEd Costs - Fund 10		$ 6,307,572	$ 5,461,156		$ 5,038,330		$ 5,251,476		$ 4,305,856		$ 2,587,233		$ 3,467,865		$ 4,848,934
60	59	(Func.1200 & 2100) rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
61	60
62	61	SpEd Purch'd SVCs - Fund 10		$ 1,440,882	$ 1,049,097		$ 1,348,247		$ 782,058		$ 351,745		$ 687,339		$ 346,419		$ 1,320,512
63	62	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
64	63	SpEd Purch'd SVCs - Fund 22		$ 144,074	$ 133,303		$ 81,615		$ -		$ -		$ 161,718		$ 108,150		$ 74,898
65	64	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
66	65	SpEd Purch'd SVCs		#ERROR!	$ 1,182,400		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
67	66	(Fnc.1200, 2100 Ob300,400,500) rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
68	67
69	68	Revenues - General Fund (10)
70	69	Local Assessment		$ 12,900,052	$ 10,875,212		$ 3,814,432		$ 10,323,331		$ 12,558,829		$ 6,408,320		$ 6,682,433		$ 11,214,480
71	70	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
72	71	Equitable Education Aid		$ 3,783,498	$ 3,786,776		$ 6,832,335		$ 6,181,293		$ 248,765		$ 5,411,690		$ 6,749,536		$ 6,330,176
73	72	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
74	73	Statewide Enhanced Ed Tax		$ 4,143,434	$ 4,236,576		$ 1,089,394		$ 1,649,604		$ 6,353,570		$ 1,241,270		$ 2,391,799		$ 2,962,333
75	74	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
76	75	Other State & Local Aid		$ 368,892	$ 173,083		$ 294,648		$ 28,878		$ 136,867		$ 1,662,442		$ 297,496		$ 559,074
77	76	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
78	77	Catastrophic Aid		$ 114,300	$ 128,886		$ 152,744		$ 216,507		$ 22,347		$ 113,650		$ 106,959		$ 110,838
79	78	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
80	79	Medicaid		$ 314,677	$ 211,878		$ 188,077		$ 85,186		$ 75,624		$ 131,739		$ 92,825		$ 238,609
81	80	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
82	81	School Building Aid		$ 97,426	$ 97,426		$ 373,817		$ 368,556		$ 180,626		$ 1,448,151		$ 187,571		$ 833,682
83	82	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
84	83	Tuition Received		$ 70,380	$ 31,792		$ 3,169,416		$ 1,487,482		$ 60,731		$ 144,867		$ 593,439		$ 175,462
85	84	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
86	85	Vocational Transport Aid		$ 5,777	$ 6,897		$ 3,891		$ 13,817		$ 10,584		$ 2,750		$ 24,882		$ 9,589
87	86	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
88	87	TOT Fund 10 Revenues		#ERROR!	$ 19,548,526		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
89	88	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
90	89
91	90	Per Student
92	91	State Defined Costs	2			2
93	92	High School ($/STDT)		$ 13,398	TBD		$ 9,937		$ 13,652		$ 10,058		$ 11,161		$ 14,120		$ 13,432
94	93	rank		3			6		5		1		2		4		7
95	94	Middle School ($/STDT)		$ 12,428	TBD		$ 1		$ 13,086		$ 9,037		$ 11,361		$ 1		$ 13,516
96	95	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!
97	96	Elementary School ($/STDT)		$ 12,800	TBD		$ 10,790		$ 14,357		$ 10,121		$ 10,322		$ 12,550		$ 12,543
98	97	rank		3			6		5		1		2		4		7
99	98	TOT ($/STDT)		$ 12,952	TBD		$ 10,514		$ 13,808		$ 9,757		$ 10,926		$ 13,093		$ 13,069
100	99	rank		#ERROR!			#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!		#ERROR!