COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED NOVEMBER 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 5,375,882.37 12,796,063.95 795,825.68 1 95.8
40111 CERTIFIED DAILY SUBSTITUTES 225,535 225,535 47,586.62 177,948.38 0.0
40111 STIPENDS 349,847 349,847 80,916.83 268,930.17 1 0.0
40112 CLASSIFIED PERSONNEL SALARIES 5,375,745 (28,466) 5,347,279 1,803,803.92 3,145,133.23 398,341.85 1 92.6
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 14,004.02 65,995.98 0.0
40113 ADDITIONAL STAFF HOURS 38,231 38,231 20,444.09 17,786.91 53.5
40130 CLASSIFIED OVERTIME 34,500 34,500 12,024.53 22,475.47 34.9
41210 EMPLOYEE RELATED INSURANCE 5,353,368 5,353,368 2,195,549.86 3,032,281.00 125,537.14 2 97.7
41220 SOCIAL SECURITY 385,768 385,768 124,140.66 261,627.34 2 32.2
41221 MEDICARE 362,060 362,060 101,156.17 260,903.83 2 27.9
41230 PENSION 225,463 225,463 74,360.58 151,102.42 2 33.0
41250 UNEMPLOYMENT 13,000 13,000 8,327.20 500.00 4,172.80 2 67.9
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 2,396.45 16,053.55 13.0
42611 INSTRUCTIONAL SUPPLIES 226,491 226,491 50,663.04 2,115.11 173,712.85 23.3
42613 MAINTENANCE SUPPLIES 65,250 65,250 10,646.82 8,792.81 45,810.37 29.8
42614 GROUNDS MAINTENANCE SUPPLIES 26,664 26,664 16,866.72 9,797.28 63.3
42641 TEXTBOOKS 105,096 105,096 51,018.24 54,077.76 48.5
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 28,193.10 17,316.53 236,326.37 16.1
43320 PROFESSIONAL DEVELOPMENT 43,545 (153) 43,392 7,469.66 1,876.37 34,045.97 21.5
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 30,400 30,400 5,912.98 7,172.90 17,314.12 43.0
43323 PUPIL SERVICES 125,427 125,427 20,256.76 47,211.00 57,959.24 53.8
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,160,440 1,160,440 475,455.41 692,664.34 (7,679.75) 3 100.7
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 901,531 901,531 308,696.61 589,704.47 3,129.92 4 99.7
43511 TECH TRANSPORTATION 199,174 199,174 65,469.70 101,341.24 32,363.06 83.8
43580 TRAVEL 43,777 43,777 3,427.75 40,349.25 7.8
43810 DUES AND FEES 51,072 51,072 30,490.50 20,581.50 59.7
44203 LEGAL 85,000 85,000 40,283.62 44,716.38 47.4
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 202,016 28,466 230,482 70,048.35 45,970.77 114,462.88 50.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,545.18 387.50 15,602.32 11.0
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 333,478.99 742,899.97 159,590.04 4 87.1
44562 TUITION - PRIVATE 898,116 898,116 331,622.06 591,799.64 (25,305.70) 4 102.8
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 298,085.00 83,457.00 78.1
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED NOVEMBER 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 35,059.29 3,925.71 89.9
44610 CURRICULUM IMPLEMENTATION 27,000 27,000 0.00 27,000.00 0.0
44815 SOFTWARE LICENSING & SUPPORT 189,762 4,700 194,462 111,916.12 8,399.95 74,145.93 61.9
45411 WATER/SEWER 51,600 51,600 8,329.75 43,270.25 16.1
45530 TELEPHONES 40,428 40,428 14,638.72 25,789.28 36.2
45620 HEAT ENERGY SUPPLIES 281,385 281,385 1,708.35 279,676.65 0.6
45622 ELECTRICITY 680,324 680,324 295,755.94 384,568.06 43.5
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 4,200 4,200 442.70 3,757.30 10.5
45627 TRANSPORTATION SUPPLIES 109,395 109,395 15,149.17 94,245.83 13.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 35,718.50 4,724.47 85,664.03 32.1
46430 EQUIPMENT CONTRACTS - OFFICE 118,707 118,707 38,999.91 47,700.62 32,006.47 73.0
46430 EQUIPMENT CONTRACTS - FACILITIES 117,221 117,221 14,276.00 28,331.19 74,613.81 36.3
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 35,676.86 180,058.14 16.5
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 13,314,351.11 22,296,427.86 5,025,626.03 87.6
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 11/30/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.
8.2.1b
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED DECEMBER 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 6,831,602.65 11,336,705.70 799,463.65 1 95.8
40111 CERTIFIED DAILY SUBSTITUTES 225,535 225,535 72,585.67 152,949.33 0.0
40111 STIPENDS 349,847 349,847 100,802.53 249,044.47 1 0.0
40112 CLASSIFIED PERSONNEL SALARIES 5,375,745 (28,466) 5,347,279 2,226,395.02 2,726,078.67 394,805.31 1 92.6
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 22,812.68 57,187.32 0.0
40113 ADDITIONAL STAFF HOURS 38,231 38,231 23,688.09 14,542.91 62.0
40130 CLASSIFIED OVERTIME 34,500 34,500 15,477.80 19,022.20 44.9
41210 EMPLOYEE RELATED INSURANCE 5,353,368 5,353,368 2,628,820.38 2,599,098.00 125,449.62 2 97.7
41220 SOCIAL SECURITY 385,768 385,768 154,204.02 231,563.98 2 40.0
41221 MEDICARE 362,060 362,060 127,741.81 234,318.19 2 35.3
41230 PENSION 225,463 225,463 92,231.17 133,231.83 2 40.9
41250 UNEMPLOYMENT 13,000 13,000 11,482.20 500.00 1,017.80 2 92.2
41260 WORKERS' COMPENSATION INSURANCE 273,473 273,473 209,656.34 61,219.66 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 3,110.31 15,339.69 16.9
42611 INSTRUCTIONAL SUPPLIES 226,491 226,491 52,545.40 17,684.39 156,261.21 31.0
42613 MAINTENANCE SUPPLIES 65,250 65,250 14,446.12 6,368.86 44,435.02 31.9
42614 GROUNDS MAINTENANCE SUPPLIES 26,664 26,664 16,986.45 9,677.55 63.7
42641 TEXTBOOKS 105,096 105,096 51,102.60 53,993.40 48.6
42642 LIBRARY BOOKS 29,955 29,955 0.00 29,955.00 0.0
42643 PERIODICALS 5,294 5,294 487.75 500.94 4,305.31 18.7
42690 OTHER SUPPLIES/MATERIALS 281,683 153 281,836 41,775.54 10,371.69 229,688.77 18.5
43320 PROFESSIONAL DEVELOPMENT 43,545 (153) 43,392 10,743.54 949.04 31,699.42 26.9
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 30,400 30,400 5,912.98 7,172.90 17,314.12 43.0
43323 PUPIL SERVICES 125,427 125,427 26,751.88 42,831.00 55,844.12 55.5
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,160,440 1,160,440 567,403.89 600,933.54 (7,897.43) 3 100.7
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 901,531 901,531 317,518.08 588,752.66 (4,739.74) 4 100.5
43511 TECH TRANSPORTATION 199,174 199,174 83,064.94 87,510.80 28,598.26 85.6
43580 TRAVEL 43,777 43,777 7,090.35 2,075.00 34,611.65 20.9
43810 DUES AND FEES 51,072 51,072 32,830.98 18,241.02 64.3
44203 LEGAL 85,000 85,000 49,621.12 35,378.88 58.4
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 202,016 28,466 230,482 89,549.66 36,786.77 104,145.57 54.8
44340 FINANCIAL MANAGEMENT SERVICES 49,195 49,195 49,195.00 0.00 100.0
44520 PROPERTY INSURANCE 73,164 73,164 60,296.42 16,189.29 (3,321.71) 3 104.5
44521 LIABILITY INSURANCE GENERAL 60,265 60,265 44,114.75 10,948.58 5,201.67 91.4
44522 LIABILITY INSURANCE TRANSPORTATION 1,208 1,208 575.25 272.76 359.99 70.2
44540 ADVERTISING 555 555 550.00 5.00 0.0
44550 PRINTING 17,535 17,535 1,936.50 15,598.50 11.0
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 485,328.39 637,277.69 113,362.92 4 90.8
44562 TUITION - PRIVATE 898,116 898,116 460,784.34 462,637.36 (25,305.70) 4 102.8
44563 TUITION - SAP OTHER 103,000 103,000 43,836.20 68,000.00 (8,836.20) 4 108.6
44566 TUITION - MAGNET SCHOOLS 381,542 381,542 311,385.00 70,157.00 81.6
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED DECEMBER 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 35,059.29 3,925.71 89.9
44610 CURRICULUM IMPLEMENTATION 27,000 27,000 0.00 27,000.00 0.0
44815 SOFTWARE LICENSING & SUPPORT 189,762 4,700 194,462 113,176.12 7,159.95 74,125.93 61.9
45411 WATER/SEWER 51,600 51,600 8,329.75 43,270.25 16.1
45530 TELEPHONES 40,428 40,428 16,045.64 24,382.36 39.7
45620 HEAT ENERGY SUPPLIES 281,385 281,385 1,708.35 279,676.65 0.6
45622 ELECTRICITY 680,324 680,324 357,029.81 323,294.19 52.5
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 4,200 4,200 442.70 3,757.30 10.5
45627 TRANSPORTATION SUPPLIES 109,395 109,395 25,279.59 84,115.41 23.1
46410 RECYCLING 33,587 33,587 11,758.79 15,494.88 6,333.33 81.1
46420 CLEANING/REPAIRING MAINTENANCE 126,107 126,107 42,018.73 3,659.40 80,428.87 36.2
46430 EQUIPMENT CONTRACTS - OFFICE 118,707 118,707 46,130.56 42,255.20 30,321.24 74.5
46430 EQUIPMENT CONTRACTS - FACILITIES 117,221 117,221 20,963.20 23,954.74 72,303.06 38.3
46431 VEHICLE MAINTENANCE 1,500 1,500 96.52 1,403.48 6.4
48730 INSTRUCTIONAL EQUIPMENT 4,000 4,000 0.00 2,400.00 1,600.00 60.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 35,676.86 180,058.14 16.5
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 16,447,649.21 19,477,196.47 4,711,559.32 88.4
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 12/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.