8.2.1
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED SEPTEMBER 30, 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 2,516,512.44 15,721,477.65 729,781.91 1 96.2
40111 CERTIFIED DAILY SUBSTITUTES 225,535 225,535 12,707.50 212,827.50 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 952,827.28 4,067,213.57 327,238.15 1 93.9
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 2,065.00 77,935.00 0.0
40113 ADDITIONAL STAFF HOURS 38,231 38,231 15,822.83 22,408.17 41.4
40130 CLASSIFIED OVERTIME 34,500 34,500 7,158.54 27,341.46 20.7
41210 EMPLOYEE RELATED INSURANCE 5,353,368 5,353,368 1,313,951.25 3,898,647.00 140,769.75 2 97.4
41220 SOCIAL SECURITY 385,768 385,768 62,948.58 322,819.42 2 16.3
41221 MEDICARE 362,060 362,060 48,733.86 313,326.14 2 13.5
41230 PENSION 225,463 225,463 38,434.88 187,028.12 2 17.0
41250 UNEMPLOYMENT 13,000 13,000 1,767.20 750.00 10,482.80 2 19.4
41260 WORKERS' COMPENSATION INSURANCE 273,473 273,473 122,437.67 122,438.33 28,597.00 89.5
41290 OTHER EMPLOYEE BENEFITS 62,917 62,917 72,571.91 (9,654.91) 3 115.3
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0.00 0.00 0.0
42535 POSTAGE 18,450 18,450 1,227.60 17,222.40 6.7
42611 INSTRUCTIONAL SUPPLIES 226,491 226,491 22,503.45 19,358.84 184,628.71 18.5
42613 MAINTENANCE SUPPLIES 65,250 65,250 7,873.67 8,255.72 49,120.61 24.7
42614 GROUNDS MAINTENANCE SUPPLIES 26,664 26,664 12,391.10 14,272.90 46.5
42641 TEXTBOOKS 105,096 105,096 17,809.51 33,433.31 53,853.18 48.8
42642 LIBRARY BOOKS 29,955 29,955 0.00 29,955.00 0.0
42643 PERIODICALS 5,294 5,294 0.00 514.60 4,779.40 9.7
42690 OTHER SUPPLIES/MATERIALS 281,683 281,683 15,325.02 7,340.02 259,017.96 8.0
43320 PROFESSIONAL DEVELOPMENT 43,545 43,545 6,537.99 425.57 36,581.44 16.0
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 9,907.50 28,747.50 86,772.00 30.8
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,160,440 1,160,440 284,105.53 816,840.94 59,493.53 94.9
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 901,531 901,531 118,596.21 757,543.03 25,391.76 4 97.2
43511 TECH TRANSPORTATION 199,174 199,174 18,834.94 87,362.60 92,976.46 53.3
43580 TRAVEL 43,777 43,777 672.08 43,104.92 1.5
43810 DUES AND FEES 51,072 51,072 17,079.50 33,992.50 33.4
44203 LEGAL 85,000 85,000 11,237.00 73,763.00 13.2
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 202,016 28,466 230,482 31,145.92 66,190.81 133,145.27 42.2
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 869.73 451.45 16,213.82 7.5
44561 TUITION - VO-AG 156,929 156,929 0.00 156,929.00 0.0
44561 TUITION - PUBLIC 1,235,969 1,235,969 113,267.20 705,132.46 417,569.34 4 66.2
44562 TUITION - PRIVATE 898,116 898,116 148,412.26 677,647.62 72,056.12 4 92.0
44563 TUITION - SAP OTHER 103,000 103,000 21,918.00 134,182.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 SEPTEMBER 30, 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 189,762 88,078.63 6,741.20 94,942.17 50.0
45411 WATER/SEWER 51,600 51,600 0.00 51,600.00 0.0
45530 TELEPHONES 40,428 40,428 8,635.69 31,792.31 21.4
45620 HEAT ENERGY SUPPLIES 281,385 281,385 0.00 281,385.00 0.0
45622 ELECTRICITY 680,324 680,324 168,003.90 512,320.10 24.7
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 4,200 4,200 55.44 4,144.56 1.3
45627 TRANSPORTATION SUPPLIES 109,395 109,395 3,218.40 106,176.60 2.9
46410 RECYCLING 33,587 33,587 4,851.00 19,693.44 9,042.56 73.1
46420 CLEANING/REPAIRING MAINTENANCE 126,107 126,107 20,330.15 2,849.08 102,927.77 18.4
46430 EQUIPMENT CONTRACTS - OFFICE 118,707 118,707 19,649.35 60,721.47 38,336.18 67.7
46430 EQUIPMENT CONTRACTS - FACILITIES 117,221 117,221 10,349.90 14,690.10 92,181.00 21.4
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 50,211 43,059.94 7,151.06 85.8
48733 FURNITURE & FIXTURES 7,000 7,000 0.00 7,000.00 0.0
48734 OTHER CAPITAL OUTLAY 215,735 215,735 13,580.74 16,067.61 186,086.65 13.7
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 6,778,297.51 27,340,785.95 6,517,321.54 84.0
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 9/30/17. Due to the uncertainty 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.