Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2014-03 Meeting - Expense Report
General Ledger Trial Balance by Full Acct Number User: spearre Printed: 03/07/14 08:46:04 Period 01 - 13 Fiscal Year 2014 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,640,000.00 1,530,886.91 0.00 8,109,113.09 84.12 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,640,000.00 1,530,886.91 0.00 8,109,113.09 84.12 10-100-401030 Motor Vehicle Sales Tax 430,000.00 75,601.90 0.00 354,398.10 82.42 R15 Motor Vehicle Sales Tax 430,000.00 75,601.90 0.00 354,398.10 82.42 10-100-403010 Gasoline Tax 1,100,000.00 178,775.59 0.00 921,224.41 83.75 10-100-403020 Cigarette Tax 120,000.00 29,802.96 0.00 90,197.04 75.16 R20 Other Taxes 1,220,000.00 208,578.55 0.00 1,011,421.45 82.90 10-100-410020 Electric Utility Lic Tax 3,220,000.00 779,341.73 0.00 2,440,658.27 75.80 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 925,000.00 396,811.94 0.00 528,188.06 57.10 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,450,000.00 585,785.28 0.00 1,864,214.72 76.09 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 -19,210.20 0.00 129,210.20 117.46 10-100-410060 Cable Franchise Fee 335,000.00 81,801.36 0.00 253,198.64 75.58 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,040,000.00 1,824,530.11 0.00 5,215,469.89 74.08 10-100-420010 Cur Property Tax 4,600,000.00 4,493,238.37 0.00 106,761.63 2.32 10-100-420020 Del Property Tax 40,000.00 22,908.19 0.00 17,091.81 42.73 10-100-420040 Fin Inst Tax 10,000.00 41,534.94 0.00 -31,534.94 -315.35 10-100-420050 Prop Tax Int & Penalties 20,000.00 7,929.94 0.00 12,070.06 60.35 10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74 10-100-420060 Surtax Receipts 470,000.00 460,951.85 0.00 9,048.15 1.93 10-100-420080 Special Tax Rev 15,000.00 15,964.66 0.00 -964.66 -6.43 R40 Property Taxes 5,209,000.00 5,096,927.23 0.00 112,072.77 2.15 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-100-430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 3,823.92 0.00 -3,823.92 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430080 Road & Bridge Tax 550,000.00 0.00 0.00 550,000.00 100.00 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 550,000.00 3,823.92 0.00 546,176.08 99.30 10-100-440010 Admin Charge Backs 1,225,559.00 306,389.76 0.00 919,169.24 75.00 10-100-440050 Emt Reimbursement 0.00 0.00 0.00 0.00 0.00 10-100-440210 Street Cuts 25,000.00 10,634.00 0.00 14,366.00 57.46 10-100-440910 Fuel Charge-backs 0.00 5,685.73 0.00 -5,685.73 0.00 10-100-440920 Parts Charge-back 91,600.00 34,701.68 0.00 56,898.32 62.12 10-100-440930 Labor Charge-backs 137,400.00 35,588.76 0.00 101,811.24 74.10 R60 Charges for Services 1,479,559.00 392,999.93 0.00 1,086,559.07 73.44 10-100-450010 Liquor Licenses 65,000.00 1,752.50 0.00 63,247.50 97.30 10-100-450020 Business Licenses 205,000.00 85,651.28 0.00 119,348.72 58.22 10-100-450021 Home Occupation Permit 1,500.00 468.00 0.00 1,032.00 68.80 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 0.00 0.00 0.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 3,352.17 0.00 -3,352.17 0.00 10-100-450045 Bldg Constr Fees 200,000.00 32,170.09 0.00 167,829.91 83.91 10-100-450050 Electrical Certificates 16,000.00 13,726.00 0.00 2,274.00 14.21 10-100-450060 Electrical Permits 2,500.00 1,110.48 0.00 1,389.52 55.58 10-100-450070 Plumbing Licenses 10,000.00 10,029.00 0.00 -29.00 -0.29 10-100-450080 Plumbing Permits 5,000.00 1,782.25 0.00 3,217.75 64.36 10-100-450090 Other Lic & Permits 1,500.00 1,573.78 0.00 -73.78 -4.92 10-100-450091 Day Care Inspection Fees 8,000.00 1,530.00 0.00 6,470.00 80.88 10-100-450092 Food Inspection Fees 88,000.00 4,670.83 0.00 83,329.17 94.69 10-100-450100 Curb Cut Permits 1,500.00 0.00 0.00 1,500.00 100.00 10-100-450110 Board Of Adj Fees 1,200.00 618.00 0.00 582.00 48.50 10-100-450120 Sign Permits 4,000.00 1,121.00 0.00 2,879.00 71.98 10-100-450130 Demolition Permits 500.00 208.00 0.00 292.00 58.40 10-100-450150 Acc Rep Fees-police 12,000.00 4,162.60 0.00 7,837.40 65.31 10-100-450160 Accrptblastg P-fire 500.00 156.00 0.00 344.00 68.80 10-100-450170 Animal Redemption Fees 53,000.00 15,830.00 0.00 37,170.00 70.13 10-100-450180 Animal Vaccinations Fees 4,500.00 1,525.00 0.00 2,975.00 66.11 10-100-450185 Animal Cremation Fees 20,000.00 6,400.00 0.00 13,600.00 68.00 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 500.00 0.00 0.00 500.00 100.00 10-100-450230 Vacating Right Of Way 400.00 390.00 0.00 10.00 2.50 10-100-450250 Rezoning Request 10,000.00 2,479.20 0.00 7,520.80 75.21 10-100-450260 Non-refundable Plansspec 3,000.00 375.00 0.00 2,625.00 87.50 R65 Fees Licenses & Permits 713,600.00 191,081.18 0.00 522,518.82 73.22 10-100-460010 Court Cost 80,000.00 24,364.26 0.00 55,635.74 69.54 10-100-460015 Court Restitutions 1,300.00 321.48 0.00 978.52 75.27 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-460018 Inmate Security Fund 12,080.00 3,850.22 0.00 8,229.78 68.13 10-100-460020 Jail Cost Recovery 10,000.00 3,203.72 0.00 6,796.28 67.96 10-100-460025 Alcohol Offense Cost Rec 10,000.00 3,203.00 0.00 6,797.00 67.97 10-100-460030 Pol Fines-traffic 850,000.00 269,896.74 0.00 580,103.26 68.25 10-100-460040 Pol Tickets-parking 1,000.00 0.00 0.00 1,000.00 100.00 10-100-460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00 10-100-460060 Dog Fines 0.00 0.00 0.00 0.00 0.00 10-100-460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00 10-100-460090 Parking Fines 58,600.00 36,757.59 0.00 21,842.41 37.27 10-100-460100 Bankcard Charges -13,000.00 -3,637.24 0.00 -9,362.76 72.02 R70 Fines & Forfeitures 1,009,980.00 337,959.77 0.00 672,020.23 66.54 10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0.00 475.00 0.00 -475.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 6,610.00 6,610.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 6,040.00 1,040.00 0.00 5,000.00 82.78 10-100-480055 JC Fire Museum 0.00 6,324.50 0.00 -6,324.50 0.00 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 700.00 700.00 0.00 0.00 0.00 10-100-480080 Dare Donations 500.00 500.00 0.00 0.00 0.00 10-100-480090 Police K-9 Donations 500.00 500.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 549.00 0.00 -549.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 25,000.00 0.00 75,000.00 75.00 10-100-481030 Rent City Hallannex 6,500.00 3,250.00 0.00 3,250.00 50.00 10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00 10-100-481045 Rent-tower Sites 80,000.00 9,004.30 0.00 70,995.70 88.74 10-100-481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair-Solid Waste Cntr 110,000.00 27,466.44 0.00 82,533.56 75.03 10-100-481070 Miscellaneous 24,000.00 11,857.29 0.00 12,142.71 50.59 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 358,228.63 119,300.74 0.00 238,927.89 66.70 10-100-481077 Insurance Claims 20,000.00 350.00 0.00 19,650.00 98.25 10-100-481078 Cafeteria Refunds 0.00 0.00 0.00 0.00 0.00 10-100-481080 Sale Of Mapsgis Data 0.00 105.00 0.00 -105.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 5,000.00 0.00 10,000.00 66.67 10-100-481090 Cole Cty Sheriff-New World 28,678.00 0.00 0.00 28,678.00 100.00 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,000.00 1,600.00 0.00 1,400.00 46.67 10-100-481110 Long & Short 0.00 41.00 0.00 -41.00 0.00 R75 Other Operating Revenues 771,756.63 219,673.27 0.00 552,083.36 71.54 10-100-470010 Interest 65,000.00 -11.80 0.00 65,011.80 100.02 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable R80 Interest Income 65,000.00 -11.80 0.00 65,011.80 100.02 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 20,000.00 0.00 0.00 20,000.00 100.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 162.80 0.00 -162.80 0.00 R85 Other Non-Operating Revenue 20,000.00 162.80 0.00 19,837.20 99.19 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 21,940.00 6,267.63 0.00 15,672.37 71.43 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 21,940.00 6,267.63 0.00 15,672.37 71.43 10-100-495995 Transfer From(to) Surplus 219,573.41 0.00 0.00 219,573.41 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 219,573.41 0.00 0.00 219,573.41 100.00 100 Revenue 28,390,409.04 9,888,481.40 0.00 18,501,927.64 65.17 149 Entitlement Grant 10-149-430010 Federal Grants 675,652.74 35,577.68 0.00 640,075.06 94.73 10-149-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-149-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 675,652.74 35,577.68 0.00 640,075.06 94.73 149 Entitlement Grant 675,652.74 35,577.68 0.00 640,075.06 94.73 185 Non-Departmental 10-185-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-185-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-185-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 0.00 0.00 0.00 0.00 0.00 300 Police Department 10-300-430010 Federal Grants 286,113.85 3,988.13 0.00 282,125.72 98.61 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 26,453.69 0.00 -26,453.69 0.00 10-300-430074 Overtime Reimb 57,755.60 5,097.36 0.00 52,658.24 91.17 R50 Intergovernmental 343,869.45 35,539.18 0.00 308,330.27 89.66 300 Police Department 343,869.45 35,539.18 0.00 308,330.27 89.66 310 School Resource Officer GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-310-430040 Local Grants 184,966.60 184,966.60 0.00 0.00 0.00 R50 Intergovernmental 184,966.60 184,966.60 0.00 0.00 0.00 310 School Resource Officer 184,966.60 184,966.60 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-320-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 148,200.00 25,955.38 0.00 122,244.62 82.49 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 9,262.50 3,173.47 0.00 6,089.03 65.74 R50 Intergovernmental 157,462.50 29,128.85 0.00 128,333.65 81.50 522 Plan & Protect Svcs-MPO 157,462.50 29,128.85 0.00 128,333.65 81.50 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 1,374,095.19 6,007.55 0.00 1,368,087.64 99.56 10-530-430020 State Grants 1,250.00 1,250.00 0.00 0.00 0.00 10-530-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,375,345.19 7,257.55 0.00 1,368,087.64 99.47 530 Plan & Protect Svc-RedevGrant 1,375,345.19 7,257.55 0.00 1,368,087.64 99.47 532 Plan & Protect Svcs-Env Health 10-532-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-532-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-532-430040 Local Grants 11,000.00 5,480.00 0.00 5,520.00 50.18 R50 Intergovernmental 11,000.00 5,480.00 0.00 5,520.00 50.18 532 Plan & Protect Svcs-Env Health 11,000.00 5,480.00 0.00 5,520.00 50.18 990 Capital Projects 10-990-430010 Federal Grants 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 990 Capital Projects 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Revenue 32,540,119.85 10,370,251.46 0.00 22,169,868.39 68.13 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 16,200.00 0.00 48,600.00 75.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 4,957.20 1,239.45 0.00 3,717.75 75.00 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 103.26 0.00 0.00 103.26 100.00 E05 Personnel Services 69,860.46 17,439.45 0.00 52,421.01 75.04 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 5.06 0.00 94.94 94.94 10-110-512010 Printing 750.00 0.00 0.00 750.00 100.00 10-110-512020 Copies 500.00 34.97 0.00 465.03 93.01 10-110-513010 Office Supplies 400.00 121.52 24.31 254.18 63.54 10-110-514040 Food 412.05 0.00 0.00 412.05 100.00 E10 Materials & Supplies 2,162.05 161.55 24.31 1,976.20 91.40 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 3,000.00 103.77 0.00 2,896.23 96.54 10-110-520030 Dues And Publications 4,582.90 4,582.90 0.00 0.00 0.00 10-110-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 417.10 107.47 0.00 309.63 74.23 10-110-522020 Professional Services 87.95 87.95 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,087.95 4,882.09 0.00 3,205.86 39.64 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 80,110.46 22,483.09 24.31 57,603.07 71.90 120 City Clerk 10-120-501020 Salaries 63,969.55 21,133.50 0.00 42,836.05 66.96 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,893.67 1,524.04 0.00 3,369.63 68.86 10-120-502020 Group Health Insurance 12,300.85 4,077.42 0.00 8,223.43 66.85 10-120-502030 Retirement 12,602.00 3,825.62 0.00 8,776.38 69.64 10-120-502040 Workers Compensation 103.26 0.00 0.00 103.26 100.00 10-120-502050 Life Insurance 108.44 34.24 0.00 74.20 68.42 10-120-502060 Long Term Disability 179.04 56.60 0.00 122.44 68.39 10-120-502070 Employee Assistance Prgm 29.53 7.41 0.00 22.12 74.91 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 94,186.34 30,658.83 0.00 63,527.51 67.45 10-120-511020 Postage 270.00 6.58 0.00 263.42 97.56 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 500.00 117.75 0.00 382.25 76.45 10-120-513010 Office Supplies 1,000.00 30.51 0.00 969.49 96.95 E10 Materials & Supplies 1,770.00 154.84 0.00 1,615.16 91.25 10-120-520030 Dues And Publications 250.00 0.00 0.00 250.00 100.00 10-120-520050 Meeting And Conferences 0.00 12.00 0.00 -12.00 0.00 10-120-520070 Training And Education 1,000.00 199.00 0.00 801.00 80.10 10-120-522020 Professional Services 750.00 0.00 0.00 750.00 100.00 10-120-529030 Election Expense 50,000.00 20.00 0.00 49,980.00 99.96 E15 Contractual Services 52,000.00 231.00 0.00 51,769.00 99.56 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 400.00 319.04 24.31 56.66 14.16 E25 Repairs & Maintenance 400.00 319.04 24.31 56.66 14.16 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 148,356.34 31,363.71 24.31 116,968.33 78.84 140 City Administrator 10-140-501020 Salaries 179,796.19 45,919.02 0.00 133,877.17 74.46 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 13,754.41 3,349.83 0.00 10,404.58 75.65 10-140-502020 Group Health Insurance 18,790.57 5,022.28 0.00 13,768.29 73.27 10-140-502030 Retirement 35,419.85 8,311.35 0.00 27,108.50 76.53 10-140-502040 Workers Compensation 542.12 0.00 0.00 542.12 100.00 10-140-502050 Life Insurance 287.28 72.73 0.00 214.55 74.68 10-140-502060 Long Term Disability 355.92 102.00 0.00 253.92 71.34 10-140-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 248,990.74 62,788.36 0.00 186,202.38 74.78 10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-140-511020 Postage 400.00 22.61 0.00 377.39 94.35 10-140-512010 Printing 300.00 45.00 0.00 255.00 85.00 10-140-512020 Copies 500.00 58.98 0.00 441.02 88.20 10-140-513010 Office Supplies 1,200.00 462.90 24.31 712.80 59.40 10-140-517010 Operational Supplies 1,750.00 0.00 0.00 1,750.00 100.00 E10 Materials & Supplies 5,150.00 589.49 24.31 4,536.21 88.08 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-520030 Dues And Publications 600.00 125.00 0.00 475.00 79.17 10-140-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 1,200.00 249.00 0.00 951.00 79.25 10-140-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-140-520090 Recruitment 0.00 6,956.94 0.00 -6,956.94 0.00 10-140-520095 Relocation Fees 0.00 2,003.47 9,771.47 -11,774.94 0.00 10-140-522020 Professional Services 2,000.00 150.22 0.00 1,849.78 92.49 E15 Contractual Services 5,800.00 9,484.63 9,771.47 -13,456.10 -232.00 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 250.00 115.44 0.00 134.56 53.82 E25 Repairs & Maintenance 250.00 115.44 0.00 134.56 53.82 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 260,190.74 72,977.92 9,795.78 177,417.05 68.19 149 Entitlement Grant 10-149-501020 Salaries 28,119.75 5,424.57 0.00 22,695.18 80.71 10-149-501050 Parttime(wo Benefits)42,730.00 4,436.25 0.00 38,293.75 89.62 10-149-502010 Social Security 1,921.66 757.74 0.00 1,163.92 60.57 10-149-502020 Group Health Insurance 0.00 801.70 0.00 -801.70 0.00 10-149-502030 Retirement 1,008.59 981.86 0.00 26.73 2.65 10-149-502050 Life Insurance 0.00 8.49 0.00 -8.49 0.00 10-149-502060 Long Term Disability 0.00 13.86 0.00 -13.86 0.00 E05 Personnel Services 73,780.00 12,424.47 0.00 61,355.53 83.16 10-149-511010 Advertising 3,500.00 229.25 0.00 3,270.75 93.45 10-149-511020 Postage 1,150.00 238.60 0.00 911.40 79.25 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 2,700.00 321.99 0.00 2,378.01 88.07 10-149-517010 Operational Supplies 700.00 31.00 0.00 669.00 95.57 E10 Materials & Supplies 8,050.00 820.84 0.00 7,229.16 89.80 10-149-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 4,750.00 1,159.34 0.00 3,590.66 75.59 10-149-522020 Professional Services 7,500.00 0.00 0.00 7,500.00 100.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 115,000.00 17,949.00 0.00 97,051.00 84.39 10-149-528012 Housing Rehab-Energy Efficienc 69,000.00 8,048.00 0.00 60,952.00 88.34 10-149-528020 Housing Assistance 40,348.00 10,089.00 0.00 30,259.00 75.00 10-149-528030 Public Improvement 171,534.74 25,707.86 649.00 145,177.88 84.63 10-149-528040 Neighborhood Redevelopmnt 162,500.00 34,587.19 27,978.00 99,934.81 61.50 10-149-528050 Neighborhood Facility 12,500.00 0.00 0.00 12,500.00 100.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-528070 Emergency Assistance 15,000.00 1,778.00 0.00 13,222.00 88.15 10-149-528080 Homeless Objectives 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 599,132.74 99,318.39 28,627.00 471,187.35 78.64 10-149-547020 Maintenance Agreements 1,300.00 155.28 465.84 678.88 52.22 E25 Repairs & Maintenance 1,300.00 155.28 465.84 678.88 52.22 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 682,262.74 112,718.98 29,092.84 540,450.92 79.21 150 City Counselor 10-150-501020 Salaries 217,116.79 44,859.38 0.00 172,257.41 79.34 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,609.43 3,182.54 0.00 13,426.89 80.84 10-150-502020 Group Health Insurance 33,916.35 6,849.97 0.00 27,066.38 79.80 10-150-502030 Retirement 42,772.01 8,119.27 0.00 34,652.74 81.02 10-150-502040 Workers Compensation 370.02 0.00 0.00 370.02 100.00 10-150-502050 Life Insurance 364.39 72.10 0.00 292.29 80.21 10-150-502060 Long Term Disability 555.12 115.86 0.00 439.26 79.13 10-150-502070 Employee Assistance Prgm 74.15 18.61 0.00 55.54 74.90 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 311,778.26 63,217.73 0.00 248,560.53 79.72 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 300.00 227.98 0.00 72.02 24.01 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 114.53 0.00 555.47 82.91 10-150-513010 Office Supplies 1,800.00 0.00 0.00 1,800.00 100.00 10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 3,070.00 342.51 0.00 2,727.49 88.84 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 12,400.00 1,379.41 0.00 11,020.59 88.88 10-150-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 1,374.90 0.00 3,625.10 72.50 10-150-520080 Tuition Reimbursement 2,880.00 855.00 0.00 2,025.00 70.31 10-150-521010 General Insurance 3,000.00 1,712.00 0.00 1,288.00 42.93 10-150-522020 Professional Services 11,100.00 9.26 0.00 11,090.74 99.92 10-150-525030 Court Cost & Witness Fees 40.00 57.00 0.00 -17.00 -42.50 E15 Contractual Services 34,420.00 5,387.57 0.00 29,032.43 84.35 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-547010 Equipment Maintenance 1,250.00 685.79 431.92 132.30 10.58 E25 Repairs & Maintenance 1,250.00 685.79 431.92 132.30 10.58 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Counselor 350,518.26 69,633.60 431.92 280,452.75 80.01 160 Municipal Court 10-160-501010 Salary-elected Officals 60,000.00 14,999.97 0.00 45,000.03 75.00 10-160-501020 Salaries 97,303.63 32,251.83 0.00 65,051.80 66.85 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)9,500.00 1,000.00 0.00 8,500.00 89.47 10-160-501090 Overtime 7,200.00 216.83 0.00 6,983.17 96.99 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,418.38 3,658.00 0.00 9,760.38 72.74 10-160-502020 Group Health Insurance 12,436.90 3,710.68 0.00 8,726.22 70.16 10-160-502030 Retirement 20,863.01 5,876.65 0.00 14,986.36 71.83 10-160-502040 Workers Compensation 154.89 0.00 0.00 154.89 100.00 10-160-502050 Life Insurance 163.88 51.87 0.00 112.01 68.35 10-160-502060 Long Term Disability 272.64 86.28 0.00 186.36 68.35 10-160-502070 Employee Assistance Prgm 51.73 12.99 0.00 38.74 74.89 E05 Personnel Services 221,365.06 61,865.10 0.00 159,499.96 72.05 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 716.17 0.00 3,283.83 82.10 10-160-512010 Printing 1,090.00 0.00 0.00 1,090.00 100.00 10-160-512020 Copies 1,000.00 35.77 0.00 964.23 96.42 10-160-513010 Office Supplies 1,600.00 0.00 0.00 1,600.00 100.00 E10 Materials & Supplies 7,690.00 751.94 0.00 6,938.06 90.22 10-160-520025 Security 10,000.00 0.00 0.00 10,000.00 100.00 10-160-520030 Dues And Publications 450.00 100.00 0.00 350.00 77.78 10-160-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,000.00 302.95 0.00 1,697.05 84.85 10-160-522020 Professional Services 3,000.00 2,560.99 0.00 439.01 14.63 10-160-525005 Appointed Counsel 7,000.00 1,720.00 0.00 5,280.00 75.43 10-160-525010 Care Of Prisoners 3,380.50 0.00 0.00 3,380.50 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 25,870.50 4,683.94 0.00 21,186.56 81.89 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 1,200.00 252.20 24.31 923.50 76.96 E25 Repairs & Maintenance 1,200.00 252.20 24.31 923.50 76.96 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-572020 Purchase Of Equipment 16,251.06 437.42 15,851.06 -37.42 -0.23 E70 Capital Purchases 16,251.06 437.42 15,851.06 -37.42 -0.23 160 Municipal Court 272,376.62 67,990.60 15,875.37 188,510.66 69.21 170 Human Resources 10-170-501020 Salaries 183,873.86 52,451.06 0.00 131,422.80 71.47 10-170-501050 Parttime(wo Benefits)9,600.00 3,823.62 0.00 5,776.38 60.17 10-170-501090 Overtime 300.00 308.74 0.00 -8.74 -2.91 10-170-502010 Social Security 14,823.70 4,490.53 0.00 10,333.17 69.71 10-170-502020 Group Health Insurance 27,431.91 4,418.73 0.00 23,013.18 83.89 10-170-502030 Retirement 36,282.25 9,549.50 0.00 26,732.75 73.68 10-170-502040 Workers Compensation 301.18 0.00 0.00 301.18 100.00 10-170-502050 Life Insurance 310.80 82.72 0.00 228.08 73.38 10-170-502060 Long Term Disability 467.04 122.14 0.00 344.90 73.85 10-170-502070 Employee Assistance Prgm 66.60 16.72 0.00 49.88 74.89 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 273,457.34 75,263.76 0.00 198,193.58 72.48 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 1,000.00 23.11 0.00 976.89 97.69 10-170-512010 Printing 2,500.00 391.71 0.00 2,108.29 84.33 10-170-512020 Copies 1,500.00 159.08 0.00 1,340.92 89.39 10-170-513010 Office Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-170-517010 Operational Supplies 1,350.00 19.76 0.00 1,330.24 98.54 E10 Materials & Supplies 8,000.00 593.66 0.00 7,406.34 92.58 10-170-520030 Dues And Publications 1,255.00 0.00 0.00 1,255.00 100.00 10-170-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 750.85 0.00 2,749.15 78.55 10-170-520070 Training And Education 4,000.00 240.00 0.00 3,760.00 94.00 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 6,000.00 2,017.25 0.00 3,982.75 66.38 10-170-522020 Professional Services 8,000.00 754.57 0.00 7,245.43 90.57 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,755.00 3,762.67 0.00 18,992.33 83.46 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 200.00 121.55 24.31 54.15 27.07 E25 Repairs & Maintenance 200.00 121.55 24.31 54.15 27.07 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 304,412.34 79,741.64 24.31 224,646.40 73.80 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 180 Finance Department 10-180-501020 Salaries 639,306.34 182,863.65 0.00 456,442.69 71.40 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)18,904.18 5,744.09 0.00 13,160.09 69.61 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 50,353.11 14,131.31 0.00 36,221.80 71.94 10-180-502020 Group Health Insurance 76,739.99 24,840.16 0.00 51,899.83 67.63 10-180-502030 Retirement 125,943.35 33,098.41 0.00 92,844.94 73.72 10-180-502040 Workers Compensation 1,634.95 0.00 0.00 1,634.95 100.00 10-180-502050 Life Insurance 1,095.73 297.72 0.00 798.01 72.83 10-180-502060 Long Term Disability 1,691.84 490.00 0.00 1,201.84 71.04 10-180-502070 Employee Assistance Prgm 285.94 71.76 0.00 214.18 74.90 E05 Personnel Services 915,955.43 261,537.10 0.00 654,418.33 71.45 10-180-511010 Advertising 2,000.00 26.25 0.00 1,973.75 98.69 10-180-511020 Postage 13,500.00 2,619.61 0.00 10,880.39 80.60 10-180-511021 Mail Machine Cost 2,000.00 1,250.51 0.00 749.49 37.47 10-180-512010 Printing 6,500.00 910.95 0.00 5,589.05 85.99 10-180-512020 Copies 5,000.00 1,525.58 0.00 3,474.42 69.49 10-180-512021 Copy Machine Cost 0.00 -153.70 145.83 7.87 0.00 10-180-513010 Office Supplies 6,000.00 1,228.19 0.00 4,771.81 79.53 10-180-517010 Operational Supplies 4,000.00 112.04 0.00 3,887.96 97.20 E10 Materials & Supplies 39,000.00 7,519.43 145.83 31,334.74 80.35 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,400.00 60.00 0.00 2,340.00 97.50 10-180-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 2,200.00 152.32 0.00 2,047.68 93.08 10-180-520080 Tuition Reimbursement 1,800.00 0.00 0.00 1,800.00 100.00 10-180-522010 Audit 27,700.00 13,500.00 25,455.00 -11,255.00 -40.63 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 34,100.00 13,712.32 25,455.00 -5,067.32 -14.86 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 991,055.43 283,659.01 25,600.83 681,795.59 68.79 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 71,947.37 0.00 0.00 71,947.37 100.00 10-185-501022 Separation Incentive Prog Svgs 22,325.24 0.00 0.00 22,325.24 100.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 56,030.00 0.00 0.00 56,030.00 100.00 10-185-502022 Wellness Assessment 25,000.00 0.00 0.00 25,000.00 100.00 10-185-503010 Awards Program 3,000.00 0.00 0.00 3,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 178,302.61 0.00 0.00 178,302.61 100.00 10-185-514010 Gas 19,000.00 6,289.85 0.00 12,710.15 66.90 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 19,000.00 6,289.85 0.00 12,710.15 66.90 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 287,100.00 233,293.02 0.00 53,806.98 18.74 10-185-521020 Insurance Deductible 30,000.00 -25,638.37 0.00 55,638.37 185.46 10-185-521030 Self Ins Prop & Casualty 70,000.00 48,710.19 11,200.00 10,089.81 14.41 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 -13,187.50 0.00 13,187.50 0.00 10-185-522020 Professional Services 125,000.00 8,333.32 69,583.31 47,083.37 37.67 10-185-522025 JCTV 55,000.00 0.00 0.00 55,000.00 100.00 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 45,500.00 11,363.69 0.00 34,136.31 75.02 10-185-527020 Economic Development 185,000.00 0.00 0.00 185,000.00 100.00 10-185-529010 Special Events 7,000.00 1,105.00 0.00 5,895.00 84.21 E15 Contractual Services 805,100.00 263,979.35 80,783.31 460,337.34 57.18 10-185-531010 Electricity 42,400.00 6,537.04 0.00 35,862.96 84.58 10-185-533010 Natural Gas 6,000.00 2,716.02 0.00 3,283.98 54.73 10-185-535010 Water 6,000.00 1,227.48 0.00 4,772.52 79.54 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 54,400.00 10,480.54 0.00 43,919.46 80.73 10-185-540010 Building & Grounds Maint.60,000.00 9,584.63 -1,574.29 51,989.66 86.65 10-185-540020 Tree & Landscape Maint 25,000.00 12,500.00 0.00 12,500.00 50.00 10-185-547020 Maintenance Agreements 2,000.00 468.00 0.00 1,532.00 76.60 E25 Repairs & Maintenance 87,000.00 22,552.63 -1,574.29 66,021.66 75.89 10-185-550010 Miscellaneous 10,000.00 1,133.00 0.00 8,867.00 88.67 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 5,500.00 0.00 0.00 5,500.00 100.00 10-185-550041 ALPLA Settlement 50,000.00 50,000.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 11,247.91 0.00 -11,247.91 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 75,500.00 72,380.91 0.00 3,119.09 4.13 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 1,219,302.61 375,683.28 79,209.02 764,410.31 62.69 190 I.T. Department 10-190-501020 Salaries 551,117.31 182,488.60 0.00 368,628.71 66.89 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 42,160.47 13,403.73 0.00 28,756.74 68.21 10-190-502020 Group Health Insurance 63,175.48 21,888.74 0.00 41,286.74 65.35 10-190-502030 Retirement 108,570.11 33,030.55 0.00 75,539.56 69.58 10-190-502040 Workers Compensation 783.06 0.00 0.00 783.06 100.00 10-190-502050 Life Insurance 908.88 291.65 0.00 617.23 67.91 10-190-502060 Long Term Disability 1,459.74 462.53 0.00 997.21 68.31 10-190-502070 Employee Assistance Prgm 205.35 51.55 0.00 153.80 74.90 E05 Personnel Services 768,380.40 251,617.35 0.00 516,763.05 67.25 10-190-511010 Advertising 500.00 50.75 0.00 449.25 89.85 10-190-511020 Postage 200.00 0.48 0.00 199.52 99.76 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 200.00 14.81 0.00 185.19 92.60 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 117.26 0.00 882.74 88.27 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 20.50 0.00 29.50 59.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,500.00 956.28 0.00 543.72 36.25 E10 Materials & Supplies 3,450.00 1,160.08 0.00 2,289.92 66.37 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-190-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,000.00 1,487.27 0.00 6,512.73 81.41 10-190-520080 Tuition Reimbursement 7,500.00 1,200.00 0.00 6,300.00 84.00 10-190-522020 Professional Services 2,000.00 0.00 0.00 2,000.00 100.00 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 19,800.00 4,855.41 0.00 14,944.59 75.48 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 2,000.00 69.99 0.00 1,930.01 96.50 E15 Contractual Services 39,800.00 7,612.67 0.00 32,187.33 80.87 10-190-534010 Telephone 60,000.00 12,121.39 0.00 47,878.61 79.80 E20 Utilities 60,000.00 12,121.39 0.00 47,878.61 79.80 10-190-545010 Software Licensemaint 229,500.00 166,092.43 11,160.67 52,246.90 22.77 10-190-545020 Citywide Wiringnetwork 3,000.00 270.61 0.00 2,729.39 90.98 10-190-547010 Equipment Maintenance 3,000.00 3,001.78 0.00 -1.78 -0.06 10-190-547020 Maintenance Agreements 34,000.00 135.87 407.61 33,456.52 98.40 E25 Repairs & Maintenance 269,500.00 169,500.69 11,568.28 88,431.03 32.81 10-190-572020 Purchase Of Equipment 25,000.00 24,390.30 0.00 609.70 2.44 E70 Capital Purchases 25,000.00 24,390.30 0.00 609.70 2.44 190 I.T. Department 1,166,130.40 466,402.48 11,568.28 688,159.64 59.01 300 Police Department 10-300-501020 Salaries 3,903,005.86 1,287,676.23 0.00 2,615,329.63 67.01 10-300-501030 Holiday Pay 119,000.00 59,314.59 0.00 59,685.41 50.16 10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits)30,400.00 8,233.00 0.00 22,167.00 72.92 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,800.00 2,804.00 0.00 3,996.00 58.76 10-300-501090 Overtime 228,158.10 46,559.00 0.00 181,599.10 79.59 10-300-501095 Overtime Straight Pay 6,000.00 1,119.30 0.00 4,880.70 81.35 10-300-502010 Social Security 324,024.04 101,889.64 0.00 222,134.40 68.55 10-300-502020 Group Health Insurance 689,481.39 212,740.35 0.00 476,741.04 69.14 10-300-502030 Retirement 912,804.08 267,811.84 0.00 644,992.24 70.66 10-300-502040 Workers Compensation 70,999.83 0.00 0.00 70,999.83 100.00 10-300-502050 Life Insurance 6,714.24 2,039.33 0.00 4,674.91 69.63 10-300-502060 Long Term Disability 10,997.52 3,338.81 0.00 7,658.71 69.64 10-300-502070 Employee Assistance Prgm 1,909.20 479.29 0.00 1,429.91 74.90 10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 10-300-503020 Unemployment Compensation 1,000.00 129.30 0.00 870.70 87.07 E05 Personnel Services 6,312,894.26 1,994,134.68 0.00 4,318,759.58 68.41 10-300-511010 Advertising 3,000.00 737.25 0.00 2,262.75 75.43 10-300-511020 Postage 2,500.00 365.91 0.00 2,134.09 85.36 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-512010 Printing 5,000.00 795.80 0.00 4,204.20 84.08 10-300-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-300-512030 Photographic Supplies 2,000.00 954.98 0.00 1,045.02 52.25 10-300-513010 Office Supplies 13,000.00 1,951.73 0.00 11,048.27 84.99 10-300-514010 Gas 282,000.00 48,858.42 0.00 233,141.58 82.67 10-300-514040 Food 700.00 41.82 0.00 658.18 94.03 10-300-515040 First Aid Supplies 1,000.00 238.57 0.00 761.43 76.14 10-300-516010 Ammunition & Firearms Supplies 23,000.00 8,453.20 14,412.50 134.30 0.58 10-300-516020 Dare Program 16,500.00 214.50 0.00 16,285.50 98.70 10-300-516030 Special Investigation 2,500.00 1,500.00 0.00 1,000.00 40.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 700.00 0.00 0.00 700.00 100.00 10-300-517010 Operational Supplies 30,000.00 6,927.11 0.00 23,072.89 76.91 E10 Materials & Supplies 382,100.00 71,039.29 14,412.50 296,648.21 77.64 10-300-520030 Dues And Publications 4,000.00 1,682.50 0.00 2,317.50 57.94 10-300-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-300-520080 Tuition Reimbursement 7,000.00 855.00 0.00 6,145.00 87.79 10-300-520090 Recruitment 2,500.00 1,134.60 0.00 1,365.40 54.62 10-300-521040 Medical Claimsservices 5,000.00 1,642.00 0.00 3,358.00 67.16 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 12,000.00 6,120.15 0.00 5,879.85 49.00 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 13,000.00 6,900.00 0.00 6,100.00 46.92 10-300-523030 Building Lease 1,200.00 400.00 800.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 11,040.00 638.57 0.00 10,401.43 94.22 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 418.86 0.00 1,781.14 80.96 E15 Contractual Services 57,940.00 19,791.68 800.00 37,348.32 64.46 10-300-531010 Electricity 60,000.00 13,053.51 0.00 46,946.49 78.24 10-300-533010 Natural Gas 14,800.00 6,377.01 0.00 8,422.99 56.91 10-300-534010 Telephone 12,100.00 817.25 0.00 11,282.75 93.25 10-300-535010 Water 3,000.00 1,288.45 0.00 1,711.55 57.05 E20 Utilities 89,900.00 21,536.22 0.00 68,363.78 76.04 10-300-540010 Building & Grounds Maint.51,000.00 10,409.80 -6,237.74 46,827.94 91.82 10-300-541030 Vehicle Wash 12,000.00 2,823.50 0.00 9,176.50 76.47 10-300-544010 K-9 Operations 10,500.00 2,307.85 0.00 8,192.15 78.02 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 17,500.00 0.00 0.00 17,500.00 100.00 10-300-546010 Clothing Expense 43,000.00 12,105.78 1,925.00 28,969.22 67.37 10-300-546020 Uniform Cleaning 26,000.00 7,509.90 0.00 18,490.10 71.12 10-300-547010 Equipment Maintenance 13,000.00 4,232.95 0.00 8,767.05 67.44 10-300-547020 Maintenance Agreements 20,000.00 14,211.79 3,094.42 2,693.79 13.47 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-547030 Radio Maintenance 10,000.00 2,214.48 0.00 7,785.52 77.86 E25 Repairs & Maintenance 203,000.00 55,816.05 -1,218.32 148,402.27 73.10 10-300-572010 Purchase Of Vehicles 250,000.00 0.00 243,414.00 6,586.00 2.63 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 11,086.20 0.00 0.00 11,086.20 100.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 10,133.00 5,485.55 0.00 4,647.45 45.86 10-300-572100 MDT Year 3 Equipment 264,894.65 72,813.74 154,718.76 37,362.15 14.10 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 536,113.85 78,299.29 398,132.76 59,681.80 11.13 300 Police Department 7,581,948.11 2,240,617.21 412,126.94 4,929,203.96 65.01 310 School Resource Officer 10-310-501020 Salaries 237,278.98 72,526.79 0.00 164,752.19 69.43 10-310-501030 Holiday Pay 6,000.00 2,287.60 0.00 3,712.40 61.87 10-310-501090 Overtime 7,126.00 7,467.92 0.00 -341.92 -4.80 10-310-501095 Overtime Straight Pay 0.00 147.64 0.00 -147.64 0.00 10-310-502010 Social Security 19,155.98 5,660.54 0.00 13,495.44 70.45 10-310-502020 Group Health Insurance 40,725.87 15,368.30 0.00 25,357.57 62.26 10-310-502030 Retirement 54,838.69 17,145.38 0.00 37,693.31 68.73 10-310-502040 Workers Compensation 3,631.31 0.00 0.00 3,631.31 100.00 10-310-502050 Life Insurance 401.52 118.20 0.00 283.32 70.56 10-310-502060 Long Term Disability 663.84 195.84 0.00 468.00 70.50 10-310-502070 Employee Assistance Prgm 111.00 27.87 0.00 83.13 74.89 E05 Personnel Services 369,933.19 120,946.08 0.00 248,987.11 67.31 10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 369,933.19 120,946.08 0.00 248,987.11 67.31 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 92,726.19 30,509.42 0.00 62,216.77 67.10 10-320-501030 Holiday Pay 2,500.00 1,595.17 0.00 904.83 36.19 10-320-501090 Overtime 6,897.00 2,750.24 0.00 4,146.76 60.12 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 7,812.42 2,492.27 0.00 5,320.15 68.10 10-320-502020 Group Health Insurance 17,953.72 5,380.11 0.00 12,573.61 70.03 10-320-502030 Retirement 22,364.98 7,249.80 0.00 15,115.18 67.58 10-320-502040 Workers Compensation 1,677.98 0.00 0.00 1,677.98 100.00 10-320-502050 Life Insurance 157.92 49.91 0.00 108.01 68.40 10-320-502060 Long Term Disability 259.68 81.73 0.00 177.95 68.53 10-320-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 152,394.29 50,119.80 0.00 102,274.49 67.11 10-320-514010 Gas 20,000.00 1,562.51 0.00 18,437.49 92.19 10-320-516040 Investigations (grant)16,900.00 1,264.87 0.00 15,635.13 92.52 10-320-517010 Operational Supplies 1,000.00 170.00 0.00 830.00 83.00 E10 Materials & Supplies 37,900.00 2,997.38 0.00 34,902.62 92.09 10-320-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 13,100.00 13,100.00 0.00 0.00 0.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 13,100.00 13,100.00 0.00 0.00 0.00 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.203,394.29 66,217.18 0.00 137,177.11 67.44 330 Animal Control 10-330-501020 Salaries 311,708.10 104,511.30 0.00 207,196.80 66.47 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 3,000.00 1,464.00 0.00 1,536.00 51.20 10-330-501090 Overtime 1,709.00 291.36 0.00 1,417.64 82.95 10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44 10-330-502010 Social Security 24,290.06 7,680.75 0.00 16,609.31 68.38 10-330-502020 Group Health Insurance 57,550.07 17,621.26 0.00 39,928.81 69.38 10-330-502030 Retirement 62,432.67 14,969.89 0.00 47,462.78 76.02 10-330-502040 Workers Compensation 5,137.19 0.00 0.00 5,137.19 100.00 10-330-502050 Life Insurance 527.52 169.12 0.00 358.40 67.94 10-330-502060 Long Term Disability 870.96 279.86 0.00 591.10 67.87 10-330-502070 Employee Assistance Prgm 177.60 44.59 0.00 133.01 74.89 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 468,503.17 147,059.95 0.00 321,443.22 68.61 10-330-511010 Advertising 1,500.00 0.00 0.00 1,500.00 100.00 10-330-511020 Postage 500.00 12.92 0.00 487.08 97.42 10-330-512010 Printing 1,700.00 667.75 0.00 1,032.25 60.72 10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-330-513010 Office Supplies 800.00 298.11 0.00 501.89 62.74 10-330-514030 Small Tools 250.00 0.00 0.00 250.00 100.00 10-330-515040 First Aid Supplies 150.00 261.06 0.00 -111.06 -74.04 10-330-517010 Operational Supplies 5,500.00 2,189.14 0.00 3,310.86 60.20 E10 Materials & Supplies 10,420.00 3,428.98 0.00 6,991.02 67.09 10-330-520030 Dues And Publications 900.00 802.75 0.00 97.25 10.81 10-330-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,650.00 1,510.80 0.00 139.20 8.44 10-330-521040 Medical Claimsservices 1,000.00 0.00 0.00 1,000.00 100.00 10-330-522020 Professional Services 9,600.00 1,117.46 0.00 8,482.54 88.36 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 10,000.00 518.17 0.00 9,481.83 94.82 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,150.00 3,949.18 0.00 19,200.82 82.94 10-330-531010 Electricity 24,000.00 7,053.77 0.00 16,946.23 70.61 10-330-533010 Natural Gas 13,200.00 3,865.60 0.00 9,334.40 70.72 10-330-534010 Telephone 572.00 72.09 0.00 499.91 87.40 10-330-535010 Water 2,500.00 1,053.97 0.00 1,446.03 57.84 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 40,272.00 12,045.43 0.00 28,226.57 70.09 10-330-540010 Building & Grounds Maint.10,000.00 2,351.73 -805.24 8,453.51 84.54 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 135.00 0.00 405.00 75.00 10-330-544040 Care Of Animals 42,000.00 10,422.15 0.00 31,577.85 75.19 10-330-546010 Clothing Expense 3,000.00 626.00 0.00 2,374.00 79.13 10-330-546020 Uniform Cleaning 100.00 0.00 0.00 100.00 100.00 10-330-547010 Equipment Maintenance 1,300.00 866.86 0.00 433.14 33.32 10-330-547020 Maintenance Agreements 800.00 1,656.00 0.00 -856.00 -107.00 10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00 E25 Repairs & Maintenance 58,440.00 16,057.74 -805.24 43,187.50 73.90 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 600,785.17 182,541.28 -805.24 419,049.13 69.75 390 9-1-1 Police 10-390-501020 Salaries 765,641.65 241,480.09 0.00 524,161.56 68.46 10-390-501030 Holiday Pay 29,000.00 14,748.64 0.00 14,251.36 49.14 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 5,076.07 0.00 10,737.93 67.90 10-390-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-390-502010 Social Security 62,038.10 18,958.04 0.00 43,080.06 69.44 10-390-502020 Group Health Insurance 157,153.93 43,585.65 0.00 113,568.28 72.27 10-390-502030 Retirement 159,758.26 46,202.01 0.00 113,556.25 71.08 10-390-502040 Workers Compensation 1,350.99 0.00 0.00 1,350.99 100.00 10-390-502050 Life Insurance 1,305.36 380.66 0.00 924.70 70.84 10-390-502060 Long Term Disability 2,142.66 624.76 0.00 1,517.90 70.84 10-390-502070 Employee Assistance Prgm 438.45 110.07 0.00 328.38 74.90 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,195,143.40 371,165.99 0.00 823,977.41 68.94 10-390-511010 Advertising 1,200.00 0.00 0.00 1,200.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 5,000.00 125.00 0.00 4,875.00 97.50 E10 Materials & Supplies 6,200.00 125.00 0.00 6,075.00 97.98 10-390-520030 Dues And Publications 900.00 40.00 0.00 860.00 95.56 10-390-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-390-522020 Professional Services 2,000.00 649.00 0.00 1,351.00 67.55 10-390-523010 Equipment Rentlease 100,000.00 30,570.15 4,860.00 64,569.85 64.57 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 102,900.00 31,259.15 4,860.00 66,780.85 64.90 10-390-534010 Telephone 150.00 0.00 0.00 150.00 100.00 E20 Utilities 150.00 0.00 0.00 150.00 100.00 10-390-546010 Clothing Expense 3,400.00 0.00 0.00 3,400.00 100.00 10-390-546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00 10-390-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-390-547020 Maintenance Agreements 25,000.00 7,170.00 13,219.50 4,610.50 18.44 10-390-547030 Radio Maintenance 4,000.00 0.00 0.00 4,000.00 100.00 E25 Repairs & Maintenance 37,400.00 7,170.00 13,219.50 17,010.50 45.48 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,341,793.40 409,720.14 18,079.50 913,993.76 68.12 400 Fire Department 10-400-501020 Salaries 3,413,576.57 1,131,576.33 0.00 2,282,000.24 66.85 10-400-501030 Holiday Pay 267,630.97 161,332.43 0.00 106,298.54 39.72 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,000.00 10,140.00 0.00 17,860.00 63.79 10-400-501090 Overtime 30,000.00 10,219.19 0.00 19,780.81 65.94 10-400-501095 Overtime Straight Pay 32,000.00 9,560.81 0.00 22,439.19 70.12 10-400-502010 Social Security 53,115.63 17,654.51 0.00 35,461.12 66.76 10-400-502020 Group Health Insurance 591,688.25 183,201.67 0.00 408,486.58 69.04 10-400-502030 Retirement 1,639,063.50 561,362.57 0.00 1,077,700.93 65.75 10-400-502040 Workers Compensation 108,750.00 0.00 0.00 108,750.00 100.00 10-400-502050 Life Insurance 5,774.79 1,829.04 0.00 3,945.75 68.33 10-400-502060 Long Term Disability 9,511.67 3,007.12 0.00 6,504.55 68.38 10-400-502070 Employee Assistance Prgm 1,608.36 403.77 0.00 1,204.59 74.90 10-400-503010 Awards Program 1,000.00 55.00 0.00 945.00 94.50 E05 Personnel Services 6,181,719.74 2,090,342.44 0.00 4,091,377.30 66.19 10-400-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-400-511020 Postage 300.00 50.16 0.00 249.84 83.28 10-400-512010 Printing 1,250.00 0.00 0.00 1,250.00 100.00 10-400-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 350.63 0.00 1,449.37 80.52 10-400-514010 Gas 77,000.00 15,125.94 0.00 61,874.06 80.36 10-400-514020 Chemicals 2,000.00 603.14 0.00 1,396.86 69.84 10-400-514030 Small Tools 2,500.00 1,166.00 0.00 1,334.00 53.36 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 400.00 0.00 0.00 400.00 100.00 10-400-517010 Operational Supplies 8,180.00 1,443.58 442.50 6,293.92 76.94 E10 Materials & Supplies 93,780.00 18,739.45 442.50 74,598.05 79.55 10-400-520030 Dues And Publications 1,240.00 334.00 0.00 906.00 73.06 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 10,000.00 1,515.00 0.00 8,485.00 84.85 10-400-520080 Tuition Reimbursement 5,000.00 0.00 0.00 5,000.00 100.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 2,700.00 0.00 0.00 2,700.00 100.00 10-400-522020 Professional Services 1,200.00 300.00 0.00 900.00 75.00 10-400-523010 Equipment Rentlease 2,000.00 0.00 0.00 2,000.00 100.00 10-400-524010 Trash Collections 250.00 0.00 0.00 250.00 100.00 10-400-529010 Special Events 6,000.00 2,340.22 0.00 3,659.78 61.00 10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 28,390.00 4,489.22 0.00 23,900.78 84.19 10-400-531010 Electricity 27,500.00 5,363.48 0.00 22,136.52 80.50 10-400-533010 Natural Gas 17,500.00 10,142.11 0.00 7,357.89 42.05 10-400-534010 Telephone 17,500.00 4,457.12 0.00 13,042.88 74.53 10-400-535010 Water 8,720.00 2,692.37 0.00 6,027.63 69.12 E20 Utilities 71,220.00 22,655.08 0.00 48,564.92 68.19 10-400-540010 Building & Grounds Maint.44,934.00 12,497.78 -1,246.36 33,682.58 74.96 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 35,000.00 5,109.17 -1,660.60 31,551.43 90.15 10-400-546020 Uniform Cleaning 1,066.00 0.00 0.00 1,066.00 100.00 10-400-547010 Equipment Maintenance 18,000.00 1,409.26 0.00 16,590.74 92.17 10-400-547020 Maintenance Agreements 13,900.00 1,664.40 576.00 11,659.60 83.88 10-400-547030 Radio Maintenance 7,000.00 372.50 0.00 6,627.50 94.68 E25 Repairs & Maintenance 119,900.00 21,053.11 -2,330.96 101,177.85 84.39 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 24,667.09 23,794.32 0.00 872.77 3.54 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 24,667.09 23,794.32 0.00 872.77 3.54 400 Fire Department 6,519,676.83 2,181,073.62 -1,888.46 4,340,491.67 66.58 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 205,628.16 68,018.07 0.00 137,610.09 66.92 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 15,730.55 4,977.73 0.00 10,752.82 68.36 10-520-502020 Group Health Insurance 31,736.64 10,270.74 0.00 21,465.90 67.64 10-520-502030 Retirement 40,508.75 12,311.29 0.00 28,197.46 69.61 10-520-502040 Workers Compensation 524.91 0.00 0.00 524.91 100.00 10-520-502050 Life Insurance 347.76 110.13 0.00 237.63 68.33 10-520-502060 Long Term Disability 531.84 168.41 0.00 363.43 68.33 10-520-502070 Employee Assistance Prgm 88.80 22.29 0.00 66.51 74.90 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 295,097.41 95,878.66 0.00 199,218.75 67.51 10-520-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-520-511020 Postage 200.00 18.16 0.00 181.84 90.92 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 800.00 145.46 0.00 654.54 81.82 10-520-514010 Gas 20,000.00 2,341.28 0.00 17,658.72 88.29 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 150.00 0.00 0.00 150.00 100.00 E10 Materials & Supplies 21,650.00 2,504.90 0.00 19,145.10 88.43 10-520-520030 Dues And Publications 500.00 145.10 0.00 354.90 70.98 10-520-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,500.00 199.00 0.00 1,301.00 86.73 10-520-522020 Professional Services 3,000.00 1,581.00 0.00 1,419.00 47.30 E15 Contractual Services 5,000.00 1,925.10 0.00 3,074.90 61.50 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,000.00 439.58 0.00 560.42 56.04 E25 Repairs & Maintenance 1,000.00 439.58 0.00 560.42 56.04 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 322,747.41 100,748.24 0.00 221,999.17 68.78 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,891.84 17,656.28 0.00 34,235.56 65.97 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)12,480.00 3,744.00 0.00 8,736.00 70.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 4,924.45 1,637.09 0.00 3,287.36 66.76 10-521-502020 Group Health Insurance 5,961.16 1,766.72 0.00 4,194.44 70.36 10-521-502030 Retirement 10,222.69 3,195.78 0.00 7,026.91 68.74 10-521-502040 Workers Compensation 86.05 0.00 0.00 86.05 100.00 10-521-502050 Life Insurance 87.36 27.66 0.00 59.70 68.34 10-521-502060 Long Term Disability 145.20 45.98 0.00 99.22 68.33 10-521-502070 Employee Assistance Prgm 22.20 5.57 0.00 16.63 74.91 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 85,820.95 28,079.08 0.00 57,741.87 67.28 10-521-511010 Advertising 6,500.00 854.00 0.00 5,646.00 86.86 10-521-511020 Postage 1,500.00 203.60 0.00 1,296.40 86.43 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 100.00 0.00 0.00 100.00 100.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 132.26 0.00 867.74 86.77 10-521-514040 Food 100.00 0.00 0.00 100.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 0.00 0.00 2,000.00 100.00 E10 Materials & Supplies 11,300.00 1,189.86 0.00 10,110.14 89.47 10-521-520030 Dues And Publications 15,500.00 2,025.00 0.00 13,475.00 86.94 10-521-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,700.00 249.00 0.00 1,451.00 85.35 10-521-520080 Tuition Reimbursement 1,600.00 0.00 0.00 1,600.00 100.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,800.00 2,274.00 0.00 16,526.00 87.90 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,400.00 713.43 465.84 220.73 15.77 E25 Repairs & Maintenance 1,400.00 713.43 465.84 220.73 15.77 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 117,320.95 32,256.37 465.84 84,598.74 72.11 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 106,803.34 34,783.56 0.00 72,019.78 67.43 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 8,170.45 2,589.84 0.00 5,580.61 68.30 10-522-502020 Group Health Insurance 18,528.02 3,816.98 0.00 14,711.04 79.40 10-522-502030 Retirement 21,230.20 3,891.50 0.00 17,338.70 81.67 10-522-502040 Workers Compensation 206.52 0.00 0.00 206.52 100.00 10-522-502050 Life Insurance 213.36 54.93 0.00 158.43 74.25 10-522-502060 Long Term Disability 352.32 90.47 0.00 261.85 74.32 10-522-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 155,548.61 45,238.43 0.00 110,310.18 70.92 10-522-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-522-511020 Postage 400.00 10.43 0.00 389.57 97.39 10-522-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-522-512020 Copies 50.00 0.18 0.00 49.82 99.64 10-522-513010 Office Supplies 1,000.00 46.45 0.00 953.55 95.36 10-522-514040 Food 200.00 0.00 0.00 200.00 100.00 10-522-517010 Operational Supplies 800.00 0.00 0.00 800.00 100.00 E10 Materials & Supplies 3,850.00 57.06 0.00 3,792.94 98.52 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-520030 Dues And Publications 1,000.00 574.65 0.00 425.35 42.54 10-522-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 2,500.00 0.00 0.00 2,500.00 100.00 10-522-522020 Professional Services 24,000.00 0.00 0.00 24,000.00 100.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,500.00 574.65 0.00 26,925.35 97.91 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,400.00 116.80 0.00 1,283.20 91.66 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,400.00 116.80 0.00 1,283.20 91.66 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 188,298.61 45,986.94 0.00 142,311.67 75.58 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,138.01 18,943.31 0.00 38,194.70 66.85 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,371.06 1,283.40 0.00 3,087.66 70.64 10-530-502020 Group Health Insurance 8,609.94 2,873.82 0.00 5,736.12 66.62 10-530-502030 Retirement 11,256.19 3,428.79 0.00 7,827.40 69.54 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 105.84 30.19 0.00 75.65 71.48 10-530-502060 Long Term Disability 176.64 49.96 0.00 126.68 71.72 10-530-502070 Employee Assistance Prgm 33.30 8.36 0.00 24.94 74.89 E05 Personnel Services 81,690.98 26,617.83 0.00 55,073.15 67.42 10-530-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-530-511020 Postage 100.00 14.38 0.00 85.62 85.62 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 300.00 96.00 0.00 204.00 68.00 10-530-517010 Operational Supplies 300.00 10.50 0.00 289.50 96.50 E10 Materials & Supplies 1,100.00 120.88 0.00 979.12 89.01 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 0.00 0.00 1,800.00 100.00 10-530-522020 Professional Services 2,500.00 0.00 0.00 2,500.00 100.00 10-530-528085 Fair Housing Assistance Prog 1,250.00 0.00 0.00 1,250.00 100.00 E15 Contractual Services 6,050.00 0.00 0.00 6,050.00 100.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 150.00 64.86 0.00 85.14 56.76 E25 Repairs & Maintenance 150.00 64.86 0.00 85.14 56.76 10-530-550020 Neighborhood Reinvestment 45,000.00 11,528.02 0.00 33,471.98 74.38 10-530-550030 Old Town Projects 45,500.00 26,317.77 0.00 19,182.23 42.16 10-530-550031 Historic Preservation Grant 1,734.00 0.00 0.00 1,734.00 100.00 10-530-550035 Old Town Redev Committee 0.00 -15.00 0.00 15.00 0.00 10-530-550037 Historic Preservation Comm 1,000.00 0.00 0.00 1,000.00 100.00 10-530-550050 Neighb Stablization Prog 105,516.24 0.00 0.00 105,516.24 100.00 10-530-550060 MSP 1,105,349.09 7,379.28 670,087.00 427,882.81 38.71 10-530-550090 Hazard Mitigation 217,664.81 217,664.81 0.00 0.00 0.00 E30 Other Operating Expenses 1,521,764.14 262,874.88 670,087.00 588,802.26 38.69 530 Plan & Protect Svc-RedevGrant 1,610,755.12 289,678.45 670,087.00 650,989.67 40.42 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 348,244.99 131,950.14 0.00 216,294.85 62.11 10-531-501060 Seasonal Salaries 21,320.00 0.00 0.00 21,320.00 100.00 10-531-501090 Overtime 740.00 0.00 0.00 740.00 100.00 10-531-501095 Overtime Straight Pay 130.00 0.00 0.00 130.00 100.00 10-531-502010 Social Security 28,338.28 9,617.13 0.00 18,721.15 66.06 10-531-502020 Group Health Insurance 55,844.61 16,719.12 0.00 39,125.49 70.06 10-531-502030 Retirement 68,775.65 19,251.20 0.00 49,524.45 72.01 10-531-502040 Workers Compensation 6,952.84 0.00 0.00 6,952.84 100.00 10-531-502050 Life Insurance 553.20 180.10 0.00 373.10 67.44 10-531-502060 Long Term Disability 968.64 308.08 0.00 660.56 68.19 10-531-502070 Employee Assistance Prgm 155.40 39.01 0.00 116.39 74.90 E05 Personnel Services 532,023.61 178,064.78 0.00 353,958.83 66.53 10-531-511010 Advertising 200.00 91.80 0.00 108.20 54.10 10-531-511020 Postage 2,000.00 871.46 0.00 1,128.54 56.43 10-531-512010 Printing 700.00 362.90 0.00 337.10 48.16 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 1,800.00 205.11 0.00 1,594.89 88.61 10-531-514030 Small Tools 300.00 0.00 0.00 300.00 100.00 10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-531-517010 Operational Supplies 2,700.00 22.23 0.00 2,677.77 99.18 E10 Materials & Supplies 7,740.00 1,553.50 0.00 6,186.50 79.93 10-531-520030 Dues And Publications 1,500.00 715.50 0.00 784.50 52.30 10-531-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 2,500.00 499.00 0.00 2,001.00 80.04 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-522021 Abatement 15,000.00 3,801.50 0.00 11,198.50 74.66 10-531-522022 Demo 20,000.00 0.00 0.00 20,000.00 100.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 39,000.00 5,016.00 0.00 33,984.00 87.14 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 540.00 135.00 0.00 405.00 75.00 10-531-546010 Clothing Expense 800.00 648.50 0.00 151.50 18.94 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,500.00 306.63 465.84 727.53 48.50 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,900.00 1,090.13 465.84 1,344.03 46.35 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 581,663.61 185,724.41 465.84 395,473.36 67.99 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 130,608.56 41,352.79 0.00 89,255.77 68.34 10-532-501060 Seasonal Salaries 3,957.00 174.00 0.00 3,783.00 95.60 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00 10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00 10-532-502010 Social Security 10,315.69 3,052.47 0.00 7,263.22 70.41 10-532-502020 Group Health Insurance 21,485.14 5,991.57 0.00 15,493.57 72.11 10-532-502030 Retirement 25,785.05 7,484.83 0.00 18,300.22 70.97 10-532-502040 Workers Compensation 1,884.50 0.00 0.00 1,884.50 100.00 10-532-502050 Life Insurance 220.08 66.36 0.00 153.72 69.85 10-532-502060 Long Term Disability 363.60 109.84 0.00 253.76 69.79 10-532-502070 Employee Assistance Prgm 55.50 13.93 0.00 41.57 74.90 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 194,955.12 58,245.79 0.00 136,709.33 70.12 10-532-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-532-511020 Postage 200.00 41.85 0.00 158.15 79.08 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,000.00 174.00 0.00 826.00 82.60 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-532-517010 Operational Supplies 1,200.00 22.31 0.00 1,177.69 98.14 E10 Materials & Supplies 2,850.00 238.16 0.00 2,611.84 91.64 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-520030 Dues And Publications 880.00 345.00 0.00 535.00 60.80 10-532-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 800.00 411.00 0.00 389.00 48.63 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 1,155.00 -1,155.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00 10-532-524025 Glass Recycling 10,000.00 1,760.00 3,850.00 4,390.00 43.90 10-532-524026 Household Hazardous Waste 20,000.00 0.00 0.00 20,000.00 100.00 10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 7,000.00 0.00 0.00 7,000.00 100.00 10-532-524030 Compost Services 212,000.00 70,666.68 141,333.36 -0.04 0.00 10-532-529010 Special Events 1,000.00 0.00 0.00 1,000.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 252,680.00 73,182.68 146,338.36 33,158.96 13.12 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 25,000.00 5,972.44 18,045.00 982.56 3.93 10-532-540065 Cemetery Restoration 5,000.00 0.00 0.00 5,000.00 100.00 10-532-541030 Vehicle Wash 1,290.00 321.00 0.00 969.00 75.12 10-532-546010 Clothing Expense 300.00 0.00 0.00 300.00 100.00 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,200.00 429.41 465.84 304.75 25.40 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 32,870.00 6,722.85 18,510.84 7,636.31 23.23 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 483,355.12 138,389.48 164,849.20 180,116.44 37.26 535 Public Works-Central Maintenan 10-535-501020 Salaries 331,324.54 107,919.28 0.00 223,405.26 67.43 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 0.00 0.00 7,400.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 7,805.21 0.00 -3,305.21 -73.45 10-535-501095 Overtime Straight Pay 500.00 259.78 0.00 240.22 48.04 10-535-502010 Social Security 26,294.93 8,245.72 0.00 18,049.21 68.64 10-535-502020 Group Health Insurance 83,283.30 24,809.61 0.00 58,473.69 70.21 10-535-502030 Retirement 66,255.94 20,993.14 0.00 45,262.80 68.32 10-535-502040 Workers Compensation 4,715.54 0.00 0.00 4,715.54 100.00 10-535-502050 Life Insurance 561.12 177.06 0.00 384.06 68.45 10-535-502060 Long Term Disability 926.64 292.35 0.00 634.29 68.45 10-535-502070 Employee Assistance Prgm 177.60 44.59 0.00 133.01 74.89 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 525,939.61 170,546.74 0.00 355,392.87 67.57 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.46 0.00 49.54 99.08 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 225.36 0.00 774.64 77.46 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 1,049.14 0.00 5,950.86 85.01 10-535-517010 Operational Supplies 8,000.00 2,152.58 0.00 5,847.42 73.09 E10 Materials & Supplies 16,140.00 3,427.54 0.00 12,712.46 78.76 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 199.00 0.00 1,801.00 90.05 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,000.00 199.00 0.00 1,801.00 90.05 10-535-531010 Electricity 6,550.00 1,775.35 0.00 4,774.65 72.90 10-535-533010 Natural Gas 6,000.00 4,522.68 0.00 1,477.32 24.62 10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-535-535010 Water 1,215.00 414.92 0.00 800.08 65.85 E20 Utilities 13,765.00 6,712.95 0.00 7,052.05 51.23 10-535-540010 Building & Grounds Maint.10,000.00 2,405.76 0.00 7,594.24 75.94 10-535-541010 Veh & Equip Parts Etc 419,500.00 129,215.55 0.00 290,284.45 69.20 10-535-546010 Clothing Expense 7,000.00 2,257.04 -1,053.79 5,796.75 82.81 10-535-547010 Equipment Maintenance 3,500.00 672.81 0.00 2,827.19 80.78 10-535-547020 Maintenance Agreements 4,000.00 1,143.01 141.60 2,715.39 67.88 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 444,500.00 135,694.17 -912.19 309,718.02 69.68 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 1,002,344.61 316,580.40 -912.19 686,676.40 68.51 540 Public Works-Admin 10-540-501020 Salaries 188,433.84 63,269.44 0.00 125,164.40 66.42 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 14,415.19 4,438.82 0.00 9,976.37 69.21 10-540-502020 Group Health Insurance 30,833.98 10,027.97 0.00 20,806.01 67.48 10-540-502030 Retirement 37,121.47 11,451.77 0.00 25,669.70 69.15 10-540-502040 Workers Compensation 567.94 0.00 0.00 567.94 100.00 10-540-502050 Life Insurance 309.12 99.64 0.00 209.48 67.77 10-540-502060 Long Term Disability 462.24 146.37 0.00 315.87 68.33 10-540-502070 Employee Assistance Prgm 66.60 16.72 0.00 49.88 74.89 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 272,210.38 89,450.73 0.00 182,759.65 67.14 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 20.15 0.00 179.85 89.93 10-540-512010 Printing 200.00 33.00 0.00 167.00 83.50 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 128,500.00 33,478.93 0.00 95,021.07 73.95 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 1,276.76 0.00 0.00 1,276.76 100.00 E10 Materials & Supplies 131,476.76 33,532.08 0.00 97,944.68 74.50 10-540-520030 Dues And Publications 1,000.00 465.20 0.00 534.80 53.48 10-540-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,000.00 696.52 0.00 1,303.48 65.17 10-540-522020 Professional Services 800.00 0.00 0.00 800.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,800.00 1,161.72 0.00 2,638.28 69.43 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 853.24 396.05 465.84 -8.65 -1.01 E25 Repairs & Maintenance 853.24 396.05 465.84 -8.65 -1.01 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works-Admin 408,340.38 124,540.58 465.84 283,333.96 69.39 541 Public Works-Engineering 10-541-501020 Salaries 662,630.75 218,888.91 0.00 443,741.84 66.97 10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 200.00 463.78 0.00 -263.78 -131.89 10-541-501095 Overtime Straight Pay 200.00 58.56 0.00 141.44 70.72 10-541-502010 Social Security 50,721.85 15,929.95 0.00 34,791.90 68.59 10-541-502020 Group Health Insurance 96,562.21 28,554.44 0.00 68,007.77 70.43 10-541-502030 Retirement 130,617.06 39,713.41 0.00 90,903.65 69.60 10-541-502040 Workers Compensation 1,204.70 0.00 0.00 1,204.70 100.00 10-541-502050 Life Insurance 1,100.40 349.78 0.00 750.62 68.21 10-541-502060 Long Term Disability 1,816.32 577.68 0.00 1,238.64 68.20 10-541-502070 Employee Assistance Prgm 244.20 61.30 0.00 182.90 74.90 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 945,297.49 304,597.81 0.00 640,699.68 67.78 10-541-511010 Advertising 600.00 127.75 0.00 472.25 78.71 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-511020 Postage 800.00 29.54 0.00 770.46 96.31 10-541-512010 Printing 100.00 66.00 0.00 34.00 34.00 10-541-512020 Copies 75.00 0.00 0.00 75.00 100.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 6,500.00 1,418.68 0.00 5,081.32 78.17 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 14.47 0.00 135.53 90.35 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-541-515080 Surveying Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-541-517010 Operational Supplies 1,150.00 414.91 0.00 735.09 63.92 E10 Materials & Supplies 13,625.00 2,071.35 0.00 11,553.65 84.80 10-541-520030 Dues And Publications 4,000.00 1,933.80 0.00 2,066.20 51.66 10-541-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 4,000.00 96.00 0.00 3,904.00 97.60 10-541-522055 Stormwater Compliance 1,500.00 0.00 551.03 948.97 63.26 E15 Contractual Services 14,000.00 2,029.80 551.03 11,419.17 81.57 10-541-534010 Telephone 1,000.00 112.47 0.00 887.53 88.75 E20 Utilities 1,000.00 112.47 0.00 887.53 88.75 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 240.00 0.00 760.00 76.00 10-541-546010 Clothing Expense 1,000.00 160.00 0.00 840.00 84.00 10-541-547010 Equipment Maintenance 1,500.00 593.12 0.00 906.88 60.46 10-541-547020 Maintenance Agreements 13,000.00 1,872.24 465.84 10,661.92 82.01 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 16,500.00 2,865.36 465.84 13,168.80 79.81 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 990,422.49 311,676.79 1,016.87 677,728.83 68.43 542 Public Works-Street 10-542-501020 Salaries 1,010,882.92 334,455.38 0.00 676,427.54 66.91 10-542-501060 Seasonal Salaries 20,543.42 0.00 0.00 20,543.42 100.00 10-542-501070 Stand-by Plan 4,081.31 1,440.00 0.00 2,641.31 64.72 10-542-501090 Overtime 20,000.00 26,864.23 0.00 -6,864.23 -34.32 10-542-501095 Overtime Straight Pay 2,000.00 183.18 0.00 1,816.82 90.84 10-542-502010 Social Security 80,893.69 27,131.17 0.00 53,762.52 66.46 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502020 Group Health Insurance 167,122.47 48,193.97 0.00 118,928.50 71.16 10-542-502030 Retirement 204,267.42 63,983.95 0.00 140,283.47 68.68 10-542-502040 Workers Compensation 26,942.26 0.00 0.00 26,942.26 100.00 10-542-502050 Life Insurance 1,700.04 540.39 0.00 1,159.65 68.21 10-542-502060 Long Term Disability 2,785.20 884.58 0.00 1,900.62 68.24 10-542-502070 Employee Assistance Prgm 521.70 130.97 0.00 390.73 74.90 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 250.00 0.00 0.00 250.00 100.00 E05 Personnel Services 1,542,190.43 503,807.82 0.00 1,038,382.61 67.33 10-542-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-542-511020 Postage 150.00 8.34 0.00 141.66 94.44 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.11 0.00 9.89 98.90 10-542-513010 Office Supplies 1,368.00 224.16 0.00 1,143.84 83.61 10-542-514020 Chemicals 300,000.00 275,269.42 -301,684.51 326,415.09 108.81 10-542-514030 Small Tools 9,000.00 955.49 0.00 8,044.51 89.38 10-542-514040 Food 700.00 413.53 0.00 286.47 40.92 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 274,750.00 28,030.50 2,830.61 243,888.89 88.77 10-542-515040 First Aid Supplies 500.00 315.50 0.00 184.50 36.90 10-542-515060 Weed Control 1,500.00 0.00 0.00 1,500.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 870.90 0.00 4,129.10 82.58 E10 Materials & Supplies 593,568.00 306,087.95 -298,853.90 586,333.95 98.78 10-542-520030 Dues And Publications 584.00 477.00 0.00 107.00 18.32 10-542-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 2,068.00 104.99 0.00 1,963.01 94.92 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,000.00 9,660.70 2,200.00 3,139.30 20.93 10-542-523010 Equipment Rentlease 200.00 60.00 0.00 140.00 70.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,852.00 10,302.69 2,200.00 5,349.31 29.96 10-542-531010 Electricity 25,000.00 8,321.76 0.00 16,678.24 66.71 10-542-531020 Street Lights 527,900.00 155,505.36 0.00 372,394.64 70.54 10-542-533010 Natural Gas 17,000.00 7,280.27 0.00 9,719.73 57.17 10-542-534010 Telephone 500.00 141.97 0.00 358.03 71.61 10-542-535010 Water 6,000.00 1,436.44 0.00 4,563.56 76.06 E20 Utilities 576,400.00 172,685.80 0.00 403,714.20 70.04 10-542-540010 Building & Grounds Maint.7,000.00 1,533.25 25.00 5,441.75 77.74 10-542-541030 Vehicle Wash 6,620.00 1,656.00 0.00 4,964.00 74.98 10-542-542010 Repairs - Stop Lights 10,000.00 2,686.44 0.00 7,313.56 73.14 10-542-542030 Signs & Marking Paint 35,000.00 3,818.67 0.00 31,181.33 89.09 10-542-546010 Clothing Expense 10,000.00 2,989.10 0.00 7,010.90 70.11 10-542-547010 Equipment Maintenance 3,200.00 1,547.17 0.00 1,652.83 51.65 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-547020 Maintenance Agreements 500.00 291.36 42.00 166.64 33.33 10-542-547030 Radio Maintenance 100.00 73.76 0.00 26.24 26.24 E25 Repairs & Maintenance 72,420.00 14,595.75 67.00 57,757.25 79.75 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 542 Public Works-Street 2,802,430.43 1,007,480.01 -296,586.90 2,091,537.32 74.63 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 1,515.57 0.00 2,484.43 62.11 10-700-590070 Airport Subsidy 170,789.16 42,697.29 0.00 128,091.87 75.00 10-700-590075 Transit Subsidy 363,990.70 90,997.68 0.00 272,993.02 75.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 538,779.86 135,210.54 0.00 403,569.32 74.90 700 Transfers & Subsidies 538,779.86 135,210.54 0.00 403,569.32 74.90 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-577042 Mo Blvd Sidewalks 75,447.33 81,464.83 -10,700.55 4,683.05 6.21 10-990-577044 Water Street @ Lohman Landing 465,460.00 0.00 2,790.68 462,669.32 99.40 10-990-577045 Clay Street Plaza 72,800.00 0.00 0.00 72,800.00 100.00 10-990-577046 Hwy 54 & Stadium Interchange 787,707.00 0.00 86,120.35 701,586.65 89.07 E75 Capital Projects 1,401,414.33 81,464.83 78,210.48 1,241,739.02 88.61 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 990 Capital Projects 1,401,414.33 81,464.83 78,210.48 1,241,739.02 88.61 Expense Expense 32,540,119.85 9,553,506.86 1,217,221.66 21,769,391.33 66.90 GL - Trial Balance by Full Acct Number (03/07/2014 - 8:46 AM)Page 35