SFPR ReportsSFPR Summary Worksheet Report OHIO DEPARTMENT OF EDUCATION 01/29/2014 SCHOOL FINANCE - POLICY AND PAYMENTS SERVICES UNIT FY14 SUMMARY SCHOOL FUNDING REPORT FOR CITY, EXEMPTED VILLAGE AND LOCAL SCHOOL DISTRICTS (FY14 JAN #2 PAYMENT, DATA RECEIVED BY 5PM 01/10/14) IRN: 045138 District: WORTHINGTON CITY S.D. County: FRANKLIN ------------------------------------------------------------------------------------------------------------------------------------ CALCULATED STATE FOUNDATION FUNDING COMPONENTS: FUNDING FUNDING A Opportunity Grant: 14,291,713.59 10,408,381.72 B Targeted Assistance: 0.00 0.00 C K-3 Literacy Funding: 348,643.13 253,910.12 D Economic Disadvantaged Funding: 252,789.37 184,101.66 E Limited English Proficiency Funding: 143,911.59 104,808.07 F Gifted Education Funding: 459,802.75 334,865.56 G Transportation Funding: 1,813,058.00 1,320,415.47 H Special Education Additional Funding (Generally Exempted from Cap): 2,030,043.79 2,030,043.79 I Career Tech Education Funding (Generally Exempted from Cap): 45,166.96 45,166.96 J Total Foundation Funding Before Guarantee (A+B+C+D+E+F+G+H+I): 19,385,129.18 14,681,693.35 K Transitional Aid Guarantee (L-J): 0.00 0.00 ------------------------------------------------------------------------------------------------------------------------------------ L Total State Funding: 14,681,693.35 ------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL AID ITEMS: M Preschool Special Education Funding: 244,748.92 N Special Education Transportation Funding: 193,516.88 ------------------------------------------------------------------------------------------------------------------------------------ O Total Additional Aid Items (M+N): 438,265.80 ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS AND ADJUSTMENTS: P Education Service Center Transfer: -59,302.04 Q Open Enrollment Adjustment: -134,837.00 R Community School Transfer: -1,458,490.96 S STEM School Transfer: -109,476.18 T Scholarship Transfer: -1,145,221.97 U Other Adjustments: -333,945.97 ------------------------------------------------------------------------------------------------------------------------------------ V Total Transfers and Adjustments (P+Q+R+S+T+U): -3,241,274.12 ------------------------------------------------------------------------------------------------------------------------------------ W Net State Foundation Funding (L+O+V): 11,878,685.03 ==================================================================================================================================== SFPR Detail Worksheet Report OHIO DEPARTMENT OF EDUCATION 01/29/2014 SCHOOL FINANCE - POLICY AND PAYMENTS SERVICES UNIT FY14 DETAILED SCHOOL FUNDING REPORT FOR CITY, EXEMPTED VILLAGE AND LOCAL SCHOOL DISTRICTS (FY14 JAN #2 PAYMENT, DATA RECEIVED BY 5PM 01/10/14) IRN: 045138 District: WORTHINGTON CITY S.D. County: FRANKLIN ------------------------------------------------------------------------------------------------------------------------------------ Statewide Factors and Parameters: s1 Statewide Total ADM: 1,716,213.07 s2 Statewide Formula ADM: 1,684,834.27 s3 Statewide Economic Disadvantaged Percentage: 44.7126993% s4 Statewide Median Income: 32,180.00 s5 Statewide 3 Year Average Valuation: 242,082,979,402.00 s6 Statewide 3 Year Average Adjusted Total Valuation: 240,926,422,084.00 s7 Statewide 3 Year Federal Adjusted Gross Income: 265,792,223,824.00 District Factors and Parameters: a Base ADM Data a1 Adjusted Total ADM [a2-(a3*0.5)]: 9,376.55 a2 Total ADM: 9,376.55 a3 Tuition Kindergarten FTE: 0.00 a4 Jointure JVS ADM: 0.00 a5 Formula ADM [a1-(0.8*a4)]: 9,376.55 b Special Education ADM Data b1 Category 1 Special Education ADM 108.50 b2 Category 2 Special Education ADM 724.86 b3 Category 3 Special Education ADM 53.33 b4 Category 4 Special Education ADM 3.50 b5 Category 5 Special Education ADM 30.83 b6 Category 6 Special Education ADM 151.03 c Career Tech FTE c1 Category 1 Career Tech FTE 12.72 c2 Category 2 Career Tech FTE 13.63 c3 Category 3 Career Tech FTE 5.85 c4 Category 4 Career Tech FTE 7.48 c5 Category 5 Career Tech FTE 13.69 d Limited English Proficient ADM d1 Category 1 LEP ADM 76.40 d2 Category 2 LEP ADM 328.90 d3 Category 3 LEP ADM 77.40 e Additional ADM Data e1 K-3 Formula ADM: 2,942.10 e2 K-3 E-School Formula ADM: 16.00 e3 Preschool Autism Scholarship ADM: 4.00 e4 Brick & Mortar Community and STEM School Formula ADM: 69.46 e5 E-School Formula ADM: 105.32 e6 Net Formula ADM [a5-(e4*0.75)-e5-e7-e8-e9]: 9,206.85 e7 Jon Peterson Scholarship ADM: 1.88 e8 Autism Scholarship ADM: 10.40 e9 Ed Choice Scholarship ADM: 0.00 e10 Economic Disadvantaged ADM: 2,562.12 e11 Economic Disadvantaged Percentage: 27.3247623% f 3 Year Average Federal Adjusted Gross Income: 2,112,329,530.00 g 3 Year Average Total Real Valuation: 1,764,934,110.00 h 3 Year Average Agricultural Real Valuation: 105,823.00 i 3 Year Average Adjusted Total Valuation [if i2>(0.3*i3) then i1-(i2-(0.3*i3)) else i1]: 1,802,822,506.00 i1 3-Year Average Total Valuation: 1,802,822,506.00 i2 Exempt Property Valuation for FY14: 143,103,320.00 i3 Potential Property Valuation (i1+i2): 1,945,925,827.00 j State Share Index: 0.265195389 k Economic Disadvantaged Index [(e11/s3)^2]: 0.373465946 Detailed Calculation of Funding Components of the Formula: A Opportunity Grant [$5,745*(a5+e3)*j]: 14,291,713.59 B Targeted Assistance [B5+B8]: 0.00 B1 District Local Wealth Per Pupil [((i1/a5)*0.5)+((f/a5)*0.5)]: 208,773.59 B2 Statewide Local Wealth Per Pupil [((s5/s2)*0.5)+((s7/s2)*0.5)]: 150,719.63 B3 Statewide Threshold Local Wealth Per Pupil [490th Observation Value]: 184,510.62 B4 Targeted Assistance Wealth Index [B2/B1]: 0.721928621 B5 Basic Targeted Assistance [((B3-B1)*0.006*B4)*e6]: 0.00 B6 Agricultural Real Value Ratio [h/g]: 0.000059959 B7 Agricultural Targeted Percentage [if B6>=0.1 then 0.4 else (B6*4)]: 0.000239836 B8 Supplemental Targeted Assistance [B5*B7]: 0.00 C K-3 Literacy Funding [($125*(e1-e2)*j)+($86*(e1-e2))]: 348,643.13 D Economic Disadvantaged Funding [$269*e10*k)]: 252,789.37 E Limited English Proficiency Funding [E1+E2+E3]: 143,911.59 E1 Category 1 Funding [$1,500*d1*j]: 30,391.39 E2 Category 2 Funding [$1,125*d2*j]: 98,125.61 E3 Category 3 Funding [$750*d3*j]: 15,394.59 F Gifted Education Funding[F1+F2+F3]: 459,802.75 F1 Identification Funding [$5.00*a5]: 46,882.75 F2 Coordinator Funding [$37,000*((a5-(e4+e5))/3,300) if <0.5 then 0.5; if >8 then 8]: 103,230.00 F3 Intervention Specialist Funding [$37,000*((a5-(e4+e5))/1,100) if <0.3 then 0.3]: 309,690.00 G Transportation Funding: 1,813,058.00 H Special Education Additional Funding [H1+H2+H3+H4+H5+H6]: 2,030,043.79 H1 Category 1 Funding [b1*$1,503*j]: 43,246.87 H2 Category 2 Funding [b2*$3,813*j]: 732,971.20 H3 Category 3 Funding [b3*$9,160*j]: 129,548.69 H4 Category 4 Funding [b4*$12,225*j]: 11,347.05 H5 Category 5 Funding [b5*$16,557*j]: 135,369.60 H6 Category 6 Funding [b6*$24,407*j]: 977,560.38 I Career Technical Education Funding [I1+I2+I3+I4+I5+I6]: 45,166.96 I1 Category 1 Funding [c1*$4,750*j]: 16,023.11 I2 Category 2 Funding [c2*$4,500*j]: 16,265.76 I3 Category 3 Funding [c3*$1,650*j]: 2,559.80 I4 Category 4 Funding [c4*$1,400*j]: 2,777.13 I5 Category 5 Funding [c5*$1,200*j]: 4,356.63 I6 Associated Services Funding [(c1+c2+c3+c4+c5)*$225*j]: 3,184.53 J Total Foundation Funding Before Guarantee [A+B+C+D+E+F+G+H+I]: 19,385,129.18 K Funding Guarantee Base [FY13 Calculated Bridge Funding (Line 'O' of Bridge Report)] 13,818,064.32 L Transitional Aid Guarantee [if K>J then K-J else 0]: 0.00 M Total Calculated Funding [J+L]: 19,385,129.18 N Cap Limit [K*1.0625]: 14,681,693.34 O Total State Funding [if M>N then N else M]: 14,681,693.34 Open Enrollment OHIO DEPARTMENT OF EDUCATION FORM SFPR SUMMARY SHEET FOR OPEN ENROLLMENT ADJUSTMENTS (FY14 JAN #2 PAYMENT, DATA RECEIVED BY 5PM 01/10/14) DISTRICT: WORTHINGTON CITY S.D. IRN: 045138 COUNTY : FRANKLIN SE1K = SPEC. ED. CATEGORY 1 KDG SE12 = SPEC. ED. CATEGORY 1 1-12 SE2K = SPEC. ED. CATEGORY 2 KDG SE22 = SPEC. ED. CATEGORY 2 1-12 SE3K = SPEC. ED. CATEGORY 3 KDG SE32 = SPEC. ED. CATEGORY 3 1-12 SE4K = SPEC. ED. CATEGORY 4 KDG SE42 = SPEC. ED. CATEGORY 4 1-12 SE5K = SPEC. ED. CATEGORY 5 KDG SE52 = SPEC. ED. CATEGORY 5 1-12 SE6K = SPEC. ED. CATEGORY 6 KDG SE62 = SPEC. ED. CATEGORY 6 1-12 OTHK = OTHER KINDERGARTEN OTH2 = OTHER 1-12 JVSD = JVS JVSE = JVS SPECIAL EDUCATION NOTE: ESC's ARE NOT FUNDED THROUGH OPEN ENROLLMENT FORMULA SUMMARY FOR OPEN ENROLLMENT STUDENTS Career-Tech/Adult Education Student - CTA1 : FUNDED FTE * $4,750 Career-Tech/Adult Education Student - CTA2 : FUNDED FTE * $4,500 Career-Tech/Adult Education Student - CTA3 : FUNDED FTE * $1,650 Career-Tech/Adult Education Student - CTA4 : FUNDED FTE * $1,400 Career-Tech/Adult Education Student - CTA5 : FUNDED FTE * $1,200 Per HB66: Kindergarten Students (SE1K,SE2K,...,SE6K,OTHK) is the following FORMULA AMOUNT * FTE Regular Students (SE12,SE22,...,SE62,OTH2) is the following FORMULA AMOUNT * FTE NOTE: Funding for Career-Tech/Adult Ed. Students is transferred on 2 seperate lines. One line transfers the base formula amount based on funded FTE while the other line transfers the weighted amount based on funded FTE. JVS FORMULAS (NON-JOINTURE) Positive Adjustment : (FTE * .20 FUNDED FTE) * FORMULA AMOUNT Negative Adjustment (Dist-Dist-JVS): (FTE * 1.0 FUNDED FTE) * FORMULA AMOUNT Negative Adjustment (Dist-JVS) : (FTE * .80 FUNDED FTE) * FORMULA AMOUNT JVS FORMULAS (JOINTURE) Positive Adjustment : (FTE * .20 FUNDED FTE) * FORMULA AMOUNT Negative Adjustment (Dist-Dist-JVS): (FTE * 1.0 FUNDED FTE) * FORMULA AMOUNT Negative Adjustment (Dist-JVS) : (FTE * .80 FUNDED FTE) * FORMULA AMOUNT NOTE: FUNDED FORMULA AMOUNT is the factor used in the districts calculation per HB66. FORMULA AMOUNT $5,745.00 Deductions = Object Code 477 Credits = Receipt Code 1227 Credits to or Deductions from WORTHINGTON CITY S.D. STUDENT STUDENT FUNDED AMOUNT DEDUCTED SAME IRN DISTRICT COUNTY TYPE FTE FTE or RECEIVED JOINTURE 043802 COLUMBUS CITY S.D. FRANKLIN OTH2 18.600 18.600 $106,857.00- N/A 043802 COLUMBUS CITY S.D. FRANKLIN OTHK 1.000 1.000 $5,745.00- N/A 043802 COLUMBUS CITY S.D. FRANKLIN SE22 0.600 0.600 $3,447.00- N/A 048264 JONATHAN ALDER LOCAL MADISON OTH2 1.000 1.000 $5,745.00- N/A 050989 DELAWARE AREA CAREER DELAWARE CTA1 0.500 0.500 $2,375.00- N/A 045138 WORTHINGTON CITY SD /DELAWARE AREA CAREER -------- JVSD 0.500 0.400 $2,298.00- N 050989 DELAWARE AREA CAREER DELAWARE CTA1 0.420 0.420 $1,995.00- N/A 050989 DELAWARE AREA CAREER DELAWARE CTA4 0.450 0.450 $630.00- N/A 046755 BUCKEYE VALLEY LOCAL/DELAWARE AREA CAREER -------- JVSD 1.000 1.000 $5,745.00- N ============================================================================================================================= FUNDED FTE KDG IN 1-12 IN TOTAL IN KDG OUT 1-12 OUT TOTAL OUT Special Ed Category 1 0.000 0.000 0.000 0.000 0.000 0.000 Special Ed Category 2 0.000 0.000 0.000 0.000 0.600 0.600 Special Ed Category 3 0.000 0.000 0.000 0.000 0.000 0.000 Special Ed Category 4 0.000 0.000 0.000 0.000 0.000 0.000 Special Ed Category 5 0.000 0.000 0.000 0.000 0.000 0.000 Special Ed Category 6 0.000 0.000 0.000 0.000 0.000 0.000 Other 0.000 0.000 0.000 1.000 19.600 20.600 JVSD/JVSE 0.000 0.000 0.000 0.000 1.400 1.400 0.000 22.600 STUDENT FTE IN - .000 FUNDED FTE IN - .000 STUDENT FTE OUT - 24.070 FUNDED FTE OUT - 23.970 REG/JVS OE POSITIVE ADJUSTMENT .000 $0.00 REG/JVS OE NEGATIVE ADJUSTMENT 22.600 + $129,837.00- CTA1 OE POSITIVE ADJUSTMENT .000 + $0.00 CTA1 OE NEGATIVE ADJUSTMENT .920 + $4,370.00- CTA2 OE POSITIVE ADJUSTMENT .000 + $0.00 CTA2 OE NEGATIVE ADJUSTMENT .000 + $0.00 CTA3 OE POSITIVE ADJUSTMENT .000 + $0.00 CTA3 OE NEGATIVE ADJUSTMENT .000 + $0.00 CTA4 OE POSITIVE ADJUSTMENT .000 + $0.00 CTA4 OE NEGATIVE ADJUSTMENT .450 + $630.00- CTA5 OE POSITIVE ADJUSTMENT .000 + $0.00 CTA5 OE NEGATIVE ADJUSTMENT .000 + $0.00 NET TOTAL - OPEN ENROLLMENT ADJUSTMENT = $134,837.00- *NOTE: The calculations shown here are pursuant to the FORMULA SUMMARY section above. Other Adjustments OHIO DEPARTMENT OF EDUCATION, CENTER FOR SCHOOL FINANCE FORM SFPR DETAIL SHEET FOR OTHER ADJUSTMENTS (FY14 JAN #2 PAYMENT, DATA RECEIVED BY 5PM 01/10/14) District: WORTHINGTON CITY S.D. IRN: 045138 County: FRANKLIN OTHER ADJUSTMENTS (O.R.C. 3317.023 (K) and 3317.20 (D)) FORMULA SUMMARY: FORMULA AMOUNT = $5,745 FTE Weighted Amount * State Share of the Resident District NOTE: Funding for Career-Tech/Adult Ed. contract students is transferred on 2 seperate lines. One line transfers the base formula amount based on ADM while the other line transfers the weighted amount based on FTE. Special Education Student(K-12): ADM * Weighted Amount * $5,745 * State Share of Resident District Other Student K-12 OR Vocational: ADM * $5,745 Special Education Amounts: Category 1 = $1,503 Category 2 = $3,813 Category 3 = $9,160 Category 4 = $12,225 Category 5 = $16,557 Category 6 = $24,407 Career-Tech/Adult Ed. Amounts: Category 1 = $4,750 Category 2 = $4,500 Category 3 = $1,650 Category 4 = $1,400 Category 5 = $1,200 STATE SHARE INDEX FOR THE ABOVE DISTRICT : 0.2651953890 Student Status Key: SE = SPECIAL EDUCATION VEC = VOCATIONAL EDUCATION CONTRACT Student Type Key: SE1K = SPEC. ED. CATEGORY 1 KDG SE12 = SPEC. ED. CATEGORY 1 1-12 SE2K = SPEC. ED. CATEGORY 2 KDG SE22 = SPEC. ED. CATEGORY 2 1-12 SE3K = SPEC. ED. CATEGORY 3 KDG SE32 = SPEC. ED. CATEGORY 3 1-12 SE4K = SPEC. ED. CATEGORY 4 KDG SE42 = SPEC. ED. CATEGORY 4 1-12 SE5K = SPEC. ED. CATEGORY 5 KDG SE52 = SPEC. ED. CATEGORY 5 1-12 SE6K = SPEC. ED. CATEGORY 6 KDG SE62 = SPEC. ED. CATEGORY 6 1-12 OTHK = OTHER KINDERGARTEN OTH2 = OTHER 1-12 CTA1 = CAREER-TECH/ADULT ED. CAT 1 CTA2 = CAREER-TECH/ADULT ED. CAT 2 CTA3 = CAREER-TECH/ADULT ED. CAT 3 CTA4 = CAREER-TECH/ADULT ED. CAT 4 CTA5 = CAREER-TECH/ADULT ED. CAT 5 Deductions = Object Code 47x Credits = Receipt Code 122x Credits to or Deductions from RESIDENT --STUDENT-- CALC AMT DEDUCTED DISTRICT COUNTY FY14 ST.SHARE STATUS TYPE FTE or RECEIVED COLUMBUS CITY S.D. FRANKLIN 0.2651953890 SE SE32 1.000 $8,174.19- COLUMBUS CITY S.D. FRANKLIN 0.2651953890 SE SE3K 1.000 $8,174.19- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC CTA1 10.400 $13,100.65- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC CTA2 13.630 $16,265.76- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC CTA3 0.990 $433.20- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC CTA4 7.480 $2,777.13- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC OTH2 21.600 $124,092.00- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE12 2.000 $12,287.18- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE22 11.920 $80,533.79- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE32 2.000 $16,348.38- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE42 0.500 $4,493.51- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE52 1.000 $10,135.84- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC SE62 2.500 $30,544.06- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC CTA1 0.420 $529.06- DELAWARE AREA CAREE DELAWARE 0.2651953890 VEC OTH2 0.500 $2,872.50- VE SERVICES ADJUSTMENT ************** *** **** ******* $3,184.53- NET TOTAL $333,945.97-