Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
20131022 finance packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Tuesday, October 22, 2013 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 24, 2013 meeting. 4. Financial Reports – Bill Betts 5. Conference Center Funding – Bill Betts 6. FY2015 Budget Discussion – Bill Betts 7. Lodging Tax Report – Shiela Pearre 8. Benefits Presentation – Gail Strope 9. New Business 10. Old Business 11. 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 process the request. CITY OF JEFFERSON Finance Committee Meeting Tuesday, September 24, 2013 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Shawn Schulte at 7:30 AM. Roll call showed that Councilmen Schulte, Graham, Prather, Scrivner and Bray were in attendance. Councilman Graham was absent. The minutes of the April 15, 2013 meeting and the July 23, 2013 meeting were reviewed and a motion to approve both was made by Councilman Scrivner and seconded by Councilman Prather. The minutes were approved unanimously. The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the Financial Reports. Information provided included September sales tax figures, year-to-date general ledger account information, the current fund balance calculation, and the July financial report. The next item on the agenda was a report by the Interim Finance Director, Bill Betts, covering Conference Center funding. Reports from Piper Jaffray & Co. were provided to the Committee. The next item on the agenda was a report by the 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% is $1,318,756.72. The average monthly amount collected for the Conference Center Fund is $48,842.84. The next item on the agenda was a presentation by Assistant City Counselor, Jeremy Cover, regarding the purchase of 215 Pine Street, Jefferson City, MO. After some discussion, a motion was made by Councilman Scrivner and seconded by Councilman Prather to recommend purchase and move to full council. The motion passed unanimously. The next item on the agenda was a discussion led by City Counselor, Drew Hilpert, regarding an Economic Incentives Ordinance. This item has been discussed several times and Mr. Hilpert wanted to point out some modifications that have been made since the last discussion. This is scheduled to be included in a future Council work session. The next item on the agenda was a discussion led by Mr. Hilpert regarding settlement with ALPLA over their previous request for the GRUT exemption. A motion was made by Councilman Prather and seconded by Councilman Scrivner to move this issue on to full council and recommend a 50/50 split in payment between the General Fund and the Capital Improvements Sales Tax Fund. The next item on the agenda was New Business. Councilman Schulte requested Human Resources Director, Gail Strope, make a presentation at the next meeting about employee benefits as there are several new members on the Finance Committee. There was no Old Business to discuss. A motion to adjourn took place at 8:36 AM. As recorded by: Shiela Pearre, Chief Accountant Memo To:Drew Hilpert From:Shiela Pearre Date:October 8, 2013 Re:Sales Tax Revenues The City received the October 1% Sales Tax in the amount of $717,262 which is $51,867 less than projected for October. January through October shortage is $55,734 (0.57%) in the General Fund. 1% General Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-12 Jan-13 $764,659 $764,659 $0 Dec-12 Feb-13 $703,181 $703,181 $0 Jan-13 & Oct-Dec 12 Qtrly Mar-13 $992,559 $1,008,111 $15,552 Feb-13 Apr-13 $852,412 $777,424 ($74,988) Mar-13 May-13 $567,215 $537,141 ($30,074) Apr-13 & Jan-Mar 13 Qtrly Jun-13 $1,028,514 $1,023,015 ($5,499) May-13 Jul-13 $797,780 $872,436 $74,656 Jun-13 Aug-13 $557,032 $546,351 ($10,681) Jul-13 & Apr-June 13 Qtrly Sep-13 $1,069,414 $1,096,581 $27,167 Aug-13 Oct-13 $769,129 $717,262 ($51,867) Sep-13 Nov-13 $615,421 $0 Oct-13 & Jul-Sept 13 Qtrly Dec-13 $982,684 $0 Total Overage/Shortfall ($55,734) 1/2% Capital Improvement Tax Receipt Budget Actual Period Projection Receipts Variance Nov-12 Jan-13 $416,244 $372,459 ($43,785) Dec-12 Feb-13 $311,418 $350,813 $39,395 Jan-13 & Oct-Dec 12 Qtrly Mar-13 $471,169 $475,110 $3,941 Feb-13 Apr-13 $413,147 $372,340 ($40,806) Mar-13 May-13 $266,340 $266,422 $82 Apr-13 & Jan-Mar 13 Qtrly Jun-13 $499,328 $483,070 ($16,258) May-13 Jul-13 $393,021 $425,325 $32,305 Jun-13 Aug-13 $280,801 $272,603 ($8,199) Jul-13 & Apr-June 13 Qtrly Sep-13 $508,966 $521,260 $12,294 Aug-13 Oct-13 $370,760 $357,619 ($13,141) Sep-13 Nov-13 $268,825 $0 Oct-13 & Jul-Sept 13 Qtrly Dec-13 $499,983 $0 Total Overage/Shortfall ($34,172) 1/2% Parks Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-12 Jan-13 $396,815 $372,447 ($24,368) Dec-12 Feb-13 $407,348 $350,714 ($56,634) Jan-13 & Oct-Dec 12 Qtrly Mar-13 $280,734 $475,026 $194,292 Feb-13 Apr-13 $452,735 $372,242 ($80,493) Mar-13 May-13 $315,030 $266,456 ($48,574) Apr-13 & Jan-Mar 13 Qtrly Jun-13 $439,265 $482,382 $43,117 May-13 Jul-13 $468,387 $425,194 ($43,193) Jun-13 Aug-13 $282,836 $272,321 ($10,515) Jul-13 & Apr-June 13 Qtrly Sep-13 $482,150 $521,155 $39,005 Aug-13 Oct-13 $382,115 $357,482 ($24,633) Sep-13 Nov-13 $264,735 $0 Oct-13 & Jul-Sept 13 Qtrly Dec-13 $495,470 $0 Total Overage/Shortfall ($11,997) Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 10/8/2013 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: OCTOBER 2013 Account Number 10-100-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average Nov January 860,921 787,676 928,460 809,385 843,061 764,659 act.845,901 Dec February 630,186 572,813 631,137 833,919 619,287 703,181 act.657,468 Jan & Oct-Dec Qtrly March 1,076,395 1,079,246 894,158 589,958 992,559 1,008,111 act.926,463 Feb April 836,513 763,906 774,964 978,391 852,653 777,424 act.841,286 Mar May 445,903 516,016 592,657 633,676 530,069 537,141 act.543,664 Apr & Jan-Mar Qtrly June 1,103,170 934,660 843,712 925,555 1,028,514 1,023,015 act.967,122 May July 821,905 686,153 939,495 955,495 797,785 872,436 act.840,167 Jun August 485,766 526,097 495,667 566,299 557,032 546,351 act.526,172 Jul & Apr-Jun Qtrly September 1,102,826 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 act.1,050,155 Aug October 788,085 718,480 822,163 797,510 769,129 717,262 act.779,073 Sept November 486,258 554,824 482,807 536,185 615,421 615,421 est.535,099 Oct & Jul-Sept Qtrly December 926,760 801,780 881,780 1,032,046 982,684 982,684 est.925,010 Actual to Date $ 9,564,688 $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 8,046,161 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,598,105 Total Actual & Estimated $ 9,644,266 Less: Budget 9,700,000 Over (Under) Budget -$ 55,734 $ 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 $ 764,659.00 $1,467,840.00 $2,460,399.00 $3,312,811.00 $3,880,026.00 $4,908,540.00 $5,706,320.00 $6,263,352.00 $7,332,766.00 $8,101,895.00 $8,717,316.00 $9,700,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 10/7/2013 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: OCTOBER 2013 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average Nov January 416,277 384,327 455,480 396,799 412,434 372,459 act.413,063 Dec February 313,830 286,909 313,836 407,407 308,567 350,813 act.326,110 Jan & Oct-Dec Qtrly March 508,380 505,185 415,473 280,758 466,856 475,110 act.435,331 Feb April 400,771 365,514 370,473 452,824 409,365 372,340 act.399,790 Mar May 221,579 257,313 295,545 315,165 263,902 266,422 act.270,701 Apr & Jan-Mar Qtrly June 527,104 453,788 400,667 439,298 494,757 483,070 act.463,123 May July 403,495 326,501 462,244 468,643 389,423 425,325 act.410,061 Jun August 241,889 261,707 247,260 282,859 278,231 272,603 act.262,389 Jul & Apr-Jun Qtrly September 530,392 481,799 495,398 482,244 504,307 521,260 act.498,828 Aug October 381,230 348,002 395,058 382,206 367,366 357,619 act.374,772 Sept November 241,897 276,487 240,417 266,364 306,968 268,825 est.266,427 Oct & Jul-Sept Qtrly December 447,485 384,320 428,058 495,406 469,095 499,983 est.444,873 Actual to Date $ 4,634,329 $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 3,897,021 Estimated to Fiscal Year end (based on averages and on Budgeted amount)768,808 Total Actual & Estimated $ 4,665,829 Less: Budget 4,700,002 Over (Under) Budget -$ 34,173 $ 372,458.69 $ 723,271.57 $ 1,198,381.28 $ 1,570,721.73 $ 1,837,144.01 $ 2,320,213.81 $ 2,745,539.17 $ 3,018,141.84 $ 3,539,402.16 $ 3,897,020.95 $ 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,002.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 10/7/2013 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: OCTOBER 2013 Account Number 21-210-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2008 2009 2010 2011 2012 2013 Average Nov January 416,569 384,305 455,442 396,815 405,730 372,447 act.411,772 Dec February 313,259 286,889 313,792 407,348 308,456 350,714 act.325,949 Jan & Oct-Dec Qtrly March 508,249 507,768 415,275 280,734 466,713 475,026 act.435,748 Feb April 400,606 365,727 370,308 452,735 409,353 372,242 act.399,746 Mar May 220,821 256,675 295,529 315,030 263,822 266,456 act.270,375 Apr & Jan-Mar Qtrly June 527,025 453,016 400,500 439,265 494,733 482,382 act.462,908 May July 402,482 326,518 461,255 468,387 389,006 425,194 act.409,530 Jun August 241,656 261,622 247,216 282,836 278,072 272,321 act.262,280 Jul & Apr-Jun Qtrly September 530,352 481,772 495,222 482,150 505,913 521,155 act.499,082 Aug October 381,309 347,721 395,014 382,115 366,846 357,482 act.374,601 Sept November 243,796 275,469 240,348 264,735 306,831 264,735 est.266,236 Oct & Jul-Sept Qtrly December 446,797 384,300 428,200 495,305 468,924 495,470 est.444,705 Actual to Date $ 4,632,921 $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 3,895,418 Estimated to Fiscal Year end (based on averages and on Budgeted amount)760,205 Total Actual & Estimated $ 4,655,623 Less: Budget 4,667,620 Over (Under) Budget -$ 11,997 $ 372,446.56 $ 723,160.39 $ 1,198,185.94 $ 1,570,427.84 $ 1,836,884.14 $ 2,319,266.06 $ 2,744,459.67 $ 3,016,780.80 $ 3,537,935.94 $ 3,895,418.24 $ 396,815.00 $804,163.00 $1,084,897.00 $1,537,632.00 $1,852,662.00 $2,291,927.00 $2,760,314.00 $3,043,150.00 $3,525,300.00 $3,907,415.00 $4,172,150.00 $4,667,620.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 Full Acct Number User: spearre Printed: 10/14/13 10:51:21 Period 01 - 13 Fiscal Year 2013 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,700,000.00 8,046,161.24 0.00 1,653,838.76 17.05 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,700,000.00 8,046,161.24 0.00 1,653,838.76 17.05 10-100-401030 Motor Vehicle Sales Tax 403,750.00 343,823.84 0.00 59,926.16 14.84 R15 Motor Vehicle Sales Tax 403,750.00 343,823.84 0.00 59,926.16 14.84 10-100-403010 Gasoline Tax 1,100,950.00 810,748.72 0.00 290,201.28 26.36 10-100-403020 Cigarette Tax 147,000.00 107,812.92 0.00 39,187.08 26.66 R20 Other Taxes 1,247,950.00 918,561.64 0.00 329,388.36 26.39 10-100-410020 Electric Utility Lic Tax 3,225,000.00 2,868,980.51 0.00 356,019.49 11.04 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 900,000.00 876,813.44 0.00 23,186.56 2.58 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,825,000.00 1,982,272.85 0.00 842,727.15 29.83 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 94,033.30 0.00 15,966.70 14.52 10-100-410060 Cable Franchise Fee 325,000.00 255,179.84 0.00 69,820.16 21.48 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,385,000.00 6,077,279.94 0.00 1,307,720.06 17.71 10-100-420010 Cur Property Tax 4,600,000.00 4,571,105.96 0.00 28,894.04 0.63 10-100-420020 Del Property Tax 50,000.00 53,019.12 0.00 -3,019.12 -6.04 10-100-420040 Fin Inst Tax 30,000.00 30,689.00 0.00 -689.00 -2.30 10-100-420050 Prop Tax Int & Penalties 16,000.00 30,531.05 0.00 -14,531.05 -90.82 10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74 10-100-420060 Surtax Receipts 450,000.00 474,343.19 0.00 -24,343.19 -5.41 10-100-420080 Special Tax Rev 21,000.00 16,307.89 0.00 4,692.11 22.34 R40 Property Taxes 5,221,000.00 5,230,395.49 0.00 -9,395.49 -0.18 10-100-430010 Federal Grants 3,079,721.32 438,924.62 0.00 2,640,796.70 85.75 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430020 State Grants 11,010.00 0.00 0.00 11,010.00 100.00 10-100-430040 Local Grants 15,594.00 38,543.64 0.00 -22,949.64 -147.17 10-100-430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 61,398.89 0.00 -61,398.89 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430080 Road & Bridge Tax 550,000.00 568,616.47 0.00 -18,616.47 -3.38 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 3,656,325.32 1,107,483.62 0.00 2,548,841.70 69.71 10-100-440010 Admin Charge Backs 1,225,660.00 1,017,941.75 0.00 207,718.25 16.95 10-100-440050 Emt Reimbursement 35,000.00 0.00 0.00 35,000.00 100.00 10-100-440210 Street Cuts 25,000.00 24,165.00 0.00 835.00 3.34 10-100-440910 Fuel Charge-backs 364,590.00 293,554.90 0.00 71,035.10 19.48 10-100-440920 Parts Charge-back 170,610.00 123,770.77 0.00 46,839.23 27.45 10-100-440930 Labor Charge-backs 167,800.00 101,781.95 0.00 66,018.05 39.34 R60 Charges for Services 1,988,660.00 1,561,214.37 0.00 427,445.63 21.49 10-100-450010 Liquor Licenses 60,000.00 65,785.83 0.00 -5,785.83 -9.64 10-100-450020 Business Licenses 233,800.00 213,174.52 0.00 20,625.48 8.82 10-100-450021 Home Occupation Permit 1,500.00 1,718.00 0.00 -218.00 -14.53 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 1,023.31 0.00 -1,023.31 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 2,990.60 0.00 -2,990.60 0.00 10-100-450045 Bldg Constr Fees 150,000.00 150,766.52 0.00 -766.52 -0.51 10-100-450050 Electrical Certificates 20,000.00 16,594.00 0.00 3,406.00 17.03 10-100-450060 Electrical Permits 2,500.00 3,376.97 0.00 -876.97 -35.08 10-100-450070 Plumbing Licenses 12,000.00 10,275.00 0.00 1,725.00 14.38 10-100-450080 Plumbing Permits 7,500.00 5,782.50 0.00 1,717.50 22.90 10-100-450090 Other Lic & Permits 1,500.00 1,600.00 0.00 -100.00 -6.67 10-100-450091 Day Care Inspection Fees 8,000.00 8,200.00 0.00 -200.00 -2.50 10-100-450092 Food Inspection Fees 88,000.00 88,933.99 0.00 -933.99 -1.06 10-100-450100 Curb Cut Permits 700.00 1,362.00 0.00 -662.00 -94.57 10-100-450110 Board Of Adj Fees 800.00 2,600.00 0.00 -1,800.00 -225.00 10-100-450120 Sign Permits 4,000.00 4,988.00 0.00 -988.00 -24.70 10-100-450130 Demolition Permits 500.00 864.00 0.00 -364.00 -72.80 10-100-450150 Acc Rep Fees-police 12,000.00 12,067.05 0.00 -67.05 -0.56 10-100-450160 Accrptblastg P-fire 2,000.00 1,130.00 0.00 870.00 43.50 10-100-450170 Animal Redemption Fees 53,000.00 48,070.00 0.00 4,930.00 9.30 10-100-450180 Animal Vaccinations Fees 2,800.00 5,465.00 0.00 -2,665.00 -95.18 10-100-450185 Animal Cremation Fees 15,000.00 23,594.00 0.00 -8,594.00 -57.29 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 300.00 450.00 0.00 -150.00 -50.00 10-100-450230 Vacating Right Of Way 800.00 100.00 0.00 700.00 87.50 10-100-450250 Rezoning Request 10,000.00 11,676.00 0.00 -1,676.00 -16.76 10-100-450260 Non-refundable Plansspec 3,000.00 1,852.50 0.00 1,147.50 38.25 R65 Fees Licenses & Permits 689,700.00 684,439.79 0.00 5,260.21 0.76 10-100-460010 Court Cost 85,000.00 74,417.55 0.00 10,582.45 12.45 10-100-460015 Court Restitutions 1,300.00 1,376.90 0.00 -76.90 -5.92 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-460018 Inmate Security Fund 12,080.00 12,066.34 0.00 13.66 0.11 10-100-460020 Jail Cost Recovery 15,000.00 8,655.74 0.00 6,344.26 42.30 10-100-460025 Alcohol Offense Cost Rec 13,000.00 10,653.00 0.00 2,347.00 18.05 10-100-460030 Pol Fines-traffic 875,000.00 780,478.91 0.00 94,521.09 10.80 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 41,189.30 0.00 17,410.70 29.71 10-100-460100 Bankcard Charges -10,000.00 -11,462.66 0.00 1,462.66 -14.63 R70 Fines & Forfeitures 1,050,980.00 917,375.08 0.00 133,604.92 12.71 10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-100-450189 Animal Shelter Bricks 0.00 100.00 0.00 -100.00 0.00 10-100-480010 Citizen Participation 0.00 11,831.30 0.00 -11,831.30 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 101,406.88 0.00 0.00 101,406.88 100.00 10-100-480025 HUD Program Income 0.00 12,340.00 0.00 -12,340.00 0.00 10-100-480030 Donations-Recycling 5,500.00 11,000.00 0.00 -5,500.00 -100.00 10-100-480050 Sober Driver Program 9,000.00 4,437.22 0.00 4,562.78 50.70 10-100-480055 JC Fire Museum 0.00 16,555.00 0.00 -16,555.00 0.00 10-100-480063 Private Donations-Cultural Art 0.00 200.00 0.00 -200.00 0.00 10-100-480065 Cultural Arts 0.00 20.00 0.00 -20.00 0.00 10-100-480070 Community Projects Donations 5,795.00 4,295.00 0.00 1,500.00 25.88 10-100-480080 Dare Donations 8,000.00 8,006.24 0.00 -6.24 -0.08 10-100-480090 Police K-9 Donations 1,000.00 500.00 0.00 500.00 50.00 10-100-480165 Animal S Donations 80,780.00 4,858.00 0.00 75,922.00 93.99 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 115,593.41 0.00 -35,593.41 -44.49 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 82,920.53 0.00 27,079.47 24.62 10-100-481070 Miscellaneous 24,000.00 24,330.37 0.00 -330.37 -1.38 10-100-481072 TIF Prof Svcs Deposit 10,000.00 10,000.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 355,715.00 356,443.96 0.00 -728.96 -0.20 10-100-481077 Insurance Claims 30,000.00 11,418.50 0.00 18,581.50 61.94 10-100-481078 Cafeteria Refunds 15,000.00 0.00 0.00 15,000.00 100.00 10-100-481080 Sale Of Mapsgis Data 100.00 60.00 0.00 40.00 40.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 0.00 28,678.00 0.00 -28,678.00 0.00 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,500.00 6,400.00 0.00 -2,900.00 -82.86 10-100-481110 Long & Short 0.00 -33.87 0.00 33.87 0.00 R75 Other Operating Revenues 973,296.88 843,453.66 0.00 129,843.22 13.34 10-100-470010 Interest 40,000.00 83,595.30 0.00 -43,595.30 -108.99 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable R80 Interest Income 40,000.00 83,595.30 0.00 -43,595.30 -108.99 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 297,000.00 279,092.02 0.00 17,907.98 6.03 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R85 Other Non-Operating Revenue 297,000.00 279,092.02 0.00 17,907.98 6.03 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 20,990.00 16,267.61 0.00 4,722.39 22.50 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-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 17,809.14 0.00 -17,809.14 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 20,990.00 34,076.75 0.00 -13,086.75 -62.35 10-100-495995 Transfer From(to) Surplus 986,566.10 0.00 0.00 986,566.10 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 986,566.10 0.00 0.00 986,566.10 100.00 100 Revenue 33,661,218.30 26,126,952.74 0.00 7,534,265.56 22.38 300 Police Department 10-300-430010 Federal Grants 543,678.79 352,595.39 0.00 191,083.40 35.15 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 68,826.00 37,397.54 0.00 31,428.46 45.66 R50 Intergovernmental 612,504.79 389,992.93 0.00 222,511.86 36.33 300 Police Department 612,504.79 389,992.93 0.00 222,511.86 36.33 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 188,765.00 192,242.34 0.00 -3,477.34 -1.84 R50 Intergovernmental 188,765.00 192,242.34 0.00 -3,477.34 -1.84 310 School Resource Officer 188,765.00 192,242.34 0.00 -3,477.34 -1.84 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 0.00 29,912.45 0.00 -29,912.45 0.00 10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-320-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 29,912.45 0.00 -29,912.45 0.00 320 M.U.S.T.A.N.G.0.00 29,912.45 0.00 -29,912.45 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Revenue 34,462,488.09 26,739,100.46 0.00 7,723,387.63 22.41 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 54,675.00 0.00 10,125.00 15.63 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,960.00 4,011.73 0.00 948.27 19.12 10-110-502020 Group Health Insurance 0.00 1,048.00 0.00 -1,048.00 0.00 10-110-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 69,760.00 59,734.73 0.00 10,025.27 14.37 10-110-511010 Advertising 1.15 0.00 0.00 1.15 100.00 10-110-511020 Postage 59.57 59.57 0.00 0.00 0.00 10-110-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-110-512020 Copies 1,030.00 49.20 0.00 980.80 95.22 10-110-513010 Office Supplies 437.50 291.66 145.83 0.01 0.00 E10 Materials & Supplies 1,678.22 400.43 145.83 1,131.96 67.45 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520030 Dues And Publications 5,014.46 4,367.51 0.00 646.95 12.90 10-110-520050 Meeting And Conferences 104.83 64.83 0.00 40.00 38.16 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,119.29 4,432.34 0.00 686.95 13.42 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 76,557.51 64,567.50 145.83 11,844.18 15.47 120 City Clerk 10-120-501020 Salaries 62,566.80 58,264.47 0.00 4,302.33 6.88 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,783.86 4,208.63 0.00 575.23 12.02 10-120-502020 Group Health Insurance 11,791.50 11,155.62 0.00 635.88 5.39 10-120-502030 Retirement 10,968.60 10,919.10 0.00 49.50 0.45 10-120-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-120-502050 Life Insurance 110.00 98.24 0.00 11.76 10.69 10-120-502060 Long Term Disability 151.47 156.61 0.00 -5.14 -3.39 10-120-502070 Employee Assistance Prgm 33.30 32.56 0.00 0.74 2.22 E05 Personnel Services 90,405.53 84,835.23 0.00 5,570.30 6.16 10-120-511020 Postage 270.00 124.36 0.00 145.64 53.94 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-120-512020 Copies 4,500.00 283.01 0.00 4,216.99 93.71 10-120-513010 Office Supplies 1,150.00 51.60 0.00 1,098.40 95.51 E10 Materials & Supplies 6,220.00 458.97 0.00 5,761.03 92.62 10-120-520030 Dues And Publications 250.00 250.00 0.00 0.00 0.00 10-120-520050 Meeting And Conferences 500.00 48.00 0.00 452.00 90.40 10-120-520070 Training And Education 500.00 0.00 0.00 500.00 100.00 10-120-522020 Professional Services 2,249.96 0.00 0.00 2,249.96 100.00 10-120-529030 Election Expense 72,083.02 72,083.02 0.00 0.00 0.00 E15 Contractual Services 75,582.98 72,381.02 0.00 3,201.96 4.24 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 617.02 471.18 145.83 0.01 0.00 E25 Repairs & Maintenance 617.02 471.18 145.83 0.01 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 172,825.53 158,146.40 145.83 14,533.30 8.41 140 City Administrator 10-140-501020 Salaries 204,859.92 275,078.12 0.00 -70,218.20 -34.28 10-140-501050 Parttime(wo Benefits)100.98 0.00 0.00 100.98 100.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 15,494.23 15,403.63 0.00 90.60 0.58 10-140-502020 Group Health Insurance 9,853.41 18,163.33 0.00 -8,309.92 -84.34 10-140-502030 Retirement 36,676.68 34,750.63 0.00 1,926.05 5.25 10-140-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-140-502050 Life Insurance 383.78 294.01 0.00 89.77 23.39 10-140-502060 Long Term Disability 475.08 365.64 0.00 109.44 23.04 10-140-502070 Employee Assistance Prgm 43.41 43.41 0.00 0.00 0.00 E05 Personnel Services 267,887.49 344,098.77 0.00 -76,211.28 -28.45 10-140-511010 Advertising 3,292.49 3,052.95 0.00 239.54 7.28 10-140-511020 Postage 370.00 239.46 0.00 130.54 35.28 10-140-512010 Printing 330.00 0.00 0.00 330.00 100.00 10-140-512020 Copies 950.00 95.23 0.00 854.77 89.98 10-140-513010 Office Supplies 1,774.14 1,154.83 619.31 0.01 0.00 E10 Materials & Supplies 6,716.63 4,542.47 619.31 1,554.86 23.15 10-140-520030 Dues And Publications 580.00 580.00 0.00 0.00 0.00 10-140-520050 Meeting And Conferences 1,851.30 1,669.41 0.00 181.89 9.82 10-140-520070 Training And Education 99.00 99.00 0.00 0.00 0.00 10-140-522020 Professional Services 2,699.66 363.82 0.00 2,335.84 86.52 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 5,229.96 2,712.23 0.00 2,517.73 48.14 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 237.60 237.60 0.00 0.00 0.00 E25 Repairs & Maintenance 237.60 237.60 0.00 0.00 0.00 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 280,071.68 351,591.07 619.31 -72,138.70 -25.76 149 Entitlement Grant 10-149-501020 Salaries 10,000.00 0.00 0.00 10,000.00 100.00 10-149-501050 Parttime(wo Benefits)29,171.15 6,367.50 0.00 22,803.65 78.17 10-149-502010 Social Security 2,000.00 487.14 0.00 1,512.86 75.64 10-149-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 1,500.00 0.00 0.00 1,500.00 100.00 10-149-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 42,671.15 6,854.64 0.00 35,816.51 83.94 10-149-511010 Advertising 2,542.14 444.58 0.00 2,097.56 82.51 10-149-511020 Postage 2,387.40 189.00 0.00 2,198.40 92.08 10-149-512020 Copies 20.60 1.87 0.00 18.73 90.92 10-149-513010 Office Supplies 2,141.58 526.78 0.00 1,614.80 75.40 10-149-517010 Operational Supplies 2,280.00 0.00 0.00 2,280.00 100.00 E10 Materials & Supplies 9,371.72 1,162.23 0.00 8,209.49 87.60 10-149-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 4,200.00 350.40 0.00 3,849.60 91.66 10-149-522020 Professional Services 10,156.00 4,319.00 0.00 5,837.00 57.47 10-149-528010 Housing Rehabilitation 20,117.25 20,117.25 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 90,000.00 0.00 0.00 90,000.00 100.00 10-149-528012 Housing Rehab-Energy Efficienc 45,000.00 0.00 0.00 45,000.00 100.00 10-149-528020 Housing Assistance 35,300.00 5,300.00 0.00 30,000.00 84.99 10-149-528030 Public Improvement 175,075.00 117.25 57,721.00 117,236.75 66.96 10-149-528040 Neighborhood Redevelopmnt 141,500.00 21,492.50 0.00 120,007.50 84.81 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 18,600.00 0.00 0.00 18,600.00 100.00 10-149-528080 Homeless Objectives 2,422.00 2,000.00 0.00 422.00 17.42 E15 Contractual Services 542,370.25 53,696.40 57,721.00 430,952.85 79.46 10-149-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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 594,413.12 61,713.27 57,721.00 474,978.85 79.91 150 City Counselor 10-150-501020 Salaries 218,045.40 195,167.67 0.00 22,877.73 10.49 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 500.00 183.60 0.00 316.40 63.28 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,687.06 13,998.54 0.00 2,688.52 16.11 10-150-502020 Group Health Insurance 28,192.50 26,901.28 0.00 1,291.22 4.58 10-150-502030 Retirement 38,218.40 32,679.90 0.00 5,538.50 14.49 10-150-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-150-502050 Life Insurance 390.00 323.65 0.00 66.35 17.01 10-150-502060 Long Term Disability 535.13 476.21 0.00 58.92 11.01 10-150-502070 Employee Assistance Prgm 77.70 75.98 0.00 1.72 2.21 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 302,646.19 269,806.83 0.00 32,839.36 10.85 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 250.00 201.68 0.00 48.32 19.33 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 182.63 0.00 487.37 72.74 10-150-513010 Office Supplies 2,000.00 1,339.64 0.00 660.36 33.02 10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 3,220.00 1,723.95 0.00 1,496.05 46.46 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 13,100.00 10,502.73 0.00 2,597.27 19.83 10-150-520050 Meeting And Conferences 1,500.00 1,285.45 0.00 214.55 14.30 10-150-520070 Training And Education 2,400.00 2,049.51 0.00 350.49 14.60 10-150-520080 Tuition Reimbursement 2,880.00 2,394.00 0.00 486.00 16.88 10-150-521010 General Insurance 2,100.00 844.00 0.00 1,256.00 59.81 10-150-522020 Professional Services 12,000.00 11,020.36 0.00 979.64 8.16 10-150-525030 Court Cost & Witness Fees 290.00 59.86 0.00 230.14 79.36 E15 Contractual Services 34,270.00 28,155.91 0.00 6,114.09 17.84 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,890.00 1,077.40 236.41 576.19 30.49 E25 Repairs & Maintenance 1,890.00 1,077.40 236.41 576.19 30.49 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 150 City Counselor 342,026.19 300,764.09 236.41 41,025.69 11.99 160 Municipal Court Dept 10-160-501010 Salary-elected Officals 60,000.00 49,999.90 0.00 10,000.10 16.67 10-160-501020 Salaries 95,145.60 89,911.86 0.00 5,233.74 5.50 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)9,250.00 5,086.75 0.00 4,163.25 45.01 10-160-501090 Overtime 8,600.00 2,081.07 0.00 6,518.93 75.80 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,252.72 11,100.65 0.00 2,152.07 16.24 10-160-502020 Group Health Insurance 14,248.50 10,576.90 0.00 3,671.60 25.77 10-160-502030 Retirement 18,210.30 17,240.50 0.00 969.80 5.33 10-160-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-160-502050 Life Insurance 170.00 149.67 0.00 20.33 11.96 10-160-502060 Long Term Disability 232.24 240.00 0.00 -7.76 -3.34 10-160-502070 Employee Assistance Prgm 55.50 54.26 0.00 1.24 2.23 E05 Personnel Services 219,164.86 186,441.56 0.00 32,723.30 14.93 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 2,661.03 0.00 1,338.97 33.47 10-160-512010 Printing 1,090.00 377.70 0.00 712.30 65.35 10-160-512020 Copies 1,000.00 169.85 0.00 830.15 83.02 10-160-513010 Office Supplies 2,600.00 2,023.56 0.00 576.44 22.17 E10 Materials & Supplies 8,690.00 5,232.14 0.00 3,457.86 39.79 10-160-520030 Dues And Publications 300.00 100.00 0.00 200.00 66.67 10-160-520050 Meeting And Conferences 750.00 683.48 0.00 66.52 8.87 10-160-520070 Training And Education 600.00 500.00 0.00 100.00 16.67 10-160-522020 Professional Services 21,869.52 18,596.35 0.00 3,273.17 14.97 10-160-525010 Care Of Prisoners 1,790.50 151.00 0.00 1,639.50 91.57 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 25,350.02 20,030.83 0.00 5,319.19 20.98 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,032.98 830.22 145.83 56.93 5.51 E25 Repairs & Maintenance 1,032.98 830.22 145.83 56.93 5.51 10-160-572020 Purchase Of Equipment 23,851.06 0.00 23,851.06 0.00 0.00 E70 Capital Purchases 23,851.06 0.00 23,851.06 0.00 0.00 160 Municipal Court Dept 278,088.92 212,534.75 23,996.89 41,557.28 14.94 170 Human Resources 10-170-501020 Salaries 182,896.20 168,351.67 0.00 14,544.53 7.95 10-170-501050 Parttime(wo Benefits)9,600.00 8,078.29 0.00 1,521.71 15.85 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502010 Social Security 15,514.34 12,960.61 0.00 2,553.73 16.46 10-170-502020 Group Health Insurance 23,310.00 23,172.77 0.00 137.23 0.59 10-170-502030 Retirement 32,107.90 31,551.13 0.00 556.77 1.73 10-170-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-170-502050 Life Insurance 320.00 282.35 0.00 37.65 11.77 10-170-502060 Long Term Disability 444.30 410.52 0.00 33.78 7.60 10-170-502070 Employee Assistance Prgm 66.60 65.11 0.00 1.49 2.24 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 264,559.34 244,872.45 0.00 19,686.89 7.44 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 1,000.00 112.94 0.00 887.06 88.71 10-170-512010 Printing 2,000.00 1,576.47 0.00 423.53 21.18 10-170-512020 Copies 1,500.00 570.72 0.00 929.28 61.95 10-170-513010 Office Supplies 1,500.00 318.56 473.48 707.97 47.20 10-170-517010 Operational Supplies 1,350.00 46.32 0.00 1,303.68 96.57 E10 Materials & Supplies 7,500.00 2,625.01 473.48 4,401.52 58.69 10-170-520030 Dues And Publications 1,255.00 483.00 0.00 772.00 61.51 10-170-520050 Meeting And Conferences 942.00 1,722.40 0.00 -780.40 -82.85 10-170-520060 Wellness Program 3,919.00 2,044.00 0.00 1,875.00 47.84 10-170-520070 Training And Education 2,002.00 1,810.36 0.00 191.64 9.57 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 6,816.00 6,283.25 0.00 532.75 7.82 10-170-522020 Professional Services 10,648.50 2,147.46 0.00 8,501.04 79.83 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 25,582.50 14,490.47 0.00 11,092.03 43.36 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 437.50 291.66 145.83 0.01 0.00 E25 Repairs & Maintenance 437.50 291.66 145.83 0.01 0.00 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 298,079.34 262,279.59 619.31 35,180.45 11.80 180 Finance Department 10-180-501020 Salaries 604,556.47 554,787.18 0.00 49,769.29 8.23 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)8,600.00 7,052.87 0.00 1,547.13 17.99 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 53,692.95 42,471.15 0.00 11,221.80 20.90 10-180-502020 Group Health Insurance 81,663.89 61,810.25 0.00 19,853.64 24.31 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502030 Retirement 103,469.01 94,631.99 0.00 8,837.02 8.54 10-180-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-180-502050 Life Insurance 1,053.35 868.11 0.00 185.24 17.59 10-180-502060 Long Term Disability 1,527.41 1,391.34 0.00 136.07 8.91 10-180-502070 Employee Assistance Prgm 273.23 303.95 0.00 -30.72 -11.24 E05 Personnel Services 854,836.31 763,316.84 0.00 91,519.47 10.71 10-180-511010 Advertising 2,000.00 657.93 0.00 1,342.07 67.10 10-180-511020 Postage 13,500.00 8,304.80 0.00 5,195.20 38.48 10-180-511021 Postage Cost 2,000.00 5,393.11 0.00 -3,393.11 -169.66 10-180-512010 Printing 6,500.00 4,040.57 0.00 2,459.43 37.84 10-180-512020 Copies 7,000.00 2,692.85 0.00 4,307.15 61.53 10-180-512021 Copy Machine Cost 0.00 -1,250.20 874.98 375.22 0.00 10-180-513010 Office Supplies 5,913.00 5,461.34 80.38 371.28 6.28 10-180-517010 Operational Supplies 3,827.60 1,276.84 0.00 2,550.76 66.64 E10 Materials & Supplies 40,740.60 26,577.24 955.36 13,208.00 32.42 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,170.50 1,235.52 0.00 934.98 43.08 10-180-520050 Meeting And Conferences 1,768.30 1,629.38 0.00 138.92 7.86 10-180-520070 Training And Education 1,426.00 1,429.80 0.00 -3.80 -0.27 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 25,342.40 25,342.40 0.00 0.00 0.00 10-180-522020 Professional Services 229.50 229.50 0.00 0.00 0.00 E15 Contractual Services 30,936.70 29,866.60 0.00 1,070.10 3.46 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 1,215.84 0.00 784.16 39.21 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 1,215.84 0.00 784.16 39.21 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 928,513.61 820,976.52 955.36 106,581.73 11.48 185 Non-Departmental 10-185-501020 Salaries 586,048.24 0.00 0.00 586,048.24 100.00 10-185-502020 Group Health Insurance 5,000.00 5,000.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 27,810.06 0.00 0.00 27,810.06 100.00 E05 Personnel Services 618,858.30 5,000.00 0.00 613,858.30 99.19 10-185-514011 Gas Oil & Antifreeze 935,000.00 824,802.53 17,042.84 93,154.63 9.96 E10 Materials & Supplies 935,000.00 824,802.53 17,042.84 93,154.63 9.96 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-520080 Tuition Reimbursement 8,000.00 0.00 0.00 8,000.00 100.00 10-185-521010 General Insurance 261,000.00 278,968.32 0.00 -17,968.32 -6.88 10-185-521020 Insurance Deductible 10,000.00 14,058.59 0.00 -4,058.59 -40.59 10-185-521030 Self Ins Prop & Casualty 70,000.00 68,876.89 0.00 1,123.11 1.60 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 10,000.00 5,543.75 0.00 4,456.25 44.56 10-185-522020 Professional Services 235,000.00 234,999.96 2,083.33 -2,083.29 -0.89 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 38,500.00 34,068.38 0.00 4,431.62 11.51 10-185-527020 Economic Development 185,000.00 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 18,000.00 14,603.59 0.00 3,396.41 18.87 E15 Contractual Services 836,000.00 836,119.48 2,083.33 -2,202.81 -0.26 10-185-531010 Electricity 37,400.00 32,705.45 0.00 4,694.55 12.55 10-185-533010 Natural Gas 11,000.00 4,527.65 0.00 6,472.35 58.84 10-185-535010 Water 6,791.05 6,052.53 0.00 738.52 10.87 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,191.05 43,285.63 0.00 11,905.42 21.57 10-185-540010 Building & Grounds Maint.55,958.95 22,492.52 238.58 33,227.85 59.38 10-185-540020 Tree & Landscape Maint 25,000.00 23,625.00 0.00 1,375.00 5.50 10-185-547020 Maintenance Agreements 2,000.00 1,560.00 0.00 440.00 22.00 E25 Repairs & Maintenance 82,958.95 47,677.52 238.58 35,042.85 42.24 10-185-550010 Miscellaneous 18,546.44 3,445.75 0.00 15,100.69 81.42 10-185-550015 Bad Debt Expense 0.00 -270.00 0.00 270.00 0.00 10-185-550020 Neighborhood Reinvestment 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-550036 Salute to America 5,000.00 5,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-550039 Katy Trail Welcome Area 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 12,391.36 6,999.34 0.00 5,392.02 43.51 10-185-550043 JC Fire Museum 0.00 4,000.00 0.00 -4,000.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 35,937.80 19,175.09 0.00 16,762.71 46.64 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 185 Non-Departmental 2,563,946.10 1,776,060.25 19,364.75 768,521.10 29.97 190 I.T. Department 10-190-501020 Salaries 519,071.25 489,908.56 0.00 29,162.69 5.62 10-190-501040 Part-time (wbenefits)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 39,713.63 36,255.79 0.00 3,457.84 8.71 10-190-502020 Group Health Insurance 65,444.47 53,844.30 0.00 11,600.17 17.73 10-190-502030 Retirement 90,885.78 84,987.53 0.00 5,898.25 6.49 10-190-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-190-502050 Life Insurance 890.25 810.85 0.00 79.40 8.92 10-190-502060 Long Term Disability 1,268.63 1,256.13 0.00 12.50 0.99 10-190-502070 Employee Assistance Prgm 206.63 206.21 0.00 0.42 0.20 E05 Personnel Services 717,480.64 667,269.37 0.00 50,211.27 7.00 10-190-511010 Advertising 155.91 0.00 0.00 155.91 100.00 10-190-511020 Postage 200.00 17.66 0.00 182.34 91.17 10-190-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-190-512020 Copies 400.00 34.99 0.00 365.01 91.25 10-190-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00 10-190-513010 Office Supplies 741.09 256.60 0.00 484.49 65.38 10-190-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-190-517010 Operational Supplies 1,758.91 1,758.91 0.00 0.00 0.00 E10 Materials & Supplies 3,605.91 2,068.16 0.00 1,537.75 42.65 10-190-520010 Mileage Expense 500.00 150.01 0.00 349.99 70.00 10-190-520030 Dues And Publications 500.00 349.00 0.00 151.00 30.20 10-190-520050 Meeting And Conferences 2,344.09 1,933.09 0.00 411.00 17.53 10-190-520070 Training And Education 3,500.00 2,927.08 0.00 572.92 16.37 10-190-520080 Tuition Reimbursement 3,000.00 615.00 0.00 2,385.00 79.50 10-190-522020 Professional Services 2,000.00 1,349.41 0.00 650.59 32.53 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,807.44 0.00 1,992.56 10.06 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 0.00 0.00 2,000.00 100.00 E15 Contractual Services 33,644.09 25,131.03 0.00 8,513.06 25.30 10-190-534010 Telephone 54,333.00 52,573.09 0.00 1,759.91 3.24 E20 Utilities 54,333.00 52,573.09 0.00 1,759.91 3.24 10-190-545010 Software Licensemaint 196,147.25 169,823.73 1,188.30 25,135.22 12.81 10-190-545020 Citywide Wiringnetwork 2,200.00 1,643.89 0.00 556.11 25.28 10-190-547010 Equipment Maintenance 4,000.00 3,878.79 0.00 121.21 3.03 10-190-547020 Maintenance Agreements 31,630.13 31,506.30 90.58 33.25 0.11 E25 Repairs & Maintenance 233,977.38 206,852.71 1,278.88 25,845.79 11.05 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-572020 Purchase Of Equipment 38,022.62 24,773.07 13,249.55 0.00 0.00 E70 Capital Purchases 38,022.62 24,773.07 13,249.55 0.00 0.00 190 I.T. Department 1,081,063.64 978,667.43 14,528.43 87,867.78 8.13 300 Police Department 10-300-501020 Salaries 3,949,853.37 3,683,999.38 0.00 265,853.99 6.73 10-300-501030 Holiday Pay 119,064.00 110,343.91 0.00 8,720.09 7.32 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,750.50 0.00 2,649.50 8.72 10-300-501060 Seasonal Salaries 9,847.50 9,847.50 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,800.00 5,516.00 0.00 1,284.00 18.88 10-300-501090 Overtime 232,919.01 209,976.28 0.00 22,942.73 9.85 10-300-501095 Overtime Straight Pay 12,309.49 10,591.77 0.00 1,717.72 13.95 10-300-502010 Social Security 361,012.26 294,254.83 0.00 66,757.43 18.49 10-300-502020 Group Health Insurance 709,640.98 595,385.94 0.00 114,255.04 16.10 10-300-502030 Retirement 849,585.75 805,887.52 0.00 43,698.23 5.14 10-300-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-300-502050 Life Insurance 6,577.18 6,045.09 0.00 532.09 8.09 10-300-502060 Long Term Disability 9,410.69 9,567.11 0.00 -156.42 -1.66 10-300-502070 Employee Assistance Prgm 1,862.24 1,986.15 0.00 -123.91 -6.65 10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,301,882.47 5,771,151.98 0.00 530,730.49 8.42 10-300-511010 Advertising 3,046.41 3,046.41 0.00 0.00 0.00 10-300-511020 Postage 1,398.16 1,137.59 0.00 260.57 18.64 10-300-512010 Printing 5,097.84 5,097.84 0.00 0.00 0.00 10-300-512020 Copies 4.00 2.59 0.00 1.41 35.25 10-300-512030 Photographic Supplies 1,073.01 1,073.01 0.00 0.00 0.00 10-300-513010 Office Supplies 12,000.00 11,183.83 0.00 816.17 6.80 10-300-514010 Gas, Oil, Anti-Freeze 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 700.00 288.52 0.00 411.48 58.78 10-300-516010 Ammunition & Firearms Supplies 29,000.00 20,814.76 7,196.00 989.24 3.41 10-300-516020 Dare Program 16,000.00 15,363.03 0.00 636.97 3.98 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 4,295.00 2,270.00 0.00 2,025.00 47.15 10-300-517010 Operational Supplies 49,043.21 38,574.23 1,945.16 8,523.82 17.38 E10 Materials & Supplies 124,157.63 101,351.81 9,141.16 13,664.66 11.01 10-300-520030 Dues And Publications 4,300.00 4,281.60 0.00 18.40 0.43 10-300-520050 Meeting And Conferences 1,368.36 1,368.36 0.00 0.00 0.00 10-300-520070 Training And Education 23,631.64 24,112.79 0.00 -481.15 -2.04 10-300-520080 Tuition Reimbursement 7,314.00 6,459.00 0.00 855.00 11.69 10-300-520090 Recruitment 1,482.47 1,482.47 0.00 0.00 0.00 10-300-521040 Medical Claimsservices 5,785.02 3,491.89 0.00 2,293.13 39.64 10-300-521050 Medical Services 1,200.00 1,220.82 0.00 -20.82 -1.74 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-522020 Professional Services 11,173.68 11,173.68 0.00 0.00 0.00 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 5,600.00 5,600.00 0.00 0.00 0.00 10-300-523030 Building Lease 1,160.00 1,160.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 12,000.00 4,082.48 0.00 7,917.52 65.98 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,252.99 2,287.31 0.00 -34.32 -1.52 E15 Contractual Services 77,268.16 66,720.40 0.00 10,547.76 13.65 10-300-531010 Electricity 72,000.00 61,282.72 0.00 10,717.28 14.89 10-300-533010 Natural Gas 11,300.00 10,738.89 0.00 561.11 4.97 10-300-534010 Telephone 4,400.00 3,975.83 0.00 424.17 9.64 10-300-535010 Water 4,200.00 3,938.86 0.00 261.14 6.22 E20 Utilities 91,900.00 79,936.30 0.00 11,963.70 13.02 10-300-540010 Building & Grounds Maint.62,000.00 60,419.12 -399.72 1,980.60 3.19 10-300-541030 Vehicle Wash 11,000.00 9,127.50 0.00 1,872.50 17.02 10-300-544010 K-9 Operations 12,000.00 10,535.06 0.00 1,464.94 12.21 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 50,208.00 50,208.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 14,000.00 10,149.83 0.00 3,850.17 27.50 10-300-546010 Clothing Expense 20,375.16 20,399.66 -3,090.26 3,065.76 15.05 10-300-546020 Uniform Cleaning 22,356.84 18,685.64 0.00 3,671.20 16.42 10-300-547010 Equipment Maintenance 8,797.51 9,083.59 0.00 -286.08 -3.25 10-300-547020 Maintenance Agreements 23,207.33 22,482.83 724.50 0.00 0.00 10-300-547030 Radio Maintenance 13,095.16 12,906.08 509.26 -320.18 -2.45 E25 Repairs & Maintenance 237,040.00 223,997.31 -2,256.22 15,298.91 6.45 10-300-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 7,978.37 -8,500.00 16,478.37 0.00 0.00 10-300-572070 MDT Year 2 Equipment 153,772.97 153,772.97 287.50 -287.50 -0.19 10-300-572075 LLEBG Annual Grant Equipment 29,631.00 11,154.00 0.00 18,477.00 62.36 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572100 MDT Year 3 Equipment 330,274.82 65,380.17 63,193.50 201,701.15 61.07 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 521,657.16 221,807.14 79,959.37 219,890.65 42.15 300 Police Department 7,353,905.42 6,464,964.94 86,844.31 802,096.17 10.91 310 School Resource Officer 10-310-501020 Salaries 217,551.83 198,960.63 0.00 18,591.20 8.55 10-310-501030 Holiday Pay 9,343.20 2,879.84 0.00 6,463.36 69.18 10-310-501090 Overtime 14,350.84 13,663.00 0.00 687.84 4.79 10-310-501095 Overtime Straight Pay 1,200.16 1,012.72 0.00 187.44 15.62 10-310-502010 Social Security 26,895.52 15,232.17 0.00 11,663.35 43.37 10-310-502020 Group Health Insurance 38,598.62 35,374.85 0.00 3,223.77 8.35 10-310-502030 Retirement 47,158.46 39,297.88 0.00 7,860.58 16.67 10-310-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-310-502050 Life Insurance 397.53 283.15 0.00 114.38 28.77 10-310-502060 Long Term Disability 519.60 452.29 0.00 67.31 12.95 10-310-502070 Employee Assistance Prgm 99.05 108.54 0.00 -9.49 -9.58 E05 Personnel Services 356,114.81 307,265.07 0.00 48,849.74 13.72 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 356,114.81 307,265.07 0.00 48,849.74 13.72 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 73,352.00 70,714.11 0.00 2,637.89 3.60 10-320-501030 Holiday Pay 3,335.40 1,551.63 0.00 1,783.77 53.48 10-320-501090 Overtime 10,347.00 8,801.20 0.00 1,545.80 14.94 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 8,315.20 5,834.04 0.00 2,481.16 29.84 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-502020 Group Health Insurance 14,532.00 12,076.29 0.00 2,455.71 16.90 10-320-502030 Retirement 20,614.10 16,964.22 0.00 3,649.88 17.71 10-320-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-320-502050 Life Insurance 150.00 119.80 0.00 30.20 20.13 10-320-502060 Long Term Disability 212.12 193.32 0.00 18.80 8.86 10-320-502070 Employee Assistance Prgm 44.40 43.41 0.00 0.99 2.23 E05 Personnel Services 130,902.22 116,298.02 0.00 14,604.20 11.16 10-320-514010 Gas Oil Anti-freeze 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations (grant)20,561.39 19,764.94 0.00 796.45 3.87 10-320-517010 Operational Supplies 438.61 438.61 0.00 0.00 0.00 E10 Materials & Supplies 21,000.00 20,203.55 0.00 796.45 3.79 10-320-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 15,000.00 15,000.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 16,456.41 16,456.41 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 1,500.00 1,500.00 0.00 0.00 0.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 32,956.41 32,956.41 0.00 0.00 0.00 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 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.184,858.63 169,457.98 0.00 15,400.65 8.33 330 Animal Control 10-330-501020 Salaries 282,083.92 267,395.39 0.00 14,688.53 5.21 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 2,765.00 2,765.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,025.00 3,880.00 0.00 145.00 3.60 10-330-501090 Overtime 1,709.00 1,445.39 0.00 263.61 15.42 10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44 10-330-502010 Social Security 23,963.21 19,121.56 0.00 4,841.65 20.20 10-330-502020 Group Health Insurance 65,287.85 54,239.19 0.00 11,048.66 16.92 10-330-502030 Retirement 54,182.34 46,599.38 0.00 7,582.96 14.00 10-330-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-330-502050 Life Insurance 522.79 441.53 0.00 81.26 15.54 10-330-502060 Long Term Disability 746.84 704.05 0.00 42.79 5.73 10-330-502070 Employee Assistance Prgm 170.77 173.65 0.00 -2.88 -1.69 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 435,956.72 396,792.96 0.00 39,163.76 8.98 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-511010 Advertising 101.23 101.23 0.00 0.00 0.00 10-330-511020 Postage 400.00 136.43 0.00 263.57 65.89 10-330-512010 Printing 1,700.00 1,609.51 0.00 90.49 5.32 10-330-512020 Copies 20.00 0.04 0.00 19.96 99.80 10-330-513010 Office Supplies 800.00 832.93 0.00 -32.93 -4.12 10-330-514030 Small Tools 250.00 27.97 0.00 222.03 88.81 10-330-515040 First Aid Supplies 150.00 0.00 0.00 150.00 100.00 10-330-517010 Operational Supplies 14,579.25 14,898.45 0.00 -319.20 -2.19 E10 Materials & Supplies 18,000.48 17,606.56 0.00 393.92 2.19 10-330-520030 Dues And Publications 1,609.94 1,609.94 0.00 0.00 0.00 10-330-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 459.58 459.58 0.00 0.00 0.00 10-330-521040 Medical Claimsservices 2,329.00 1,255.00 0.00 1,074.00 46.11 10-330-522020 Professional Services 24,971.00 19,889.87 0.00 5,081.13 20.35 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 10,000.00 10,054.23 0.00 -54.23 -0.54 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 3,669.05 3,669.05 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 1,433.00 1,433.00 0.00 0.00 0.00 E15 Contractual Services 44,471.57 38,370.67 0.00 6,100.90 13.72 10-330-531010 Electricity 21,768.36 19,017.36 0.00 2,751.00 12.64 10-330-533010 Natural Gas 19,098.36 15,302.32 0.00 3,796.04 19.88 10-330-534010 Telephone 572.00 300.02 0.00 271.98 47.55 10-330-535010 Water 5,500.00 3,029.91 0.00 2,470.09 44.91 E20 Utilities 46,938.72 37,649.61 0.00 9,289.11 19.79 10-330-540010 Building & Grounds Maint.11,000.00 6,941.97 150.00 3,908.03 35.53 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 455.00 0.00 85.00 15.74 10-330-544040 Care Of Animals 41,790.95 37,187.00 -2,549.35 7,153.30 17.12 10-330-546010 Clothing Expense 3,000.00 2,069.62 0.00 930.38 31.01 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 1,300.00 803.09 0.00 496.91 38.22 10-330-547020 Maintenance Agreements 800.00 312.00 0.00 488.00 61.00 10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00 E25 Repairs & Maintenance 59,130.95 47,768.68 -2,399.35 13,761.62 23.27 10-330-572020 Purchase Of Equipment 2,094.00 2,094.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 2,094.00 2,094.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 61,689.28 61,689.28 0.00 0.00 0.00 E75 Capital Projects 61,689.28 61,689.28 0.00 0.00 0.00 330 Animal Control 668,281.72 601,971.76 -2,399.35 68,709.31 10.28 390 9-1-1 Police GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-501020 Salaries 810,066.96 748,101.08 0.00 61,965.88 7.65 10-390-501030 Holiday Pay 29,988.00 26,597.95 0.00 3,390.05 11.30 10-390-501050 Parttime(wo Benefits)210.00 150.00 0.00 60.00 28.57 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 12,879.69 0.00 2,934.31 18.56 10-390-501095 Overtime Straight Pay 500.00 36.04 0.00 463.96 92.79 10-390-502010 Social Security 68,429.89 56,906.93 0.00 11,522.96 16.84 10-390-502020 Group Health Insurance 162,023.23 133,872.93 0.00 28,150.30 17.37 10-390-502030 Retirement 153,915.34 136,561.49 0.00 17,353.85 11.27 10-390-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,429.50 1,229.59 0.00 199.91 13.98 10-390-502060 Long Term Disability 1,999.42 1,947.39 0.00 52.03 2.60 10-390-502070 Employee Assistance Prgm 460.22 455.84 0.00 4.38 0.95 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,244,836.56 1,118,738.93 0.00 126,097.63 10.13 10-390-511010 Advertising 0.00 0.00 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,200.00 6,063.60 477.36 3,659.04 35.87 E10 Materials & Supplies 10,200.00 6,063.60 477.36 3,659.04 35.87 10-390-520030 Dues And Publications 510.00 510.00 0.00 0.00 0.00 10-390-520050 Meeting And Conferences 1,764.69 1,764.69 0.00 0.00 0.00 10-390-520070 Training And Education 3,035.31 2,611.11 0.00 424.20 13.98 10-390-522020 Professional Services 923.00 923.00 0.00 0.00 0.00 10-390-523010 Equipment Rentlease 97,500.00 97,331.15 0.00 168.85 0.17 E15 Contractual Services 103,733.00 103,139.95 0.00 593.05 0.57 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 1,900.00 1,817.27 0.00 82.73 4.35 10-390-546020 Uniform Cleaning 1,695.68 1,695.68 0.00 0.00 0.00 10-390-547010 Equipment Maintenance 2,272.45 2,272.45 0.00 0.00 0.00 10-390-547020 Maintenance Agreements 24,392.52 24,392.52 0.00 0.00 0.00 10-390-547030 Radio Maintenance 4,605.35 2,295.24 0.00 2,310.11 50.16 E25 Repairs & Maintenance 34,866.00 32,473.16 0.00 2,392.84 6.86 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,393,635.56 1,260,415.64 477.36 132,742.56 9.52 400 Fire Department 10-400-501020 Salaries 3,562,022.04 3,287,693.31 0.00 274,328.73 7.70 10-400-501030 Holiday Pay 277,478.80 275,289.26 0.00 2,189.54 0.79 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,000.00 25,794.52 0.00 2,205.48 7.88 10-400-501090 Overtime 40,000.00 36,388.12 0.00 3,611.88 9.03 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-501095 Overtime Straight Pay 27,000.00 22,505.96 0.00 4,494.04 16.64 10-400-502010 Social Security 86,218.37 47,138.28 0.00 39,080.09 45.33 10-400-502020 Group Health Insurance 572,264.23 515,577.86 0.00 56,686.37 9.91 10-400-502030 Retirement 1,619,822.08 1,506,493.78 0.00 113,328.30 7.00 10-400-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-400-502050 Life Insurance 6,242.77 5,394.33 0.00 848.44 13.59 10-400-502060 Long Term Disability 8,662.18 8,561.85 0.00 100.33 1.16 10-400-502070 Employee Assistance Prgm 1,632.56 1,649.71 0.00 -17.15 -1.05 10-400-503010 Awards Program 2,245.00 2,242.59 0.00 2.41 0.11 E05 Personnel Services 6,231,588.03 5,734,729.57 0.00 496,858.46 7.97 10-400-511010 Advertising 75.00 75.00 0.00 0.00 0.00 10-400-511020 Postage 140.00 85.66 0.00 54.34 38.81 10-400-512010 Printing 1,250.00 895.22 0.00 354.78 28.38 10-400-512020 Copies 200.00 0.42 0.00 199.58 99.79 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 1,676.64 0.00 123.36 6.85 10-400-514020 Chemicals 1,120.00 1,110.79 0.00 9.21 0.82 10-400-514030 Small Tools 2,500.00 1,976.33 0.00 523.67 20.95 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 400.00 53.66 0.00 346.34 86.59 10-400-517010 Operational Supplies 9,275.00 7,582.25 0.00 1,692.75 18.25 E10 Materials & Supplies 16,760.00 13,455.97 0.00 3,304.03 19.71 10-400-520030 Dues And Publications 1,300.00 1,292.73 0.00 7.27 0.56 10-400-520050 Meeting And Conferences 60.00 53.54 0.00 6.46 10.77 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 9,120.00 8,451.51 0.00 668.49 7.33 10-400-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 2,530.00 2,528.75 0.00 1.25 0.05 10-400-522020 Professional Services 600.00 600.00 0.00 0.00 0.00 10-400-523010 Equipment Rentlease 50.00 50.00 0.00 0.00 0.00 10-400-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-400-529010 Special Events 8,055.00 5,169.47 0.00 2,885.53 35.82 10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,215.00 18,146.00 0.00 4,069.00 18.32 10-400-531010 Electricity 42,200.00 39,229.87 0.00 2,970.13 7.04 10-400-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-400-534010 Telephone 17,500.00 17,314.97 0.00 185.03 1.06 10-400-535010 Water 9,620.00 9,054.03 0.00 565.97 5.88 E20 Utilities 69,320.00 65,598.87 0.00 3,721.13 5.37 10-400-540010 Building & Grounds Maint.47,126.00 39,274.64 689.75 7,161.61 15.20 10-400-541030 Vehicle Wash 1,608.00 1,340.00 0.00 268.00 16.67 10-400-546010 Clothing Expense 35,000.00 24,979.29 -1,586.06 11,606.77 33.16 10-400-546020 Uniform Cleaning 1,066.00 1,065.01 0.00 0.99 0.09 10-400-547010 Equipment Maintenance 15,300.00 10,198.54 0.00 5,101.46 33.34 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-547020 Maintenance Agreements 17,400.00 12,148.65 1,050.10 4,201.25 24.15 10-400-547030 Radio Maintenance 7,000.00 1,915.61 3,894.00 1,190.39 17.01 E25 Repairs & Maintenance 124,500.00 90,921.74 4,047.79 29,530.47 23.72 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 815,000.00 790,091.40 0.00 24,908.60 3.06 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 815,000.00 790,091.40 0.00 24,908.60 3.06 400 Fire Department 7,279,383.03 6,712,943.55 4,047.79 562,391.69 7.73 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 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 -229.50 0.00 229.50 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 -229.50 0.00 229.50 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 -229.50 0.00 229.50 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 202,276.20 187,443.48 0.00 14,832.72 7.33 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,473.42 13,824.27 0.00 1,649.15 10.66 10-520-502020 Group Health Insurance 28,707.00 26,390.62 0.00 2,316.38 8.07 10-520-502030 Retirement 35,451.00 35,129.26 0.00 321.74 0.91 10-520-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-520-502050 Life Insurance 360.00 316.24 0.00 43.76 12.16 10-520-502060 Long Term Disability 494.76 467.24 0.00 27.52 5.56 10-520-502070 Employee Assistance Prgm 88.80 86.84 0.00 1.96 2.21 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,851.18 263,657.95 0.00 19,193.23 6.79 10-520-511010 Advertising 500.00 470.55 0.00 29.45 5.89 10-520-511020 Postage 165.00 153.35 0.00 11.65 7.06 10-520-512010 Printing 85.00 45.00 0.00 40.00 47.06 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 500.00 473.23 18.25 8.52 1.70 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 150.00 18.00 0.00 132.00 88.00 E10 Materials & Supplies 1,400.00 1,160.13 18.25 221.62 15.83 10-520-520030 Dues And Publications 400.00 266.75 0.00 133.25 33.31 10-520-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 99.00 99.00 0.00 0.00 0.00 10-520-522020 Professional Services 600.00 95.65 0.00 504.35 84.06 E15 Contractual Services 1,099.00 461.40 0.00 637.60 58.02 10-520-534010 Telephone 74.19 0.00 0.00 74.19 100.00 E20 Utilities 74.19 0.00 0.00 74.19 100.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 770.81 713.83 47.60 9.38 1.22 E25 Repairs & Maintenance 770.81 713.83 47.60 9.38 1.22 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 520 Plan & Protect Svcs-Admin 286,195.18 265,993.31 65.85 20,136.02 7.04 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,387.60 47,300.46 0.00 4,087.14 7.95 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)12,480.00 10,368.00 0.00 2,112.00 16.92 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,657.08 4,411.66 0.00 1,245.42 22.02 10-521-502020 Group Health Insurance 5,638.50 5,482.71 0.00 155.79 2.76 10-521-502030 Retirement 9,009.20 8,864.46 0.00 144.74 1.61 10-521-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-521-502050 Life Insurance 90.00 79.50 0.00 10.50 11.67 10-521-502060 Long Term Disability 121.21 127.42 0.00 -6.21 -5.12 10-521-502070 Employee Assistance Prgm 22.20 21.70 0.00 0.50 2.25 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 84,405.79 76,655.91 0.00 7,749.88 9.18 10-521-511010 Advertising 5,300.00 2,573.75 0.00 2,726.25 51.44 10-521-511020 Postage 2,000.00 1,007.42 0.00 992.58 49.63 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 100.00 2.32 0.00 97.68 97.68 10-521-512030 Photographic Supplies 30.00 0.00 0.00 30.00 100.00 10-521-513010 Office Supplies 1,265.00 930.67 15.00 319.33 25.24 10-521-514040 Food 0.00 0.00 0.00 0.00 0.00 10-521-515040 First Aid Supplies 10.00 0.00 0.00 10.00 100.00 10-521-517010 Operational Supplies 2,000.00 1,967.10 0.00 32.90 1.65 E10 Materials & Supplies 10,705.00 6,481.26 15.00 4,208.74 39.32 10-521-520030 Dues And Publications 15,100.00 15,083.70 0.00 16.30 0.11 10-521-520050 Meeting And Conferences 322.00 0.00 0.00 322.00 100.00 10-521-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 78.00 78.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 15,500.00 15,161.70 0.00 338.30 2.18 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,710.00 1,433.81 233.27 42.92 2.51 E25 Repairs & Maintenance 1,710.00 1,433.81 233.27 42.92 2.51 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 521 Plan & Protect Svcs-Planning 112,320.79 99,732.68 248.27 12,339.84 10.99 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 126,439.20 106,711.60 0.00 19,727.60 15.60 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 9,669.66 7,523.54 0.00 2,146.12 22.19 10-522-502020 Group Health Insurance 17,556.00 12,743.74 0.00 4,812.26 27.41 10-522-502030 Retirement 22,159.40 18,021.71 0.00 4,137.69 18.67 10-522-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-522-502050 Life Insurance 220.00 155.28 0.00 64.72 29.42 10-522-502060 Long Term Disability 312.98 244.61 0.00 68.37 21.84 10-522-502070 Employee Assistance Prgm 44.40 43.41 0.00 0.99 2.23 E05 Personnel Services 176,401.64 145,443.89 0.00 30,957.75 17.55 10-522-511010 Advertising 1,000.00 785.25 0.00 214.75 21.48 10-522-511020 Postage 700.00 144.92 0.00 555.08 79.30 10-522-512010 Printing 700.00 72.00 0.00 628.00 89.71 10-522-512020 Copies 500.00 0.00 0.00 500.00 100.00 10-522-513010 Office Supplies 500.00 451.99 5.00 43.01 8.60 10-522-514040 Food 300.00 183.53 0.00 116.47 38.82 10-522-517010 Operational Supplies 800.00 41.75 0.00 758.25 94.78 E10 Materials & Supplies 4,500.00 1,679.44 5.00 2,815.56 62.57 10-522-520030 Dues And Publications 800.00 730.49 0.00 69.51 8.69 10-522-520050 Meeting And Conferences 2,188.00 972.58 0.00 1,215.42 55.55 10-522-520070 Training And Education 1,874.42 776.54 0.00 1,097.88 58.57 10-522-522020 Professional Services 0.00 0.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 4,862.42 2,479.61 0.00 2,382.81 49.00 10-522-534010 Telephone 100.00 0.00 0.00 100.00 100.00 E20 Utilities 100.00 0.00 0.00 100.00 100.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 2,925.58 613.20 116.80 2,195.58 75.05 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,925.58 613.20 116.80 2,195.58 75.05 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 188,789.64 150,216.14 121.80 38,451.70 20.37 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 112,433.52 64,715.27 0.00 47,718.25 42.44 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 8,596.77 4,571.05 0.00 4,025.72 46.83 10-530-502020 Group Health Insurance 9,658.85 6,490.38 0.00 3,168.47 32.80 10-530-502030 Retirement 19,432.96 6,825.04 0.00 12,607.92 64.88 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 157.32 99.15 0.00 58.17 36.98 10-530-502060 Long Term Disability 281.51 157.10 0.00 124.41 44.19 10-530-502070 Employee Assistance Prgm 37.57 43.41 0.00 -5.84 -15.54 E05 Personnel Services 150,598.50 82,901.40 0.00 67,697.10 44.95 10-530-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-530-511020 Postage 26.00 23.91 0.00 2.09 8.04 10-530-513010 Office Supplies 175.00 168.89 1.25 4.86 2.78 E10 Materials & Supplies 201.00 192.80 1.25 6.95 3.46 10-530-520030 Dues And Publications 324.00 324.00 0.00 0.00 0.00 10-530-520050 Meeting And Conferences 681.98 681.98 0.00 0.00 0.00 10-530-520070 Training And Education 211.00 211.00 0.00 0.00 0.00 E15 Contractual Services 1,216.98 1,216.98 0.00 0.00 0.00 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 492.02 383.62 64.90 43.50 8.84 E25 Repairs & Maintenance 492.02 383.62 64.90 43.50 8.84 10-530-550020 Neighborhood Reinvestment 28,565.00 28,532.00 0.00 33.00 0.12 10-530-550030 Old Town Projects 57,468.00 26,264.10 0.00 31,203.90 54.30 10-530-550035 Old Town Redev Committee 10,000.00 7,735.70 0.00 2,264.30 22.64 10-530-550037 Historic Preservation Comm 15,650.00 12,985.00 0.00 2,665.00 17.03 10-530-550050 Neighb Stablization Prog 101,406.88 1,123.25 0.00 100,283.63 98.89 10-530-550060 MSP 1,304,060.97 119,638.83 0.00 1,184,422.14 90.83 10-530-550090 Hazard Mitigation 272,029.23 54,364.42 0.00 217,664.81 80.02 E30 Other Operating Expenses 1,789,180.08 250,643.30 0.00 1,538,536.78 85.99 530 Plan & Protect Svc-RedevGrant 1,941,688.58 335,338.10 66.15 1,606,284.33 82.73 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 403,257.40 373,198.08 0.00 30,059.32 7.45 10-531-501060 Seasonal Salaries 21,320.00 0.00 0.00 21,320.00 100.00 10-531-501090 Overtime 740.00 0.00 0.00 740.00 100.00 10-531-501095 Overtime Straight Pay 130.00 0.00 0.00 130.00 100.00 10-531-502010 Social Security 42,061.01 27,044.70 0.00 15,016.31 35.70 10-531-502020 Group Health Insurance 51,516.11 50,775.16 0.00 740.95 1.44 10-531-502030 Retirement 68,838.57 63,413.26 0.00 5,425.31 7.88 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 656.52 539.18 0.00 117.34 17.87 10-531-502060 Long Term Disability 912.49 903.13 0.00 9.36 1.03 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-502070 Employee Assistance Prgm 163.08 173.65 0.00 -10.57 -6.48 E05 Personnel Services 589,595.18 516,047.16 0.00 73,548.02 12.47 10-531-511010 Advertising 200.00 45.50 0.00 154.50 77.25 10-531-511020 Postage 1,900.00 1,818.82 0.00 81.18 4.27 10-531-512010 Printing 600.00 159.00 0.00 441.00 73.50 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00 10-531-513010 Office Supplies 1,829.00 1,619.26 58.49 151.25 8.27 10-531-514030 Small Tools 300.00 203.07 0.00 96.93 32.31 10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-531-517010 Operational Supplies 1,589.42 1,522.65 0.00 66.77 4.20 E10 Materials & Supplies 6,558.42 5,368.30 58.49 1,131.63 17.25 10-531-520030 Dues And Publications 2,000.00 945.40 0.00 1,054.60 52.73 10-531-520050 Meeting And Conferences 719.96 143.00 0.00 576.96 80.14 10-531-520070 Training And Education 2,500.00 1,931.99 0.00 568.01 22.72 10-531-522020 Professional Services 26,024.90 24,075.50 0.00 1,949.40 7.49 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 31,244.86 27,095.89 0.00 4,148.97 13.28 10-531-534010 Telephone 137.98 0.00 0.00 137.98 100.00 E20 Utilities 137.98 0.00 0.00 137.98 100.00 10-531-541030 Vehicle Wash 540.00 465.00 0.00 75.00 13.89 10-531-546010 Clothing Expense 1,130.00 778.81 0.00 351.19 31.08 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,982.64 1,396.50 457.58 128.56 6.48 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,712.64 2,640.31 457.58 614.75 16.56 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 631,249.08 551,151.66 516.07 79,581.35 12.61 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 114,362.40 119,058.15 0.00 -4,695.75 -4.11 10-532-501060 Seasonal Salaries 3,957.00 2,247.50 0.00 1,709.50 43.20 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,381.54 8,924.03 0.00 1,457.51 14.04 10-532-502020 Group Health Insurance 17,356.50 17,396.64 0.00 -40.14 -0.23 10-532-502030 Retirement 20,099.00 22,313.39 0.00 -2,214.39 -11.02 10-532-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-532-502050 Life Insurance 200.00 200.33 0.00 -0.33 -0.17 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502060 Long Term Disability 282.69 319.22 0.00 -36.53 -12.92 10-532-502070 Employee Assistance Prgm 44.40 43.41 0.00 0.99 2.23 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 166,963.53 170,502.67 0.00 -3,539.14 -2.12 10-532-511010 Advertising 800.00 84.50 0.00 715.50 89.44 10-532-511020 Postage 500.00 148.07 0.00 351.93 70.39 10-532-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-532-512020 Copies 19.96 0.35 0.00 19.61 98.25 10-532-512030 Photographic Supplies 20.00 0.00 0.00 20.00 100.00 10-532-513010 Office Supplies 1,800.00 857.13 474.73 468.15 26.01 10-532-514030 Small Tools 50.00 31.98 0.00 18.02 36.04 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 30.00 19.36 0.00 10.64 35.47 10-532-517010 Operational Supplies 1,800.00 1,128.89 473.48 197.64 10.98 E10 Materials & Supplies 5,019.96 2,270.28 948.20 1,801.48 35.89 10-532-520030 Dues And Publications 880.00 794.90 0.00 85.10 9.67 10-532-520050 Meeting And Conferences 400.00 255.00 0.00 145.00 36.25 10-532-520070 Training And Education 400.00 229.00 0.00 171.00 42.75 10-532-521040 Medical Claimsservices 100.00 0.00 0.00 100.00 100.00 10-532-522020 Professional Services 3,200.00 2,045.00 1,155.00 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 0.00 0.00 1,000.00 100.00 10-532-524025 Glass Recycling 6,247.82 5,042.78 1,210.00 -4.96 -0.08 10-532-524026 Household Hazardous Waste 16,000.00 8,563.81 -1,660.85 9,097.04 56.86 10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 7,752.18 5,650.25 0.00 2,101.93 27.11 10-532-524030 Compost Services 212,000.04 194,333.37 17,666.67 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 247,980.04 216,914.11 18,370.82 12,695.11 5.12 10-532-534010 Telephone 1,320.00 0.00 0.00 1,320.00 100.00 E20 Utilities 1,320.00 0.00 0.00 1,320.00 100.00 10-532-540060 Cemetery Maintenance 22,956.42 21,028.28 1,910.00 18.14 0.08 10-532-540065 Cemetery Exp from Donations 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,070.00 0.00 220.00 17.05 10-532-546010 Clothing Expense 520.00 160.00 0.00 360.00 69.23 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,018.68 776.05 142.44 100.19 9.84 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 25,865.10 23,034.33 2,052.44 778.33 3.01 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 447,148.63 412,721.39 21,371.46 13,055.78 2.92 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 535 Public Works-Central Maintenan 10-535-501020 Salaries 343,750.20 306,319.81 0.00 37,430.39 10.89 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 6,360.62 0.00 1,039.38 14.05 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 1,800.00 1,629.98 0.00 170.02 9.45 10-535-501095 Overtime Straight Pay 200.00 63.14 0.00 136.86 68.43 10-535-502010 Social Security 27,395.62 22,467.15 0.00 4,928.47 17.99 10-535-502020 Group Health Insurance 70,056.00 69,999.17 0.00 56.83 0.08 10-535-502030 Retirement 61,498.90 57,723.35 0.00 3,775.55 6.14 10-535-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-535-502050 Life Insurance 600.00 510.70 0.00 89.30 14.88 10-535-502060 Long Term Disability 848.09 813.78 0.00 34.31 4.05 10-535-502070 Employee Assistance Prgm 177.60 173.65 0.00 3.95 2.22 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 513,726.41 466,061.35 0.00 47,665.06 9.28 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 285.00 13.04 0.00 271.96 95.42 10-535-512020 Copies 0.70 0.70 0.00 0.00 0.00 10-535-513010 Office Supplies 1,899.30 1,293.68 0.00 605.62 31.89 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,900.00 6,041.74 0.00 1,858.26 23.52 10-535-517010 Operational Supplies 9,115.00 9,113.68 0.00 1.32 0.01 E10 Materials & Supplies 19,280.00 16,462.84 0.00 2,817.16 14.61 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 Meeting And Conferences 400.00 24.00 0.00 376.00 94.00 10-535-520070 Training And Education 1,000.00 412.51 0.00 587.49 58.75 10-535-521040 Medical Claimsservices 430.00 0.00 0.00 430.00 100.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 1,830.00 436.51 0.00 1,393.49 76.15 10-535-531010 Electricity 7,470.00 6,642.34 0.00 827.66 11.08 10-535-533010 Natural Gas 6,950.00 6,666.46 0.00 283.54 4.08 10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-535-535010 Water 1,215.00 1,250.15 0.00 -35.15 -2.89 E20 Utilities 15,635.00 14,558.95 0.00 1,076.05 6.88 10-535-540010 Building & Grounds Maint.8,769.41 6,034.58 25.00 2,709.83 30.90 10-535-541010 Veh & Equip Parts Etc 405,000.00 292,037.28 0.00 112,962.72 27.89 10-535-546010 Clothing Expense 7,000.00 6,749.54 0.00 250.46 3.58 10-535-547010 Equipment Maintenance 3,230.59 3,230.59 0.00 0.00 0.00 10-535-547020 Maintenance Agreements 3,500.00 2,571.25 0.00 928.75 26.54 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 428,000.00 310,623.24 25.00 117,351.76 27.42 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 978,471.41 808,142.89 25.00 170,303.52 17.41 540 Public Works-Admin 10-540-501020 Salaries 189,536.40 174,579.45 0.00 14,956.95 7.89 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 16,164.30 12,499.16 0.00 3,665.14 22.67 10-540-502020 Group Health Insurance 23,278.50 22,518.65 0.00 759.85 3.26 10-540-502030 Retirement 37,228.60 32,475.07 0.00 4,753.53 12.77 10-540-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-540-502050 Life Insurance 410.00 283.65 0.00 126.35 30.82 10-540-502060 Long Term Disability 524.46 396.18 0.00 128.28 24.46 10-540-502070 Employee Assistance Prgm 66.60 65.11 0.00 1.49 2.24 E05 Personnel Services 267,208.86 242,817.27 0.00 24,391.59 9.13 10-540-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-540-511020 Postage 230.00 11.48 0.00 218.52 95.01 10-540-512010 Printing 1,230.00 201.00 0.00 1,029.00 83.66 10-540-512020 Copies 100.00 0.18 0.00 99.82 99.82 10-540-513010 Office Supplies 1,100.00 363.21 0.00 736.79 66.98 10-540-514040 Food 650.00 632.49 0.00 17.51 2.69 10-540-517010 Operational Supplies 1,400.00 4.99 0.00 1,395.01 99.64 E10 Materials & Supplies 5,110.00 1,213.35 0.00 3,896.65 76.26 10-540-520030 Dues And Publications 1,300.00 500.50 0.00 799.50 61.50 10-540-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,400.00 698.00 0.00 1,702.00 70.92 10-540-522020 Professional Services 900.00 163.15 0.00 736.85 81.87 10-540-527010 Comm Serv Projects 1,000.00 85.35 0.00 914.65 91.47 E15 Contractual Services 5,600.00 1,447.00 0.00 4,153.00 74.16 10-540-534010 Telephone 924.00 0.00 0.00 924.00 100.00 E20 Utilities 924.00 0.00 0.00 924.00 100.00 10-540-547020 Maintenance Agreements 930.00 717.98 142.44 69.58 7.48 E25 Repairs & Maintenance 930.00 717.98 142.44 69.58 7.48 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 279,772.86 246,195.60 142.44 33,434.82 11.95 541 Public Works-Engineering 10-541-501020 Salaries 742,215.90 689,866.83 0.00 52,349.07 7.05 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-501060 Seasonal Salaries 1,950.00 993.75 0.00 956.25 49.04 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 550.00 545.82 0.00 4.18 0.76 10-541-501095 Overtime Straight Pay 500.00 27.99 0.00 472.01 94.40 10-541-502010 Social Security 57,855.03 50,508.90 0.00 7,346.13 12.70 10-541-502020 Group Health Insurance 102,005.55 90,852.73 0.00 11,152.82 10.93 10-541-502030 Retirement 129,184.51 129,414.54 0.00 -230.03 -0.18 10-541-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-541-502050 Life Insurance 1,299.69 1,149.62 0.00 150.07 11.55 10-541-502060 Long Term Disability 1,819.00 1,796.31 0.00 22.69 1.25 10-541-502070 Employee Assistance Prgm 275.79 303.90 0.00 -28.11 -10.19 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,037,655.47 965,460.39 0.00 72,195.08 6.96 10-541-511010 Advertising 1,400.00 969.50 0.00 430.50 30.75 10-541-511020 Postage 1,500.00 387.78 0.00 1,112.22 74.15 10-541-512010 Printing 100.00 31.00 0.00 69.00 69.00 10-541-512020 Copies 199.65 110.08 0.00 89.57 44.86 10-541-512030 Photographic Supplies 175.35 0.00 0.00 175.35 100.00 10-541-513010 Office Supplies 7,900.00 3,437.68 0.00 4,462.32 56.49 10-541-514030 Small Tools 500.00 469.15 0.00 30.85 6.17 10-541-514040 Food 150.00 100.47 0.00 49.53 33.02 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 2,000.00 983.67 0.00 1,016.33 50.82 10-541-515080 Surveying Supplies 2,000.00 958.11 0.00 1,041.89 52.09 10-541-517010 Operational Supplies 1,150.00 339.75 0.00 810.25 70.46 E10 Materials & Supplies 17,125.00 7,787.19 0.00 9,337.81 54.53 10-541-520030 Dues And Publications 4,000.00 3,279.77 0.00 720.23 18.01 10-541-520050 Meeting And Conferences 1,000.00 240.00 0.00 760.00 76.00 10-541-520070 Training And Education 2,500.00 869.00 0.00 1,631.00 65.24 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 4,000.00 2,768.00 0.00 1,232.00 30.80 E15 Contractual Services 11,500.00 7,156.77 0.00 4,343.23 37.77 10-541-534010 Telephone 1,650.00 412.59 0.00 1,237.41 74.99 E20 Utilities 1,650.00 412.59 0.00 1,237.41 74.99 10-541-541020 Veh Maintenance 480.00 0.00 0.00 480.00 100.00 10-541-541030 Vehicle Wash 800.00 800.00 0.00 0.00 0.00 10-541-546010 Clothing Expense 1,000.00 591.07 0.00 408.93 40.89 10-541-547010 Equipment Maintenance 1,480.00 588.45 0.00 891.55 60.24 10-541-547020 Maintenance Agreements 17,000.00 8,201.86 345.76 8,452.38 49.72 10-541-547030 Radio Maintenance 200.00 0.00 0.00 200.00 100.00 E25 Repairs & Maintenance 20,960.00 10,181.38 345.76 10,432.86 49.78 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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 1,088,890.47 990,998.32 345.76 97,546.39 8.96 542 Public Works-Street 10-542-501020 Salaries 1,096,536.31 966,482.27 0.00 130,054.04 11.86 10-542-501060 Seasonal Salaries 9,964.69 13,969.47 0.00 -4,004.78 -40.19 10-542-501070 Stand-by Plan 4,081.31 3,980.00 0.00 101.31 2.48 10-542-501090 Overtime 20,500.00 22,522.41 0.00 -2,022.41 -9.87 10-542-501095 Overtime Straight Pay 1,500.00 334.51 0.00 1,165.49 77.70 10-542-502010 Social Security 96,881.84 75,010.66 0.00 21,871.18 22.58 10-542-502020 Group Health Insurance 174,072.88 141,423.30 0.00 32,649.58 18.76 10-542-502030 Retirement 196,864.18 180,363.10 0.00 16,501.08 8.38 10-542-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-542-502050 Life Insurance 1,904.14 1,584.24 0.00 319.90 16.80 10-542-502060 Long Term Disability 2,659.61 2,502.61 0.00 157.00 5.90 10-542-502070 Employee Assistance Prgm 545.60 564.36 0.00 -18.76 -3.44 10-542-503010 Awards Program 350.00 335.00 0.00 15.00 4.29 10-542-503020 Unemployment Compensation 250.00 247.36 0.00 2.64 1.06 E05 Personnel Services 1,606,110.56 1,409,319.29 0.00 196,791.27 12.25 10-542-511010 Advertising 400.00 323.75 0.00 76.25 19.06 10-542-511020 Postage 150.00 148.13 0.00 1.87 1.25 10-542-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-542-512020 Copies 50.35 33.29 0.00 17.06 33.88 10-542-513010 Office Supplies 1,700.00 994.00 0.00 706.00 41.53 10-542-514020 Chemicals 50,000.00 49,292.66 0.00 707.34 1.41 10-542-514030 Small Tools 9,000.00 7,480.43 0.00 1,519.57 16.88 10-542-514040 Food 1,385.38 1,307.79 0.00 77.59 5.60 10-542-515010 Stormwater Material 17,500.00 15,802.94 0.00 1,697.06 9.70 10-542-515020 Street Materials 242,837.00 182,144.70 -72,647.36 133,339.66 54.91 10-542-515040 First Aid Supplies 500.00 40.55 0.00 459.45 91.89 10-542-515060 Weed Control 2,000.00 378.88 0.00 1,621.12 81.06 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 4,500.00 4,380.88 0.00 119.12 2.65 E10 Materials & Supplies 330,272.73 262,328.00 -72,647.36 140,592.09 42.57 10-542-520030 Dues And Publications 446.00 371.00 0.00 75.00 16.82 10-542-520050 Meeting And Conferences 389.27 0.00 0.00 389.27 100.00 10-542-520070 Training And Education 1,000.00 269.00 0.00 731.00 73.10 10-542-521040 Medical Claimsservices 295.00 0.00 0.00 295.00 100.00 10-542-522020 Professional Services 15,711.00 15,006.10 660.00 44.90 0.29 10-542-523010 Equipment Rentlease 1,000.00 825.00 0.00 175.00 17.50 10-542-524010 Trash Collections 4,983.00 589.60 0.00 4,393.40 88.17 10-542-529070 Street Light Installation 1,676.00 1,582.89 0.00 93.11 5.56 E15 Contractual Services 25,500.27 18,643.59 660.00 6,196.68 24.30 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-531010 Electricity 42,500.00 24,074.26 0.00 18,425.74 43.35 10-542-531020 Street Lights 527,900.00 541,309.54 0.00 -13,409.54 -2.54 10-542-533010 Natural Gas 16,385.00 13,305.35 0.00 3,079.65 18.80 10-542-534010 Telephone 1,250.00 487.00 0.00 763.00 61.04 10-542-535010 Water 7,800.00 5,531.61 0.00 2,268.39 29.08 E20 Utilities 595,835.00 584,707.76 0.00 11,127.24 1.87 10-542-540010 Building & Grounds Maint.9,287.00 8,164.49 50.00 1,072.51 11.55 10-542-541030 Vehicle Wash 6,365.00 5,790.00 0.00 575.00 9.03 10-542-542010 Repairs - Stop Lights 10,000.00 7,090.50 0.00 2,909.50 29.10 10-542-542030 Signs & Marking Paint 31,629.88 31,629.38 0.00 0.50 0.00 10-542-546010 Clothing Expense 12,000.00 6,679.61 0.00 5,320.39 44.34 10-542-547010 Equipment Maintenance 3,100.00 1,515.87 0.00 1,584.13 51.10 10-542-547020 Maintenance Agreements 1,275.12 309.60 0.00 965.52 75.72 10-542-547030 Radio Maintenance 100.00 55.00 0.00 45.00 45.00 E25 Repairs & Maintenance 73,757.00 61,234.45 50.00 12,472.55 16.91 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 542 Public Works-Street 2,631,475.56 2,336,233.09 -71,937.36 367,179.83 13.95 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 1,682.28 0.00 2,317.72 57.94 10-700-590070 Airport Subsidy 171,635.85 143,029.89 0.00 28,605.96 16.67 10-700-590075 Transit Subsidy 689,630.76 592,133.20 0.00 97,497.56 14.14 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 865,266.61 736,845.37 0.00 128,421.24 14.84 700 Transfers & Subsidies 865,266.61 736,845.37 0.00 128,421.24 14.84 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 96,371.20 96,371.20 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 161,268.00 161,268.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 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 55,318.00 54,398.00 0.00 920.00 1.66 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 312,957.20 312,037.20 0.00 920.00 0.29 900 CapitalVehicleEquipment 312,957.20 312,037.20 0.00 920.00 0.29 990 Capital Projects 10-990-577042 Mo Blvd Sidewalks 370,978.00 85,587.11 280,707.84 4,683.05 1.26 10-990-577044 Water Street @ Lohman Landing 473,460.00 0.00 10,790.68 462,669.32 97.72 10-990-577045 Clay Street Plaza 72,800.00 0.00 0.00 72,800.00 100.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 917,238.00 85,587.11 291,498.52 540,152.37 58.89 990 Capital Projects 917,238.00 85,587.11 291,498.52 540,152.37 58.89 Expense Expense 34,533,228.82 27,835,283.17 449,767.18 6,248,178.47 18.09 GL - Trial Balance by Full Acct Number (10/14/2013 - 10:51 AM)Page 33 FUND BALANCE CALCULATION FYE 12 Unassigned General Fund Balance 4,681,316.00$ Per Audited CAFR Reappropriation (50,417.16)$ Cole County Emergency Siren Reappropriation (100,000.00)$ Prof Svcs to Columbia Airport Reappropriation (815,000.00)$ Fire Dept ONE TIME PUCHASES Reappropriation (23,851.06)$ Court Software - not completed in prior fiscal year Supplemental Appropriation (5,000.00)$ Establish UHC Deductible Self Insurance Imprest Fund Supplemental Appropriation (40,000.00)$ Election Expenses Estimated Current Fund Balance 3,647,047.78$ CURRENT CURRENT YEAR-YTD 2012-2013 MONTH TO-DATE %BUDGET FUND BUDGET ACTIVITY ACTUAL RECEIVED/SPENT VARIANCE REVENUES: Property Taxes $5,221,000 $18,845.41 $5,216,288.65 100%($4,711) Sales Tax & Sale Tax Interest $9,700,000 $546,351.36 $6,232,318.77 64%($3,467,681) Motor Vehicle Sales Tax $403,750 $41,832.25 $305,468.60 76%($98,281) Gasoline Tax $1,100,950 $93,588.42 $715,196.24 65%($385,754) Cigarette Tax $147,000 $11,653.52 $96,208.56 65%($50,791) Franchise Fees $7,385,000 $668,382.59 $5,432,792.12 74%($1,952,208) Intergovernmental $3,656,325 $84,751.39 $1,028,945.08 28%($2,627,380) Charges for Services $1,988,660 $155,856.63 $1,554,794.51 78%($433,865) Fees, Licenses & Permits $689,700 $61,435.97 $636,554.33 92%($53,146) Fines & Forfeitures $1,050,980 $88,033.22 $803,174.41 76%($247,806) Interest Income $40,000 $10,168.98 $83,595.30 209%$43,595 Other Operating Revenues $1,270,297 $67,516.38 $959,720.10 76%($310,577) Operating Transfers In $20,990 $1,855.93 $34,076.75 162%$13,087 Police Grants $612,505 $115,585.49 $378,239.00 62%($234,266) School Resource Officer $188,765 $0.00 $192,242.34 102%$3,477 M.U.S.T.A.N.G.$0 $2,986.67 $27,308.33 N/A $27,308 Transfer from (to) Surplus $986,566 $0.00 $0.00 N/A ($986,566) Total General Fund $34,462,488 $1,968,844.21 $23,696,923.09 69%($10,765,565) EXPENDITURES: Council & Mayor $76,558 $5,838.34 $58,705.73 77%($17,852) City Clerk $172,826 $7,368.90 $147,196.89 85%($25,629) City Administrator $280,072 $19,458.30 $232,882.60 83%($47,189) Entitlement Grant $594,413 $1,409.63 $46,728.39 8%($547,685) City Counselor $342,026 $25,777.82 $268,432.18 78%($73,594) Municipal Court $278,089 $19,266.88 $188,457.64 68%($89,631) Human Resources $298,079 $20,993.22 $228,559.76 77%($69,519) Finance $928,514 $64,577.14 $724,228.13 78%($204,285) Non Departmental $2,563,946 $69,028.89 $1,659,542.79 65%($904,403) IT Department $1,081,064 $67,117.08 $855,270.15 79%($225,793) Police $7,353,905 $522,751.61 $5,666,925.64 77%($1,686,980) School Resource Officer $356,115 $22,624.68 $261,220.22 73%($94,895) M.U.S.T.A.N.G.$184,859 $13,271.66 $146,741.15 79%($38,117) Animal Control $668,282 $49,538.52 $526,496.76 79%($141,785) 9-1-1 Police $1,393,636 $100,064.95 $1,101,563.82 79%($292,072) Fire $7,279,383 $537,774.85 $5,998,484.50 82%($1,280,899) Public Works $0 $0.00 ($229.50)N/A ($230) Planning & Protective Services Admin $286,195 $22,704.32 $232,458.62 81%($53,737) Planning $112,321 $7,063.14 $89,616.98 80%($22,704) Metropolitan Planning Org $188,790 $8,439.30 $137,944.36 73%($50,845) Redevelopment/Grant $1,941,689 $7,264.66 $312,436.68 16%($1,629,252) Building Regulations $631,249 $42,207.54 $466,007.83 74%($165,241) Environmental Health $447,149 $53,310.63 $366,584.58 82%($80,564) Public Works - Central Main $978,471 $66,339.33 $700,286.59 72%($278,185) Public Works - Admin $279,773 $20,645.55 $214,957.18 77%($64,816) Public Works - Engineering $1,088,890 $79,837.61 $871,156.17 80%($217,734) Public Works - Street $2,631,476 $192,142.82 $2,029,508.35 77%($601,967) Transfers & Subsidies $865,267 $63,051.76 $736,845.37 85%($128,421) Capital/Vehicle/Equipment $312,957 $257,639.20 $312,037.20 100%($920) Capital Projects $917,238 $0.00 $0.00 0%($917,238) $34,533,228 $2,367,508.33 $24,581,046.76 71%($9,952,182) Fund Income (Loss)($70,740)*($398,664.12)($884,123.67)($813,383) CITY OF JEFFERSON GENERAL FUND INCOME STATEMENT FOR THE MONTH ENDING AUGUST 31, 2013 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. SOURCES AND USES OF FUNDS City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - Dated Date12/01/2013 Delivery Date12/01/2013 Sources: Bond Proceeds: Par Amount7,950,000.00 Net Premium87,253.85 8,037,253.85 Uses: Project Fund Deposits: Project Fund7,898,128.85 Cost of Issuance: ($17.5 / 1000)139,125.00 8,037,253.85 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. BOND DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - Period Annual EndingPrincipalCouponInterestDebt ServiceDebt Service 04/01/2014106,527.08106,527.08 10/01/2014305,0003.000%159,790.63464,790.63 10/31/2014571,317.71 04/01/2015155,215.63155,215.63 10/01/2015260,0003.000%155,215.63415,215.63 10/31/2015570,431.26 04/01/2016151,315.63151,315.63 10/01/2016270,0003.000%151,315.63421,315.63 10/31/2016572,631.26 04/01/2017147,265.63147,265.63 10/01/2017280,0003.000%147,265.63427,265.63 10/31/2017574,531.26 04/01/2018143,065.63143,065.63 10/01/2018285,0003.000%143,065.63428,065.63 10/31/2018571,131.26 04/01/2019138,790.63138,790.63 10/01/2019295,0003.000%138,790.63433,790.63 10/31/2019572,581.26 04/01/2020134,365.63134,365.63 10/01/2020305,0003.000%134,365.63439,365.63 10/31/2020573,731.26 04/01/2021129,790.63129,790.63 10/01/2021315,0003.000%129,790.63444,790.63 10/31/2021574,581.26 04/01/2022125,065.63125,065.63 10/01/2022320,0003.375%125,065.63445,065.63 10/31/2022570,131.26 04/01/2023119,665.63119,665.63 10/01/2023335,0003.375%119,665.63454,665.63 10/31/2023574,331.26 04/01/2024114,012.50114,012.50 10/01/2024345,0004.000%114,012.50459,012.50 10/31/2024573,025.00 04/01/2025107,112.50107,112.50 10/01/2025360,0004.000%107,112.50467,112.50 10/31/2025574,225.00 04/01/202699,912.5099,912.50 10/01/2026375,0004.000%99,912.50474,912.50 10/31/2026574,825.00 04/01/202792,412.5092,412.50 10/01/2027385,0004.000%92,412.50477,412.50 10/31/2027569,825.00 04/01/202884,712.5084,712.50 10/01/2028405,0004.500%84,712.50489,712.50 10/31/2028574,425.00 04/01/202975,600.0075,600.00 10/01/2029420,0004.500%75,600.00495,600.00 10/31/2029571,200.00 04/01/203066,150.0066,150.00 10/01/2030440,0004.500%66,150.00506,150.00 10/31/2030572,300.00 04/01/203156,250.0056,250.00 10/01/2031460,0005.000%56,250.00516,250.00 10/31/2031572,500.00 04/01/203244,750.0044,750.00 10/01/2032485,0005.000%44,750.00529,750.00 10/31/2032574,500.00 04/01/203332,625.0032,625.00 10/01/2033505,0005.000%32,625.00537,625.00 10/31/2033570,250.00 04/01/203420,000.0020,000.00 10/01/2034530,0005.000%20,000.00550,000.00 10/31/2034570,000.00 04/01/20356,750.006,750.00 10/01/2035270,0005.000%6,750.00276,750.00 10/31/2035283,500.00 7,950,0004,355,974.0512,305,974.0512,305,974.05 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. NET DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - PeriodTotalNet EndingPrincipalCouponInterestDebt ServiceDebt Service 10/31/2014305,0003.000%266,317.71571,317.71571,317.71 10/31/2015260,0003.000%310,431.26570,431.26570,431.26 10/31/2016270,0003.000%302,631.26572,631.26572,631.26 10/31/2017280,0003.000%294,531.26574,531.26574,531.26 10/31/2018285,0003.000%286,131.26571,131.26571,131.26 10/31/2019295,0003.000%277,581.26572,581.26572,581.26 10/31/2020305,0003.000%268,731.26573,731.26573,731.26 10/31/2021315,0003.000%259,581.26574,581.26574,581.26 10/31/2022320,0003.375%250,131.26570,131.26570,131.26 10/31/2023335,0003.375%239,331.26574,331.26574,331.26 10/31/2024345,0004.000%228,025.00573,025.00573,025.00 10/31/2025360,0004.000%214,225.00574,225.00574,225.00 10/31/2026375,0004.000%199,825.00574,825.00574,825.00 10/31/2027385,0004.000%184,825.00569,825.00569,825.00 10/31/2028405,0004.500%169,425.00574,425.00574,425.00 10/31/2029420,0004.500%151,200.00571,200.00571,200.00 10/31/2030440,0004.500%132,300.00572,300.00572,300.00 10/31/2031460,0005.000%112,500.00572,500.00572,500.00 10/31/2032485,0005.000%89,500.00574,500.00574,500.00 10/31/2033505,0005.000%65,250.00570,250.00570,250.00 10/31/2034530,0005.000%40,000.00570,000.00570,000.00 10/31/2035270,0005.000%13,500.00283,500.00283,500.00 7,950,0004,355,974.0512,305,974.0512,305,974.05 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. BOND SUMMARY STATISTICS City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - Dated Date12/01/2013 Delivery Date12/01/2013 Last Maturity10/01/2035 Arbitrage Yield4.224563% True Interest Cost (TIC)4.224563% Net Interest Cost (NIC)4.319255% All-In TIC4.415177% Average Coupon4.407542% Average Life (years)12.431 Weighted Average Maturity (years)12.380 Duration of Issue (years)9.393 Par Amount7,950,000.00 Bond Proceeds8,037,253.85 Total Interest4,355,974.05 Net Interest4,268,720.20 Bond Years from Dated Date98,830,000.00 Bond Years from Delivery Date98,830,000.00 Total Debt Service12,305,974.05 Maximum Annual Debt Service574,825.00 Average Annual Debt Service563,632.40 Underwriter's Fees (per $1000) Average Takedown Other Fee Total Underwriter's Discount Bid Price101.097533 ParAverageAveragePV of 1 bp Bond ComponentValuePriceCouponLifechange Serial Bonds2,315,000.00102.7303.000%4.414964.20 Term Bond655,000.0099.7893.375%9.345543.65 Term Bond #2705,000.00101.6244.000%11.344585.15 Term Bond #3760,000.0098.9474.000%13.340790.40 Term Bond #41,265,000.00100.0004.500%15.8611,480.05 Term Bond #51,450,000.00101.1555.000%18.8641,131.00 Term Bond #6800,000.00100.6565.000%21.1711,072.00 7,950,000.0012.4316,566.45 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. BOND PRICING City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - MaturityYield toCallCallPremium Bond ComponentDateAmountRateYieldPriceMaturityDatePrice(-Discount)Principal Cost Serial Bonds: 10/01/2014305,0003.000%0.650%101.9495,944.45310,944.45 10/01/2015260,0003.000%1.100%103.4388,938.80268,938.80 10/01/2016270,0003.000%1.400%104.42811,955.60281,955.60 10/01/2017280,0003.000%1.750%104.61312,916.40292,916.40 10/01/2018285,0003.000%2.100%104.11411,724.90296,724.90 10/01/2019295,0003.000%2.500%102.6967,953.20302,953.20 10/01/2020305,0003.000%2.800%101.2333,760.65308,760.65 10/01/2021315,0003.000%3.000%100.000315,000.00 2,315,000 63,194.00 2,378,194.00 Term Bond: 10/01/2022320,0003.375%3.400%99.789 (675.20)319,324.80 10/01/2023335,0003.375%3.400%99.789 (706.85)334,293.15 655,000 (1,382.05)653,617.95 Term Bond #2: 10/01/2024345,0004.000%3.800%101.624C3.828%10/01/2023100.0005,602.80350,602.80 10/01/2025360,0004.000%3.800%101.624C3.828%10/01/2023100.0005,846.40365,846.40 705,000 11,449.20 716,449.20 Term Bond #3: 10/01/2026375,0004.000%4.100%98.947 (3,948.75)371,051.25 10/01/2027385,0004.000%4.100%98.947 (4,054.05)380,945.95 760,000 (8,002.80)751,997.20 Term Bond #4: 10/01/2028405,0004.500%4.500%100.000405,000.00 10/01/2029420,0004.500%4.500%100.000420,000.00 10/01/2030440,0004.500%4.500%100.000440,000.00 1,265,000 1,265,000.00 Term Bond #5: 10/01/2031460,0005.000%4.850%101.155C4.908%10/01/2023100.0005,313.00465,313.00 10/01/2032485,0005.000%4.850%101.155C4.908%10/01/2023100.0005,601.75490,601.75 10/01/2033505,0005.000%4.850%101.155C4.908%10/01/2023100.0005,832.75510,832.75 1,450,000 16,747.50 1,466,747.50 Term Bond #6: 10/01/2034530,0005.000%4.950%100.6563,476.80533,476.80 10/01/2035270,0005.000%4.950%100.6561,771.20271,771.20 800,000 5,248.00 805,248.00 7,950,000 87,253.858,037,253.85 Dated Date12/01/2013 Delivery Date12/01/2013 First Coupon04/01/2014 Par Amount7,950,000.00 Premium87,253.85 Production8,037,253.85101.097533% Underwriter's Discount Purchase Price8,037,253.85101.097533% Accrued Interest Net Proceeds8,037,253.85 Oct 14, 2013 3:20 pm Prepared by Piper Jaffray & Co. BOND SOLUTION City of Jefferson, Missouri Certificates of Participation Series 2013 - Preliminary, 'A+' Rated - PeriodProposedProposedTotal AdjRevenueUnusedDebt Serv EndingPrincipalDebt ServiceDebt ServiceConstraintsRevenuesCoverage 10/31/2014305,000571,318571,318575,0003,682100.64453% 10/31/2015260,000570,431570,431575,0004,569100.80093% 10/31/2016270,000572,631572,631575,0002,369100.41366% 10/31/2017280,000574,531574,531575,000469100.08159% 10/31/2018285,000571,131571,131575,0003,869100.67738% 10/31/2019295,000572,581572,581575,0002,419100.42243% 10/31/2020305,000573,731573,731575,0001,269100.22114% 10/31/2021315,000574,581574,581575,000419100.07288% 10/31/2022320,000570,131570,131575,0004,869100.85397% 10/31/2023335,000574,331574,331575,000669100.11644% 10/31/2024345,000573,025573,025575,0001,975100.34466% 10/31/2025360,000574,225574,225575,000775100.13496% 10/31/2026375,000574,825574,825575,000175100.03044% 10/31/2027385,000569,825569,825575,0005,175100.90817% 10/31/2028405,000574,425574,425575,000575100.10010% 10/31/2029420,000571,200571,200575,0003,800100.66527% 10/31/2030440,000572,300572,300575,0002,700100.47178% 10/31/2031460,000572,500572,500575,0002,500100.43668% 10/31/2032485,000574,500574,500575,000500100.08703% 10/31/2033505,000570,250570,250575,0004,750100.83297% 10/31/2034530,000570,000570,000575,0005,000100.87719% 10/31/2035270,000283,500283,500287,5004,000101.41093% 7,950,00012,305,97412,305,97412,362,50056,526 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Convention Center 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 Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 May-12 6/20/12 89,713.24 37,679.58 50,239.40 Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 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 Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 May-13 6/20/13 97,602.44 40,993.02 54,657.37 Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 Total 2,444,701.66 1,026,774.70 1,369,032.94 average monthly amount for Convention Center Fund 48,894.03