8.2.1
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED OCTOBER 31, 2017
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
40111 CERTIFIED PERSONNEL SALARIES 18,967,772 18,967,772 3,951,880.23 14,204,478.82 811,412.95 1 95.7
40111 CERTIFIED DAILY SUBSTITUTES 225,535 225,535 31,365.00 194,170.00 0.0
40111 STIPENDS 349,847 349,847 0.00 349,847.00 1 0.0
40112 CLASSIFIED PERSONNEL SALARIES 5,375,745 (28,466) 5,347,279 1,382,078.11 3,531,107.12 434,093.77 1 91.9
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 6,952.27 73,047.73 0.0
40113 ADDITIONAL STAFF HOURS 38,231 38,231 18,868.22 19,362.78 49.4
40130 CLASSIFIED OVERTIME 34,500 34,500 9,150.74 25,349.26 26.5
41210 EMPLOYEE RELATED INSURANCE 5,353,368 5,353,368 1,757,285.32 3,465,464.00 130,618.68 2 97.6
41220 SOCIAL SECURITY 385,768 385,768 92,081.27 293,686.73 2 23.9
41221 MEDICARE 362,060 362,060 74,388.82 287,671.18 2 20.5
41230 PENSION 225,463 225,463 56,501.34 168,961.66 2 25.1
41250 UNEMPLOYMENT 13,000 13,000 5,803.20 500.00 6,696.80 2 48.5
41260 WORKERS' COMPENSATION INSURANCE 273,473 273,473 148,437.67 122,438.33 2,597.00 99.1
41290 OTHER EMPLOYEE BENEFITS 62,917 62,917 70,686.56 (7,769.56) 3 112.3
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0.00 0.00 0.0
42535 POSTAGE 18,450 18,450 1,427.60 17,022.40 7.7
42611 INSTRUCTIONAL SUPPLIES 226,491 226,491 35,818.83 10,152.89 180,519.28 20.3
42613 MAINTENANCE SUPPLIES 65,250 65,250 9,397.94 7,116.53 48,735.53 25.3
42614 GROUNDS MAINTENANCE SUPPLIES 26,664 26,664 16,777.81 9,886.19 62.9
42641 TEXTBOOKS 105,096 105,096 21,251.42 29,796.39 54,048.19 48.6
42642 LIBRARY BOOKS 29,955 29,955 0.00 29,955.00 0.0
42643 PERIODICALS 5,294 5,294 487.75 4,806.25 9.2
42690 OTHER SUPPLIES/MATERIALS 281,683 153 281,836 21,412.27 18,798.98 241,624.75 14.3
43320 PROFESSIONAL DEVELOPMENT 43,545 (153) 43,392 7,286.27 320.00 35,785.73 17.5
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 30,400 30,400 1,578.88 11,250.00 17,571.12 42.2
43323 PUPIL SERVICES 125,427 125,427 14,722.50 46,866.00 63,838.50 49.1
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,160,440 1,160,440 374,858.83 733,846.40 51,734.77 95.5
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 901,531 901,531 314,530.58 581,790.50 5,209.92 4 99.4
43511 TECH TRANSPORTATION 199,174 199,174 46,101.05 69,890.08 83,182.87 58.2
43580 TRAVEL 43,777 43,777 1,116.64 42,660.36 2.6
43810 DUES AND FEES 51,072 51,072 21,199.50 29,872.50 41.5
44203 LEGAL 85,000 85,000 27,549.62 57,450.38 32.4
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 202,016 28,466 230,482 53,678.85 53,121.52 123,681.63 46.3
44340 FINANCIAL MANAGEMENT SERVICES 49,195 49,195 49,195.00 0.00 100.0
44520 PROPERTY INSURANCE 73,164 73,164 38,509.34 32,377.87 2,276.79 96.9
44521 LIABILITY INSURANCE GENERAL 60,265 60,265 33,166.50 21,896.66 5,201.84 91.4
44522 LIABILITY INSURANCE TRANSPORTATION 1,208 1,208 545.50 545.50 117.00 90.3
44540 ADVERTISING 555 555 550.00 5.00 0.0
44550 PRINTING 17,535 17,535 1,458.73 86.45 15,989.82 8.8
44561 TUITION - VO-AG 156,929 156,929 61,407.00 61,407.00 34,115.00 78.3
44561 TUITION - PUBLIC 1,235,969 1,235,969 246,058.70 763,138.46 226,771.84 4 81.7
44562 TUITION - PRIVATE 898,116 898,116 259,012.98 636,629.30 2,473.72 4 99.7
44563 TUITION - SAP OTHER 103,000 103,000 30,418.00 125,682.00 (53,100.00) 4 151.6
44566 TUITION - MAGNET SCHOOLS 381,542 381,542 0.00 381,542.00 0.0
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED OCTOBER 31, 2017
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 38,985 38,985 34,853.48 4,131.52 89.4
44610 CURRICULUM IMPLEMENTATION 27,000 27,000 0.00 27,000.00 0.0
44815 SOFTWARE LICENSING & SUPPORT 189,762 4,700 194,462 99,804.88 1,839.95 92,817.17 52.3
45411 WATER/SEWER 51,600 51,600 8,329.75 43,270.25 16.1
45530 TELEPHONES 40,428 40,428 11,612.33 28,815.67 28.7
45620 HEAT ENERGY SUPPLIES 281,385 281,385 1,708.35 279,676.65 0.6
45622 ELECTRICITY 680,324 680,324 213,991.03 466,332.97 31.5
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 4,200 4,200 362.67 3,837.33 8.6
45627 TRANSPORTATION SUPPLIES 109,395 109,395 8,510.40 100,884.60 7.8
46410 RECYCLING 33,587 33,587 7,560.23 19,693.44 6,333.33 81.1
46420 CLEANING/REPAIRING MAINTENANCE 126,107 126,107 30,028.20 4,612.62 91,466.18 27.5
46430 EQUIPMENT CONTRACTS - OFFICE 118,707 118,707 31,866.15 53,200.05 33,640.80 71.7
46430 EQUIPMENT CONTRACTS - FACILITIES 117,221 117,221 12,902.00 20,782.00 83,537.00 28.7
46431 VEHICLE MAINTENANCE 1,500 1,500 96.52 1,403.48 6.4
48730 INSTRUCTIONAL EQUIPMENT 4,000 4,000 0.00 4,000.00 0.0
48731 NON-INSTRUCTIONAL EQUIPMENT 50,211 (4,700) 45,511 43,059.94 2,451.06 94.6
48733 FURNITURE & FIXTURES 7,000 7,000 0.00 7,000.00 0.0
48734 OTHER CAPITAL OUTLAY 215,735 215,735 32,657.43 183,077.57 15.1
50700 TRANSFER TO DEBT SERVICE FUND 212,336 212,336 212,336.00 0.00 100.0
TOTAL 40,636,405 0 40,636,405 10,044,676.20 24,628,828.86 5,962,899.94 85.3
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 10/31/17. Due to the reduction of State funding, vacant positions have been left unfilled at this time.
(2) Employee benefit amounts reflect only actual expended amounts to date.
(3) Pending budget transfer
(4) Special Education expenditures subject to reimbursement from Excess Cost grant.