ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Calculating Full Enrollment
2
Goal: Measuring enrollment vs. Staffed Capacity
3
Licensed capacity is the number of children legally allowed to enroll in a center or home.
4
Desired capacity is the number of children a program may wish to serve, which is often fewer than licensed capacity.
5
Staffed capacity is the number of children the center/home is currently staffed to serve. It may be less than desired capacity.
6
FTE children or capacity refers to full-time equivalent children. For example, half-time children are counted as .5 FTE.
7
8
A process should be created to gather and track the following data from each participating site, on a regular basis (at least quarterly):
9
1.     Staffed capacity, as described above.
10
2.     Actual Enrollment should be reported as the monthly average for each center (by classroom), or by age in a home.
11
Note: Vacancies due to circumstances such as a child “aging up”, or slots being held for certain children: report as vacancies for that month, since even temporary gaps lead to lost revenue.
12
3.     Enrollment vs. staffed capacity – or how close enrollment is to the desired level – is calculated by dividing #2 by #1, expressed as a percentage.
13
4.     Track over time
14
5.     Identify barriers to maintaining consistent staffed capacity and full enrollment, e.g.:
15
Gaps in subsidy eligibility or part-time authorization
16
Payment gaps due to incomplete paperwork, etc.
17
Under-enrollment in 4-year-olds due to Universal PreK or Head Start availability in other locations
18
Instructions:
19
1. You can only enter data in blue cells. All other cells are locked.
20
2. Enter the staffed FTE capacity of each classroom, for each month, in lines 29-32 (add lines if necessary for more classrooms).
21
Note:if you insert more row(s), be sure the new Total Center calculation (now in row 33) includes all classrooms.
22
3. Enter the average monthly FTE enrollment in each classroom, for each month, in lines 37-40 (add lines if necessary for more classrooms).
23
Note:if you insert more row(s), be sure the new Total Center calculation (now in row 41) includes all classrooms.
24
4. All other numbers will be automatically calculated.
25
26
Calculation (example below shows 4 classrooms):
27
Staffed Capacity (see definition above):
28
Age(s)Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9 Month 10Month 11 Month 12Annual Avg.
29
Classroom 10-18888888888888
30
Classroom 22's12121212121212121212121212
31
Classroom 33's16161616161616161616161616
32
Classroom 44's20202020202020202020202020
33
Total center56565656565656565656565656
34
35
Average monthly enrollment:
36
Age(s)Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9 Month 10Month 11 Month 12Annual Avg.
37
Classroom 10-17887767887767
38
Classroom 22's12121111101212121111101211
39
Classroom 33's16151212131316141212111614
40
Classroom 44's18192020202020202016121218
41
Total center53545150505155545146404650
42
43
Enrollment as % of staffed capacity:
44
Age(s)Month 1Month 2Month 3Month 4Month 5Month 6Month 7Month 8Month 9 Month 10Month 11 Month 12
45
Classroom 10-188%100%100%88%88%75%88%100%100%88%88%75%
46
Classroom 22's100%100%92%92%83%100%100%100%92%92%83%100%
47
Classroom 33's100%94%75%75%81%81%100%88%75%75%69%100%
48
Classroom 44's90%95%100%100%100%100%100%100%100%80%60%60%
49
Total center95%96%91%89%89%91%98%96%91%82%71%82%
50
51
Average enrollment over all months
52
Classroom 10-190%
53
Classroom 22's94%
54
Classroom 33's84%
55
Classroom 44's90%
56
Total center89%
57
58
Average vacancy rate over all months
59
Classroom 10-110%
60
Classroom 22's6%
61
Classroom 33's16%
62
Classroom 44's10%
63
Total center11%
64
65
66
67
68
69
70
71
72
73
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