REPORT 1191F STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:13 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191F ***** STATE SUMMARY ***** ACCOUNT 3100 FUNDING FOR 1999-2000 SCHOOL YEAR A. GUARANTEED ENTITLEMENT COMPUTATION 1. CERT. INSTR MAINT: FORMULA UNITS 46,277.335 * LEAP 12E CIS 9899 SAL $23,077 * 99-00 LEAP 1A BEA SP ED MIX FCTR 1.69011$ 1,805,013,279.21 2. CERT. INSTR INCREASE: FORM UNITS 46,277.335 * 1191E LINE E3 $25,858 * 1.0000 * 99-00 LEAP 1S BEA SP ED MIX 1.60537 - A1$ 116,104,259.34 3. CERT. ADMIN ALLOC: FORMULA UNITS 3,795.962 * LEAP 12E ADMIN AVG SALARY $45,963.44................................$ 174,475,464.82 4. CERT. ADMIN INCREASE: FORMULA UNITS 3,795.962 * LEAP 12E ADMIN AVG SALARY $45,963.44 * .0300.......................$ 5,234,263.98 5. CLASS MAINT: FORMULA UNITS 15,863.920 * LEAP 12E CLASS AVG SALARY $24,440.81..........................................$ 387,727,119.23 6. CLASS INCREASE: FORMULA UNITS 15,863.920 * LEAP 12E CLASS AVG SALARY $24,440.81 * .0300.............................$ 11,631,811.64 7.a. INSURANCE BENEFITS: CERT. FORM UNIT50,073.297 * 4656.24 $ 233,153,288.40 b. INSURANCE BENEFITS: CERT. INCR. 50,073.297 * .00 ... c. INSUR BEN: CLASS. FORM UNIT15,863.920 * 4656.24 * 1.152.$ 85,093,884.19 d. INSUR BEN: CLASS. INCR. 15,863.920 * .00 * 1.152.... 8.a. MANDATED BENEFITS: CERT MAINT: (A.1 + A.3) * .1649 ....$ 326,417,693.85 b. MANDATED BENEFITS: CERT INCR: (A.2 + A.4) * .1585 .....$ 19,232,155.97 c. MANDATED BENEFITS: CLASS MAINT: (A.5) * .1556 .........$ 60,330,339.69 d. MANDATED BENEFITS: CLASS INCR: (A.6) * .1206 ..........$ 1,402,796.54 9. NON-EMPLOYEE-RELATED COST: K-12 UNITS47,076.700 * 8,117.00$ 382,121,574.02 10. NON-EMPLOYEE-RELATED COST: VOC UNITS 2,791.108 * 19,933.00$ 55,635,155.91 11. NON-EMPLOYEE-RELATED COST: SKILL UNIT 205.543 * 15,467.00$ 3,179,133.58 12. SUBS: CERT INSTR FORM UNITS 46,277.335 * .915 * 376.24$ 15,931,415.36 13. RUN START: 6,564.45 * 3,687.00 + 902.22 * 4,373.00 $ 28,148,535.21 14. TOTAL GUARANTEED ENTITLEMENT: (A.1 THRU A.13) * 100.00% ...$ 3,710,832,171.46 B. BASIC EDUCATION ALLOCATION PER FTE STUDENT RATES: AVERAGE $ 3,913.58 VOC ENHC W P31 MIX .00000 ; SKILLS CENTER BASIC ALLOC FOR VOC ; K-12, K-3 AT 49, NO ENH C. COMPUTATION OF STATE FUNDED SUPPORT 1. LOCAL DEDUCTIBLE REVENUE SOURCES 1400 LOCAL IN-LIEU-OF TAXES .................$ 158,795.69 1600 COUNTY ADMINISTERED FORESTS ............$ 826,964.85 3600 STATE FORESTS ..........................$ 13,728,172.14 5400 FEDERAL IN-LIEU-OF TAXES ...............$ 531,605.21 TOTAL DEDUCTIBLE REVENUE ..................................$ 15,245,537.89 2. ADDITIONAL ALLOTMENT ......................................$ 223,750.38- 3. SKILLS CENTER SUMMER PROGRAM...............................$ 2,098,000.00 4. TOTAL DUE ON APPORTIONMENT SCHED (A.14-C.1+C.2+C.3) .......$ 3,697,460,883.19 5. FEDERAL FOREST ACCOUNT 5500 DEDUCTION......................$ 10,674,256.07 6. EMERGENCY PAYMENT .........................................$ 208,016.00 7. FIRE DISTRICT PAYMENT .....................................$ 434,216.88 8. ADJUSTMENT FOR 1998-1999 ..................................$ 1,542,279.76- 9. TOTAL AMOUNT TO BE PAID SEPT.99-AUG.00 IN ACCT 3100 .......$ 3,685,886,580.24 D. ANALYSIS OF LINE C.9 1. ADVANCE PAYMENT THIS YEAR .................................$ 1,020,212.00 2. TOTAL ALLOTMENT (3100) PAID PREVIOUSLY ....................$ 3,682,709,532.53 3. RECOVERY ..................................................$ 19,885.06 4. OTHER DEDUCTIONS AND/OR RECOVERIES ........................$ 134,428.55 5. ADJUSTMENT FOR 1999-2000 (C.10 - D.2 - D.3 - D.4)..........$ 3,022,734.10 REPORT 1191EF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:14 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION PAGE 1 OF 2 APPORTIONMENT FINAL 1999-2000 REPORT 1191EF ***** STATE SUMMARY ***** FULL-TIME ENROLLMENTS USED TO CALCULATE STAFF UNITS FOR 1999-2000 ACCOUNT NO. 3100 A. FULL-TIME EQUIVALENT ENROLLMENT REMOTE & NECESSARY DISTRICT PLANTS TOTALS 1. KINDERGARTEN .................................. 14.390 . 34,236.17 2. GRADES 1-3 .................................... 109.230 . 230,319.27 ADDITIONAL SCHOOL ANNUAL CLASS FTE ....................... 73.29 3. GRADE 4 .................................... 31.110 . 78,853.68 ADDITIONAL SCHOOL ANNUAL CLASS FTE ....................... 24.37 4. GRADES 5-6 .................................... 36.340 . 153,649.82 ADDITIONAL SCHOOL ANNUAL CLASS FTE ....................... 46.22 5. GRADES 7-8 .................................... 8.870 . 152,919.37 ADDITIONAL SCHOOL ANNUAL CLASS FTE ....................... 44.55 6. GRADES 9-12 (INCLUDING VOC-SECONDARY) ..................... 290,263.27 ADDITIONAL SCHOOL ANNUAL CLASS FTE ....................... 297.59 7. TOTAL K-12 LESS RUNNING START 940,727.60 8. RUNNING START (COMMUNITY AND TECHNICAL COLLEGE FTE) a. NONVOCATIONAL FTE ....................................... 6,564.45 b. VOCATIONAL FTE .......................................... 902.22 9. TOTAL K-12 INCLUDING RUNNING START ....................... 948,194.27 B. ENROLLMENT INCREASE IN EXCESS OF MONTHLY ENROLLMENT FOR QUALIFIED DISTRICT 1. GRADES K-4 FTES IN EXCESS OF MONTHLY ENROLLMENT COUNT....... .00 2. GRADES K-12 FTES IN EXCESS OF MONTHLY ENROLLMENT COUNT...... .00 C. GRADES 9-12 VOC-SECONDARY 1. APPROVED ANNUAL PUBLIC SCHOOL .............................. 54,555.97 NONSTANDARD (P223S) VOCAIONAL FTE .......................... 20.94 2. APPROVED ANNUAL SKILL CENTER PUBLIC SCHOOL W/O SUMMER ...... 3,426.26 NONSTANDARD (P223S) SKILLS CENTER FTE ...................... .13 3. TOTAL VOC-SECONDARY ........................................ 58,003.30 D. STAFFING DATA FROM REPORT 1159 AND REPORT 1191VOC 1. K-4 ENHANCEMENT RATIO FROM REPORT 1159...................... .0000 2. FUNDING REDUCTION STAFF UNITS FROM REPORT 1159.............. .054- 3. FUNDED VOCATIONAL STAFF RATIO FROM REPORT 1159 VOC.......... 19.55 E. ALLOCATED CERTIFIED INSTRUCTION STAFF (CIS) BASE SALARY CALCULATION 1. LEARNING IMPROVEMENT DAYS (LID) PURSUANT TO WAC 392-140-961. .00 2. LEAP 12E CIS BASE SALARY FOR 1999-2000 INCLUDING 3 LID...... .00 3. ALLOCATED CIS BASE SALARY (1 - ((3 - E.1) * .00547)) * E.2 .00 F. FUNDED K-4 CIS RATIO CALCULATION 1. MINIMUM ALLOCATED K-4 CIS RATIO (((A.1 + A.2) * .049) + (A.3 * .046))/(A.1 + A.2 + A.3).. .0000 2. GREATER OF ACTUAL OR MINIMUM ALLOCATED K-4 CIS RATIO (IF D.1 IS GREATER THAN F.1 THEN D.1, ELSE F.1).......... .0530 REPORT 1191EF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:14 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION PAGE 2 OF 2 APPORTIONMENT FINAL 1999-2000 REPORT 1191EF ***** STATE SUMMARY ***** FULL-TIME ENROLLMENTS USED TO CALCULATE STAFF UNITS FOR 1999-2000 ACCOUNT NO. 3100 G. CALCULATION OF 100% FORMULA BEA STAFF UNITS 1. CERTIFICATED STAFF UNITS A. FORMULA UNITS I. INSTRUCTIONAL GRADES K-4 (A1+A2+A3+(B1*1.1)) * F2..... 18,215.337 II. REDUCTION IN INSTR UNITS PURSUANT TO WAC 392-127-111 D2 .054- III. INSTRUCTIONAL GRADES 5-12 (A4 + A5 + A6 - C3 + ((B2 - B1) * 1.1) * .046............................. 24,804.986 IV. ADMINISTRATIVE (A7 - C3 + (B2 * 1.1)) * .004.......... 3,530.901 B. BONUS UNITS - R&N PLANT, SMALL DISTRICT, SMALL HIGH & NON-HIGH I. GRADES K THROUGH 6 OR 8 -- UNDER 25 FTE (A). INSTRUCTIONAL ................................... 23.124 (B). ADMINISTRATIVE .................................. 3.194 II. GRADES K THROUGH 6 -- 25 FTE TO 60 FTE (A).INSTRUCTIONAL 2.76-((A.1+A.2+A.3)*F2+(A.4*.046)). 18.456 (B).ADMINISTRATIVE .24-((A.1 + A.2 + A.3 + A.4)*.004) 2.037 III. GRADES 7 AND 8 -- UNDER 20 FTE (A). INSTRUCTIONAL (.92 - (A.5 * .046)).............. 5.258 (B). ADMINISTRATIVE (.08 - (A.5 * .004)).............. .457 IV. SMALL HIGH -- UNDER 300 FTE (A). INSTRUCTIONAL 9 + (((A.6 - 60)/43.5) * .8732) - (A.6 * .046)............... 432.262 (B). ADMINISTRATIVE .5 + (((A.6 - 60)/43.5) * .1268) - (A.6 * .004)............... 18.836 V. NON-HIGH UNITS -- INSTRUCTIONAL ...................... 6.500 C. ADDITIONAL UNITS -- TWO R/N PLANTS OR SMALL HIGHS (I). INSTRUCTIONAL ................................... 14.552 (II). ADMINISTRATIVE ................................. .800 D. K-12 UNITS (EXCLUDES VOC.) (G.1A - G.1AII + G.1B + G.1C) 47,076.700 E. VOCATIONAL UNITS (I).INSTRUCTIONAL ((C.1 / D.3) * .92)................. 2,567.815 (II).ADMINISTRATIVE ((C.1 / D.3) * .08)............... 223.293 F. SKILL CENTER UNITS (I). INSTRUCTIONAL ((C.2 / 16.67) * .92).............. 189.099 (II). ADMINISTRATIVE ((C.2 / 16.67) * .08)............ 16.444 G. TOTAL CERT INSTRUCTIONAL UNITS (G.1AI + G.1AII + G.1AIII + G.1BI(A) + G.1BII(A) + G.1BIII(A) + G.1BIV(A) + G.1BV + G.1CI + G.1EI + G.1FI) 46,277.335 H. TOTAL CERT ADMINISTRATIVE UNITS (G.1AIV + G.1BI(B) + G.1BII(B) + G.1BIII(B) + G.1BIV(B) + G.1CII + G.1EII + G.1FII) ............................. 3,795.962 2. CLASSIFIED STAFF UNITS A. FORMULA UNITS (A.7 + (B.2 * 1.1))/60 + ((G.1B + G.1C (SEE NOTE))/3).......................... 15,855.920 B. NON-HIGH UNITS .......................................... 8.000 C. TOTAL FORMULA CLASSIFIED UNITS (G.2A + G.2B) ........... 15,863.920 NOTE: IF G.1BI+G.1BII > 0, ADD (A.1+A.2+A.3)*(F2-.046) TO (G.1B + G.1C) REPORT 1191FSF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:15 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191FSF ***** STATE SUMMARY ***** FOOD SERVICES FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NOS. 4198 & 419801 4198 419801 SCHOOL FREE AND REDUCED LUNCH BREAKFASTS A. ACTUAL NUMBER OF MEALS SERVED IN 1999-2000 1. TYPE A LUNCH .......................... 75,128,628 2. FREE AND REDUCED BREAKFASTS ............................ 15,303,567 B. ALLOTMENT FOR 1999-2000 1. (A.1 * 0.0406 PER LUNCH)..............$ 3,050,746.72 2. (A.2 * 0.1461 PER FREE AND REDUCED BREAKFAST)...........$ 2,236,201.85 C. CURRENT YEAR ADJUSTMENT ......................$ .00 $ .00 D. FINAL 1999-2000 ALLOTMENT 1. B.1 + C ..............................$ 3,050,746.72 2. B.2 + C ................................................$ 2,236,201.85 E. ADJUSTMENT FOR 1998-1999 .....................$ 102,465.28- $ 3,809.96- F. TOTAL AMOUNT DUE 1999-2000 (D + E) ..........$ 2,948,281.44 $ 2,232,391.89 G. TOTAL AMOUNT PAID IN 1999-2000 ...............$ 2,991,832.16 $ 2,278,403.30 H. ADJUSTMENT FOR 1999-2000 (F - G) ............$ 43,550.72- $ 46,011.41- REPORT 1191LEF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:15 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191LEF ***** STATE SUMMARY ***** LOCAL EDUCATION PROGRAM ENHANCEMENT FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NO. 4175 4175 LOCAL ENHANCEMENT A. ADJUSTED TOTAL FTE FOR 1999-2000 ............................... 949,687.09 B. ALLOTMENT FOR 1999-2000 1. MAXIMUM ALLOTMENT (A1. * $ 28.81 PER ADJ FTE)...............$ 27,360,485.14 2. MEDICAID AND/OR TRUANCY PENALTY (A1. * $ .00 PER ADJ FTE).......................$ 202,838.03- C. CURRENT YEAR ADJUSTMENT.........................................$ .00 D. ADJUSTMENT FOR 1998-1999 .......................................$ 1,834.02 E. TOTAL AMOUNT DUE 1999-2000 (B1 + B2 + C + D) ..................$ 27,159,481.13 F. TOTAL AMOUNT PAID IN 1999-2000 .................................$ 27,142,414.93 G. ADJUSTMENT FOR 1999-2000 (E - F) ..............................$ 17,066.20 REPORT 1191SEF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:16 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191SEF ***** STATE SUMMARY ***** SPECIAL EDUCATION FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NO. 4121 A. SPECIAL EDUCATION ALLOTMENT FOR 1999-2000 (SEE REPORT 1220) ....$ 409,646,963.42 B. HOME AND HOSPITAL ALLOTMENT ....................................$ 883,605.20 C. FOSTER HOME ALLOTMENT (ROOM & BOARD) ...........................$ .00 D. OTHER ..........................................................$ .00 E. 1. CALCULATED ALLOTMENT (A + B + C + D) ......$ 410,530,568.62 2. PRIOR YEAR CARRY FORWARD ..................$ 7,509.59 3. a. F-196, PART 3 NET EXPENDITURES..........$ 647,417,332.68 b. PAYMENTS TO OTHER DISTRICTS ............$ 7,538,207.59 c. PAYMENTS FROM OTHER DISTRICTS ..........$ 8,376,640.29 d. TOTAL (E.3a + E.3b - E.3c) .............$ 646,578,899.98 4. LESSER OF E.1 OR (E.3d - E.2) .............$ 410,516,372.27 5. CARRY FORWARD (E.1 - E.4 TO MAX. OF E.1 *.1$ 14,196.35 6. E.4 + E.5 ...................................................$ 410,530,568.62 F. RECOVERY OF STATE SHARE OF MEDICAID PAYMENTS ...................$ 12,897.14- G. ADJUSTMENT FOR 1998-1999 .......................................$ 73,092.52 H. TOTAL AMOUNT DUE 1999-2000 (E6 + F + G) .......................$ 410,590,764.00 I. TOTAL AMOUNT PAID IN 1999-2000 .................................$ 410,540,385.98 J. ADJUSTMENT FOR 1999-2000 (H - I) ..............................$ 50,378.02 REPORT 1191SNF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:17 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191SNF ***** STATE SUMMARY ***** SPECIAL NEEDS PROGRAMS FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NO.S 4155, 4165 & 4174 4155 4165 4174 LEARNING TRANSITIONAL HIGHLY ASSISTANCE BILINGUAL CAPABLE A. TOTAL ALLOTMENT FOR 1999-2000 1. LEARNING ASSISTANCE a. GRADES K-6: GRADES K-6 FTE 496,776.32 * 4TH GRADE LOW QUART .2219 * .920 i. * .00.........$ 40,849,127.43 ii.* 0.00 INS BEN INCR$ .00 b. GRADES 7-9: GRADES 7-9 FTE 236,964.31 * 8TH GRADE LOW QUART .1929 * .920 i. * .00 ........$ 16,936,370.65 ii.* 0.00 INS BEN INCR$ .00 c. GRADES 10-11: GRADES 10-11 FTE 145,438.54 * 11TH GRADE LOW QUART .2162 * .920 i. * .00 ........$ 11,647,186.85 ii.* 0.00 INS BEN INCR$ .00 d. POVERTY: TOTAL FTE 948,194.27 * (DIST POV. .37736 - STATE POV. .31380) * .22300 i. * .00.........$ 5,412,136.78 ii.* 0.00 INS BEN INCR$ .00 e. TOTAL LEARNING ASSISTANCE (A.1a + b + c + d)...$ 74,844,821.71 2. TRANSITIONAL BILINGUAL (ELIG STUDENTS) 55,652.39 i. * .00) ........................$ 38,439,509.09 ii. * 0.00) INS BEN INCR ...............$ .00 3. HIGHLY CAPABLE (TOTAL FTE 935,680.14 * .020) i. * .00) W/O BEN INCR .............................$ 6,167,012.26 ii. * 0.00) INS BEN INCR .................................$ .00 B. CURRENT YEAR ADJUSTMENT ....$ .00 $ .00 $ .00 C. 1. CALCULATED ALLOTMENT(A+B)$ 74,844,821.71 $ 38,439,509.09 $ 6,167,012.26 2. PRIOR YEAR CARRY FORWARD.$ .00 3. F-196 DIRECT EXPENDITURES$ 72,569,845.56 4. INDIRECT PERCENT ........% 9.1670 5. C.3 * (1 + C.4) .........$ 74,789,964.28 6. F-196, PART 3 NET EXPEND. $ 71,567,464.38 $ 16,329,925.08 7. LESSER OF C.1, (C.5 - C.2) OR C.6.................$ 70,694,652.35 $ 38,418,440.34 $ 6,145,179.77 8. CARRY FORWARD (C.1*.1 MAX$ .00 9. C.7 + C.8................$ .00 D. ADJUSTMENT FOR 1998-1999 ...$ 256,814.77- $ 12,406.83- $ 34,754.71- E. TOTAL AMOUNT DUE FOR 1999-2000 ((C.7 OR C.9) + D)$ 74,281,338.79 $ 38,406,033.51 $ 6,110,425.06 F. TOTAL AMOUNT PAID IN 1999-00$ 74,527,166.23 $ 38,424,997.34 $ 6,116,392.72 G. ADJUSTMENT 1999-2000 (E - F)$ 245,827.44- $ 18,963.83- $ 5,967.66- REPORT 1191TRNF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:17 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191TRNF ***** STATE SUMMARY ***** TRANSPORTATION FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NO. 4199 & 4499 A. ACCOUNT 4199 - OPERATIONS 1. TRANSPORTATION ALLOT FROM 1026-A A. WITHOUT INSURANCE BENEFIT INCREASE ......................$ 163,673,714.22 B. INSUR BEN INCREASE (WTD UNITS .00 * RATE 0.00) .$ .00 C. TOTAL ...................................................$ 163,673,714.22 2. IN-LIEU-OF DEPRECIATION FOR CONTRACTING DISTRICTS ..........$ 5,774,625.06 3. CURRENT YEAR ADJUSTMENT ....................................$ .00 4. A. CALCULATED ALLOTMENT (A.1+A.2+A.3) ...$ 169,448,339.28 B. i. F-196, PART 3 NET EXPENDITURES ....$ 276,602,202.16 ii. TRANSFERS TO TVF ..................$ 6,952,786.74 iii.TOTAL COST AND TRANSFERS ..........$ 283,554,988.90 C. LESSER OF A.4A, A.4Biii .................................$ 169,231,075.13 5. ADJUSTMENT FOR 1998-1999 ...................................$ 241,351.96- 6. TOTAL AMOUNT DUE FOR 1999-2000 (A.4C + A.5) ...............$ 168,989,723.17 7. TOTAL AMOUNT PAID IN 1999-2000 .............................$ 169,196,179.57 8. ADJUSTMENT FOR 1999-2000 (A.6 - A.7) ......................$ 206,456.40- B. ACCOUNT 4499 - DEPRECIATION 1. SCHOOL BUS DEPRECIATION ALLOWANCE a. BUSES ON AFTER AUG 1982 ...............$ 15,834,533.97 b. BUSES ON BEFORE SEPT 1982 AT 100.00% ..$ 13,225.34 c. BUSES ON BEFORE SEPT 1980 TOTAL .00 * 90.00% =.........$ .00 d. TOTAL DEPRECIATION ALLOWANCE (B.1a + B.1b + B.1c) .......$ 15,847,759.31 2. AMOUNT FOR BUSES SOLD/SALVAGE a. Report 1020 FOR 1999-2000 .............$ 164,807.56 b. Report 1020 FOR 1999-2000 100.00% .....$ 29,588.48 c. Report 1020 FOR 1999-2000 TOTAL 29,460.00 * 90.00% = ........$ 26,514.00 d. TOTAL DEPRECIATION ALLOWANCE (B.2a + B.2b + B.2c) ......$ 220,910.04 3. TOTAL ALLOTMENT 1999-2000 (B.1d - B.2d) ...................$ 15,626,849.27 4. ADJUSTMENT FOR 1998-1999 ...................................$ 299,646.79- 5. TOTAL AMOUNT DUE 1999-2000 (B.3 + B.4) ....................$ 15,327,202.48 6. TOTAL AMOUNT PAID IN 1999-2000 .............................$ 15,552,711.82 7. ADJUSTMENT FOR 1999-2000 (B.5 - B.6) ......................$ 225,509.34- REPORT 1191TSEF STATE OF WASHINGTON RUN JAN 24, 2001 @ 11:18 STATE SUMMARY SUPERINTENDENT OF PUBLIC INSTRUCTION APPORTIONMENT FINAL 1999-2000 REPORT 1191TSEF ***** STATE SUMMARY ***** TRAFFIC SAFETY EDUCATION FINAL ALLOTMENT FOR 1999-2000 ACCOUNT NO. 4171 A. NUMBER OF PUPILS 1999-2000 1. TOTAL....................................................... 47,510 2. LOW INCOME.................................................. 11,983 B. ALLOTMENT FOR 1999-2000 1. CALCULATED ALLOT (A.1 * $137.16 PER PUPIL) $ 6,516,471.60 2. TOTAL COST (F-196 PART III)................$ 20,609,867.55 3. LESSER OF B1, B2 ...........................................$ 6,514,825.68 C. LOW INCOME TUITION ASSISTANCE FOR 1999-2000 1. CALCULATED ALLOT (A.2 * $ 66.81 PER PUPIL) $ 800,584.23 2. AMOUNT USED................................$ 967,721.55 3. LESSER OF C1, C2 ...........................................$ 774,900.95 D. ADJUSTMENT FOR 1998-1999 .......................................$ 213,325.50- E. TOTAL AMOUNT DUE 1999-2000 (B3 + C3 + D) ......................$ 7,076,401.13 F. TOTAL AMOUNT PAID IN 1999-2000 .................................$ 7,402,233.95 G. ADJUSTMENT FOR 1999-2000 (E - F) ..............................$ 325,832.82- REPORT 1159(F) 22-Jan-2001 State of Washington 04:23 PM Superintendent of Public Instruction CALCULATION OF 1999-2000 CERTIFICATED INSTRUCTIONAL STAFFING RATIOS 00000 STATE SUMMARY SCHOOL DISTRICT >>>> BASE DATA AS REPORTED BY THE DISTRICT <<<<< GRADES GRADES A. Full-Time Equivalent (FTE) Basic Education K-12 K-4 Certificated Instructional Staff (BEACIS): 1. Form S-275 BEACIS for 1999-2000 47,904.332 18,326.634 2. Form 1158 Supplemental BEACIS for 1999-2000 56.633 39.610 3. Total BEACIS [A.1 + A.2] 47,960.965 18,366.244 B. FTE Basic Education Classified Instructional Assistants (BEACIA): 1. Form S-275 BEACIA for 1999-2000 940.587 2. Form 1158 Supplemental BEACIA for 1999-2000 1.266 3. Total BEACIA [B.1 + B.2] 941.853 C. 1999-2000 FTE Enrollment for Selected Month: 1. October or Month Selected on Form SPI 1160 VARIES BY S.D. 2. FTE Students (Excluding Running Start) 942,605.34 341,411.70 D. Calculated 1999-2000 BEACIS Ratio [A.3/C.2 * 1000] 50.88 53.79 E. Average Salaries Used in the 1.3 Enhancement: 1. Form S-275 BEACIA Avg. Actual Salary 1999-2000 $23,067 2. Form 1191 BEACIS Avg. Alloc. Salary 1999-2000 $41,516 F. Form 1230, 1989-90 BEACIA FTE, Received 3/24/98 723.192 >>>> CALCULATION OF K-4 ENHANCEMENT RATIO <<<< GRADES G. 1. Calculation of K-4 Enhancement Ratio Based on D: K-4 If D => 53.20 then 53.20, otherwise D 0.00 2. Calculation of Credit for Classified Staff for Districts Submitting SPI Form 1230 if D => 51.00 and < 53.20 and B.3 > F: a. Increase in BEACIA [B.3 - F] b. Certificated Staff Ratio Equivalent [E.1 / E.2) * G.2.a * 1000 / C.2] c. BEACIS Credit for BEACIA Staff [Lesser of G.2.b, 1.3 or (53.20 - G.1)] 0.00 3. K-4 Enhancement Ratio [G.1 + G.2.c] (If < 49, 53.00 refer to Report 1191E, line D.1 for the district's State-funded K-4 ratio) GRADES ========== >>>> CALCULATION OF K-12 RATIO COMPLIANCE <<<< K-12 H. Did the district maintain the statutory ratio of 46 BEACIS per 1000 K-12 Students? YES 1. If "NO," K-12 Ratio Shortfall [46.00 - D] 2. Penalty BEACIS FTE [H.1 * K-12 C.2 /1000] 0.054 ========== Rules governing K-12 ratio compliance are codified in Chapter 392-127 WAC. Rules governing the K-4 staff ratio enhancement are codified in WAC 392-140-900 through 913. REPORT 1159-VOC(F) State of Washington 24-Jan-2001 Superintendent of Public Instruction 04:48 PM School Apportionment and Financial Services CALCULATION OF 1999-2000 VOCATIONAL CERTIFICATED STAFFING RATIOS 00000 STATE SUMMARY SCHOOL DISTRICT >>>>>>>>>>>>>>>>>>>>BASE DATA<<<<<<<<<<<<<<<<<<<<<<<<< A. 1999-2000 Vocational Average Monthly Full-Time Equivalent (FTE)Enrollment[Report P-223, Year-to-Date Average FTE] 54,555.97 B. 1999-2000 Vocational FTE Certificated Staff [Report S-275, Program 31, Duty Roots 11-49, 63, & 64] 2,607.987 C. Unadjusted Vocational Staffing Ratio [A / B] 20.92 >>>>>>>>>>SUPPLEMENTAL DATA FROM FORM SPI 1455<<<<<<<<< D. Vocational FTE Enrollment Served by Contracted Staff Not Reported on Report S-275 144.01 E. Net Increase in Vocational Certificated Staff FTE After October 1, 1999 3.275 F. 1. Vocational Certificated Staff Supplemental Hours 52,981 2. FTE Equivalent of Supplemental Hours [F.1 / 900] 58.868 G. 1. Does the District Claim Classified Instructional Assistants Above the State Average? 0 2. District FTE Vocational Classified Instructional Assistants [Report S-275, Program 31, Duty Root 91] 57.534 3. District Classified Instructional Assistants per 1000 FTE Vocational Students [(G.2 / A) * 1000] 89.287 4. District Staff in Excess of the State Average [If G.3 > 2.88 Then (G.3 - 2.88) * A / 1000, Otherwise 0] 30.683 5. Certificate Staff Equivalent [G.4 / 2] 15.342 CALCULATION OF STATE-FUNDED VOCATIONAL STAFFING RATIO H. Adjusted Vocational FTE Enrollment [A - D] 54,411.96 I. Adjusted Vocational FTE Certificated Staff [B + E + F.2 + G.5] 2,685.472 J. Adjusted Vocational Staffing Ratio [H / I] 20.26 K. State-Funded Vocational Certificated Staffing Ratio [If J =< 22.10 Then 19.50; If J => 22.69 Then 20.00; Otherwise (J * 0.882)] 19.55 (This ratio is used on Line D.3 of Report 1191E.) Report 1220R State of Washington 23-Jan-2001 STATE SUMMARY Superintendent of Public Instruction 01:13 PM SPECIAL EDUCATION FOR 1999-2000 Report 1220R 1999-2000 Special Education Allocation - Final 00000 STATE SUMMARY School District Oct - May P-223H Resident Enrollment A. Age 0-2 Resident Special Education Enrollment ..... 1,887.06 B. Age 3-21 Resident Special Education Enrollment ... 116,216.51 C. BEA Resident FTE Enrollment ...................... 948,444.98 D. Age 3-21 Special Ed Enrollment Percent (B/C) ..... 12.25% E. Funded Age 3-21 Special Ed Enrollment Percent If D is less than or equal to 12.7%, D, else 12.7% ...... 11.96% F.1. Funded Age 3-21 Resident Special Education enrollment (C * E) ...................................... 113,389.69 F.2. Special Services Demonstration Project Units ............ 0.00 F.3. Total Funded Ages 3-21 Resident Special Ed Enroll 113,389.69 G. BEA Rate (Report 1191 Section B).......................... 3,728.59 H. Age 0-2 Allocation (A * G * 1.15) ........................ 8,102,029.24 I. Age 3-21 Allocation (F.3. * G * .9309) ................... 393,569,329.72 J. Safety Net Allocation .................................... 7,975,604.46 K. Transfer of Special Education Allocation ................. 0.00 L. Total Special Education Allocation (H + I + J + K) ....... 409,646,963.42 ENROLLMENT BY SERVING DISTRICT A. B. C. TOTAL Report 1220-SNET State of Washington 24-Jan-2001 Page 1 Superintendent of Public Instruction 1999-2000 Special Education Safety Net Calculation 00000 State Totals School District ---- REVISED MONTHLY CALCULATION OF 1999-2000 MAINTENANCE OF STATE REVENUE ---- A. 1994-95 Annual Average Resident Enrollment 1. Ages 0 - 21 Special Education *** 107,232.21 B. 1999-2000 Annual Average Resident Enrollment [ Report 1220R ] 1. K-12 and Running Start Resident AAFTE 948,444.98 2. Ages 0 - 2 Resident Special Education 1,887.06 3. Ages 3 - 21 Resident Special Education 116,216.51 4. Special Services Demonstration Units 0.00 5. Total Ages 3 - 21 Special Education [B.3 + B.4] 116,216.51 C. Ages 3-21 Enrollment Percent 1. 1999-2000 Current Enrollment Percent [B.5 divided by B.1] 12.25% 2. 1999-2000 Current Funded Percent [lesser of C1 or 12.70%) 12.15% D. 1999-2000 Current Funded Resident Enrollment 1. Ages 0 - 2 Special Education [B.2] 1,887.06 2. Ages 3 - 21 Special Education [B.1 times C.2] 113,389.69 3. Ages 0 - 21 Special Education [D.1 plus D.2] 115,276.75 E. 1994-95 Special Education Excess Cost Allocation 1. 1994-95 Actual Based on Resident Enrollment $345,269,271 F. 1999-2000 Current Special Education Excess Cost Allocation 1. 1999-2000 BEA Per-Pupil Rate [ Report 1220R ] $3,724.79 2. Age 0 - 2 Weighted Units [D.1 times 1.15] 2,170.12 3. Age 3 - 21 Weighted Units [D.2 times 0.9309] 105,554.46 4. Excess Cost Allocation [F.1 times (F.2 plus F.3)] $401,362,069 G. Maintenance of State Revenue 1. Aggregate Basis Difference [F.4 minus E.1] $56,092,798.02 2. Per-Pupil Basis Difference [((F.4 divided by D.3) minus $264.64 (E.1 divided by A.1)) times D.3] 3. Loss (Any calculated loss appears as a positive amount on $2,581,006.00 this line.) ------------------------SAFETY NET AWARD SUMMARY -------------------------------- Safety Net Awards shall be adjusted for those districts not maximizing Medicaid billing for special education students under Chapter 318, Laws of 1999. H. Maintenance of State Revenue 1. Maximum Possible Award [ G.3 ] $2,581,006.00 2. District Application Amount [ Form SPI 1381-Maintenance ] $0.00 3. Current Award $2,389,681.00 4. Medicaid Adjustment see 1220-MD $2,503.19 5. Current Award Amount Available $2,387,177.81 ------------ *** Includes special services demonstration units, if applicable, for Edmonds, Omak and Stanwood school districts. Report 1220-SNET 24-Jan-2001 Page 2 1999-2000 Special Education Safety Net Calculation 00000 State Totals School District I. Students Above the Funded Percentage 1. Maximum Possible Award $8,855,277.00 [ $0 or {(B.5 - D.2) times .9309 times F.1} - H.1 ] 2. District Application Amount [ Form SPI 1381-Percentage ] $0.00 3. Current Award $4,431,548.00 4. Medicaid Adjustment see 1220-MD $3,892.35 5. Current Award Amount Available $4,427,655.65 J. Student Demographics 1. District Application Amount [ Form SPI 1381-Demographics $0.00 2. Current Award $1,160,771.00 3. Medicaid Adjustment see 1220-MD $0.00 4. Current Award Amount Available $1,160,771.00 K. Total State Safety Net Awards 1. Safety net awards appearing on line M of Report 1220 $7,982,000.00 [ H.2 plus I.3 plus J.2 ] L. High Cost Individual Students (Federal Award) 1. District Application Amount [ Form SPI 1381-Individuals ] $0.00 2. Medicaid Adjustment see 1220-MD 3. Current Award (district must submit form 1000B to receive $1,794,639.00 4. Medicaid Adjustment see 1220-MD $377.64 5. Current Award Amount Available $1,794,261.36 =================== GENERAL COMMENTS PROVIDED TO ALL DISTRICTS=================== ================================================================================= This report is the Final year end calculation of safety net awards for the 1999-2000 school year. Safety Net funding is provided only to districts making application as provided for in Bulletin No. 62-99 SAFS, dated October 15, 1999. Applications are considered and awards are made by the State Safety Net Oversight Committee. The FINAL meeting of the committee for the 1999-2000 schoool year was June 30th. Safety Net Awards are adjusted for those districts not maximizing Medicaid billing for special education students under Chapter 318, Laws of 1999. ========================== MONTHLY ADJUSTMENTS ================================= This report, 1220-SNET, uses school district data submitted to OPSI as of Final 1999-2000. MAINTENANCE and PERCENTAGE amounts are recalculated monthly throu August 2000. Final Amounts will be recalculated in January 2001. Monthly apportionment for applicant districts awarded the "Full" MAINTENANCE amount is based upon the calculation on line G.3. Monthly apportionment for applicant districts awarded the "Full" PERCENTAGE amount is based upon calculation on line I.1. Monthly apportionment for applicant districts awarded a specific MAINENANCE or PERCENTAGE amount is the lesser of the awarded amount or the amount calculated on this report. Monthly apportionment of state safety net funding awarded by the state oversight committee is made in accordance with the regular monthly apportionment schedule. Report 1220-MD 24-Jan-2001 Page 1 State of Washington Superintendent of Public Instruction 1999-2000 Estimated Medicaid Billing Adjustment to Safety Net Award 00000 State Totals School District ------------ REPORT OF MEDICAID BILLINGS FOR SAFETY NET ADJUSTMENT ------------- A. Medicaid-Eligible Student and Medicaid Billing Infomation 1. 1998-99 Medicaid Eligible Special Education Students 20,974 2. Percentage of Medicaid Eligible Students Billed 97% 3. 1998-99 Eligible Students Billed 20,427 4. 1998-99 Unbilled Students [ Line A.1 - A.3 ] 547 B. Medicaid Reimbursement Information 1. 1998-99 State Average Reimbursement Per Student $269.74 ------------------ CALCULATION OF SAFETY NET AWARD ADJUSTMENT ----------------- C. Estimated Safety Net Award Adjustment 1. Estimated Adjustment for Billed Students $57,273.89 [ 50% -[ Line A.2 / 2 ] * Line A.3 * Line B.1 ] 2. Estimated Adjustment for Unbilled Students $147,547.78 [ Line A.4 * Line B.1 ] 3. Total Estimated Safety Net Award Adjustment $204,821.67 [ Line C.1 + Line C.2 ] ================================= FOOTNOTES ====================================== a. Line A.1 uses the 1999-2000 data. The 1999-2000 data is based upon information as of December 31, 2000. b. The 1999-2000 state average rate is based upon Medicaid billing information for all districts for the 1999-2000 activities. ============================= MONTHLY ADJUSTMENTS ================================ This report, 1220-MD, uses school district Medicaid billing percentage and the eligible Medicaid students reported for 1999-2000. ======================= END-OF-YEAR ADJUSTMENTS ================================== Unexpended state safety net (account 4121) revenues are recovered in January 2001 as part of the 1999-2000 year-end apportionment calculations. Unexpended federal flow-through special education funding from 1999-2000 may result in a recovery or reduction in INDIVIDUAL awards for 1999-2000