Colchester, Connecticut

Excess Cost June (2)

BOE Budget Committee Meeting 2:30PM

← Document Library

budget FY 2020-21 BoardDocs (BOE meetings) 2020-07-13

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                                   6/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,617
                                   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