Colchester, Connecticut

Excess Cost - 2-1-22

Board of Education Meeting 6:00PM

← Document Library

budget FY 2021-22 BoardDocs (BOE meetings) 2022-02-08

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

A                    B                  C                      D           E            F              G              H         I                   J                M           N         O                  P                   Q                       R                       S
 1                                                                                                      EXCESS COST 2021 - 2022
 2                                 PRIVATE                                                                     2/1/2022           PRIVATE                                                                                                              Per Pupil Exp. 4.5x       $    77,866.70
 3                                                                      TUITION                                                                       OTHER SERVICES                                          TRANSPORTATION
 4                                                                                                                                                                                                                                                                               EXCESS
 5 ID#         PO#                 BOE Budget                    FORECAST         Cost over Rate        DIFFERENCE                BOE Budget          FORECAST         DIFFERENCE            BOE Budget          FORECAST           DIFFERENCE                  TOTALS           COST AID
 6 8207        225045                                74,716.33        79,561.44                               (4,845.11)                                                            -              34,315.01         31,292.10            3,022.91                110,853.54          32,986.85
 7 61508       225044                                74,716.33        77,719.74                               (3,003.41)                                                            -              26,433.10         31,292.10            (4,859.00)              109,011.84          31,145.15
 8 61609       225043                                53,838.10        52,730.00                                1,108.10                15,227.52           11,404.58         3,822.94              25,184.55         56,842.80           (31,658.25)              120,977.38          43,110.69
 9 81604                                            144,231.00                                              144,231.00                                                              -                     0.00               -                   -                           -                -
10 92799 }                                            7,073.00        11,444.44                               (4,371.44)                    572.23           730.56           (158.33)              5,285.66         10,920.00            (5,634.34)               23,095.00
11 92908       225022                                45,918.00        46,327.73                                    (409.73)                                                         -             21,522.07          51,294.60           (29,772.53)               97,622.33          19,755.64
12 110101/                                                                                                             -                                                            -              27,014.70                 0.00        27,014.70                           -                -
13 112311*     225079                                                 52,785.00                              (52,785.00)                                                            -                                15,255.00           (15,255.00)               68,040.00
14 62706*      225080                                                 52,785.00                              (52,785.00)                                                                                             15,255.00           (15,255.00)               68,040.00
15
16 T                                                400,492.76      373,353.35                      -         27,139.41                15,799.75          12,135.14          3,664.61            139,755.09         212,151.60           (72,396.51)              597,640.09         126,998.31
17 *= New students to Colchester                                 /= now Public         ***= Returned to District                                                                             ^=also SAP          **= Moved          } =Graduated       # = Outplaced
18
19                                                                                     PUBLIC                                                                                                                                                          Per Pupil Exp. 4.5x       $    77,866.70
20                                                                      TUITION                                                                       OTHER SERVICES                                          TRANSPORTATION
21                                                                                                                                                                                                                                                                               EXCESS
22 ID#         PO#                 BUDGET                        FORECAST                               DIFFERENCE                BUDGET              FORECAST         DIFFERENCE            BUDGET              FORECAST           DIFFERENCE         TOTALS                    COST AID
23 62304       225032                                63,860.00        64,480.00                                    -620.00                                                                          6,478.00         13,860.00                                        78,340.00 $         473.31
24 10104                                              8,267.76         8,026.95                                    240.81               1,854.00            1,500.00          354.00                                                             -                    9,526.95
25 5509                                              73,470.19        73,470.54                                      (0.35)            33,300.11          33,810.10           (509.99)             39,690.42         50,565.90           (10,875.48)              157,846.54          79,979.85
26 1910        225030                                69,628.00        71,286.22                               (1,658.22)                3,708.00           9,450.00         (5,742.00)             21,415.07        $26,147.10            (4,732.03)              106,883.32          29,016.63
27 1311        225029                                69,628.00        64,480.00                                5,148.00                                                             -              12,164.67        $24,192.00           (12,027.33)               88,672.00          10,805.31
28 62703 }                                           63,680.00              -                                 63,680.00                                                             -               9,447.31                              9,447.31                           -
29 62906**                                           63,680.00              -                                 63,680.00                                                             -              16,227.42                             16,227.42                           -
30 102706                                             8,267.76         8,026.95                                    240.81                                                           -                                                            -                    8,026.95
31 9606                                              69,628.00              -                                 69,628.00                                                             -              18,709.80                             18,709.80                           -
32 6904                                               8,267.76         8,026.95                                    240.81               1,854.00           1,500.00           354.00                                                                                  9,526.95
33 102904                                                                                                              -                2,428.74           2,358.00              70.74                                                           -                    2,358.00
34 8902        225028                               135,432.28      129,561.72                                 5,870.56                61,862.10          82,748.01        (20,885.91)             54,799.14         56,857.50            (2,058.36)              269,167.23         191,300.54
35 71810       225031                                69,628.00        71,286.22                               (1,658.22)                4,429.00           6,300.00         (1,871.00)            13,661.93          15,815.10            (2,153.17)               93,401.32          15,534.63
36 9206        225035                               107,905.89        96,278.00                               11,627.89                                   10,218.00        (10,218.00)            42,479.96         $47,460.00            (4,980.04)              153,956.00          76,089.31
37 1500         225027                               64,052.00        39,256.35                               24,795.65                 2,348.40          30,784.82        (28,436.42)             11,587.60         23,522.80           (11,935.20)               93,563.97          15,697.28
38 72711                                              8,100.13         8,301.10                                    (200.97)             6,489.00           5,615.00           874.00                                                             -                 13,916.10
39 12909        225085                              124,630.00      126,475.00                                (1,845.00)               23,175.00          34,275.00        (11,100.00)             10,514.79         17,250.00            (6,735.21)              178,000.00         100,133.31
40 121101       225026                               83,049.37        76,456.80                                6,592.57                 5,438.40           5,462.50            (24.10)             24,140.38         37,374.00           (13,233.62)              119,293.30          41,426.61
41 81016                                                                                                               -                5,407.50           6,650.00         (1,242.50)                                                           -                    6,650.00
42 92112        225070                                                                                                 -                       0.00          855.00           (855.00)                                                           -                     855.00
43 72605                                                                                                               -                                                            -                                                            -                           -
44 6905         225025                              193,870.37      184,730.40                                 9,139.97                17,742.78          16,953.64           789.14              71,668.22          71,391.60              276.62                273,075.64         195,208.95
45 82803 }                                            7,706.92              -                                  7,706.92                                                             -                                                            -                           -
46 6906         225086                                                 8,026.95                               (8,026.95)                                     750.00           (750.00)                                                           -                    8,776.95
47 22605 #      225033                                                64,480.00                              (64,480.00)                                                            -                                                            -                 64,480.00
48 61203        225021                                                42,300.00                              (42,300.00)                                                            -                                                            -                 42,300.00
49 11207 #                                                            32,107.80                              (32,107.80)                                   3,000.00         (3,000.00)                                                           -                 35,107.80
50 82806 #                                                             8,026.95                               (8,026.95)                                   1,500.00         (1,500.00)                                                           -                    9,526.95
         A                   B                   C                         D          E            F               G           H             I                J              M           N         O                 P                Q                      R                      S
 3                                                                          TUITION                                                                   OTHER SERVICES                                          TRANSPORTATION
51
52
53
54
55 T                                                 1,293,344.00     1,120,604.90                               108,287.53              170,454.00       253,730.07       (83,693.04)           352,985.00        370,576.00       (24,069.29)            1,744,910.97        755,665.68
56 *= New students to Colchester                                    ***= Returned to District                **= Moved                                                 **= Moved             @@Exited Services                  # = Outplaced
57
58                                                                                        STATE AGENCY                                                                                                                                            Per Pupil Exp. 1 x       $        17,304
59                                                                          TUITION                                                                   OTHER SERVICES                                          TRANSPORATION
60                                                                                                                                                                                                                                                                         EXCESS
61 ID#         PO#                 BUDGET                           FORECAST                                 DIFFERENCE            BUDGET             FORECAST         DIFFERENCE            BUDGET           FORECAST          DIFFERENCE        TOTALS                   COST AID
62                                                                                                                        -                                                         -                                     -                  -                         -
63                                                                                                                        -                                                         -                                     -                  -                         -
64
65 **= Moved                                                        ***= Returned to District
                                                                                         &= Now Private Tuition                                                                              ## Now State Placed
66                                 STATUS Without EXCESS COST estimate
67                                                                  BUDGET                FORECAST           DIFFERENCE            Estimated TUITON Status                 120,267.05
68 Tuit.                           PRIVATE                              416,292.51              385,488.49        30,804.02        Estimated TRANS. Status                (136,333.71)
69                                 PUBLIC                             1,463,798.00         1,374,334.97           89,463.03        Estimated cost over rate                #REF!
70                                 SAP                                         -                       -                  -        Total                                   #REF!
71                                 Total                              1,880,090.51         1,759,823.46          120,267.05
72                                                                                                                                 EXCESS COST ESTIMATES (Tuition and Transportation)
73 Trans                           PRIVATE                              139,755.09              212,151.60       (72,396.51)       Private                                 126,998.31
74                                 PUBLIC                               352,985.00              370,576.00       (17,591.00)       Public                                  755,665.68
75                                 SAP                                         -                       -                  -        SAP                                              -
76                                 Total                               492,740.09               582,727.60       (89,987.51)
77                                                                                                                                 Total                                   882,663.99
78 Trans                           In Dictrict                      BUDGET                FORECAST           DIFFERENCE
79                                 Run 1                                       -                 43,711.50       (43,711.50)
80                                 Run 2                                       -                 41,050.80       (41,050.80)       EXCESS COST SUMMARY REPORT
81                                 Run 3                                       -                 40,906.00       (40,906.00)       estimate
82                                 Run 4                                       -                 40,906.00       (40,906.00)       Expected Entitlement                    882,663.99
83                                 Run 5                                       -                 45,231.90       (45,231.90)       *Loss Due to 0% Cap                              -
84                                 Run 6                                       -                 64,255.00       (64,255.00)       Subtotal                                882,663.99
85                                 Run 7                                       -                 40,906.00       (40,906.00)
86                                 Alt Ed                                      -                                          -        BOE Deficit                             #REF!
87                                 Total                               270,621.00               316,967.20       (46,346.20)
88
89                                                                                                                                 Revenue to Town General Fund                                   #REF!
90 Grand Total                                                        2,643,451.60         2,659,518.26          (16,066.66)
91                                                                                                                                 EXCESS COST SUMMARY REPORT
92                                                                                                                                 estimate
93                                                                                                                                 Expected Entitlement                    882,663.99
94                                                                                                                                 *Loss Due to 77% Cap                    203,012.72
95                                                                                                                                 Subtotal                                679,651.27
96                                                                                                                                 BOE Deficit                             #REF!
97
98                                                                                                                                 Revenue to Town General Fund                                   #REF!