Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
20140128 finance packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Tuesday, January 28, 2014 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the November 26, 2013 meeting. 4. Financial Reports – Bill Betts 5. Conference Center Funding – Bill Betts 6. Eliminating position of Engineering Supervisor – Drew Hilpert 7. Purchasing Code Revisions – Drew Hilpert 8. Lodging Tax Report – Shiela Pearre 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, November 26, 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, Bray, Scrivner, Prather, and Graham were in attendance. Next the minutes of the October 22, 2013 meeting were reviewed. Councilman Schulte requested a correction on a discrepancy and then a motion to approve as modified was made by Councilman Graham 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 November sales tax figures, year-to-date general ledger account information, the current fund balance calculation, and the October 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 discussion led by the Interim Finance Director, Bill Betts, regarding the CIP Five year Plan. Mr. Betts discussed the requested staff changes and explained that there were no changes to the amounts just changes to when the projects are scheduled. A motion was made by Councilman Prather to move the amended plan to Council and seconded by Councilman Bray. The motion was approved unanimously. 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%, less any expenses paid by the Conference Center Fund, is $1,407,836.89. The average monthly amount collected for the Conference Center Fund is $49,310.53. The next item on the agenda was New Business. Mr. Betts informed the Committee that Finance is working on a new revenue forecasting model. Councilman Bray inquired about the $100,000 that was sent to the Columbia airport and wanted to know how long it stays there. Councilman Schulte congratulated Finance for receiving the GFOA Excellence in Financial Reporting Award on the CAFR. Councilman Schulte asked for an update on the effectiveness of the new grant process. There was no Old Business to discuss. A motion to adjourn was made by Councilman Prather and seconded by Councilman Scrivner. Adjournment took place at 8:20 AM. As recorded by: Shiela Pearre, Chief Accountant Memo To:Drew Hilpert From:Shiela Pearre Date:January 8, 2014 Re:Sales Tax Revenues The City received the January 1% Sales Tax in the amount of $741,056 which is $23,603 less than projected for January. January shortage is $23,603 (0.24%) in the General Fund. 1% General Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $764,659 $741,056 ($23,603) Dec-13 Feb-14 $703,181 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $1,008,111 Feb-14 Apr-14 $777,424 Mar-14 May-14 $537,141 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $1,023,015 May-14 Jul-14 $872,436 Jun-14 Aug-14 $546,351 Jul-14 & Apr-June 14 Qtrly Sep-14 $1,096,581 Aug-14 Oct-14 $717,262 Sep-14 Nov-14 $677,366 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $916,473 Total Overage/Shortfall ($23,603) 1/2% Capital Improvement Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $416,244 $359,800 ($56,444) Dec-13 Feb-14 $311,418 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $471,169 Feb-14 Apr-14 $413,147 Mar-14 May-14 $266,340 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $499,328 May-14 Jul-14 $393,021 Jun-14 Aug-14 $280,801 Jul-14 & Apr-June 14 Qtrly Sep-14 $508,966 Aug-14 Oct-14 $370,760 Sep-14 Nov-14 $268,825 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $499,981 Total Overage/Shortfall ($56,444) 1/2% Parks Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $372,447 $359,708 ($12,739) Dec-13 Feb-14 $350,714 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $475,026 Feb-14 Apr-14 $372,242 Mar-14 May-14 $266,456 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $482,382 May-14 Jul-14 $425,194 Jun-14 Aug-14 $272,321 Jul-14 & Apr-June 14 Qtrly Sep-14 $521,155 Aug-14 Oct-14 $357,482 Sep-14 Nov-14 $323,768 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $419,277 Total Overage/Shortfall ($12,739) Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 1/14/2014 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: JANUARY 2014 Account Number 10-100-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 787,676 928,460 809,385 843,061 764,659 741,056 act.826,648 Dec February 572,813 631,137 833,919 619,287 703,181 703,181 est.672,067 Jan & Oct-Dec Qtrly March 1,079,246 894,158 589,958 992,559 1,008,111 1,008,111 est.912,806 Feb April 763,906 774,964 978,391 852,653 777,424 777,424 est.829,468 Mar May 516,016 592,657 633,676 530,069 537,141 537,141 est.561,912 Apr & Jan-Mar Qtrly June 934,660 843,712 925,555 1,028,514 1,023,015 1,023,015 est.951,091 May July 686,153 939,495 955,495 797,785 872,436 872,436 est.850,273 Jun August 526,097 495,667 566,299 557,032 546,351 546,351 est.538,289 Jul & Apr-Jun Qtrly September 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 1,096,581 est.1,048,906 Aug October 718,480 822,163 797,510 769,129 717,262 717,262 est.764,909 Sept November 554,824 482,807 536,185 615,421 677,366 677,366 est.573,321 Oct & Jul-Sept Qtrly December 801,780 881,780 1,032,046 982,684 932,387 916,473 est.926,135 Actual to Date $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 741,056 Estimated to Fiscal Year end (based on averages and on Budgeted amount)8,875,341 Total Actual & Estimated $ 9,616,397 Less: Budget 9,640,000 Over (Under) Budget -$ 23,603 $ 741,056.45 $ 764,659.19 $1,467,840.39 $2,475,951.79 $3,253,375.33 $3,790,516.42 $4,813,531.75 $5,685,967.41 $6,232,318.77 $7,328,899.63 $8,046,161.24 $8,723,526.86 $9,640,000.00 $ 500,000.00 $ 750,000.00 $ 1,000,000.00 $ 1,250,000.00 $ 1,500,000.00 $ 1,750,000.00 $ 2,000,000.00 $ 2,250,000.00 $ 2,500,000.00 $ 2,750,000.00 $ 3,000,000.00 $ 3,250,000.00 $ 3,500,000.00 $ 3,750,000.00 $ 4,000,000.00 $ 4,250,000.00 $ 4,500,000.00 $ 4,750,000.00 $ 5,000,000.00 $ 5,250,000.00 $ 5,500,000.00 $ 5,750,000.00 $ 6,000,000.00 $ 6,250,000.00 $ 6,500,000.00 $ 6,750,000.00 $ 7,000,000.00 $ 7,250,000.00 $ 7,500,000.00 $ 7,750,000.00 $ 8,000,000.00 $ 8,250,000.00 $ 8,500,000.00 $ 8,750,000.00 $ 9,000,000.00 $ 9,250,000.00 $ 9,500,000.00 $ 9,750,000.00 $ 10,000,000.00 $ 10,250,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 1/14/2014 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: JANUARY 2014 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,327 455,480 396,799 412,434 372,459 359,800 act.404,300 Dec February 286,909 313,836 407,407 308,567 350,813 311,418 est.333,506 Jan & Oct-Dec Qtrly March 505,185 415,473 280,758 466,856 475,110 471,169 est.428,677 Feb April 365,514 370,473 452,824 409,365 372,340 413,147 est.394,103 Mar May 257,313 295,545 315,165 263,902 266,422 266,340 est.279,669 Apr & Jan-Mar Qtrly June 453,788 400,667 439,298 494,757 483,070 499,328 est.454,316 May July 326,501 462,244 468,643 389,423 425,325 393,021 est.414,427 Jun August 261,707 247,260 282,859 278,231 272,603 280,801 est.268,532 Jul & Apr-Jun Qtrly September 481,799 495,398 482,244 504,307 521,260 508,966 est.497,002 Aug October 348,002 395,058 382,206 367,366 357,619 370,760 est.370,050 Sept November 276,487 240,417 266,364 306,968 323,871 268,825 est.282,821 Oct & Jul-Sept Qtrly December 384,320 428,058 495,406 469,095 443,688 499,981 est.444,113 Actual to Date $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 359,800 Estimated to Fiscal Year end (based on averages and on Budgeted amount)4,283,756 Total Actual & Estimated $ 4,643,556 Less: Budget 4,700,000 Over (Under) Budget -$ 56,444 $ 359,799.94 $ 416,244.00 $727,662.00 $1,198,831.00 $1,611,978.00 $1,878,318.00 $2,377,646.00 $2,770,667.00 $3,051,468.00 $3,560,434.00 $3,931,194.00 $4,200,019.00 $4,700,000.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 1/14/2014 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: JANUARY 2014 Account Number 21-210-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,305 455,442 396,815 405,730 372,447 359,708 act.402,948 Dec February 286,889 313,792 407,348 308,456 350,714 350,714 est.333,440 Jan & Oct-Dec Qtrly March 507,768 415,275 280,734 466,713 475,026 475,026 est.429,103 Feb April 365,727 370,308 452,735 409,353 372,242 372,242 est.394,073 Mar May 256,675 295,529 315,030 263,822 266,456 266,456 est.279,502 Apr & Jan-Mar Qtrly June 453,016 400,500 439,265 494,733 482,382 482,382 est.453,979 May July 326,518 461,255 468,387 389,006 425,194 425,194 est.414,072 Jun August 261,622 247,216 282,836 278,072 272,321 272,321 est.268,413 Jul & Apr-Jun Qtrly September 481,772 495,222 482,150 505,913 521,155 521,155 est.497,242 Aug October 347,721 395,014 382,115 366,846 357,482 357,482 est.369,836 Sept November 275,469 240,348 264,735 306,831 323,768 323,768 est.282,230 Oct & Jul-Sept Qtrly December 384,300 428,200 495,305 468,924 443,569 419,277 est.444,060 Actual to Date $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 359,708 Estimated to Fiscal Year end (based on averages and on Budgeted amount)4,266,017 Total Actual & Estimated $ 4,625,725 Less: Budget 4,638,464 Over (Under) Budget -$ 12,739 $ 359,708.18 $ 372,447.00 $723,161.00 $1,198,187.00 $1,570,429.00 $1,836,885.00 $2,319,267.00 $2,744,461.00 $3,016,782.00 $3,537,937.00 $3,895,419.00 $4,219,187.00 $4,638,464.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget General Ledger Trial Balance by Full Acct Number User: spearre Printed: 01/14/14 15:29:54 Period 01 - 13 Fiscal Year 2014 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,640,000.00 741,056.45 0.00 8,898,943.55 92.31 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,640,000.00 741,056.45 0.00 8,898,943.55 92.31 10-100-401030 Motor Vehicle Sales Tax 430,000.00 0.00 0.00 430,000.00 100.00 R15 Motor Vehicle Sales Tax 430,000.00 0.00 0.00 430,000.00 100.00 10-100-403010 Gasoline Tax 1,100,000.00 0.00 0.00 1,100,000.00 100.00 10-100-403020 Cigarette Tax 120,000.00 10,756.88 0.00 109,243.12 91.04 R20 Other Taxes 1,220,000.00 10,756.88 0.00 1,209,243.12 99.12 10-100-410020 Electric Utility Lic Tax 3,220,000.00 224,277.70 0.00 2,995,722.30 93.03 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 925,000.00 62,977.35 0.00 862,022.65 93.19 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,450,000.00 196,298.46 0.00 2,253,701.54 91.99 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 -19,210.20 0.00 129,210.20 117.46 10-100-410060 Cable Franchise Fee 335,000.00 0.00 0.00 335,000.00 100.00 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,040,000.00 464,343.31 0.00 6,575,656.69 93.40 10-100-420010 Cur Property Tax 4,600,000.00 426,390.03 0.00 4,173,609.97 90.73 10-100-420020 Del Property Tax 40,000.00 7,922.60 0.00 32,077.40 80.19 10-100-420040 Fin Inst Tax 10,000.00 41,478.22 0.00 -31,478.22 -314.78 10-100-420050 Prop Tax Int & Penalties 20,000.00 2,616.45 0.00 17,383.55 86.92 10-100-420055 Surtax Receipts - County Reimb 54,000.00 0.00 0.00 54,000.00 100.00 10-100-420060 Surtax Receipts 470,000.00 26,161.30 0.00 443,838.70 94.43 10-100-420080 Special Tax Rev 15,000.00 202.67 0.00 14,797.33 98.65 R40 Property Taxes 5,209,000.00 504,771.27 0.00 4,704,228.73 90.31 10-100-430010 Federal Grants 2,458,920.90 137,111.59 0.00 2,321,809.31 94.42 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 20,262.50 12,083.91 0.00 8,178.59 40.36 10-100-430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430080 Road & Bridge Tax 550,000.00 0.00 0.00 550,000.00 100.00 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 3,029,183.40 149,195.50 0.00 2,879,987.90 95.07 10-100-440010 Admin Charge Backs 1,225,559.00 102,129.92 0.00 1,123,429.08 91.67 10-100-440050 Emt Reimbursement 0.00 0.00 0.00 0.00 0.00 10-100-440210 Street Cuts 25,000.00 7,488.00 0.00 17,512.00 70.05 10-100-440910 Fuel Charge-backs 0.00 2,941.12 0.00 -2,941.12 0.00 10-100-440920 Parts Charge-back 91,600.00 11,719.51 0.00 79,880.49 87.21 10-100-440930 Labor Charge-backs 137,400.00 9,726.85 0.00 127,673.15 92.92 R60 Charges for Services 1,479,559.00 134,005.40 0.00 1,345,553.60 90.94 10-100-450010 Liquor Licenses 65,000.00 1,467.50 0.00 63,532.50 97.74 10-100-450020 Business Licenses 205,000.00 63,078.81 0.00 141,921.19 69.23 10-100-450021 Home Occupation Permit 1,500.00 364.00 0.00 1,136.00 75.73 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 0.00 0.00 0.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 2,136.17 0.00 -2,136.17 0.00 10-100-450045 Bldg Constr Fees 200,000.00 20,852.70 0.00 179,147.30 89.57 10-100-450050 Electrical Certificates 16,000.00 12,744.00 0.00 3,256.00 20.35 10-100-450060 Electrical Permits 2,500.00 795.48 0.00 1,704.52 68.18 10-100-450070 Plumbing Licenses 10,000.00 7,168.00 0.00 2,832.00 28.32 10-100-450080 Plumbing Permits 5,000.00 1,042.25 0.00 3,957.75 79.16 10-100-450090 Other Lic & Permits 1,500.00 537.00 0.00 963.00 64.20 10-100-450091 Day Care Inspection Fees 8,000.00 0.00 0.00 8,000.00 100.00 10-100-450092 Food Inspection Fees 88,000.00 4,343.33 0.00 83,656.67 95.06 10-100-450100 Curb Cut Permits 1,500.00 0.00 0.00 1,500.00 100.00 10-100-450110 Board Of Adj Fees 1,200.00 206.00 0.00 994.00 82.83 10-100-450120 Sign Permits 4,000.00 367.00 0.00 3,633.00 90.83 10-100-450130 Demolition Permits 500.00 52.00 0.00 448.00 89.60 10-100-450150 Acc Rep Fees-police 12,000.00 2,246.30 0.00 9,753.70 81.28 10-100-450160 Accrptblastg P-fire 500.00 156.00 0.00 344.00 68.80 10-100-450170 Animal Redemption Fees 53,000.00 9,130.00 0.00 43,870.00 82.77 10-100-450180 Animal Vaccinations Fees 4,500.00 900.00 0.00 3,600.00 80.00 10-100-450185 Animal Cremation Fees 20,000.00 3,264.00 0.00 16,736.00 83.68 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 500.00 0.00 0.00 500.00 100.00 10-100-450230 Vacating Right Of Way 400.00 130.00 0.00 270.00 67.50 10-100-450250 Rezoning Request 10,000.00 474.00 0.00 9,526.00 95.26 10-100-450260 Non-refundable Plansspec 3,000.00 350.00 0.00 2,650.00 88.33 R65 Fees Licenses & Permits 713,600.00 131,804.54 0.00 581,795.46 81.53 10-100-460010 Court Cost 80,000.00 11,622.25 0.00 68,377.75 85.47 10-100-460015 Court Restitutions 1,300.00 179.12 0.00 1,120.88 86.22 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-460018 Inmate Security Fund 12,080.00 1,907.01 0.00 10,172.99 84.21 10-100-460020 Jail Cost Recovery 10,000.00 891.07 0.00 9,108.93 91.09 10-100-460025 Alcohol Offense Cost Rec 10,000.00 1,525.00 0.00 8,475.00 84.75 10-100-460030 Pol Fines-traffic 850,000.00 132,319.06 0.00 717,680.94 84.43 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 11,318.89 0.00 47,281.11 80.68 10-100-460100 Bankcard Charges -13,000.00 -1,261.77 0.00 -11,738.23 90.29 R70 Fines & Forfeitures 1,009,980.00 158,500.63 0.00 851,479.37 84.31 10-100-450187 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 0.00 6,610.00 0.00 -6,610.00 0.00 10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 5,000.00 490.00 0.00 4,510.00 90.20 10-100-480055 JC Fire Museum 0.00 4,972.00 0.00 -4,972.00 0.00 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 400.00 700.00 0.00 -300.00 -75.00 10-100-480080 Dare Donations 0.00 500.00 0.00 -500.00 0.00 10-100-480090 Police K-9 Donations 0.00 0.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 388.00 0.00 -388.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 0.00 0.00 100,000.00 100.00 10-100-481030 Rent City Hallannex 6,500.00 3,250.00 0.00 3,250.00 50.00 10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00 10-100-481045 Rent-tower Sites 80,000.00 5,643.10 0.00 74,356.90 92.95 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 0.00 0.00 110,000.00 100.00 10-100-481070 Miscellaneous 24,000.00 4,851.59 0.00 19,148.41 79.79 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 358,228.63 59,440.96 0.00 298,787.67 83.41 10-100-481077 Insurance Claims 20,000.00 350.00 0.00 19,650.00 98.25 10-100-481078 Cafeteria Refunds 0.00 0.00 0.00 0.00 0.00 10-100-481080 Sale Of Mapsgis Data 0.00 0.00 0.00 0.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 2,500.00 0.00 12,500.00 83.33 10-100-481090 Cole Cty Sheriff-New World 28,678.00 0.00 0.00 28,678.00 100.00 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,000.00 400.00 0.00 2,600.00 86.67 10-100-481110 Long & Short 0.00 1.00 0.00 -1.00 0.00 R75 Other Operating Revenues 762,806.63 90,096.65 0.00 672,709.98 88.19 10-100-470010 Interest 65,000.00 5,504.60 0.00 59,495.40 91.53 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable R80 Interest Income 65,000.00 5,504.60 0.00 59,495.40 91.53 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 20,000.00 0.00 0.00 20,000.00 100.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R85 Other Non-Operating Revenue 20,000.00 0.00 0.00 20,000.00 100.00 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 21,940.00 2,177.58 0.00 19,762.42 90.07 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 21,940.00 2,177.58 0.00 19,762.42 90.07 10-100-495995 Transfer From(to) Surplus -27,113.69 0.00 0.00 -27,113.69 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus -27,113.69 0.00 0.00 -27,113.69 100.00 100 Revenue 30,613,955.34 2,392,212.81 0.00 28,221,742.53 92.19 300 Police Department 10-300-430010 Federal Grants 0.00 1,818.72 0.00 -1,818.72 0.00 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 0.00 2,574.56 0.00 -2,574.56 0.00 R50 Intergovernmental 0.00 4,393.28 0.00 -4,393.28 0.00 300 Police Department 0.00 4,393.28 0.00 -4,393.28 0.00 310 School Resource Officer 10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-310-430040 Local Grants 184,966.60 184,966.60 0.00 0.00 0.00 R50 Intergovernmental 184,966.60 184,966.60 0.00 0.00 0.00 310 School Resource Officer 184,966.60 184,966.60 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 0.00 2,387.39 0.00 -2,387.39 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 2,387.39 0.00 -2,387.39 0.00 320 M.U.S.T.A.N.G.0.00 2,387.39 0.00 -2,387.39 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Revenue Revenue 30,798,921.94 2,583,960.08 0.00 28,214,961.86 91.61 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 5,400.00 0.00 59,400.00 91.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 4,957.20 413.15 0.00 4,544.05 91.67 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 103.26 0.00 0.00 103.26 100.00 E05 Personnel Services 69,860.46 5,813.15 0.00 64,047.31 91.68 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-110-512010 Printing 750.00 0.00 0.00 750.00 100.00 10-110-512020 Copies 500.00 2.24 0.00 497.76 99.55 10-110-513010 Office Supplies 400.00 72.90 72.92 254.19 63.55 10-110-514040 Food 500.00 0.00 0.00 500.00 100.00 E10 Materials & Supplies 2,250.00 75.14 72.92 2,101.95 93.42 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 3,000.00 0.00 0.00 3,000.00 100.00 10-110-520030 Dues And Publications 4,500.00 4,582.90 0.00 -82.90 -1.84 10-110-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 500.00 0.00 0.00 500.00 100.00 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 8,000.00 4,582.90 0.00 3,417.10 42.71 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 80,110.46 10,471.19 72.92 69,566.36 86.84 120 City Clerk 10-120-501020 Salaries 63,969.55 11,292.22 0.00 52,677.33 82.35 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,893.67 821.17 0.00 4,072.50 83.22 10-120-502020 Group Health Insurance 12,300.85 1,913.52 0.00 10,387.33 84.44 10-120-502030 Retirement 12,602.00 2,044.13 0.00 10,557.87 83.78 10-120-502040 Workers Compensation 103.26 0.00 0.00 103.26 100.00 10-120-502050 Life Insurance 108.44 16.20 0.00 92.24 85.06 10-120-502060 Long Term Disability 179.04 26.76 0.00 152.28 85.05 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-502070 Employee Assistance Prgm 29.53 7.41 0.00 22.12 74.91 E05 Personnel Services 94,186.34 16,121.41 0.00 78,064.93 82.88 10-120-511020 Postage 270.00 1.38 0.00 268.62 99.49 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 500.00 96.57 0.00 403.43 80.69 10-120-513010 Office Supplies 1,000.00 30.51 0.00 969.49 96.95 E10 Materials & Supplies 1,770.00 128.46 0.00 1,641.54 92.74 10-120-520030 Dues And Publications 250.00 0.00 0.00 250.00 100.00 10-120-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 199.00 0.00 801.00 80.10 10-120-522020 Professional Services 750.00 0.00 0.00 750.00 100.00 10-120-529030 Election Expense 50,000.00 0.00 0.00 50,000.00 100.00 E15 Contractual Services 52,000.00 199.00 0.00 51,801.00 99.62 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 400.00 270.45 72.92 56.64 14.16 E25 Repairs & Maintenance 400.00 270.45 72.92 56.64 14.16 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 148,356.34 16,719.32 72.92 131,564.11 88.68 140 City Administrator 10-140-501020 Salaries 179,796.19 24,541.92 0.00 155,254.27 86.35 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 13,754.41 1,799.19 0.00 11,955.22 86.92 10-140-502020 Group Health Insurance 18,790.57 2,370.66 0.00 16,419.91 87.38 10-140-502030 Retirement 35,419.85 4,442.09 0.00 30,977.76 87.46 10-140-502040 Workers Compensation 542.12 0.00 0.00 542.12 100.00 10-140-502050 Life Insurance 287.28 33.63 0.00 253.65 88.29 10-140-502060 Long Term Disability 355.92 48.28 0.00 307.64 86.44 10-140-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 248,990.74 33,246.92 0.00 215,743.82 86.65 10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-140-511020 Postage 400.00 1.84 0.00 398.16 99.54 10-140-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-140-512020 Copies 500.00 16.31 0.00 483.69 96.74 10-140-513010 Office Supplies 1,200.00 72.90 72.92 1,054.19 87.85 10-140-517010 Operational Supplies 1,750.00 0.00 0.00 1,750.00 100.00 E10 Materials & Supplies 5,150.00 91.05 72.92 4,986.04 96.82 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-520030 Dues And Publications 600.00 0.00 0.00 600.00 100.00 10-140-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 1,200.00 199.00 0.00 1,001.00 83.42 10-140-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-140-520090 Recruitment 0.00 3,550.95 0.00 -3,550.95 0.00 10-140-522020 Professional Services 2,000.00 93.00 0.00 1,907.00 95.35 E15 Contractual Services 5,800.00 3,842.95 0.00 1,957.05 33.74 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 250.00 115.44 0.00 134.56 53.82 E25 Repairs & Maintenance 250.00 115.44 0.00 134.56 53.82 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 260,190.74 37,296.36 72.92 222,821.47 85.64 149 Entitlement Grant 10-149-501020 Salaries 5,119.75 2,950.88 0.00 2,168.87 42.36 10-149-501050 Parttime(wo Benefits)20,000.00 2,182.50 0.00 17,817.50 89.09 10-149-502010 Social Security 1,921.66 396.08 0.00 1,525.58 79.39 10-149-502020 Group Health Insurance 0.00 386.49 0.00 -386.49 0.00 10-149-502030 Retirement 1,008.59 534.12 0.00 474.47 47.04 10-149-502050 Life Insurance 0.00 3.94 0.00 -3.94 0.00 10-149-502060 Long Term Disability 0.00 6.45 0.00 -6.45 0.00 E05 Personnel Services 28,050.00 6,460.46 0.00 21,589.54 76.97 10-149-511010 Advertising 1,750.00 229.25 0.00 1,520.75 86.90 10-149-511020 Postage 400.00 32.14 0.00 367.86 91.97 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 700.00 321.99 0.00 378.01 54.00 10-149-517010 Operational Supplies 700.00 0.00 0.00 700.00 100.00 E10 Materials & Supplies 3,550.00 583.38 0.00 2,966.62 83.57 10-149-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,250.00 1,159.34 0.00 90.66 7.25 10-149-522020 Professional Services 6,500.00 0.00 0.00 6,500.00 100.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 50,000.00 17,916.00 0.00 32,084.00 64.17 10-149-528012 Housing Rehab-Energy Efficienc 24,000.00 1,300.00 325.00 22,375.00 93.23 10-149-528020 Housing Assistance 10,000.00 5,064.00 0.00 4,936.00 49.36 10-149-528030 Public Improvement 20,000.00 0.00 26,356.86 -6,356.86 -31.78 10-149-528040 Neighborhood Redevelopmnt 32,500.00 0.00 60,785.19 -28,285.19 -87.03 10-149-528050 Neighborhood Facility 12,500.00 0.00 0.00 12,500.00 100.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-528070 Emergency Assistance 10,000.00 1,745.00 0.00 8,255.00 82.55 10-149-528080 Homeless Objectives 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 167,750.00 27,184.34 87,467.05 53,098.61 31.65 10-149-547020 Maintenance Agreements 650.00 103.52 517.60 28.88 4.44 E25 Repairs & Maintenance 650.00 103.52 517.60 28.88 4.44 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 200,000.00 34,331.70 87,984.65 77,683.65 38.84 150 City Counselor 10-150-501020 Salaries 217,116.79 23,991.72 0.00 193,125.07 88.95 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,609.43 1,720.98 0.00 14,888.45 89.64 10-150-502020 Group Health Insurance 33,916.35 3,169.65 0.00 30,746.70 90.65 10-150-502030 Retirement 42,772.01 4,342.37 0.00 38,429.64 89.85 10-150-502040 Workers Compensation 370.02 0.00 0.00 370.02 100.00 10-150-502050 Life Insurance 364.39 33.92 0.00 330.47 90.69 10-150-502060 Long Term Disability 555.12 54.81 0.00 500.31 90.13 10-150-502070 Employee Assistance Prgm 74.15 18.61 0.00 55.54 74.90 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 311,778.26 33,332.06 0.00 278,446.20 89.31 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 300.00 27.96 0.00 272.04 90.68 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 61.78 0.00 608.22 90.78 10-150-513010 Office Supplies 1,800.00 0.00 0.00 1,800.00 100.00 10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 3,070.00 89.74 0.00 2,980.26 97.08 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 12,400.00 855.40 0.00 11,544.60 93.10 10-150-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 574.00 0.00 4,426.00 88.52 10-150-520080 Tuition Reimbursement 2,880.00 855.00 0.00 2,025.00 70.31 10-150-521010 General Insurance 3,000.00 0.00 0.00 3,000.00 100.00 10-150-522020 Professional Services 11,100.00 0.00 0.00 11,100.00 100.00 10-150-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 34,420.00 2,284.40 0.00 32,135.60 93.36 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-547010 Equipment Maintenance 1,250.00 591.91 525.82 132.28 10.58 E25 Repairs & Maintenance 1,250.00 591.91 525.82 132.28 10.58 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Counselor 350,518.26 36,298.11 525.82 313,694.34 89.49 160 Municipal Court 10-160-501010 Salary-elected Officals 60,000.00 4,999.99 0.00 55,000.01 91.67 10-160-501020 Salaries 97,303.63 17,215.03 0.00 80,088.60 82.31 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)9,500.00 560.00 0.00 8,940.00 94.11 10-160-501090 Overtime 8,600.00 216.83 0.00 8,383.17 97.48 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,418.38 1,738.99 0.00 11,679.39 87.04 10-160-502020 Group Health Insurance 12,436.90 1,727.32 0.00 10,709.58 86.11 10-160-502030 Retirement 20,863.01 3,155.07 0.00 17,707.94 84.88 10-160-502040 Workers Compensation 154.89 0.00 0.00 154.89 100.00 10-160-502050 Life Insurance 163.88 24.55 0.00 139.33 85.02 10-160-502060 Long Term Disability 272.64 40.89 0.00 231.75 85.00 10-160-502070 Employee Assistance Prgm 51.73 12.99 0.00 38.74 74.89 E05 Personnel Services 222,765.06 29,691.66 0.00 193,073.40 86.67 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 191.38 0.00 3,808.62 95.22 10-160-512010 Printing 1,090.00 0.00 0.00 1,090.00 100.00 10-160-512020 Copies 1,000.00 15.33 0.00 984.67 98.47 10-160-513010 Office Supplies 1,600.00 0.00 0.00 1,600.00 100.00 E10 Materials & Supplies 7,690.00 206.71 0.00 7,483.29 97.31 10-160-520025 Security 10,000.00 0.00 0.00 10,000.00 100.00 10-160-520030 Dues And Publications 300.00 0.00 0.00 300.00 100.00 10-160-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,000.00 302.95 0.00 697.05 69.71 10-160-522020 Professional Services 3,000.00 1,147.51 0.00 1,852.49 61.75 10-160-525005 Appointed Counsel 7,000.00 1,176.25 0.00 5,823.75 83.20 10-160-525010 Care Of Prisoners 3,530.50 0.00 0.00 3,530.50 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 24,870.50 2,626.71 0.00 22,243.79 89.44 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 1,200.00 203.58 72.92 923.51 76.96 E25 Repairs & Maintenance 1,200.00 203.58 72.92 923.51 76.96 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-572020 Purchase Of Equipment 0.00 0.00 15,851.06 -15,851.06 0.00 E70 Capital Purchases 0.00 0.00 15,851.06 -15,851.06 0.00 160 Municipal Court 256,525.56 32,728.66 15,923.98 207,872.93 81.03 170 Human Resources 10-170-501020 Salaries 183,873.86 29,751.05 0.00 154,122.81 83.82 10-170-501050 Parttime(wo Benefits)9,600.00 1,963.22 0.00 7,636.78 79.55 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-170-502010 Social Security 14,823.70 2,587.14 0.00 12,236.56 82.55 10-170-502020 Group Health Insurance 27,431.91 2,505.29 0.00 24,926.62 90.87 10-170-502030 Retirement 36,282.25 5,384.93 0.00 30,897.32 85.16 10-170-502040 Workers Compensation 301.18 0.00 0.00 301.18 100.00 10-170-502050 Life Insurance 310.80 41.28 0.00 269.52 86.72 10-170-502060 Long Term Disability 467.04 61.26 0.00 405.78 86.88 10-170-502070 Employee Assistance Prgm 66.60 16.72 0.00 49.88 74.89 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 273,457.34 42,310.89 0.00 231,146.45 84.53 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 1,000.00 7.86 0.00 992.14 99.21 10-170-512010 Printing 2,500.00 115.44 0.00 2,384.56 95.38 10-170-512020 Copies 1,500.00 88.76 0.00 1,411.24 94.08 10-170-513010 Office Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-170-517010 Operational Supplies 1,350.00 10.50 0.00 1,339.50 99.22 E10 Materials & Supplies 8,000.00 222.56 0.00 7,777.44 97.22 10-170-520030 Dues And Publications 1,255.00 0.00 0.00 1,255.00 100.00 10-170-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 248.40 0.00 3,251.60 92.90 10-170-520070 Training And Education 4,000.00 220.00 0.00 3,780.00 94.50 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 6,000.00 766.50 0.00 5,233.50 87.23 10-170-522020 Professional Services 8,000.00 204.22 0.00 7,795.78 97.45 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,755.00 1,439.12 0.00 21,315.88 93.68 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 200.00 72.93 72.92 54.16 27.08 E25 Repairs & Maintenance 200.00 72.93 72.92 54.16 27.08 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 304,412.34 44,045.50 72.92 260,293.93 85.51 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 180 Finance Department 10-180-501020 Salaries 639,306.34 97,553.90 0.00 541,752.44 84.74 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)18,904.18 2,981.11 0.00 15,923.07 84.23 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 50,353.11 7,581.51 0.00 42,771.60 84.94 10-180-502020 Group Health Insurance 76,739.99 11,275.84 0.00 65,464.15 85.31 10-180-502030 Retirement 125,943.35 17,657.31 0.00 108,286.04 85.98 10-180-502040 Workers Compensation 1,634.95 0.00 0.00 1,634.95 100.00 10-180-502050 Life Insurance 1,095.73 140.36 0.00 955.37 87.19 10-180-502060 Long Term Disability 1,691.84 231.20 0.00 1,460.64 86.33 10-180-502070 Employee Assistance Prgm 285.94 71.76 0.00 214.18 74.90 E05 Personnel Services 915,955.43 137,492.99 0.00 778,462.44 84.99 10-180-511010 Advertising 2,000.00 26.25 0.00 1,973.75 98.69 10-180-511020 Postage 13,500.00 1,233.08 0.00 12,266.92 90.87 10-180-511021 Mail Machine Cost 2,000.00 800.38 0.00 1,199.62 59.98 10-180-512010 Printing 6,500.00 910.95 0.00 5,589.05 85.99 10-180-512020 Copies 5,000.00 103.01 0.00 4,896.99 97.94 10-180-512021 Copy Machine Cost 0.00 49.17 437.49 -486.66 0.00 10-180-513010 Office Supplies 6,000.00 906.04 0.00 5,093.96 84.90 10-180-517010 Operational Supplies 4,000.00 0.00 0.00 4,000.00 100.00 E10 Materials & Supplies 39,000.00 4,028.88 437.49 34,533.63 88.55 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,400.00 60.00 0.00 2,340.00 97.50 10-180-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 2,200.00 0.00 0.00 2,200.00 100.00 10-180-520080 Tuition Reimbursement 1,800.00 0.00 0.00 1,800.00 100.00 10-180-522010 Audit 27,700.00 0.00 25,455.00 2,245.00 8.10 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 34,100.00 60.00 25,455.00 8,585.00 25.18 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 991,055.43 142,472.03 25,892.49 822,690.91 83.01 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 71,947.37 0.00 0.00 71,947.37 100.00 10-185-501022 Separation Incentive Prog Svgs 22,325.24 0.00 0.00 22,325.24 100.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 56,030.00 0.00 0.00 56,030.00 100.00 10-185-502022 Wellness Assessment 25,000.00 0.00 0.00 25,000.00 100.00 10-185-503010 Awards Program 3,000.00 0.00 0.00 3,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 178,302.61 0.00 0.00 178,302.61 100.00 10-185-514010 Gas 19,000.00 1,839.25 0.00 17,160.75 90.32 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 19,000.00 1,839.25 0.00 17,160.75 90.32 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 287,100.00 232,787.02 0.00 54,312.98 18.92 10-185-521020 Insurance Deductible 30,000.00 2,946.38 0.00 27,053.62 90.18 10-185-521030 Self Ins Prop & Casualty 70,000.00 11,099.70 0.00 58,900.30 84.14 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 1,431.25 0.00 -1,431.25 0.00 10-185-522020 Professional Services 125,000.00 4,166.66 18,749.97 102,083.37 81.67 10-185-522025 JCTV 55,000.00 0.00 0.00 55,000.00 100.00 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 45,500.00 11,363.69 0.00 34,136.31 75.02 10-185-527020 Economic Development 185,000.00 0.00 0.00 185,000.00 100.00 10-185-529010 Special Events 7,000.00 1,000.00 0.00 6,000.00 85.71 E15 Contractual Services 805,100.00 264,794.70 18,749.97 521,555.33 64.78 10-185-531010 Electricity 42,400.00 4,403.58 0.00 37,996.42 89.61 10-185-533010 Natural Gas 6,000.00 1,570.90 0.00 4,429.10 73.82 10-185-535010 Water 6,000.00 620.92 0.00 5,379.08 89.65 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 54,400.00 6,595.40 0.00 47,804.60 87.88 10-185-540010 Building & Grounds Maint.60,000.00 7,347.98 -670.80 53,322.82 88.87 10-185-540020 Tree & Landscape Maint 25,000.00 12,500.00 0.00 12,500.00 50.00 10-185-547020 Maintenance Agreements 2,000.00 156.00 0.00 1,844.00 92.20 E25 Repairs & Maintenance 87,000.00 20,003.98 -670.80 67,666.82 77.78 10-185-550010 Miscellaneous 10,000.00 3,098.00 0.00 6,902.00 69.02 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 5,500.00 0.00 0.00 5,500.00 100.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 10,547.91 0.00 -10,547.91 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 25,500.00 23,645.91 0.00 1,854.09 7.27 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 1,169,302.61 316,879.24 18,079.17 834,344.20 71.35 190 I.T. Department 10-190-501020 Salaries 551,117.31 97,559.60 0.00 453,557.71 82.30 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 42,160.47 7,226.73 0.00 34,933.74 82.86 10-190-502020 Group Health Insurance 63,175.48 10,996.86 0.00 52,178.62 82.59 10-190-502030 Retirement 108,570.11 17,658.35 0.00 90,911.76 83.74 10-190-502040 Workers Compensation 783.06 0.00 0.00 783.06 100.00 10-190-502050 Life Insurance 908.88 137.09 0.00 771.79 84.92 10-190-502060 Long Term Disability 1,459.74 219.01 0.00 1,240.73 85.00 10-190-502070 Employee Assistance Prgm 205.35 51.55 0.00 153.80 74.90 E05 Personnel Services 768,380.40 133,849.19 0.00 634,531.21 82.58 10-190-511010 Advertising 500.00 50.75 0.00 449.25 89.85 10-190-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 200.00 3.19 0.00 196.81 98.41 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,500.00 0.00 0.00 1,500.00 100.00 E10 Materials & Supplies 3,450.00 53.94 0.00 3,396.06 98.44 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-190-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,000.00 721.67 0.00 7,278.33 90.98 10-190-520080 Tuition Reimbursement 7,500.00 1,200.00 0.00 6,300.00 84.00 10-190-522020 Professional Services 2,000.00 0.00 0.00 2,000.00 100.00 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 19,800.00 3,236.94 0.00 16,563.06 83.65 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 39,800.00 5,158.61 0.00 34,641.39 87.04 10-190-534010 Telephone 60,000.00 7,638.16 0.00 52,361.84 87.27 E20 Utilities 60,000.00 7,638.16 0.00 52,361.84 87.27 10-190-545010 Software Licensemaint 229,500.00 43,287.42 19,849.00 166,363.58 72.49 10-190-545020 Citywide Wiringnetwork 3,000.00 243.69 0.00 2,756.31 91.88 10-190-547010 Equipment Maintenance 3,000.00 1,475.55 0.00 1,524.45 50.82 10-190-547020 Maintenance Agreements 34,000.00 90.58 452.90 33,456.52 98.40 E25 Repairs & Maintenance 269,500.00 45,097.24 20,301.90 204,100.86 75.73 10-190-572020 Purchase Of Equipment 25,000.00 2,049.87 22,340.43 609.70 2.44 E70 Capital Purchases 25,000.00 2,049.87 22,340.43 609.70 2.44 190 I.T. Department 1,166,130.40 193,847.01 42,642.33 929,641.06 79.72 300 Police Department 10-300-501020 Salaries 3,903,005.86 690,712.78 0.00 3,212,293.08 82.30 10-300-501030 Holiday Pay 119,000.00 49,307.61 0.00 69,692.39 58.57 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 4,131.00 0.00 26,269.00 86.41 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,800.00 1,500.00 0.00 5,300.00 77.94 10-300-501090 Overtime 170,402.50 25,200.59 0.00 145,201.91 85.21 10-300-501095 Overtime Straight Pay 6,000.00 242.13 0.00 5,757.87 95.96 10-300-502010 Social Security 324,024.04 56,289.92 0.00 267,734.12 82.63 10-300-502020 Group Health Insurance 689,481.39 100,974.87 0.00 588,506.52 85.35 10-300-502030 Retirement 912,804.08 145,712.06 0.00 767,092.02 84.04 10-300-502040 Workers Compensation 70,999.83 0.00 0.00 70,999.83 100.00 10-300-502050 Life Insurance 6,714.24 955.73 0.00 5,758.51 85.77 10-300-502060 Long Term Disability 10,997.52 1,565.59 0.00 9,431.93 85.76 10-300-502070 Employee Assistance Prgm 1,909.20 479.29 0.00 1,429.91 74.90 10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,255,138.66 1,077,071.57 0.00 5,178,067.09 82.78 10-300-511010 Advertising 3,000.00 781.00 0.00 2,219.00 73.97 10-300-511020 Postage 2,500.00 140.97 0.00 2,359.03 94.36 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-512010 Printing 5,000.00 301.80 0.00 4,698.20 93.96 10-300-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-300-512030 Photographic Supplies 2,000.00 485.99 0.00 1,514.01 75.70 10-300-513010 Office Supplies 13,000.00 1,039.98 0.00 11,960.02 92.00 10-300-514010 Gas 302,000.00 16,210.63 0.00 285,789.37 94.63 10-300-514040 Food 700.00 24.51 0.00 675.49 96.50 10-300-515040 First Aid Supplies 1,000.00 123.48 0.00 876.52 87.65 10-300-516010 Ammunition & Firearms Supplies 23,000.00 0.00 4,081.62 18,918.38 82.25 10-300-516020 Dare Program 16,000.00 214.50 0.00 15,785.50 98.66 10-300-516030 Special Investigation 2,500.00 0.00 0.00 2,500.00 100.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 400.00 0.00 0.00 400.00 100.00 10-300-517010 Operational Supplies 30,000.00 3,361.73 0.00 26,638.27 88.79 E10 Materials & Supplies 401,300.00 22,684.59 4,081.62 374,533.79 93.33 10-300-520030 Dues And Publications 4,000.00 942.50 0.00 3,057.50 76.44 10-300-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-300-520080 Tuition Reimbursement 7,000.00 855.00 0.00 6,145.00 87.79 10-300-520090 Recruitment 2,500.00 89.60 0.00 2,410.40 96.42 10-300-521040 Medical Claimsservices 5,000.00 1,642.00 0.00 3,358.00 67.16 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 12,000.00 5,888.00 0.00 6,112.00 50.93 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 13,000.00 6,900.00 0.00 6,100.00 46.92 10-300-523030 Building Lease 1,200.00 300.00 900.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 10,000.00 119.43 0.00 9,880.57 98.81 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 323.86 0.00 1,876.14 85.28 E15 Contractual Services 56,900.00 17,060.39 900.00 38,939.61 68.44 10-300-531010 Electricity 60,000.00 9,031.75 0.00 50,968.25 84.95 10-300-533010 Natural Gas 14,800.00 3,944.51 0.00 10,855.49 73.35 10-300-534010 Telephone 12,100.00 487.32 0.00 11,612.68 95.97 10-300-535010 Water 3,000.00 652.92 0.00 2,347.08 78.24 E20 Utilities 89,900.00 14,116.50 0.00 75,783.50 84.30 10-300-540010 Building & Grounds Maint.51,000.00 4,800.42 -2,970.69 49,170.27 96.41 10-300-541030 Vehicle Wash 12,000.00 822.00 0.00 11,178.00 93.15 10-300-544010 K-9 Operations 10,000.00 1,216.55 0.00 8,783.45 87.83 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 17,500.00 0.00 0.00 17,500.00 100.00 10-300-546010 Clothing Expense 43,000.00 3,402.65 0.00 39,597.35 92.09 10-300-546020 Uniform Cleaning 26,000.00 3,181.29 0.00 22,818.71 87.76 10-300-547010 Equipment Maintenance 13,000.00 4,093.17 0.00 8,906.83 68.51 10-300-547020 Maintenance Agreements 20,000.00 12,964.51 4,029.70 3,005.79 15.03 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-547030 Radio Maintenance 10,000.00 1,446.48 0.00 8,553.52 85.54 E25 Repairs & Maintenance 202,500.00 31,927.07 1,059.01 169,513.92 83.71 10-300-572010 Purchase Of Vehicles 250,000.00 0.00 0.00 250,000.00 100.00 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572100 MDT Year 3 Equipment 0.00 1,350.00 64,543.50 -65,893.50 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 250,000.00 1,350.00 64,543.50 184,106.50 73.64 300 Police Department 7,255,738.66 1,164,210.12 70,584.13 6,020,944.41 82.98 310 School Resource Officer 10-310-501020 Salaries 237,278.98 38,420.13 0.00 198,858.85 83.81 10-310-501030 Holiday Pay 6,000.00 2,132.58 0.00 3,867.42 64.46 10-310-501090 Overtime 7,126.00 6,376.10 0.00 749.90 10.52 10-310-501095 Overtime Straight Pay 0.00 147.64 0.00 -147.64 0.00 10-310-502010 Social Security 19,155.98 3,294.94 0.00 15,861.04 82.80 10-310-502020 Group Health Insurance 40,725.87 7,155.50 0.00 33,570.37 82.43 10-310-502030 Retirement 54,838.69 9,791.88 0.00 45,046.81 82.14 10-310-502040 Workers Compensation 3,631.31 0.00 0.00 3,631.31 100.00 10-310-502050 Life Insurance 401.52 56.32 0.00 345.20 85.97 10-310-502060 Long Term Disability 663.84 93.32 0.00 570.52 85.94 10-310-502070 Employee Assistance Prgm 111.00 27.87 0.00 83.13 74.89 E05 Personnel Services 369,933.19 67,496.28 0.00 302,436.91 81.75 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 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 369,933.19 67,496.28 0.00 302,436.91 81.75 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 92,726.19 16,533.76 0.00 76,192.43 82.17 10-320-501030 Holiday Pay 2,500.00 1,243.62 0.00 1,256.38 50.26 10-320-501090 Overtime 6,897.00 1,394.92 0.00 5,502.08 79.77 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 7,812.42 1,380.54 0.00 6,431.88 82.33 10-320-502020 Group Health Insurance 17,953.72 2,507.59 0.00 15,446.13 86.03 10-320-502030 Retirement 22,364.98 3,987.84 0.00 18,377.14 82.17 10-320-502040 Workers Compensation 1,677.98 0.00 0.00 1,677.98 100.00 10-320-502050 Life Insurance 157.92 23.87 0.00 134.05 84.88 10-320-502060 Long Term Disability 259.68 39.09 0.00 220.59 84.95 10-320-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 152,394.29 27,122.38 0.00 125,271.91 82.20 10-320-514010 Gas 0.00 998.56 0.00 -998.56 0.00 10-320-516040 Investigations (grant)20,000.00 399.98 3,540.00 16,060.02 80.30 10-320-517010 Operational Supplies 1,000.00 170.00 0.00 830.00 83.00 E10 Materials & Supplies 21,000.00 1,568.54 3,540.00 15,891.46 75.67 10-320-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 10,000.00 18,100.00 0.00 -8,100.00 -81.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 10,000.00 18,100.00 0.00 -8,100.00 -81.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 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.183,394.29 46,790.92 3,540.00 133,063.37 72.56 330 Animal Control 10-330-501020 Salaries 311,708.10 56,150.87 0.00 255,557.23 81.99 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 3,000.00 812.00 0.00 2,188.00 72.93 10-330-501090 Overtime 1,709.00 291.36 0.00 1,417.64 82.95 10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44 10-330-502010 Social Security 24,290.06 4,116.72 0.00 20,173.34 83.05 10-330-502020 Group Health Insurance 57,550.07 8,378.86 0.00 49,171.21 85.44 10-330-502030 Retirement 62,432.67 8,056.71 0.00 54,375.96 87.10 10-330-502040 Workers Compensation 5,137.19 0.00 0.00 5,137.19 100.00 10-330-502050 Life Insurance 527.52 80.64 0.00 446.88 84.71 10-330-502060 Long Term Disability 870.96 133.46 0.00 737.50 84.68 10-330-502070 Employee Assistance Prgm 177.60 44.59 0.00 133.01 74.89 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 468,503.17 78,093.03 0.00 390,410.14 83.33 10-330-511010 Advertising 1,500.00 0.00 0.00 1,500.00 100.00 10-330-511020 Postage 500.00 3.22 0.00 496.78 99.36 10-330-512010 Printing 1,700.00 0.00 0.00 1,700.00 100.00 10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-330-513010 Office Supplies 800.00 224.72 0.00 575.28 71.91 10-330-514030 Small Tools 250.00 0.00 0.00 250.00 100.00 10-330-515040 First Aid Supplies 150.00 105.99 0.00 44.01 29.34 10-330-517010 Operational Supplies 5,500.00 1,556.21 0.00 3,943.79 71.71 E10 Materials & Supplies 10,420.00 1,890.14 0.00 8,529.86 81.86 10-330-520030 Dues And Publications 900.00 737.75 0.00 162.25 18.03 10-330-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,650.00 1,210.80 0.00 439.20 26.62 10-330-521040 Medical Claimsservices 1,000.00 0.00 0.00 1,000.00 100.00 10-330-522020 Professional Services 9,600.00 292.46 0.00 9,307.54 96.95 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 10,000.00 117.96 0.00 9,882.04 98.82 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,150.00 2,358.97 0.00 20,791.03 89.81 10-330-531010 Electricity 24,000.00 2,279.64 0.00 21,720.36 90.50 10-330-533010 Natural Gas 13,200.00 1,400.54 0.00 11,799.46 89.39 10-330-534010 Telephone 572.00 48.23 0.00 523.77 91.57 10-330-535010 Water 2,500.00 859.93 0.00 1,640.07 65.60 E20 Utilities 40,272.00 4,588.34 0.00 35,683.66 88.61 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-540010 Building & Grounds Maint.10,000.00 1,115.35 -177.06 9,061.71 90.62 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 45.00 0.00 495.00 91.67 10-330-544040 Care Of Animals 42,000.00 4,044.53 0.00 37,955.47 90.37 10-330-546010 Clothing Expense 3,000.00 0.00 0.00 3,000.00 100.00 10-330-546020 Uniform Cleaning 100.00 0.00 0.00 100.00 100.00 10-330-547010 Equipment Maintenance 1,300.00 93.34 0.00 1,206.66 92.82 10-330-547020 Maintenance Agreements 800.00 1,656.00 0.00 -856.00 -107.00 10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00 E25 Repairs & Maintenance 58,440.00 6,954.22 -177.06 51,662.84 88.40 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 600,785.17 93,884.70 -177.06 507,077.53 84.40 390 9-1-1 Police 10-390-501020 Salaries 765,641.65 135,265.46 0.00 630,376.19 82.33 10-390-501030 Holiday Pay 29,000.00 12,279.69 0.00 16,720.31 57.66 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 2,237.45 0.00 13,576.55 85.85 10-390-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-390-502010 Social Security 62,038.10 10,962.03 0.00 51,076.07 82.33 10-390-502020 Group Health Insurance 157,153.93 20,905.66 0.00 136,248.27 86.70 10-390-502030 Retirement 159,758.26 26,032.92 0.00 133,725.34 83.70 10-390-502040 Workers Compensation 1,350.99 0.00 0.00 1,350.99 100.00 10-390-502050 Life Insurance 1,305.36 184.66 0.00 1,120.70 85.85 10-390-502060 Long Term Disability 2,142.66 303.08 0.00 1,839.58 85.85 10-390-502070 Employee Assistance Prgm 438.45 110.07 0.00 328.38 74.90 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,195,143.40 208,281.02 0.00 986,862.38 82.57 10-390-511010 Advertising 1,200.00 0.00 0.00 1,200.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 5,000.00 125.00 0.00 4,875.00 97.50 E10 Materials & Supplies 6,200.00 125.00 0.00 6,075.00 97.98 10-390-520030 Dues And Publications 900.00 40.00 0.00 860.00 95.56 10-390-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-390-522020 Professional Services 2,000.00 0.00 0.00 2,000.00 100.00 10-390-523010 Equipment Rentlease 100,000.00 14,579.13 6,480.00 78,940.87 78.94 E15 Contractual Services 102,900.00 14,619.13 6,480.00 81,800.87 79.50 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-534010 Telephone 150.00 0.00 0.00 150.00 100.00 E20 Utilities 150.00 0.00 0.00 150.00 100.00 10-390-546010 Clothing Expense 3,400.00 0.00 0.00 3,400.00 100.00 10-390-546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00 10-390-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-390-547020 Maintenance Agreements 25,000.00 3,679.50 16,777.50 4,543.00 18.17 10-390-547030 Radio Maintenance 4,000.00 0.00 0.00 4,000.00 100.00 E25 Repairs & Maintenance 37,400.00 3,679.50 16,777.50 16,943.00 45.30 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,341,793.40 226,704.65 23,257.50 1,091,831.25 81.37 400 Fire Department 10-400-501020 Salaries 3,413,576.57 601,641.83 0.00 2,811,934.74 82.38 10-400-501030 Holiday Pay 267,630.97 132,854.91 0.00 134,776.06 50.36 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 5,610.00 0.00 22,390.00 79.96 10-400-501090 Overtime 30,000.00 6,479.81 0.00 23,520.19 78.40 10-400-501095 Overtime Straight Pay 32,000.00 5,655.13 0.00 26,344.87 82.33 10-400-502010 Social Security 53,115.63 10,072.25 0.00 43,043.38 81.04 10-400-502020 Group Health Insurance 591,688.25 87,542.54 0.00 504,145.71 85.20 10-400-502030 Retirement 1,639,063.50 319,583.39 0.00 1,319,480.11 80.50 10-400-502040 Workers Compensation 108,750.00 0.00 0.00 108,750.00 100.00 10-400-502050 Life Insurance 5,774.79 871.30 0.00 4,903.49 84.91 10-400-502060 Long Term Disability 9,511.67 1,432.63 0.00 8,079.04 84.94 10-400-502070 Employee Assistance Prgm 1,608.36 403.77 0.00 1,204.59 74.90 10-400-503010 Awards Program 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,181,719.74 1,172,147.56 0.00 5,009,572.18 81.04 10-400-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-400-511020 Postage 300.00 46.72 0.00 253.28 84.43 10-400-512010 Printing 1,250.00 0.00 0.00 1,250.00 100.00 10-400-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 230.64 0.00 1,569.36 87.19 10-400-514010 Gas 77,000.00 5,151.33 0.00 71,848.67 93.31 10-400-514020 Chemicals 2,000.00 80.00 0.00 1,920.00 96.00 10-400-514030 Small Tools 2,500.00 0.00 0.00 2,500.00 100.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 400.00 0.00 0.00 400.00 100.00 10-400-517010 Operational Supplies 8,180.00 122.95 583.70 7,473.35 91.36 E10 Materials & Supplies 93,780.00 5,631.64 583.70 87,564.66 93.37 10-400-520030 Dues And Publications 1,240.00 25.00 0.00 1,215.00 97.98 10-400-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 10,000.00 0.00 0.00 10,000.00 100.00 10-400-520080 Tuition Reimbursement 5,000.00 0.00 0.00 5,000.00 100.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 2,700.00 0.00 0.00 2,700.00 100.00 10-400-522020 Professional Services 1,200.00 300.00 0.00 900.00 75.00 10-400-523010 Equipment Rentlease 2,000.00 0.00 0.00 2,000.00 100.00 10-400-524010 Trash Collections 250.00 0.00 0.00 250.00 100.00 10-400-529010 Special Events 6,000.00 1,609.31 0.00 4,390.69 73.18 10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 28,390.00 1,934.31 0.00 26,455.69 93.19 10-400-531010 Electricity 27,500.00 1,746.76 0.00 25,753.24 93.65 10-400-533010 Natural Gas 17,500.00 2,081.78 0.00 15,418.22 88.10 10-400-534010 Telephone 17,500.00 2,928.02 0.00 14,571.98 83.27 10-400-535010 Water 8,720.00 1,288.76 0.00 7,431.24 85.22 E20 Utilities 71,220.00 8,045.32 0.00 63,174.68 88.70 10-400-540010 Building & Grounds Maint.44,934.00 8,227.65 -859.36 37,565.71 83.60 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 35,000.00 2,443.85 -479.20 33,035.35 94.39 10-400-546020 Uniform Cleaning 1,066.00 0.00 0.00 1,066.00 100.00 10-400-547010 Equipment Maintenance 18,000.00 987.35 0.00 17,012.65 94.51 10-400-547020 Maintenance Agreements 13,900.00 1,520.40 720.00 11,659.60 83.88 10-400-547030 Radio Maintenance 7,000.00 82.50 0.00 6,917.50 98.82 E25 Repairs & Maintenance 119,900.00 13,261.75 -618.56 107,256.81 89.46 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 0.00 23,794.32 0.00 -23,794.32 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 23,794.32 0.00 -23,794.32 0.00 400 Fire Department 6,495,009.74 1,224,814.90 -34.86 5,270,229.70 81.14 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 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 205,628.16 36,371.30 0.00 169,256.86 82.31 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 15,730.55 2,684.97 0.00 13,045.58 82.93 10-520-502020 Group Health Insurance 31,736.64 4,408.50 0.00 27,328.14 86.11 10-520-502030 Retirement 40,508.75 6,583.21 0.00 33,925.54 83.75 10-520-502040 Workers Compensation 524.91 0.00 0.00 524.91 100.00 10-520-502050 Life Insurance 347.76 52.17 0.00 295.59 85.00 10-520-502060 Long Term Disability 531.84 79.77 0.00 452.07 85.00 10-520-502070 Employee Assistance Prgm 88.80 22.29 0.00 66.51 74.90 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 295,097.41 50,202.21 0.00 244,895.20 82.99 10-520-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-520-511020 Postage 200.00 6.90 0.00 193.10 96.55 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 800.00 145.46 0.00 654.54 81.82 10-520-514010 Gas 20,000.00 827.68 0.00 19,172.32 95.86 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 150.00 0.00 0.00 150.00 100.00 E10 Materials & Supplies 21,650.00 980.04 0.00 20,669.96 95.47 10-520-520030 Dues And Publications 500.00 145.10 0.00 354.90 70.98 10-520-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-520-522020 Professional Services 3,000.00 1,581.00 0.00 1,419.00 47.30 E15 Contractual Services 5,000.00 1,726.10 0.00 3,273.90 65.48 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,000.00 430.08 0.00 569.92 56.99 E25 Repairs & Maintenance 1,000.00 430.08 0.00 569.92 56.99 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 322,747.41 53,338.43 0.00 269,408.98 83.47 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,891.84 9,180.68 0.00 42,711.16 82.31 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 1,872.00 0.00 10,608.00 85.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 4,924.45 845.52 0.00 4,078.93 82.83 10-521-502020 Group Health Insurance 5,961.16 818.00 0.00 5,143.16 86.28 10-521-502030 Retirement 10,222.69 1,661.70 0.00 8,560.99 83.74 10-521-502040 Workers Compensation 86.05 0.00 0.00 86.05 100.00 10-521-502050 Life Insurance 87.36 13.10 0.00 74.26 85.00 10-521-502060 Long Term Disability 145.20 21.78 0.00 123.42 85.00 10-521-502070 Employee Assistance Prgm 22.20 5.57 0.00 16.63 74.91 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 85,820.95 14,418.35 0.00 71,402.60 83.20 10-521-511010 Advertising 6,500.00 523.25 0.00 5,976.75 91.95 10-521-511020 Postage 1,500.00 88.60 0.00 1,411.40 94.09 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-513010 Office Supplies 1,000.00 132.26 0.00 867.74 86.77 10-521-514040 Food 100.00 0.00 0.00 100.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 0.00 0.00 2,000.00 100.00 E10 Materials & Supplies 11,300.00 744.11 0.00 10,555.89 93.41 10-521-520030 Dues And Publications 15,500.00 340.00 0.00 15,160.00 97.81 10-521-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,700.00 199.00 0.00 1,501.00 88.29 10-521-520080 Tuition Reimbursement 1,600.00 0.00 0.00 1,600.00 100.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,800.00 539.00 0.00 18,261.00 97.13 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,400.00 635.72 517.60 246.68 17.62 E25 Repairs & Maintenance 1,400.00 635.72 517.60 246.68 17.62 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 117,320.95 16,337.18 517.60 100,466.17 85.63 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 106,803.34 18,605.16 0.00 88,198.18 82.58 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 8,170.45 1,355.36 0.00 6,815.09 83.41 10-522-502020 Group Health Insurance 18,528.02 1,911.54 0.00 16,616.48 89.68 10-522-502030 Retirement 21,230.20 2,081.50 0.00 19,148.70 90.20 10-522-502040 Workers Compensation 206.52 0.00 0.00 206.52 100.00 10-522-502050 Life Insurance 213.36 25.25 0.00 188.11 88.17 10-522-502060 Long Term Disability 352.32 41.43 0.00 310.89 88.24 10-522-502070 Employee Assistance Prgm 44.40 11.15 0.00 33.25 74.89 E05 Personnel Services 155,548.61 24,031.39 0.00 131,517.22 84.55 10-522-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-522-511020 Postage 400.00 7.90 0.00 392.10 98.03 10-522-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-522-512020 Copies 50.00 0.18 0.00 49.82 99.64 10-522-513010 Office Supplies 1,000.00 46.45 0.00 953.55 95.36 10-522-514040 Food 200.00 0.00 0.00 200.00 100.00 10-522-517010 Operational Supplies 800.00 0.00 0.00 800.00 100.00 E10 Materials & Supplies 3,850.00 54.53 0.00 3,795.47 98.58 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-520030 Dues And Publications 1,000.00 514.00 0.00 486.00 48.60 10-522-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 2,500.00 0.00 0.00 2,500.00 100.00 10-522-522020 Professional Services 24,000.00 0.00 0.00 24,000.00 100.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,500.00 514.00 0.00 26,986.00 98.13 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,400.00 93.44 0.00 1,306.56 93.33 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,400.00 93.44 0.00 1,306.56 93.33 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 188,298.61 24,693.36 0.00 163,605.25 86.89 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,138.01 10,099.05 0.00 47,038.96 82.33 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,371.06 686.78 0.00 3,684.28 84.29 10-530-502020 Group Health Insurance 8,609.94 1,650.35 0.00 6,959.59 80.83 10-530-502030 Retirement 11,256.19 1,827.96 0.00 9,428.23 83.76 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 105.84 14.13 0.00 91.71 86.65 10-530-502060 Long Term Disability 176.64 23.49 0.00 153.15 86.70 10-530-502070 Employee Assistance Prgm 33.30 8.36 0.00 24.94 74.89 E05 Personnel Services 81,690.98 14,310.12 0.00 67,380.86 82.48 10-530-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-530-511020 Postage 100.00 4.76 0.00 95.24 95.24 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 300.00 96.00 0.00 204.00 68.00 10-530-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 1,100.00 100.76 0.00 999.24 90.84 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 0.00 0.00 1,800.00 100.00 10-530-522020 Professional Services 2,500.00 0.00 0.00 2,500.00 100.00 E15 Contractual Services 4,800.00 0.00 0.00 4,800.00 100.00 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 150.00 51.88 0.00 98.12 65.41 E25 Repairs & Maintenance 150.00 51.88 0.00 98.12 65.41 10-530-550020 Neighborhood Reinvestment 45,000.00 9,893.35 0.00 35,106.65 78.01 10-530-550030 Old Town Projects 45,500.00 21,822.23 0.00 23,677.77 52.04 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 1,000.00 0.00 0.00 1,000.00 100.00 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 1,105,349.09 0.00 11,500.00 1,093,849.09 98.96 10-530-550090 Hazard Mitigation 217,664.81 0.00 217,664.81 0.00 0.00 E30 Other Operating Expenses 1,414,513.90 31,715.58 229,164.81 1,153,633.51 81.56 530 Plan & Protect Svc-RedevGrant 1,502,254.88 46,178.34 229,164.81 1,226,911.73 81.67 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 348,244.99 62,390.27 0.00 285,854.72 82.08 10-531-501060 Seasonal Salaries 21,320.00 0.00 0.00 21,320.00 100.00 10-531-501090 Overtime 740.00 0.00 0.00 740.00 100.00 10-531-501095 Overtime Straight Pay 130.00 0.00 0.00 130.00 100.00 10-531-502010 Social Security 28,338.28 4,516.17 0.00 23,822.11 84.06 10-531-502020 Group Health Insurance 55,844.61 8,116.12 0.00 47,728.49 85.47 10-531-502030 Retirement 68,775.65 11,292.64 0.00 57,483.01 83.58 10-531-502040 Workers Compensation 6,952.84 0.00 0.00 6,952.84 100.00 10-531-502050 Life Insurance 553.20 83.27 0.00 469.93 84.95 10-531-502060 Long Term Disability 968.64 145.81 0.00 822.83 84.95 10-531-502070 Employee Assistance Prgm 155.40 39.01 0.00 116.39 74.90 E05 Personnel Services 532,023.61 86,583.29 0.00 445,440.32 83.73 10-531-511010 Advertising 200.00 91.80 0.00 108.20 54.10 10-531-511020 Postage 2,000.00 105.12 0.00 1,894.88 94.74 10-531-512010 Printing 700.00 331.90 0.00 368.10 52.59 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 1,800.00 153.72 0.00 1,646.28 91.46 10-531-514030 Small Tools 300.00 0.00 0.00 300.00 100.00 10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-531-517010 Operational Supplies 2,700.00 0.00 0.00 2,700.00 100.00 E10 Materials & Supplies 7,740.00 682.54 0.00 7,057.46 91.18 10-531-520030 Dues And Publications 1,500.00 640.50 0.00 859.50 57.30 10-531-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 2,500.00 79.00 0.00 2,421.00 96.84 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 15,000.00 2,326.50 0.00 12,673.50 84.49 10-531-522022 Demo 20,000.00 0.00 0.00 20,000.00 100.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 39,000.00 3,046.00 0.00 35,954.00 92.19 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 540.00 45.00 0.00 495.00 91.67 10-531-546010 Clothing Expense 800.00 0.00 0.00 800.00 100.00 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,500.00 224.60 517.60 757.80 50.52 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,900.00 269.60 517.60 2,112.80 72.86 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 581,663.61 90,581.43 517.60 490,564.58 84.34 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 130,608.56 22,085.52 0.00 108,523.04 83.09 10-532-501060 Seasonal Salaries 3,957.00 174.00 0.00 3,783.00 95.60 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00 10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00 10-532-502010 Social Security 10,315.69 1,643.65 0.00 8,672.04 84.07 10-532-502020 Group Health Insurance 21,485.14 2,745.85 0.00 18,739.29 87.22 10-532-502030 Retirement 25,785.05 3,997.47 0.00 21,787.58 84.50 10-532-502040 Workers Compensation 1,884.50 0.00 0.00 1,884.50 100.00 10-532-502050 Life Insurance 220.08 31.25 0.00 188.83 85.80 10-532-502060 Long Term Disability 363.60 51.72 0.00 311.88 85.78 10-532-502070 Employee Assistance Prgm 55.50 13.93 0.00 41.57 74.90 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 194,955.12 30,743.39 0.00 164,211.73 84.23 10-532-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-532-511020 Postage 200.00 11.92 0.00 188.08 94.04 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,000.00 122.61 0.00 877.39 87.74 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-532-517010 Operational Supplies 1,200.00 22.31 0.00 1,177.69 98.14 E10 Materials & Supplies 2,850.00 156.84 0.00 2,693.16 94.50 10-532-520030 Dues And Publications 880.00 345.00 0.00 535.00 60.80 10-532-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-520070 Training And Education 800.00 199.00 0.00 601.00 75.13 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 1,155.00 -1,155.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00 10-532-524025 Glass Recycling 10,000.00 1,100.00 4,510.00 4,390.00 43.90 10-532-524026 Household Hazardous Waste 20,000.00 0.00 0.00 20,000.00 100.00 10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 7,000.00 0.00 0.00 7,000.00 100.00 10-532-524030 Compost Services 212,000.00 35,333.34 176,666.70 -0.04 0.00 10-532-529010 Special Events 1,000.00 0.00 0.00 1,000.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 252,680.00 36,977.34 182,331.70 33,370.96 13.21 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 25,000.00 3,949.96 20,050.00 1,000.04 4.00 10-532-540065 Cemetery Restoration 5,000.00 0.00 0.00 5,000.00 100.00 10-532-541030 Vehicle Wash 1,290.00 107.00 0.00 1,183.00 91.71 10-532-546010 Clothing Expense 300.00 0.00 0.00 300.00 100.00 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,200.00 369.00 517.60 313.40 26.12 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 32,870.00 4,425.96 20,567.60 7,876.44 23.96 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 483,355.12 72,303.53 202,899.30 208,152.29 43.06 535 Public Works-Central Maintenan 10-535-501020 Salaries 331,324.54 58,178.52 0.00 273,146.02 82.44 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 0.00 0.00 7,400.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,366.87 0.00 1,133.13 25.18 10-535-501095 Overtime Straight Pay 500.00 86.29 0.00 413.71 82.74 10-535-502010 Social Security 26,294.93 4,436.12 0.00 21,858.81 83.13 10-535-502020 Group Health Insurance 83,283.30 11,506.49 0.00 71,776.81 86.18 10-535-502030 Retirement 66,255.94 11,155.35 0.00 55,100.59 83.16 10-535-502040 Workers Compensation 4,715.54 0.00 0.00 4,715.54 100.00 10-535-502050 Life Insurance 561.12 83.96 0.00 477.16 85.04 10-535-502060 Long Term Disability 926.64 138.63 0.00 788.01 85.04 10-535-502070 Employee Assistance Prgm 177.60 44.59 0.00 133.01 74.89 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 525,939.61 88,996.82 0.00 436,942.79 83.08 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 142.51 0.00 857.49 85.75 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 50.98 0.00 6,949.02 99.27 10-535-517010 Operational Supplies 8,000.00 2,066.25 0.00 5,933.75 74.17 E10 Materials & Supplies 16,140.00 2,259.74 0.00 13,880.26 86.00 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 199.00 0.00 1,801.00 90.05 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,000.00 199.00 0.00 1,801.00 90.05 10-535-531010 Electricity 6,550.00 1,160.92 0.00 5,389.08 82.28 10-535-533010 Natural Gas 6,000.00 2,464.61 0.00 3,535.39 58.92 10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-535-535010 Water 1,215.00 208.94 0.00 1,006.06 82.80 E20 Utilities 13,765.00 3,834.47 0.00 9,930.53 72.14 10-535-540010 Building & Grounds Maint.10,000.00 2,104.10 0.00 7,895.90 78.96 10-535-541010 Veh & Equip Parts Etc 419,500.00 54,571.06 0.00 364,928.94 86.99 10-535-546010 Clothing Expense 7,000.00 1,203.25 0.00 5,796.75 82.81 10-535-547010 Equipment Maintenance 3,500.00 567.76 0.00 2,932.24 83.78 10-535-547020 Maintenance Agreements 4,000.00 559.60 213.60 3,226.80 80.67 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 444,500.00 59,005.77 213.60 385,280.63 86.68 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 1,002,344.61 154,295.80 213.60 847,835.21 84.59 540 Public Works-Admin 10-540-501020 Salaries 188,433.84 33,517.04 0.00 154,916.80 82.21 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 14,415.19 2,365.68 0.00 12,049.51 83.59 10-540-502020 Group Health Insurance 30,833.98 5,091.65 0.00 25,742.33 83.49 10-540-502030 Retirement 37,121.47 6,066.59 0.00 31,054.88 83.66 10-540-502040 Workers Compensation 567.94 0.00 0.00 567.94 100.00 10-540-502050 Life Insurance 309.12 46.72 0.00 262.40 84.89 10-540-502060 Long Term Disability 462.24 69.33 0.00 392.91 85.00 10-540-502070 Employee Assistance Prgm 66.60 16.72 0.00 49.88 74.89 E05 Personnel Services 272,210.38 47,173.73 0.00 225,036.65 82.67 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-511020 Postage 200.00 0.46 0.00 199.54 99.77 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 128,500.00 7,520.28 0.00 120,979.72 94.15 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 1,300.00 0.00 0.00 1,300.00 100.00 E10 Materials & Supplies 131,500.00 7,520.74 0.00 123,979.26 94.28 10-540-520030 Dues And Publications 1,000.00 465.20 0.00 534.80 53.48 10-540-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,000.00 646.52 0.00 1,353.48 67.67 10-540-522020 Professional Services 800.00 0.00 0.00 800.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,800.00 1,111.72 0.00 2,688.28 70.74 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 830.00 335.64 517.60 -23.24 -2.80 E25 Repairs & Maintenance 830.00 335.64 517.60 -23.24 -2.80 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works-Admin 408,340.38 56,141.83 517.60 351,680.95 86.12 541 Public Works-Engineering 10-541-501020 Salaries 662,630.75 117,081.48 0.00 545,549.27 82.33 10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 200.00 419.86 0.00 -219.86 -109.93 10-541-501095 Overtime Straight Pay 200.00 0.00 0.00 200.00 100.00 10-541-502010 Social Security 50,721.85 8,605.30 0.00 42,116.55 83.03 10-541-502020 Group Health Insurance 96,562.21 13,545.57 0.00 83,016.64 85.97 10-541-502030 Retirement 130,617.06 21,267.71 0.00 109,349.35 83.72 10-541-502040 Workers Compensation 1,204.70 0.00 0.00 1,204.70 100.00 10-541-502050 Life Insurance 1,100.40 165.82 0.00 934.58 84.93 10-541-502060 Long Term Disability 1,816.32 273.77 0.00 1,542.55 84.93 10-541-502070 Employee Assistance Prgm 244.20 61.30 0.00 182.90 74.90 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 945,297.49 161,420.81 0.00 783,876.68 82.92 10-541-511010 Advertising 600.00 127.75 0.00 472.25 78.71 10-541-511020 Postage 800.00 13.62 0.00 786.38 98.30 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 0.00 0.00 75.00 100.00 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 8,000.00 340.63 0.00 7,659.37 95.74 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-541-515080 Surveying Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-541-517010 Operational Supplies 1,150.00 3.88 0.00 1,146.12 99.66 E10 Materials & Supplies 15,125.00 485.88 0.00 14,639.12 96.79 10-541-520030 Dues And Publications 4,000.00 1,933.80 0.00 2,066.20 51.66 10-541-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,500.00 0.00 0.00 4,500.00 100.00 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 4,000.00 0.00 0.00 4,000.00 100.00 E15 Contractual Services 12,500.00 1,933.80 0.00 10,566.20 84.53 10-541-534010 Telephone 1,000.00 74.98 0.00 925.02 92.50 E20 Utilities 1,000.00 74.98 0.00 925.02 92.50 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 80.00 0.00 920.00 92.00 10-541-546010 Clothing Expense 1,000.00 160.00 0.00 840.00 84.00 10-541-547010 Equipment Maintenance 1,500.00 593.12 0.00 906.88 60.46 10-541-547020 Maintenance Agreements 13,000.00 926.68 517.60 11,555.72 88.89 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 16,500.00 1,759.80 517.60 14,222.60 86.20 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 990,422.49 165,675.27 517.60 824,229.62 83.22 542 Public Works-Street 10-542-501020 Salaries 1,010,882.92 178,845.07 0.00 832,037.85 82.31 10-542-501060 Seasonal Salaries 20,543.42 0.00 0.00 20,543.42 100.00 10-542-501070 Stand-by Plan 4,081.31 788.00 0.00 3,293.31 80.69 10-542-501090 Overtime 20,000.00 10,506.64 0.00 9,493.36 47.47 10-542-501095 Overtime Straight Pay 2,000.00 97.03 0.00 1,902.97 95.15 10-542-502010 Social Security 80,893.69 14,236.46 0.00 66,657.23 82.40 10-542-502020 Group Health Insurance 167,122.47 22,398.70 0.00 144,723.77 86.60 10-542-502030 Retirement 204,267.42 33,518.92 0.00 170,748.50 83.59 10-542-502040 Workers Compensation 26,942.26 0.00 0.00 26,942.26 100.00 10-542-502050 Life Insurance 1,700.04 255.43 0.00 1,444.61 84.98 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502060 Long Term Disability 2,785.20 418.20 0.00 2,367.00 84.98 10-542-502070 Employee Assistance Prgm 521.70 130.97 0.00 390.73 74.90 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 250.00 0.00 0.00 250.00 100.00 E05 Personnel Services 1,542,190.43 261,195.42 0.00 1,280,995.01 83.06 10-542-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-542-511020 Postage 150.00 0.92 0.00 149.08 99.39 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,500.00 39.28 0.00 1,460.72 97.38 10-542-514020 Chemicals 300,000.00 147,186.49 -146,420.58 299,234.09 99.74 10-542-514030 Small Tools 9,000.00 852.33 0.00 8,147.67 90.53 10-542-514040 Food 700.00 84.02 0.00 615.98 88.00 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 174,750.00 16,745.18 0.00 158,004.82 90.42 10-542-515040 First Aid Supplies 500.00 299.00 0.00 201.00 40.20 10-542-515060 Weed Control 1,500.00 0.00 0.00 1,500.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 748.56 0.00 4,251.44 85.03 E10 Materials & Supplies 493,700.00 165,955.78 -146,420.58 474,164.80 96.04 10-542-520030 Dues And Publications 320.00 452.00 0.00 -132.00 -41.25 10-542-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 2,200.00 0.00 0.00 2,200.00 100.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,000.00 1,184.20 2,640.00 11,175.80 74.51 10-542-523010 Equipment Rentlease 200.00 60.00 0.00 140.00 70.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,720.00 1,696.20 2,640.00 13,383.80 75.53 10-542-531010 Electricity 25,000.00 4,937.02 0.00 20,062.98 80.25 10-542-531020 Street Lights 527,900.00 103,981.04 0.00 423,918.96 80.30 10-542-533010 Natural Gas 17,000.00 3,498.80 0.00 13,501.20 79.42 10-542-534010 Telephone 500.00 94.28 0.00 405.72 81.14 10-542-535010 Water 6,000.00 656.98 0.00 5,343.02 89.05 E20 Utilities 576,400.00 113,168.12 0.00 463,231.88 80.37 10-542-540010 Building & Grounds Maint.7,000.00 80.48 25.00 6,894.52 98.49 10-542-541030 Vehicle Wash 6,620.00 552.00 0.00 6,068.00 91.66 10-542-542010 Repairs - Stop Lights 10,000.00 2,340.11 0.00 7,659.89 76.60 10-542-542030 Signs & Marking Paint 35,000.00 3,727.16 0.00 31,272.84 89.35 10-542-546010 Clothing Expense 10,000.00 2,820.71 0.00 7,179.29 71.79 10-542-547010 Equipment Maintenance 3,200.00 1,492.17 0.00 1,707.83 53.37 10-542-547020 Maintenance Agreements 500.00 279.36 54.00 166.64 33.33 10-542-547030 Radio Maintenance 100.00 73.76 0.00 26.24 26.24 E25 Repairs & Maintenance 72,420.00 11,365.75 79.00 60,975.25 84.20 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 542 Public Works-Street 2,702,430.43 553,381.27 -143,701.58 2,292,750.74 84.84 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 0.00 0.00 4,000.00 100.00 10-700-590070 Airport Subsidy 170,789.16 14,232.43 0.00 156,556.73 91.67 10-700-590075 Transit Subsidy 363,990.70 30,332.56 0.00 333,658.14 91.67 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 538,779.86 44,564.99 0.00 494,214.87 91.73 700 Transfers & Subsidies 538,779.86 44,564.99 0.00 494,214.87 91.73 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-577042 Mo Blvd Sidewalks 0.00 57,274.04 13,490.24 -70,764.28 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 2,790.68 -2,790.68 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 787,707.00 0.00 0.00 787,707.00 100.00 E75 Capital Projects 787,707.00 57,274.04 16,280.92 714,152.04 90.66 990 Capital Projects 787,707.00 57,274.04 16,280.92 714,152.04 90.66 Expense Expense 30,798,921.94 5,023,756.16 595,437.25 25,179,728.53 81.76 GL - Trial Balance by Full Acct Number (01/14/2014 - 3:29 PM)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$ Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. SOURCES AND USES OF FUNDS City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - Dated Date03/01/2014 Delivery Date03/01/2014 Sources: Bond Proceeds: Par Amount8,160,000.00 Net Original Issue Discount -15,808.85 8,144,191.15 Uses: Project Fund Deposits: Project Fund8,001,391.15 Cost of Issuance: ($17.5 / 1000)142,800.00 8,144,191.15 Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. BOND DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - Period Annual EndingPrincipalCouponInterestDebt ServiceDebt Service 04/01/201426,333.3326,333.33 10/01/2014390,0003.000%158,000.00548,000.00 10/31/2014574,333.33 04/01/2015152,150.00152,150.00 10/01/2015270,0003.000%152,150.00422,150.00 10/31/2015574,300.00 04/01/2016148,100.00148,100.00 10/01/2016275,0003.000%148,100.00423,100.00 10/31/2016571,200.00 04/01/2017143,975.00143,975.00 10/01/2017285,0003.000%143,975.00428,975.00 10/31/2017572,950.00 04/01/2018139,700.00139,700.00 10/01/2018295,0003.000%139,700.00434,700.00 10/31/2018574,400.00 04/01/2019135,275.00135,275.00 10/01/2019300,0003.000%135,275.00435,275.00 10/31/2019570,550.00 04/01/2020130,775.00130,775.00 10/01/2020310,0003.000%130,775.00440,775.00 10/31/2020571,550.00 04/01/2021126,125.00126,125.00 10/01/2021320,0003.000%126,125.00446,125.00 10/31/2021572,250.00 04/01/2022121,325.00121,325.00 10/01/2022330,0003.250%121,325.00451,325.00 10/31/2022572,650.00 04/01/2023115,962.50115,962.50 10/01/2023340,0003.500%115,962.50455,962.50 10/31/2023571,925.00 04/01/2024110,012.50110,012.50 10/01/2024350,0003.750%110,012.50460,012.50 10/31/2024570,025.00 04/01/2025103,450.00103,450.00 10/01/2025365,0003.750%103,450.00468,450.00 10/31/2025571,900.00 04/01/202696,606.2596,606.25 10/01/2026380,0004.000%96,606.25476,606.25 10/31/2026573,212.50 04/01/202789,006.2589,006.25 10/01/2027395,0004.000%89,006.25484,006.25 10/31/2027573,012.50 04/01/202881,106.2581,106.25 10/01/2028410,0004.375%81,106.25491,106.25 10/31/2028572,212.50 04/01/202972,137.5072,137.50 10/01/2029430,0004.375%72,137.50502,137.50 10/31/2029574,275.00 04/01/203062,731.2562,731.25 10/01/2030445,0004.375%62,731.25507,731.25 10/31/2030570,462.50 04/01/203152,996.8852,996.88 10/01/2031465,0004.625%52,996.88517,996.88 10/31/2031570,993.76 04/01/203242,243.7542,243.75 10/01/2032490,0004.625%42,243.75532,243.75 10/31/2032574,487.50 04/01/203330,912.5030,912.50 10/01/2033510,0004.625%30,912.50540,912.50 10/31/2033571,825.00 04/01/203419,118.7519,118.75 10/01/2034535,0004.750%19,118.75554,118.75 10/31/2034573,237.50 04/01/20356,412.506,412.50 10/01/2035270,0004.750%6,412.50276,412.50 10/31/2035282,825.00 8,160,0004,144,577.0912,304,577.0912,304,577.09 Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. NET DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - PeriodTotalNet EndingPrincipalCouponInterestDebt ServiceDebt Service 10/31/2014390,0003.000%184,333.33574,333.33574,333.33 10/31/2015270,0003.000%304,300.00574,300.00574,300.00 10/31/2016275,0003.000%296,200.00571,200.00571,200.00 10/31/2017285,0003.000%287,950.00572,950.00572,950.00 10/31/2018295,0003.000%279,400.00574,400.00574,400.00 10/31/2019300,0003.000%270,550.00570,550.00570,550.00 10/31/2020310,0003.000%261,550.00571,550.00571,550.00 10/31/2021320,0003.000%252,250.00572,250.00572,250.00 10/31/2022330,0003.250%242,650.00572,650.00572,650.00 10/31/2023340,0003.500%231,925.00571,925.00571,925.00 10/31/2024350,0003.750%220,025.00570,025.00570,025.00 10/31/2025365,0003.750%206,900.00571,900.00571,900.00 10/31/2026380,0004.000%193,212.50573,212.50573,212.50 10/31/2027395,0004.000%178,012.50573,012.50573,012.50 10/31/2028410,0004.375%162,212.50572,212.50572,212.50 10/31/2029430,0004.375%144,275.00574,275.00574,275.00 10/31/2030445,0004.375%125,462.50570,462.50570,462.50 10/31/2031465,0004.625%105,993.76570,993.76570,993.76 10/31/2032490,0004.625%84,487.50574,487.50574,487.50 10/31/2033510,0004.625%61,825.00571,825.00571,825.00 10/31/2034535,0004.750%38,237.50573,237.50573,237.50 10/31/2035270,0004.750%12,825.00282,825.00282,825.00 8,160,0004,144,577.0912,304,577.0912,304,577.09 Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. BOND SUMMARY STATISTICS City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - Dated Date03/01/2014 Delivery Date03/01/2014 Last Maturity10/01/2035 Arbitrage Yield4.189982% True Interest Cost (TIC)4.189982% Net Interest Cost (NIC)4.235783% All-In TIC4.387984% Average Coupon4.219688% Average Life (years)12.037 Weighted Average Maturity (years)11.911 Duration of Issue (years)9.162 Par Amount8,160,000.00 Bond Proceeds8,144,191.15 Total Interest4,144,577.09 Net Interest4,160,385.94 Bond Years from Dated Date98,220,000.00 Bond Years from Delivery Date98,220,000.00 Total Debt Service12,304,577.09 Maximum Annual Debt Service574,487.50 Average Annual Debt Service570,096.24 Underwriter's Fees (per $1000) Average Takedown Other Fee Total Underwriter's Discount Bid Price99.806264 ParAverageAverage Bond ComponentValuePriceCouponLife Serial Bonds3,115,000.00102.0033.146%5.127 Term Bond715,000.0099.7183.750%11.094 Term Bond #2775,000.0099.2724.000%13.093 Term Bond #31,285,000.0098.6614.375%15.611 Term Bond #41,465,000.0097.6664.625%18.614 Term Bond #5805,000.0097.6214.750%20.919 8,160,000.0012.037 Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. BOND PRICING City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - MaturityPremium Bond ComponentDateAmountRateYieldPrice(-Discount)Principal Cost Serial Bonds: 10/01/2014390,0003.000%0.570%101.4125,506.80395,506.80 10/01/2015270,0003.000%0.830%103.4059,193.50279,193.50 10/01/2016275,0003.000%1.110%104.79913,197.25288,197.25 10/01/2017285,0003.000%1.520%105.14114,651.85299,651.85 10/01/2018295,0003.000%1.970%104.49113,248.45308,248.45 10/01/2019300,0003.000%2.400%103.1169,348.00309,348.00 10/01/2020310,0003.000%2.800%101.1933,698.30313,698.30 10/01/2021320,0003.000%3.110%99.260 -2,368.00 317,632.00 10/01/2022330,0003.250%3.360%99.183 -2,696.10 327,303.90 10/01/2023340,0003.500%3.550%99.594 -1,380.40 338,619.60 3,115,000 62,399.65 3,177,399.65 Term Bond: 10/01/2024350,0003.750%3.780%99.718 -987.00 349,013.00 10/01/2025365,0003.750%3.780%99.718 -1,029.30 363,970.70 715,000 -2,016.30 712,983.70 Term Bond #2: 10/01/2026380,0004.000%4.070%99.272 -2,766.40 377,233.60 10/01/2027395,0004.000%4.070%99.272 -2,875.60 392,124.40 775,000 -5,642.00 769,358.00 Term Bond #3: 10/01/2028410,0004.375%4.490%98.661 -5,489.90 404,510.10 10/01/2029430,0004.375%4.490%98.661 -5,757.70 424,242.30 10/01/2030445,0004.375%4.490%98.661 -5,958.55 439,041.45 1,285,000 -17,206.15 1,267,793.85 Term Bond #4: 10/01/2031465,0004.625%4.810%97.666 -10,853.10 454,146.90 10/01/2032490,0004.625%4.810%97.666 -11,436.60 478,563.40 10/01/2033510,0004.625%4.810%97.666 -11,903.40 498,096.60 1,465,000 -34,193.10 1,430,806.90 Term Bond #5: 10/01/2034535,0004.750%4.930%97.621 -12,727.65 522,272.35 10/01/2035270,0004.750%4.930%97.621 -6,423.30 263,576.70 805,000 -19,150.95 785,849.05 8,160,000 -15,808.85 8,144,191.15 Dated Date03/01/2014 Delivery Date03/01/2014 First Coupon04/01/2014 Par Amount8,160,000.00 Original Issue Discount -15,808.85 Production8,144,191.1599.806264% Underwriter's Discount Purchase Price8,144,191.1599.806264% Accrued Interest Net Proceeds8,144,191.15 Jan 16, 2014 1:22 pm Prepared by Piper Jaffray & Co. BOND SOLUTION City of Jefferson, Missouri Certificates of Participation Series 2014 - Preliminary, 'A+' Rated - PeriodProposedProposedTotal AdjRevenueUnusedDebt Serv EndingPrincipalDebt ServiceDebt ServiceConstraintsRevenuesCoverage 10/31/2014390,000574,333574,333575,000667100.11608% 10/31/2015270,000574,300574,300575,000700100.12189% 10/31/2016275,000571,200571,200575,0003,800100.66527% 10/31/2017285,000572,950572,950575,0002,050100.35780% 10/31/2018295,000574,400574,400575,000600100.10446% 10/31/2019300,000570,550570,550575,0004,450100.77995% 10/31/2020310,000571,550571,550575,0003,450100.60362% 10/31/2021320,000572,250572,250575,0002,750100.48056% 10/31/2022330,000572,650572,650575,0002,350100.41037% 10/31/2023340,000571,925571,925575,0003,075100.53766% 10/31/2024350,000570,025570,025575,0004,975100.87277% 10/31/2025365,000571,900571,900575,0003,100100.54205% 10/31/2026380,000573,213573,213575,0001,788100.31184% 10/31/2027395,000573,013573,013575,0001,988100.34685% 10/31/2028410,000572,213572,213575,0002,788100.48714% 10/31/2029430,000574,275574,275575,000725100.12625% 10/31/2030445,000570,463570,463575,0004,538100.79541% 10/31/2031465,000570,994570,994575,0004,006100.70163% 10/31/2032490,000574,488574,488575,000513100.08921% 10/31/2033510,000571,825571,825575,0003,175100.55524% 10/31/2034535,000573,238573,238575,0001,763100.30746% 10/31/2035270,000282,825282,825287,5004,675101.65297% 8,160,00012,304,57712,304,57712,362,50057,923 Disclosure We are providing this material to provide you with certain regulatory disclosures as required by the Municipal Securities Rulemaking Board. As part of our services, Piper Jaffray may provide advice concerning the structure, timing, terms, and other similar matters concerning an issue of municipal securities that Piper Jaffray is underwriting or placing. However, Piper Jaffray intends to serve as an underwriter and not as a financial advisor to you in this transaction; and the primary role of Piper Jaffray is to purchase securities for resale to investors or arrange for the placement of securities in an arm’s-length commercial transaction between you and Piper Jaffray. Piper Jaffray has financial and other interests that differ from your interests. BILL NO. SPONSORED BY COUNCILMAN ORDINANCE NO. AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, AMENDING THE 2013- 2014 BUDGET OF THE CITY OF JEFFERSON, MISSOURI, BY DELETING THE POSITION OF ENGINEERING SUPERVISOR WITHIN THE PERSONNEL SCHEDULE OF FULL-TIME POSITIONS. BE IT ENACTED BY THE CITY COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS FOLLOWS: Section 1. The Personnel Schedule of Full Time positions as set out in the 2013- 2014 Budget is hereby amended to eliminate the position of Engineering Supervisor, range 23. Section 2. This Ordinance shall be in full force and effect from and after the date of its passage and approval. Passed: Approved: Presiding Officer Mayor ATTEST: City Clerk 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 566.37 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge Jul-12 8/20/12 89,904.69 37,759.97 50,346.63 Aug-12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) Ck #1001 - C H Johnson Consulting Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Convention Center Fund (4/7) Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 8/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Total 2,673,829.66 1,123,008.46 1,478,752.33 average monthly amount for Convention Center Fund 49,911.49$