COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED DECEMBER 31, 2012
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
40111 CERTIFIED PERSONNEL SALARIES 18,537,059 (8,110) 18,528,949 7,440,107.27 10,876,675.31 212,166.42 1 98.9
40111 CERTIFIED DAILY SUBSTITUTES 265,000 265,000 93,536.75 0.00 171,463.25 35.3
40111 STIPENDS 282,268 282,268 106,414.78 65,494.22 110,359.00 1 60.9
40112 CLASSIFIED PERSONNEL SALARIES 4,694,823 (3,693) 4,691,130 2,133,592.26 2,376,557.86 180,979.88 1 96.1
40112 CLASSIFIED DAILY SUBSTITUTES 70,000 70,000 29,176.90 0.00 40,823.10 41.7
40113 ADDITIONAL STAFF HOURS 28,689 28,689 21,295.04 0.00 7,393.96 74.2
40130 CLASSIFIED OVERTIME 31,500 31,500 11,308.47 0.00 20,191.53 35.9
41210 EMPLOYEE RELATED INSURANCE 4,777,005 4,777,005 2,807,317.12 1,953,052.76 16,635.12 2 99.7
41220 SOCIAL SECURITY 335,341 335,341 152,067.18 0.00 183,273.82 2 45.3
41221 MEDICARE 344,546 344,546 135,197.21 0.00 209,348.79 2 39.2
41230 PENSION 234,660 234,660 98,762.85 0.00 135,897.15 2 42.1
41250 UNEMPLOYMENT 62,596 62,596 27,211.60 440.00 34,944.40 2 44.2
41260 WORKERS' COMPENSATION INSURANCE 158,613 158,613 116,715.00 38,905.00 2,993.00 98.1
41290 OTHER EMPLOYEE BENEFITS 84,352 11,803 96,155 86,847.88 0.00 9,307.12 90.3
42535 POSTAGE 23,800 23,800 9,446.18 1,000.00 13,353.82 43.9
42611 INSTRUCTIONAL SUPPLIES 260,803 (1,871) 258,932 176,173.18 17,953.95 64,804.87 75.0
42613 MAINTENANCE SUPPLIES 71,275 71,275 43,458.94 0.00 27,816.06 61.0
42614 GROUNDS MAINTENANCE SUPPLIES 25,400 25,400 13,900.82 0.00 11,499.18 54.7
42641 TEXTBOOKS 143,271 181 143,452 101,457.18 1,943.68 40,051.14 72.1
42642 LIBRARY BOOKS 4,000 4,000 1,315.90 0.00 2,684.10 32.9
42643 PERIODICALS 3,139 3,139 1,636.08 198.69 1,304.23 58.5
42690 OTHER SUPPLIES/MATERIALS 233,815 233,815 84,104.64 3,033.53 146,676.83 37.3
43320 PROFESSIONAL DEVELOPMENT 31,610 31,610 14,311.03 128.73 17,170.24 45.7
43322 INSTRUCTIONAL PROGRAM IMPROVEMENTS 15,460 15,460 2,588.98 0.00 12,871.02 16.7
43323 PUPIL SERVICES 172,345 172,345 42,670.09 23,055.00 106,619.91 38.1
43510 PUPIL TRANSPORTATION - REGULAR EDUC 1,263,629 1,263,629 584,692.43 573,298.38 105,638.19 91.6
43510 PUPIL TRANSPORTATION - SPECIAL EDUC 812,263 812,263 332,820.93 479,493.39 (51.32) 4 100.0
43511 TECH TRANSPORTATION 136,180 136,180 67,233.85 68,089.68 856.47 99.4
43580 TRAVEL 36,114 36,114 6,172.03 1,500.00 28,441.97 21.2
43810 DUES AND FEES 70,582 70,582 45,351.75 363.00 24,867.25 64.8
44203 LEGAL 85,000 85,000 42,620.00 0.00 42,380.00 50.1
44330 OTHER PROFESSIONAL TECHNICAL SERVICES 162,219 (3,000) 159,219 74,428.29 28,206.14 56,584.57 64.5
44340 FINANCIAL MANAGEMENT SERVICES 46,340 46,340 35,089.47 11,250.50 0.03 100.0
44520 PROPERTY INSURANCE 64,327 (831) 63,496 47,592.00 15,516.00 388.00 99.4
44521 LIABILITY INSURANCE GENERAL 44,999 831 45,830 36,178.75 9,651.25 0.00 100.0
44522 LIABILITY INSURANCE TRANSPORTATION 1,240 1,240 920.25 306.75 13.00 99.0
44540 ADVERTISING 3,000 3,000 560.00 0.00 2,440.00 18.7
44550 PRINTING 21,500 21,500 7,148.03 8,141.00 6,210.97 71.1
44561 TUITION - VO-AG 87,912 87,912 51,948.00 51,948.00 (15,984.00) 3 118.2
44561 TUITION - PUBLIC 579,159 579,159 234,330.65 321,611.50 23,216.85 4 96.0
44562 TUITION - PRIVATE 686,642 686,642 238,214.30 360,578.32 87,849.38 4 87.2
44563 TUITION - SAP OTHER 240,340 240,340 124,280.92 191,155.44 (75,096.36) 4 131.2
44566 TUITION - MAGNET SCHOOLS 120,041 120,041 149,173.00 0.00 (29,132.00) 3 124.3
COLCHESTER PUBLIC SCHOOLS
YEAR TO DATE BUDGET REPORT
FOR THE PERIOD ENDED DECEMBER 31, 2012
UNEXPENDED/
TOTAL BUDGET REVISED YTD UNENCUMBERED PERCENT
OBJECT ACCOUNT DESCRIPTION BUDGET TRANSFERS BUDGET EXPENDED ENCUMBRANCES BALANCE NOTES USED
44590 OTHER PURCHASED SERVICES 39,048 39,048 37,451.97 0.00 1,596.03 95.9
44610 CURRICULUM IMPLEMENTATION 10,000 10,000 1,418.61 0.00 8,581.39 14.2
44815 SOFTWARE LICENSING & SUPPORT 132,159 570 132,729 83,374.52 17,928.63 31,425.85 76.3
45411 WATER/SEWER 60,250 60,250 8,271.98 0.00 51,978.02 13.7
45530 TELEPHONES 42,360 42,360 13,646.26 5,019.19 23,694.55 44.1
45620 HEAT ENERGY SUPPLIES 484,275 484,275 77,400.27 0.00 406,874.73 16.0
45622 ELECTRICITY 828,290 828,290 371,036.36 4,077.50 453,176.14 45.3
45623 PROPANE 800 800 0.00 0.00 800.00 0.0
45626 GASOLINE - MAINTENANCE VEHICLES 7,350 7,350 2,092.32 0.00 5,257.68 28.5
45627 TRANSPORTATION SUPPLIES 216,725 216,725 65,969.37 0.00 150,755.63 30.4
46410 RECYCLING 27,000 27,000 11,660.00 16,324.00 (984.00) 3 103.6
46420 CLEANING/REPAIRING MAINTENANCE 45,606 (2,390) 43,216 12,259.35 986.00 29,970.65 30.6
46430 EQUIPMENT CONTRACTS - OFFICE 153,714 (820) 152,894 67,336.46 85,373.22 184.32 99.9
46430 EQUIPMENT CONTRACTS - FACILITIES 103,726 103,726 64,340.02 13,859.05 25,526.93 75.4
46431 VEHICLE MAINTENANCE 1,500 1,500 1,899.89 0.00 (399.89) 3 126.7
48730 INSTRUCTIONAL EQUIPMENT 0 3,000 3,000 2,916.00 0.00 84.00 97.2
48731 NON-INSTRUCTIONAL EQUIPMENT 2,500 4,330 6,830 4,284.22 0.00 2,545.78 62.7
48733 FURNITURE & FIXTURES 1,000 1,000 0.00 0.00 1,000.00 0.0
48734 OTHER CAPITAL OUTLAY 15,000 15,000 4,492.39 0.00 10,507.61 29.9
TOTAL 37,524,160 0 37,524,160 16,659,217.97 17,623,115.67 3,241,826.36 91.4
Purchase orders for goods and services are issued throughout the school year.
(1) Vacant positions exist as of 12/31/12
(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