Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
20141113 finance packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, November 13, 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 September 11, 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. Review of CVB Budget – Diane Gillespie 7. New Business 8. Old Business 9. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, September 11, 2014 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Bray at 7:33 am. Roll call showed that Councilmen Bray, Graham, Scrivner, Mihalevich and Prather were in attendance. Next the minutes of the August 14, 2014 meeting were reviewed. A motion to approve was made by Councilman Scrivner and seconded by Councilman Graham. The minutes were approved unanimously. 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 Chief Accountant, Shiela Pearre, 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 $1,970,794. The average monthly amount collected for the 4 Cent Lockbox Fund is $50,613. 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 Financial Policies. Mr. Betts addressed the key issues within the policies, focusing on the fund balance policy. A motion to move the Financial Policies to the full Council for approval was made by Councilman Scrivner and seconded by Councilman Prather. The motion was approved unanimously. The next item on the agenda was a discussion of the City Administrator purchasing authority process, led by City Counselor, Drew Hilpert. An ordinance was proposed by staff seeking to change City Code. A motion to move the proposed ordinance to full Council for approval was made by Councilman Mihalevich and seconded by Councilman Prather. The motion was approved unanimously. The next item on the agenda was a discussion, led by Mr. Betts, of the Socket Contract Agreement which is offering bandwidth as compensation for the use of the City’s conduit. A motion to move the contract to full Council for approval was made by Councilman Scrivner and seconded by Councilman Graham. The motion was approved unanimously. There was no old business to discuss. There was no new business to discuss. A motion to adjourn was made 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 October 31, 2014 Data as of 11-04-14 for period ending 10-31-14 Description Sales Tax and Use Tax Intergovernmental Taxes Other Taxes Franchise & Utility Tax Property Taxes Intergovernmental Charges for Services Fees, Licenses, & Permits Fines & Forfeitures Contributions/Donations Other Operating Revenues Interest Income Other Non Operating Revenue Operating Transfers In Totals CFY 2014 Budget $ 9,640,000.00 $ 2,080,000.00 $ 120 000.00 $ 7,040,000.00 $ 5,209,000.00 $ 6,610.00 $ 2,082,965.63 $ 713,600.00 $ 1,009,980.00 $ 167,699.12 $ 102,241.76 $ 65,000.00 $ 20,000.00 $ 21,940.00 $ 28,279,036.51 **Includes November 2014 actual sales tax receipts amount NOTES for November Finance Meeting: YTD Actual Projected Over/ As of 10-31-14 (Under) Budget $ 9,086,852 .60 ** $ $ 1,895,540.73 $ $ 111549.58 $ $ 7,185,266.13 $ $ 5,190,117.72 $ $ 66,778.95 $ 60,168.95 $ 2,177,211.32 $ 94,245.69 $ 832,546 .9 6 $ 118,952.96 $ 996,133.88 $ (13,215.93) $ 205,228.98 $ 37,529.86 $ 205,335.77 $ 103,094.01 $ 102,157.02 $ 37,686.15 $ 27,384.16 $ 7,384.16 $ 23,121.88 $ 1,181.88 $ 28,105,225 .68 $ 1,463,860.41 Revenue Model Report (Detail) For Period Ending October 31, 2014 Description Sales Tax and Use Tax 10-100-400010 10-100-400020 Sa les Ta x (I nc. Ma rc h Actua l) Sales Ta x In terest Intergovernmental Taxes 10-100-401030 10-100-403010 10-100-430080 Other Taxes Motor Vehicle Sales Tax Gasoline Tax Road & Bridge Tax Cig Tax Franchise & Utility Tax 10-100-410020 Electric Utility Lie Tax 10-100-410030 Ga s Utility License Tax 10-100-410052 10-100-410053 10-100-410060 10-100-410061 Property Taxes 10 -100-420010 10-100-420020 10-100-420040 10-100-420050 10-100-420055 10-100-420060 10-100-420080 Telephone Cell w/o audit money Telecom Audit Cable Franchise Fee Cable Utility Audit Current Property Ta x Del Property Ta x Fin Institution Tax Prop Ta x lnt & Pena lti es Surtax Receipts-County Reimb Surta x Rece ipts Special Tax Rev Intergovernmental 10-100-430010 Federal Grant 10-100-430100 10-100-480020 10-100-480025 State DNR Historic Pres NSP Rehab Sales HUD Program Income Charges for Services 10-100-440010 Admin Charge Backs ~0-100-440050 Emt Reimbursement il.0-100-440210 Street Cuts 10-100-440910 Fuel Charge -backs ~0-100-440920 Parts Charge backs 10-100-440930 Labor Charge backs 10-100-450189 10-100-481020 10-100-481030 10-100-481040 10-100-481045 Animal Shelter Bricks Cole Cty Animal Rescue Rent City Hall/annex Rent Other Rent -towe r Sites Start Month R/1 2 2 2 0 1 1 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 $ Budget 9,640,000.00 0.00 9,640,000 .00 430,000.00 1 '1 00,000.00 550,000.00 2,080,000 .00 120,000.00 120 000.00 3,220,000.00 925,000.00 2,450,000 .00 110,000.00 335,000.00 7,040,000.00 4,600,000.00 40,000.00 10,000.00 20,000.00 54,000.00 470,000.00 15,000.00 5,209,000 .00 0.00 o.oo o.oo 6.610.00 6,610.00 1,225,559.00 0.00 25,000.00 o.oo 91,600.00 137,400.00 0.00 100,000.00 6,500.00 12,000.00 80 000.00 Remaining Initial Estimated Revenue YTD Actual Estimated Revenues Asof10-31-14 10/31/2014 9 ,64 0,000.00 9,086,852.60 0.00 9,086,852.60 450,469.49 1 ,095,781 .10 550,000.00 131,715.76 3,422,802.04 908,060.23 2,383,173.00 337,942 .30 427,261.79 917,747.28 550,531.66 1,895,540. 73 111,549.58 111549.58 3,434,822.60 1,044,735.82 2,028,849 .54 281,121.98 391,736.19 916,473.14 0.00 9 16,473.14 76 ,444.92 185,583 .89 0.00 262 ,028.81 10.000.00 10 000.00 212,608.84 43,134.46 190,000.00 0.00 o.oo $ 4,000.00 ;,;_$ _____ _ 4,570,217.73 64 ,812.15 16,519.75 29,246.15 54,399 .28 471,744.89 27,359.89 6,610.00 1,225,559.00 25,411.50 84,442.07 124,065.41 100,000.00 6,500.00 12,000.00 80 000.00 7,185,266.13 4,514,123.36 54,847.13 41,534.94 28,731.44 54,399.28 472,315.78 24,165.79 5,190,117 .72 0.00 0.00 56,168.95 10,610.00 66,778.95 1,225,559 .00 0.00 28,588.00 16,334.18 161,512.63 150,003.29 900.00 100,000.00 6,500.00 12,000.00 97 857.50 445,743.30 0.00 0.00 0.00 0.00 0.00 0.00 2,260.68 2,260.68 0.00 0.00 0.00 0.00 0.00 o.oo 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 $ Actual & Estimated TOTAL Projected Over/ Verification (Under) Budget of Formulas 10,003,325.74 0.00 10,003,325.74 503 ,706.71 1,103,331.17 550.531.66 2,157,569.54 121,549.58 121549.58 363,325 .74 0.00 363,325 .74 73 ,7 06.70 3,331.17 531 .66 77,569.54 1.549 .58 1549.58 3,647,431.44 427,431.44 1,087,870.2 8 162,870.28 2,218,849.54 (231,150.46) 281,121.98 171,121 .98 391,736.19 56,736.19 4,ooo.oo "-$ ----"4,~oo:..:o;;..;.o"'o 7,631,009.43 591,009.43 4,514,123.36 54,847.13 41,534.94 28,731.44 54,399.28 472,315.78 26.426.47 5,192,378.40 0.00 0.00 56,168.95 10,610.00 66,778.95 1,225,559.00 0.00 28,588.00 16,334.18 161,512.63 150,003.29 900.00 100,000.00 6,500.00 12,000.00 97 857.50 (85,876.64) 14,847.13 31,534.94 8,731.44 399.28 2,315 .78 11,426.47 ( 16,621.60) 0.00 0.00 56,168.95 4,000.00 60,168.95 o.oo 0.00 3,588.00 16,334.18 69,912.63 12,603.29 900.00 0.00 o.oo o.oo 17 857.50 363,325.74 l1..I!Q 363,325.74 73 ,706.70 3,33 1.17 531.66 77,569.54 1,549.58 1,549.58 427,431.44 162,870.28 1231,150.46) 171,121.98 56,736.19 4,000.00 S91,009.43 (85 ,876.64) 14,847.13 31,534.94 8,731.44 399.28 2,31S.78 11.426.47 (16,621.60) 0.00 0.00 56,168.95 4.000.00 60,168.95 0.00 0.00 3,588.00 16,334.18 69,912.63 12,603.29 900.00 0.00 0.00 0.00 17,857.50 Revenue Model Report (Detail) For Period Ending October 31, 2014 Description 10-100-481075 10-100-481080 10-100-481085 10-100-481090 10-100-481100 10-100-481110 Cole Cty 911 Reimb Sale Of Maps/gis Data Col e Cty Gis Joint Coop Cole Cty Sheriff-New World Sale Of Grave Sites Long & Short Start Month 0 0 0 0 0 0 Remaining YTD Actual Estimated Revenues Actual & Estimated Initial Estimated Revenue Budget Asof10-31-14 10/31/2014 T OTAL 358,228 .63 358,228 .63 358,739 .86 o.oo 358,739 .86 Projected Over / Verification (Und er ) Budge t of Formu las 511.23 Sll.23 0.00 0.00 150.00 0.00 150.00 150.00 1SO.OO 15 ,00 0.00 15,000.00 15,000.00 0.00 15 ,00 0.00 0.00 0.00 28 ,678.00 0.00 o.oo 0.00 o.oo (28,678.00) (28,678 .00 3,000.00 3,000.00 4,000.00 0.00 4,000.00 1,000.00 1,000.00 0.00 0.00 66 .86 0.00 66 .86 66.86 ~ ·~------------------------~2~,0~8~2 ~,9~6~5 .~63~------------------~2~,1~7~7~,2~1~1 .~3 ~2 ------------~0 .~0 ~0 ________ ~2~,1~7~7~,2~1~1~.3~2 _______ 9~4~,2~4~5 .~6~9 -------~~2-4S •. 6_.9 Fees, Licenses, & Permits 10-100-450010 Li quor Licenses 10-100-450020 10-100-450021 10-100-450030 10-100-4500 40 10 -100-450041 10-100-450045 10-100 -450050 10-100-450060 10-10 0 -450070 10-100-450080 10-100-450090 10-100-450091 10-100-450092 10 -100-450100 10-100-450110 10 -100 -450120 10-100-450130 10-100-450150 10 -100-450160 10-1 00 -45 0170 10-100-450180 10-100-450185 10-100-450186 10-100-450190 10-100-450230 10-100-450250 10-100-450260 Business Lice nses Home Occup ation Permit Soli citors Lie Abandoned Bld g. Reg Abandoned Bl dg. Admin Fee Bldg . Con str Fee s Electrica l Certi ficat es Electrica l Permits Plumbing Li censes Plumbing Pe rmits Other Lie & Pe rm its Da y Care Inspection Fees Food In s pection Fees Curb Cut Permits Boa rd Of Adj Fees Sign Perm it s Demoliti on Permits Ace Rep Fees-police Accrpt /blast g P-fire An imal Redemption Fe e s Animal Vac cinations Fe e s Anima l Cremation Fees Anima l Boarding Fees Ta xi Permits Vacating Right Of Way Rezoning Request Non-refundable Plans/spec Fines & Forfeitures 10-100-460010 10-100-460015 10-100-460018 10-100-460020 10-100-460025 10-100-460030 10-100-460040 10-100-460050 10-100-460060 Co u rt Cost Court Restitutions Inm ate Secu rity Fund Ja il Cost Recovery Alcohol Offense Cost Rec Pol Fines-traffic Pol Tickets-parki ng Pol fines-Ot her Dog Fines 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 65,000 .00 205 ,000.00 1,500 .00 0.00 0.00 0.00 200,000.00 16 ,000.00 2,5 00.00 10,000 .00 5,000 .00 1,500.00 8,000.0 0 88,000 .00 1,500.00 1,200.00 4,000 .00 500.00 12,000 .00 500.00 53,000.00 4,500.00 20,000 .00 0 .00 500.00 400.00 10,000.00 3,000.00 713,600.00 80,000.00 1,300.00 12,080.00 10,000.00 10,000.00 850,000.00 1,000.00 0 .00 0 .00 64,405.00 216,000 .00 1,666.00 129,807.55 16,3 98 .00 4,592 .37 10,384.0 0 5,937 .50 2,597 .19 8,515.00 86,739 .25 1,518.00 5,240.00 916 .00 12,387.67 793 .50 52,360.00 5,140.00 23 ,665.00 0 .00 500.00 315.00 11,651.00 2, 727.25 82,550.20 1,986.90 13,15 5 .29 11,661.0 7 9,810.00 8 36,162.54 66 ,296.00 215,754.21 1,560.00 0.00 22 0.00 7,86 4.17 279 ,972.77 19,085.00 3,654.8 1 11,43 4.00 4,93 7.2 5 3,696 .78 7,890.00 88,125 .07 728 .00 1,85 4.00 4,105 .00 988 .00 11,286.90 609 .00 56,465 .00 5 ,030.00 25,540.00 0.00 575 .00 780.00 1 2,255 .00 1 ,841.00 832,546.96 75,542.66 1,863.30 12,469.04 8,196.05 7,705 .00 844,869.08 0.00 0 .00 0 .00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0 .00 0.00 0.00 0 .00 0.00 0 .00 0 .00 0 .00 0 .00 6.00 0 .00 0 .00 0 .00 0.00 0 .00 0 .00 0.00 0 .00 6 .00 0 .00 630 .19 0.00 0 .00 0 .00 0 .00 0.00 0 .00 0.00 66 ,296 .00 215 ,7 54.21 1,560.00 0.00 220.00 7,864.17 279 ,972.77 19 ,085.00 3,65 4.8 1 11,434.00 4,93 7.25 3,69 6.78 7,890 .00 88,125.07 728.00 1,85 4.00 4,105 .00 988.00 11,286.90 615 .00 56,465.00 5,030.00 25 ,540.00 0.00 575.00 780.00 12,255 .00 1,841.00 832,552.96 75,542.66 2,493.49 12,469.04 8,196.05 7,705 .00 844,869.08 0 .00 0.00 0.00 1,296 .00 10,754 .21 60.00 0.00 220.00 7,864.1 7 79 ,972.77 3,085 .00 1,154 .81 1,4 34 .00 (62 .75) 2,196.78 (110.00) 125.07 (772.00) 654.00 105.00 488.00 (713 .10) 115.00 3,465 .00 530.00 5,540.00 0 .00 75 .00 380.00 2,255 .00 (1,159.00) 118,952.96 (4,457.34) 1,193.49 389.04 (1,80 3.95) (2,2 95.00) (5,130.92 ) (1,000 .00) 0 .00 0 .00 1,296 .00 10,7S4.21 60.00 0.00 220.00 7,864 .17 79,972.77 3,08S .OO 1,1S4 .81 1,434 .00 (62.7 SI 2,196.78 (110.00) 12S.07 (772.00) 6S4 .00 10S .OO 488 .00 {713.10) 11S .OO 3,4 6S.OO S30.00 S,S40 .00 0.00 7S .OO 380.00 2,2S S.OO ~ 118,9S2.96 (4,4S7.3 4) 1,193.49 389.04 (1,803 .9S) (2,29 S.OO) (5 ,130.92) (1 ,000.00) 0.00 0.00 Revenue Model Report (Detail) For Period Ending October 31,2014 10-100-460070 10-100-460090 10-100-460100 Description P & Code Violations Parking Fines Bankcard Charges Contri6utions7Donations 10 -100-430055 10-100-480010 10-1 00-480015 10-100-480030 10-100-480050 10-100-480055 10-100-480063 10-100-480065 10-100-480070 0-100-480080 0-100-480090 10-100-480165 10-100-481050 10-100-481055 10-100-48 1095 10-100-486070 10-100-470010 10-100-470051 DARE Con t ri Citizen Parti cipation Sidewalk Waive r Revenue Donations-Recycling Sober Driver Program JC Fire Museum Private Donations-Cultura l Art Cul t ura l Art s Community Project s Do nat ions Dare Don ation s Police K-9 Donations Anim a lS Dona t io n s Transfe r Stn/Pi ng-Sid Wst Cntr Street Re pair-S ol id Waste Cn t r Ce me t e ry Donations Cap Con t r-ne ighorhood Imp Pro Specia l Sn Program Adopt ion Vo uch er Progra m Police Ev idence Fu nds Miscellaneous TIF Prof Svcs Deposit Insurance Cla ims Cafeteria Refunds Interest Unrealized Gains and Losses Other Non Operating Revenue Start Month 0 0 0 Budget Initial Estimated Revenue Remaining YTD Actual Estimated Revenues As of 10-31-14 10/31/2014 0.00 0.00 0 .00 58,600.00 41 ,650.35 62,668.59 0 .00 (13,000 .00) (13 ,843.12) (17 ,179 .84) 0.00 ___ .....:1,_oo_9.;..,9_8_o._oo __________ 9_9...;6,_13_3_.8_8 630.19 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 .00 0.00 0.00 0.00 6,040.00 9,884.50 0 .00 0.00 750 .00 500 .00 500.00 40,024.62 0 .00 110,000.00 0 .00 0.00 167,699.12 0 .00 0.00 0 .00 24,000 .00 0 .00 78,241.76 0.00 102,241.76 65 ,000 .00 0.00 65 ,000 .00 27 ,535.59 12,098.45 65 ,000.00 0 .00 711 .93 0.00 0.00 3,360.00 11,884.50 0 .00 1,280.00 750.00 500.00 500.00 52,850.92 0.00 133,2 28.83 0.00 162.80 205 ,228.98 0.00 0.00 75,069 .65 51,070 .31 0 .00 60,746.11 18,449 .70 205,335 .77 102,157.02 0 .00 102,157.02 0.00 0.00 0.00 0.00 0.00 0.00 0 .00 0.00 0.00 0 .00 0.00 0 .00 0.00 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 0 .00 0.00 0.00 0 .00 0.00 529.13 0 .00 529.13 10-100-485049 Cap Vhcl Equip sal;-e-o-;-f -as-s-e""'ts--~o~-----o;;:0'-.:;.00::::--~---------~0~.~00;;----0 .00 0.00 0 .00 10-100-485050 Sa le Of Assets 0 20,000.00 20,000 .00 27,384.16 Operating Transfers In 10-100-490193 Trsfer From Grant Fund 10-100-490240 Trsfr From Lodging Tax 10-100-490260 10-100-490280 10-100-490353 10-100-490600 Trsfr from Fireman's Spec Rev Trnf from Stoneridge TDD Transfer From Cit "e" Transfer from Water Fund 0 0 0 0 0 0 20,000 .00 27,38;..;.4;.;;.1~6 --~- 0.00 21,940.00 0.00 0.00 0.00 0 .00 19,930 .23 0.00 23,121.88 0.00 0 .00 0.00 0.00 0.00 0 .00 0.00 0.00 0.00 0.00 Actual & Estimated TOTAL 0.00 62,668.59 (17,179 .84) 996,764.07 0 .00 711 .93 0.00 0 .00 3,360.00 11,884.50 0 .00 1,280.00 750.00 500.00 500.00 52,850.92 0 .00 133 ,22 8.83 0.00 162.80 205 ,228.98 0 .00 0 .00 75,069.65 51,070.31 0 .00 60,746 .11 18,449.70 205 335.77 102,686 .15 0.00 102,686.15 0 .00 27 ,384.16 27,384.16 0.00 23,121.88 0.00 0 .00 0.00 0 .00 Projected Over/ Verification (Under) Budget of Formulas 0.00 0.00 4,068.59 4,068.59 (4 ,179 .84 ) 14 .179.84) (13,215.93.:..) ____ 11-3,-215_._93) 0.00 711.93 0.00 0.00 (2,680.00 ) 2,000.00 0.00 1,280.00 0.00 0.00 0.00 12,826.30 0.00 23 ,228.83 0.00 162.80 37,529 .86 0.00 0.00 75 ,069 .65 27,070 .31 0.00 (17,495.65 ) 18,449.70 103,094.01 37,686.15 0.00 37,686.15 0.00 0.00 711.93 0.00 0.00 (2,680.00) 2,000.00 0.00 1,280.00 0.00 0.00 0.00 12,826.30 0.00 23 ,228.83 0.00 ill!!! 37,529.86 0.00 0.00 75,069.65 27,070.31 0.00 (17,495 6S 18.449.70 103,094.01 37,686.15 .!!&Q 37,686.15 7,384.16 1,384.16 7,384.16 ----'7"',3.;;.84;.;.;.1;.;6 0.00 1,181 .88 0.00 0.00 0.00 0.00 0.00 1,181.88 0.00 0.00 0.00 0.00 Revenue Model Report (Detail) For Period Ending October 31,2014 Description 10-100-490620 Transfer from Parking Fund Start Month 0 Budget 0.00 21,940.00 28,279,036.51 Initial Estimated YTD Actual Revenue As ofl0-31-14 0.00 23,121.88 28,105,225.68 Remaining Estimated Revenues Actual & Estimated Projected Over/ Verification 10/31/2014 TOTAL (Under) Budget of Formulas 0.00 0.00 0.00 Q&Q 0.00 23 ,121.88 1,181.88 1.181.88 1,637,671 .24 29,742,896.92 1,463,860.41 1,463,860.41 Memo To:Steve Crowell From:Shiela Pearre Date:November 7, 2014 Re:Sales Tax Revenues The City received the November 1% Sales Tax in the amount of $651,079.96 which is $26,286 less than projected for November. January thru November overage is $363,325 (3.77%) in the General Fund. 1% General Sales Tax Receipt Budget Actual 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 Total Overage/Shortfall $363,325 1/2% Capital Improvement Tax Receipt Budget Actual 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 Total Overage/Shortfall $192,776 1/2% Parks Sales Tax Receipt Budget Actual 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 Total Overage/Shortfall $169,832 Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 11/7/2014 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: NOVEMBER 2014 Account Number 10-100-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 787,676 928,460 809,385 843,061 764,659 741,056 act.826,648 Dec February 572,813 631,137 833,919 619,287 703,181 789,830 act.672,067 Jan & Oct-Dec Qtrly March 1,079,246 894,158 589,958 992,559 1,008,111 920,599 act.912,806 Feb April 763,906 774,964 978,391 852,653 777,424 737,482 act.829,468 Mar May 516,016 592,657 633,676 530,069 537,141 802,765 act.561,912 Apr & Jan-Mar Qtrly June 934,660 843,712 925,555 1,028,514 1,023,015 865,930 act.951,091 May July 686,153 939,495 955,495 797,785 872,436 1,048,754 act.850,273 Jun August 526,097 495,667 566,299 557,032 546,351 614,048 act.538,289 Jul & Apr-Jun Qtrly September 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 996,272 act.1,048,906 Aug October 718,480 822,163 797,510 769,129 717,262 919,035 act.764,909 Sept November 554,824 482,807 536,185 615,421 677,366 651,080 act.573,321 Oct & Jul-Sept Qtrly December 801,780 881,780 1,032,046 982,684 932,387 916,473 est.926,135 Actual to Date $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 9,086,853 Estimated to Fiscal Year end (based on averages and on Budgeted amount)916,473 Total Actual & Estimated $ 10,003,326 Less: Budget 9,640,000 Over (Under) Budget $ 363,326 $ 741,056.45 $ 1,530,886.91 $ 2,451,485.95 $ 3,188,968.08 $ 3,991,732.73 $ 4,857,663.18 $ 5,906,417.41 $ 6,520,465.33 $ 7,516,737.40 $ 8,435,772.83 $ 9,086,852.79 $ 764,659.19 $1,467,840.39 $2,475,951.79 $3,253,375.33 $3,790,516.42 $4,813,531.75 $5,685,967.41 $6,232,318.77 $7,328,899.63 $8,046,161.24 $8,723,526.86 $9,640,000.00 $ 500,000.00 $ 750,000.00 $ 1,000,000.00 $ 1,250,000.00 $ 1,500,000.00 $ 1,750,000.00 $ 2,000,000.00 $ 2,250,000.00 $ 2,500,000.00 $ 2,750,000.00 $ 3,000,000.00 $ 3,250,000.00 $ 3,500,000.00 $ 3,750,000.00 $ 4,000,000.00 $ 4,250,000.00 $ 4,500,000.00 $ 4,750,000.00 $ 5,000,000.00 $ 5,250,000.00 $ 5,500,000.00 $ 5,750,000.00 $ 6,000,000.00 $ 6,250,000.00 $ 6,500,000.00 $ 6,750,000.00 $ 7,000,000.00 $ 7,250,000.00 $ 7,500,000.00 $ 7,750,000.00 $ 8,000,000.00 $ 8,250,000.00 $ 8,500,000.00 $ 8,750,000.00 $ 9,000,000.00 $ 9,250,000.00 $ 9,500,000.00 $ 9,750,000.00 $ 10,000,000.00 $ 10,250,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/7/2014 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: NOVEMBER 2014 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,327 455,480 396,799 412,434 372,459 359,800 act.404,300 Dec February 286,909 313,836 407,407 308,567 350,813 394,475 act.333,506 Jan & Oct-Dec Qtrly March 505,185 415,473 280,758 466,856 475,110 423,641 act.428,677 Feb April 365,514 370,473 452,824 409,365 372,340 348,172 act.394,103 Mar May 257,313 295,545 315,165 263,902 266,422 399,863 act.279,669 Apr & Jan-Mar Qtrly June 453,788 400,667 439,298 494,757 483,070 416,943 act.454,316 May July 326,501 462,244 468,643 389,423 425,325 503,869 act.414,427 Jun August 261,707 247,260 282,859 278,231 272,603 306,157 act.268,532 Jul & Apr-Jun Qtrly September 481,799 495,398 482,244 504,307 521,260 484,992 act.497,002 Aug October 348,002 395,058 382,206 367,366 357,619 430,185 act.370,050 Sept November 276,487 240,417 266,364 306,968 323,871 324,697 act.282,821 Oct & Jul-Sept Qtrly December 384,320 428,058 495,406 469,095 443,688 499,981 est.444,113 Actual to Date $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 4,392,795 Estimated to Fiscal Year end (based on averages and on Budgeted amount)499,981 Total Actual & Estimated $ 4,892,776 Less: Budget 4,700,000 Over (Under) Budget $ 192,776 $ 359,799.94 $ 754,275.37 $ 1,177,916.24 $ 1,526,088.37 $ 1,925,951.58 $ 2,342,894.17 $ 2,846,763.19 $ 3,152,920.28 $ 3,637,912.42 $ 4,068,097.56 $ 4,392,794.94 $ 416,244.00 $727,662.00 $1,198,831.00 $1,611,978.00 $1,878,318.00 $2,377,646.00 $2,770,667.00 $3,051,468.00 $3,560,434.00 $3,931,194.00 $4,200,019.00 $4,700,000.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/7/2014 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: NOVEMBER 2014 Account Number 21-210-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,305 455,442 396,815 405,730 372,447 359,708 act.402,948 Dec February 286,889 313,792 407,348 308,456 350,714 393,562 act.333,440 Jan & Oct-Dec Qtrly March 507,768 415,275 280,734 466,713 475,026 423,546 act.429,103 Feb April 365,727 370,308 452,735 409,353 372,242 348,076 act.394,073 Mar May 256,675 295,529 315,030 263,822 266,456 398,085 act.279,502 Apr & Jan-Mar Qtrly June 453,016 400,500 439,265 494,733 482,382 416,845 act.453,979 May July 326,518 461,255 468,387 389,006 425,194 503,790 act.414,072 Jun August 261,622 247,216 282,836 278,072 272,321 305,930 act.268,413 Jul & Apr-Jun Qtrly September 481,772 495,222 482,150 505,913 521,155 484,904 act.497,242 Aug October 347,721 395,014 382,115 366,846 357,482 430,093 act.369,836 Sept November 275,469 240,348 264,735 306,831 323,768 324,481 act.282,230 Oct & Jul-Sept Qtrly December 384,300 428,200 495,305 468,924 443,569 419,277 est.444,060 Actual to Date $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 4,389,019 Estimated to Fiscal Year end (based on averages and on Budgeted amount)419,277 Total Actual & Estimated $ 4,808,296 Less: Budget 4,638,464 Over (Under) Budget $ 169,832 $ 359,708.18 $ 753,270.03 $ 1,176,815.59 $ 1,524,891.51 $ 1,922,976.56 $ 2,339,821.20 $ 2,843,610.78 $ 3,149,540.59 $ 3,634,444.98 $ 4,064,538.29 $ 4,389,019.26 $ 372,447.00 $723,161.00 $1,198,187.00 $1,570,429.00 $1,836,885.00 $2,319,267.00 $2,744,461.00 $3,016,782.00 $3,537,937.00 $3,895,419.00 $4,219,187.00 $4,638,464.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 11/05/14 07:57:48 Period 01 - 13 Fiscal Year 2014 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,640,000.00 8,435,772.83 0.00 1,204,227.17 12.49 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,640,000.00 8,435,772.83 0.00 1,204,227.17 12.49 10-100-401030 Motor Vehicle Tax 430,000.00 427,261.79 0.00 2,738.21 0.64 10-100-403010 Gasoline Tax 1,100,000.00 917,747.28 0.00 182,252.72 16.57 10-100-430080 Road & Bridge Tax 550,000.00 550,531.66 0.00 -531.66 -0.10 R16 Intergovernmental Taxes 2,080,000.00 1,895,540.73 0.00 184,459.27 8.87 10-100-403020 Cigarette Tax 120,000.00 111,549.20 0.00 8,450.80 7.04 R20 Other Taxes 120,000.00 111,549.20 0.00 8,450.80 7.04 10-100-410020 Electric Utility Lic Tax 3,220,000.00 3,434,822.63 0.00 -214,822.63 -6.67 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 925,000.00 1,044,735.82 0.00 -119,735.82 -12.94 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,450,000.00 2,028,849.53 0.00 421,150.47 17.19 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 281,121.98 0.00 -171,121.98 -155.57 10-100-410060 Cable Franchise Fee 335,000.00 391,736.19 0.00 -56,736.19 -16.94 10-100-410061 Cable Utility-AUDIT 0.00 4,000.00 0.00 -4,000.00 0.00 R30 Franchise & Utility Tax 7,040,000.00 7,185,266.15 0.00 -145,266.15 -2.06 10-100-420010 Cur Property Tax 4,600,000.00 4,514,123.64 0.00 85,876.36 1.87 10-100-420020 Del Property Tax 40,000.00 54,847.13 0.00 -14,847.13 -37.12 10-100-420040 Fin Inst Tax 10,000.00 41,534.94 0.00 -31,534.94 -315.35 10-100-420050 Prop Tax Int & Penalties 20,000.00 28,731.45 0.00 -8,731.45 -43.66 10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74 10-100-420060 Surtax Receipts 470,000.00 472,315.78 0.00 -2,315.78 -0.49 10-100-420080 Special Tax Rev 15,000.00 24,165.79 0.00 -9,165.79 -61.11 R40 Property Taxes 5,209,000.00 5,190,118.01 0.00 18,881.99 0.36 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 1 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 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 7,135.42 0.00 -7,135.42 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 56,168.95 0.00 -56,168.95 0.00 10-100-480025 HUD Program Income 6,610.00 10,610.00 0.00 -4,000.00 -60.51 R50 Intergovernmental 6,610.00 73,914.37 0.00 -67,304.37 -1,018.22 10-100-440010 Admin Charge Backs 1,225,559.00 1,225,559.00 0.00 0.00 0.00 10-100-440050 Emt Reimbursement 0.00 0.00 0.00 0.00 0.00 10-100-440210 Street Cuts 25,000.00 28,588.00 0.00 -3,588.00 -14.35 10-100-440910 Fuel Charge-backs 0.00 16,334.18 0.00 -16,334.18 0.00 10-100-440920 Parts Charge-back 91,600.00 161,512.63 0.00 -69,912.63 -76.32 10-100-440930 Labor Charge-backs 137,400.00 150,003.89 0.00 -12,603.89 -9.17 10-100-450189 Animal Shelter Bricks 0.00 900.00 0.00 -900.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 100,000.00 0.00 0.00 0.00 10-100-481030 Rent City Hallannex 6,500.00 6,500.00 0.00 0.00 0.00 10-100-481040 Rent Other 12,000.00 12,000.00 0.00 0.00 0.00 10-100-481045 Rent-tower Sites 80,000.00 97,857.52 0.00 -17,857.52 -22.32 10-100-481065 Parking Spot Maintenance 0.00 0.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 358,228.63 358,739.86 0.00 -511.23 -0.14 10-100-481080 Sale Of Mapsgis Data 0.00 150.00 0.00 -150.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 15,000.00 0.00 0.00 0.00 10-100-481090 Cole Cty Sheriff-New World 28,678.00 0.00 0.00 28,678.00 100.00 10-100-481100 Sale Of Grave Sites 3,000.00 4,000.00 0.00 -1,000.00 -33.33 10-100-481105 TIF Administration Fee 0.00 0.00 0.00 0.00 0.00 10-100-481110 Long & Short 0.00 66.86 0.00 -66.86 0.00 R60 Charges for Services 2,082,965.63 2,177,211.94 0.00 -94,246.31 -4.52 10-100-450010 Liquor Licenses 65,000.00 66,295.95 0.00 -1,295.95 -1.99 10-100-450020 Business Licenses 205,000.00 215,754.72 0.00 -10,754.72 -5.25 10-100-450021 Home Occupation Permit 1,500.00 1,560.00 0.00 -60.00 -4.00 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 220.00 0.00 -220.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 7,864.17 0.00 -7,864.17 0.00 10-100-450045 Bldg Constr Fees 200,000.00 279,972.54 0.00 -79,972.54 -39.99 10-100-450050 Electrical Certificates 16,000.00 19,085.00 0.00 -3,085.00 -19.28 10-100-450060 Electrical Permits 2,500.00 3,654.81 0.00 -1,154.81 -46.19 10-100-450070 Plumbing Licenses 10,000.00 11,434.00 0.00 -1,434.00 -14.34 10-100-450080 Plumbing Permits 5,000.00 4,937.25 0.00 62.75 1.26 10-100-450090 Other Lic & Permits 1,500.00 3,696.78 0.00 -2,196.78 -146.45 10-100-450091 Day Care Inspection Fees 8,000.00 7,890.00 0.00 110.00 1.38 10-100-450092 Food Inspection Fees 88,000.00 88,125.07 0.00 -125.07 -0.14 10-100-450100 Curb Cut Permits 1,500.00 728.00 0.00 772.00 51.47 10-100-450110 Board Of Adj Fees 1,200.00 1,854.00 0.00 -654.00 -54.50 10-100-450120 Sign Permits 4,000.00 4,105.00 0.00 -105.00 -2.63 10-100-450130 Demolition Permits 500.00 988.00 0.00 -488.00 -97.60 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450150 Acc Rep Fees-police 12,000.00 11,286.90 0.00 713.10 5.94 10-100-450160 Accrptblastg P-fire 500.00 609.00 0.00 -109.00 -21.80 10-100-450170 Animal Redemption Fees 53,000.00 56,465.00 0.00 -3,465.00 -6.54 10-100-450180 Animal Vaccinations Fees 4,500.00 5,030.00 0.00 -530.00 -11.78 10-100-450185 Animal Cremation Fees 20,000.00 25,540.00 0.00 -5,540.00 -27.70 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 500.00 575.00 0.00 -75.00 -15.00 10-100-450230 Vacating Right Of Way 400.00 780.00 0.00 -380.00 -95.00 10-100-450250 Rezoning Request 10,000.00 12,255.00 0.00 -2,255.00 -22.55 10-100-450260 Non-refundable Plansspec 3,000.00 1,841.00 0.00 1,159.00 38.63 R65 Fees Licenses & Permits 713,600.00 832,547.19 0.00 -118,947.19 -16.67 10-100-460010 Court Cost 80,000.00 75,542.63 0.00 4,457.37 5.57 10-100-460015 Court Restitutions 1,300.00 1,863.30 0.00 -563.30 -43.33 10-100-460018 Inmate Security Fund 12,080.00 12,469.07 0.00 -389.07 -3.22 10-100-460020 Jail Cost Recovery 10,000.00 8,196.05 0.00 1,803.95 18.04 10-100-460025 Alcohol Offense Cost Rec 10,000.00 7,705.00 0.00 2,295.00 22.95 10-100-460030 Pol Fines-traffic 850,000.00 844,869.08 0.00 5,130.92 0.60 10-100-460040 Pol Tickets-parking 1,000.00 0.00 0.00 1,000.00 100.00 10-100-460050 Pol Fines-other 0.00 0.00 0.00 0.00 0.00 10-100-460060 Dog Fines 0.00 0.00 0.00 0.00 0.00 10-100-460070 P & Code Violations 0.00 0.00 0.00 0.00 0.00 10-100-460090 Parking Fines 58,600.00 62,668.59 0.00 -4,068.59 -6.94 10-100-460100 Bankcard Charges -13,000.00 -17,179.92 0.00 4,179.92 -32.15 R70 Fines & Forfeitures 1,009,980.00 996,133.80 0.00 13,846.20 1.37 10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0.00 711.93 0.00 -711.93 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 6,040.00 3,360.00 0.00 2,680.00 44.37 10-100-480055 JC Fire Museum 9,884.50 11,884.50 0.00 -2,000.00 -20.23 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 1,280.00 0.00 -1,280.00 0.00 10-100-480070 Community Projects Donations 750.00 750.00 0.00 0.00 0.00 10-100-480080 Dare Donations 500.00 500.00 0.00 0.00 0.00 10-100-480090 Police K-9 Donations 500.00 500.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 40,024.62 52,850.93 0.00 -12,826.31 -32.05 10-100-481050 Transfer StnPlng-Sld Wst Cntr 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair-Solid Waste Cntr 110,000.00 133,228.83 0.00 -23,228.83 -21.12 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 162.80 0.00 -162.80 0.00 R72 ContributionsDonations 167,699.12 205,228.99 0.00 -37,529.87 -22.38 10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 75,069.65 0.00 -75,069.65 0.00 10-100-481070 Miscellaneous 24,000.00 51,070.23 0.00 -27,070.23 -112.79 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 (11/05/2014 - 7:57 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-481077 Insurance Claims 78,241.76 60,746.11 0.00 17,495.65 22.36 10-100-481078 Cafeteria Refunds 0.00 18,449.70 0.00 -18,449.70 0.00 R75 Other Operating Revenues 102,241.76 205,335.69 0.00 -103,093.93 -100.83 10-100-470010 Interest 65,000.00 102,157.02 0.00 -37,157.02 -57.16 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 65,000.00 102,157.02 0.00 -37,157.02 -57.16 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 20,000.00 27,384.16 0.00 -7,384.16 -36.92 R85 Other Non-Operating Revenue 20,000.00 27,384.16 0.00 -7,384.16 -36.92 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 21,940.00 23,121.88 0.00 -1,181.88 -5.39 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 21,940.00 23,121.88 0.00 -1,181.88 -5.39 10-100-495995 Transfer From(to) Surplus 863,149.27 0.00 0.00 863,149.27 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 863,149.27 0.00 0.00 863,149.27 100.00 100 Revenue 29,142,185.78 27,461,281.96 0.00 1,680,903.82 5.77 149 Entitlement Grant 10-149-430010 Federal Grants 719,083.74 404,404.13 0.00 314,679.61 43.76 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 719,083.74 404,404.13 0.00 314,679.61 43.76 149 Entitlement Grant 719,083.74 404,404.13 0.00 314,679.61 43.76 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 306,582.85 285,311.12 0.00 21,271.73 6.94 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 52,955.42 0.00 -52,955.42 0.00 10-300-430074 Overtime Reimb 120,884.95 40,312.27 0.00 80,572.68 66.65 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable R50 Intergovernmental 427,467.80 378,578.81 0.00 48,888.99 11.44 300 Police Department 427,467.80 378,578.81 0.00 48,888.99 11.44 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 184,966.60 184,966.60 0.00 0.00 0.00 R50 Intergovernmental 184,966.60 184,966.60 0.00 0.00 0.00 310 School Resource Officer 184,966.60 184,966.60 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 54.99 20,785.79 0.00 -20,730.80 -37,699.22 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 54.99 20,785.79 0.00 -20,730.80 -37,699.22 320 M.U.S.T.A.N.G.54.99 20,785.79 0.00 -20,730.80 -37,699.22 400 Fire Department 10-400-430010 Federal Grants 184,500.00 0.00 0.00 184,500.00 100.00 10-400-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 184,500.00 0.00 0.00 184,500.00 100.00 400 Fire Department 184,500.00 0.00 0.00 184,500.00 100.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 148,200.00 90,096.00 0.00 58,104.00 39.21 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 9,262.50 5,631.00 0.00 3,631.50 39.21 R50 Intergovernmental 157,462.50 95,727.00 0.00 61,735.50 39.21 522 Plan & Protect Svcs-MPO 157,462.50 95,727.00 0.00 61,735.50 39.21 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 1,374,095.19 979,129.49 0.00 394,965.70 28.74 10-530-430020 State Grants 1,250.00 1,250.00 0.00 0.00 0.00 10-530-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,375,345.19 980,379.49 0.00 394,965.70 28.72 530 Plan & Protect Svc-RedevGrant 1,375,345.19 980,379.49 0.00 394,965.70 28.72 532 Plan & Protect Svcs-Env Health 10-532-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-532-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-532-430040 Local Grants 11,000.00 10,980.00 0.00 20.00 0.18 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable R50 Intergovernmental 11,000.00 10,980.00 0.00 20.00 0.18 532 Plan & Protect Svcs-Env Health 11,000.00 10,980.00 0.00 20.00 0.18 990 Capital Projects 10-990-430010 Federal Grants 1,401,414.33 144,958.65 0.00 1,256,455.68 89.66 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,401,414.33 144,958.65 0.00 1,256,455.68 89.66 990 Capital Projects 1,401,414.33 144,958.65 0.00 1,256,455.68 89.66 Revenue Revenue 33,603,480.93 29,682,062.43 0.00 3,921,418.50 11.67 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 59,175.00 0.00 5,625.00 8.68 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 4,527.43 0.00 429.77 8.67 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00 E05 Personnel Services 69,860.46 63,805.69 0.00 6,054.77 8.67 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 30.50 0.00 69.50 69.50 10-110-512010 Printing 750.00 21.00 0.00 729.00 97.20 10-110-512020 Copies 500.00 166.28 0.00 333.72 66.74 10-110-513010 Office Supplies 400.00 317.65 145.83 -63.48 -15.87 10-110-514040 Food 412.05 0.00 0.00 412.05 100.00 E10 Materials & Supplies 2,162.05 535.43 145.83 1,480.79 68.49 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 3,000.00 431.59 0.00 2,568.41 85.61 10-110-520030 Dues And Publications 4,582.90 4,582.90 0.00 0.00 0.00 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 417.10 138.47 0.00 278.63 66.80 10-110-522020 Professional Services 87.95 87.95 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,087.95 5,240.91 0.00 2,847.04 35.20 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 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 110 Mayor & Council 80,110.46 69,582.03 145.83 10,382.60 12.96 120 City Clerk 10-120-501020 Salaries 63,969.55 68,723.96 0.00 -4,754.41 -7.43 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 16.85 16.85 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,893.67 4,979.07 0.00 -85.40 -1.75 10-120-502020 Group Health Insurance 12,300.85 12,296.33 0.00 4.52 0.04 10-120-502030 Retirement 12,602.00 11,432.55 0.00 1,169.45 9.28 10-120-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00 10-120-502050 Life Insurance 108.44 101.89 0.00 6.55 6.04 10-120-502060 Long Term Disability 179.04 168.50 0.00 10.54 5.89 10-120-502070 Employee Assistance Prgm 29.53 29.66 0.00 -0.13 -0.44 E05 Personnel Services 94,203.19 97,852.07 0.00 -3,648.88 -3.87 10-120-511020 Postage 270.00 80.68 0.00 189.32 70.12 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 500.00 516.98 0.00 -16.98 -3.40 10-120-513010 Office Supplies 1,000.00 728.23 0.00 271.77 27.18 E10 Materials & Supplies 1,770.00 1,325.89 0.00 444.11 25.09 10-120-520030 Dues And Publications 250.00 185.00 0.00 65.00 26.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 285.00 0.00 715.00 71.50 10-120-522020 Professional Services 498.15 4.05 0.00 494.10 99.19 10-120-529030 Election Expense 50,000.00 21,613.64 0.00 28,386.36 56.77 E15 Contractual Services 51,748.15 22,087.69 0.00 29,660.46 57.32 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 635.00 489.15 145.83 0.02 0.00 10-120-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 635.00 489.15 145.83 0.02 0.00 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 148,356.34 121,754.80 145.83 26,455.71 17.83 140 City Administrator 10-140-501020 Salaries 194,289.92 189,686.43 0.00 4,603.49 2.37 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 12,139.78 13,938.81 0.00 -1,799.03 -14.82 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-502020 Group Health Insurance 16,066.75 15,572.25 0.00 494.50 3.08 10-140-502030 Retirement 27,331.24 18,092.83 0.00 9,238.41 33.80 10-140-502040 Workers Compensation 542.12 542.12 0.00 0.00 0.00 10-140-502050 Life Insurance 287.61 278.51 0.00 9.10 3.16 10-140-502060 Long Term Disability 424.74 453.67 0.00 -28.93 -6.81 10-140-502070 Employee Assistance Prgm 36.72 40.76 0.00 -4.04 -11.00 E05 Personnel Services 251,118.88 238,605.38 0.00 12,513.50 4.98 10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-140-511020 Postage 400.00 152.60 0.00 247.40 61.85 10-140-512010 Printing 300.00 120.00 0.00 180.00 60.00 10-140-512020 Copies 500.00 151.72 0.00 348.28 69.66 10-140-513010 Office Supplies 1,200.00 1,046.07 145.83 8.10 0.68 10-140-517010 Operational Supplies 1,750.00 513.91 0.00 1,236.09 70.63 E10 Materials & Supplies 5,150.00 1,984.30 145.83 3,019.87 58.64 10-140-520030 Dues And Publications 600.00 365.00 0.00 235.00 39.17 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 1,200.00 849.89 0.00 350.11 29.18 10-140-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-140-520090 Recruitment 7,960.75 7,960.75 0.00 0.00 0.00 10-140-520095 Relocation Fees 17,402.06 17,402.06 0.00 0.00 0.00 10-140-522020 Professional Services 1,693.01 494.30 0.00 1,198.71 70.80 E15 Contractual Services 30,855.82 27,072.00 0.00 3,783.82 12.26 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 250.00 115.44 0.00 134.56 53.82 10-140-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 250.00 115.44 0.00 134.56 53.82 10-140-572020 Purchase Of Equipment 306.99 306.99 0.00 0.00 0.00 E70 Capital Purchases 306.99 306.99 0.00 0.00 0.00 140 City Administrator 287,681.69 268,084.11 145.83 19,451.75 6.76 149 Entitlement Grant 10-149-501020 Salaries 20,803.88 16,089.84 0.00 4,714.04 22.66 10-149-501050 Parttime(wo Benefits)16,000.00 13,305.00 0.00 2,695.00 16.84 10-149-502010 Social Security 2,135.28 2,248.62 0.00 -113.34 -5.31 10-149-502020 Group Health Insurance 2,363.92 2,368.43 0.00 -4.51 -0.19 10-149-502030 Retirement 2,803.50 2,912.31 0.00 -108.81 -3.88 10-149-502050 Life Insurance 25.59 25.64 0.00 -0.05 -0.20 10-149-502060 Long Term Disability 42.42 41.86 0.00 0.56 1.32 E05 Personnel Services 44,174.59 36,991.70 0.00 7,182.89 16.26 10-149-511010 Advertising 1,500.00 561.75 0.00 938.25 62.55 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-511020 Postage 699.37 394.41 0.00 304.96 43.60 10-149-512020 Copies 0.63 0.63 0.00 0.00 0.00 10-149-513010 Office Supplies 1,500.00 1,029.46 0.00 470.54 31.37 10-149-517010 Operational Supplies 700.00 169.97 0.00 530.03 75.72 E10 Materials & Supplies 4,400.00 2,156.22 0.00 2,243.78 51.00 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,671.34 1,957.18 0.00 714.16 26.73 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 27.00 27.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 59,937.00 39,695.00 0.00 20,242.00 33.77 10-149-528012 Housing Rehab-Energy Efficienc 42,402.00 29,078.15 0.00 13,323.85 31.42 10-149-528020 Housing Assistance 30,433.00 30,433.00 0.00 0.00 0.00 10-149-528030 Public Improvement 363,071.17 291,998.41 46,226.45 24,846.31 6.84 10-149-528040 Neighborhood Redevelopmnt 103,536.69 80,681.69 0.00 22,855.00 22.07 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 6,778.00 1,733.00 0.00 5,045.00 74.43 10-149-528080 Homeless Objectives 22,524.00 460.00 0.00 22,064.00 97.96 E15 Contractual Services 631,380.20 476,063.43 46,226.45 109,090.32 17.28 10-149-547020 Maintenance Agreements 738.95 569.36 51.76 117.83 15.95 E25 Repairs & Maintenance 738.95 569.36 51.76 117.83 15.95 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 45,000.00 45,000.00 0.00 0.00 0.00 E75 Capital Projects 45,000.00 45,000.00 0.00 0.00 0.00 149 Entitlement Grant 725,693.74 560,780.71 46,278.21 118,634.82 16.35 150 City Counselor 10-150-501020 Salaries 191,239.55 184,828.33 0.00 6,411.22 3.35 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 17.36 17.36 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,354.55 13,187.42 0.00 4,167.13 24.01 10-150-502020 Group Health Insurance 31,716.35 26,574.75 0.00 5,141.60 16.21 10-150-502030 Retirement 44,534.97 33,456.75 0.00 11,078.22 24.88 10-150-502040 Workers Compensation 370.02 370.02 0.00 0.00 0.00 10-150-502050 Life Insurance 324.39 304.77 0.00 19.62 6.05 10-150-502060 Long Term Disability 555.12 455.92 0.00 99.20 17.87 10-150-502070 Employee Assistance Prgm 74.15 74.48 0.00 -0.33 -0.45 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 286,186.46 259,269.80 0.00 26,916.66 9.41 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)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 465.00 476.65 0.00 -11.65 -2.51 10-150-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-150-512020 Copies 670.00 224.71 0.00 445.29 66.46 10-150-513010 Office Supplies 1,800.00 609.16 0.00 1,190.84 66.16 10-150-517010 Operational Supplies 10.00 0.00 0.00 10.00 100.00 E10 Materials & Supplies 3,070.00 1,310.52 0.00 1,759.48 57.31 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 12,240.00 9,653.08 0.00 2,586.92 21.13 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 4,369.14 0.00 630.86 12.62 10-150-520080 Tuition Reimbursement 3,420.00 3,420.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 3,000.00 1,712.00 0.00 1,288.00 42.93 10-150-522020 Professional Services 24,760.16 8,152.08 0.00 16,608.08 67.08 10-150-525030 Court Cost & Witness Fees 60.00 57.00 0.00 3.00 5.00 E15 Contractual Services 48,480.16 27,363.30 0.00 21,116.86 43.56 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 1,410.00 1,218.25 191.12 0.63 0.04 10-150-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,410.00 1,218.25 191.12 0.63 0.04 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 339,146.62 289,161.87 191.12 49,793.63 14.68 160 Municipal Court 10-160-501010 Salary-elected Officals 60,000.00 54,999.89 0.00 5,000.11 8.33 10-160-501020 Salaries 97,303.63 96,071.87 0.00 1,231.76 1.27 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)9,500.00 5,214.76 0.00 4,285.24 45.11 10-160-501090 Overtime 7,200.00 378.10 0.00 6,821.90 94.75 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,418.38 11,815.83 0.00 1,602.55 11.94 10-160-502020 Group Health Insurance 12,436.90 11,152.62 0.00 1,284.28 10.33 10-160-502030 Retirement 20,863.01 17,444.86 0.00 3,418.15 16.38 10-160-502040 Workers Compensation 154.89 154.89 0.00 0.00 0.00 10-160-502050 Life Insurance 163.88 154.63 0.00 9.25 5.64 10-160-502060 Long Term Disability 272.64 256.53 0.00 16.11 5.91 10-160-502070 Employee Assistance Prgm 51.73 51.98 0.00 -0.25 -0.48 E05 Personnel Services 221,365.06 197,695.96 0.00 23,669.10 10.69 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 3,166.11 0.00 833.89 20.85 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-512010 Printing 1,090.00 393.61 0.00 696.39 63.89 10-160-512020 Copies 1,000.00 177.09 0.00 822.91 82.29 10-160-513010 Office Supplies 1,600.00 1,254.66 0.00 345.34 21.58 E10 Materials & Supplies 7,690.00 4,991.47 0.00 2,698.53 35.09 10-160-520025 Security 10,000.00 6,937.28 0.00 3,062.72 30.63 10-160-520030 Dues And Publications 450.00 392.32 0.00 57.68 12.82 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,960.00 805.63 0.00 1,154.37 58.90 10-160-522020 Professional Services 3,000.00 2,595.49 0.00 404.51 13.48 10-160-525005 Appointed Counsel 7,000.00 5,766.80 0.00 1,233.20 17.62 10-160-525010 Care Of Prisoners 3,380.50 0.00 0.00 3,380.50 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 25,830.50 16,497.52 0.00 9,332.98 36.13 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 1,200.00 422.34 145.83 631.83 52.65 10-160-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,200.00 422.34 145.83 631.83 52.65 10-160-572020 Purchase Of Equipment 16,291.06 3,124.92 13,163.56 2.58 0.02 E70 Capital Purchases 16,291.06 3,124.92 13,163.56 2.58 0.02 160 Municipal Court 272,376.62 222,732.21 13,309.39 36,335.02 13.34 170 Human Resources 10-170-501020 Salaries 150,903.54 148,813.64 0.00 2,089.90 1.38 10-170-501050 Parttime(wo Benefits)9,600.00 10,705.84 0.00 -1,105.84 -11.52 10-170-501090 Overtime 308.74 308.74 0.00 0.00 0.00 10-170-502010 Social Security 12,302.14 12,392.65 0.00 -90.51 -0.74 10-170-502020 Group Health Insurance 16,353.16 11,590.13 0.00 4,763.03 29.13 10-170-502030 Retirement 29,742.18 26,991.09 0.00 2,751.09 9.25 10-170-502040 Workers Compensation 301.18 301.18 0.00 0.00 0.00 10-170-502050 Life Insurance 250.06 238.12 0.00 11.94 4.77 10-170-502060 Long Term Disability 366.60 350.44 0.00 16.16 4.41 10-170-502070 Employee Assistance Prgm 46.53 56.82 0.00 -10.29 -22.11 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 220,174.13 211,748.65 0.00 8,425.48 3.83 10-170-511010 Advertising 150.00 71.75 0.00 78.25 52.17 10-170-511020 Postage 1,000.00 111.74 0.00 888.26 88.83 10-170-512010 Printing 2,481.24 596.94 0.00 1,884.30 75.94 10-170-512020 Copies 1,500.00 374.99 0.00 1,125.01 75.00 10-170-513010 Office Supplies 1,500.00 814.74 0.00 685.26 45.68 10-170-517010 Operational Supplies 1,301.38 552.86 0.00 748.52 57.52 E10 Materials & Supplies 7,932.62 2,523.02 0.00 5,409.60 68.19 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-520030 Dues And Publications 1,255.00 407.50 0.00 847.50 67.53 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 2,614.33 0.00 885.67 25.30 10-170-520070 Training And Education 4,000.00 4,758.09 0.00 -758.09 -18.95 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 7,634.00 7,234.00 0.00 400.00 5.24 10-170-522020 Professional Services 6,366.00 2,011.48 0.00 4,354.52 68.40 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,755.00 17,025.40 0.00 5,729.60 25.18 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 267.38 291.69 145.83 -170.14 -63.63 10-170-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 267.38 291.69 145.83 -170.14 -63.63 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 251,129.13 231,588.76 145.83 19,394.54 7.72 180 Finance Department 10-180-501020 Salaries 636,305.10 546,039.97 0.00 90,265.13 14.19 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 17,813.95 0.00 1,090.23 5.77 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 50,353.11 41,994.82 0.00 8,358.29 16.60 10-180-502020 Group Health Insurance 76,739.99 76,102.22 0.00 637.77 0.83 10-180-502030 Retirement 125,943.35 98,833.42 0.00 27,109.93 21.53 10-180-502040 Workers Compensation 1,634.95 1,634.95 0.00 0.00 0.00 10-180-502050 Life Insurance 1,095.73 887.82 0.00 207.91 18.97 10-180-502060 Long Term Disability 1,691.84 1,460.50 0.00 231.34 13.67 10-180-502070 Employee Assistance Prgm 287.18 287.18 0.00 0.00 0.00 E05 Personnel Services 912,955.43 785,054.83 0.00 127,900.60 14.01 10-180-511010 Advertising 2,000.00 52.50 0.00 1,947.50 97.38 10-180-511020 Postage 13,500.00 8,711.77 0.00 4,788.23 35.47 10-180-511021 Mail Machine Cost 3,015.69 3,015.69 0.00 0.00 0.00 10-180-512010 Printing 6,500.00 2,978.26 0.00 3,521.74 54.18 10-180-512020 Copies 5,000.00 2,481.67 0.00 2,518.33 50.37 10-180-512021 Copy Machine Cost 0.00 -16.07 874.98 -858.91 0.00 10-180-513010 Office Supplies 4,415.25 3,939.29 0.00 475.96 10.78 10-180-517010 Operational Supplies 4,559.15 3,805.65 0.00 753.50 16.53 E10 Materials & Supplies 38,990.09 24,968.76 874.98 13,146.35 33.72 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)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 2,400.00 1,974.08 0.00 425.92 17.75 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 2,200.00 152.32 0.00 2,047.68 93.08 10-180-520080 Tuition Reimbursement 1,800.00 0.00 0.00 1,800.00 100.00 10-180-522010 Audit 38,955.00 38,955.00 0.00 0.00 0.00 10-180-522020 Professional Services 9.91 9.91 0.00 0.00 0.00 E15 Contractual Services 45,364.91 41,091.31 0.00 4,273.60 9.42 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 2,000.00 928.15 0.00 1,071.85 53.59 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 928.15 0.00 1,071.85 53.59 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 999,310.43 852,043.05 874.98 146,392.40 14.65 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 5,322.11 0.00 0.00 5,322.11 100.00 10-185-501022 Separation Incentive Prog Svgs 22,325.24 0.00 0.00 22,325.24 100.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 105,030.00 91,680.52 0.00 13,349.48 12.71 10-185-502022 Wellness Assessment 25,000.00 24,500.00 0.00 500.00 2.00 10-185-503010 Awards Program 3,000.00 0.00 0.00 3,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 160,677.35 116,180.52 0.00 44,496.83 27.69 10-185-514010 Gas 19,000.00 18,742.83 0.00 257.17 1.35 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 19,000.00 18,742.83 0.00 257.17 1.35 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 287,100.00 247,793.02 0.00 39,306.98 13.69 10-185-521020 Insurance Deductible 30,000.00 12,983.91 0.00 17,016.09 56.72 10-185-521030 Self Ins Prop & Casualty 104,437.68 103,871.95 0.00 565.73 0.54 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 -11.52 0.00 11.52 0.00 10-185-522020 Professional Services 129,050.00 30,414.96 4,050.00 94,585.04 73.29 10-185-522025 JCTV 55,000.00 55,000.00 0.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 34,174.93 0.00 11,325.07 24.89 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-527020 Economic Development 185,000.00 231,250.00 0.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 6,582.06 0.00 417.94 5.97 E15 Contractual Services 843,587.68 722,059.31 4,050.00 117,478.37 13.93 10-185-531010 Electricity 42,400.00 32,687.49 0.00 9,712.51 22.91 10-185-533010 Natural Gas 6,000.00 5,904.79 0.00 95.21 1.59 10-185-535010 WaterSewer 6,000.00 5,691.63 0.00 308.37 5.14 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 54,400.00 44,283.91 0.00 10,116.09 18.60 10-185-540010 Building & Grounds Maint.60,000.00 61,185.78 -2,370.57 1,184.79 1.97 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,000.00 1,716.00 0.00 284.00 14.20 E25 Repairs & Maintenance 87,000.00 87,901.78 -2,370.57 1,468.79 1.69 10-185-550010 Miscellaneous 10,000.00 5,846.51 0.00 4,153.49 41.53 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 5,500.00 4,190.00 1,165.00 145.00 2.64 10-185-550041 ALPLA Settlement 50,000.00 50,000.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 22,439.50 11,436.48 0.00 11,003.02 49.03 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 97,939.50 81,472.99 1,165.00 15,301.51 15.62 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 370,524.00 370,524.00 0.00 0.00 0.00 10-185-580090 Note Interest 21,276.70 21,276.70 0.00 0.00 0.00 E90 Debt Service 391,800.70 391,800.70 0.00 0.00 0.00 185 Non-Departmental 1,654,405.23 1,462,442.04 2,844.43 189,118.76 11.43 190 I.T. Department GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-501020 Salaries 554,117.31 541,436.58 0.00 12,680.73 2.29 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 42,160.47 39,514.38 0.00 2,646.09 6.28 10-190-502020 Group Health Insurance 63,175.48 62,528.30 0.00 647.18 1.02 10-190-502030 Retirement 108,570.11 98,000.38 0.00 10,569.73 9.74 10-190-502040 Workers Compensation 783.06 783.06 0.00 0.00 0.00 10-190-502050 Life Insurance 908.88 871.25 0.00 37.63 4.14 10-190-502060 Long Term Disability 1,459.74 1,375.73 0.00 84.01 5.76 10-190-502070 Employee Assistance Prgm 205.35 206.28 0.00 -0.93 -0.45 E05 Personnel Services 771,380.40 744,715.96 0.00 26,664.44 3.46 10-190-511010 Advertising 500.00 50.75 0.00 449.25 89.85 10-190-511020 Postage 200.00 14.50 0.00 185.50 92.75 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 200.00 31.01 0.00 168.99 84.50 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 995.80 0.00 4.20 0.42 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 20.50 0.00 29.50 59.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,500.00 1,504.39 0.00 -4.39 -0.29 E10 Materials & Supplies 3,450.00 2,616.95 0.00 833.05 24.15 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 200.00 0.00 300.00 60.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 7,045.17 0.00 954.83 11.94 10-190-520080 Tuition Reimbursement 7,500.00 3,660.00 0.00 3,840.00 51.20 10-190-522020 Professional Services 2,000.00 818.83 0.00 1,181.17 59.06 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 19,800.00 17,802.64 0.00 1,997.36 10.09 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 2,000.00 435.32 0.00 1,564.68 78.23 E15 Contractual Services 39,800.00 29,961.96 0.00 9,838.04 24.72 10-190-534010 Telephone 53,128.15 45,476.28 0.00 7,651.87 14.40 E20 Utilities 53,128.15 45,476.28 0.00 7,651.87 14.40 10-190-545010 Software Licensemaint 233,257.73 228,957.73 4,300.00 0.00 0.00 10-190-545020 Citywide Wiringnetwork 3,525.76 3,525.76 0.00 0.00 0.00 10-190-547010 Equipment Maintenance 4,080.99 3,812.79 0.00 268.20 6.57 10-190-547020 Maintenance Agreements 33,625.00 30,410.24 45.29 3,169.47 9.43 E25 Repairs & Maintenance 274,489.48 266,706.52 4,345.29 3,437.67 1.25 10-190-572020 Purchase Of Equipment 26,882.37 26,882.37 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 26,882.37 26,882.37 0.00 0.00 0.00 190 I.T. Department 1,169,130.40 1,116,360.04 4,345.29 48,425.07 4.14 300 Police Department 10-300-501020 Salaries 3,975,931.74 3,901,356.69 0.00 74,575.05 1.88 10-300-501030 Holiday Pay 100,650.00 99,846.64 0.00 803.36 0.80 10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits)30,400.00 27,330.50 0.00 3,069.50 10.10 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 7,150.00 7,024.00 0.00 126.00 1.76 10-300-501090 Overtime 277,087.45 200,511.35 0.00 76,576.10 27.64 10-300-501095 Overtime Straight Pay 6,000.00 4,779.47 0.00 1,220.53 20.34 10-300-502010 Social Security 331,874.92 307,530.16 0.00 24,344.76 7.34 10-300-502020 Group Health Insurance 630,217.28 615,044.58 0.00 15,172.70 2.41 10-300-502030 Retirement 807,697.38 789,812.51 0.00 17,884.87 2.21 10-300-502040 Workers Compensation 70,999.83 70,999.83 0.00 0.00 0.00 10-300-502050 Life Insurance 6,782.09 6,042.36 0.00 739.73 10.91 10-300-502060 Long Term Disability 11,071.66 9,882.56 0.00 1,189.10 10.74 10-300-502070 Employee Assistance Prgm 1,927.56 1,927.20 0.00 0.36 0.02 10-300-503010 Awards Program 1,600.00 1,600.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 1,000.00 129.30 0.00 870.70 87.07 E05 Personnel Services 6,260,389.91 6,043,817.15 0.00 216,572.76 3.46 10-300-511010 Advertising 3,758.23 3,758.23 0.00 0.00 0.00 10-300-511020 Postage 1,419.40 1,492.97 0.00 -73.57 -5.18 10-300-512010 Printing 6,130.60 6,130.60 0.00 0.00 0.00 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 2,157.73 2,157.73 0.00 0.00 0.00 10-300-513010 Office Supplies 9,446.84 9,446.84 0.00 0.00 0.00 10-300-514010 Gas 282,000.00 231,698.76 0.00 50,301.24 17.84 10-300-514040 Food 496.15 496.15 0.00 0.00 0.00 10-300-515040 First Aid Supplies 1,100.77 1,100.77 0.00 0.00 0.00 10-300-516010 Ammunition & Firearms Supplies 22,929.86 22,929.86 0.00 0.00 0.00 10-300-516020 Dare Program 17,981.99 17,981.99 0.00 0.00 0.00 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant)167,494.00 167,494.00 0.00 0.00 0.00 10-300-516050 Community Projects 750.00 559.00 0.00 191.00 25.47 10-300-517010 Operational Supplies 48,306.97 44,564.46 0.00 3,742.51 7.75 E10 Materials & Supplies 566,472.54 512,311.36 0.00 54,161.18 9.56 10-300-520030 Dues And Publications 4,019.43 4,019.43 0.00 0.00 0.00 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 0.00 -192.00 0.00 192.00 0.00 10-300-520080 Tuition Reimbursement 3,795.00 3,795.00 0.00 0.00 0.00 10-300-520090 Recruitment 1,981.43 1,981.43 0.00 0.00 0.00 10-300-521040 Medical Claimsservices 7,240.00 7,240.00 0.00 0.00 0.00 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 15,273.55 15,273.55 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 6,900.00 6,900.00 0.00 0.00 0.00 10-300-523030 Building Lease 1,200.00 1,200.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 11,040.00 2,894.19 0.00 8,145.81 73.78 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 1,601.63 1,225.27 0.00 376.36 23.50 E15 Contractual Services 53,051.04 44,336.87 0.00 8,714.17 16.43 10-300-531010 Electricity 65,010.07 59,810.07 0.00 5,200.00 8.00 10-300-533010 Natural Gas 13,248.03 12,451.55 0.00 796.48 6.01 10-300-534010 Telephone 5,451.97 3,576.80 0.00 1,875.17 34.39 10-300-535010 WaterSewer 4,500.00 4,119.40 0.00 380.60 8.46 E20 Utilities 88,210.07 79,957.82 0.00 8,252.25 9.36 10-300-540010 Building & Grounds Maint.34,565.04 34,553.48 -13,683.13 13,694.69 39.62 10-300-541030 Vehicle Wash 11,433.62 10,831.22 0.00 602.40 5.27 10-300-544010 K-9 Operations 10,712.23 10,348.19 0.00 364.04 3.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 23,074.46 16,656.71 0.00 6,417.75 27.81 10-300-546010 Clothing Expense 48,600.69 49,463.69 -3,850.25 2,987.25 6.15 10-300-546020 Uniform Cleaning 21,975.00 21,709.90 0.00 265.10 1.21 10-300-547010 Equipment Maintenance 10,928.13 10,928.13 0.00 0.00 0.00 10-300-547020 Maintenance Agreements 21,198.20 21,198.20 0.00 0.00 0.00 10-300-547030 Radio Maintenance 10,262.98 10,262.98 0.00 0.00 0.00 E25 Repairs & Maintenance 192,750.35 185,952.50 -17,533.38 24,331.23 12.62 10-300-572010 Purchase Of Vehicles 250,000.00 250,000.00 0.00 0.00 0.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 31,555.20 11,086.20 0.00 20,469.00 64.87 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 10,133.00 9,701.87 0.00 431.13 4.25 10-300-572100 MDT Year 3 Equipment 264,894.65 264,894.65 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 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 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 556,582.85 535,682.72 0.00 20,900.13 3.76 300 Police Department 7,717,456.76 7,402,058.42 -17,533.38 332,931.72 4.31 310 School Resource Officer 10-310-501020 Salaries 232,053.46 227,663.24 0.00 4,390.22 1.89 10-310-501030 Holiday Pay 3,999.48 3,503.06 0.00 496.42 12.41 10-310-501090 Overtime 27,326.00 26,204.07 0.00 1,121.93 4.11 10-310-501095 Overtime Straight Pay 600.00 410.80 0.00 189.20 31.53 10-310-502010 Social Security 18,099.63 17,803.94 0.00 295.69 1.63 10-310-502020 Group Health Insurance 47,375.87 46,162.30 0.00 1,213.57 2.56 10-310-502030 Retirement 54,838.69 51,460.46 0.00 3,378.23 6.16 10-310-502040 Workers Compensation 3,631.31 3,631.31 0.00 0.00 0.00 10-310-502050 Life Insurance 401.52 350.25 0.00 51.27 12.77 10-310-502060 Long Term Disability 663.84 580.29 0.00 83.55 12.59 10-310-502070 Employee Assistance Prgm 111.52 111.52 0.00 0.00 0.00 E05 Personnel Services 389,101.32 377,881.24 0.00 11,220.08 2.88 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 389,101.32 377,881.24 0.00 11,220.08 2.88 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 94,852.10 92,923.32 0.00 1,928.78 2.03 10-320-501030 Holiday Pay 2,676.21 2,676.21 0.00 0.00 0.00 10-320-501090 Overtime 12,197.00 12,256.64 0.00 -59.64 -0.49 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502010 Social Security 7,975.06 7,731.65 0.00 243.41 3.05 10-320-502020 Group Health Insurance 17,127.51 15,950.06 0.00 1,177.45 6.87 10-320-502030 Retirement 22,564.98 21,991.92 0.00 573.06 2.54 10-320-502040 Workers Compensation 1,677.98 1,677.98 0.00 0.00 0.00 10-320-502050 Life Insurance 157.92 147.56 0.00 10.36 6.56 10-320-502060 Long Term Disability 259.46 241.63 0.00 17.83 6.87 10-320-502070 Employee Assistance Prgm 44.62 44.62 0.00 0.00 0.00 E05 Personnel Services 159,532.84 155,641.59 0.00 3,891.25 2.44 10-320-514010 Gas 20,000.00 5,753.31 0.00 14,246.69 71.23 10-320-516040 Investigations 16,499.59 15,891.59 0.00 608.00 3.68 10-320-517010 Operational Supplies 1,455.40 1,455.40 0.00 0.00 0.00 E10 Materials & Supplies 37,954.99 23,100.30 0.00 14,854.69 39.14 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 13,100.00 13,100.00 7,200.00 -7,200.00 -54.96 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 13,100.00 13,100.00 7,200.00 -7,200.00 -54.96 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.210,587.83 191,841.89 7,200.00 11,545.94 5.48 330 Animal Control 10-330-501020 Salaries 319,727.53 313,494.72 0.00 6,232.81 1.95 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,200.00 4,252.00 0.00 -52.00 -1.24 10-330-501090 Overtime 1,709.00 1,200.39 0.00 508.61 29.76 10-330-501095 Overtime Straight Pay 500.00 155.00 0.00 345.00 69.00 10-330-502010 Social Security 24,635.80 23,134.88 0.00 1,500.92 6.09 10-330-502020 Group Health Insurance 56,900.07 54,265.84 0.00 2,634.23 4.63 10-330-502030 Retirement 57,020.95 52,182.82 0.00 4,838.13 8.48 10-330-502040 Workers Compensation 5,137.19 5,137.19 0.00 0.00 0.00 10-330-502050 Life Insurance 527.52 500.92 0.00 26.60 5.04 10-330-502060 Long Term Disability 870.14 828.86 0.00 41.28 4.74 10-330-502070 Employee Assistance Prgm 178.42 178.42 0.00 0.00 0.00 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 472,006.62 455,331.04 0.00 16,675.58 3.53 10-330-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-330-511020 Postage 242.15 70.68 0.00 171.47 70.81 10-330-512010 Printing 1,957.85 1,957.85 0.00 0.00 0.00 10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-330-513010 Office Supplies 800.00 599.40 0.00 200.60 25.08 10-330-514030 Small Tools 178.63 42.10 0.00 136.53 76.43 10-330-515040 First Aid Supplies 721.37 721.37 0.00 0.00 0.00 10-330-517010 Operational Supplies 9,000.00 8,231.86 0.00 768.14 8.53 E10 Materials & Supplies 13,420.00 11,623.26 0.00 1,796.74 13.39 10-330-520030 Dues And Publications 1,524.65 937.24 0.00 587.41 38.53 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 1,568.87 0.00 81.13 4.92 10-330-521040 Medical Claimsservices 1,304.00 1,304.00 0.00 0.00 0.00 10-330-522020 Professional Services 7,233.35 5,306.86 0.00 1,926.49 26.63 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 7,000.00 4,668.50 0.00 2,331.50 33.31 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 38.00 38.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 40,024.62 0.00 0.00 40,024.62 100.00 E15 Contractual Services 58,774.62 13,823.47 0.00 44,951.15 76.48 10-330-531010 Electricity 23,000.00 20,613.54 0.00 2,386.46 10.38 10-330-533010 Natural Gas 16,050.00 14,803.94 0.00 1,246.06 7.76 10-330-534010 Telephone 572.00 265.21 0.00 306.79 53.63 10-330-535010 WaterSewer 4,000.00 3,775.47 0.00 224.53 5.61 E20 Utilities 43,622.00 39,458.16 0.00 4,163.84 9.55 10-330-540010 Building & Grounds Maint.6,944.00 6,462.23 -2,687.95 3,169.72 45.65 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 38,000.00 36,296.31 -2,260.56 3,964.25 10.43 10-330-546010 Clothing Expense 3,000.00 1,845.89 0.00 1,154.11 38.47 10-330-546020 Uniform Cleaning 100.00 0.00 0.00 100.00 100.00 10-330-547010 Equipment Maintenance 1,800.00 1,720.99 0.00 79.01 4.39 10-330-547020 Maintenance Agreements 1,656.00 1,500.00 0.00 156.00 9.42 10-330-547030 Radio Maintenance 50.00 0.00 0.00 50.00 100.00 E25 Repairs & Maintenance 52,090.00 48,365.42 -4,948.51 8,673.09 16.65 10-330-572020 Purchase Of Equipment 4,400.00 2,869.45 0.00 1,530.55 34.79 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 4,400.00 2,869.45 0.00 1,530.55 34.79 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 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 330 Animal Control 644,313.24 571,470.80 -4,948.51 77,790.95 12.07 390 9-1-1 Police 10-390-501020 Salaries 734,661.24 718,618.95 0.00 16,042.29 2.18 10-390-501030 Holiday Pay 25,600.00 25,143.40 0.00 456.60 1.78 10-390-501050 Parttime(wo Benefits)1,200.00 1,187.08 0.00 12.92 1.08 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 20,814.00 20,088.63 0.00 725.37 3.49 10-390-501095 Overtime Straight Pay 500.00 230.51 0.00 269.49 53.90 10-390-502010 Social Security 62,276.75 55,451.76 0.00 6,824.99 10.96 10-390-502020 Group Health Insurance 135,653.93 131,165.12 0.00 4,488.81 3.31 10-390-502030 Retirement 145,558.26 129,756.42 0.00 15,801.84 10.86 10-390-502040 Workers Compensation 1,350.99 1,350.99 0.00 0.00 0.00 10-390-502050 Life Insurance 1,305.36 1,145.76 0.00 159.60 12.23 10-390-502060 Long Term Disability 2,140.65 1,879.28 0.00 261.37 12.21 10-390-502070 Employee Assistance Prgm 440.46 440.46 0.00 0.00 0.00 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,131,501.64 1,086,458.36 0.00 45,043.28 3.98 10-390-511010 Advertising 31.72 31.72 0.00 0.00 0.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 10,103.58 7,432.13 0.00 2,671.45 26.44 E10 Materials & Supplies 10,135.30 7,463.85 0.00 2,671.45 26.36 10-390-520030 Dues And Publications 115.00 115.00 0.00 0.00 0.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 0.00 -12.00 0.00 12.00 0.00 10-390-522020 Professional Services 1,442.70 1,442.70 0.00 0.00 0.00 10-390-523010 Equipment Rentlease 96,835.00 96,822.22 0.00 12.78 0.01 E15 Contractual Services 98,392.70 98,367.92 0.00 24.78 0.03 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 8,961.00 6,913.35 0.00 2,047.65 22.85 10-390-546020 Uniform Cleaning 1,400.00 0.00 0.00 1,400.00 100.00 10-390-547010 Equipment Maintenance 3,075.00 3,073.88 0.00 1.12 0.04 10-390-547020 Maintenance Agreements 20,322.00 20,322.00 0.00 0.00 0.00 10-390-547030 Radio Maintenance 4,364.00 4,364.00 0.00 0.00 0.00 E25 Repairs & Maintenance 38,122.00 34,673.23 0.00 3,448.77 9.05 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,278,151.64 1,226,963.36 0.00 51,188.28 4.00 400 Fire Department 10-400-501020 Salaries 3,413,576.57 3,339,438.10 0.00 74,138.47 2.17 10-400-501030 Holiday Pay 267,630.97 267,021.05 0.00 609.92 0.23 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 33,000.00 27,570.00 0.00 5,430.00 16.45 10-400-501090 Overtime 40,000.00 39,381.25 0.00 618.75 1.55 10-400-501095 Overtime Straight Pay 37,000.00 31,402.08 0.00 5,597.92 15.13 10-400-502010 Social Security 53,115.63 49,422.96 0.00 3,692.67 6.95 10-400-502020 Group Health Insurance 566,688.25 532,155.42 0.00 34,532.83 6.09 10-400-502030 Retirement 1,639,063.50 1,562,638.45 0.00 76,425.05 4.66 10-400-502040 Workers Compensation 108,750.00 108,750.00 0.00 0.00 0.00 10-400-502050 Life Insurance 5,774.79 5,386.02 0.00 388.77 6.73 10-400-502060 Long Term Disability 9,511.67 8,855.80 0.00 655.87 6.90 10-400-502070 Employee Assistance Prgm 1,608.36 1,615.76 0.00 -7.40 -0.46 10-400-503010 Awards Program 812.00 633.21 0.00 178.79 22.02 E05 Personnel Services 6,176,531.74 5,974,270.10 0.00 202,261.64 3.27 10-400-511010 Advertising 625.92 625.92 0.00 0.00 0.00 10-400-511020 Postage 210.80 213.68 0.00 -2.88 -1.37 10-400-512010 Printing 1,079.50 1,079.50 0.00 0.00 0.00 10-400-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 955.81 955.81 0.00 0.00 0.00 10-400-514010 Gas 77,000.00 66,625.89 0.00 10,374.11 13.47 10-400-514020 Chemicals 650.00 638.14 0.00 11.86 1.82 10-400-514030 Small Tools 1,520.91 1,520.91 0.00 0.00 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 88.00 87.68 0.00 0.32 0.36 10-400-517010 Operational Supplies 7,194.00 6,802.58 0.00 391.42 5.44 E10 Materials & Supplies 89,324.94 78,550.11 0.00 10,774.83 12.06 10-400-520030 Dues And Publications 1,240.00 576.95 0.00 663.05 53.47 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 11,350.00 11,339.86 0.00 10.14 0.09 10-400-520080 Tuition Reimbursement 1,715.00 855.00 0.00 860.00 50.15 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 3,496.00 3,495.75 0.00 0.25 0.01 10-400-522020 Professional Services 900.00 900.00 0.00 0.00 0.00 10-400-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-400-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-400-529010 Special Events 6,000.00 5,936.92 0.00 63.08 1.05 10-400-529040 INACTIVE - Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 24,701.00 23,104.48 0.00 1,596.52 6.46 10-400-531010 Electricity 36,727.97 34,851.04 0.00 1,876.93 5.11 10-400-533010 Natural Gas 18,700.00 18,626.08 0.00 73.92 0.40 10-400-534010 Telephone 16,550.00 16,903.61 0.00 -353.61 -2.14 10-400-535010 WaterSewer 11,220.00 11,037.79 0.00 182.21 1.62 E20 Utilities 83,197.97 81,418.52 0.00 1,779.45 2.14 10-400-540010 Building & Grounds Maint.41,931.39 41,928.79 -2,456.84 2,459.44 5.87 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 33,480.00 32,560.58 -18,276.89 19,196.31 57.34 10-400-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-400-547010 Equipment Maintenance 19,275.00 19,256.35 0.00 18.65 0.10 10-400-547020 Maintenance Agreements 18,465.37 18,464.24 -8,674.01 8,675.14 46.98 10-400-547030 Radio Maintenance 2,000.00 1,878.45 0.00 121.55 6.08 E25 Repairs & Maintenance 115,151.76 114,088.41 -29,407.74 30,471.09 26.46 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 259,573.50 24,769.42 24,924.00 209,880.08 80.86 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 259,573.50 24,769.42 24,924.00 209,880.08 80.86 400 Fire Department 6,748,480.91 6,296,201.04 -4,483.74 456,763.61 6.77 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 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 205,628.16 202,404.46 0.00 3,223.70 1.57 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 15,730.55 14,763.44 0.00 967.11 6.15 10-520-502020 Group Health Insurance 31,736.64 28,960.64 0.00 2,776.00 8.75 10-520-502030 Retirement 40,508.75 36,635.26 0.00 3,873.49 9.56 10-520-502040 Workers Compensation 524.91 524.91 0.00 0.00 0.00 10-520-502050 Life Insurance 347.76 327.48 0.00 20.28 5.83 10-520-502060 Long Term Disability 531.84 500.81 0.00 31.03 5.83 10-520-502070 Employee Assistance Prgm 89.20 89.20 0.00 0.00 0.00 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 295,097.81 284,206.20 0.00 10,891.61 3.69 10-520-511010 Advertising 3.33 0.00 0.00 3.33 100.00 10-520-511020 Postage 134.60 83.61 0.00 50.99 37.88 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 1,050.00 981.01 0.00 68.99 6.57 10-520-514010 Gas 20,000.00 13,738.72 0.00 6,261.28 31.31 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 251.67 251.67 0.00 0.00 0.00 E10 Materials & Supplies 21,439.60 15,055.01 0.00 6,384.59 29.78 10-520-520030 Dues And Publications 376.09 374.13 0.00 1.96 0.52 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 1,090.48 0.00 409.52 27.30 10-520-522020 Professional Services 3,783.45 3,783.45 0.00 0.00 0.00 E15 Contractual Services 5,659.54 5,248.06 0.00 411.48 7.27 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 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-547020 Maintenance Agreements 550.46 550.46 0.00 0.00 0.00 E25 Repairs & Maintenance 550.46 550.46 0.00 0.00 0.00 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 322,747.41 305,059.73 0.00 17,687.68 5.48 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 56,451.84 55,270.28 0.00 1,181.56 2.09 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)11,880.00 11,160.00 0.00 720.00 6.06 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,224.45 5,081.76 0.00 142.69 2.73 10-521-502020 Group Health Insurance 5,961.16 5,324.42 0.00 636.74 10.68 10-521-502030 Retirement 10,222.69 10,003.88 0.00 218.81 2.14 10-521-502040 Workers Compensation 86.05 86.05 0.00 0.00 0.00 10-521-502050 Life Insurance 87.36 82.26 0.00 5.10 5.84 10-521-502060 Long Term Disability 145.20 136.73 0.00 8.47 5.83 10-521-502070 Employee Assistance Prgm 22.20 22.30 0.00 -0.10 -0.45 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 90,080.95 87,167.68 0.00 2,913.27 3.23 10-521-511010 Advertising 4,500.00 3,847.30 0.00 652.70 14.50 10-521-511020 Postage 700.00 601.98 0.00 98.02 14.00 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 20.00 2.24 0.00 17.76 88.80 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 610.80 0.00 389.20 38.92 10-521-514040 Food 0.00 0.00 0.00 0.00 0.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,700.00 1,077.36 0.00 622.64 36.63 E10 Materials & Supplies 7,920.00 6,139.68 0.00 1,780.32 22.48 10-521-520030 Dues And Publications 15,500.00 15,483.70 0.00 16.30 0.11 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 710.00 710.00 0.00 0.00 0.00 10-521-520080 Tuition Reimbursement 1,710.00 1,710.00 0.00 0.00 0.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 17,920.00 17,903.70 0.00 16.30 0.09 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,400.00 1,265.27 51.76 82.97 5.93 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 1,400.00 1,265.27 51.76 82.97 5.93 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 117,320.95 112,476.33 51.76 4,792.86 4.09 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 106,803.34 103,541.76 0.00 3,261.58 3.05 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 8,170.45 7,838.06 0.00 332.39 4.07 10-522-502020 Group Health Insurance 18,528.02 10,960.38 0.00 7,567.64 40.84 10-522-502030 Retirement 21,230.20 16,057.12 0.00 5,173.08 24.37 10-522-502040 Workers Compensation 206.52 206.52 0.00 0.00 0.00 10-522-502050 Life Insurance 213.36 166.23 0.00 47.13 22.09 10-522-502060 Long Term Disability 352.32 274.37 0.00 77.95 22.12 10-522-502070 Employee Assistance Prgm 44.62 44.62 0.00 0.00 0.00 E05 Personnel Services 155,548.83 139,089.06 0.00 16,459.77 10.58 10-522-511010 Advertising 1,375.00 1,353.05 0.00 21.95 1.60 10-522-511020 Postage 399.78 113.29 0.00 286.49 71.66 10-522-512010 Printing 25.00 0.00 0.00 25.00 100.00 10-522-512020 Copies 50.00 0.53 0.00 49.47 98.94 10-522-513010 Office Supplies 1,000.00 479.84 0.00 520.16 52.02 10-522-514040 Food 200.00 64.57 0.00 135.43 67.72 10-522-517010 Operational Supplies 800.00 657.82 0.00 142.18 17.77 E10 Materials & Supplies 3,849.78 2,669.10 0.00 1,180.68 30.67 10-522-520030 Dues And Publications 1,000.00 664.65 0.00 335.35 33.54 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 2,500.00 2,245.74 0.00 254.26 10.17 10-522-522020 Professional Services 24,000.00 24,000.00 0.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,500.00 26,910.39 0.00 589.61 2.14 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 325.12 0.00 1,074.88 76.78 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,400.00 325.12 0.00 1,074.88 76.78 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 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 522 Plan & Protect Svcs-MPO 188,298.61 168,993.67 0.00 19,304.94 10.25 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,138.01 56,361.73 0.00 776.28 1.36 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,371.06 3,835.40 0.00 535.66 12.25 10-530-502020 Group Health Insurance 8,609.94 6,664.99 0.00 1,944.95 22.59 10-530-502030 Retirement 11,256.19 10,201.61 0.00 1,054.58 9.37 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 105.84 90.45 0.00 15.39 14.54 10-530-502060 Long Term Disability 176.64 149.02 0.00 27.62 15.64 10-530-502070 Employee Assistance Prgm 33.30 33.46 0.00 -0.16 -0.48 E05 Personnel Services 81,690.98 77,336.66 0.00 4,354.32 5.33 10-530-511010 Advertising 250.00 0.00 0.00 250.00 100.00 10-530-511020 Postage 100.00 71.17 0.00 28.83 28.83 10-530-512010 Printing 50.00 32.00 0.00 18.00 36.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 350.00 334.98 0.00 15.02 4.29 10-530-517010 Operational Supplies 300.00 268.55 0.00 31.45 10.48 E10 Materials & Supplies 1,100.00 706.70 0.00 393.30 35.75 10-530-520030 Dues And Publications 360.50 12.07 0.00 348.43 96.65 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 1,353.35 0.00 446.65 24.81 10-530-522020 Professional Services 2,500.00 720.00 0.00 1,780.00 71.20 10-530-528085 Fair Housing Assistance Prog 1,250.00 0.00 0.00 1,250.00 100.00 E15 Contractual Services 5,910.50 2,085.42 0.00 3,825.08 64.72 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 289.50 185.82 0.00 103.68 35.81 E25 Repairs & Maintenance 289.50 185.82 0.00 103.68 35.81 10-530-550020 Neighborhood Reinvestment 45,000.00 34,479.76 0.00 10,520.24 23.38 10-530-550030 Old Town Projects 45,500.00 35,359.68 0.00 10,140.32 22.29 10-530-550031 Historic Preservation Grant 1,734.00 1,734.00 0.00 0.00 0.00 10-530-550035 Old Town Redev Committee 0.00 -15.00 0.00 15.00 0.00 10-530-550037 Historic Preservation Comm 1,000.00 171.00 0.00 829.00 82.90 10-530-550050 Neighb Stablization Prog 105,516.24 77.00 0.00 105,439.24 99.93 10-530-550060 MSP 1,105,349.09 1,007,358.94 30,580.52 67,409.63 6.10 10-530-550090 Hazard Mitigation 217,664.81 217,664.81 0.00 0.00 0.00 E30 Other Operating Expenses 1,521,764.14 1,296,830.19 30,580.52 194,353.43 12.77 530 Plan & Protect Svc-RedevGrant 1,610,755.12 1,377,144.79 30,580.52 203,029.81 12.60 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 349,817.21 328,067.02 0.00 21,750.19 6.22 10-531-501060 Seasonal Salaries 9,310.58 7,249.00 0.00 2,061.58 22.14 10-531-501090 Overtime 8,849.42 10,064.65 0.00 -1,215.23 -13.73 10-531-501095 Overtime Straight Pay 630.00 191.76 0.00 438.24 69.56 10-531-502010 Social Security 29,529.55 25,104.95 0.00 4,424.60 14.98 10-531-502020 Group Health Insurance 54,594.03 45,259.95 0.00 9,334.08 17.10 10-531-502030 Retirement 68,404.76 47,885.18 0.00 20,519.58 30.00 10-531-502040 Workers Compensation 6,952.84 6,952.84 0.00 0.00 0.00 10-531-502050 Life Insurance 580.83 489.01 0.00 91.82 15.81 10-531-502060 Long Term Disability 972.93 817.41 0.00 155.52 15.98 10-531-502070 Employee Assistance Prgm 157.11 156.96 0.00 0.15 0.10 E05 Personnel Services 529,799.26 472,238.73 0.00 57,560.53 10.86 10-531-511010 Advertising 409.88 409.88 0.00 0.00 0.00 10-531-511020 Postage 2,500.00 2,585.81 0.00 -85.81 -3.43 10-531-512010 Printing 633.00 632.52 0.00 0.48 0.08 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 937.12 867.48 0.00 69.64 7.43 10-531-514030 Small Tools 300.00 216.61 0.00 83.39 27.80 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 3,069.64 3,069.64 0.00 0.00 0.00 E10 Materials & Supplies 7,859.64 7,781.94 0.00 77.70 0.99 10-531-520030 Dues And Publications 1,437.00 958.49 0.00 478.51 33.30 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 2,500.00 1,962.25 0.00 537.75 21.51 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 29,000.00 25,417.62 0.00 3,582.38 12.35 10-531-522022 Demo 23,400.00 23,400.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 56,337.00 51,738.36 0.00 4,598.64 8.16 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 545.00 545.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 1,113.00 1,113.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,125.36 1,066.80 51.76 6.80 0.60 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,843.36 2,724.80 51.76 66.80 2.35 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 531 Plan & Protect Svcs-Build Reg 596,839.26 534,483.83 51.76 62,303.67 10.44 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 130,608.56 123,068.88 0.00 7,539.68 5.77 10-532-501060 Seasonal Salaries 3,957.00 449.00 0.00 3,508.00 88.65 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00 10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00 10-532-502010 Social Security 10,315.69 9,080.59 0.00 1,235.10 11.97 10-532-502020 Group Health Insurance 21,485.14 17,920.57 0.00 3,564.57 16.59 10-532-502030 Retirement 25,785.05 22,275.36 0.00 3,509.69 13.61 10-532-502040 Workers Compensation 1,884.50 1,884.50 0.00 0.00 0.00 10-532-502050 Life Insurance 220.08 197.90 0.00 22.18 10.08 10-532-502060 Long Term Disability 363.60 327.78 0.00 35.82 9.85 10-532-502070 Employee Assistance Prgm 55.74 55.74 0.00 0.00 0.00 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 194,955.36 175,260.32 0.00 19,695.04 10.10 10-532-511010 Advertising 145.00 0.00 0.00 145.00 100.00 10-532-511020 Postage 199.76 147.58 0.00 52.18 26.12 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 857.85 0.00 142.15 14.22 10-532-514030 Small Tools 50.00 40.85 0.00 9.15 18.30 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 30.00 24.78 0.00 5.22 17.40 10-532-517010 Operational Supplies 1,199.05 1,066.42 0.00 132.63 11.06 E10 Materials & Supplies 2,693.81 2,137.48 0.00 556.33 20.65 10-532-520030 Dues And Publications 880.00 574.00 0.00 306.00 34.77 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 799.96 714.00 0.00 85.96 10.75 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 1,155.00 157.50 997.50 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 1,000.00 -1,091.48 0.00 2,091.48 209.15 10-532-524025 Glass Recycling 10,000.00 5,170.00 440.00 4,390.00 43.90 10-532-524026 Household Hazardous Waste 18,000.00 13,871.76 -12,659.35 16,787.59 93.26 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 9,000.00 4,543.59 0.00 4,456.41 49.52 10-532-524030 Compost Services 212,000.04 212,000.04 0.00 0.00 0.00 10-532-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 252,835.00 235,939.41 -11,221.85 28,117.44 11.12 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-540060 Cemetery Maintenance 25,000.00 24,285.20 0.00 714.80 2.86 10-532-540065 Cemetery Restoration 5,000.00 4,960.00 0.00 40.00 0.80 10-532-541030 Vehicle Wash 1,290.00 1,286.00 0.00 4.00 0.31 10-532-546010 Clothing Expense 300.95 300.95 0.00 0.00 0.00 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,200.00 942.37 51.76 205.87 17.16 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 32,870.95 31,774.52 51.76 1,044.67 3.18 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 483,355.12 445,111.73 -11,170.09 49,413.48 10.22 535 Public Works-Central Maintenan 10-535-501020 Salaries 331,324.54 323,227.48 0.00 8,097.06 2.44 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,062.43 3,100.00 0.00 3,962.43 56.11 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 9,837.57 9,937.99 0.00 -100.42 -1.02 10-535-501095 Overtime Straight Pay 499.18 290.67 0.00 208.51 41.77 10-535-502010 Social Security 26,294.93 23,813.11 0.00 2,481.82 9.44 10-535-502020 Group Health Insurance 80,283.30 74,648.47 0.00 5,634.83 7.02 10-535-502030 Retirement 62,255.94 60,355.48 0.00 1,900.46 3.05 10-535-502040 Workers Compensation 4,715.54 4,715.54 0.00 0.00 0.00 10-535-502050 Life Insurance 561.12 527.76 0.00 33.36 5.95 10-535-502060 Long Term Disability 926.64 871.50 0.00 55.14 5.95 10-535-502070 Employee Assistance Prgm 178.42 178.42 0.00 0.00 0.00 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 523,939.61 501,666.42 0.00 22,273.19 4.25 10-535-511010 Advertising 80.00 25.95 0.00 54.05 67.56 10-535-511020 Postage 50.00 2.76 0.00 47.24 94.48 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 965.34 0.00 34.66 3.47 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 5,416.22 0.00 1,583.78 22.63 10-535-517010 Operational Supplies 7,500.00 5,963.21 0.00 1,536.79 20.49 E10 Materials & Supplies 15,640.00 12,373.48 0.00 3,266.52 20.89 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 199.00 0.00 1,801.00 90.05 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.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 699.00 0.00 1,801.00 72.04 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-531010 Electricity 6,001.08 6,001.08 0.00 0.00 0.00 10-535-533010 Natural Gas 8,042.06 8,042.74 0.00 -0.68 -0.01 10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-535-535010 WaterSewer 1,275.16 1,275.16 0.00 0.00 0.00 E20 Utilities 15,318.30 15,318.98 0.00 -0.68 0.00 10-535-540010 Building & Grounds Maint.9,500.00 9,241.61 25.00 233.39 2.46 10-535-541010 Veh & Equip Parts Etc 474,500.00 464,328.53 0.00 10,171.47 2.14 10-535-546010 Clothing Expense 7,000.00 5,202.40 -3,752.70 5,550.30 79.29 10-535-547010 Equipment Maintenance 3,006.86 1,339.52 0.00 1,667.34 55.45 10-535-547020 Maintenance Agreements 3,500.00 2,829.76 0.00 670.24 19.15 10-535-547030 Radio Maintenance 439.84 0.00 0.00 439.84 100.00 E25 Repairs & Maintenance 497,946.70 482,941.82 -3,727.70 18,732.58 3.76 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,055,344.61 1,012,999.70 -3,727.70 46,072.61 4.37 540 Public Works-Admin 10-540-501020 Salaries 188,433.84 189,604.59 0.00 -1,170.75 -0.62 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 14,415.19 13,342.96 0.00 1,072.23 7.44 10-540-502020 Group Health Insurance 29,833.98 27,658.29 0.00 2,175.69 7.29 10-540-502030 Retirement 35,121.47 34,318.44 0.00 803.03 2.29 10-540-502040 Workers Compensation 567.94 567.94 0.00 0.00 0.00 10-540-502050 Life Insurance 309.12 298.09 0.00 11.03 3.57 10-540-502060 Long Term Disability 462.24 435.27 0.00 26.97 5.83 10-540-502070 Employee Assistance Prgm 66.90 66.90 0.00 0.00 0.00 E05 Personnel Services 269,210.68 266,292.48 0.00 2,918.20 1.08 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 62.58 0.00 137.42 68.71 10-540-512010 Printing 200.00 97.00 0.00 103.00 51.50 10-540-512020 Copies 100.00 0.11 0.00 99.89 99.89 10-540-513010 Office Supplies 864.00 864.00 0.00 0.00 0.00 10-540-514010 Gas 128,335.70 128,198.05 0.00 137.65 0.11 10-540-514040 Food 1,000.00 697.68 0.00 302.32 30.23 10-540-517010 Operational Supplies 700.91 57.46 0.00 643.45 91.80 E10 Materials & Supplies 131,400.61 129,976.88 0.00 1,423.73 1.08 10-540-520030 Dues And Publications 1,000.00 600.20 0.00 399.80 39.98 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,968.32 836.52 0.00 1,131.80 57.50 10-540-522020 Professional Services 800.00 0.00 0.00 800.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,768.32 1,436.72 0.00 2,331.60 61.87 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 960.77 909.01 51.76 0.00 0.00 E25 Repairs & Maintenance 960.77 909.01 51.76 0.00 0.00 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 405,340.38 398,615.09 51.76 6,673.53 1.65 541 Public Works-Engineering 10-541-501020 Salaries 662,630.75 652,790.47 0.00 9,840.28 1.49 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 849.02 849.02 0.00 0.00 0.00 10-541-501095 Overtime Straight Pay 306.71 306.71 0.00 0.00 0.00 10-541-502010 Social Security 50,721.85 47,484.69 0.00 3,237.16 6.38 10-541-502020 Group Health Insurance 89,562.21 83,615.79 0.00 5,946.42 6.64 10-541-502030 Retirement 117,617.06 114,458.16 0.00 3,158.90 2.69 10-541-502040 Workers Compensation 1,204.70 1,204.70 0.00 0.00 0.00 10-541-502050 Life Insurance 1,100.40 1,038.02 0.00 62.38 5.67 10-541-502060 Long Term Disability 1,816.32 1,714.75 0.00 101.57 5.59 10-541-502070 Employee Assistance Prgm 245.32 245.32 0.00 0.00 0.00 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 926,054.34 903,707.63 0.00 22,346.71 2.41 10-541-511010 Advertising 918.55 918.55 0.00 0.00 0.00 10-541-511020 Postage 782.70 200.43 0.00 582.27 74.39 10-541-512010 Printing 498.26 498.26 0.00 0.00 0.00 10-541-512020 Copies 75.00 0.19 0.00 74.81 99.75 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 5,943.46 3,808.80 0.00 2,134.66 35.92 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 116.69 0.00 33.31 22.21 10-541-515040 First Aid Supplies 50.00 33.93 0.00 16.07 32.14 10-541-515070 Const & Inspect Supplies 2,000.00 319.50 0.00 1,680.50 84.03 10-541-515080 Surveying Supplies 2,000.00 620.27 0.00 1,379.73 68.99 10-541-517010 Operational Supplies 1,205.91 1,205.91 0.00 0.00 0.00 E10 Materials & Supplies 13,823.88 7,722.53 0.00 6,101.35 44.14 10-541-520030 Dues And Publications 4,000.00 1,943.80 0.00 2,056.20 51.41 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,500.00 2,850.24 0.00 1,649.76 36.66 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 3,044.27 484.00 0.00 2,560.27 84.10 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-522055 Stormwater Compliance 1,500.00 1,111.03 0.00 388.97 25.93 E15 Contractual Services 13,044.27 6,389.07 0.00 6,655.20 51.02 10-541-534010 Telephone 1,000.00 414.22 0.00 585.78 58.58 E20 Utilities 1,000.00 414.22 0.00 585.78 58.58 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 969.00 0.00 31.00 3.10 10-541-546010 Clothing Expense 1,000.00 625.54 0.00 374.46 37.45 10-541-547010 Equipment Maintenance 1,500.00 843.12 0.00 656.88 43.79 10-541-547020 Maintenance Agreements 13,000.00 9,577.54 51.76 3,370.70 25.93 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 16,500.00 12,015.20 51.76 4,433.04 26.87 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 970,422.49 930,248.65 51.76 40,122.08 4.13 542 Public Works-Street 10-542-501020 Salaries 1,010,882.92 996,842.95 0.00 14,039.97 1.39 10-542-501060 Seasonal Salaries 22,820.02 22,820.02 0.00 0.00 0.00 10-542-501070 Stand-by Plan 4,081.31 4,208.00 0.00 -126.69 -3.10 10-542-501090 Overtime 63,723.40 63,705.01 0.00 18.39 0.03 10-542-501095 Overtime Straight Pay 1,000.00 265.41 0.00 734.59 73.46 10-542-502010 Social Security 80,893.69 79,361.93 0.00 1,531.76 1.89 10-542-502020 Group Health Insurance 157,122.47 145,277.46 0.00 11,845.01 7.54 10-542-502030 Retirement 189,267.42 185,666.76 0.00 3,600.66 1.90 10-542-502040 Workers Compensation 26,942.26 26,942.26 0.00 0.00 0.00 10-542-502050 Life Insurance 1,700.04 1,609.00 0.00 91.04 5.36 10-542-502060 Long Term Disability 2,785.20 2,633.50 0.00 151.70 5.45 10-542-502070 Employee Assistance Prgm 524.10 524.10 0.00 0.00 0.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,562,192.83 1,529,856.40 0.00 32,336.43 2.07 10-542-511010 Advertising 354.08 354.08 0.00 0.00 0.00 10-542-511020 Postage 150.00 144.52 0.00 5.48 3.65 10-542-512010 Printing 50.08 0.00 0.00 50.08 100.00 10-542-512020 Copies 50.69 42.83 0.00 7.86 15.51 10-542-513010 Office Supplies 1,323.68 1,095.78 0.00 227.90 17.22 10-542-514020 Chemicals 475,000.00 473,730.88 -224,321.24 225,590.36 47.49 10-542-514030 Small Tools 8,696.48 8,034.08 0.00 662.40 7.62 10-542-514040 Food 1,037.84 1,037.84 0.00 0.00 0.00 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-515020 Street Materials 274,750.00 247,397.53 -20,742.78 48,095.25 17.51 10-542-515040 First Aid Supplies 500.00 315.50 0.00 184.50 36.90 10-542-515060 Weed Control 1,500.00 1,489.50 0.00 10.50 0.70 10-542-515070 Const & Inspect Supplies 152.75 0.00 0.00 152.75 100.00 10-542-517010 Operational Supplies 5,000.00 4,532.97 0.00 467.03 9.34 E10 Materials & Supplies 768,565.60 738,175.51 -245,064.02 275,454.11 35.84 10-542-520030 Dues And Publications 584.00 527.00 0.00 57.00 9.76 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 1,689.50 692.39 0.00 997.11 59.02 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,378.50 14,938.50 440.00 0.00 0.00 10-542-523010 Equipment Rentlease 155.00 60.00 0.00 95.00 61.29 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,807.00 16,217.89 440.00 1,149.11 6.45 10-542-531010 Electricity 25,000.00 24,773.89 0.00 226.11 0.90 10-542-531020 Street Lights 527,900.00 615,327.70 0.00 -87,427.70 -16.56 10-542-533010 Natural Gas 16,408.84 14,267.64 0.00 2,141.20 13.05 10-542-534010 Telephone 500.00 357.75 0.00 142.25 28.45 10-542-535010 WaterSewer 6,296.18 6,296.18 0.00 0.00 0.00 E20 Utilities 576,105.02 661,023.16 0.00 -84,918.14 -14.74 10-542-540010 Building & Grounds Maint.6,239.86 6,060.39 50.00 129.47 2.07 10-542-541030 Vehicle Wash 6,840.00 6,840.00 0.00 0.00 0.00 10-542-542010 Repairs - Stop Lights 10,000.00 7,411.06 0.00 2,588.94 25.89 10-542-542030 Signs & Marking Paint 35,339.98 35,339.98 0.00 0.00 0.00 10-542-546010 Clothing Expense 10,000.00 10,094.31 0.00 -94.31 -0.94 10-542-547010 Equipment Maintenance 2,806.24 2,781.08 0.00 25.16 0.90 10-542-547020 Maintenance Agreements 500.00 333.36 0.00 166.64 33.33 10-542-547030 Radio Maintenance 1,033.90 1,033.90 0.00 0.00 0.00 E25 Repairs & Maintenance 72,759.98 69,894.08 50.00 2,815.90 3.87 10-542-572010 Purchase Of Vehicles 0.00 15,000.00 0.00 -15,000.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 15,000.00 0.00 -15,000.00 0.00 542 Public Works-Street 2,997,430.43 3,030,167.04 -244,574.02 211,837.41 7.07 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 1,515.57 0.00 2,484.43 62.11 10-700-590070 Airport Subsidy 170,789.16 170,789.16 0.00 0.00 0.00 10-700-590075 Transit Subsidy 363,990.70 363,990.70 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E80 Transfers Out 538,779.86 536,295.43 0.00 2,484.43 0.46 700 Transfers & Subsidies 538,779.86 536,295.43 0.00 2,484.43 0.46 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-577042 Mo Blvd Sidewalks 75,447.33 75,447.33 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 465,460.00 11,170.40 297,799.11 156,490.49 33.62 10-990-577045 Clay Street Plaza 72,800.00 0.00 72,800.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 787,707.00 69,511.31 16,609.04 701,586.65 89.07 E75 Capital Projects 1,401,414.33 156,129.04 387,208.15 858,077.14 61.23 990 Capital Projects 1,401,414.33 156,129.04 387,208.15 858,077.14 61.23 Expense Expense 33,603,480.93 30,268,671.40 207,185.01 3,127,624.52 9.31 GL - Trial Balance by Acct Type and Full Acct Number (11/05/2014 - 7:57 AM)Page 35 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 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge 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 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) 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/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Nov-13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 1/2014 Interest Received (8.28) 1/2014 Service Charge Dec-13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 2/2014 Interest Received (8.28) 2/2014 Service Charge Jan-14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) Ck #1007 - C H Johnson Consulting 2,078.72 3/2014 Interest Received (8.45) 3/2014 Service Charge Feb-14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 4/2014 Interest Received (8.28) 4/2014 Service Charge Mar-14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 5/2014 Interest Received (8.29) 5/2014 Service Charge Apr-14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 6/2014 Interest Received (8.29) 6/2014 Service Charge May-14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 7/2014 Interest Received (8.29) 7/2014 Service Charge Jun-14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 8/2014 Interest Received (8.29) 8/2014 Service Charge Jul-14 8/20/14 98,901.39 41,538.58 55,384.78 2,459.73 9/2014 Interest Received (8.29) 9/2014 Service Charge Aug-14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 10/2014 Interest Received (8.29) 10/2014 Service Charge Sep-14 10/20/14 112,370.02 47,195.41 62,927.21 Total 3,713,166.29 1,559,529.84 2,081,296.73 average monthly amount for 4 cent lockbox fund 50,716.42$ 2014 Occupancy 2013 Occupancy 2012 Occupancy January 49.20%45.30%38.20% February 56.00%52.90%49.80% March 59.30%52.90%54.90% April 63.70%64.10%53.90% May 64.70%56.80%53.70% June 63.70%55.70%53.10% July 59.70%58.50%51.40% August 54.20%55.80%47.00% September 61.20%63.00%59.30% October 65.90%59.30% November 52.40%43.40% December 38.80%33.00% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: September 2014 Percent Change from September 2013 Percent Change from YTD 2013 2014 2013 2014 2013 2014 2013 Occ ADR RevPAR Room Rev Room Avail Room Sold 2014 2013 2014 2013 2014 2013 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 65.7 63.2 117.17 111.26 76.97 70.32 3.9 5.3 9.5 10.5 0.9 4.9 65.9 63.7 115.49 110.47 76.14 70.40 3.5 4.5 8.2 9.1 0.8 4.3 53251 30831 4965379 3571739 West North Central 65.1 63.7 92.22 88.22 60.00 56.24 2.1 4.5 6.7 8.5 1.7 3.8 61.3 59.2 90.78 87.02 55.66 51.53 3.5 4.3 8.0 9.4 1.3 4.9 4474 2565 346890 247122 Missouri 60.0 59.3 92.79 87.64 55.71 52.01 1.2 5.9 7.1 7.8 0.6 1.8 59.1 56.4 90.22 85.57 53.28 48.24 4.8 5.4 10.5 10.3 -0.2 4.6 1128 622 102629 71586 Kansas City, MO-KS 64.7 62.5 91.50 88.10 59.20 55.07 3.5 3.9 7.5 6.8 -0.6 2.9 63.6 59.6 90.28 86.92 57.44 51.80 6.8 3.9 10.9 10.4 -0.4 6.3 290 220 31951 26684 St Louis, MO-IL 68.8 67.2 99.86 93.71 68.73 63.01 2.4 6.6 9.1 9.7 0.6 3.0 66.1 63.4 96.50 90.45 63.79 57.37 4.2 6.7 11.2 10.8 -0.3 3.9 328 232 38033 31192 Columbia, MO+59.2 60.4 91.40 84.01 54.15 50.79 -2.0 8.8 6.6 13.4 6.3 4.2 58.6 60.0 82.33 76.17 48.21 45.69 -2.4 8.1 5.5 9.5 3.8 1.3 38 29 3886 3253 Jefferson City, MO+61.2 63.0 75.64 70.79 46.28 44.61 -2.9 6.8 3.7 3.7 0.0 -2.9 59.1 56.1 74.24 68.44 43.85 38.41 5.2 8.5 14.2 15.3 1.0 6.3 15 11 1494 1063 Springfield, MO 55.4 55.9 77.65 72.20 43.05 40.37 -0.9 7.5 6.6 3.2 -3.2 -4.0 57.7 54.1 76.33 72.53 44.06 39.25 6.7 5.2 12.3 8.6 -3.2 3.2 66 44 5995 4311 Branson, MO 44.0 41.6 95.41 90.79 41.94 37.81 5.6 5.1 10.9 11.0 0.1 5.6 43.9 39.3 94.63 89.88 41.55 35.32 11.7 5.3 17.6 15.7 -1.6 9.9 155 36 14159 5025 Lake of the Ozarks+51.0 49.4 98.45 96.59 50.19 47.72 3.2 1.9 5.2 5.2 0.0 3.2 48.0 47.3 99.11 96.92 47.53 45.87 1.3 2.3 3.6 4.0 0.3 1.7 38 10 2807 1433 Joplin, MO 62.9 56.5 72.16 67.90 45.37 38.39 11.2 6.3 18.2 18.2 0.0 11.2 59.7 54.2 71.30 69.34 42.54 37.56 10.1 2.8 13.3 13.3 0.0 10.1 34 24 2713 2275 A blank row indicates insufficient data.Source 2014 STR, Inc. Participation Occ % Current Month - September 2014 vs September 2013 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. RevPARADROcc % Year to Date - September 2014 vs September 2013 RoomsRevPARPropertiesADR Account Number Line Item 2014 Budget Proposed 2015 Budget 2014-2015 Comparison % Change Revenue 4100 Room Tax 456,785.21$ 465,920.91$ 9,135.70$ 1.96% 4200 Interest Earning 600.00$ 360.00$ (240.00)$ -66.67% 4300 Advertising Cooperative 39,511.91$ 32,474.00$ (7,037.91)$ -21.67% 4350 Special Events 8,700.00$ 9,300.00$ 600.00$ 6.45% 4500 Fundraising Athletic Events Revenue 14,000.00$ 15,000.00$ 1,000.00$ 6.67% 4550 Prison Tour Ticket Sales 210,000.00$ 226,029.43$ 16,029.43$ 7.09% 4600 Grant Support -$ 4700 Advertising Cooperative 1,700.00$ 2,225.00$ 525.00$ 23.60% 4801 Jefferson City Promotional Item Sales $ 43,000.00 43,000.00$ -$ 0.00% 4900 Miscellaneous Revenue 2,000.00$ 5,000.00$ 3,000.00$ 60.00% 4950 Jefferson City Outdoors 5,200.00$ 2,000.00$ (3,200.00)$ -160.00% Total Revenue 781,497.12$ 801,309.34$ 19,812.22$ 2.47% Payroll Expenses 6100 Salaries and Wages 202,000.00$ 213,000.00$ 11,000.00$ 5.16% 6110 Temporary/Part-Time Wages 1,200.00$ 1,200.00$ -$ 0.00% 6120 Retirement Benefits 3,200.00$ 3,400.00$ 200.00$ 5.88% 6130 Payroll Taxes 17,500.00$ 18,500.00$ 1,000.00$ 5.41% 6140 Insurance Benefits 29,100.00$ 30,100.00$ 1,000.00$ 3.32% Total Payroll Expenses $253,000.00 266,200.00$ 33%13,200.00$ 4.96% Adminsitrative and General Expenses 6200 Auditing and Accounting 19,400.00$ 18,900.00$ (500.00)$ -2.65% 6210 Bulding Rental 36,000.00$ 36,000.00$ -$ 0.00% 6211 Building Maintenance 5,000.00$ 5,000.00$ -$ 0.00% 6211 Building Utilities 9,600.00$ 8,200.00$ (1,400.00)$ -17.07% 6212 Cleaning Services 3,300.00$ 1,500.00$ (1,800.00)$ -120.00% 6213 Security Monitoring 275.00$ 275.00$ -$ 0.00% 6220 Computer Support/Service 5,920.00$ 6,320.00$ 400.00$ 6.33% 6230 Consulting 500.00$ 500.00$ -$ 0.00% 6240 Dues and Subscriptions 4,935.00$ 1,705.00$ (3,230.00)$ -189.44% 6245 Depreciation Expense 10,569.96$ 10,569.96$ -$ 0.00% 6250 Office Equip Lease & Repair 3,600.68$ 3,600.00$ (0.68)$ -0.02% 6260 Insurance Premiums 3,816.00$ 4,564.00$ 748.00$ 16.39% 6270 Minor Office Furniture 500.00$ 500.00$ -$ 0.00% 6280 Expenses 2,340.00$ 2,590.00$ 250.00$ 9.65% 6285 Promotional Items to sell 21,000.00$ 19,000.00$ (2,000.00)$ -10.53% 6290 Parking Fee 3,720.00$ 3,720.00$ -$ 0.00% 6300 Office Supplies 1,800.00$ 1,600.00$ (200.00)$ -12.50% 6310 Printing and Binding 400.00$ 400.00$ -$ 0.00% 6320 Telephone and Fax 7,940.00$ 8,824.40$ 884.40$ 10.02% 6330 Training and Education 1,260.00$ 1,390.00$ 130.00$ 9.35% Total Administrative and General Expense 141,876.64$ 135,158.36$ 17%(6,718.28)$ -4.97% Marketing Expenses 6340 Travel Expenses 11,860.00$ 10,500.00$ (1,360.00)$ -12.95% 6361 MSP Salaries and Wages 123,251.16$ 123,251.16$ -$ 0.00% 6362 MSP Internet Marketing 6,210.00$ 9,150.00$ 2,940.00$ 32.13% 6363 MSP Credit Card Fees 12,000.00$ 10,000.00$ 3,790.00$ 37.90% 6364 MSP Handy John 1,962.00$ -$ (1,962.00)$ 6365 MSP/Museum Insurance 1,520.00$ -$ (1,520.00)$ 6366 MSP Misc. Expense 11,000.00$ 10,182.00$ (818.00)$ -8.03% 6367 MSP Advertising 6,029.82$ 15,530.07$ 9,500.25$ 61.17% 6400 Graphic Design 2,500.00$ 2,500.00$ -$ 0.00% 6410 Outdoor Advertising 16,000.00$ 24,000.00$ 8,000.00$ 33.33% 6420 Wayfinding Signage 6430 Brochures/Printed Material 8,000.00$ 9,000.00$ 1,000.00$ 11.11% 6440 Postage and Freight 8,000.00$ 8,000.00$ -$ -$ 6461 Marketing Memberships 1,670.00$ 4,570.00$ 2,900.00$ 63.46% 6470 Print Advertising 28,913.00$ 42,557.75$ 13,644.75$ 32.06% 6480 Broadcast Advertising 6490 Marketing Research 11,500.00$ -$ (11,500.00)$ 6500 Promotion/Publicity 4,350.00$ 3,750.00$ (600.00)$ -16.00% 6510 Sponsorship 15,000.00$ 21,500.00$ 6,500.00$ 30.23% 6520 Tradeshow Fees 15,279.00$ 12,551.00$ (2,728.00)$ -21.74% 6530 Familiarization tour expense 1,000.00$ 1,000.00$ -$ 0.00% 6540 Marketing Promo 1,885.00$ 3,010.00$ 1,125.00$ 37.38% 6545 Public Relations 22,000.00$ 27,500.00$ 5,500.00$ 20.00% 6550 Internet Marketing 33,715.00$ 16,425.00$ (17,290.00)$ -105.27% 6560 Local Promotions 2,000.00$ 2,000.00$ -$ 6620 Special Events 4,600.00$ 5,526.00$ 926.00$ 16.76% 6630 Athletic Events Exp - CVB 11,610.00$ 14,948.00$ 3,338.00$ 22.33% 6640 Athletic Events Committee Exp 13,765.50$ 14,500.00$ 734.50$ 5.07% Total Marketing 375,620.48$ 391,950.98$ 49%16,330.50$ 4.17% Contracted Services 6610 Contracted Services & Exp -$ -$ Total Contracted Services -$ -$ 0% Capital Expenses 6700 Office Furniture & Equip -$ 6710 Computer Hardware 11,000.00$ 8,000.00$ (3,000.00)$ -37.50% 6720 Other Equip -$ 6730 Other Bldg improvements -$ Total Capital Expenses $11,000.00 8,000.00$ 1%(3,000.00)$ -37.50% Total Bureau Expenses $781,497.12 $801,309.34 100%$19,812.22 2.47% Proposed 2015 Budget CVB Board review Sept 29, 2014 Account number Line Item 2015 Budget Explanation of Account Codes Revenue 4100 Room Tax (2% incresase)465,920.91$ Monthly lodging tax revenues 4200 Interest Earning 360.00$ *based on 2014 numbers 4300 Advertising Cooperative 32,474.00$ 64,948.00$ FY15 Coop 1,288.00$ St. Louis Magazine 1st quarter(Mar issue) FY15 Coop 769.00$ Misouri Life 1st quarter (Feb-Mar issue) FY15 Coop 1,288.00$ St. Louis Magazine 2nd quarter (June issue) FY15 Coop 1,127.00$ Missour Life 2nd quarter (Apr-May issue) FY15 Coop 2,021.00$ Missour Life 2nd quarter (June-July issue) FY15 Coop 5,455.00$ Madden Insert Spring (April-June) FY15 Coop 4,000.00$ Porlier Outdoor Advertising 2 billboards Mar-June FY15 Coop 4,000.00$ DDI Media 2 billboards Mar-June FY16 Coop (pending)6,000.00$ Porlier Outdoor Advertising 2 billboards Jul-Dec FY16 Coop (pending)6,000.00$ DDI Media 2 billboards Jul-Dec FY16 Coop (pending)2,635.00$ Madden Fall insert FY16 Coop (pending)22,865.00$ Misc projected advertising FY16 Coop (pending)7,500.00$ Facebook Advertising 4350 Special Events 9,300.00$ 1,500.00$ Corvette Classic 3,800.00$ State Track hotel rebates 3,000.00$ Bags Campaign 1,000.00$ misc events 4500 Fundraising Athletic Events Revenue $15,000.00 15,000.00$ Eagles fundraiser 4550 Prison Tour Ticket Sales 226,029.43$ 226,029.43$ Prison tour ticket sales Proposed 2015 Budget CVB Board review Sept 29, 2014 4600 Grant Support -$ 4700 Advertising Revenue 2,225.00$ 1,725.00$ MSP postcards and Hand fans 500.00$ Misc 4801 Jefferson City Promotional Item Sales 43,000.00$ 43,000.00$ CVB and MSP Promotional Items 4900 Miscellaneous Revenue 5,000.00$ 400.00$ Salute to America Lunches 4,600.00$ Misc. revenue 4950 Jefferson City Outdoors 2,000.00$ 2,000.00$ Prison Break Total Revenue 801,309.34$ Payroll Expenses 6100 Salaries and Wages 213,000.00$ 213,000.00$ CVB Staff 6110 Temporary/Part Time Wages 65%1,200.00$ 1,200.00$ Weekend Desk Coverage and Summer Intern 6120 Retirment Benefits 3,400.00$ 3,400.00$ Simple Retirment Plan 3% 6130 Payroll Taxes 18,500.00$ 18,500.00$ includes Medicare, federal and state employement taxes 6140 Insurance Benefits 30,100.00$ 30,100.00$ Anthem Blue Corss / ACCE Benefits Trust Total Payroll 266,200.00$ 33% Proposed 2015 Budget CVB Board review Sept 29, 2014 Administrative and General Expenses 6200 Auditing and Accounting 18,900.00$ 14,400.00$ Monthly Accounting and Payroll services $1,200 per month 4,500.00$ Annual audit 6210 Building Rental 36,000.00$ 36,000.00$ Missouri Optometric Assn. 6211 Building Maintenace 5,000.00$ $5,000.00 Office Maintenance 6211 Building Utilities $8,200.00 $8,200.00 Utilities 6212 Cleaning Service 1,500.00$ 1,500.00$ office cleaning services 6213 Security Monitoring 275.00$ 275.00$ Maintenance contract 6220 Computer Support/Software 6,320.00$ 900.00$ Infotrac annual support 1,920.00$ CVB Leads annual support 300.00$ Inquiry + annual support 3,200.00$ Computer support 6230 Consulting 500.00$ 500.00$ Legal services 6240 Dues and Subscriptions 1,705.00$ 500.00$ Miscellanous Pay in January 550.00$ ACCE Annual membership Pay in June 150.00$ Downtown Jefferson City 40.00$ Eastside Business Association 50.00$ Westside Business Association Pay in September 300.00$ Jefferson City Chamber of Commerce 115.00$ News Tribune Annual Subscription 6245 Depreciation Expense 10,569.96$ ($880.83 monthly) Proposed 2015 Budget CVB Board review Sept 29, 2014 6250 Office Equipment Lease and Repair $3,600.00 pay June $871.20 KOPI service aggreement pay July $650.00 additional copies $1,451.16 monthly payments - $120.93 $627.64 misc expenses 6260 Insurance Premiums 4,564.00$ pay in April 1,830.00$ Worker's Comp pay in April 1,100.00$ Director & Officers Liability pay in April 1,634.00$ Commercial Package/Umbrella 6270 Minor Office Furniture 500.00$ Misc. expenses 6280 Expenses 2,590.00$ 100.00$ Post office box ($100.00 per year) 20.00$ Annual Business License/Registration 250.00$ Board Retreat 700.00$ Holiday Luncheon - Diplomats & Comm 200.00$ Board of Directors gifts 120.00$ ACH Payroll processing charge 100.00$ Staff Holiday Party 100.00$ Salute to America Lunches 1,000.00$ Miscellanous (job advertisment, cards) 6285 Promotional Items to sell 19,000.00$ JC and MSP items to sell 6290 Parking Fee 3,720.00$ CVB parking for 6 staff 6300 Office Supplies 1,600.00$ General Office supplies 6310 Printing and Binding 400.00$ Business Cards-inhouse printing projects 6320 Telphone service 8,824.40$ 374.40$ telephone system maintenance 8,450.00$ monthly telephone charges 6330 Training and Education 1,390.00$ 240.00$ MACVB - 2 ppl @120.00 650.00$ Gov.'s Conf. on Tourism 500.00$ staff training and educational seminars Total Administrative and General Expenses 135,158.36$ 17.00% Marketing Proposed 2015 Budget CVB Board review Sept 29, 2014 6340 Travel Expenses 10,500.00$ 5,000.00$ Local and miscellanous travel 875.00$ Locations conference October 850.00$ TEAMS- travel for Tradeshow 800.00$ Travel South January 400.00$ American Bus Assn. St. Louis March 300.00$ QCCA Flower Show 800.00$ Your Military Connection March 375.00$ Johnson County Garden Show 200.00$ Travel Talks, Kansas City 400.00$ Missouri Bank Travel Exchange 500.00$ MACVB Annual Conference 6360 MSP Tour Expenses 10,182.00$ 1,602.00$ Jobsite 360.00$ Allied Waste 1,720.00$ MSP and Museum insur, (Winter Dent) 2,000.00$ Water 4,500.00$ Misc Expense for MSP and museum 6361 MSP Salaries & Wages 123,251.16$ 123,251.16$ salary, payroll taxes, insur. & ret. 6362 MSP Internet Marketing 9,150.00$ 130.00$ Website Hosting (MSP and Museum) 20.00$ Domain Name Reg.(MSP and Museum 9,000.00$ SEM Internet marketing FY16 Coop 3,750.00$ Facebook Advertising 2,500.00$ Madden Rich Media Spring 6363 MSP Credit Card Fees 10,000.00$ 10,000.00$ Based on credit card sales and MSP ticket res. System 6367 MSP Advertising 15,530.07$ 1,029.82$ MSP Brochure 5,600.00$ Misc. Advertising projects FY15 Coop 1,288.00$ St. Louis Magazine 1st quarter(Mar issue) FY15 Coop 769.00$ Misouri Life 1st quarter (Feb-Mar issue) FY15 Coop 1,127.00$ Missouri Life 2nd quarter (Apr-May issue) summer/MSP FY16 Coop 5,716.25$ Misc. Advertising print projects 6400 Graphic Design 2,500.00$ Proposed 2015 Budget CVB Board review Sept 29, 2014 2,500.00$ Miscellaneous (MSP and CVB projects) 6410 Outdoor Advertising $24,000.00 $2,000.00 CVB Billboard Porlier (Jan and Feb) $2,000.00 CVB Billboard DDI (Jan-Feb) FY15 Coop 4,000.00$ Porlier Outdoor Advertising 2 billboards Mar-June FY15 Coop 4,000.00$ DDI Media 2 billboards Mar-June FY16 Coop (pending)6,000.00$ Porlier Outdoor Advertising 2 billboards Jul-Dec FY16 Coop (pending)6,000.00$ DDI Media 2 billboards Jul-Dec 6420 Wayfinding Signage $0 6430 Brochures and Printed Materials 9,000.00$ 9,000.00$ misc. brochures 6440 Postage 8,000.00$ 8,000.00$ Postage charges 6461 Marketing Memberships 4,570.00$ pd in February 400.00$ Society of Gov. Meeting Professionals 700.00$ National Assoc. of Sports Commissions 145.00$ Missouri Society of Assoc Executives 75.00$ Missouri Motion Media Association pay January 225.00$ Missouri Travel Council pay January $ 1,050.00 Missouri Association of Convention * Visitors Bureau pay May 1,075.00$ Destination Marketing Intl. pay January 400.00$ Society of Gov. Meeting Professionals pay June 250.00$ Missouri Hotel and Lodging Assn 250.00$ Your Military Reunion Connection 6470 Print Advertising 42,557.75$ pay December 2015 6,010.00$ Missouri Travel Guide (January 2016 issue) FY15 Coop 1,288.00$ St. Louis Magazine 2nd quarter (June issue) Salute FY15 Coop 2,021.00$ Missour Life 2nd quarter (June-July issue) Salute FY15 Coop 5,455.00$ Madden Insert Spring (April-June) FY16 Coop (pending)2,635.00$ Madden Fall insert FY16 Coop (pending)17,148.75$ Misc projected print advertising 8,000.00$ Misc. print advertisements Proposed 2015 Budget CVB Board review Sept 29, 2014 6490 Market Research 0 6500 Promotion/Publicity 3,750.00$ $ 2,500.00 Miscellanous(flowers for building, cards, community events) 700.00$ Lunches with meeting planners/business and community leaders 350.00$ cookies for conventionservices and "Thank You" 200.00$ AEC tickets for CVB staff 6510 Sponsorships 21,500.00$ 5,000.00$ Salute to America 16,500.00$ Misc Event sponsorships 6520 Tradeshows Fees 12,551.00$ 3,000.00$ TEAMS 1,007.00$ Johnson Co. Home & Garden Show, Overland Park, KS 494.00$ QCCA Flower & Garden Show, Rock Island, IL 285.00$ Missouri Bank Travel 395.00$ Travel Talk, KC (Fall) 375.00$ Joint Meeting Planners Tradeshow 695.00$ Your Military Reunion Connection 300.00$ MSAE Funfest 1,000.00$ AAA Travel Show, Columbus, Ohio 5,000.00$ Miscellanous Tradeshows 6530 Familiarization (FAM) Tour Expenses 1,000.00$ 1,000.00$ Event/Mtg Planners/Travel Writers visits 6540 Marketing Promo 3,010.00$ 1,700.00$ Misc Gift baskets 50.00$ MSAE and SGMP Holiday Baskets 100.00$ MSAE Holiday Dinner 40.00$ SGMP Holiday Dinner 120.00$ MTC Capitol Days (4 people) 1,000.00$ Misc. convention services 6545 Public Relations 27,500.00$ 13,750.00$ MSP w/ Beenders Walker 13,750.00$ CVB w/ Beenders Walker Proposed 2015 Budget CVB Board review Sept 29, 2014 6550 Internet Marketing 16,425.00$ 260.00$ Annual Hosting 110.00$ Domain name registration 805.00$ Constant Contact Subscription 9,000.00$ SEM Internet Marketing - Madden Media FY16 Coop 3,750.00$ Facebook advertising (July - Oct) 2,500.00$ Madden Rich Media (Spring) 6560 Local Promotion 2,000.00$ 2,000.00$ Local events 6620 Special Events 5,526.00$ 600.00$ Corvette Classic 500.00$ Bags Campaign 1,000.00$ Prison Break 3,426.00$ Misc. events 6630 Athletic Events Expenses - CVB 14,948.00$ State Track Expenses 8,000.00$ Lincoln Univ. Track Rental 928.00$ Breakfast through Lincoln Univ 2,200.00$ D& K Transportation 520.00$ MSHSAA official rooms 1,200.00$ refreshments 200.00$ Holiday reception Cross Country Expenses 1,100.00$ Elks Lodge Breakfast for officials 600.00$ Shuttle service 200.00$ Misc expenses 6640 Athletic Events Committee Expenses 14,500.00$ AEC Fundraiser 3,000.00$ Petty Cash 2,060.00$ Auction Merchandise 2,550.00$ Eagles 155.00$ Thank you Ad State Track Expenses 616.00$ Refreshments (ice) 4,400.00$ Lunch for officials Sponsorships 1,600.00$ misc. event sponsorships 119.00$ Misc. expenses Proposed 2015 Budget CVB Board review Sept 29, 2014 Total Marketing Expenses 391,950.98$ 49% Contracted Services 6610 Contracted Services and Expenses Capital Expenses 6700 Office Furniture and Equipment 6710 Computer Hardware 8,000.00$ Total Capital Expenses 8,000.00$ 6800 Contigency Total Bureau Expenses 801,309.34$