Regulated* Provider Fees Worksheet by Care Type and County/Region
County/Region Code Example Example Example Example Example 1 County 1 County 1 County 1 County 1 County 2 County 2 County 2 County 2 County 2 County 3 County 3 County 3 County 3 County 3 County 4 County 4 County 4 County 4 County 4 County 5 County 5 County 5 County 5 County 5 County 6 County 6 County Facility Max. Total Enrollment Enrollment Enrollment Enrollment Type of Care Code Count/Co. Capacity Vacancy Enrollment Infant Toddler Preschool School-age DCC 79 5689 569 5120 614 973 3021 512 FDC 140 1041 0 1041 GFDC 34 456 0 456 SACC 58 3895 0 3895 SACC Summer 58 3895 0 3895 DCC 0 FDC 0 GFDC 0 SACC 0 SACC (Summer) 0 DCC 0 FDC 0 GFDC 0 SACC 0 SACC (Summer) 0 DCC 0 FDC 0 GFDC 0 SACC 0 SACC (Summer) 0 DCC 0 FDC 0 GFDC 0 SACC 0 SACC (Summer) 0 DCC 0 FDC 0 GFDC 0 SACC 0 SACC (Summer) 0 DCC 0 FDC 0 Average Price $ 160 $ 143 $ 154 $ 25 $ 150
6 County 6 County 6 County 7 County 7 County 7 County 7 County 7 County 8 County 8 County 8 County 8 County 8 County 9 County 9 County 9 County 9 County 9 County 10 County 10 County 10 County 10 County 10 County 11 County 11 County 11 County 11 County 11 County 12 County 12 County 12 County 12 County 12 County 13 County 13 County 13 County 13 County
GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
13 County 14 County 14 County 14 County 14 County 14 County 15 County 15 County 15 County 15 County 15 County 16 County 16 County 16 County 16 County 16 County 17 County 17 County 17 County 17 County 17 County 18 County 18 County 18 County 18 County 18 County 19 County 19 County 19 County 19 County 19 County 20 County 20 County 20 County 20 County 20 County 21 County
SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 County 21 County 21 County 21 County 22 County 22 County 22 County 22 County 22 County 23 County 23 County 23 County 23 County 23 County 24 County 24 County 24 County 24 County 24 County 25 County 25 County 25 County 25 County 25 County
FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer) DCC FDC GFDC SACC SACC (Summer)
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Code DCC = Day Care Center (or Child Care Center) Code FDC = Family Day Care (or Family Child Care) Code GFDC = Group Family Day Care (or Group Family Child Care) Code SACC= School Age Child Care
*Un-regulated care (such as friend, family and neighbor care, nursery schools, nannies, private summer camps, etc.) are not included. If your state/region has data on unregulated care - please feel free to adapt tool as needed. Back to Methodology Guide
Age Under 1 1/2 Age 1 1/2 - 2 Age 3 to 5 $ 176 $ 165 $ 150 $ 150 $ 150 $ 135 $ 165 $ 150 $ 150
County Weekly County Yearly Total Age 6 to 12 Total $ 150 $ 798,559 $ 41,525,068 DCC $ 135 $ 148,343 $ 7,713,810 FDC $ 150 $ 70,110 $ 3,645,720 GFDC $ 25 $ 97,375 $ 3,895,000 SACC $ 150 $ 584,250 $ 7,011,000 Total $ $ DCC $ $ FDC $ $ GFDC $ $ SACC $ $ Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ -
$ $ $ $ $ $ $ $ $ $
41,525,068 7,713,810 3,645,720 10,906,000 63,790,598 -
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
-
Notes on the work sheet Grey Cells with Blue Numbers are data cells White Cells with Black Numbers are formula Cells
*This data sheet assumes providers are open 52 wks/yr. You can lower the number of weeks based on your own d *For child care centers, prices vary by age of child and are multiplied by the number of children in each age group. *For family child care, prices may vary by child but state licensing data typically does not disaggregate. If you have specific data, you should disaggregate. *For school age child care be careful to distinguish full day rates (holidays and summers - we assume 12 weeks) from partial day rates (we assumed 40 weeks). SACC is split into two groups, summer and school year. Engineering estimates such as this, may overstate provider revenues if you do not take vacancies into account. See Methodology guide p.20 For more discussion. Brian make this a hotlink
Notes on the work sheet Grey Cells with Blue Numbers are data cells White Cells with Black Numbers are formula Cells
*This data sheet assumes providers are open 52 wks/yr. You can lower the number of weeks based on your own data. *For child care centers, prices vary by age of child and are multiplied by the number of children in each age group. *For family child care, prices may vary by child but state licensing data typically does not disaggregate. If you have specific data, you should disaggregate. *For school age child care be careful to distinguish full day rates (holidays and summers - we assume 12 weeks) from partial day rates (we assumed 40 weeks). SACC is split into two groups, summer and school year. Engineering estimates such as this, may overstate provider revenues if you do not take vacancies into account. See Methodology guide p.20 For more discussion. Brian make this a hotlink
on your own data.