sample enrollment rollover 2023-2026.xlsx

	A	B	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	T	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AL	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BD	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BV	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL
1			FY22																FY23																FY24																FY25																FY26
2			PK	K	1	2	3	4	5	6	7	8	9	10	11	12	Total		PK	K	1	2	3	4	5	6	7	8	9	10	11	12	Total		PK	K	1	2	3	4	5	6	7	8	9	10	11	12	Total		PK	K	1	2	3	4	5	6	7	8	9	10	11	12	Total		PK	K	1	2	3	4	5	6	7	8	9	10	11	12	Total
3		NHS / Northstar											396	386	388	383	1,553	NHS / Northstar											412	396	386	388	1,582	NHS / Northstar											435	412	396	386	1,629	NHS / Northstar											410	435	412	396	1,653	NHS / Northstar											413	410	435	412	1670
4		KENNEDY							226	204	232	189					851	KENNEDY							203	226	204	232					865	KENNEDY							240	203	226	204					873	KENNEDY							212	240	203	226					881	KENNEDY							194	212	240	203					849
5		WILSON							187	206	203	223					819	WILSON							191	187	206	203					787	WILSON							181	191	187	206					765	WILSON							170	181	191	187					729	WILSON							166	170	181	191					708
6		BEN-HEM		22	18	19	20	23										BEN-HEM		21	22	18	19	20										BEN-HEM		22	21	22	18	19										BEN-HEM		22	22	21	22	18										BEN-HEM		21	22	22	21	22
7				22	17	20	20	22												21	22	17	20	20												22	21	22	17	20												22	22	21	22	17												20	22	22	21	22
8				22	20	17	19	21												21	22	20	17	19												22	21	22	20	17												22	22	21	22	20												20	22	22	21	22
9				23	20	19	19	22												21	23	20	19	19												21	21	23	20	19												21	21	21	23	20												20	21	21	21	23
10				22	18	20	20	22												22	22	18	20	20												21	22	22	18	20												21	21	22	22	18												20	21	21	22	22
11
12		Total:		111	93	95	98	110									507	Total:		106	111	93	95	98									503	Total:		108	106	111	93	95									513	Total:		108	108	106	111	93									526	Total:		101	108	108	106	111									534
13
14
15		BROWN		20	18	20	20	20										BROWN		21	20	18	20	20										BROWN		22	21	20	18	20										BROWN		22	22	21	20	18										BROWN		21	22	22	21	20
16				20	15	20	20	19												21	20	15	20	20												22	21	20	15	20												22	22	21	20	15												20	22	22	21	20
17				19	17	19	21	20												21	19	17	19	21												22	21	19	17	19												22	22	21	19	17												20	22	22	21	19
18				19	15	20	20	16												21	19	15	20	20												21	21	19	15	20												21	21	21	19	15												20	21	21	21	19
19				19	16	20	20													21	19	16	20	20												21	21	19	16	20												21	21	21	19	16												20	21	21	21	19
20
21		Total:		97	81	99	101	75									453	Total:		105	97	81	99	101									483	Total:		108	105	97	81	99									490	Total:		108	108	105	97	81									499	Total:		101	108	108	105	97									519
22
23
24		JOHNSON		22	20	19	22	18										JOHNSON			22	20	19	22										JOHNSON				22	20	19										JOHNSON					22	20										JOHNSON						22
25				22	19	18	24	18													22	19	18	24														22	19	18															22	19																22
26								17
27
28		Total:		44	39	37	46	53									219	Total:			44	39	37	46									166	Total:				44	39	37									120	Total:					44	39									83	Total:						44									44
29
30
31		LILJA		19	18	19	20	20										LILJA		21	19	18	19	20										LILJA		22	21	19	18	19										LILJA		22	22	21	19	18										LILJA		21	22	22	21	19
32				19	19	19	21	20												21	19	19	19	21												21	21	19	19	19												22	21	21	19	19												20	22	21	21	19
33				18	19	18	21	20												21	18	19	18	21												21	21	18	19	18												21	21	21	10	19												20	21	21	21	10
34				19			21	21												21			19	21												21			17	19												21			20	17												20			21	20
35		Combo Classes:			8	10												Combo Classes:			10	8												Combo Classes:			10	10												Combo Classes:			11	10												Combo Classes:			10	11
36		Combo Classes:			9	9												Combo Classes:			9	9												Combo Classes:			11	9												Combo Classes:			10	11												Combo Classes:			11	10
37
38		Total:		75	73	75	83	81									387	Total:		84	75	73	75	83									390	Total:		85	84	75	73	75									392	Total:		86	85	84	68	73									396	Total:		81	86	85	84	68									404
39
40
41		MEMORIAL		20	19	18	20	19										MEMORIAL		21	20	19	18	20										MEMORIAL		22	21	20	19	18										MEMORIAL		21	22	21	20	19										MEMORIAL		20	21	22	21	20
42				20	19	19	17	18												21	20	19	19	17												22	21	20	19	19												22	22	21	20	19												20	22	22	21	20
43				19	18	19	19	19												21	19	18	19	19												22	21	19	18	19												22	22	21	19	18												20	22	22	21	19
44				19	18	20	19	19												21	19	18	20	19												22	21	19	18	20												21	22	21	19	18												20	21	22	21	19
45							18																	18
46
47		Total:		78	74	76	93	75									396	Total:		84	78	74	76	93									405	Total:		88	84	78	74	76									400	Total:		86	88	84	78	74									410	Total:		80	86	88	84	78									416
48
49
50		PRE-K NHS	94															PRE-K NHS	94														94	PRE-K NHS	94															PRE-K NHS	94															PRE-K NHS	94
51		PRE-K LIL	28															PRE-K LIL	28														28	PRE-K LIL	28															PRE-K LIL	28															PRE-K LIL	28
52		PRE-K-MEM	15															PRE-K-MEM	15														15	PRE-K-MEM	15															PRE-K-MEM	15															PRE-K-MEM	15
53		Total:	137	405	360	382	421	394	413	410	435	412	396	386	388	383	5,322	Total:	137	379	405	360	382	421	394	413	410	435	412	396	386	388	5,318	Total:	137	389	379	405	360	382	421	394	413	410	435	412	396	386	5,319	Total:	137	388	389	379	398	360	382	421	394	413	410	435	412	396	5314	Total:	137	363	388	389	379	398	360	382	421	394	413	410	435	412	5281
54
55	Birthrate 5 years ago
56
57	Born	Enter K
58	2016 - 414	21-22
59	2017 - 379	22-23
60	2018 - 389	23-24
61	2019 - 388	24-25
62	2020 - 363	25-26
63	2021 - 258	26-27
64
65	Assumed 100% of Natick births matriculated 5 years from birth year
66	typically we assume 90% of births to K
67
68
69
70	Take-aways
71	In FY24 there would be only 120 students @ Johnson if Johnson does not fully close then
72
73	Difference in student popolation at Kennedy v. Wilson grows from 32 (FY22) to 152 (FY25) assuming Johnson remains open and BR, JO, and ME are districted to Kennedy
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100