Colchester, Connecticut

Excess Cost - Sent 3-4-21

BOE Budget Committee Meeting 9:00AM

← Document Library

budget FY 2020-21 BoardDocs (BOE meetings) 2021-03-04

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

EXCESS COST 2020 - 2021
                PRIVATE                                                                   3/2/2020       PRIVATE                                                                                                      Per Pupil Exp. 4.5x       $        77,894
                                                    TUITION                                                                 OTHER SERVICES                                      TRANSPORTATION
                                                                                                                                                                                                                                                EXCESS
ID#             BOE Budget                   FORECAST         Cost over Rate       DIFFERENCE            BOE Budget         FORECAST         DIFFERENCE        BOE Budget          FORECAST        DIFFERENCE                  TOTALS           COST AID
8207                             74,534.00        72,362.12                               2,171.88                    -                                   -          29,083.00         35,113.77         (6,030.77)              107,475.89          29,582.20
61203                            47,658.00        52,270.00                              (4,612.00)           16,069.00          16,922.60          (853.60)         26,244.00         30,501.75         (4,257.75)               99,694.35          21,800.66
61508                            74,534.00        72,363.12                               2,170.88                                                        -          26,473.00         27,606.75         (1,133.75)               99,969.87          22,076.18
61609                            47,658.00        52,270.00                              (4,612.00)           14,466.00          14,784.00          (318.00)         24,370.00         24,406.55            (36.55)               91,460.55          13,566.86
62703                            77,552.00                                               77,552.00             1,906.00                            1,906.00          31,441.00                          31,441.00                           -               -
81604                           146,775.00      126,000.00                               20,775.00                                                        -          18,485.00                          18,485.00                126,000.00          48,106.31
92799                            59,946.00        67,800.00                              (7,854.00)            5,150.00          5,000.00           150.00          49,963.00          56,602.16         (6,639.16)              129,402.16          51,508.47
92908                            45,402.00        45,162.00                                   240.00                                                      -          41,530.00         23,744.55        17,785.45                 68,906.55                 -
110101                                            55,863.05                             (55,863.05)                                                       -                            32,785.71        (32,785.71)               88,648.76          10,755.07
62903                                             55,000.00                             (55,000.00)                                                       -                                                                       55,000.00
12601 *                                           70,500.00                             (70,500.00)                              50,525.00       (50,525.00)                           43,421.40                                 164,446.40          86,552.71
T                               574,059.00      669,590.29                     -        (95,531.29)           37,591.00         87,231.60        (49,640.60)       247,589.00         274,182.64        16,827.76              1,031,004.53         283,948.42
*= New students to Colchester                /= now Public        ***= Returned to District                                                                    ^=also SAP          **= Moved       } =Graduated       # = Outplaced


                                                                  PUBLIC                                                                                                                                              Per Pupil Exp. 4.5x       $        77,894
                                                    TUITION                                                                 OTHER SERVICES                                      TRANSPORTATION
                                                                                                                                                                                                                                                EXCESS
ID#             BUDGET                       FORECAST                              DIFFERENCE            BUDGET             FORECAST         DIFFERENCE        BUDGET              FORECAST        DIFFERENCE         TOTALS                    COST AID
        62703                                     31,000.00                             (31,000.00)                                                       -                              9172.14         (9,172.14)               40,172.14                     0
1311                             68,598.00        62,000.00                               6,598.00                                                        -          26,471.00          9,970.41        16,500.59                 71,970.41                 -
1500                            121,652.00        80,630.46                              41,021.54             4,599.00         56,137.20        (51,538.20)         22,603.00        $26,183.91         (3,580.91)              162,951.57          85,057.88
1716***                                                                                           -            1,313.00                            1,313.00                                                     -                           -               -
4409**                            1,669.00                                                1,669.00                                                        -                                                     -                           -
5509                             97,452.00        71,330.28                              26,121.72                              32,330.20        (32,330.20)         42,879.00         47,189.58         (4,310.58)              150,850.06          72,956.37
6813***                           4,357.00                                                4,357.00                                                        -                                                     -                           -               -
6904                              7,028.00         7,892.43                                   (864.43)        10,893.00          1,500.00          9,393.00                                                     -                  9,392.43                 -
6905                            179,363.00      181,108.80                               (1,745.80)           14,570.00         15,048.00           (478.00)        38,316.00          62,702.88        (24,386.88)              258,859.68         180,965.99
8102}                             7,028.00                                                7,028.00             8,267.00                            8,267.00                                                     -                           -               -
8303                              7,028.00                                                7,028.00                                                        -                 -                                   -                           -               -
8902                            168,074.00      119,747.75                               48,326.25             5,519.00         71,800.20        (66,281.20)        45,711.00         $56,781.84        (11,070.84)              248,329.79         170,436.10
9206                             96,562.00      104,763.00                               (8,201.00)                                                       -          45,862.00         51,951.57         (6,089.57)              156,714.57          78,820.88
12909                           113,300.00      121,000.00                               (7,700.00)           23,690.00         22,500.00          1,190.00          14,060.00          8,759.18         5,300.82                152,259.18          74,365.49
22805
Withdrew                          7,028.00                                                7,028.00                                                        -                                                     -                           -               -
32812***                         11,373.00                                               11,373.00                                                        -                                                     -                           -               -
71810                            63,860.00        67,600.00                              (3,740.00)            4,738.00          4,300.00           438.00           16,779.00         13,478.01         3,300.99                 85,378.01           7,484.32
72711                            14,589.00                                               14,589.00                              14,164.20        (14,164.20)                0.00                                -                 14,164.20                 -
81505                            53,238.00        22,883.53                              30,354.47            21,918.00         34,992.74        (13,074.74)         15,017.00         20,898.00         (5,881.00)               78,774.27              880.57
82803                             8,355.00                                                8,355.00                               8,111.92         (8,111.92)                0.00                                -                  8,111.92                 -
92711**                          63,860.00        21,099.80                              42,760.20                 515.00          125.00           390.00          18,952.00           3,428.64        15,523.36                 24,653.44                 -
112907                             834.00                                                     834.00                               810.00           (810.00)                                                    -                     810.00                -
121101                           72,117.00        80,630.46                              (8,513.46)            4,599.00          5,280.00           (681.00)         47,359.00         30,598.53        16,760.47                116,508.99          38,615.30
10104                                              7,892.43                              (7,892.43)                              1,800.00         (1,800.00)                                                    -                  9,692.43
102706                                             7,892.43                              (7,892.43)                                                       -                                                     -                  7,892.43
102904                                                                                            -                              2,358.00         (2,358.00)                                                    -                  2,358.00
92112                                                                                             -                                810.00           (810.00)                                                    -                     810.00
81016                                                                                             -                              5,250.00         (5,250.00)                                                    -                  5,250.00
                                                   TUITION                                                               OTHER SERVICES                                      TRANSPORTATION
9606*                                           62,000.00                               (62,000.00)                                                    -                           17,264.60       (17,264.60)               79,264.60          1,370.91
62906                                           37,755.12                               (37,755.12)                                                    -                           15,754.77       (15,754.77)               53,509.89
62304                                           53,043.76                               (53,043.76)                                                    -                            6,290.90        (6,290.90)               59,334.66
1910                                            62,000.00                               (62,000.00)                            4,820.00        (4,820.00)                          18,951.39       (18,951.39)               85,771.39          7,877.70
T                           1,167,365.00     1,202,270.25                               (34,905.25)         100,621.00       282,137.46      (181,516.46)       334,009.00        399,376.35       (65,367.35)            1,883,784.06        718,831.47
*= New students to Colchester              ***= Returned to District                **= Moved                                             **= Moved         @@Exited Services                  # = Outplaced


                                                                STATE AGENCY                                                                                                                                     Per Pupil Exp. 1 x       $        17,310
                                                   TUITION                                                               OTHER SERVICES                                      TRANSPORATION
                                                                                                                                                                                                                                          EXCESS
ID#           BUDGET                       FORECAST                                 DIFFERENCE        BUDGET             FORECAST         DIFFERENCE        BUDGET           FORECAST          DIFFERENCE        TOTALS                   COST AID
                                                                                                 -                                                     -                                 -                  -                         -
                                                                                                 -                                                     -                                 -                  -                         -


**= Moved                                  ***= Returned to District
                                                                &= Now Private Tuition                                                                      ## Now State Placed
              STATUS Without EXCESS COST estimate
                                           BUDGET               FORECAST            DIFFERENCE        Estimated TUITON Status                (361,593.60)
Tuit.         PRIVATE                          611,650.00              756,821.89      (145,171.89)   Estimated TRANS. Status                (164,338.69)
              PUBLIC                         1,267,986.00         1,484,407.71         (216,421.71)   Estimated cost over rate                         -
              SAP                                     -                       -                  -    Total                                  (525,932.29)
              Total                          1,879,636.00         2,241,229.60         (361,593.60)
                                                                                                      EXCESS COST ESTIMATES (Tuition and Transportation)
Trans         PRIVATE                          247,589.00              274,182.64       (26,593.64)   Private                                 283,948.42
              PUBLIC                           334,009.00              399,376.35       (65,367.35)   Public                                  718,831.47
              SAP                                     -                       -                  -    SAP                                              -
              Total                           581,598.00               673,558.99       (91,960.99)
                                                                                                      Total                                 1,002,779.89
Trans         In Dictrict                  BUDGET               FORECAST            DIFFERENCE
              Run 1                                   -                 31,988.13       (31,988.13)
              Run 2                                   -                 43,972.14       (43,972.14)   EXCESS COST SUMMARY REPORT
              Run 3                                   -                 26,849.54       (26,849.54)   estimate
              Run 4                                   -                 55,291.88       (55,291.88)   Expected Entitlement                  1,002,779.89
              Run 5                                   -                 52,613.08       (52,613.08)   *Loss Due to 0% Cap                              -
              Run 6                                   -                 50,495.38       (50,495.38)   Subtotal                              1,002,779.89
              Run 7                                   -                 44,786.64       (44,786.64)
              Alt Ed                                  -                 16,966.91       (16,966.91)   BOE Deficit                            (525,932.29)
              Total                           250,586.00               322,963.70       (72,377.70)


                                                                                                      Revenue to Town General Fund                              476,847.60
Grand Total                                  2,711,820.00         3,237,752.29         (525,932.29)
                                                                                                      EXCESS COST SUMMARY REPORT
                                                                                                      estimate
                                                                                                      Expected Entitlement                  1,002,779.89
                                                                                                      *Loss Due to 77% Cap                    230,639.37
                                                                                                      Subtotal                                772,140.51
                                                                                                      BOE Deficit                            (525,932.29)


                                                                                                      Revenue to Town General Fund                              246,208.22