Loading...
HomeMy Public PortalAbout20130723 finance packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Tuesday, July 23, 2013 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the June 25, 2013 meeting 4. Financial Reports – Bill Betts 5. Income Statement – Bill Betts 6. Lodging Tax Report – Shiela Pearre 7. Alpla to Present to the Finance Committee – Randy Allen 8. New Business 9. Old Business a. Economic Development Incentives Policy – Drew Hilpert 10. 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, June 25, 2013 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Shawn Schulte at 7:30 AM. Roll call showed that Councilmen Schulte, Graham, Prather, Scrivner and Bray were in attendance. The minutes of the May 28, 2013 meeting were reviewed and a motion to approve was made by Councilman Graham and seconded by Councilman Bray. The minutes were approved unanimously. The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the sales tax revenue for June. Mr. Betts discussed the new format of the sales tax report and pointed out that the projections for the next six months were the actual numbers from the previous year. Also, it was noted that the majority of the general ledger accounts with negative balances were cleaned-up. The next item on the agenda was a report by the Interim Finance Director, Bill Betts, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7% is $1,159,856.12. The average monthly amount collected for the Conference Center Fund is $48,327.34. This is on target for the $9,000,000 bond. The next item on the agenda was RFP 2680 for Audit Services. There were six responses to the RFP. A committee was formed to evaluate all responses. It was comprised of four people from three different departments. It is the recommendation of the committee to award the contract to the best offer which was from Evers and Company, LLC of Jefferson City, Missouri. Mr. Betts informed the committee that the recommendation would not be moved to the full council, if so approved by the committee, until the second meeting in July due to the protest period. A motion to move the committee recommendation to the full council at the second meeting in July was made by Councilman Scrivner and seconded by Councilman Bray. There was no New Business. The next item on the agenda was Old Business. Councilman Schulte mentioned the Economic Development Policy. If anyone had questions they should email City Counselor, Drew Hilpert. It will be discussed at the next Finance Committee meeting. A motion to adjourn was made by Councilman Graham and seconded by Councilman Scrivner. Adjournment took place at 7.50 AM. As recorded by: Cara Sankey, Accountant Memo To:Nathan Nickolaus From:Shiela Pearre Date:July 8, 2013 Re:Sales Tax Revenues The City received the July 1% Sales Tax in the amount of $872,436 which is $74,656 more than projected for July. January through July shortage is $20,353 (0.21%) in the General Fund. 1% General Sales Tax ReceiptBudget Actual PeriodProjectionReceipts Variance Nov-12Jan-13$764,659$764,659$0 Dec-12Feb-13$703,181$703,181$0 Jan-13& Oct-Dec 12 QtrlyMar-13$992,559$1,008,111$15,552 Feb-13Apr-13$852,412$777,424($74,988) Mar-13May-13$567,215$537,141($30,074) Apr-13& Jan-Mar 13 QtrlyJun-13$1,028,514$1,023,015($5,499) May-13Jul-13$797,780$872,436$74,656 Jun-13Aug-13$557,032$0 Jul-13& Apr-June 13 QtrlySep-13$1,069,414$0 Aug-13Oct-13$769,129$0 Sep-13Nov-13$615,421$0 Oct-13& Jul-Sept 13 QtrlyDec-13$982,684$0 Total Overage/Shortfall ($20,353) 1/2% Capital Improvement Tax ReceiptBudget Actual PeriodProjectionReceipts Variance Nov-12Jan-13$416,244$372,459($43,785) Dec-12Feb-13$311,418$350,813$39,395 Jan-13& Oct-Dec 12 QtrlyMar-13$471,169$475,110$3,941 Feb-13Apr-13$413,147$372,340($40,806) Mar-13May-13$266,340$266,422$82 Apr-13& Jan-Mar 13 QtrlyJun-13$499,328$483,070($16,258) May-13Jul-13$393,021$425,325$32,305 Jun-13Aug-13$280,801$0 Jul-13& Apr-June 13 QtrlySep-13$508,966$0 Aug-13Oct-13$370,760$0 Sep-13Nov-13$268,825$0 Oct-13& Jul-Sept 13 QtrlyDec-13$499,983$0 Total Overage/Shortfall ($25,126) 1/2% Parks Sales Tax ReceiptBudget Actual PeriodProjectionReceipts Variance Nov-12Jan-13$396,815$372,447($24,368) Dec-12Feb-13$407,348$350,714($56,634) Jan-13& Oct-Dec 12 QtrlyMar-13$280,734$475,026$194,292 Feb-13Apr-13$452,735$372,242($80,493) Mar-13May-13$315,030$266,456($48,574) Apr-13& Jan-Mar 13 QtrlyJun-13$439,265$482,382$43,117 May-13Jul-13$468,387$425,194($43,193) Jun-13Aug-13$282,836$0 Jul-13& Apr-June 13 QtrlySep-13$482,150$0 Aug-13Oct-13$382,115$0 Sep-13Nov-13$264,735$0 Oct-13& Jul-Sept 13 QtrlyDec-13$495,470$0 Total Overage/Shortfall ($15,854) Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: JULY 2013 Account Number 10-100-400010 Monthly REPORTING PERIODRECEIPT PERIOD20082009201020112012 2013 Average NovJanuary860,921787,676928,460809,385843,061764,659act.845,901 DecFebruary630,186572,813631,137833,919619,287703,181act.657,468 Jan & Oct-Dec QtrlyMarch1,076,3951,079,246894,158589,958992,5591,008,111act.926,463 FebApril836,513763,906774,964978,391852,653777,424act.841,286 MarMay 445,903516,016592,657633,676530,069537,141act.543,664 Apr & Jan-Mar QtrlyJune1,103,170934,660843,712925,5551,028,5141,023,015act.967,122 MayJuly821,905686,153939,495955,495797,785872,436act.840,167 JunAugust485,766526,097495,667566,299557,032557,032est.526,172 Jul & Apr-Jun QtrlySeptember1,102,8261,006,1201,040,1561,032,2581,069,4141,069,414est.1,050,155 AugOctober788,085718,480822,163797,510769,129769,129est.779,073 SeptNovember 486,258554,824482,807536,185615,421615,421est.535,099 Oct & Jul-Sept QtrlyDecember926,760801,780881,7801,032,046982,684982,684est.925,010 Actual to Date $ 9,564,688$ 8,947,771$ 9,327,157$ 9,690,677$ 9,657,608 5,685,967 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,993,680 Total Actual & Estimated $ 9,679,647 Less: Budget 9,700,000 Over (Under) Budget -$ 20,353 $ 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 $ 764,659.00 $1,467,840.00 $2,460,399.00 $3,312,811.00 $3,880,026.00 $4,908,540.00 $5,706,320.00 $6,263,352.00 $7,332,766.00 $8,101,895.00 $8,717,316.00 $9,700,000.00 $ 500,000.00 $ 750,000.00 $ 1,000,000.00 $ 1,250,000.00 $ 1,500,000.00 $ 1,750,000.00 $ 2,000,000.00 $ 2,250,000.00 $ 2,500,000.00 $ 2,750,000.00 $ 3,000,000.00 $ 3,250,000.00 $ 3,500,000.00 $ 3,750,000.00 $ 4,000,000.00 $ 4,250,000.00 $ 4,500,000.00 $ 4,750,000.00 $ 5,000,000.00 $ 5,250,000.00 $ 5,500,000.00 $ 5,750,000.00 $ 6,000,000.00 $ 6,250,000.00 $ 6,500,000.00 $ 6,750,000.00 $ 7,000,000.00 $ 7,250,000.00 $ 7,500,000.00 $ 7,750,000.00 $ 8,000,000.00 $ 8,250,000.00 $ 8,500,000.00 $ 8,750,000.00 $ 9,000,000.00 $ 9,250,000.00 $ 9,500,000.00 $ 9,750,000.00 $ 10,000,000.00 $ 10,250,000.00 NovDecJan & Oct‐ Dec Qtrly FebMarApr & Jan‐ Mar Qtrly MayJunJul & Apr‐ Jun Qtrly AugSeptOct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 7/8/2013 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2013 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIODRECEIPT PERIOD20082009201020112012 2013 Average NovJanuary416,277384,327455,480396,799412,434372,459act.413,063 DecFebruary313,830286,909313,836407,407308,567350,813act.326,110 Jan & Oct-Dec QtrlyMarch508,380505,185415,473280,758466,856475,110act.435,331 FebApril400,771365,514370,473452,824409,365372,340act.399,790 MarMay 221,579257,313295,545315,165263,902266,422act.270,701 Apr & Jan-Mar QtrlyJune527,104453,788400,667439,298494,757483,070act.463,123 MayJuly403,495326,501462,244468,643389,423425,325act.410,061 JunAugust241,889261,707247,260282,859278,231280,801est.262,389 Jul & Apr-Jun QtrlySeptember530,392481,799495,398482,244504,307508,966est.498,828 AugOctober381,230348,002395,058382,206367,366370,760est.374,772 SeptNovember 241,897276,487240,417266,364306,968268,825est.266,427 Oct & Jul-Sept QtrlyDecember447,485384,320428,058495,406469,095499,983est.444,873 Actual to Date $ 4,634,329$ 4,331,852$ 4,519,908$ 4,669,974$ 4,671,272 2,745,539 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,929,335 Total Actual & Estimated $ 4,674,874 Less: Budget 4,700,002 Over (Under) Budget -$ 25,128 $ 372,458.69 $ 723,271.57 $ 1,198,381.28 $ 1,570,721.73 $ 1,837,144.01 $ 2,320,213.81 $ 2,745,539.17 $ 416,244.00 $727,662.00 $1,198,831.00 $1,611,978.00 $1,878,318.00 $2,377,646.00 $2,770,667.00 $3,051,468.00 $3,560,434.00 $3,931,194.00 $4,200,019.00 $4,700,002.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 NovDecJan & Oct‐ Dec Qtrly FebMarApr & Jan‐ Mar Qtrly MayJunJul & Apr‐ Jun Qtrly AugSeptOct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 7/8/2013 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2013 Account Number 21-210-400010 Monthly REPORTING PERIODRECEIPT PERIOD20082009201020112012 2013 Average NovJanuary416,569384,305455,442396,815405,730372,447act.411,772 DecFebruary313,259286,889313,792407,348308,456350,714act.325,949 Jan & Oct-Dec QtrlyMarch508,249507,768415,275280,734466,713475,026act.435,748 FebApril400,606365,727370,308452,735409,353372,242act.399,746 MarMay 220,821256,675295,529315,030263,822266,456act.270,375 Apr & Jan-Mar QtrlyJune527,025453,016400,500439,265494,733482,382act.462,908 MayJuly402,482326,518461,255468,387389,006425,194act.409,530 JunAugust241,656261,622247,216282,836278,072282,836est.262,280 Jul & Apr-Jun QtrlySeptember530,352481,772495,222482,150505,913482,150est.499,082 AugOctober381,309347,721395,014382,115366,846382,115est.374,601 SeptNovember 243,796275,469240,348264,735306,831264,735est.266,236 Oct & Jul-Sept QtrlyDecember446,797384,300428,200495,305468,924495,470est.444,705 Actual to Date $ 4,632,921$ 4,331,782$ 4,518,100$ 4,667,453$ 4,664,400 2,744,460 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,907,306 Total Actual & Estimated $ 4,651,766 Less: Budget 4,667,620 Over (Under) Budget -$ 15,854 $ 372,446.56 $ 723,160.39 $ 1,198,185.94 $ 1,570,427.84 $ 1,836,884.14 $ 2,319,266.06 $ 2,744,459.67 $ 396,815.00 $804,163.00 $1,084,897.00 $1,537,632.00 $1,852,662.00 $2,291,927.00 $2,760,314.00 $3,043,150.00 $3,525,300.00 $3,907,415.00 $4,172,150.00 $4,667,620.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 NovDecJan & Oct‐ Dec Qtrly FebMarApr & Jan‐ Mar Qtrly MayJunJul & Apr‐ Jun Qtrly AugSeptOct & Jul‐ Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Printed 7/8/2013 General Ledger Trial Balance by Full Acct Number User: spearre Printed: 07/16/13 08:14:11 Period 01 - 13 Fiscal Year 2013 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,700,000.00 5,685,967.41 0.00 4,014,032.59 41.38 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,700,000.00 5,685,967.41 0.00 4,014,032.59 41.38 10-100-401030 Motor Vehicle Sales Tax 403,750.00 235,323.63 0.00 168,426.37 41.72 R15 Motor Vehicle Sales Tax 403,750.00 235,323.63 0.00 168,426.37 41.72 10-100-403010 Gasoline Tax 1,100,950.00 526,190.01 0.00 574,759.99 52.21 10-100-403020 Cigarette Tax 147,000.00 74,318.96 0.00 72,681.04 49.44 R20 Other Taxes 1,247,950.00 600,508.97 0.00 647,441.03 51.88 10-100-410020 Electric Utility Lic Tax 3,225,000.00 1,664,660.94 0.00 1,560,339.06 48.38 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 900,000.00 779,419.88 0.00 120,580.12 13.40 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 Telephone Utility Lic Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 Cell Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,825,000.00 1,404,023.78 0.00 1,420,976.22 50.30 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 81,796.40 0.00 28,203.60 25.64 10-100-410060 Cable Franchise Fee 325,000.00 169,891.24 0.00 155,108.76 47.73 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,385,000.00 4,099,792.24 0.00 3,285,207.76 44.48 10-100-420010 Cur Property Tax 4,600,000.00 4,559,886.24 0.00 40,113.76 0.87 10-100-420020 Del Property Tax 50,000.00 41,925.20 0.00 8,074.80 16.15 10-100-420040 Fin Inst Tax 30,000.00 30,689.00 0.00 -689.00 -2.30 10-100-420050 Prop Tax Int & Penalties 16,000.00 23,002.21 0.00 -7,002.21 -43.76 10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74 10-100-420060 Surtax Receipts 450,000.00 473,502.77 0.00 -23,502.77 -5.22 10-100-420080 Special Tax Rev 21,000.00 14,038.54 0.00 6,961.46 33.15 R40 Property Taxes 5,221,000.00 5,197,443.24 0.00 23,556.76 0.45 10-100-430010 Federal Grants 1,748,895.20 295,412.35 0.00 1,453,482.85 83.11 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430020 State Grants 10,650.00 0.00 0.00 10,650.00 100.00 10-100-430040 Local Grants 15,594.00 22,146.60 0.00 -6,552.60 -42.02 10-100-430055 DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 20,763.76 0.00 -20,763.76 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 551,540.67 0.00 -1,540.67 -0.28 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 2,325,139.20 889,863.38 0.00 1,435,275.82 61.73 10-100-440010 Admin Charge Backs 1,225,660.00 810,119.47 0.00 415,540.53 33.90 10-100-440050 Emt Reimbursement 35,000.00 0.00 0.00 35,000.00 100.00 10-100-440210 Street Cuts 25,000.00 20,293.00 0.00 4,707.00 18.83 10-100-440910 Fuel Charge-backs 364,590.00 225,695.81 0.00 138,894.19 38.10 10-100-440920 Parts Charge-back 170,610.00 99,807.79 0.00 70,802.21 41.50 10-100-440930 Labor Charge-backs 167,800.00 86,625.99 0.00 81,174.01 48.38 R60 Charges for Services 1,988,660.00 1,242,542.06 0.00 746,117.94 37.52 10-100-450010 Liquor Licenses 60,000.00 62,473.33 0.00 -2,473.33 -4.12 10-100-450020 Business Licenses 233,800.00 162,773.47 0.00 71,026.53 30.38 10-100-450021 Home Occupation Permit 1,500.00 1,354.00 0.00 146.00 9.73 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 627.31 0.00 -627.31 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 1,485.73 0.00 -1,485.73 0.00 10-100-450045 Bldg Constr Fees 150,000.00 107,055.32 0.00 42,944.68 28.63 10-100-450050 Electrical Certificates 20,000.00 14,652.00 0.00 5,348.00 26.74 10-100-450060 Electrical Permits 2,500.00 2,339.08 0.00 160.92 6.44 10-100-450070 Plumbing Licenses 12,000.00 9,741.00 0.00 2,259.00 18.83 10-100-450080 Plumbing Permits 7,500.00 4,370.00 0.00 3,130.00 41.73 10-100-450090 Other Lic & Permits 1,500.00 1,100.00 0.00 400.00 26.67 10-100-450091 Day Care Inspection Fees 8,000.00 3,160.00 0.00 4,840.00 60.50 10-100-450092 Food Inspection Fees 88,000.00 86,587.58 0.00 1,412.42 1.61 10-100-450100 Curb Cut Permits 700.00 550.00 0.00 150.00 21.43 10-100-450110 Board Of Adj Fees 800.00 2,600.00 0.00 -1,800.00 -225.00 10-100-450120 Sign Permits 4,000.00 2,758.00 0.00 1,242.00 31.05 10-100-450130 Demolition Permits 500.00 554.00 0.00 -54.00 -10.80 10-100-450150 Acc Rep Fees-police 12,000.00 8,532.65 0.00 3,467.35 28.89 10-100-450160 Accrptblastg P-fire 2,000.00 510.00 0.00 1,490.00 74.50 10-100-450170 Animal Redemption Fees 53,000.00 35,090.00 0.00 17,910.00 33.79 10-100-450180 Animal Vaccinations Fees 2,800.00 3,990.00 0.00 -1,190.00 -42.50 10-100-450185 Animal Cremation Fees 15,000.00 17,346.00 0.00 -2,346.00 -15.64 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 300.00 375.00 0.00 -75.00 -25.00 10-100-450230 Vacating Right Of Way 800.00 100.00 0.00 700.00 87.50 10-100-450250 Rezoning Request 10,000.00 6,586.00 0.00 3,414.00 34.14 10-100-450260 Non-refundable Plansspec 3,000.00 1,347.50 0.00 1,652.50 55.08 R65 Fees Licenses & Permits 689,700.00 538,057.97 0.00 151,642.03 21.99 10-100-460010 Court Cost 85,000.00 54,285.79 0.00 30,714.21 36.13 10-100-460015 Court Restitutions 1,300.00 1,116.79 0.00 183.21 14.09 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-460018 Inmate Security Fund 12,080.00 8,732.23 0.00 3,347.77 27.71 10-100-460020 Jail Cost Recovery 15,000.00 7,256.42 0.00 7,743.58 51.62 10-100-460025 Alcohol Offense Cost Rec 13,000.00 7,975.25 0.00 5,024.75 38.65 10-100-460030 Pol Fines-traffic 875,000.00 561,035.34 0.00 313,964.66 35.88 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 35,213.23 0.00 23,386.77 39.91 10-100-460100 Bankcard Charges -10,000.00 -8,837.87 0.00 -1,162.13 11.62 R70 Fines & Forfeitures 1,050,980.00 666,777.18 0.00 384,202.82 36.56 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 5,868.80 0.00 -5,868.80 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 101,406.88 0.00 0.00 101,406.88 100.00 10-100-480025 HUD Program Income 0.00 8,340.00 0.00 -8,340.00 0.00 10-100-480030 Donations-Recycling 5,500.00 11,000.00 0.00 -5,500.00 -100.00 10-100-480050 Sober Driver Program 9,000.00 3,502.22 0.00 5,497.78 61.09 10-100-480055 JC Fire Museum 0.00 2,090.00 0.00 -2,090.00 0.00 10-100-480063 Private Donations-Cultural Art 0.00 200.00 0.00 -200.00 0.00 10-100-480065 Cultural Arts 0.00 20.00 0.00 -20.00 0.00 10-100-480070 Community Projects Donations 3,770.00 2,270.00 0.00 1,500.00 39.79 10-100-480080 Dare Donations 8,000.00 8,006.24 0.00 -6.24 -0.08 10-100-480090 Police K-9 Donations 1,000.00 500.00 0.00 500.00 50.00 10-100-480165 Animal S Donations 80,780.00 4,313.00 0.00 76,467.00 94.66 10-100-481020 Cole Cty Animal Rescue 100,000.00 75,000.00 0.00 25,000.00 25.00 10-100-481030 Rent City Hallannex 6,500.00 6,500.00 0.00 0.00 0.00 10-100-481040 Rent Other 12,000.00 0.00 0.00 12,000.00 100.00 10-100-481045 Rent-tower Sites 80,000.00 45,229.85 0.00 34,770.15 43.46 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 50,110.92 0.00 59,889.08 54.44 10-100-481070 Miscellaneous 24,000.00 13,208.21 0.00 10,791.79 44.97 10-100-481075 Cole Cty 911 Reimb 355,715.00 267,282.52 0.00 88,432.48 24.86 10-100-481077 Insurance Claims 30,000.00 11,368.50 0.00 18,631.50 62.11 10-100-481078 Cafeteria Refunds 15,000.00 0.00 0.00 15,000.00 100.00 10-100-481080 Sale Of Mapsgis Data 100.00 50.00 0.00 50.00 50.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 11,250.00 0.00 3,750.00 25.00 10-100-481090 Cole Cty Sheriff-New World 0.00 28,678.00 0.00 -28,678.00 0.00 10-100-481100 Sale Of Grave Sites 3,500.00 4,400.00 0.00 -900.00 -25.71 10-100-481110 Long & Short 0.00 -33.87 0.00 33.87 0.00 R75 Other Operating Revenues 961,271.88 559,154.39 0.00 402,117.49 41.83 10-100-470010 Interest 40,000.00 57,209.99 0.00 -17,209.99 -43.02 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 40,000.00 57,209.99 0.00 -17,209.99 -43.02 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 297,000.00 277,592.02 0.00 19,407.98 6.53 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R85 Other Non-Operating Revenue 297,000.00 277,592.02 0.00 19,407.98 6.53 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 20,990.00 12,459.63 0.00 8,530.37 40.64 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 17,809.14 0.00 -17,809.14 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 20,990.00 30,268.77 0.00 -9,278.77 -44.21 10-100-495995 Transfer From(to) Surplus 986,566.10 0.00 0.00 986,566.10 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 986,566.10 0.00 0.00 986,566.10 100.00 100 Revenue 32,318,007.18 20,080,501.25 0.00 12,237,505.93 37.87 300 Police Department 10-300-430010 Federal Grants 525,201.79 237,588.44 0.00 287,613.35 54.76 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 68,826.00 20,842.96 0.00 47,983.04 69.72 R50 Intergovernmental 594,027.79 258,431.40 0.00 335,596.39 56.50 300 Police Department 594,027.79 258,431.40 0.00 335,596.39 56.50 310 School Resource Officer 10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-310-430040 Local Grants 188,765.00 192,242.34 0.00 -3,477.34 -1.84 R50 Intergovernmental 188,765.00 192,242.34 0.00 -3,477.34 -1.84 310 School Resource Officer 188,765.00 192,242.34 0.00 -3,477.34 -1.84 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 0.00 24,321.66 0.00 -24,321.66 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 24,321.66 0.00 -24,321.66 0.00 320 M.U.S.T.A.N.G.0.00 24,321.66 0.00 -24,321.66 0.00 Revenue Revenue 33,100,799.97 20,555,496.65 0.00 12,545,303.32 37.90 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 38,475.00 0.00 26,325.00 40.63 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 4,960.00 2,772.28 0.00 2,187.72 44.11 10-110-502020 Group Health Insurance 0.00 650.00 0.00 -650.00 0.00 10-110-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 69,760.00 41,897.28 0.00 27,862.72 39.94 10-110-511010 Advertising 1.15 0.00 0.00 1.15 100.00 10-110-511020 Postage 59.57 59.57 0.00 0.00 0.00 10-110-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-110-512020 Copies 1,030.00 47.72 0.00 982.28 95.37 10-110-513010 Office Supplies 437.50 218.73 218.75 0.03 0.01 E10 Materials & Supplies 1,678.22 326.02 218.75 1,133.46 67.54 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520030 Dues And Publications 5,014.46 4,367.51 0.00 646.95 12.90 10-110-520050 Meeting And Conferences 104.83 64.83 0.00 40.00 38.16 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,119.29 4,432.34 0.00 686.95 13.42 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 76,557.51 46,655.64 218.75 29,683.13 38.77 120 City Clerk 10-120-501020 Salaries 62,566.80 43,502.48 0.00 19,064.32 30.47 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,783.86 3,147.79 0.00 1,636.07 34.20 10-120-502020 Group Health Insurance 11,791.50 8,089.96 0.00 3,701.54 31.39 10-120-502030 Retirement 10,968.60 8,158.65 0.00 2,809.95 25.62 10-120-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-120-502050 Life Insurance 110.00 71.17 0.00 38.83 35.30 10-120-502060 Long Term Disability 151.47 111.85 0.00 39.62 26.16 10-120-502070 Employee Assistance Prgm 33.30 24.56 0.00 8.74 26.25 E05 Personnel Services 90,405.53 63,106.46 0.00 27,299.07 30.20 10-120-511020 Postage 270.00 109.64 0.00 160.36 59.39 10-120-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-120-512020 Copies 4,500.00 220.63 0.00 4,279.37 95.10 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-513010 Office Supplies 1,150.00 20.07 0.00 1,129.93 98.25 E10 Materials & Supplies 6,220.00 350.34 0.00 5,869.66 94.37 10-120-520030 Dues And Publications 200.00 200.00 0.00 0.00 0.00 10-120-520050 Meeting And Conferences 500.00 36.00 0.00 464.00 92.80 10-120-520070 Training And Education 500.00 0.00 0.00 500.00 100.00 10-120-522020 Professional Services 2,299.96 0.00 0.00 2,299.96 100.00 10-120-529030 Election Expense 72,083.02 72,083.02 0.00 0.00 0.00 E15 Contractual Services 75,582.98 72,319.02 0.00 3,263.96 4.32 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 617.02 398.28 218.75 -0.01 0.00 E25 Repairs & Maintenance 617.02 398.28 218.75 -0.01 0.00 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 172,825.53 136,174.10 218.75 36,432.69 21.08 140 City Administrator 10-140-501020 Salaries 204,859.92 146,955.67 0.00 57,904.25 28.27 10-140-501050 Parttime(wo Benefits)100.98 0.00 0.00 100.98 100.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 15,494.23 9,917.13 0.00 5,577.10 35.99 10-140-502020 Group Health Insurance 9,853.41 13,104.85 0.00 -3,251.44 -33.00 10-140-502030 Retirement 36,676.68 27,335.13 0.00 9,341.55 25.47 10-140-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-140-502050 Life Insurance 383.78 224.94 0.00 158.84 41.39 10-140-502060 Long Term Disability 475.08 278.07 0.00 197.01 41.47 10-140-502070 Employee Assistance Prgm 31.59 32.74 0.00 -1.15 -3.64 E05 Personnel Services 267,875.67 197,848.53 0.00 70,027.14 26.14 10-140-511010 Advertising 3,292.49 2,137.95 0.00 1,154.54 35.07 10-140-511020 Postage 370.00 230.26 0.00 139.74 37.77 10-140-512010 Printing 330.00 0.00 0.00 330.00 100.00 10-140-512020 Copies 950.00 93.30 0.00 856.70 90.18 10-140-513010 Office Supplies 1,300.64 1,081.90 218.75 -0.01 0.00 E10 Materials & Supplies 6,243.13 3,543.41 218.75 2,480.98 39.74 10-140-520030 Dues And Publications 580.00 580.00 0.00 0.00 0.00 10-140-520050 Meeting And Conferences 1,211.80 925.41 0.00 286.39 23.63 10-140-520070 Training And Education 99.00 99.00 0.00 0.00 0.00 10-140-522020 Professional Services 3,184.98 205.88 0.00 2,979.10 93.54 E15 Contractual Services 5,075.78 1,810.29 0.00 3,265.49 64.33 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 237.60 237.60 0.00 0.00 0.00 E25 Repairs & Maintenance 237.60 237.60 0.00 0.00 0.00 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 279,432.18 203,439.83 218.75 75,773.61 27.12 149 Entitlement Grant 10-149-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)20,000.00 3,187.50 0.00 16,812.50 84.06 10-149-502010 Social Security 1,000.00 243.86 0.00 756.14 75.61 10-149-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 21,000.00 3,431.36 0.00 17,568.64 83.66 10-149-511010 Advertising 500.00 383.33 0.00 116.67 23.33 10-149-511020 Postage 600.00 158.85 0.00 441.15 73.53 10-149-512020 Copies 800.00 1.55 0.00 798.45 99.81 10-149-513010 Office Supplies 600.00 299.59 0.00 300.41 50.07 E10 Materials & Supplies 2,500.00 843.32 0.00 1,656.68 66.27 10-149-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,500.00 350.40 0.00 1,149.60 76.64 10-149-522020 Professional Services 10,000.00 189.00 0.00 9,811.00 98.11 10-149-528010 Housing Rehabilitation 50,000.00 20,117.25 0.00 29,882.75 59.77 10-149-528020 Housing Assistance 10,020.00 300.00 0.00 9,720.00 97.01 10-149-528030 Public Improvement 50,000.00 0.00 0.00 50,000.00 100.00 10-149-528040 Neighborhood Redevelopmnt 80,000.00 19,500.00 0.00 60,500.00 75.63 10-149-528050 Neighborhood Facility 80,000.00 0.00 0.00 80,000.00 100.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 281,520.00 40,456.65 0.00 241,063.35 85.63 10-149-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-149-572020 Purchase Of Equipment 1,000.00 0.00 0.00 1,000.00 100.00 E70 Capital Purchases 1,000.00 0.00 0.00 1,000.00 100.00 149 Entitlement Grant 306,020.00 44,731.33 0.00 261,288.67 85.38 150 City Counselor 10-150-501020 Salaries 218,045.40 148,223.60 0.00 69,821.80 32.02 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 500.00 183.60 0.00 316.40 63.28 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,687.06 10,656.30 0.00 6,030.76 36.14 10-150-502020 Group Health Insurance 28,192.50 19,832.76 0.00 8,359.74 29.65 10-150-502030 Retirement 38,218.40 23,901.28 0.00 14,317.12 37.46 10-150-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-150-502050 Life Insurance 390.00 238.34 0.00 151.66 38.89 10-150-502060 Long Term Disability 535.13 345.34 0.00 189.79 35.47 10-150-502070 Employee Assistance Prgm 77.70 57.31 0.00 20.39 26.24 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 302,646.19 203,438.53 0.00 99,207.66 32.78 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 100.00 152.69 0.00 -52.69 -52.69 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 153.96 0.00 516.04 77.02 10-150-513010 Office Supplies 2,000.00 1,269.44 0.00 730.56 36.53 10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 3,070.00 1,576.09 0.00 1,493.91 48.66 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 13,250.00 8,474.74 0.00 4,775.26 36.04 10-150-520050 Meeting And Conferences 1,500.00 804.08 0.00 695.92 46.39 10-150-520070 Training And Education 2,400.00 972.01 0.00 1,427.99 59.50 10-150-520080 Tuition Reimbursement 2,880.00 2,394.00 0.00 486.00 16.88 10-150-521010 General Insurance 2,100.00 844.00 0.00 1,256.00 59.81 10-150-522020 Professional Services 12,000.00 11,020.36 0.00 979.64 8.16 10-150-525030 Court Cost & Witness Fees 290.00 28.36 0.00 261.64 90.22 E15 Contractual Services 34,420.00 24,537.55 0.00 9,882.45 28.71 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 1,890.00 913.92 399.91 576.18 30.49 E25 Repairs & Maintenance 1,890.00 913.92 399.91 576.18 30.49 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Counselor 342,026.19 230,466.09 399.91 111,160.20 32.50 160 Municipal Court Dept 10-160-501010 Salary-elected Officals 60,000.00 34,999.93 0.00 25,000.07 41.67 10-160-501020 Salaries 95,145.60 67,524.53 0.00 27,621.07 29.03 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 4,166.75 0.00 5,333.25 56.14 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-501090 Overtime 8,600.00 2,013.91 0.00 6,586.09 76.58 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,252.72 8,207.70 0.00 5,045.02 38.07 10-160-502020 Group Health Insurance 14,248.50 7,793.64 0.00 6,454.86 45.30 10-160-502030 Retirement 18,210.30 13,041.50 0.00 5,168.80 28.38 10-160-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-160-502050 Life Insurance 170.00 108.73 0.00 61.27 36.04 10-160-502060 Long Term Disability 232.24 171.86 0.00 60.38 26.00 10-160-502070 Employee Assistance Prgm 55.50 40.93 0.00 14.57 26.25 E05 Personnel Services 219,414.86 138,069.48 0.00 81,345.38 37.07 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 2,098.49 0.00 1,901.51 47.54 10-160-512010 Printing 1,090.00 377.70 0.00 712.30 65.35 10-160-512020 Copies 1,000.00 133.83 0.00 866.17 86.62 10-160-513010 Office Supplies 1,600.00 1,554.02 0.00 45.98 2.87 E10 Materials & Supplies 7,690.00 4,164.04 0.00 3,525.96 45.85 10-160-520030 Dues And Publications 300.00 100.00 0.00 200.00 66.67 10-160-520050 Meeting And Conferences 500.00 359.48 0.00 140.52 28.10 10-160-520070 Training And Education 600.00 500.00 0.00 100.00 16.67 10-160-522020 Professional Services 21,869.52 10,473.48 1,702.50 9,693.54 44.32 10-160-525010 Care Of Prisoners 2,790.50 75.00 0.00 2,715.50 97.31 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 26,100.02 11,507.96 1,702.50 12,889.56 49.39 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 1,032.98 757.29 218.75 56.95 5.51 E25 Repairs & Maintenance 1,032.98 757.29 218.75 56.95 5.51 10-160-572020 Purchase Of Equipment 23,851.06 0.00 23,851.06 0.00 0.00 E70 Capital Purchases 23,851.06 0.00 23,851.06 0.00 0.00 160 Municipal Court Dept 278,088.92 154,498.77 25,772.31 97,817.85 35.18 170 Human Resources 10-170-501020 Salaries 182,896.20 125,901.83 0.00 56,994.37 31.16 10-170-501050 Parttime(wo Benefits)9,600.00 6,104.26 0.00 3,495.74 36.41 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-170-502010 Social Security 15,514.34 9,719.46 0.00 5,794.88 37.35 10-170-502020 Group Health Insurance 23,310.00 17,026.93 0.00 6,283.07 26.95 10-170-502030 Retirement 32,107.90 23,613.01 0.00 8,494.89 26.46 10-170-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-170-502050 Life Insurance 320.00 204.65 0.00 115.35 36.05 10-170-502060 Long Term Disability 444.30 293.76 0.00 150.54 33.88 10-170-502070 Employee Assistance Prgm 66.60 49.11 0.00 17.49 26.26 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 264,559.34 182,913.01 0.00 81,646.33 30.86 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 1,000.00 75.46 0.00 924.54 92.45 10-170-512010 Printing 2,000.00 1,576.47 0.00 423.53 21.18 10-170-512020 Copies 1,500.00 414.83 0.00 1,085.17 72.34 10-170-513010 Office Supplies 1,500.00 224.72 0.00 1,275.28 85.02 10-170-517010 Operational Supplies 1,350.00 46.32 0.00 1,303.68 96.57 E10 Materials & Supplies 7,500.00 2,337.80 0.00 5,162.20 68.83 10-170-520030 Dues And Publications 1,255.00 483.00 0.00 772.00 61.51 10-170-520050 Meeting And Conferences 942.00 365.08 0.00 576.92 61.24 10-170-520060 Wellness Program 3,919.00 1,476.81 0.00 2,442.19 62.32 10-170-520070 Training And Education 2,002.00 1,018.75 0.00 983.25 49.11 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 5,816.00 5,242.00 0.00 574.00 9.87 10-170-522020 Professional Services 10,648.50 1,980.46 0.00 8,668.04 81.40 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 24,582.50 10,566.10 0.00 14,016.40 57.02 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 437.50 218.76 218.75 -0.01 0.00 E25 Repairs & Maintenance 437.50 218.76 218.75 -0.01 0.00 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 297,079.34 196,035.67 218.75 100,824.93 33.94 180 Finance Department 10-180-501020 Salaries 606,766.81 423,756.63 0.00 183,010.18 30.16 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)8,600.00 2,762.98 0.00 5,837.02 67.87 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 48,011.64 32,259.26 0.00 15,752.38 32.81 10-180-502020 Group Health Insurance 84,704.73 46,110.08 0.00 38,594.65 45.56 10-180-502030 Retirement 106,596.32 71,654.05 0.00 34,942.27 32.78 10-180-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-180-502050 Life Insurance 1,078.90 635.01 0.00 443.89 41.14 10-180-502060 Long Term Disability 1,592.54 1,007.10 0.00 585.44 36.76 10-180-502070 Employee Assistance Prgm 286.89 229.26 0.00 57.63 20.09 E05 Personnel Services 857,637.83 578,414.37 0.00 279,223.46 32.56 10-180-511010 Advertising 2,000.00 327.93 0.00 1,672.07 83.60 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511020 Postage 13,500.00 7,144.71 0.00 6,355.29 47.08 10-180-511021 Postage Cost 2,000.00 6,801.96 0.00 -4,801.96 -240.10 10-180-512010 Printing 6,500.00 3,175.66 0.00 3,324.34 51.14 10-180-512020 Copies 7,000.00 2,355.55 0.00 4,644.45 66.35 10-180-512021 Copy Machine Cost 0.00 -1,006.64 1,312.47 -305.83 0.00 10-180-513010 Office Supplies 5,913.00 1,564.04 0.00 4,348.96 73.55 10-180-517010 Operational Supplies 3,827.60 1,273.61 0.00 2,553.99 66.73 E10 Materials & Supplies 40,740.60 21,636.82 1,312.47 17,791.31 43.67 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 640.52 0.00 1,759.48 73.31 10-180-520050 Meeting And Conferences 1,768.30 1,629.38 0.00 138.92 7.86 10-180-520070 Training And Education 1,426.00 450.00 0.00 976.00 68.44 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 25,342.40 25,342.40 0.00 0.00 0.00 10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 30,936.70 28,062.30 0.00 2,874.40 9.29 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 2,000.00 1,215.84 0.00 784.16 39.21 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 1,215.84 0.00 784.16 39.21 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 931,315.13 629,329.33 1,312.47 300,673.33 32.28 185 Non-Departmental 10-185-501020 Salaries 327,024.85 0.00 0.00 327,024.85 100.00 10-185-502020 Group Health Insurance 5,000.00 5,000.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 35,530.92 0.00 0.00 35,530.92 100.00 E05 Personnel Services 367,555.77 5,000.00 0.00 362,555.77 98.64 10-185-514011 Gas Oil & Antifreeze 935,000.00 571,707.27 65,395.22 297,897.51 31.86 E10 Materials & Supplies 935,000.00 571,707.27 65,395.22 297,897.51 31.86 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 8,000.00 0.00 0.00 8,000.00 100.00 10-185-521010 General Insurance 261,000.00 308,287.72 0.00 -47,287.72 -18.12 10-185-521020 Insurance Deductible 10,000.00 13,612.79 0.00 -3,612.79 -36.13 10-185-521030 Self Ins Prop & Casualty 70,000.00 43,125.12 0.00 26,874.88 38.39 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 235,000.00 226,666.64 12,500.00 -4,166.64 -1.77 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 38,500.00 22,704.69 0.00 15,795.31 41.03 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-527020 Economic Development 185,000.00 138,750.00 46,250.00 0.00 0.00 10-185-529010 Special Events 18,000.00 8,894.57 0.00 9,105.43 50.59 E15 Contractual Services 826,000.00 762,041.53 58,750.00 5,208.47 0.63 10-185-531010 Electricity 37,400.00 20,983.64 0.00 16,416.36 43.89 10-185-533010 Natural Gas 11,000.00 4,010.89 0.00 6,989.11 63.54 10-185-535010 Water 6,791.05 3,839.02 0.00 2,952.03 43.47 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,191.05 28,833.55 0.00 26,357.50 47.76 10-185-540010 Building & Grounds Maint.55,958.95 20,549.92 787.50 34,621.53 61.87 10-185-540020 Tree & Landscape Maint 25,000.00 23,625.00 0.00 1,375.00 5.50 10-185-547020 Maintenance Agreements 2,000.00 1,092.00 0.00 908.00 45.40 E25 Repairs & Maintenance 82,958.95 45,266.92 787.50 36,904.53 44.49 10-185-550010 Miscellaneous 17,246.44 2,422.44 0.00 14,824.00 85.95 10-185-550015 Bad Debt Expense 0.00 -270.00 0.00 270.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 5,000.00 5,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550039 Katy Trail Welcome Area 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 6,250.00 1,021.48 0.00 5,228.52 83.66 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 28,496.44 8,173.92 0.00 20,322.52 71.32 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 2,295,202.21 1,421,023.19 124,932.72 749,246.30 32.64 190 I.T. Department 10-190-501020 Salaries 519,071.25 362,506.54 0.00 156,564.71 30.16 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 39,713.63 26,867.42 0.00 12,846.21 32.35 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-502020 Group Health Insurance 65,444.47 39,016.82 0.00 26,427.65 40.38 10-190-502030 Retirement 90,885.78 61,508.57 0.00 29,377.21 32.32 10-190-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-190-502050 Life Insurance 890.25 583.63 0.00 306.62 34.44 10-190-502060 Long Term Disability 1,268.63 891.21 0.00 377.42 29.75 10-190-502070 Employee Assistance Prgm 206.63 155.54 0.00 51.09 24.73 E05 Personnel Services 717,480.64 491,529.73 0.00 225,950.91 31.49 10-190-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-190-511020 Postage 200.00 10.43 0.00 189.57 94.79 10-190-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-190-512020 Copies 400.00 31.70 0.00 368.30 92.08 10-190-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00 10-190-513010 Office Supplies 750.00 177.90 0.00 572.10 76.28 10-190-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-190-517010 Operational Supplies 1,750.00 1,733.91 0.00 16.09 0.92 E10 Materials & Supplies 3,950.00 1,953.94 0.00 1,996.06 50.53 10-190-520010 Mileage Expense 500.00 150.01 0.00 349.99 70.00 10-190-520030 Dues And Publications 500.00 200.00 0.00 300.00 60.00 10-190-520050 Meeting And Conferences 1,000.00 75.00 0.00 925.00 92.50 10-190-520070 Training And Education 3,500.00 2,448.07 0.00 1,051.93 30.06 10-190-520080 Tuition Reimbursement 3,000.00 615.00 0.00 2,385.00 79.50 10-190-522020 Professional Services 3,000.00 824.41 0.00 2,175.59 72.52 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 12,952.03 0.00 6,847.97 34.59 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 9.33 0.00 1,990.67 99.53 E15 Contractual Services 33,300.00 17,273.85 0.00 16,026.15 48.13 10-190-534010 Telephone 54,333.00 38,679.33 0.00 15,653.67 28.81 E20 Utilities 54,333.00 38,679.33 0.00 15,653.67 28.81 10-190-545010 Software Licensemaint 207,369.87 148,026.64 0.00 59,343.23 28.62 10-190-545020 Citywide Wiringnetwork 4,000.00 424.04 0.00 3,575.96 89.40 10-190-547010 Equipment Maintenance 4,000.00 2,524.33 0.00 1,475.67 36.89 10-190-547020 Maintenance Agreements 31,630.13 31,415.72 181.16 33.25 0.11 E25 Repairs & Maintenance 247,000.00 182,390.73 181.16 64,428.11 26.08 10-190-572020 Purchase Of Equipment 25,000.00 24,409.23 0.00 590.77 2.36 E70 Capital Purchases 25,000.00 24,409.23 0.00 590.77 2.36 190 I.T. Department 1,081,063.64 756,236.81 181.16 324,645.67 30.03 300 Police Department 10-300-501020 Salaries 4,010,765.89 2,802,625.02 0.00 1,208,140.87 30.12 10-300-501030 Holiday Pay 119,064.00 99,623.49 0.00 19,440.51 16.33 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 20,982.50 0.00 9,417.50 30.98 10-300-501060 Seasonal Salaries 9,847.50 9,847.50 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,800.00 3,768.00 0.00 3,032.00 44.59 10-300-501090 Overtime 232,919.01 156,354.75 0.00 76,564.26 32.87 10-300-501095 Overtime Straight Pay 12,309.49 8,917.98 0.00 3,391.51 27.55 10-300-502010 Social Security 343,918.63 225,255.10 0.00 118,663.53 34.50 10-300-502020 Group Health Insurance 720,145.46 436,539.11 0.00 283,606.35 39.38 10-300-502030 Retirement 864,464.58 615,223.76 0.00 249,240.82 28.83 10-300-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-300-502050 Life Insurance 6,745.31 4,433.41 0.00 2,311.90 34.27 10-300-502060 Long Term Disability 9,688.90 6,917.80 0.00 2,771.10 28.60 10-300-502070 Employee Assistance Prgm 1,900.66 1,498.10 0.00 402.56 21.18 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,371,569.43 4,391,986.52 0.00 1,979,582.91 31.07 10-300-511010 Advertising 3,000.00 1,568.62 0.00 1,431.38 47.71 10-300-511020 Postage 2,500.00 947.55 0.00 1,552.45 62.10 10-300-512010 Printing 4,996.00 951.69 0.00 4,044.31 80.95 10-300-512020 Copies 4.00 2.59 0.00 1.41 35.25 10-300-512030 Photographic Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-300-513010 Office Supplies 12,000.00 7,588.14 0.00 4,411.86 36.77 10-300-514010 Gas, Oil, Anti-Freeze 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 700.00 227.61 0.00 472.39 67.48 10-300-516010 Ammunition & Firearms Supplies 28,000.00 6,515.88 16,537.51 4,946.61 17.67 10-300-516020 Dare Program 16,000.00 3,374.67 0.00 12,625.33 78.91 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 2,270.00 2,270.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 30,000.00 11,319.51 6,659.44 12,021.05 40.07 E10 Materials & Supplies 102,970.00 37,266.26 23,196.95 42,506.79 41.28 10-300-520030 Dues And Publications 4,000.00 3,939.30 0.00 60.70 1.52 10-300-520050 Meeting And Conferences 2,000.00 1,490.58 0.00 509.42 25.47 10-300-520070 Training And Education 15,000.00 13,085.16 0.00 1,914.84 12.77 10-300-520080 Tuition Reimbursement 7,000.00 5,707.50 0.00 1,292.50 18.46 10-300-520090 Recruitment 2,500.00 12.00 0.00 2,488.00 99.52 10-300-521040 Medical Claimsservices 4,000.00 2,762.00 0.00 1,238.00 30.95 10-300-521050 Medical Services 1,000.00 739.25 0.00 260.75 26.08 10-300-522020 Professional Services 15,000.00 10,349.53 0.00 4,650.47 31.00 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 12,840.00 5,600.00 0.00 7,240.00 56.39 10-300-523030 Building Lease 1,160.00 860.00 300.00 0.00 0.00 10-300-524010 Trash Collections 600.00 0.00 0.00 600.00 100.00 10-300-525020 Sober Driver Program 12,000.00 3,153.54 0.00 8,846.46 73.72 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 1,717.73 0.00 482.27 21.92 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 79,300.00 49,416.59 300.00 29,583.41 37.31 10-300-531010 Electricity 49,500.00 40,540.12 0.00 8,959.88 18.10 10-300-533010 Natural Gas 19,800.00 10,290.21 0.00 9,509.79 48.03 10-300-534010 Telephone 7,900.00 3,289.06 0.00 4,610.94 58.37 10-300-535010 Water 4,200.00 2,635.59 0.00 1,564.41 37.25 E20 Utilities 81,400.00 56,754.98 0.00 24,645.02 30.28 10-300-540010 Building & Grounds Maint.51,000.00 31,925.72 11,524.05 7,550.23 14.80 10-300-541030 Vehicle Wash 11,000.00 7,271.50 0.00 3,728.50 33.90 10-300-544010 K-9 Operations 12,000.00 5,657.03 0.00 6,342.97 52.86 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 50,417.16 50,208.00 0.00 209.16 0.41 10-300-544030 Emerg Mgmt Operations 17,500.00 3,007.17 0.00 14,492.83 82.82 10-300-546010 Clothing Expense 35,732.00 13,885.24 -837.18 22,683.94 63.48 10-300-546020 Uniform Cleaning 26,000.00 16,370.95 0.00 9,629.05 37.03 10-300-547010 Equipment Maintenance 8,000.00 6,259.23 0.00 1,740.77 21.76 10-300-547020 Maintenance Agreements 51,000.00 21,262.88 1,744.37 27,992.75 54.89 10-300-547030 Radio Maintenance 10,000.00 7,149.97 0.00 2,850.03 28.50 E25 Repairs & Maintenance 272,649.16 162,997.69 12,431.24 97,220.23 35.66 10-300-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 153,772.97 131,397.59 600.82 21,774.56 14.16 10-300-572075 LLEBG Annual Grant Equipment 11,154.00 11,154.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 330,274.82 65,380.17 4,848.70 260,045.95 78.74 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 495,201.79 207,931.76 5,449.52 281,820.51 56.91 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 300 Police Department 7,403,090.38 4,906,353.80 41,377.71 2,455,358.87 33.17 310 School Resource Officer 10-310-501020 Salaries 242,821.20 154,768.96 0.00 88,052.24 36.26 10-310-501030 Holiday Pay 9,343.20 2,879.84 0.00 6,463.36 69.18 10-310-501090 Overtime 6,300.84 6,702.93 0.00 -402.09 -6.38 10-310-501095 Overtime Straight Pay 825.16 780.19 0.00 44.97 5.45 10-310-502010 Social Security 20,668.24 11,753.35 0.00 8,914.89 43.13 10-310-502020 Group Health Insurance 41,485.50 23,729.02 0.00 17,756.48 42.80 10-310-502030 Retirement 51,873.60 28,558.56 0.00 23,315.04 44.95 10-310-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-310-502050 Life Insurance 450.00 202.23 0.00 247.77 55.06 10-310-502060 Long Term Disability 605.93 318.29 0.00 287.64 47.47 10-310-502070 Employee Assistance Prgm 111.00 81.87 0.00 29.13 26.24 E05 Personnel Services 374,484.67 229,775.24 0.00 144,709.43 38.64 10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 374,484.67 229,775.24 0.00 144,709.43 38.64 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 76,802.00 49,090.74 0.00 27,711.26 36.08 10-320-501030 Holiday Pay 3,335.40 1,383.96 0.00 1,951.44 58.51 10-320-501090 Overtime 6,897.00 6,223.27 0.00 673.73 9.77 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 8,315.20 4,118.98 0.00 4,196.22 50.46 10-320-502020 Group Health Insurance 14,532.00 7,874.00 0.00 6,658.00 45.82 10-320-502030 Retirement 20,614.10 11,871.08 0.00 8,743.02 42.41 10-320-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-320-502050 Life Insurance 150.00 80.32 0.00 69.68 46.45 10-320-502060 Long Term Disability 212.12 128.40 0.00 83.72 39.47 10-320-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26 E05 Personnel Services 130,902.22 80,803.49 0.00 50,098.73 38.27 10-320-514010 Gas Oil Anti-freeze 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-516040 Investigations (grant)20,000.00 14,674.94 0.00 5,325.06 26.63 10-320-517010 Operational Supplies 1,000.00 438.61 0.00 561.39 56.14 E10 Materials & Supplies 21,000.00 15,113.55 0.00 5,886.45 28.03 10-320-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 1,500.00 0.00 0.00 1,500.00 100.00 10-320-522020 Professional Services 15,000.00 15,000.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 16,456.41 16,456.41 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 32,956.41 31,456.41 0.00 1,500.00 4.55 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.184,858.63 127,373.45 0.00 57,485.18 31.10 330 Animal Control 10-330-501020 Salaries 298,908.92 209,735.82 0.00 89,173.10 29.83 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 2,765.00 2,765.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 3,000.00 2,908.00 0.00 92.00 3.07 10-330-501090 Overtime 1,709.00 1,210.07 0.00 498.93 29.19 10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44 10-330-502010 Social Security 23,963.21 15,068.27 0.00 8,894.94 37.12 10-330-502020 Group Health Insurance 65,287.85 40,582.95 0.00 24,704.90 37.84 10-330-502030 Retirement 54,182.34 36,517.28 0.00 17,665.06 32.60 10-330-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-330-502050 Life Insurance 522.79 333.31 0.00 189.48 36.24 10-330-502060 Long Term Disability 746.84 525.30 0.00 221.54 29.66 10-330-502070 Employee Assistance Prgm 170.77 130.98 0.00 39.79 23.30 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 451,756.72 309,804.80 0.00 141,951.92 31.42 10-330-511010 Advertising 2,000.00 45.73 0.00 1,954.27 97.71 10-330-511020 Postage 900.00 98.87 0.00 801.13 89.01 10-330-512010 Printing 1,700.00 1,430.50 0.00 269.50 15.85 10-330-512020 Copies 20.00 0.04 0.00 19.96 99.80 10-330-513010 Office Supplies 800.00 796.04 0.00 3.96 0.50 10-330-514030 Small Tools 250.00 27.97 0.00 222.03 88.81 10-330-515040 First Aid Supplies 150.00 0.00 0.00 150.00 100.00 10-330-517010 Operational Supplies 10,500.00 6,269.86 0.00 4,230.14 40.29 E10 Materials & Supplies 16,320.00 8,669.01 0.00 7,650.99 46.88 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-520030 Dues And Publications 900.00 847.94 0.00 52.06 5.78 10-330-520050 Meeting And Conferences 1,000.00 0.00 0.00 1,000.00 100.00 10-330-520070 Training And Education 650.00 459.58 0.00 190.42 29.30 10-330-521040 Medical Claimsservices 829.00 829.00 0.00 0.00 0.00 10-330-522020 Professional Services 9,171.00 4,528.59 0.00 4,642.41 50.62 10-330-524010 Trash Collections 1,500.00 0.00 0.00 1,500.00 100.00 10-330-529050 Spay & Neuter Program 10,000.00 7,045.09 0.00 2,954.91 29.55 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 3,460.00 3,480.00 0.00 -20.00 -0.58 10-330-529067 Animal Shelter Bricks 1,433.00 1,433.00 0.00 0.00 0.00 E15 Contractual Services 28,943.00 18,623.20 0.00 10,319.80 35.66 10-330-531010 Electricity 20,768.36 12,425.35 0.00 8,343.01 40.17 10-330-533010 Natural Gas 20,098.36 11,247.02 0.00 8,851.34 44.04 10-330-534010 Telephone 572.00 203.91 0.00 368.09 64.35 10-330-535010 Water 5,500.00 1,522.15 0.00 3,977.85 72.32 E20 Utilities 46,938.72 25,398.43 0.00 21,540.29 45.89 10-330-540010 Building & Grounds Maint.12,000.00 5,472.34 225.00 6,302.66 52.52 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 365.00 0.00 175.00 32.41 10-330-544040 Care Of Animals 42,000.00 19,453.20 0.00 22,546.80 53.68 10-330-546010 Clothing Expense 3,000.00 438.30 0.00 2,561.70 85.39 10-330-546020 Uniform Cleaning 200.00 0.00 0.00 200.00 100.00 10-330-547010 Equipment Maintenance 1,300.00 475.36 0.00 824.64 63.43 10-330-547020 Maintenance Agreements 800.00 0.00 0.00 800.00 100.00 10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00 E25 Repairs & Maintenance 60,540.00 26,204.20 225.00 34,110.80 56.34 10-330-572020 Purchase Of Equipment 2,094.00 2,094.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 2,094.00 2,094.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 61,689.28 61,689.28 0.00 0.00 0.00 E75 Capital Projects 61,689.28 61,689.28 0.00 0.00 0.00 330 Animal Control 668,281.72 452,482.92 225.00 215,573.80 32.26 390 9-1-1 Police 10-390-501020 Salaries 816,560.64 571,261.72 0.00 245,298.92 30.04 10-390-501030 Holiday Pay 29,988.00 24,166.39 0.00 5,821.61 19.41 10-390-501050 Parttime(wo Benefits)210.00 150.00 0.00 60.00 28.57 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 10,169.64 0.00 5,644.36 35.69 10-390-501095 Overtime Straight Pay 500.00 36.04 0.00 463.96 92.79 10-390-502010 Social Security 67,111.40 43,831.70 0.00 23,279.70 34.69 10-390-502020 Group Health Insurance 163,307.38 97,902.82 0.00 65,404.56 40.05 10-390-502030 Retirement 155,143.26 103,250.70 0.00 51,892.56 33.45 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,442.94 903.25 0.00 539.69 37.40 10-390-502060 Long Term Disability 2,021.54 1,411.71 0.00 609.83 30.17 10-390-502070 Employee Assistance Prgm 463.64 343.83 0.00 119.81 25.84 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,252,562.80 853,427.80 0.00 399,135.00 31.87 10-390-511010 Advertising 2,200.00 0.00 0.00 2,200.00 100.00 10-390-512010 Printing 300.00 0.00 0.00 300.00 100.00 10-390-517010 Operational Supplies 5,000.00 2,665.00 0.00 2,335.00 46.70 E10 Materials & Supplies 7,500.00 2,665.00 0.00 4,835.00 64.47 10-390-520030 Dues And Publications 900.00 510.00 0.00 390.00 43.33 10-390-520050 Meeting And Conferences 1,764.69 1,764.69 0.00 0.00 0.00 10-390-520070 Training And Education 1,735.31 1,521.99 0.00 213.32 12.29 10-390-522020 Professional Services 2,000.00 923.00 0.00 1,077.00 53.85 10-390-523010 Equipment Rentlease 100,000.00 73,087.03 1,620.00 25,292.97 25.29 E15 Contractual Services 106,400.00 77,806.71 1,620.00 26,973.29 25.35 10-390-534010 Telephone 159.00 0.00 0.00 159.00 100.00 E20 Utilities 159.00 0.00 0.00 159.00 100.00 10-390-546010 Clothing Expense 3,400.00 788.86 0.00 2,611.14 76.80 10-390-546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00 10-390-547010 Equipment Maintenance 2,272.45 2,272.45 0.00 0.00 0.00 10-390-547020 Maintenance Agreements 24,392.52 19,314.39 5,078.13 0.00 0.00 10-390-547030 Radio Maintenance 2,675.03 1,483.24 0.00 1,191.79 44.55 E25 Repairs & Maintenance 34,740.00 23,858.94 5,078.13 5,802.93 16.70 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,401,361.80 957,758.45 6,698.13 436,905.22 31.18 400 Fire Department 10-400-501020 Salaries 3,644,108.20 2,510,171.45 0.00 1,133,936.75 31.12 10-400-501030 Holiday Pay 282,478.80 248,350.24 0.00 34,128.56 12.08 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 19,704.52 0.00 8,295.48 29.63 10-400-501090 Overtime 30,000.00 27,468.61 0.00 2,531.39 8.44 10-400-501095 Overtime Straight Pay 32,000.00 16,325.95 0.00 15,674.05 48.98 10-400-502010 Social Security 59,092.54 36,220.72 0.00 22,871.82 38.71 10-400-502020 Group Health Insurance 581,939.20 378,014.74 0.00 203,924.46 35.04 10-400-502030 Retirement 1,663,127.92 1,156,007.50 0.00 507,120.42 30.49 10-400-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-400-502050 Life Insurance 6,409.99 3,963.39 0.00 2,446.60 38.17 10-400-502060 Long Term Disability 8,975.29 6,209.07 0.00 2,766.22 30.82 10-400-502070 Employee Assistance Prgm 1,673.54 1,244.33 0.00 429.21 25.65 10-400-503010 Awards Program 2,245.00 2,242.59 0.00 2.41 0.11 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 6,340,050.48 4,405,923.11 0.00 1,934,127.37 30.51 10-400-511010 Advertising 350.00 75.00 0.00 275.00 78.57 10-400-511020 Postage 640.00 74.84 0.00 565.16 88.31 10-400-512010 Printing 1,250.00 750.83 0.00 499.17 39.93 10-400-512020 Copies 200.00 0.42 0.00 199.58 99.79 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 1,156.36 0.00 643.64 35.76 10-400-514020 Chemicals 2,000.00 966.34 0.00 1,033.66 51.68 10-400-514030 Small Tools 2,500.00 1,557.83 0.00 942.17 37.69 10-400-514040 Food 20.00 0.00 0.00 20.00 100.00 10-400-515040 First Aid Supplies 400.00 53.66 0.00 346.34 86.59 10-400-517010 Operational Supplies 7,500.00 5,697.96 0.00 1,802.04 24.03 E10 Materials & Supplies 16,660.00 10,333.24 0.00 6,326.76 37.98 10-400-520030 Dues And Publications 1,300.00 1,292.73 0.00 7.27 0.56 10-400-520050 Meeting And Conferences 60.00 32.18 0.00 27.82 46.37 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 9,120.00 8,430.35 0.00 689.65 7.56 10-400-520080 Tuition Reimbursement 600.00 0.00 0.00 600.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 3,980.00 2,184.00 0.00 1,796.00 45.13 10-400-522020 Professional Services 900.00 0.00 0.00 900.00 100.00 10-400-523010 Equipment Rentlease 5,000.00 0.00 0.00 5,000.00 100.00 10-400-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-400-529010 Special Events 8,055.00 1,223.11 0.00 6,831.89 84.82 10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 29,515.00 13,162.37 0.00 16,352.63 55.40 10-400-531010 Electricity 39,500.00 28,819.35 0.00 10,680.65 27.04 10-400-533010 Natural Gas 1,500.00 0.00 0.00 1,500.00 100.00 10-400-534010 Telephone 15,000.00 12,653.99 0.00 2,346.01 15.64 10-400-535010 Water 8,720.00 6,532.80 0.00 2,187.20 25.08 E20 Utilities 64,720.00 48,006.14 0.00 16,713.86 25.82 10-400-540010 Building & Grounds Maint.43,326.00 24,915.21 1,500.00 16,910.79 39.03 10-400-541030 Vehicle Wash 1,608.00 1,072.00 0.00 536.00 33.33 10-400-546010 Clothing Expense 35,000.00 15,256.19 -884.19 20,628.00 58.94 10-400-546020 Uniform Cleaning 1,066.00 1,065.01 0.00 0.99 0.09 10-400-547010 Equipment Maintenance 18,000.00 5,741.90 0.00 12,258.10 68.10 10-400-547020 Maintenance Agreements 15,900.00 4,923.27 8,275.48 2,701.25 16.99 10-400-547030 Radio Maintenance 7,000.00 1,590.61 0.00 5,409.39 77.28 E25 Repairs & Maintenance 121,900.00 54,564.19 8,891.29 58,444.52 47.94 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 815,000.00 702,062.10 107,088.54 5,849.36 0.72 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 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 815,000.00 702,062.10 107,088.54 5,849.36 0.72 400 Fire Department 7,387,845.48 5,234,051.15 115,979.83 2,037,814.50 27.58 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 -229.50 0.00 229.50 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 -229.50 0.00 229.50 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 -229.50 0.00 229.50 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 202,276.20 139,973.29 0.00 62,302.91 30.80 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 15,473.42 10,341.70 0.00 5,131.72 33.16 10-520-502020 Group Health Insurance 28,707.00 19,295.47 0.00 9,411.53 32.78 10-520-502030 Retirement 35,451.00 26,252.35 0.00 9,198.65 25.95 10-520-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-520-502050 Life Insurance 360.00 229.30 0.00 130.70 36.31 10-520-502060 Long Term Disability 494.76 334.28 0.00 160.48 32.44 10-520-502070 Employee Assistance Prgm 88.80 65.50 0.00 23.30 26.24 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 282,851.18 196,491.89 0.00 86,359.29 30.53 10-520-511010 Advertising 500.00 470.55 0.00 29.45 5.89 10-520-511020 Postage 150.00 135.39 0.00 14.61 9.74 10-520-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 500.00 262.44 0.00 237.56 47.51 10-520-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-520-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-520-517010 Operational Supplies 150.00 18.00 0.00 132.00 88.00 E10 Materials & Supplies 1,400.00 886.38 0.00 513.62 36.69 10-520-520030 Dues And Publications 400.00 191.85 0.00 208.15 52.04 10-520-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 99.00 99.00 0.00 0.00 0.00 10-520-522020 Professional Services 600.00 95.65 0.00 504.35 84.06 E15 Contractual Services 1,099.00 386.50 0.00 712.50 64.83 10-520-534010 Telephone 74.19 0.00 0.00 74.19 100.00 E20 Utilities 74.19 0.00 0.00 74.19 100.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 770.81 694.83 66.64 9.34 1.21 E25 Repairs & Maintenance 770.81 694.83 66.64 9.34 1.21 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 286,195.18 198,459.60 66.64 87,668.94 30.63 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,387.60 35,325.66 0.00 16,061.94 31.26 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 7,968.00 0.00 4,512.00 36.15 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 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 5,657.08 3,311.98 0.00 2,345.10 41.45 10-521-502020 Group Health Insurance 5,638.50 3,537.35 0.00 2,101.15 37.26 10-521-502030 Retirement 9,009.20 6,625.20 0.00 2,384.00 26.46 10-521-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-521-502050 Life Insurance 90.00 57.66 0.00 32.34 35.93 10-521-502060 Long Term Disability 121.21 91.12 0.00 30.09 24.82 10-521-502070 Employee Assistance Prgm 22.20 16.37 0.00 5.83 26.26 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 84,405.79 56,933.34 0.00 27,472.45 32.55 10-521-511010 Advertising 5,300.00 2,052.25 0.00 3,247.75 61.28 10-521-511020 Postage 2,000.00 950.10 0.00 1,049.90 52.50 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 100.00 2.32 0.00 97.68 97.68 10-521-512030 Photographic Supplies 30.00 0.00 0.00 30.00 100.00 10-521-513010 Office Supplies 1,265.00 504.02 0.00 760.98 60.16 10-521-514040 Food 0.00 0.00 0.00 0.00 0.00 10-521-515040 First Aid Supplies 10.00 0.00 0.00 10.00 100.00 10-521-517010 Operational Supplies 2,000.00 1,967.10 0.00 32.90 1.65 E10 Materials & Supplies 10,705.00 5,475.79 0.00 5,229.21 48.85 10-521-520030 Dues And Publications 15,100.00 15,083.70 0.00 16.30 0.11 10-521-520050 Meeting And Conferences 322.00 0.00 0.00 322.00 100.00 10-521-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 78.00 78.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 15,500.00 15,161.70 0.00 338.30 2.18 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,710.00 1,278.39 388.69 42.92 2.51 E25 Repairs & Maintenance 1,710.00 1,278.39 388.69 42.92 2.51 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 112,320.79 78,849.22 388.69 33,082.88 29.45 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 126,439.20 91,367.88 0.00 35,071.32 27.74 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,669.66 6,490.48 0.00 3,179.18 32.88 10-522-502020 Group Health Insurance 17,556.00 10,711.19 0.00 6,844.81 38.99 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-502030 Retirement 22,159.40 15,152.43 0.00 7,006.97 31.62 10-522-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-522-502050 Life Insurance 220.00 131.34 0.00 88.66 40.30 10-522-502060 Long Term Disability 312.98 205.37 0.00 107.61 34.38 10-522-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26 E05 Personnel Services 176,401.64 124,091.43 0.00 52,310.21 29.65 10-522-511010 Advertising 1,000.00 739.35 0.00 260.65 26.07 10-522-511020 Postage 700.00 108.46 0.00 591.54 84.51 10-522-512010 Printing 1,200.00 0.00 0.00 1,200.00 100.00 10-522-512020 Copies 500.00 0.00 0.00 500.00 100.00 10-522-513010 Office Supplies 500.00 111.54 0.00 388.46 77.69 10-522-514040 Food 300.00 144.53 0.00 155.47 51.82 10-522-517010 Operational Supplies 800.00 0.00 0.00 800.00 100.00 E10 Materials & Supplies 5,000.00 1,103.88 0.00 3,896.12 77.92 10-522-520030 Dues And Publications 800.00 615.49 0.00 184.51 23.06 10-522-520050 Meeting And Conferences 2,188.00 0.00 0.00 2,188.00 100.00 10-522-520070 Training And Education 1,374.42 0.00 0.00 1,374.42 100.00 10-522-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,362.42 615.49 0.00 3,746.93 85.89 10-522-534010 Telephone 100.00 0.00 0.00 100.00 100.00 E20 Utilities 100.00 0.00 0.00 100.00 100.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 2,925.58 566.48 163.52 2,195.58 75.05 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,925.58 566.48 163.52 2,195.58 75.05 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 188,789.64 126,377.28 163.52 62,248.84 32.97 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 112,433.52 50,344.93 0.00 62,088.59 55.22 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 8,596.77 3,622.34 0.00 4,974.43 57.86 10-530-502020 Group Health Insurance 9,658.85 4,636.07 0.00 5,022.78 52.00 10-530-502030 Retirement 19,432.96 5,141.11 0.00 14,291.85 73.54 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 157.32 72.74 0.00 84.58 53.76 10-530-502060 Long Term Disability 281.51 112.95 0.00 168.56 59.88 10-530-502070 Employee Assistance Prgm 37.57 32.74 0.00 4.83 12.86 E05 Personnel Services 150,598.50 63,962.88 0.00 86,635.62 57.53 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-530-511020 Postage 20.00 16.79 0.00 3.21 16.05 10-530-513010 Office Supplies 80.00 47.70 0.00 32.30 40.38 E10 Materials & Supplies 100.00 64.49 0.00 35.51 35.51 10-530-520030 Dues And Publications 324.00 324.00 0.00 0.00 0.00 10-530-520050 Meeting And Conferences 350.00 269.00 0.00 81.00 23.14 10-530-520070 Training And Education 446.00 211.00 0.00 235.00 52.69 E15 Contractual Services 1,120.00 804.00 0.00 316.00 28.21 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 723.00 357.66 90.86 274.48 37.96 E25 Repairs & Maintenance 723.00 357.66 90.86 274.48 37.96 10-530-550020 Neighborhood Reinvestment 28,532.00 23,834.20 0.00 4,697.80 16.47 10-530-550030 Old Town Projects 57,468.00 26,264.10 0.00 31,203.90 54.30 10-530-550035 Old Town Redev Committee 10,000.00 6,344.30 0.00 3,655.70 36.56 10-530-550037 Historic Preservation Comm 15,650.00 6,585.00 6,400.00 2,665.00 17.03 10-530-550050 Neighb Stablization Prog 101,406.88 0.00 0.00 101,406.88 100.00 10-530-550060 MSP 1,304,060.97 119,638.83 0.00 1,184,422.14 90.83 10-530-550090 Hazard Mitigation 146,834.23 54,118.42 0.00 92,715.81 63.14 E30 Other Operating Expenses 1,663,952.08 236,784.85 6,400.00 1,420,767.23 85.39 530 Plan & Protect Svc-RedevGrant 1,816,493.58 301,973.88 6,490.86 1,508,028.84 83.02 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 429,746.40 268,221.89 0.00 161,524.51 37.59 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 34,574.62 19,440.38 0.00 15,134.24 43.77 10-531-502020 Group Health Insurance 54,747.00 37,276.30 0.00 17,470.70 31.91 10-531-502030 Retirement 75,477.30 48,180.89 0.00 27,296.41 36.17 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 740.00 400.88 0.00 339.12 45.83 10-531-502060 Long Term Disability 1,050.11 660.97 0.00 389.14 37.06 10-531-502070 Employee Assistance Prgm 177.60 130.98 0.00 46.62 26.25 E05 Personnel Services 618,703.03 374,312.29 0.00 244,390.74 39.50 10-531-511010 Advertising 200.00 45.50 0.00 154.50 77.25 10-531-511020 Postage 1,800.00 1,471.88 0.00 328.12 18.23 10-531-512010 Printing 700.00 0.00 0.00 700.00 100.00 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 100.00 0.00 0.00 100.00 100.00 10-531-513010 Office Supplies 1,829.00 1,480.46 0.00 348.54 19.06 10-531-514030 Small Tools 300.00 0.00 0.00 300.00 100.00 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-531-517010 Operational Supplies 1,589.42 1,498.71 0.00 90.71 5.71 E10 Materials & Supplies 6,558.42 4,496.55 0.00 2,061.87 31.44 10-531-520030 Dues And Publications 2,000.00 633.00 0.00 1,367.00 68.35 10-531-520050 Meeting And Conferences 719.96 108.00 0.00 611.96 85.00 10-531-520070 Training And Education 2,500.00 1,416.99 0.00 1,083.01 43.32 10-531-522020 Professional Services 25,000.00 19,780.50 0.00 5,219.50 20.88 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 30,219.96 21,938.49 0.00 8,281.47 27.40 10-531-534010 Telephone 137.98 0.00 0.00 137.98 100.00 E20 Utilities 137.98 0.00 0.00 137.98 100.00 10-531-541030 Vehicle Wash 540.00 375.00 0.00 165.00 30.56 10-531-546010 Clothing Expense 1,130.00 778.81 0.00 351.19 31.08 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,982.64 1,128.92 725.16 128.56 6.48 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,712.64 2,282.73 725.16 704.75 18.98 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 659,332.03 403,030.06 725.16 255,576.81 38.76 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 114,362.40 88,903.37 0.00 25,459.03 22.26 10-532-501060 Seasonal Salaries 3,957.00 1,798.00 0.00 2,159.00 54.56 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00 10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00 10-532-502010 Social Security 10,381.54 6,679.91 0.00 3,701.63 35.66 10-532-502020 Group Health Insurance 17,356.50 12,694.55 0.00 4,661.95 26.86 10-532-502030 Retirement 20,099.00 16,674.46 0.00 3,424.54 17.04 10-532-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-532-502050 Life Insurance 200.00 145.26 0.00 54.74 27.37 10-532-502060 Long Term Disability 282.69 228.31 0.00 54.38 19.24 10-532-502070 Employee Assistance Prgm 44.40 32.74 0.00 11.66 26.26 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 166,963.53 127,156.60 0.00 39,806.93 23.84 10-532-511010 Advertising 800.00 84.50 0.00 715.50 89.44 10-532-511020 Postage 500.00 108.36 0.00 391.64 78.33 10-532-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-532-512020 Copies 20.00 0.35 0.00 19.65 98.25 10-532-512030 Photographic Supplies 20.00 0.00 0.00 20.00 100.00 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-513010 Office Supplies 1,800.00 522.93 0.00 1,277.07 70.95 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,800.00 344.71 0.00 1,455.29 80.85 E10 Materials & Supplies 5,020.00 1,060.85 0.00 3,959.15 78.87 10-532-520030 Dues And Publications 880.00 565.90 0.00 314.10 35.69 10-532-520050 Meeting And Conferences 400.00 255.00 0.00 145.00 36.25 10-532-520070 Training And Education 400.00 99.00 0.00 301.00 75.25 10-532-521040 Medical Claimsservices 100.00 0.00 0.00 100.00 100.00 10-532-522020 Professional Services 4,224.90 0.00 3,200.00 1,024.90 24.26 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00 10-532-524025 Glass Recycling 6,247.82 3,830.30 2,420.00 -2.48 -0.04 10-532-524026 Household Hazardous Waste 16,000.00 6,902.96 0.00 9,097.04 56.86 10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 7,752.18 5,650.25 0.00 2,101.93 27.11 10-532-524030 Compost Services 212,000.00 141,333.36 70,666.68 -0.04 0.00 10-532-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 249,004.90 158,636.77 76,286.68 14,081.45 5.66 10-532-534010 Telephone 1,320.00 0.00 0.00 1,320.00 100.00 E20 Utilities 1,320.00 0.00 0.00 1,320.00 100.00 10-532-540060 Cemetery Maintenance 22,956.42 15,245.84 7,640.00 70.58 0.31 10-532-541030 Vehicle Wash 1,290.00 856.00 0.00 434.00 33.64 10-532-546010 Clothing Expense 520.00 160.00 0.00 360.00 69.23 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,018.68 655.23 263.26 100.19 9.84 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 25,865.10 16,917.07 7,903.26 1,044.77 4.04 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 448,173.53 303,771.29 84,189.94 60,212.30 13.44 535 Public Works-Central Maintenan 10-535-501020 Salaries 343,750.20 229,852.71 0.00 113,897.49 33.13 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 4,782.21 0.00 2,617.79 35.38 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 1,800.00 1,603.31 0.00 196.69 10.93 10-535-501095 Overtime Straight Pay 200.00 63.14 0.00 136.86 68.43 10-535-502010 Social Security 27,395.62 16,929.87 0.00 10,465.75 38.20 10-535-502020 Group Health Insurance 70,056.00 50,873.62 0.00 19,182.38 27.38 10-535-502030 Retirement 61,498.90 43,419.00 0.00 18,079.90 29.40 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-535-502050 Life Insurance 600.00 370.42 0.00 229.58 38.26 10-535-502060 Long Term Disability 848.09 582.12 0.00 265.97 31.36 10-535-502070 Employee Assistance Prgm 177.60 130.98 0.00 46.62 26.25 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 513,726.41 348,607.38 0.00 165,119.03 32.14 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 300.00 12.12 0.00 287.88 95.96 10-535-512020 Copies 0.70 0.70 0.00 0.00 0.00 10-535-513010 Office Supplies 1,899.30 977.15 0.00 922.15 48.55 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 9,000.00 5,139.20 0.00 3,860.80 42.90 10-535-517010 Operational Supplies 9,100.00 8,303.50 0.00 796.50 8.75 E10 Materials & Supplies 20,380.00 14,432.67 0.00 5,947.33 29.18 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 Meeting And Conferences 400.00 24.00 0.00 376.00 94.00 10-535-520070 Training And Education 1,000.00 144.00 0.00 856.00 85.60 10-535-521040 Medical Claimsservices 430.00 0.00 0.00 430.00 100.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 1,830.00 168.00 0.00 1,662.00 90.82 10-535-531010 Electricity 6,050.00 4,653.03 0.00 1,396.97 23.09 10-535-533010 Natural Gas 6,950.00 6,520.17 0.00 429.83 6.18 10-535-534010 Telephone 320.00 0.00 0.00 320.00 100.00 10-535-535010 Water 715.00 908.93 0.00 -193.93 -27.12 E20 Utilities 14,035.00 12,082.13 0.00 1,952.87 13.91 10-535-540010 Building & Grounds Maint.9,000.00 5,340.81 75.00 3,584.19 39.82 10-535-541010 Veh & Equip Parts Etc 405,000.00 200,467.79 0.00 204,532.21 50.50 10-535-546010 Clothing Expense 7,000.00 5,457.27 0.00 1,542.73 22.04 10-535-547010 Equipment Maintenance 3,000.00 2,665.09 0.00 334.91 11.16 10-535-547020 Maintenance Agreements 4,000.00 1,168.10 0.00 2,831.90 70.80 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 428,500.00 215,099.06 75.00 213,325.94 49.78 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 978,471.41 590,389.24 75.00 388,007.17 39.65 540 Public Works-Admin 10-540-501020 Salaries 189,536.40 131,077.01 0.00 58,459.39 30.84 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 16,164.30 9,510.01 0.00 6,654.29 41.17 10-540-502020 Group Health Insurance 23,278.50 15,657.73 0.00 7,620.77 32.74 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-502030 Retirement 37,228.60 24,340.12 0.00 12,888.48 34.62 10-540-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-540-502050 Life Insurance 410.00 206.37 0.00 203.63 49.67 10-540-502060 Long Term Disability 524.46 280.62 0.00 243.84 46.49 10-540-502070 Employee Assistance Prgm 66.60 49.11 0.00 17.49 26.26 E05 Personnel Services 267,208.86 181,120.97 0.00 86,087.89 32.22 10-540-511010 Advertising 400.00 0.00 0.00 400.00 100.00 10-540-511020 Postage 230.00 11.48 0.00 218.52 95.01 10-540-512010 Printing 1,230.00 201.00 0.00 1,029.00 83.66 10-540-512020 Copies 100.00 0.18 0.00 99.82 99.82 10-540-513010 Office Supplies 1,100.00 206.17 0.00 893.83 81.26 10-540-514040 Food 650.00 632.49 0.00 17.51 2.69 10-540-517010 Operational Supplies 1,400.00 4.99 0.00 1,395.01 99.64 E10 Materials & Supplies 5,110.00 1,056.31 0.00 4,053.69 79.33 10-540-520030 Dues And Publications 1,300.00 500.50 0.00 799.50 61.50 10-540-520050 Meeting And Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,400.00 503.00 0.00 1,897.00 79.04 10-540-522020 Professional Services 900.00 163.15 0.00 736.85 81.87 10-540-527010 Comm Serv Projects 1,000.00 85.35 0.00 914.65 91.47 E15 Contractual Services 5,600.00 1,252.00 0.00 4,348.00 77.64 10-540-534010 Telephone 924.00 0.00 0.00 924.00 100.00 E20 Utilities 924.00 0.00 0.00 924.00 100.00 10-540-547020 Maintenance Agreements 930.00 597.16 263.26 69.58 7.48 E25 Repairs & Maintenance 930.00 597.16 263.26 69.58 7.48 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works-Admin 279,772.86 184,026.44 263.26 95,483.16 34.13 541 Public Works-Engineering 10-541-501020 Salaries 742,215.90 524,966.51 0.00 217,249.39 29.27 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 2,000.00 993.75 0.00 1,006.25 50.31 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 500.00 0.00 0.00 500.00 100.00 10-541-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-541-502010 Social Security 57,855.03 38,440.48 0.00 19,414.55 33.56 10-541-502020 Group Health Insurance 102,005.55 66,795.83 0.00 35,209.72 34.52 10-541-502030 Retirement 129,184.51 98,470.94 0.00 30,713.57 23.77 10-541-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-541-502050 Life Insurance 1,299.69 852.68 0.00 447.01 34.39 10-541-502060 Long Term Disability 1,819.00 1,306.05 0.00 512.95 28.20 10-541-502070 Employee Assistance Prgm 275.79 229.22 0.00 46.57 16.89 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,037,655.47 732,055.46 0.00 305,600.01 29.45 10-541-511010 Advertising 1,400.00 630.00 0.00 770.00 55.00 10-541-511020 Postage 1,500.00 357.18 0.00 1,142.82 76.19 10-541-512010 Printing 100.00 31.00 0.00 69.00 69.00 10-541-512020 Copies 199.65 110.08 0.00 89.57 44.86 10-541-512030 Photographic Supplies 175.35 0.00 0.00 175.35 100.00 10-541-513010 Office Supplies 7,900.00 2,802.77 0.00 5,097.23 64.52 10-541-514030 Small Tools 500.00 469.15 0.00 30.85 6.17 10-541-514040 Food 150.00 72.52 0.00 77.48 51.65 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 346.40 0.00 1,653.60 82.68 10-541-515080 Surveying Supplies 2,000.00 704.62 0.00 1,295.38 64.77 10-541-517010 Operational Supplies 1,150.00 339.75 0.00 810.25 70.46 E10 Materials & Supplies 17,125.00 5,863.47 0.00 11,261.53 65.76 10-541-520030 Dues And Publications 4,000.00 3,279.77 0.00 720.23 18.01 10-541-520050 Meeting And Conferences 1,000.00 240.00 0.00 760.00 76.00 10-541-520070 Training And Education 2,500.00 314.00 0.00 2,186.00 87.44 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 196.00 0.00 3,804.00 95.10 E15 Contractual Services 11,500.00 4,029.77 0.00 7,470.23 64.96 10-541-534010 Telephone 1,650.00 300.12 0.00 1,349.88 81.81 E20 Utilities 1,650.00 300.12 0.00 1,349.88 81.81 10-541-541020 Veh Maintenance 560.00 0.00 0.00 560.00 100.00 10-541-541030 Vehicle Wash 720.00 640.00 0.00 80.00 11.11 10-541-546010 Clothing Expense 1,000.00 355.67 0.00 644.33 64.43 10-541-547010 Equipment Maintenance 1,480.00 588.45 0.00 891.55 60.24 10-541-547020 Maintenance Agreements 17,000.00 7,999.72 547.90 8,452.38 49.72 10-541-547030 Radio Maintenance 200.00 0.00 0.00 200.00 100.00 E25 Repairs & Maintenance 20,960.00 9,583.84 547.90 10,828.26 51.66 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 1,088,890.47 751,832.66 547.90 336,509.91 30.90 542 Public Works-Street 10-542-501020 Salaries 1,117,853.58 738,051.67 0.00 379,801.91 33.98 10-542-501060 Seasonal Salaries 9,964.69 8,122.08 0.00 1,842.61 18.49 10-542-501070 Stand-by Plan 4,081.31 3,008.00 0.00 1,073.31 26.30 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501090 Overtime 20,000.00 20,112.26 0.00 -112.26 -0.56 10-542-501095 Overtime Straight Pay 2,000.00 334.51 0.00 1,665.49 83.27 10-542-502010 Social Security 91,487.54 57,377.91 0.00 34,109.63 37.28 10-542-502020 Group Health Insurance 177,578.38 103,806.82 0.00 73,771.56 41.54 10-542-502030 Retirement 201,158.04 137,381.57 0.00 63,776.47 31.70 10-542-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-542-502050 Life Insurance 1,953.57 1,169.29 0.00 784.28 40.15 10-542-502060 Long Term Disability 2,741.84 1,823.17 0.00 918.67 33.51 10-542-502070 Employee Assistance Prgm 560.12 425.68 0.00 134.44 24.00 10-542-503010 Awards Program 450.00 335.00 0.00 115.00 25.56 10-542-503020 Unemployment Compensation 250.00 247.36 0.00 2.64 1.06 E05 Personnel Services 1,630,079.07 1,072,195.32 0.00 557,883.75 34.22 10-542-511010 Advertising 300.00 323.75 0.00 -23.75 -7.92 10-542-511020 Postage 150.00 142.01 0.00 7.99 5.33 10-542-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-542-512020 Copies 50.35 33.22 0.00 17.13 34.02 10-542-513010 Office Supplies 2,000.00 994.00 0.00 1,006.00 50.30 10-542-514020 Chemicals 50,000.00 49,292.66 0.00 707.34 1.41 10-542-514030 Small Tools 9,000.00 4,376.69 0.00 4,623.31 51.37 10-542-514040 Food 1,385.38 1,307.79 0.00 77.59 5.60 10-542-515010 Stormwater Material 17,500.00 12,181.86 0.00 5,318.14 30.39 10-542-515020 Street Materials 245,324.00 122,812.78 -18,395.71 140,906.93 57.44 10-542-515040 First Aid Supplies 500.00 40.55 0.00 459.45 91.89 10-542-515060 Weed Control 2,000.00 195.88 0.00 1,804.12 90.21 10-542-515070 Const & Inspect Supplies 400.00 0.00 0.00 400.00 100.00 10-542-517010 Operational Supplies 4,500.00 3,383.45 0.00 1,116.55 24.81 E10 Materials & Supplies 333,159.73 195,084.64 -18,395.71 156,470.80 46.97 10-542-520030 Dues And Publications 346.00 346.00 0.00 0.00 0.00 10-542-520050 Meeting And Conferences 489.27 0.00 0.00 489.27 100.00 10-542-520070 Training And Education 1,000.00 269.00 0.00 731.00 73.10 10-542-521040 Medical Claimsservices 400.00 0.00 0.00 400.00 100.00 10-542-522020 Professional Services 14,956.00 12,861.50 1,320.00 774.50 5.18 10-542-523010 Equipment Rentlease 1,000.00 75.00 0.00 925.00 92.50 10-542-524010 Trash Collections 4,983.00 589.60 0.00 4,393.40 88.17 10-542-529070 Street Light Installation 1,676.00 1,582.89 0.00 93.11 5.56 E15 Contractual Services 24,850.27 15,723.99 1,320.00 7,806.28 31.41 10-542-531010 Electricity 42,500.00 17,855.74 0.00 24,644.26 57.99 10-542-531020 Street Lights 527,900.00 389,661.99 0.00 138,238.01 26.19 10-542-533010 Natural Gas 16,385.00 12,820.76 0.00 3,564.24 21.75 10-542-534010 Telephone 2,450.00 345.59 0.00 2,104.41 85.89 10-542-535010 Water 7,800.00 4,243.84 0.00 3,556.16 45.59 E20 Utilities 597,035.00 424,927.92 0.00 172,107.08 28.83 10-542-540010 Building & Grounds Maint.7,000.00 5,009.98 75.00 1,915.02 27.36 10-542-541030 Vehicle Wash 6,620.00 4,416.00 0.00 2,204.00 33.29 10-542-542010 Repairs - Stop Lights 10,000.00 6,723.95 0.00 3,276.05 32.76 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-542030 Signs & Marking Paint 30,000.00 30,124.88 0.00 -124.88 -0.42 10-542-546010 Clothing Expense 12,000.00 4,745.94 0.00 7,254.06 60.45 10-542-547010 Equipment Maintenance 3,100.00 1,386.43 0.00 1,713.57 55.28 10-542-547020 Maintenance Agreements 1,400.00 291.60 18.00 1,090.40 77.89 10-542-547030 Radio Maintenance 100.00 55.00 0.00 45.00 45.00 E25 Repairs & Maintenance 70,220.00 52,753.78 93.00 17,373.22 24.74 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,655,344.07 1,760,685.65 -16,982.71 911,641.13 34.33 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 1,682.28 0.00 2,317.72 57.94 10-700-590070 Airport Subsidy 171,635.85 114,423.92 0.00 57,211.93 33.33 10-700-590075 Transit Subsidy 689,630.76 494,635.64 0.00 194,995.12 28.28 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 865,266.61 610,741.84 0.00 254,524.77 29.42 700 Transfers & Subsidies 865,266.61 610,741.84 0.00 254,524.77 29.42 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 96,371.20 0.00 96,371.20 0.00 0.00 10-900-571090 Capvhcleqp-police 161,268.00 0.00 161,268.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 55,318.00 54,398.00 0.00 920.00 1.66 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 312,957.20 54,398.00 257,639.20 920.00 0.29 900 CapitalVehicleEquipment 312,957.20 54,398.00 257,639.20 920.00 0.29 Expense Expense 33,171,540.70 21,090,691.43 651,321.67 11,429,527.60 34.46 GL - Trial Balance by Full Acct Number (07/16/2013 - 8:14 AM)Page 32 FU N D  BA L A N C E  CA L C U L A T I O N FY E  12  Un a s s i g n e d  Ge n e r a l  Fu n d  Ba l a n c e 4 , 6 8 1 , 3 1 6 . 0 0 $   Pe r  Au d i t e d  CA F R Re a p p r o p r i a t i o n ( 5 0 , 4 1 7 . 1 6 ) $           Co l e  Co u n t y  Em e r g e n c y  Si r e n Re a p p r o p r i a t i o n ( 1 0 0 , 0 0 0 . 0 0 ) $       Pr o f  Sv c s  to  Co l u m b i a  Ai r p o r t Re a p p r o p r i a t i o n ( 8 1 5 , 0 0 0 . 0 0 ) $       Fi r e  De p t  ON E  TI M E  PU C H A S E S Re a p p r o p r i a t i o n ( 2 3 , 8 5 1 . 0 6 ) $           Co u r t  So f t w a r e  ‐   no t  co m p l e t e d  in  pr i o r  fi s c a l  ye a r Su p p l e m e n t a l  Ap p r o p r i a t i o n ( 5 , 0 0 0 . 0 0 ) $               Es t a b l i s h  UH C  De d u c t i b l e  Se l f  In s u r a n c e  Im p r e s t  Fu n d Su p p l e m e n t a l  Ap p r o p r i a t i o n ( 4 0 , 0 0 0 . 0 0 ) $           El e c t i o n  Ex p e n s e s Es t i m a t e d  Cu r r e n t  Fu n d  Ba l a n c e 3 , 6 4 7 , 0 4 7 . 7 8 $   CURRENT CURRENT YEAR-YTD 2012-2013 MONTH TO-DATE %BUDGET FUND BUDGET ACTIVITY ACTUAL RECEIVED/SPENT VARIANCE REVENUES: Property Taxes $5,221,000 $20,968.64 $5,178,556.77 99%($42,443) Sales Tax & Sale Tax Interest $9,700,000 $1,023,015.33 $4,813,531.75 50%($4,886,468) Motor Vehicle Sales Tax $403,750 $49,542.29 $235,323.63 58%($168,426) Gasoline Tax $1,100,950 $91,639.06 $526,190.01 48%($574,760) Cigarette Tax $147,000 $11,566.00 $73,901.76 50%($73,098) Franchise Fees $7,385,000 $509,278.04 $4,093,687.49 55%($3,291,313) Intergovernmental $2,325,139 $47,589.20 $889,863.38 38%($1,435,276) Charges for Services $1,988,660 $154,907.99 $1,238,607.24 62%($750,053) Fees, Licenses & Permits $689,700 $69,344.44 $512,213.59 74%($177,486) Fines & Forfeitures $1,050,980 $70,825.55 $641,770.17 61%($409,210) Interest Income $40,000 $0.00 $57,209.99 143%$17,210 Other Operating Revenues $1,258,272 $84,753.14 $764,494.59 61%($493,777) Operating Transfers In $20,990 $2,000.45 $30,268.77 144%$9,279 Police Grants $594,028 $6,185.22 $241,865.82 41%($352,162) School Resource Officer $188,765 $0.00 $192,242.34 102%$3,477 M.U.S.T.A.N.G.$0 $1,120.64 $16,963.89 N/A $16,964 Transfer from (to) Surplus $986,566 $0.00 $0.00 N/A ($986,566) Total General Fund $33,100,800 $2,142,735.99 $19,506,691.19 59%($13,594,109) EXPENDITURES: Council & Mayor $76,558 $5,798.58 $46,631.36 61%($29,926) City Clerk $172,826 $7,314.35 $132,328.13 77%($40,497) City Administrator $279,432 $19,294.58 $193,077.13 69%($86,355) Entitlement Grant $306,020 $1,031.28 $44,407.67 15%($261,612) City Counselor $342,026 $25,097.92 $216,318.32 63%($125,708) Municipal Court $278,089 $17,500.77 $148,925.10 54%($129,164) Human Resources $297,079 $22,187.73 $184,974.30 62%($112,105) Finance $931,315 $59,344.05 $598,318.28 64%($332,997) Non Departmental $2,295,202 $255,701.20 $1,398,806.33 61%($896,396) IT Department $1,081,064 $66,714.32 $720,241.07 67%($360,823) Police $7,403,090 $614,051.13 $4,637,081.47 63%($2,766,009) School Resource Officer $374,485 $43,432.38 $220,755.42 59%($153,729) M.U.S.T.A.N.G.$184,859 $30,630.71 $121,832.66 66%($63,026) Animal Control $668,282 $67,129.67 $425,791.12 64%($242,491) 9-1-1 Police $1,401,362 $123,286.43 $899,602.40 64%($501,759) Fire $7,387,845 $529,743.50 $4,965,732.59 67%($2,422,113) Public Works $0 ($229.61)($229.50)N/A ($230) Planning & Protective Services Admin $286,195 $22,456.53 $187,198.03 65%($98,997) Planning $112,321 $7,230.59 $62,690.32 56%($49,630) Metropolitan Planning Org $188,790 $21,435.16 $123,284.10 65%($65,506) Redevelopment/Grant $1,816,494 $55,478.14 $243,411.17 13%($1,573,082) Building Regulations $659,332 $41,387.92 $369,935.22 56%($289,397) Environmental Health $448,174 $35,186.75 $269,415.35 60%($178,758) Public Works - Central Main $978,471 $70,472.38 $565,321.15 58%($413,150) Public Works - Admin $279,773 $21,684.71 $173,493.21 62%($106,280) Public Works - Engineering $1,088,890 $79,003.26 $712,404.13 65%($376,486) Public Works - Street $2,655,344 $244,899.53 $1,635,575.26 62%($1,019,769) Transfers & Subsidies $865,267 $63,051.77 $610,741.84 71%($254,525) Capital/Vehicle/Equipment $312,957 ($99.00)$54,398.00 17%($258,559) $33,171,541 $2,550,216.73 $19,962,461.63 60%($13,209,079) Fund Income (Loss)($70,741)*($407,480.74)($455,770.44)($385,030) CITY OF JEFFERSON GENERAL FUND INCOME STATEMENT FOR THE MONTH ENDING JUNE 30, 2013 Tax Period Due Date to  City  Total Lodging Tax  JCCVB (3/7) JCCVB/Convention  Center Fund (4/7) May‐116/20/1191,258.41             38,328.53        51,104.71                 Jun‐117/20/11101,479.82           42,621.54        56,828.68                 Jul‐118/20/1188,392.47             37,124.82        49,499.80                 Aug‐119/20/1173,144.02             30,720.48        40,960.66                 Sep‐1110/20/11103,618.61           43,519.80        58,026.44                 Oct‐1111/20/11105,531.99           44,323.44        59,097.91                 Nov‐1112/20/1166,556.88             27,953.89        37,271.85                 Dec‐111/20/1252,204.97             21,926.07        29,234.80                 Jan‐122/20/1265,645.72             27,571.20        36,761.61                 Feb‐123/20/1285,143.89             35,760.45        47,680.56                 Mar‐124/20/1281,904.23             34,399.77        45,866.38                 Apr‐125/20/12103,406.71           43,430.82        57,907.76                 May‐126/20/1289,713.24             37,679.58        50,239.40                 Jun‐127/20/1286,753.72             36,436.56        48,582.08                 Jul‐128/20/1289,904.69             37,759.97        50,346.63                 Aug‐129/20/1276,708.71             32,217.66        42,956.88                 Sep‐1210/20/12109,335.16           45,920.77        61,227.69                 Oct‐1211/20/12109,059.34           45,804.92        61,073.23                 Nov‐1312/20/1269,756.75             29,297.84        39,063.77                 Dec‐121/20/1355,126.67             23,153.20        30,870.94                 Jan‐132/20/1384,295.92             35,404.29        47,205.71                 Feb‐133/20/1384,199.16             35,363.65        47,151.53                 Mar‐134/20/1398,008.06             41,163.39        54,884.51                 Apr‐135/20/13100,022.48           42,009.44        56,012.59                 May‐136/20/1397,602.44             40,993.02        54,657.37                 Total2,168,774.06        910,885.10        1,214,513.49             average monthly amount for Convention Center Fund48,580.54   BILL NO. [Bill No.] SPONSORED BY COUNCILMAN _______________________ ORDINANCE NO. AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, ADOPTING AN ECONOMIC INCENTIVE POLICY. BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS FOLLOWS: Section 1. Chapter 25 (Planning and Development) is amended by the addition of an Article XI as follows: Article XI. Economic Incentive Policy Sec. 25-200. Purpose Statement The City of Jefferson is dedicated to achieving the highest quality of development, services, infrastructure, and quality of life for its citizens. One of the primary keys for achieving these goals is to enhance and expand the local economy. Competition for attracting new businesses and employers, as well as retaining the ones already in existence in the community, can be aggressive from time to time at national, regional, interstate, and intrastate levels. For this reason, the City recognizes that the appropriate use of economic development incentives may be necessary in the correct circumstances to aid the City in reaching its full economic potential. The purpose of th ese policies are two-fold: First, to establish the goals, standards, guidelines, and preferences of the City to direct the use of economic incentives to ensure that these incentives are used in a way that advances the City’s economic goals. These policies allow the City to be proactive (not reactive) with respect to requests from developers and businesses to create the public-private partnerships, which are the real result of granting incentives in any instance. These policies serve as a guide to developers and businesses far and wide to attract those having concepts, ideas, and plans that closely match the development needs of the City. Conversely, these policies also inform the development and business community that incentives for businesses already supported in the City, or for which there is no longer a community need, may be more difficult to obtain. Second, the procedures component establishes a uniform, transparent, and well -informed path for businesses and developers to follow when seeking economic development incentives of the City. We believe that through a standard approach the expectations of applicants can be managed at reasonable levels, which leads to a more positive experience for those seeking incentives. The uniform application of these procedures ensures that the goals and needs of the City are being specifically considered for each economic development incentives request, which leads to greater long -term success of the program as a whole. Finally, these procedures address the ongoing execution of each approved incentive application thereby confirming that the applicant will be held accountable for delivering the promised investment in the community, which in turn builds confidence in the City’s incentives program by its citizens and the other affected taxing jurisdiction s that are the City’s neighbors. Nevertheless, the applicability of the differing incentives programs often varies from project to project, and the City Council’s decision to grant incentives is discretionary, based upon one or more of the criteria set forth in this document and other outside factors. The City Council is under no obligation to approve any requested incentives that are not required by state or local laws, and it reserves the right to deviate from these policies and procedures at its sole discretion when doing so is deemed to be in the best interests of the City. Sec. 25-201. General Policy And Procedure Guidelines To implement the City’s economic development incentive program, certain overarching concepts apply. These concepts, which are listed in detail below, fall into the categories of both the policy and procedural components of the City’s overall program. Applicants with the highest likelihood of success will address each of these general policy issues and procedural steps in addition to the policy issues and procedural steps that apply to the specific economic incentive tool or tools applied for and described in more detail in this document. A. General Policy Matters 1. When funds exist, either from the City’s budget or supplementary grants or other funding sources, or a combination thereof, the City should obtain, maintain, and update a market study designed to identify the economic development needs of the City for utilization in the review of economic development requests. 2. Applicants must demonstrate that the private investment (through equity, private financing, or a combination thereof) is greater than the incentives requested. The preferred ratio of investment to incentive is that the incentives request should be 25% or less of the total proposed project costs). 3. The purpose of any requested incentive is to provide additional funding for a specific City-designated economic development goal; or, if not, the applicant has provided justification and supporting documents (e.g., third-party market studies, etc.) explaining why the purpose of the request should be a City-designated economic development goal. 4. To ensure that the City’s interests are adequately protected and that the citizens and current business partners of the City of Jefferson are not bearing the burden of the costs to review requests for public aid through economic development incentives, applicants will be required to enter into a funding agreement whereby the applicant provides funds to the City to obtain professional consultants necessary to aid in determining the appropriate levels of assistance for the proposal, project feasibility, de veloper’s financial capacity, and a legal review of the application, the approval process, and the negotiation and implementation of applicable agreements. The City’s expenses may include, but is not limited to, fees for special legal and financial consultation, market study reviews, appraisal reviews, and if applicable, bond underwriters and bond counsel. These costs may be reimbursed through the incentive program as allowed by law. 5. When the level and type of economic development incentives reaches or exceeds an appropriate amount, the City will conduct, and the applicant should expect to provide, a review of its relevant business experience, financial condition , ability to carry out the proposed project, and criminal background. Applicants are notified that the level of scrutiny into the applicant’s background will vary ratably with the amount of public incentives and public risk associated with the level of incentives requested in the application. 6. Projects utilizing funds created from the development to reimburse development costs (“pay-as-you-go”) are highly encouraged. The use of public debt should be limited to only that amount absolutely necessary, which fact will be the applicant’s responsibility to justify in the approval process. 7. Incentive requests for projects that involve property acquisition by eminent domain are highly discouraged. B. General Procedural Requirements. 1. Applicants for any economic development incentive program granted by the City must schedule and attend a pre-application meeting with City staff prior to submitting an application. 2. The City will provide basic forms, a summary of the application, review, and consideration process, applicable statutory requirements, and an estimated timeline for the approval process, in addition to other relevant information, at the pre-application meeting. 3. Applicants will be expected to work with City staff and, when applicable, City consultants, while preparing the applicable “official” document to be placed on file with the City, thus triggering the applicable statutory review process. 4. Applicants will be required to enter into a funding agreement whereby the applicant provides funds to the City to obtain professional consultants necessary to aid in determining the appropriate levels of assistance for the proposal, project feasibility, developer’s financial capacity, and a legal review of the application, the approval process, and the negotiation and implementation of applicable agreements. An initial deposit will be required before the City’s staff and consultants will begin work processing the applicant’s proposal. The amount of the funding agreement deposit will vary depending upon the application or applications filed, and applicants are hereby notified that the funding agreement will contain an “evergreen” clause whereby the applicant must replenish the fund as it is used to ensure the full amount of the deposit is available to the City for use in reviewing the application. Applicants are placed on notice that the costs associated with a funding agreement are not refundable in the event that the application is not approved. Payment of the associated costs does not guarantee approval of the application by the TIF Commission or City Council, whose decisions shall remain at their sole discretion. 5. Applicants shall consider reimbursement of the City’s costs to review and consider the approval of the application, and in the event the application is approved, to administer the incen tive program while it remains active, as a component of the overall project costs. Applicants also shall provide a mechanism for the prompt payment of the City’s costs in its application. The City’s costs associated with the consideration of the approval of an application shall be paid in full at the time of any applicable hearing or meeting to consider a recommendation of approval or the approval of the application. The City reserves the right to postpone such hearing or meeting until the necessary payments have been made. Secs 25-203 through 25-109 Reserved. Sec 25-210. Tax Increment Financing (TIF) Incentives. Sections 25-210 through 25–219 shall be known as “The Policy And Procedure Guidelines For Tax Increment Financing (TIF) Incentives. Sec 25-211. TIF Overview. Tax Increment Financing (TIF) is a public funding mechanism to assist private development of an area within the City. TIF may only be used: 1) when there is evidence the development would not occur without public assistance; and 2) when the project area qualifies as a blighted or conservation area in accordance with state statutes. TIF is a financial tool used to capture the increase in property taxes and sales taxes created as a result of the redevelopment of an approved area within the City. TIF by itself does not cause an increase in property or sales tax rates. 100% of the incremental increase in property tax revenues (known as payments in lieu of taxes or “PILOTs”) and 50% of the incremental increase in local sales and use tax revenues (known as economic activity taxes or “EATs”) generated in an approved TIF redevelopment area as a result of the completion of a development project will be captured and directed to a TIF special allocation fund. The PILOTs and EATs may then be used to reimburse a private developer for eligible expenses or to repay principal and interest on bonds used to finance the eligible expenses for a maximum of 23 years from the date a TIF redevelopment project was activated. Sec 25-212. TIF Statutory Requirements. By law, the City must determine that certain requirements have been met before approving a Tax Increment Financing Plan filed by the applicant. These requirements are set forth under Sections 99.805 to 99.865 of the Revised Statutes of the State of Missouri (RSMo) (the “TIF Act”). Sec 25-213. TIF Policy Guidelines. A. In addition to meeting the statutory requirements referenced above, the City has established several criteria that will be applied in the review and evaluation of applications for TIF financing. In general, applications that meet each of the evaluation criteria will be viewed most favorably. However, TIF applications that do not meet all of the criteria listed herein may be approved if the application demonstrates that the TIF Plan and project or projects on the whole is of vital economic interest to the City. B. The City’s evaluation criteria for TIF applications are as follows: 1. The proposal must demonstrate a substantial and significant public benefit by eliminating blight, financing desirable public improvements, strengthening the City’s economic and employment base through the creation of new jobs or retention of existing employment, positively impacts surrounding areas, creates economic stability, facilitates economic self-sufficiency, aids in the implementation of the City’s comprehensive development plan and economic development strategies, and serves as a catalyst for further high quality development or redevelopment in the City. 2. Proposals for the redevelopment and/or infill of deteriorating areas within the City will be given more favorable consideration than projects for the redevelopment of “green field” areas. 3. The applicant must provide evidence that the applicant has thoroughly explored alternative financing methods and has a track record which demonstrates the financial and technical ability to complete the project. 4. TIF assistance to the project should generally not exceed 25% of total project costs. However, project assistance above 25% may be considered in circumstances where the developer: a. has a proven track record in completing successful projects comparable in scope and scale; and b. documents the developer’s finan cial capacity to complete the proposed project; and c. demonstrates that tenant commitments are already in place for a significant portion of the proposed project; and d. demonstrates the need for additional assistance in order to achieve a reasonable rate of return of the proposed project. 5. Proposals requesting TIF assistance should have a ratio of three to one (3:1) in comparing potential increased revenue to the City from all sources to the value of the incentives provided, measured over the term of the TIF project. 6. Generally, TIF applications which encompass a project area of less than 10 acres will be discouraged. 7. In evaluating the employment potential of a proposed redevelopment, the following shall be taken into consideration: a. number of additional employees that will be hired as a result of the project and whether they are likely to be hired from the local population; and b. skill and education levels required for the jobs expected to be created by the project; and c. range of salary and compensation for jobs expected to be created by the project; and d. potential for executive relocation. TIF projects that create jobs with wages that exceed the community average will be viewed favorably. 8. TIF applications for new or expanded office, commercial, or industrial and manufacturing projects will be viewed more favorably than new or expanded retail projects. TIF applications for retail and service commercial projects should be limited to those projects that encourage an inflow of new customers from outside the City or that will provide services or fill retail markets that are currently unavailable or in short supply in the City as documented in a professionally prepared market study. New or expanded industrial and manufacturing projects will be given more favorable consideration than new or expanded warehouse type uses based upon the projected employment per square foot. 9. TIF applications for the development of commercial, office and industrial projects that would stabilize existing commercial, office and industrial areas that have or will likely experience deterioration will be favored. 10. TIF applications that include the development of business areas, or the redevelopment of existing business areas, shall include information as to the business type of the major tenants of the TIF area. In addition, a thorough market analysis should be completed that identifies: (1) the population areas from which the project will draw; and (2) the businesses of similar types that would be competing with the TIF area businesses. 11. TIF applications for new residential development projects (other than a limited number of residential units which are creatively integrated into commercial or retail projects) will be strongly disfavored. TIF applications for the redevelopment of existing residential areas will generally be disfavored. [NOTE: Need to consider this based on the City’s needs. Residential TIFs are usually disfavored because they cause a drain on resources without an offsetting increase in revenues. They are particularly burdensome on school districts, who have two representatives on the TIF Commission] 12. Government-issued financing related to TIF applications. a. If an applicant’s financing plan includes a request for the City or another governmental entity at the City’s request (e.g., an industrial development authority or the Missouri Economic Development Financing Board (“MDFB”)) to issue notes and/or bonds to finance the project, the applicant shall enter into an agreement with the City regarding the terms of such financing prior to the consideration of the approval of the application, which financing terms shall be incorporated into a redevelopment agreement for the implantation of the redevelopment plan upon the approval of the application, as applicable. b. TIF applications requesting the issuance of bonds or notes shall be required to demonstrat e using a third-party revenue consultant selected by the City that the payments-in-lieu of taxes and/or economic activity taxes expected to be generated will be sufficient to provide debt service coverage of at least 1.30 times the projected debt service on any tax increment financing bonds or notes, that is to say that the development must show that there will be $1.30 of revenue produced for every $1.00 of debt service to repay debt issued. This limitation may be modified for projects that involve the redevelopment of existing structures or the assembly and clearance of land upon which existing structures are located. The debt service coverage ratio provided in this subsection is for guidance only, the actual ratio will be determined through negotiations of the parties in the context of an actual request for incentives through an application. c. Applications requesting the City to issue annual-appropriation backed bonds are highly discouraged. In the event that the applicant justifies why annual-appropriation backed bonds are necessary for the project, the applicant shall be required to demonstrate using a third-party revenue consultant selected by the City that the payments-in-lieu of taxes and/or economic activity taxes expected to be generated will be sufficient to provide debt service coverage of at least 1.70 times the projected debt service on any tax increment financing bonds or notes., that is to say that the development must show that there will be $1.70 of revenue produced for every $1.00 of debt service to repay debt issued The debt service coverage ratio provided in this subsection is for guidance only, the actual ratio will be determined through negotiations of the parties in the context of an actual request for incentives through an application. 13. If the TIF application is being recommended based upon specifically delineated benefits that are projected to flow to the City as a result of the development, such as increased employment opportunities, increased ad valorem or economic activity taxes, or construction of public infrastructure, language will be included in the development agreement that stipulates that the City's assistance to the developer may be reduced if satisfactory evidence is not shown that the degree, nature and/or quality of the benefits have been generated to the City by the project in accordance with the timeline provided in the application. 14. Applications that include the utilization of a Community Improvement District (CID), Transportation Development District (TDD), Neighborhood Improvement District (NID), or other private or public financing mechanisms that result in reducing the term of the TIF project and/or reduce the burden on affected taxing jurisdictions will be viewed more favorably. 15. Notwithstanding the foregoing, TIF applications that, based upon the above guidelines, would not otherwise be favorably considered or do not meet any of the above referenced criteria, shall be viewed favorably by the City if the application clearly demonstrates that the project as a whole or a portion of it is of vital interest to the City and will significantly assist the City by eliminating blight, financing desirable public improvements, strengthening the City’s economic and employment base through the creation of new jobs or retention of existing employment, positively impacting surrounding areas, creating economic stability, facilitates economic self-sufficiency, aiding in the implementation of the City’s comprehensive development plan and economic development strategies, and serving as a catalyst for further high quality development or redevelopment in the City. Sec 25-213. TIF Expenses Eligible for Reimbursement. A. A TIF proposal shall include what expenses are to be eligible for reimbursement. B. Subject to the requirements of the TIF Act, expenses eligible for reimbursement under a TIF proposal may include, but are not limited to, the following: 1. Studies, surveys, plans and specifications, Fees incurred by either the City or the applicant, or both, for professional services such as architectural, engineering, legal, marketing, financial, and planning; 2. Site preparation, including demolition of structures, clearing and grading of land. 3. Constructing public infrastructure such as streets, sewers, utilities, parking, and lighting. 4. Financing costs including bond issuance. 5. Relocation costs if persons or businesses within the redevelopment area are displaced. Sec 25-213. TIF City Application/Approval Process. A. The applicant is required to first meet with staff in a pre-qualification conference to determine project eligibility. An application may then be submitted to the Department of Public Works for review and processing. A copy of the formal application may be obtained through the Department of Public Works. B. Provided that the application exhibits initial feasibility in the opinion of City staff as determined by the information exchanged in the pre-qualification conference, the applicant will be required to enter into a funding agreement with the City to cover the City’s expenses associated with the TIF consideration and approval process, as provided in the City’s General Policy and Procedural Guidelines. The City’s expenses may include, but is not limited to, fees for special legal and financial consultation, market study revie ws, appraisal reviews, and if applicable, bond underwriters and bond counsel. Applicants are placed on notice that the costs associated with a funding agreement are not refundable in the event that the application is not approved. Payment of the associat ed costs does not guarantee approval of the application by the TIF Commission or City Council, whose decisions shall remain at their sole discretion. C. Care will be exercised in the use of TIF incentives to thoroughly evaluate each project to ensure that th e benefits that will accrue from the approval of the project are appropriate, in relation to the TIF incentive provided to and the costs that will result from the project, and that the project, when viewed from this prospective, benefits the City as a whole. D. Each project, and the location at which it is proposed, is unique and, therefore, every proposal shall be evaluated on its individual merit, including its potential economic benefit, potential impact on the City's service levels, its overall contribution to the City's economy and its consistency with the City's goals and objective as expressed in the Comprehensive Plan and other adopted or City endorsed planning or strategic documents. The applicant is expected to work with the City’s staff and consultants to prepare the TIF Plan prior to the applicant’s formal submittal of the final TIF Plan for TIF Commission and City Council review and approval. E. Following a public hearing before the City’s TIF Commission and approval of the TIF Plan by the City Council, the City and the applicant shall enter into a redevelopment agreement for the purpose of governing the implementation of the TIF Plan. Secs 25-214 through 25-299 Reserved. Sec 25-220. Community Improvement District (Cid) Incentives Sections 25-220 through 25 – 221 shall be known as “The General Policy And Procedure Guidelines For The Use Of Community Improvement District (Cid) Incentives.” Sec 25-221. CID Overview A Community Improvement District (CID) is a special purpose district in which property owners voluntarily impose a funding mechanism upon themselves to fund a broad range of public improvements and/or services to support business activity and economic development within specified boundaries. Created by an ordinance of the City Council, establishment of the CID is considered after the receipt of a petition, signed by owners of real property, representing more than 50 percent of the assessed valuation within the proposed CID boundary and over 50 percent per capita of all owners of real property. A CID may be established either as a separate political subdivision that is distinct from the municipality or as a not-for -profit corporation. If the CID is organi zed as a political subdivision, the District can impose a sales tax in 1/8% increments up to 1% on most retail sales and/or a real property tax. If the CID is organized as a non -profit corporation, it may only impose special assessments to finance the cost of improvements and services. The District, if desired, may issue tax-exempt revenue bonds to finance capital improvement projects for up to 20 years. Responsibility for repayment of CID bonds lies solely with the District. As such, the City does not pledge its full faith and credit behind the repayment of the bonds. In terms of governance, a board of directors made up of the representatives of business owner, property owners, and voters either elected or appointed by the City of Jefferson City Council oversees District activities. If the District is funded solely through special assessments, a not -for -profit agency can serve as the administrator. Although the CID is established with the approval of the City Council, once formed the District op erates independently in accordance with the provisions set forth in the petition and Missouri State Law. Sec 25-222. CID Statutory Requirements By law, the City must determine that certain requirements have been met before approving the establishment of a Community Improvement District. These requirements are set forth under Sections 67.1401 - 67.1571 of the Revised Statutes of the State of Missouri (RSMo) (the “CID Act”). Sec 25-223. CID Policy Guidelines A. In addition to meeting the statutory requirements referenced above, the City has established several criteria that will be applied in the review and evaluation of applications for the establishment of a CID. In general, applications that meet each of the evaluation criteria will be viewed most favorably. However, CID applications that do not meet all of the criteria listed herein may be approved if the application demonstrates that the CID proposal on the whole provides a substantial and significant public benefi t to meet identified economic development needs in the City. B. The City’s evaluation criteria for CID applications are as follows: 1. CIDs which are established for the purpose of: (1) reducing the time a TIF project is active and/or offsetting the burden of TIF incentives on the affected taxing jurisdictions; or (2) providing all or a portion of the funding needed to construct public improvements that have been identified as a long -term goal of the City’s capital improvements plan are highly favored. 2. The applicant should work with City staff and consultants to ensure that a proposed sales tax would not cause the cumulative sales tax rate within the proposed CID boundaries to exceed ten percent (10%). 3. Perpetual CIDs having a sales tax as a funding mechanism are disfavored. C. CIDs formed primarily for the purpose of funding common area maintenance costs are discouraged. D. The CID petition shall require that at least two (2) members of the Board of Directors shall be an elected or appointed official or employee of the City. E. The CID petition shall provide that the City Council must review and approve the CID’s annual budget before it is presented for approval by the CID’s Board of Directors. F. CID petitions which provide that the CID Board of Directors will be a ppointed by the Mayor with the consent of the City Council are favored. G. A CID formed to provide sustainable funding for an organization having the purpose of promoting the City’s historic downtown shopping district would be strongly encouraged. H. Petitions which propose the issuance of CID bonds are discouraged. I. The use of a CID as a substitute for traditional homeowners associations i s encouraged; provided that the proposed CID is established as a not-for -profit corporation. Sec 25-224. CID City Application/Approval Process A. CID applicants are required to first meet with staff pre-qualification conferences to determine project eligibility. An application may then be submitted to the Department of Public Works for review and processing. A copy of the formal application may be obtained through the Department of Public Works. Applicants may be required to enter into a funding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as a component of the City of Jefferson’s Economic Development Policies and Procedures. B. Prior to the applicant’s formal submittal of the final CID Petition with the City Clerk for City Council review and approval, the applicant is expected to work with the City’s staff and consultants to prepare the CID petition to ensure that it substantially complies with statutory requirements. Once the review process has been completed, the petitioner(s) may file the petition pursuant to the CID Act in the office of the City Clerk. Upon receipt of the petition, the City Clerk, upon the advice of the City Counselor, or his or her designee, shall make a final determination of whether the petition substantially complies with statutory requirements. Following confirmation that the petition complies with these requirements, a public hearing will be held by the City Council. The City Council would then consider whether to approve an ordinance to establish the CID. C. Following the establishment of the CID, the City and the CID board shall enter into a cooperative agreement for the purpose of establishing the terms of the relationship between the City and the CID board. Once established, the CID applicant will either seek to impose a sales tax and/or a property tax within the district, or to levy a special assessment within the district in accordance with the procedures and provisions set forth in the CID Act. Secs 25-225 through 25-229 Reserved. Sec 25-230. Transportation Development District (TDD) Incentives Sections 25-230 through 25 – 239 shall be known as “The General Policy And Procedure Guidelines For The Use Of Transportation Development District (TDD) Incentives”. Sec 25-231. TDD Overview Transportation Development Districts (TDD) are independent political subdivisions organized to levy sales taxes, property taxes, or special assessments to pay for the construction of roads, bridges, interchanges, intersections, parking facilities or other transportation related improvements. Unlike CIDs, TDDs are approved and organized by order of the circuit court. A TDD petition is a law suit filed by the petitioners against the Missouri Highways and Transportation Commission and the affected local transportation authority, which may include the City (provided that the City is not the petitioner). Property owners may petition for the creation of a district as large as several counties or as small as a single parcel of property. The TDD Act also allows for the governing body of local transportation (in the City’s case, the City Council) to file a petition to form a TDD. As long as the TDD is proposed to construct transportation related improvements, any property is eligible to be included in a TDD. TDDs may generate revenues through sales taxes (up to 1%), ad valorem taxes on real and personal property (up to ten cents per $100 assessed valuation), special assessments, or tolls. The TDD is authorized to issue bonds on its own behalf, utilizing these captured taxes and assessments to pay debt service on bonds issued to construct transportation projects. Either the Missouri Department of Transportation (MoDOT) or the City are required to sponsor projects and must agree to accept maintenance responsibilities for completed projects. When the project costs are paid off (or if applicable, the bonds financing the project costs are paid off), the TDD is terminated. Sec 25-232. TDD Statutory Requirements While City approval of a TDD is not specifically required by law, it is in an applicant’s best interest to coordinate the filing of a petition for the formation of a TDD for which the City is a local transportation authority with the City befo re doing so. The City will aid the applicant in determining whether the requirements for a valid TDD have been met before asking the City Council to adopt a resolution in support of the formation of the proposed TDD. These requirements are set forth under Sections 238.200 – 238.275 of the Revised Statutes of the State of Missouri (RSMo) (the “TDD Act”). Sec 25-233. TDD Policy Guidelines A. The City may pass a resolution endorsing (or opposing) projects prior to the time of the circuit court review of petitions filed to establish a proposed TDD. Additionally, for proposed TDDs which include the City as a local transportation authority, the City has a statutory right to file a petition in support of or opposing the formation of the TDD. The City will support the formation of a TDD only in circumstances where projects create substantial public benefits by advancing the City’s goals. B. In addition to meeting the statutory requirements referenced above, the City has established several criteria that will be applied in the review and evaluation of app lications for the formation of a TDD within the City’s jurisdictional boundaries. In general, applications that meet each of the evaluation criteria will be viewed most favorably. However, TDD proposals that do not meet all of the criteria listed herein may be approved if the application demonstrates that the TDD proposal on the whole provides a substantial and significant public benefit to meet identified economic development needs in the City. The City’s evaluation criteria for TDD applications are as follows: 1. TDDs which are established for the purpose of: (1) reducing the time a TIF project is active and/or offsetting the burden of TIF incentives on the affected taxing jurisdictions; or (2) providing all or a portion of the funding needed to construct public improvements that have been identified as a long-term goal of the City’s capital improvements plan are highly favored. 2. The applicant should work with City staff and consultants to ensure that a proposed sales tax would not cause the cumulative sales tax rate within the proposed TDD boundaries to exceed ten percent (10%). 3. TDD petitions requiring that at least two (2) members of the TDD Board of Directors shall be an elected or appointed official or employee of the City are highly favored. 4. TDD petitions that require the City Council to review and approve the TDD’s annual budget before it is presented for approval by the TDD’s Board of Directors are highly favored. 5. Petitions which propose the issuance of TDD bonds are discouraged. Sec 25-234. TDD City Application/Approval Process A. TDD applicants are required to first meet with staff pre-qualification conferences to determine project eligibility. An application may then be submitted to the Department of Public Works for review and processing. A copy of the formal application may be obtained through the Department of Public Works. Applicants may be required to enter into a funding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as a component of the City of Jefferson’s Economic Development Policies and Procedures. B. Prior to the applicant’s formal submittal of the final TDD Petition with the Circuit Court Clerk, the applicant is expected to work with the City’s staff and consultants to prepare the TDD petition to ensure that it complies with statutory requirements and City policy. Among the issues to be resolved in this process is whether the City will be the petitioner as the local transportation authority, or whether the property owners will file the petition. Once the review process has been completed, City staff will forward the matter to the City Council, which will consider a resolution of support in favor of the formation of the TDD. C. After the City Council’s determination, the petitioner(s) may file th e petition with the Circuit Court Clerk pursuant to the TDD Act. If the City Council has approved a resolution of support in favor of the formation of the TDD, the City will cooperate with the petitioners in the prosecution of the case, as is required by whether the City is the petitioner or a respondent. If the City Council has not approved a resolution of support in favor of the formation of the TDD, the City reserves its right to file an answer in opposition to the petition. D. Once the TDD is formed by the circuit court, the City and the TDD board should enter into a cooperative agreement for the purpose of establishing the terms of the relationship between the City and the TDD Board of Directors. Secs 25-235 through 25-139 Reserved. Sec 25-240. Neighborhood Improvement District (NID) Incentives Sections 25-240 through 25– 249 shall be known as the “The General Policy And Procedure Guidelines For The Use Of Neighborhood Improvement District (Nid) Incentives” Sec 25-241. NID Overview Neighborhood Improvement District (NID) is not an entity separate from the City, but rather the designation of a special district in which special assessments are imposed to finance public improvements, including acquisition, construction, engineering, legal and related costs. Temporary notes are issued by the municipality to pay the costs of the improvements and related costs. Once the construction of the improvements is completed, the temporary notes are paid by the NID bonds, which are in turn retired through special assessments against property owners in the area in which the improvements are made. NID bonds cannot exceed 125% of the estimated cost of the improvements established in the NID petition. The cost of the public improvements assessed again st property owners in the district are apportioned in a manner commensurate to the amount of benefit received from such improvements. NID bonds are counted against the City’s constitutional debt limits. The creation of a NID may be established by one of two methods. The first is by a favorable vote of qualified voters living within the boundaries of the proposed district. The second is through a proper petition signed by at least two- thirds of the owners of record of all real property within the proposed district. In both instances, approval by the City’s City Council is required in order to establish the NID. Sec 25-242. NID Statutory Requirements By law, the City must determine that certain requirements have been met before approving the establishment of a Neighborhood Improvement District (NID). These requirements are set forth under Sections 67.453 to 67.475 of the Revised Statutes for the State of Missouri (RSMo) (the “NID Act”). Sec 25-243. NID Policy Guidelines The City of Jefferson is prepared to approve petitions for Neighborhood Improvement Districts (NID) to facilitate business activity, economic development, and expedited neighborhood improvement through the participation of property owners to fund public infrastructure within Jefferson City. Because the City issues special obligation bonds that count against its constitutional debt limits, decisions to approve the establishment of a NID will be determined on a case-by-case basis and approved only where there is a clear demonstration of substantial and significant public benefit. Improvements funded by a NID must be purely public in nature, meaning that the improvement will be owned, operated, and maintained by the City after completion and must remain open for public use. At a minimum, all statutory requirements must be met. Sec 25-244. NID City Application/Approval Process A. NID applicants are required to first meet with staff pre-qualification conferences to determine project eligibility. An application may then be submitted to the Department of Public Works for review and processing. A copy of the formal application may be obtained through the Department of Public Works. Applicants may be required to enter into a fun ding agreement with the City pursuant to the General Policy and Procedure Guidelines provided as a component of the City of Jefferson’s Economic Development Policies and Procedures. B. Prior to the applicant’s formal submittal of the final NID Petition with the City Clerk for City Council review and approval, the applicant is expected to work with the City’s staff and consultants to prepare the NID petition to ensure that it substantially complies with statutory requirements. Once the review process has been completed, the petitioner(s) may file the petition pursuant to the NID Act in the office of the City Clerk. Upon receipt of the petition, the City Clerk, upon the advice of the City Counselor, or his or her designee, shall make a final determination of whether the petition substantially complies with statutory requirements. Petitions that comply with the statutory requirements will be forwarded to the City Council for consideration, subject to the procedural requirements established in the NID Act. Under certain conditions a cooperative agreement may be required to establish the terms of the relationship between the City and the applicants filing the NID petition. Secs 25-245 through 25-250 Reserved. 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: APPROVED AS TO FORM: City Clerk City Counselor