8.2.1
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED APRIL 30, 2018
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 (468,358) 18,499,414 13,273,149.54 5,021,972.25 204,292.21 1 98.9
40111 CERTIFIED DAILY SUBSTITUTES 225,535 225,535 169,212.56 56,322.44 0.0
40111 STIPENDS 349,847 (8,724) 341,123 190,228.07 150,894.93 1 0.0
40112 CLASSIFIED PERSONNEL SALARIES 5,375,745 (136,638) 5,239,107 4,116,181.85 903,521.73 219,403.42 1 95.8
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 57,255.95 22,744.05 0.0
40113 ADDITIONAL STAFF HOURS 38,231 17,407 55,638 32,680.97 22,957.03 58.7
40130 CLASSIFIED OVERTIME 34,500 34,500 36,290.15 (1,790.15) 3 105.2
41210 EMPLOYEE RELATED INSURANCE 5,353,368 5,353,368 4,381,073.96 866,366.00 105,928.04 2 98.0
41220 SOCIAL SECURITY 385,768 385,768 294,162.80 91,605.20 2 76.3
41221 MEDICARE 362,060 362,060 245,075.97 116,984.03 2 67.7
41230 PENSION 225,463 225,463 172,838.82 52,624.18 2 76.7
41250 UNEMPLOYMENT 13,000 13,000 20,054.20 (7,054.20) 3 154.3
41260 WORKERS' COMPENSATION INSURANCE 273,473 273,473 261,825.01 11,647.99 95.7
41290 OTHER EMPLOYEE BENEFITS 62,917 62,917 70,871.77 (7,954.77) 3 112.6
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0.00 0.00 0.0
42535 POSTAGE 18,450 18,450 6,980.99 11,469.01 37.8
42611 INSTRUCTIONAL SUPPLIES 226,491 (57,185) 169,306 114,777.55 15,356.28 39,172.17 76.9
42613 MAINTENANCE SUPPLIES 65,250 65,250 25,125.97 4,942.73 35,181.30 46.1
42614 GROUNDS MAINTENANCE SUPPLIES 26,664 26,664 21,986.74 4,677.26 82.5
42641 TEXTBOOKS 105,096 (10,725) 94,371 75,355.46 3,289.77 15,725.77 83.3
42642 LIBRARY BOOKS 29,955 (11,444) 18,511 9,432.81 4,607.61 4,470.58 75.8
42643 PERIODICALS 5,294 5,294 2,325.98 789.00 2,179.02 58.8
42690 OTHER SUPPLIES/MATERIALS 281,683 (44,894) 236,789 116,824.58 19,808.00 100,156.42 57.7
43320 PROFESSIONAL DEVELOPMENT 43,545 (5,681) 37,864 15,685.76 2,627.62 19,550.62 48.4
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 30,400 (8,371) 22,029 8,028.16 6,670.36 7,330.48 66.7
43323 PUPIL SERVICES 125,427 125,427 58,598.87 14,947.05 51,881.08 58.6
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,160,440 1,160,440 967,266.07 221,131.20 (27,957.27) 3 102.4
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 901,531 901,531 640,528.67 277,371.94 (16,369.61) 4 101.8
43511 TECH TRANSPORTATION 199,174 199,174 143,692.11 33,604.09 21,877.80 89.0
43580 TRAVEL 43,777 43,777 7,201.97 2,075.00 34,500.03 21.2
43810 DUES AND FEES 51,072 (1,904) 49,168 37,438.93 11,729.07 76.1
44203 LEGAL 85,000 85,000 76,389.12 8,610.88 89.9
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 202,016 14,716 216,732 149,326.64 7,350.97 60,054.39 72.3
44340 FINANCIAL MANAGEMENT SERVICES 49,195 49,195 49,195.00 0.00 100.0
44520 PROPERTY INSURANCE 73,164 73,164 82,083.66 (8,919.66) 3 112.2
44521 LIABILITY INSURANCE GENERAL 60,265 60,265 55,062.84 5,202.16 91.4
44522 LIABILITY INSURANCE TRANSPORTATION 1,208 1,208 848.00 360.00 70.2
44540 ADVERTISING 555 555 550.00 5.00 0.0
44550 PRINTING 17,535 (3,767) 13,768 3,369.23 7,820.56 2,578.21 81.3
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 966,705.30 244,483.05 24,780.65 4 98.0
44562 TUITION - PRIVATE 898,116 898,116 728,606.77 196,903.22 (27,393.99) 4 103.1
44563 TUITION - SAP OTHER 103,000 103,000 77,836.20 34,000.00 (8,836.20) 4 108.6
44566 TUITION - MAGNET SCHOOLS 381,542 381,542 326,565.00 54,977.00 85.6
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED APRIL 30, 2018
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 35,711.14 3,273.86 91.6
44610 CURRICULUM IMPLEMENTATION 27,000 (27,000) 0 0.00 0.00 0.0
44815 SOFTWARE LICENSING & SUPPORT 189,762 (47,961) 141,801 132,266.57 5,842.70 3,691.73 97.4
45411 WATER/SEWER 51,600 51,600 37,439.65 14,160.35 72.6
45530 TELEPHONES 40,428 (400) 40,028 27,308.62 12,719.38 68.2
45620 HEAT ENERGY SUPPLIES 281,385 281,385 175,938.41 105,446.59 62.5
45622 ELECTRICITY 680,324 680,324 564,524.22 115,799.78 83.0
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 4,200 4,200 1,105.55 3,094.45 26.3
45627 TRANSPORTATION SUPPLIES 109,395 109,395 63,659.71 45,735.29 58.2
46410 RECYCLING 33,587 33,587 20,729.39 6,564.48 6,293.13 81.3
46420 CLEANING/REPAIRING MAINTENANCE 126,107 (10,445) 115,662 68,339.55 8,198.20 39,124.25 66.2
46430 EQUIPMENT CONTRACTS - OFFICE 118,707 2,828 121,535 89,474.64 16,164.25 15,896.11 86.9
46430 EQUIPMENT CONTRACTS - FACILITIES 117,221 (3,500) 113,721 51,326.48 5,461.29 56,933.23 49.9
46431 VEHICLE MAINTENANCE 1,500 1,500 96.52 1,403.48 6.4
48730 INSTRUCTIONAL EQUIPMENT 4,000 (1,600) 2,400 2,400.00 0.00 100.0
48731 NON-INSTRUCTIONAL EQUIPMENT 50,211 (2,700) 47,511 38,690.94 6,369.00 2,451.06 94.8
48733 FURNITURE & FIXTURES 7,000 (6,000) 1,000 0.00 1,000.00 0.0
48734 OTHER CAPITAL OUTLAY 215,735 (37,654) 178,081 35,676.86 142,404.14 20.0
50260 TRANSFER TO EDUCATION GRANTS FUND 0 35,000 35,000 35,000.00 0.00 100.0
50700 TRANSFER TO DEBT SERVICE FUND 212,336 212,336 212,336.00 0.00 100.0
50900 CONTINGENCY 0 825,000 825,000 0.00 825,000.00 100.0
TOTAL 40,636,405 0 40,636,405 29,742,121.25 7,999,645.35 2,894,638.40 92.9
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 4/30/18. 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.