Colchester, Connecticut

Excess Cost May 2020

BOE Budget Committee Meeting 9:00AM

← Document Library

budget FY 2019-20 BoardDocs (BOE meetings) 2020-05-07

Machine-extracted text of a publicly posted document, provided for reference and search. The original document at the link above is authoritative.

EXCESS COST 2019 - 2020
           Private                                   5/1/2020                                                         Per Pupil Exp. 4.5x       $        74,843
                                 TUITION                                          TRANSPORTATION
                                                                                                                                                EXCESS
ID#        BOE Budget          FORECAST        DIFFERENCE         BOE Budget      FORECAST         DIFFERENCE                TOTALS             COST AID
8207            88,010.32          83,445.74         4,564.58         28,380.80        28,236.00           144.80               111,681.74           36,838.74
11401          143,994.00         144,000.00             (6.00)            0.00                                 -               144,000.00           69,157.00
32402           68,988.63                           68,988.63         15,027.55                          15,027.55                          -               -
61203            67,665.34         61,870.90         5,794.44         45,828.00        25,480.00        20,348.00                 87,350.90          12,507.90
61508            88,010.32         83,445.74         4,564.58         25,463.08        25,702.00          (238.92)              109,147.74           34,304.74
61609                    -         60,314.80       (60,314.80)             0.00        23,660.00       (23,660.00)                83,974.80           9,131.80
61705                                                       -         40,243.54                         40,243.54                           -               -
62703            68,988.63         31,745.22        37,243.41         17,131.00         8,325.40         8,805.60                 40,070.62                 -
81604           157,526.25        142,500.00        15,026.25              0.00        17,946.36       (17,946.36)              160,446.36           85,603.36
92799            69,010.00         69,060.00            (50.00)      48,370.44         48,508.00          (137.56)              117,568.00           42,725.00
92908                    -         44,080.00        (44,080.00)            0.00        40,320.00       (40,320.00)                84,400.00           9,557.00
T              752,193.49         720,462.40        31,731.09       220,444.41        218,177.76         2,266.65               938,640.16          299,825.54
*= New students to Colchester                                     ^=also SAP      **= Moved        } =Graduated       # = Outplaced


           Public                                                                                                     Per Pupil Exp. 4.5x       $        74,843
                                 TUITION                                          TRANSPORTATION
                                                                                                                                                EXCESS
ID#        BUDGET              FORECAST        DIFFERENCE         BUDGET          FORECAST         DIFFERENCE         TOTALS                    COST AID
1311                     -         40,988.36        (40,988.36)                        25,773.00       (25,773.00)                66,761.36                 -
1500            134,885.85        135,352.66          (466.81)        21,861.40        21,945.00            (83.60)             157,297.66           82,454.66
2302                7,565.94                         7,565.94              0.00                                 -                           -               -
2602            33,742.60                           33,742.60                                                   -                           -               -
5509           101,001.86          95,139.03         5,862.83              0.00        41,630.00       (41,630.00)              136,769.03           61,926.03
6813                3,090.00        4,230.00         (1,140.00)            0.00                                 -                  4,230.00                 -
6904                3,399.00                         3,399.00              0.00                                 -                           -               -
6905           187,715.95         188,285.20          (569.25)       36,691.20         37,200.00          (508.80)              225,485.20          150,642.20
8102                8,389.45                         8,389.45              0.00                                 -                           -               -
8303                2,480.88                         2,480.88              -                                    -                           -               -
8902           189,993.53         168,536.56        21,456.97        36,336.00                          36,336.00               168,536.56           93,693.56
9206            105,274.24         93,750.00        11,524.24         41,611.90        44,526.00         (2,914.10)             138,276.00           63,433.00
11101            14,156.67                          14,156.67              0.00                                 -                           -               -
12909           65,093.50         133,000.00       (67,906.50)        19,910.00        13,650.00         6,260.00               146,650.00           71,807.00
21999            63,874.42         52,420.00        11,454.42         22,842.40        38,010.00       (15,167.60)                90,430.00          15,587.00
52802                    -         15,504.00       (15,504.00)             0.00        11,538.00       (11,538.00)                27,042.00                 -
61705           66,885.63                           66,885.63                                                   -                           -               -
62703                    -         35,477.32       (35,477.32)                         11,793.50       (11,793.50)                47,270.82                 -
63200           65,093.50          72,600.00         (7,506.50)       12,025.00        16,290.00         (4,265.00)               88,890.00          14,047.00
72098           56,994.95          54,052.00         2,942.95         40,855.32        40,906.00            (50.68)               94,958.00          20,115.00
72711               4,274.50                         4,274.50              0.00                                 -                           -               -
81505           65,311.27          72,967.00         (7,655.73)            0.00        14,580.00       (14,580.00)                87,547.00          12,704.00
82803            12,814.61          8,111.92         4,702.69              0.00                                 -                  8,111.92                 -
92698          101,004.89          99,717.00         1,287.89              -                                    -                 99,717.00          24,874.00
92711                    -         62,500.00        (62,500.00)            -           18,400.00       (18,400.00)                80,900.00           6,057.00
121101           82,399.11         81,961.96           437.15         46,941.40        45,980.00           961.40               127,941.96           53,098.96
121902          14,156.67                           14,156.67                                                                               -               -
T             1,389,599.02      1,414,593.01       (24,993.99)      279,074.62        382,221.50      (103,146.88)             1,796,814.51         670,439.41
*= New students to Colchester                  **= Moved          @@Exited Services                # = Outplaced
                                                                                                                     Per Pupil Exp. 1 x       $        16,632
                                   TUITION                                         TRANSPORATION
                                                                                                                                              EXCESS
ID#         BUDGET              FORECAST         DIFFERENCE         BUDGET         FORECAST        DIFFERENCE        TOTALS                   COST AID
                                                              -                                -                -                         -               -
                                                              -                                -                -                         -               -


**= Moved                       ***= Returned to District           ## Now State Placed
            STATUS Without EXCESS COST estimate
                                BUDGET           DIFFERENCE         Estimated TUITON Status              6,737.10
Tuit.       PRIVATE                752,193.49         31,731.09     Estimated TRANS. Status           (129,287.77)
            PUBLIC                1,389,599.02        (24,993.99)   Estimated cost over rate                    -
            SAP                            -                  -     Total                             (122,550.67)
            Total                2,141,792.51          6,737.10
                                                                    EXCESS COST ESTIMATES (Tuition and Transportation)
Trans       PRIVATE                220,444.41          2,266.65     Private                            299,825.54
            PUBLIC                 279,074.62       (103,146.88)    Public                             670,439.41
            SAP                            -                  -     SAP                                         -
            Total                  499,519.03       (100,880.23)
                                                                    Total                              970,264.95
Trans       In Dictrict         BUDGET           DIFFERENCE
            V #1 (10CES)             20,060.00              42.00
            V #2 (16,18,11 CE        32,309.00         (2,003.00)   EXCESS COST SUMMARY REPORT
            V #3 (14CES)             21,610.00        11,774.46     estimate
            V #4 (15 CES)            14,050.00          1,490.00    Expected Entitlement               970,264.95
            Van # 6(misc)             3,764.00          3,764.00    *Loss Due to 0% Cap                         -
            Van#10( Bacon 13         55,608.00        (22,321.00)   Subtotal                           970,264.95
            V # 13 JJIS, WJJM        26,445.00        (21,154.00)
            Total                  173,846.00        (28,407.54)    BOE Deficit                       (122,550.67)



        Grand Total              2,815,157.54       (122,550.67)    Revenue to Town General Fund                                847,714.28


                                                                    EXCESS COST SUMMARY REPORT
                                                                    estimate
                                                                    Expected Entitlement               970,264.95
                                                                    *Loss Due to 77% Cap               223,160.94
                                                                    Subtotal                           747,104.01
                                                                    BOE Deficit                       (122,550.67)


                                                                    Revenue to Town General Fund                                624,553.34