Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2016-09-08 packet
Memo To:Steve Crowell From:Shiela Pearre Date:September 7, 2016 Re:Sales Tax Revenues The City received the September 1% Sales Tax in the amount of $1,197,976 which is $106,895 more than projected for September. January thru September overage is $599,765 (5.82%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-15 Jan-16 $929,179 $842,838 $86,341 Dec-15 Feb-16 $812,670 $758,634 $54,036 Jan-16 & Oct-Dec 15 Qtrly Mar-16 $1,183,675 $1,005,810 $177,865 Feb-16 Apr-16 $893,024 $898,713 ($5,689) Mar-16 May-16 $648,305 $710,809 ($62,504) Apr-16 & Jan-Mar 16 Qtrly Jun-16 $1,119,566 $955,932 $163,634 May-16 Jul-16 $1,012,207 $1,006,017 $6,190 Jun-16 Aug-16 $661,518 $588,522 $72,996 Jul-16 & Apr-June 16 Qtrly Sep-16 $1,197,976 $1,091,081 $106,895 Aug-16 Oct-16 $918,937 Sep-16 Nov-16 $656,465 Oct-16 & Jul-Sept 16 Qtrly Dec-16 $870,163 Total Overage/Shortfall $10,303,921 $599,765 1Budgeted based on Monthly 2-year average receipts with adjustment of (175,317) in last period 1/2% Capital Improvement Tax Receipt Actual Budget Period Receipts Projection2 Variance Nov-15 Jan-16 $455,278 $410,680 $44,598 Dec-15 Feb-16 $405,543 $378,536 $27,007 Jan-16 & Oct-Dec 15 Qtrly Mar-16 $563,056 $467,663 $95,393 Feb-16 Apr-16 $431,353 $430,490 $863 Mar-16 May-16 $322,957 $354,055 ($31,098) Apr-16 & Jan-Mar 16 Qtrly Jun-16 $539,529 $456,704 $82,825 May-16 Jul-16 $498,229 $488,494 $9,735 Jun-16 Aug-16 $330,112 $293,445 $36,667 Jul-16 & Apr-June 16 Qtrly Sep-16 $570,134 $525,144 $44,990 Aug-16 Oct-16 $436,278 Sep-16 Nov-16 $327,545 Oct-16 & Jul-Sept 16 Qtrly Dec-16 $130,966 Total Overage/Shortfall $4,700,000 $310,980 2Budgeted based on Monthly 2-year average receipts with adjustment of (369,341) in last period 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-15 Jan-16 $455,239 $410,590 $44,649 Dec-15 Feb-16 $405,543 $377,966 $27,577 Jan-16 & Oct-Dec 15 Qtrly Mar-16 $563,039 $467,564 $95,475 Feb-16 Apr-16 $431,353 $430,407 $946 Mar-16 May-16 $322,957 $353,058 ($30,101) Apr-16 & Jan-Mar 16 Qtrly Jun-16 $539,529 $456,615 $82,914 May-16 Jul-16 $498,229 $488,414 $9,815 Jun-16 Aug-16 $330,112 $293,221 $36,891 Jul-16 & Apr-June 16 Qtrly Sep-16 $572,847 $525,060 $47,787 Aug-16 Oct-16 $436,232 Sep-16 Nov-16 $327,437 Oct-16 & Jul-Sept 16 Qtrly Dec-16 $343,191 Total Overage/Shortfall $4,909,755 $315,953 3Budgeted based on Monthly 2-year average receipts with adjustment of (156,992) in last period Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 9/7/2016 Account Name General Fund Sales TaxOne percent (1%)Receipt Month: SEPTEMBER 2016 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2011 2012 2013 2014 2015 2016 Average Nov January 809,385 843,061 764,659 741,056 944,619 929,179 act.820,556 Dec February 833,919 619,287 703,181 789,830 727,437 812,670 act.734,731 Jan & Oct-Dec Qtrly March 589,958 992,559 1,008,111 920,599 1,091,021 1,183,675 act.920,450 Feb April 978,391 852,653 777,424 737,482 1,059,943 893,024 act.881,179 Mar May 633,676 530,069 537,141 802,765 618,854 648,305 act.624,501 Apr & Jan-Mar Qtrly June 925,555 1,028,514 1,023,015 865,930 1,045,933 1,119,566 act.977,790 May July 955,495 797,785 872,436 1,048,754 963,280 1,012,207 act.927,550 Jun August 566,299 557,032 546,351 614,048 562,996 661,518 act.569,345 Jul & Apr-Jun Qtrly September 1,032,258 1,069,414 1,096,581 996,272 1,185,891 1,197,976 act.1,076,083 Aug October 797,510 769,129 717,262 919,035 918,839 918,937 est.824,355 Sept November 536,185 615,421 677,366 651,080 661,849 656,465 est.628,380 Oct & Jul-Sept Qtrly December 1,032,046 982,684 932,387 1,015,322 1,075,638 870,163 est.1,007,615 Actual to Date $ 9,690,677 $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 8,458,121 Estimated to Fiscal Year end (based on averages and on Budgeted amount)2,445,565 Total Actual & Estimated $ 10,903,686 Less: Budget 10,303,921 Over (Under) Budget $ 599,765 $ 929,179 $ 1,741,849 $ 2,925,524 $ 3,818,548 $ 4,466,854 $ 5,586,420 $ 6,598,627 $ 7,260,145 $ 8,458,121 $ 842,838 $ 1,601,472 $ 2,607,282 $ 3,505,995 $ 4,216,804 $ 5,172,736 $ 6,178,753 $ 6,767,275 $ 7,858,356 $ 8,777,293 $ 9,433,758 $ 10,303,921 $ 500,000$ 750,000$ 1,000,000$ 1,250,000$ 1,500,000$ 1,750,000$ 2,000,000$ 2,250,000$ 2,500,000$ 2,750,000$ 3,000,000$ 3,250,000$ 3,500,000$ 3,750,000$ 4,000,000$ 4,250,000$ 4,500,000$ 4,750,000$ 5,000,000$ 5,250,000$ 5,500,000$ 5,750,000$ 6,000,000$ 6,250,000$ 6,500,000$ 6,750,000$ 7,000,000$ 7,250,000$ 7,500,000$ 7,750,000$ 8,000,000$ 8,250,000$ 8,500,000$ 8,750,000$ 9,000,000$ 9,250,000$ 9,500,000$ 9,750,000$ 10,000,000$ 10,250,000$ 10,500,000$ 10,750,000$ 11,000,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 9/7/2016 Account Name Capital Imprs Sales Tax Receipt Month: SEPTEMBER 2016 Account Number 44-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2011 2012 2013 2014 2015 2016 Average Nov January 396,799 412,434 372,459 359,800 461,560 455,278 act.400,610 Dec February 407,407 308,567 350,813 394,475 362,597 405,543 act.364,772 Jan & Oct-Dec Qtrly March 280,758 466,856 475,110 423,641 511,685 563,056 act.431,610 Feb April 452,824 409,365 372,340 348,172 512,808 431,353 act.419,102 Mar May 315,165 263,902 266,422 399,863 308,247 322,957 act.310,720 Apr & Jan-Mar Qtrly June 439,298 494,757 483,070 416,943 496,466 539,529 act.466,107 May July 468,643 389,423 425,325 503,869 473,120 498,229 act.452,076 Jun August 282,859 278,231 272,603 306,157 280,733 330,112 act.284,117 Jul & Apr-Jun Qtrly September 482,244 504,307 521,260 484,992 565,296 570,134 act.511,620 Aug October 382,206 367,366 357,619 430,185 442,371 436,278 est.395,949 Sept November 266,364 306,968 323,871 324,697 330,393 327,545 est.310,459 Oct & Jul-Sept Qtrly December 495,406 469,095 443,688 485,136 515,478 130,966 est.481,761 Actual to Date $ 4,669,974 $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 4,116,191 Estimated to Fiscal Year end (based on averages and on Budgeted amount)894,789 Total Actual & Estimated $ 5,010,980 Less: Budget 4,700,000 Over (Under) Budget $ 310,980 $ 455,278 $ 860,821 $ 1,423,877 $ 1,855,230 $ 2,178,187 $ 2,717,716 $ 3,215,945 $ 3,546,057 $ 4,116,191 $ 410,680 $ 789,216 $ 1,256,879 $ 1,687,369 $ 2,041,424 $ 2,498,128 $ 2,986,622 $ 3,280,067 $ 3,805,211 $ 4,241,489 $ 4,569,034 $ 4,700,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 9/7/2016 Account Name Parks Sales Tax Receipt Month: SEPTEMBER 2016 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2011 2012 2013 2014 2015 2015 Average Nov January 396,815 405,730 372,447 359,708 461,472 455,239 act.399,234 Dec February 407,348 308,456 350,714 393,562 362,371 405,543 act.364,490 Jan & Oct-Dec Qtrly March 280,734 466,713 475,026 423,546 511,582 563,039 act.431,520 Feb April 452,735 409,353 372,242 348,076 512,738 431,353 act.419,029 Mar May 315,030 263,822 266,456 398,085 308,030 322,957 act.310,285 Apr & Jan-Mar Qtrly June 439,265 494,733 482,382 416,845 496,386 539,529 act.465,922 May July 468,387 389,006 425,194 503,790 473,038 498,229 act.451,883 Jun August 282,836 278,072 272,321 305,930 280,513 330,112 act.283,934 Jul & Apr-Jun Qtrly September 482,150 505,913 521,155 484,904 565,217 572,847 act.511,868 Aug October 382,115 366,846 357,482 430,093 442,370 436,232 est.395,781 Sept November 264,735 306,831 323,768 324,481 330,393 327,437 est.310,042 Oct & Jul-Sept Qtrly December 495,305 468,924 443,569 484,999 515,368 343,191 est.481,633 Actual to Date $ 4,667,453 $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 4,118,848 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,106,860 Total Actual & Estimated $ 5,225,708 Less: Budget 4,909,755 Over (Under) Budget $ 315,953 $ 455,239 $ 860,782 $ 1,423,821 $ 1,855,174 $ 2,178,131 $ 2,717,660 $ 3,215,889 $ 3,546,000 $ 4,118,848 $ 410,590 $ 788,556 $ 1,256,120 $ 1,686,527 $ 2,039,585 $ 2,496,200 $ 2,984,614 $ 3,277,835 $ 3,802,895 $ 4,239,127 $ 4,566,564 $ 4,909,755 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 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 Revenue Model Report For Period Ending August 31, 2016 Data as of September 7, 2016 CFY 2016 YTD Actual Projected Over/ Description Budget As of 9/7/16 (Under) Budget Sales Tax and Use Tax $10,303,920.64 $8,458,121.12 $810,527.00 Intergovernmental Taxes $2,175,000.00 $1,674,127.31 $69,120.96 Other Taxes $120,000.00 $88,333.32 ($768.08) Franchise & Utility Tax $7,557,241.00 $5,317,851.95 ($303,085.41) Property Taxes $5,249,399.00 $5,222,264.34 ($5,842.48) Intergovernmental $3,930.00 $52,301.29 ($3,930.00) Charges for Services $2,614,957.65 $2,552,759.56 $99,828.18 Fees, Licenses, & Permits $716,850.00 $698,902.43 $78,648.17 Fines & Forfeitures $986,300.00 $803,060.09 ($12,821.08) Contributions/Donations $134,371.30 $182,835.53 $88,923.85 Other Operating Revenues $65,000.00 $66,908.39 $9,583.14 Interest Income $95,000.00 $120,526.58 $54,536.04 Other Non Operating Revenue $25,000.00 $223,380.00 $223,380.00 Operating Transfers In $72,200.00 $68,010.24 ($513.96) Totals $30,119,169.59 $25,529,382.15 $1,107,586.32 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending August 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 9/7/16 As of 9/7/16 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $0.00 $10,303,920.64 $8,458,121.12 $2,656,326.52 $11,114,447.64 $810,527.00 $810,527.00 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10,303,920.64 $8,458,121.12 $2,656,326.52 $11,114,447.64 $810,527.00 $810,527.00Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $0.00 $510,000.00 $373,839.74 $176,452.36 $550,292.10 $40,292.10 $40,292.10 10-100-403010 Gasoline Tax $0.00 $1,115,000.00 $747,643.29 $393,541.29 $1,141,184.58 $26,184.58 $26,184.58 10-100-430080 Road & Bridge Tax $0.00 $550,000.00 $552,644.28 $0.00 $552,644.28 $2,644.28 $2,644.28 $2,175,000.00 $1,674,127.31 $569,993.65 $2,244,120.96 $69,120.96 $69,120.96Other Taxes 10-100-403020 Cig Tax $0.00 $120,000.00 $88,333.32 $30,898.60 $119,231.92 ($768.08)($768.08) $120,000.00 $88,333.32 $30,898.60 $119,231.92 ($768.08)($768.08)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $0.00 $3,953,963.00 $2,798,431.25 $1,169,151.68 $3,967,582.93 $13,619.93 $13,619.93 10-100-410030 Gas Utility License Tax $0.00 $1,083,278.00 $686,142.67 $114,143.95 $800,286.62 ($282,991.38)($282,991.38) 10-100-410052 Telephone Cell w/o audit money $0.00 $2,100,000.00 $1,529,775.98 $528,256.22 $2,058,032.20 ($41,967.80)($41,967.80) 10-100-410053 Telephone/Cell Utility Audit $0.00 $0.00 ($17,210.20)$17,210.20 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $0.00 $420,000.00 $320,712.25 $107,541.59 $428,253.84 $8,253.83 $8,253.83 10-100-410061 Cable Utility Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7,557,241.00 $5,317,851.95 $1,936,303.64 $7,254,155.59 ($303,085.41)($303,085.41)Property Taxes 10-100-420010 Current Property Tax $0.00 $4,578,000.00 $4,579,050.07 $8,093.56 $4,587,143.63 $9,143.63 $9,143.63 10-100-420020 Del Property Tax $0.00 $55,000.00 $37,088.38 $2,442.81 $39,531.19 ($15,468.82)($15,468.82) 10-100-420040 Fin Institution Tax $0.00 $40,000.00 $41,818.57 $0.00 $41,818.57 $1,818.57 $1,818.57 10-100-420050 Prop Tax Int & Penalties $0.00 $30,000.00 $19,336.28 $4,805.22 $24,141.50 ($5,858.51)($5,858.51) 10-100-420055 Surtax Receipts - County Reimb $0.00 $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10-100-420060 Surtax Receipts $0.00 $472,000.00 $465,643.86 $1,636.39 $467,280.25 ($4,719.76)($4,719.76) 10-100-420080 Special Tax Rev $0.00 $20,000.00 $24,927.90 $4,314.22 $29,242.12 $9,242.12 $9,242.12 $5,249,399.00 $5,222,264.34 $21,292.18 $5,243,556.52 ($5,842.48)($5,842.48)Intergovernmental 10-100-430010 Federal Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430020 State Grant $0.00 $3,930.00 $0.00 $0.00 $0.00 ($3,930.00)($3,930.00) 10-100-430100 State DNR Historic Pres $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480020 NSP Rehab Sales $0.00 $0.00 $52,301.29 ($52,301.29)$0.00 $0.00 $0.00 10-100-480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3,930.00 $52,301.29 ($52,301.29)$0.00 ($3,930.00)($3,930.00)Charges for Services 10-100-440010 Admin Charge Backs $0.00 $1,559,899.00 $1,559,899.00 $0.00 $1,559,899.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $0.00 $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $0.00 $25,000.00 $21,374.00 $4,944.00 $26,318.00 $1,318.00 $1,318.00 10-100-440910 Fuel Charge - backs $0.00 $13,000.00 $6,733.81 $0.00 $6,733.81 ($6,266.19)($6,266.19) 10-100-440920 Parts Charge backs $0.00 $110,000.00 $131,365.73 $18,333.33 $149,699.06 $39,699.06 $39,699.06 10-100-440930 Labor Charge backs $0.00 $216,449.00 $190,722.25 $34,093.91 $224,816.16 $8,367.16 $8,367.16 10-100-450189 Animal Shelter Bricks $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481020 Cole Cty Animal Rescue $0.00 $105,000.00 $78,038.49 $27,974.34 $106,012.83 $1,012.83 $1,012.83 10-100-481030 Rent City Hall/annex $0.00 $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00 10-100-481039 Rent-Hyde Park Facility $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481040 Rent Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $0.00 $104,000.00 $149,943.69 $4,804.08 $154,747.77 $50,747.77 $50,747.77 10-100-481065 Parking Spot Maintenance $0.00 $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $0.00 $369,879.65 $305,454.20 $61,646.60 $367,100.80 ($2,778.85)($2,778.85) 10-100-481080 Sale Of Maps/gis Data $0.00 $0.00 $265.00 $0.00 $265.00 $265.00 $265.00 10-100-481085 Cole Cty Gis Joint Coop $0.00 $15,000.00 $12,500.00 $2,500.00 $15,000.00 $0.00 $0.00 10-100-481090 Cole Cty Sheriff-New World $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $0.00 $4,000.00 $3,264.00 $0.00 $3,264.00 ($736.00)($736.00) 10-100-481105 TIF Administration Fee $0.00 $7,730.00 $8,105.00 $7,730.00 $15,835.00 $8,105.00 $8,105.00 10-100-481110 Long & Short $0.00 $0.00 $94.39 $0.00 $94.39 $94.39 $94.39 $2,614,957.65 $2,552,759.56 $162,026.27 $2,714,785.83 $99,828.18 $99,828.18Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $0.00 $65,000.00 $63,913.58 $1,441.25 $65,354.83 $354.83 $354.83 10-100-450020 Business Licenses $0.00 $215,000.00 $203,621.35 $15,147.44 $218,768.79 $3,768.79 $3,768.79 10-100-450021 Home Occupation Permit $0.00 $1,500.00 $1,431.00 $132.00 $1,563.00 $63.00 $63.00 10-100-450030 Solicitors Lic $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450040 Abandoned Bldg. Reg $0.00 $0.00 $5,400.00 $0.00 $5,400.00 $5,400.00 $5,400.00 10-100-450041 Abandoned Bldg. Admin Fee $0.00 $6,500.00 $5,238.00 $0.00 $5,238.00 ($1,262.00)($1,262.00) 10-100-450045 Bldg. Constr Fees $0.00 $175,000.00 $168,962.62 $51,773.88 $220,736.50 $45,736.50 $45,736.50 10-100-450050 Electrical Certificates $0.00 $18,000.00 $16,950.00 $358.00 $17,308.00 ($692.00)($692.00) 10-100-450060 Electrical Permits $0.00 $3,000.00 $2,055.52 $1,801.18 $3,856.70 $856.70 $856.70 10-100-450070 Plumbing Licenses $0.00 $10,000.00 $10,188.00 $476.00 $10,664.00 $664.00 $664.00 10-100-450080 Plumbing Permits $0.00 $5,000.00 $3,224.65 $580.00 $3,804.65 ($1,195.35)($1,195.35) 10-100-450090 Other Lic & Permits $0.00 $2,000.00 $1,287.00 $792.00 $2,079.00 $79.00 $79.00 10-100-450091 Day Care Inspection Fees $0.00 $9,000.00 $5,200.00 $2,147.50 $7,347.50 ($1,652.50)($1,652.50) 10-100-450092 Food Inspection Fees $0.00 $86,500.00 $86,628.91 $907.69 $87,536.60 $1,036.60 $1,036.60 10-100-450100 Curb Cut Permits $0.00 $1,500.00 $583.00 $53.00 $636.00 ($864.00)($864.00) 10-100-450110 Board Of Adj Fees $0.00 $1,200.00 $1,260.00 $0.00 $1,260.00 $60.00 $60.00 10-100-450120 Sign Permits $0.00 $5,000.00 $6,295.00 $560.00 $6,855.00 $1,855.00 $1,855.00 10-100-450130 Demolition Permits $0.00 $500.00 $1,484.00 $0.00 $1,484.00 $984.00 $984.00 10-100-450150 Acc Rep Fees-police $0.00 $12,000.00 $9,770.80 $1,763.80 $11,534.60 ($465.40)($465.40) 10-100-450160 Accrpt/blastg P-fire $0.00 $750.00 $969.00 $311.50 $1,280.50 $530.50 $530.50 10-100-450170 Animal Redemption Fees $0.00 $55,000.00 $55,631.00 $11,052.50 $66,683.50 $11,683.50 $11,683.50 10-100-450180 Animal Vaccinations Fees $0.00 $5,000.00 $3,800.00 $762.50 $4,562.50 ($437.50)($437.50) 10-100-450185 Animal Cremation Fees $0.00 $25,000.00 $27,545.00 $4,043.00 $31,588.00 $6,588.00 $6,588.00 10-100-450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450190 Taxi Permits $0.00 $500.00 $962.00 $26.00 $988.00 $488.00 $488.00 10-100-450230 Vacating Right Of Way $0.00 $400.00 $1,330.00 $131.50 $1,461.50 $1,061.50 $1,061.50 10-100-450250 Rezoning Request $0.00 $12,000.00 $4,499.00 $2,247.50 $6,746.50 ($5,253.50)($5,253.50) 10-100-450255 Planning & Zoning Review Fees $0.00 $0.00 $8,713.00 $0.00 $8,713.00 $8,713.00 $8,713.00 10-100-450260 Non-refundable Plans/spec $0.00 $1,500.00 $1,960.00 $87.50 $2,047.50 $547.50 $547.50 $716,850.00 $698,902.43 $96,595.74 $795,498.17 $78,648.17 $78,648.17 CFY2016 Revenue Model Report (Detail)Remaining For Period Ending August 31, 2016 Start YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Month Budget As of 9/7/16 As of 9/7/16 TOTAL (Under) Budget of Formulas Fines & Forfeitures 10-100-460010 Court Cost $0.00 $75,500.00 $61,997.01 $13,334.69 $75,331.70 ($168.30)($168.30) 10-100-460015 Court Restitutions $0.00 $1,300.00 $89.71 $0.00 $89.71 ($1,210.29)($1,210.29) 10-100-460018 Inmate Security Fund $0.00 $12,500.00 $9,960.61 $2,078.82 $12,039.43 ($460.57)($460.57) 10-100-460020 Jail Cost Recovery $0.00 $8,000.00 $2,299.99 $597.06 $2,897.05 ($5,102.96)($5,102.96) 10-100-460025 Alcohol Offense Cost Rec $0.00 $8,000.00 $6,956.50 $1,353.25 $8,309.75 $309.75 $309.75 10-100-460030 Pol Fines-traffic $0.00 $835,000.00 $675,983.76 $147,109.80 $823,093.56 ($11,906.44)($11,906.44) 10-100-460040 Pol Tickets-parking $0.00 $0.00 $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 $0.00 $0.00 10-100-460060 Dog Fines $0.00 $0.00 $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 $0.00 $0.00 10-100-460090 Parking Fines $0.00 $53,000.00 $48,796.00 $6,509.98 $55,305.98 $2,305.98 $2,305.98 10-100-460100 Bankcard Charges $0.00 ($7,000.00)($3,023.49)($564.77)($3,588.26)$3,411.74 $3,411.74 $986,300.00 $803,060.09 $170,418.83 $973,478.92 ($12,821.08)($12,821.09)Contributions/Donations 10-100-480010 Citizen Participation $0.00 $0.00 $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 $0.00 $0.00 10-100-480030 Donations-Recycling $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480050 Sober Driver Program $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480055 JC Fire Museum $0.00 $0.00 $2,315.00 $0.00 $2,315.00 $2,315.00 $2,315.00 10-100-480063 Private Donations-Cultural Art $0.00 $0.00 $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 $0.00 $0.00 10-100-480070 Community Projects Donations $0.00 $3,300.00 $3,300.00 $0.00 $3,300.00 $0.00 $0.00 10-100-480080 Dare Donations $0.00 $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10-100-480090 Police K-9 Donations $0.00 $55,500.00 $55,500.00 $0.00 $55,500.00 $0.00 $0.00 10-100-480165 Animal S Donations $0.00 $0.00 $9,164.28 $0.00 $9,164.28 $9,164.28 $9,164.28 10-100-481050 Transfer Stn/Plng-Sld Wst Cntr $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481055 Street Repair-Solid Waste Cntr $0.00 $75,000.00 $111,484.95 $40,459.62 $151,944.57 $76,944.57 $76,944.57 10-100-481095 Cemetery Donations $0.00 $571.30 $571.30 $0.00 $571.30 $0.00 $0.00 10-100-486070 Cap Contr-neighorhood Imp Pro $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $134,371.30 $182,835.53 $40,459.62 $223,295.15 $88,923.85 $88,923.85 Other Operating Revenues 10-100-450187 Special Sn Program $0.00 $0.00 $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 $0.00 $0.00 10-100-480011 Police Evidence Funds $0.00 $0.00 $14,342.74 $0.00 $14,342.74 $14,342.74 $14,342.74 10-100-481069 Utility Audit Revenue $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $0.00 $35,000.00 $18,558.07 $0.00 $18,558.07 ($16,441.93)($16,441.93) 10-100-481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481074 Revenue Share - Purchasing Card $0.00 $16,789.46 $0.00 $16,789.46 $16,789.46 $16,789.46 10-100-481077 Insurance Claims $0.00 $20,000.00 $17,218.12 $7,674.75 $24,892.87 $4,892.87 $4,892.87 10-100-481078 Cafeteria Refunds $0.00 $10,000.00 $0.00 $0.00 $0.00 ($10,000.00)($10,000.00) $65,000.00 $66,908.39 $7,674.75 $74,583.14 $9,583.14 $9,583.14Interest Income 10-100-470010 Interest $0.00 $95,000.00 $120,526.58 $29,009.46 $149,536.04 $54,536.04 $54,536.04 10-100-470051 Unrealized Gains and Losses $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $95,000.00 $120,526.58 $29,009.46 $149,536.04 $54,536.04 $54,536.04Other Non Operating Revenue 10-100-485049 Cap Vhcl Equip sale of assets $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-485050 Sale Of Assets $0.00 $25,000.00 $223,380.00 $25,000.00 $248,380.00 $223,380.00 $223,380.00 $25,000.00 $223,380.00 $25,000.00 $248,380.00 $223,380.00 $223,380.00Operating Transfers In 10-100-490193 Trsfer From Grant Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490240 Trsfr From Lodging Tax $0.00 $23,800.00 $19,610.24 $3,675.80 $23,286.04 ($513.96)($513.96) 10-100-490260 Trsfr from Fireman's Spec Rev $0.00 $0.00 $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 $0.00 $0.00 10-100-490353 Transfer From Cit "e"$0.00 $0.00 $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 $0.00 $0.00 10-100-490620 Transfer from Parking Fund $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $48,400.00 $48,400.00 $0.00 $48,400.00 $0.00 $0.00 $72,200.00 $68,010.24 $3,675.80 $71,686.04 ($513.96)($513.96) $30,119,169.59 $25,529,382.15 $5,697,373.76 $31,226,755.91 $1,107,586.32 $1,107,586.32 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 09/06/16 09:00:22 Period 01 - 13 Fiscal Year 2016 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 10,303,920.64 7,260,144.71 0.00 3,043,775.93 29.54 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 10,303,920.64 7,260,144.71 0.00 3,043,775.93 29.54 10-100-401030 Motor Vehicle Tax 510,000.00 373,839.74 0.00 136,160.26 26.70 10-100-403010 Gasoline Tax 1,115,000.00 747,643.29 0.00 367,356.71 32.95 10-100-430080 Road & Bridge Tax 550,000.00 552,644.28 0.00 -2,644.28 -0.48 R16 Intergovernmental Taxes 2,175,000.00 1,674,127.31 0.00 500,872.69 23.03 10-100-403020 Cigarette Tax 120,000.00 88,333.32 0.00 31,666.68 26.39 R20 Other Taxes 120,000.00 88,333.32 0.00 31,666.68 26.39 10-100-410020 Electric Utility Lic Tax 3,953,963.00 2,798,431.25 0.00 1,155,531.75 29.22 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 1,083,278.00 686,142.67 0.00 397,135.33 36.66 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,100,000.00 1,529,775.98 0.00 570,224.02 27.15 10-100-410053 TelephoneCell Utility-AUDIT 0.00 -17,210.20 0.00 17,210.20 0.00 10-100-410060 Cable Franchise Fee 420,000.00 320,712.25 0.00 99,287.75 23.64 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,557,241.00 5,317,851.95 0.00 2,239,389.05 29.63 10-100-420010 Cur Property Tax 4,578,000.00 4,579,050.07 0.00 -1,050.07 -0.02 10-100-420020 Del Property Tax 55,000.00 37,088.38 0.00 17,911.62 32.57 10-100-420040 Fin Inst Tax 40,000.00 41,818.57 0.00 -1,818.57 -4.55 10-100-420050 Prop Tax Int & Penalties 30,000.00 19,336.28 0.00 10,663.72 35.55 10-100-420055 Surtax Receipts - County Reimb 54,399.00 54,399.28 0.00 -0.28 0.00 10-100-420060 Surtax Receipts 472,000.00 465,643.86 0.00 6,356.14 1.35 10-100-420080 Special Tax Rev 20,000.00 24,927.90 0.00 -4,927.90 -24.64 R40 Property Taxes 5,249,399.00 5,222,264.34 0.00 27,134.66 0.52 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-100-430020 State Grants 3,930.00 0.00 0.00 3,930.00 100.00 10-100-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-100-430060 Drug Forfeiture 0.00 1,162.50 0.00 -1,162.50 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 52,301.29 0.00 -52,301.29 0.00 10-100-480025 HUD Program Income 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 3,930.00 53,463.79 0.00 -49,533.79 -1,260.40 10-100-440010 Admin Charge Backs 1,559,899.00 1,559,899.00 0.00 0.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 21,109.00 0.00 3,891.00 15.56 10-100-440910 Fuel Charge-backs 13,000.00 6,733.81 0.00 6,266.19 48.20 10-100-440920 Parts Charge-back 110,000.00 131,365.73 0.00 -21,365.73 -19.42 10-100-440930 Labor Charge-backs 216,449.00 190,722.25 0.00 25,726.75 11.89 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 105,000.00 78,038.49 0.00 26,961.51 25.68 10-100-481030 Rent City Hallannex 35,000.00 35,000.00 0.00 0.00 0.00 10-100-481039 Rent-Hyde Park Facility 0.00 0.00 0.00 0.00 0.00 10-100-481040 Rent Other 0.00 0.00 0.00 0.00 0.00 10-100-481045 Rent-tower Sites 104,000.00 149,943.69 0.00 -45,943.69 -44.18 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 369,879.65 305,454.20 0.00 64,425.45 17.42 10-100-481080 Sale Of Mapsgis Data 0.00 265.00 0.00 -265.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 12,500.00 0.00 2,500.00 16.67 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 4,000.00 2,448.00 0.00 1,552.00 38.80 10-100-481105 TIF Administration Fee 7,730.00 8,105.00 0.00 -375.00 -4.85 10-100-481110 Long & Short 0.00 64.39 0.00 -64.39 0.00 R60 Charges for Services 2,614,957.65 2,551,648.56 0.00 63,309.09 2.42 10-100-450010 Liquor Licenses 65,000.00 63,898.58 0.00 1,101.42 1.69 10-100-450020 Business Licenses 215,000.00 202,651.35 0.00 12,348.65 5.74 10-100-450021 Home Occupation Permit 1,500.00 1,431.00 0.00 69.00 4.60 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 5,400.00 0.00 -5,400.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 6,500.00 5,238.00 0.00 1,262.00 19.42 10-100-450045 Bldg Constr Fees 175,000.00 168,456.51 0.00 6,543.49 3.74 10-100-450050 Electrical Certificates 18,000.00 16,950.00 0.00 1,050.00 5.83 10-100-450060 Electrical Permits 3,000.00 2,055.52 0.00 944.48 31.48 10-100-450070 Plumbing Licenses 10,000.00 10,188.00 0.00 -188.00 -1.88 10-100-450080 Plumbing Permits 5,000.00 3,144.65 0.00 1,855.35 37.11 10-100-450090 Other Lic & Permits 2,000.00 1,287.00 0.00 713.00 35.65 10-100-450091 Day Care Inspection Fees 9,000.00 5,200.00 0.00 3,800.00 42.22 10-100-450092 Food Inspection Fees 86,500.00 86,628.91 0.00 -128.91 -0.15 10-100-450100 Curb Cut Permits 1,500.00 583.00 0.00 917.00 61.13 10-100-450110 Board Of Adj Fees 1,200.00 1,260.00 0.00 -60.00 -5.00 10-100-450120 Sign Permits 5,000.00 6,295.00 0.00 -1,295.00 -25.90 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450130 Demolition Permits 500.00 1,325.00 0.00 -825.00 -165.00 10-100-450150 Acc Rep Fees-police 12,000.00 9,680.80 0.00 2,319.20 19.33 10-100-450160 Accrptblastg P-fire 750.00 969.00 0.00 -219.00 -29.20 10-100-450170 Animal Redemption Fees 55,000.00 55,631.00 0.00 -631.00 -1.15 10-100-450180 Animal Vaccinations Fees 5,000.00 3,800.00 0.00 1,200.00 24.00 10-100-450185 Animal Cremation Fees 25,000.00 27,545.00 0.00 -2,545.00 -10.18 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 500.00 962.00 0.00 -462.00 -92.40 10-100-450230 Vacating Right Of Way 400.00 1,330.00 0.00 -930.00 -232.50 10-100-450250 Rezoning Request 12,000.00 4,499.00 0.00 7,501.00 62.51 10-100-450255 Planning & Zoning Review Fees 0.00 8,713.00 0.00 -8,713.00 0.00 10-100-450260 Non-refundable Plansspec 1,500.00 1,960.00 0.00 -460.00 -30.67 R65 Fees Licenses & Permits 716,850.00 697,082.32 0.00 19,767.68 2.76 10-100-460010 Court Cost 75,500.00 61,997.01 0.00 13,502.99 17.88 10-100-460015 Court Restitutions 1,300.00 89.71 0.00 1,210.29 93.10 10-100-460018 Inmate Security Fund 12,500.00 9,960.61 0.00 2,539.39 20.32 10-100-460020 Jail Cost Recovery 8,000.00 2,299.99 0.00 5,700.01 71.25 10-100-460025 Alcohol Offense Cost Rec 8,000.00 6,956.50 0.00 1,043.50 13.04 10-100-460030 Pol Fines-traffic 835,000.00 675,983.76 0.00 159,016.24 19.04 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 48,796.00 0.00 4,204.00 7.93 10-100-460100 Bankcard Charges -7,000.00 -3,023.49 0.00 -3,976.51 56.81 R70 Fines & Forfeitures 986,300.00 803,060.09 0.00 183,239.91 18.58 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 0.00 0.00 0.00 0.00 0.00 10-100-480055 JC Fire Museum 0.00 2,315.00 0.00 -2,315.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 3,300.00 3,300.00 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 55,500.00 55,500.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 9,164.28 0.00 -9,164.28 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 75,000.00 111,484.95 0.00 -36,484.95 -48.65 10-100-481095 Cemetery Donations 571.30 571.30 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 134,371.30 182,835.53 0.00 -48,464.23 -36.07 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 14,342.74 0.00 -14,342.74 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-481069 Utility Audit Revenue 0.00 0.00 0.00 0.00 0.00 10-100-481070 Miscellaneous 35,000.00 18,521.11 0.00 16,478.89 47.08 10-100-481072 TIF Prof Svcs Deposit 0.00 0.00 0.00 0.00 0.00 10-100-481074 Revenue Share 0.00 16,789.46 0.00 -16,789.46 0.00 10-100-481077 Insurance Claims 20,000.00 17,218.12 0.00 2,781.88 13.91 10-100-481078 Cafeteria Refunds 10,000.00 0.00 0.00 10,000.00 100.00 R75 Other Operating Revenues 65,000.00 66,871.43 0.00 -1,871.43 -2.88 10-100-470010 Interest 95,000.00 120,526.58 0.00 -25,526.58 -26.87 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 95,000.00 120,526.58 0.00 -25,526.58 -26.87 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 223,380.00 0.00 -198,380.00 -793.52 R85 Other Non-Operating Revenue 25,000.00 223,380.00 0.00 -198,380.00 -793.52 10-100-490193 Trsfr From Grant Fund 0.00 0.00 0.00 0.00 0.00 10-100-490240 Trsfr From Lodging Tax 23,800.00 19,610.24 0.00 4,189.76 17.60 10-100-490260 Trans from Firemen's Spec Rev 0.00 0.00 0.00 0.00 0.00 10-100-490280 Trnf From Stoneridge Tdd 0.00 0.00 0.00 0.00 0.00 10-100-490320 Trans from Cap Proj-Street&PF 0.00 0.00 0.00 0.00 0.00 10-100-490353 Transfer From Cit 'e'0.00 0.00 0.00 0.00 0.00 10-100-490600 Transfer from Water Fund 0.00 0.00 0.00 0.00 0.00 10-100-490620 Transfer from Parking Fund 0.00 0.00 0.00 0.00 0.00 10-100-490630 Tran from Self-Funded Hlth Ins 48,400.00 48,400.00 0.00 0.00 0.00 R90 Transfers In 72,200.00 68,010.24 0.00 4,189.76 5.80 10-100-495995 Transfer From(to) Surplus 989,837.07 0.00 0.00 989,837.07 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 989,837.07 0.00 0.00 989,837.07 100.00 100 Revenue 31,109,006.66 24,329,600.17 0.00 6,779,406.49 21.79 149 Entitlement Grant 10-149-430010 Federal Grants 480,195.44 171,053.28 0.00 309,142.16 64.38 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 480,195.44 171,053.28 0.00 309,142.16 64.38 149 Entitlement Grant 480,195.44 171,053.28 0.00 309,142.16 64.38 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 300 Police Department 10-300-430010 Federal Grants 26,395.20 19,333.35 0.00 7,061.85 26.75 10-300-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-300-430040 Local Grants 13,000.00 13,000.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 46,809.36 29,592.41 0.00 17,216.95 36.78 R50 Intergovernmental 86,204.56 61,925.76 0.00 24,278.80 28.16 300 Police Department 86,204.56 61,925.76 0.00 24,278.80 28.16 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 189,537.10 189,537.10 0.00 0.00 0.00 R50 Intergovernmental 189,537.10 189,537.10 0.00 0.00 0.00 310 School Resource Officer 189,537.10 189,537.10 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 52,417.70 14,008.72 0.00 38,408.98 73.27 10-320-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-320-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-320-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-320-430074 Overtime Reimb 0.00 13,651.77 0.00 -13,651.77 0.00 R50 Intergovernmental 52,417.70 27,660.49 0.00 24,757.21 47.23 320 M.U.S.T.A.N.G.52,417.70 27,660.49 0.00 24,757.21 47.23 400 Fire Department 10-400-430010 Federal Grant 0.00 0.00 0.00 0.00 0.00 10-400-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 0.00 0.00 0.00 0.00 400 Fire Department 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-430040 Local Grants 25,000.00 0.00 0.00 25,000.00 100.00 R50 Intergovernmental 25,000.00 0.00 0.00 25,000.00 100.00 520 Plan & Protect Svcs-Admin 25,000.00 0.00 0.00 25,000.00 100.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 282,170.93 104,305.39 0.00 177,865.54 63.03 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 14,311.96 5,580.65 0.00 8,731.31 61.01 R50 Intergovernmental 296,482.89 109,886.04 0.00 186,596.85 62.94 522 Plan & Protect Svcs-MPO 296,482.89 109,886.04 0.00 186,596.85 62.94 530 Plan & Protect Svc-RedevGrant GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-430010 Federal Grants 90,597.29 33,346.54 0.00 57,250.75 63.19 10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-530-430040 Local Grants 74,622.50 66,543.75 0.00 8,078.75 10.83 R50 Intergovernmental 165,219.79 99,890.29 0.00 65,329.50 39.54 530 Plan & Protect Svc-RedevGrant 165,219.79 99,890.29 0.00 65,329.50 39.54 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 978,295.67 111,667.33 0.00 866,628.34 88.59 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 12,500.00 39,691.06 0.00 -27,191.06 -217.53 R50 Intergovernmental 990,795.67 151,358.39 0.00 839,437.28 84.72 990 Capital Projects 990,795.67 151,358.39 0.00 839,437.28 84.72 Revenue Revenue 33,394,859.81 25,140,911.52 0.00 8,253,948.29 24.72 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 54,225.00 0.00 10,575.00 16.32 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 4,148.71 0.00 808.49 16.31 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 37.47 37.47 0.00 0.00 0.00 E05 Personnel Services 69,794.67 58,411.18 0.00 11,383.49 16.31 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 12.14 0.00 87.86 87.86 10-110-512010 Printing 500.00 79.55 0.00 420.45 84.09 10-110-512020 Copies 200.00 10.02 0.00 189.98 94.99 10-110-513010 Office Supplies 100.00 63.20 0.00 36.80 36.80 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 900.00 164.91 0.00 735.09 81.68 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 410.37 0.00 1,089.63 72.64 10-110-520030 Dues And Publications 5,000.00 4,707.90 0.00 292.10 5.84 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,400.00 200.00 0.00 1,200.00 85.71 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 8,000.00 5,318.27 0.00 2,681.73 33.52 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 55.35 10.83 258.82 79.64 E25 Repairs & Maintenance 325.00 55.35 10.83 258.82 79.64 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 79,019.67 63,949.71 10.83 15,059.13 19.06 120 City Clerk 10-120-501020 Salaries 66,736.49 54,187.60 0.00 12,548.89 18.80 10-120-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 5,105.34 3,937.25 0.00 1,168.09 22.88 10-120-502020 Group Health Insurance 12,917.75 11,200.61 0.00 1,717.14 13.29 10-120-502030 Retirement 10,355.24 8,372.55 0.00 1,982.69 19.15 10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00 10-120-502050 Life Insurance 113.46 98.55 0.00 14.91 13.14 10-120-502060 Long Term Disability 187.25 168.51 0.00 18.74 10.01 10-120-502070 Employee Assistance Prgm 33.84 24.00 0.00 9.84 29.08 E05 Personnel Services 95,482.94 78,022.64 0.00 17,460.30 18.29 10-120-511020 Postage 200.00 73.84 0.00 126.16 63.08 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 135.02 0.00 164.98 54.99 10-120-513010 Office Supplies 500.00 43.32 0.00 456.68 91.34 E10 Materials & Supplies 1,000.00 252.18 0.00 747.82 74.78 10-120-520030 Dues And Publications 275.00 225.00 0.00 50.00 18.18 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 101.00 0.00 899.00 89.90 10-120-522020 Professional Services 500.00 255.00 0.00 245.00 49.00 10-120-529030 Election Expense 62,500.00 40,552.00 0.00 21,948.00 35.12 E15 Contractual Services 64,275.00 41,133.00 0.00 23,142.00 36.00 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 252.85 10.83 261.32 49.77 E25 Repairs & Maintenance 525.00 252.85 10.83 261.32 49.77 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 161,282.94 119,660.67 10.83 41,611.44 25.80 140 City Administrator 10-140-501020 Salaries 215,152.67 173,221.71 0.00 41,930.96 19.49 10-140-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-140-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,985.50 11,405.69 0.00 5,579.81 32.85 10-140-502020 Group Health Insurance 18,812.19 14,058.70 0.00 4,753.49 25.27 10-140-502030 Retirement 33,257.84 25,473.08 0.00 7,784.76 23.41 10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00 10-140-502050 Life Insurance 354.72 131.42 0.00 223.30 62.95 10-140-502060 Long Term Disability 372.34 304.80 0.00 67.54 18.14 10-140-502070 Employee Assistance Prgm 50.92 36.12 0.00 14.80 29.07 E05 Personnel Services 285,071.50 224,716.84 0.00 60,354.66 21.17 10-140-511010 Advertising 1,000.00 634.25 0.00 365.75 36.58 10-140-511020 Postage 250.00 47.26 0.00 202.74 81.10 10-140-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-140-512020 Copies 250.00 107.37 0.00 142.63 57.05 10-140-513010 Office Supplies 855.00 184.61 172.44 497.95 58.24 10-140-517010 Operational Supplies 1,200.00 574.03 0.00 625.97 52.16 E10 Materials & Supplies 3,755.00 1,547.52 172.44 2,035.04 54.20 10-140-520030 Dues And Publications 1,800.00 458.70 0.00 1,341.30 74.52 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 3,400.00 1,871.77 0.00 1,528.23 44.95 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 800.00 328.66 0.00 471.34 58.92 E15 Contractual Services 6,000.00 2,659.13 0.00 3,340.87 55.68 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 475.00 55.40 10.83 408.77 86.06 E25 Repairs & Maintenance 475.00 55.40 10.83 408.77 86.06 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 295,301.50 228,978.89 183.27 66,139.34 22.40 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 149 Entitlement Grant 10-149-501020 Salaries 19,177.42 12,502.00 0.00 6,675.42 34.81 10-149-501050 Parttime(wo Benefits)20,000.00 8,666.25 0.00 11,333.75 56.67 10-149-502010 Social Security 2,997.07 1,606.05 0.00 1,391.02 46.41 10-149-502020 Group Health Insurance 3,089.76 2,338.09 0.00 751.67 24.33 10-149-502030 Retirement 2,958.93 1,975.29 0.00 983.64 33.24 10-149-502040 Workers Compensation 30.00 0.00 0.00 30.00 100.00 10-149-502050 Life Insurance 32.56 23.18 0.00 9.38 28.81 10-149-502060 Long Term Disability 53.00 38.80 0.00 14.20 26.79 10-149-502070 Employee Assistance Program 12.73 9.03 0.00 3.70 29.07 E05 Personnel Services 48,351.47 27,158.69 0.00 21,192.78 43.83 10-149-511010 Advertising 1,500.00 504.43 0.00 995.57 66.37 10-149-511020 Postage 500.00 120.64 0.00 379.36 75.87 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 141.34 0.00 858.66 85.87 10-149-517010 Operational Supplies 525.00 0.00 0.00 525.00 100.00 E10 Materials & Supplies 3,525.00 766.41 0.00 2,758.59 78.26 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 864.99 0.00 1,135.01 56.75 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab-Code Deficiency 46,853.20 7,414.25 0.00 39,438.95 84.18 10-149-528012 Housing Rehab-Energy Efficienc 40,198.00 24,538.00 0.00 15,660.00 38.96 10-149-528020 Housing Assistance 48,182.00 48,182.00 0.00 0.00 0.00 10-149-528030 Public Improvement 138,660.59 0.00 0.00 138,660.59 100.00 10-149-528040 Neighborhood Redevelopmnt 54,476.25 12,885.00 0.00 41,591.25 76.35 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 5,816.00 783.00 0.00 5,033.00 86.54 10-149-528080 Homeless Objectives 38,042.13 16,709.19 0.00 21,332.94 56.08 E15 Contractual Services 374,228.17 111,376.43 0.00 262,851.74 70.24 10-149-547020 Maintenance Agreements 375.00 194.97 49.71 130.32 34.75 E25 Repairs & Maintenance 375.00 194.97 49.71 130.32 34.75 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 53,715.80 51,806.10 0.00 1,909.70 3.56 E75 Capital Projects 53,715.80 51,806.10 0.00 1,909.70 3.56 149 Entitlement Grant 480,195.44 191,302.60 49.71 288,843.13 60.15 150 City Counselor 10-150-501020 Salaries 226,073.12 200,345.60 0.00 25,727.52 11.38 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,294.59 14,304.55 0.00 2,990.04 17.29 10-150-502020 Group Health Insurance 28,871.82 28,543.03 0.00 328.79 1.14 10-150-502030 Retirement 35,244.61 27,871.82 0.00 7,372.79 20.92 10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00 10-150-502050 Life Insurance 383.13 331.57 0.00 51.56 13.46 10-150-502060 Long Term Disability 577.76 519.53 0.00 58.23 10.08 10-150-502070 Employee Assistance Prgm 85.03 60.30 0.00 24.73 29.08 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 308,690.82 272,137.16 0.00 36,553.66 11.84 10-150-511010 Advertising 1,000.00 1,425.73 0.00 -425.73 -42.57 10-150-511020 Postage 600.00 411.13 0.00 188.87 31.48 10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-150-512020 Copies 500.00 53.79 0.00 446.21 89.24 10-150-513010 Office Supplies 1,800.00 742.00 0.00 1,058.00 58.78 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,050.00 2,632.65 0.00 1,417.35 35.00 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 10,944.91 6,226.79 0.00 4,718.12 43.11 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 1,879.42 0.00 3,120.58 62.41 10-150-520080 Tuition Reimbursement 3,420.00 0.00 0.00 3,420.00 100.00 10-150-521010 Malpractice Insurance 2,500.00 960.00 0.00 1,540.00 61.60 10-150-522020 Professional Services 11,158.74 9,157.59 0.00 2,001.15 17.93 10-150-525030 Court Cost & Witness Fees 75.00 0.00 0.00 75.00 100.00 E15 Contractual Services 33,098.65 18,223.80 0.00 14,874.85 44.94 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 55.09 31.48 23.61 0.00 0.00 10-150-547020 Maintenance Agreements 800.00 489.80 10.83 299.37 37.42 E25 Repairs & Maintenance 855.09 521.28 34.44 299.37 35.01 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 346,694.56 293,514.89 34.44 53,145.23 15.33 160 Municipal Court 10-160-501010 Salary-elected Officals 59,999.88 49,999.90 0.00 9,999.98 16.67 10-160-501020 Salaries 101,637.42 83,838.21 0.00 17,799.21 17.51 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-501050 Parttime(wo Benefits)16,482.07 11,509.25 0.00 4,972.82 30.17 10-160-501090 Overtime 1,074.42 1,074.42 0.00 0.00 0.00 10-160-501095 Overtime Straight Pay 12.50 12.50 0.00 0.00 0.00 10-160-502010 Social Security 13,709.28 10,878.66 0.00 2,830.62 20.65 10-160-502020 Group Health Insurance 12,896.84 15,345.86 0.00 -2,449.02 -18.99 10-160-502030 Retirement 15,806.39 13,086.79 0.00 2,719.60 17.21 10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00 10-160-502050 Life Insurance 171.72 152.59 0.00 19.13 11.14 10-160-502060 Long Term Disability 284.44 259.14 0.00 25.30 8.89 10-160-502070 Employee Assistance Prgm 59.32 42.09 0.00 17.23 29.05 E05 Personnel Services 222,240.70 186,305.83 0.00 35,934.87 16.17 10-160-511010 Advertising 154.20 154.20 0.00 0.00 0.00 10-160-511020 Postage 3,645.80 2,763.80 0.00 882.00 24.19 10-160-512010 Printing 1,090.00 393.95 0.00 696.05 63.86 10-160-512020 Copies 500.00 302.14 0.00 197.86 39.57 10-160-513010 Office Supplies 2,500.00 1,319.41 0.00 1,180.59 47.22 E10 Materials & Supplies 7,890.00 4,933.50 0.00 2,956.50 37.47 10-160-520025 Security 10,500.00 7,539.12 0.00 2,960.88 28.20 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 617.68 0.00 1,882.32 75.29 10-160-522020 Professional Services 3,000.00 2,841.64 0.00 158.36 5.28 10-160-525005 Appointed Counsel 5,000.00 1,035.00 0.00 3,965.00 79.30 10-160-525010 Care Of Prisoners 500.00 0.00 0.00 500.00 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 21,990.00 12,133.44 0.00 9,856.56 44.82 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 950.00 647.96 10.83 291.21 30.65 E25 Repairs & Maintenance 950.00 647.96 10.83 291.21 30.65 10-160-572020 Purchase Of Equipment 5,563.24 0.00 5,563.24 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 5,563.24 0.00 5,563.24 0.00 0.00 160 Municipal Court 258,633.94 204,020.73 5,574.07 49,039.14 18.96 170 Human Resources 10-170-501020 Salaries 200,607.28 151,298.98 0.00 49,308.30 24.58 10-170-501050 Parttime(wo Benefits)9,600.00 9,748.40 0.00 -148.40 -1.55 10-170-501090 Overtime 300.00 196.83 0.00 103.17 34.39 10-170-502010 Social Security 12,401.21 12,315.77 0.00 85.44 0.69 10-170-502020 Group Health Insurance 12,513.01 14,189.26 0.00 -1,676.25 -13.40 10-170-502030 Retirement 23,811.75 20,711.66 0.00 3,100.09 13.02 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00 10-170-502050 Life Insurance 258.75 275.69 0.00 -16.94 -6.55 10-170-502060 Long Term Disability 375.03 422.18 0.00 -47.15 -12.57 10-170-502070 Employee Assistance Prgm 50.92 36.12 0.00 14.80 29.07 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 260,012.48 209,289.42 0.00 50,723.06 19.51 10-170-511010 Advertising 150.00 527.60 0.00 -377.60 -251.73 10-170-511020 Postage 300.00 70.16 0.00 229.84 76.61 10-170-512010 Printing 1,000.00 496.81 0.00 503.19 50.32 10-170-512020 Copies 500.00 552.48 0.00 -52.48 -10.50 10-170-513010 Office Supplies 1,200.00 196.86 0.00 1,003.14 83.60 10-170-517010 Operational Supplies 750.00 551.10 0.00 198.90 26.52 E10 Materials & Supplies 3,900.00 2,395.01 0.00 1,504.99 38.59 10-170-520030 Dues And Publications 1,468.00 574.00 0.00 894.00 60.90 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,942.77 0.00 1,557.23 44.49 10-170-520070 Training And Education 5,220.00 2,054.25 0.00 3,165.75 60.65 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 940.00 440.00 0.00 500.00 53.19 10-170-522020 Professional Services 12,345.00 0.00 6,880.00 5,465.00 44.27 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 23,473.00 5,011.02 6,880.00 11,581.98 49.34 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 475.00 55.40 10.83 408.77 86.06 E25 Repairs & Maintenance 475.00 55.40 10.83 408.77 86.06 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 287,860.48 216,750.85 6,890.83 64,218.80 22.31 180 Finance Department 10-180-501020 Salaries 642,524.07 508,774.67 0.00 133,749.40 20.82 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 16,991.73 0.00 1,912.45 10.12 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 50,599.26 38,384.36 0.00 12,214.90 24.14 10-180-502020 Group Health Insurance 79,918.72 59,306.98 0.00 20,611.74 25.79 10-180-502030 Retirement 99,812.40 61,602.19 0.00 38,210.21 38.28 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00 10-180-502050 Life Insurance 1,091.56 885.97 0.00 205.59 18.83 10-180-502060 Long Term Disability 1,731.47 1,468.52 0.00 262.95 15.19 10-180-502070 Employee Assistance Prgm 330.97 234.75 0.00 96.22 29.07 E05 Personnel Services 895,443.73 688,180.27 0.00 207,263.46 23.15 10-180-511010 Advertising 1,000.00 815.41 0.00 184.59 18.46 10-180-511020 Postage 11,000.00 6,995.43 0.00 4,004.57 36.41 10-180-511021 Mail Machine Cost 2,000.00 1,132.26 0.00 867.74 43.39 10-180-512010 Printing 5,000.00 2,521.19 0.00 2,478.81 49.58 10-180-512020 Copies 3,000.00 1,105.54 0.00 1,894.46 63.15 10-180-512021 Copy Machine Cost 0.00 -651.94 65.00 586.94 0.00 10-180-513010 Office Supplies 4,808.13 2,803.32 0.00 2,004.81 41.70 10-180-517010 Operational Supplies 4,000.00 1,597.55 0.00 2,402.45 60.06 E10 Materials & Supplies 30,808.13 16,318.76 65.00 14,424.37 46.82 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,300.00 1,285.00 0.00 1,015.00 44.13 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 4,108.90 2,453.86 0.00 1,655.04 40.28 10-180-520080 Tuition Reimbursement 6,095.10 0.00 0.00 6,095.10 100.00 10-180-522010 Audit 39,776.00 36,631.20 0.00 3,144.80 7.91 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 320.33 0.00 179.67 35.93 E15 Contractual Services 52,780.00 40,690.39 0.00 12,089.61 22.91 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 0.00 0.00 0.00 0.00 10-180-547020 Maintenance Agreements 900.00 592.56 0.00 307.44 34.16 E25 Repairs & Maintenance 900.00 592.56 0.00 307.44 34.16 10-180-572020 Purchase Of Equipment 2,652.87 3,044.64 0.00 -391.77 -14.77 E70 Capital Purchases 2,652.87 3,044.64 0.00 -391.77 -14.77 180 Finance Department 982,584.73 748,826.62 65.00 233,693.11 23.78 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 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 17,913.64 17,413.64 0.00 500.00 2.79 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 17,913.64 17,413.64 0.00 500.00 2.79 10-185-514010 Gas 14,000.00 6,380.43 0.00 7,619.57 54.43 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 14,000.00 6,380.43 0.00 7,619.57 54.43 10-185-520030 Dues and Publications 0.00 0.00 0.00 0.00 0.00 10-185-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-521010 General Insurance 270,000.00 377,376.17 0.00 -107,376.17 -39.77 10-185-521020 Insurance Deductible 15,000.00 -11,175.64 0.00 26,175.64 174.50 10-185-521030 Self Ins Prop & Casualty 75,000.00 53,889.12 0.00 21,110.88 28.15 10-185-521060 Drugalcohol screening 5,364.00 3,201.00 0.00 2,163.00 40.32 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 -30,000.00 0.00 30,000.00 0.00 10-185-522020 Professional Services 27,083.33 22,916.63 8,333.33 -4,166.63 -15.38 10-185-522025 JCTV 55,000.00 27,500.00 27,500.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 45,750.00 45,795.74 0.00 -45.74 -0.10 10-185-527020 Economic Development 185,000.00 185,000.00 46,250.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 6,356.72 0.00 643.28 9.19 E15 Contractual Services 685,197.33 680,859.74 82,083.33 -77,745.74 -11.35 10-185-531010 Electricity 42,000.00 24,302.45 0.00 17,697.55 42.14 10-185-533010 Natural Gas 6,400.00 3,378.34 0.00 3,021.66 47.21 10-185-535010 Water 7,250.00 4,863.12 0.00 2,386.88 32.92 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 32,543.91 0.00 23,106.09 41.52 10-185-540010 Building & Grounds Maint.80,000.00 26,770.66 -12,359.09 65,588.43 81.99 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,716.00 0.00 284.00 14.20 E25 Repairs & Maintenance 107,000.00 53,486.66 -12,359.09 65,872.43 61.56 10-185-550010 Miscellaneous 7,916.67 2,120.01 0.00 5,796.66 73.22 10-185-550015 Bad Debt Expense 0.00 1,745.34 0.00 -1,745.34 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 50,000.00 29,245.11 29,167.50 -8,412.61 -16.83 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 11,930.00 1,446.67 0.00 10,483.33 87.87 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 15,405.59 0.00 -15,405.59 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 79,846.67 59,962.72 29,167.50 -9,283.55 -11.63 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 55,000.00 0.00 0.00 55,000.00 100.00 E70 Capital Purchases 55,000.00 0.00 0.00 55,000.00 100.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 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,014,607.64 850,647.10 98,891.74 65,068.80 6.41 190 I.T. Department 10-190-501020 Salaries 528,580.84 363,134.85 0.00 165,445.99 31.30 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 500.00 401.01 0.00 98.99 19.80 10-190-501095 Overtime Straight Pay 121.52 121.52 0.00 0.00 0.00 10-190-502010 Social Security 40,436.43 26,179.27 0.00 14,257.16 35.26 10-190-502020 Group Health Insurance 79,475.86 45,879.83 0.00 33,596.03 42.27 10-190-502030 Retirement 82,200.42 33,146.31 0.00 49,054.11 59.68 10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00 10-190-502050 Life Insurance 891.50 617.79 0.00 273.71 30.70 10-190-502060 Long Term Disability 1,448.73 1,039.90 0.00 408.83 28.22 10-190-502070 Employee Assistance Prgm 235.50 166.95 0.00 68.55 29.11 E05 Personnel Services 734,247.91 471,044.54 0.00 263,203.37 35.85 10-190-511010 Advertising 1,861.15 1,861.15 0.00 0.00 0.00 10-190-511020 Postage 100.00 3.36 0.00 96.64 96.64 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 14.28 0.00 85.72 85.72 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 733.11 0.00 266.89 26.69 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 118.67 118.67 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 1,750.00 605.41 172.44 972.15 55.55 E10 Materials & Supplies 4,929.82 3,335.98 172.44 1,421.40 28.83 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 444.60 0.00 55.40 11.08 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 10,400.00 10,101.71 0.00 298.29 2.87 10-190-520080 Tuition Reimbursement 1,548.66 0.00 0.00 1,548.66 100.00 10-190-522020 Professional Services 8,000.00 7,369.04 0.00 630.96 7.89 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 14,561.46 0.00 5,238.54 26.46 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 3,600.00 360.15 0.00 3,239.85 90.00 E15 Contractual Services 43,848.66 32,836.96 0.00 11,011.70 25.11 10-190-534010 Telephone 58,000.00 43,092.51 0.00 14,907.49 25.70 E20 Utilities 58,000.00 43,092.51 0.00 14,907.49 25.70 10-190-545010 Software Licensemaint 142,000.00 87,676.57 1,539.00 52,784.43 37.17 10-190-545020 Citywide Wiringnetwork 3,000.00 1,232.57 0.00 1,767.43 58.91 10-190-547010 Equipment Maintenance 3,000.00 748.59 0.00 2,251.41 75.05 10-190-547020 Maintenance Agreements 24,500.00 4,793.36 0.00 19,706.64 80.44 E25 Repairs & Maintenance 172,500.00 94,451.09 1,539.00 76,509.91 44.35 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,013,526.39 644,761.08 1,711.44 367,053.87 36.22 300 Police Department 10-300-501020 Salaries 4,104,222.87 3,412,312.59 0.00 691,910.28 16.86 10-300-501030 Holiday Pay 127,214.49 100,456.41 0.00 26,758.08 21.03 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 21,439.25 0.00 6,960.75 24.51 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 3,564.00 0.00 1,436.00 28.72 10-300-501090 Overtime 215,728.61 235,107.04 0.00 -19,378.43 -8.98 10-300-501095 Overtime Straight Pay 7,483.25 10,630.44 0.00 -3,147.19 -42.06 10-300-502010 Social Security 330,342.59 273,994.90 0.00 56,347.69 17.06 10-300-502020 Group Health Insurance 720,153.79 594,417.71 0.00 125,736.08 17.46 10-300-502030 Retirement 764,220.57 621,169.06 0.00 143,051.51 18.72 10-300-502040 Workers Compensation 39,409.96 39,409.96 0.00 0.00 0.00 10-300-502050 Life Insurance 6,868.11 6,208.80 0.00 659.31 9.60 10-300-502060 Long Term Disability 11,245.62 10,488.03 0.00 757.59 6.74 10-300-502070 Employee Assistance Prgm 2,278.60 1,616.25 0.00 662.35 29.07 10-300-503010 Awards Program 1,600.00 0.00 0.00 1,600.00 100.00 10-300-503020 Unemployment Compensation 1,000.00 0.00 0.00 1,000.00 100.00 E05 Personnel Services 6,365,168.46 5,330,814.44 0.00 1,034,354.02 16.25 10-300-511010 Advertising 1,350.59 1,349.21 0.00 1.38 0.10 10-300-511020 Postage 1,290.79 1,234.34 0.00 56.45 4.37 10-300-512010 Printing 6,603.48 6,603.48 0.00 0.00 0.00 10-300-512020 Copies 100.00 100.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 2,728.60 2,728.60 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-513010 Office Supplies 13,533.14 13,776.35 0.00 -243.21 -1.80 10-300-514010 Gas 182,500.00 103,626.23 0.00 78,873.77 43.22 10-300-514040 Food 700.00 594.98 0.00 105.02 15.00 10-300-515040 First Aid Supplies 1,000.00 821.65 0.00 178.35 17.84 10-300-516010 Ammunition & Firearms Supplies 23,104.43 20,315.95 3,766.50 -978.02 -4.23 10-300-516020 Dare Program 16,500.00 8,349.10 7,792.27 358.63 2.17 10-300-516030 Special Investigation 2,500.00 0.00 0.00 2,500.00 100.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 3,300.00 2,946.61 0.00 353.39 10.71 10-300-517010 Operational Supplies 43,888.97 34,715.58 -22,800.00 31,973.39 72.85 E10 Materials & Supplies 299,100.00 197,162.08 -11,241.23 113,179.15 37.84 10-300-520030 Dues And Publications 4,071.96 4,071.96 0.00 0.00 0.00 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 50,000.00 34,170.06 0.00 15,829.94 31.66 10-300-520080 Tuition Reimbursement 7,000.00 7,350.00 0.00 -350.00 -5.00 10-300-520090 Recruitment 2,694.80 2,694.80 0.00 0.00 0.00 10-300-521040 Medical Claimsservices 5,000.00 4,292.35 -246.00 953.65 19.07 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 12,094.49 12,094.49 0.00 0.00 0.00 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 21,765.68 0.00 -21,765.68 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 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 2,200.00 569.44 0.00 1,630.56 74.12 E15 Contractual Services 90,061.25 94,008.78 -246.00 -3,701.53 -4.11 10-300-531010 Electricity 68,250.00 43,376.56 0.00 24,873.44 36.44 10-300-533010 Natural Gas 12,000.00 3,249.64 0.00 8,750.36 72.92 10-300-534010 Telephone 19,500.00 16,442.41 0.00 3,057.59 15.68 10-300-535010 Water 4,500.00 2,973.91 0.00 1,526.09 33.91 E20 Utilities 104,250.00 66,042.52 0.00 38,207.48 36.65 10-300-540010 Building & Grounds Maint.40,000.00 34,313.75 5,359.00 327.25 0.82 10-300-541030 Vehicle Wash 12,000.00 8,801.84 0.00 3,198.16 26.65 10-300-544010 K-9 Operations 40,390.47 40,390.47 0.00 0.00 0.00 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 21,300.00 9,365.87 0.00 11,934.13 56.03 10-300-545010 Software Licensemaint 40,360.00 40,360.00 0.00 0.00 0.00 10-300-546010 Clothing Expense 43,000.00 13,037.76 -10,715.51 40,677.75 94.60 10-300-546020 Uniform Cleaning 25,000.00 16,958.80 0.00 8,041.20 32.16 10-300-547010 Equipment Maintenance 9,350.00 8,836.93 0.00 513.07 5.49 10-300-547020 Maintenance Agreements 25,579.45 16,978.40 4,118.50 4,482.55 17.52 10-300-547030 Radio Maintenance 10,010.83 10,010.83 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 266,990.75 199,054.65 -1,238.01 69,174.11 25.91 10-300-572010 Purchase Of Vehicles 249,327.22 247,804.00 0.00 1,523.22 0.61 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 28,435.00 12,993.19 0.00 15,441.81 54.31 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 10,960.20 10,960.00 0.00 0.20 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 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 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 288,722.42 271,757.19 0.00 16,965.23 5.88 300 Police Department 7,414,292.88 6,158,839.66 -12,725.24 1,268,178.46 17.10 310 School Resource Officer 10-310-501020 Salaries 230,497.20 191,759.22 0.00 38,737.98 16.81 10-310-501030 Holiday Pay 8,692.20 2,477.55 0.00 6,214.65 71.50 10-310-501090 Overtime 16,967.83 19,538.29 0.00 -2,570.46 -15.15 10-310-501095 Overtime Straight Pay 568.17 647.22 0.00 -79.05 -13.91 10-310-502010 Social Security 19,518.55 14,878.67 0.00 4,639.88 23.77 10-310-502020 Group Health Insurance 54,231.77 46,708.23 0.00 7,523.54 13.87 10-310-502030 Retirement 44,896.12 37,366.27 0.00 7,529.85 16.77 10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00 10-310-502050 Life Insurance 390.70 350.70 0.00 40.00 10.24 10-310-502060 Long Term Disability 645.54 598.49 0.00 47.05 7.29 10-310-502070 Employee Assistance Prgm 127.30 90.30 0.00 37.00 29.07 E05 Personnel Services 379,074.20 316,953.76 0.00 62,120.44 16.39 10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 379,074.20 316,953.76 0.00 62,120.44 16.39 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 89,351.33 74,213.89 0.00 15,137.44 16.94 10-320-501030 Holiday Pay 3,228.90 659.62 0.00 2,569.28 79.57 10-320-501090 Overtime 6,897.00 24,712.76 0.00 -17,815.76 -258.31 10-320-501095 Overtime Straight Pay 0.00 225.48 0.00 -225.48 0.00 10-320-502010 Social Security 7,610.01 7,108.80 0.00 501.21 6.59 10-320-502020 Group Health Insurance 18,291.99 14,939.68 0.00 3,352.31 18.33 10-320-502030 Retirement 17,386.55 17,446.08 0.00 -59.53 -0.34 10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00 10-320-502050 Life Insurance 149.08 133.77 0.00 15.31 10.27 10-320-502060 Long Term Disability 244.80 226.98 0.00 17.82 7.28 10-320-502070 Employee Assistance Prgm 50.92 36.12 0.00 14.80 29.07 E05 Personnel Services 144,229.04 140,721.64 0.00 3,507.40 2.43 10-320-514010 Gas 5,000.00 3,950.31 0.00 1,049.69 20.99 10-320-516040 Investigations 14,350.00 7,273.89 0.00 7,076.11 49.31 10-320-517010 Operational Supplies 8,170.40 1,617.34 0.00 6,553.06 80.20 E10 Materials & Supplies 27,520.40 12,841.54 0.00 14,678.86 53.34 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 17,450.58 10,000.00 0.00 7,450.58 42.70 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,450.58 10,000.00 0.00 7,450.58 42.70 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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.189,200.02 163,563.18 0.00 25,636.84 13.55 330 Animal Control 10-330-501020 Salaries 326,374.56 266,087.43 0.00 60,287.13 18.47 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,308.00 3,548.03 0.00 759.97 17.64 10-330-501090 Overtime 1,709.00 1,156.49 0.00 552.51 32.33 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,466.20 19,567.23 0.00 5,898.97 23.16 10-330-502020 Group Health Insurance 57,755.93 49,953.02 0.00 7,802.91 13.51 10-330-502030 Retirement 51,459.27 38,352.02 0.00 13,107.25 25.47 10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00 10-330-502050 Life Insurance 431.83 486.35 0.00 -54.52 -12.63 10-330-502060 Long Term Disability 709.68 827.85 0.00 -118.17 -16.65 10-330-502070 Employee Assistance Prgm 178.21 126.42 0.00 51.79 29.06 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 471,387.45 382,599.61 0.00 88,787.84 18.84 10-330-511010 Advertising 136.90 136.90 0.00 0.00 0.00 10-330-511020 Postage 100.00 61.47 0.00 38.53 38.53 10-330-512010 Printing 1,348.10 1,262.50 0.00 85.60 6.35 10-330-512020 Copies 1.00 0.00 0.00 1.00 100.00 10-330-513010 Office Supplies 1,900.00 207.70 0.00 1,692.30 89.07 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 60.24 0.00 179.76 74.90 10-330-515040 First Aid Supplies 700.00 300.37 0.00 399.63 57.09 10-330-517010 Operational Supplies 9,200.00 8,843.86 0.00 356.14 3.87 E10 Materials & Supplies 13,626.00 10,873.04 0.00 2,752.96 20.20 10-330-520030 Dues And Publications 1,150.00 926.00 0.00 224.00 19.48 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,950.00 1,797.99 0.00 152.01 7.80 10-330-521040 Medical Claimsservices 464.00 0.00 0.00 464.00 100.00 10-330-522020 Professional Services 5,200.00 3,455.10 0.00 1,744.90 33.56 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 461.28 65.65 0.00 395.63 85.77 10-330-529050 Spay & Neuter Program 2,933.84 2,933.84 0.00 0.00 0.00 10-330-529060 Special Sn Program 0.00 0.00 0.00 0.00 0.00 10-330-529065 Adoption Voucher Program 0.00 0.00 0.00 0.00 0.00 10-330-529067 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-330-529068 Animal Shelter Donations 4,995.00 6,125.40 138.00 -1,268.40 -25.39 E15 Contractual Services 17,154.12 15,303.98 138.00 1,712.14 9.98 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-531010 Electricity 21,538.00 16,119.19 0.00 5,418.81 25.16 10-330-533010 Natural Gas 15,300.00 13,598.30 0.00 1,701.70 11.12 10-330-534010 Telephone 282.00 228.74 0.00 53.26 18.89 10-330-535010 Water 4,300.00 2,936.81 0.00 1,363.19 31.70 E20 Utilities 41,420.00 32,883.04 0.00 8,536.96 20.61 10-330-540010 Building & Grounds Maint.7,900.00 8,104.89 163.89 -368.78 -4.67 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 35,000.00 40,464.02 -20,758.11 15,294.09 43.70 10-330-544050 Animal Food 6,204.88 6,204.88 0.00 0.00 0.00 10-330-545010 Software Licensemaint 1,650.00 1,500.00 0.00 150.00 9.09 10-330-546010 Clothing Expense 2,500.00 944.19 0.00 1,555.81 62.23 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 900.00 485.28 0.00 414.72 46.08 10-330-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 320.00 0.00 0.00 320.00 100.00 E25 Repairs & Maintenance 55,014.88 58,243.26 -20,594.22 17,365.84 31.57 10-330-572010 Purchase of Vehicles 0.00 0.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 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 859.00 0.00 0.00 859.00 100.00 E75 Capital Projects 859.00 0.00 0.00 859.00 100.00 330 Animal Control 599,461.45 499,902.93 -20,456.22 120,014.74 20.02 390 9-1-1 Police 10-390-501020 Salaries 855,819.59 650,685.87 0.00 205,133.72 23.97 10-390-501030 Holiday Pay 22,236.22 23,510.13 0.00 -1,273.91 -5.73 10-390-501050 Parttime(wo Benefits)2,600.00 0.00 0.00 2,600.00 100.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 22,873.46 30,823.16 0.00 -7,949.70 -34.76 10-390-501095 Overtime Straight Pay 256.05 346.88 0.00 -90.83 -35.47 10-390-502010 Social Security 69,139.58 50,916.97 0.00 18,222.61 26.36 10-390-502020 Group Health Insurance 181,388.02 124,810.92 0.00 56,577.10 31.19 10-390-502030 Retirement 135,396.52 100,594.98 0.00 34,801.54 25.70 10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00 10-390-502050 Life Insurance 1,450.99 1,207.70 0.00 243.29 16.77 10-390-502060 Long Term Disability 2,385.09 2,047.48 0.00 337.61 14.16 10-390-502070 Employee Assistance Prgm 591.93 419.85 0.00 172.08 29.07 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,294,618.58 985,845.07 0.00 308,773.51 23.85 10-390-511010 Advertising 233.15 233.15 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,536.29 1,519.67 0.00 3,016.62 66.50 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 4,769.44 1,752.82 0.00 3,016.62 63.25 10-390-520030 Dues And Publications 477.00 276.00 0.00 201.00 42.14 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,453.56 5,453.56 0.00 0.00 0.00 10-390-522020 Professional Services 2,111.15 1,783.36 340.00 -12.21 -0.58 10-390-523010 Equipment Rentlease 97,088.85 84,079.62 3,240.00 9,769.23 10.06 E15 Contractual Services 105,130.56 91,592.54 3,580.00 9,958.02 9.47 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-545010 Software Licensemaint 23,000.00 23,000.00 0.00 0.00 0.00 10-390-546010 Clothing Expense 6,000.00 631.25 0.00 5,368.75 89.48 10-390-546020 Uniform Cleaning 1,671.00 1,908.00 0.00 -237.00 -14.18 10-390-547010 Equipment Maintenance 2,596.00 1,504.18 0.00 1,091.82 42.06 10-390-547020 Maintenance Agreements 36,733.00 11,210.80 912.58 24,609.62 67.00 10-390-547030 Radio Maintenance 5,000.00 4,296.45 0.00 703.55 14.07 E25 Repairs & Maintenance 75,000.00 42,550.68 912.58 31,536.74 42.05 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,479,518.58 1,121,741.11 4,492.58 353,284.89 23.88 400 Fire Department 10-400-501020 Salaries 3,604,310.01 2,915,990.52 0.00 688,319.49 19.10 10-400-501030 Holiday Pay 270,620.22 231,892.64 0.00 38,727.58 14.31 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,170.00 23,400.00 0.00 4,770.00 16.93 10-400-501090 Overtime 53,000.00 45,042.07 0.00 7,957.93 15.01 10-400-501095 Overtime Straight Pay 36,419.00 30,389.27 0.00 6,029.73 16.56 10-400-502010 Social Security 55,654.76 45,645.39 0.00 10,009.37 17.98 10-400-502020 Group Health Insurance 641,786.04 509,039.63 0.00 132,746.41 20.68 10-400-502030 Retirement 1,671,301.18 1,311,191.24 0.00 360,109.94 21.55 10-400-502040 Workers Compensation 79,145.55 79,145.55 0.00 0.00 0.00 10-400-502050 Life Insurance 6,154.44 5,252.51 0.00 901.93 14.65 10-400-502060 Long Term Disability 10,055.08 8,945.48 0.00 1,109.60 11.04 10-400-502070 Employee Assistance Prgm 1,883.98 1,336.35 0.00 547.63 29.07 10-400-503010 Awards Program 1,500.00 881.66 0.00 618.34 41.22 E05 Personnel Services 6,460,000.26 5,208,152.31 0.00 1,251,847.95 19.38 10-400-511010 Advertising 850.00 352.00 0.00 498.00 58.59 10-400-511020 Postage 213.25 216.00 0.00 -2.75 -1.29 10-400-512010 Printing 1,250.00 1,011.00 0.00 239.00 19.12 10-400-512020 Copies 11.95 0.04 0.00 11.91 99.67 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 1,534.06 0.00 265.94 14.77 10-400-514010 Gas 44,000.00 31,449.98 0.00 12,550.02 28.52 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-514020 Chemicals 1,024.80 1,024.80 0.00 0.00 0.00 10-400-514030 Small Tools 3,915.12 3,915.10 0.00 0.02 0.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 534.88 290.68 0.00 244.20 45.66 10-400-517010 Operational Supplies 10,000.00 8,492.41 119.80 1,387.79 13.88 E10 Materials & Supplies 63,600.00 48,286.07 119.80 15,194.13 23.89 10-400-520030 Dues And Publications 1,677.20 1,677.20 0.00 0.00 0.00 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 14,000.00 8,772.99 0.00 5,227.01 37.34 10-400-520080 Tuition Reimbursement 5,880.00 5,880.00 0.00 0.00 0.00 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 5,045.50 5,045.50 0.00 0.00 0.00 10-400-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-400-523010 Equipment Rentlease 315.72 315.72 0.00 0.00 0.00 10-400-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-400-529010 Special Events 6,670.00 6,669.95 0.00 0.05 0.00 10-400-529040 INACTIVE - Fire Hydrants 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 33,588.42 28,361.36 0.00 5,227.06 15.56 10-400-531010 Electricity 33,000.00 25,551.89 0.00 7,448.11 22.57 10-400-533010 Natural Gas 16,340.00 11,686.58 0.00 4,653.42 28.48 10-400-534010 Telephone 18,000.00 14,184.53 0.00 3,815.47 21.20 10-400-535010 Water 13,000.00 9,385.19 0.00 3,614.81 27.81 E20 Utilities 80,340.00 60,808.19 0.00 19,531.81 24.31 10-400-540010 Building & Grounds Maint.319,672.00 46,862.18 143,916.06 128,893.76 40.32 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 52,538.00 53,188.47 -59,783.33 59,132.86 112.55 10-400-546020 Uniform Cleaning 333.28 21.00 0.00 312.28 93.70 10-400-547010 Equipment Maintenance 16,299.05 11,641.33 0.00 4,657.72 28.58 10-400-547020 Maintenance Agreements 21,215.25 14,903.66 -17,017.42 23,329.01 109.96 10-400-547030 Radio Maintenance 7,000.00 6,781.96 0.00 218.04 3.11 E25 Repairs & Maintenance 417,057.58 133,398.60 67,115.31 216,543.67 51.92 10-400-572010 Purchase Of Vehicles 42,000.00 41,988.82 0.00 11.18 0.03 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 42,000.00 41,988.82 0.00 11.18 0.03 400 Fire Department 7,096,586.26 5,520,995.35 67,235.11 1,508,355.80 21.25 401 Fire Museum 10-401-531010 Electricity 445.25 382.80 0.00 62.45 14.03 10-401-533010 Natural Gas 379.25 289.41 0.00 89.84 23.69 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-401-535010 Water 356.10 262.21 0.00 93.89 26.37 E20 Utilities 1,180.60 934.42 0.00 246.18 20.85 10-401-540010 Building & Grounds Maint.129.40 129.40 0.00 0.00 0.00 E25 Repairs & Maintenance 129.40 129.40 0.00 0.00 0.00 401 Fire Museum 1,310.00 1,063.82 0.00 246.18 18.79 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 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 -256.68 0.00 256.68 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 -256.68 0.00 256.68 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 500 Public Works 0.00 -256.68 0.00 256.68 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 213,322.64 177,104.48 0.00 36,218.16 16.98 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,319.18 13,083.30 0.00 3,235.88 19.83 10-520-502020 Group Health Insurance 29,505.81 24,092.65 0.00 5,413.16 18.35 10-520-502030 Retirement 33,136.18 27,413.84 0.00 5,722.34 17.27 10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00 10-520-502050 Life Insurance 361.57 324.58 0.00 36.99 10.23 10-520-502060 Long Term Disability 548.60 508.70 0.00 39.90 7.27 10-520-502070 Employee Assistance Prgm 101.84 72.24 0.00 29.60 29.07 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 293,419.17 242,723.14 0.00 50,696.03 17.28 10-520-511010 Advertising 250.00 196.35 0.00 53.65 21.46 10-520-511020 Postage 200.00 31.47 0.00 168.53 84.27 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 800.00 730.95 0.00 69.05 8.63 10-520-514010 Gas 9,000.00 5,999.74 0.00 3,000.26 33.34 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 400.00 185.06 0.00 214.94 53.74 E10 Materials & Supplies 10,650.00 7,143.57 0.00 3,506.43 32.92 10-520-520030 Dues And Publications 500.00 173.99 0.00 326.01 65.20 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 531.00 0.00 969.00 64.60 10-520-522020 Professional Services 30,000.00 21,142.81 2,487.99 6,369.20 21.23 E15 Contractual Services 32,000.00 21,847.80 2,487.99 7,664.21 23.95 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 900.00 801.64 19.83 78.53 8.73 E25 Repairs & Maintenance 900.00 801.64 19.83 78.53 8.73 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 336,969.17 272,516.15 2,507.82 61,945.20 18.38 521 Plan & Protect Svcs-Planning GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-501020 Salaries 59,631.84 49,519.70 0.00 10,112.14 16.96 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)16,000.00 9,936.00 0.00 6,064.00 37.90 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,785.84 4,446.18 0.00 1,339.66 23.15 10-521-502020 Group Health Insurance 6,179.51 7,859.65 0.00 -1,680.14 -27.19 10-521-502030 Retirement 9,279.63 7,681.99 0.00 1,597.64 17.22 10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00 10-521-502050 Life Insurance 101.10 90.86 0.00 10.24 10.13 10-521-502060 Long Term Disability 165.97 154.04 0.00 11.93 7.19 10-521-502070 Employee Assistance Prgm 25.46 18.06 0.00 7.40 29.07 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 97,209.62 79,746.75 0.00 17,462.87 17.96 10-521-511010 Advertising 4,000.00 3,178.50 0.00 821.50 20.54 10-521-511020 Postage 1,000.00 497.37 0.00 502.63 50.26 10-521-512010 Printing 100.00 38.00 0.00 62.00 62.00 10-521-512020 Copies 10.00 2.44 0.00 7.56 75.60 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 369.89 0.00 630.11 63.01 10-521-514040 Food 100.00 16.67 0.00 83.33 83.33 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 962.48 0.00 1,037.52 51.88 E10 Materials & Supplies 8,210.00 5,065.35 0.00 3,144.65 38.30 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 2,500.00 0.00 0.00 2,500.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,000.00 14,743.70 0.00 3,256.30 18.09 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,100.00 1,027.77 74.20 -1.97 -0.18 E25 Repairs & Maintenance 1,100.00 1,027.77 74.20 -1.97 -0.18 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 124,519.62 100,583.57 74.20 23,861.85 19.16 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 142,737.58 110,883.11 0.00 31,854.47 22.32 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 11,975.12 8,414.79 0.00 3,560.33 29.73 10-522-502020 Group Health Insurance 18,608.84 12,494.80 0.00 6,114.04 32.86 10-522-502030 Retirement 24,448.54 17,235.15 0.00 7,213.39 29.50 10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00 10-522-502050 Life Insurance 255.33 207.50 0.00 47.83 18.73 10-522-502060 Long Term Disability 423.50 354.87 0.00 68.63 16.21 10-522-502070 Employee Assistance Prgm 76.38 54.18 0.00 22.20 29.07 E05 Personnel Services 198,588.66 149,707.77 0.00 48,880.89 24.61 10-522-511010 Advertising 3,650.00 1,090.45 0.00 2,559.55 70.12 10-522-511020 Postage 300.00 50.18 0.00 249.82 83.27 10-522-512010 Printing 860.80 71.00 0.00 789.80 91.75 10-522-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-522-513010 Office Supplies 1,000.00 929.63 0.00 70.37 7.04 10-522-514040 Food 400.00 294.32 0.00 105.68 26.42 10-522-517010 Operational Supplies 2,300.00 604.12 0.00 1,695.88 73.73 E10 Materials & Supplies 8,560.80 3,039.70 0.00 5,521.10 64.49 10-522-520030 Dues And Publications 1,300.00 1,253.50 0.00 46.50 3.58 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 5,900.00 2,943.44 0.00 2,956.56 50.11 10-522-522020 Professional Services 125,000.00 0.00 0.00 125,000.00 100.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 132,200.00 4,196.94 0.00 128,003.06 96.83 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 700.00 521.13 72.27 106.60 15.23 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 700.00 521.13 72.27 106.60 15.23 10-522-572020 Purchase Of Equipment 12,664.20 2,664.20 0.00 10,000.00 78.96 E70 Capital Purchases 12,664.20 2,664.20 0.00 10,000.00 78.96 522 Plan & Protect Svcs-MPO 352,713.66 160,129.74 72.27 192,511.65 54.58 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 68,107.45 60,643.44 0.00 7,464.01 10.96 10-530-501050 Parttime (wo Benefits)450.00 450.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 5,210.22 4,241.58 0.00 968.64 18.59 10-530-502020 Group Health Insurance 9,315.17 8,656.76 0.00 658.41 7.07 10-530-502030 Retirement 10,547.68 9,297.24 0.00 1,250.44 11.86 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-502040 Workers Compensation 28.02 0.00 0.00 28.02 100.00 10-530-502050 Life Insurance 114.81 109.12 0.00 5.69 4.96 10-530-502060 Long Term Disability 188.37 185.39 0.00 2.98 1.58 10-530-502070 Employee Assistance Prgm 38.19 27.09 0.00 11.10 29.07 E05 Personnel Services 93,999.91 83,610.62 0.00 10,389.29 11.05 10-530-511010 Advertising 340.00 332.50 0.00 7.50 2.21 10-530-511020 Postage 120.00 105.10 0.00 14.90 12.42 10-530-512010 Printing 10.00 0.00 0.00 10.00 100.00 10-530-512020 Copies 30.00 0.00 0.00 30.00 100.00 10-530-513010 Office Supplies 300.00 164.99 0.00 135.01 45.00 10-530-517010 Operational Supplies 300.00 179.46 0.00 120.54 40.18 E10 Materials & Supplies 1,100.00 782.05 0.00 317.95 28.90 10-530-520030 Dues And Publications 500.00 395.00 0.00 105.00 21.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,000.00 1,059.46 0.00 940.54 47.03 10-530-522020 Professional Services 840.00 600.00 0.00 240.00 28.57 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 83,274.50 78,500.00 0.00 4,774.50 5.73 10-530-524025 Glass Recycling 3,732.50 3,732.50 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 18,800.00 11,103.40 -11,103.40 18,800.00 100.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 5,045.50 2,225.70 0.00 2,819.80 55.89 10-530-524029 Recycling Education 0.00 0.00 0.00 0.00 0.00 10-530-528085 Fair Housing Assistance Prog 333.10 333.10 0.00 0.00 0.00 E15 Contractual Services 114,525.60 97,949.16 -11,103.40 27,679.84 24.17 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 350.00 284.30 27.95 37.75 10.79 E25 Repairs & Maintenance 350.00 284.30 27.95 37.75 10.79 10-530-550020 NRA-Residential 55,000.00 49,934.00 0.00 5,066.00 9.21 10-530-550030 NRA-Commercial Facade 45,500.00 21,474.45 0.00 24,025.55 52.80 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 376.90 334.46 0.00 42.44 11.26 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 126,648.58 125,977.41 0.00 671.17 0.53 10-530-550055 HERO 41,250.00 20.00 0.00 41,230.00 99.95 10-530-550060 MSP 0.00 0.00 -75.38 75.38 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 288,874.48 197,740.32 -75.38 91,209.54 31.57 530 Plan & Protect Svc-RedevGrant 498,849.99 380,366.45 -11,150.83 129,634.37 25.99 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 165,297.12 137,237.44 0.00 28,059.68 16.98 10-532-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.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 300.00 0.00 0.00 300.00 100.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 12,668.18 9,875.29 0.00 2,792.89 22.05 10-532-502020 Group Health Insurance 29,033.84 23,753.45 0.00 5,280.39 18.19 10-532-502030 Retirement 25,737.74 21,256.80 0.00 4,480.94 17.41 10-532-502040 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00 10-532-502050 Life Insurance 279.32 250.79 0.00 28.53 10.21 10-532-502060 Long Term Disability 461.94 428.17 0.00 33.77 7.31 10-532-502070 Employee Assistance Prgm 76.38 54.18 0.00 22.20 29.07 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 235,633.75 194,635.35 0.00 40,998.40 17.40 10-532-511010 Advertising 68.82 0.00 0.00 68.82 100.00 10-532-511020 Postage 320.22 228.76 0.00 91.46 28.56 10-532-512010 Printing 50.00 38.00 0.00 12.00 24.00 10-532-512020 Copies 20.00 0.98 0.00 19.02 95.10 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,410.96 1,310.96 0.00 100.00 7.09 10-532-514030 Small Tools 50.00 0.00 0.00 50.00 100.00 10-532-515030 Insect Control 0.00 0.00 0.00 0.00 0.00 10-532-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-532-517010 Operational Supplies 1,347.56 606.63 431.36 309.57 22.97 E10 Materials & Supplies 3,282.56 2,185.33 431.36 665.87 20.29 10-532-520030 Dues And Publications 1,000.00 524.00 0.00 476.00 47.60 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 454.00 0.00 546.00 54.60 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 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 163,500.03 54,500.00 -0.03 0.00 10-532-529010 Special Events 152.44 152.44 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 220,152.44 164,630.47 54,500.00 1,021.97 0.46 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 30,000.00 21,991.36 6,756.00 1,252.64 4.18 10-532-540065 Cemetery Restoration 571.30 250.00 0.00 321.30 56.24 10-532-541030 Vehicle Wash 1,290.00 1,290.00 0.00 0.00 0.00 10-532-546010 Clothing Expense 1,860.00 1,815.85 0.00 44.15 2.37 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 700.00 585.40 61.41 53.19 7.60 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 34,501.30 25,932.61 6,817.41 1,751.28 5.08 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,570.05 387,383.76 61,748.77 44,437.52 9.00 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 146,697.02 109,431.98 0.00 37,265.04 25.40 10-533-501060 Seasonal Salaries 10,940.00 7,796.25 0.00 3,143.75 28.74 10-533-501090 Overtime 740.00 693.82 0.00 46.18 6.24 10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00 10-533-502010 Social Security 12,813.37 8,469.13 0.00 4,344.24 33.90 10-533-502020 Group Health Insurance 25,582.16 16,641.87 0.00 8,940.29 34.95 10-533-502030 Retirement 23,511.19 14,344.43 0.00 9,166.76 38.99 10-533-502040 Workers Compensation 1,874.09 0.00 0.00 1,874.09 100.00 10-533-502050 Life Insurance 255.33 161.30 0.00 94.03 36.83 10-533-502060 Long Term Disability 419.34 318.60 0.00 100.74 24.02 10-533-502070 Employee Assistance Prgm 76.38 54.18 0.00 22.20 29.07 E05 Personnel Services 223,168.88 157,911.56 0.00 65,257.32 29.24 10-533-511010 Advertising 100.00 92.40 0.00 7.60 7.60 10-533-511020 Postage 1,114.00 1,150.23 0.00 -36.23 -3.25 10-533-512010 Printing 163.00 163.00 0.00 0.00 0.00 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 800.00 785.48 0.00 14.52 1.82 10-533-514030 Small Tools 75.00 0.00 0.00 75.00 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,750.00 1,209.18 0.00 540.82 30.90 E10 Materials & Supplies 4,032.00 3,400.29 0.00 631.71 15.67 10-533-520030 Dues And Publications 550.58 541.38 0.00 9.20 1.67 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 2,033.16 930.16 0.00 1,103.00 54.25 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 32,333.34 26,410.57 0.00 5,922.77 18.32 10-533-522022 Demo 20,000.00 887.25 2,770.00 16,342.75 81.71 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 54,917.08 28,769.36 2,770.00 23,377.72 42.57 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 1,599.00 1,358.44 0.00 240.56 15.04 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 772.42 508.10 81.28 183.04 23.70 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,671.42 2,136.54 81.28 453.60 16.98 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 284,789.38 192,217.75 2,851.28 89,720.35 31.50 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 214,962.70 178,544.16 0.00 36,418.54 16.94 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 370.00 134.13 0.00 235.87 63.75 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 16,477.92 12,589.43 0.00 3,888.49 23.60 10-534-502020 Group Health Insurance 38,169.41 34,998.60 0.00 3,170.81 8.31 10-534-502030 Retirement 33,464.04 27,662.36 0.00 5,801.68 17.34 10-534-502040 Workers Compensation 2,012.43 0.00 0.00 2,012.43 100.00 10-534-502050 Life Insurance 361.57 324.86 0.00 36.71 10.15 10-534-502060 Long Term Disability 598.29 555.19 0.00 43.10 7.20 10-534-502070 Employee Assistance Prgm 101.84 72.24 0.00 29.60 29.07 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 306,583.20 254,880.97 0.00 51,702.23 16.86 10-534-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-534-511020 Postage 1,000.00 1,035.98 0.00 -35.98 -3.60 10-534-512010 Printing 350.00 270.62 0.00 79.38 22.68 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,000.00 994.23 0.00 5.77 0.58 10-534-514030 Small Tools 150.00 0.00 0.00 150.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,250.00 1,180.40 0.00 69.60 5.57 E10 Materials & Supplies 3,780.00 3,481.23 0.00 298.77 7.90 10-534-520030 Dues And Publications 2,334.95 2,334.95 0.00 0.00 0.00 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 1,965.05 911.52 0.00 1,053.53 53.61 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 4,300.00 3,246.47 0.00 1,053.53 24.50 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 2,083.00 2,082.66 0.00 0.34 0.02 10-534-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-534-547020 Maintenance Agreements 647.00 576.89 67.26 2.85 0.44 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,030.00 2,929.55 67.26 33.19 1.10 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,693.20 264,538.22 67.26 53,087.72 16.71 535 Public Works-Central Maintenan 10-535-501020 Salaries 319,589.28 265,475.90 0.00 54,113.38 16.93 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 5,080.80 0.00 2,319.20 31.34 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,332.27 0.00 1,167.73 25.95 10-535-501095 Overtime Straight Pay 500.00 345.60 0.00 154.40 30.88 10-535-502010 Social Security 25,397.18 19,783.27 0.00 5,613.91 22.10 10-535-502020 Group Health Insurance 67,768.69 55,115.46 0.00 12,653.23 18.67 10-535-502030 Retirement 50,289.71 41,530.93 0.00 8,758.78 17.42 10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00 10-535-502050 Life Insurance 539.78 484.43 0.00 55.35 10.25 10-535-502060 Long Term Disability 893.28 828.86 0.00 64.42 7.21 10-535-502070 Employee Assistance Prgm 178.21 126.42 0.00 51.79 29.06 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 479,316.68 394,364.49 0.00 84,952.19 17.72 10-535-511010 Advertising 80.00 75.62 0.00 4.38 5.48 10-535-511020 Postage 50.00 2.61 0.00 47.39 94.78 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 390.64 0.00 1,109.36 73.96 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 8,000.00 5,429.18 0.00 2,570.82 32.14 10-535-517010 Operational Supplies 7,000.00 6,016.34 -634.40 1,618.06 23.12 E10 Materials & Supplies 16,640.00 11,914.39 -634.40 5,360.01 32.21 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 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-520070 Training And Education 2,000.00 995.28 0.00 1,004.72 50.24 10-535-521005 Tank Insurance 500.00 0.00 0.00 500.00 100.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 995.28 0.00 1,504.72 60.19 10-535-531010 Electricity 7,560.00 5,399.25 0.00 2,160.75 28.58 10-535-533010 Natural Gas 7,851.34 5,136.40 0.00 2,714.94 34.58 10-535-534010 Telephone 220.00 210.18 0.00 9.82 4.46 10-535-535010 Water 1,400.00 1,181.81 0.00 218.19 15.59 E20 Utilities 17,031.34 11,927.64 0.00 5,103.70 29.97 10-535-540010 Building & Grounds Maint.10,000.00 6,225.71 50.00 3,724.29 37.24 10-535-541010 Veh & Equip Parts Etc 475,000.00 405,049.94 0.00 69,950.06 14.73 10-535-546010 Clothing Expense 4,204.29 4,626.58 -7,327.85 6,905.56 164.25 10-535-547010 Equipment Maintenance 3,000.00 1,720.74 211.20 1,068.06 35.60 10-535-547020 Maintenance Agreements 7,244.37 7,310.71 211.20 -277.54 -3.83 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 499,548.66 424,933.68 -6,855.45 81,470.43 16.31 10-535-572020 Purchase Of Equipment 39,000.00 24,654.58 4,999.99 9,345.43 23.96 E70 Capital Purchases 39,000.00 24,654.58 4,999.99 9,345.43 23.96 535 Public Works-Central Maintenan 1,054,036.68 868,790.06 -2,489.86 187,736.48 17.81 540 Public Works-Admin 10-540-501020 Salaries 200,948.53 154,604.08 0.00 46,344.45 23.06 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,372.56 11,715.28 0.00 3,657.28 23.79 10-540-502020 Group Health Insurance 32,660.76 26,491.55 0.00 6,169.21 18.89 10-540-502030 Retirement 31,323.27 25,914.81 0.00 5,408.46 17.27 10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00 10-540-502050 Life Insurance 339.29 305.90 0.00 33.39 9.84 10-540-502060 Long Term Disability 476.14 443.84 0.00 32.30 6.78 10-540-502070 Employee Assistance Prgm 76.38 54.18 0.00 22.20 29.07 E05 Personnel Services 281,312.20 219,644.91 0.00 61,667.29 21.92 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 12.80 0.00 187.20 93.60 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 53.82 0.00 946.18 94.62 10-540-514010 Gas 45,000.00 35,898.51 0.00 9,101.49 20.23 10-540-514040 Food 200.00 93.53 0.00 106.47 53.24 10-540-517010 Operational Supplies 1,300.00 129.00 0.00 1,171.00 90.08 E10 Materials & Supplies 48,000.00 36,187.66 0.00 11,812.34 24.61 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-520030 Dues And Publications 689.84 689.84 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,810.16 1,731.84 0.00 78.32 4.33 10-540-522020 Professional Services 200.00 0.00 0.00 200.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 2,421.68 0.00 278.32 10.31 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 675.00 315.05 61.41 298.54 44.23 E25 Repairs & Maintenance 675.00 315.05 61.41 298.54 44.23 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 332,687.20 258,569.30 61.41 74,056.49 22.26 541 Public Works-Engineering 10-541-501020 Salaries 698,595.57 570,066.77 0.00 128,528.80 18.40 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 41.63 0.00 358.37 89.59 10-541-501095 Overtime Straight Pay 400.00 30.73 0.00 369.27 92.32 10-541-502010 Social Security 53,503.76 39,968.28 0.00 13,535.48 25.30 10-541-502020 Group Health Insurance 108,119.51 86,978.17 0.00 21,141.34 19.55 10-541-502030 Retirement 108,940.30 83,440.70 0.00 25,499.60 23.41 10-541-502040 Workers Compensation 3,639.97 3,639.97 0.00 0.00 0.00 10-541-502050 Life Insurance 1,175.53 1,019.82 0.00 155.71 13.25 10-541-502060 Long Term Disability 1,923.88 1,722.42 0.00 201.46 10.47 10-541-502070 Employee Assistance Prgm 280.05 198.63 0.00 81.42 29.07 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 976,978.57 787,107.12 0.00 189,871.45 19.43 10-541-511010 Advertising 1,520.85 1,520.85 0.00 0.00 0.00 10-541-511020 Postage 800.00 311.98 0.00 488.02 61.00 10-541-512010 Printing 100.00 32.00 0.00 68.00 68.00 10-541-512020 Copies 75.00 0.04 0.00 74.96 99.95 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 5,471.57 4,468.33 0.00 1,003.24 18.34 10-541-514030 Small Tools 144.43 0.00 0.00 144.43 100.00 10-541-514040 Food 205.57 205.57 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 954.83 0.00 1,045.17 52.26 10-541-515080 Surveying Supplies 2,000.00 339.49 0.00 1,660.51 83.03 10-541-517010 Operational Supplies 1,632.83 1,632.83 0.00 0.00 0.00 E10 Materials & Supplies 14,000.25 9,465.92 0.00 4,534.33 32.39 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-520030 Dues And Publications 3,849.56 2,087.00 0.00 1,762.56 45.79 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 2,792.34 1,232.84 0.00 1,559.50 55.85 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 2,924.75 381.00 0.00 2,543.75 86.97 10-541-522055 Stormwater Compliance 1,500.00 684.60 0.00 815.40 54.36 E15 Contractual Services 11,066.65 4,385.44 0.00 6,681.21 60.37 10-541-534010 Telephone 500.00 343.40 0.00 156.60 31.32 E20 Utilities 500.00 343.40 0.00 156.60 31.32 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 1,000.00 0.00 0.00 0.00 10-541-546010 Clothing Expense 1,358.10 1,358.10 0.00 0.00 0.00 10-541-547010 Equipment Maintenance 1,500.00 1,039.20 0.00 460.80 30.72 10-541-547020 Maintenance Agreements 9,400.00 7,928.53 108.19 1,363.28 14.50 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 13,258.10 11,325.83 108.19 1,824.08 13.76 10-541-572010 Purchase of Vehicles 28,000.00 27,941.00 0.00 59.00 0.21 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 28,000.00 27,941.00 0.00 59.00 0.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,043,803.57 840,568.71 108.19 203,126.67 19.46 542 Public Works-Street 10-542-501020 Salaries 1,050,712.34 860,620.27 0.00 190,092.07 18.09 10-542-501060 Seasonal Salaries 18,000.00 14,777.75 0.00 3,222.25 17.90 10-542-501070 Stand-by Plan 5,000.00 3,548.00 0.00 1,452.00 29.04 10-542-501090 Overtime 35,000.00 13,680.71 0.00 21,319.29 60.91 10-542-501095 Overtime Straight Pay 500.00 194.19 0.00 305.81 61.16 10-542-502010 Social Security 84,854.74 66,073.34 0.00 18,781.40 22.13 10-542-502020 Group Health Insurance 174,200.51 134,432.16 0.00 39,768.35 22.83 10-542-502030 Retirement 169,069.85 131,952.22 0.00 37,117.63 21.95 10-542-502040 Workers Compensation 18,752.09 18,752.09 0.00 0.00 0.00 10-542-502050 Life Insurance 1,777.86 1,574.31 0.00 203.55 11.45 10-542-502060 Long Term Disability 2,905.41 2,651.19 0.00 254.22 8.75 10-542-502070 Employee Assistance Prgm 598.29 424.38 0.00 173.91 29.07 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,561,571.09 1,248,680.61 0.00 312,890.48 20.04 10-542-511010 Advertising 388.50 388.50 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-511020 Postage 150.00 107.89 0.00 42.11 28.07 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 1,364.07 0.00 235.93 14.75 10-542-514020 Chemicals 268,318.00 268,317.62 -697,495.80 697,496.18 259.95 10-542-514030 Small Tools 8,450.40 6,554.42 0.00 1,895.98 22.44 10-542-514040 Food 2,000.00 305.46 0.00 1,694.54 84.73 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 270,885.72 199,863.69 -36,324.50 107,346.53 39.63 10-542-515040 First Aid Supplies 411.50 0.00 0.00 411.50 100.00 10-542-515060 Weed Control 1,596.00 1,596.00 0.00 0.00 0.00 10-542-515070 Const & Inspect Supplies 394.04 394.04 0.00 0.00 0.00 10-542-517010 Operational Supplies 6,555.10 6,555.10 0.00 0.00 0.00 E10 Materials & Supplies 560,849.26 485,446.79 -733,820.30 809,222.77 144.29 10-542-520030 Dues And Publications 600.00 567.50 0.00 32.50 5.42 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 1,868.89 1,253.65 0.00 615.24 32.92 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 16,799.21 17,138.21 1,000.00 -1,339.00 -7.97 10-542-523010 Equipment Rentlease 200.00 75.00 0.00 125.00 62.50 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 2,000.00 0.00 0.00 2,000.00 100.00 E15 Contractual Services 21,468.10 19,034.36 1,000.00 1,433.74 6.68 10-542-531010 Electricity 30,450.00 18,146.53 0.00 12,303.47 40.41 10-542-531020 Street Lights 640,000.00 473,591.73 0.00 166,408.27 26.00 10-542-533010 Natural Gas 16,431.90 6,762.54 0.00 9,669.36 58.85 10-542-534010 Telephone 580.00 76.00 12.00 492.00 84.83 10-542-535010 Water 7,000.00 4,792.75 0.00 2,207.25 31.53 E20 Utilities 694,461.90 503,369.55 12.00 191,080.35 27.51 10-542-540010 Building & Grounds Maint.8,000.00 4,388.88 75.00 3,536.12 44.20 10-542-541030 Vehicle Wash 7,000.00 7,000.00 0.00 0.00 0.00 10-542-542010 Repairs - StopStreet Lights 15,000.00 10,902.05 0.00 4,097.95 27.32 10-542-542030 Signs & Marking Paint 36,000.00 33,464.72 309.60 2,225.68 6.18 10-542-546010 Clothing Expense 10,000.00 7,192.85 0.00 2,807.15 28.07 10-542-547010 Equipment Maintenance 2,977.28 1,496.83 0.00 1,480.45 49.72 10-542-547020 Maintenance Agreements 522.72 261.36 0.00 261.36 50.00 10-542-547030 Radio Maintenance 836.26 90.95 0.00 745.31 89.12 E25 Repairs & Maintenance 80,336.26 64,797.64 384.60 15,154.02 18.86 10-542-572010 Purchase Of Vehicles 120,000.00 80,474.00 30,001.00 9,525.00 7.94 10-542-572020 Purchase Of Equipment 31,482.48 10,482.48 20,670.00 330.00 1.05 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 87,182.00 0.00 84,885.09 2,296.91 2.63 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 238,664.48 90,956.48 135,556.09 12,151.91 5.09 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 542 Public Works-Street 3,157,351.09 2,412,285.43 -596,867.61 1,341,933.27 42.50 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 16,600.00 10,047.43 0.00 6,552.57 39.47 10-700-590065 Trans to Self-Funded Hlth Ins 54,000.00 54,000.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 189,381.74 189,381.74 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,211,548.73 1,211,548.73 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,471,530.47 1,464,977.90 0.00 6,552.57 0.45 700 Transfers & Subsidies 1,471,530.47 1,464,977.90 0.00 6,552.57 0.45 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 2,308.08 0.00 0.00 2,308.08 100.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 224,810.00 224,810.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 28,200.00 28,200.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 35,100.00 35,100.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 290,418.08 288,110.00 0.00 2,308.08 0.79 900 CapitalVehicleEquipment 290,418.08 288,110.00 0.00 2,308.08 0.79 990 Capital Projects 10-990-575015 Police HVAC 265,981.30 257,922.70 8,058.60 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 145,629.22 0.00 0.00 145,629.22 100.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 596,711.14 87,735.30 508,975.84 0.00 0.00 10-990-577054 Wayfinding 248,455.31 91,900.34 144,054.97 12,500.00 5.03 10-990-577056 SOMO Sewer Extension 300,000.00 0.00 0.00 300,000.00 100.00 E75 Capital Projects 1,556,776.97 437,558.34 661,089.41 458,129.22 29.43 990 Capital Projects 1,556,776.97 437,558.34 661,089.41 458,129.22 29.43 Expense Expense 33,394,859.81 25,673,811.65 270,040.72 7,451,007.44 22.31 GL - Trial Balance by Acct Type and Full Acct Number (09/06/2016 - 9:00 AM)Page 38 FYE2015 Unassigned Fund Balance - (excluding the $1.5M commitment to the Multipurpose Bldg)7,010,330.00$ FYE2015 Fund Balance % of Adopted Budget 23.78% FY2016 Activities Year-to-Date: Reappropriations from FY2015 to FY2016 Air Conditioner Unit #3 (20,000.00)$ Police HVAC (265,981.30)$ Remaining portion of NRA - Rental Façade Improvement (20,099.00)$ Remaining NSP Program Income (52,301.29)$ Compensation Study (50,000.00)$ Matching portion of Loader Grant (21,207.50)$ Remaining balance for court softward project (5,563.24)$ (435,152.33)$ 2016 Adjustments/Supplementals FY2016 Supplemental Appropriations: Creation of New Internal Service fund for Self-Funding Health Insurance (54,000.00)$ 304 Marshall Street - Neighborhood Stabilization Program (25,000.00)$ Special Olympics of Missouri sewer extension (300,000.00)$ Defense Cost Sharing Agreement - Ameren Missouri (5,158.74)$ (384,158.74)$ FYE2016 Estimated Unassigned Fund Balance 6,191,018.93$ FYE2016 Fund Balance % of Adopted Budget 20.13% * Ordinance 15541 supplementally appropriated $164,672 - sale of old Station #3 - offsetting revenue also recorded in FY2016 so no effect on fund balance 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 3,421.47 11/2015 Interest Received (8.00) 11/2015 Service Charge Oct-15 12/1/15 107,837.70 45,291.83 60,389.11 3,605.14 12/2015 Interest Received (8.29) 12/2015 Service Charge Nov-15 12/31/15 67,119.58 28,190.22 37,586.96 Sep-15 1,908.92 801.75 1,069.00 late pays 3,666.35 1/2016 Interest Received (8.29) 1/2016 Service Charge Dec-15 1/31/16 66,959.22 28,122.88 37,497.16 3,478.72 2/2016 Interest Received (8.49) 2/2016 Service Charge Jan-16 2/20/16 83,239.99 34,960.80 46,614.39 3,786.20 3/2016 Interest Received (8.28) 3/2016 Service Charge Feb-16 3/20/16 97,559.96 40,975.18 54,633.58 3,718.19 4/2016 Interest Received (8.27) 4/2016 Service Charge Mar-16 4/29/16 101,134.20 42,476.36 56,635.16 3,914.86 5/2016 Interest Received (8.26) 5/2016 Service Charge Apr-16 5/20/16 140,992.87 59,217.01 78,956.01 3,905.43 6/2016 Interest Received May-16 6/20/16 112,152.91 47,104.22 62,805.63 3,985.42 7/2016 Interest Received Jun-16 7/31/16 106,704.37 44,815.83 59,754.44 4,207.43 8/2016 Interest Received Jul-16 8/20/16 96,811.40 40,660.79 54,214.38 Total 5,833,119.25 2,449,910.10 3,341,920.57 average monthly amount for 4 cent lockbox fund 51,849.95$ **Effective for 25 years starting in 2011 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy January 51.30%45.90%49.20%45.30%38.20% February 58.60%51.20%56.00%52.90%49.80% March 59.80%59.80%59.30%52.90%54.90% April 67.20%58.10%63.70%64.10%53.90% May 64.90%63.10%64.70%56.80%53.70% June 64.00%59.70%63.70%55.70%53.10% July 58.20%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 60.70%67.60%65.90%59.30% November 51.30%48.90%52.40%43.40% December 45.10%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: July 2016 Percent Change from July 2015 Percent Change from YTD 2015 2016 2015 2016 2015 2016 2015 Occ ADR RevPAR Room Rev Room Avail Room Sold 2016 2015 2016 2015 2016 2015 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 74.4 75.1 128.77 124.32 95.81 93.43 -1.0 3.6 2.5 4.2 1.6 0.6 66.4 66.5 123.93 120.13 82.33 79.91 -0.1 3.2 3.0 4.6 1.5 1.4 54289 32091 5079583 3716251 West North Central 70.8 72.9 100.82 98.56 71.35 71.87 -3.0 2.3 -0.7 0.6 1.3 -1.7 59.1 60.0 95.28 92.64 56.27 55.60 -1.6 2.9 1.2 2.9 1.7 0.0 4575 2657 355634 255913 Missouri 72.4 72.4 100.50 97.70 72.76 70.76 -0.0 2.9 2.8 2.4 -0.4 -0.4 62.0 60.0 95.18 92.77 58.98 55.66 3.3 2.6 6.0 6.0 0.0 3.3 1122 632 101927 72003 Kansas City, MO-KS 74.8 77.1 102.93 97.66 77.01 75.26 -2.9 5.4 2.3 3.9 1.5 -1.4 65.2 66.3 99.13 93.52 64.68 62.04 -1.7 6.0 4.2 6.0 1.6 -0.0 294 229 32781 28026 St Louis, MO-IL 76.2 76.8 104.21 103.63 79.39 79.58 -0.8 0.6 -0.2 0.9 1.1 0.3 67.5 66.3 100.93 99.92 68.08 66.25 1.7 1.0 2.8 4.0 1.2 3.0 330 242 38141 32232 Columbia, MO+64.8 64.4 85.98 86.86 55.75 55.92 0.7 -1.0 -0.3 1.7 2.0 2.7 60.3 57.1 86.66 85.84 52.28 49.00 5.7 1.0 6.7 10.0 3.0 8.9 39 29 4013 3125 Jefferson City, MO+58.2 60.8 78.95 77.05 45.98 46.82 -4.2 2.5 -1.8 -1.8 0.0 -4.2 60.5 57.0 82.15 78.37 49.73 44.64 6.3 4.8 11.4 11.4 0.0 6.3 15 11 1494 1063 Springfield, MO 71.8 70.1 81.30 79.41 58.35 55.63 2.5 2.4 4.9 4.8 -0.1 2.3 62.5 61.2 79.28 77.29 49.56 47.28 2.2 2.6 4.8 7.4 2.5 4.7 70 47 6262 4513 Branson, MO 76.1 71.6 111.67 108.77 84.95 77.88 6.2 2.7 9.1 5.7 -3.1 3.0 51.6 45.7 98.33 97.54 50.70 44.53 12.9 0.8 13.9 10.7 -2.8 9.8 151 32 13564 4326 Lake of the Ozarks+69.0 65.1 121.69 116.81 83.98 76.06 6.0 4.2 10.4 10.4 -0.0 5.9 49.5 46.1 102.54 99.52 50.75 45.89 7.3 3.0 10.6 13.1 2.3 9.8 36 11 2785 1544 Joplin, MO 67.3 68.6 84.09 80.16 56.61 55.00 -1.9 4.9 2.9 -4.8 -7.5 -9.3 62.0 56.4 79.17 75.12 49.05 42.34 9.9 5.4 15.8 4.8 -9.5 -0.5 30 23 2300 2011 Saint Joseph, MO+62.8 63.4 84.35 80.45 53.00 51.00 -0.9 4.9 3.9 3.9 0.0 -0.9 58.6 58.5 81.62 78.90 47.83 46.19 0.1 3.4 3.6 3.6 0.0 0.1 14 10 1291 999 A blank row indicates insufficient data.Source 2016 STR, Inc. Participation Occ % Current Month - July 2016 vs July 2015 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 - July 2016 vs July 2015 RoomsRevPARPropertiesADR 1 PURCHASING OVERVIEW The purchasing division is responsible for the procurement of all supplies, materials, services and equipment requested by the departments. It is the division’s task to insure purchases are at the maximum value for the money spent and are made in full compliance with the provisions of the City Code and all local, state and federal regulations. The division must also provide for financial accountability, ensure fair and equitable treatment of all persons dealing with the purchasing system, and maintain a system of quality and integrity. Departments submit a purchase requisition to initiate a request for procurement services. Purchasing determines the appropriate procurement method and processes the request through the required steps to complete the purchase. City procurement is divided into three categories – non-competitive, competitive and other. Departments are prohibited from artificially dividing purchases to avoid competitive bidding and there are additional requirements for the expenditure of federal funds. NON COMPETITIVE • Petty cash – Up to $100 • Procurement Card Purchases – monthly limits are up to $1,500.00 General Employee; $2,500.00 Supervisory Employee and $5,000.00 Department Director • Small Purchases – Up to $5,000.00 or $2,000.00 for federally funded construction or $3,000 for other purchases. This category does not require competition, the employee completes the purchase, prepares the appropriate form and submits a request for reimbursement or payment through the department to purchasing where it is audited for compliance to city policy. COMPETITIVE CATEGORY • Informal Quotes $5,000.00 – 24,999.99 or $2,500.00 federal construction or $3,000 federal funding. • Formal Bids (Sealed) - $25,000 and above • Construction Bids - $5,000 and up • Proposals • Requests for Qualifications • Cooperative Procurement Agreements – State, Cole County, Housing Authority This category requires competition. A minimum of three bids or proposals are required for these purchases. 2 Quotes Informal bids may be obtained by the department or through purchasing up to $24,999.99. Departments are encouraged to use requisitions to submit the request with the bids taken or to list the requirements for bidding by purchasing. Bids are reviewed or solicited, a recommendation for award is made by the department and purchasing approves the purchase by issuing a purchase order or requesting an administrative contract. Sealed Bids Purchases of $25,000.00 and above require formal bidding through the Purchasing Division. The department submits a requisition listing the requirements of the purchase, specifications are completed in purchasing, bids are advertised, formally opened, evaluated by the department and purchasing and a recommendation is submitted to the Council for award. Construction Bids Specifications for these requests are completed in the Department. Purchasing advertises the project and advises contractors, specifications and plans are sold in the department, purchasing holds a formal bid opening, the department evaluates bids and makes a recommendation through purchasing for an administrative contract or for council award. Proposals Proposals are also either informal or formal based on the expected contract amount. Proposals are used when the requirements of the product or service cannot be defined or are not specific. This method is used whenever several possible methods may satisfy the requirements or whenever subjective evaluation of criteria other than cost is necessary. This method permits negotiations and discussion with competing vendors after proposals are opened. The department submits requirements on a requisition. Purchasing completes the RFP packet, solicits and receives proposals. Responses are not publicly opened and remain confidential until a recommendation for award is made. Proposals are evaluated based on evaluation criteria listed in the solicitation and a recommendation for award is made for an administrative contract or if $25,000.00 or above, the recommendation is submitted to the Council for award of a contract. Requests for Qualifications This method is required to secure the services of professional service firms including, but not limited to Architectural, Engineering and Land Surveying firms. By law, these services must be selected on the basis of demonstrated competence and qualifications for the services needed. Consideration of cost is prohibited until after the most qualified firm has been selected. The department submits requirements and a basic scope of services on a requisition. Purchasing completes the RFQ packet, solicits and receives responses. Responses are not publicly opened and remain confidential until a recommendation for award is made. A final scope and cost is negotiated with the most qualified firm. A recommendation for award and 3 final contract is made through purchasing for an administrative contract or if $25,000.00 or above, for Council award of a contract. EVALUATION OF VENDOR RESPONSES Many of the specifications that include services to the City require bidders to submit the qualifications for each member of the firm that will be performing on the work and references where similar work has been completed. During the evaluation of responses these qualifications and references are reviewed. The city also uses past history of work performed for the City. Departments work directly with the awarded vendors and must let Purchasing know if there are concerns with the vendor’s product or services. These concerns must be documented with specific information regarding the deficiencies. It is up to the department to contact purchasing with the information in order for purchasing to become involved. There are vendors who have notes regarding deficiencies. City Code Section 26A-33 Debarment states the procedure to debar a person or firm from further award for a period of up to three years. The city has not debarred a vendor to date. The Missouri Office of Administration, Department of Transportation, and federal websites have debarred vendor listings that are also reviewed. COOPERATIVE PROCUREMENT AGREEMENTS Established through competitive bidding by other entities. The City “piggybacks” on these agreements as long as the item purchased is as stated on the cooperative award, the city meets the minimum order requirements and all applicable terms and conditions of the award. In addition, the procurement process used by the bidding agency must be in full compliance with City Code, Chapter 26A. The City has cooperative procurement agreements with the State of Missouri (includes all state agencies), Missouri Department of Transportation, Cole County, and the Jefferson City Housing Authority. Other procurements have been approved through a one-time purchase through the Council in the past. As members of cooperative procurement with the State of Missouri the City can purchase from any cooperative contract they list. The state vets the bidding practices and agreement through other cooperative service groups and adds those agreements to the statewide cooperative procurement listing that meet Missouri requirements. The State of Missouri cooperative procurement listing has included agreements from other cooperative services such as NJIP, NACPO ValuePoint, WISCA, and US Communities for specific items. Each Cooperative Group has its own bidding and award process. Many are based on the requirements of the state they are located in and may not meet standards set by Missouri or the City’s purchasing ordinance for lowest and best award. Many of the cooperative groups award to each vendor responding to a very loose specification. It is then up to the City to 4 actually prepare a specification for the item and a list of the attachments to obtain an actual price for the product. Many of these cooperatives are more a list of vendors and brands to choose from with a price determined later. OTHER CATEGORY This category includes special purchasing situations that may or may not require competitive procurement or contain specific requirements set out in the procurement code. The category includes Sole Source Emergency Purchases Exempt Purchases (Bulk Chemicals and Fuel) Surplus Property Change Orders to Existing Contracts Employee Reimbursements Sole Source – does not require competitive bids, but does require City Administrator approval through the Purchasing Division and may require Council award if in excess of $25,000. Emergency Purchase – the emergency must be declared through the City Administrator, bids are required, purchasing reviews or solicits bids, and the City Administrator approves an immediate award. Emergency purchases are reported to the Council if over $25,000. Exempt Purchases (Bulk Chemicals and Fuel) – requires bidding but because of the frequent price fluctuations, award is made by the purchasing agent for an immediate purchase or agreement. Surplus Property – does not require bidding, purchases are made by the department through the State Agency for Surplus Property. Contract Change Orders – Do not require bids, however cannot change the scope of the original agreement and must be under 10% of the original contract or $25,000.00 whichever is greater. Council approval is required for change orders exceeding the limits. Employee Reimbursements – are based on specific reimbursement rates listed in the personnel policy, uniform policy or approved by the department director for expenses incurred in the conduct of City business. COUNCIL PREFERENCE SUBSTITUTION Section 26A-8 Allows the City Council to substitute its judgement for staff’s judgement and make any selection it feels is in the best interest of the City. If the contract is brought before the Council as the result of competitive bidding, the Council substitutes the name of the party recommended for award of the contract with another party who also submitted a bid, the price 5 of the bid of the substituted party shall be deemed to also be approved unless specifically stated to the contrary in a motion. If this clause were to be used, the federal funding would be lost as this would be considered a prohibited action under the Federal Funds competition requirements. FEDERAL FUNDS Upon accepting federal funds, the City is required to comply with the requirements of that funding agency. In general, all federal funds expenditures must comply with 2CFR 200.317- 326. Each federal funding agency may require additional stipulations for the expenditure based on the mission of that program. Additional requirements may be included in Circulars named in the grant acceptance documents, such as FTA, MPO, and CDBG Circulars. Although grant funds require the City to use its own documented procurement procedures it also requires us to conform to the applicable Federal standards. In areas where federal and City standards differ, the stricter of the two is used. Federal funds requirements • Encourages the use of Federal excess and surplus property in lieu of new equipment where feasible. • Must maintain records sufficient to detail the history of the procurement including rational for the method of procurement, selection of contract type, contractor selection and basis for the contract price. • Discourages the award of time and material contracts. Competition All transactions must be conducted in a manner providing full and open competition. Certain restrictions to competition are prohibited and include: • Contractors that help develop or draft specifications, requirements or statements of work are not allowed to bid or offer a proposal for the project. • Placing unreasonable requirements on firms in order to get the award such as unnecessary experience or excessive bonding. • Non-competitive pricing practices between firms or between affiliated companies. 6 • Non-competitive contracts to consultants that are on retainer contracts • Organizational conflicts of interest – Companies that may have business interests or affiliates that may cause a conflict of interest. Company A provides input for specification preparation and doesn’t bid but their subsidiary business bids the project. • Specifying a “brand name” products instead of allowing “an equal” product to be offered. Must describe the performance or other relevant requirements of the procurement • Any arbitrary action in the procurement process. • Prohibits the use of any local geographical preferences in the solicitation or evaluation of any procurement. The only exception I have seen is when contracting for Architectural and Engineering services. • Cost plus a percentage of cost and percentage of construction cost contracts are expressly prohibited. • Written procedures must ensure that all solicitations: o Contain clear and accurate description for the technical requirements. o Must not include features which unduly restrict competition. o May include a statement of quality and set forth minimum essential characteristics and standards required to satisfy its intended use. o Must identify all requirements that must be fulfilled and all factors to be used in evaluating bids or proposals. Federal Procurement Methods When using federal funds with differing requirements, the City is required to abide by the most restrictive process. For instance, small purchases $5,000 to $25,000 in City Code require three written quotes. However, federal requirements have a lower threshold - $2,000 for construction and $3,000 for other services and products. Because federal requirements are lower, federal requirements are used to determine when three written quotes are required. Formal Bidding is required in City Code at $25,000.00; however federal requirements contain the $150,000 threshold. Because the City’s requirement is lower, formal bids are taken at $25,000.00. 7 Awards for formal bids under federal regulations require award to the responsible bidder whose bid conforms with the terms and conditions of the specifications and is the lowest in price. Small, Minority, And Woman Owned Business Enterprises Expenditure of federal funds require that small, minority, and woman owned business enterprises are used when possible. Affirmative steps must include: • Placing qualified small, minority and woman owned business enterprises on bid lists • Dividing total requirements when economically feasible into smaller tasks or quantities to permit participation. • Establishing delivery schedules which encourage participation, • Requiring prime contractors to take the same steps for sub-contracting participation. The City does not certify small, Minority and Woman Owned Business Enterprises because the certification process requires an in-depth review of the company and its operations on an on- going basis. The City uses the Missouri Department of Transportation and Office of Administration listings. Independent Cost Estimates An independent analysis of the expected cost must be made prior to receiving bids or proposals. There are several methods to accomplish the analysis, prior cost of similar City projects with current CPI increase/decrease included. Current costs incurred by other governmental entities, on line and catalog pricing or from a vendor. If a vendor is used, that vendor is prohibited from bidding on the product or service. Federal Funding Clauses Specific funding clauses are required to be included in solicitations and contracts. Each funding agency specifies certain standard clauses that must be included as well as agency specific clauses. Review by Federal Agency Some agencies require a review of the specifications prior to soliciting responses and may require approval of the recommendation for award prior to award. 8 Reports to the funding agency are required before funds are reimbursed to the City. In the case of FTA funding for the Transit Division, the City requests funding reimbursements as funds are used. In addition, a description of every purchase is submitted for review by FTA to determine compliance with federal procurement requirements every three years. Proof of compliance by the City is required. In a past Triennial Review, a Federal Funding Checkoff form was submitted to correct deficiencies. The format was approved and is required for purchases using those funds.