Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
20141212 finance packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Friday, December 12, 2014 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO Boone -Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the November 13, 2014 meeting. 4. Financial Reports a. Revenue Model Report b. Sales Tax Report c. Revenue Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. Street Light FY2014 Budget Amendment 7. Utility Audit 8. Transit FY2014 Revenue 9. New Business 10. Old Business 11. Adjournment NOTES Individuals should contact the ADA Coordinator at (5 73) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days toprocess the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, November 13, 2014 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Bray at 7:30 am. Roll call showed that Councilmen Bray, Scrivner, Mihalevich and Prather were in attendance. Councilman Graham was absent during roll call, but joined the meeting at 8:27 am. Next the minutes of the September 11, 2014 meeting were reviewed. A motion to approve was made by Councilman Mihalevich and seconded by Councilman Prather. The minutes were approved unanimously. The next item, which was taken out of order, was a review of the CVB Budget. Diane Gillespie, Executive Director, discussed the budget and answered questions posed by the members of the Finance Committee. Also in attendance were Kevin Zumwalt - Chairman of the Board, Andy Neidert — Vice Chairman, and Carol Burkhead — Accountant. The next item on the agenda was a report by Finance Director, Bill Betts, covering the Financial Reports. Mr. Betts reviewed the Revenue Model, the September sales tax figures, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by Mr. Betts covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the 4 Cent Lockbox Fund, is $2,081,296.73. The average monthly amount collected for the 4 Cent Lockbox Fund is $50,716. A report comparing occupancy rates for 2014, 2013 and 2012 was included along with a report listing occupancy rates from other cities. The next item on the agenda was new business. City Administrator, Steve Crowell, discussed the Police HVAC system. There was no old business to discuss. A motion to adjourn was made by Councilman Scrivner and seconded by Councilman Graham. The motion passed unanimously and the meeting adjourned at 8:40 am. As recorded by: Shiela Pearre, Chief Accountant Revenue Model Report For Period Ending November 30, 2014 Data as of 12-02-14 for period ending 11-30-14 Ott -14 CFY 2014 YTD Actual Projected Over/ Projected Over/ Description Budget As of 10-31-14 (Under)Budget (Under)Budget Diff Sales Tax and Use Tax $ 9,640,000.00 $ 10,102,174.46 `" $ 462,174.46 $ 363,325.74 $ 98,848.72 intergovernmental Taxes $ 2,080,000.00 $ 2,039,563.29 $ 67,814.04 $ 77,569.54 $ (9,755.50) Other Taxes $ 120,000.00 $ 121,781.74 $ 1,781.74 $ 1,549.58 $ 232.16 Franchise & Utility Tax $ 7,040,000.00 $ 7,652,068.29 $ 612,068.29 $ 591,009.43 $ 21,058.86 Property Taxes $ 5,209,000.00 $ 5,190,117.72 $ (16,621.60) $ (16,621.60) $ 0.00 Intergovernmental $ 6,610.00 $ 12,150.92 $ 5,540.92 $ 60,168.95 $ (54,628.03) Charges for Services $ 2,082,965.63 $ 2,188,672.07 $ 105,706.44 $ 94,245.69 $ 11,460.75 Fees, Licenses, & Permits $ 713,600.00 $ 832,546.96 $ 118,952.96 $ 118,952.96 $ - Fines & Forfeitures $ 1,009,980.00 $ 996,133.88 $ (13,215.93) $ (13,215.93) $ 0.00 Contributions/Donations $ 167,699.12 $ 205,228.98 $ 37,529.86 $ 37,529.86 $ - Other Operating Revenues $ 102,241.76 $ 206,902.95 $ 104,661.19 $ 103,094.01 $ 1,567.18 Interest Income $ 65,000.00 $ 109,019.76 $ 44,019.76 $ 37,686.15 $ 6,333.61 Other Non Operating Revenue $ 20,000.00 $ 27,384.16 $ 7,384.16 $ 7,384.16 $ - Operating Transfers ln $ 21,940.00 $ 23,121.88 $ 1,181.88 $ 1,181.88 $ (0.00) Totals $ 28,279,036.51 $ 29,706,867.06 $ 1,538,978.17 $ 1,463,860.42 75,117.75 Revenue Model Report (Detail) For Period Ending November 30, 2014 Initial Estimated De diplon Sales Tax and Use Tax 10-100.400010 Sales Tax (Inc. March Actual) 10-100400020 Sales Tax Interest Intergovernmental Taxes 10.100-401030 Motor Vehicle Sales Tax 10-100403010 Gasoline Tax 10-100-430080 Road & Bridge Tax Other Taxes 462,174.46 10-100-403020 Cig Tax Franchise & Utility Tax 10-100-410020 Electric Utility tic Tax 10-100-410030 Gas Utility License Tax 10-100-410052 Telephone Cell w/o audit money 10.100-410053 Telecom Audit 10-100-410060 Cable Franchise Fee 10-100-410061 Cable Utility Audit Property Taxes 2 10-100-420010 Current Property Tax 10-100-420020 Del Property Tax 10-100-420040 Fin Institution Tax 10-100-420050 Prop Tax Int & Penalties 10-100-420055 Surtax Receipts - County Reimb 30-100-420060 Surtax Receipts 10-100-420080 Special Tax Rev Intergovernmental 0 30-100-430010 Federal Grant 10-100-430100 State DNR Historic Pres 10-100480020 NSP Rehab Sales 30-100-480025 HUD Program Income Charges for Services 10-100-440010 Admin Charge Backs 10-100-440050 Emt Reimbursement 10-100-440210 Street Cuts 10-100-440910 Fuel Charge - backs 10-100-440920 Parts Charge backs 10-100-440930 tabor Charge backs 10-100-450189 Animal Shelter Bricks 10-100-481020 Cole Cry Animal Rescue 30-100-481030 Rent City Hall/annex 10-100-481040 Rent Other 10-100-481045 Rent4ower5ites Remaining Start Initial Estimated YTD Actual Estimated Revenues Actual &Estimated Projected Over/ Verification Month Budget Revenue Asof10-31-14 10/31/2014 TOTAL (Under)Budget of Formulas 2 9,640,000.00 9,640,000.00 10,102,174.46 0.00 10,102,174.46 462,174.46 462,174.46 000 0.00 0.00 0.00 0_00 ➢.9P 9,640,000.00 10,102,174.46 0.00 10,102,174.46 462,174.46 462.174.46 2 430,000.00 450,469.49 477,799.41 16,151.80 493,95L21 63,951.21 w,9s- 2 1,100,000.00 1,095,781.10 1,011,232.22 92,098.95 1,303,331.17 3,331.17 8,331.17 0 550.000.00 550,000.00 550.531.66 0.00 550.531.66 531.66 511.66 2,080,000.00 2,039,563.29 108,250.75 2,147,814.04 67,814.04 67,814.04 1 120,000.00 131,715.76 121.781.74 0.00 121.781.74 n�81.74 17, ei>n 120,000.00 121,781.74 0.00 121,781.74 1,781.74 1,761J4 1 3,220,000.00 3,422,802.04 3,662,305.46 0.00 3,662,305.46 442,305.46 442,1a5.46 1 925,000.00 908,060.23 1,087,592.66 0.00 1,087,592.66 162,592.66 162,s92.66 1 2,450,000.00 2,383,173.00 2,216,492.39 0.00 2,216,492.39 (233,507.61) 1213,507.611 110,000.00 281,121.98 0.00 281,121.98 171,121.98 171,121.98 9/1 335,000.00 337,942.30 400555.80 0.00 400,555.80 65,555.80 65,5sza4 $ $ 4,000.00 $ $ 4,000.00 $ 4,000.00 5 4,- 7,040,000.00 7,652,068.29 0.00 7,652,068.29 612,068.29 fiv,0se.z9 0 4,600,000.00 4,570,217.73 4514,123.36 0.00 4,514,123.36 (85,876.64) (85,876.64) 0 40,000.00 64,812.15 54,847.13 0.00 54,847.13 14,847.13 14,847.1a 0 10,000.00 16,519.75 41,534.94 0.00 41,534.94 31,534.94 31,536.90 0 20,000.00 29,246.15 28,731.44 0.00 28,731.44 8,73144 s7a144 0 54,000.00 54,399.28 54,399.28 0.00 54,399.28 399.28 399.28 0 470,000.00 471,744.89 472,315.78 0.00 472,315.78 2,315.78 2,815.78 2 15.000.00 27,359.89 241. 65.79 2.260.66 26.426.47 114, 26.47 lL426.47 5,209,000.00 5,190,117.72 2,260.68 5,192,378.40 (16,621.60) 116.671.60) 0 0.00 0.00 0.00 0.00 0.00 o.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 1,540.92 ODD 1,540.92 1,540.92 1,540.92 0 66 610.00 6,610.00 10,610.00 000 10.610.00 4.000.00 4 0� 00.00 6,610.00 12,150.92 0.00 12,150.92 5,540.92 5,540.92 0 1,225,559,00 1,225,559.00 1,225,559.00 0.00 1,225,559.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 o.o0 0 25,000.00 25,411.50 28,588.00 0.00 28,588.00 3,588.00 3,s8a. 0 0.00 16,334.18 0.00 16,334.18 16,334.18 16,114.18 0 91,60000 84,442.07 161,512.63 0.00 161,512.63 69,912.63 69,91x.61 0 137,400.00 124,065.41 150,003.29 0.00 150,003.29 12,603.29 12,603.29 0 OAO 900.00 0.00 900.00 900.00 'Moo 0 100,000.00 100,000.00 100,000.00 0.00 100,000.00 0.00 soo 0 6,500.00 6,500.00 6,500.00 0.00 6,500.00 0.00 coo 0 12,000.00 12,000.00 12,000.00 0.00 12,000.00 0.00 0.00 1 80,000AO 80,000.00 109,218.70 0.00 109,218.70 29,218.70 29,219.70 Revenue Model Report (Detail) Remaining For Period Ending November 30,2014 start Initial Estimated YTD Actual Estimated Revenues Actual&Estimated Projected Over/ Verification Description Month Budget Revenue Asot10-31-14 10/31/2014 TOTAL (Under)Budget of Formulas 10-100-481075 Cale Cry911Ralmb 0 358,228.63 358,228.63 358,739.86 0.00 358,739.86 'S1Lt3 -' Szzz3 10-100-481080 Sale Of Maps/gis Data 0 0.00 0.00 150.00 0.00 150.00 150.00 -.00 10-100-481085 Cale Cry Gis Joint Coop 0 15,000.00 15,000.00 15,000.00 0.00 15,000.00 0.00 0,00 10-100-481090 Cale Cry Sheriff -New World 0 28,678.00 0.00 0.00 0.00 0.00 (28,678.00) (za,a7e.001 10-100-481100 Sale Of Grave Sites 0 3,000.00 3,000.00 4,000.00 0.00 4,000A0 1,000.00 L-00 10.100-481110 Long & Short 0 0.00 0.00 166.41 000 166.41 166.41 166.61 2,082,965.63 2,188,672.07 0.00 2,188,672.07 105,706.44 205,708.44 Fees, Licenses, & Permits 10-100-450010 Uquor U-ses 0 65,000.00 64,405.00 66,296.00 0.00 66,296.00 1,296.00 z,z.. 10-100-450020 Business Licenses 0 205,000.00 216,000.00 215,754.21 0.00 215,754.21 10,754.21 10,754.21 10-100-450021 Home Occupation Permit 0 1,500.00 1,666.00 1,560.00 0.00 1,560.00 60.00 50.00 10-100-450030 Solicitors Lic 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg. Reg 0 0.00 220.00 0.00 220.00 220.00 2za. 10-100-450041 Abandoned Bldg. Admin Fee 0 0.00 7,864.17 0.00 7,864.17 7,864,17 7,ew.27 10-100-450045 Bldg. Constr Fees 0 200,000.00 129,807.55 279,972.77 0.00 279,972.77 79,972.77 79,972.n 10-100-450050 Elecuical Certificates 0 16,000.00 16,398.00 19,085.00 0.00 19,085.00 3,085.00 s. -.a0 10.100-450060 Electrical Permits 0 2,500.00 4,592.37 3,654.81 0.00 3,654.81 1,154.81 s,is4.e1 10.100-450070 Plumbing Licenses 0 10,000.00 10,384.00 11,434.00 0.00 11,434.00 1,434.00 v,434.a0 10-100-450080 Plumbing Permits 0 5,000.00 5,937.50 4,937.25 0.00 4,937.25 (62.75) Is2.7s) 10.100-450090 Other Lic&Permits 0 1,500.00 2,597.19 3,696.78 0.00 3,696.78 2,196.78 ;196.78 10-100-450091 Day Care Inspection Fees 0 8,000.00 8,515.00 7,890.00 0.00 7,890.00 (110.00) i110ao) 10-100-450092 Food Inspection Fees 0 88,000.00 86,739.25 88,125.07 0.00 88,125.07 125.07 125..7 10-100-450100 Curb Cut Permits 0 1,500.00 1,518.00 728.00 0.00 728.00 (772.00) (-00) 10-100-450110 Board Of Adj Fees 0 1,200.00 1,854.00 0.00 1,854.00 654.00 954.00 10-100-450120 Sign Permits 0 4,000.00 5,240.00 4,105.00 0.00 4,105.00 105.00 105.00 10-100-450130 Demolition Permits 0 500.00 916.00 988.00 0.00 988.00 488.00 05000 10-100-450150 Act, Rep Fees -police 0 12,000.00 12,387.67 11,286.90 0.00 11,286.90 (713.10) (713. 10) 30-100-450160 Accrpt/blastg P -fire 0 500.00 793.50 609.00 6.00 615.00 115.00 22s.00 10-100.450170 Animal Redemption Fees 0 53,000.00 52,360.00 56,465.00 0.00 56,465.00 3,465.00 a,-.. 10.100-450180 Animal Vaccinations Fees 0 4,500.00 5,140.00 5,030.00 0.00 5,030.00 530.00 s3a.00 10-100-450185 Animal Cremation Fees 0 20,000.00 23,665.00 25,540.00 0.00 25,540.00 5,540.00 s,s40.m 10-100.450186 Animal Boarding Fees 0 0.00 0.00 0.00 0.00 0.00 0.00 a.. 10-100-450190 Taxi Permits 0 500.00 500.00 575.00 0.00 575.00 75.00 75.00 10-100-450230 Vacating Right Of Way 0 400.00 315.00 780.00 0.00 780.00 380.00 380.00 10-100-450250 Rezoning Request 0 10,000.00 11,651.00 12,255.00 0.00 12,255.00 2,255.00 z,zss.00 30-300-450260 Non-refundable Plans/spec 0 33,000.00 2,727.25 1,841.00 0_00 18� 41.00 1 159.00 z zsv.ao 713,600.00 832,546.96 6.00 832,552.96 118,952.96 219,9sz9s Fines & Forfeitures 30-100-460010 Court Cost 0 80,000.00 82,550.20 75,542.66 0.00 75,542.66 (4,457.34) (4,457.34) 10-100-460015 Court Restitutions 0 1,300.00 1,986.90 1,863.30 630.19 2,493.49 1,193.49 L193.49 10.100.460018 Inmate Security Fund 0 12,080.00 13,155.29 12,469.04 0.00 12,469.04 389.04 389.04 10-100-460020 Jail Cost Recovery 0 10,000.00 11,661.07 8,196.05 0.00 8,196.05 (1,803.95) 11,805.951 10-100-460025 Alcohol Offense Cost Rec 0 10,000.00 91810.00 7,705.00 0.00 7,705.00 (2,295.00) (2,295.00) 10-100-460030 Pol Fines -traffic 0 850,000.00 836,162.54 844,869.08 0.00 844,869.08 (5,130.92) (5,2s0.9z) 10-100-460040 Pol Tickets -parking 0 11000.00 0.00 0.00 O.DO (1,000.00) 11,000.001 10-100-460050 Pol fines - Other 0 0.00 0.00 O.DO 0.00 0.00 o.ao 10-100-460060 Dog Fines 0 0.00 0.00 0.00 0.00 0.00 0.00 Revenue Model Report (Detail) 0 0.00 0.00 Remaining 0.00 0.00 0.o0 For Period Ending November 30, 2014 Start Initial Estimated YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification 10-100-480011 Police Evidence Funds Description Month Budget Revenue As of 10-31-14 10/31/2014 TOTAL (Under)Budget of Formulas 10.100-460070 P & Code Violations 0 0.00 52,637.49 0.00 0.00 0.00 0.00 0'. 10-100-460090 Parking Fines 0 58,600.00 41,650.35 62,668.59 0.00 62,668.59 4,068.59 4,068.59 10-100-460100 Bankcard Charges 0 13000.00 (13,843.12) 17179.84 0_00 17179.84 4179.84 n]j 7 -MI 18,449.70 0.00 1,009,980.00 18,449.70 996,133.88 630.19 996,764.07 (13,215.93) p3,ns �3l Contributions/Donations` 0.00 206,902.95 104,661.19 104,66119 Interest Income 10.100.430055 DARE Contd 0 0.00 0.00 0.00 0.00 0.00 aoo 10-100-480010 Citizen Participation 0 0100 10-100-470051 Unrealized Gains and Losses 711.93 0.00 711.93 711.93 m93 10-100-480015 Sidewalk Waiver Revenue 0 0.00 0.00 0.00 0.00 0.00 oao 10-100-480030 Donations -Recycling 0 0.00 0.00 0.00 0.00 0.00 o.ao 30-100-480050 Sober Driver Program 0 6,040.00 3,360.00 0.00 3,360.00 (2,680.00) (7.660.8..) 10-100-480055 JC Fire Museum 0 9,884.50 27,384.16 11,884.50 0.00 11,884.50 2,000.00 2,000.o0 10-100-480063 Private Donations -Cultural Art 0 DAO 0.00 0.00 0.00 0.00 OAO 0.00 10-100-480065 Cultural Arts 0 O.DO 1,280.00 0.00 1,280.00 1,280.00 1,z9o.00 30-100.480070 Community Projects Donations 0 750.00 0.00 750.00 0.00 750.00 0.00 0.00 10-100-480080 Dare Donations 0 500.00 111e1.88 500.00 0.00 500.00 O.DO 0.00 10-100-480090 Police K-9 Donations 0 500.00 10-100-490280 Trnffrom Stoneridge TDD 500,00 0.00 500.00 0.00 o.00 10-100-480165 Animal s Donations 0 40,024.62 0 52,850.92 0.00 52,850.92 12,826.30 1z,fiz6.30 10-100-481050 Transfer Stn/Ping-Sld Wst Cntr 0 0.00 0.00 0.00 0.00 0.00 0.00 a.o0 10-100-481055 Street Repair -Solid Waste Cntr 0 110,000.00 133,228.83 0.00 133,228.83 23,228.83 z3,nee3 10-100-481095 Cemetery Donations 0 0.00 0.00 0.00 0.00 0.00 a.a0 10-100-486070 Cap Contr-neighorhood Imp Pro 0 0_00 162.80 0_00 162.80 162,80 16180 167,699.12 205,228.98 0.00 205,228.98 37,529.86 37,529.86 Other Operating Revenues 10-100-450187 Special Sn Program 0 0.00 0.00 0.00 0.00 0.00 0.o0 10-100-450188 Adoption Voucher Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 75,069.65 0.00 75,069.65 75,069.65 7s,869.ss 10-100-481070 Miscellaneous 0 24,000.00 27,535.59 52,637.49 0.00 52,637.49 28,637.49 28,637.49 10-100-481072 TIF Prof Svcs Deposit 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481077 Insurance Claims 0 78,241.76 12,098.45 60,746.11 0.00 60,746.11 (17,495.65) u�a9s 651 10-100-481078 Cafeteria Refunds 0 0.00 18,449.70 0.00 18,449.70 18,449.70 [8_449.78 102,241.76 206,902.95 0.00 206,902.95 104,661.19 104,66119 Interest Income 10-100-470010 Interest 0 65,000.00 65,000.00 109,019.76 0.00 109,019.76 44,019.76 44,o18.7s 10-100-470051 Unrealized Gains and Losses 0 0.00 0.00 0.00 0.00 0.00 02. 65,000.00 109,019.76 0.00 109,019.76 44,019.76 44,019.76 Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets 0 0.DO 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 0 20,000.00 20,000.00 27,384.16 0_00 27,384.16 73y84.16 7384.16 20,000.00 27,384.16 0.00 27,384.16 7,384.16 7,384.16 Operating Transfers In 10-100-490193 inter From Grant Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 0 21,940.00 19,930.23 23,121.88 0.00 23,121.88 1,181.88 111e1.88 10-100-490260 Trsfr from Fireman's Spec Rev 0 0.00 0.00 0.00 0.00 0.00 0.90 10-100-490280 Trnffrom Stoneridge TDD 0 0.00 0.00 0.00 0.00 0.00 000 10-100-490353 Transfer From Cit"e" 0 0.00 0.00 0.00 0.00 0.00 0m 10-100-490600 Transfer from Water Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 Revenue Model Report (Detail) For Period Ending November 30, 2014 Description 10-100-490620 Transfer from Parking Fund Remaining Start Initial Estimated YTD Actual Estimated Revenues Actual&Estimated Prolerted Over/ Verification Month Budget Revenue Asof10-31-14 10/31/2014 TOTAL (Under)Budget of Formulas 0 0_00 0_00 0_00 0_00 0_00 om 21,940.00 23,121.88 0.00 23,121.88 11181.88 1'"." 28,279,036.51 29,706,867.06 111,147.62 29,818,014.68 1,538,978.17 1,538,978.17 Memo To: From: Date: Re: Steve Crowell Shiela Pearre December 8, 2014 Sales Tax Revenues The City received the December 1% Sales Tax in the amount of $1,015,322 which is $98,849 more than projected for December. January thru December overage is $462,174 (4.79%) in the General Fund. 1% General Sales Tax Receipt Budget Actual Reporting Receipt Budget Actual Variance Period Period Projection Receipts Variance Nov -13 Jan -14 $764,659 $741,056 ($23,603) Dec -13 Feb -14 $703,181 $789,830 $86,649 Jan -14 & Oct -Dec 13 Qtrly Mar -14 $1,008,111 $920,599 ($87,512) Feb -14 Apr -14 $777,424 $737,482 ($39,942) Mar -14 May -14 $537,141 $802,765 $265,624 Apr -14 & Jan -Mar 14 Qtrly Jun -14 $1,023,015 $865,930 ($157,085) May -14 Jul -14 $872,436 $1,048,754 $176,318 Jun -14 Aug -14 $546,351 $614,048 $67,697 Jul -14 & Apr -June 14 Qtrly Sep -14 $1,096,581 $996,272 ($100,309) Aug -14 Oct -14 $717,262 $919,035 $201,773 Sep -14 Nov -14 $677,366 $651,080 ($26,286) Oct -14 & Jul -Sept 14 Qtrly Dec -14 $916,473 $1,015,322 $98,849 Total Overage/Shortfall $462,174 1/2% Capital Improvement Tax Reporting Receipt Budget Actual Period Period Projection Receipts Variance Nov -13 Jan -14 $416,244 $359,800 ($56,444) Dec -13 Feb -14 $311,418 $394,475 $83,057 Jan -14 & Oct -Dec 13 Qtrly Mar -14 $471,169 $423,641 ($47,528) Feb -14 Apr -14 $413,147 $348,172 ($64,975) Mar -14 May -14 $266,340 $399,863 $133,523 Apr -14 & Jan -Mar 14 Qtrly Jun -14 $499,328 $416,943 ($82,385) May -14 Jul -14 $393,021 $503,869 $110,848 Jun -14 Aug -14 $280,801 $306,157 $25,356 Jul -14 & Apr -June 14 Qtrly Sep -14 $508,966 $484,992 ($23,974) Aug -14 Oct -14 $370,760 $430,185 $59,425 Sep -14 Nov -14 $268,825 $324,697 $55,872 Oct -14 & Jul -Sept 14 Qtrly Dec -14 $499,981 $485,136 ($14,845) Total Overage/Shortfall $177,931 1/2% Parks Sales Tax Reporting Receipt Budget Actual Period Period Projection Receipts Variance Nov -13 Jan -14 $372,447 $359,708 ($12,739) Dec -13 Feb -14 $350,714 $393,562 $42,848 Jan -14 & Oct -Dec 13 Qtrly Mar -14 $475,026 $423,546 ($51,480) Feb -14 Apr -14 $372,242 $348,076 ($24,166) Mar -14 May -14 $266,456 $398,085 $131,629 Apr -14 & Jan -Mar 14 Qtrly Jun -14 $482,382 $416,845 ($65,537) May -14 Jul -14 $425,194 $503,790 $78,596 Jun -14 Aug -14 $272,321 $305,930 $33,609 Jul -14 & Apr -June 14 Qtrly Sep -14 $521,155 $484,904 ($36,251) Aug -14 Oct -14 $357,482 $430,093 $72,611 Sep -14 Nov -14 $323,768 $324,481 $713 Oct -14 & Jul -Sept 14 Qtrly Dec -14 $419,277 $484,999 $65,722 Total Overage/Shortfall $235,554 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 12/08/14 13:11:15 Period 01 - 13 Fiscal Year 2015 CITY OF JEFFERSON JOHN G. CHRISTY MUNICIPAL BUILDING 320 E McCarty St Jefferson City, MO 65101-3193 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,772,509.00 -1,015,321.86 0.00 10,787,830.86 110.39 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,772,509.00 -1,015,321.86 0.00 10,787,830.86 110.39 10-100-401030 Motor Vehicle Tax 480,000.00 50,537.62 0.00 429,462.38 89.47 10-100-403010 Gasoline Tax 1,100,000.00 93,484.94 0.00 1,006,515.06 91.50 10-100-430080 Road & Bridge Tax 550,000.00 0.00 0.00 550,000.00 100.00 R16 Intergovernmental Taxes 2,130,000.00 144,022.56 0.00 1,985,977.44 93.24 10-100-403020 Cigarette Tax 120,000.00 0.00 0.00 120,000.00 100.00 R20 Other Taxes 120,000.00 0.00 0.00 120,000.00 100.00 10-100-410020 Electric Utility Lic Tax 3,580,000.00 0.00 0.00 3,580,000.00 100.00 10-100-410021 Electric Utility -AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 990,000.00 0.00 0.00 990,000.00 100.00 10-100-410031 Gas Utility -AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 INACTIVE - Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 INACTIVE - Cell Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,250,000.00 0.00 0.00 2,250,000.00 100.00 10-100-410053 TelephoneCell Utility -AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410060 Cable Franchise Fee 405,000.00 0.00 0.00 405,000.00 100.00 10-100-410061 Cable Utility -AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,225,000.00 0.00 0.00 7,225,000.00 100.00 10-100-420010 Cur Property Tax 4,600,000.00 5,148.38 0.00 4,594,851.62 99.89 10-100-420020 Del Property Tax 55,000.00 1,089.97 0.00 53,910.03 98.02 10-100-420040 Fin Inst Tax 20,000.00 0.00 0.00 20,000.00 100.00 10-100-420050 Prop Tax Int & Penalties 30,000.00 883.55 0.00 29,116.45 97.05 10-100-420055 Surtax Receipts - County Reimb 54,399.00 0.00 0.00 54,399.00 100.00 10-100-420060 Surtax Receipts 470,000.00 173.24 0.00 469,826.76 99.96 10-100-420080 Special Tax Rev 20,000.00 2,672.04 0.00 17,327.96 86.64 R40 Property Taxes 5,249,399.00 9,967.18 0.00 5,239,431.82 99.81 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page I Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 176,674.55 0.00 -176,674.55 0.00 10-100-430060 Drug Forfeiture 0.00 4,202.37 0.00 -4,202.37 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430100 State DNR Historic Pres. 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 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 180,876.92 0.00 -180,876.92 0.00 10-100-440010 Admin Charge Backs 1,527,958.00 0.00 0.00 1,527,958.00 100.00 10-100-440050 Emt Reimbursement 25,000.00 0.00 0.00 25,000.00 100.00 10-100-440210 Street Cuts 25,000.00 1,812.00 0.00 23,188.00 92.75 10-100-440910 Fuel Charge -backs 18,000.00 1,089.27 0.00 16,910.73 93.95 10-100-440920 Parts Charge -back 95,000.00 243.76 0.00 94,756.24 99.74 10-100-440930 Labor Charge -backs 125,000.00 568.40 0.00 124,431.60 99.55 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 0.00 0.00 100,000.00 100.00 10-100-481030 Rent City Hallannex 6,500.00 0.00 0.00 6,500.00 100.00 10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00 10-100-481045 Rent -tower Sites 115,000.00 2,000.00 0.00 113,000.00 98.26 10-100-481065 Parking Spot Maintenance 25,000.00 0.00 0.00 25,000.00 100.00 10-100-481075 Cole Cty 911 Reimb 348,556.80 29,929.89 0.00 318,626.91 91.41 10-100-481080 Sale Of Mapsgis Data 0.00 0.00 0.00 0.00 0.00 10-100-481085 Cole Cty GisJoint Coop 15,000.00 1,250.00 0.00 13,750.00 91.67 10-100-481090 Cole Cty Sheriff -New World 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,000.00 400.00 0.00 2,600.00 86.67 10-100-481105 TIF Administration Fee 7,730.00 0.00 0.00 7,730.00 100.00 10-100-481110 Long & Short 0.00 30.00 0.00 -30.00 0.00 R60 Charges for Services 2,448,744.80 37,323.32 0.00 2,411,421.48 98.48 10-100-450010 Liquor Licenses 65,000.00 315.00 0.00 64,685.00 99.52 10-100-450020 Business Licenses 215,000.00 22,875.70 0.00 192,124.30 89.36 10-100-450021 Home Occupation Permit 1,500.00 104.00 0.00 1,396.00 93.07 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 132.00 0.00 -132.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 5,500.00 672.00 0.00 4,828.00 87.78 10-100-450045 Bldg Constr Fees 125,000.00 8,893.25 0.00 116,106.75 92.89 10-100-450050 Electrical Certificates 16,000.00 1,026.00 0.00 14,974.00 93.59 10-100-450060 Electrical Permits 2,500.00 180.00 0.00 2,320.00 92.80 10-100-450070 Plumbing Licenses 10,000.00 0.00 0.00 10,000.00 100.00 10-100-450080 Plumbing Permits 5,000.00 340.00 0.00 4,660.00 93.20 10-100-450090 Other Lic & Permits 2,000.00 0.00 0.00 2,000.00 100.00 10-100-450091 Day Care Inspection Fees 8,000.00 0.00 0.00 8,000.00 100.00 10-100-450092 Food Inspection Fees 88,000.00 734.32 0.00 87,265.68 99.17 10-100-450100 Curb Cut Permits 1,500.00 208.00 0.00 1,292.00 86.13 10-100-450110 Board Of Adj Fees 1,200.00 0.00 0.00 1,200.00 100.00 10-100-450120 Sign Permits 5,000.00 247.00 0.00 4,753.00 95.06 10-100-450130 Demolition Permits 500.00 0.00 0.00 500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450150 Ace Rep Fees -police 12,000.00 875.30 0.00 11,124.70 92.71 10-100-450160 Accrptblastg P -fire 750.00 5.00 0.00 745.00 99.33 10-100-450170 Animal Redemption Fees 52,000.00 4,520.00 0.00 47,480.00 91.31 10-100-450180 Animal Vaccinations Fees 5,000.00 300.00 0.00 4,700.00 94.00 10-100-450185 Animal Cremation Fees 24,000.00 1,811.00 0.00 22,189.00 92.45 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 450.00 0.00 0.00 450.00 100.00 10-100-450230 Vacating Right Of Way 400.00 0.00 0.00 400.00 100.00 10-100-450250 Rezoning Request 10,000.00 2,466.00 0.00 7,534.00 75.34 10-100-450260 Non-refundable Plansspec 2,000.00 25.00 0.00 1,975.00 98.75 R65 Fees Licenses & Permits 658,300.00 45,729.57 0.00 612,570.43 93.05 10-100-460010 Court Cost 80,000.00 5,891.02 0.00 74,108.98 92.64 10-100-460015 Court Restitutions 1,300.00 0.00 0.00 1,300.00 100.00 10-100-460018 Inmate Security Fund 12,080.00 984.81 0.00 11,095.19 91.85 10-100-460020 Jail Cost Recovery 10,000.00 250.16 0.00 9,749.84 97.50 10-100-460025 Alcohol Offense Cost Rec 8,000.00 625.00 0.00 7,375.00 92.19 10-100-460030 Pol Fines -traffic 835,000.00 62,902.28 0.00 772,097.72 92.47 10-100-460040 Pol Tickets -parking 0.00 0.00 0.00 0.00 0.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 53,000.00 8,638.20 0.00 44,361.80 83.70 10-100-460100 Bankcard Charges -7,000.00 0.00 0.00 -7,000.00 100.00 R70 Fines & Forfeitures 992,380.00 79,291.47 0.00 913,088.53 92.01 10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.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 260.00 710.00 0.00 -450.00 -173.08 10-100-480055 JC Fire Museum 0.00 400.00 0.00 -400.00 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 0.00 0.00 0.00 0.00 0.00 10-100-480080 Dare Donations 0.00 500.00 0.00 -500.00 0.00 10-100-480090 Police K-9 Donations 0.00 0.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 89.00 0.00 -89.00 0.00 10-100-481050 Transfer StnPing-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair -Solid Waste Cntr 112,000.00 0.00 0.00 112,000.00 100.00 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R72 ContributionsDonations 112,260.00 1,699.00 0.00 110,561.00 98.49 10-100-450187 SpecialSn 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-480010 Citizen Participation 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-100-481070 Miscellaneous 30,000.00 1,331.42 0.00 28,668.58 95.56 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 10-100-481077 Insurance Claims 22,097.00 2,097.00 0.00 20,000.00 90.51 10-100-481078 Cafeteria Refunds 10,000.00 0.00 0.00 10,000.00 100.00 R75 Other Operating Revenues 62,097.00 3,428.42 0.00 58,668.58 94.48 10-100-470010 Interest 90,000.00 0.00 0.00 90,000.00 100.00 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 90,000.00 0.00 0.00 90,000.00 100.00 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 25,000.00 500.00 0.00 24,500.00 98.00 R85 Other Non -Operating Revenue 25,000.00 500.00 0.00 24,500.00 98.00 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 24,100.00 0.00 0.00 24,100.00 100.00 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 24,100.00 0.00 0.00 24,100.00 100.00 10-100-495995 Transfer From(to) Surplus 125,555.61 0.00 0.00 125,555.61 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 125,555.61 0.00 0.00 125,555.61 100.00 100 Revenue 29,035,345.41 -512,483.42 0.00 29,547,828.83 101.77 149 Entitlement Grant 10-149-430010 Federal Grants 205,495.26 0.00 0.00 205,495.26 100.00 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 205,495.26 0.00 0.00 205,495.26 100.00 149 Entitlement Grant 205,495.26 0.00 0.00 205,495.26 100.00 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 0.00 798.72 0.00 -798.72 0.00 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 750.00 -798.72 0.00 1.548.72 206.50 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-430010 Federal Grants 0.00 0.00 0.00 R50 Intergovernmental 750.00 0.00 0.00 750.00 100.00 300 Police Department 750.00 0.00 0.00 750.00 100.00 310 School Resource Officer 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 176,674.55 0.00 0.00 176,674.55 100.00 R50 Intergovernmental 176,674.55 0.00 0.00 176,674.55 100.00 310 School Resource Officer 176,674.55 0.00 0.00 176,674.55 100.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 30,761.68 0.00 0.00 30,761.68 100.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 30,761.68 0.00 0.00 30,761.68 100.00 320 M.U.S.T.A.N.G. 30,761.68 0.00 0.00 30,761.68 100.00 400 Fire Department 10-400-430010 Federal Grant 0.00 0.00 0.00 0.00 0.00 10-400-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 400 Fire Department 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs -MPO 10-522-430010 Federal Grants 141,626.54 0.00 0.00 141,626.54 100.00 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 8,851.66 2,955.81 0.00 5,895.85 66.61 R50 Intergovernmental 150,478.20 2,955.81 0.00 147,522.39 98.04 522 Plan & Protect Svcs -MPO 150,478.20 2,955.81 0.00 147,522.39 98.04 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 0.00 -251,672.28 0.00 251,672.28 0.00 10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-530-430040 Local Grants 11,000.00 0.00 0.00 11,000.00 100.00 R50 Intergovernmental 11,000.00 -251,672.28 0.00 262,672.28 2,387.93 530 Plan & Protect Svc-RedevGrant 11,000.00 -251,672.28 0.00 262,672.28 2,387.93 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 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-430010 Federal Grants 0.00 -118,243.91 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-430010 Federal Grants 0.00 -118,243.91 0.00 118,243.91 0.00 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 0.00 -118,243.91 0.00 118,243.91 0.00 990 Capital Projects 0.00 -118,243.91 0.00 118,243.91 0.00 Revenue Revenue 29,610,505.10 -879,443.80 0.00 30,489,948.90 102.97 Expense Expense 110 Mayor & Council 10-110-501010 Salary -Elected Officials 64,800.00 5,400.00 0.00 59,400.00 91.67 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 413.15 0.00 4,544.05 91.67 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 69,757.20 5,813.15 0.00 63,944.05 91.67 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-110-512010 Printing 750.00 0.00 0.00 750.00 100.00 10-110-512020 Copies 400.00 0.00 0.00 400.00 100.00 10-110-513010 Office Supplies 75.00 24.31 121.53 -70.84 -94.45 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,325.00 24.31 121.53 1,179.17 88.99 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 0.00 0.00 1,500.00 100.00 10-110-520030 Dues And Publications 4,582.90 0.00 0.00 4,582.90 100.00 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,400.00 0.00 0.00 1,400.00 100.00 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,582.90 0.00 0.00 7,582.90 100.00 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-547020 Maintenance Agreements 325.00 0.00 0.00 325.00 100.00 E25 Repairs & Maintenance 325.00 0.00 0.00 325.00 100.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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 110 Mayor & Council 78,990.10 5,837.46 121.53 73,031.12 92.46 120 City Clerk 10-120-501020 Salaries 65,539.49 3,781.19 0.00 61,758.30 94.23 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 5,013.77 270.53 0.00 4,743.24 94.60 10-120-502020 Group Health Insurance 13,043.71 830.20 0.00 12,213.51 93.64 10-120-502030 Retirement 11,534.95 665.47 0.00 10,869.48 94.23 10-120-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-120-502050 Life Insurance 110.61 6.79 0.00 103.82 93.86 10-120-502060 Long Term Disability 182.62 11.23 0.00 171.39 93.85 10-120-502070 Employee Assistance Prgm 32.87 0.00 0.00 32.87 100.00 E05 Personnel Services 95,458.02 5,565.41 0.00 89,892.61 94.17 10-120-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 400.00 0.00 0.00 400.00 100.00 10-120-513010 Office Supplies 500.00 0.00 0.00 500.00 100.00 E10 Materials & Supplies 1,100.00 0.00 0.00 1,100.00 100.00 10-120-520030 Dues And Publications 275.00 0.00 0.00 275.00 100.00 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-120-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 10-120-529030 Election Expense 35,000.00 0.00 0.00 35,000.00 100.00 E15 Contractual Services 36,775.00 0.00 0.00 36,775.00 100.00 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 0.00 24.31 121.53 -145.84 0.00 10-120-547020 Maintenance Agreements 525.00 0.00 0.00 525.00 100.00 E25 Repairs & Maintenance 525.00 24.31 121.53 379.17 72.22 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 133,858.02 5,589.72 121.53 128,146.78 95.73 140 City Administrator 10-140-501020 Salaries 224,385.52 13,345.41 0.00 211,040.11 94.05 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 17,165.49 977.36 0.00 16,188.13 94.31 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-502020 Group Health Insurance 19,199.71 1,107.01 0.00 18,092.70 94.23 10-140-502030 Retirement 37,581.76 2,204.74 0.00 35,377.02 94.13 10-140-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-140-502050 Life Insurance 342.72 21.89 0.00 320.83 93.61 10-140-502060 Long Tenn Disability 591.44 37.79 0.00 553.65 93.61 10-140-502070 Employee Assistance Prgm 49.43 0.00 0.00 49.43 100.00 E05 Personnel Services 299,316.07 17,694.20 0.00 281,621.87 94.09 10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-140-511020 Postage 350.00 0.00 0.00 350.00 100.00 10-140-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-140-512020 Copies 300.00 0.00 0.00 300.00 100.00 10-140-513010 Office Supplies 885.00 24.31 121.53 739.17 83.52 10-140-517010 Operational Supplies 1,500.00 0.00 0.00 1,500.00 100.00 E10 Materials & Supplies 4,235.00 24.31 121.53 4,089.17 96.56 10-140-520030 Dues And Publications 2,000.00 0.00 0.00 2,000.00 100.00 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 3,500.00 70.00 0.00 3,430.00 98.00 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 6,500.00 70.00 0.00 6,430.00 98.92 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 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 450.00 0.00 0.00 450.00 100.00 E25 Repairs & Maintenance 450.00 0.00 0.00 450.00 100.00 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 310,501.07 17,788.51 121.53 292,591.04 94.23 149 Entitlement Grant 10-149-501020 Salaries 18,727.37 1,321.79 0.00 17,405.58 92.94 10-149-501050 Parttime(wo Benefits) 20,000.00 817.50 0.00 19,182.50 95.91 10-149-502010 Social Security 2,962.64 163.62 0.00 2,799.02 94.48 10-149-502020 Group Health Insurance 3,163.15 219.11 0.00 2,944.04 93.07 10-149-502030 Retirement 3,296.02 232.63 0.00 3,063.39 92.94 10-149-502050 Life Insurance 31.70 2.38 0.00 29.32 92.49 10-149-502060 Long Term Disability 52.02 3.93 0.00 48.09 92.45 10-149-502070 Employee Assistance Program 12.36 0.00 0.00 12.36 100.00 E05 Personnel Services 48,245.26 2,760.96 0.00 45,484.30 94.28 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-511010 Advertising 1,500.00 0.00 0.00 1,500.00 100.00 10-149-511020 Postage 500.00 0.00 0.00 500.00 100.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-149-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 3,000.00 0.00 0.00 3,000.00 100.00 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 0.00 0.00 2,000.00 100.00 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 25,000.00 162.00 0.00 24,838.00 99.35 10-149-528012 Housing Rehab -Energy Efficient 27,000.00 4,500.00 0.00 22,500.00 83.33 10-149-528020 Housing Assistance 10,000.00 0.00 0.00 10,000.00 100.00 10-149-528030 Public Improvement 39,450.00 0.00 0.00 39,450.00 100.00 10-149-528040 Neighborhood Redevelopmnt 15,000.00 0.00 0.00 15,000.00 100.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 5,000.00 0.00 0.00 5,000.00 100.00 10-149-528080 Homeless Objectives 30,000.00 0.00 0.00 30,000.00 100.00 E15 Contractual Services 153,450.00 4,662.00 0.00 148,788.00 96.96 10-149-547020 Maintenance Agreements 800.00 0.00 0.00 800.00 100.00 E25 Repairs & Maintenance 800.00 0.00 0.00 800.00 100.00 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 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 205,495.26 7,422.96 0.00 198,072.30 96.39 150 City Counselor 10-150-501020 Salaries 222,294.95 12,888.26 0.00 209,406.69 94.20 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 17,005.56 913.42 0.00 16,092.14 94.63 10-150-502020 Group Health Insurance 36,130.31 2,030.78 0.00 34,099.53 94.38 10-150-502030 Retirement 39,123.91 2,268.32 0.00 36,855.59 94.20 10-150-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-150-502050 Life Insurance 390.53 24.13 0.00 366.40 93.82 10-150-502060 Long Term Disability 567.94 35.12 0.00 532.82 93.82 10-150-502070 Employee Assistance Prgm 82.55 0.00 0.00 82.55 100.00 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 315,595.75 18,160.03 0.00 297,435.72 94.25 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 0.00 0.00 600.00 100.00 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 0.00 0.00 670.00 100.00 10-150-513010 Office Supplies 5,667.00 0.00 0.00 5,667.00 100.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,137.00 0.00 0.00 7,137.00 100.00 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,000.00 410.00 0.00 10,590.00 96.27 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,000.00 0.00 0.00 6,000.00 100.00 10-150-520080 Tuition Reimbursement 3,420.00 0.00 0.00 3,420.00 100.00 10-150-521010 Malpractice Insurance 3,400.00 941.00 0.00 2,459.00 72.32 10-150-522020 Professional Services 8,000.00 0.00 0.00 8,000.00 100.00 10-150-525030 Court Cost & Witness Fees 75.00 0.00 0.00 75.00 100.00 E15 Contractual Services 31,895.00 1,351.00 0.00 30,544.00 95.76 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 10-150-547010 Equipment Maintenance 0.00 24.28 121.53 -145.81 0.00 10-150-547020 Maintenance Agreements 1,350.00 0.00 0.00 1,350.00 100.00 E25 Repairs & Maintenance 1,350.00 24.28 121.53 1,204.20 89.20 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 355,977.75 19,535.31 121.53 336,320.92 94.48 160 Municipal Court 10-160-501010 Salary -elected Officals 59,999.88 4,999.99 0.00 54,999.89 91.67 10-160-501020 Salaries 99,540.25 5,742.60 0.00 93,797.65 94.23 10-160-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits) 16,931.49 496.00 0.00 16,435.49 97.07 10-160-501090 Overtime 1,000.00 0.00 0.00 1,000.00 100.00 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,576.58 846.27 0.00 12,730.31 93.77 10-160-502020 Group Health Insurance 13,032.88 744.93 0.00 12,287.95 94.28 10-160-502030 Retirement 17,695.08 1,010.74 0.00 16,684.34 94.29 10-160-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-160-502050 Life Insurance 167.16 10.30 0.00 156.86 93.84 10-160-502060 Long Term Disability 277.85 17.09 0.00 260.76 93.85 10-160-502070 Employee Assistance Prgm 57.59 0.00 0.00 57.59 100.00 E05 Personnel Services 222,278.76 13,867.92 0.00 208,410.84 93.76 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-511020 Postage 4,000.00 0.00 0.00 4,000.00 100.00 10-160-512010 Printing 1,090.00 -128.77 0.00 1,218.77 111.81 10-160-512020 Copies 500.00 0.00 0.00 500.00 100.00 10-160-513010 Office Supplies 2,500.00 0.00 0.00 2,500.00 100.00 E10 Materials & Supplies 8,090.00 -128.77 0.00 8,218.77 101.59 10-160-520025 Security 10,000.00 0.00 0.00 10,000.00 100.00 10-160-520030 Dues And Publications 450.00 0.00 0.00 450.00 100.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 0.00 0.00 2,500.00 100.00 10-160-522020 Professional Services 3,000.00 125.00 0.00 2,875.00 95.83 10-160-525005 Appointed Counsel 7,000.00 1,260.00 0.00 5,740.00 82.00 10-160-525010 Care Of Prisoners 2,500.00 0.00 0.00 2,500.00 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 25,490.00 1,385.00 0.00 24,105.00 94.57 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 0.00 24.31 121.53 -145.84 0.00 10-160-547020 Maintenance Agreements 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 500.00 24.31 121.53 354.17 70.83 10-160-572020 Purchase Of Equipment 0.00 0.00 13,163.56 -13,163.56 0.00 E70 Capital Purchases 0.00 0.00 13,163.56 -13,163.56 0.00 160 Municipal Court 256,358.76 15,148.46 13,285.09 227,925.22 88.91 170 Human Resources 10-170-501020 Salaries 200,475.09 8,700.31 0.00 191,774.78 95.66 10-170-501050 Parttime(wo Benefits) 9,600.00 649.71 0.00 8,950.29 93.23 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-170-502010 Social Security 16,093.69 715.61 0.00 15,378.08 95.55 10-170-502020 Group Health Insurance 18,338.30 720.29 0.00 17,618.01 96.07 10-170-502030 Retirement 35,336.40 1,531.26 0.00 33,805.14 95.67 10-170-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-170-502050 Life Insurance 339.29 15.65 0.00 323.64 95.39 10-170-502060 Long Term Disability 512.86 23.00 0.00 489.86 95.52 10-170-502070 Employee Assistance Prgm 74.14 0.00 0.00 74.14 100.00 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 281,069.77 12,355.83 0.00 268,713.94 95.60 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-170-512010 Printing 2,000.00 0.00 0.00 2,000.00 100.00 10-170-512020 Copies 1,000.00 0.00 0.00 1,000.00 100.00 10-170-513010 Office Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-170-517010 Operational Supplies 750.00 0.00 0.00 750.00 100.00 E10 Materials & Sunnlies 5.700.00 0.00 0.00 5.700.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-520030 Dues And Publications 1,468.00 0.00 0.00 1,468.00 100.00 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 228.10 0.00 3,271.90 93.48 10-170-520070 Training And Education 4,000.00 361.20 0.00 3,638.80 90.97 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 8,000.00 0.00 0.00 8,000.00 100.00 10-170-522020 Professional Services 8,000.00 0.00 0.00 8,000.00 100.00 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 24,968.00 589.30 0.00 24,378.70 97.64 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 0.00 24.31 121.53 -145.84 0.00 10-170-547020 Maintenance Agreements 450.00 0.00 0.00 450.00 100.00 E25 Repairs & Maintenance 450.00 24.31 121.53 304.17 67.59 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 312,187.77 12,969.44 121.53 299,096.81 95.81 180 Finance Department 10-180-501020 Salaries 528,842.07 33,122.25 0.00 495,719.82 93.74 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 1,017.94 0.00 17,886.24 94.62 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 41,536.01 2,522.93 0.00 39,013.08 93.93 10-180-502020 Group Health Insurance 84,169.48 5,256.09 0.00 78,913.39 93.76 10-180-502030 Retirement 92,232.82 5,829.49 0.00 86,403.33 93.68 10-180-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-180-502050 Life Insurance 881.07 59.20 0.00 821.87 93.28 10-180-502060 Long Term Disability 1,447.10 97.39 0.00 1,349.71 93.27 10-180-502070 Employee Assistance Prgm 272.35 0.00 0.00 272.35 100.00 E05 Personnel Services 768,285.08 47,905.29 0.00 720,379.79 93.76 10-180-511010 Advertising 2,000.00 0.00 0.00 2,000.00 100.00 10-180-511020 Postage 11,000.00 0.00 0.00 11,000.00 100.00 10-180-511021 Mail Machine Cost 2,000.00 0.00 0.00 2,000.00 100.00 10-180-512010 Printing 5,000.00 610.10 0.00 4,389.90 87.80 10-180-512020 Copies 4,000.00 0.00 0.00 4,000.00 100.00 10-180-512021 Copy Machine Cost 0.00 145.83 729.15 -874.98 0.00 10-180-513010 Office Supplies 4,500.00 0.00 0.00 4,500.00 100.00 10-180-517010 Operational Supplies 4,000.00 0.00 0.00 4,000.00 100.00 E10 Materials & Supplies 32,500.00 755.93 729.15 31,014.92 95.43 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 1,400.00 0.00 0.00 1,400.00 100.00 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 3,000.00 0.00 0.00 3,000.00 100.00 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 27,700.00 0.00 26,219.00 1,481.00 5.35 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 2,000.00 0.00 0.00 2,000.00 100.00 E15 Contractual Services 34,100.00 0.00 26,219.00 7,881.00 23.11 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 0.00 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 2,000.00 0.00 0.00 2,000.00 100.00 E25 Repairs & Maintenance 2,000.00 0.00 0.00 2,000.00 100.00 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 836,885.08 48,661.22 26,948.15 761,275.71 90.97 185 Non -Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance -Group Health 17,000.00 0.00 0.00 17,000.00 100.00 10-185-502022 Wellness Assessment 25,000.00 0.00 0.00 25,000.00 100.00 10-185-502023 Self Insurance -Retirees 5,400.00 0.00 0.00 5,400.00 100.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 47,400.00 0.00 0.00 47,400.00 100.00 10-185-514010 Gas 21,600.00 0.00 0.00 21,600.00 100.00 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 21,600.00 0.00 0.00 21,600.00 100.00 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 270,000.00 36,951.29 0.00 233,048.71 86.31 10-185-521020 Insurance Deductible 20,000.00 0.00 0.00 20,000.00 100.00 10-185-521030 Self Ins Prop & Casualty 75,000.00 6,786.77 0.00 68,213.23 90.95 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 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 25,000.00 4,166.66 22,916.67 -2,083.33 -8.33 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-522025 JCTV 55,000.00 27,500.00 27,500.00 0.00 0.00 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 45,500.00 0.00 0.00 45,500.00 100.00 10-185-527020 Economic Development 185,000.00 46,250.00 0.00 138,750.00 75.00 10-185-529010 Special Events 7,000.00 0.00 0.00 7,000.00 100.00 E15 Contractual Services 683,000.00 121,654.72 50,416.67 510,928.61 74.81 10-185-531010 Electricity 42,000.00 1,648.67 0.00 40,351.33 96.07 10-185-533010 Natural Gas 6,200.00 28.83 0.00 6,171.17 99.54 10-185-535010 Water 7,250.00 341.66 0.00 6,908.34 95.29 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,450.00 2,019.16 0.00 53,430.84 96.36 10-185-540010 Building & Grounds Maint. 60,000.00 620.20 -2,610.57 61,990.37 103.32 10-185-540020 Tree & Landscape Maint 25,000.00 0.00 0.00 25,000.00 100.00 10-185-547020 Maintenance Agreements 2,000.00 0.00 0.00 2,000.00 100.00 E25 Repairs & Maintenance 87,000.00 620.20 -2,610.57 88,990.37 102.29 10-185-550010 Miscellaneous 10,000.00 1,098.00 0.00 8,902.00 89.02 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-550026 Addt'1 PositionsEquipment 232,250.77 0.00 0.00 232,250.77 100.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 0.00 0.00 10,000.00 100.00 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 6,000.00 0.00 0.00 6,000.00 100.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 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 258,250.77 1,098.00 0.00 257,152.77 99.57 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 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 185 Non -Departmental 1,152,700.77 125,392.08 47,806.10 979,502.59 84.97 190 I.T. Department 500.00 0.00 0.00 500.00 100.00 10-190-501020 Salaries 577,862.21 33,480.65 0.00 544,381.56 94.21 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 44,206.46 2,410.93 0.00 41,795.53 94.55 10-190-502020 Group Health Insurance 70,923.68 4,475.45 0.00 66,448.23 93.69 10-190-502030 Retirement 101,703.74 5,892.62 0.00 95,811.12 94.21 10-190-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-190-502050 Life Insurance 945.91 58.55 0.00 887.36 93.81 10-190-502060 Long Term Disability 1,490.40 92.29 0.00 1,398.11 93.81 10-190-502070 Employee Assistance Prgm 228.61 0.00 0.00 228.61 100.00 E05 Personnel Services 797,361.01 46,410.49 0.00 750,950.52 94.18 10-190-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-190-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,750.00 0.00 0.00 1,750.00 100.00 E10 Materials & Supplies 3,500.00 0.00 0.00 3,500.00 100.00 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 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,000.00 0.00 0.00 8,000.00 100.00 10-190-520080 Tuition Reimbursement 10,000.00 0.00 0.00 10,000.00 100.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 Tl Web 19,800.00 0.00 0.00 19,800.00 100.00 10-190-522050 Service -remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 3,600.00 0.00 0.00 3,600.00 100.00 E15 Contractual Services 43,900.00 0.00 0.00 43,900.00 100.00 10-190-534010 Telephone 58,000.00 276.99 0.00 57,723.01 99.52 E20 Utilities 58,000.00 276.99 0.00 57,723.01 99.52 10-190-545010 Software Licensemaint 195,000.00 72,364.00 0.00 122,636.00 62.89 10-190-545020 Citywide Wiringnetwork 3,000.00 0.00 0.00 3,000.00 100.00 10-190-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-547020 Maintenance Agreements 30,000.00 0.00 0.00 30,000.00 100.00 E25 Repairs & Maintenance 231,000.00 72,364.00 0.00 158,636.00 68.67 10-190-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 190 I.T. Department 1,133,761.01 119,051.48 0.00 1,014,709.53 89.50 300 Police Department 13,000.00 391.63 0.00 12,608.37 96.99 10-300-501020 Salaries 3,966,121.50 224,262.72 0.00 3,741,858.78 94.35 10-300-501030 Holiday Pay 127,510.80 11,179.02 0.00 116,331.78 91.23 10-300-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits) 28,400.00 1,652.27 0.00 26,747.73 94.18 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,500.00 272.00 0.00 6,228.00 95.82 10-300-501090 Overtime 171,152.50 13,482.63 0.00 157,669.87 92.12 10-300-501095 Overtime Straight Pay 6,000.00 140.92 0.00 5,859.08 97.65 10-300-502010 Social Security 329,327.52 18,106.62 0.00 311,220.90 94.50 10-300-502020 Group Health Insurance 734,685.47 39,815.06 0.00 694,870.41 94.58 10-300-502030 Retirement 839,140.74 47,462.33 0.00 791,678.41 94.34 10-300-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-300-502050 Life Insurance 6,800.30 399.69 0.00 6,400.61 94.12 10-300-502060 Long Term Disability 11,118.82 653.64 0.00 10,465.18 94.12 10-300-502070 Employee Assistance Prgm 2,199.60 0.00 0.00 2,199.60 100.00 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 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,231,557.25 357,426.90 0.00 5,874,130.35 94.26 10-300-511010 Advertising 3,000.00 0.00 0.00 3,000.00 100.00 10-300-511020 Postage 1,500.00 10.56 0.00 1,489.44 99.30 10-300-512010 Printing 5,000.00 781.18 0.00 4,218.82 84.38 10-300-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-300-512030 Photographic Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-300-513010 Office Supplies 13,000.00 391.63 0.00 12,608.37 96.99 10-300-514010 Gas 267,000.00 0.00 0.00 267,000.00 100.00 10-300-514040 Food 700.00 0.00 0.00 700.00 100.00 10-300-515040 First Aid Supplies 1,000.00 106.37 0.00 893.63 89.36 10-300-516010 Ammunition & Firearms Supplies 23,000.00 0.00 2,309.75 20,690.25 89.96 10-300-516020 Dare Program 16,500.00 95.15 0.00 16,404.85 99.42 10-300-516030 Special Investigation 2,500.00 1,000.00 0.00 1,500.00 60.00 10-300-516040 Investigations (Grant) 0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 0.00 -2,105.53 0.00 2,105.53 0.00 10-300-517010 Operational Supplies 30,000.00 1,723.58 0.00 28,276.42 94.25 E10 Materials & Supplies 365,300.00 2,002.94 2,309.75 360,987.31 98.82 10-300-520030 Dues And Publications 4,000.00 426.60 0.00 3,573.40 89.34 10-300-520050 INACTIVE - Mtgs & 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 0.00 0.00 7,000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-520090 Recruitment 2,500.00 0.00 0.00 2,500.00 100.00 10-300-521040 Medical Claimsservices 5,000.00 560.00 0.00 4,440.00 88.80 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 12,000.00 5,048.00 5,000.00 1,952.00 16.27 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-522028 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 8,000.00 0.00 7,000.00 1,000.00 12.50 10-300-523030 Building Lease 0.00 0.00 0.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 260.00 131.46 0.00 128.54 49.44 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 0.00 0.00 2,200.00 100.00 E15 Contractual Services 40,960.00 6,166.06 12,000.00 22,793.94 55.65 10-300-531010 Electricity 65,000.00 3,973.18 0.00 61,026.82 93.89 10-300-533010 Natural Gas 12,000.00 1,768.35 0.00 10,231.65 85.26 10-300-534010 Telephone 19,500.00 87.43 0.00 19,412.57 99.55 10-300-535010 Water 4,500.00 309.46 0.00 4,190.54 93.12 E20 Utilities 101,000.00 6,138.42 0.00 94,861.58 93.92 10-300-540010 Building & Grounds Maint. 61,000.00 999.06 -14,334.81 74,335.75 121.86 10-300-541030 Vehicle Wash 12,000.00 0.00 0.00 12,000.00 100.00 10-300-544010 K-9 Operations 9,000.00 233.75 0.00 8,766.25 97.40 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 16,000.00 0.00 0.00 16,000.00 100.00 10-300-546010 Clothing Expense 43,000.00 529.49 -4,009.75 46,480.26 108.09 10-300-546020 Uniform Cleaning 25,000.00 1,808.82 0.00 23,191.18 92.76 10-300-547010 Equipment Maintenance 11,150.00 0.00 0.00 11,150.00 100.00 10-300-547020 Maintenance Agreements 27,500.00 7,816.83 3,563.90 16,119.27 58.62 10-300-547030 Radio Maintenance 10,000.00 651.82 0.00 9,348.18 93.48 E25 Repairs & Maintenance 214,650.00 12,039.77 -14,780.66 217,390.89 101.28 10-300-572010 Purchase Of Vehicles 240,000.00 0.00 0.00 240,000.00 100.00 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 0.00 0.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 263.32 0.00 -263.32 0.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 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 Sery 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 240,000.00 263.32 0.00 239,736.68 99.89 300 Police Department 7,193,467.25 384,037.41 -470.91 6,809,900.75 94.67 310 School Resource Officer 10-310-501020 Salaries 226,076.71 13,175.42 0.00 212,901.29 94.17 10-310-501030 Holiday Pay 8,692.49 869.25 0.00 7,823.24 90.00 10-310-501090 Overtime 7,126.00 694.29 0.00 6,431.71 90.26 10-310-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-310-502010 Social Security 18,504.98 992.18 0.00 17,512.80 94.64 10-310-502020 Group Health Insurance 42,816.10 3,271.04 0.00 39,545.06 92.36 10-310-502030 Retirement 47,895.25 2,918.32 0.00 44,976.93 93.91 10-310-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-310-502050 Life Insurance 378.71 23.22 0.00 355.49 93.87 10-310-502060 Long Term Disability 627.42 38.45 0.00 588.97 93.87 10-310-502070 Employee Assistance Prgm 123.57 0.00 0.00 123.57 100.00 E05 Personnel Services 352,241.23 21,982.17 0.00 330,259.06 93.76 10-310-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-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 352,241.23 21,982.17 0.00 330,259.06 93.76 320 M.U.S.T.A.N.G. GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-501020 Salaries 137,810.20 5,357.29 0.00 132,452.91 96.11 10-320-501030 Holiday Pay 5,225.62 358.58 0.00 4,867.04 93.14 10-320-501090 Overtime 6,897.00 206.75 0.00 6,690.25 97.00 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 11,469.86 417.31 0.00 11,052.55 96.36 10-320-502020 Group Health Insurance 31,962.96 1,042.98 0.00 30,919.98 96.74 10-320-502030 Retirement 29,686.70 1,172.68 0.00 28,514.02 96.05 10-320-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-320-502050 Life Insurance 231.34 9.85 0.00 221.49 95.74 10-320-502060 Long Term Disability 380.42 16.12 0.00 364.30 95.76 10-320-502070 Employee Assistance Prgm 74.14 0.00 0.00 74.14 100.00 E05 Personnel Services 223,738.24 8,581.56 0.00 215,156.68 96.16 10-320-514010 Gas 20,000.00 277.03 0.00 19,722.97 98.61 10-320-516040 Investigations 14,350.00 2,260.00 0.00 12,090.00 84.25 10-320-517010 Operational Supplies 0.00 158.72 0.00 -158.72 0.00 E10 Materials & Supplies 34,350.00 2,695.75 0.00 31,654.25 92.15 10-320-520050 INACTIVE - Mtgs & 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 10,000.00 0.00 0.00 10,000.00 100.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 10,000.00 0.00 0.00 10,000.00 100.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 10-320-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-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. 268,088.24 11,277.31 0.00 256,810.93 95.79 330 Animal Control 10-330-501020 Salaries 320,566.35 17,300.15 0.00 303,266.20 94.60 10-330-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,200.00 272.00 0.00 3,928.00 93.52 10-330-501090 Overtime 1,709.00 0.00 0.00 1,709.00 100.00 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,013.61 1,237.09 0.00 23,776.52 95.05 10-330-502020 Group Health Insurance 46,734.22 4,343.37 0.00 42,390.85 90.71 10-330-502030 Retirement 57,547.66 3,092.70 0.00 54,454.96 94.63 10-330-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-502050 Life Insurance 541.50 33.22 0.00 508.28 93.87 10-330-502060 Long Term Disability 895.97 54.95 0.00 841.02 93.87 10-330-502070 Employee Assistance Prgm 197.72 0.00 0.00 197.72 100.00 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 457,906.03 26,333.48 0.00 431,572.55 94.25 10-330-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-330-511020 Postage 300.00 0.00 0.00 300.00 100.00 10-330-512010 Printing 1,700.00 0.00 0.00 1,700.00 100.00 10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-330-513010 Office Supplies 800.00 0.00 0.00 800.00 100.00 10-330-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-330-515040 First Aid Supplies 750.00 120.89 0.00 629.11 83.88 10-330-517010 Operational Supplies 10,000.00 0.00 0.00 10,000.00 100.00 E10 Materials & Supplies 14,170.00 120.89 0.00 14,049.11 99.15 10-330-520030 Dues And Publications 900.00 0.00 0.00 900.00 100.00 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,650.00 0.00 0.00 1,650.00 100.00 10-330-521040 Medical Claimsservices 1,500.00 0.00 0.00 1,500.00 100.00 10-330-522020 Professional Services 9,600.00 0.00 0.00 9,600.00 100.00 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 10,000.00 1,729.18 0.00 8,270.82 82.71 10-330-529060 Special So 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 10-330-529068 Animal Shelter Donations 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,650.00 1,729.18 0.00 21,920.82 92.69 10-330-531010 Electricity 24,000.00 0.00 0.00 24,000.00 100.00 10-330-533010 Natural Gas 17,000.00 0.00 0.00 17,000.00 100.00 10-330-534010 Telephone 300.00 0.00 0.00 300.00 100.00 10-330-535010 Water 4,000.00 130.61 0.00 3,869.39 96.73 E20 Utilities 45,300.00 130.61 0.00 45,169.39 99.71 10-330-540010 Building & Grounds Maint. 9,000.00 25.00 -3,696.95 12,671.95 140.80 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 0.00 0.00 540.00 100.00 10-330-544040 Care Of Animals 40,000.00 2,530.95 -3,554.04 41,023.09 102.56 10-330-546010 Clothing Expense 3,000.00 107.40 0.00 2,892.60 96.42 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 1,000.00 77.24 0.00 922.76 92.28 10-330-547020 Maintenance Agreements 1,600.00 1,500.00 0.00 100.00 6.25 10-330-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 55,640.00 4,240.59 -7,250.99 58,650.40 105.41 10-330-572010 Purchase of Vehicles 24,000.00 0.00 0.00 24,000.00 100.00 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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 24,000.00 0.00 0.00 24,000.00 100.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 620,666.03 32,554.75 -7,250.99 595,362.27 95.92 390 9-1-1 Police 10-390-501020 Salaries 802,758.23 46,383.14 0.00 756,375.09 94.22 10-390-501030 Holiday Pay 28,998.73 2,628.95 0.00 26,369.78 90.93 10-390-501050 Parttime(wo Benefits) 2,600.00 250.46 0.00 2,349.54 90.37 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 431.94 0.00 15,382.06 97.27 10-390-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-390-502010 Social Security 65,076.33 3,580.62 0.00 61,495.71 94.50 10-390-502020 Group Health Insurance 170,798.30 9,678.02 0.00 161,120.28 94.33 10-390-502030 Retirement 149,260.49 8,702.11 0.00 140,558.38 94.17 10-390-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,367.45 83.62 0.00 1,283.83 93.88 10-390-502060 Long Tenn Disability 2,240.84 137.11 0.00 2,103.73 93.88 10-390-502070 Employee Assistance Prgm 512.83 0.00 0.00 512.83 100.00 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,239,927.20 71,875.97 0.00 1,168,051.23 94.20 10-390-511010 Advertising 500.00 0.00 0.00 500.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 591.50 0.00 4,408.50 88.17 E10 Materials & Supplies 5,500.00 591.50 0.00 4,908.50 89.25 10-390-520030 Dues And Publications 600.00 0.00 0.00 600.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,000.00 0.00 0.00 5,000.00 100.00 10-390-522020 Professional Services 1,200.00 0.00 0.00 1,200.00 100.00 10-390-523010 Equipment Rentlease 98,000.00 7,632.42 6,180.00 84,187.58 85.91 E15 Contractual Services 104,800.00 7,632.42 6,180.00 90,987.58 86.82 10-390-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-390-546010 Clothing Expense 6,000.00 0.00 0.00 6,000.00 100.00 10-390-546020 Uniform Cleaning 1,000.00 0.00 0.00 1,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 29,000.00 9,304.34 2,211.19 17,484.47 60.29 10-390-547030 Radio Maintenance 5,000.00 605.00 0.00 4,395.00 87.90 E25 Repairs & Maintenance 44,000.00 9,909.34 2,211.19 31,879.47 72.45 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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 390 9-1-1 Police 1,394,227.20 90,009.23 8,391.19 1,295,826.78 92.94 400 Fire Department 0.00 0.00 0.00 0.00 0.00 10-400-501020 Salaries 3,505,507.23 210,123.69 0.00 3,295,383.54 94.01 10-400-501030 Holiday Pay 272,061.79 27,125.33 0.00 244,936.46 90.03 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 1,950.00 0.00 26,050.00 93.04 10-400-501090 Overtime 35,000.00 4,337.00 0.00 30,663.00 87.61 10-400-501095 Overtime Straight Pay 32,000.00 2,467.63 0.00 29,532.37 92.29 10-400-502010 Social Security 58,511.68 3,260.60 0.00 55,251.08 94.43 10-400-502020 Group Health Insurance 632,155.71 37,296.42 0.00 594,859.29 94.10 10-400-502030 Retirement 1,617,193.48 102,262.27 0.00 1,514,931.21 93.68 10-400-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-400-502050 Life Insurance 5,933.71 374.39 0.00 5,559.32 93.69 10-400-502060 Long Term Disability 9,795.18 615.65 0.00 9,179.53 93.71 10-400-502070 Employee Assistance Prgm 1,804.17 0.00 0.00 1,804.17 100.00 10-400-503010 Awards Program 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,198,962.95 389,812.98 0.00 5,809,149.97 93.71 10-400-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-400-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-400-512010 Printing 1,250.00 294.00 0.00 956.00 76.48 10-400-512020 Copies 50.00 0.00 0.00 50.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 114.00 0.00 1,686.00 93.67 10-400-514010 Gas 73,000.00 0.00 0.00 73,000.00 100.00 10-400-514020 Chemicals 2,000.00 0.00 0.00 2,000.00 100.00 10-400-514030 Small Tools 2,500.00 0.00 0.00 2,500.00 100.00 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,000.00 497.32 447.00 7,055.68 88.20 E10 Materials & Supplies 89,350.00 905.32 447.00 87,997.68 98.49 10-400-520030 Dues And Publications 1,240.00 150.00 0.00 1,090.00 87.90 10-400-520050 INACTIVE - Mtgs & 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 0.00 0.00 10,000.00 100.00 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 200.00 0.00 0.00 200.00 100.00 10-400-523010 Equipment Rentlease 500.00 0.00 0.00 500.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 0.00 0.00 6,000.00 100.00 10-400-529040 INACTIVE - Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 25,890.00 150.00 0.00 25,740.00 99.42 10-400-531010 Electricity 27,500.00 -3.00 0.00 27,503.00 100.01 10-400-533010 Natural Gas 27,500.00 0.00 0.00 27,500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-534010 Telephone 17,500.00 4.61 0.00 17,495.39 99.97 10-400-535010 Water 8,720.00 95.80 0.00 8,624.20 98.90 E20 Utilities 81,220.00 97.41 0.00 81,122.59 99.88 10-400-540010 Building & Grounds Maim. 60,000.00 0.00 -2,791.33 62,791.33 104.65 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 35,000.00 0.00 -8,254.29 43,254.29 123.58 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 188.66 0.00 17,811.34 98.95 10-400-547020 Maintenance Agreements 14,900.00 0.00 -7,810.01 22,710.01 152.42 10-400-547030 Radio Maintenance 7,000.00 0.00 0.00 7,000.00 100.00 E25 Repairs & Maintenance 135,966.00 188.66 -18,855.63 154,632.97 113.73 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 0.00 0.00 22,495.00 -22,495.00 0.00 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 0.00 0.00 22,495.00 -22,495.00 0.00 400 Fire Department 6,531,388.95 391,154.37 4,086.37 6,136,148.21 93.95 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 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 INACTIVE - Mtgs & 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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Sery 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 209,722.72 12,122.41 0.00 197,600.31 94.22 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 16,043.79 876.09 0.00 15,167.70 94.54 10-520-502020 Group Health Insurance 34,618.66 1,924.17 0.00 32,694.49 94.44 10-520-502030 Retirement 36,911.20 2,133.53 0.00 34,777.67 94.22 10-520-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-520-502050 Life Insurance 354.72 21.87 0.00 332.85 93.83 10-520-502060 Long Term Disability 542.48 33.45 0.00 509.03 93.83 10-520-502070 Employee Assistance Prgm 98.86 0.00 0.00 98.86 100.00 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 298,292.43 17,111.52 0.00 281,180.91 94.26 10-520-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-520-511020 Postage 200.00 0.00 0.00 200.00 100.00 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 0.00 0.00 800.00 100.00 10-520-514010 Gas 19,000.00 0.00 0.00 19,000.00 100.00 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 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 20,600.00 0.00 0.00 20,600.00 100.00 10-520-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-520-522020 Professional Services 3,000.00 0.00 0.00 3,000.00 100.00 E15 Contractual Services 5.000.00 0.00 0.00 5.000.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 650.00 31.68 21.12 597.20 91.88 E25 Repairs & Maintenance 650.00 31.68 21.12 597.20 91.88 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 324,542.43 17,143.20 21.12 307,378.11 94.71 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 58,731.84 3,403.70 0.00 55,328.14 94.20 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 624.00 0.00 11,856.00 95.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 5,447.71 308.13 0.00 5,139.58 94.34 10-521-502020 Group Health Insurance 6,326.31 359.53 0.00 5,966.78 94.32 10-521-502030 Retirement 10,336.80 599.05 0.00 9,737.75 94.20 10-521-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-521-502050 Life Insurance 89.11 5.52 0.00 83.59 93.81 10-521-502060 Long Term Disability 148.10 9.17 0.00 138.93 93.81 10-521-502070 Employee Assistance Prgm 24.71 0.00 0.00 24.71 100.00 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 93,584.58 5,309.10 0.00 88,275.48 94.33 10-521-511010 Advertising 5,000.00 0.00 0.00 5,000.00 100.00 10-521-511020 Postage 1,500.00 0.00 0.00 1,500.00 100.00 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,350.00 0.00 0.00 1,350.00 100.00 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 10,060.00 0.00 0.00 10,060.00 100.00 10-521-520030 Dues And Publications 15,500.00 0.00 0.00 15,500.00 100.00 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,700.00 0.00 0.00 1,700.00 100.00 10-521-520080 Tuition Reimbursement 1,710.00 0.00 0.00 1,710.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,910.00 0.00 0.00 18,910.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 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,500.00 51.84 34.56 1,413.60 94.24 E25 Repairs & Maintenance 1,500.00 51.84 34.56 1,413.60 94.24 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 124,054.58 5,360.94 34.56 118,659.08 95.65 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 107,262.79 6,188.25 0.00 101,074.54 94.23 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,205.60 472.21 0.00 7,733.39 94.25 10-522-502020 Group Health Insurance 12,270.61 715.92 0.00 11,554.69 94.17 10-522-502030 Retirement 18,878.25 1,089.13 0.00 17,789.12 94.23 10-522-502040 Workers Compensation 134.73 0.00 0.00 134.73 100.00 10-522-502050 Life Insurance 181.64 11.17 0.00 170.47 93.85 10-522-502060 Long Term Disability 300.12 18.45 0.00 281.67 93.85 10-522-502070 Employee Assistance Prgm 49.43 0.00 0.00 49.43 100.00 E05 Personnel Services 147,283.17 8,495.13 0.00 138,788.04 94.23 10-522-511010 Advertising 750.00 0.00 0.00 750.00 100.00 10-522-511020 Postage 400.00 0.00 0.00 400.00 100.00 10-522-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-522-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-522-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 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,600.00 0.00 0.00 3,600.00 100.00 10-522-520030 Dues And Publications 1,000.00 98.00 0.00 902.00 90.20 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 6,250.00 0.00 0.00 6,250.00 100.00 10-522-522020 Professional Services 17,500.00 0.00 17,500.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 24,750.00 98.00 17,500.00 7,152.00 28.90 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 54.72 36.48 1,308.80 93.49 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 0.00 10-530-547020 Maintenance Agreements 400.00 89.28 59.52 E25 Repairs & Maintenance 1,400.00 54.72 36.48 1,308.80 93.49 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 177,033.17 8,647.85 17,536.48 150,848.84 85.21 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 66,757.43 3,397.29 0.00 63,360.14 94.91 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 5,106.94 227.55 0.00 4,879.39 95.54 10-530-502020 Group Health Insurance 9,587.38 436.65 0.00 9,150.73 95.45 10-530-502030 Retirement 11,749.31 597.91 0.00 11,151.40 94.91 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 112.24 6.12 0.00 106.12 94.55 10-530-502060 Long Term Disability 184.70 10.04 0.00 174.66 94.56 10-530-502070 Employee Assistance Prgm 37.07 0.00 0.00 37.07 100.00 E05 Personnel Services 93,535.07 4,675.56 0.00 88,859.51 95.00 10-530-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-530-511020 Postage 100.00 0.00 0.00 100.00 100.00 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 600.00 0.00 0.00 600.00 100.00 10-530-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 1,400.00 0.00 0.00 1,400.00 100.00 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 241.76 0.00 1,558.24 86.57 10-530-522020 Professional Services 1,000.00 0.00 0.00 1,000.00 100.00 10-530-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00 10-530-524025 Glass Recycling 7,000.00 0.00 6,000.00 1,000.00 14.29 10-530-524026 Household Hazardous Waste 18,000.00 0.00 0.00 18,000.00 100.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 7,000.00 0.00 0.00 7,000.00 100.00 10-530-528085 Fair Housing Assistance Prog 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 36,800.00 241.76 6,000.00 30,558.24 83.04 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 400.00 89.28 59.52 251.20 62.80 E25 Repairs & Maintenance 400.00 89.28 59.52 251.20 62.80 10-530-550020 Neighborhood Reinvestment 45,000.00 0.00 0.00 45,000.00 100.00 10-530-550030 Old Town Proiects 45.500.00 3.943.13 0.00 41.556.87 91.33 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 500.00 0.00 0.00 500.00 100.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 91,000.00 3,943.13 0.00 87,056.87 95.67 530 Plan & Protect Svc-RedevGrant 223,135.07 8,949.73 6,059.52 208,125.82 93.27 531 Plan & Protect Svcs -Build Reg 0.00 0.00 0.00 0.00 0.00 10-531-501020 Salaries 0.00 5,974.80 0.00 -5,974.80 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 399.45 0.00 -399.45 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 449.31 0.00 -449.31 0.00 10-531-502020 Group Health Insurance 0.00 1,083.98 0.00 -1,083.98 0.00 10-531-502030 Retirement 0.00 937.46 0.00 -937.46 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 10.29 0.00 -10.29 0.00 10-531-502060 Long Term Disability 0.00 16.94 0.00 -16.94 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 8,872.23 0.00 -8,872.23 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-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-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.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 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio 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-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 0.00 8,872.23 0.00 -8,872.23 0.00 532 Plan & Protect Svcs -Env Health 10-532-501020 Salaries 162,597.53 8,746.07 0.00 153,851.46 94.62 10-532-501050 Parttime (wo Benefits) 3,957.00 0.00 0.00 3,957.00 100.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 12,741.42 616.15 0.00 12,125.27 95.16 10-532-502020 Group Health Insurance 33,031.05 1,640.49 0.00 31,390.56 95.03 10-532-502030 Retirement 28,617.17 1,539.32 0.00 27,077.85 94.62 10-532-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-532-502050 Life Insurance 274.18 15.73 0.00 258.45 94.26 10-532-502060 Long Term Disability 452.88 26.00 0.00 426.88 94.26 10-532-502070 Employee Assistance Prgm 74.14 0.00 0.00 74.14 100.00 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 241,745.37 12,583.76 0.00 229,161.61 94.79 10-532-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-532-511020 Postage 200.00 0.00 0.00 200.00 100.00 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 0.00 0.00 1,000.00 100.00 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 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,200.00 0.00 0.00 1,200.00 100.00 E10 Materials & Supplies 2,835.00 0.00 0.00 2,835.00 100.00 10-532-520030 Dues And Publications 1,000.00 15.00 0.00 985.00 98.50 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,300.00 0.00 0.00 1,300.00 100.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 997.50 -997.50 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-524025 Glass Recycling 0.00 330.00 110.00 -440.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 218,000.00 17,916.67 197,083.33 3,000.00 1.38 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 221,300.00 18,261.67 198,190.83 4,847.50 2.19 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 26,000.00 0.00 25,160.00 840.00 3.23 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 0.00 0.00 1,290.00 100.00 10-532-546010 Clothing Expense 160.00 0.00 0.00 160.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 28.80 19.20 1,152.00 96.00 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 28,730.00 28.80 25,179.20 3,522.00 12.26 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 494,610.37 30,874.23 223,370.03 240,366.11 48.60 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 147,805.18 5,647.41 0.00 142,157.77 96.18 10-533-501060 Seasonal Salaries 15,990.00 0.00 0.00 15,990.00 100.00 10-533-501090 Overtime 370.00 119.82 0.00 250.18 67.62 10-533-501095 Overtime Straight Pay 100.00 0.00 0.00 100.00 100.00 10-533-502010 Social Security 12,566.29 413.19 0.00 12,153.10 96.71 10-533-502020 Group Health Insurance 25,990.23 973.64 0.00 25,016.59 96.25 10-533-502030 Retirement 26,013.71 1,015.03 0.00 24,998.68 96.10 10-533-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-533-502050 Life Insurance 250.19 10.22 0.00 239.97 95.92 10-533-502060 Long Term Disability 411.26 16.80 0.00 394.46 95.91 10-533-502070 Employee Assistance Prgm 74.14 0.00 0.00 74.14 100.00 E05 Personnel Services 229,571.00 8,196.11 0.00 221,374.89 96.43 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,500.00 0.00 0.00 1,500.00 100.00 10-533-512010 Printing 350.00 0.00 0.00 350.00 100.00 10-533-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 900.00 0.00 0.00 900.00 100.00 10-533-514030 Small Tools 150.00 0.00 0.00 150.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,350.00 0.00 0.00 1,350.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 4,380.00 0.00 0.00 4,380.00 100.00 10-533-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 15,000.00 0.00 0.00 15,000.00 100.00 10-533-522022 Demo 20,000.00 0.00 0.00 20,000.00 100.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 36,500.00 0.00 0.00 36,500.00 100.00 10-533-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-533-541030 Vehicle Wash 270.00 0.00 0.00 270.00 100.00 10-533-546010 Clothing Expense 160.00 0.00 0.00 160.00 100.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 650.00 67.68 45.12 537.20 82.65 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,110.00 67.68 45.12 997.20 89.84 10-533-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 533 PPS - Prop MaintCode Enforce 271,561.00 8,263.79 45.12 263,252.09 96.94 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 215,803.73 3,853.20 0.00 211,950.53 98.21 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 370.00 0.00 0.00 370.00 100.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 16,542.26 276.25 0.00 16,266.01 98.33 10-534-502020 Group Health Insurance 30,156.23 638.15 0.00 29,518.08 97.88 10-534-502030 Retirement 37,981.46 379.76 0.00 37,601.70 99.00 10-534-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-534-502050 Life Insurance 380.42 6.72 0.00 373.70 98.23 10-534-502060 Long Term Disability 628.65 11.09 0.00 617.56 98.24 10-534-502070 Employee Assistance Prgm 98.86 0.00 0.00 98.86 100.00 E05 Personnel Services 302,026.61 5,165.17 0.00 296,861.44 98.29 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,000.00 0.00 0.00 1,000.00 100.00 10-534-512010 Printing 350.00 0.00 0.00 350.00 100.00 10-534-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 0.00 0.00 900.00 100.00 10-534-514030 Small Tools 150.00 0.00 0.00 150.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,350.00 0.00 0.00 1,350.00 100.00 E10 Materials & Supplies 3,880.00 0.00 0.00 3,880.00 100.00 10-534-520030 Dues And Publications 1,000.00 0.00 0.00 1,000.00 100.00 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 2,500.00 0.00 0.00 2,500.00 100.00 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,500.00 0.00 0.00 3,500.00 100.00 10-534-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-534-541030 Vehicle Wash 270.00 0.00 0.00 270.00 100.00 10-534-546010 Clothing Expense 160.00 0.00 0.00 160.00 100.00 10-534-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-534-547020 Maintenance Agreements 650.00 50.40 33.60 566.00 87.08 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,110.00 50.40 33.60 1,026.00 92.43 10-534-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 534 Plan & Protect Svcs -Bldg Regs 310,516.61 5,215.57 33.60 305,267.44 98.31 535 Public Works -Central Maintenan 10-535-501020 Salaries 313,289.54 19,295.82 0.00 293,993.72 93.84 10-535-501040 Part-time (wbenefits) 24,082.81 0.00 0.00 24,082.81 100.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 0.00 0.00 4,500.00 100.00 10-535-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-535-502010 Social Security 26,757.59 1,347.63 0.00 25,409.96 94.96 10-535-502020 Group Health Insurance 88,589.19 4,926.73 0.00 83,662.46 94.44 10-535-502030 Retirement 60,257.53 3,396.05 0.00 56,861.48 94.36 10-535-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-535-502050 Life Insurance 572.34 34.84 0.00 537.50 93.91 10-535-502060 Long Term Disability 945.17 57.56 0.00 887.61 93.91 10-535-502070 Employee Assistance Prgm 173.00 0.00 0.00 173.00 100.00 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 527,067.17 29,058.63 0.00 498,008.54 94.49 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postaee 50.00 0.00 0.00 50.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 291.94 0.00 6,708.06 95.83 10-535-517010 Operational Supplies 6,000.00 170.93 -48.00 5,877.07 97.95 E10 Materials & Supplies 14,640.00 462.87 -48.00 14,225.13 97.17 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 0.00 0.00 2,000.00 100.00 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.00 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,500.00 0.00 0.00 2,500.00 100.00 10-535-531010 Electricity 7,200.00 0.00 0.00 7,200.00 100.00 10-535-533010 Natural Gas 7,000.00 0.00 0.00 7,000.00 100.00 10-535-534010 Telephone 220.00 72.00 144.00 4.00 1.82 10-535-535010 Water 1,400.00 69.43 0.00 1,330.57 95.04 E20 Utilities 15,820.00 141.43 144.00 15,534.57 98.20 10-535-540010 Building & Grounds Maint. 10,000.00 0.00 25.00 9,975.00 99.75 10-535-541010 Veh & Equip Parts Etc 425,000.00 30,327.41 0.00 394,672.59 92.86 10-535-546010 Clothing Expense 5,000.00 517.41 -281.96 4,764.55 95.29 10-535-547010 Equipment Maintenance 4,300.00 0.00 0.00 4,300.00 100.00 10-535-547020 Maintenance Agreements 4,100.00 106.00 211.20 3,782.80 92.26 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 448,900.00 30,950.82 -45.76 417,994.94 93.12 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,008,927.17 60,613.75 50.24 948,263.18 93.99 540 Public Works -Admin 10-540-501020 Salaries 197,163.06 11,397.75 0.00 185,765.31 94.22 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 15,082.97 795.29 0.00 14,287.68 94.73 10-540-502020 Group Health Insurance 32,634.09 1,859.62 0.00 30,774.47 94.30 10-540-502030 Retirement 34,700.70 2,006.01 0.00 32,694.69 94.22 10-540-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-540-502050 Life Insurance 323.87 19.97 0.00 303.90 93.83 10-540-502060 Long Term Disability 471.48 29.07 0.00 442.41 93.83 10-540-502070 Employee Assistance Prgm 74.14 0.00 0.00 74.14 100.00 E05 Personnel Services 280,450.31 16,107.71 0.00 264,342.60 94.26 10-540-511010 Advertisine 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 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 130,000.00 0.00 0.00 130,000.00 100.00 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 1,300.00 0.00 0.00 1,300.00 100.00 E10 Materials & Supplies 133,000.00 0.00 0.00 133,000.00 100.00 10-540-520030 Dues And Publications 500.00 307.80 0.00 192.20 38.44 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,000.00 0.00 0.00 2,000.00 100.00 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,700.00 307.80 0.00 2,392.20 88.60 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 1,175.00 28.80 19.20 1,127.00 95.91 E25 Repairs & Maintenance 1,175.00 28.80 19.20 1,127.00 95.91 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 417,325.31 16,444.31 19.20 400,861.80 96.05 541 Public Works -Engineering 10-541-501020 Salaries 683,642.80 39,453.74 0.00 644,189.06 94.23 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 400.00 0.00 0.00 400.00 100.00 10-541-501095 Overtime Straight Pay 400.00 0.00 0.00 400.00 100.00 10-541-502010 Social Security 52,359.87 2,824.88 0.00 49,534.99 94.60 10-541-502020 Group Health Insurance 94,160.94 5,976.20 0.00 88,184.74 93.65 10-541-502030 Retirement 120,461.93 6,552.96 0.00 113,908.97 94.56 10-541-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-541-502050 Life Insurance 1,141.26 70.17 0.00 1,071.09 93.85 10-541-502060 Long Term Disability 1,884.96 116.01 0.00 1,768.95 93.85 10-541-502070 Employee Assistance Prgm 271.86 0.00 0.00 271.86 100.00 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 954,723.62 54,993.96 0.00 899,729.66 94.24 10-541-511010 Advertising 600.00 0.00 0.00 600.00 100.00 10-541-511020 Postage 800.00 0.00 0.00 800.00 100.00 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Conies 75.00 0.00 0.00 75.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 34 Sort Level DescriDtlon Budget YTD Actual Encumbered Remainine Budget % UncollectedAvailable 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 5,800.00 0.00 0.00 5,800.00 100.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 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 0.00 0.00 1,150.00 100.00 E10 Materials & Supplies 12,925.00 0.00 0.00 12,925.00 100.00 10-541-520030 Dues And Publications 4,000.00 1,231.20 0.00 2,768.80 69.22 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,000.00 0.00 0.00 3,000.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 0.00 0.00 4,000.00 100.00 10-541-522055 Stormwater Compliance 1,500.00 0.00 0.00 1,500.00 100.00 E15 Contractual Services 12,500.00 1,231.20 0.00 11,268.80 90.15 10-541-534010 Telephone 1,000.00 0.00 0.00 1,000.00 100.00 E20 Utilities 1,000.00 0.00 0.00 1,000.00 100.00 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 0.00 0.00 1,000.00 100.00 10-541-546010 Clothing Expense 1,000.00 174.49 0.00 825.51 82.55 10-541-547010 Equipment Maintenance 1,500.00 0.00 0.00 1,500.00 100.00 10-541-547020 Maintenance Agreements 9,400.00 77.37 101.76 9,220.87 98.09 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 12,900.00 251.86 101.76 12,546.38 97.26 10-541-572020 Purchase Of Equipment 18,900.00 0.00 18,140.00 760.00 4.02 E70 Capital Purchases 18,900.00 0.00 18,140.00 760.00 4.02 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 1,012,948.62 56,477.02 18,241.76 938,229.84 92.62 542 Public Works -Street 10-542-501020 Salaries 1,031,248.60 58,441.20 0.00 972,807.40 94.33 10-542-501060 Seasonal Salaries 18,000.00 0.00 0.00 18,000.00 100.00 10-542-501070 Stand-by Plan 4,081.31 272.00 0.00 3,809.31 93.34 10-542-501090 Overtime 20,000.00 356.48 0.00 19,643.52 98.22 10-542-501095 Overtime Straight Pay 2,000.00 0.00 0.00 2,000.00 100.00 10-542-502010 Social Security 82,262.74 4,388.89 0.00 77,873.85 94.66 10-542-502020 Group Health Insurance 171,458.38 9,482.60 0.00 161,975.78 94.47 10-542-502030 Retirement 186,090.06 10,396.31 0.00 175,693.75 94.41 10-542-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502050 Life Insurance 1,743.59 104.62 0.00 1,638.97 94.00 10-542-502060 Long Term Disability 2,854.37 171.14 0.00 2,683.23 94.00 10-542-502070 Employee Assistance Prgm 580.79 0.00 0.00 580.79 100.00 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,520,769.84 83,613.24 0.00 1,437,156.60 94.50 10-542-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-542-511020 Postage 150.00 0.00 0.00 150.00 100.00 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 0.00 0.00 1,600.00 100.00 10-542-514020 Chemicals 225,000.00 62,952.67 -259,971.83 422,019.16 187.56 10-542-514030 Small Tools 9,000.00 0.00 0.00 9,000.00 100.00 10-542-514040 Food 2,000.00 0.00 0.00 2,000.00 100.00 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 275,000.00 417.87 -21,458.33 296,040.46 107.65 10-542-515040 First Aid Supplies 500.00 0.00 0.00 500.00 100.00 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 190.00 0.00 4,810.00 96.20 E10 Materials & Supplies 520,350.00 63,560.54 -281,430.16 738,219.62 141.87 10-542-520030 Dues And Publications 600.00 0.00 0.00 600.00 100.00 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 2,100.00 0.00 0.00 2,100.00 100.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,000.00 645.10 220.00 14,134.90 94.23 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,900.00 705.10 220.00 16,974.90 94.83 10-542-531010 Electricity 30,000.00 76.47 0.00 29,923.53 99.75 10-542-531020 Street Lights 621,000.00 1,055.15 0.00 619,944.85 99.83 10-542-533010 Natural Gas 17,000.00 0.00 0.00 17,000.00 100.00 10-542-534010 Telephone 580.00 12.00 60.00 508.00 87.59 10-542-535010 Water 6,500.00 187.85 0.00 6,312.15 97.11 E20 Utilities 675,080.00 1,331.47 60.00 673,688.53 99.79 10-542-540010 Building & Grounds Maint. 7,000.00 362.32 50.00 6,587.68 94.11 10-542-541030 Vehicle Wash 7,000.00 0.00 0.00 7,000.00 100.00 10-542-542010 Repairs - StopStreet Lights 17,097.00 0.00 0.00 17,097.00 100.00 10-542-542030 Signs & Marking Paint 35,000.00 0.00 0.00 35,000.00 100.00 10-542-546010 Clothing Expense 10,000.00 2,273.75 0.00 7,726.25 77.26 10-542-547010 Equipment Maintenance 3,200.00 0.00 0.00 3,200.00 100.00 10-542-547020 Maintenance Agreements 300.00 0.00 0.00 300.00 100.00 10-542-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 79,697.00 2,636.07 50.00 77,010.93 96.63 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,813,796.84 151,846.42 -281,100.16 2,943,050.58 104.59 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 0.00 0.00 4,000.00 100.00 10-700-590070 Airport Subsidy 196,059.23 0.00 0.00 196,059.23 100.00 10-700-590075 Transit Subsidy 1,095,200.21 0.00 0.00 1,095,200.21 100.00 10-700-590080 Transfer To Amb Sery 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 1,295,259.44 0.00 0.00 1,295,259.44 100.00 700 Transfers & Subsidies 1,295,259.44 0.00 0.00 1,295,259.44 100.00 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 Capvhclegp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhclegp-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 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 0.00 0.00 0.00 0.00 0.00 Expense Expense 29,610,505.10 1,687,120.92 77,714.09 27,845,670.09 94.04 GL - Trial Balance by Acct Type and Full Acct Number (12/08/2014 - 1:11 PM) Page 37 FUND BALANCE CALCULATION FYE 13 Unassigned General Fund Balance $ 4,944,983.00 Per Audited CAFR Supplemental Appropriation $ (50,000.00) Bill 2013-105 Ordinance 15204 - ALPLA Settlement Supplemental Appropriation $ (100,000.00) Bill 2013-133 Ordinance 15231- Replenish Funds Used for Street Chemicals Supplemental Appropriation $ (200,000.00) Bill 2014-17 Ordinance 15272 - Replenish Funds Used for Street Chemicals Supplemental Appropriation $ (14,220.16) Bill 2014-39 Ordinance 15294 - Execute Defense Sharing Agreement with Cole County Supplemental Appropriation $ (25,000.00) Bill 2014-49 Ordinance 15297 - Replenish Funds Used for Street Chemicals Supplemental Appropriation $ (391,800.70) Bill 2014-55 Ordinance 15310 - Repay Promissory Note to Fire Pension Fund Supplemental Appropriation $ (136,138.00) Bill 2014-83 Ordinance 15338 - FTA Grant Lien Payoff on 620 McCarty Street Supplemental Appropriation $ (108,000.00) Bill 2014-87 Ordinance 15342 - To purchase police vehicles Supplemental Appropriation $ (18,900.00) Bill 2014-86 Ordinance 15341- To purchase GIS system for engineering Estimated Fund Balance $ 3,900,924.14 Unreserved Fund Balance Percentage 13.60% Based on original budget of $28,688,000 for FY2014 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7) May -11 6/20/11 91,258.41 38,328.53 51,104.71 Jun -11 7/20/11 101,479.82 42,621.54 56,828.68 Jul -11 8/20/11 88,392.47 37,124.82 49,499.80 Aug -11 9/20/11 73,144.02 30,720.48 40,960.66 Sep -11 10/20/11 103,618.61 43,519.80 58,026.44 Oct -11 11/20/11 105,531.99 44,323.44 59,097.91 Nov -11 12/20/11 66,556.88 27,953.89 37,271.85 Dec -11 1/20/12 52,204.97 21,926.07 29,234.80 Jan -12 2/20/12 65,645.72 27,571.20 36,761.61 566.37 Feb -12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 Mar -12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 (8.11) Apr -12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 (7.25) May -12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 (7.25) Jun -12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 (7.25) Jul -12 8/20/12 89,904.69 37,759.97 50,346.63 Aug -12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 (7.25) 987.59 (7.50) Sep -12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 (7.00) Oct -12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 1,166.54 (7.50) Nov -12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) 1,185.18 (7.33) Dec -12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 (7.35) Jan -13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 (8.28) Feb -13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 (8.28) Mar -13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 (7.37) Apr -13 5/20/13 100,022.48 42,009.44 56,012.59 1,450.30 (8.56) (10,000.00) May -13 6/20/131 97,602.44 1 40,993.02 1 54,657.37 1,570.41 (8.45) (1,187.09) Interest Received 4/2012 Interest Received 5/2012 Interest Received 5/2012 Service Charge 6/2012 Interest Received 6/2012 Service Charge 7/2012 Interest Received 7/2012 Service Charge 8/2012 Interest Received 8/2012 Service Charge 9/2012 Interest Received 9/2012 Service Charge 10/2012 Interest Received 10/2012 Service Charge 11/2012 Interest Received 11/2012 Service Charge 1CCVB 3/7 Check Deposited in Error 12/2012 Interest Received 12/2012 Service Charge Correction of Deposit Error 1/2013 Interest Received 1/2013 Service Charge 2/2013 Interest Received 2/2013 Service Charge 3/2013 Interest Received 3/2013 Service Charge 4/2013 Interest Received 4/2013 Service Charge 5/2013 Interest Received 5/2013 Service Charge 6/2013 Interest Received 6/2013 Service Charge Ck #50 - C H Johnson Consulting 7/2013 Interest Received 7/2013 Service Charge Ck #1001 - C H Johnson Consulting Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7) Jun -13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 (8.45) (33.25) (15,000.00) (10,000.00) Jul -13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 (8.79) (5,000.00) Aug -13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 (8.45) (3,000.00) Sep -13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 (8.45) Oct -13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 (8.28) Nov -13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 (8.28) Dec -13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 (8.28) Jan -14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) 2,078.72 (8.45) Feb -14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 (8.28) Mar -14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 (8.29) Apr -14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 (8.29) May -14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 (8.29) Jun -14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 (8.29) Jul -14 8/20/14 98,901.39 41,538.58 55,384.78 2,459.73 (8.29) Aug -14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 (8.29) Sep -14 10/20/14 112,370.02 47,195.41 62,927.21 2,586.87 (8.29) Total 3,713,166.29 1,559,529.84 2,083,875.31 8/2013 Interest Received 8/2013 Service Charge Ck #1002 - City of Jefferson - RFP Ad Ck #1003 - C H Johnson Consulting Ck #1004 - C H Johnson Consulting 9/2013 Interest Received 9/2013 Service Charge Ck #1005 - C H Johnson Consulting 10/2013 Interest Received 10/2013 Service Charge Ck #1006 - C H Johnson Consulting 11/2013 Interest Received 11/2013 Service Charge 12/2013 Interest Received 12/2013 Service Charge 1/2014 Interest Received 1/2014 Service Charge 2/2014 Interest Received 2/2014 Service Charge Ck #1007 - C H Johnson Consulting 3/2014 Interest Received 3/2014 Service Charge 4/2014 Interest Received 4/2014 Service Charge 5/2014 Interest Received 5/2014 Service Charge 6/2014 Interest Received 6/2014 Service Charge 7/2014 Interest Received 7/2014 Service Charge 8/2014 Interest Received 8/2014 Service Charge 9/2014 Interest Received 9/2014 Service Charge 10/2014 Interest Received 10/2014 Service Charge 11/2014 Interest Received 11/2014 Service Charge average monthly amount for 4 cent lockbox fund $ 50,716.42 January February March April May June July August September October November December COMPARATIVE OCCUPANCY RATE 2014 Occupancy 49.20% 56.00% 59.30% 63.70% 64.70% 63.70% 59.70% 54.20% 61.20% 67.60% 2013 Occupancy 45.30% 52.90% 52.90% 64.10% 56.80% 55.70% 58.50% 55.80% 63.00% 65.90% 52.40% 38.80% 2012 Occupancy 38.20% 49.80% 54.90% 53.90% 53.70% 53.10% 51.40% 47.00% 59.30% 59.30% 43.40% 33.00% Tab 2 - Multi -Segment Missouri Hotel & Lodging Association For the month of: October 2014 Currency: USD - US Dollar Columbia, MO+ Current Month - October 2014 vs October 2013 Year to Date - October 2014 vs October 2013 Participation 5.4 10.1 16.1 23.4 6.3 12.0 Occ % ADR RevPAR Percent Change from October 2013 1 1 Occ % ADR RevPAR 4.5 Percent Change from YTD 2013 7.7 Properties Rooms Springfield, MO 60.5 59.8 78.31 74.08 47.35 44.31 1.1 5.7 Room Room Room 2.8 Branson, MO 53.4 47.1 96.51 89.26 51.55 42.06 13.3 Room Room Room 0.1 13.4 Lake of the Ozarks+ 47.6 48.1 2014 2013 2014 2013 2014 2013 Occ ADR RevPAR Rev Avall Sold 2014 2013 2014 2013 2014 2013 Occ ADR RevPAR Rev Avall Sold Census Sample Census Sample United States 68.0 64.61 118.87 113.60 80.81 73.37 5.3 4.6 10.1 11.2 0.9 6.3 1 66.1 63.8 115.85 110.79 76.62 70.70 3.6 4.6 8.4 9.3 0.8 4.5 53034 30797 4954164 3569907 West North Can Val 65.0 62.71 92.17 89.141 59.93 55.881 3.7 3.4 7.2 9.3 L9 5.71 61.7 59.61 90.94 87.261 56.10 51.991 3.6 4.2 7.9 9.4 1.4 5.01 1 4450 25611 346854 247000 Missouri 11 63.9 60.61 95.00 90.531 60.72 54.831 5.5 4.9 10.7 12.0 1.1 6.71 59.6 56.81 90.75 86.111 54.05 48.911 4.9 5.4 10.5 10.5 -0.0 4.81 1 1130 623 102927 71710 Kansas MO, MO -KS 65.71 16 93.101 718.75 76 St Louis, 700.4 66.5 101.89 98.07 65.25 5.8 3.9 10.0 11.3 10.2 7.1 66.5 63.7 97.09 91.26 64.61 58.17 4.4 6.4 11.1 10.9 -0.2 4.2 330 2311 38261 36526 Columbia, MO+ 63.6 60.3 94.62 85.90 60.14 51.81 5.4 10.1 16.1 23.4 6.3 12.0 Jefferson City, MO+ 67.6 65.5 79.50 76.11 53.71 49.88 3.1 4.5 7.7 7.7 0.0 3.1 Springfield, MO 60.5 59.8 78.31 74.08 47.35 44.31 1.1 5.7 6.9 8.7 1.8 2.8 Branson, MO 53.4 47.1 96.51 89.26 51.55 42.06 13.3 8.1 22.6 22.6 0.1 13.4 Lake of the Ozarks+ 47.6 48.1 90.37 90.50 43.03 43.53 -1.0 -0.1 -1.1 -1.1 0.0 -1.0 Joplin, MO 60.9 58.0 70.98 67.74 43.23 39.28 5.0 4.8 10.1 10.1 0.0 5.0 59.1 60.0 83.72 77.17 49.45 46.32 -1.6 8.5 6.8 11.1 4.1 2.4 59.9 57.1 74.85 69.34 44.85 39.59 5.0 7.9 13.3 14.3 0.9 5.9 58.0 54.7 76.53 72.70 44.39 39.75 6.1 5.3 11.7 8.6 -2.7 3.2 44.9 40.1 94.88 89.80 42.63 36.04 11.9 5.7 18.3 16.6 -1.4 10.3 47.9 47.4 98.21 96.24 47.06 45.63 1.1 2.0 3.1 3.5 0.3 1.4 59.8 54.6 71.25 69.16 42.60 37.73 9.6 3.0 12.9 12.9 0.0 9.6 38 29 3886 3253 15 11 1494 1063 67 45 6105 4421 154 35 14112 5001 38 10 2807 1433 34 24 2713 2275 A blank row indicates insufficient data. Source 2014 STR, Inc. DISCLOSURE Destination Reports are publications of STR, Inc. (Reports containing only North American data) and STR Global Ltd (Reports containing worldwide data) and are intended solely for use by our paid subscribers. Reproduction or distribution of Destination Reports, in whole or part, without written permission of either STR, Inc. or STR Global Ltd. is prohibited and subject to legal action. Site licenses are available. Please consult your contract with STR, Inc. or STR Global, Ltd for the terms and conditions governing the ownership, distribution and use of Destination Reports and their contents. Memo To: Finance Committee From: Steven S. Crowell, Jr.; City Date: December 1, 2014 RE: Streetlight Budget Adjustment Attached you will find an explanation from Matt Morasch, Director of Public Works, regarding a year-end budget adjustment to the streetlight budget. Mr. Morasch was able to make some adjustments within the budgeted line items to partially address the streetlight budget overage. Mr. Morasch, along with the Director of Finance and Information Technology, Bill Betts, and I recommend that the remaining amount of approximately $94,313.57 come from a FY2014 budgeted amount of approximately $100,000 which was related to the Columbia Regional Airport. Obviously, an alternative would be to make a supplemental appropriation from the General Fund fund balance to offset this expenditure. Mr. Morasch has indicated, that at this point, we think the amount budgeted for streetlights in the FY2015 are sufficient. I would also acknowledge that I made a proposal to have an audit conducted of various utilities, one of which would be for our streetlight payments. I think this is an expenditure the City Administrator can authorize; however, I did want to inform the committee of the proposed expenditure. Since we are in the process of closing out our year- end records, time is of the essence. Unless the Finance Committee wants to have staff pursue another method of covering the expenditure, I will authorize the expenditure as referenced above and advise the City Council accordingly. Attachment Department of Public Works Memorandum 320 East McCarty Street . Jefferson City, Missouri 65101 . P: 573.634.6410 . F: 573.634.6562 . www.jeffcitymo.org Date: November 25, 2014 i To: Steven Crowell, City Administrator i From: Matt Morasch, P. E., Public Works Director I J C'� Subject: FY2014 Street Light Budget Adjustment The street light line item within the Public Works Street Division budget requires a total budget adjustment of approximately $130,000 to account for increased expenses incurred in street lighting during this last fiscal year (FY 2014). The vast majority of the expenses within that line item are for "per light" charges by Ameren to supply and maintain non -metered street lights installed on poles owned by the utility company. The budget overrun was primarily a result of two events. First Ameren enacted a rate increase, on the "per light" charges for street lights, resulting in a cost increase of approximately 18%. This increase was not accounted for when the FY2014 budget was proposed and passed. Secondly, during FY2014 it was noted that the bill for services for the street light accounts were billed approximately 1 month in arears meaning that at the beginning of FY2014 one month of service from FY2013 was expensed in FY2014. This resulted in 13 months of services being billed to the account as opposed to the normal 12 month. During the development of FY2015 budget the above issues were noted and it appears that the new budget (FY 2015) will cover the expenses for the account. In addition, staff has developed a spreadsheet model to track the monthly charges and the budget performance. This should allow us to note any unusual changes in monthly usage very quickly as well as help us develop future budgets for this line item. Questions on this issue can be directed to Britt Smith or myself. Thanks. CC'. Bill Betts Britt E. Smith, P.E. C:\Users\mmoraseh.J CMO\Desktop\Street Light Overage.docx CITY OF JEFFERSON BUDGET ADJUSTMENT FORM City Hall % 320 E. McCarty Street FY 2014 BUDGET ADJUSTMENT Jefferson City, MO 65101 FROM ACCOUNT # TO ACCOUNT # TOTAL AMOUNT DESCRIPTION OF TRANSFER 10-185-522020 Prof Svcs 10-542-531020 Street Lights $ 94,313.57 to cover deficit balance in street lights Dept Director Approval I ry Date Entered By Date Memo To: Finance Committee From: Steven S. Crowell, Jr., City Admini Date: November 25, 2014 RE: Audit of Utility Payments RECOMMENDATION: Staff is requesting authorization to proceed with soliciting Requests for Proposals (RFP) from firms qualified to perform audits of the following: electric bills paid by the City; street light bills paid by the City; franchise fees (excluding cell phone companies) paid to the City; and telecom fees (excluding cell phone companies) paid by the City (in the course of the RFP and/or after acceptance, there may be other utility revenue streams identified which also may be appropriate to review. DISCUSSION: The audits of the areas noted above are an attempt to review (and collect overpayment as warranted) revenues owed to, or paid by, the City. The analysis is NOT AN ENERGY NEEDS/USAGE audit. In addition to the areas of interest noted above, typically firms also audit hotel lodging tax payments. I am not recommending conducting hotel lodging tax audits since we conduct such audits internally. I am also not recommending an audit of cell phone companies since the City recently audited several cell phone companies. I am also not recommending that we review cable television franchise(s) at this time. Typically, firms providing the referenced utility audit services are paid a fixed fee; paid on an hourly basis; or paid by contingency fee. If paid by contingency fee, there are typically two methods which occur: 1. The firm charges a percentage of the savings identified in the first year (and no fees thereafter); or 2. The firm charges a percentage of savings for the first year and percentage of savings for future years (approximately 2-5 years). Typically, contingency fees range from 35-50% depending on the size of the audit and other circumstances. Firms getting paid on a contingency fee are only paid after the City receives a check for any (utility) overpayment, if any. If the firm does not identify any savings, (i.e., the City does not receive a refund payment), then the firm conducting the audit does not receive payment from the City. I prefer the contingency percentage amount, paid for the first year, instead of a contingency fee to include future years, but again, it can be dependent upon the firm responding to the Request for Proposal. Typically, such utility reviews can take from eight to 12 months to complete depending upon the firm. It is difficult to estimate any potential revenue resulting from the audit. One firm with which I am familiar is TriStem (www.tristem.com), but there are other firms which provide a similar service. I have attached some information from TriStem. I do think familiarity with Missouri utility companies would be helpful. The RFP process would identify the firm most appropriate for the City to consider. Advantages of conducting a utility audit as referenced above include: 1. Identification of potential added revenues to the City, with future year savings identified. 2. No out-of-pocket costs to the City. 3. Correcting any billing discrepancies will provide a basis for determining savings related to any future energy/needs assessments. Disadvantages of conducting a utility audit as referenced above include: 1. Audited companies (Ameren, Missouri American Water, etc.) might not like having their bills reviewed and potentially having to provide a refund payment. 2. The process does require some staff time to provide information to the company conducting the audit. 3. The auditing firm may not be able to identify savings (in which case there is no cost to the City). I have advised the applicable companies of our interest in conducting the referenced audits, subject to Committee and City Council review and approval. Attachments RI TE Utility Audit Services Presented by: doe Seeber Owner & Founding Partner TriStem, Ltd. 1� m tility Bill Audits ELECTRIC • STREET LIGHT • GAS WATER/SEWER • TELEPHONE FRANCHISE FEES T STE i� the nation's premier R 1M utility audit firm Serving commercial utility consumers for 35 years Core focus is recovering funds for municipalities and reducing future expenses for electric, street lighting, natural gas, water, and telecom accounts Recovered $30+ million in funds for municipal clients nationwide All consumers have benefitted by hundreds of millions of dollars as a result of TriStem audits and our work as consumer advocates. Is your organization looking for ways to.. . REDUCE EXPENDITURES? BOOST REVENUE? A TriStem X11 EASE BUDGET CONSTRAINTS? ENSURE THAT IT HASN'T OVERPAID FOR VITAL SERVICES? Utility Audit can da •,# the abr�ve! TriStem's Services Include Audits of: - Electricity & Streetl ig hti ng Accounts - Natural Gas Accounts - Telecommunications Accounts (local,, long distance &cell) - Water & Sewer Accounts (if paid to an outside entity) - Franchise Revenue from Local Utilities Core Objectives of a TriStem Audit TriStem strives to accomplish the following objectives for each of its clients: 1. Save your organization's valuable time by conducting a comprehensive audit on your behalf; i. Enhance your organization's revenue by securing refunds of overbilled utility services; 3. Reduce future expenses by correcting ongoing errors and implementing savings opportunities; 4. Educate your organization on utility billing practices and regulations applicable to your specific region and business, providing your staff with knowledge to identify future billing errors and savings opportunities after our audit has been completed. TriStem values the importance of customer service, and will tailor our audit to address specific concerns or needs of each client, What Will TriStem Do For Your Organization? 1 . Analyze your paid utility invoices to determine if errors exist; 2. Communicate with your providers to obtain confirmation of errors and overcharges; 3. Negotiate with your utility providers to obtain the maximum refund due to the City, and facilitate corrections so that future bills are accurate. EXam,nle5 of What We Look Fora Meter read errors ®:• Charges not in compliance with tariff/contract terms ❖ Charges for services not ,being used ❖ Streetlight features ,billed incorrectly quipment malfunctions What Will TriStem's Services Coit? TriStem's service is self - funding and RISK FREE — if you don't receive actual funds from your utility providers as a result of our service, you owe us nothing. TriStem's only fee is 49% of actual funds secured for prior errors. Any savings that occur in the future as a result of our service are 100% yours to keep, "Try as we might, sir, our team of mana�gment consultants has been unable to find a .Tingle fault in the manner in which you conduct your business. 1•:verything you do is a hundred per rent right_ Keep it up! That will be eleven thousand dollars. " Why Should You Choose TriStem? TriStem has been working as an advocate for commercial utility consumers across the U.S. for 35 years — no other company can match our experience and expertise. Our competition comes to us for our streetlight audit expertise — TriStem's innovative audit process has resulted in tens of millions of dollars in recovered funds for governmental utility consumers across the country, and many millions more in reduced costs. TriStem has completed successful audits for other local munici al consumers: the cities of Gladstone, Kansas City (Aviation Dept, Olathe and St. Louis, as well as the Missouri Department of Transportation and Overland Park, KS. TriStem's core focus is utility audits for governmental consumers. We've completed successful audits for thousands of school districts, cities, counties and state agencies across the nation. Our familiarity with the infrastructure of political subdivisions allows us to focus on refund and savings opportunities our competitors may not be aware of. Questions / Comments? Thank you for considering TriStem to be of service to your organization!