Colchester, Connecticut

BOE Excess Cost - 5-1-22

Board of Education Meeting 6:00PM

← Document Library

other FY 2021-22 BoardDocs (BOE meetings) 2022-05-10

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

A                   D                   E                      F           G         H                 I              J         K                   L                O             P         Q                  R                    S                      T                     U
 1                                                                                                     EXCESS COST 2021 - 2022
 2                                 PRIVATE                                                                    5/1/2022            PRIVATE                                                                                                                 Per Pupil Exp. 4.5x       $    83,749.50
 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           27,104.04
 7 61508      225044                                 74,716.33       77,719.74                                (3,003.41)                                                            -                26,433.10         31,292.10            (4,859.00)              109,011.84           25,262.34
 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           37,227.88
 9 81604                                            144,231.00        19,333.43                             124,897.57                                                              -                       0.00               -                    -                 19,333.43                -
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          13,872.83
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      392,686.78                     -          7,805.98                 15,799.75          12,135.14          3,664.61              139,755.09         212,151.60          (72,396.51)               616,973.52          103,467.09
17 *= New students to Colchester                                 /= now Public         ***= Returned to District                                                                               ^=also SAP          **= Moved          } =Graduated        # = Outplaced
18
19                                                                                     PUBLIC                                                                                                                                                             Per Pupil Exp. 4.5x       $    83,749.50
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.70         16,966.00                                        81,446.00
24 10104      225115                                  8,267.76         7,404.80                                    862.96               1,854.00            1,500.00          354.00                                                                -                   8,904.80
25 5509       225099                                 73,470.19       73,470.54                                       (0.35)            33,300.11          33,810.10           (509.99)               39,690.41         50,565.90          (10,875.49)               157,846.54           74,097.04
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           23,133.82
27 1311       225029                                 69,628.00       64,480.00                                5,148.00                                                              -                12,164.67        $24,192.00          (12,027.33)                 88,672.00           4,922.50
28 62703 }                                           63,860.00              -                                63,860.00                                                              -                 9,447.31                              9,447.31                            -
29 62906**                                           63,860.00              -                                63,860.00                                                              -                16,227.42                             16,227.42                            -
30 102706     225116                                  8,267.76         7,404.80                                    862.96                                                           -                                                               -                   7,404.80
31 6904       225114                                  8,267.76         7,404.80                                    862.96               1,854.00           1,500.00           354.00                                                                                    8,904.80
32 102904     225111                                                                                                   -                2,428.74           1,763.50           665.24                                                                -                   1,763.50
33 8902       225028                                135,432.28      129,561.72                                5,870.56                 61,862.10          82,748.01        (20,885.91)               54,799.14         66,191.25          (11,392.11)               278,500.98          194,751.48
34 71810      225031                                 69,628.00       42,270.00                               27,358.00                  4,429.00           3,495.00           934.00                13,661.93           9,655.10            4,006.83                  55,420.10
35 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           70,206.50
36 1500        225027                                64,052.00       39,256.35                               24,795.65                  2,348.40          30,784.82        (28,436.42)               11,587.60         21,848.40          (10,260.80)                 91,889.57           8,140.07
37 72711       225093                                 8,100.13         8,301.10                                    (200.97)             6,489.00           5,615.00           874.00                                                                -                 13,916.10
38 12909       225085                               124,630.00      126,475.00                                (1,845.00)               23,175.00          34,275.00        (11,100.00)               10,514.79         20,356.00            (9,841.21)              181,106.00           97,356.50
39 121101      225026                                83,049.37       76,456.80                                6,592.57                  5,438.40           5,462.50              (24.10)             24,140.38         76,598.25          (52,457.87)               158,517.55           74,768.05
40 81016       225092                                                                                                  -                5,407.50           6,650.00         (1,242.50)                                                              -                   6,650.00
41 92112       225070                                                                                                  -                       0.00          855.00           (855.00)                                                              -                     855.00
42 72605                                                                                                               -                                                            -                                                               -                           -
43 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          189,326.14
44 82803 }                                            7,938.13              -                                 7,938.13                      417.15                            417.15                                                                -                           -              -
45 6906        225086                                69,628.00         8,026.95                              61,601.05                                       750.00           (750.00)               18,709.80                             18,709.80                    8,776.95
46 22605 #     225033                                                64,480.00                              (64,480.00)                                                             -                                                               -                 64,480.00
47 61203       225021                                                42,300.00                              (42,300.00)                                                             -                                                               -                 42,300.00
48 11207 #     225113                                                29,619.20                              (29,619.20)                                    3,000.00         (3,000.00)                                                              -                 32,619.20
49 82806 #     225112                                                  7,404.80                               (7,404.80)                                   1,500.00         (1,500.00)                                                              -                   8,904.80
         A                  D                    E                         F          G           H                I           J             K                L              O           P         Q                 R                S                      T                    U
 3                                                                          TUITION                                                                   OTHER SERVICES                                          TRANSPORTATION
50 101706                                                                                                                                                     382.50          (382.50)                                                       -                    382.50
51 112205                                                                                                                                                                                                            2,034.00        (2,034.00)                  2,034.00
52
53
54 T                                                 1,293,343.64     1,151,091.48                               142,252.16              170,454.18      250,713.07        (80,258.89)           352,985.40        433,405.60       (69,932.90)            1,835,210.15         736,702.10
55 *= New students to Colchester                                    ***= Returned to District                **= Moved                                                 **= Moved             @@Exited Services                  # = Outplaced
56
57                                                                                        STATE AGENCY                                                                                                                                            Per Pupil Exp. 1 x        $        17,304
58                                                                          TUITION                                                                   OTHER SERVICES                                          TRANSPORATION
59                                                                                                                                                                                                                                                                          EXCESS
60 ID#         PO#                 BUDGET                           FORECAST                                 DIFFERENCE            BUDGET             FORECAST         DIFFERENCE            BUDGET           FORECAST          DIFFERENCE        TOTALS                    COST AID
61                                                                                                                        -                                                         -                                     -                  -                         -
62                                                                                                                        -                                                         -                                     -                  -                         -
63
64 **= Moved                                                        ***= Returned to District
                                                                                        &= Now Private Tuition                                                                               ## Now State Placed
65                                 STATUS Without EXCESS COST estimate
66                                                                  BUDGET                FORECAST           DIFFERENCE            Estimated TUITON Status                  73,463.86
67 Tuit.                           PRIVATE                             416,292.51               404,821.92        11,470.59        Estimated TRANS. Status                (199,162.91)
68                                 PUBLIC                             1,463,797.82         1,401,804.55           61,993.27        Estimated cost over rate                         -
69                                 SAP                                         -                       -                  -        Total                                  (125,699.05)
70                                 Total                             1,880,090.33          1,806,626.47           73,463.86
71                                                                                                                                 EXCESS COST ESTIMATES (Tuition and Transportation)
72 Trans                           PRIVATE                             139,755.09               212,151.60       (72,396.51)       Private                                 103,467.09
73                                 PUBLIC                              352,985.40               433,405.60       (80,420.20)       Public                                  736,702.10
74                                 SAP                                         -                       -                  -        SAP                                              -
75                                 Total                               492,740.49               645,557.20      (152,816.71)
76                                                                                                                                 Total                                   840,169.19
77 Trans                           In Dictrict                      BUDGET                FORECAST           DIFFERENCE
78                                 Run 1                                       -                 43,711.50       (43,711.50)
79                                 Run 2                                       -                 41,050.80       (41,050.80)       EXCESS COST SUMMARY REPORT
80                                 Run 3                                       -                 40,906.00       (40,906.00)       estimate
81                                 Run 4                                       -                 40,906.00       (40,906.00)       Expected Entitlement                    840,169.19
82                                 Run 5                                       -                 45,231.90       (45,231.90)       *Loss Due to 0% Cap                              -
83                                 Run 6                                       -                 64,255.00       (64,255.00)       Subtotal                                840,169.19
84                                 Run 7                                       -                 40,906.00       (40,906.00)
85                                 Alt Ed                                      -                                          -        BOE Deficit                            (125,699.05)
86                                 Total                               270,621.00               316,967.20       (46,346.20)
87
88                                                                                                                                 Revenue to Town General Fund                                  714,470.14
89 Grand Total                                                       2,643,451.82          2,769,150.87         (125,699.05)
90                                                                                                                                 EXCESS COST SUMMARY REPORT
91                                                                                                                                 estimate
92                                                                                                                                 Expected Entitlement                    840,169.19
93                                                                                                                                 *Loss Due to 77% Cap                    193,238.91
94                                                                                                                                 Subtotal                                646,930.28
95                                                                                                                                 BOE Deficit                            (125,699.05)
96
97                                                                                                                                 Revenue to Town General Fund                                  521,231.23