FY25 alternate elementary schools classrooms to save 10 to 16 to 25 sections 040325.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:	433	351	495	338	379	582	# 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	13	15	13	23	17	17	317	2578		18	20	K	19	20	19	20	18	18	317
5			14	15	14	22	18	17	20	133					19	20	19	20	18	17	17
6			13	14	13		17	18		19.4	kids per classroom				19		19		18	17
7			14		13			17												17
8
9	Total from above		54	44	53	45	52	69					available:		3	-4	4	-5	2	0	0		4		5			9
10		1	21	19	17	22	22	18	410			22	24	1	24	20	23	23	23	24	410
11			20	20	17	21	21	20	21						24	20	23	23	22	24	18
12			20	20	16		23	19							24	20	23		22	24
13			18		17			20												24
14								19
15
16	Total from above		79	59	67	43	66	96					available:		-7	1	2	3	1	0	0	7						7
17		2	23	21	20	17	20	20	405			22	26	2	25	24	26	26	26	26	405
18			23	22	20	18	21	20	20						24	24	26	26	26	26	16
19			21	21	21	16	20	20							24	24	26			26
20					20			21
21
22	Total from above		67	64	81	51	61	81					available:		6	8	-3	1	-9	-3	0			3		9	3	15
23		3	19	19	19	19	22	18	468			24	26	3	26	26	26	26	26	26	468
24			19	17	20	20	21	19	24						26	26	26	26	26	26	18
25			19	19	20	20	20	19							26		26		26	26
26			19		21			19									26			26
27					21			20
28								19
29
30	Total from above		76	55	101	59	63	114					available:		2	-3	3	-7	15	-10	0		3		7		10	20
31		4	19	17	26	21	19	19	450			24	26	4	25	25	25	25	25	25	450
32			17	17	24	21	16	20	23						25	25	25	25	25	25	18
33			18	17	24	21	18	19							25	25	25			25
34			18	16	24			20									25			25
35								19
36
37	Total from above		72	67	98	63	53	97					available:		3	8	2	-13	-3	3	0				13	3		16
38		5	23	21	24	19	21	20	528			24	26	5	26	26	25	26	25	25	528
39			21	20	24	19	21	21	25						25	25	25	25	25	25	21
40			19	21	23	21	20	21							25	25	25	25	25	25
41			22		24	18	22	21									25			25
42								21												25
43								21
44
45	Total from above		85	62	95	77	84	125					available:		-9	14	5	-1	-9	0	0	9			1	9		19
46
47																				TOTALS	after moves							86	kids to move
48																				# kids	2578						or	3.3%	of	2578	kids total
49																				# sections	108	instead of 133							to eliminate	25	classrooms
50																				or	23.9	kids per classroom				or at	$150,000	per classroom			$3,750,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	35%	25%	35%	-15%	15%	15%	21%
55	20		30%	25%	30%	-10%	10%	15%
56	20		35%	30%	35%		15%	10%
57	20		30%		35%			15%
58	24	1	13%	21%	29%	8%	8%	25%	19%
59	24		17%	17%	29%	13%	13%	17%
60	24		17%	17%	33%		4%	21%
61	24		25%		29%			17%
62	26							21%
63	26	2	12%	19%	23%	35%	23%	23%	22%
64	26		12%	15%	23%	31%	19%	23%
65	26		19%	19%	19%	38%	23%	23%
66	26				23%			19%
67	26	3	27%	27%	27%	27%	15%	31%	25%
68	26		27%	35%	23%	23%	19%	27%
69	26		27%	27%	23%	23%	23%	27%
70	26		27%		19%			27%
71	26				19%			23%
72	26							27%
73	26	4	27%	35%	0%	19%	27%	27%	25%
74	26		35%	35%	8%	19%	38%	23%
75	26		31%	35%	8%	19%	31%	27%
76	26		31%	38%	8%			23%
77	26							27%
78	26	5	12%	19%	8%	27%	19%	23%	19%
79	26		19%	23%	8%	27%	19%	19%
80	26		27%	19%	12%	19%	23%	19%
81	26		15%		8%	31%	15%	19%
82	26							19%
83	26							19%
84		Average per school:	24%	25%	21%	20%	19%	22%	22%
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100