07/01/02 OHIO DEPARTMENT OF EDUCATION
POLICY RESEARCH & ANALYSIS - SIMULATION UNIT
PROJECTED SF3 FUNDING CALCULATION FOR FY03 PURSUANT TO PROVISIONS OF HB94 AS PASSED BY GENERAL ASSEMBLY
IRN: 43794 DISTRICT: Cleveland Hts-Univ Hts City COUNTY: Cuyahoga
A-CURRENT YEAR FORMULA ADM [Aa-(0.5*Ab)-(0.75*Ac)+(0.25*Ad)] 6,510.46 (SF3:3A)
a-TOTAL ADM 6,728.67 (SF3:2)
b-KINDERGARTEN ADM 445.42 (SF3:1A-1F)
c-JVS ADM 0.00 (SF3:1G-1H)
d-VOCATIONAL CONTRACT ADM 18.00
B-THREE YEAR AVERAGE FORMULA ADM 6,538.46 (SF3:3B)
C-GREATER OF CURRENT YEAR OR 3 YEAR AVERAGE FORMULA ADM 6,538.46
D-COST OF DOING BUSINESS FACTOR 1.0672 (SF3:5A)
E-MEDIAN INCOME TY00 - {STATEWIDE MEDIAN INCOME=$30,079} 37,019.00
F-UNADJUSTED PROPERTY VALUATION 974,823,724.00 (SF3:4A)
G-RECOGNIZED PROPERTY VALUATION 938,503,791.00 (SF3:4C)
H-FORMULA AMOUNT [($4,949*C*D)-(G*Ha)+I] 12,947,748.44 (SF3:6)
a-CHARGE OFF MILLAGE [0.023 FOR SCHOOL DISTRICTS & 0.0005 FOR JOINT VOCATIONAL SCHOOLS]
I-EXEMPT PROPERTY VALUATION ADJUSTMENT {SEC. 3317.022(A)(2)} 0.00
J-3317. 23 ADJUSTMENTS [Ja+Jb+Jc] 42,571.79
a-CLASSROOM TEACHER ADJUSTMENT 0.00 (SF3:10A)
b-TEACHER TRAINING ADJUSTMENT 42,571.79 (SF3:10B)
c-EDUCATION SERVICE PERSONNEL ADJUSTMENT 0.00 (SF3:10C)
K-AVERAGE NUMBER OF OWF STUDENTS 769.80
L-AVERAGE PERCENT OF OWF STUDENTS 11.77
M-DPIA INDEX [L/8.2322] {8.2322 IS THE STATEWIDE AVERAGE OWF PERCENT} 1.43
N-SAFETY & REMEDIATION DPIA [IF 0.35=<M<1 THEN (K*230) IF M>=1 THEN (K*230*M)] 253,216.82
O-FULL DAY KINDERGARTEN DPIA [IF M>=1 THEN ((Ab/2)*$4,949)] 1,102,189.69
P-CLASS SIZE REDUCTION DPIA [Pa*$43,658] {$43,658 IS AVERAGE TEACHER SALARY & FRINGE} 830,428.68
a-ADDITIONAL TEACHERS NEEDED FOR K-3 CLASS SIZE REDUCTION 19.02
Q-DPIA GUARANTEE AMOUNT {POSITIVE DIFFERENCE OF FY98 DPIA MINUS FY03 DPIA} 0.00
R-TOTAL DPIA [N+O+P+Q] 2,185,835.19 (SF3:11)
S-TOTAL GIFTED AMOUNT 153,898.41 (SF3:12)
T-STATE AID RATIO [(H/C)/($4,949*D)] 0.37 (SF3:7)
U-STATE WEIGHTED SPECIAL EDUCATION CLASSROOM FUNDING [$4,949*Ug*T] 1,477,154.85 (SF3:8)
a-SPECIAL EDUCATION CATEGORY 1 STUDENT COUNT {REDUCED 0.2531 WEIGHT} 82.11
b-SPECIAL EDUCATION CATEGORY 2 STUDENT COUNT {REDUCED 0.3230 WEIGHT} 557.82
c-SPECIAL EDUCATION CATEGORY 3 STUDENT COUNT {REDUCED 1.5483 WEIGHT} 173.63
d-SPECIAL EDUCATION CATEGORY 4 STUDENT COUNT {REDUCED 2.0690 WEIGHT} 5.05
e-SPECIAL EDUCATION CATEGORY 5 STUDENT COUNT {REDUCED 2.7238 WEIGHT} 67.57
f-SPECIAL EDUCATION CATEGORY 6 STUDENT COUNT {REDUCED 4.1424 WEIGHT} 31.82
g-WEIGHTED COUNT [(Ua*0.2531)+(Ub*0.3230)+(Uc*1.5483)+(Ud*2.0690)+(Ue*2.7238)+(Uf*4.1424) 796.07
V-SPEECH ONLY RELATED SERVICES [((A/2000)*$30,000)*T] 36,614.97
W-STATE WEIGHTED VOC ED [(Wa*0.57)+(Wb*0.28)+((Wa+Wb)*0.05)]*$4,949*T 152,113.72 (SF3:9)
a-WORK FORCE DEVELOPMENT VOCATIONAL FTE 104.80 (SF3:9)
b-OTHER VOCATIONAL FTE 51.52 (SF3:9)
X-GRADS TEACHER GRANT [(Xa*$46,260)*T] 11,794.25
a-FTE GRADS TEACHERS 0.68
Y-EQUITY AID [($66,900-Yb)*0.009*Ya] {$66,900 IS THE THRESHOLD VALUATION PER PUPIL} 0.00 (SF3:13)
a-ADM USED IN EQUITY CALCULATION {PREVIOUS YEAR FORMULA ADM} 6,577.37
b-EQUITY ADJUSTED VALUATION PER PUPIL 144,260.89
Z-BASIC AID [H+J+R+S+U+V+W+X+Y] 17,007,731.61 (SF3:16)
AA-ADDITIONAL GUARANTEE AMOUNT [AAa-Z ONLY IF AAa>Z AND C>150] 0.00
a-FY98 FUNDAMENTAL AMOUNT 13,108,010.37
AB-TRANSPORTATION AMOUNT 604,107.65 (SF3:15)
AC-EXCESS CATEGORICAL SUPPLEMENT 281,981.99
AD-PARITY AID [IF (E/$30,079)<=1 & M>=1 & D>=1.0375 THEN GREATER OF (ADa OR ADe) ELSE ADa] 0.00 (SF3:17)
a-SEC 3317.0217(C) CALCULATION [((($144,155.29-ADb)*0.0095)*A)*0.4 ONLY IF ADb<$144,155.2 0.00
b-LOCAL WEALTH [((1/3)*ADc)+((2/3)*ADd)] 176,137.45
c-3 YEAR AVERAGE INCOME PER PUPIL 240,105.91
d-CURRENT YEAR VALUATION PER PUPIL 144,153.21
e-SEC 3317.0217(D) CALCULATION [($60,000*(1-(E/$30,079))*(4/15)*0.023)*A] 0.00
AE-TOTAL SF3 [Z+AA+AB+AC+AD] 17,893,821.25 (SF3:18)
AF-ESC TRANSFER 48,538.13 (SF3:20)
AG-REAPPRAISAL GUARANTEE 0.00
AH-SF3 AID LESS ESC TRANSFER PLUS REAPPRAISAL GUARANTEE [(AE-AF)+AG] 17,845,283.12 (SF3:21)
AI-CHARGE OFF SUPPLEMENT 0.00
AJ-SF3 AID PLUS CHARGE OFF SUPPLEMENT [AH+AI] 17,845,283.12
AK-ALL OTHER ADJUSTMENTS [AKa+AKb+AKc+AKd+AKe] 472,617.68
a-ESTIMATED PRE-SCHOOL CLASSROOM & RELATED SERVICE FUNDING 288,260.77 (SF3:22A)
b-ESTIMATED COMMUNITY SCHOOL TRANSFER -368,028.94 (SF3:22C)
c-ESTIMATED OPEN ENROLLMENT ADJUSTMENT 0.00 (SF3:22D)
d-ESTIMATED SPECIAL EDUCATION TRANSPORTATION 400,918.22 (SF3:22E)
e-ESTIMATED OTHER ADJUSTMENTS 151,467.63 (SF3:22F)
AL-TOTAL FUNDING FOR FY03 PLUS ADJUSTMENTS [AJ+AK] 18,317,900.80 (SF3:23)
AM-TOTAL FY02 FUNDING INCLUDING ALL ADJUSTMENTS 17,547,908.94
AN-CHANGE IN TOTAL FUNDING FY02 TO FY03 [AM-AL] 769,991.86