Loading...
HomeMy Public PortalAbout20140410 finance packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, April 10, 2014 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO Small Conference Room (Lower Level) TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the March 13, 2013 meeting. 4. Financial Reports – Bill Betts a. Revenue Model Report b. Sales Tax Report c. Monthly Budget Report d. Fund Balance Report 5. Conference Center Funding – Bill Betts 6. Lodging Tax Report – Shiela Pearre 7. Applicant Tracking Software – Gail Strope 8. Revisions of Purchasing Rules – Drew Hilpert 9. New Business 10. Old Business 11. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634 -6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, March 13, 2014 MINUTES The meeting was called to order by the Finance Committee Vice-Chairman, Councilman Ralph Bray at 7:30 am. Roll call showed that Councilmen Bray, Graham, Prather and Scrivner were in attendance. Councilman Schulte was absent. Next the minutes of the February 25, 2014 meeting were reviewed. A motion to approve was made by Councilman Graham and seconded by Councilman Prather. The minutes were approved unanimously. The next item on the agenda was a report by Interim Finance Director, Bill Betts, covering the Financial Reports. Mr. Betts reviewed the Revenue Model and explained some variances. Other information reviewed included March sales tax figures, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by the Mr. Betts, covering Conference Center funding. Reports from Piper Jaffray & Co. were provided to the Committee. The next item on the agenda was a report by the Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the Conference Center Fund, is $1,615,328. The average monthly amount collected for the Conference Center Fund is $49,448. Also provided was a comparison of 2014 vs. 2013 occupancy rates. The committee requested that the 2012 occupancy rates be added to the comparison and also requested that staff try and obtain some occupancy rates from other cities as well. The next item on the agenda was a continued discussion led by Interim City Administrator, Drew Hilpert, regarding purchasing code revisions. It was requested that this item be held until the next meeting due to the absence of Councilman Schulte. The next item on the agenda was New Business. Councilman Graham informed the Committee that the MIAA Outdoor Track & Field Championships would be hosted by Lincoln University May 2-4, 2014. Mr. Hilpert also informed the Committee that there would be no State Revolving Fund money available this year for the wastewater program, so it was probable that there would be discussions of obtaining funds through a conventional bond issue. The next item on the agenda was Old Business. Ms. Pearre updated the Committee on the status of the audit and of CAFR preparation. A motion to adjourn was made by Councilman Prather and seconded by Councilman Graham. The meeting adjourned. As recorded by: Shiela Pearre, Chief Accountant REVENUE MODEL REPORT (SUMMARY) For Period Ending March 31, 2014 Data as of 4-02-14 for period ending 3-31-14 **Includes April 2014 actual sales tax receipts amount February 2014 CFY 2014 YTD Actual Projected Over/ Projected Over/ Description Budget As of 3-31-14 (Under)Budget (Under)Budget Diff Sales Tax and Use Tax $ 9,640,000.00 $ 3,188,954.91 ** $ (64,420.09) $ (24,465.09) $ (39,955.00) Intergovernmental Taxes $ 2,080,000.00 $ 379,341.98 $ 26,447.13 $ 19,311.66 $ 7,135.47 Other Taxes $ 120,000.00 $ 38,422.12 $ 7,140.52 $ 8,013.32 $ (872.80) Franchise & Utility Tax $ 7,040,000.00 $ 2,495,548.53 $ 236,642.87 $ 163,813.07 $ 72,829.80 Property Taxes $ 5,209,000.00 $ 5,059,463.18 $ 28,188.33 $ 115,063.90 $ (86,875.57) Intergovernmental $ 6,610.00 $ 6,610.00 $ - $ - $ - Charges for Services $ 2,082,965.63 $ 1,560,270.33 $ (18,467.34) $ (34,092.92) $ 15,625.58 Fees, Licenses, & Permits $ 713,600.00 $ 226,514.86 $ (32,242.94) $ (51,349.95) $ 19,107.01 Fines & Forfeitures $ 1,009,980.00 $ 404,861.70 $ (41,494.36) $ (31,458.04) $ (10,036.32) Contributions/Donations $ 117,740.00 $ 38,840.74 $ 11,923.81 $ 10,797.81 $ 1,126.00 Other Operating Revenues $ 44,000.00 $ 12,666.18 $ (7,500.20) $ (2,454.16) $ (5,046.04) Interest Income $ 65,000.00 $ 22,728.15 $ 5,597.39 $ 5,597.39 $ - Other Non Operating Revenue $ 20,000.00 $ - $ (6,417.77) $ (6,417.77) $ (0.00) Operating Transfers In $ 21,940.00 $ 7,542.54 $ 403.65 $ 231.27 $ 172.38 Totals $ 28,170,835.63 $ 13,441,765.22 $ 145,801.00 $ 172,590.49 (26,789.49) **Includes April 2014 actual sales tax receipts amount CFY2014 Revenue Model Report (Detail) For Period Ending March 31, 2014 Description Sales Tax and Use Tax 10-100-400010 Sales Tax (Inc. March Actual) 10-100-000020 Sales Tax Interest Intergovernmental Taxes 10-100401030 Motor Vehicle Sales Tax 10-100403010 Gasoline Tax 10-10D430080 Road & Bridge Tax Other Taxes 30-100-403020 Cig Tax Franchise& -Utility Tax 10.100-410020 Electric Utility Uc Tax 10-100-410030 Gas Utility License Tax 10-100410052 Telephone Cell w/o audit money IG.1DD-410053 Telecom Audit 10-1004100670 Cable F-chise Fee 10-100-410061 Cable Auidt Property Taxes 10-100-420010 Current Property Tax 10-100-420020 Del Property Tax 10-100-420040 Fin Institution Tax 10-100-420050 Prop Tax Int & Penalties 10-100-420055 Surtax Receipts -County Reimb 30-100-420060 Surtax Receipts 10-100-420080 Special Tax Rev Intergovernmental 3,188,954.91 10-100-430100 State DNR Historic Pres 10-100-480020 NSP Rehab Sales 10-100-480025 HUD Program Income Charges for Services 10-100-440010 Admin Charge Backs 10-100-440050 Emt Reimbursement 10-100-440210 Street Cuts 30-100-440910 Fuel Charge - backs 10-100-440920 Parts Charge backs 10-100-440930 labor Charge backs 10-100-481020 Cole Cry Animal Rescue 10-100-481030 Rent City Hall/annex 10-100-481040 Rent Other 30-100-481045 Rent -tower Sites 10-100-481075 Cole Cry 911 Reimb 10-100-481080 Sale Of Maps/gis Data Remaining Start Initial Estimated YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Month Budget Revenue Asof3-31-14 4-14 thru 10-14 TOTAL (Under)Budget of Formulas 2 9,640,000.00 9,640,000.00 3,188,954.91 6,386,625.00 9,575,579.91 (64,420.09) (64,420.09) 0100 0,00 _090_ 090 0_00 ➢ND. 9,640,000.00 3,188,954.91 6,386,625.00 9,575,579.91 (64,420.09) (64.420.09) 2 430,000.00 450,469.49 112,870.79 360,043.36 472,914.15 42,914.14 4;914.14 2 1,100,000.00 1,095,781.10 266,471.19 828,822.80 1,095,293.99 (4,706.01) 14,706.01) 0 550,000.00 550,000.00 0.00 538,239.0 538.239.00 111,761.001 111,76LOO 2,080,000.00 379,341.98 1,727,105.15 2,106,447.13 26,447.13 z6,a47.v 1 120,000.00 131,715.76 38.422.12 88.718.40 127.140.52 71� 40.52 71� ao.sz 120,000.00 38,422.12 88,718.40 127,140.52 7,140.52, 7,140.52 1 3,220,000.00 3,422,802.04 1,069,756.53 2,525,960.51 3,595,717.04 375,717.04 375,717.oa 1 925,000.00 908,060.23 584,693.80 426,684.14 1,011,377.94 86,377.94 86.3n.64 1 2,450,000.00 2,383,173.00 763,271.07 1,574,280.90 2,337$5197 (112,448.03) Wz44s.03) 110,000.00 (15,591.56) 0.00 (15,591.56) (125,591.56) 1-.11116) R/1 335,000.00 337,942.30 89,418.69 254,168.79 343,587.48 8,587.48 8$87.48 $ $ 4,000.00 $ $ 4,000.00 $ 4,000.00 5 4,000.00 7,040,000.00 2,495,548.53 4,781,094.34 7,276,642.87 236,642.87 -.W- 0 4,600,000.00 4,570,217.73 4,447,646.06 102,504.96 4,550,151.02 (49,848.98) 149,a4s.9a) 0 40,000.00 64,812.15 24,759.64 30,516.36 55,276.00 15,276.00 15,276.00 0 10,000.00 16,519.75 41,534.94 1,175.25 42,710.19 32,710.19 32,730.19 0 20,000.00 29,246.15 9,374.83 19,909.35 29,284.18 9,284.18 9,z84.ie 0 54,000.00 54,399.28 54,399.28 0.00 54,399.28 399.28 a99.za 0 470,000.00 471,744.89 465,295.38 12,155.75 477,451.13 7,451.13 7,4s1.13 2 150. 00.00 27,359.89 16.453.05 114. 63.49 27.916.54 12,916.S4 12_a16 5,209,000.00 5,059,463.18 177,725.16 5,237,188.34 28,188.33 18,188.33 0 0.00 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 6,610.0 10.00 6,610.00 6,610.0 0 0.00 6 610.00 0.00 2.00 6,610.00 6,610.00 0.00 6,610.00 0.00 2.00 0 1,225,559.00 1,225,559.00 1,225,559.00 0.00 1,225,559.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0.00 0.00 0 25,000.00 25,411.50 11,926.00 13,21500 25,141.00 141.00 ULM 0 0.00 7,178.34 0.00 7,178.34 7,178.34 7,178.34 0 91,600.00 84,442.07 51,272.40 50,975.04 102,247.44 10,647.44 10,647.44 0 137,400.00 124,065.41 45,896.46 79,483.71 125,380.17 (12,019.83) 112,010831 0 100,000.00 25,000.00 75,000.00 100,000.00 0.00 2.22 0 6,500.00 6,500.00 0.00 6,500.00 0.00 0.22 0 12,000.00 0.00 12,000.00 12,000.00 0.00 U. 1 80,000.00 29,677.50 55,360.85 85,038.35 5,038.35 5,038.35 0 358,228.63 149,230.63 208,043.36 357,273.99 (954.64) 1a54.64) 0 0.00 140.00 0.00 140.00 140.00 140.02 CFY2014 Revenue Model Report (Detail) Remaining For Period Ending March 31, 2014 Start Initial Estimated YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Month Budget Revenue As of3-3144 4-14 thru 10-14 TOTAL (Under)Budget of Formulas 10-100-481085 Cole Cty Gis Joint Coop 0 15,000.00 6,250.00 8,750.00 15,000.00 0.00 0.00 10-100-481090 Cole Cry Sheriff -New World 0 28,678.00 0.00 0.00 0.00 (28,678.00) 128,6x8.00) 10-100-481100 Sale Of Grave Sites 0 3,000.00 1,600.00 1,400.00 3,000.00 0.00 0.00 10-100-481110 Long &Short 0 0.00 4040-00 0.00 40_00 40.00 ao_oo 2,082,965.63 1,560,270.33 504,227.96 .2,064,498.29 (18,467.34) ([.,46x.347 Fees, Licenses, & Permits - - - -- 10-100-450010 Liquor Licenses 0 65,000.00 64,405.00 8,327.50 59,667.50 67,995.00 2,995.00 2,9%.60 10-100-450020 Business Licenses 0 205,000.00 216,000.00 91,905.89 127,337.39 219,243.28 14,243.28 14,2a3.ze 10-100-450021 Home Occupation Permit 0 1,500.00 1,666.00 728.00 766.00 1,494.00 (6.00) ('eo) 10-100-450030 Solicitors Lic 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg. Reg 0 0.00 44.00 0100 44.00 44.00 a4.a0 30-100-450041 Abandoned Bldg. Admin Fee 0 0.00 3,864.17 0.00 3,864.17 3,864.17 3,864.17 10-100-450045 Bldg. Constr Fees 0 200,000.00 129,807.55 41,174.86 89,227.26 130,402.12 (69,597.88) (69,597.881 10 -IDD -450050 Electrical Cartlflcates 0 16,000.00 16,398.00 14,252.00 2,563.00 16,815.00 815.00 815.00 30-100-450060 Electrical Permits 0 2,500.00 4,592.37 1,222.98 3,061.05 4,284.03 1,784.03 1,7e4.93 10-100-450070 Plumbing Licenses 0 10,000.00 10,384.00 10,680.00 1,724.00 12,404.00 2,404.00 z,4w.00 10-100-4SO080 Plumbing Permits 0 5,000.00 5,937.50 2,152.25 3,383.75 5,536.00 536.00 536.4 30-100-450090 Other Lic&Peonies 0 1,500.00 2,597.19 2,382.78 777.69 3,160.47 1,660.47 ;660.47 10-100-450091 Day Care Inspection Fees 0 8,000.00 8,515.00 1,530.00 7,225.00 8,755.00 755.00 11s.00 10-100-450092 Food Inspection Fees 0 88,000.00 86,739.25 4,889.33 85,672.37 90,561.70 2,561.70 ;561.78 10-100-450100 Curb Cut Permits 0 1,500.00 1,518.00 52.00 1,268.00 1,320.00 (180.00) (>e0.00) 10-100-450110 Board Of Ad)Fees 0 1,200.00 824.00 0.00 824.00 (376.00) 1376001 10-100-450120 Sign Permits 0 4,000.00 5,240.00 1,332.00 4,220.00 5,552.00 1552.00 L55mo 10-100-450130 Demolition Permits 0 500.00 916.00 260.00 666.00 926.00 426.00 426.00 10-100-450150 Ace Rep Fees -police 0 12,000.00 12,387.67 4,779.10 7,289.20 12,068.30 68.30 se - 10 -100-450160 Accrpt/blastg P-flre 0 500.00 793.50 359.00 532.00 891,00 391.00 39LOe 10-100-450170 Animal Redemption Fees 0 53,000.00 52,360.00 19,615.00 32,437.50 52,052.50 (947.50) (.'so) 10-100-450180 Animal Vaccinations Fees 0 4,500.00 5,140.00 1,800.00 3,375.00 5,175.00 675.00 67so. 30-100-450185 Animal Cremation Fees 0 20,000.00 23,665.00 8,612.00 14,281.50 22,893.50 2,893.50 z,es3.s0 10-100-450186 Animal Boarding Fees 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 0 500.00 500.00 0.00 450.00 450.00 (SOHO) ('0.00) 10-100-450230 Vacating Right Of Way 0 400.00 315.00 390.00 215.00 605.00 205.00 205.00 10-100-450250 Rezoning Request 0 10,000.00 11,651.00 4,903.00 7,728.00 12,631.00 2,631.00 ;63100 10-100-450260 Non-refundable Plans/spec 0 33,000.00 2,727.25 435.00 975.00 1,410.00 1590.00 (590.00 713,600.00 226,514.86 454,842.20 681,357.06 (32,242.94) 132,2.2941 Fines & Forfeitures 10-100-460010 Court Cost 0 80,000.00 82,550.20 29,174.64 47,393.28 76,567.92 (3,432.08) 13,4320e) 30-100-460015 Court Restitutions 0 1,300.00 1,986.90 387.40 1,165.89 1,553.29 253.29 253.x9 10-100-460018 Inmate Security Fund 0 12,080.00 13,155.29 4,649.20 7,638.38 12,287.58 207.58 207.58 10-100-460020 Jail Cost Recovery 0 10,000.00 11,661.07 3,926.81 5,615.65 9,542.46 (457.55) (457.55) 10-100-460025 Alcohol Offense Cost Rec 0 10,000.00 9,810.00 3,778.00 5,679.00 9,457.00 (543.00) 15.3.00) 10-100-460030 Pol Fines -traffic 0 850,000.00 836,16254 329,461.15 487,373.46 816,834.61 (33,165.40) (33,165.40) 30-100-460040 Pol Tickets -parking 0 1,000.00 0.00 0.00 0.00 (1,000.00) µ,0o0.00) 10-100-460050 Pal fines - Other 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460060 Dog Fines 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460070 P & Code Violations o 0.00 0.00 0.00 0.00 0.00 a.00 10-100-460090 Parking Fines 0 58,600.00 41,650.35 38,474.86 18,420.08 56,894.94 (1,705.06) 11.7os.as) CFY2014 Revenue Model Report (Detail) 0 0.00 0.00 Remaining 0.00 0.00 0.00 For Period Ending March 31, 2014 Start 0.00 Initial Estimated YTD Actual Esthnated Revenues Actual & Estimated Projected Over/ Verification Descrlptlon Month Budget Revenue As of3-31-14 4-14 thru 10-14 TOTAL (Under)Budget of Formulas 10-500-460100 Bankcard Charges 0 (13,000.00) (13,843.12) 4990.36 9661.78 (14,652.14) 1652.14 r6s2.r4 30-100-481077 Insurance Claims 0 1,009,980.00 12,098.45 404,861.70 563,623.95 968,485.65 (41,494.36) in i,:5a36i Contributions/ Donations 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-430055 DARE Contri 0 0.00 0.00 0.00 0.00 0.00 0c0 10-100-480010 Citizen Participation 0 0.00 475.00 0.00 475.00 475.00 41s.o6 10-100-480015 Sidewalk Waiver Revenue 0 0.00 65,000.00 0.00 0.00 0.00 0.00 0.a6 10-100-480030 Donations -Recycling 0 0.00 0.00 0.00 0.00 0.00 0.c0 10-100-480050 Sober Driver Program 0 6,040.00 1,040.00 5,000.00 6,040.00 0.00 0.c0 10-100-480055 JC Fire Museum 0 0.00 7,324.50 0.00 7,324.50 7,324.50 7,3z4.s0 10-100-480063 Private Dona tions -Cultural Art 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0 0.00 20,000.00 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 0 700.00 700.00 0.00 700.00 0.00 eco 10-100-480080 Dare Donations 0 500.00 500.00 0.00 500.00 0.00 ete 10-100-480090 Police K-9 Donations 0 500.00 500.00 0.00 500.00 0.00 0.00 10-100-480165 Animal S Donations 0 0.00 19,930.23 672.00 0.00 672.00 672.00 677.00 10-100-481050 Transfer Stn/Ping-Sid Wst Cntr 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair -Solid Waste Cntr 0 110,000.00 27,466.44 85,823.07 113,28951 3,289.51 3,389.5] 30-100-481095 Cemetery Donations 0 0.00 0.00 0.00 0.00 0.00 0.00 30-100-486070 Cap Comr-neighorhood Imp Pro 0 0_00 162.80 0_00 162.80 162.80 tsz.s0 10-100-490620 Transfer from Parking Fund 0 117,740.00 38,840.74 90,823.07 129,663.81 11,923.81 tt,s73.at Other Operating Revenues 30-100-450187 Special Sri Program 0 0.00 0.00 0.00 0.00 0.00 0.00 30-100-450188 Adoption Voucher Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481070 Miscellaneous 0 24,000.00 27,535.59 12,316.18 17,401.01 29,717.19 5,717.19 1,7z7.ts 10-100-481072 TIF Prof Svcs Deposit 0 0.00 0.00 0.00 0.00 0.00 0.00 30-100-481077 Insurance Claims 0 20,000.00 12,098.45 350.00 6,432.61 6,782.61 (13,217.39) p"", 3e) 10-100-481078 Cafeteria Refunds 0 0.00 0.00 0.00 0.00 0.00 0.00 44,000.00 12,666.18 23,833.62 36,499.80 (7,500.20) (1,50 20) Interest Income 10-100-470010 Interest 0 65,000.00 65,000.00 22,728.15 47,869.24 70,597.39 5,597.39 5,sw,s 10-100-470051 Unrealized Gains and Losses 0 0.00 0.00 0_00 0_00 0_00 0_a0 65,000.00 22,728.15 47,869.24 70,597.39 5,597.39 s,6 39 Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets 0 0.00 0.00 0.00 0.D0 0.00 0.00 10-100-485050 Sale Of Assets 0 20.000.00 20,000.00 0_00 13,582.23 13,582.23 (6,417.77)cpu.n 20,000.00 0.00 13,582.23 13,582.23 (6,417.77) 16,4v.n1 Operating Transfers In 30-100-490193 Trsfer From Grant Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 0 21,940.00 19,930.23 7,542.54 14,801.11 22,343.65 403.65 403.0 10-100-490260 Trsfrfrom Fireman's Spec Rev 0 0.00 0.00 0.00 0.00 0.00 eeo 10-100-490280 Trnffrom Stoneridge TDD 0 0.00 -0.00 0.00 0.00 0.00 a.aa 10-100-490353 Transfer From Cit"e" 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490600 Transferfrom Water Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0 0_00 0_00 0_00 0_00 0.00 0.00 21,940.00 7,542.54 14,801.11 22,343.65 403.65 403.65 28,170,835.63 13,441,765.22 14,874,871.41 28,316,636.63 145,801.00 145,801.00 Memo To:Steve Crowell From:Shiela Pearre Date:April 7, 2014 Re:Sales Tax Revenues The City received the April 1% Sales Tax in the amount of $737,469 which is $39,955 less than projected for April. January thru April shortage is $64,421 (0.67%) in the General Fund. 1% General Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $764,659 $741,056 ($23,603) Dec-13 Feb-14 $703,181 $789,830 $86,649 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $1,008,111 $920,599 ($87,512) Feb-14 Apr-14 $777,424 $737,469 ($39,955) Mar-14 May-14 $537,141 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $1,023,015 May-14 Jul-14 $872,436 Jun-14 Aug-14 $546,351 Jul-14 & Apr-June 14 Qtrly Sep-14 $1,096,581 Aug-14 Oct-14 $717,262 Sep-14 Nov-14 $677,366 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $916,473 Total Overage/Shortfall ($64,421) 1/2% Capital Improvement Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $416,244 $359,800 ($56,444) Dec-13 Feb-14 $311,418 $394,475 $83,057 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $471,169 $423,641 ($47,528) Feb-14 Apr-14 $413,147 $348,172 ($64,975) Mar-14 May-14 $266,340 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $499,328 May-14 Jul-14 $393,021 Jun-14 Aug-14 $280,801 Jul-14 & Apr-June 14 Qtrly Sep-14 $508,966 Aug-14 Oct-14 $370,760 Sep-14 Nov-14 $268,825 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $499,981 Total Overage/Shortfall ($85,890) 1/2% Parks Sales Tax Receipt Budget Actual Period Projection Receipts Variance Nov-13 Jan-14 $372,447 $359,708 ($12,739) Dec-13 Feb-14 $350,714 $393,562 $42,848 Jan-14 & Oct-Dec 13 Qtrly Mar-14 $475,026 $423,546 ($51,480) Feb-14 Apr-14 $372,242 $348,076 ($24,166) Mar-14 May-14 $266,456 Apr-14 & Jan-Mar 14 Qtrly Jun-14 $482,382 May-14 Jul-14 $425,194 Jun-14 Aug-14 $272,321 Jul-14 & Apr-June 14 Qtrly Sep-14 $521,155 Aug-14 Oct-14 $357,482 Sep-14 Nov-14 $323,768 Oct-14 & Jul-Sept 14 Qtrly Dec-14 $419,277 Total Overage/Shortfall ($45,538) Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 4/7/2014 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: APRIL 2014 Account Number 10-100-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 787,676 928,460 809,385 843,061 764,659 741,056 act.826,648 Dec February 572,813 631,137 833,919 619,287 703,181 789,830 act.672,067 Jan & Oct-Dec Qtrly March 1,079,246 894,158 589,958 992,559 1,008,111 920,599 act.912,806 Feb April 763,906 774,964 978,391 852,653 777,424 737,469 act.829,468 Mar May 516,016 592,657 633,676 530,069 537,141 537,141 est.561,912 Apr & Jan-Mar Qtrly June 934,660 843,712 925,555 1,028,514 1,023,015 1,023,015 est.951,091 May July 686,153 939,495 955,495 797,785 872,436 872,436 est.850,273 Jun August 526,097 495,667 566,299 557,032 546,351 546,351 est.538,289 Jul & Apr-Jun Qtrly September 1,006,120 1,040,156 1,032,258 1,069,414 1,096,581 1,096,581 est.1,048,906 Aug October 718,480 822,163 797,510 769,129 717,262 717,262 est.764,909 Sept November 554,824 482,807 536,185 615,421 677,366 677,366 est.573,321 Oct & Jul-Sept Qtrly December 801,780 881,780 1,032,046 982,684 932,387 916,473 est.926,135 Actual to Date $ 8,947,771 $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 3,188,955 Estimated to Fiscal Year end (based on averages and on Budgeted amount)6,386,625 Total Actual & Estimated $ 9,575,579 Less: Budget 9,640,000 Over (Under) Budget -$ 64,421 $ 741,056.45 $ 1,530,886.91 $ 2,451,485.95 $ 3,188,954.82 $ 764,659.19 $1,467,840.39 $2,475,951.79 $3,253,375.33 $3,790,516.42 $4,813,531.75 $5,685,967.41 $6,232,318.77 $7,328,899.63 $8,046,161.24 $8,723,526.86 $9,640,000.00 $ 500,000.00 $ 750,000.00 $ 1,000,000.00 $ 1,250,000.00 $ 1,500,000.00 $ 1,750,000.00 $ 2,000,000.00 $ 2,250,000.00 $ 2,500,000.00 $ 2,750,000.00 $ 3,000,000.00 $ 3,250,000.00 $ 3,500,000.00 $ 3,750,000.00 $ 4,000,000.00 $ 4,250,000.00 $ 4,500,000.00 $ 4,750,000.00 $ 5,000,000.00 $ 5,250,000.00 $ 5,500,000.00 $ 5,750,000.00 $ 6,000,000.00 $ 6,250,000.00 $ 6,500,000.00 $ 6,750,000.00 $ 7,000,000.00 $ 7,250,000.00 $ 7,500,000.00 $ 7,750,000.00 $ 8,000,000.00 $ 8,250,000.00 $ 8,500,000.00 $ 8,750,000.00 $ 9,000,000.00 $ 9,250,000.00 $ 9,500,000.00 $ 9,750,000.00 $ 10,000,000.00 $ 10,250,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 4/7/2014 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: APRIL 2014 Account Number 44-100-400010 F - effective 4/1/12 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,327 455,480 396,799 412,434 372,459 359,800 act.404,300 Dec February 286,909 313,836 407,407 308,567 350,813 394,475 act.333,506 Jan & Oct-Dec Qtrly March 505,185 415,473 280,758 466,856 475,110 423,641 act.428,677 Feb April 365,514 370,473 452,824 409,365 372,340 348,172 act.394,103 Mar May 257,313 295,545 315,165 263,902 266,422 266,340 est.279,669 Apr & Jan-Mar Qtrly June 453,788 400,667 439,298 494,757 483,070 499,328 est.454,316 May July 326,501 462,244 468,643 389,423 425,325 393,021 est.414,427 Jun August 261,707 247,260 282,859 278,231 272,603 280,801 est.268,532 Jul & Apr-Jun Qtrly September 481,799 495,398 482,244 504,307 521,260 508,966 est.497,002 Aug October 348,002 395,058 382,206 367,366 357,619 370,760 est.370,050 Sept November 276,487 240,417 266,364 306,968 323,871 268,825 est.282,821 Oct & Jul-Sept Qtrly December 384,320 428,058 495,406 469,095 443,688 499,981 est.444,113 Actual to Date $ 4,331,852 $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 1,526,088 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,088,022 Total Actual & Estimated $ 4,614,110 Less: Budget 4,700,000 Over (Under) Budget -$ 85,890 $ 359,799.94 $ 754,275.37 $ 1,177,916.24 $ 1,526,088.37 $ 416,244.00 $727,662.00 $1,198,831.00 $1,611,978.00 $1,878,318.00 $2,377,646.00 $2,770,667.00 $3,051,468.00 $3,560,434.00 $3,931,194.00 $4,200,019.00 $4,700,000.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 4/7/2014 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: APRIL 2014 Account Number 21-210-400010 Monthly REPORTING PERIOD RECEIPT PERIOD 2009 2010 2011 2012 2013 2014 Average Nov January 384,305 455,442 396,815 405,730 372,447 359,708 act.402,948 Dec February 286,889 313,792 407,348 308,456 350,714 393,562 act.333,440 Jan & Oct-Dec Qtrly March 507,768 415,275 280,734 466,713 475,026 423,546 act.429,103 Feb April 365,727 370,308 452,735 409,353 372,242 348,076 act.394,073 Mar May 256,675 295,529 315,030 263,822 266,456 266,456 est.279,502 Apr & Jan-Mar Qtrly June 453,016 400,500 439,265 494,733 482,382 482,382 est.453,979 May July 326,518 461,255 468,387 389,006 425,194 425,194 est.414,072 Jun August 261,622 247,216 282,836 278,072 272,321 272,321 est.268,413 Jul & Apr-Jun Qtrly September 481,772 495,222 482,150 505,913 521,155 521,155 est.497,242 Aug October 347,721 395,014 382,115 366,846 357,482 357,482 est.369,836 Sept November 275,469 240,348 264,735 306,831 323,768 323,768 est.282,230 Oct & Jul-Sept Qtrly December 384,300 428,200 495,305 468,924 443,569 419,277 est.444,060 Actual to Date $ 4,331,782 $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 1,524,892 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,068,035 Total Actual & Estimated $ 4,592,927 Less: Budget 4,638,464 Over (Under) Budget -$ 45,537 $ 359,708.18 $ 753,270.03 $ 1,176,815.59 $ 1,524,891.51 $ 372,447.00 $723,161.00 $1,198,187.00 $1,570,429.00 $1,836,885.00 $2,319,267.00 $2,744,461.00 $3,016,782.00 $3,537,937.00 $3,895,419.00 $4,219,187.00 $4,638,464.00 $ 100,000.00 $ 350,000.00 $ 600,000.00 $ 850,000.00 $ 1,100,000.00 $ 1,350,000.00 $ 1,600,000.00 $ 1,850,000.00 $ 2,100,000.00 $ 2,350,000.00 $ 2,600,000.00 $ 2,850,000.00 $ 3,100,000.00 $ 3,350,000.00 $ 3,600,000.00 $ 3,850,000.00 $ 4,100,000.00 $ 4,350,000.00 $ 4,600,000.00 $ 4,850,000.00 $ 5,100,000.00 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 04/07/14 08:52:08 Period 01 - 13 Fiscal Year 2014 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,640,000.00 2,451,485.95 0.00 7,188,514.05 74.57 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,640,000.00 2,451,485.95 0.00 7,188,514.05 74.57 10-100-401030 Motor Vehicle Tax 430,000.00 112,870.79 0.00 317,129.21 73.75 10-100-403010 Gasoline Tax 1,100,000.00 266,471.19 0.00 833,528.81 75.78 10-100-430080 Road & Bridge Tax 550,000.00 0.00 0.00 550,000.00 100.00 R16 Intergovernmental Taxes 2,080,000.00 379,341.98 0.00 1,700,658.02 81.76 10-100-403020 Cigarette Tax 120,000.00 38,422.12 0.00 81,577.88 67.98 R20 Other Taxes 120,000.00 38,422.12 0.00 81,577.88 67.98 10-100-410020 Electric Utility Lic Tax 3,220,000.00 1,069,756.56 0.00 2,150,243.44 66.78 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 925,000.00 584,693.80 0.00 340,306.20 36.79 10-100-410031 Gas Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410050 INACTIVE - Phone Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410051 INACTIVE - Cell Utility Tax 0.00 0.00 0.00 0.00 0.00 10-100-410052 TelephoneCell Utility Tax 2,450,000.00 763,271.07 0.00 1,686,728.93 68.85 10-100-410053 TelephoneCell Utility-AUDIT 110,000.00 -15,591.56 0.00 125,591.56 114.17 10-100-410060 Cable Franchise Fee 335,000.00 89,418.69 0.00 245,581.31 73.31 10-100-410061 Cable Utility-AUDIT 0.00 4,000.00 0.00 -4,000.00 0.00 R30 Franchise & Utility Tax 7,040,000.00 2,495,548.56 0.00 4,544,451.44 64.55 10-100-420010 Cur Property Tax 4,600,000.00 4,447,766.40 0.00 152,233.60 3.31 10-100-420020 Del Property Tax 40,000.00 24,759.64 0.00 15,240.36 38.10 10-100-420040 Fin Inst Tax 10,000.00 41,534.94 0.00 -31,534.94 -315.35 10-100-420050 Prop Tax Int & Penalties 20,000.00 9,382.21 0.00 10,617.79 53.09 10-100-420055 Surtax Receipts - County Reimb 54,000.00 54,399.28 0.00 -399.28 -0.74 10-100-420060 Surtax Receipts 470,000.00 465,295.38 0.00 4,704.62 1.00 10-100-420080 Special Tax Rev 15,000.00 16,453.05 0.00 -1,453.05 -9.69 R40 Property Taxes 5,209,000.00 5,059,590.90 0.00 149,409.10 2.87 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 746.77 0.00 -746.77 0.00 10-100-430060 Drug Forfeiture 0.00 3,823.92 0.00 -3,823.92 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 6,610.00 6,610.00 0.00 0.00 0.00 R50 Intergovernmental 6,610.00 11,180.69 0.00 -4,570.69 -69.15 10-100-440010 Admin Charge Backs 1,225,559.00 1,225,559.00 0.00 0.00 0.00 10-100-440050 Emt Reimbursement 0.00 0.00 0.00 0.00 0.00 10-100-440210 Street Cuts 25,000.00 11,926.00 0.00 13,074.00 52.30 10-100-440910 Fuel Charge-backs 0.00 7,178.34 0.00 -7,178.34 0.00 10-100-440920 Parts Charge-back 91,600.00 62,218.95 0.00 29,381.05 32.08 10-100-440930 Labor Charge-backs 137,400.00 58,084.82 0.00 79,315.18 57.73 10-100-450189 Animal Shelter Bricks 0.00 100.00 0.00 -100.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 25,000.00 0.00 75,000.00 75.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 29,677.50 0.00 50,322.50 62.90 10-100-481075 Cole Cty 911 Reimb 358,228.63 149,230.63 0.00 208,998.00 58.34 10-100-481080 Sale Of Mapsgis Data 0.00 140.00 0.00 -140.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 6,250.00 0.00 8,750.00 58.33 10-100-481090 Cole Cty Sheriff-New World 28,678.00 0.00 0.00 28,678.00 100.00 10-100-481100 Sale Of Grave Sites 3,000.00 1,600.00 0.00 1,400.00 46.67 10-100-481110 Long & Short 0.00 40.00 0.00 -40.00 0.00 R60 Charges for Services 2,082,965.63 1,583,505.24 0.00 499,460.39 23.98 10-100-450010 Liquor Licenses 65,000.00 17,367.50 0.00 47,632.50 73.28 10-100-450020 Business Licenses 205,000.00 94,016.36 0.00 110,983.64 54.14 10-100-450021 Home Occupation Permit 1,500.00 832.00 0.00 668.00 44.53 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 44.00 0.00 -44.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 0.00 3,864.17 0.00 -3,864.17 0.00 10-100-450045 Bldg Constr Fees 200,000.00 42,504.86 0.00 157,495.14 78.75 10-100-450050 Electrical Certificates 16,000.00 14,252.00 0.00 1,748.00 10.93 10-100-450060 Electrical Permits 2,500.00 1,296.48 0.00 1,203.52 48.14 10-100-450070 Plumbing Licenses 10,000.00 10,908.00 0.00 -908.00 -9.08 10-100-450080 Plumbing Permits 5,000.00 2,192.25 0.00 2,807.75 56.16 10-100-450090 Other Lic & Permits 1,500.00 2,485.78 0.00 -985.78 -65.72 10-100-450091 Day Care Inspection Fees 8,000.00 1,530.00 0.00 6,470.00 80.88 10-100-450092 Food Inspection Fees 88,000.00 4,941.33 0.00 83,058.67 94.38 10-100-450100 Curb Cut Permits 1,500.00 52.00 0.00 1,448.00 96.53 10-100-450110 Board Of Adj Fees 1,200.00 824.00 0.00 376.00 31.33 10-100-450120 Sign Permits 4,000.00 1,395.00 0.00 2,605.00 65.13 10-100-450130 Demolition Permits 500.00 364.00 0.00 136.00 27.20 10-100-450150 Acc Rep Fees-police 12,000.00 4,994.10 0.00 7,005.90 58.38 10-100-450160 Accrptblastg P-fire 500.00 359.00 0.00 141.00 28.20 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450170 Animal Redemption Fees 53,000.00 20,330.00 0.00 32,670.00 61.64 10-100-450180 Animal Vaccinations Fees 4,500.00 1,875.00 0.00 2,625.00 58.33 10-100-450185 Animal Cremation Fees 20,000.00 8,612.00 0.00 11,388.00 56.94 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 500.00 0.00 0.00 500.00 100.00 10-100-450230 Vacating Right Of Way 400.00 390.00 0.00 10.00 2.50 10-100-450250 Rezoning Request 10,000.00 4,955.00 0.00 5,045.00 50.45 10-100-450260 Non-refundable Plansspec 3,000.00 615.00 0.00 2,385.00 79.50 R65 Fees Licenses & Permits 713,600.00 240,999.83 0.00 472,600.17 66.23 10-100-460010 Court Cost 80,000.00 30,997.44 0.00 49,002.56 61.25 10-100-460015 Court Restitutions 1,300.00 387.40 0.00 912.60 70.20 10-100-460018 Inmate Security Fund 12,080.00 4,900.32 0.00 7,179.68 59.43 10-100-460020 Jail Cost Recovery 10,000.00 5,253.11 0.00 4,746.89 47.47 10-100-460025 Alcohol Offense Cost Rec 10,000.00 4,008.00 0.00 5,992.00 59.92 10-100-460030 Pol Fines-traffic 850,000.00 347,789.53 0.00 502,210.47 59.08 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 38,769.86 0.00 19,830.14 33.84 10-100-460100 Bankcard Charges -13,000.00 -6,183.34 0.00 -6,816.66 52.44 R70 Fines & Forfeitures 1,009,980.00 425,922.32 0.00 584,057.68 57.83 10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0.00 475.00 0.00 -475.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 6,040.00 1,980.00 0.00 4,060.00 67.22 10-100-480055 JC Fire Museum 0.00 7,324.50 0.00 -7,324.50 0.00 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 700.00 700.00 0.00 0.00 0.00 10-100-480080 Dare Donations 500.00 500.00 0.00 0.00 0.00 10-100-480090 Police K-9 Donations 500.00 500.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 865.00 0.00 -865.00 0.00 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 27,466.44 0.00 82,533.56 75.03 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 162.80 0.00 -162.80 0.00 R72 ContributionsDonations 117,740.00 39,973.74 0.00 77,766.26 66.05 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-481070 Miscellaneous 24,000.00 12,396.27 0.00 11,603.73 48.35 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 10-100-481077 Insurance Claims 20,000.00 350.00 0.00 19,650.00 98.25 10-100-481078 Cafeteria Refunds 0.00 0.00 0.00 0.00 0.00 R75 Other Operating Revenues 44,000.00 12,746.27 0.00 31,253.73 71.03 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-470010 Interest 65,000.00 34,903.25 0.00 30,096.75 46.30 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 65,000.00 34,903.25 0.00 30,096.75 46.30 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 20,000.00 0.00 0.00 20,000.00 100.00 R85 Other Non-Operating Revenue 20,000.00 0.00 0.00 20,000.00 100.00 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 21,940.00 9,383.57 0.00 12,556.43 57.23 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 21,940.00 9,383.57 0.00 12,556.43 57.23 10-100-495995 Transfer From(to) Surplus 219,573.41 0.00 0.00 219,573.41 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 219,573.41 0.00 0.00 219,573.41 100.00 100 Revenue 28,390,409.04 12,783,004.42 0.00 15,607,404.62 54.97 149 Entitlement Grant 10-149-430010 Federal Grants 675,652.74 35,577.68 0.00 640,075.06 94.73 10-149-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-149-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 675,652.74 35,577.68 0.00 640,075.06 94.73 149 Entitlement Grant 675,652.74 35,577.68 0.00 640,075.06 94.73 185 Non-Departmental 10-185-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-185-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-185-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 0.00 0.00 0.00 0.00 0.00 300 Police Department 10-300-430010 Federal Grants 286,113.85 3,961.72 0.00 282,152.13 98.62 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 26,453.69 0.00 -26,453.69 0.00 10-300-430074 Overtime Reimb 57,755.60 9,313.97 0.00 48,441.63 83.87 R50 Intergovernmental 343,869.45 39,729.38 0.00 304,140.07 88.45 300 Police Department 343,869.45 39,729.38 0.00 304,140.07 88.45 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-310-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-310-430040 Local Grants 184,966.60 184,966.60 0.00 0.00 0.00 R50 Intergovernmental 184,966.60 184,966.60 0.00 0.00 0.00 310 School Resource Officer 184,966.60 184,966.60 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 0.00 6,806.58 0.00 -6,806.58 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 6,806.58 0.00 -6,806.58 0.00 320 M.U.S.T.A.N.G.0.00 6,806.58 0.00 -6,806.58 0.00 400 Fire Department 10-400-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 400 Fire Department 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 148,200.00 25,955.38 0.00 122,244.62 82.49 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 9,262.50 3,173.47 0.00 6,089.03 65.74 R50 Intergovernmental 157,462.50 29,128.85 0.00 128,333.65 81.50 522 Plan & Protect Svcs-MPO 157,462.50 29,128.85 0.00 128,333.65 81.50 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 1,374,095.19 225,844.37 0.00 1,148,250.82 83.56 10-530-430020 State Grants 1,250.00 1,250.00 0.00 0.00 0.00 10-530-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,375,345.19 227,094.37 0.00 1,148,250.82 83.49 530 Plan & Protect Svc-RedevGrant 1,375,345.19 227,094.37 0.00 1,148,250.82 83.49 532 Plan & Protect Svcs-Env Health 10-532-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-532-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-532-430040 Local Grants 11,000.00 10,233.23 0.00 766.77 6.97 R50 Intergovernmental 11,000.00 10,233.23 0.00 766.77 6.97 532 Plan & Protect Svcs-Env Health 11,000.00 10,233.23 0.00 766.77 6.97 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 990 Capital Projects 10-990-430010 Federal Grants 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 990 Capital Projects 1,401,414.33 183,820.20 0.00 1,217,594.13 86.88 Revenue Revenue 32,540,119.85 13,500,361.31 0.00 19,039,758.54 58.51 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 21,600.00 0.00 43,200.00 66.67 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 4,957.20 1,652.60 0.00 3,304.60 66.66 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00 E05 Personnel Services 69,860.46 23,355.86 0.00 46,504.60 66.57 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 5.06 0.00 94.94 94.94 10-110-512010 Printing 750.00 0.00 0.00 750.00 100.00 10-110-512020 Copies 500.00 45.65 0.00 454.35 90.87 10-110-513010 Office Supplies 400.00 121.52 24.31 254.18 63.54 10-110-514040 Food 412.05 0.00 0.00 412.05 100.00 E10 Materials & Supplies 2,162.05 172.23 24.31 1,965.52 90.91 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 3,000.00 132.60 0.00 2,867.40 95.58 10-110-520030 Dues And Publications 4,582.90 4,582.90 0.00 0.00 0.00 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 417.10 107.47 0.00 309.63 74.23 10-110-522020 Professional Services 87.95 87.95 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,087.95 4,910.92 0.00 3,177.03 39.28 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 80,110.46 28,439.01 24.31 51,647.15 64.47 120 City Clerk 10-120-501020 Salaries 63,969.55 26,065.10 0.00 37,904.45 59.25 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 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 4,893.67 1,876.41 0.00 3,017.26 61.66 10-120-502020 Group Health Insurance 12,300.85 5,186.87 0.00 7,113.98 57.83 10-120-502030 Retirement 12,602.00 4,718.23 0.00 7,883.77 62.56 10-120-502040 Workers Compensation 103.26 103.26 0.00 0.00 0.00 10-120-502050 Life Insurance 108.44 43.26 0.00 65.18 60.11 10-120-502060 Long Term Disability 179.04 71.53 0.00 107.51 60.05 10-120-502070 Employee Assistance Prgm 29.53 14.82 0.00 14.71 49.81 E05 Personnel Services 94,186.34 38,079.48 0.00 56,106.86 59.57 10-120-511020 Postage 270.00 42.33 0.00 227.67 84.32 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 500.00 142.32 0.00 357.68 71.54 10-120-513010 Office Supplies 1,000.00 131.07 0.00 868.93 86.89 E10 Materials & Supplies 1,770.00 315.72 0.00 1,454.28 82.16 10-120-520030 Dues And Publications 250.00 0.00 0.00 250.00 100.00 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 223.00 0.00 777.00 77.70 10-120-522020 Professional Services 750.00 0.00 0.00 750.00 100.00 10-120-529030 Election Expense 50,000.00 20.00 0.00 49,980.00 99.96 E15 Contractual Services 52,000.00 243.00 0.00 51,757.00 99.53 10-120-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-120-547010 Equipment Maintenance 400.00 319.04 24.31 56.66 14.16 E25 Repairs & Maintenance 400.00 319.04 24.31 56.66 14.16 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 148,356.34 38,957.24 24.31 109,374.80 73.72 140 City Administrator 10-140-501020 Salaries 158,689.92 62,940.07 0.00 95,749.85 60.34 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 12,139.78 4,603.61 0.00 7,536.17 62.08 10-140-502020 Group Health Insurance 13,866.75 6,312.06 0.00 7,554.69 54.48 10-140-502030 Retirement 27,331.24 9,571.64 0.00 17,759.60 64.98 10-140-502040 Workers Compensation 542.12 542.12 0.00 0.00 0.00 10-140-502050 Life Insurance 247.61 96.51 0.00 151.10 61.02 10-140-502060 Long Term Disability 424.74 139.59 0.00 285.15 67.14 10-140-502070 Employee Assistance Prgm 36.72 22.30 0.00 14.42 39.27 E05 Personnel Services 213,278.88 84,227.90 0.00 129,050.98 60.51 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-140-511020 Postage 400.00 38.70 0.00 361.30 90.33 10-140-512010 Printing 300.00 45.00 0.00 255.00 85.00 10-140-512020 Copies 500.00 65.64 0.00 434.36 86.87 10-140-513010 Office Supplies 1,200.00 481.85 24.31 693.85 57.82 10-140-517010 Operational Supplies 1,750.00 0.00 0.00 1,750.00 100.00 E10 Materials & Supplies 5,150.00 631.19 24.31 4,494.51 87.27 10-140-520030 Dues And Publications 600.00 290.00 0.00 310.00 51.67 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 1,200.00 249.00 0.00 951.00 79.25 10-140-520080 Tuition Reimbursement 2,000.00 0.00 0.00 2,000.00 100.00 10-140-520090 Recruitment 0.00 7,946.26 0.00 -7,946.26 0.00 10-140-520095 Relocation Fees 0.00 17,402.06 0.00 -17,402.06 0.00 10-140-522020 Professional Services 2,000.00 200.22 0.00 1,799.78 89.99 E15 Contractual Services 5,800.00 26,087.54 0.00 -20,287.54 -349.79 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 250.00 115.44 0.00 134.56 53.82 E25 Repairs & Maintenance 250.00 115.44 0.00 134.56 53.82 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 224,478.88 111,062.07 24.31 113,392.51 50.51 149 Entitlement Grant 10-149-501020 Salaries 28,119.75 6,799.32 0.00 21,320.43 75.82 10-149-501050 Parttime(wo Benefits)42,730.00 5,527.50 0.00 37,202.50 87.06 10-149-502010 Social Security 1,921.66 946.42 0.00 975.24 50.75 10-149-502020 Group Health Insurance 0.00 1,032.34 0.00 -1,032.34 0.00 10-149-502030 Retirement 1,008.59 1,230.70 0.00 -222.11 -22.02 10-149-502050 Life Insurance 0.00 11.00 0.00 -11.00 0.00 10-149-502060 Long Term Disability 0.00 17.97 0.00 -17.97 0.00 E05 Personnel Services 73,780.00 15,565.25 0.00 58,214.75 78.90 10-149-511010 Advertising 3,500.00 306.25 0.00 3,193.75 91.25 10-149-511020 Postage 1,150.00 274.94 0.00 875.06 76.09 10-149-512020 Copies 0.00 0.63 0.00 -0.63 0.00 10-149-513010 Office Supplies 2,700.00 321.99 0.00 2,378.01 88.07 10-149-517010 Operational Supplies 700.00 31.00 0.00 669.00 95.57 E10 Materials & Supplies 8,050.00 934.81 0.00 7,115.19 88.39 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 4,750.00 1,159.34 0.00 3,590.66 75.59 10-149-522020 Professional Services 7,500.00 0.00 0.00 7,500.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 115,000.00 18,102.00 0.00 96,898.00 84.26 10-149-528012 Housing Rehab-Energy Efficienc 69,000.00 11,531.00 0.00 57,469.00 83.29 10-149-528020 Housing Assistance 40,348.00 10,122.00 0.00 30,226.00 74.91 10-149-528030 Public Improvement 171,534.74 26,006.86 649.00 144,878.88 84.46 10-149-528040 Neighborhood Redevelopmnt 162,500.00 34,650.19 27,978.00 99,871.81 61.46 10-149-528050 Neighborhood Facility 12,500.00 0.00 0.00 12,500.00 100.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 15,000.00 1,778.00 0.00 13,222.00 88.15 10-149-528080 Homeless Objectives 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 599,132.74 103,349.39 28,627.00 467,156.35 77.97 10-149-547020 Maintenance Agreements 1,300.00 258.80 362.32 678.88 52.22 E25 Repairs & Maintenance 1,300.00 258.80 362.32 678.88 52.22 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 682,262.74 120,108.25 28,989.32 533,165.17 78.15 150 City Counselor 10-150-501020 Salaries 226,856.91 59,217.46 0.00 167,639.45 73.90 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,354.55 4,199.35 0.00 13,155.20 75.80 10-150-502020 Group Health Insurance 33,916.35 9,115.54 0.00 24,800.81 73.12 10-150-502030 Retirement 44,534.97 10,718.09 0.00 33,816.88 75.93 10-150-502040 Workers Compensation 370.02 370.02 0.00 0.00 0.00 10-150-502050 Life Insurance 364.39 97.56 0.00 266.83 73.23 10-150-502060 Long Term Disability 555.12 154.33 0.00 400.79 72.20 10-150-502070 Employee Assistance Prgm 74.15 37.22 0.00 36.93 49.80 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 324,026.46 83,909.57 0.00 240,116.89 74.10 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 300.00 247.35 0.00 52.65 17.55 10-150-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-150-512020 Copies 670.00 131.37 0.00 538.63 80.39 10-150-513010 Office Supplies 1,800.00 404.75 0.00 1,395.25 77.51 10-150-517010 Operational Supplies 100.00 0.00 0.00 100.00 100.00 E10 Materials & Supplies 3,070.00 783.47 0.00 2,286.53 74.48 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 12,400.00 2,211.22 0.00 10,188.78 82.17 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 1,472.75 0.00 3,527.25 70.55 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-520080 Tuition Reimbursement 2,880.00 1,710.00 0.00 1,170.00 40.63 10-150-521010 General Insurance 3,000.00 1,712.00 0.00 1,288.00 42.93 10-150-522020 Professional Services 11,100.00 9.26 0.00 11,090.74 99.92 10-150-525030 Court Cost & Witness Fees 40.00 57.00 0.00 -17.00 -42.50 E15 Contractual Services 34,420.00 7,172.23 0.00 27,247.77 79.16 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,250.00 776.37 341.34 132.30 10.58 E25 Repairs & Maintenance 1,250.00 776.37 341.34 132.30 10.58 10-150-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-150-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 150 City Counselor 362,766.46 92,641.64 341.34 269,783.49 74.37 160 Municipal Court 10-160-501010 Salary-elected Officals 60,000.00 19,999.96 0.00 40,000.04 66.67 10-160-501020 Salaries 97,303.63 39,747.55 0.00 57,556.08 59.15 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 1,310.00 0.00 8,190.00 86.21 10-160-501090 Overtime 7,200.00 216.83 0.00 6,983.17 96.99 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,418.38 4,621.92 0.00 8,796.46 65.56 10-160-502020 Group Health Insurance 12,436.90 4,702.46 0.00 7,734.44 62.19 10-160-502030 Retirement 20,863.01 7,233.38 0.00 13,629.63 65.33 10-160-502040 Workers Compensation 154.89 154.89 0.00 0.00 0.00 10-160-502050 Life Insurance 163.88 65.57 0.00 98.31 59.99 10-160-502060 Long Term Disability 272.64 108.96 0.00 163.68 60.04 10-160-502070 Employee Assistance Prgm 51.73 25.98 0.00 25.75 49.78 E05 Personnel Services 221,365.06 78,187.50 0.00 143,177.56 64.68 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 4,000.00 1,155.58 0.00 2,844.42 71.11 10-160-512010 Printing 1,090.00 0.00 0.00 1,090.00 100.00 10-160-512020 Copies 1,000.00 54.33 0.00 945.67 94.57 10-160-513010 Office Supplies 1,600.00 0.00 0.00 1,600.00 100.00 E10 Materials & Supplies 7,690.00 1,209.91 0.00 6,480.09 84.27 10-160-520025 Security 10,000.00 2,689.38 0.00 7,310.62 73.11 10-160-520030 Dues And Publications 450.00 392.32 0.00 57.68 12.82 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,000.00 302.95 0.00 1,697.05 84.85 10-160-522020 Professional Services 3,000.00 625.00 0.00 2,375.00 79.17 10-160-525005 Appointed Counsel 7,000.00 2,177.50 0.00 4,822.50 68.89 10-160-525010 Care Of Prisoners 3,380.50 0.00 0.00 3,380.50 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 25,870.50 6,187.15 0.00 19,683.35 76.08 10-160-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-160-547010 Equipment Maintenance 1,200.00 252.20 24.31 923.50 76.96 E25 Repairs & Maintenance 1,200.00 252.20 24.31 923.50 76.96 10-160-572020 Purchase Of Equipment 16,251.06 437.42 15,851.06 -37.42 -0.23 E70 Capital Purchases 16,251.06 437.42 15,851.06 -37.42 -0.23 160 Municipal Court 272,376.62 86,274.18 15,875.37 170,227.08 62.50 170 Human Resources 10-170-501020 Salaries 150,912.28 63,801.08 0.00 87,111.20 57.72 10-170-501050 Parttime(wo Benefits)9,600.00 4,606.12 0.00 4,993.88 52.02 10-170-501090 Overtime 300.00 308.74 0.00 -8.74 -2.91 10-170-502010 Social Security 12,302.14 5,419.12 0.00 6,883.02 55.95 10-170-502020 Group Health Insurance 16,353.16 5,375.45 0.00 10,977.71 67.13 10-170-502030 Retirement 29,742.18 11,603.86 0.00 18,138.32 60.99 10-170-502040 Workers Compensation 301.18 301.18 0.00 0.00 0.00 10-170-502050 Life Insurance 250.06 103.44 0.00 146.62 58.63 10-170-502060 Long Term Disability 366.60 152.58 0.00 214.02 58.38 10-170-502070 Employee Assistance Prgm 46.53 33.44 0.00 13.09 28.13 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 220,174.13 91,705.01 0.00 128,469.12 58.35 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 1,000.00 51.00 0.00 949.00 94.90 10-170-512010 Printing 2,500.00 391.71 0.00 2,108.29 84.33 10-170-512020 Copies 1,500.00 206.51 0.00 1,293.49 86.23 10-170-513010 Office Supplies 1,500.00 0.00 0.00 1,500.00 100.00 10-170-517010 Operational Supplies 1,350.00 19.76 0.00 1,330.24 98.54 E10 Materials & Supplies 8,000.00 668.98 0.00 7,331.02 91.64 10-170-520030 Dues And Publications 1,255.00 0.00 0.00 1,255.00 100.00 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,229.97 0.00 2,270.03 64.86 10-170-520070 Training And Education 4,000.00 535.00 0.00 3,465.00 86.63 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 6,000.00 2,586.00 0.00 3,414.00 56.90 10-170-522020 Professional Services 8,000.00 1,027.57 0.00 6,972.43 87.16 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,755.00 5,378.54 0.00 17,376.46 76.36 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-547010 Equipment Maintenance 200.00 121.55 24.31 54.15 27.07 E25 Repairs & Maintenance 200.00 121.55 24.31 54.15 27.07 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 251,129.13 97,874.08 24.31 153,230.75 61.02 180 Finance Department 10-180-501020 Salaries 639,306.34 225,518.51 0.00 413,787.83 64.72 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)18,904.18 7,198.29 0.00 11,705.89 61.92 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 50,353.11 17,411.76 0.00 32,941.35 65.42 10-180-502020 Group Health Insurance 76,739.99 30,707.58 0.00 46,032.41 59.98 10-180-502030 Retirement 125,943.35 40,818.95 0.00 85,124.40 67.59 10-180-502040 Workers Compensation 1,634.95 1,634.95 0.00 0.00 0.00 10-180-502050 Life Insurance 1,095.73 376.40 0.00 719.33 65.65 10-180-502060 Long Term Disability 1,691.84 619.40 0.00 1,072.44 63.39 10-180-502070 Employee Assistance Prgm 285.94 143.52 0.00 142.42 49.81 E05 Personnel Services 915,955.43 324,429.36 0.00 591,526.07 64.58 10-180-511010 Advertising 2,000.00 26.25 0.00 1,973.75 98.69 10-180-511020 Postage 13,500.00 3,777.49 0.00 9,722.51 72.02 10-180-511021 Mail Machine Cost 2,000.00 1,556.51 0.00 443.49 22.17 10-180-512010 Printing 6,500.00 1,039.72 0.00 5,460.28 84.00 10-180-512020 Copies 5,000.00 1,828.72 0.00 3,171.28 63.43 10-180-512021 Copy Machine Cost 0.00 -601.41 145.83 455.58 0.00 10-180-513010 Office Supplies 6,000.00 2,051.73 0.00 3,948.27 65.80 10-180-517010 Operational Supplies 4,000.00 112.04 0.00 3,887.96 97.20 E10 Materials & Supplies 39,000.00 9,791.05 145.83 29,063.12 74.52 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 310.00 0.00 2,090.00 87.08 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 2,200.00 152.32 0.00 2,047.68 93.08 10-180-520080 Tuition Reimbursement 1,800.00 0.00 0.00 1,800.00 100.00 10-180-522010 Audit 27,700.00 13,500.00 25,455.00 -11,255.00 -40.63 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 34,100.00 13,962.32 25,455.00 -5,317.32 -15.59 10-180-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-180-547010 Equipment Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,000.00 890.16 0.00 1,109.84 55.49 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 991,055.43 349,072.89 25,600.83 616,381.71 62.19 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 62,439.92 0.00 0.00 62,439.92 100.00 10-185-501022 Separation Incentive Prog Svgs 22,325.24 0.00 0.00 22,325.24 100.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 56,030.00 31,385.46 0.00 24,644.54 43.98 10-185-502022 Wellness Assessment 25,000.00 0.00 0.00 25,000.00 100.00 10-185-503010 Awards Program 3,000.00 0.00 0.00 3,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 168,795.16 31,385.46 0.00 137,409.70 81.41 10-185-514010 Gas 19,000.00 9,276.21 0.00 9,723.79 51.18 10-185-514011 Gas Oil & Antifreeze 0.00 522.78 0.00 -522.78 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 19,000.00 9,798.99 0.00 9,201.01 48.43 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 287,100.00 233,293.02 0.00 53,806.98 18.74 10-185-521020 Insurance Deductible 30,000.00 -22,506.25 0.00 52,506.25 175.02 10-185-521030 Self Ins Prop & Casualty 70,000.00 56,626.68 11,200.00 2,173.32 3.10 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 -13,187.50 0.00 13,187.50 0.00 10-185-522020 Professional Services 129,050.00 10,416.65 67,499.98 51,133.37 39.62 10-185-522025 JCTV 55,000.00 0.00 0.00 55,000.00 100.00 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 45,500.00 11,363.69 0.00 34,136.31 75.02 10-185-527020 Economic Development 185,000.00 0.00 0.00 185,000.00 100.00 10-185-529010 Special Events 7,000.00 1,105.00 0.00 5,895.00 84.21 E15 Contractual Services 809,150.00 277,111.29 78,699.98 453,338.73 56.03 10-185-531010 Electricity 42,400.00 8,705.99 0.00 33,694.01 79.47 10-185-533010 Natural Gas 6,000.00 3,794.28 0.00 2,205.72 36.76 10-185-535010 Water 6,000.00 1,677.70 0.00 4,322.30 72.04 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 54,400.00 14,177.97 0.00 40,222.03 73.94 10-185-540010 Building & Grounds Maint.60,000.00 16,386.34 -2,249.21 45,862.87 76.44 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,000.00 468.00 0.00 1,532.00 76.60 E25 Repairs & Maintenance 87,000.00 41,854.34 -2,249.21 47,394.87 54.48 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550010 Miscellaneous 10,000.00 1,133.00 0.00 8,867.00 88.67 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 5,500.00 0.00 0.00 5,500.00 100.00 10-185-550041 ALPLA Settlement 50,000.00 50,000.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 11,247.91 0.00 -11,247.91 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 75,500.00 72,380.91 0.00 3,119.09 4.13 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 1,213,845.16 446,708.96 76,450.77 690,685.43 56.90 190 I.T. Department 10-190-501020 Salaries 551,117.31 225,003.10 0.00 326,114.21 59.17 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 42,160.47 16,496.06 0.00 25,664.41 60.87 10-190-502020 Group Health Insurance 63,175.48 25,403.04 0.00 37,772.44 59.79 10-190-502030 Retirement 108,570.11 40,725.70 0.00 67,844.41 62.49 10-190-502040 Workers Compensation 783.06 783.06 0.00 0.00 0.00 10-190-502050 Life Insurance 908.88 368.93 0.00 539.95 59.41 10-190-502060 Long Term Disability 1,459.74 584.29 0.00 875.45 59.97 10-190-502070 Employee Assistance Prgm 205.35 103.10 0.00 102.25 49.79 E05 Personnel Services 768,380.40 309,467.28 0.00 458,913.12 59.72 10-190-511010 Advertising 500.00 50.75 0.00 449.25 89.85 10-190-511020 Postage 200.00 4.88 0.00 195.12 97.56 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-512020 Copies 200.00 22.69 0.00 177.31 88.66 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 453.40 0.00 546.60 54.66 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 20.50 0.00 29.50 59.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,500.00 1,223.55 0.00 276.45 18.43 E10 Materials & Supplies 3,450.00 1,775.77 0.00 1,674.23 48.53 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferencess 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,000.00 4,303.27 0.00 3,696.73 46.21 10-190-520080 Tuition Reimbursement 7,500.00 1,200.00 0.00 6,300.00 84.00 10-190-522020 Professional Services 2,000.00 150.00 0.00 1,850.00 92.50 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 6,473.88 0.00 13,326.12 67.30 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 69.99 0.00 1,930.01 96.50 E15 Contractual Services 39,800.00 12,197.14 0.00 27,602.86 69.35 10-190-534010 Telephone 60,000.00 16,346.23 0.00 43,653.77 72.76 E20 Utilities 60,000.00 16,346.23 0.00 43,653.77 72.76 10-190-545010 Software Licensemaint 229,500.00 177,089.30 10,408.75 42,001.95 18.30 10-190-545020 Citywide Wiringnetwork 3,000.00 715.09 242.73 2,042.18 68.07 10-190-547010 Equipment Maintenance 3,000.00 3,001.78 0.00 -1.78 -0.06 10-190-547020 Maintenance Agreements 34,000.00 3,526.45 317.03 30,156.52 88.70 E25 Repairs & Maintenance 269,500.00 184,332.62 10,968.51 74,198.87 27.53 10-190-572020 Purchase Of Equipment 25,000.00 24,636.99 0.00 363.01 1.45 E70 Capital Purchases 25,000.00 24,636.99 0.00 363.01 1.45 190 I.T. Department 1,166,130.40 548,756.03 10,968.51 606,405.86 52.00 300 Police Department 10-300-501020 Salaries 3,946,429.11 1,582,109.89 0.00 2,364,319.22 59.91 10-300-501030 Holiday Pay 119,000.00 59,314.59 0.00 59,685.41 50.16 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 10,233.00 0.00 20,167.00 66.34 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,800.00 3,316.00 0.00 3,484.00 51.24 10-300-501090 Overtime 228,158.10 55,573.90 0.00 172,584.20 75.64 10-300-501095 Overtime Straight Pay 6,000.00 1,253.68 0.00 4,746.32 79.11 10-300-502010 Social Security 327,345.92 123,845.71 0.00 203,500.21 62.17 10-300-502020 Group Health Insurance 703,711.28 259,962.35 0.00 443,748.93 63.06 10-300-502030 Retirement 918,697.38 327,418.43 0.00 591,278.95 64.36 10-300-502040 Workers Compensation 70,999.83 70,999.83 0.00 0.00 0.00 10-300-502050 Life Insurance 6,782.09 2,578.47 0.00 4,203.62 61.98 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502060 Long Term Disability 11,071.66 4,221.01 0.00 6,850.65 61.88 10-300-502070 Employee Assistance Prgm 1,927.56 958.58 0.00 968.98 50.27 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 129.30 0.00 870.70 87.07 E05 Personnel Services 6,379,922.93 2,501,914.74 0.00 3,878,008.19 60.78 10-300-511010 Advertising 3,000.00 782.75 0.00 2,217.25 73.91 10-300-511020 Postage 2,500.00 531.92 0.00 1,968.08 78.72 10-300-512010 Printing 5,000.00 795.80 0.00 4,204.20 84.08 10-300-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-300-512030 Photographic Supplies 2,000.00 954.98 0.00 1,045.02 52.25 10-300-513010 Office Supplies 13,000.00 2,191.92 0.00 10,808.08 83.14 10-300-514010 Gas 282,000.00 87,729.83 0.00 194,270.17 68.89 10-300-514040 Food 700.00 41.82 0.00 658.18 94.03 10-300-515040 First Aid Supplies 1,000.00 447.03 0.00 552.97 55.30 10-300-516010 Ammunition & Firearms Supplies 23,000.00 9,894.70 12,970.99 134.31 0.58 10-300-516020 Dare Program 16,500.00 957.61 0.00 15,542.39 94.20 10-300-516030 Special Investigation 2,500.00 1,500.00 0.00 1,000.00 40.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 700.00 0.00 0.00 700.00 100.00 10-300-517010 Operational Supplies 30,000.00 8,391.52 0.00 21,608.48 72.03 E10 Materials & Supplies 382,100.00 114,219.88 12,970.99 254,909.13 66.71 10-300-520030 Dues And Publications 4,000.00 2,701.50 0.00 1,298.50 32.46 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-300-520080 Tuition Reimbursement 7,000.00 1,710.00 0.00 5,290.00 75.57 10-300-520090 Recruitment 2,500.00 1,134.60 0.00 1,365.40 54.62 10-300-521040 Medical Claimsservices 5,000.00 2,164.75 0.00 2,835.25 56.71 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 12,000.00 6,140.15 0.00 5,859.85 48.83 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 13,000.00 6,900.00 0.00 6,100.00 46.92 10-300-523030 Building Lease 1,200.00 400.00 800.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 11,040.00 1,576.11 0.00 9,463.89 85.72 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 418.86 0.00 1,781.14 80.96 E15 Contractual Services 57,940.00 23,145.97 800.00 33,994.03 58.67 10-300-531010 Electricity 60,000.00 20,242.96 0.00 39,757.04 66.26 10-300-533010 Natural Gas 14,800.00 10,353.26 0.00 4,446.74 30.05 10-300-534010 Telephone 12,100.00 903.22 0.00 11,196.78 92.54 10-300-535010 Water 3,000.00 1,599.94 0.00 1,400.06 46.67 E20 Utilities 89,900.00 33,099.38 0.00 56,800.62 63.18 10-300-540010 Building & Grounds Maint.51,000.00 10,668.60 -6,302.74 46,634.14 91.44 10-300-541030 Vehicle Wash 12,000.00 7,206.70 0.00 4,793.30 39.94 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-544010 K-9 Operations 10,500.00 2,793.85 0.00 7,706.15 73.39 10-300-544015 Care of Animals 0.00 0.00 0.00 0.00 0.00 10-300-544020 Civil Defense 0.00 0.00 0.00 0.00 0.00 10-300-544030 Emerg Mgmt Operations 17,500.00 7,708.93 0.00 9,791.07 55.95 10-300-546010 Clothing Expense 43,000.00 17,294.75 1,925.00 23,780.25 55.30 10-300-546020 Uniform Cleaning 26,000.00 9,902.47 0.00 16,097.53 61.91 10-300-547010 Equipment Maintenance 13,000.00 5,271.55 0.00 7,728.45 59.45 10-300-547020 Maintenance Agreements 20,000.00 14,991.43 2,626.78 2,381.79 11.91 10-300-547030 Radio Maintenance 10,000.00 2,908.25 0.00 7,091.75 70.92 E25 Repairs & Maintenance 203,000.00 78,746.53 -1,750.96 126,004.43 62.07 10-300-572010 Purchase Of Vehicles 250,000.00 0.00 243,414.00 6,586.00 2.63 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 11,086.20 0.00 0.00 11,086.20 100.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 10,133.00 6,157.81 0.00 3,975.19 39.23 10-300-572100 MDT Year 3 Equipment 264,894.65 150,996.29 107,066.22 6,832.14 2.58 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 536,113.85 157,154.10 350,480.22 28,479.53 5.31 300 Police Department 7,648,976.78 2,908,280.60 362,500.25 4,378,195.93 57.24 310 School Resource Officer 10-310-501020 Salaries 237,278.98 89,576.90 0.00 147,702.08 62.25 10-310-501030 Holiday Pay 6,000.00 2,287.60 0.00 3,712.40 61.87 10-310-501090 Overtime 7,126.00 7,792.86 0.00 -666.86 -9.36 10-310-501095 Overtime Straight Pay 0.00 147.64 0.00 -147.64 0.00 10-310-502010 Social Security 19,155.98 6,820.26 0.00 12,335.72 64.40 10-310-502020 Group Health Insurance 40,725.87 19,474.70 0.00 21,251.17 52.18 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-502030 Retirement 54,838.69 20,759.38 0.00 34,079.31 62.14 10-310-502040 Workers Compensation 3,631.31 3,631.31 0.00 0.00 0.00 10-310-502050 Life Insurance 401.52 149.14 0.00 252.38 62.86 10-310-502060 Long Term Disability 663.84 247.10 0.00 416.74 62.78 10-310-502070 Employee Assistance Prgm 111.00 55.74 0.00 55.26 49.78 E05 Personnel Services 369,933.19 150,942.63 0.00 218,990.56 59.20 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 369,933.19 150,942.63 0.00 218,990.56 59.20 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 92,726.19 37,615.36 0.00 55,110.83 59.43 10-320-501030 Holiday Pay 2,500.00 1,595.17 0.00 904.83 36.19 10-320-501090 Overtime 6,897.00 3,999.26 0.00 2,897.74 42.01 10-320-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-320-502010 Social Security 7,812.42 3,087.43 0.00 4,724.99 60.48 10-320-502020 Group Health Insurance 17,953.72 6,816.37 0.00 11,137.35 62.03 10-320-502030 Retirement 22,364.98 8,987.64 0.00 13,377.34 59.81 10-320-502040 Workers Compensation 1,677.98 1,677.98 0.00 0.00 0.00 10-320-502050 Life Insurance 157.92 62.93 0.00 94.99 60.15 10-320-502060 Long Term Disability 259.68 103.05 0.00 156.63 60.32 10-320-502070 Employee Assistance Prgm 44.40 22.30 0.00 22.10 49.77 E05 Personnel Services 152,394.29 63,967.49 0.00 88,426.80 58.03 10-320-514010 Gas 20,000.00 1,831.99 0.00 18,168.01 90.84 10-320-516040 Investigations (grant)16,900.00 1,389.87 0.00 15,510.13 91.78 10-320-517010 Operational Supplies 1,000.00 170.00 0.00 830.00 83.00 E10 Materials & Supplies 37,900.00 3,391.86 0.00 34,508.14 91.05 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 13,100.00 13,100.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 13,100.00 13,100.00 0.00 0.00 0.00 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.203,394.29 80,459.35 0.00 122,934.94 60.44 330 Animal Control 10-330-501020 Salaries 311,708.10 128,691.50 0.00 183,016.60 58.71 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)600.00 0.00 0.00 600.00 100.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 3,000.00 1,784.00 0.00 1,216.00 40.53 10-330-501090 Overtime 1,709.00 291.36 0.00 1,417.64 82.95 10-330-501095 Overtime Straight Pay 500.00 27.82 0.00 472.18 94.44 10-330-502010 Social Security 24,290.06 9,462.31 0.00 14,827.75 61.04 10-330-502020 Group Health Insurance 57,550.07 22,242.46 0.00 35,307.61 61.35 10-330-502030 Retirement 62,432.67 18,917.17 0.00 43,515.50 69.70 10-330-502040 Workers Compensation 5,137.19 5,137.19 0.00 0.00 0.00 10-330-502050 Life Insurance 527.52 213.36 0.00 314.16 59.55 10-330-502060 Long Term Disability 870.96 353.06 0.00 517.90 59.46 10-330-502070 Employee Assistance Prgm 177.60 89.18 0.00 88.42 49.79 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 468,503.17 187,209.41 0.00 281,293.76 60.04 10-330-511010 Advertising 1,500.00 0.00 0.00 1,500.00 100.00 10-330-511020 Postage 500.00 23.26 0.00 476.74 95.35 10-330-512010 Printing 1,700.00 742.75 0.00 957.25 56.31 10-330-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-330-513010 Office Supplies 800.00 323.93 0.00 476.07 59.51 10-330-514030 Small Tools 250.00 0.00 0.00 250.00 100.00 10-330-515040 First Aid Supplies 150.00 334.33 0.00 -184.33 -122.89 10-330-517010 Operational Supplies 5,500.00 2,740.38 0.00 2,759.62 50.17 E10 Materials & Supplies 10,420.00 4,164.65 0.00 6,255.35 60.03 10-330-520030 Dues And Publications 900.00 802.75 0.00 97.25 10.81 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,650.00 1,568.87 0.00 81.13 4.92 10-330-521040 Medical Claimsservices 1,000.00 0.00 0.00 1,000.00 100.00 10-330-522020 Professional Services 9,600.00 1,477.46 0.00 8,122.54 84.61 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 10,000.00 770.07 0.00 9,229.93 92.30 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,150.00 4,619.15 0.00 18,530.85 80.05 10-330-531010 Electricity 24,000.00 9,123.70 0.00 14,876.30 61.98 10-330-533010 Natural Gas 13,200.00 5,423.41 0.00 7,776.59 58.91 10-330-534010 Telephone 572.00 95.95 0.00 476.05 83.23 10-330-535010 Water 2,500.00 1,151.23 0.00 1,348.77 53.95 E20 Utilities 40,272.00 15,794.29 0.00 24,477.71 60.78 10-330-540010 Building & Grounds Maint.10,000.00 2,945.37 -920.08 7,974.71 79.75 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 42,000.00 12,313.05 0.00 29,686.95 70.68 10-330-546010 Clothing Expense 3,000.00 775.90 0.00 2,224.10 74.14 10-330-546020 Uniform Cleaning 100.00 0.00 0.00 100.00 100.00 10-330-547010 Equipment Maintenance 1,300.00 1,363.05 0.00 -63.05 -4.85 10-330-547020 Maintenance Agreements 800.00 1,656.00 0.00 -856.00 -107.00 10-330-547030 Radio Maintenance 700.00 0.00 0.00 700.00 100.00 E25 Repairs & Maintenance 58,440.00 19,593.37 -920.08 39,766.71 68.05 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 600,785.17 231,380.87 -920.08 370,324.38 61.64 390 9-1-1 Police 10-390-501020 Salaries 765,641.65 294,907.07 0.00 470,734.58 61.48 10-390-501030 Holiday Pay 29,000.00 14,748.64 0.00 14,251.36 49.14 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 6,448.70 0.00 9,365.30 59.22 10-390-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-390-502010 Social Security 62,038.10 22,874.44 0.00 39,163.66 63.13 10-390-502020 Group Health Insurance 157,153.93 54,198.72 0.00 102,955.21 65.51 10-390-502030 Retirement 159,758.26 56,054.65 0.00 103,703.61 64.91 10-390-502040 Workers Compensation 1,350.99 1,350.99 0.00 0.00 0.00 10-390-502050 Life Insurance 1,305.36 478.66 0.00 826.70 63.33 10-390-502060 Long Term Disability 2,142.66 785.60 0.00 1,357.06 63.34 10-390-502070 Employee Assistance Prgm 438.45 220.14 0.00 218.31 49.79 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,195,143.40 452,067.61 0.00 743,075.79 62.17 10-390-511010 Advertising 1,200.00 0.00 0.00 1,200.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-517010 Operational Supplies 5,000.00 125.00 0.00 4,875.00 97.50 E10 Materials & Supplies 6,200.00 125.00 0.00 6,075.00 97.98 10-390-520030 Dues And Publications 900.00 40.00 0.00 860.00 95.56 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-390-522020 Professional Services 2,000.00 649.00 0.00 1,351.00 67.55 10-390-523010 Equipment Rentlease 100,000.00 38,221.64 4,860.00 56,918.36 56.92 E15 Contractual Services 102,900.00 38,910.64 4,860.00 59,129.36 57.46 10-390-534010 Telephone 150.00 0.00 0.00 150.00 100.00 E20 Utilities 150.00 0.00 0.00 150.00 100.00 10-390-546010 Clothing Expense 3,400.00 0.00 0.00 3,400.00 100.00 10-390-546020 Uniform Cleaning 2,000.00 0.00 0.00 2,000.00 100.00 10-390-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-390-547020 Maintenance Agreements 25,000.00 8,780.25 11,609.25 4,610.50 18.44 10-390-547030 Radio Maintenance 4,000.00 0.00 0.00 4,000.00 100.00 E25 Repairs & Maintenance 37,400.00 8,780.25 11,609.25 17,010.50 45.48 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,341,793.40 499,883.50 16,469.25 825,440.65 61.52 400 Fire Department 10-400-501020 Salaries 3,413,576.57 1,391,133.54 0.00 2,022,443.03 59.25 10-400-501030 Holiday Pay 267,630.97 161,332.43 0.00 106,298.54 39.72 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 12,120.00 0.00 15,880.00 56.71 10-400-501090 Overtime 30,000.00 13,861.38 0.00 16,138.62 53.80 10-400-501095 Overtime Straight Pay 32,000.00 12,331.56 0.00 19,668.44 61.46 10-400-502010 Social Security 53,115.63 21,204.58 0.00 31,911.05 60.08 10-400-502020 Group Health Insurance 591,688.25 226,806.46 0.00 364,881.79 61.67 10-400-502030 Retirement 1,639,063.50 675,071.32 0.00 963,992.18 58.81 10-400-502040 Workers Compensation 108,750.00 108,750.00 0.00 0.00 0.00 10-400-502050 Life Insurance 5,774.79 2,302.24 0.00 3,472.55 60.13 10-400-502060 Long Term Disability 9,511.67 3,785.08 0.00 5,726.59 60.21 10-400-502070 Employee Assistance Prgm 1,608.36 807.54 0.00 800.82 49.79 10-400-503010 Awards Program 1,000.00 92.40 0.00 907.60 90.76 E05 Personnel Services 6,181,719.74 2,629,598.53 0.00 3,552,121.21 57.46 10-400-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-400-511020 Postage 300.00 77.21 50.00 172.79 57.60 10-400-512010 Printing 1,250.00 454.00 0.00 796.00 63.68 10-400-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 399.63 0.00 1,400.37 77.80 10-400-514010 Gas 77,000.00 25,832.86 0.00 51,167.14 66.45 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514020 Chemicals 2,000.00 623.14 0.00 1,376.86 68.84 10-400-514030 Small Tools 2,500.00 1,166.00 0.00 1,334.00 53.36 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 400.00 0.00 0.00 400.00 100.00 10-400-517010 Operational Supplies 8,180.00 2,552.37 278.60 5,349.03 65.39 E10 Materials & Supplies 93,780.00 31,105.21 328.60 62,346.19 66.48 10-400-520030 Dues And Publications 1,240.00 499.00 0.00 741.00 59.76 10-400-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-400-520060 Wellness Program 0.00 0.00 0.00 0.00 0.00 10-400-520070 Training And Education 10,000.00 1,515.00 0.00 8,485.00 84.85 10-400-520080 Tuition Reimbursement 5,000.00 0.00 0.00 5,000.00 100.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 2,700.00 0.00 0.00 2,700.00 100.00 10-400-522020 Professional Services 1,200.00 300.00 0.00 900.00 75.00 10-400-523010 Equipment Rentlease 2,000.00 0.00 0.00 2,000.00 100.00 10-400-524010 Trash Collections 250.00 0.00 0.00 250.00 100.00 10-400-529010 Special Events 6,000.00 2,532.22 0.00 3,467.78 57.80 10-400-529040 Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 28,390.00 4,846.22 0.00 23,543.78 82.93 10-400-531010 Electricity 27,500.00 7,438.72 0.00 20,061.28 72.95 10-400-533010 Natural Gas 17,500.00 13,801.84 0.00 3,698.16 21.13 10-400-534010 Telephone 17,500.00 6,483.79 0.00 11,016.21 62.95 10-400-535010 Water 8,720.00 3,921.23 0.00 4,798.77 55.03 E20 Utilities 71,220.00 31,645.58 0.00 39,574.42 55.57 10-400-540010 Building & Grounds Maint.44,934.00 12,808.77 5,923.64 26,201.59 58.31 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 35,000.00 8,666.31 -1,660.60 27,994.29 79.98 10-400-546020 Uniform Cleaning 1,066.00 0.00 0.00 1,066.00 100.00 10-400-547010 Equipment Maintenance 18,000.00 2,399.71 0.00 15,600.29 86.67 10-400-547020 Maintenance Agreements 13,900.00 1,736.40 504.00 11,659.60 83.88 10-400-547030 Radio Maintenance 7,000.00 372.50 0.00 6,627.50 94.68 E25 Repairs & Maintenance 119,900.00 25,983.69 4,767.04 89,149.27 74.35 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 24,667.09 23,794.32 0.00 872.77 3.54 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 24,667.09 23,794.32 0.00 872.77 3.54 400 Fire Department 6,519,676.83 2,746,973.55 5,095.64 3,767,607.64 57.79 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 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 205,628.16 83,841.48 0.00 121,786.68 59.23 10-520-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-520-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-520-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-520-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-520-502010 Social Security 15,730.55 6,124.11 0.00 9,606.44 61.07 10-520-502020 Group Health Insurance 31,736.64 12,226.86 0.00 19,509.78 61.47 10-520-502030 Retirement 40,508.75 15,175.33 0.00 25,333.42 62.54 10-520-502040 Workers Compensation 524.91 524.91 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-502050 Life Insurance 347.76 139.11 0.00 208.65 60.00 10-520-502060 Long Term Disability 531.84 212.73 0.00 319.11 60.00 10-520-502070 Employee Assistance Prgm 88.80 44.58 0.00 44.22 49.80 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 295,097.41 118,289.11 0.00 176,808.30 59.92 10-520-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-520-511020 Postage 200.00 36.76 0.00 163.24 81.62 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 800.00 170.86 0.00 629.14 78.64 10-520-514010 Gas 20,000.00 3,792.15 0.00 16,207.85 81.04 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 94.10 0.00 55.90 37.27 E10 Materials & Supplies 21,650.00 4,093.87 0.00 17,556.13 81.09 10-520-520030 Dues And Publications 500.00 145.10 0.00 354.90 70.98 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,500.00 224.00 0.00 1,276.00 85.07 10-520-522020 Professional Services 3,000.00 1,581.00 0.00 1,419.00 47.30 E15 Contractual Services 5,000.00 1,950.10 0.00 3,049.90 61.00 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,000.00 455.42 95.04 449.54 44.95 E25 Repairs & Maintenance 1,000.00 455.42 95.04 449.54 44.95 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 322,747.41 124,788.50 95.04 197,863.87 61.31 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 51,891.84 22,090.28 0.00 29,801.56 57.43 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 4,704.00 0.00 7,776.00 62.31 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 4,924.45 2,049.72 0.00 2,874.73 58.38 10-521-502020 Group Health Insurance 5,961.16 2,241.08 0.00 3,720.08 62.41 10-521-502030 Retirement 10,222.69 3,998.33 0.00 6,224.36 60.89 10-521-502040 Workers Compensation 86.05 86.05 0.00 0.00 0.00 10-521-502050 Life Insurance 87.36 34.94 0.00 52.42 60.00 10-521-502060 Long Term Disability 145.20 58.08 0.00 87.12 60.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-502070 Employee Assistance Prgm 22.20 11.14 0.00 11.06 49.82 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 85,820.95 35,273.62 0.00 50,547.33 58.90 10-521-511010 Advertising 6,500.00 1,135.75 0.00 5,364.25 82.53 10-521-511020 Postage 1,500.00 274.73 0.00 1,225.27 81.68 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 148.93 0.00 851.07 85.11 10-521-514040 Food 100.00 0.00 0.00 100.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 0.00 0.00 2,000.00 100.00 E10 Materials & Supplies 11,300.00 1,559.41 0.00 9,740.59 86.20 10-521-520030 Dues And Publications 15,500.00 2,525.00 0.00 12,975.00 83.71 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 1,700.00 249.00 0.00 1,451.00 85.35 10-521-520080 Tuition Reimbursement 1,600.00 0.00 0.00 1,600.00 100.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,800.00 2,774.00 0.00 16,026.00 85.24 10-521-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-521-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-521-547020 Maintenance Agreements 1,400.00 836.63 480.40 82.97 5.93 E25 Repairs & Maintenance 1,400.00 836.63 480.40 82.97 5.93 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 117,320.95 40,443.66 480.40 76,396.89 65.12 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 106,803.34 42,872.76 0.00 63,930.58 59.86 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 8,170.45 3,207.08 0.00 4,963.37 60.75 10-522-502020 Group Health Insurance 18,528.02 4,769.70 0.00 13,758.32 74.26 10-522-502030 Retirement 21,230.20 5,076.07 0.00 16,154.13 76.09 10-522-502040 Workers Compensation 206.52 206.52 0.00 0.00 0.00 10-522-502050 Life Insurance 213.36 69.77 0.00 143.59 67.30 10-522-502060 Long Term Disability 352.32 114.99 0.00 237.33 67.36 10-522-502070 Employee Assistance Prgm 44.40 22.30 0.00 22.10 49.77 E05 Personnel Services 155,548.61 56,339.19 0.00 99,209.42 63.78 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-522-511020 Postage 400.00 79.94 0.00 320.06 80.02 10-522-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-522-512020 Copies 50.00 0.18 0.00 49.82 99.64 10-522-513010 Office Supplies 1,000.00 57.18 0.00 942.82 94.28 10-522-514040 Food 200.00 0.00 0.00 200.00 100.00 10-522-517010 Operational Supplies 800.00 0.00 0.00 800.00 100.00 E10 Materials & Supplies 3,850.00 137.30 0.00 3,712.70 96.43 10-522-520030 Dues And Publications 1,000.00 574.65 0.00 425.35 42.54 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 2,500.00 140.00 0.00 2,360.00 94.40 10-522-522020 Professional Services 24,000.00 0.00 0.00 24,000.00 100.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 27,500.00 714.65 0.00 26,785.35 97.40 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,400.00 146.56 178.56 1,074.88 76.78 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,400.00 146.56 178.56 1,074.88 76.78 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 188,298.61 57,337.70 178.56 130,782.35 69.45 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 57,138.01 23,296.46 0.00 33,841.55 59.23 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,371.06 1,576.36 0.00 2,794.70 63.94 10-530-502020 Group Health Insurance 8,609.94 2,824.05 0.00 5,785.89 67.20 10-530-502030 Retirement 11,256.19 4,216.72 0.00 7,039.47 62.54 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 105.84 38.11 0.00 67.73 63.99 10-530-502060 Long Term Disability 176.64 62.99 0.00 113.65 64.34 10-530-502070 Employee Assistance Prgm 33.30 16.72 0.00 16.58 49.79 E05 Personnel Services 81,690.98 32,031.41 0.00 49,659.57 60.79 10-530-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-530-511020 Postage 100.00 25.52 0.00 74.48 74.48 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 300.00 112.67 0.00 187.33 62.44 10-530-517010 Operational Supplies 300.00 10.50 0.00 289.50 96.50 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 1,100.00 148.69 0.00 951.31 86.48 10-530-520030 Dues And Publications 360.50 0.00 0.00 360.50 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 0.00 0.00 1,800.00 100.00 10-530-522020 Professional Services 2,500.00 0.00 0.00 2,500.00 100.00 10-530-528085 Fair Housing Assistance Prog 1,250.00 0.00 0.00 1,250.00 100.00 E15 Contractual Services 5,910.50 0.00 0.00 5,910.50 100.00 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 289.50 82.14 103.68 103.68 35.81 E25 Repairs & Maintenance 289.50 82.14 103.68 103.68 35.81 10-530-550020 Neighborhood Reinvestment 45,000.00 11,528.02 0.00 33,471.98 74.38 10-530-550030 Old Town Projects 45,500.00 29,359.68 0.00 16,140.32 35.47 10-530-550031 Historic Preservation Grant 1,734.00 0.00 0.00 1,734.00 100.00 10-530-550035 Old Town Redev Committee 0.00 -15.00 0.00 15.00 0.00 10-530-550037 Historic Preservation Comm 1,000.00 45.00 0.00 955.00 95.50 10-530-550050 Neighb Stablization Prog 105,516.24 0.00 0.00 105,516.24 100.00 10-530-550060 MSP 1,105,349.09 8,366.28 1,000,770.00 96,212.81 8.70 10-530-550090 Hazard Mitigation 217,664.81 217,664.81 0.00 0.00 0.00 E30 Other Operating Expenses 1,521,764.14 266,948.79 1,000,770.00 254,045.35 16.69 530 Plan & Protect Svc-RedevGrant 1,610,755.12 299,211.03 1,000,873.68 310,670.41 19.29 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 363,817.21 156,430.27 0.00 207,386.94 57.00 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 29,529.55 11,396.96 0.00 18,132.59 61.40 10-531-502020 Group Health Insurance 54,594.03 19,985.52 0.00 34,608.51 63.39 10-531-502030 Retirement 68,404.76 22,907.29 0.00 45,497.47 66.51 10-531-502040 Workers Compensation 6,952.84 6,952.84 0.00 0.00 0.00 10-531-502050 Life Insurance 580.83 225.95 0.00 354.88 61.10 10-531-502060 Long Term Disability 972.93 383.83 0.00 589.10 60.55 10-531-502070 Employee Assistance Prgm 157.11 78.02 0.00 79.09 50.34 E05 Personnel Services 547,199.26 218,360.68 0.00 328,838.58 60.09 10-531-511010 Advertising 200.00 91.80 0.00 108.20 54.10 10-531-511020 Postage 2,000.00 1,341.13 0.00 658.87 32.94 10-531-512010 Printing 700.00 362.90 0.00 337.10 48.16 10-531-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 1,800.00 218.69 0.00 1,581.31 87.85 10-531-514030 Small Tools 300.00 14.97 0.00 285.03 95.01 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 27 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 2,700.00 22.23 1,320.90 1,356.87 50.25 E10 Materials & Supplies 7,740.00 2,051.72 1,320.90 4,367.38 56.43 10-531-520030 Dues And Publications 1,500.00 739.00 0.00 761.00 50.73 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 2,500.00 511.00 0.00 1,989.00 79.56 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 15,000.00 5,508.50 0.00 9,491.50 63.28 10-531-522022 Demo 20,000.00 0.00 0.00 20,000.00 100.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 39,000.00 6,758.50 0.00 32,241.50 82.67 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 800.00 648.50 0.00 151.50 18.94 10-531-547010 Equipment Maintenance 60.00 0.00 0.00 60.00 100.00 10-531-547020 Maintenance Agreements 1,500.00 443.75 563.92 492.33 32.82 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,900.00 1,632.25 563.92 703.83 24.27 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 596,839.26 228,803.15 1,884.82 366,151.29 61.35 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 130,608.56 50,917.49 0.00 79,691.07 61.02 10-532-501060 Seasonal Salaries 3,957.00 174.00 0.00 3,783.00 95.60 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 220.00 0.00 0.00 220.00 100.00 10-532-501095 Overtime Straight Pay 60.00 0.00 0.00 60.00 100.00 10-532-502010 Social Security 10,315.69 3,751.63 0.00 6,564.06 63.63 10-532-502020 Group Health Insurance 21,485.14 7,528.50 0.00 13,956.64 64.96 10-532-502030 Retirement 25,785.05 9,216.03 0.00 16,569.02 64.26 10-532-502040 Workers Compensation 1,884.50 1,884.50 0.00 0.00 0.00 10-532-502050 Life Insurance 220.08 83.79 0.00 136.29 61.93 10-532-502060 Long Term Disability 363.60 138.70 0.00 224.90 61.85 10-532-502070 Employee Assistance Prgm 55.50 27.86 0.00 27.64 49.80 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 194,955.12 73,722.50 0.00 121,232.62 62.18 10-532-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-532-511020 Postage 200.00 64.90 0.00 135.10 67.55 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,000.00 181.16 0.00 818.84 81.88 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 30.00 0.00 0.00 30.00 100.00 10-532-517010 Operational Supplies 1,200.00 360.54 0.00 839.46 69.96 E10 Materials & Supplies 2,850.00 606.60 0.00 2,243.40 78.72 10-532-520030 Dues And Publications 880.00 345.00 0.00 535.00 60.80 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 800.00 411.00 0.00 389.00 48.63 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 1,155.00 -1,155.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 1,000.00 0.00 0.00 1,000.00 100.00 10-532-524025 Glass Recycling 10,000.00 2,090.00 3,520.00 4,390.00 43.90 10-532-524026 Household Hazardous Waste 20,000.00 0.00 0.00 20,000.00 100.00 10-532-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 7,000.00 200.00 0.00 6,800.00 97.14 10-532-524030 Compost Services 212,000.00 88,333.35 123,666.69 -0.04 0.00 10-532-529010 Special Events 1,000.00 0.00 0.00 1,000.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 252,680.00 91,379.35 128,341.69 32,958.96 13.04 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 25,000.00 9,999.92 14,035.00 965.08 3.86 10-532-540065 Cemetery Restoration 5,000.00 0.00 0.00 5,000.00 100.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 300.00 160.00 0.00 140.00 46.67 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,200.00 542.53 419.92 237.55 19.80 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 32,870.00 11,986.45 14,454.92 6,428.63 19.56 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 483,355.12 177,694.90 142,796.61 162,863.61 33.69 535 Public Works-Central Maintenan 10-535-501020 Salaries 331,324.54 133,179.14 0.00 198,145.40 59.80 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 0.00 0.00 7,400.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 9,717.70 0.00 -5,217.70 -115.95 10-535-501095 Overtime Straight Pay 500.00 278.91 0.00 221.09 44.22 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-502010 Social Security 26,294.93 10,151.68 0.00 16,143.25 61.39 10-535-502020 Group Health Insurance 83,283.30 31,417.33 0.00 51,865.97 62.28 10-535-502030 Retirement 66,255.94 25,914.79 0.00 40,341.15 60.89 10-535-502040 Workers Compensation 4,715.54 4,715.54 0.00 0.00 0.00 10-535-502050 Life Insurance 561.12 223.82 0.00 337.30 60.11 10-535-502060 Long Term Disability 926.64 369.57 0.00 557.07 60.12 10-535-502070 Employee Assistance Prgm 177.60 89.18 0.00 88.42 49.79 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 525,939.61 216,057.66 0.00 309,881.95 58.92 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.46 0.00 49.54 99.08 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,000.00 225.36 0.00 774.64 77.46 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 3,023.63 0.00 3,976.37 56.81 10-535-517010 Operational Supplies 8,000.00 2,183.73 0.00 5,816.27 72.70 E10 Materials & Supplies 16,140.00 5,433.18 0.00 10,706.82 66.34 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 199.00 0.00 1,801.00 90.05 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,000.00 199.00 0.00 1,801.00 90.05 10-535-531010 Electricity 5,550.00 2,374.33 0.00 3,175.67 57.22 10-535-533010 Natural Gas 7,000.00 6,384.73 0.00 615.27 8.79 10-535-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-535-535010 Water 1,215.00 456.38 0.00 758.62 62.44 E20 Utilities 13,765.00 9,215.44 0.00 4,549.56 33.05 10-535-540010 Building & Grounds Maint.10,000.00 5,009.98 0.00 4,990.02 49.90 10-535-541010 Veh & Equip Parts Etc 419,500.00 159,703.10 18,390.00 241,406.90 57.55 10-535-546010 Clothing Expense 7,000.00 2,587.00 -1,383.75 5,796.75 82.81 10-535-547010 Equipment Maintenance 3,500.00 684.79 0.00 2,815.21 80.43 10-535-547020 Maintenance Agreements 4,000.00 1,285.01 105.60 2,609.39 65.23 10-535-547030 Radio Maintenance 500.00 0.00 0.00 500.00 100.00 E25 Repairs & Maintenance 444,500.00 169,269.88 17,111.85 258,118.27 58.07 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 1,002,344.61 400,175.16 17,111.85 585,057.60 58.37 540 Public Works-Admin 10-540-501020 Salaries 188,433.84 78,145.68 0.00 110,288.16 58.53 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 14,415.19 5,475.39 0.00 8,939.80 62.02 10-540-502020 Group Health Insurance 30,833.98 11,619.25 0.00 19,214.73 62.32 10-540-502030 Retirement 37,121.47 14,144.37 0.00 22,977.10 61.90 10-540-502040 Workers Compensation 567.94 567.94 0.00 0.00 0.00 10-540-502050 Life Insurance 309.12 126.10 0.00 183.02 59.21 10-540-502060 Long Term Disability 462.24 184.89 0.00 277.35 60.00 10-540-502070 Employee Assistance Prgm 66.60 33.44 0.00 33.16 49.79 E05 Personnel Services 272,210.38 110,297.06 0.00 161,913.32 59.48 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 27.35 0.00 172.65 86.33 10-540-512010 Printing 200.00 33.00 0.00 167.00 83.50 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 128,500.00 61,589.33 0.00 66,910.67 52.07 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 1,200.91 0.00 0.00 1,200.91 100.00 E10 Materials & Supplies 131,400.91 61,649.68 0.00 69,751.23 53.08 10-540-520030 Dues And Publications 1,000.00 475.20 0.00 524.80 52.48 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,000.00 696.52 0.00 1,303.48 65.17 10-540-522020 Professional Services 800.00 0.00 0.00 800.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,800.00 1,171.72 0.00 2,628.28 69.17 10-540-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-540-547020 Maintenance Agreements 929.09 509.17 419.92 0.00 0.00 E25 Repairs & Maintenance 929.09 509.17 419.92 0.00 0.00 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works-Admin 408,340.38 173,627.63 419.92 234,292.83 57.38 541 Public Works-Engineering 10-541-501020 Salaries 662,630.75 268,666.17 0.00 393,964.58 59.45 10-541-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-541-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-541-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 200.00 463.78 0.00 -263.78 -131.89 10-541-501095 Overtime Straight Pay 200.00 58.56 0.00 141.44 70.72 10-541-502010 Social Security 50,721.85 19,524.11 0.00 31,197.74 61.51 10-541-502020 Group Health Insurance 96,562.21 35,659.87 0.00 60,902.34 63.07 10-541-502030 Retirement 130,617.06 48,601.10 0.00 82,015.96 62.79 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-502040 Workers Compensation 1,204.70 1,204.70 0.00 0.00 0.00 10-541-502050 Life Insurance 1,100.40 440.50 0.00 659.90 59.97 10-541-502060 Long Term Disability 1,816.32 727.59 0.00 1,088.73 59.94 10-541-502070 Employee Assistance Prgm 244.20 122.60 0.00 121.60 49.80 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 945,297.49 375,468.98 0.00 569,828.51 60.28 10-541-511010 Advertising 600.00 127.75 0.00 472.25 78.71 10-541-511020 Postage 800.00 75.79 0.00 724.21 90.53 10-541-512010 Printing 100.00 66.00 0.00 34.00 34.00 10-541-512020 Copies 75.00 0.00 0.00 75.00 100.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 6,500.00 1,463.17 0.00 5,036.83 77.49 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 14.47 0.00 135.53 90.35 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-541-515080 Surveying Supplies 2,000.00 399.82 0.00 1,600.18 80.01 10-541-517010 Operational Supplies 1,150.00 661.82 0.00 488.18 42.45 E10 Materials & Supplies 13,625.00 2,808.82 0.00 10,816.18 79.38 10-541-520030 Dues And Publications 4,000.00 1,943.80 0.00 2,056.20 51.41 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,500.00 500.00 0.00 4,000.00 88.89 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 202.00 0.00 3,798.00 94.95 10-541-522055 Stormwater Compliance 1,500.00 551.03 0.00 948.97 63.26 E15 Contractual Services 14,000.00 3,196.83 0.00 10,803.17 77.17 10-541-534010 Telephone 1,000.00 149.96 0.00 850.04 85.00 E20 Utilities 1,000.00 149.96 0.00 850.04 85.00 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,000.00 160.00 0.00 840.00 84.00 10-541-547010 Equipment Maintenance 1,500.00 593.12 0.00 906.88 60.46 10-541-547020 Maintenance Agreements 13,000.00 2,027.60 7,029.14 3,943.26 30.33 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 16,500.00 3,740.72 7,029.14 5,730.14 34.73 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 990,422.49 385,365.31 7,029.14 598,028.04 60.38 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 542 Public Works-Street 10-542-501020 Salaries 1,010,882.92 412,404.45 0.00 598,478.47 59.20 10-542-501060 Seasonal Salaries 20,543.42 0.00 0.00 20,543.42 100.00 10-542-501070 Stand-by Plan 4,081.31 1,760.00 0.00 2,321.31 56.88 10-542-501090 Overtime 20,000.00 31,936.18 0.00 -11,936.18 -59.68 10-542-501095 Overtime Straight Pay 2,000.00 183.18 0.00 1,816.82 90.84 10-542-502010 Social Security 80,893.69 33,348.08 0.00 47,545.61 58.78 10-542-502020 Group Health Insurance 167,122.47 60,699.65 0.00 106,422.82 63.68 10-542-502030 Retirement 204,267.42 78,859.16 0.00 125,408.26 61.39 10-542-502040 Workers Compensation 26,942.26 26,942.26 0.00 0.00 0.00 10-542-502050 Life Insurance 1,700.04 682.87 0.00 1,017.17 59.83 10-542-502060 Long Term Disability 2,785.20 1,117.77 0.00 1,667.43 59.87 10-542-502070 Employee Assistance Prgm 521.70 261.94 0.00 259.76 49.79 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 250.00 0.00 0.00 250.00 100.00 E05 Personnel Services 1,542,190.43 648,195.54 0.00 893,994.89 57.97 10-542-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-542-511020 Postage 150.00 12.60 0.00 137.40 91.60 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 1.13 0.00 8.87 88.70 10-542-513010 Office Supplies 1,333.68 336.42 0.00 997.26 74.78 10-542-514020 Chemicals 300,000.00 272,682.26 -301,684.51 329,002.25 109.67 10-542-514030 Small Tools 9,000.00 2,203.47 0.00 6,796.53 75.52 10-542-514040 Food 734.32 734.32 0.00 0.00 0.00 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 274,750.00 33,256.53 0.00 241,493.47 87.90 10-542-515040 First Aid Supplies 500.00 315.50 0.00 184.50 36.90 10-542-515060 Weed Control 1,500.00 0.00 0.00 1,500.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 1,456.35 0.00 3,543.65 70.87 E10 Materials & Supplies 593,568.00 310,998.58 -301,684.51 584,253.93 98.43 10-542-520030 Dues And Publications 584.00 527.00 0.00 57.00 9.76 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 2,068.00 158.99 0.00 1,909.01 92.31 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 15,000.00 10,333.10 1,980.00 2,686.90 17.91 10-542-523010 Equipment Rentlease 200.00 60.00 0.00 140.00 70.00 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,852.00 11,079.09 1,980.00 4,792.91 26.85 10-542-531010 Electricity 25,000.00 11,285.12 0.00 13,714.88 54.86 10-542-531020 Street Lights 527,900.00 206,999.74 0.00 320,900.26 60.79 10-542-533010 Natural Gas 17,000.00 11,027.55 0.00 5,972.45 35.13 10-542-534010 Telephone 500.00 189.86 0.00 310.14 62.03 10-542-535010 Water 6,000.00 1,478.71 0.00 4,521.29 75.35 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 576,400.00 230,980.98 0.00 345,419.02 59.93 10-542-540010 Building & Grounds Maint.7,000.00 1,917.99 0.00 5,082.01 72.60 10-542-541030 Vehicle Wash 6,620.00 6,620.00 0.00 0.00 0.00 10-542-542010 Repairs - Stop Lights 10,000.00 2,686.44 0.00 7,313.56 73.14 10-542-542030 Signs & Marking Paint 35,000.00 3,844.80 0.00 31,155.20 89.01 10-542-546010 Clothing Expense 10,000.00 3,149.10 0.00 6,850.90 68.51 10-542-547010 Equipment Maintenance 3,200.00 1,770.14 0.00 1,429.86 44.68 10-542-547020 Maintenance Agreements 500.00 297.36 36.00 166.64 33.33 10-542-547030 Radio Maintenance 100.00 73.76 0.00 26.24 26.24 E25 Repairs & Maintenance 72,420.00 20,359.59 36.00 52,024.41 71.84 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,802,430.43 1,221,613.78 -299,668.51 1,880,485.16 67.10 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 1,515.57 0.00 2,484.43 62.11 10-700-590070 Airport Subsidy 170,789.16 170,789.16 0.00 0.00 0.00 10-700-590075 Transit Subsidy 363,990.70 363,990.70 0.00 0.00 0.00 10-700-590080 Transfer To Amb Serv 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 538,779.86 536,295.43 0.00 2,484.43 0.46 700 Transfers & Subsidies 538,779.86 536,295.43 0.00 2,484.43 0.46 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-animal Rescue 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 990 Capital Projects 10-990-577042 Mo Blvd Sidewalks 75,447.33 81,464.83 -10,700.55 4,683.05 6.21 10-990-577044 Water Street @ Lohman Landing 465,460.00 0.00 2,790.68 462,669.32 99.40 10-990-577045 Clay Street Plaza 72,800.00 0.00 0.00 72,800.00 100.00 10-990-577046 Hwy 54 & Stadium Interchange 787,707.00 0.00 86,120.35 701,586.65 89.07 E75 Capital Projects 1,401,414.33 81,464.83 78,210.48 1,241,739.02 88.61 990 Capital Projects 1,401,414.33 81,464.83 78,210.48 1,241,739.02 88.61 Expense Expense 32,540,119.85 12,264,635.93 1,490,880.40 18,784,603.52 57.73 GL - Trial Balance by Acct Type and Full Acct Number (04/07/2014 - 8:52 AM)Page 35 FUND BALANCE CALCULATION FYE 13 Unassigned General Fund Balance 4,955,493.00$ Per Tentative Audited CAFR Supplemental Appropriation (50,000.00)$ Bill 2013-105 Ordinance 15204 - ALPLA Settlement Supplemental Appropriation (100,000.00)$ Bill 2013-133 Ordinance 15231 - Replenish Funds Used for Street Chemicals Estimated FY14 Fund Balance 4,805,493.00$ Unreserved Fund Balance Percentage 16.75%Based on original budget of $28,688,000 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 1 SOURCES AND USES OF FUNDS City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - Dated Date01/15/2015 Delivery Date01/15/2015 Sources: Bond Proceeds: Par Amount7,905,000.00 Net Premium19,058.90 7,924,058.90 Uses: Project Fund Deposits: Project Fund7,785,721.40 Cost of Issuance: ($17.5 / 1000)138,337.50 7,924,058.90 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 2 BOND DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - Period Annual EndingPrincipalCouponInterestDebt ServiceDebt Service 04/01/201559,417.2259,417.22 10/01/2015180,0002.000%140,725.00320,725.00 10/31/2015380,142.22 04/01/2016138,925.00138,925.00 10/01/2016295,0002.000%138,925.00433,925.00 10/31/2016572,850.00 04/01/2017135,975.00135,975.00 10/01/2017300,0002.000%135,975.00435,975.00 10/31/2017571,950.00 04/01/2018132,975.00132,975.00 10/01/2018305,0003.000%132,975.00437,975.00 10/31/2018570,950.00 04/01/2019128,400.00128,400.00 10/01/2019315,0003.000%128,400.00443,400.00 10/31/2019571,800.00 04/01/2020123,675.00123,675.00 10/01/2020325,0003.000%123,675.00448,675.00 10/31/2020572,350.00 04/01/2021118,800.00118,800.00 10/01/2021335,0003.000%118,800.00453,800.00 10/31/2021572,600.00 04/01/2022113,775.00113,775.00 10/01/2022345,0003.000%113,775.00458,775.00 10/31/2022572,550.00 04/01/2023108,600.00108,600.00 10/01/2023355,0003.125%108,600.00463,600.00 10/31/2023572,200.00 04/01/2024103,053.13103,053.13 10/01/2024365,0003.375%103,053.13468,053.13 10/31/2024571,106.26 04/01/202596,893.7596,893.75 10/01/2025380,0003.375%96,893.75476,893.75 10/31/2025573,787.50 04/01/202690,481.2590,481.25 10/01/2026390,0003.750%90,481.25480,481.25 10/31/2026570,962.50 04/01/202783,168.7583,168.75 10/01/2027405,0003.750%83,168.75488,168.75 10/31/2027571,337.50 04/01/202875,575.0075,575.00 10/01/2028420,0004.000%75,575.00495,575.00 10/31/2028571,150.00 04/01/202967,175.0067,175.00 10/01/2029440,0004.000%67,175.00507,175.00 10/31/2029574,350.00 04/01/203058,375.0058,375.00 10/01/2030455,0004.000%58,375.00513,375.00 10/31/2030571,750.00 04/01/203149,275.0049,275.00 10/01/2031475,0004.250%49,275.00524,275.00 10/31/2031573,550.00 04/01/203239,181.2539,181.25 10/01/2032495,0004.250%39,181.25534,181.25 10/31/2032573,362.50 04/01/203328,662.5028,662.50 10/01/2033515,0004.250%28,662.50543,662.50 10/31/2033572,325.00 04/01/203417,718.7517,718.75 10/01/2034535,0004.375%17,718.75552,718.75 10/31/2034570,437.50 04/01/20356,015.636,015.63 10/01/2035275,0004.375%6,015.63281,015.63 10/31/2035287,031.26 7,905,0003,633,542.2411,538,542.2411,538,542.24 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 3 NET DEBT SERVICE City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - PeriodTotalNet EndingPrincipalCouponInterestDebt ServiceDebt Service 10/31/2015180,0002.000%200,142.22380,142.22380,142.22 10/31/2016295,0002.000%277,850.00572,850.00572,850.00 10/31/2017300,0002.000%271,950.00571,950.00571,950.00 10/31/2018305,0003.000%265,950.00570,950.00570,950.00 10/31/2019315,0003.000%256,800.00571,800.00571,800.00 10/31/2020325,0003.000%247,350.00572,350.00572,350.00 10/31/2021335,0003.000%237,600.00572,600.00572,600.00 10/31/2022345,0003.000%227,550.00572,550.00572,550.00 10/31/2023355,0003.125%217,200.00572,200.00572,200.00 10/31/2024365,0003.375%206,106.26571,106.26571,106.26 10/31/2025380,0003.375%193,787.50573,787.50573,787.50 10/31/2026390,0003.750%180,962.50570,962.50570,962.50 10/31/2027405,0003.750%166,337.50571,337.50571,337.50 10/31/2028420,0004.000%151,150.00571,150.00571,150.00 10/31/2029440,0004.000%134,350.00574,350.00574,350.00 10/31/2030455,0004.000%116,750.00571,750.00571,750.00 10/31/2031475,0004.250%98,550.00573,550.00573,550.00 10/31/2032495,0004.250%78,362.50573,362.50573,362.50 10/31/2033515,0004.250%57,325.00572,325.00572,325.00 10/31/2034535,0004.375%35,437.50570,437.50570,437.50 10/31/2035275,0004.375%12,031.26287,031.26287,031.26 7,905,0003,633,542.2411,538,542.2411,538,542.24 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 4 BOND SUMMARY STATISTICS City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - Dated Date01/15/2015 Delivery Date01/15/2015 Last Maturity10/01/2035 Arbitrage Yield3.830490% True Interest Cost (TIC)3.830490% Net Interest Cost (NIC)3.877729% All-In TIC4.025075% Average Coupon3.898176% Average Life (years)11.791 Weighted Average Maturity (years)11.724 Duration of Issue (years)9.261 Par Amount7,905,000.00 Bond Proceeds7,924,058.90 Total Interest3,633,542.24 Net Interest3,614,483.34 Bond Years from Dated Date93,211,333.33 Bond Years from Delivery Date93,211,333.33 Total Debt Service11,538,542.24 Maximum Annual Debt Service574,350.00 Average Annual Debt Service557,118.46 Underwriter's Fees (per $1000) Average Takedown Other Fee Total Underwriter's Discount Bid Price100.241099 ParAverageAveragePV of 1 bp Bond ComponentValuePriceCouponLifechange Serial Bonds2,755,000.00101.9002.924%5.0521,285.85 Term Bond745,000.0099.1523.375%10.221655.60 Term Bond #2795,000.00100.0693.750%12.221588.30 Term Bond #31,315,000.0099.0734.000%14.7381,499.10 Term Bond #41,485,000.0099.2294.250%17.7381,885.95 Term Bond #5810,000.0099.5224.375%20.0511,093.50 7,905,000.0011.7917,008.30 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 5 BOND PRICING City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - MaturityYield toCallCallPremium Bond ComponentDateAmountRateYieldPriceMaturityDatePrice(-Discount)Principal Cost Serial Bonds: 10/01/2015180,0002.000%0.550%101.0271,848.60181,848.60 10/01/2016295,0002.000%0.890%101.8805,546.00300,546.00 10/01/2017300,0002.000%1.300%101.8585,574.00305,574.00 10/01/2018305,0003.000%1.690%104.69114,307.55319,307.55 10/01/2019315,0003.000%2.110%103.96912,502.35327,502.35 10/01/2020325,0003.000%2.480%102.7508,937.50333,937.50 10/01/2021335,0003.000%2.770%101.3974,679.95339,679.95 10/01/2022345,0003.000%2.970%100.202696.90345,696.90 10/01/2023355,0003.125%3.190%99.506 (1,753.70)353,246.30 2,755,000 52,339.15 2,807,339.15 Term Bond: 10/01/2024365,0003.375%3.470%99.152 (3,095.20)361,904.80 10/01/2025380,0003.375%3.470%99.152 (3,222.40)376,777.60 745,000 (6,317.60)738,682.40 Term Bond #2: 10/01/2026390,0003.750%3.740%100.069C3.743%10/01/2023100.000269.10390,269.10 10/01/2027405,0003.750%3.740%100.069C3.743%10/01/2023100.000279.45405,279.45 795,000 548.55 795,548.55 Term Bond #3: 10/01/2028420,0004.000%4.080%99.073 (3,893.40)416,106.60 10/01/2029440,0004.000%4.080%99.073 (4,078.80)435,921.20 10/01/2030455,0004.000%4.080%99.073 (4,217.85)450,782.15 1,315,000 (12,190.05)1,302,809.95 Term Bond #4: 10/01/2031475,0004.250%4.310%99.229 (3,662.25)471,337.75 10/01/2032495,0004.250%4.310%99.229 (3,816.45)491,183.55 10/01/2033515,0004.250%4.310%99.229 (3,970.65)511,029.35 1,485,000 (11,449.35)1,473,550.65 Term Bond #5: 10/01/2034535,0004.375%4.410%99.522 (2,557.30)532,442.70 10/01/2035275,0004.375%4.410%99.522 (1,314.50)273,685.50 810,000 (3,871.80)806,128.20 7,905,000 19,058.907,924,058.90 Dated Date01/15/2015 Delivery Date01/15/2015 First Coupon04/01/2015 Par Amount7,905,000.00 Premium19,058.90 Production7,924,058.90100.241099% Underwriter's Discount Purchase Price7,924,058.90100.241099% Accrued Interest Net Proceeds7,924,058.90 Mar 31, 2014 5:59 pm Prepared by Piper Jaffray & Co. Page 6 BOND SOLUTION City of Jefferson, Missouri Certificates of Participation Series 2015 - Preliminary, 'A+' Rated - PeriodProposedProposedTotal AdjRevenueUnusedDebt Serv EndingPrincipalDebt ServiceDebt ServiceConstraintsRevenuesCoverage 10/31/2015180,000380,142380,142383,3333,191100.83936% 10/31/2016295,000572,850572,850575,0002,150100.37532% 10/31/2017300,000571,950571,950575,0003,050100.53326% 10/31/2018305,000570,950570,950575,0004,050100.70934% 10/31/2019315,000571,800571,800575,0003,200100.55964% 10/31/2020325,000572,350572,350575,0002,650100.46300% 10/31/2021335,000572,600572,600575,0002,400100.41914% 10/31/2022345,000572,550572,550575,0002,450100.42791% 10/31/2023355,000572,200572,200575,0002,800100.48934% 10/31/2024365,000571,106571,106575,0003,894100.68179% 10/31/2025380,000573,788573,788575,0001,213100.21132% 10/31/2026390,000570,963570,963575,0004,038100.70714% 10/31/2027405,000571,338571,338575,0003,663100.64104% 10/31/2028420,000571,150571,150575,0003,850100.67408% 10/31/2029440,000574,350574,350575,000650100.11317% 10/31/2030455,000571,750571,750575,0003,250100.56843% 10/31/2031475,000573,550573,550575,0001,450100.25281% 10/31/2032495,000573,363573,363575,0001,638100.28560% 10/31/2033515,000572,325572,325575,0002,675100.46739% 10/31/2034535,000570,438570,438575,0004,563100.79982% 10/31/2035275,000287,031287,031287,500469100.16331% 7,905,00011,538,54211,538,54211,595,83357,291 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Convention Center Fund (4/7) May-11 6/20/11 91,258.41 38,328.53 51,104.71 Jun-11 7/20/11 101,479.82 42,621.54 56,828.68 Jul-11 8/20/11 88,392.47 37,124.82 49,499.80 Aug-11 9/20/11 73,144.02 30,720.48 40,960.66 Sep-11 10/20/11 103,618.61 43,519.80 58,026.44 Oct-11 11/20/11 105,531.99 44,323.44 59,097.91 Nov-11 12/20/11 66,556.88 27,953.89 37,271.85 Dec-11 1/20/12 52,204.97 21,926.07 29,234.80 Jan-12 2/20/12 65,645.72 27,571.20 36,761.61 566.37 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge Jul-12 8/20/12 89,904.69 37,759.97 50,346.63 Aug-12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) Ck #1001 - C H Johnson Consulting Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Convention Center Fund (4/7) Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 8/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Nov-13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 1/2014 Interest Received (8.28) 1/2014 Service Charge Dec-13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 2/2014 Interest Received (8.28) 2/2014 Service Charge Jan-14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) Ck #1007 - C H Johnson Consulting 2,078.72 3/2014 Interest Received (8.45) 3/2014 Service Charge Feb-14 3/20/14 80,825.68 33,946.79 45,262.38 Total 2,994,706.24 1,257,776.63 1,662,660.96 average monthly amount for Convention Center Fund 49,324.57$ 2014 Occupancy 2013 Occupancy 2012 Occupancy January 49.20%45.30%38.20% February 56.00%52.90%49.80% March 52.90%54.90% April 64.10%53.90% May 56.80%53.70% June 55.70%53.10% July 58.50%51.40% August 55.80%47.00% September 63.00%59.30% October 65.90%59.30% November 52.40%43.40% December 38.80%33.00% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi -Segment Missouri Hotel & Lodging Association For the month of: February 2014 Currency: USD - US Dollar Properties Rooms Census Sample Census Sample 51511 30336 4865008 3522172 West North Central Occ % 49.01 85.50 ADR RevPAR Percent Change from February 2013 40.611 3.7 i Room Room Room 8.5 2014 2013 2014 2013 2014 2013 occ ADR RevPAR Rev Avail Sold United States 1 60.3 58.4 111.94 107.77 67.49 62.891 3.3 3.9 7.3 8.2 0.8 4.2 Currency: USD - US Dollar Properties Rooms Census Sample Census Sample 51511 30336 4865008 3522172 West North Central 50.8 49.01 85.50 82.861 43.47 40.611 3.7 i Currency: USD - US Dollar Properties Rooms Census Sample Census Sample 51511 30336 4865008 3522172 West North Central 50.8 49.01 85.50 82.861 43.47 40.611 3.7 3.2 7.0 8.5 1.3 5.1 46.9 45.3 84.10 81.941 39.48 37.091 3.7 2.6 6.5 7.8 1.3 5.1 4278 2502 334797 241677 Missouri 48.6 46AI 83.97 80.961 40.83 37.531 4.9 3.7 8.8 8.5 0.2 4.644.3 -3.3 42.0 82.00 79.82 36.30 33.491 5.5 2.7 8.4 8.0 0.4 5.11 1072 6141 98367 70598 Kansas O 29.9 82.00 78.32 26.30 23.43 7.2 4.7 12.3 12.4 0.1 7.3 Joplin, MO 50.7 47.3 68.14 67.28 34.54 31.82 7.2 1.3 8.5 8.5 0.0 2-9 St Louis, IL 56.4 51.2 89.52 84.30 50.45 43.16 10.1 6.2 16.9 15.7 -10 .0 9.0 50.6 46.7 86.89 82.84 43.94 38.69 8.3 4.9 13.5 12.6 0.8 7.4 325 2310 37803 31013 48.4 47.2 76.36 70.85 36.92 Columbia, MO+ 54.3 53.2 80.33 73.70 43.62 39.24 2.0 9.0 11.1 11.1 -0.1 1.9 Jefferson City, MO+ 56.0 52.9 73.44 68.59 41.12 36.30 5.8 7.1 13.3 18.9 4.9 11.0 Springfield, MO 47.3 43.9 72.69 70.51 34.36 30.93 7.8 3.1 11.1 7.4 -3.3 4.2 Branson, MO 23.3 22.3 79.72 79.16 18.60 17.68 4.5 0.7 5.2 6.0 0.8 5.3 Lake of the Ozarks+ 32.1 29.9 82.00 78.32 26.30 23.43 7.2 4.7 12.3 12.4 0.1 7.3 Joplin, MO 50.7 47.3 68.14 67.28 34.54 31.82 7.2 1.3 8.5 8.5 0.0 7.2 48.4 47.2 76.36 70.85 36.92 33.43 2.5 7.8 10.5 10.4 -0.1 2.4 52.4 48.8 72.73 69.74 38.11 34.06 7.3 4.3 11.9 14.4 2.3 9.7 43.0 39.8 72.41 70.53 31.17 28.04 8.3 2.7 11.2 7.5 -3.3 4.7 21.1 18.7 81.35 79.74 17.18 14.91 13.0 2.0 15.2 13.5 -1.5 11.3 28.5 28.4 81.09 78.53 23.12 22.28 0.5 3.2 3.7 5.3 1.5 2.0 46.3 43.5 67.33 67.42 31.15 29.31 6.4 -0.1 6.3 6.3 0.0 6.4 36 28 3652 3119 15 11 1494 1063 66 43 5996 4267 113 30 10554 4431 33 12 2578 1568 34 23 2713 2225 A blank row indicates insufficient data. Source 2014 SMITH TRAVEL RESEARCH, Inc. DISCLOSURE Destination Reports are publications of Smith Travel Research, Inc. (Reports containing only North American data) and STIR Global Ltd (Reports containing worldwide data) and are intended solely for use by our paid subscribers. Reproduction or distribution of Destination Reports, in whole or part, without written permission of either Smith Travel Research, Inc. or STIR Global Ltd. is prohibited and subject to legal action. Site licenses are available. Please consult your contract with Smith Travel Research, Inc. or STIR Global Ltd for the terms and conditions governing the ownership, distribution and use of Destination Reports and their contents. 1 BILL NO. [Bill No.] SPONSORED BY COUNCILMAN _______________________ ORDINANCE NO. AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, AMENDING CHAPTER 26A (PURCHASING) AND CHAPTER 2 (ADMINSISTRATION), ARTICLE IV (DIVISION 1. CITY ADMINISTRATOR), SECTION 307 (POWERS) OF THE CODE OF THE CITY OF JEFFERSON BY REVISING THE PURCHASING PROCEDURES. BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, A S FOLLOWS: Section 1. Chapter 26A (Purchasing and Finance) is hereby amended as follows: ARTICLE I. GENERALLY Sec. 26A-1. Statement of Purpose The purpose of these purchasing procedures is to balance the goals hereinafter listed to the greatest degree possible for the benefit of the taxpayers. These goals are declared to be in the best interest of the taxpayers: 1. Satisfy Requirements. To comply with federal and state law and conditions of any grant or purchase when necessary but not burden other procedures when the same are not applicable. 2. Accountability. To provide accountability to the public, city council, and staff management, which provides transparency and prevents extravagance, fraud, and corruption. 3. Value. To maximize to the fullest extent the purchasing power of the City, to achieve the best value possible with taxpayer money, and prevent expense in processes. 4. Efficiency. To ensure that taxpayer money is used to maximum benefit by providing timely purchasing, clear and consistent regulations, and policies that allow city staff to maximize the productive use of their time. Sec. 26A-347. Fiscal year. The fiscal year of the city shall commence on the first day of November in each year and terminate on the thirty-first day of October of the following year, and the books, accounts and reports of the officers of the city shall be made to conform thereto. (Code 1977, § 16-1; Code 1983, § 2-352) (Previously codified in section 2-347) Sec. 26A-348. Annual audit. An audit of the financial affairs and records of the city shall be made by a certified public accountant annually, and the audit shall be commenced within thirty (30) days after the close of business for the preceding fiscal year. (Code 1977, § 16-6; Code 1983, § 2-353) (Previously codified in section 2-348) Secs. 26A-349 – 26A-352. Reserved 2 Sec. 26A-353. Enforcement of licensing and similar ordinances. A. It shall be the duty of the finance department to enforce all provisions of ordinances of the city regulating: 1. The licensing of trades, businesses, vocations and occupations within the city. 2. The licensing of peddlers, transient merchants, solicitors and canvassers within the city. 3. The licensing of the manufacture, distribution or sale of intoxicating liquor and nonin toxicating beer within the city. B. In the performance of such duties, the authorized agents of the finance department shall have the power: 1. To enter any business establishment in the city to determine if the provisions of all ordinances of the city pertaining to the issuance of licenses are being observed. 2. To demand presentation to him and inspect every license required by ordinances of the city to be issued. (Code 1977, §§ 22-1, 22-2; Code 1983, § 2-354) (Previously codified in section 2-353) Cross references - Alcoholic beverages, Ch. 4; licenses, taxes and miscellaneous business regulations, Ch. 17; peddlers, solicitors, itinerant merchants, etc. Ch.24. Section 26A-354. Reserved. Sec. 26A-355. Appropriations. The City through its annual budgeting process shall adopt appropriations or shall set out authorized appropriations by category. Appropriations shall be divided into two classifications to be known as “annual appropriations” and “continuing appropriations.” The characteristics and practice with regard to each of these categories of appropriations shall be as set out in the subsections below. A. Annual appropriations: All appropriations shall be considered an annua l appropriation unless specifically designated either by category or by indication within the budget document as a continuing appropriation. Unencumbered annual appropriations shall lapse at the close of each fiscal year. Annual appropriations shall not be subjected to reappropriation. B. Continuing appropriations: All appropriations for capital improvement projects and for grant funds including any matching funds required by the grant shall be considered continuing appropriations. Any sums appropriated through and designated as continuing appropriations shall continue for the life of the project or grant regardless of fiscal years. Continuing appropriations shall not be subject to changes or transfers between projects or grants without council approval. Any funds remaining unexpended at the completion of the project or grant would automatically be added into the fund in which they had been appropriated. C. Reporting requirement: City staff shall prepare and forward to the Council at least semi -annually a report of the status of all projects and grants which have been designated as continuing appropriations. The reports shall include as a minimum the original date of the appropriation, funds expended and project completion status. It should also show anticipated conclusion of each project or grant. D. Parks and Recreation Commission Budget: The parks commission shall prepare an annual budget to be submitted to the mayor as part of his annual budget. Such budget shall not take effect until approved by the Council. Such funds may be only drawn upon by the director of finance upon the properly authorization of the parks and recreation commission. (Ord. 13828, §1, 1-18-2005) (Ord. No. 12562, § 1, 12-16-96) 3 (Previously codified in section 2-355) Secs. 26A-356 – 26A-373. Reserved. Sec. 26A-374 26A-2. Definitions. Whenever the following words appear in this division they shall have the meaning set out below: Business: shall mean any corporation, partnership, individual, sole proprietorship, joint stock company, joint venture, or any other private legal entity. City Council or Council: Shall mean the Council of the City of Jefferson or the Parks and Recreation Commission based on the nature of the project or contract. City Administrator : Shall mean the City Administrator and/or designee or the Parks and Recreation Commission based on the nature of the project or contract. Construction: means the process of building, altering, repairing, improving, or demolishing any public infrastructure facility, including any public structure, public building, or other public improvements of any kind to real property. It does not include the routine operation, routine repair, or routine maintenance of any existing public infrastructure facility, including structures, buildings, or real property. Contract: means all types of agreements, regardless of what they may be called, for the procurement or disposal of supplies, services, or construction. Contractor: means any person having a contract with a governmental body Department Director. The Director of a city department who has been assigned to admi nister a contract or project by the city administrator. Employee: means an individual drawing a salary from a governmental body, whether elected or not, and any uncompensated individual performing personal services for any governmental body, or any elected or appointed official of the City. Equipment: means a vehicle powered by a motor traveling on wheels or tracks, and designed to be ridden by its operator, items which are used when affixed to such vehicles; or, trailers and other devices which are towed by a motor vehicle as well as items attached to them; or, devices which are powered by a motor and which are operated by a person walking behind the device and which said device has a purchase price of no less than Five Thousand Dollars ($5000) ($5,000.00). Person: means any business, individual, union, committee, club, other organization, or group of individuals. Procurement: means buying, purchasing, renting, leasing, or otherwise acquiring any supplies, services or construction. It also includes all functions that pertain to the obtaining of any supply, service, or construction, including description of requirements, selection and solicitation of sources, preparation and award of contract, and all phases of contract administration. Services: means the furnishing of labor, time, or effort by a contractor, not involving the delivery of a specific end product other than reports which are merely incidental to the required performance. This term shall not include employment agreements or collective bargaining agreements. Signature: means [enter the appropriate reference to the State’s applicable Digital Signature Act if enacted] [a manual or electronic identifier, or the electronic result of an authentication technique attached to or logically associated with a record that is intended by the person using it to have the same force and effect as a manual signature.] Supplies: means all property, including but not limited to equipment, materials, printing, insurance, and leases of real property, excluding land or a permanent interest in land. Vehicle: a motor vehicle used primarily for transporting the driver and passengers 4 Written or In Writing: means the product of any method of forming characters on paper, other materials, or viewable screens, which can be read, retrieved, and reproduced, including information that is electronically transmitted and stored. (Previously codified in section 2-374) Sec. 26A-3. Federal, State and Grant requirements. A. Any requirement placed by Federal or State law or as a condition of grant accepted by the Council, shall be deemed to be an additional requirement to these purchasing rules. B. No such condition identified in Section A above shall be imposed as a purchasing requirement unless expressly required by Federal or State law or by condition of a grant approved by the City Council. [Purpose: not burden other purchases with unnecessary red tape[ Sec. 26A-4. Electronic Signatures. Unless expressly prohibited by Federal or State Law, scanned or electronic signatures are deemed to be acceptable for purposes of the purchase of goods and services. Sec. 26A-375. Purchasing agent; office established. Moved to Article III, Sec. 26A-30 There is hereby established within the finance department the office of purchasing agent who shall be the head of the purchasing division. (Code 1977, § 16-20; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-375) Sec. 26A-376. Establish and maintain specifications. Moved to 26A-31 The purchasing agent shall compile and maintain specifications for all items purchased, or to be purchased, by the city. The specifications shall not be unduly restrictive and shall be written, if possible and practicable, so that the city may obtain competitive bids. (Code 1977, § 16-21; Ord. No. 9655, § 1, 8-17-81; Ord. No. 10044, § 1(16-21), 9-6-83; Ord. No. 11936, § 2, 7-19- 93) (Previously codified in section 2-376) Sec. 26A-377. Standards and procedure. Moved to 26A-33 The purchasing agent shall observe the following standards and procedures in the administration of this division: A. The purchasing agent shall purchase those supplies, materials and equipment requested by the department for whose use they are intended. The purchasing agent shall keep the department s informed on prices, changes, deliveries and other information that will assist them in placing purchase orders at such times as to ensure purchasing at the best possible prices. B. All supplies, materials and equipment disposed of by sale or otherwise shall be sold by the purchasing agent only with the advice and consent of the mayor and council. Supplies, materials and equipment deemed to be obsolete, unusable and of no monetary value to the City, may be disposed of by the purchasing agent at an approved landfill or disposal site. The purchasing agent shall determine, based on recommendations from the staff, what property has no monetary value. The purchasing agent shall file a report with the council annually setting forth what property was determined to be of no value and how such property was disposed. C. Copies of all correspondence with suppliers concerning prices, adjustments or defective merchandise, as well as all invoices, bills of lading, delivery tickets and other papers pertaining to purchases, shall be 5 delivered to the purchasing agent. D. The purchasing agent shall maintain a complete record of all quotations, bids and purchase orders for a period of five (5) years, and such records shall at all times be open to the public for inspection. Only proposals and related documents will be closed until the earlier of the making of a recommendation to the public governmental body or the acceptance or rejection of all proposals. E. The purchasing agent shall maintain supervisory control over all purchases and shall determine whether any claims for shortages, breakages or other claims exist, in which case he shall pursue all such claims against the shipper or carrier or supplier for any shortage, breakage or other damage existing. F. Notwithstanding the foregoing paragraphs the purchasing agent may designate types of personal property as “disposable” which may then be deposited into the land fill by departments without notice to the purchasing agent and without annual notice to the Council. To be “disposable” the property must be declared as disposable by the purchasing agent, and designed to be thrown away after use and have no monetary value after use. Examples may include but are not limited to paper, pencils, pens, plastic bags, and cardboard. (Ord. 14866, § 2, 10-17-2011) (Code 1977, § 16-22; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-377) Sec. 2-378 26A-5 Promulgation of rules. The purchasing agent shall recommend to the finance director, for his/her review and recommendations to the city administrator , may adopt rules and regulations relating to the procedure to be followed by city employees in the preparation and submission of purchasing requests and invoices for purchases not in conflict with the City Code or City Charter. (Code 1977, § 16-23; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-378) Sec. 26A-379. Purchasing limits. Replaced with a new 26A-40 General provision for purchases of goods & services. A. The purchasing agent shall adopt operational procedures for making small purchases of three thousand dollars ($3,000.00) or less. Such operating procedures shall allow purchasing without competitive bids but shall be at the discretion of the department heads and the purchasing division. Purchases must be requisitioned through the normal purchasing procedure. B. The purchasing agent shall request quotations or telephone bids from at least three (3) businesses or vendors on all requisitions of items of a value of more than three thousand dollars ($3,000.00) and not more than twenty-five thousand dollars ($25,000.00). The names of the businesses submitting quotations, the date and the amount of each quotation shall be recorded and maintained. The lowest and best bid shall be selected by the purchasing agent upon consultation with the appropriate department director. C. The purchasing agent shall advertise for sealed bids on any requisition involving more than twenty-five thousand dollars allowing a minimum of fourteen (14) days before bids are received and opened. The lowest and best bid submitted by a responsible bidder meeting specifications will be recommended to the City Council for an award. (Code 1977, § 16-25; Ord. No. 9655, § 2, 8-17-81; Ord. No. 10044, § 1(16-25(c)-(d)), 9-6-83; Ord. No. 11936, § 2, 7-19-93; Ord. 13209, §1, 6-4-2001) (Previously codified in section 2-379) Sec. 26A-380. Emergency purchases. Moved to Sec. 26A-64 When a disaster has not been declared by the Mayor, notwithstanding any other provisions of this division, the City Administrator or designee may make or authorize others to make emergency procurement of supplies, services, or construction items when there exists a threat to public health, welfare, or safety; provided that such emergency procurement shall be made with such competition as is practicable under the circumstances. A written determination of the basis for the emergency and for the selection of the particular contractor shall be included in a record of each emergency procurement which shall be made and shall set forth the contractor's name, the amount 6 and type of the contract, a listing of the item(s) procured under the contract, and the identification number of the contract file. A copy of the record shall be given within five days of the purchase to the City Administrator and purchasing division. If a disaster has been declared, or if a disaster is later declared the provisions of Chapter 11, Emergency Preparedness and Emergencies, shall be followed. In any case where a purchase under this section might be reimbursable under Federal or State Disaster Relief provisions, the Department Director shall maintain such records as are required for such reimbursement. An emergency exists as defined below: An emergency exists when a breakdown in machinery and/or a threatened termination of essential services, including but not limited to maintenance and repair of essential office equipment, or a dangerous condition develops, or when supplies are needed for immediate use in work which may vitally affect safety, health or welfare of the public. (Code 1977, § 16-29(a); Code 1983, § 2-403; Ord. No. 11936, § 2, 7-19-93; Ord. No. 14051, §2, 6-5-2006) (Previously codified in section 2-380) Sec. 26A-381. Small sum purchases. Moved to 26A-44 Any employee of the city making a purchase involving an immediate cash expenditure of fifty dollars ($50.00) or less shall be reimbursed by the city upon submission of a sales ticket for the purchase. (Code 1977, § 16-29(b); Code 1983, § 2-404; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-381) Sec. 26A-382. Cooperative purchasing. Moved to 26A-65 A. The City of Jefferson desires to participate in the cooperative procurement program with the State of Missouri, the County of Cole, the Housing Authority and any other interested governmental bodies. The purchasing agent shall be the designated city representative for the administration of the cooperative procurement program. (Resolution passed 8-20-79) B. In lieu of the purchasing requirements set out in this chapter, the purchasing agent shall be authorized to approve purchases based upon a bid received by another government entity within this State, provided that all of the following requirements are met: 1. The other entity must have competitively bid the purchase using procedures which are substantially similar to the procedures which would have been required had the City of Jefferson bid the purchase itself as determined by the purchasing agent; and, 2. The purchasing agent receives verification, acceptable to the purchasing agent, that the other governmental entity’s procedures wer e actually followed; and 3. The successful bidder to the other governmental entity must state in writing, in a form acceptable to the purchasing agent, that the City of Jefferson is authorized to make the same purchase at the same price. (Previously codified in section 2-382) Sec. 26A-383 26A-6 Preference for U.S.-manufactured goods. A. Each contract for the purchase or lease of manufactured goods or commodities by the City, and each contract made by the City for construction, alteration, repair, or maintenance of any public works shall contain a provision that any manufactured goods or commodities used or supplied in the performance of that contract or any subcontract thereto shall be manufactured or produced in the United States. This section shall not apply where the purchase, lease, or contract involves an expenditure of less than twenty- five thousand dollars $25,000.00). This section shall not apply when only one line of a particular good or product is manufactured or produced in the United States. This section shall not apply where the executive head of the public agency certifies in writing that: 1. The specified products are not manufactured or produced in the United States in sufficient quantities to meet the agency's requirements or cannot be manufactured or produced in the United 7 States within the necessary time in sufficient quantities to meet the agency's requirements; 2. Obtaining the specified products manufactured or produced in the United States would increase the cost of the contract by more than ten percent; B. Every commission, board, committee, officer or other body of the City shall purchase and use only those materials, products, supplies, provisions and other needed articles produced, manufactured, compounded, made or grown within the state of Missouri, when they are found in marketable quantities in the state and are of a quality suited to the purpose intended and can be secured without additional cost over foreig n products or products of other states; provided, however, that quality and fitness of articles shall be considered in purchasing or letting contracts for articles herein mentioned (Ord. 10939, § 1, 10-19-87; Ord. No. 11936, § 2, 7-19-93 State Law reference Sub-Section A § 34.353 RSMo, Sub- Section B § 71.140. RSMo.) (Previously codified in section 2-383) Sec 26A-383.1 26A-7. Preference to Missouri products and firms. A. In making purchases, the City shall give preference to all commodities and tangible personal property manufactured, mined, produced, processed, or grown within the State of Missouri, to all new generation processing entities defined in section 348.432, RSMo, except new generation processing entities that own or operate a renewable fuel production facility or that produce renewable fuel, and to all firms, corporations or individuals doing business as Missouri firms, corporations or individuals, when quality is equal or better and delivered price is the same or less. The City may also give such preference whenever competing bids, in their entirety, are comparable. For purposes of this section, “commodities” shall include any agricultural product that has been State Law reference § 34.070 RSMo, B. Provision B Paragraph A shall not be applicable when prohibited by state or federal law or would violate any funding condition set out by the State or Federal government. (Previously codified in section 2-383.1) Sec. 26A-8. Council Preference Substitution. A. For any award or selection required by the City Council, the City Council may substitute its judgment for that of staff’s judgment and make any selection it feels is in the best interest of the City. B. If a contract is brought before the City Council as a result of a competitive bidding process, and the City Council substitutes the name of the party recommended for award of the contract with another party who also submitted a bid, then there shall be a presumption that the City Council intended to also approve the price of the bid of the substituted party. C. The presumption shall be overcome if specifically stated to the contrary in a motion approved by the Council as a whole. Sec. 26A-9. Signatures on Financial Accounts. A. The Mayor, City Administrator, and Finance Director shall be designated as signatories for city financial accounts. B. The City Administrator is authorized to execute documents to change the signatories as persons holding the positions identified above change. C. The City Administrator may appoint other Department Directors as signatories if necessary during times of vacancy in any of the above referenced offices. 8 Sec. 26A-9 through 26A—19 reserved. Sec. 26A-10 through 26A—19 reserved. ARTICLE II. City Administrator Purchasing Authority Sec. 26A-20. City administrator power to execute contracts. Notwithstanding the provisions of section 2-378 regarding the promulgation of purchasing rules, A. The city administrator is hereby authorized to sign contracts on behalf of the city, provided the following criteria are met: 1. The contract has a cumulative total value of less than twenty five thousand dollars ($25,000.00) no greater than twenty-four thousand, nine hundred ninety-nine dollars and ninety-nine cents ($24,999.99), unless specifically authorized by the City Council; or 2. The contract or purchase has a combined total value of no greater than fifty thousand ($50,000.00), the City administrator may place the same on the consent agenda for approval by the Council in one meeting. Such contract or purchase shall be considered rejected if any two councilpersons vote to reject the same. B. The city administrator shall not have the power to sign any contract pertaining to the purchase or sale of real estate, unless specifically authorized by the City Council, except that such prohibition shall not apply to : 1. Leases which are no more than twenty five thousand dollars ($25,000) in total val ue including all renewals; or 2. The accepting or granting of easements across city property. (Replaces former Sec. 2-290g) [Purpose is to allow more timely/efficient purchases of goods between $25K and $50K] Sec. 26A-21. City administrator power to execute change orders. The City administrator is hereby authorized to execute change orders to contracts including increasing the amount to be expended under the contract provided the following criteria are met: A. The change order has previously been approved by the department director of the department administering the contract and the financial amount involved does not exceed ten percent (10%) in total of the original contract amount with any previously approved change orders on that contract, or of less than twenty-five thousand dollars ($25,000.00) ten thousand dollars ($10,000), whichever is greater. For the purposes of this section, the term “original” contract shall mean the contract as approved by the Council and execu ted by the appropriate official as well as any amendments to the contract which have been duly approved by 9 the Council. B. The change order does not change the general scope of the work project. C. All change orders approved shall be reported to the city council within two weeks of execution. The report shall include the reason for the change order . (Previously codified as Chapter 2 –307F) [Purpose: Recognizes that City Admin. Could just sign another contract thus eliminates inefficiency ] Sec. 26A-22. City administrator power to accept grants. The city administrator may, on behalf of the city, accept any grant, gift, or donation, which requires the city to pay out an equivalent expense, not in excess of five thousand dollars ($5,000.00) $2,000, and shall may amend the budget to reflect the acceptance of such revenue, and shall may amend the budget to reflect equivalent expenses so as to accomplish the purpose of such funds. (Previously codified Chapter 2-307H) Sec. 26A-23. Variations authorized (the common sense provision). A. The city administrator is authorized to make variations from these procedures in the following situations: 1. The variation must be a result of the purchase having an unusual or unique quality that requires variation in order to effectively accomplish the purchase and it is in the best interest of the City. 2. An emergency has been declared pursuant to the provisi ons of the City Code. B. Any such variation shall be promptly reported to the City Council through a written memorandum which shall be kept for at least 3 years following the variation. [Purpose: to avoid conflicts over trivial problems, exempt out when nece ssary and cover the FEMA provisions that a city must follow its own purchasing provisions to be reimbursed] Sec. 26A-24 through 26A—29 reserved. ARTICLE III. Office of the Purchasing Agent Sec. 26A-375 26A-30. Purchasing agent; office established. There is hereby established within the finance department the office of purchasing agent who shall be the head of the purchasing division. (Code 1977, § 16-20; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-375) Sec. 26A-376 26A-31 . Establish and maintain specifications. The purchasing agent shall compile and maintain specifications for all items purchased, or to be purchased, by the city. The specifications shall not be unduly restrictive and shall be written, if possible and practicable, so that 10 the city may obtain competitive bids. (Code 1977, § 16-21; Ord. No. 9655, § 1, 8-17-81; Ord. No. 10044, § 1(16-21), 9-6-83; Ord. No. 11936, § 2, 7-19- 93) (Previously codified in section 2-376) Sec. 26A-377 33. Standards and procedure. The purchasing agent shall observe the following standards and procedures in the administration of this division: A. The purchasing agent shall purchase those supplies, materials and equipment requested by the department for whose use they are intended. The purchasing agent shall keep the department s informed on prices, changes, deliveries and other information that will assist them in placing purchase orders at such times as to ensure purchasing at the best possible prices. B. All supplies, materials and equipmen t with an estimated value in excess of one thousand dollars ($1,000.00) disposed of by sale or otherwise shall be sold by the purchasing agent only with the advice and consent of the mayor and council. Supplies, materials and equipment deemed to be obsolete, unusable and of no monetary value to the City with an estimated value in excess of one thousand dollars ($1,000.00), may be lawfully disposed of by the purchasing agent at an approved landfill or disposal site. The purchasing agent shall determine, based on recommendations from the staff, what property has no monetary value. The purchasing agent shall file a report with the council annually setting forth what property was determined to be of no value and how such property was disposed. C. Copies of all correspondence with suppliers concerning prices, adjustments or defect ive merchandise, as well as all invoices, bills of lading, delivery tickets and other papers pertaining to purchases, shall be delivered to the purchasing agent. D. The purchasing agent shall maintain a complete record of all quotations, bids and purchase orders for a period of five (5) years, and such records shall at all times be open to the public for inspection. Only proposals and related documents will be closed until the earlier of the making of a recommendation to the public governmental body or the acceptance or rejection of all proposals. E. The purchasing agent shall maintain supervisory control over all purchases and shall determine whether any claims for shortages, breakages or other claims exist, in which case he shall pursue all such claims against the shipper or carrier or supplier for any shortage, breakage or other damage existing. F. Notwithstanding the foregoing paragraphs the purchasing agent may designate types of personal property as “disposable” which may then be deposited into the lan d fill by departments without notice to the purchasing agent and without annual notice to the Council. To be “disposable” the property must be declared as disposable by the purchasing agent, and designed to be thrown away after use and have no monetary value after use. Examples may include but are not limited to paper, pencils, pens, plastic bags, and cardboard. (Ord. 14866, § 2, 10-17-2011) (Code 1977, § 16-22; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-377) Sec. 26A-389 34. Debarment. A. The purchasing agent is authorized to debar a person from consideration for award of contracts for any of the following reasons: 1. Conviction of a criminal offense as an incident to obtaining or attempting to obtain a public or private contract or subcontract, or in the performance of such contract or subcontract. 2. Conviction under state or federal statutes of embezzlement, theft, forgery, bribery, falsification or destruction of records, receiving stolen property, or any other offense indicating a lack of integrity or honesty which currently, seriously and directly affects responsibility as a city contractor or vendor. 3. Conviction under state or federal antitrust statutes arising out of the submission of bids or 11 proposals. 4. Deliberate failure without good cause to perform in accordance with contract specifications or within the time limit provided in the contract. 5. A recent record of failure to perform or of unsatisfactory performance in accordance with the terms of one or more contracts; provided that failure to perform or unsatisfactory performance caused by acts beyond the control of the contractor or vendor shall not be considered a basis for debarment. 6. Any other cause so serious and compelling as to affect responsibility as a city contractor, including debarment by another governmental entity for any cause listed in this article. B. The length of a debarment shall not exceed three (3) years. C. An action to debar a contractor may be initiated and shall proceed as follows: 1. The purchasing agent shall initiate a debarment by serving written notice of the debarment to the person he intends to debar. The notice shall set forth the specific grounds for the debarment and advise the person of his right to appeal. The notice shall be served by registered or certified mail or by delivering a copy of the notice to the person subject to debarment or his agent or employee. The debarment shall take effect ten (10) days after service of the notice unless an appeal is taken to the director of finance. If such an appeal is taken, the debarment shall not take effect until a final order upholding the debarment is entered by the director or until the appeal is dismissed by the appellant. 2. Within ten (10) days after service of a written notice of debarment, the person affected by the notice may file a written request for a hearing before the director of finance contesting the debarment. 3. The director of finance shall set the matter for hearing on the record within thirty (30) fifteen (15) days of the receipt of a request for a hearing. At least ten (10) days’ notice of the hearing shall be given to the affected person and to the head of the purchasing division. 4. At the hearing, each party shall have the right to call and examine witnesses, introduce exhibits, cross-examine opposing witnesses and impeach any witness. Oral evidence shall be taken only on oath or affirmation. All evidence shall be suitably recorded and preserved. The technical rules of evidence shall not apply, except the director of finance may exclude evidence which is irrelevant or repetitious. Each party shall be entitled to present oral arguments or written briefs at or after the hearing. 5. Within ten (10) working days of the hearing, the director of finance shall make written findings of fact and conclusions of law and issue a final order. Findings of fact shall be based upon competent and substantial evidence found in the records as a whole. A copy of the director's order, his findings of fact and conclusions of law, shall be delivered or mailed to the purchasing agent and to the affected person. 6. An appeal from the director's order shall be to the circuit court pursuant to Chapter 536, RSMo. The debarment shall not be stayed unless by order of the circuit court. 7. Cost of Proceedings. The cost of debarment proceedings shall be taxed against the losing party. 8. If there are grounds for debarment pending against a bidder, all other bids submitted by the party against which the debarment is pending may be rejected until the department matter is resolved. Nothing in this section shall limit the authority of the purchasing division to accept the bid which in his judgment is the lowest and best bid, or to reject any or all bids or to reject a bid on grounds which could have been used to debar the bidder. (Ord. No. 11936, § 3, 7-19-93) (Previously codified in section 26A-389) Sec. 26A-35 through 26A-39 reserved. 12 DIVISION IV. Purchase of Goods and Services Sec. 26A-40 General Provision for purchases of Goods and Services. Unless otherwise stated, the purchase of goods and services shall be accomplished utilizing the following methods: A. Category 1: Purchases of goods or services valued less than five thousand dollars ($5000.00). The purchases of goods or services which have a value of less than five thousand dollars ($5,000.00) may be purchased without the utilization of bids. Purchases must be requisitioned through the normal purchasing procedures. B. Category 2: Purchases of goods or services valued from five thousand dollars ($5,000) to less than twenty five thousand dollars ($25,000.00). The purchases of goods or services which have a value of from five thousand dollars ($5,000) to less than twenty five thousand dollars ($25,000.00) shall require obtaining three (3) bids or quotes for the cost of the good or service requested. 1. Such bid/quote shall be in writing (with electronic bids or quotes being acceptable), except that purchases made in connection with an emergency declared pursuant to the terms of the City Code, may be oral. 2. A bid for a good may include the sales price of a seller of an online dealer of such goods. 3. The name of the business submitting bids or quotations, the names and contrac t information of the persons designated for communication by the business, the date and the amount of each quotation shall be recorded and maintained. 4. A bid/quote must be received from at least (3) businesses or vendors or an explanation as to why three bids could not be reasonably obtained which is accepted by the city administrator. The lowest and best bid shall be selected by the department director. C. Category 3: Purchases of goods or services valued at twenty five thousand dollars ($25,000) or greater. Purchases of goods or services expected to be twenty five thousand dollars ($25,000) or greater shall be accomplished by sealed bid. The purchasing agent shall advertise for sealed bids on any requisition involving more than twenty-five thousand dollars allowing a minimum of fourteen (14) days before proposals are received and the bids opened. The lowest and best bid submitted by a responsible bidder meeting specifications will be recommended to the City Council for an award. D. Maintenance Contracts. Contracts awarded for maintenance services (including but not limited to electricians and plumbers) based upon an hourly fee shall include provisions to allow for other similar work which may be determined to be beyond maintenance at the discretion of the city administrator so long as there are sufficient budgetary funds. (Replaces Chapter 2 and subsequently 26A -379) Sec. 26A-41. Architectural, Engineering and Land Surveying Services Selection. A. General Provisions. 1. The following procedure describes policies and procedures to be used by City of Jefferson in selecting architectural, engineering and land surveying services referred to as "AELS firms". 13 2. The process for selection of AELS shall be called “Request for Quali fications”. 3. The following provisions for purchase of AELS are governed by the Federal “Brooks Act” (40U.S.C. 1101 et seq) and the State or “Mini Brooks Act” (RSMo 8 Sections 285-291). 4. Selection Committee. For purposes of this section, Selection Committee shall mean a committee appointed by the city administrator which shall be composed of the department director who shall be in charge of the project requiring an AELS Firm and others as appointed. B. Policy. It shall be the policy of City of Jefferson to negotiate contracts with AELS firms for services on the basis of demonstrated competence and qualifications for the type of services required and at fair and reasonable fees. C. AELS Firm List And Evaluation. 1. The purchasing agent shall compile and maintain a file of AELS firms that are potential consultants for doing projects for City of Jefferson. 2. Each AELS firm shall be evaluated within 30 days after completing a contract with the City. The evaluation shall be forward to the purchasing agent for use in future project selections. D. Request for Qualifications. 1. When a project is proposed, the principal department proposing the project shall prepare a description of the project, including the Scope of Work, the identification of applicable plans, a timetable and a project budget. This information shall be compiled into a “Request for Qualifications” for the project. 2. The selection committee shall select AELS firms to be sent a “Request for Quali fications” for the project from the purchasing agent’s list and other sources deemed appropriate. Selection of these AELS firms shall be based upon preliminary review comparing the nature of the job with the experience of the AELS firms and other significant factors. 3. Interested AELS firms shall submit responses to the Request for Qualifications for review by the selection committee. 4. The selection committee shall evaluate the responses and if deemed necessary, some or all the submitting AELS firms may be interviewed. 5. In instances of small, less complex projects, the principal department may choose to select qualified firms from the purchasing agent’s list with no additional submission from the AELS firms required. E. AELS Firm Selection The selection committee shall rank the AELS firms based on the following criteria: 1. The specialized experience and technical competence of the firm with respect to the type of services required; 2. The capacity and capability of the firm to perform the work in question, including specialized services, within the time limitations fixed for the completion of the project; 3. The past record of performance of the firm with respect to such factors as control of costs, quality of work, and ability to meet schedules; 4. The firm's proximity to and familiarity with the area in which the project is located. 5. Any other criteria deemed appropriate for the services sought which may be lawfully considered. F. Negotiation For Contract 1. The selection committee shall select up to three AELS firms that are highly qualified to fulfill the proposed assignment in the best interest of the City. The AELS firms shall be 14 placed in ranked order. 2. The AELS firm ranked first shall be asked to prepare a fee proposal based on the written description of the scope services and negotiations shall proceed. 3. If the committee is unable to negotiate a satisfactory contract with the highest ranked firm selected, negotiations with that firm shall be terminated. The committee shall then undertake negotiations with the second highest ranked AELS firm. If there is a failing of accord with the second firm, negotiations with such firm shall be terminated. The committ ee shall then undertake negotiations with the third most qualified firm. 4. If these negotiations prove unsatisfactory, the project shall be restudied and the City’s expectations shall be reexamined before beginning the process again. If the process begins again, the selection committee shall compile a list of qualified AELS firms and proceed in the same manner. G. Appeal. There shall be no right to appeal such award but all qualifications on file with the City shall be a public record. (Replaces Chapter 2 and subsequently 26A- 394) Sec. 26A-42. Request for Proposals Procedures. A. If the city administrator or City Council believes it would be advantageous to solicit a broad base of potential providers of a goods or services sought by the City and solicit those providers’ concepts or strategies in providing said service the city is authorized to use this process, which shall be called “Request for Proposals”. B. The Purchasing Division shall notify the Council of any request for proposals expected to exceed twenty five thousand ($25,000.00) issued by its office. C. Proposal Preparation Time. Proposal preparation time shall be set to provide potential providers with a reasonable time to prepare their proposals. D. Contents of Request for Proposals. 1. The request for proposals shall include a. A description of the good or service sought; and b. All evaluation factors (and subfactors), including price, and their relative importance, but may include a catchall provisions for any other factor the City may wish to consider. 2. The manner in which proposals are to be submitted, including any forms for that purpose, may be designated as a part of the Request for Proposals. E. Amendments to Requests for Proposals. Amendments to Requests for Proposals by the City may be made at any time prior to submission of proposals F. Selection committee. 1. A selection committee shall be appointed by the city administrator. 2. The selection Committee shall be charged with review of all timely filed proposal s. 15 3. The selection committee shall evaluate the proposals based on the evaluation factors set forth in the Request for Proposals. Numerical rating systems may be used but are not required. Factors not specified in the Request for Proposals may be consider ed if advantageous to the City. Any numerical scoring shall be only in the aggregate of all members and individual member’s scores shall not be made. 4. If after review of a Proposal, but before award of a contract, the selection committee has reason to conclude that a mistake has been made by a Proposer, they may request the Proposer to confirm the facts of the proposal. If the Proposer alleges mistake, the proposal may be corrected or withdrawn. 5. All members of the selection committee must be in attendance for all meetings of the committee. G. Pre-Proposal Conferences. Pre-proposal conferences may be conducted at the discretion of the city administrator. Any such conference should be held prior to submission of initial proposals. H. Proposals. 1. Proposals shall be submitted prior to the established due date. 2. Proposals may be modified or withdrawn prior to the established due date. For the purposes of this Section, the established due date is the time and date announced for receipt of proposals. 3. Late Proposals. Any proposal received after the established due date at the place designated for receipt of proposals shall not be accepted. 4. Minor Informalities. Minor informalities are matters of form rather than substance evident from the proposal, or insignificant mistakes that can be waived or corrected without prejudice to other proposers; that is, the effect on price, quantity, quality, delivery, or contractual conditions is negligible. The purchasing agent shall waive such informalities or allow the proposers to correct them depending on which is in the best interest of the City. Examples include, but are not limited to, the failure of a proposer to: a. return the number of signed proposals required; b. sign the proposal, but only if the unsigned proposal is accompanied by other material indicating the proposers intent to be bound. I. Receipt and Registration of Proposals. Proposals shall not be opened publicly but shall be opened in the presence of two or more city employees. Proposals and modifications shall be time -stamped upon receipt and held in a secure place until the established due date. After the date established for receipt of proposals, a Register of Proposals shall be prepared which shall inc lude for all proposals the name of each proposer, the number of modifications received, if any, and a description sufficient to identify the supply, service, or construction item offered. The Register of Proposals shall be open to public inspection only after recommendation to the City Council by city staff. Proposals and modifications shall be shown only to city personnel having a legitimate interest in them. J. Interviews/Discussions. 16 1. The selection committee may interview or conduct discussions with some or all Proposers for the following purposes: a. Promote understanding of the City’s requirements and the proposals submitted; and b. Facilitate arriving at a contract that will be most advantageous to the City taking into consideration price and the other evaluation factors set forth in the Request for Proposals. c. Clarify any questions the committee may have about the proposal. 2. Conduct of interviews/discussions. a. Proposers shall be accorded fair and equal treatment with respect to any opportunity for discussions and revisions of proposals. b. Revealing one proposers price to another and disclosure of any information derived from competing proposals is strictly prohibited. c. Any substantial oral clarification of a proposal shall be reduced to writing by the Proposer. K. Negotiation For Contract. 1. The selection committee shall select the proposal that they feel best fulfills the proposed assignment in the best interest of the City and proceed with negotiating a contract with that party. 2. If negotiations are unsatisfactory, the selection committee shall negotiate with the next best offer. L. Council Approval. If the contract must be approved by the City Council, the negotiated contract shall be submitted to the City Council for approval and they may make any decision they feel is in the best interest of the City. M. Mistakes Discovered After Award. Mistakes shall not be corrected after award of the contract except where the City Council finds it would be unconscionable not to allow the mistake to be corrected. (was in 26A-395) Sec. 26A-43. Policies and Procedures for selecting Professional Economic Development contracts and Promotion and Development of Tourism. A. The ability to contract for economic development, promotion and development of tourism or any other service identified by the Council by resolution shall be held exclusively by the City Council. B. The selection of any provider under section shall be exempt from all other purchasing procedures and if such service is desired to be bid rather than awarded, such process shall be developed by the City Council at the time of selection. C. Any requirements for selection shall be adopted ad hoc by the City Council by resolution. 17 (Purpose: completely new with purpose to give Council full and complete leeway on this issue) Sec. 26A-381 44. Small sum purchases. Any employee of the city making a an authorized purchase involving an immediate cash expenditure of fifty dollars ($50.00) one hundred dollars ($100.00) or less shall be reimbursed by the city upon submission of a sales ticket for the purchase. (Code 1977, § 16-29(b); Code 1983, § 2-404; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-381) Moved from 26A-381 Sec. 26A-398 45. Purchases of vehicles. A. Contrary provisions of the City Code notwithstanding, tThe Purchasing Agent is authorized, contrary provisions of the City Code notwithstanding, to purchase vehicles by any of the following means, except when State or Federal laws or regulations, or the provisions of any grant agreement, require otherwise: method deemed most advantageous to the City. B. The Parks and Recreation Commission shall be authorized to purchase or sell vehicles by any method deemed most advantageous to the Department of Parks and Recreation. A. Competitive bidding as provided in this chapter B. Purchase from State Contract C. Purchase from MoDOT Contract D. Purchases based upon a negotiated agreement with a particular vendor, provided that such vendor must be selected according to an established written procedure which provides a mechanism for all known interested parties to make proposals in a fair an even manner. Direct negotiations as provided in this sub- section may only be used if the Purchasing Agent certifies to the Council that the use of direct negotiations in a particular instance is in the best interests of the City, and setting forth in particular why such means are in the best interests of the City, and why the other available means are less desirable. This subsection shall also authorize negotiated agreements which include a repurchase agreement. In making such purchases, the Purchasing Agent shall abide by all provisions of the City Code not in consistent with this Division, all rules set forth by the Council, and all policies adopted by the City Administrator. (Previously codified in section 2-398) Moved from 26-398 & 399 Sec. 26A-46 through 26A-49 reserved. ARTICLE V Construction Contracts Sec. 26A-50. Bidding procedure for construction projects over twenty five thousand dollars ($25,000.00). The following describes procedures to be followed by the City in selecting construction contractors for projects in excess of twenty five thousand dollars ($25,000.00). When construction documents have been completed and approved and the approved sets have been delivered to the appropriate City official, the next step is the selection of a construction firm for the project. This contractor shall be selected as follows: A. Competitive bids: The City shall seek competitive bids for projects by advertising and or invitations to prospective contractors that the City intends to construct said project B. Advertising or invitation to contractors: To inform prospective bidders that a contract is to be awarded and invite bids for the proposed project an advertisement shall be placed in a daily paper of general circulation. Items which may be included in the advertisement or invitation are: 1. A brief description of the project and its location. 2. Name and address of the owner City of Jefferson. 3. Name and address of the person authorized to receive bids. 4. The place, date and hour of bid opening, restrictions on submission, changes and withdrawal of bids. 5. Character of bids: Phasing, unit-price, lump-sum, alternates etc. 18 6. Quantities involved in the project. 7. The amount of the bid surety and whether it is to be by certified check, bid bond etc. and provisions for returning surety to unsuccessful bidders. 8. Statement as to where plans and specifications may be obtained or examined and the charge or deposit required for each set and provision for recovery of charge or deposit when documents are returned. 9. Conditions of contract award and the owner’s City of Jefferson right to accept the lowest responsible bid and to reject any or all bids. 10. Name of the consultant and the authorized representative for the owner City of Jefferson and consultant. 11. Contract surety: The amount and type of performance and payment bond. C. Instructions to bidders: A document in which all bidders are furnished identical information on the features of the project along with instructions on the procedure to be followed in submitting bids. Items which may be included in the instructions to bidders are: 1. Bidder's experience, work record and or prequalification data. 2. Procedure for completing and submitting the bid. 3. A list of the plans and specifications and an estimate of quantities for unit -price contracts or an exact description of the scope of the project if contract is to be lump-sum. 4. An estimate of the time it will take the bidder to complete the project. 5. Responsibility for accuracy of bidding information in reference to subsoil data, test borings, errors in plans and specifications, etc. 6. Information on formalities and informalities in accepting or rejecting bids. 7. Miscellaneous instructions as needed. D. Bid form: A document to ensure that all bids are prepared in a similar manner and to facilitate the analysis and comparison of bids and to detect informalities in the bids. It is a convenience to bidders and it encourages accuracy and fairness. Items which may be included in the bid form are: 1. An offer from the bidder to perform the work as specified for a given price. 2. An agreement to complete the project in a given number of days after the notice to proceed has been given. 3. The amount of the bid bond, certified check or other form of guarantee that is to accompany the bid. 4. An agreement by the bidder to furnish the required contract surety if the contract is awarded. 5. Provision for the bidder to acknowledge receipt of all addenda to the plans and specifications. 6. The list of subcontractors to be employed for special work. 7. The experience record, financial statement and plant equipment questionnaire, when required. 8. Statement that there is no collusion or fraud with reference to illegal relationships of bidders and representatives of the Owner or con sultant, bid pooling or straw bids. 9. Statement by the bidder that the site has been examined and the plans and specifications are understood by the bidder. 10. Appropriate signatures and witnesses as required. E. Pre-bid conference: Preparatory to putting the bid together, a pre-bid conference may be held for those bidders anticipating submitting a bid on said project. The pre-bid conference is to do the following: 1. Allow bidders, both contractors and subcontractors a chance to ask questions of those who prepared the plans and wrote the specifications. 2. Allow explanations and answers to questions to be given by those best qualified. 3. To allow scheduled pre-bid conference to be held midway between advertising for bids and the bid opening date. 4. To give additional opportunities so the site can be visited, if necessary. F. Addenda: During the bidding period, any and all additional instructions, clarifications, interpretation or modifications shall be made by an addendum prepared by the consul tant or Owner and signed by the consultant and Owner's representative. 1. The addendum shall be delivered, either by the Owner or the consultant, as agreed upon by the two. 2. A receipt shall be received for all hand delivered addendum by the deliverer. Addendum sent by mail shall be mailed by the fastest delivery method and shall be sent by registered mail with a signed receipt requested. 19 3. No one is authorized to make any clarifications, interpretations, or modifications or give any instructions to the bidders during the bidding period except as described in this section on ADDENDA addenda. G. Receiving and opening bids: Bids may be submitted at any time after the project has been officially advertised or invitations extended and prior to the hour designated for the opening of the bids. 1. Bids submitted may be withdrawn or changed any time before the official opening. 2. No changes are permitted after bids have been opened. 3. Bids shall be submitted on the proposal/bid form with all accompanying papers placed in a sealed envelope addressed to the person authorized to receive same and endorsed with the bidder's name and the title of the project. 4. All bids shall be opened and read aloud publicly at the proper time so that all bidders and others interested may be present as witnesses and/or to tabulate amounts. H. Awarding the contract: After the bids have been opened any consultant and the Owner's representative shall meet to determine if a bid is the lowest and best bid submitted by a responsible bidder has been received. The following shall be done: 1. A study of the qualifications of the bidders shall be made to determine if there are irresponsible and undesirable bidders and to eliminate same. 2. An analysis and comparison of bids shall be made to determine the lowest responsible bidder. 3. When a bidder has been determined to be the lowest and best bid submitted by a responsible bidder, the City shall proceed to obtain a contract with the lowest responsible bidder. 4. A formal notice of awar d shall be issued to the bidder notifying the bidder of his/her selection. The bidder shall be told of the time and place designated to sign the contract. 5. If the bidder determined to be the lowest and best bid submitted by the successful bidder is unable to execute a contract, the City shall proceed to execute a contract with the next responsible bidder. If this bidder is unable to execute a contract, the City shall continue the process with all responsible bidders if necessary. 6. The City shall have the right to use any or all of the bid security of any or all bidders to execute a contract when the bidder is unable to execute a contract for a project bid. 7. After acceptance of the bid and the contract has been signed, a formal notice to proceed shall be forwarded to the contractor authorizing the contractor to begin work. (Ord. 13208, §2, 6-4-2001) I. WHEN LOW BID EXCEEDS FUNDS: Occasionally after opening bids, the lowest and best bid submitted by a responsible bidder may exceed available funds. These are the possible alternatives when this happens: (Ord. 13208, §2, 6-4-2001) 1. Reduce the scope of the project to allow bids within the budget. 2. Secure additional funds. 3. Rejection of all bids. J. PRECONSTRUCTION CONFERENCE: Immediately after a construction contract has been fully executed and before construction begins, the Owner, consultants and contractor shall meet to do the following: 1. Meet with subcontractors and the superintendent for the project. 2. Get acquainted and discuss the several phases of the project so that when understood by all, the job will run smoothly. 3. To establish lines of communication and lines of authority to be followed during construction. 4. To discuss items of interest and concern to all. (Ord. 12316, 7/24/95; Ord. No. 14549, §1, 6-15-2009) (Replaces Chapter 2 and subsequently 26A- 395) Sec. 26A-51. Bonds Required when. All construction contracts of twenty-five thousand ($25,000.00) or more shall require a performance bond. Contracts less than twenty-five thousand dollars ($25,000.00) shall require a performance bond at the discretion of the city counselor after consultation with the city administrator. Secs. 26A-52- 26A-54. Reserved. 20 ARTICLE VI Surplus and Disposable Property Sec. 26A-384 55 . Surplus Property. A. The city administrator may declare any property which has a reasonable fair market value of less than one thousand dollars ($1,000.00) and which is no longer beneficial to needs to the City to be declared surplus and dispose in a manner most financially beneficial to the City. On a yearly basis, or as needed, the purchasing agent shall submit a report to the City Council identifying all property declared surplus pursuant to this provision. B. Any property (other than motor vehicles) which has a reasonable fair market value of more than one thousand dollars ($1,000.00) shall be disposed of by a method approved by the City Council. Such method shall be approved on the consent agenda. A. On a yearly basis, or as needed, all departments shall submit to the purchasing agent reports showing any personal property to be declared surplus. The report shall include any surveys, drawings, appraisals or other information that may be pertinent to th e sale or disposal of the property. The purchasing agent shall submit a report to the city council informing them of the content of the departmental reports. B. Personal property declared to be surplus may be disposed of in the following manner: 1. Sale by auction, or 2. Sale by sealed bid, or 3. Solicitation of offers to purchase the asset. Such solicitations shall be upon the condition that no offer less than the expected sale price carried on the item as reported to the city council may be accepted, unless a lower price is approved by the City Administrator with notice to the City Council, or 4. Sales based upon a negotiated agreement with a particular vendor, provided that such vendor must be selected according to an established written procedure which provides a mechanism for all interested parties to make proposals in a fair an even manner. Direct negotiations as provided in this sub-section may only be used if the Purchasing Agent certifies to the Council that the use of direct negotiations in a particular instance is in the best interests of the City, and setting forth in particular why such means are in the best interests of the City, and why the other available means are less desirable. This subsection shall also authorize negotiated agreements which in clude a repurchase agreement, or 5. Sales by a third party selected according to the City’s standard procedures for selecting providers of services. Any such agreement shall set forth the parameters and authority of the third party provider. C. Disposable property. Notwithstanding the foregoing paragraphs the purchasing agent may designate types of personal property as “disposable” which may then be disposed without annual notice to the City Council. To be “disposable” the property must be declared as disposable by the purchasing agent, and designed to be thrown away after use and have no monetary value after use. E xamples may include but are not limited to paper, pencils, pens, plastic bags, and cardboard. D. City employees shall not be allowed to purchase surplus city property unless such property is sold to the highest bidder, or if offered at a pre-determined p rice then only after the item has been offered to the general public for no less than six days. (Replaces 26A-377F) & 26A-384) (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-384) Sec. 26A-385 56. Announcement and Method of Sale of s Surplus of real p Property. A. A notice shall be published in the newspaper with the highest circulation in the city and posted at City Hall not less than thirty (30) days before bid opening, announcing the city's intent to sell real property. The purchasing agent shall offer for public inspection the file of all nonconfidential documents for public information. 21 Declaration of Real Estate Surplus. The City Council may declare any real property owned by the City to be declared surplus and no longer needed. Such declarati on shall be made on the consent agenda. B. During the thirty day period, sealed bids may be filed with the purchasing agent. In determining which bid to accept, the council may consider the competitive nature of the bid as well as the location of the property and whether the bidder owns property adjacent to or close by the property which is the subject of the sale. (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) Disposition of Surplused Real Estate. Once the real property is declared surplus t he method of disposition shall be approved by the City Council, which may be by any means deemed most beneficial by the City Council. C. The City may elect to dispose of real property by seeking requests for proposals where the bid price may be only one of several factors. Such requests shall not be considered an offer to sell the property but shall be deemed to be negotiations as to the possible sale of real estate for the purposes of Chapter 610 RSMo. (Ord. 14866, § 2, 10-17-2011) (Replaces Chapter 2 and subsequently 26A sections 377F) Letter of Intent. At any time, a letter of intent may be filed with the city clerk by a member of the public who is interested in purchasing city-owned property. The letter shall state the property, its location, and the price the purchaser would be willing to pay for the property. The city clerk shall forward the letter of intent to the City Council. A councilman may thereafter sponsor a resolution to sell the property as proposed or as modified. (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Replaces Chapter 2 and subsequently 26A sections 385, 386 & 388) (Previously codified in section 2-385) Sec. 26A-386. Minimum Bid Requirement and Rejection of Bids. Incorporated into 26A-56 The city council may establish a minimum bid requirement for any property and may reject any and all bids. (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-386) Sec. 26A-387 57. Sale of Park Commission Property. Should the Parks and Recreation Commission determine that property owned by the Parks Commission is surplus, the procedure outlined above for the disposal of surplus property shall be followed. The Commission may establish a minimum bid requirement for any parcel of property at the time it declares it surplus. The City Council may approve any such sale on the consent agenda. (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-387) (moved from 26A-387) Sec. 26A-388. Letter of Intent. At any time, a letter of intent may be filed with the cit y clerk by a member of the public who is interested in purchasing city-owned property. The letter shall state the property, its location, and the price the purchaser would be willing to pay for the property. The city clerk shall forward the letter of int ent to the city council. (Ord. No. 11747, § 1, 6-4-92; Ord. No. 11936, § 2, 7-19-93) (Previously codified in section 2-388) (Incorporated into 26A-56) Sec. 26A-389. Debarment. Moved to 26A-34 D. The purchasing agent is authorized to debar a person from consideration for award of contracts for any of the following reasons: 22 7. Conviction of a criminal offense as an incident to obtaining or attempting to obtain a public or private contract or subcontract, or in the performance of such contract or subcontract. 8. Conviction under state or federal statutes of embezzlement, theft, forgery, bribery, falsification or destruction of records, receiving stolen property, or any other offense indicating a lack of integrity or honesty which currently, seriously and directly affects responsibility as a city contractor or vendor. 9. Conviction under state or federal antitrust statutes arising out of the submission of bids or proposals. 10. Deliberate failure without good cause to perform in accordance with contract specifications or within the time limit provided in the contract. 11. A recent record of failure to perform or of unsatisfactory performance in accordance with the terms of one or more contracts; provided that failure to perform or unsatisfactory performance caused by acts beyond the control of the contractor or vendor shall not be considered a basis for debarment. 12. Any other cause so serious and compelling as to affect responsibility as a city contractor, including debarment by another governmental entity for any cause listed in this article. E. The length of a debarment shall not exceed three (3) years. F. An action to debar a contractor may be initiated and shall proceed as follows: 9. The purchasing agent shall initiate a debarment by serving written notice of the debarment to the person he intends to debar. The notice shall set forth the specific grounds for the debarment and advise the person of his right to appeal. The notice shall be served by registered or certified mail or by delivering a copy of the notice to the person subject to debarment or his agent or employee. The debarment shall take effect ten (10) days after service of the notice unless an appeal is taken to the director of finance. If such an appeal is taken, the debarment sh all not take effect until a final order upholding the debarment is entered by the director or until the appeal is dismissed by the appellant. 10. Within ten (10) days after service of a written notice of debarment, the person affected by the notice may file a written request for a hearing before the director of finance contesting the debarment. 11. The director of finance shall set the matter for hearing on the record within thirty (30) days of the receipt of a request for a hearing. At least ten (10) days’ notice of the hearing shall be given to the affected person and to the head of the purchasing division. 12. At the hearing, each party shall have the right to call and examine witnesses, introduce exhibits, cross-examine opposing witnesses and impeach any witness. Oral evidence shall be taken only on oath or affirmation. All evidence shall be suitably recorded and preserved. The technical rules of evidence shall not apply, except the director may exclude evidence which is irrelevant or repetitious. Each party shall be entitled to present oral arguments or written briefs at or after the hearing. 13. Within ten (10) working days of the hearing, the director of finance shall make written findings of fact and conclusions of law and issue a final order. Findings of fact shall be based upon competent and substantial evidence found in the records as a whole. A copy of the director's order, his findings of fact and conclusions of law, shall be delivered or mailed to the purchasing agent and to the affected person. 14. An appeal from the director's order shall be to the circuit court pursuant to Chapter 536, RSMo. 15. Cost of Proceedings. The cost of debarment proceedings shall be taxed against the losing party. 16. Nothing in this section shall limit the authority of the purchasing division to accept the bid which in his judgment is the lowest and best bid, or to reject any or all bids or to reject a bid on grounds which could have been used to debar the bidder. (Ord. No. 11936, § 3, 7-19-93) (Previously codified in section 2-389) 23 ARTICLE VII. Specific Categories in Purchasing Sec. 26A-390 60. Sole source procurement. A. Competitive bids, and advertising, can be waived when there is only a single feasible source. A single feasible source is defined as listed below. 1. Proprietary, only available from manufacturer or single distributor. 2. Bidding history determines that the item is only available from manufacturer or a single distributor. Advertising may be waived in the above circumstances. B. The city administrator shall be charged with determination as to whether a sole source is applicable. (Previously codified in section 2-390) Sec. 26A-391 61. Purchases of certain commodities exempt. A. All purchases of the following commodities shall may not be purchased pursuant according to the procedures in this section Section 26A-379, item (c) but shall be purchased according to the procedures in this section: 1. Any chemical purchased by the Street Division or Wastewater Division or Parks and Recreation Department in bulk. 2. Fuel. B. Purchases of items authorized by this section shall be made as follows: 1. The purchasing agent shall maintain a list of approved vendors of each authorized item. The criteria for approval shall be designated by each affected department director. Vendors may be added to the list by the department director or at the request of the vendor. The person requesting a vendor’s name to be added to the list shall provide the information necessary to show compliance with the criteria set forth. 2. The purchasing agent, at the request of the department director, is hereby authorized to purchase such quantities of the material as are requested, from the approved vendor then offering the lowest price, without further authorization as long as said purchase is within the budgetary control of said department. but in no event shall the total amounts of the purchase exceed the amounts appropriated. (Previously codified in section 2-391) Sec. 26A-392 62. Purchases from federal surplus property. All purchases from federal surplus property or from (Surplus Property, State of Missouri) are exempt from purchasing limits Sec. 26A-379 items (a), (b), (c). (Previously codified in section 2-392) Moved from 26A-392 Sec. 26A-393 63. Cooperatives General Services Administration (G S A) contracts. All purchases from General Services Administration (G S A) contracts are exempt from Sec 26A-379. Purchasing limits do not apply in these instances. 24 (Previously codified in section 2-393) Moved from 26A-393 Sec. 26A-380 64. Emergency purchases. A. When a disaster has not been declared by the Mayor, notwithstanding any other provisions of this division, the City Administrator or designee may make or authorize others to make emergency procurement of supplies, services, or construction items when there exists a threat to public health, welfare, or safety; provided that such emergency procurement shall be made with such competition as is practicable under the circumstances. A written determination of the basis for the emergency and for the selection of the particular contractor shall be included in a record of each emergency procurement which shall be made and shall set forth the contractor's name, the amount and type of the contract, a listing of the item(s) procured under the contract, and the identification number of the contract file. A copy of the record shall be given within five days of the purchase to the City Administrator and purchasing division. If a disaster has been declared, or if a disaster is later declared the provisions of Chapter 11, E mergency Preparedness and Emergencies, shall be followed. In any case where a purchase under this section might be reimbursable under Federal or State Disaster Relief provisions, the Department Director shall maintain such records as are required for such reimbursement. In any such instance when emergency procedures are implemented, the Department Director shall maintain all records related to an incident. B. An emergency exists as defined below: An emergency exists when a breakdown in machinery and/or a threatened termination of essential services, including but not limited to maintenance and repair of essential office equipment, or a dangerous condition develops, or when supplies are needed for immediate use in work which may vitally affect safety, health or welfare of the public. (Code 1977, § 16-29(a); Code 1983, § 2-403; Ord. No. 11936, § 2, 7-19-93; Ord. No. 14051, §2, 6-5-2006) (Previously codified in section 2-380) Moved from 26A-380 Sec. 26A-382 65. Cooperative purchasing. A. The City of Jefferson desires to participate in the cooperative procurement program with the State of Missouri, the County of Cole, the Housing Authority and any other interested governmental bodies. Th e purchasing agent shall be the designated city representative for the administration of the cooperative procurement program. (Resolution passed 8-20-79) In lieu of the purchasing requirements set out in this chapter, the City Council may authorize parti cipation in any multi-government cooperative or for-profit cooperative by ordinance. B. In addition to other groups authorized by ordinance the Council specifically authorizes participation in cooperative purchasing with State of Missouri, the Co9unty of Cole, and the Housing Authority. C. In lieu of the purchasing requirements set out in this chapter, the purchasing agent shall be authorized to approve purchases based upon a bid received by another government entity within this State, provided that all of the following requirements are met: 4. The other entity must have competitively bid the purchase using procedures which are substantially similar to the procedures which would have been required had the City of Jefferson bid the purchase itself as determined by the purchasing agent; and, 5. The purchasing agent receives verification, acceptable to the purchasing agent, that the other governmental entity’s procedures were actually followed; and 6. The successful bidder to the other governmental entity must state in writing, in a form acceptable to the purchasing agent, that the City of Jefferson is authorized to make the same purchase at the same price. 25 (Previously codified in section 2-382) Moved from 26A-382 Sec. 26A-393. General Services Administration (G S A) contracts. Moved to 26A-63 All purchases from General Services Administration (G S A) contracts are exempt from Sec 26A-379. Purchasing limits do not apply in these instances. (Previously codified in section 2-393) Sec. 26A-394. Policies and Procedures for Selecting Professional Service Firms including Architectural, Engineering and Land Surveying Firms. Updated & moved into 26A-41 The following describes policies and procedures to be used by City of Jefferson in selecting professional service firms. Professional service firms including, but not limited to, architectural, engineering and land surveying firms shall be referred to as "firms". A. CONTRACTS AND FEES It shall be the policy of City of Jefferson to negotiate contracts with firms for services on the basis of demonstrated competence and qualifications for the type of services required and at fair and reasonable fees. B. QUALIFICATIONS OF FIRMS It shall be the policy of City of Jefferson to encourage firms engaged in the lawful practice of their professions to annually submit statements of their qualifications and performance record. Whenever a proposed project requires the services of a firm, the City shall evaluate current statements of qualifications and performance records of firms on file together with those that may be submitted by other firms regarding the proposed project. The City shall use the following criteria in evaluating the qualifications of each firm: 1. The specialized experience and technical competence of the firm with respect to the type of services required. 2. The capacity and capability of the firm to perform the work in question, including specialized services, within the time limitations fixed for the completion of the project. 3. The past record of performance of the firm with respect to such factors as control costs, quality of work, and ability to meet schedules. 4. The firm's proximity to and familiarity with the area in which the project is located. C. CITY FILES FOR FIRMS AND PROJECTS 1. The purchasing agent shall compile and maintain a file of firms that are potential consultants for doing projects for City of Jefferson. 2. The purchasing agent shall prepare every six months, a list of all the firms used in the preceding year for review. 3. Each firm shall be evaluated within 30 days after completing a contract with the City. 4. When a project is proposed, the principal department proposing the project shall prepare a description of the project, including the Scope of Work, the identification of applicable plans, a timetable and a budget. 5. The selection committee shall prepare a list of firms from the file for the proposed project. Selection of the firms shall be based upon preliminary review comparing the nature of the job with the experience of the firms and other significant factors. 26 6. The firms selected shall be sent a description of the project and a questionnaire designed to obtain more detailed information related to the firm's qualifications for the specific project. Selected firms from those responding to the questionnaire shall be interviewed by a selection committee. D. SELECTION COMMITTEE The selection committee shall be appointed by the City Administrator. The selection committee shall be composed of the department director and at least two additional members from other departments. This Committee shall review the information at hand and the principals of the firms. Whenever the project involves total expenditures of over $500,000.00 or the anticipated expenditure for professional services being sought exceed $25,000.00 all members of the Council shall be notified of the proceedings of the selection committee. E. NEGOTIATION FOR CONTRACT 1. The selection committee shall select from the file for each project, three firms that are highly qualified to fulfill the proposed assignment in the best interest of the City. The firms shall be placed in ranked order. 2. The firm ranked first shall be asked to make a comprehensive written and oral presentation demonstrating its methods and experience related to the project, which principals shall be assigned to the project, the consultants to be used, a schedule of document preparation, estimating procedures, services to be rendered during construction, and any other information helpful in determining how well the particular firm is qualified to do the job. 3. The selection committee shall then reach a decision as to whether or not to proceed with fee negotiations with the selected firm. If the parties reach an agreement, a contract shall be prepared and the other firms shall be promptly advised. 4. If the first-ranking firm's proposal is not satisfactory, negotiations shall be initiated with the second-ranking firm. Again, if the negotiations are unsatisfactory, the selection committee shall negotiate with the third-ranking firm. If these negotiations prove unsatisfactory, the project shall be restudied and the City’s expectations shall be reexamined before beginning the process again. If the process begins again, the selection committee shall compile a list of qualified firms and proceed in the same manner. (Previously codified in section 2-394) Sec. 26A-395. Bidding procedure for construction projects. Parts of this section moved into 26A-42 & 26?A-395 The following describes procedures to be followed by the City in selecting construction contractors for projects. When construction documents have been completed and approved and the approved sets have been delivered to the appropriate City official, the next step is the select ion of a construction firm for the project. This contractor shall be selected as follows: A. Competitive bids: The City shall seek competitive bids for projects by advertising and or invitations to prospective contractors that the City intends to construct said project B. Advertising or invitation to contractors: To inform prospective bidders that a contract is to be awarded and invite bids for the proposed project an advertisement shall be placed in a daily paper of general circulation. Items which may be included in the advertisement or invitation are: 1. A brief description of the project and its location. 2. Name and address of the owner. 3. Name and address of the person authorized to receive bids. 4. The place, date and hour of bid opening, restrictions on submission, changes and withdrawal of bids. 27 5. Character of bids: Phasing, unit-price, lump-sum, alternates etc. 6. Quantities involved in the project. 7. The amount of the bid surety and whether it is to be by certified check, bid bond etc. and provisions for returning surety to unsuccessful bidders. 8. Statement as to where plans and specifications may be obtained or examined and the charge or deposit required for each set and provision for recovery of charge or deposit when documents are returned. 9. Conditions of contract award and the owner's right to accept the lowest responsible bid and to reject any or all bids. 10. Name of the consultant and the authorized representative for the owner and consultant. 11. Contract surety: The amount and type of performance and paymen t bond. C. Instructions to bidders: A document in which all bidders are furnished identical information on the features of the project along with instructions on the procedure to be followed in submitting bids. Items which may be included in the instructions to bidders are: 1. Bidder's experience, work record and or prequalification data. 2. Procedure for completing and submitting the bid. 3. A list of the plans and specifications and an estimate of quantities for unit -price contracts or an exact description of the scope of the project if contract is to be lump-sum. 4. An estimate of the time it will take the bidder to complete the project. 5. Responsibility for accuracy of bidding information in reference to subsoil data, test borings, errors in plans and specifications, etc. 6. Information on formalities and informalities in accepting or rejecting bids. 7. Miscellaneous instructions as needed. D. Bid form: A document to ensure that all bids are prepared in a similar manner and to facilitate the analysis and comparison of bids and to detect informalities in the bids. It is a convenience to bidders and it encourages accuracy and fairness. Items which may be included in the bid form are: 1. An offer from the bidder to perform the work as specified for a given price. 2. An agreement to complete the project in a given number of days after the notice to proceed has been given. 3. The amount of the bid bond, certified check or other form of guarantee that is to accompany the bid. 4. An agreement by the bidder to furnish the required contract surety if the contract is awarded. 5. Provision for the bidder to acknowledge receipt of all addenda to the plans and specifications. 6. The list of subcontractors to be employed for special work. 7. The experience record, financial statement and plant equipment questionnaire, when required. 8. Statement that there is no collusion or fraud with reference to illegal relationships of bidders and representatives of the Owner or consultant, bid pooling or straw bids. 9. Statement by the bidder that the site has been examined and the plans and specifications are understood by the bidder. 10. Appropriate signatures and witnesses as required. E. Pre-bid conference: Preparatory to putting the bid together, a pre-bid conference may be held for those bidders anticipating submitting a bid on said project. The pre-bid conference is to do the following: 28 1. Allow bidders, both contractors and subcontractors a chance to ask questions of those who prepared the plans and wrote the specifications. 2. Allow explanations and answers to questions to be given by those best qualified. 3. To allow scheduled pre-bid conference to be held midway between advertising for bids and the bid opening date. 4. To give additional opportunities so the site can be visited, if necessary. F. Addenda: During the bidding period, any and all additional instructions, clarifications, interpretation or modifications shall be made by an addendum prepared by the consultant or Owner and signed by the consultant and Owner's representative. 1. The addendum shall be delivered, either by the Owner or the consultant, as agreed upon by the two. 2. A receipt shall be received for all hand delivered addendum by the deliverer. Addendum sent by mail shall be mailed by the fastest delivery method and shall be sent by registered mail with a signed receipt requested. 3. No one is authorized to make any clarifications, interpretations, or modifications or give any instructions to the bidders during the bidding period except as described in this section on ADDENDA. G. Receiving and opening bids: Bids may be submitted at any time after the project has been officially advertised or invitations extended and prior to the hour designated for the opening of the bids. 1. Bids submitted may be withdrawn or changed any time before the official opening. 2. No changes are permitted after bids have been opened. 3. Bids shall be submitted on the proposal/bid form with all accompanying papers placed in a sealed envelope addressed to the person authorized to receive same and endorsed with the bidder's name and the title of the project. 4. All bids shall be opened and read aloud publicly at the proper time so that all bidders and others interested may be present as witnesses and/or to tabulate amounts. H. Awarding the contract: After the bids have been opened any consultant and the Owner's representative shall meet to determine if a bid is the lowest and best bid submitted by a responsible bidder has been received. The following shall be done: 1. A study of the qualifications of the bidders shall be made to determin e if there are irresponsible and undesirable bidders and to eliminate same. 2. An analysis and comparison of bids shall be made to determine the lowest responsible bidder. 3. When a bidder has been determined to be the lowest and best bid submitted by a respon sible bidder, the City shall proceed to obtain a contract with the lowest responsible bidder. 4. A formal notice of award shall be issued to the bidder notifying the bidder of his/her selection. The bidder shall be told of the time and place designated to sign the contract. 5. If the bidder determined to be the lowest and best bid submitted by the successful bidder is unable to execute a contract, the City shall proceed to execute a contract with the next responsible bidder. If this bidder is unable to execute a contract, the City shall continue the process with all responsible bidders if necessary. 6. The City shall have the right to use any or all of the bid security of any or all bidders to execute a contract when the bidder is unable to execute a contract for a project bid. 7. After acceptance of the bid and the contract has been signed, a formal notice to proceed shall be forwarded to the contractor authorizing the contractor to begin work. (Ord. 13208, §2, 6-4-2001) 29 I. WHEN LOW BID EXCEEDS FUNDS: Occasionally after opening bids, the lowest and best bid submitted by a responsible bidder may exceed available funds. These are the possible alternatives when this happens: (Ord. 13208, §2, 6-4-2001) 1. Reduce the scope of the project to allow bids within the budget. 2. Secure additional funds. 3. Rejection of all bids. J. PRECONSTRUCTION CONFERENCE: Immediately after a construction contract has been fully executed and before construction begins, the Owner, consultants and contractor shall meet to do the following: 1. Meet with subcontractors and the superintendent for the project. 2. Get acquainted and discuss the several phases of the project so that when understood by all, the job will run smoothly. 3. To establish lines of communication and lines of authority to be followed during construction. 4. To discuss items of interest and concern to all. (Ord. 12316, 7/24/95; Ord. No. 14549, §1, 6-15-2009) (Previously codified in section 2-395) Sec. 26A-398. Purchases of vehicles. Moved to 26A-45 The Purchasing Agent is authorized, contrary provisions of the City Code notwithstanding, to purchase vehicles by any of the following means, except when State or Federal laws or regulations, or the provisions of any grant agreement, require otherwise: E. Competitive bidding as provided in this chapter F. Purchase from State Contract G. Purchase from MoDOT Contract H. Purchases based upon a negotiated agreement with a particular vendor, provided that such vendor must be selected according to an established written procedure which provides a mechanism for all known interested parties to make proposals in a fair an even manner. Direct negotiations as provided in this sub- section may only be used if the Purchasing Agent certifies to the Council that the use of direct negotiations in a particular instance is in the best interests of the City, and setting forth in particular why such means are in the best interests of the City, and why the other available means are less desirable. This subsection shall also authorize negotiated agreements which include a repurchase agreement. In making such purchases, the Purchasing Agent shall abide by all provisions of the City Code not inconsistent with this Division, all rules set forth by the Council, and all policies adopted by the City Administrator. (Previously codified in section 2-398) Sec. 26A-399. Sale of vehicles. Moved to 26A-45 The Purchasing Agent is authorized, contrary provisions of the City Code notwithstanding, to dispose of vehicles by any of the following means, except when State or Federal laws or regulations, or the provisions of any grant agreement, require otherwise: A. Sale by auction B. Sale by sealed bid C. Solicitation of offers to purchase the vehicle. Such solicitations shall be upon the condition that no offer less than the purchase price may be accepted, unless a lower price is authorized by the City Administrator 30 with Notice to the Council. D. Sales based upon a negotiated agreement with a particular vendor, provided that such vendor must be selected according to an established written procedure which provides a mechanism for all interested parties to make proposals in a fair an even manner. Direct negotiations as provided in this sub-section may only be used if the Purchasing Agent certifies to the Council that the use of direct negotiations in a particular instance is in the best interests of the City, and setting forth in particular why such means are in the best interests of the City, and why the other available means are less desirable. This subsection shall also authorize negotiated agreements which include a repurchase agreement. E. Sales by a third party selected according to the City’s standard procedures for selecting providers of services. Any such agreement shall set forth the parameters and authority of the third party provider. (Ord. No. 13829, §1, 1-18-2005; Ord. No. 14549, §1, 6-15-2009) (Previously codified in section 2-399) Secs. 26A-400 – 26A-405. Reserved. Sec. 26A-406. Purchase of City Property by City Employees. City employees shall not be allowed to purchase surplus city property unless such property is sold to the highest bidder or, if offered at a pre-determined price then only after the item has been offered to the general public for no less than six days. (Previously codified in section 2-406) Sec. 26A-407. Automotive purchase and replacement advisory group. The City Administrator may create an Automotive Purchase and Replacement Advisory Group composed of staff members representing the various departments which have vehicles assigned to them, for the purpose of making recommendations to the City Administrator as to the vehicles which should be purchased, replaced or sold. The Purchasing Officer shall be the non -voting chairman of such a committee. (Ord. No. 14549, §2, 6-15-2009) (Previously codified in section 2-407) (Ord. No. 13829, §1, 1-18-2005; Ord. No. 13860, §§1, 2, 3, 4-4-2005; Ord. No. 14549, §1, 6-15-2009) Section 2. Chapter 2 (Administration), Article IV (Division 1. City Administrator), Section 307 (Powers) is hereby amended as follows: Sec. 2-307. Powers. A. The city administrator shall have the power to prescribe such rules and regulations as he shall deem necessary or expedient for the conduct of administrative agencies departments subject to his authority, and he shall have the power to revoke, suspend, or amend any rule or regulation of the administrative service except those prescribed by the city council. B. The city administrator shall have the power to coordinate the work of all the departments of the city, and shall have the authority to assign employees of the city to any department for the most efficient discharge of the functions of city government, subject to the provisions of section 6.2 (parks and recreation commission) and section 6.3 (police department) of the city charter. C. The city administrator shall have the power to overrule any action taken by a department director, and may supersede him in the functions of his office, except the parks and recreation department. 31 D. The city administrator shall have the power to appoint and remove all subordinate employees of the city, subject to the provisions of sections 6.2 (parks and recreation commission) and 6.3 (police department) of the city charter. E. At no time shall the duties or powers of the city administrator supersede an acti on by the mayor and/or city council. (Ord. No. 14051, §1, 6-5-2006) F. The purchasing authority of the city administrator shall be as provided in Chapter 26A of the Code. The city administrator is hereby authorized to execute change orders to contracts including increasing the amount to be expended under the contract provided the following criteria are met: 1. The change order has previously been approved by the department director of the department administering the contract and the financial amount involved does not exceed ten percent (10%) in total of the original contract amount with any previously approved change orders on that contract, or ten thousand dollars ($10,000), whichever is greater. For the purposes of this section, the term “original” contract sh all mean the contract as approved by the council and executed by the appropriate official as well as any amendments to the contract which have been duly approved by the Council. 2. The change order does not change the general scope of the project. 3. All change orders approved shall be reported to the city council within two weeks of execution. The report shall include the reason for the change order. G. Notwithstanding the provisions of section 2-378 regarding the promulgation of purchasing rules, the city administrator is hereby authorized to sign contracts on behalf of the city, provided the following criteria are met: 1. The item(s) and/or service(s) that are the subject of the contract have a combined total value of no greater than twenty-four thousand, nine hundred ninety-nine dollars and ninety-nine cents ($24,999.99), unless specifically authorized by the city council. 2. The contract does not pertain to the purchase or sale of real estate, unless specifically authorized by the city council. 3. All contracts signed in accordance with this subsection, including contracts for the purchase or sale of real estate, shall be reported to the city council within two weeks of execution. The report shall include the rationale for the contract. H. The City Administrator may, on behalf of the city, accept any grant, gift, or donation not in excess of $2,000, and may amend the budget to reflect the acceptance of such revenue, and may amend the budget to reflect equivalent expenses so as to accomplish the purpose of such funds. (Ord. 14866, §3, 10-17-2011) (Ord. No. 9360, § 8(a) - (d), 12-17-79; Ord. No. 12163, § 1, 10-10-94; Ord. No. 14051, §1, 6-5-2006) (Previously codified in section 2-290) State law reference - Similar provisions, RSMo. §§ 77.046, 77.048. Charter reference - 5.2, 6.1, 6.2, 6.3 Section 3. This Ordinance shall be in full force and effect from and after the date of its passage and approval. Passed: Approved: Presiding Officer Mayor 32 ATTEST: APPROVED AS TO FORM: City Clerk City Counselor