COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED MAY 31, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
40111 CERTIFIED PERSONNEL SALARIES 19,092,672 0 19,092,672 15,370,291.40 3,958,798.01 (236,417.41) 1, 3 101.2
40111 CERTIFIED DAILY SUBSTITUTES 215,000 0 215,000 110,187.29 0.00 104,812.71 51.2
40111 STIPENDS 410,346 0 410,346 336,438.74 0.00 73,907.26 1 82.0
40112 CLASSIFIED PERSONNEL SALARIES 5,717,069 (42,291) 5,674,778 4,958,049.86 513,660.48 203,067.66 1 96.4
40112 CLASSIFIED DAILY SUBSTITUTES 75,000 0 75,000 25,371.06 0.00 49,628.94 33.8
40113 ADDITIONAL STAFF HOURS 30,450 (2,696) 27,754 22,603.09 0.00 5,150.91 81.4
40130 CLASSIFIED OVERTIME 34,000 0 34,000 26,094.08 0.00 7,905.92 76.7
41210 EMPLOYEE RELATED INSURANCE 5,297,896 (47) 5,297,849 4,787,730.82 420,888.00 89,230.18 2 98.3
41220 SOCIAL SECURITY 408,457 (2,899) 405,558 327,985.29 0.00 77,572.71 2 80.9
41221 MEDICARE 376,886 (678) 376,208 287,866.36 0.00 88,341.64 2 76.5
41230 PENSION 242,272 (1,692) 240,580 194,967.22 0.00 45,612.78 2 81.0
41250 UNEMPLOYMENT 26,350 10,573 36,923 12,403.00 0.00 24,520.00 2 33.6
41260 WORKERS' COMPENSATION INSURANCE 303,718 (56,580) 247,138 248,319.61 0.00 (1,181.61) 3 100.5
41290 OTHER EMPLOYEE BENEFITS 287,428 (4,474) 282,954 282,276.44 0.00 677.56 99.8
42323 PROTECTIVE CLOTHING & SAFETY EQUIPMENT 0 0 0 0.00 0.00 0.00 0.0
42535 POSTAGE 17,700 (2,500) 15,200 12,140.40 0.00 3,059.60 79.9
42611 INSTRUCTIONAL SUPPLIES 236,209 (28,008) 208,201 185,069.83 3,670.34 19,460.83 90.7
42613 MAINTENANCE SUPPLIES 63,800 0 63,800 35,876.93 16,401.87 11,521.20 81.9
42614 GROUNDS MAINTENANCE SUPPLIES 24,000 0 24,000 28,384.31 0.00 (4,384.31) 3 118.3
42641 TEXTBOOKS 69,035 (3,352) 65,683 58,180.20 2,807.25 4,695.55 92.9
42642 LIBRARY BOOKS 14,627 0 14,627 10,282.54 4,314.46 30.00 99.8
42643 PERIODICALS 2,630 (73) 2,557 2,663.59 0.00 (106.59) 3 104.2
42690 OTHER SUPPLIES/MATERIALS 269,706 14,587 284,293 184,502.31 50,675.55 49,115.14 82.7
43320 PROFESSIONAL DEVELOPMENT 51,215 (4,300) 46,915 19,785.15 2,259.25 24,870.60 47.0
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 27,430 0 27,430 12,932.36 925.00 13,572.64 50.5
43323 PUPIL SERVICES 86,082 0 86,082 71,231.90 3,730.00 11,120.10 87.1
43326 PUPIL SERVICES PUBLIC ADD'L SERVICES 0 0 0 71,732.88 47,358.32 (119,091.20) 4,5 0.0
43327 PUPIL SERVICES PRIVATE ADD'L SERVICES 0 0 0 28,964.82 5,680.88 (34,645.70) 4,5 0.0
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,261,581 (6,710) 1,254,871 1,057,667.69 2,749.72 194,453.59 84.5
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 753,967 0 753,967 671,140.05 323,114.89 (240,287.94) 5 131.9
43511 TECH TRANSPORTATION 207,331 (720) 206,611 170,302.15 0.00 36,308.85 82.4
43580 TRAVEL 38,501 (2,000) 36,501 49,289.77 500.00 (13,288.77) 3 136.4
43810 DUES AND FEES 44,290 (816) 43,474 33,632.61 120.00 9,721.39 77.6
44203 LEGAL 100,000 0 100,000 126,583.50 0.00 (26,583.50) 3 126.6
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 172,399 (1,372) 171,027 147,928.37 12,120.49 10,978.14 93.6
44340 FINANCIAL MANAGEMENT SERVICES 51,657 0 51,657 51,657.00 0.00 0.00 100.0
44520 PROPERTY INSURANCE 77,710 28,909 106,619 105,573.08 0.00 1,045.92 99.0
44521 LIABILITY INSURANCE GENERAL 55,501 4,332 59,833 59,832.72 0.00 0.28 100.0
44522 LIABILITY INSURANCE TRANSPORTATION 1,058 (225) 833 843.62 0.00 (10.62) 3 101.3
44540 ADVERTISING 580 0 580 580.00 0.00 0.00 100.0
44550 PRINTING 16,185 (159) 16,026 8,625.58 5,717.32 1,683.10 89.5
44561 TUITION - VO-AG 95,522 0 95,522 44,349.50 44,349.50 6,823.00 92.9
44561 TUITION - PUBLIC 1,324,506 0 1,324,506 1,147,817.60 279,388.66 (102,700.26) 5 107.8
44562 TUITION - PRIVATE 817,287 0 817,287 563,633.18 137,182.20 116,471.62 5 85.7
44563 TUITION - SAP OTHER 0 0 0 0.00 0.00 0.00 5 0.0
44566 TUITION - MAGNET SCHOOLS 337,694 0 337,694 285,609.32 0.00 52,084.68 84.6
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED MAY 31, 2020
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 37,513 0 37,513 33,283.48 0.00 4,229.52 88.7
44610 CURRICULUM IMPLEMENTATION 130,000 0 130,000 111,579.66 5,180.95 13,239.39 89.8
44815 SOFTWARE LICENSING & SUPPORT 212,024 1,960 213,984 206,643.12 7,050.95 289.93 99.9
45411 WATER/SEWER 60,850 0 60,850 41,448.42 0.00 19,401.58 68.1
45530 TELEPHONES 40,770 0 40,770 38,124.52 0.00 2,645.48 93.5
45620 HEAT ENERGY SUPPLIES 342,225 0 342,225 254,643.26 0.00 87,581.74 74.4
45622 ELECTRICITY 857,115 0 857,115 712,072.83 0.00 145,042.17 83.1
45623 PROPANE 500 0 500 293.29 0.00 206.71 58.7
45626 GASOLINE - MAINTENANCE VEHICLES 750 0 750 526.01 0.00 223.99 70.1
45627 TRANSPORTATION SUPPLIES 117,000 0 117,000 82,007.64 0.00 34,992.36 70.1
46410 RECYCLING 30,621 0 30,621 23,224.83 5,687.56 1,708.61 94.4
46420 CLEANING/REPAIRING MAINTENANCE 105,523 (3,075) 102,448 79,488.25 13,838.84 9,120.91 91.1
46430 EQUIPMENT CONTRACTS - OFFICE 115,011 (7,235) 107,776 90,691.28 3,364.47 13,720.25 87.3
46430 EQUIPMENT CONTRACTS - FACILITIES 125,187 0 125,187 80,772.55 15,269.16 29,145.29 76.7
46431 VEHICLE MAINTENANCE 750 0 750 43.62 86.88 619.50 17.4
48730 INSTRUCTIONAL EQUIPMENT 0 0 0 0.00 0.00 0.00 0.0
48731 NON-INSTRUCTIONAL EQUIPMENT 14,700 0 14,700 14,752.16 0.00 (52.16) 3 100.4
48733 FURNITURE & FIXTURES 3,500 (1,000) 2,500 0.00 0.00 2,500.00 0.0
48734 OTHER CAPITAL OUTLAY 87,750 (20,263) 67,487 19,818.16 6,047.25 41,621.59 38.3
50205 TRANSFER TO BOE CAPITAL RESERVE 72,250 289,872 362,122 362,122.00 0.00 0.00 100.0
50260 TRANSFER TO EDUCATION GRANTS FUND 35,000 77,226 112,226 112,226.00 0.00 0.00 100.0
50700 TRANSFER TO DEBT SERVICE FUND 212,336 0 212,336 212,336.00 0.00 0.00 100.0
50900 CONTINGENCY (100,000) 132,804 32,804 0.00 0.00 32,804.00 0.0
TOTAL 41,237,122 367,098 41,604,220 34,713,494.30 5,892,938.25 997,787.45 97.6
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 5/31/20
(2) Employee benefit amounts reflect only actual expended amounts to date.
(3) Pending budget Transfer
(4) Reclassification of educational services associated with out of district special education placements - need to report separately from tuition costs to maximize
Medicaid reimbursements.
(5) Special Education expenditures subject to reimbursement form Excess Cost grant.