Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2015-11-12 packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, November 12, 2015 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the September 10, 2015 meeting. 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. JCCVB 2016 Budget – Diane Gillespie 7. Sales Tax G Update – Mayor Tergin 8. New Business 9. Old Business 10. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, September 10, 2015 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Prather at 7:31 am. Roll call showed that Councilmen Prather, Scrivner and Henry were in attendance. Councilmen Mihalevich and Graham were absent during roll call but Councilman Mihalevich joined the meeting at 7:33 am. Next the minutes of the August 13, 2015 meeting was reviewed. A motion to approve was made by Councilman Henry and seconded by Councilman Scrivner. The minutes were approved unanimously. The next item on the agenda was a report by Finance Director, Bill Betts, covering the Financial Reports. Mr. Betts reviewed the Revenue Model, the September sales tax receipts, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the 4 Cent Lockbox Fund, is $2,644,349. The average monthly amount collected for the 4 Cent Lockbox Fund is $51,242. A report comparing occupancy rates for 2015, 2014, 2013 and 2012 was included along with a report listing occupancy rates from other cities. There was no new business to discuss. The next item on the agenda was old business. Councilman Scrivner asked about the status of the Sales Tax G initiative and City Administrator, Steve Crowell said Mayor Tergin has been having preliminary discussions on the initiative. A motion to adjourn was made by Councilman Henry and seconded by Councilman Mihalevich. The motion passed unanimously. The meeting adjourned at 7:48 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:November 6, 2015 Re:Sales Tax Revenues The City received the November 1% Sales Tax in the amount of $661,849 which is $10,769 more than projected for November. January thru November overage is $693,812 (7.10%) in the General Fund 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-14 Jan-15 $944,619 $741,056 $203,563 Dec-14 Feb-15 $727,437 $789,830 ($62,393) Jan-15 & Oct-Dec 14 Qtrly Mar-15 $1,091,021 $920,599 $170,422 Feb-15 Apr-15 $1,059,943 $737,482 $322,461 Mar-15 May-15 $618,854 $802,765 ($183,911) Apr-15 & Jan-Mar 15 Qtrly Jun-15 $1,045,933 $865,930 $180,003 May-15 Jul-15 $963,280 $1,048,754 ($85,474) Jun-15 Aug-15 $562,996 $614,048 ($51,052) Jul-15 & Apr-June 15 Qtrly Sep-15 $1,185,891 $996,272 $189,619 Aug-15 Oct-15 $918,839 $919,035 ($196) Sep-15 Nov-15 $661,849 $651,080 $10,769 Oct-15 & Jul-Sept 15 Qtrly Dec-15 $685,658 Total Overage/Shortfall $9,772,509 $693,812 1Budgeted based on FY14 receipts with adjustment of (329,664) in last period 1/2% Capital Improvement Tax Receipt Actual Budget Period Receipts Projection2 Variance Nov-14 Jan-15 $461,560 $359,800 $101,760 Dec-14 Feb-15 $362,597 $394,475 ($31,878) Jan-15 & Oct-Dec 14 Qtrly Mar-15 $511,685 $423,641 $88,044 Feb-15 Apr-15 $512,808 $348,172 $164,636 Mar-15 May-15 $308,247 $399,863 ($91,616) Apr-15 & Jan-Mar 15 Qtrly Jun-15 $496,466 $416,943 $79,523 May-15 Jul-15 $473,120 $503,869 ($30,749) Jun-15 Aug-15 $280,733 $306,157 ($25,424) Jul-15 & Apr-June 15 Qtrly Sep-15 $565,296 $484,992 $80,304 Aug-15 Oct-15 $442,371 $430,185 $12,186 Sep-15 Nov-15 $330,393 $324,697 $5,696 Oct-15 & Jul-Sept 15 Qtrly Dec-15 $307,206 Total Overage/Shortfall $4,700,000 $352,481 2Budgeted based on FY14 receipts with adjustment of (177,930) in last period 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-14 Jan-15 $461,472 $359,708 $101,764 Dec-14 Feb-15 $362,371 $393,562 ($31,191) Jan-15 & Oct-Dec 14 Qtrly Mar-15 $511,582 $423,546 $88,036 Feb-15 Apr-15 $512,738 $348,076 $164,662 Mar-15 May-15 $308,030 $398,085 ($90,055) Apr-15 & Jan-Mar 15 Qtrly Jun-15 $496,386 $416,845 $79,541 May-15 Jul-15 $473,038 $503,790 ($30,752) Jun-15 Aug-15 $280,513 $305,930 ($25,417) Jul-15 & Apr-June 15 Qtrly Sep-15 $565,217 $484,904 $80,313 Aug-15 Oct-15 $442,370 $430,093 $12,277 Sep-15 Nov-15 $330,393 $324,481 $5,912 Oct-15 & Jul-Sept 15 Qtrly Dec-15 $157,124 Total Overage/Shortfall $4,546,144 $355,090 3Budgeted based on FY14 receipts with adjustment of (327,875) in last period Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate: One percent (1%) Receipt Month: NOVEMBER 2015 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2010 2011 2012 2013 2014 2015 Average Nov January 928,460 809,385 843,061 764,659 741,056 944,619 act. 817,324 Dec February 631,137 833,919 619,287 703,181 789,830 727,437 act. 715,471 Jan & Oct-Dec Qtrly March 894,158 589,958 992,559 1,008,111 920,599 1,091,021 act. 881,077 Feb April 774,964 978,391 852,653 777,424 737,482 1,059,943 act. 824,183 Mar May 592,657 633,676 530,069 537,141 802,765 618,854 act. 619,262 Apr & Jan-Mar Qtrly June 843,712 925,555 1,028,514 1,023,015 865,930 1,045,933 act. 937,345 May July 939,495 955,495 797,785 872,436 1,048,754 963,280 act. 922,793 Jun August 495,667 566,299 557,032 546,351 614,048 562,996 act. 555,879 Jul & Apr-Jun Qtrly September 1,040,156 1,032,258 1,069,414 1,096,581 996,272 1,185,891 act. 1,046,936 Aug October 822,163 797,510 769,129 717,262 919,035 918,839 act. 805,020 Sept November 482,807 536,185 615,421 677,366 651,080 661,849 act. 592,572 Oct & Jul-Sept Qtrly December 881,780 1,032,046 982,684 932,387 1,015,322 685,658 est. 968,844 Actual to Date $ 9,327,157 $ 9,690,677 $ 9,657,608 $ 9,655,913 $ 10,102,175 9,780,663 Estimated to Fiscal Year end (based on averages and on Budgeted amount)685,658 Total Actual & Estimated $ 10,466,321 Less: Budget 9,772,509 Over (Under) Budget $ 693,812 $ 944,619.00 $ 1,672,056.00 $ 2,763,077.28 $ 3,823,020.67 $ 4,441,874.53 $ 5,487,807.99 $ 6,451,087.87 $ 7,014,084.35 $ 8,199,974.86 $ 9,118,813.80 $ 9,780,663.27 $ 741,056.00 $1,530,886.00 $2,451,485.00 $3,188,967.00 $3,991,732.00 $4,857,662.00 $5,906,416.00 $6,520,464.00 $7,516,736.00 $8,435,771.00 $9,086,851.00 $9,772,509.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 Printed 11/6/2015 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax One-Half percent (½%)Receipt Month: NOVEMBER 2015 Account Number 44-100-400010 F - effective 4/1/12 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2010 2011 2012 2013 2014 2015 Average Nov January 455,480 396,799 412,434 372,459 359,800 461,560 act. 399,394 Dec February 313,836 407,407 308,567 350,813 394,475 362,597 act. 355,020 Jan & Oct-Dec Qtrly March 415,473 280,758 466,856 475,110 423,641 511,685 act. 412,368 Feb April 370,473 452,824 409,365 372,340 348,172 512,808 act. 390,635 Mar May 295,545 315,165 263,902 266,422 399,863 308,247 act. 308,179 Apr & Jan-Mar Qtrly June 400,667 439,298 494,757 483,070 416,943 496,466 act. 446,947 May July 462,244 468,643 389,423 425,325 503,869 473,120 act. 449,901 Jun August 247,260 282,859 278,231 272,603 306,157 280,733 act. 277,422 Jul & Apr-Jun Qtrly September 495,398 482,244 504,307 521,260 484,992 565,296 act. 497,640 Aug October 395,058 382,206 367,366 357,619 430,185 442,371 act. 386,487 Sept November 240,417 266,364 306,968 323,871 324,697 330,393 act. 292,463 Oct & Jul-Sept Qtrly December 428,058 495,406 469,095 443,688 485,136 307,206 est. 464,277 Actual to Date $ 4,519,908 $ 4,669,974 $ 4,671,272 $ 4,664,580 $ 4,877,931 4,745,275 Estimated to Fiscal Year end (based on averages and on Budgeted amount)307,206 Total Actual & Estimated $ 5,052,481 Less: Budget 4,700,000 Over (Under) Budget $ 352,481 $ 461,560.00 $ 824,156.86 $ 1,335,842.18 $ 1,848,650.52 $ 2,156,897.25 $ 2,653,362.75 $ 3,126,482.34 $ 3,407,215.54 $ 3,972,511.25 $ 4,414,882.42 $ 4,745,275.14 $ 359,800.00 $754,275.00 $1,177,916.00 $1,526,088.00 $1,925,951.00 $2,342,894.00 $2,846,763.00 $3,152,920.00 $3,637,912.00 $4,068,097.00 $4,392,794.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 Printed 11/6/2015 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax One-Half percent (½%)Receipt Month: NOVEMBER 2015 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2010 2011 2012 2013 2014 2015 Average Nov January 455,442 396,815 405,730 372,447 359,708 461,472 act. 398,028 Dec February 313,792 407,348 308,456 350,714 393,562 362,371 act. 354,774 Jan & Oct-Dec Qtrly March 415,275 280,734 466,713 475,026 423,546 511,582 act. 412,259 Feb April 370,308 452,735 409,353 372,242 348,076 512,738 act. 390,543 Mar May 295,529 315,030 263,822 266,456 398,085 308,030 act. 307,784 Apr & Jan-Mar Qtrly June 400,500 439,265 494,733 482,382 416,845 496,386 act. 446,745 May July 461,255 468,387 389,006 425,194 503,790 473,038 act. 449,526 Jun August 247,216 282,836 278,072 272,321 305,930 280,513 act. 277,275 Jul & Apr-Jun Qtrly September 495,222 482,150 505,913 521,155 484,904 565,217 act. 497,869 Aug October 395,014 382,115 366,846 357,482 430,093 442,370 act. 386,310 Sept November 240,348 264,735 306,831 323,768 324,481 330,393 act. 292,032 Oct & Jul-Sept Qtrly December 428,200 495,305 468,924 443,569 484,999 157,124 est. 464,199 Actual to Date $ 4,518,100 $ 4,667,453 $ 4,664,400 $ 4,662,755 $ 4,874,018 4,744,110 Estimated to Fiscal Year end (based on averages and on Budgeted amount)157,124 Total Actual & Estimated $ 4,901,234 Less: Budget 4,546,144 Over (Under) Budget $ 355,090 $ 461,472.00 $ 823,843.06 $ 1,335,424.65 $ 1,848,162.57 $ 2,156,192.92 $ 2,652,579.19 $ 3,125,617.17 $ 3,406,129.99 $ 3,971,346.52 $ 4,413,716.52 $ 4,744,109.61 $ 359,708.00 $753,270.00 $1,176,816.00 $1,524,892.00 $1,922,977.00 $2,339,822.00 $2,843,612.00 $3,149,542.00 $3,634,446.00 $4,064,539.00 $4,389,020.00 $4,546,144.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 Printed 11/6/2015 Revenue Model Report For Period Ending October 31, 2015 Data as of November 9, 2015 for period ending October 31, 2015 CFY 2015 YTD Actual Projected Over/Description Budget As of 10/31/15 (Under) Budget Sales Tax and Use Tax 9,772,509.00$ 9,118,813.98$ **1,023,476.41$ Intergovernmental Taxes 2,130,000.00$ 1,967,782.78$ 118,765.70$ Other Taxes 120,000.00$ 110,862.36$ 862.36$ Franchise & Utility Tax 7,225,000.00$ 6,728,366.92$ 34,789.63$ Property Taxes 5,249,399.00$ 5,263,725.10$ 16,586.78$ Intergovernmental 1,057,136.48$ 16,620.02$ 5,000.00$ Charges for Services 2,448,744.80$ 2,580,221.34$ 141,476.54$ Fees, Licenses, & Permits 658,300.00$ 776,165.32$ 119,321.62$ Fines & Forfeitures 992,380.00$ 1,012,495.17$ 20,115.17$ Contributions/Donations 122,685.53$ 175,644.15$ 52,958.62$ Other Operating Revenues 84,313.00$ 238,236.42$ 163,923.42$ Interest Income 90,000.00$ 127,987.76$ 37,987.76$ Other Non Operating Revenue 25,000.00$ 44,425.40$ 19,425.40$ Operating Transfers In 34,100.00$ 32,943.83$ (1,156.17)$ Totals 30,009,567.81$ 28,194,290.55$ 1,753,533.24$ **Includes August actual sales tax receipts amount CFY2015 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 10/31/15 15-Oct TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax 2 9,772,509.00 9,118,813.98 1,677,171.43 10,795,985.41 1,023,476.41 1,023,476.41 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 0.00 9,772,509.00 9,118,813.98 1,677,171.43 10,795,985.41 1,023,476.41 1,023,476.41Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax 2 480,000.00 460,058.72 86,982.92 547,041.64 67,041.64 67,041.64 10-100-403010 Gasoline Tax 2 1,100,000.00 958,105.66 194,000.00 1,152,105.66 52,105.66 52,105.66 10-100-430080 Road & Bridge Tax 0 550,000.00 549,618.40 0.00 549,618.40 (381.60)(381.60) 2,130,000.00 1,967,782.78 280,982.92 2,248,765.70 118,765.70 118,765.70Other Taxes 10-100-403020 Cig Tax 1 120,000.00 110,862.36 10,000.00 120,862.36 862.36 862.36 120,000.00 110,862.36 10,000.00 120,862.36 862.36 862.36Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax 1 3,580,000.00 3,561,891.79 212,608.84 3,774,500.63 194,500.63 194,500.63 10-100-410030 Gas Utility License Tax 1 990,000.00 922,442.91 43,134.46 965,577.37 (24,422.63)(24,422.63) 10-100-410052 Telephone Cell w/o audit money 1 2,250,000.00 1,917,130.91 190,000.00 2,107,130.91 (142,869.09)(142,869.09) 10-100-410053 Telecom Audit 0.00 (17,210.20)0.00 (17,210.20)(17,210.20)(17,210.20) 10-100-410060 Cable Franchise Fee R/1 405,000.00 344,111.51 85,679.41 429,790.92 24,790.92 24,790.92 10-100-410061 Cable Utility Audit -$ -$ -$ -$ -$ -$ 7,225,000.00 6,728,366.92 531,422.71 7,259,789.63 34,789.63 34,789.63Property Taxes 10-100-420010 Current Property Tax 0 4,600,000.00 4,558,915.81 0.00 4,558,915.81 (41,084.19)(41,084.19) 10-100-420020 Del Property Tax 0 55,000.00 51,607.69 0.00 51,607.69 (3,392.31)(3,392.31) 10-100-420040 Fin Institution Tax 0 20,000.00 43,692.38 0.00 43,692.38 23,692.38 23,692.38 10-100-420050 Prop Tax Int & Penalties 0 30,000.00 26,896.44 0.00 26,896.44 (3,103.56)(3,103.56) 10-100-420055 Surtax Receipts - County Reimb 0 54,399.00 54,399.28 0.00 54,399.28 0.28 0.28 10-100-420060 Surtax Receipts 0 470,000.00 465,198.63 0.00 465,198.63 (4,801.37)(4,801.37) 10-100-420080 Special Tax Rev 2 20,000.00 63,014.87 2,260.68 65,275.55 45,275.55 45,275.55 5,249,399.00 5,263,725.10 2,260.68 5,265,985.78 16,586.78 16,586.78Intergovernmental 10-100-430010 Federal Grant 0 1,057,136.48 11,620.02 1,045,516.46 1,057,136.48 (0.00)0.00 10-100-430100 State DNR Historic Pres 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480025 HUD Program Income 0 0.00 5,000.00 0.00 5,000.00 5,000.00 5,000.00 1,057,136.48 16,620.02 1,045,516.46 1,062,136.48 5,000.00 5,000.00Charges for Services 10-100-440010 Admin Charge Backs 0 1,527,958.00 1,527,957.00 0.00 1,527,957.00 (1.00)(1.00) 10-100-440050 Emt Reimbursement 0 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100-440210 Street Cuts 0 25,000.00 27,660.00 0.00 27,660.00 2,660.00 2,660.00 10-100-440910 Fuel Charge - backs 0 18,000.00 10,386.56 0.00 10,386.56 (7,613.44)(7,613.44) 10-100-440920 Parts Charge backs 0 95,000.00 179,220.46 0.00 179,220.46 84,220.46 84,220.46 10-100-440930 Labor Charge backs 0 125,000.00 174,309.26 0.00 174,309.26 49,309.26 49,309.26 10-100-450189 Animal Shelter Bricks 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 0 100,000.00 104,051.30 0.00 104,051.30 4,051.30 4,051.30 10-100-481030 Rent City Hall/annex 0 6,500.00 6,500.00 0.00 6,500.00 0.00 0.00 CFY2015 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 10/31/15 15-Oct TOTAL (Under) Budget of Formulas 10-100-481039 Rent-Hyde Park Facility 0.00 100.00 0.00 100.00 100.00 100.00 10-100-481040 Rent Other 0 12,000.00 12,000.00 0.00 12,000.00 0.00 0.00 10-100-481045 Rent-tower Sites 1 115,000.00 109,743.82 10,000.00 119,743.82 4,743.82 4,743.82 10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 25,000.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 0 348,556.80 351,098.78 0.00 351,098.78 2,541.98 2,541.98 10-100-481080 Sale Of Maps/gis Data 0 0.00 55.00 0.00 55.00 55.00 55.00 10-100-481085 Cole Cty Gis Joint Coop 0 15,000.00 15,000.00 0.00 15,000.00 0.00 0.00 10-100-481090 Cole Cty Sheriff-New World 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 0 3,000.00 4,416.00 0.00 4,416.00 1,416.00 1,416.00 10-100-481105 TIF Administration Fee 7,730.00 7,730.00 0.00 7,730.00 0.00 0.00 10-100-481110 Long & Short 0 0.00 (6.84)0.00 (6.84)(6.84)(6.84) 2,448,744.80 2,580,221.34 10,000.00 2,590,221.34 141,476.54 141,476.54Fees, Licenses, & Permits 10-100-450010 Liquor Licenses 0 65,000.00 66,018.40 0.00 66,018.40 1,018.40 1,018.40 10-100-450020 Business Licenses 0 215,000.00 215,381.42 0.00 215,381.42 381.42 381.42 10-100-450021 Home Occupation Permit 0 1,500.00 1,596.00 0.00 1,596.00 96.00 96.00 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 716.00 0.00 716.00 716.00 716.00 10-100-450041 Abandoned Bldg. Admin Fee 0 5,500.00 19,337.17 0.00 19,337.17 13,837.17 13,837.17 10-100-450045 Bldg. Constr Fees 0 125,000.00 209,595.65 0.00 209,595.65 84,595.65 84,595.65 10-100-450050 Electrical Certificates 0 16,000.00 19,305.00 0.00 19,305.00 3,305.00 3,305.00 10-100-450060 Electrical Permits 0 2,500.00 5,617.83 0.00 5,617.83 3,117.83 3,117.83 10-100-450070 Plumbing Licenses 0 10,000.00 10,646.00 0.00 10,646.00 646.00 646.00 10-100-450080 Plumbing Permits 0 5,000.00 3,870.00 0.00 3,870.00 (1,130.00)(1,130.00) 10-100-450090 Other Lic & Permits 0 2,000.00 1,415.00 0.00 1,415.00 (585.00)(585.00) 10-100-450091 Day Care Inspection Fees 0 8,000.00 7,450.00 0.00 7,450.00 (550.00)(550.00) 10-100-450092 Food Inspection Fees 0 88,000.00 86,507.15 0.00 86,507.15 (1,492.85)(1,492.85) 10-100-450100 Curb Cut Permits 0 1,500.00 940.00 0.00 940.00 (560.00)(560.00) 10-100-450110 Board Of Adj Fees 0 1,200.00 1,038.00 0.00 1,038.00 (162.00)(162.00) 10-100-450120 Sign Permits 0 5,000.00 4,576.00 274.00 4,850.00 (150.00)(150.00) 10-100-450130 Demolition Permits 0 500.00 885.00 0.00 885.00 385.00 385.00 10-100-450150 Acc Rep Fees-police 0 12,000.00 11,259.70 1,182.30 12,442.00 442.00 442.00 10-100-450160 Accrpt/blastg P-fire 0 750.00 910.00 0.00 910.00 160.00 160.00 10-100-450170 Animal Redemption Fees 0 52,000.00 58,100.00 0.00 58,100.00 6,100.00 6,100.00 10-100-450180 Animal Vaccinations Fees 0 5,000.00 4,300.00 0.00 4,300.00 (700.00)(700.00) 10-100-450185 Animal Cremation Fees 0 24,000.00 29,854.00 0.00 29,854.00 5,854.00 5,854.00 10-100-450186 Animal Boarding Fees 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 0 450.00 630.00 0.00 630.00 180.00 180.00 10-100-450230 Vacating Right Of Way 0 400.00 523.00 0.00 523.00 123.00 123.00 10-100-450250 Rezoning Request 0 10,000.00 12,281.00 0.00 12,281.00 2,281.00 2,281.00 10-100-450255 Planning & Zoning Review Fees 0.00 1,540.00 0.00 1,540.00 1,540.00 1,540.00 10-100-450260 Non-refundable Plans/spec 0 2,000.00 1,873.00 0.00 1,873.00 (127.00)(127.00) 658,300.00 776,165.32 1,456.30 777,621.62 119,321.62 119,321.62Fines & Forfeitures 10-100-460010 Court Cost 0 80,000.00 73,530.22 0.00 73,530.22 (6,469.78)(6,469.78) CFY2015 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 10/31/15 15-Oct TOTAL (Under) Budget of Formulas 10-100-460015 Court Restitutions 0 1,300.00 1,905.97 0.00 1,905.97 605.97 605.97 10-100-460018 Inmate Security Fund 0 12,080.00 12,393.91 0.00 12,393.91 313.91 313.91 10-100-460020 Jail Cost Recovery 0 10,000.00 4,557.37 0.00 4,557.37 (5,442.63)(5,442.63) 10-100-460025 Alcohol Offense Cost Rec 0 8,000.00 10,016.00 0.00 10,016.00 2,016.00 2,016.00 10-100-460030 Pol Fines-traffic 0 835,000.00 865,038.25 0.00 865,038.25 30,038.25 30,038.25 10-100-460040 Pol Tickets-parking 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460050 Pol 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 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-460090 Parking Fines 0 53,000.00 49,030.06 0.00 49,030.06 (3,969.94)(3,969.94) 10-100-460100 Bankcard Charges 0 (7,000.00)(3,976.61)0.00 (3,976.61)3,023.39 3,023.39 992,380.00 1,012,495.17 0.00 1,012,495.17 20,115.17 20,115.17Contributions/Donations 10-100-430055 DARE Contri 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480010 Citizen Participation 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 0 2,930.00 2,930.00 0.00 2,930.00 0.00 0.00 10-100-480055 JC Fire Museum 0 0.00 3,651.00 0.00 3,651.00 3,651.00 3,651.00 10-100-480063 Private Donations-Cultural Art 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 0 7,255.53 7,255.53 0.00 7,255.53 0.00 0.00 10-100-480080 Dare Donations 0 0.00 500.00 0.00 500.00 500.00 500.00 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 8,855.21 0.00 8,855.21 8,855.21 8,855.21 10-100-481050 Transfer Stn/Plng-Sld Wst Cntr 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481055 Street Repair-Solid Waste Cntr 0 112,000.00 151,952.41 0.00 151,952.41 39,952.41 39,952.41 10-100-481095 Cemetery Donations 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-neighorhood Imp Pro 0 0.00 0.00 0.00 0.00 0.00 0.00 122,685.53 175,644.15 0.00 175,644.15 52,958.62 52,958.62 Other Operating Revenues 10-100-450187 Special Sn Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-450188 Adoption Voucher Program 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 48,313.69 0.00 48,313.69 48,313.69 48,313.69 10-100-481069 Utility Audit Revenue 0.00 301.91 0.00 301.91 301.91 301.91 10-100-481070 Miscellaneous 0 31,716.00 140,503.12 0.00 140,503.12 108,787.12 108,787.12 10-100-481072 TIF Prof Svcs Deposit 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share - Purchasing Card 0.00 7,946.32 0.00 7,946.32 7,946.32 7,946.32 10-100-481077 Insurance Claims 0 42,597.00 41,171.38 0.00 41,171.38 (1,425.62)(1,425.62) 10-100-481078 Cafeteria Refunds 0 10,000.00 0.00 10,000.00 10,000.00 0.00 0.00 84,313.00 238,236.42 10,000.00 248,236.42 163,923.42 163,923.42Interest Income 10-100-470010 Interest 0 90,000.00 127,987.76 0.00 127,987.76 37,987.76 37,987.76 10-100-470051 Unrealized Gains and Losses 0 0.00 0.00 0.00 0.00 0.00 0.00 CFY2015 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2015 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 10/31/15 15-Oct TOTAL (Under) Budget of Formulas 90,000.00 127,987.76 0.00 127,987.76 37,987.76 37,987.76Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 0 25,000.00 44,425.40 0.00 44,425.40 19,425.40 19,425.40 25,000.00 44,425.40 0.00 44,425.40 19,425.40 19,425.40Operating Transfers In 10-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 24,100.00 22,943.83 0.00 22,943.83 (1,156.17)(1,156.17) 10-100-490260 Trsfr from Fireman's Spec Rev 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf from Stoneridge TDD 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit "e"0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0 0.00 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0 10,000.00 10,000.00 0.00 10,000.00 0.00 0.00 34,100.00 32,943.83 0.00 32,943.83 (1,156.17)(1,156.17) 30,009,567.81 28,194,290.55 3,568,810.50 31,763,101.05 1,753,533.24 1,753,533.24 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 11/09/15 10:29:38 Period 01 - 13 Fiscal Year 2015 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 9,772,509.00 9,118,813.98 0.00 653,695.02 6.69 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 9,772,509.00 9,118,813.98 0.00 653,695.02 6.69 10-100-401030 Motor Vehicle Tax 480,000.00 460,058.72 0.00 19,941.28 4.15 10-100-403010 Gasoline Tax 1,100,000.00 958,105.66 0.00 141,894.34 12.90 10-100-430080 Road & Bridge Tax 550,000.00 549,618.40 0.00 381.60 0.07 R16 Intergovernmental Taxes 2,130,000.00 1,967,782.78 0.00 162,217.22 7.62 10-100-403020 Cigarette Tax 120,000.00 110,862.36 0.00 9,137.64 7.61 R20 Other Taxes 120,000.00 110,862.36 0.00 9,137.64 7.61 10-100-410020 Electric Utility Lic Tax 3,580,000.00 3,561,891.79 0.00 18,108.21 0.51 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 990,000.00 922,442.91 0.00 67,557.09 6.82 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,250,000.00 1,917,130.91 0.00 332,869.09 14.79 10-100-410053 TelephoneCell Utility-AUDIT 0.00 -17,210.20 0.00 17,210.20 0.00 10-100-410060 Cable Franchise Fee 405,000.00 344,111.51 0.00 60,888.49 15.03 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,225,000.00 6,728,366.92 0.00 496,633.08 6.87 10-100-420010 Cur Property Tax 4,600,000.00 4,558,915.81 0.00 41,084.19 0.89 10-100-420020 Del Property Tax 55,000.00 51,607.69 0.00 3,392.31 6.17 10-100-420040 Fin Inst Tax 20,000.00 43,692.38 0.00 -23,692.38 -118.46 10-100-420050 Prop Tax Int & Penalties 30,000.00 26,896.44 0.00 3,103.56 10.35 10-100-420055 Surtax Receipts - County Reimb 54,399.00 54,399.28 0.00 -0.28 0.00 10-100-420060 Surtax Receipts 470,000.00 465,198.63 0.00 4,801.37 1.02 10-100-420080 Special Tax Rev 20,000.00 63,014.87 0.00 -43,014.87 -215.07 R40 Property Taxes 5,249,399.00 5,263,725.10 0.00 -14,326.10 -0.27 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 1,057,136.48 11,620.02 0.00 1,045,516.46 98.90 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 5,174.46 0.00 -5,174.46 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 0.00 5,000.00 0.00 -5,000.00 0.00 R50 Intergovernmental 1,057,136.48 21,794.48 0.00 1,035,342.00 97.94 10-100-440010 Admin Charge Backs 1,527,958.00 1,527,957.00 0.00 1.00 0.00 10-100-440050 Emt Reimbursement 25,000.00 25,000.00 0.00 0.00 0.00 10-100-440210 Street Cuts 25,000.00 27,660.00 0.00 -2,660.00 -10.64 10-100-440910 Fuel Charge-backs 18,000.00 10,386.56 0.00 7,613.44 42.30 10-100-440920 Parts Charge-back 95,000.00 179,220.46 0.00 -84,220.46 -88.65 10-100-440930 Labor Charge-backs 125,000.00 174,309.26 0.00 -49,309.26 -39.45 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 100,000.00 104,051.30 0.00 -4,051.30 -4.05 10-100-481030 Rent City Hallannex 6,500.00 6,500.00 0.00 0.00 0.00 10-100-481039 Rent-Hyde Park Facility 0.00 100.00 0.00 -100.00 0.00 10-100-481040 Rent Other 12,000.00 12,000.00 0.00 0.00 0.00 10-100-481045 Rent-tower Sites 115,000.00 109,743.82 0.00 5,256.18 4.57 10-100-481065 Parking Spot Maintenance 25,000.00 25,000.00 0.00 0.00 0.00 10-100-481075 Cole Cty 911 Reimb 348,556.80 351,098.78 0.00 -2,541.98 -0.73 10-100-481080 Sale Of Mapsgis Data 0.00 55.00 0.00 -55.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 15,000.00 0.00 0.00 0.00 10-100-481090 Cole Cty Sheriff-New World 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 3,000.00 4,416.00 0.00 -1,416.00 -47.20 10-100-481105 TIF Administration Fee 7,730.00 7,730.00 0.00 0.00 0.00 10-100-481110 Long & Short 0.00 -6.84 0.00 6.84 0.00 R60 Charges for Services 2,448,744.80 2,580,221.34 0.00 -131,476.54 -5.37 10-100-450010 Liquor Licenses 65,000.00 66,018.40 0.00 -1,018.40 -1.57 10-100-450020 Business Licenses 215,000.00 215,381.42 0.00 -381.42 -0.18 10-100-450021 Home Occupation Permit 1,500.00 1,596.00 0.00 -96.00 -6.40 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 716.00 0.00 -716.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 5,500.00 19,337.17 0.00 -13,837.17 -251.58 10-100-450045 Bldg Constr Fees 125,000.00 209,595.65 0.00 -84,595.65 -67.68 10-100-450050 Electrical Certificates 16,000.00 19,305.00 0.00 -3,305.00 -20.66 10-100-450060 Electrical Permits 2,500.00 5,617.83 0.00 -3,117.83 -124.71 10-100-450070 Plumbing Licenses 10,000.00 10,646.00 0.00 -646.00 -6.46 10-100-450080 Plumbing Permits 5,000.00 3,870.00 0.00 1,130.00 22.60 10-100-450090 Other Lic & Permits 2,000.00 1,415.00 0.00 585.00 29.25 10-100-450091 Day Care Inspection Fees 8,000.00 7,450.00 0.00 550.00 6.88 10-100-450092 Food Inspection Fees 88,000.00 86,507.15 0.00 1,492.85 1.70 10-100-450100 Curb Cut Permits 1,500.00 940.00 0.00 560.00 37.33 10-100-450110 Board Of Adj Fees 1,200.00 1,038.00 0.00 162.00 13.50 10-100-450120 Sign Permits 5,000.00 4,576.00 0.00 424.00 8.48 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450130 Demolition Permits 500.00 885.00 0.00 -385.00 -77.00 10-100-450150 Acc Rep Fees-police 12,000.00 11,259.70 0.00 740.30 6.17 10-100-450160 Accrptblastg P-fire 750.00 910.00 0.00 -160.00 -21.33 10-100-450170 Animal Redemption Fees 52,000.00 58,100.00 0.00 -6,100.00 -11.73 10-100-450180 Animal Vaccinations Fees 5,000.00 4,300.00 0.00 700.00 14.00 10-100-450185 Animal Cremation Fees 24,000.00 29,854.00 0.00 -5,854.00 -24.39 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 450.00 630.00 0.00 -180.00 -40.00 10-100-450230 Vacating Right Of Way 400.00 523.00 0.00 -123.00 -30.75 10-100-450250 Rezoning Request 10,000.00 12,281.00 0.00 -2,281.00 -22.81 10-100-450255 Planning & Zoning Review Fees 0.00 1,540.00 0.00 -1,540.00 0.00 10-100-450260 Non-refundable Plansspec 2,000.00 1,873.00 0.00 127.00 6.35 R65 Fees Licenses & Permits 658,300.00 776,165.32 0.00 -117,865.32 -17.90 10-100-460010 Court Cost 80,000.00 73,530.22 0.00 6,469.78 8.09 10-100-460015 Court Restitutions 1,300.00 1,905.97 0.00 -605.97 -46.61 10-100-460018 Inmate Security Fund 12,080.00 12,393.91 0.00 -313.91 -2.60 10-100-460020 Jail Cost Recovery 10,000.00 4,557.37 0.00 5,442.63 54.43 10-100-460025 Alcohol Offense Cost Rec 8,000.00 10,016.00 0.00 -2,016.00 -25.20 10-100-460030 Pol Fines-traffic 835,000.00 865,038.25 0.00 -30,038.25 -3.60 10-100-460040 Pol Tickets-parking 0.00 0.00 0.00 0.00 0.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 53,000.00 49,030.06 0.00 3,969.94 7.49 10-100-460100 Bankcard Charges -7,000.00 -3,976.61 0.00 -3,023.39 43.19 R70 Fines & Forfeitures 992,380.00 1,012,495.17 0.00 -20,115.17 -2.03 10-100-430055 INACTIVE - DARE Contributions 0.00 0.00 0.00 0.00 0.00 10-100-480015 Sidewalk Waiver Revenue 0.00 0.00 0.00 0.00 0.00 10-100-480030 Donations-Recycling 0.00 0.00 0.00 0.00 0.00 10-100-480050 Sober Driver Program 2,930.00 2,930.00 0.00 0.00 0.00 10-100-480055 JC Fire Museum 0.00 3,651.00 0.00 -3,651.00 0.00 10-100-480063 Private Donations-Cultural Art 0.00 0.00 0.00 0.00 0.00 10-100-480065 Cultural Arts 0.00 0.00 0.00 0.00 0.00 10-100-480070 Community Projects Donations 7,255.53 7,255.53 0.00 0.00 0.00 10-100-480080 Dare Donations 0.00 500.00 0.00 -500.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 8,855.21 0.00 -8,855.21 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 112,000.00 151,952.41 0.00 -39,952.41 -35.67 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 0.00 0.00 0.00 0.00 R72 ContributionsDonations 122,685.53 175,644.15 0.00 -52,958.62 -43.17 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-480010 Citizen Participation 0.00 0.00 0.00 0.00 0.00 10-100-480011 Police Evidence Funds 0.00 48,313.69 0.00 -48,313.69 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-481069 Utility Audit Revenue 0.00 301.91 0.00 -301.91 0.00 10-100-481070 Miscellaneous 31,716.00 140,476.12 0.00 -108,760.12 -342.92 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share 0.00 7,946.32 0.00 -7,946.32 0.00 10-100-481077 Insurance Claims 42,597.00 41,171.38 0.00 1,425.62 3.35 10-100-481078 Cafeteria Refunds 10,000.00 0.00 0.00 10,000.00 100.00 R75 Other Operating Revenues 84,313.00 238,209.42 0.00 -153,896.42 -182.53 10-100-470010 Interest 90,000.00 127,987.76 0.00 -37,987.76 -42.21 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 90,000.00 127,987.76 0.00 -37,987.76 -42.21 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 25,000.00 44,425.40 0.00 -19,425.40 -77.70 R85 Other Non-Operating Revenue 25,000.00 44,425.40 0.00 -19,425.40 -77.70 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 24,100.00 22,943.83 0.00 1,156.17 4.80 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 10,000.00 10,000.00 0.00 0.00 0.00 R90 Transfers In 34,100.00 32,943.83 0.00 1,156.17 3.39 10-100-495995 Transfer From(to) Surplus 1,006,131.45 0.00 0.00 1,006,131.45 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 1,006,131.45 0.00 0.00 1,006,131.45 100.00 100 Revenue 31,015,699.26 28,199,438.01 0.00 2,816,261.25 9.08 149 Entitlement Grant 10-149-430010 Federal Grants 392,466.81 108,461.11 0.00 284,005.70 72.36 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 392,466.81 108,461.11 0.00 284,005.70 72.36 149 Entitlement Grant 392,466.81 108,461.11 0.00 284,005.70 72.36 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 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-430010 Federal Grants 34,413.83 14,386.80 0.00 20,027.03 58.19 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 95,971.39 42,378.74 0.00 53,592.65 55.84 R50 Intergovernmental 130,385.22 56,765.54 0.00 73,619.68 56.46 300 Police Department 130,385.22 56,765.54 0.00 73,619.68 56.46 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 176,674.55 176,674.55 0.00 0.00 0.00 R50 Intergovernmental 176,674.55 176,674.55 0.00 0.00 0.00 310 School Resource Officer 176,674.55 176,674.55 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 50,400.85 40,887.10 0.00 9,513.75 18.88 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 34,379.65 12,698.51 0.00 21,681.14 63.06 R50 Intergovernmental 84,780.50 53,585.61 0.00 31,194.89 36.79 320 M.U.S.T.A.N.G.84,780.50 53,585.61 0.00 31,194.89 36.79 400 Fire Department 10-400-430010 Federal Grant 184,500.00 184,493.00 0.00 7.00 0.00 10-400-430040 Local Grants 13,749.48 0.00 0.00 13,749.48 100.00 R50 Intergovernmental 198,249.48 184,493.00 0.00 13,756.48 6.94 400 Fire Department 198,249.48 184,493.00 0.00 13,756.48 6.94 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 141,626.54 105,450.17 0.00 36,176.37 25.54 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 8,851.66 6,590.63 0.00 2,261.03 25.54 R50 Intergovernmental 150,478.20 112,040.80 0.00 38,437.40 25.54 522 Plan & Protect Svcs-MPO 150,478.20 112,040.80 0.00 38,437.40 25.54 530 Plan & Protect Svc-RedevGrant 10-530-430010 Federal Grants 90,794.60 93,946.13 0.00 -3,151.53 -3.47 10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-530-430040 Local Grants 74,622.50 5,500.00 0.00 69,122.50 92.63 R50 Intergovernmental 165,417.10 99,446.13 0.00 65,970.97 39.88 530 Plan & Protect Svc-RedevGrant 165,417.10 99,446.13 0.00 65,970.97 39.88 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-430010 Federal Grants 214,000.00 272,377.75 0.00 -58,377.75 -27.28 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 31,000.00 31,000.00 0.00 0.00 0.00 R50 Intergovernmental 245,000.00 303,377.75 0.00 -58,377.75 -23.83 990 Capital Projects 245,000.00 303,377.75 0.00 -58,377.75 -23.83 Revenue Revenue 32,559,151.12 29,294,282.50 0.00 3,264,868.62 10.03 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 65,475.00 0.00 -675.00 -1.04 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 5,009.44 0.00 -52.24 -1.05 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 69,757.20 70,484.44 0.00 -727.24 -1.04 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 7.21 0.00 92.79 92.79 10-110-512010 Printing 750.00 64.00 0.00 686.00 91.47 10-110-512020 Copies 400.00 32.96 0.00 367.04 91.76 10-110-513010 Office Supplies 75.00 54.50 0.00 20.50 27.33 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,325.00 158.67 0.00 1,166.33 88.02 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 441.84 0.00 1,058.16 70.54 10-110-520030 Dues And Publications 4,707.90 4,707.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 1,275.00 330.00 0.00 945.00 74.12 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,582.90 5,479.74 0.00 2,103.16 27.74 10-110-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-110-547020 Maintenance Agreements 325.00 205.56 0.00 119.44 36.75 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 325.00 205.56 0.00 119.44 36.75 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 78,990.10 76,328.41 0.00 2,661.69 3.37 120 City Clerk 10-120-501020 Salaries 65,539.49 63,617.90 0.00 1,921.59 2.93 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 42.96 69.70 0.00 -26.74 -62.24 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 5,013.77 4,528.52 0.00 485.25 9.68 10-120-502020 Group Health Insurance 13,043.71 13,404.62 0.00 -360.91 -2.77 10-120-502030 Retirement 11,534.95 11,209.06 0.00 325.89 2.83 10-120-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-120-502050 Life Insurance 110.61 109.85 0.00 0.76 0.69 10-120-502060 Long Term Disability 182.62 183.68 0.00 -1.06 -0.58 10-120-502070 Employee Assistance Prgm 32.87 30.62 0.00 2.25 6.85 E05 Personnel Services 95,500.98 93,153.95 0.00 2,347.03 2.46 10-120-511020 Postage 242.95 233.82 0.00 9.13 3.76 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 465.39 492.27 0.00 -26.88 -5.78 10-120-513010 Office Supplies 477.56 364.54 0.00 113.02 23.67 E10 Materials & Supplies 1,185.90 1,090.63 0.00 95.27 8.03 10-120-520030 Dues And Publications 275.00 260.00 0.00 15.00 5.45 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 951.90 34.00 0.00 917.90 96.43 10-120-522020 Professional Services 419.24 27.00 0.00 392.24 93.56 10-120-529030 Election Expense 35,000.00 19,960.51 0.00 15,039.49 42.97 E15 Contractual Services 36,646.14 20,281.51 0.00 16,364.63 44.66 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 0.00 0.00 0.00 0.00 0.00 10-120-547020 Maintenance Agreements 525.00 403.08 0.00 121.92 23.22 E25 Repairs & Maintenance 525.00 403.08 0.00 121.92 23.22 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 133,858.02 114,929.17 0.00 18,928.85 14.14 140 City Administrator 10-140-501020 Salaries 224,385.52 217,241.65 0.00 7,143.87 3.18 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 17,165.49 13,955.46 0.00 3,210.03 18.70 10-140-502020 Group Health Insurance 19,199.71 17,870.87 0.00 1,328.84 6.92 10-140-502030 Retirement 37,581.76 36,361.89 0.00 1,219.87 3.25 10-140-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-140-502050 Life Insurance 342.72 249.34 0.00 93.38 27.25 10-140-502060 Long Term Disability 591.44 403.35 0.00 188.09 31.80 10-140-502070 Employee Assistance Prgm 49.43 46.04 0.00 3.39 6.86 E05 Personnel Services 299,316.07 286,128.60 0.00 13,187.47 4.41 10-140-511010 Advertising 1,000.00 382.39 0.00 617.61 61.76 10-140-511020 Postage 350.00 96.37 0.00 253.63 72.47 10-140-512010 Printing 200.00 62.00 0.00 138.00 69.00 10-140-512020 Copies 300.00 218.14 0.00 81.86 27.29 10-140-513010 Office Supplies 885.00 654.20 0.00 230.80 26.08 10-140-517010 Operational Supplies 1,500.00 154.68 0.00 1,345.32 89.69 E10 Materials & Supplies 4,235.00 1,567.78 0.00 2,667.22 62.98 10-140-520030 Dues And Publications 1,000.00 612.70 0.00 387.30 38.73 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 4,650.63 4,059.03 0.00 591.60 12.72 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 849.37 324.31 0.00 525.06 61.82 E15 Contractual Services 6,500.00 4,996.04 0.00 1,503.96 23.14 10-140-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-140-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-547020 Maintenance Agreements 450.00 336.28 0.00 113.72 25.27 E25 Repairs & Maintenance 450.00 336.28 0.00 113.72 25.27 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 310,501.07 293,028.70 0.00 17,472.37 5.63 149 Entitlement Grant 10-149-501020 Salaries 26,003.37 24,950.01 0.00 1,053.36 4.05 10-149-501050 Parttime(wo Benefits)14,000.00 13,110.00 0.00 890.00 6.36 10-149-502010 Social Security 2,962.64 2,908.23 0.00 54.41 1.84 10-149-502020 Group Health Insurance 4,139.28 3,985.86 0.00 153.42 3.71 10-149-502030 Retirement 4,391.42 4,391.42 0.00 0.00 0.00 10-149-502050 Life Insurance 44.70 43.28 0.00 1.42 3.18 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502060 Long Term Disability 73.02 71.62 0.00 1.40 1.92 10-149-502070 Employee Assistance Program 12.36 11.52 0.00 0.84 6.80 E05 Personnel Services 51,626.79 49,471.94 0.00 2,154.85 4.17 10-149-511010 Advertising 1,452.13 604.75 0.00 847.38 58.35 10-149-511020 Postage 500.00 275.05 0.00 224.95 44.99 10-149-512020 Copies 1.18 0.92 0.00 0.26 22.03 10-149-513010 Office Supplies 998.82 105.01 0.00 893.81 89.49 10-149-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,952.13 985.73 0.00 1,966.40 66.61 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 1,005.79 0.00 994.21 49.71 10-149-522020 Professional Services 442.34 0.00 0.00 442.34 100.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 44,783.00 14,176.00 0.00 30,607.00 68.35 10-149-528012 Housing Rehab-Energy Efficienc 44,086.81 35,907.52 0.00 8,179.29 18.55 10-149-528020 Housing Assistance 25,423.00 25,423.00 0.00 0.00 0.00 10-149-528030 Public Improvement 39,735.94 358.75 0.00 39,377.19 99.10 10-149-528040 Neighborhood Redevelopmnt 41,750.00 7,273.75 0.00 34,476.25 82.58 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 3,724.00 0.00 0.00 3,724.00 100.00 10-149-528080 Homeless Objectives 45,142.80 14,024.21 0.00 31,118.59 68.93 E15 Contractual Services 247,087.89 98,169.02 0.00 148,918.87 60.27 10-149-547020 Maintenance Agreements 800.00 223.33 0.00 576.67 72.08 E25 Repairs & Maintenance 800.00 223.33 0.00 576.67 72.08 10-149-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-149-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-149-577055 Marshall & Roland Sidewalk 90,000.00 36,284.20 53,715.80 0.00 0.00 E75 Capital Projects 90,000.00 36,284.20 53,715.80 0.00 0.00 149 Entitlement Grant 392,466.81 185,134.22 53,715.80 153,616.79 39.14 150 City Counselor 10-150-501020 Salaries 222,294.95 210,229.88 0.00 12,065.07 5.43 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 44.26 71.80 0.00 -27.54 -62.22 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,005.56 14,972.02 0.00 2,033.54 11.96 10-150-502020 Group Health Insurance 36,130.31 27,515.74 0.00 8,614.57 23.84 10-150-502030 Retirement 39,123.91 30,840.57 0.00 8,283.34 21.17 10-150-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502050 Life Insurance 390.53 352.01 0.00 38.52 9.86 10-150-502060 Long Term Disability 567.94 517.15 0.00 50.79 8.94 10-150-502070 Employee Assistance Prgm 82.55 76.90 0.00 5.65 6.84 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 315,640.01 284,576.07 0.00 31,063.94 9.84 10-150-511010 Advertising 191.60 191.60 0.00 0.00 0.00 10-150-511020 Postage 600.00 284.78 0.00 315.22 52.54 10-150-512010 Printing 200.00 38.00 0.00 162.00 81.00 10-150-512020 Copies 670.00 104.03 0.00 565.97 84.47 10-150-513010 Office Supplies 6,632.40 4,712.43 0.00 1,919.97 28.95 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 8,294.00 5,330.84 0.00 2,963.16 35.73 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 10,843.00 8,652.28 0.00 2,190.72 20.20 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,000.00 3,798.47 0.00 2,201.53 36.69 10-150-520080 Tuition Reimbursement 2,375.74 0.00 0.00 2,375.74 100.00 10-150-521010 Malpractice Insurance 3,400.00 1,663.00 0.00 1,737.00 51.09 10-150-522020 Professional Services 8,000.00 3,864.54 0.00 4,135.46 51.69 10-150-525030 Court Cost & Witness Fees 75.00 62.30 0.00 12.70 16.93 E15 Contractual Services 30,693.74 18,040.59 0.00 12,653.15 41.22 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 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 1,350.00 662.39 0.00 687.61 50.93 E25 Repairs & Maintenance 1,350.00 662.39 0.00 687.61 50.93 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 355,977.75 308,609.89 0.00 47,367.86 13.31 160 Municipal Court 10-160-501010 Salary-elected Officals 59,999.88 59,999.88 0.00 0.00 0.00 10-160-501020 Salaries 99,540.25 102,054.29 0.00 -2,514.04 -2.53 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)16,931.49 13,080.76 0.00 3,850.73 22.74 10-160-501090 Overtime 1,000.00 737.88 0.00 262.12 26.21 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,576.58 13,229.53 0.00 347.05 2.56 10-160-502020 Group Health Insurance 13,032.88 12,689.56 0.00 343.32 2.63 10-160-502030 Retirement 17,695.08 16,831.49 0.00 863.59 4.88 10-160-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-160-502050 Life Insurance 167.16 161.99 0.00 5.17 3.09 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502060 Long Term Disability 277.85 270.88 0.00 6.97 2.51 10-160-502070 Employee Assistance Prgm 57.59 53.64 0.00 3.95 6.86 E05 Personnel Services 222,278.76 219,109.90 0.00 3,168.86 1.43 10-160-511010 Advertising 0.00 75.45 0.00 -75.45 0.00 10-160-511020 Postage 4,000.00 3,024.86 0.00 975.14 24.38 10-160-512010 Printing 1,090.00 422.31 0.00 667.69 61.26 10-160-512020 Copies 500.00 184.14 0.00 315.86 63.17 10-160-513010 Office Supplies 3,300.00 2,615.66 0.00 684.34 20.74 E10 Materials & Supplies 8,890.00 6,322.42 0.00 2,567.58 28.88 10-160-520025 Security 10,000.00 7,165.49 0.00 2,834.51 28.35 10-160-520030 Dues And Publications 450.00 100.00 0.00 350.00 77.78 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,500.00 1,532.08 0.00 967.92 38.72 10-160-522020 Professional Services 3,000.00 2,938.38 0.00 61.62 2.05 10-160-525005 Appointed Counsel 7,000.00 4,672.50 0.00 2,327.50 33.25 10-160-525010 Care Of Prisoners 1,398.39 200.86 0.00 1,197.53 85.64 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 24,388.39 16,609.31 0.00 7,779.08 31.90 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 0.00 0.00 0.00 0.00 0.00 10-160-547020 Maintenance Agreements 801.61 798.14 0.00 3.47 0.43 E25 Repairs & Maintenance 801.61 798.14 0.00 3.47 0.43 10-160-572020 Purchase Of Equipment 13,163.56 7,600.32 0.00 5,563.24 42.26 E70 Capital Purchases 13,163.56 7,600.32 0.00 5,563.24 42.26 160 Municipal Court 269,522.32 250,440.09 0.00 19,082.23 7.08 170 Human Resources 10-170-501020 Salaries 150,407.24 147,530.40 0.00 2,876.84 1.91 10-170-501050 Parttime(wo Benefits)9,600.00 10,479.57 0.00 -879.57 -9.16 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-170-502010 Social Security 12,263.50 12,088.45 0.00 175.05 1.43 10-170-502020 Group Health Insurance 11,914.07 11,818.61 0.00 95.46 0.80 10-170-502030 Retirement 26,524.46 25,965.42 0.00 559.04 2.11 10-170-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-170-502050 Life Insurance 253.61 253.85 0.00 -0.24 -0.09 10-170-502060 Long Term Disability 372.59 373.04 0.00 -0.45 -0.12 10-170-502070 Employee Assistance Prgm 49.43 69.08 0.00 -19.65 -39.75 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 211,684.90 208,578.42 0.00 3,106.48 1.47 10-170-511010 Advertising 150.00 133.75 0.00 16.25 10.83 10-170-511020 Postage 300.00 235.03 0.00 64.97 21.66 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-512010 Printing 2,000.00 183.68 0.00 1,816.32 90.82 10-170-512020 Copies 1,000.00 472.99 0.00 527.01 52.70 10-170-513010 Office Supplies 1,500.00 535.55 0.00 964.45 64.30 10-170-517010 Operational Supplies 750.00 204.60 0.00 545.40 72.72 E10 Materials & Supplies 5,700.00 1,765.60 0.00 3,934.40 69.02 10-170-520030 Dues And Publications 1,468.00 540.00 0.00 928.00 63.22 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 2,502.81 0.00 997.19 28.49 10-170-520070 Training And Education 4,000.00 3,343.54 0.00 656.46 16.41 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 8,000.00 7,863.00 0.00 137.00 1.71 10-170-522020 Professional Services 8,000.00 2,009.98 0.00 5,990.02 74.88 10-170-529010 Special Events 0.00 0.00 0.00 0.00 0.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 24,968.00 16,259.33 0.00 8,708.67 34.88 10-170-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-170-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-170-547020 Maintenance Agreements 450.00 205.59 0.00 244.41 54.31 E25 Repairs & Maintenance 450.00 205.59 0.00 244.41 54.31 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 242,802.90 226,808.94 0.00 15,993.96 6.59 180 Finance Department 10-180-501020 Salaries 578,909.92 550,342.81 0.00 28,567.11 4.93 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)18,904.18 17,795.77 0.00 1,108.41 5.86 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 45,366.20 42,495.69 0.00 2,870.51 6.33 10-180-502020 Group Health Insurance 90,593.71 75,166.42 0.00 15,427.29 17.03 10-180-502030 Retirement 101,044.76 95,498.05 0.00 5,546.71 5.49 10-180-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-180-502050 Life Insurance 966.75 942.41 0.00 24.34 2.52 10-180-502060 Long Term Disability 1,587.37 1,572.09 0.00 15.28 0.96 10-180-502070 Employee Assistance Prgm 297.06 253.60 0.00 43.46 14.63 E05 Personnel Services 837,669.95 784,066.84 0.00 53,603.11 6.40 10-180-511010 Advertising 2,000.00 226.05 0.00 1,773.95 88.70 10-180-511020 Postage 11,000.00 8,710.54 0.00 2,289.46 20.81 10-180-511021 Mail Machine Cost 2,449.97 2,449.97 0.00 0.00 0.00 10-180-512010 Printing 5,000.00 3,050.66 523.30 1,426.04 28.52 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-512020 Copies 4,000.00 1,051.71 0.00 2,948.29 73.71 10-180-512021 Copy Machine Cost 1,531.03 1,084.48 0.00 446.55 29.17 10-180-513010 Office Supplies 4,179.85 1,448.17 0.00 2,731.68 65.35 10-180-517010 Operational Supplies 4,000.00 3,754.36 0.00 245.64 6.14 E10 Materials & Supplies 34,160.85 21,775.94 523.30 11,861.61 34.72 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 1,585.00 1,585.00 0.00 0.00 0.00 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 3,135.15 3,135.15 0.00 0.00 0.00 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 26,219.00 26,219.00 0.00 0.00 0.00 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 1,500.00 9.92 0.00 1,490.08 99.34 E15 Contractual Services 32,439.15 30,949.07 0.00 1,490.08 4.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 0.00 156.00 0.00 -156.00 0.00 10-180-547020 Maintenance Agreements 2,000.00 853.92 0.00 1,146.08 57.30 E25 Repairs & Maintenance 2,000.00 1,009.92 0.00 990.08 49.50 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 906,269.95 837,801.77 523.30 67,944.88 7.50 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 17,000.00 17,304.20 0.00 -304.20 -1.79 10-185-502022 Wellness Assessment 25,000.00 24,500.00 0.00 500.00 2.00 10-185-502023 Self Insurance-Retirees 5,400.00 0.00 0.00 5,400.00 100.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 47,400.00 41,804.20 0.00 5,595.80 11.81 10-185-514010 Gas 21,600.00 10,174.37 0.00 11,425.63 52.90 10-185-514011 Gas Oil & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-185-514012 Gas, Oil, Antifreeze ALLOCATE 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 21,600.00 10,174.37 0.00 11,425.63 52.90 10-185-520030 Dues and Publications 0.00 350.00 0.00 -350.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 270,000.00 247,705.64 0.00 22,294.36 8.26 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-521020 Insurance Deductible 20,000.00 19,411.65 0.00 588.35 2.94 10-185-521030 Self Ins Prop & Casualty 75,000.00 41,504.76 0.00 33,495.24 44.66 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 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 25,000.00 22,916.63 4,166.67 -2,083.30 -8.33 10-185-522025 JCTV 55,000.00 55,000.00 0.00 0.00 0.00 10-185-524010 Trash Collections 500.00 0.00 0.00 500.00 100.00 10-185-526030 Assessment Charge 45,500.00 45,704.98 0.00 -204.98 -0.45 10-185-527020 Economic Development 560,000.00 606,250.00 0.00 -46,250.00 -8.26 10-185-529010 Special Events 7,000.00 8,060.74 0.00 -1,060.74 -15.15 E15 Contractual Services 1,058,000.00 1,046,904.40 4,166.67 6,928.93 0.65 10-185-531010 Electricity 42,000.00 32,410.19 0.00 9,589.81 22.83 10-185-533010 Natural Gas 6,200.00 5,347.75 0.00 852.25 13.75 10-185-535010 Water 7,250.00 5,541.37 0.00 1,708.63 23.57 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,450.00 43,299.31 0.00 12,150.69 21.91 10-185-540010 Building & Grounds Maint.60,000.00 41,529.55 -10,314.38 28,784.83 47.97 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,000.00 1,560.00 0.00 440.00 22.00 E25 Repairs & Maintenance 87,000.00 68,089.55 -10,314.38 29,224.83 33.59 10-185-550010 Miscellaneous 10,000.00 4,320.22 0.00 5,679.78 56.80 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-550026 Addt'l PositionsEquipment 232,250.77 0.00 0.00 232,250.77 100.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 6,000.00 2,100.00 0.00 3,900.00 65.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 705.97 0.00 -705.97 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 258,250.77 17,126.19 0.00 241,124.58 93.37 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 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 185 Non-Departmental 1,527,700.77 1,227,398.02 -6,147.71 306,450.46 20.06 190 I.T. Department 10-190-501020 Salaries 577,862.21 552,197.14 0.00 25,665.07 4.44 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 44,206.46 40,127.20 0.00 4,079.26 9.23 10-190-502020 Group Health Insurance 70,923.68 70,922.60 0.00 1.08 0.00 10-190-502030 Retirement 101,703.74 92,923.69 0.00 8,780.05 8.63 10-190-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-190-502050 Life Insurance 945.91 914.63 0.00 31.28 3.31 10-190-502060 Long Term Disability 1,490.40 1,436.68 0.00 53.72 3.60 10-190-502070 Employee Assistance Prgm 228.61 212.96 0.00 15.65 6.85 E05 Personnel Services 797,361.01 758,734.90 0.00 38,626.11 4.84 10-190-511010 Advertising 500.00 179.50 0.00 320.50 64.10 10-190-511020 Postage 100.00 146.37 0.00 -46.37 -46.37 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 51.19 0.00 48.81 48.81 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 972.11 505.28 0.00 466.83 48.02 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 77.89 77.89 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 2,140.51 2,140.51 0.00 0.00 0.00 E10 Materials & Supplies 3,890.51 3,100.74 0.00 789.77 20.30 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 200.00 0.00 300.00 60.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 8,000.00 6,827.42 0.00 1,172.58 14.66 10-190-520080 Tuition Reimbursement 6,654.56 6,315.00 0.00 339.56 5.10 10-190-522020 Professional Services 1,609.49 1,397.29 0.00 212.20 13.18 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 19,800.00 17,797.34 0.00 2,002.66 10.11 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 3,843.14 3,843.14 0.00 0.00 0.00 E15 Contractual Services 40,407.19 36,380.19 0.00 4,027.00 9.97 10-190-534010 Telephone 58,000.00 51,084.09 0.00 6,915.91 11.92 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 58,000.00 51,084.09 0.00 6,915.91 11.92 10-190-545010 Software Licensemaint 198,102.30 198,102.30 0.00 0.00 0.00 10-190-545020 Citywide Wiringnetwork 3,000.00 2,045.00 0.00 955.00 31.83 10-190-547010 Equipment Maintenance 3,000.00 2,822.21 0.00 177.79 5.93 10-190-547020 Maintenance Agreements 30,000.00 21,169.00 0.00 8,831.00 29.44 E25 Repairs & Maintenance 234,102.30 224,138.51 0.00 9,963.79 4.26 10-190-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 190 I.T. Department 1,133,761.01 1,073,438.43 0.00 60,322.58 5.32 300 Police Department 10-300-501020 Salaries 3,966,121.50 3,913,450.29 0.00 52,671.21 1.33 10-300-501030 Holiday Pay 127,510.80 102,458.41 0.00 25,052.39 19.65 10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits)28,400.00 25,772.72 0.00 2,627.28 9.25 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 6,500.00 4,304.00 0.00 2,196.00 33.78 10-300-501090 Overtime 266,373.89 248,413.46 0.00 17,960.43 6.74 10-300-501095 Overtime Straight Pay 6,000.00 6,531.77 0.00 -531.77 -8.86 10-300-502010 Social Security 329,327.52 311,754.82 0.00 17,572.70 5.34 10-300-502020 Group Health Insurance 734,685.47 665,760.30 0.00 68,925.17 9.38 10-300-502030 Retirement 839,140.74 795,043.03 0.00 44,097.71 5.26 10-300-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-300-502050 Life Insurance 6,800.30 6,573.75 0.00 226.55 3.33 10-300-502060 Long Term Disability 11,118.82 10,883.16 0.00 235.66 2.12 10-300-502070 Employee Assistance Prgm 2,199.60 2,048.98 0.00 150.62 6.85 10-300-503010 Awards Program 1,600.00 979.70 0.00 620.30 38.77 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,326,778.64 6,093,974.39 0.00 232,804.25 3.68 10-300-511010 Advertising 839.16 1,295.03 0.00 -455.87 -54.32 10-300-511020 Postage 1,456.50 1,397.31 0.00 59.19 4.06 10-300-512010 Printing 6,239.28 6,139.28 0.00 100.00 1.60 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 4,026.56 4,026.56 0.00 0.00 0.00 10-300-513010 Office Supplies 15,187.77 14,842.32 0.00 345.45 2.27 10-300-514010 Gas 247,361.83 158,270.47 0.00 89,091.36 36.02 10-300-514040 Food 989.37 989.37 0.00 0.00 0.00 10-300-515040 First Aid Supplies 1,300.00 1,013.61 0.00 286.39 22.03 10-300-516010 Ammunition & Firearms Supplies 29,152.00 29,152.00 0.00 0.00 0.00 10-300-516020 Dare Program 14,500.00 14,328.47 0.00 171.53 1.18 10-300-516030 Special Investigation 2,500.00 2,500.00 0.00 0.00 0.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 10,035.38 9,398.92 0.00 636.46 6.34 10-300-517010 Operational Supplies 52,162.32 45,813.43 -1,298.00 7,646.89 14.66 E10 Materials & Supplies 385,750.17 289,166.77 -1,298.00 97,881.40 25.37 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-520030 Dues And Publications 4,554.64 4,334.64 0.00 220.00 4.83 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 5,852.30 6,150.00 0.00 -297.70 -5.09 10-300-520090 Recruitment 1,312.90 1,312.90 0.00 0.00 0.00 10-300-521040 Medical Claimsservices 5,153.18 5,153.18 -246.00 246.00 4.77 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 14,627.65 14,721.30 0.00 -93.65 -0.64 10-300-522026 Drug Forfeiture - Justice 56,685.42 56,685.42 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 28,314.58 28,314.58 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 9,233.28 0.00 -9,233.28 0.00 10-300-523010 Equipment Rentlease 7,000.00 7,000.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 2,930.00 2,135.35 0.00 794.65 27.12 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,296.89 2,520.18 0.00 -223.29 -9.72 E15 Contractual Services 128,727.56 137,560.83 -246.00 -8,587.27 -6.67 10-300-531010 Electricity 61,500.00 66,696.25 0.00 -5,196.25 -8.45 10-300-533010 Natural Gas 12,000.00 11,486.03 0.00 513.97 4.28 10-300-534010 Telephone 19,500.00 19,532.90 0.00 -32.90 -0.17 10-300-535010 Water 4,500.00 3,830.68 0.00 669.32 14.87 E20 Utilities 97,500.00 101,545.86 0.00 -4,045.86 -4.15 10-300-540010 Building & Grounds Maint.44,601.07 45,213.22 -1,582.99 970.84 2.18 10-300-541030 Vehicle Wash 12,000.00 10,258.23 0.00 1,741.77 14.51 10-300-544010 K-9 Operations 9,500.00 8,641.62 0.00 858.38 9.04 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 13,045.03 13,045.03 0.00 0.00 0.00 10-300-546010 Clothing Expense 50,533.38 53,128.07 -9,415.07 6,820.38 13.50 10-300-546020 Uniform Cleaning 19,272.07 19,068.36 0.00 203.71 1.06 10-300-547010 Equipment Maintenance 7,650.00 7,779.71 0.00 -129.71 -1.70 10-300-547020 Maintenance Agreements 19,863.17 21,751.17 0.00 -1,888.00 -9.51 10-300-547030 Radio Maintenance 18,970.17 18,970.16 0.00 0.01 0.00 E25 Repairs & Maintenance 195,434.89 197,855.57 -10,998.06 8,577.38 4.39 10-300-572010 Purchase Of Vehicles 267,448.00 267,448.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 23,209.50 12,281.40 0.00 10,928.10 47.08 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 676.32 676.32 0.00 0.00 0.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 291,333.82 280,405.72 0.00 10,928.10 3.75 300 Police Department 7,425,525.08 7,100,509.14 -12,542.06 337,558.00 4.55 310 School Resource Officer 10-310-501020 Salaries 226,076.71 225,095.83 0.00 980.88 0.43 10-310-501030 Holiday Pay 5,692.49 3,178.93 0.00 2,513.56 44.16 10-310-501090 Overtime 10,126.00 22,464.77 0.00 -12,338.77 -121.85 10-310-501095 Overtime Straight Pay 0.00 79.05 0.00 -79.05 0.00 10-310-502010 Social Security 18,504.98 17,172.84 0.00 1,332.14 7.20 10-310-502020 Group Health Insurance 42,816.10 53,824.37 0.00 -11,008.27 -25.71 10-310-502030 Retirement 47,895.25 49,017.44 0.00 -1,122.19 -2.34 10-310-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-310-502050 Life Insurance 378.71 382.56 0.00 -3.85 -1.02 10-310-502060 Long Term Disability 627.42 639.75 0.00 -12.33 -1.97 10-310-502070 Employee Assistance Prgm 123.57 115.10 0.00 8.47 6.85 E05 Personnel Services 352,241.23 371,970.64 0.00 -19,729.41 -5.60 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 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 352,241.23 371,970.64 0.00 -19,729.41 -5.60 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 135,810.20 97,222.49 0.00 38,587.71 28.41 10-320-501030 Holiday Pay 5,225.62 2,311.76 0.00 2,913.86 55.76 10-320-501090 Overtime 42,948.68 27,536.49 0.00 15,412.19 35.89 10-320-501095 Overtime Straight Pay 327.97 327.97 0.00 0.00 0.00 10-320-502010 Social Security 11,469.86 9,043.96 0.00 2,425.90 21.15 10-320-502020 Group Health Insurance 31,962.96 19,911.69 0.00 12,051.27 37.70 10-320-502030 Retirement 29,686.70 25,042.31 0.00 4,644.39 15.64 10-320-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-320-502050 Life Insurance 231.34 166.04 0.00 65.30 28.23 10-320-502060 Long Term Disability 380.42 275.33 0.00 105.09 27.62 10-320-502070 Employee Assistance Prgm 74.14 69.08 0.00 5.06 6.82 E05 Personnel Services 258,117.89 181,907.12 0.00 76,210.77 29.53 10-320-514010 Gas 20,000.00 5,156.78 0.00 14,843.22 74.22 10-320-516040 Investigations 14,350.00 14,350.00 0.00 0.00 0.00 10-320-517010 Operational Supplies 6,439.17 5,171.51 0.00 1,267.66 19.69 E10 Materials & Supplies 40,789.17 24,678.29 0.00 16,110.88 39.50 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 523.68 0.00 0.00 523.68 100.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 22,000.00 17,325.00 0.00 4,675.00 21.25 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,523.68 17,325.00 0.00 5,198.68 23.08 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.321,430.74 223,910.41 0.00 97,520.33 30.34 330 Animal Control 10-330-501020 Salaries 302,907.62 290,026.59 0.00 12,881.03 4.25 10-330-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,200.00 4,184.00 0.00 16.00 0.38 10-330-501090 Overtime 1,709.00 641.85 0.00 1,067.15 62.44 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,013.61 20,662.17 0.00 4,351.44 17.40 10-330-502020 Group Health Insurance 50,734.22 58,154.65 0.00 -7,420.43 -14.63 10-330-502030 Retirement 57,547.66 45,978.22 0.00 11,569.44 20.10 10-330-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-330-502050 Life Insurance 541.50 482.50 0.00 59.00 10.90 10-330-502060 Long Term Disability 895.97 805.31 0.00 90.66 10.12 10-330-502070 Employee Assistance Prgm 197.72 184.18 0.00 13.54 6.85 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 444,247.30 421,119.47 0.00 23,127.83 5.21 10-330-511010 Advertising 420.10 205.00 0.00 215.10 51.20 10-330-511020 Postage 300.00 88.04 0.00 211.96 70.65 10-330-512010 Printing 900.00 1,160.01 0.00 -260.01 -28.89 10-330-512020 Copies 20.00 0.11 0.00 19.89 99.45 10-330-513010 Office Supplies 1,600.00 855.66 0.00 744.34 46.52 10-330-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-330-515040 First Aid Supplies 750.00 539.34 0.00 210.66 28.09 10-330-517010 Operational Supplies 7,050.00 5,458.61 0.00 1,591.39 22.57 E10 Materials & Supplies 11,140.10 8,306.77 0.00 2,833.33 25.43 10-330-520030 Dues And Publications 1,450.65 1,445.70 0.00 4.95 0.34 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,179.25 1,153.47 0.00 25.78 2.19 10-330-521040 Medical Claimsservices 1,500.00 161.00 0.00 1,339.00 89.27 10-330-522020 Professional Services 15,846.62 15,769.39 0.00 77.23 0.49 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529050 Spay & Neuter Program 26,678.93 26,615.12 0.00 63.81 0.24 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 233.18 233.18 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 53,712.93 4,688.45 0.00 49,024.48 91.27 E15 Contractual Services 100,601.56 50,066.31 0.00 50,535.25 50.23 10-330-531010 Electricity 24,000.00 20,371.10 0.00 3,628.90 15.12 10-330-533010 Natural Gas 17,000.00 14,129.83 0.00 2,870.17 16.88 10-330-534010 Telephone 300.00 295.77 0.00 4.23 1.41 10-330-535010 Water 4,000.00 3,124.49 0.00 875.51 21.89 E20 Utilities 45,300.00 37,921.19 0.00 7,378.81 16.29 10-330-540010 Building & Grounds Maint.9,000.00 6,640.20 -613.53 2,973.33 33.04 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 33,500.00 40,841.72 -12,774.78 5,433.06 16.22 10-330-546010 Clothing Expense 3,000.00 2,143.19 0.00 856.81 28.56 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 1,000.00 278.09 0.00 721.91 72.19 10-330-547020 Maintenance Agreements 1,600.00 1,500.00 0.00 100.00 6.25 10-330-547030 Radio Maintenance 1,000.00 689.18 0.00 310.82 31.08 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 49,640.00 52,632.38 -13,388.31 10,395.93 20.94 10-330-572010 Purchase of Vehicles 23,450.00 23,450.00 0.00 0.00 0.00 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 23,450.00 23,450.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 674,378.96 593,496.12 -13,388.31 94,271.15 13.98 390 9-1-1 Police 10-390-501020 Salaries 795,258.23 774,532.00 0.00 20,726.23 2.61 10-390-501030 Holiday Pay 28,998.73 26,354.25 0.00 2,644.48 9.12 10-390-501050 Parttime(wo Benefits)2,600.00 944.03 0.00 1,655.97 63.69 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 23,314.00 23,463.88 0.00 -149.88 -0.64 10-390-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-390-502010 Social Security 65,076.33 59,018.44 0.00 6,057.89 9.31 10-390-502020 Group Health Insurance 170,798.30 161,614.58 0.00 9,183.72 5.38 10-390-502030 Retirement 149,260.49 138,052.86 0.00 11,207.63 7.51 10-390-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,367.45 1,333.70 0.00 33.75 2.47 10-390-502060 Long Term Disability 2,240.84 2,216.48 0.00 24.36 1.09 10-390-502070 Employee Assistance Prgm 512.83 477.72 0.00 35.11 6.85 10-390-503020 Unemployment Compensation 0.00 169.48 0.00 -169.48 0.00 E05 Personnel Services 1,239,927.20 1,188,177.42 0.00 51,749.78 4.17 10-390-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 4,500.00 4,441.99 0.00 58.01 1.29 E10 Materials & Supplies 4,500.00 4,441.99 0.00 58.01 1.29 10-390-520030 Dues And Publications 600.00 446.00 0.00 154.00 25.67 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 4,500.00 2,805.40 0.00 1,694.60 37.66 10-390-522020 Professional Services 2,320.35 2,546.32 0.00 -225.97 -9.74 10-390-523010 Equipment Rentlease 98,000.00 95,264.42 0.00 2,735.58 2.79 E15 Contractual Services 105,420.35 101,062.14 0.00 4,358.21 4.13 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-390-546010 Clothing Expense 5,186.19 4,678.87 0.00 507.32 9.78 10-390-546020 Uniform Cleaning 5,967.00 4,149.00 0.00 1,818.00 30.47 10-390-547010 Equipment Maintenance 879.09 552.20 0.00 326.89 37.19 10-390-547020 Maintenance Agreements 22,300.00 18,512.81 0.00 3,787.19 16.98 10-390-547030 Radio Maintenance 10,047.37 9,912.37 0.00 135.00 1.34 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 44,379.65 37,805.25 0.00 6,574.40 14.81 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,394,227.20 1,331,486.80 0.00 62,740.40 4.50 400 Fire Department 10-400-501020 Salaries 3,505,507.23 3,474,195.01 0.00 31,312.22 0.89 10-400-501030 Holiday Pay 272,061.79 270,243.01 0.00 1,818.78 0.67 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 27,480.00 0.00 520.00 1.86 10-400-501090 Overtime 35,000.00 37,926.26 0.00 -2,926.26 -8.36 10-400-501095 Overtime Straight Pay 32,000.00 25,832.76 0.00 6,167.24 19.27 10-400-502010 Social Security 58,511.68 50,710.61 0.00 7,801.07 13.33 10-400-502020 Group Health Insurance 632,155.71 598,300.88 0.00 33,854.83 5.36 10-400-502030 Retirement 1,617,193.48 1,547,352.28 0.00 69,841.20 4.32 10-400-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-400-502050 Life Insurance 5,933.71 5,883.39 0.00 50.32 0.85 10-400-502060 Long Term Disability 9,795.18 9,802.03 0.00 -6.85 -0.07 10-400-502070 Employee Assistance Prgm 1,804.17 1,680.64 0.00 123.53 6.85 10-400-503010 Awards Program 1,060.00 1,824.25 0.00 -764.25 -72.10 E05 Personnel Services 6,199,022.95 6,051,231.12 0.00 147,791.83 2.38 10-400-511010 Advertising 150.00 51.95 0.00 98.05 65.37 10-400-511020 Postage 200.00 145.39 0.00 54.61 27.31 10-400-512010 Printing 2,083.00 2,082.93 0.00 0.07 0.00 10-400-512020 Copies 50.00 4.42 0.00 45.58 91.16 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 1,815.75 0.00 -15.75 -0.88 10-400-514010 Gas 73,000.00 47,917.81 0.00 25,082.19 34.36 10-400-514020 Chemicals 850.00 525.30 0.00 324.70 38.20 10-400-514030 Small Tools 2,500.00 2,049.75 0.00 450.25 18.01 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 1,150.00 1,131.33 0.00 18.67 1.62 10-400-517010 Operational Supplies 9,000.00 9,156.15 0.00 -156.15 -1.74 E10 Materials & Supplies 90,783.00 64,880.78 0.00 25,902.22 28.53 10-400-520030 Dues And Publications 1,320.00 1,316.95 0.00 3.05 0.23 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 12,059.63 0.00 -2,059.63 -20.60 10-400-520080 Tuition Reimbursement 5,000.00 4,653.00 0.00 347.00 6.94 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 2,683.25 0.00 16.75 0.62 10-400-522020 Professional Services 17.00 0.00 0.00 17.00 100.00 10-400-523010 Equipment Rentlease 420.00 210.00 0.00 210.00 50.00 10-400-524010 Trash Collections 250.00 0.00 0.00 250.00 100.00 10-400-529010 Special Events 5,440.00 2,987.58 0.00 2,452.42 45.08 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-529040 INACTIVE - Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 25,147.00 23,910.41 0.00 1,236.59 4.92 10-400-531010 Electricity 29,216.00 30,448.94 0.00 -1,232.94 -4.22 10-400-533010 Natural Gas 24,500.00 18,537.53 0.00 5,962.47 24.34 10-400-534010 Telephone 17,500.00 14,800.79 0.00 2,699.21 15.42 10-400-535010 Water 11,720.00 12,839.75 0.00 -1,119.75 -9.55 E20 Utilities 82,936.00 76,627.01 0.00 6,308.99 7.61 10-400-540010 Building & Grounds Maint.60,000.00 55,243.51 -6,424.16 11,180.65 18.63 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 35,000.00 40,783.12 -14,507.42 8,724.30 24.93 10-400-546020 Uniform Cleaning 316.00 87.30 0.00 228.70 72.37 10-400-547010 Equipment Maintenance 15,150.00 16,214.82 0.00 -1,064.82 -7.03 10-400-547020 Maintenance Agreements 17,750.00 22,554.82 -9,663.96 4,859.14 27.38 10-400-547030 Radio Maintenance 7,000.00 6,542.18 0.00 457.82 6.54 E25 Repairs & Maintenance 135,216.00 141,425.75 -30,595.54 24,385.79 18.03 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 244,983.45 246,780.79 0.00 -1,797.34 -0.73 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 244,983.45 246,780.79 0.00 -1,797.34 -0.73 400 Fire Department 6,778,088.40 6,604,855.86 -30,595.54 203,828.08 3.01 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 -263.58 0.00 263.58 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 -263.58 0.00 263.58 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 -263.58 0.00 263.58 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 209,722.72 205,705.86 0.00 4,016.86 1.92 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 16,043.79 15,164.52 0.00 879.27 5.48 10-520-502020 Group Health Insurance 34,618.66 28,493.79 0.00 6,124.87 17.69 10-520-502030 Retirement 36,911.20 36,204.17 0.00 707.03 1.92 10-520-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-520-502050 Life Insurance 354.73 354.73 0.00 0.00 0.00 10-520-502060 Long Term Disability 545.17 545.17 0.00 0.00 0.00 10-520-502070 Employee Assistance Prgm 98.86 92.10 0.00 6.76 6.84 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 298,295.13 286,560.34 0.00 11,734.79 3.93 10-520-511010 Advertising 87.74 74.25 0.00 13.49 15.37 10-520-511020 Postage 200.00 174.49 0.00 25.51 12.76 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 900.95 900.95 0.00 0.00 0.00 10-520-514010 Gas 10,765.78 10,825.88 0.00 -60.10 -0.56 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 1,809.49 397.99 1,400.88 10.62 0.59 E10 Materials & Supplies 13,763.96 12,373.56 1,400.88 -10.48 -0.08 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-520030 Dues And Publications 500.00 392.17 0.00 107.83 21.57 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,500.00 1,399.06 0.00 100.94 6.73 10-520-522020 Professional Services 3,000.00 1,580.55 0.00 1,419.45 47.32 E15 Contractual Services 5,000.00 3,371.78 0.00 1,628.22 32.56 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 650.00 553.47 0.00 96.53 14.85 E25 Repairs & Maintenance 650.00 553.47 0.00 96.53 14.85 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 317,709.09 302,859.15 1,400.88 13,449.06 4.23 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 58,731.84 57,612.90 0.00 1,118.94 1.91 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)11,514.72 8,664.00 0.00 2,850.72 24.76 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 5,447.71 5,015.32 0.00 432.39 7.94 10-521-502020 Group Health Insurance 7,268.29 7,268.29 0.00 0.00 0.00 10-521-502030 Retirement 10,336.80 10,139.85 0.00 196.95 1.91 10-521-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-521-502050 Life Insurance 97.80 97.80 0.00 0.00 0.00 10-521-502060 Long Term Disability 162.71 162.71 0.00 0.00 0.00 10-521-502070 Employee Assistance Prgm 24.71 23.02 0.00 1.69 6.84 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 93,584.58 88,983.89 0.00 4,600.69 4.92 10-521-511010 Advertising 3,674.44 3,410.75 0.00 263.69 7.18 10-521-511020 Postage 1,500.00 480.69 0.00 1,019.31 67.95 10-521-512010 Printing 100.00 38.00 0.00 62.00 62.00 10-521-512020 Copies 25.00 11.94 0.00 13.06 52.24 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,335.00 1,226.26 0.00 108.74 8.15 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 1,964.82 0.00 35.18 1.76 E10 Materials & Supplies 8,734.44 7,132.46 0.00 1,601.98 18.34 10-521-520030 Dues And Publications 15,500.00 14,743.70 0.00 756.30 4.88 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 608.00 0.00 1,092.00 64.24 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-520080 Tuition Reimbursement 627.70 0.00 0.00 627.70 100.00 10-521-522020 Professional Services 75.00 75.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,902.70 15,426.70 0.00 2,476.00 13.83 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,500.00 864.13 0.00 635.87 42.39 E25 Repairs & Maintenance 1,500.00 864.13 0.00 635.87 42.39 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 121,721.72 112,407.18 0.00 9,314.54 7.65 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 107,262.79 105,200.25 0.00 2,062.54 1.92 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,205.60 8,043.32 0.00 162.28 1.98 10-522-502020 Group Health Insurance 12,270.61 11,772.74 0.00 497.87 4.06 10-522-502030 Retirement 18,878.25 18,515.29 0.00 362.96 1.92 10-522-502040 Workers Compensation 134.73 0.00 0.00 134.73 100.00 10-522-502050 Life Insurance 181.64 181.61 0.00 0.03 0.02 10-522-502060 Long Term Disability 304.01 304.01 0.00 0.00 0.00 10-522-502070 Employee Assistance Prgm 49.43 46.04 0.00 3.39 6.86 E05 Personnel Services 147,287.06 144,063.26 0.00 3,223.80 2.19 10-522-511010 Advertising 1,033.94 1,000.00 0.00 33.94 3.28 10-522-511020 Postage 400.00 202.46 0.00 197.54 49.39 10-522-512010 Printing 400.00 38.00 0.00 362.00 90.50 10-522-512020 Copies 50.00 0.56 0.00 49.44 98.88 10-522-513010 Office Supplies 1,000.00 784.83 0.00 215.17 21.52 10-522-514040 Food 212.17 212.17 0.00 0.00 0.00 10-522-517010 Operational Supplies 1,417.21 1,407.93 0.00 9.28 0.65 E10 Materials & Supplies 4,513.32 3,645.95 0.00 867.37 19.22 10-522-520030 Dues And Publications 1,000.00 630.75 0.00 369.25 36.93 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 6,250.00 5,709.87 0.00 540.13 8.64 10-522-522020 Professional Services 17,500.00 17,485.78 0.00 14.22 0.08 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 24,750.00 23,826.40 0.00 923.60 3.73 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 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 482.79 393.27 0.00 89.52 18.54 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 482.79 393.27 0.00 89.52 18.54 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 177,033.17 171,928.88 0.00 5,104.29 2.88 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 66,757.43 58,671.39 0.00 8,086.04 12.11 10-530-501050 Parttime (wo Benefits)450.00 0.00 0.00 450.00 100.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 5,106.94 4,011.90 0.00 1,095.04 21.44 10-530-502020 Group Health Insurance 9,587.38 7,691.52 0.00 1,895.86 19.77 10-530-502030 Retirement 11,749.31 10,325.97 0.00 1,423.34 12.11 10-530-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-530-502050 Life Insurance 112.24 100.82 0.00 11.42 10.17 10-530-502060 Long Term Disability 184.70 167.45 0.00 17.25 9.34 10-530-502070 Employee Assistance Prgm 37.07 34.54 0.00 2.53 6.82 E05 Personnel Services 93,985.07 81,003.59 0.00 12,981.48 13.81 10-530-511010 Advertising 177.62 177.62 0.00 0.00 0.00 10-530-511020 Postage 100.00 77.36 0.00 22.64 22.64 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 18.68 1.72 0.00 16.96 90.79 10-530-513010 Office Supplies 600.00 562.84 0.00 37.16 6.19 10-530-517010 Operational Supplies 300.00 233.42 0.00 66.58 22.19 E10 Materials & Supplies 1,196.30 1,052.96 0.00 143.34 11.98 10-530-520030 Dues And Publications 24.65 20.00 0.00 4.65 18.86 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,841.46 2,841.46 0.00 0.00 0.00 10-530-522020 Professional Services 1,890.73 855.35 975.38 60.00 3.17 10-530-524020 Recycle Collectprocess 729.03 -1,089.74 0.00 1,818.77 249.48 10-530-524025 Glass Recycling 91,830.00 6,627.96 224.00 84,978.04 92.54 10-530-524026 Household Hazardous Waste 18,000.00 14,174.18 3,825.82 0.00 0.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 6,710.00 3,130.84 0.00 3,579.16 53.34 10-530-528085 Fair Housing Assistance Prog 1,332.35 1,332.35 0.00 0.00 0.00 E15 Contractual Services 123,358.22 27,892.40 5,025.20 90,440.62 73.32 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 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-547020 Maintenance Agreements 400.00 341.72 0.00 58.28 14.57 E25 Repairs & Maintenance 400.00 341.72 0.00 58.28 14.57 10-530-550020 NRA-Residential 45,000.00 41,943.87 0.00 3,056.13 6.79 10-530-550030 NRA-Commercial Facade 25,401.00 19,122.89 0.00 6,278.11 24.72 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA-Rental Facade 20,099.00 0.00 0.00 20,099.00 100.00 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 225.48 225.48 0.00 0.00 0.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 103,975.32 1,726.75 0.00 102,248.57 98.34 10-530-550060 MSP 41,447.31 40,855.69 -75.38 667.00 1.61 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 236,148.11 103,874.68 -75.38 132,348.81 56.04 530 Plan & Protect Svc-RedevGrant 455,087.70 214,165.35 4,949.82 235,972.53 51.85 531 Plan & Protect Svcs-Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-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-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-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-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 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 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio 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-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 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 162,597.53 159,724.98 0.00 2,872.55 1.77 10-532-501050 Parttime (wo Benefits)2,670.43 0.00 0.00 2,670.43 100.00 10-532-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-532-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-532-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 12,741.42 11,411.71 0.00 1,329.71 10.44 10-532-502020 Group Health Insurance 33,031.05 28,032.52 0.00 4,998.53 15.13 10-532-502030 Retirement 28,617.17 28,111.67 0.00 505.50 1.77 10-532-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-532-502050 Life Insurance 274.50 274.50 0.00 0.00 0.00 10-532-502060 Long Term Disability 459.13 459.13 0.00 0.00 0.00 10-532-502070 Employee Assistance Prgm 74.14 69.08 0.00 5.06 6.82 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 240,465.37 228,083.59 0.00 12,381.78 5.15 10-532-511010 Advertising 300.00 45.50 0.00 254.50 84.83 10-532-511020 Postage 300.00 276.37 0.00 23.63 7.88 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,000.00 887.44 0.00 112.56 11.26 10-532-514030 Small Tools 50.00 24.97 0.00 25.03 50.06 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,100.00 1,050.09 0.00 49.91 4.54 E10 Materials & Supplies 2,835.00 2,284.37 0.00 550.63 19.42 10-532-520030 Dues And Publications 1,000.00 838.00 0.00 162.00 16.20 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,300.00 850.90 0.00 449.10 34.55 10-532-521040 Medical Claimsservices 0.00 448.83 0.00 -448.83 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 218,000.00 215,000.04 0.00 2,999.96 1.38 10-532-529010 Special Events 1,000.00 684.81 0.00 315.19 31.52 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 221,300.00 217,822.58 0.00 3,477.42 1.57 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 26,000.00 23,421.46 2,105.00 473.54 1.82 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 160.00 157.96 0.00 2.04 1.28 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 1,200.00 544.65 0.00 655.35 54.61 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 28,730.00 25,408.07 2,105.00 1,216.93 4.24 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 493,330.37 473,598.61 2,105.00 17,626.76 3.57 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 147,805.18 145,247.09 0.00 2,558.09 1.73 10-533-501060 Seasonal Salaries 6,843.09 5,047.50 0.00 1,795.59 26.24 10-533-501090 Overtime 1,368.06 1,368.06 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 100.00 53.26 0.00 46.74 46.74 10-533-502010 Social Security 12,566.29 10,714.34 0.00 1,851.95 14.74 10-533-502020 Group Health Insurance 25,990.23 24,272.98 0.00 1,717.25 6.61 10-533-502030 Retirement 26,013.71 25,663.57 0.00 350.14 1.35 10-533-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-533-502050 Life Insurance 394.08 394.08 0.00 0.00 0.00 10-533-502060 Long Term Disability 416.22 416.22 0.00 0.00 0.00 10-533-502070 Employee Assistance Prgm 74.14 69.08 0.00 5.06 6.82 E05 Personnel Services 221,571.00 213,246.18 0.00 8,324.82 3.76 10-533-511010 Advertising 100.00 47.25 0.00 52.75 52.75 10-533-511020 Postage 1,200.00 970.54 0.00 229.46 19.12 10-533-512010 Printing 195.00 195.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 809.08 738.76 0.00 70.32 8.69 10-533-514030 Small Tools 150.00 99.98 0.00 50.02 33.35 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,650.00 1,632.42 0.00 17.58 1.07 E10 Materials & Supplies 4,134.08 3,683.95 0.00 450.13 10.89 10-533-520030 Dues And Publications 100.00 155.00 0.00 -55.00 -55.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,645.92 1,645.92 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 29,945.00 29,917.78 0.00 27.22 0.09 10-533-522022 Demo 15,000.00 12,595.50 0.00 2,404.50 16.03 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 46,690.92 44,314.20 0.00 2,376.72 5.09 10-533-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-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 160.00 160.00 0.00 0.00 0.00 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 650.00 481.66 0.00 168.34 25.90 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,110.00 911.66 0.00 198.34 17.87 10-533-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 533 PPS - Prop MaintCode Enforce 273,506.00 262,155.99 0.00 11,350.01 4.15 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 214,843.73 197,253.90 0.00 17,589.83 8.19 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 48.56 0.00 0.00 48.56 100.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 16,542.26 14,076.48 0.00 2,465.78 14.91 10-534-502020 Group Health Insurance 33,386.22 33,386.22 0.00 0.00 0.00 10-534-502030 Retirement 37,981.46 26,959.13 0.00 11,022.33 29.02 10-534-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-534-502050 Life Insurance 380.42 327.58 0.00 52.84 13.89 10-534-502060 Long Term Disability 628.65 548.82 0.00 79.83 12.70 10-534-502070 Employee Assistance Prgm 98.86 92.10 0.00 6.76 6.84 10-534-503020 Unemployment Compensation 2,240.00 2,240.00 0.00 0.00 0.00 E05 Personnel Services 306,215.16 274,884.23 0.00 31,330.93 10.23 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-534-511020 Postage 1,128.69 1,107.80 0.00 20.89 1.85 10-534-512010 Printing 114.00 114.00 0.00 0.00 0.00 10-534-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 1,002.19 1,002.19 0.00 0.00 0.00 10-534-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-534-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-534-517010 Operational Supplies 2,110.83 2,110.83 0.00 0.00 0.00 E10 Materials & Supplies 4,370.71 4,334.82 0.00 35.89 0.82 10-534-520030 Dues And Publications 3,683.11 3,683.31 0.00 -0.20 -0.01 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 2,301.66 2,301.66 0.00 0.00 0.00 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,984.77 5,984.97 0.00 -0.20 0.00 10-534-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-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 312.99 312.99 0.00 0.00 0.00 10-534-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-534-547020 Maintenance Agreements 357.03 357.03 0.00 0.00 0.00 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 970.02 940.02 0.00 30.00 3.09 10-534-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 534 Plan & Protect Svcs-Bldg Regs 317,540.66 286,144.04 0.00 31,396.62 9.89 535 Public Works-Central Maintenan 10-535-501020 Salaries 313,289.54 312,397.49 0.00 892.05 0.28 10-535-501040 Part-time (wbenefits)23,860.87 0.00 0.00 23,860.87 100.00 10-535-501050 Parttime(wo Benefits)7,256.01 3,883.48 0.00 3,372.53 46.48 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,809.98 4,938.53 0.00 -128.55 -2.67 10-535-501095 Overtime Straight Pay 555.95 555.95 0.00 0.00 0.00 10-535-502010 Social Security 26,757.59 22,897.09 0.00 3,860.50 14.43 10-535-502020 Group Health Insurance 88,589.19 67,890.23 0.00 20,698.96 23.37 10-535-502030 Retirement 60,257.53 55,948.73 0.00 4,308.80 7.15 10-535-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-535-502050 Life Insurance 572.34 539.30 0.00 33.04 5.77 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-502060 Long Term Disability 945.17 902.84 0.00 42.33 4.48 10-535-502070 Employee Assistance Prgm 173.00 161.14 0.00 11.86 6.86 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 527,067.17 470,114.78 0.00 56,952.39 10.81 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 3.37 0.00 46.63 93.26 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 1,348.25 0.00 151.75 10.12 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 6,777.42 0.00 222.58 3.18 10-535-517010 Operational Supplies 6,000.00 5,853.53 -634.40 780.87 13.01 E10 Materials & Supplies 14,640.00 13,982.57 -634.40 1,291.83 8.82 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 1,631.25 0.00 368.75 18.44 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,500.00 2,131.25 0.00 368.75 14.75 10-535-531010 Electricity 6,716.67 7,197.79 0.00 -481.12 -7.16 10-535-533010 Natural Gas 7,664.98 7,759.69 0.00 -94.71 -1.24 10-535-534010 Telephone 220.00 192.00 0.00 28.00 12.73 10-535-535010 Water 1,400.00 1,421.15 0.00 -21.15 -1.51 E20 Utilities 16,001.65 16,570.63 0.00 -568.98 -3.56 10-535-540010 Building & Grounds Maint.10,000.00 7,399.31 50.00 2,550.69 25.51 10-535-541010 Veh & Equip Parts Etc 487,106.62 469,396.86 0.00 17,709.76 3.64 10-535-546010 Clothing Expense 5,000.00 5,055.96 -3,832.71 3,776.75 75.54 10-535-547010 Equipment Maintenance 4,300.00 2,390.96 0.00 1,909.04 44.40 10-535-547020 Maintenance Agreements 4,100.00 3,322.93 211.20 565.87 13.80 10-535-547030 Radio Maintenance 318.35 0.00 0.00 318.35 100.00 E25 Repairs & Maintenance 510,824.97 487,566.02 -3,571.51 26,830.46 5.25 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,071,033.79 990,365.25 -4,205.91 84,874.45 7.92 540 Public Works-Admin 10-540-501020 Salaries 197,163.06 194,181.39 0.00 2,981.67 1.51 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 15,082.97 13,463.46 0.00 1,619.51 10.74 10-540-502020 Group Health Insurance 32,634.09 30,934.28 0.00 1,699.81 5.21 10-540-502030 Retirement 34,700.70 34,175.84 0.00 524.86 1.51 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-540-502050 Life Insurance 371.88 331.63 0.00 40.25 10.82 10-540-502060 Long Term Disability 473.23 473.23 0.00 0.00 0.00 10-540-502070 Employee Assistance Prgm 74.14 69.08 0.00 5.06 6.82 E05 Personnel Services 280,500.07 273,628.91 0.00 6,871.16 2.45 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 190.49 7.83 0.00 182.66 95.89 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.64 0.00 99.36 99.36 10-540-513010 Office Supplies 1,000.00 10.00 0.00 990.00 99.00 10-540-514010 Gas 77,879.62 66,923.39 0.00 10,956.23 14.07 10-540-514040 Food 232.52 232.52 0.00 0.00 0.00 10-540-517010 Operational Supplies 1,267.48 48.88 0.00 1,218.60 96.14 E10 Materials & Supplies 80,870.11 67,223.26 0.00 13,646.85 16.88 10-540-520030 Dues And Publications 620.80 620.80 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 1,882.20 444.03 0.00 1,438.17 76.41 10-540-522020 Professional Services 197.00 0.00 0.00 197.00 100.00 10-540-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,700.00 1,064.83 0.00 1,635.17 60.56 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 1,175.00 420.50 0.00 754.50 64.21 E25 Repairs & Maintenance 1,175.00 420.50 0.00 754.50 64.21 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 365,245.18 342,337.50 0.00 22,907.68 6.27 541 Public Works-Engineering 10-541-501020 Salaries 683,642.80 675,253.46 0.00 8,389.34 1.23 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 400.00 19.34 0.00 380.66 95.17 10-541-501095 Overtime Straight Pay 400.00 0.00 0.00 400.00 100.00 10-541-502010 Social Security 52,359.87 48,206.21 0.00 4,153.66 7.93 10-541-502020 Group Health Insurance 94,160.94 101,818.62 0.00 -7,657.68 -8.13 10-541-502030 Retirement 120,461.93 115,495.21 0.00 4,966.72 4.12 10-541-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-541-502050 Life Insurance 1,141.26 1,151.13 0.00 -9.87 -0.86 10-541-502060 Long Term Disability 1,884.96 1,908.69 0.00 -23.73 -1.26 10-541-502070 Employee Assistance Prgm 271.86 253.24 0.00 18.62 6.85 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 954,723.62 944,105.90 0.00 10,617.72 1.11 10-541-511010 Advertising 728.00 768.25 0.00 -40.25 -5.53 10-541-511020 Postage 631.75 356.66 0.00 275.09 43.54 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 0.11 0.00 74.89 99.85 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 4,556.46 3,291.84 0.00 1,264.62 27.75 10-541-514030 Small Tools 123.54 0.00 0.00 123.54 100.00 10-541-514040 Food 226.46 226.46 0.00 0.00 0.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 10-541-515070 Const & Inspect Supplies 2,000.00 1,002.28 0.00 997.72 49.89 10-541-515080 Surveying Supplies 2,000.00 1,979.23 0.00 20.77 1.04 10-541-517010 Operational Supplies 2,393.54 2,733.28 0.00 -339.74 -14.19 E10 Materials & Supplies 12,884.75 10,358.11 0.00 2,526.64 19.61 10-541-520030 Dues And Publications 4,000.00 3,136.35 0.00 863.65 21.59 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,000.00 2,527.64 0.00 472.36 15.75 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 938.97 0.00 3,061.03 76.53 10-541-522055 Stormwater Compliance 1,500.00 0.00 0.00 1,500.00 100.00 E15 Contractual Services 12,500.00 6,602.96 0.00 5,897.04 47.18 10-541-534010 Telephone 1,000.00 419.30 0.00 580.70 58.07 E20 Utilities 1,000.00 419.30 0.00 580.70 58.07 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 709.49 0.00 290.51 29.05 10-541-547010 Equipment Maintenance 1,500.00 602.93 0.00 897.07 59.80 10-541-547020 Maintenance Agreements 9,400.00 8,336.28 0.00 1,063.72 11.32 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 12,900.00 10,608.70 0.00 2,291.30 17.76 10-541-572020 Purchase Of Equipment 26,900.00 26,037.62 0.00 862.38 3.21 E70 Capital Purchases 26,900.00 26,037.62 0.00 862.38 3.21 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 1,020,908.37 998,132.59 0.00 22,775.78 2.23 542 Public Works-Street 10-542-501020 Salaries 1,031,248.60 1,016,710.77 0.00 14,537.83 1.41 10-542-501060 Seasonal Salaries 18,000.00 17,861.90 0.00 138.10 0.77 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-501070 Stand-by Plan 4,196.00 4,356.00 0.00 -160.00 -3.81 10-542-501090 Overtime 20,913.79 21,451.69 0.00 -537.90 -2.57 10-542-501095 Overtime Straight Pay 971.52 465.70 0.00 505.82 52.06 10-542-502010 Social Security 82,262.74 78,717.21 0.00 3,545.53 4.31 10-542-502020 Group Health Insurance 171,458.38 160,337.16 0.00 11,121.22 6.49 10-542-502030 Retirement 186,090.06 180,307.13 0.00 5,782.93 3.11 10-542-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-542-502050 Life Insurance 1,743.59 1,734.84 0.00 8.75 0.50 10-542-502060 Long Term Disability 2,867.27 2,867.27 0.00 0.00 0.00 10-542-502070 Employee Assistance Prgm 580.79 541.02 0.00 39.77 6.85 10-542-503010 Awards Program 200.00 49.16 0.00 150.84 75.42 10-542-503020 Unemployment Compensation 237.10 0.00 0.00 237.10 100.00 E05 Personnel Services 1,520,769.84 1,485,399.85 0.00 35,369.99 2.33 10-542-511010 Advertising 296.67 236.01 0.00 60.66 20.45 10-542-511020 Postage 226.85 231.55 0.00 -4.70 -2.07 10-542-512010 Printing 16.48 0.00 0.00 16.48 100.00 10-542-512020 Copies 10.00 3.30 0.00 6.70 67.00 10-542-513010 Office Supplies 1,600.00 1,535.41 0.00 64.59 4.04 10-542-514020 Chemicals 225,000.00 203,016.09 -419,645.35 441,629.26 196.28 10-542-514030 Small Tools 7,698.39 7,289.98 0.00 408.41 5.31 10-542-514040 Food 2,000.00 1,465.03 0.00 534.97 26.75 10-542-515010 Stormwater Material 153.81 153.81 0.00 0.00 0.00 10-542-515020 Street Materials 267,900.00 200,691.75 -11,622.11 78,830.36 29.43 10-542-515040 First Aid Supplies 500.00 248.39 0.00 251.61 50.32 10-542-515060 Weed Control 1,903.50 1,903.50 0.00 0.00 0.00 10-542-515070 Const & Inspect Supplies 161.50 0.00 0.00 161.50 100.00 10-542-517010 Operational Supplies 4,635.00 4,205.21 0.00 429.79 9.27 E10 Materials & Supplies 512,102.20 420,980.03 -431,267.46 522,389.63 102.01 10-542-520030 Dues And Publications 671.50 671.50 0.00 0.00 0.00 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 2,364.82 2,364.82 0.00 0.00 0.00 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 18,259.00 18,266.00 500.00 -507.00 -2.78 10-542-523010 Equipment Rentlease 200.00 98.52 0.00 101.48 50.74 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 21,495.32 21,400.84 500.00 -405.52 -1.89 10-542-531010 Electricity 30,000.00 25,085.62 0.00 4,914.38 16.38 10-542-531020 Street Lights 621,000.00 574,197.73 0.00 46,802.27 7.54 10-542-533010 Natural Gas 15,136.24 9,577.89 0.00 5,558.35 36.72 10-542-534010 Telephone 131.65 72.00 0.00 59.65 45.31 10-542-535010 Water 6,500.00 6,667.71 0.00 -167.71 -2.58 E20 Utilities 672,767.89 615,600.95 0.00 57,166.94 8.50 10-542-540010 Building & Grounds Maint.13,565.70 15,232.23 50.00 -1,716.53 -12.65 10-542-541030 Vehicle Wash 7,000.00 6,839.00 0.00 161.00 2.30 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-542010 Repairs - StopStreet Lights 17,234.53 18,131.32 0.00 -896.79 -5.20 10-542-542030 Signs & Marking Paint 35,000.00 33,915.22 0.00 1,084.78 3.10 10-542-546010 Clothing Expense 10,376.85 11,452.32 0.00 -1,075.47 -10.36 10-542-547010 Equipment Maintenance 2,592.33 2,377.03 0.00 215.30 8.31 10-542-547020 Maintenance Agreements 261.36 261.36 0.00 0.00 0.00 10-542-547030 Radio Maintenance 630.82 630.82 0.00 0.00 0.00 E25 Repairs & Maintenance 86,661.59 88,839.30 50.00 -2,227.71 -2.57 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,813,796.84 2,632,220.97 -430,717.46 612,293.33 21.76 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 4,000.00 24,432.38 0.00 -20,432.38 -510.81 10-700-590070 Airport Subsidy 196,059.23 196,059.23 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,055,200.21 1,055,200.21 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 1,255,259.44 1,275,691.82 0.00 -20,432.38 -1.63 700 Transfers & Subsidies 1,255,259.44 1,275,691.82 0.00 -20,432.38 -1.63 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 Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575015 Police HVAC 267,100.00 1,118.70 265,981.30 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577044 Water Street @ Lohman Landing 339,513.26 193,884.04 0.00 145,629.22 42.89 10-990-577045 Clay Street Plaza 12,210.90 7,351.53 4,859.37 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 705,412.32 108,701.18 -104,875.51 701,586.65 99.46 10-990-577054 Wayfinding 255,000.00 12,328.74 48,616.29 194,054.97 76.10 E75 Capital Projects 1,579,236.48 323,384.19 214,581.45 1,041,270.84 65.94 990 Capital Projects 1,579,236.48 323,384.19 214,581.45 1,041,270.84 65.94 Expense Expense 32,559,151.12 29,205,274.55 -220,320.74 3,574,197.31 10.98 GL - Trial Balance by Acct Type and Full Acct Number (11/09/2015 - 10:29 AM)Page 38 Current Fund Balance: (This includes the $1.5M commitment to the Multipurpose Bldg) FY2014 Year End Fund Balance 6,466,439.00$ Reappropriations from FY2014 (246,542.56)$ 2015 Adjustments/Supplementals (623,307.50)$ Multipurpose Commitment (1,500,000.00)$ Estimated Fund Balance 4,096,588.94$ Estimated Fund Balance %13.90% Reduced Transit Subsidy/Loader Grant Matching/Police HVAC Supplemental/CCP Agreement Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** May-11 6/20/11 91,258.41 38,328.53 51,104.71 Jun-11 7/20/11 101,479.82 42,621.54 56,828.68 Jul-11 8/20/11 88,392.47 37,124.82 49,499.80 Aug-11 9/20/11 73,144.02 30,720.48 40,960.66 Sep-11 10/20/11 103,618.61 43,519.80 58,026.44 Oct-11 11/20/11 105,531.99 44,323.44 59,097.91 Nov-11 12/20/11 66,556.88 27,953.89 37,271.85 Dec-11 1/20/12 52,204.97 21,926.07 29,234.80 Jan-12 2/20/12 65,645.72 27,571.20 36,761.61 566.37 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge Jul-12 8/20/12 89,904.69 37,759.97 50,346.63 Aug-12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) Ck #1001 - C H Johnson Consulting Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 8/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Nov-13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 1/2014 Interest Received (8.28) 1/2014 Service Charge Dec-13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 2/2014 Interest Received (8.28) 2/2014 Service Charge Jan-14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) Ck #1007 - C H Johnson Consulting 2,078.72 3/2014 Interest Received (8.45) 3/2014 Service Charge Feb-14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 4/2014 Interest Received (8.28) 4/2014 Service Charge Mar-14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 5/2014 Interest Received (8.29) 5/2014 Service Charge Apr-14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 6/2014 Interest Received (8.29) 6/2014 Service Charge May-14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 7/2014 Interest Received (8.29) 7/2014 Service Charge Jun-14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 8/2014 Interest Received (8.29) 8/2014 Service Charge Jul-14 8/20/14 98,901.39 41,538.58 55,384.78 2,459.73 9/2014 Interest Received (8.29) 9/2014 Service Charge Aug-14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 10/2014 Interest Received (8.29) 10/2014 Service Charge Sep-14 10/20/14 112,370.02 47,195.41 62,927.21 2,586.87 11/2014 Interest Received (8.29) 11/2014 Service Charge Oct-14 11/20/14 116,992.89 49,137.01 65,516.02 2,736.57 12/2014 Interest Received (14.65) 12/2014 Service Charge Nov-14 12/20/14 72,761.33 30,559.76 40,746.34 2,798.53 1/2015 Interest Received (8.29) 1/2015 Service Charge Dec-14 1/20/15 60,394.73 25,365.79 33,821.05 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 2,575.56 2/2015 Interest Received (8.29) 2/2015 Service Charge Jan-15 2/20/15 85,741.83 36,011.57 48,015.42 2,935.34 3/2015 Interest Received (8.29) 3/2015 Service Charge Feb-15 3/20/15 84,317.61 35,413.40 47,217.86 2,911.14 4/2015 Interest Received (10.54) 4/2015 Service Charge Mar-15 4/20/15 114,789.97 48,211.79 64,282.38 3,049.41 5/2015 Interest Received (8.29) 5/2015 Service Charge Apr-15 5/20/15 102,479.43 43,041.36 57,388.48 3,046.67 6/2015 Interest Received (8.29) 6/2015 Service Charge May-15 6/20/15 116,174.48 48,793.28 65,057.71 3,217.49 7/2015 Interest Received (8.29) 7/2015 Service Charge Jun-15 7/31/15 97,379.11 40,899.23 54,532.30 3,287.90 8/2015 Interest Received (10.67) 8/2015 Service Charge Jul-15 8/20/15 102,541.78 43,067.55 57,423.40 3,307.41 9/2015 Interest Received (8.58) 9/2015 Service Charge Aug-15 9/20/15 81,248.87 34,124.53 45,499.37 3,476.74 10/2015 Interest Received (8.29) 10/2015 Service Charge Sep-15 10/20/15 102,709.81 43,138.12 57,517.49 11/2015 Interest Received 11/2015 Service Charge Total 4,850,698.13 2,037,293.23 2,754,133.42 average monthly amount for 4 cent lockbox fund 51,252.66$ **Effective for 25 years starting in 2011 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy January 45.90%49.20%45.30%38.20% February 51.20%56.00%52.90%49.80% March 59.80%59.30%52.90%54.90% April 58.10%63.70%64.10%53.90% May 63.10%64.70%56.80%53.70% June 59.70%63.70%55.70%53.10% July 60.80%59.70%58.50%51.40% August 52.60%54.20%55.80%47.00% September 63.30%61.20%63.00%59.30% October 67.60%65.90%59.30% November 48.90%52.40%43.40% December 38.30%38.80%33.00% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: September 2015 Percent Change from September 2014 Percent Change from YTD 2014 2015 2014 2015 2014 2015 2014 Occ ADR RevPAR Room Rev Room Avail Room Sold 2015 2014 2015 2014 2015 2014 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 67.9 65.7 122.02 116.68 82.82 76.68 3.3 4.6 8.0 9.3 1.2 4.6 67.3 66.0 120.35 114.98 80.94 75.85 2.0 4.7 6.7 7.8 1.0 3.0 53676 31386 5015957 3635228 West North Central 66.4 65.0 95.59 91.91 63.46 59.75 2.1 4.0 6.2 7.8 1.5 3.7 61.8 61.4 93.52 90.46 57.75 55.51 0.6 3.4 4.0 5.8 1.7 2.3 4522 2612 351533 252199 Missouri 65.3 59.9 96.01 92.22 62.71 55.23 9.1 4.1 13.5 14.2 0.6 9.7 61.1 59.2 93.31 89.67 56.97 53.07 3.2 4.1 7.3 8.1 0.7 3.8 1128 630 102799 72181 Kansas City, MO-KS 67.8 65.1 96.27 90.65 65.24 59.00 4.1 6.2 10.6 11.8 1.1 5.3 66.9 64.2 93.14 89.34 62.30 57.31 4.3 4.2 8.7 9.4 0.6 4.9 292 223 32306 27162 St Louis, MO-IL 73.4 69.0 103.00 99.14 75.57 68.37 6.4 3.9 10.5 11.6 1.0 7.5 67.3 66.3 100.00 95.94 67.33 63.57 1.6 4.2 5.9 6.9 0.9 2.6 330 244 38182 32426 Columbia, MO+61.8 58.9 93.43 92.20 57.70 54.32 4.8 1.3 6.2 8.9 2.5 7.5 57.7 58.5 86.19 82.86 49.75 48.44 -1.3 4.0 2.7 6.9 4.1 2.8 38 30 3935 3349 Jefferson City, MO+63.3 60.7 78.84 75.97 49.89 46.14 4.2 3.8 8.1 8.1 0.0 4.2 57.2 59.0 77.91 74.40 44.56 43.89 -3.1 4.7 1.5 1.5 0.0 -3.1 15 11 1494 1063 Springfield, MO 62.9 56.6 78.47 76.05 49.34 43.01 11.2 3.2 14.7 19.7 4.3 16.0 61.8 58.7 77.22 74.70 47.72 43.88 5.2 3.4 8.7 11.2 2.3 7.6 69 47 6254 4520 Branson, MO 56.2 42.6 98.35 94.65 55.24 40.32 31.9 3.9 37.0 34.1 -2.1 29.0 48.1 43.5 99.21 94.08 47.72 40.91 10.6 5.5 16.6 15.0 -1.4 9.1 153 31 13945 4304 Lake of the Ozarks+51.6 50.7 102.43 98.93 52.83 50.20 1.7 3.5 5.3 8.4 3.0 4.7 48.0 47.8 100.29 99.57 48.14 47.57 0.5 0.7 1.2 2.8 1.6 2.1 37 10 2824 1440 Joplin, MO 60.9 63.2 75.95 72.57 46.27 45.86 -3.6 4.7 0.9 -2.1 -3.0 -6.4 57.1 59.9 75.87 71.88 43.33 43.03 -4.6 5.6 0.7 -0.6 -1.3 -5.9 32 24 2524 2198 A blank row indicates insufficient data.Source 2015 STR, Inc. RevPAR PropertiesADR Participation Occ % Current Month - September 2015 vs September 2014 DISCLOSURE Destination Reports are publications of STR, Inc. (Reports containing only North American data) and STR Global Ltd (Reports containing worldwide data) and are intended solely for use by our paid subscribers. Reproduction or distribution of Destination Reports, in whole or part, without written permission of either STR, Inc. or STR Global Ltd. is prohibited and subject to legal action. Site licenses are available. Please consult your contract with STR, Inc. or STR Global, Ltd for the terms and conditions governing the ownership, distribution and use of Destination Reports and their contents. RevPARADROcc % Year to Date - September 2015 vs September 2014 Rooms Account Number Line Item 2015 Budget Proposed 2016 Budget 2015-2016 Comparison %Change Revenue 4100 Room Tax 465,720.91$ 475,000.00$ 9,279.09$ 1.95% 4200 Interest Earning 360.00$ 400.00$ 40.00$ 10.00% 4300 MDT PMF Coop 32,474.00$ 30,701.25$ (1,772.75)$ -5.77% 4350 Special Events 9,300.00$ 11,000.00$ 1,700.00$ 15.45% 4500 Fundraising Athletic Events Revenue 15,000.00$ 18,500.00$ 3,500.00$ 18.92% 4550 Prison Tour Ticket Sales 226,029.43$ 311,398.44$ 85,369.01$ 27.41% 4600 Grant Support 4700 Misc Advertising revenue 2,225.00$ 2,000.00$ (225.00)$ -11.25% 4801 Jefferson City Promotional Item Sales 43,000.00$ 50,000.00$ 7,000.00$ 14.00% 4900 Miscellaneous Revenue 5,000.00$ 5,000.00$ -$ 0.00% 4950 Jefferson City Outdoors 2,000.00$ 2,000.00$ -$ 0.00% Total Revenue 801,309.34$ 905,999.69$ 104,690.35$ 11.56% Payroll Expenses * 6100 Salaries and Wages 213,000.00$ 225,100.00$ 12,100.00$ 5.38% 6110 Temporary/Part-Time Wages 1,200.00$ 1,200.00$ -$ 0.00% 6120 Retirement Benefits 3,400.00$ 3,500.00$ 100.00$ 2.86% 6130 Payroll Taxes 18,500.00$ 19,500.00$ 1,000.00$ 5.13% 6140 Insurance Benefits 30,100.00$ 31,400.00$ 1,300.00$ 4.14% Total Payroll Expenses 266,200.00$ 280,700.00$ 14,500.00$ 5.17% Administrative and General Expenses 6200 Auditing and Accounting 18,900.00$ 21,000.00$ 2,100.00$ 10.00% * 6210 Building Rental 36,000.00$ 47,000.00$ 11,000.00$ 23.40% 6211 Building Maintenance 5,000.00$ 5,000.00$ -$ 0.00% *6211 Building Utilities 8,200.00$ 6,700.00$ (1,500.00)$ -22.39% 6212 Cleaning Services 1,500.00$ 1,500.00$ -$ 0.00% 6213 Security Monitoring 275.00$ 275.00$ -$ 0.00% 6220 Computer Support/Service 6,320.00$ 6,303.96$ (16.04)$ -0.25% 6230 Consulting 500.00$ 500.00$ -$ 0.00% 6240 Dues and Subscriptions 1,705.00$ 1,752.80$ 47.80$ 2.73% 6245 Depreciation Expense 10,569.96$ 9,420.00$ (1,149.96)$ -12.21% 6250 Office Equip Lease & Repair 3,600.00$ 3,796.36$ 196.36$ 5.17% 6260 Insurance Premiums 4,564.00$ 4,424.00$ (140.00)$ -3.16% 6270 Minor Office Furniture 500.00$ 500.00$ -$ 0.00% 6280 Misc. Expenses 2,590.00$ 2,590.00$ -$ 0.00% 6290 Parking Fee 3,720.00$ 1,980.00$ (1,740.00)$ -87.88% 6300 Office Supplies 1,600.00$ 2,000.00$ 400.00$ 20.00% 6310 Printing and Binding 400.00$ 2,000.00$ 1,600.00$ 80.00% 6320 Telephone and Fax 8,824.40$ 8,700.00$ (124.40)$ -1.43% 6330 Training and Education 1,390.00$ 2,230.00$ 840.00$ 37.67% Total Administrative and General Expense 116,158.36$ 127,672.12$ 11,513.76$ 9.02% Marketing Expenses 6285 Promotional Items to sell 19,000.00$ 30,000.00$ 11,000.00$ 36.67% 6340 Travel Expenses 10,500.00$ 10,275.00$ (225.00)$ -2.19% 6360 MSP Tour Expenses 10,182.00$ 6,243.92$ (3,938.08)$ -63.07% 6361 MSP Salaries and Wages 123,251.16$ 158,931.50$ 35,680.34$ 22.45% 6362 MSP Digital Marketing 9,150.00$ 12,500.00$ 3,350.00$ 26.80% 6363 MSP Credit Card Fees 10,000.00$ 24,000.00$ 14,000.00$ 58.33% 6364 MSP Janitorial Services 2,836.08$ 2,836.08$ 100.00% 6365 MSP Tour Insurance -$ 2,500.00$ 2,500.00$ 100.00% 6367 MSP Advertising 15,530.07$ 13,650.19$ (1,879.88)$ -13.77% 6368 MSP Utilites and Lawn service 20,241.51$ 20,241.51$ 100.00% 6400 Graphic Design 2,500.00$ 2,000.00$ (500.00)$ -25.00% 6410 Outdoor Advertising 24,000.00$ 28,000.00$ 4,000.00$ 14.29% 6420 Wayfinding Signage 6430 Brochures/Printed Material 9,000.00$ 9,000.00$ -$ 0.00% 6440 Postage and Freight 8,000.00$ 8,000.00$ -$ 0.00% 6461 Marketing Memberships 4,570.00$ 4,865.00$ 295.00$ 6.06% 6470 Print Advertising 42,557.75$ 27,973.37$ (14,584.38)$ -52.14% 6490 Marketing Research -$ 6,000.00$ 6,000.00$ 100.00% 6500 Promotion/Publicity 3,750.00$ 5,000.00$ 1,250.00$ 25.00% 6510 Sponsorship 21,500.00$ 28,000.00$ 6,500.00$ 23.21% 6520 Tradeshow Fees 12,551.00$ 10,285.00$ (2,266.00)$ -22.03% 6530 Familiarization tour expense 1,000.00$ 1,000.00$ -$ 0.00% 6540 Marketing Promo 3,010.00$ 5,020.00$ 2,010.00$ 40.04% 6545 Public Relations 27,500.00$ 27,500.00$ -$ 0.00% 6550 Digital Marketing 16,425.00$ 14,358.00$ (2,067.00)$ -14.40% 6560 Local Promotions 2,000.00$ 3,000.00$ 1,000.00$ 33.33% 6620 Special Events 2,100.00$ 2,100.00$ -$ 0.00% 6630 Athletic Events Exp - CVB 14,948.00$ 14,848.00$ (100.00)$ -0.67% 6640 Athletic Events Committee 14,500.00$ 14,500.00$ -$ 0.00% Total Marketing 388,524.98$ 492,627.57$ 104,102.59$ 21.13% Contracted Services 6610 Contracted Services & Exp -$ Total Contracted Services -$ Capital Expenses 6710 Computer Hardware 8,000.00$ 5,000.00$ (3,000.00)$ Total Capital Expenses $8,000.00 5,000.00$ (3,000.00)$ -60.00% 6800 Surplus to be Transferred CVB moving expenses 10,000.00$ MSP moving expenses 20,000.00$ Total Bureau Expenses $787,397.10 905,999.69$ 118,602.59$ 13.09% *6100 - 3% avg & performance measure goal *6210- estimates for 2017 - $42,000 *6211 estimates for 2017-$1200.