8.2.1
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED MAY 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,515,852 35,403 18,551,255 14,799,984.61 3,664,825.94 86,444.45 1 99.5
40111 CERTIFIED DAILY SUBSTITUTES 250,000 250,000 198,444.53 51,555.47 79.4
40111 STIPENDS 313,076 313,076 292,788.40 20,287.60 1 93.5
40112 CLASSIFIED PERSONNEL SALARIES 5,313,916 (10,000) 5,303,916 4,703,356.54 490,118.36 110,441.10 1 97.9
40112 CLASSIFIED DAILY SUBSTITUTES 80,000 80,000 54,496.61 25,503.39 68.1
40113 ADDITIONAL STAFF HOURS 40,748 40,748 33,759.74 6,988.26 82.9
40130 CLASSIFIED OVERTIME 34,500 34,500 39,973.78 (5,473.78) 3 115.9
41210 EMPLOYEE RELATED INSURANCE 4,562,868 4,562,868 4,200,039.25 366,885.00 (4,056.25) 2 100.1
41220 SOCIAL SECURITY 380,895 380,895 342,468.34 38,426.66 2 89.9
41221 MEDICARE 359,092 359,092 281,950.79 77,141.21 2 78.5
41230 PENSION 222,315 222,315 190,930.62 31,384.38 2 85.9
41250 UNEMPLOYMENT 59,629 59,629 24,177.00 35,452.00 2 40.5
41260 WORKERS' COMPENSATION INSURANCE 215,842 215,842 237,133.98 (21,291.98) 3 109.9
41290 OTHER EMPLOYEE BENEFITS 352,872 352,872 358,103.30 (5,231.30) 3 101.5
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 500 500 0.00 500.00 0.0
42535 POSTAGE 21,450 21,450 9,406.07 12,043.93 43.9
42611 INSTRUCTIONAL SUPPLIES 232,552 (3,473) 229,079 203,323.52 13,730.13 12,025.35 94.8
42613 MAINTENANCE SUPPLIES 66,726 66,726 55,114.94 3,368.63 8,242.43 87.6
42614 GROUNDS MAINTENANCE SUPPLIES 26,400 26,400 17,418.08 8,981.92 66.0
42641 TEXTBOOKS 99,531 33 99,564 96,695.37 411.69 2,456.94 97.5
42642 LIBRARY BOOKS 18,843 18,843 17,430.41 1,314.58 98.01 99.5
42643 PERIODICALS 5,394 38 5,432 5,127.48 34.95 269.57 95.0
42690 OTHER SUPPLIES/MATERIALS 318,118 24,281 342,399 255,168.31 27,426.33 59,804.36 82.5
43320 PROFESSIONAL DEVELOPMENT 48,565 9,888 58,453 35,317.84 1,291.66 21,843.50 62.6
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 33,150 33,150 11,212.94 11,290.95 10,646.11 67.9
43323 PUPIL SERVICES 163,987 (40,000) 123,987 84,884.46 12,480.60 26,621.94 78.5
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,182,223 1,182,223 1,164,159.33 0.00 18,063.67 98.5
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 904,597 904,597 816,958.47 108,704.91 (21,066.38) 4 102.3
43511 TECH TRANSPORTATION 190,587 190,587 164,618.62 20,200.00 5,768.38 97.0
43580 TRAVEL 39,561 750 40,311 28,501.98 1,847.45 9,961.57 75.3
43810 DUES AND FEES 53,279 (40) 53,239 49,711.00 495.68 3,032.32 94.3
44203 LEGAL 100,000 100,000 83,960.00 16,040.00 84.0
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 189,282 641 189,923 178,727.71 8,998.00 2,197.29 98.8
44340 FINANCIAL MANAGEMENT SERVICES 50,831 50,831 50,831.00 0.00 100.0
44520 PROPERTY INSURANCE 70,970 70,970 78,556.23 (7,586.23) 3 110.7
44521 LIABILITY INSURANCE GENERAL 58,524 58,524 57,780.00 744.00 98.7
44522 LIABILITY INSURANCE TRANSPORTATION 1,171 1,171 1,173.00 (2.00) 3 100.2
44540 ADVERTISING 0 0 835.00 (835.00) 3 0.0
44550 PRINTING 19,220 1,000 20,220 12,350.73 5,533.77 2,335.50 88.4
44561 TUITION - VO-AG 136,460 136,460 137,521.08 (1,061.08) 3 100.8
44561 TUITION - PUBLIC 1,117,701 1,117,701 1,119,907.34 84,937.60 (87,143.94) 4 107.8
44562 TUITION - PRIVATE 1,101,711 1,101,711 1,043,536.23 163,688.53 (105,513.76) 4 109.6
44563 TUITION - SAP OTHER 192,916 192,916 99,580.95 26,034.70 67,300.35 4 65.1
44566 TUITION - MAGNET SCHOOLS 322,297 322,297 346,646.86 (24,349.86) 3 107.6
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED MAY 31, 2017
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 42,877 3,129 46,006 46,821.57 (815.57) 3 101.8
44610 CURRICULUM IMPLEMENTATION 30,950 (9,500) 21,450 20,195.83 1,254.17 94.2
44815 SOFTWARE LICENSING & SUPPORT 143,921 (450) 143,471 133,321.58 13,158.96 (3,009.54) 3 102.1
45411 WATER/SEWER 53,550 53,550 39,030.26 14,519.74 72.9
45530 TELEPHONES 36,360 36,360 36,576.71 (216.71) 3 100.6
45620 HEAT ENERGY SUPPLIES 243,164 243,164 195,808.65 47,355.35 80.5
45622 ELECTRICITY 696,319 696,319 617,054.49 79,264.51 88.6
45623 PROPANE 500 500 0.00 500.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 3,160 3,160 2,459.07 700.93 77.8
45627 TRANSPORTATION SUPPLIES 71,780 71,780 61,039.82 10,740.18 85.0
46410 RECYCLING 32,905 32,905 34,079.31 4,438.36 (5,612.67) 3 117.1
46420 CLEANING/REPAIRING MAINTENANCE 143,025 (5,663) 137,362 79,043.59 2,659.64 55,658.77 59.5
46430 EQUIPMENT CONTRACTS - OFFICE 129,307 129,307 109,329.12 8,127.42 11,850.46 90.8
46430 EQUIPMENT CONTRACTS - FACILITIES 121,887 121,887 91,245.60 3,388.50 27,252.90 77.6
46431 VEHICLE MAINTENANCE 2,700 2,700 3,453.09 (753.09) 3 127.9
48730 INSTRUCTIONAL EQUIPMENT 12,598 2,204 14,802 13,735.00 1,067.00 92.8
48731 NON-INSTRUCTIONAL EQUIPMENT 47,500 (7,600) 39,900 32,679.36 326.24 6,894.40 82.7
48733 FURNITURE & FIXTURES 2,000 (641) 1,359 895.54 463.46 65.9
48734 OTHER CAPITAL OUTLAY 215,735 215,735 114,486.50 101,248.50 53.1
50700 TRANSFER TO DEBT SERVICE FUND 206,675 206,675 206,675.00 0.00 100.0
TOTAL 39,705,064 0 39,705,064 33,821,992.53 5,045,718.58 837,352.89 97.9
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 5/31/17
(2) Employee benefit amounts reflect only actual expended amounts to date.
(3) Pending budget transfer
(4) Special Education expenditures subject to reimbursement from Excess Costs grant