COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED JANUARY 31, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
40111 CERTIFIED PERSONNEL SALARIES 19,092,672 19,092,672 9,370,442.02 9,966,027.55 (243,797.57) 1, 3 101.3
40111 CERTIFIED DAILY SUBSTITUTES 215,000 215,000 73,797.29 141,202.71 34.3
40111 STIPENDS 410,346 410,346 170,838.56 239,507.44 1 41.6
40112 CLASSIFIED PERSONNEL SALARIES 5,717,069 (42,291) 5,674,778 3,049,948.31 2,394,202.61 230,627.08 1 95.9
40112 CLASSIFIED DAILY SUBSTITUTES 75,000 75,000 17,833.26 57,166.74 23.8
40113 ADDITIONAL STAFF HOURS 30,450 30,450 19,876.91 10,573.09 65.3
40130 CLASSIFIED OVERTIME 34,000 34,000 18,850.58 15,149.42 55.4
41210 EMPLOYEE RELATED INSURANCE 5,297,896 (47) 5,297,849 3,076,024.21 2,104,440.00 117,384.79 2 97.8
41220 SOCIAL SECURITY 408,457 (2,899) 405,558 202,314.31 203,243.69 2 49.9
41221 MEDICARE 376,886 (678) 376,208 178,283.23 197,924.77 2 47.4
41230 PENSION 242,272 (1,692) 240,580 118,500.57 122,079.43 2 49.3
41250 UNEMPLOYMENT 26,350 10,573 36,923 7,302.00 275.00 29,346.00 2 20.5
41260 WORKERS' COMPENSATION INSURANCE 303,718 (56,580) 247,138 191,846.11 55,291.89 0.00 100.0
41290 OTHER EMPLOYEE BENEFITS 287,428 (4,474) 282,954 282,276.44 677.56 99.8
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0.00 0.00 0.0
42535 POSTAGE 17,700 17,700 6,237.07 1,600.00 9,862.93 44.3
42611 INSTRUCTIONAL SUPPLIES 236,209 236,209 162,606.88 23,119.73 50,482.39 78.6
42613 MAINTENANCE SUPPLIES 63,800 63,800 23,742.61 7,290.84 32,766.55 48.6
42614 GROUNDS MAINTENANCE SUPPLIES 24,000 24,000 12,760.58 0.00 11,239.42 53.2
42641 TEXTBOOKS 69,035 69,035 51,967.57 3,181.67 13,885.76 79.9
42642 LIBRARY BOOKS 14,627 14,627 5,879.21 1,425.73 7,322.06 49.9
42643 PERIODICALS 2,630 2,630 2,663.59 0.00 (33.59) 3 101.3
42690 OTHER SUPPLIES/MATERIALS 269,706 269,706 144,719.02 17,176.01 107,810.97 60.0
43320 PROFESSIONAL DEVELOPMENT 51,215 51,215 15,900.05 2,546.88 32,768.07 36.0
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 27,430 27,430 12,592.36 199.00 14,638.64 46.6
43323 PUPIL SERVICES 86,082 86,082 15,133.90 10,131.60 60,816.50 29.4
43326 PUPIL SERVICES PUBLIC ADD'L SERVICES 0 0 40,538.80 77,720.40 (118,259.20) 4,5 100.0
43327 PUPIL SERVICES PRIVATE ADD'L SERVICES 0 0 14,482.42 20,163.28 (34,645.70) 4,5 100.0
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,261,581 (6,710) 1,254,871 708,522.24 518,652.42 27,696.34 97.8
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 753,967 753,967 234,186.78 804,639.94 (284,859.72) 5 137.8
43511 TECH TRANSPORTATION 207,331 (720) 206,611 97,107.46 106,890.33 2,613.21 98.7
43580 TRAVEL 38,501 38,501 5,587.82 1,700.00 31,213.18 18.9
43810 DUES AND FEES 44,290 44,290 32,065.66 828.00 11,396.34 74.3
44203 LEGAL 100,000 100,000 80,202.00 0.00 19,798.00 80.2
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 172,399 172,399 78,082.97 54,565.45 39,750.58 76.9
44340 FINANCIAL MANAGEMENT SERVICES 51,657 51,657 51,657.00 0.00 0.00 100.0
44520 PROPERTY INSURANCE 77,710 28,909 106,619 79,301.58 26,317.84 999.58 99.1
44521 LIABILITY INSURANCE GENERAL 55,501 4,332 59,833 57,745.47 2,087.53 0.00 100.0
44522 LIABILITY INSURANCE TRANSPORTATION 1,058 (225) 833 635.37 197.63 0.00 100.0
44540 ADVERTISING 580 580 580.00 0.00 0.00 100.0
44550 PRINTING 16,185 16,185 5,139.70 7,903.56 3,141.74 80.6
44561 TUITION - VO-AG 95,522 95,522 44,349.50 44,349.50 6,823.00 92.9
44561 TUITION - PUBLIC 1,324,506 1,324,506 593,589.61 813,165.48 (82,249.09) 5 106.2
44562 TUITION - PRIVATE 817,287 817,287 397,548.73 343,558.66 76,179.61 5 90.7
44563 TUITION - SAP OTHER 0 0 0.00 0.00 0.00 5 0.0
44566 TUITION - MAGNET SCHOOLS 337,694 337,694 285,609.32 0.00 52,084.68 84.6
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED JANUARY 31, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 37,513 37,513 33,283.48 0.00 4,229.52 88.7
44610 CURRICULUM IMPLEMENTATION 130,000 130,000 107,354.06 5,177.72 17,468.22 86.6
44815 SOFTWARE LICENSING & SUPPORT 212,024 212,024 195,571.08 4,968.80 11,484.12 94.6
45411 WATER/SEWER 60,850 60,850 26,283.19 0.00 34,566.81 43.2
45530 TELEPHONES 40,770 40,770 21,183.28 0.00 19,586.72 52.0
45620 HEAT ENERGY SUPPLIES 342,225 342,225 84,933.72 0.00 257,291.28 24.8
45622 ELECTRICITY 857,115 857,115 399,167.04 0.00 457,947.96 46.6
45623 PROPANE 500 500 40.06 0.00 459.94 8.0
45626 GASOLINE - MAINTENANCE VEHICLES 750 750 317.93 0.00 432.07 42.4
45627 TRANSPORTATION SUPPLIES 117,000 117,000 42,219.25 0.00 74,780.75 36.1
46410 RECYCLING 30,621 30,621 14,938.02 13,682.14 2,000.84 93.5
46420 CLEANING/REPAIRING MAINTENANCE 105,523 105,523 67,355.43 5,151.53 33,016.04 68.7
46430 EQUIPMENT CONTRACTS - OFFICE 115,011 (7,235) 107,776 44,936.13 30,283.01 32,556.86 69.8
46430 EQUIPMENT CONTRACTS - FACILITIES 125,187 125,187 51,788.82 23,375.43 50,022.75 60.0
46431 VEHICLE MAINTENANCE 750 750 0.00 0.00 750.00 0.0
48730 INSTRUCTIONAL EQUIPMENT 0 0 0.00 0.00 0.00 0.0
48731 NON-INSTRUCTIONAL EQUIPMENT 14,700 14,700 14,752.16 0.00 (52.16) 3 100.4
48733 FURNITURE & FIXTURES 3,500 3,500 0.00 0.00 3,500.00 0.0
48734 OTHER CAPITAL OUTLAY 87,750 (20,263) 67,487 14,818.16 0.00 52,668.84 22.0
50205 TRANSFER TO BOE CAPITAL RESERVE 72,250 289,872 362,122 362,122.00 0.00 0.00 100.0
50260 TRANSFER TO EDUCATION GRANTS FUND 35,000 77,226 112,226 112,226.00 0.00 0.00 100.0
50700 TRANSFER TO DEBT SERVICE FUND 212,336 212,336 212,336.00 0.00 0.00 100.0
50900 CONTINGENCY (100,000) 100,000 0 0.00 0.00 0.00 0.0
TOTAL 41,237,122 367,098 41,604,220 21,844,894.88 17,492,287.16 2,267,037.96 94.6
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 1/31/2020.
(2) Employee benefit amounts reflect only actual expended amounts to date.
(3) Pending budget Transfer
(4) Reclassification of educational services associated with out of district special education placements - need to report separately from tuition costs to maximize
Medicaid reimbursements.
(5) Special Education expenditures subject to reimbursement form Excess Cost grant.