ABCDEFMNOPQRSTUVWXYZ
1
Charles City
2
DEPARTMENT OF MANAGEMENT
3
LOCAL BUDGETS DIVISION - SCHOOLS
4
FINAL FISCAL YEAR 2023 CHAPTER 257 SCHOOL BUDGET AID AND LEVY
5
Valuations for School Year 2022-2023 Statutory Minimum State Aid is $300
6
#ERROR!
7
School District Name Charles City
8
9
AMOUNTSECTION LINE DESCRIPTION
10
BUDGET ENROLLMENT
11
#ERROR!*1.1Budget Enrollment (Oct 2021 Budget Enrollment)
12
#ERROR!***1.2Audited Change in Oct 2020 Certified Enrollment
13
X#ERROR!1.3FY22 Regular Program District Cost Per Pupil (Line 2.3 - FY22 Aid & Levy)
14
=#ERROR!1.4Enrollment Audit Adjustment
15
#ERROR!1.5FY22 Regular Program Foundation Cost Per Pupil
16
X#ERROR!***1.6Audited Change in Oct 2020 Certified Enrollment (Line 1.2)
17
=#ERROR!1.7Enrollment Audit Adjustment - State Aid Portion
18
#ERROR!COST PER PUPIL AMOUNTS
19
#ERROR!2.1FY22 Regular Program District Cost Per Pupil (Line 1.3)
20
+#ERROR!2.2FY23 Regular Program Supplemental State Aid Amount Per Pupil
21
=#ERROR!2.3FY23 Regular Program District Cost Per Pupil - Minimum $7,413
22
#ERROR!**2.4FY22 Teacher Salary Supplement Cost Per Pupil (Line 2.6 - FY22 Aid & Levy)
23
+#ERROR!**2.5FY23 Teacher Salary Supplement Supplemental State Aid Amount Per Pupil
24
=#ERROR!**2.6FY23 Teacher Salary Supplement Cost Per Pupil
25
#ERROR!**2.7FY22 Professional Dev Suppl Cost Per Pupil (Line 2.9 - FY22 Aid & Levy)
26
+#ERROR!**2.8FY23 Professional Development Supplement Supplemental State Aid Amt Per Pupil
27
=#ERROR!**2.9FY23 Professional Development Supplement Cost Per Pupil
28
#ERROR!**2.10FY22 Early Intervention Suppl Cost Per Pupil (Line 2.12 - FY22 Aid & Levy)
29
+#ERROR!**2.11FY23 Early Intervention Supplement Supplemental State Aid Amount Per Pupil
30
=#ERROR!**2.12FY23 Early Intervention Supplement Cost Per Pupil
31
#ERROR!**2.13FY22 Teacher Leadership Suppl Cost Per Pupil (Line 2.15 - FY22 Aid & Levy)
32
+#ERROR!**2.14FY23 Teacher Leadership Supplement Supplemental State Aid Amount Per Pupil
33
=#ERROR!**2.15FY23 Teacher Leadership Supplement Cost Per Pupil
34
#ERROR!WEIGHTED ENROLLMENT
35
#ERROR!**3.10.72 Special Ed Weighting in Addition to 1.0
36
+#ERROR!**3.21.21 Special Ed Weighting in Addition to 1.0
37
+#ERROR!**3.32.74 Special Ed Weighting in Addition to 1.0
38
=#ERROR!**3.4Total Special Ed Weighting in Addition to 1.0
39
+#ERROR!*3.5Budget Enrollment (Line 1.1)
40
=#ERROR!**3.6AEA Weighted Enrollment
41
+#ERROR!**3.7AEA Supplementary Weight for Sharing
42
=#ERROR!**3.8AEA Weighted Enrollment with AEA Supplementary Weight for Sharing
43
+#ERROR!***3.9Supplementary Weighting - Sharing
44
+#ERROR!***3.10Supplementary Weighting - At-Risk Formula
45
+#ERROR!**3.11Supplementary Weighting - ELL
46
+#ERROR!***3.12Supplementary Weighting - Reorganization Incentives
47
=#ERROR!***3.13Total Supplementary Weighting
48
+#ERROR!**3.14AEA Weighted Enrollment (Line 3.6)
49
=#ERROR!***3.15District Weighted Enrollment
50
-#ERROR!**3.16Total Special Ed Weighting in Addition to 1.0 (Line 3.4)
51
=#ERROR!***3.17District Weighted Enrollment without Special Ed Weightings
52
#ERROR!REGULAR PROGRAM DISTRICT COST CALCULATIONS
53
#ERROR!4.1FY23 Regular Program District Cost Per Pupil (Line 2.3)
54
X#ERROR!*4.2Budget Enrollment (Line 1.1)
55
=#ERROR!4.3FY23 Regular Program District Cost without Adjustment
56
#ERROR!4.4FY22 Regular Program District Cost (Line 4.3 - FY22 Aid & Levy)
57
X#ERROR!**4.5101% Budget Adjustment
58
=#ERROR!4.6101% of FY22 Regular Program District Cost
59
-#ERROR!4.7FY23 Regular Program District Cost without Adjustment (Line 4.3)
60
=#ERROR!4.8FY23 Regular Program Budget Adjustment (if negative, enter zero)
61
#ERROR!OTHER DISTRICT COST CALCULATIONS
62
#ERROR!4.9FY23 Regular Program District Cost Per Pupil (Line 2.3)
63
X#ERROR!***4.10Total Supplementary Weighting (Line 3.13)
64
=#ERROR!4.11District Cost for Supplementary Weighting
65
#ERROR!4.12FY23 Regular Program District Cost Per Pupil (Line 2.3)
66
X#ERROR!**4.13Total Special Ed Weighting in Addition to 1.0 (Line 3.4)
67
=#ERROR!4.14Special Education Instruction District Cost
68
#ERROR!**4.15FY23 Teacher Salary Supplement District Cost Per Pupil (Line 2.6)
69
X#ERROR!*4.16Budget Enrollment (Line 1.1)
70
=#ERROR!4.17Unadjusted Teacher Salary Supplement District Cost
71
#ERROR!4.18FY22 Unadj Teacher Salary Suppl District Cost (Line 4.17 - FY22 Aid & Levy)
72
-#ERROR!4.19Unadjusted Teacher Salary Supplement District Cost (Line 4.17)
73
=#ERROR!4.20Teacher Salary Supplement Budget Adjustment (if negative, enter zero)
74
+#ERROR!4.21Unadjusted Teacher Salary Supplement District Cost (Line 4.17)
75
=#ERROR!4.22Teacher Salary Supplement District Cost
76
#ERROR!**4.23FY23 Professional Development Supplement District Cost Per Pupil (Line 2.9)
77
X#ERROR!*4.24Budget Enrollment (Line 1.1)
78
=#ERROR!4.25Unadjusted Professional Development Supplement District Cost
79
#ERROR!4.26FY22 Unadjusted Prof Dev Suppl District Cost (Line 4.25 - FY22 Aid & Levy)
80
-#ERROR!4.27Unadjusted Professional Development Supplement District Cost (Line 4.25)
81
=#ERROR!4.28Professional Development Supplement Budget Adjustment (if negative, enter zero)
82
+#ERROR!4.29Unadjusted Professional Development Supplement District Cost (Line 4.25)
83
=#ERROR!4.30Professional Development Supplement District Cost
84
#ERROR!**4.31FY23 Early Intervention Supplement District Cost Per Pupil (Line 2.12)
85
X#ERROR!*4.32Budget Enrollment (Line 1.1)
86
=#ERROR!4.33Unadjusted Early Intervention Supplement District Cost
87
#ERROR!4.34FY22 Unadj Early Intervention Suppl District Cost (Line 4.33 - FY22 Aid & Levy)
88
-#ERROR!4.35Unadjusted Early Intervention Supplement District Cost (Line 4.33)
89
=#ERROR!4.36Early Intervention Supplement Budget Adjustment (if negative, enter zero)
90
+#ERROR!4.37Unadjusted Early Intervention Supplement District Cost (Line 4.33)
91
=#ERROR!4.38Early Intervention Supplement District Cost
92
#ERROR!4.39FY23 Teacher Leadership Supplement District Cost Per Pupil (Line 2.15)
93
X#ERROR!*4.40Budget Enrollment (Line 1.1)
94
=#ERROR!4.41Unadjusted Teacher Leadership Supplement District Cost
95
#ERROR!4.42FY22 Unadj Teacher Leadership Suppl District Cost (Line 4.41 - FY22 Aid & Levy)
96
-#ERROR!4.43Unadjusted Teacher Leadership Supplement District Cost (Line 4.41)
97
=#ERROR!4.44Teacher Leadership Supplement Budget Adjustment (if negative, enter zero)
98
+#ERROR!4.45Unadjusted Teacher Leadership Supplement District Cost (Line 4.41)
99
=#ERROR!4.46Teacher Leadership Supplement District Cost
100
#ERROR!AEA DISTRICT COST CALCULATIONS