FY26 alternate elementary schools classrooms to save 6 to 9 to 14 sections 100925.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1		Actual enrollments 12/19/2024 per Maureen Kavanaugh							Total/school	6 schools				Alternate assignments to minimize # sections							TOTALS	# kids moving to another school
2		Total from below:	421	349	468	283	364	540	# kids	# kids		# kids/classroom									# kids	from	from	from	from	from	from	from
3		Grade	Bowman	Bridge	Estabrook	Fiske	Harrington	Hastings	# sections	# sections		Preferred	Maximum	Grade	Bowman	Bridge	Estabrook	Fiske	Harrington	Hastings	# sections	Bowman	Bridge	Estabrook	Fiske	Harrington	Hastings	All schools

4		K	17	14	20	18	16	19	307	2425		18	20	K	19	20	20	19	20	19	307
5			18	15	20	17	15	18	18	121					19	20	19	19	20	19	16
6			18	15	18		15	17		20.0	kids per classroom				18		19			19
7								17												18
8
9	Total from above		53	44	58	35	46	71					available:		3	-4	0	3	-6	4	0		4			6		10
10		1	22	18	19	15	20	19	347			22	24	1	22	24	19	24	20	24	347
11			22	18	18	14	19	19	19						22	24	19	24	19	24	16
12			21	17	17	14	19	18							20		19		19	24
13								18
14
15
16	Total from above		65	53	54	43	58	74					available:		-1	-5	3	5	0	-2	0	1	5				2	8
17		2	21	21	24	19	24	20	420			22	26	2	26	21	24	21	24	26	420
18			20	20	24	19	24	20	20						26	20	24	20	24	26	18
19			20	20	23		24	19							26	20	23		24	26
20			20					19												19
21								19
22	Total from above		81	61	71	38	72	97					available:		-3	0	0	3	0	0	0	3						3
23		3	24	22	22	16	21	22	410			24	26	3	24	22	22	26	21	26	410
24			23	21	20	16	21	21	20						24	21	20	26	21	26	18
25			22	21	20	16	21	21							23	21	20		21	26
26					20			20									20
27
28
29
30	Total from above		69	64	82	48	63	84					available:		2	0	0	4	0	-6	0						6	6
31		4	21	19	20	21	23	24	477			24	26	4	21	26	26	26	24	24	477
32			20	18	20	20	23	24	23						20	26	26	26	24	24	20
33			20	18	20	18	22	23							20		26		24	23
34			19		20			23							19		26			23
35					18			23												23
36
37	Total from above		80	55	98	59	68	117					available:		0	-3	6	-7	4	0	0		3		7			10
38		5	25	24	23	21	19	25	464			24	26	5	24	24	24	26	26	24	464
39			24	24	21	20	19	24	21						24	24	24	26	26	24	19
40			24	24	21	19	19	24							24	24	24			24
41					20			24									24			24
42					20												24
43
44
45	Total from above		73	72	105	60	57	97					available:		-1	0	15	-8	-5	-1	0	1			8	5	1	15
46
47																				TOTALS	after moves							52	kids to move
48																				# kids	2425						or	2.1%	of	2425	kids total
49																				# sections	107	instead of	121						to eliminate	14	classrooms
50																				or	22.7	kids per classroom				or at	$150,000	per classroom			$2,100,000	saved
51		Actual enrollments 12/19/2024 per Maureen Kavanaugh
52	Maximal capacity		% of each classroom's maximal capacity that is empty						Average per
53	per grade	Grade	Bowman	Bridge	Estabrook	Fiske	Harrington	Hastings	grade
54	20	K	15%	30%	0%	10%	20%	5%	15%
55	20		10%	25%	0%	15%	25%	10%
56	20		10%	25%	10%		25%	15%
57	20							15%
58	24	1	8%	25%	21%	38%	17%	21%	24%
59	24		8%	25%	25%	42%	21%	21%
60	24		13%	29%	29%	42%	21%	25%
61	24							25%
62	26
63	26	2	19%	19%	8%	27%	8%	23%	19%
64	26		23%	23%	8%	27%	8%	23%
65	26		23%	23%	12%		8%	27%
66	26		23%					27%
67	26	3	8%	15%	15%	38%	19%	15%	21%
68	26		12%	19%	23%	38%	19%	19%
69	26		15%	19%	23%	38%	19%	19%
70	26				23%			23%
71	26
72	26
73	26	4	19%	27%	23%	19%	12%	8%	20%
74	26		23%	31%	23%	23%	12%	8%
75	26		23%	31%	23%	31%	15%	12%
76	26		27%		23%			12%
77	26				31%			12%
78	26	5	4%	8%	12%	19%	27%	4%	15%
79	26		8%	8%	19%	23%	27%	8%
80	26		8%	8%	19%	27%	27%	8%
81	26				23%			8%
82	26				23%
83	26
84		Average per school:	15%	22%	18%	29%	18%	16%	19%
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100