The URL can be used to link to this page

Home My Public Portal About2017-02-09 packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, February 9, 2017 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the January 12, 2017 meeting 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. Fire Apparatus Discussion – Chief Schofield 7. Sales Tax G Budget Amendment – Margie Mueller 8. New Business 9. Old Business 10. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, January 12, 2017 MINUTES The meeting was called to order by the Finance Committee Vice Chairman, Councilman Mihalevich at 7:34 am. Roll call showed that Councilmen Mihalevich, Graham, Henry and Hussey were in attendance. Councilmen Prather was absent. Next the minutes of the November 10, 2016 meeting were reviewed. A motion to approve was made by Councilman Graham and seconded by Councilman Henry. The minutes were approved unanimously. The next item on the agenda was a report by the Finance Director, Margie Mueller, covering the Financial Reports. Ms. Mueller reviewed the Revenue Model, the January sales tax receipts, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the 4 Cent Lockbox Fund, is $3,582,395. The average monthly amount collected for the 4 Cent Lockbox Fund is $52,085. A report comparing occupancy rates for 2016, 2015, 2014, 2013 and 2012 was included along with a report listing occupancy rates from other cities. The next item on the agenda was a discussion lead by the City Counselor, Ryan Moehlman, regarding a St. Patrick’s Day Festival District at Main and Bolivar streets. Discussion ensued regarding the fact that Chapter 4 of the City Code would need to be amended in order to allow for a Designated Festival District at Main and Bolivar. A motion was made to make the necessary code revisions and move to full council by Councilman Hussey and seconded by Councilman Henry. The motion passed unanimously. There was no new business to discuss. There was no old business to discuss. The meeting adjourned at 8:10 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:February 7, 2017 Re:Sales Tax Revenues The City received the February 1% Sales Tax in the amount of $806789 which is $16,981 less than projected for February. January thru February overage is $142,085 (1.26%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-16 Jan-17 $1,083,570 $924,504 $159,066 Dec-16 Feb-17 $806,789 $823,770 ($16,981) Jan-17 & Oct-Dec 16 Qtrly Mar-17 $1,129,724 Feb-17 Apr-17 $951,232 Mar-17 May-17 $731,839 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $1,071,788 May-17 Jul-17 $1,069,247 Jun-17 Aug-17 $650,040 Jul-17 & Apr-June 17 Qtrly Sep-17 $1,195,077 Aug-17 Oct-17 $969,353 Sep-17 Nov-17 $959,772 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $823,654 Total Overage/Shortfall $11,300,000 $142,085 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax F & G combined Receipt Actual Budget Period Receipts Projection2 Variance Nov-16 Jan-00 Jan-17 $525,521 $396,801 $128,721 Dec-16 Jan-00 Feb-17 $402,964 $353,565 $49,399 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $484,882 Feb-17 Jan-00 Apr-17 $408,272 Mar-17 Jan-00 May-17 $314,108 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $460,015 May-17 Jan-00 Jul-17 $458,924 Jun-17 Jan-00 Aug-17 $278,999 Jul-17 & Apr-June 17 Qtrly Sep-17 $512,931 Aug-17 Jan-00 Oct-17 $416,050 Sep-17 Jan-00 Nov-17 $411,938 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $353,515 Total Overage/Shortfall $4,850,000 $178,120 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-16 Jan-00 Jan-17 $525,521 $415,075 $110,446 Dec-16 Jan-00 Feb-17 $395,217 $369,848 $25,369 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $507,213 Feb-17 Jan-00 Apr-17 $427,075 Mar-17 Jan-00 May-17 $328,574 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $481,201 May-17 Jan-00 Jul-17 $480,060 Jun-17 Jan-00 Aug-17 $291,848 Jul-17 & Apr-June 17 Qtrly Sep-17 $536,554 Aug-17 Jan-00 Oct-17 $435,211 Sep-17 Jan-00 Nov-17 $430,909 Oct-17 & Jul-Sept 17 Qtrly Dec-17 $369,796 Total Overage/Shortfall $5,073,365 $135,815 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 2/7/2017 Account Name General Fund Sales Tax Receipt Month: FEBRUARY 2017 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 843,061 764,659 741,056 944,619 $ 929,178.75 1,083,570 act.844,515 Dec February 619,287 703,181 789,830 727,437 $ 812,670.24 806,789 act.730,481 Jan & Oct-Dec Qtrly March 992,559 1,008,111 920,599 1,091,021 $ 1,183,675.38 1,129,724 est.1,039,193 Feb April 852,653 777,424 737,482 1,059,943 $ 893,023.78 951,232 est.864,105 Mar May 530,069 537,141 802,765 618,854 $ 648,305.45 731,839 est.627,427 Apr & Jan-Mar Qtrly June 1,028,514 1,023,015 865,930 1,045,933 $ 1,119,566.03 1,071,788 est.1,016,592 May July 797,785 872,436 1,048,754 963,280 $ 1,012,207.36 1,069,247 est.938,892 Jun August 557,032 546,351 614,048 562,996 $ 661,517.72 650,040 est.588,389 Jul & Apr-Jun Qtrly September 1,069,414 1,096,581 996,272 1,185,891 $ 1,197,976.41 1,195,077 est.1,109,227 Aug October 769,129 717,262 919,035 918,839 $ 903,829.48 969,353 est.845,619 Sept November 615,421 677,366 651,080 661,849 $ 623,644.91 959,772 est.645,872 Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 $ 1,016,681.71 823,654 est.1,004,542 Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 1,890,359 Estimated to Fiscal Year end (based on averages and on Budgeted amount)9,551,726 Total Actual & Estimated $ 11,442,085 Less: Budget 11,300,000 Over (Under) Budget $ 142,085 $ 1,083,570 $ 1,890,359 $ 924,504 $ 1,748,274 $ 2,877,998 $ 3,829,230 $ 4,561,069 $ 5,632,857 $ 6,702,104 $ 7,352,144 $ 8,547,221 $ 9,516,574 $ 10,476,346 $ 11,300,000 $ 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$ 11,250,000$ 11,500,000$ 11,750,000$ 12,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 2/7/2017 Account Name Capital Imprs Sales Tax Receipt Month: FEBRUARY 2017 Account Number 44-100-400010/45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 412,434 372,459 359,800 461,560 $ 455,278.00 525,521 act.412,306 Dec February 308,567 350,813 394,475 362,597 $ 405,542.89 402,964 act.364,399 Jan & Oct-Dec Qtrly March 466,856 475,110 423,641 511,685 $ 563,056.17 484,882 est.488,070 Feb April 409,365 372,340 348,172 512,808 $ 431,352.82 408,272 est.414,808 Mar May 263,902 266,422 399,863 308,247 $ 322,957.32 314,108 est.312,278 Apr & Jan-Mar Qtrly June 494,757 483,070 416,943 496,466 $ 539,529.28 460,015 est.486,153 May July 389,423 425,325 503,869 473,120 $ 498,228.87 458,924 est.457,993 Jun August 278,231 272,603 306,157 280,733 $ 330,112.03 278,999 est.293,567 Jul & Apr-Jun Qtrly September 504,307 521,260 484,992 565,296 $ 570,133.50 512,931 est.529,198 Aug October 367,366 357,619 430,185 442,371 $ 435,415.92 416,050 est.406,591 Sept November 306,968 323,871 324,697 330,393 $ 310,506.00 411,938 est.319,287 Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 $ 494,217.51 353,515 est.481,523 Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 928,485 Estimated to Fiscal Year end (based on averages and on Budgeted amount)4,099,635 Total Actual & Estimated $ 5,028,120 Less: Budget 4,850,000 Over (Under) Budget $ 178,120 $ 525,521 $ 928,485 $ 396,801 $ 750,365 $ 1,235,247 $ 1,643,519 $ 1,957,627 $ 2,417,642 $ 2,876,567 $ 3,155,566 $ 3,668,497 $ 4,084,547 $ 4,496,485 $ 4,850,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 2/7/2017 Account Name Parks Sales Tax Receipt Month: FEBRUARY 2017 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 405,730 372,447 359,708 461,472 $ 455,239.00 525,521 act.410,919 Dec February 308,456 350,714 393,562 362,371 $ 405,542.91 395,217 act.364,129 Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 $ 563,039.19 507,213 est.487,981 Feb April 409,353 372,242 348,076 512,738 $ 431,352.57 427,075 est.414,752 Mar May 263,822 266,456 398,085 308,030 $ 322,957.44 328,574 est.311,870 Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 $ 539,528.94 481,201 est.485,975 May July 389,006 425,194 503,790 473,038 $ 498,228.56 480,060 est.457,851 Jun August 278,072 272,321 305,930 280,513 $ 330,111.85 291,848 est.293,390 Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 $ 572,847.39 536,554 est.530,007 Aug October 366,846 357,482 430,093 442,370 $ 435,416.02 435,211 est.406,441 Sept November 306,831 323,768 324,481 330,393 $ 310,506.09 430,909 est.319,196 Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 $ 494,217.74 369,796 est.481,415 Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 920,739 Estimated to Fiscal Year end (based on averages and on Budgeted amount)4,288,442 Total Actual & Estimated $ 5,209,181 Less: Budget 5,073,365 Over (Under) Budget $ 135,815 $ 525,521 $ 920,739 $ 415,075 $ 784,923 $ 1,292,136 $ 1,719,211 $ 2,047,785 $ 2,528,986 $ 3,009,046 $ 3,300,895 $ 3,837,449 $ 4,272,660 $ 4,703,569 $ 5,073,365 $ 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 January 31, 2017 Data as of February 3, 2017 FY 2017 YTD Actual Projected Over/ Description Budget As of 2/3/17 (Under) Budget Sales Tax and Use Tax $11,300,000.00 $1,083,570.26 $159,065.99 Intergovernmental Taxes $2,220,000.00 $138,766.93 $8,257.12 Other Taxes $116,000.00 $19,645.16 ($36.24) Franchise & Utility Tax $7,500,000.00 $1,113,137.37 $45,600.57 Property Taxes $5,274,699.00 $5,190,630.13 $134,863.16 Intergovernmental $0.00 $350.09 $350.09 Charges for Services $2,715,993.65 $1,769,890.79 ($109,401.07) Fees, Licenses, & Permits $708,400.00 $149,961.82 ($7,160.71) Fines & Forfeitures $1,009,100.00 $177,667.46 ($57,824.64) Contributions/Donations $306,950.00 $35,480.76 $5,780.76 Other Operating Revenues $84,181.25 $41,527.86 $31,026.31 Interest Income $110,000.00 $24,468.68 $11,661.39 Other Non Operating Revenue $54,000.00 $34,000.00 $0.00 Operating Transfers In $23,800.00 $4,184.53 $624.95 Totals $31,423,123.90 $9,783,281.84 $222,807.66 FY2017 Revenue Model Report (Detail)Remaining For Period Ending January 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/3/17 As of 2/3/17 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $11,300,000.00 $1,083,570.26 $10,375,495.73 $11,459,065.99 $159,065.99 $159,065.99 $11,300,000.00 $1,083,570.26 $10,375,495.73 $11,459,065.99 $159,065.99 $159,065.99Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $550,000.00 $43,898.32 $501,918.14 $545,816.46 ($4,183.54)($4,183.54) 10-100-403010 Gasoline Tax $1,120,000.00 $94,868.61 $1,037,572.06 $1,132,440.67 $12,440.67 $12,440.67 10-100-430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00 $2,220,000.00 $138,766.93 $2,089,490.19 $2,228,257.12 $8,257.12 $8,257.12Other Taxes 10-100-403020 Cig Tax $116,000.00 $19,645.16 $96,318.60 $115,963.76 ($36.24)($36.24) $116,000.00 $19,645.16 $96,318.60 $115,963.76 ($36.24)($36.24)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $4,000,000.00 $534,507.42 $3,484,000.91 $4,018,508.33 $18,508.33 $18,508.33 10-100-410030 Gas Utility License Tax $1,000,000.00 $147,448.70 $816,705.63 $964,154.33 ($35,845.67)($35,845.67) 10-100-410052 Telephone/Cell Utility $2,070,000.00 $348,349.30 $1,721,914.66 $2,070,263.96 $263.96 $263.96 10-100-410053 Telephone/Cell Audit $0.00 ($16,210.20)$0.00 ($16,210.20)($16,210.20)($16,210.20) 10-100-410060 Cable Franchise Fee $430,000.00 $99,042.15 $409,842.00 $508,884.15 $78,884.15 $78,884.15 $7,500,000.00 $1,113,137.37 $6,432,463.20 $7,545,600.57 $45,600.57 $45,600.57Property Taxes 10-100-420010 Current Property Tax $4,617,300.00 $4,586,292.36 $137,409.40 $4,723,701.76 $106,401.76 $106,401.76 10-100-420020 Del Property Tax $46,000.00 $12,521.47 $30,403.15 $42,924.62 ($3,075.38)($3,075.38) 10-100-420040 Fin Institution Tax $42,000.00 $53,356.45 $0.00 $53,356.45 $11,356.45 $11,356.45 10-100-420050 Prop Tax Int & Penalties $25,000.00 $4,168.92 $20,303.19 $24,472.11 ($527.89)($527.89) 10-100-420055 Surtax Receipts - County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10-100-420060 Surtax Receipts $465,000.00 $456,953.41 $13,639.43 $470,592.84 $5,592.84 $5,592.84 10-100-420080 Special Tax Rev $25,000.00 $22,938.24 $17,176.87 $40,115.11 $15,115.11 $15,115.11 $5,274,699.00 $5,190,630.13 $218,932.03 $5,409,562.16 $134,863.16 $134,863.16Intergovernmental 10-100-430040 Local Grant $0.00 $0.09 $0.00 $0.09 $0.09 $0.09 10-100-480020 NSP Rehab Sales $0.00 $350.00 $0.00 $350.00 $350.00 $350.00 10-100-480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $350.09 $0.00 $350.09 $350.09 $350.09 Charges for Services 10-100-440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $28,000.00 $4,893.00 $22,230.06 $27,123.06 ($876.94)($876.94) 10-100-440910 Fuel Charge - backs $11,000.00 $1,994.67 $7,886.32 $9,880.99 ($1,119.01)($1,119.01) 10-100-440920 Parts Charge backs $185,000.00 $7,603.61 $143,471.17 $151,074.78 ($33,925.22)($33,925.22) 10-100-440930 Labor Charge backs $240,000.00 $11,462.74 $182,254.07 $193,716.81 ($46,283.19)($46,283.19) 10-100-481020 Cole Cty Animal Rescue $105,508.00 $26,377.01 $79,131.00 $105,508.01 $0.01 $0.01 10-100-481030 Rent City Hall/Annex $35,000.00 $0.00 $0.00 $0.00 ($35,000.00)($35,000.00) 10-100-481040 Rent Other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $104,000.00 $12,654.33 $98,577.10 $111,231.43 $7,231.43 $7,231.43 10-100-481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-481075 Cole Cty 911 Reimb $366,423.91 $92,414.43 $273,721.51 $366,135.94 ($287.97)($287.97) 10-100-481080 Sale Of Maps/GIS Data $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $3,750.00 $11,250.00 $15,000.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $4,000.00 $2,448.00 $2,181.82 $4,629.82 $629.82 $629.82 10-100-481105 TIF Administration Fee $15,998.74 $230.00 $15,998.74 $16,228.74 $230.00 $230.00 10-100-481110 Long & Short $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,715,993.65 $1,769,890.79 $836,701.79 $2,606,592.58 ($109,401.07)($109,401.07)Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $66,000.00 $50.00 $64,815.05 $64,865.05 ($1,134.95)($1,134.95) 10-100-450020 Business Licenses $215,000.00 $32,332.41 $140,639.20 $172,971.61 ($42,028.39)($42,028.39) 10-100-450021 Home Occupation Permit $1,600.00 $371.02 $1,224.64 $1,595.66 ($4.34)($4.34) 10-100-450040 Abandoned Bldg. Regist.$0.00 $7,625.00 $0.00 $7,625.00 $7,625.00 $7,625.00 10-100-450041 Abandoned Bldg. Admin Fee $6,500.00 $22,322.00 $5,875.22 $28,197.22 $21,697.22 $21,697.22 10-100-450045 Building Construct. Fees $150,000.00 $28,200.03 $121,867.31 $150,067.34 $67.34 $67.34 10-100-450050 Electrical Certificates $19,000.00 $14,367.00 $3,626.07 $17,993.07 ($1,006.93)($1,006.93) 10-100-450060 Electrical Permits $4,000.00 $542.29 $3,214.58 $3,756.87 ($243.13)($243.13) 10-100-450070 Plumbing Licenses $10,500.00 $7,596.00 $2,734.53 $10,330.53 ($169.47)($169.47) 10-100-450080 Plumbing Permits $4,000.00 $790.00 $3,065.06 $3,855.06 ($144.94)($144.94) 10-100-450090 Other Lic & Permits $2,000.00 $631.00 $1,648.78 $2,279.78 $279.78 $279.78 10-100-450091 Day Care Inspection Fees $7,000.00 $1,290.00 $5,606.18 $6,896.18 ($103.82)($103.82) 10-100-450092 Food Inspection Fees $85,000.00 $4,741.07 $84,611.17 $89,352.24 $4,352.24 $4,352.24 10-100-450100 Curb Cut Permits $800.00 $212.00 $640.48 $852.48 $52.48 $52.48 FY2017 Revenue Model Report (Detail)Remaining For Period Ending January 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 2/3/17 As of 2/3/17 TOTAL (Under) Budget of Formulas 10-100-450110 Board Of Adj Fees $1,300.00 $420.00 $886.57 $1,306.57 $6.57 $6.57 10-100-450120 Sign Permits $5,100.00 $1,083.00 $4,298.47 $5,381.47 $281.47 $281.47 10-100-450130 Demolition Permits $900.00 $212.00 $645.58 $857.58 ($42.42)($42.42) 10-100-450150 Acc Rep Fees-police $11,200.00 $2,346.00 $8,547.24 $10,893.24 ($306.76)($306.76) 10-100-450160 Accrpt/blastg P-fire $900.00 $14.00 $789.29 $803.29 ($96.71)($96.71) 10-100-450170 Animal Redemption Fees $60,000.00 $12,695.00 $47,422.57 $60,117.57 $117.57 $117.57 10-100-450180 Animal Vaccinations Fees $4,300.00 $1,200.00 $3,612.00 $4,812.00 $512.00 $512.00 10-100-450185 Animal Cremation Fees $30,000.00 $6,907.00 $24,316.33 $31,223.33 $1,223.33 $1,223.33 10-100-450190 Taxi Permits $700.00 $78.00 $644.65 $722.65 $22.65 $22.65 10-100-450230 Vacating Right Of Way $800.00 $399.00 $479.45 $878.45 $78.45 $78.45 10-100-450250 Rezoning Request $12,000.00 $790.00 $12,000.00 $12,790.00 $790.00 $790.00 10-100-450255 Planning & Zoning Review Fees $8,000.00 $2,703.00 $6,278.79 $8,981.79 $981.79 $981.79 10-100-450260 Non-refundable Plans/spec $1,800.00 $45.00 $1,788.26 $1,833.26 $33.26 $33.26 $708,400.00 $149,961.82 $551,277.47 $701,239.29 ($7,160.71)($7,160.71)Fines & Forfeitures 10-100-460010 Court Cost $75,500.00 $15,969.84 $57,244.71 $73,214.55 ($2,285.45)($2,285.45) 10-100-460015 Court Restitutions $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00) 10-100-460018 Inmate Security Fund $12,500.00 $2,641.32 $9,587.80 $12,229.12 ($270.88)($270.88) 10-100-460020 Jail Cost Recovery $4,000.00 $353.82 $2,849.27 $3,203.09 ($796.91)($796.91) 10-100-460025 Alcohol Offense Cost Rec $8,000.00 $1,876.50 $6,522.99 $8,399.49 $399.49 $399.49 10-100-460030 Pol Fines-traffic $860,000.00 $146,381.97 $661,684.51 $808,066.48 ($51,933.52)($51,933.52) 10-100-460090 Parking Fines $53,000.00 $10,871.55 $39,152.72 $50,024.27 ($2,975.73)($2,975.73) 10-100-460100 Bankcard Charges ($3,900.00)($417.54)($3,434.11)($3,851.65)$48.35 $48.35 $1,009,100.00 $177,667.46 $773,607.90 $951,275.36 ($57,824.64)($57,824.64)Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $700.00 $0.00 $700.00 $700.00 $700.00 10-100-480070 Community Projects Donations $4,200.00 $4,200.00 $0.00 $4,200.00 $0.00 $0.00 10-100-480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10-100-480090 Police K-9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00 10-100-480165 Animal S Donations $0.00 $4,580.76 $0.00 $4,580.76 $4,580.76 $4,580.76 10-100-481055 Street Repair-Solid Waste Cntr $302,250.00 $25,000.00 $277,250.00 $302,250.00 $0.00 $0.00 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $306,950.00 $35,480.76 $277,250.00 $312,730.76 $5,780.76 $5,780.76 Other Operating Revenues 10-100-480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $35,000.00 $12,881.12 $32,600.40 $45,481.52 $10,481.52 $10,481.52 10-100-481072 TIF Prof Svcs Deposit $1,181.25 $21,582.50 $0.00 $21,582.50 $20,401.25 $20,401.25 10-100-481074 Revenue Share - Purchasing Card $18,000.00 $2,356.24 $14,705.31 $17,061.55 ($938.45)($938.45) 10-100-481077 Insurance Claims $20,000.00 $4,708.00 $16,373.98 $21,081.98 $1,081.98 $1,081.98 10-100-481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,181.25 $41,527.86 $73,679.70 $115,207.56 $31,026.31 $31,026.31 Interest Income 10-100-470010 Interest $110,000.00 $24,468.68 $97,192.71 $121,661.39 $11,661.39 $11,661.39 $110,000.00 $24,468.68 $97,192.71 $121,661.39 $11,661.39 $11,661.39Other Non Operating Revenue 10-100-485050 Sale Of Assets $54,000.00 $34,000.00 $20,000.00 $54,000.00 $0.00 $0.00 $54,000.00 $34,000.00 $20,000.00 $54,000.00 $0.00 $0.00Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $23,800.00 $4,184.53 $20,240.42 $24,424.95 $624.95 $624.95 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23,800.00 $4,184.53 $20,240.42 $24,424.95 $624.95 $624.95 $31,423,123.90 $9,783,281.84 $21,862,649.72 $31,645,931.56 $222,807.66 $222,807.66 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 02/03/17 08:09:01 Period 01 - 13 Fiscal Year 2017 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Revenue Revenue 100 Revenue 10-100-400010 Sales Tax 11,300,000.00 1,083,570.26 0.00 10,216,429.74 90.41 10-100-400020 Sales Tax Interest 0.00 0.00 0.00 0.00 0.00 R10 Sales & Use Taxes 11,300,000.00 1,083,570.26 0.00 10,216,429.74 90.41 10-100-401030 Motor Vehicle Tax 550,000.00 43,898.32 0.00 506,101.68 92.02 10-100-403010 Gasoline Tax 1,120,000.00 94,868.61 0.00 1,025,131.39 91.53 10-100-430080 Road & Bridge Tax 550,000.00 0.00 0.00 550,000.00 100.00 R16 Intergovernmental Taxes 2,220,000.00 138,766.93 0.00 2,081,233.07 93.75 10-100-403020 Cigarette Tax 116,000.00 19,645.16 0.00 96,354.84 83.06 R20 Other Taxes 116,000.00 19,645.16 0.00 96,354.84 83.06 10-100-410020 Electric Utility Lic Tax 4,000,000.00 534,507.42 0.00 3,465,492.58 86.64 10-100-410021 Electric Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 10-100-410030 Gas Utility License Tax 1,000,000.00 147,448.70 0.00 852,551.30 85.26 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,070,000.00 348,349.30 0.00 1,721,650.70 83.17 10-100-410053 TelephoneCell Utility-AUDIT 0.00 -16,210.20 0.00 16,210.20 0.00 10-100-410060 Cable Franchise Fee 430,000.00 99,042.15 0.00 330,957.85 76.97 10-100-410061 Cable Utility-AUDIT 0.00 0.00 0.00 0.00 0.00 R30 Franchise & Utility Tax 7,500,000.00 1,113,137.37 0.00 6,386,862.63 85.16 10-100-420010 Cur Property Tax 4,617,300.00 4,586,292.36 0.00 31,007.64 0.67 10-100-420020 Del Property Tax 46,000.00 12,521.47 0.00 33,478.53 72.78 10-100-420040 Fin Inst Tax 42,000.00 53,356.45 0.00 -11,356.45 -27.04 10-100-420050 Prop Tax Int & Penalties 25,000.00 4,168.92 0.00 20,831.08 83.32 10-100-420055 Surtax Receipts - County Reimb 54,399.00 54,399.28 0.00 -0.28 0.00 10-100-420060 Surtax Receipts 465,000.00 456,953.41 0.00 8,046.59 1.73 10-100-420080 Special Tax Rev 25,000.00 22,938.24 0.00 2,061.76 8.25 R40 Property Taxes 5,274,699.00 5,190,630.13 0.00 84,068.87 1.59 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-430010 Federal Grants 0.00 0.00 0.00 0.00 0.00 10-100-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-100-430040 Local Grants 0.00 0.09 0.00 -0.09 0.00 10-100-430060 Drug Forfeiture 0.00 0.00 0.00 0.00 0.00 10-100-430074 Overtime Reimb 0.00 0.00 0.00 0.00 0.00 10-100-430100 State DNR Historic Pres.0.00 0.00 0.00 0.00 0.00 10-100-480020 NSP Rehab Sales 0.00 350.00 0.00 -350.00 0.00 10-100-480025 HUD Program Income 0.00 0.00 0.00 0.00 0.00 R50 Intergovernmental 0.00 350.09 0.00 -350.09 0.00 10-100-440010 Admin Charge Backs 1,556,063.00 1,556,063.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 28,000.00 4,893.00 0.00 23,107.00 82.53 10-100-440910 Fuel Charge-backs 11,000.00 1,994.67 0.00 9,005.33 81.87 10-100-440920 Parts Charge-back 185,000.00 7,603.61 0.00 177,396.39 95.89 10-100-440930 Labor Charge-backs 240,000.00 11,462.74 0.00 228,537.26 95.22 10-100-450189 Animal Shelter Bricks 0.00 0.00 0.00 0.00 0.00 10-100-481020 Cole Cty Animal Rescue 105,508.00 26,012.83 0.00 79,495.17 75.35 10-100-481030 Rent City Hallannex 35,000.00 0.00 0.00 35,000.00 100.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 12,654.33 0.00 91,345.67 87.83 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 366,423.91 92,414.43 0.00 274,009.48 74.78 10-100-481080 Sale Of Mapsgis Data 0.00 0.00 0.00 0.00 0.00 10-100-481085 Cole Cty Gis Joint Coop 15,000.00 3,750.00 0.00 11,250.00 75.00 10-100-481090 Cole Cty Sheriff-New World 0.00 0.00 0.00 0.00 0.00 10-100-481100 Sale Of Grave Sites 4,000.00 2,448.00 0.00 1,552.00 38.80 10-100-481105 TIF Administration Fee 15,998.74 230.00 0.00 15,768.74 98.56 10-100-481110 Long & Short 0.00 0.00 0.00 0.00 0.00 R60 Charges for Services 2,715,993.65 1,769,526.61 0.00 946,467.04 34.85 10-100-450010 Liquor Licenses 66,000.00 50.00 0.00 65,950.00 99.92 10-100-450020 Business Licenses 215,000.00 32,332.41 0.00 182,667.59 84.96 10-100-450021 Home Occupation Permit 1,600.00 371.02 0.00 1,228.98 76.81 10-100-450030 Soliciters Licenses 0.00 0.00 0.00 0.00 0.00 10-100-450040 Abandoned Bldg Registration 0.00 7,625.00 0.00 -7,625.00 0.00 10-100-450041 Abandoned Bldg Admin Fee 6,500.00 22,322.00 0.00 -15,822.00 -243.42 10-100-450045 Bldg Constr Fees 150,000.00 28,200.03 0.00 121,799.97 81.20 10-100-450050 Electrical Certificates 19,000.00 14,367.00 0.00 4,633.00 24.38 10-100-450060 Electrical Permits 4,000.00 542.29 0.00 3,457.71 86.44 10-100-450070 Plumbing Licenses 10,500.00 7,596.00 0.00 2,904.00 27.66 10-100-450080 Plumbing Permits 4,000.00 790.00 0.00 3,210.00 80.25 10-100-450090 Other Lic & Permits 2,000.00 631.00 0.00 1,369.00 68.45 10-100-450091 Day Care Inspection Fees 7,000.00 1,290.00 0.00 5,710.00 81.57 10-100-450092 Food Inspection Fees 85,000.00 4,584.82 0.00 80,415.18 94.61 10-100-450100 Curb Cut Permits 800.00 212.00 0.00 588.00 73.50 10-100-450110 Board Of Adj Fees 1,300.00 420.00 0.00 880.00 67.69 10-100-450120 Sign Permits 5,100.00 1,083.00 0.00 4,017.00 78.76 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-100-450130 Demolition Permits 900.00 212.00 0.00 688.00 76.44 10-100-450150 Acc Rep Fees-police 11,200.00 2,346.00 0.00 8,854.00 79.05 10-100-450160 Accrptblastg P-fire 900.00 14.00 0.00 886.00 98.44 10-100-450170 Animal Redemption Fees 60,000.00 12,695.00 0.00 47,305.00 78.84 10-100-450180 Animal Vaccinations Fees 4,300.00 1,200.00 0.00 3,100.00 72.09 10-100-450185 Animal Cremation Fees 30,000.00 6,907.00 0.00 23,093.00 76.98 10-100-450186 Animal Boarding Fees 0.00 0.00 0.00 0.00 0.00 10-100-450190 Taxi Permits 700.00 78.00 0.00 622.00 88.86 10-100-450230 Vacating Right Of Way 800.00 399.00 0.00 401.00 50.13 10-100-450250 Rezoning Request 12,000.00 790.00 0.00 11,210.00 93.42 10-100-450255 Planning & Zoning Review Fees 8,000.00 2,703.00 0.00 5,297.00 66.21 10-100-450260 Non-refundable Plansspec 1,800.00 45.00 0.00 1,755.00 97.50 R65 Fees Licenses & Permits 708,400.00 149,805.57 0.00 558,594.43 78.85 10-100-460010 Court Cost 75,500.00 15,969.84 0.00 59,530.16 78.85 10-100-460015 Court Restitutions 0.00 -10.00 0.00 10.00 0.00 10-100-460018 Inmate Security Fund 12,500.00 2,641.32 0.00 9,858.68 78.87 10-100-460020 Jail Cost Recovery 4,000.00 353.82 0.00 3,646.18 91.15 10-100-460025 Alcohol Offense Cost Rec 8,000.00 1,876.50 0.00 6,123.50 76.54 10-100-460030 Pol Fines-traffic 860,000.00 146,381.97 0.00 713,618.03 82.98 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 10,871.55 0.00 42,128.45 79.49 10-100-460100 Bankcard Charges -3,900.00 -417.54 0.00 -3,482.46 89.29 R70 Fines & Forfeitures 1,009,100.00 177,667.46 0.00 831,432.54 82.39 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 700.00 0.00 -700.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 4,200.00 4,200.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 500.00 500.00 0.00 0.00 0.00 10-100-480165 Animal S Donations 0.00 4,580.76 0.00 -4,580.76 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 302,250.00 25,000.00 0.00 277,250.00 91.73 10-100-481095 Cemetery Donations 0.00 0.00 0.00 0.00 0.00 10-100-486070 Cap Contr-Neighborhood Imp Pro 0.00 0.00 0.00 0.00 0.00 R72 ContributionsDonations 306,950.00 35,480.76 0.00 271,469.24 88.44 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 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 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 12,827.12 0.00 22,172.88 63.35 10-100-481072 TIF Developer Reimbursements 1,181.25 21,582.50 0.00 -20,401.25 -1,727.09 10-100-481074 Revenue Share 18,000.00 2,356.24 0.00 15,643.76 86.91 10-100-481077 Insurance Claims 20,000.00 4,708.00 0.00 15,292.00 76.46 10-100-481078 Cafeteria Refunds 10,000.00 0.00 0.00 10,000.00 100.00 R75 Other Operating Revenues 84,181.25 41,473.86 0.00 42,707.39 50.73 10-100-470010 Interest 110,000.00 24,468.68 0.00 85,531.32 77.76 10-100-470051 Unrealized Gainslosses 0.00 0.00 0.00 0.00 0.00 R80 Interest Income 110,000.00 24,468.68 0.00 85,531.32 77.76 10-100-485049 Capvhcleqp-sale Of Assets 0.00 0.00 0.00 0.00 0.00 10-100-485050 Sale Of Assets 54,000.00 34,000.00 0.00 20,000.00 37.04 R85 Other Non-Operating Revenue 54,000.00 34,000.00 0.00 20,000.00 37.04 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 4,184.53 0.00 19,615.47 82.42 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 0.00 0.00 0.00 0.00 0.00 R90 Transfers In 23,800.00 4,184.53 0.00 19,615.47 82.42 10-100-495995 Transfer From(to) Surplus 480,536.13 0.00 0.00 480,536.13 100.00 10-100-495996 Trnasfer From(To) Surplus 0.00 0.00 0.00 0.00 0.00 R99 Carry Over Surplus 480,536.13 0.00 0.00 480,536.13 100.00 100 Revenue 31,903,660.03 9,782,707.41 0.00 22,120,952.62 69.34 149 Entitlement Grant 10-149-430010 Federal Grants 463,024.67 6,716.02 0.00 456,308.65 98.55 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 463,024.67 6,716.02 0.00 456,308.65 98.55 149 Entitlement Grant 463,024.67 6,716.02 0.00 456,308.65 98.55 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 (02/03/2017 - 8:09 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 300 Police Department 10-300-430010 Federal Grants 16,504.00 0.00 0.00 16,504.00 100.00 10-300-430020 State Grants 35,000.00 0.00 0.00 35,000.00 100.00 10-300-430040 Local Grants 0.00 0.00 0.00 0.00 0.00 10-300-430074 Overtime Reimb 48,513.77 2,492.67 0.00 46,021.10 94.86 R50 Intergovernmental 100,017.77 2,492.67 0.00 97,525.10 97.51 300 Police Department 100,017.77 2,492.67 0.00 97,525.10 97.51 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 194,541.30 0.00 0.00 194,541.30 100.00 R50 Intergovernmental 194,541.30 0.00 0.00 194,541.30 100.00 310 School Resource Officer 194,541.30 0.00 0.00 194,541.30 100.00 320 M.U.S.T.A.N.G. 10-320-430010 Federal Grants 39,329.20 1,635.50 0.00 37,693.70 95.84 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 4,814.99 0.00 -4,814.99 0.00 R50 Intergovernmental 39,329.20 6,450.49 0.00 32,878.71 83.60 320 M.U.S.T.A.N.G.39,329.20 6,450.49 0.00 32,878.71 83.60 400 Fire Department 10-400-430010 Federal Grant 2,500.00 0.00 0.00 2,500.00 100.00 10-400-430040 Local Grants 0.00 1,200.00 0.00 -1,200.00 0.00 R50 Intergovernmental 2,500.00 1,200.00 0.00 1,300.00 52.00 400 Fire Department 2,500.00 1,200.00 0.00 1,300.00 52.00 520 Plan & Protect Svcs-Admin 10-520-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 520 Plan & Protect Svcs-Admin 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 10-522-430010 Federal Grants 376,825.72 12,008.00 0.00 364,817.72 96.81 10-522-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-522-430040 Local Grants 20,064.70 0.00 0.00 20,064.70 100.00 R50 Intergovernmental 396,890.42 12,008.00 0.00 384,882.42 96.97 522 Plan & Protect Svcs-MPO 396,890.42 12,008.00 0.00 384,882.42 96.97 530 Plan & Protect Svc-RedevGrant GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-430010 Federal Grants 48,480.00 0.00 0.00 48,480.00 100.00 10-530-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-530-430040 Local Grants 20,500.00 6,168.75 0.00 14,331.25 69.91 R50 Intergovernmental 68,980.00 6,168.75 0.00 62,811.25 91.06 530 Plan & Protect Svc-RedevGrant 68,980.00 6,168.75 0.00 62,811.25 91.06 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 521,246.26 120,254.84 0.00 400,991.42 76.93 10-990-430020 State Grants 0.00 0.00 0.00 0.00 0.00 10-990-430040 Local Grants 0.00 14,870.99 0.00 -14,870.99 0.00 R50 Intergovernmental 521,246.26 135,125.83 0.00 386,120.43 74.08 990 Capital Projects 521,246.26 135,125.83 0.00 386,120.43 74.08 Revenue Revenue 33,690,189.65 9,952,869.17 0.00 23,737,320.48 70.46 Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 64,800.00 15,300.00 0.00 49,500.00 76.39 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-110-502010 Social Security 4,957.20 1,136.16 0.00 3,821.04 77.08 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 16,473.63 0.00 53,321.04 76.40 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-110-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-110-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-110-513010 Office Supplies 500.00 404.70 0.00 95.30 19.06 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 900.00 404.70 0.00 495.30 55.03 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 124.29 0.00 1,375.71 91.71 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 180.00 0.00 1,220.00 87.14 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 (02/03/2017 - 8:09 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,012.19 0.00 2,987.81 37.35 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 75.00 17.55 52.65 4.80 6.40 E25 Repairs & Maintenance 75.00 17.55 52.65 4.80 6.40 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 78,769.67 21,908.07 52.65 56,808.95 72.12 120 City Clerk 10-120-501020 Salaries 65,500.58 14,431.27 0.00 51,069.31 77.97 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,010.79 1,047.34 0.00 3,963.45 79.10 10-120-502020 Group Health Insurance 4,427.58 3,181.28 0.00 1,246.30 28.15 10-120-502030 Retirement 9,694.09 2,135.80 0.00 7,558.29 77.97 10-120-502040 Workers Compensation 33.57 33.57 0.00 0.00 0.00 10-120-502050 Life Insurance 129.25 22.65 0.00 106.60 82.48 10-120-502060 Long Term Disability 203.17 50.02 0.00 153.15 75.38 10-120-502070 Employee Assistance Prgm 34.84 8.09 0.00 26.75 76.78 E05 Personnel Services 85,033.87 20,910.02 0.00 64,123.85 75.41 10-120-511020 Postage 200.00 89.16 0.00 110.84 55.42 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 24.85 0.00 275.15 91.72 10-120-513010 Office Supplies 500.00 106.27 0.00 393.73 78.75 E10 Materials & Supplies 1,000.00 220.28 0.00 779.72 77.97 10-120-520030 Dues And Publications 275.00 0.00 0.00 275.00 100.00 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 1,000.00 12.00 0.00 988.00 98.80 10-120-522020 Professional Services 400.00 60.00 0.00 340.00 85.00 10-120-529030 Election Expense 30,000.00 0.00 0.00 30,000.00 100.00 E15 Contractual Services 31,675.00 72.00 0.00 31,603.00 99.77 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 295.00 17.55 52.65 224.80 76.20 E25 Repairs & Maintenance 295.00 17.55 52.65 224.80 76.20 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 (02/03/2017 - 8:09 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 118,003.87 21,219.85 52.65 96,731.37 81.97 140 City Administrator 10-140-501020 Salaries 208,452.50 52,107.33 0.00 156,345.17 75.00 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,616.69 2,401.81 0.00 14,214.88 85.55 10-140-502020 Group Health Insurance 20,053.89 5,887.33 0.00 14,166.56 70.64 10-140-502030 Retirement 33,358.22 6,047.86 0.00 27,310.36 81.87 10-140-502040 Workers Compensation 85.32 85.32 0.00 0.00 0.00 10-140-502050 Life Insurance 199.76 38.38 0.00 161.38 80.79 10-140-502060 Long Term Disability 412.24 86.79 0.00 325.45 78.95 10-140-502070 Employee Assistance Prgm 52.39 12.16 0.00 40.23 76.79 E05 Personnel Services 279,231.01 66,666.98 0.00 212,564.03 76.12 10-140-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-140-511020 Postage 250.00 25.57 0.00 224.43 89.77 10-140-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-140-512020 Copies 250.00 21.81 0.00 228.19 91.28 10-140-513010 Office Supplies 850.00 22.44 0.00 827.56 97.36 10-140-517010 Operational Supplies 1,000.00 0.00 0.00 1,000.00 100.00 E10 Materials & Supplies 3,050.00 69.82 0.00 2,980.18 97.71 10-140-520030 Dues And Publications 1,800.00 100.00 0.00 1,700.00 94.44 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 3,000.00 2,190.00 0.00 810.00 27.00 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 58.47 0.00 741.53 92.69 E15 Contractual Services 5,600.00 2,348.47 0.00 3,251.53 58.06 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 220.00 17.55 52.65 149.80 68.09 E25 Repairs & Maintenance 220.00 17.55 52.65 149.80 68.09 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 288,101.01 69,102.82 52.65 218,945.54 76.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 149 Entitlement Grant 10-149-501020 Salaries 19,098.96 4,593.59 0.00 14,505.37 75.95 10-149-501050 Parttime(wo Benefits)20,000.00 0.00 0.00 20,000.00 100.00 10-149-502010 Social Security 2,991.07 331.17 0.00 2,659.90 88.93 10-149-502020 Group Health Insurance 3,238.50 1,281.82 0.00 1,956.68 60.42 10-149-502030 Retirement 2,826.65 599.97 0.00 2,226.68 78.77 10-149-502040 Workers Compensation 30.00 0.00 0.00 30.00 100.00 10-149-502050 Life Insurance 37.21 8.49 0.00 28.72 77.18 10-149-502060 Long Term Disability 58.75 15.99 0.00 42.76 72.78 10-149-502070 Employee Assistance Program 13.10 3.04 0.00 10.06 76.79 E05 Personnel Services 48,294.24 6,834.07 0.00 41,460.17 85.85 10-149-511010 Advertising 1,500.00 0.00 0.00 1,500.00 100.00 10-149-511020 Postage 500.00 28.46 0.00 471.54 94.31 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-149-517010 Operational Supplies 525.00 67.94 0.00 457.06 87.06 E10 Materials & Supplies 3,525.00 96.40 0.00 3,428.60 97.27 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 3,000.00 2,516.02 0.00 483.98 16.13 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 30,198.00 33.00 0.00 30,165.00 99.89 10-149-528012 Housing Rehab-Energy Efficienc 30,198.00 0.00 0.00 30,198.00 100.00 10-149-528020 Housing Assistance 25,540.00 5,000.00 0.00 20,540.00 80.42 10-149-528030 Public Improvement 167,785.96 0.00 0.00 167,785.96 100.00 10-149-528040 Neighborhood Redevelopmnt 114,000.00 0.00 0.00 114,000.00 100.00 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,000.00 0.00 0.00 5,000.00 100.00 10-149-528080 Homeless Objectives 35,133.47 816.65 0.00 34,316.82 97.68 E15 Contractual Services 410,855.43 8,365.67 0.00 402,489.76 97.96 10-149-547020 Maintenance Agreements 350.00 43.49 76.32 230.19 65.77 E25 Repairs & Maintenance 350.00 43.49 76.32 230.19 65.77 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 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 149 Entitlement Grant 463,024.67 15,339.63 76.32 447,608.72 96.67 150 City Counselor 10-150-501020 Salaries 226,107.86 51,613.20 0.00 174,494.66 77.17 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 (02/03/2017 - 8:09 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,297.25 3,747.79 0.00 13,549.46 78.33 10-150-502020 Group Health Insurance 38,273.07 9,588.49 0.00 28,684.58 74.95 10-150-502030 Retirement 33,463.96 7,638.75 0.00 25,825.21 77.17 10-150-502040 Workers Compensation 160.76 160.76 0.00 0.00 0.00 10-150-502050 Life Insurance 444.56 89.04 0.00 355.52 79.97 10-150-502060 Long Term Disability 635.04 157.46 0.00 477.58 75.20 10-150-502070 Employee Assistance Prgm 87.49 20.31 0.00 67.18 76.79 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 316,469.99 73,015.80 0.00 243,454.19 76.93 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 2.76 0.00 597.24 99.54 10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-150-512020 Copies 300.00 0.00 0.00 300.00 100.00 10-150-513010 Office Supplies 1,800.00 72.67 0.00 1,727.33 95.96 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,850.00 75.43 0.00 2,774.57 97.35 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,000.00 2,044.23 4,620.00 4,335.77 39.42 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 6,000.00 0.00 0.00 6,000.00 100.00 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 2,500.00 0.00 0.00 2,500.00 100.00 10-150-522020 Professional Services 5,650.00 30.61 0.00 5,619.39 99.46 10-150-525030 Court Cost & Witness Fees 75.00 0.00 0.00 75.00 100.00 E15 Contractual Services 25,225.00 2,074.84 4,620.00 18,530.16 73.46 10-150-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-150-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-150-547020 Maintenance Agreements 625.00 17.55 52.65 554.80 88.77 E25 Repairs & Maintenance 625.00 17.55 52.65 554.80 88.77 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 345,169.99 75,183.62 4,672.65 265,313.72 76.86 160 Municipal Court 10-160-501010 Salary-elected Officals 59,999.88 14,999.97 0.00 44,999.91 75.00 10-160-501020 Salaries 100,670.13 19,491.21 0.00 81,178.92 80.64 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)17,068.99 1,093.75 0.00 15,975.24 93.59 10-160-501090 Overtime 3,000.00 1,324.59 0.00 1,675.41 55.85 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,826.53 2,724.92 0.00 11,101.61 80.29 10-160-502020 Group Health Insurance 20,227.17 2,863.95 0.00 17,363.22 85.84 10-160-502030 Retirement 15,343.18 1,790.09 0.00 13,553.09 88.33 10-160-502040 Workers Compensation 106.42 106.42 0.00 0.00 0.00 10-160-502050 Life Insurance 199.76 19.41 0.00 180.35 90.28 10-160-502060 Long Term Disability 312.11 36.23 0.00 275.88 88.39 10-160-502070 Employee Assistance Prgm 61.03 14.16 0.00 46.87 76.80 E05 Personnel Services 230,815.20 44,464.70 0.00 186,350.50 80.74 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,800.00 631.32 0.00 3,168.68 83.39 10-160-512010 Printing 1,090.00 0.00 0.00 1,090.00 100.00 10-160-512020 Copies 500.00 29.30 0.00 470.70 94.14 10-160-513010 Office Supplies 3,500.00 900.73 0.00 2,599.27 74.26 E10 Materials & Supplies 8,890.00 1,561.35 0.00 7,328.65 82.44 10-160-520025 Security 7,000.00 2,211.99 0.00 4,788.01 68.40 10-160-520030 Dues And Publications 450.00 60.00 0.00 390.00 86.67 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 34.56 0.00 2,465.44 98.62 10-160-522020 Professional Services 4,500.00 595.02 0.00 3,904.98 86.78 10-160-525005 Appointed Counsel 7,000.00 262.50 0.00 6,737.50 96.25 10-160-525010 Care Of Prisoners 2,000.00 0.00 0.00 2,000.00 100.00 10-160-525030 Court Cost & Witness Fees 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 23,490.00 3,164.07 0.00 20,325.93 86.53 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 730.00 17.55 52.65 659.80 90.38 E25 Repairs & Maintenance 730.00 17.55 52.65 659.80 90.38 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 269,488.44 49,207.67 5,615.89 214,664.88 79.66 170 Human Resources 10-170-501020 Salaries 187,788.56 46,303.21 0.00 141,485.35 75.34 10-170-501050 Parttime(wo Benefits)38,932.80 3,072.24 0.00 35,860.56 92.11 10-170-501090 Overtime 300.00 0.00 0.00 300.00 100.00 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 17,367.13 3,761.88 0.00 13,605.25 78.34 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502020 Group Health Insurance 19,329.42 4,859.93 0.00 14,469.49 74.86 10-170-502030 Retirement 27,837.11 6,852.85 0.00 20,984.26 75.38 10-170-502040 Workers Compensation 94.53 94.53 0.00 0.00 0.00 10-170-502050 Life Insurance 370.14 84.24 0.00 285.90 77.24 10-170-502060 Long Term Disability 521.91 143.57 0.00 378.34 72.49 10-170-502070 Employee Assistance Prgm 78.58 18.24 0.00 60.34 76.79 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 292,620.18 65,190.69 0.00 227,429.49 77.72 10-170-511010 Advertising 150.00 0.00 0.00 150.00 100.00 10-170-511020 Postage 300.00 13.42 0.00 286.58 95.53 10-170-512010 Printing 1,000.00 0.00 0.00 1,000.00 100.00 10-170-512020 Copies 500.00 52.99 0.00 447.01 89.40 10-170-513010 Office Supplies 1,200.00 0.00 0.00 1,200.00 100.00 10-170-517010 Operational Supplies 750.00 6.61 0.00 743.39 99.12 E10 Materials & Supplies 3,900.00 73.02 0.00 3,826.98 98.13 10-170-520030 Dues And Publications 1,468.00 0.00 0.00 1,468.00 100.00 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 252.18 0.00 3,247.82 92.79 10-170-520070 Training And Education 5,220.00 36.65 0.00 5,183.35 99.30 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 100.00 0.00 840.00 89.36 10-170-522020 Professional Services 2,000.00 128.44 0.00 1,871.56 93.58 10-170-529010 Special Events 1,000.00 0.00 0.00 1,000.00 100.00 10-170-529015 Human Rights Commission 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,128.00 517.27 0.00 13,610.73 96.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 220.00 17.55 52.65 149.80 68.09 E25 Repairs & Maintenance 220.00 17.55 52.65 149.80 68.09 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 310,868.18 65,798.53 52.65 245,017.00 78.82 180 Finance Department 10-180-501020 Salaries 614,666.09 149,328.56 0.00 465,337.53 75.71 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)4,362.72 4,362.72 0.00 0.00 0.00 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 47,355.71 11,405.68 0.00 35,950.03 75.91 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502020 Group Health Insurance 74,853.57 19,691.73 0.00 55,161.84 73.69 10-180-502030 Retirement 90,970.58 21,324.70 0.00 69,645.88 76.56 10-180-502040 Workers Compensation 531.10 531.10 0.00 0.00 0.00 10-180-502050 Life Insurance 1,212.25 272.94 0.00 939.31 77.48 10-180-502060 Long Term Disability 1,788.94 502.24 0.00 1,286.70 71.93 10-180-502070 Employee Assistance Prgm 307.77 71.41 0.00 236.36 76.80 E05 Personnel Services 836,048.73 207,491.08 0.00 628,557.65 75.18 10-180-511010 Advertising 1,000.00 0.00 0.00 1,000.00 100.00 10-180-511020 Postage 9,500.00 1,279.84 0.00 8,220.16 86.53 10-180-511021 Mail Machine Cost 2,500.00 452.68 0.00 2,047.32 81.89 10-180-512010 Printing 4,000.00 0.00 0.00 4,000.00 100.00 10-180-512020 Copies 2,500.00 105.95 0.00 2,394.05 95.76 10-180-512021 Copy Machine Cost 1,000.00 -131.89 315.90 815.99 81.60 10-180-513010 Office Supplies 4,000.00 121.40 0.00 3,878.60 96.97 10-180-517010 Operational Supplies 5,500.00 6.61 0.00 5,493.39 99.88 E10 Materials & Supplies 30,000.00 1,834.59 315.90 27,849.51 92.83 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 425.00 0.00 1,875.00 81.52 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 11,000.00 60.00 0.00 10,940.00 99.45 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 31,595.00 0.00 26,883.28 4,711.72 14.91 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 45,395.00 485.00 26,883.28 18,026.72 39.71 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 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 10-180-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 912,443.73 209,810.67 27,199.18 675,433.88 74.02 185 Non-Departmental 10-185-501020 Salaries 411,373.78 0.00 0.00 411,373.78 100.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 21,397.40 0.00 -21,397.40 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 11,221.68 19,635.00 0.00 -8,413.32 -74.97 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 422,595.46 41,032.40 0.00 381,563.06 90.29 10-185-514010 Gas 12,000.00 552.11 0.00 11,447.89 95.40 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 12,000.00 552.11 0.00 11,447.89 95.40 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 315,582.72 199,287.07 0.00 116,295.65 36.85 10-185-521020 Insurance Deductible 15,000.00 2,076.74 0.00 12,923.26 86.16 10-185-521030 Self Ins Prop & Casualty 75,000.00 796.50 0.00 74,203.50 98.94 10-185-521060 Drugalcohol screening 5,364.00 390.75 0.00 4,973.25 92.72 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 1,181.25 2,925.00 0.00 -1,743.75 -147.62 10-185-522020 Professional Services 25,000.00 6,249.99 20,833.33 -2,083.32 -8.33 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 0.00 0.00 45,750.00 100.00 10-185-527020 Economic Development 185,000.00 92,500.00 138,750.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 2,109.99 0.00 4,890.01 69.86 E15 Contractual Services 729,877.97 333,836.04 187,083.33 208,958.60 28.63 10-185-531010 Electricity 42,000.00 4,113.87 0.00 37,886.13 90.21 10-185-533010 Natural Gas 6,400.00 1,131.06 0.00 5,268.94 82.33 10-185-535010 Water 7,250.00 932.96 0.00 6,317.04 87.13 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 6,177.89 0.00 49,472.11 88.90 10-185-540010 Building & Grounds Maint.60,000.00 15,255.78 240.00 44,504.22 74.17 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,100.00 312.00 0.00 1,788.00 85.14 E25 Repairs & Maintenance 87,100.00 40,567.78 240.00 46,292.22 53.15 10-185-550010 Miscellaneous 10,000.00 1,203.00 0.00 8,797.00 87.97 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 20,754.89 12,625.38 0.00 8,129.51 39.17 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 0.00 0.00 10,000.00 100.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 9,665.00 0.00 0.00 9,665.00 100.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 1,029.02 0.00 -1,029.02 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 20,000.00 0.00 0.00 20,000.00 100.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 70,419.89 14,857.40 0.00 55,562.49 78.90 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 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,377,643.32 437,023.62 187,323.33 753,296.37 54.68 190 I.T. Department 10-190-501020 Salaries 523,890.49 115,542.36 0.00 408,348.13 77.95 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 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 40,169.42 8,355.65 0.00 31,813.77 79.20 10-190-502020 Group Health Insurance 75,335.92 16,378.02 0.00 58,957.90 78.26 10-190-502030 Retirement 77,713.39 15,199.31 0.00 62,514.08 80.44 10-190-502040 Workers Compensation 357.11 357.11 0.00 0.00 0.00 10-190-502050 Life Insurance 1,026.20 200.67 0.00 825.53 80.45 10-190-502060 Long Term Disability 1,575.82 376.90 0.00 1,198.92 76.08 10-190-502070 Employee Assistance Prgm 248.84 57.75 0.00 191.09 76.79 E05 Personnel Services 721,517.19 156,467.77 0.00 565,049.42 78.31 10-190-511010 Advertising 646.00 0.00 0.00 646.00 100.00 10-190-511020 Postage 100.00 0.00 0.00 100.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 100.00 1.37 0.00 98.63 98.63 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 52.06 0.00 947.94 94.79 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 50.00 0.00 0.00 50.00 100.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 1,750.00 394.48 0.00 1,355.52 77.46 E10 Materials & Supplies 3,646.00 447.91 0.00 3,198.09 87.72 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 480.10 0.00 19.90 3.98 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 12,000.00 580.00 0.00 11,420.00 95.17 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 10,000.00 4,577.10 0.00 5,422.90 54.23 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 19,654.00 5,039.88 0.00 14,614.12 74.36 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 3,900.00 212.83 0.00 3,687.17 94.54 E15 Contractual Services 46,054.00 10,889.91 0.00 35,164.09 76.35 10-190-534010 Telephone 58,000.00 9,466.49 0.00 48,533.51 83.68 E20 Utilities 58,000.00 9,466.49 0.00 48,533.51 83.68 10-190-545010 Software Licensemaint 142,000.00 58,712.41 23,961.95 59,325.64 41.78 10-190-545020 Citywide Wiringnetwork 3,000.00 0.00 0.00 3,000.00 100.00 10-190-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-190-547020 Maintenance Agreements 25,500.00 1,698.72 0.00 23,801.28 93.34 E25 Repairs & Maintenance 173,500.00 60,411.13 23,961.95 89,126.92 51.37 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,002,717.19 237,683.21 23,961.95 741,072.03 73.91 300 Police Department 10-300-501020 Salaries 4,187,166.55 1,022,620.87 0.00 3,164,545.68 75.58 10-300-501030 Holiday Pay 131,844.61 67,441.81 0.00 64,402.80 48.85 10-300-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-300-501050 Parttime(wo Benefits)61,845.64 6,834.84 0.00 55,010.80 88.95 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 1,084.00 0.00 3,916.00 78.32 10-300-501090 Overtime 228,916.27 73,658.58 0.00 155,257.69 67.82 10-300-501095 Overtime Straight Pay 6,000.00 2,917.20 0.00 3,082.80 51.38 10-300-502010 Social Security 349,777.83 84,935.19 0.00 264,842.64 75.72 10-300-502020 Group Health Insurance 757,648.99 191,923.06 0.00 565,725.93 74.67 10-300-502030 Retirement 815,784.60 209,550.07 0.00 606,234.53 74.31 10-300-502040 Workers Compensation 39,409.96 39,409.96 0.00 0.00 0.00 10-300-502050 Life Insurance 8,521.00 1,860.56 0.00 6,660.44 78.17 10-300-502060 Long Term Disability 12,725.99 3,506.83 0.00 9,219.16 72.44 10-300-502070 Employee Assistance Prgm 2,396.71 556.25 0.00 1,840.46 76.79 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,609,638.15 1,706,299.22 0.00 4,903,338.93 74.18 10-300-511010 Advertising 3,000.00 67.25 0.00 2,932.75 97.76 10-300-511020 Postage 1,500.00 446.44 0.00 1,053.56 70.24 10-300-512010 Printing 5,000.00 733.73 0.00 4,266.27 85.33 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-300-512030 Photographic Supplies 2,000.00 0.00 0.00 2,000.00 100.00 10-300-513010 Office Supplies 13,000.00 3,132.59 0.00 9,867.41 75.90 10-300-514010 Gas 158,000.00 10,346.93 0.00 147,653.07 93.45 10-300-514040 Food 700.00 212.66 0.00 487.34 69.62 10-300-515040 First Aid Supplies 1,000.00 376.92 0.00 623.08 62.31 10-300-516010 Ammunition & Firearms Supplies 26,000.00 3,150.00 22,223.35 626.65 2.41 10-300-516020 Dare Program 16,500.00 1,835.07 0.00 14,664.93 88.88 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 4,200.00 3,900.00 0.00 300.00 7.14 10-300-517010 Operational Supplies 45,000.00 14,869.41 1,465.25 28,665.34 63.70 E10 Materials & Supplies 278,500.00 39,071.00 23,688.60 215,740.40 77.47 10-300-520030 Dues And Publications 4,600.00 1,881.90 0.00 2,718.10 59.09 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 57,009.00 8,025.08 0.00 48,983.92 85.92 10-300-520080 Tuition Reimbursement 7,000.00 3,075.00 0.00 3,925.00 56.07 10-300-520090 Recruitment 2,500.00 379.52 0.00 2,120.48 84.82 10-300-521040 Medical Claimsservices 5,000.00 783.48 0.00 4,216.52 84.33 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 15,500.00 11,093.00 0.00 4,407.00 28.43 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 5,498.03 0.00 -5,498.03 0.00 10-300-523010 Equipment Rentlease 0.00 0.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 648.89 0.00 1,551.11 70.51 E15 Contractual Services 93,809.00 31,384.90 0.00 62,424.10 66.54 10-300-531010 Electricity 68,250.00 7,511.47 0.00 60,738.53 88.99 10-300-533010 Natural Gas 12,000.00 165.37 0.00 11,834.63 98.62 10-300-534010 Telephone 19,500.00 2,904.13 0.00 16,595.87 85.11 10-300-535010 Water 4,500.00 551.16 0.00 3,948.84 87.75 E20 Utilities 104,250.00 11,132.13 0.00 93,117.87 89.32 10-300-540010 Building & Grounds Maint.40,000.00 6,309.82 280.00 33,410.18 83.53 10-300-541030 Vehicle Wash 12,000.00 5,719.50 0.00 6,280.50 52.34 10-300-544010 K-9 Operations 18,500.00 6,611.89 0.00 11,888.11 64.26 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 0.00 0.00 21,300.00 100.00 10-300-545010 Software Licensemaint 62,000.00 50,920.00 0.00 11,080.00 17.87 10-300-546010 Clothing Expense 43,000.00 5,857.22 0.00 37,142.78 86.38 10-300-546020 Uniform Cleaning 25,000.00 3,525.44 0.00 21,474.56 85.90 10-300-547010 Equipment Maintenance 9,350.00 639.46 0.00 8,710.54 93.16 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-547020 Maintenance Agreements 41,600.00 7,730.97 2,150.34 31,718.69 76.25 10-300-547030 Radio Maintenance 10,000.00 1,082.81 0.00 8,917.19 89.17 E25 Repairs & Maintenance 282,750.00 88,397.11 2,430.34 191,922.55 67.88 10-300-572010 Purchase Of Vehicles 198,511.76 0.00 167,634.00 30,877.76 15.55 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 35,000.00 0.00 27,134.00 7,866.00 22.47 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 9,902.40 7,000.00 0.00 2,902.40 29.31 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-572210 Cole Co Reimbursable Grant Exp 6,601.60 0.00 0.00 6,601.60 100.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 250,015.76 7,000.00 194,768.00 48,247.76 19.30 300 Police Department 7,618,962.91 1,883,284.36 220,886.94 5,514,791.61 72.38 310 School Resource Officer 10-310-501020 Salaries 230,589.14 69,984.50 0.00 160,604.64 69.65 10-310-501030 Holiday Pay 8,866.04 2,077.92 0.00 6,788.12 76.56 10-310-501090 Overtime 17,126.00 4,290.63 0.00 12,835.37 74.95 10-310-501095 Overtime Straight Pay 410.00 105.82 0.00 304.18 74.19 10-310-502010 Social Security 19,659.83 5,410.37 0.00 14,249.46 72.48 10-310-502020 Group Health Insurance 61,286.66 15,184.82 0.00 46,101.84 75.22 10-310-502030 Retirement 47,286.38 12,465.79 0.00 34,820.59 73.64 10-310-502040 Workers Compensation 2,538.82 2,538.82 0.00 0.00 0.00 10-310-502050 Life Insurance 473.93 116.47 0.00 357.46 75.42 10-310-502060 Long Term Disability 714.82 226.00 0.00 488.82 68.38 10-310-502070 Employee Assistance Prgm 130.97 30.40 0.00 100.57 76.79 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 389,082.59 112,431.54 0.00 276,651.05 71.10 10-310-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-310-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-310-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 310 School Resource Officer 389,082.59 112,431.54 0.00 276,651.05 71.10 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 92,709.46 21,751.56 0.00 70,957.90 76.54 10-320-501030 Holiday Pay 3,364.09 167.26 0.00 3,196.83 95.03 10-320-501090 Overtime 6,897.00 7,704.86 0.00 -807.86 -11.71 10-320-501095 Overtime Straight Pay 0.00 338.29 0.00 -338.29 0.00 10-320-502010 Social Security 7,613.85 2,144.59 0.00 5,469.26 71.83 10-320-502020 Group Health Insurance 19,569.70 4,847.69 0.00 14,722.01 75.23 10-320-502030 Retirement 18,313.05 5,512.98 0.00 12,800.07 69.90 10-320-502040 Workers Compensation 1,018.46 1,018.46 0.00 0.00 0.00 10-320-502050 Life Insurance 180.17 39.47 0.00 140.70 78.09 10-320-502060 Long Term Disability 271.24 75.04 0.00 196.20 72.33 10-320-502070 Employee Assistance Prgm 52.39 12.16 0.00 40.23 76.79 E05 Personnel Services 149,989.41 43,612.36 0.00 106,377.05 70.92 10-320-514010 Gas 5,000.00 769.82 0.00 4,230.18 84.60 10-320-516040 Investigations 14,350.00 3,715.29 0.00 10,634.71 74.11 10-320-517010 Operational Supplies 3,616.98 402.66 0.00 3,214.32 88.87 E10 Materials & Supplies 22,966.98 4,887.77 0.00 18,079.21 78.72 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 18,269.11 3,000.00 0.00 15,269.11 83.58 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,269.11 3,000.00 0.00 15,269.11 83.58 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 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.191,225.50 51,500.13 0.00 139,725.37 73.07 330 Animal Control 10-330-501020 Salaries 323,724.06 80,577.86 0.00 243,146.20 75.11 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 1,084.00 0.00 3,224.00 74.84 10-330-501090 Overtime 1,709.00 419.98 0.00 1,289.02 75.43 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 25,263.44 5,959.08 0.00 19,304.36 76.41 10-330-502020 Group Health Insurance 57,912.97 16,756.79 0.00 41,156.18 71.07 10-330-502030 Retirement 48,875.68 12,148.13 0.00 36,727.55 75.14 10-330-502040 Workers Compensation 2,494.77 2,494.77 0.00 0.00 0.00 10-330-502050 Life Insurance 640.40 147.29 0.00 493.11 77.00 10-330-502060 Long Term Disability 1,003.75 279.61 0.00 724.14 72.14 10-330-502070 Employee Assistance Prgm 209.55 48.63 0.00 160.92 76.79 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 466,641.62 119,916.14 0.00 346,725.48 74.30 10-330-511010 Advertising 120.00 0.00 0.00 120.00 100.00 10-330-511020 Postage 100.00 7.14 0.00 92.86 92.86 10-330-512010 Printing 1,450.00 530.78 0.00 919.22 63.39 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,900.00 28.39 0.00 1,871.61 98.51 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 101.16 0.00 138.84 57.85 10-330-515040 First Aid Supplies 700.00 87.28 0.00 612.72 87.53 10-330-517010 Operational Supplies 9,700.00 3,494.51 0.00 6,205.49 63.97 E10 Materials & Supplies 14,210.00 4,249.26 0.00 9,960.74 70.10 10-330-520030 Dues And Publications 1,150.00 651.25 0.00 498.75 43.37 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 0.00 0.00 1,950.00 100.00 10-330-521040 Medical Claimsservices 464.00 250.00 0.00 214.00 46.12 10-330-522020 Professional Services 5,200.00 1,097.60 0.00 4,102.40 78.89 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,600.00 0.00 0.00 5,600.00 100.00 10-330-529050 Spay & Neuter Program 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-529068 Animal Shelter Donations 7,625.00 14,752.46 207.00 -7,334.46 -96.19 E15 Contractual Services 21,989.00 16,751.31 207.00 5,030.69 22.88 10-330-531010 Electricity 21,700.00 4,978.65 0.00 16,721.35 77.06 10-330-533010 Natural Gas 15,800.00 3,784.16 0.00 12,015.84 76.05 10-330-534010 Telephone 300.00 40.70 0.00 259.30 86.43 10-330-535010 Water 4,300.00 601.69 0.00 3,698.31 86.01 E20 Utilities 42,100.00 9,405.20 0.00 32,694.80 77.66 10-330-540010 Building & Grounds Maint.9,000.00 675.69 125.00 8,199.31 91.10 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 41,000.00 13,941.71 0.00 27,058.29 66.00 10-330-544050 Animal Food 5,000.00 813.56 0.00 4,186.44 83.73 10-330-545010 Software Licensemaint 1,650.00 1,995.00 0.00 -345.00 -20.91 10-330-546010 Clothing Expense 2,500.00 923.53 0.00 1,576.47 63.06 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 900.00 110.00 0.00 790.00 87.78 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 60,910.00 18,999.49 125.00 41,785.51 68.60 10-330-572010 Purchase of Vehicles 28,251.96 0.00 23,976.00 4,275.96 15.14 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 28,251.96 0.00 23,976.00 4,275.96 15.14 10-330-578069 Animal Shelter 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 330 Animal Control 634,102.58 169,321.40 24,308.00 440,473.18 69.46 390 9-1-1 Police 10-390-501020 Salaries 850,359.80 200,406.27 0.00 649,953.53 76.43 10-390-501030 Holiday Pay 29,479.22 16,378.20 0.00 13,101.02 44.44 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 15,814.00 3,946.96 0.00 11,867.04 75.04 10-390-501095 Overtime Straight Pay 500.00 78.70 0.00 421.30 84.26 10-390-502010 Social Security 68,754.61 16,024.64 0.00 52,729.97 76.69 10-390-502020 Group Health Insurance 169,048.38 38,882.77 0.00 130,165.61 77.00 10-390-502030 Retirement 133,827.35 32,679.99 0.00 101,147.36 75.58 10-390-502040 Workers Compensation 481.13 481.13 0.00 0.00 0.00 10-390-502050 Life Insurance 1,737.10 366.47 0.00 1,370.63 78.90 10-390-502060 Long Term Disability 2,637.44 694.80 0.00 1,942.64 73.66 10-390-502070 Employee Assistance Prgm 556.61 129.18 0.00 427.43 76.79 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,275,795.64 310,069.11 0.00 965,726.53 75.70 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 5,000.00 186.99 0.00 4,813.01 96.26 E10 Materials & Supplies 5,100.00 186.99 0.00 4,913.01 96.33 10-390-520030 Dues And Publications 600.00 0.00 0.00 600.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 5,000.00 12.00 0.00 4,988.00 99.76 10-390-522020 Professional Services 1,200.00 0.00 0.00 1,200.00 100.00 10-390-523010 Equipment Rentlease 98,000.00 23,341.54 0.00 74,658.46 76.18 E15 Contractual Services 104,800.00 23,353.54 0.00 81,446.46 77.72 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 614.41 0.00 5,385.59 89.76 10-390-546020 Uniform Cleaning 1,000.00 438.00 0.00 562.00 56.20 10-390-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-390-547020 Maintenance Agreements 42,000.00 288.58 1,442.90 40,268.52 95.88 10-390-547030 Radio Maintenance 5,000.00 373.22 0.00 4,626.78 92.54 E25 Repairs & Maintenance 80,000.00 24,714.21 1,442.90 53,842.89 67.30 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,465,695.64 358,323.85 1,442.90 1,105,928.89 75.45 400 Fire Department 10-400-501020 Salaries 3,666,487.45 861,219.24 0.00 2,805,268.21 76.51 10-400-501030 Holiday Pay 270,304.05 158,306.13 0.00 111,997.92 41.43 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 28,500.00 7,470.00 0.00 21,030.00 73.79 10-400-501090 Overtime 43,000.00 3,492.00 0.00 39,508.00 91.88 10-400-501095 Overtime Straight Pay 35,000.00 2,444.77 0.00 32,555.23 93.01 10-400-502010 Social Security 59,906.96 14,793.16 0.00 45,113.80 75.31 10-400-502020 Group Health Insurance 644,562.45 165,165.38 0.00 479,397.07 74.38 10-400-502030 Retirement 1,767,713.82 444,799.49 0.00 1,322,914.33 74.84 10-400-502040 Workers Compensation 79,145.55 79,145.55 0.00 0.00 0.00 10-400-502050 Life Insurance 7,794.43 1,568.36 0.00 6,226.07 79.88 10-400-502060 Long Term Disability 11,342.56 2,963.62 0.00 8,378.94 73.87 10-400-502070 Employee Assistance Prgm 1,990.71 462.02 0.00 1,528.69 76.79 10-400-503010 Awards Program 1,500.00 281.18 0.00 1,218.82 81.25 E05 Personnel Services 6,617,247.98 1,742,110.90 0.00 4,875,137.08 73.67 10-400-511010 Advertising 1,150.00 290.75 0.00 859.25 74.72 10-400-511020 Postage 200.00 5.29 0.00 194.71 97.36 10-400-512010 Printing 1,250.00 0.00 0.00 1,250.00 100.00 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,800.00 365.76 0.00 1,434.24 79.68 10-400-514010 Gas 49,000.00 3,027.49 0.00 45,972.51 93.82 10-400-514020 Chemicals 1,500.00 910.00 0.00 590.00 39.33 10-400-514030 Small Tools 4,500.00 997.00 0.00 3,503.00 77.84 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 800.00 0.00 0.00 800.00 100.00 10-400-517010 Operational Supplies 10,000.00 1,415.42 0.00 8,584.58 85.85 E10 Materials & Supplies 70,250.00 7,011.71 0.00 63,238.29 90.02 10-400-520030 Dues And Publications 2,500.00 464.90 0.00 2,035.10 81.40 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 24,000.00 4,948.59 0.00 19,051.41 79.38 10-400-520080 Tuition Reimbursement 4,000.00 615.00 0.00 3,385.00 84.63 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 38,550.00 803.75 0.00 37,746.25 97.92 10-400-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-400-523010 Equipment Rentlease 500.00 0.00 0.00 500.00 100.00 10-400-524010 Trash Collections 100.00 0.00 0.00 100.00 100.00 10-400-529010 Special Events 6,000.00 1,679.04 0.00 4,320.96 72.02 10-400-529040 Child Pass Seat Pass-through 2,500.00 0.00 0.00 2,500.00 100.00 E15 Contractual Services 78,350.00 8,511.28 0.00 69,838.72 89.14 10-400-531010 Electricity 32,000.00 4,592.08 0.00 27,407.92 85.65 10-400-533010 Natural Gas 20,000.00 4,918.56 0.00 15,081.44 75.41 10-400-534010 Telephone 20,000.00 3,115.30 0.00 16,884.70 84.42 10-400-535010 Water 13,000.00 2,108.95 0.00 10,891.05 83.78 E20 Utilities 85,000.00 14,734.89 0.00 70,265.11 82.66 10-400-540010 Building & Grounds Maint.206,788.00 5,306.86 122,805.21 78,675.93 38.05 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 45,000.00 20,704.70 0.00 24,295.30 53.99 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 18,000.00 4,974.64 0.00 13,025.36 72.36 10-400-547020 Maintenance Agreements 28,500.00 7,327.77 3,107.80 18,064.43 63.38 10-400-547030 Radio Maintenance 9,500.00 187.50 0.00 9,312.50 98.03 E25 Repairs & Maintenance 308,288.00 38,501.47 125,913.01 143,873.52 46.67 10-400-572010 Purchase Of Vehicles 87,375.00 0.00 44,227.00 43,148.00 49.38 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 87,375.00 0.00 44,227.00 43,148.00 49.38 400 Fire Department 7,246,510.98 1,810,870.25 170,140.01 5,265,500.72 72.66 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 1,250.00 67.24 0.00 1,182.76 94.62 10-401-533010 Natural Gas 0.00 79.77 0.00 -79.77 0.00 10-401-535010 Water 0.00 98.21 0.00 -98.21 0.00 E20 Utilities 1,250.00 245.22 0.00 1,004.78 80.38 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 1,250.00 245.22 0.00 1,004.78 80.38 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 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 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 213,899.09 84,252.42 0.00 129,646.67 60.61 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,363.28 6,315.26 0.00 10,048.02 61.41 10-520-502020 Group Health Insurance 31,191.13 7,999.74 0.00 23,191.39 74.35 10-520-502030 Retirement 31,657.07 8,109.47 0.00 23,547.60 74.38 10-520-502040 Workers Compensation 123.35 123.35 0.00 0.00 0.00 10-520-502050 Life Insurance 419.10 98.13 0.00 320.97 76.59 10-520-502060 Long Term Disability 607.35 175.00 0.00 432.35 71.19 10-520-502070 Employee Assistance Prgm 104.77 24.32 0.00 80.45 76.79 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 294,365.14 107,097.69 0.00 187,267.45 63.62 10-520-511010 Advertising 432.30 432.30 0.00 0.00 0.00 10-520-511020 Postage 200.00 2.08 0.00 197.92 98.96 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 347.83 0.00 452.17 56.52 10-520-514010 Gas 13,000.00 454.51 0.00 12,545.49 96.50 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 152.98 0.00 247.02 61.76 E10 Materials & Supplies 14,832.30 1,389.70 0.00 13,442.60 90.63 10-520-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,317.70 0.00 382.20 935.50 70.99 10-520-522020 Professional Services 5,000.00 444.35 0.00 4,555.65 91.11 E15 Contractual Services 6,817.70 444.35 382.20 5,991.15 87.88 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,419.45 61.42 276.57 1,081.46 76.19 E25 Repairs & Maintenance 1,419.45 61.42 276.57 1,081.46 76.19 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 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 520 Plan & Protect Svcs-Admin 317,434.59 108,993.16 658.77 207,782.66 65.46 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 59,894.48 14,795.84 0.00 45,098.64 75.30 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 3,087.00 0.00 12,913.00 80.71 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,805.93 1,335.33 0.00 4,470.60 77.00 10-521-502020 Group Health Insurance 10,246.91 2,541.85 0.00 7,705.06 75.19 10-521-502030 Retirement 8,864.38 2,189.79 0.00 6,674.59 75.30 10-521-502040 Workers Compensation 40.27 40.27 0.00 0.00 0.00 10-521-502050 Life Insurance 117.50 26.84 0.00 90.66 77.16 10-521-502060 Long Term Disability 183.84 50.87 0.00 132.97 72.33 10-521-502070 Employee Assistance Prgm 26.19 6.08 0.00 20.11 76.79 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 101,179.50 24,073.87 0.00 77,105.63 76.21 10-521-511010 Advertising 4,000.00 2,156.50 0.00 1,843.50 46.09 10-521-511020 Postage 1,000.00 96.62 0.00 903.38 90.34 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 136.55 0.00 863.45 86.35 10-521-514040 Food 100.00 81.54 0.00 18.46 18.46 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 483.38 0.00 1,516.62 75.83 E10 Materials & Supplies 8,210.00 2,954.59 0.00 5,255.41 64.01 10-521-520030 Dues And Publications 15,500.00 484.00 0.00 15,016.00 96.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 484.00 0.00 17,516.00 97.31 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,188.71 286.90 487.26 414.55 34.87 E25 Repairs & Maintenance 1,188.71 286.90 487.26 414.55 34.87 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 128,578.21 27,799.36 487.26 100,291.59 78.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 160,408.24 34,432.80 0.00 125,975.44 78.53 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 12,271.23 2,614.46 0.00 9,656.77 78.69 10-522-502020 Group Health Insurance 18,872.81 4,259.11 0.00 14,613.70 77.43 10-522-502030 Retirement 23,740.42 5,096.07 0.00 18,644.35 78.53 10-522-502040 Workers Compensation 63.37 63.37 0.00 0.00 0.00 10-522-502050 Life Insurance 317.26 63.01 0.00 254.25 80.14 10-522-502060 Long Term Disability 496.94 118.24 0.00 378.70 76.21 10-522-502070 Employee Assistance Prgm 78.58 18.24 0.00 60.34 76.79 E05 Personnel Services 216,248.85 46,665.30 0.00 169,583.55 78.42 10-522-511010 Advertising 2,500.00 0.00 0.00 2,500.00 100.00 10-522-511020 Postage 400.00 11.01 0.00 388.99 97.25 10-522-512010 Printing 125.00 38.00 0.00 87.00 69.60 10-522-512020 Copies 50.00 0.11 0.00 49.89 99.78 10-522-513010 Office Supplies 1,000.00 151.92 0.00 848.08 84.81 10-522-514040 Food 250.00 39.98 0.00 210.02 84.01 10-522-517010 Operational Supplies 1,300.00 26.03 0.00 1,273.97 98.00 E10 Materials & Supplies 5,625.00 267.05 0.00 5,357.95 95.25 10-522-520030 Dues And Publications 1,250.00 535.00 0.00 715.00 57.20 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 9,576.64 576.84 0.00 8,999.80 93.98 10-522-522020 Professional Services 235,000.00 0.00 75,000.00 160,000.00 68.09 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 245,826.64 1,111.84 75,000.00 169,714.80 69.04 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 750.00 198.71 451.44 99.85 13.31 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 750.00 198.71 451.44 99.85 13.31 10-522-572020 Purchase Of Equipment 2,375.00 0.00 0.00 2,375.00 100.00 E70 Capital Purchases 2,375.00 0.00 0.00 2,375.00 100.00 522 Plan & Protect Svcs-MPO 470,825.49 48,242.90 75,451.44 347,131.15 73.73 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 104,093.76 18,674.21 0.00 85,419.55 82.06 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-502010 Social Security 7,963.17 1,278.88 0.00 6,684.29 83.94 10-530-502020 Group Health Insurance 16,238.38 3,089.14 0.00 13,149.24 80.98 10-530-502030 Retirement 15,405.88 2,763.79 0.00 12,642.09 82.06 10-530-502040 Workers Compensation 28.02 0.00 0.00 28.02 100.00 10-530-502050 Life Insurance 205.63 32.53 0.00 173.10 84.18 10-530-502060 Long Term Disability 307.40 62.31 0.00 245.09 79.73 10-530-502070 Employee Assistance Prgm 65.48 15.20 0.00 50.28 76.79 E05 Personnel Services 144,307.72 25,916.06 0.00 118,391.66 82.04 10-530-511010 Advertising 300.00 40.00 0.00 260.00 86.67 10-530-511020 Postage 100.00 12.77 0.00 87.23 87.23 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-530-513010 Office Supplies 300.00 54.26 0.00 245.74 81.91 10-530-517010 Operational Supplies 300.00 91.00 0.00 209.00 69.67 E10 Materials & Supplies 1,100.00 198.03 0.00 901.97 82.00 10-530-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,800.00 0.00 0.00 1,800.00 100.00 10-530-522020 Professional Services 1,000.00 0.00 0.00 1,000.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid-Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 18,800.00 0.00 18,800.00 0.00 0.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 2,000.00 10.98 0.00 1,989.02 99.45 10-530-524029 Recycling Education 9,000.00 0.00 0.00 9,000.00 100.00 10-530-528085 Fair Housing Assistance Prog 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 33,600.00 10.98 18,800.00 14,789.02 44.01 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 36.51 102.15 211.34 60.38 E25 Repairs & Maintenance 350.00 36.51 102.15 211.34 60.38 10-530-550020 NRA-Residential 55,000.00 24,110.82 0.00 30,889.18 56.16 10-530-550030 NRA-Commercial Facade 35,000.00 16,715.32 0.00 18,284.68 52.24 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA-Rental Facade 15,066.00 5,027.00 0.00 10,039.00 66.63 10-530-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-530-550037 Historic Preservation Comm 500.00 55.00 0.00 445.00 89.00 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550050 Neighb Stablization Prog 350.00 345.13 0.00 4.87 1.39 10-530-550055 HERO 48,480.00 9,200.00 0.00 39,280.00 81.02 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E30 Other Operating Expenses 154,396.00 55,453.27 0.00 98,942.73 64.08 530 Plan & Protect Svc-RedevGrant 333,753.72 81,614.85 18,902.15 233,236.72 69.88 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 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 167,631.06 40,997.81 0.00 126,633.25 75.54 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,846.73 2,890.23 0.00 9,956.50 77.50 10-532-502020 Group Health Insurance 21,564.41 7,684.38 0.00 13,880.03 64.37 10-532-502030 Retirement 24,853.80 6,067.68 0.00 18,786.12 75.59 10-532-502040 Workers Compensation 1,779.23 1,779.23 0.00 0.00 0.00 10-532-502050 Life Insurance 327.05 74.37 0.00 252.68 77.26 10-532-502060 Long Term Disability 511.14 141.39 0.00 369.75 72.34 10-532-502070 Employee Assistance Prgm 78.58 18.24 0.00 60.34 76.79 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 229,892.00 59,653.33 0.00 170,238.67 74.05 10-532-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-532-511020 Postage 200.00 31.50 0.00 168.50 84.25 10-532-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-532-512020 Copies 20.00 0.00 0.00 20.00 100.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 560.80 0.00 739.20 56.86 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,000.00 441.16 0.00 558.84 55.88 E10 Materials & Supplies 2,935.00 1,033.46 0.00 1,901.54 64.79 10-532-520030 Dues And Publications 1,000.00 645.00 0.00 355.00 35.50 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 0.00 0.00 1,000.00 100.00 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 1,474.00 737.00 737.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 221,000.00 36,833.34 184,166.67 -0.01 0.00 10-532-529010 Special Events 700.00 0.00 0.00 700.00 100.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E15 Contractual Services 225,174.00 38,215.34 184,903.67 2,054.99 0.91 10-532-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-532-540060 Cemetery Maintenance 30,000.00 4,648.02 23,650.00 1,701.98 5.67 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,860.00 164.00 0.00 1,696.00 91.18 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 800.00 87.30 196.04 516.66 64.58 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 34,030.00 6,183.32 23,846.04 4,000.64 11.76 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 492,031.00 105,085.45 208,749.71 178,195.84 36.22 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 140,238.21 35,121.80 0.00 105,116.41 74.96 10-533-501060 Seasonal Salaries 35,990.00 2,432.70 0.00 33,557.30 93.24 10-533-501090 Overtime 740.00 0.00 0.00 740.00 100.00 10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00 10-533-502010 Social Security 13,557.96 2,736.87 0.00 10,821.09 79.81 10-533-502020 Group Health Insurance 23,276.78 5,922.07 0.00 17,354.71 74.56 10-533-502030 Retirement 20,903.25 4,747.92 0.00 16,155.33 77.29 10-533-502040 Workers Compensation 1,874.09 0.00 0.00 1,874.09 100.00 10-533-502050 Life Insurance 276.13 54.85 0.00 221.28 80.14 10-533-502060 Long Term Disability 434.77 119.79 0.00 314.98 72.45 10-533-502070 Employee Assistance Prgm 78.58 18.24 0.00 60.34 76.79 E05 Personnel Services 237,629.77 51,154.24 0.00 186,475.53 78.47 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,200.00 315.63 0.00 884.37 73.70 10-533-512010 Printing 350.00 0.00 0.00 350.00 100.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 900.00 270.06 0.00 629.94 69.99 10-533-514030 Small Tools 150.00 0.00 0.00 150.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,350.00 14.37 0.00 1,335.63 98.94 E10 Materials & Supplies 4,080.00 600.06 0.00 3,479.94 85.29 10-533-520030 Dues And Publications 500.00 93.98 0.00 406.02 81.20 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 15,000.00 9,575.00 0.00 5,425.00 36.17 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-522022 Demo 40,000.00 0.00 0.00 40,000.00 100.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 56,500.00 9,668.98 0.00 46,831.02 82.89 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 2,180.00 441.28 0.00 1,738.72 79.76 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 750.00 181.77 343.93 224.30 29.91 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,230.00 893.05 343.93 1,993.02 61.70 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 301,439.77 62,316.33 343.93 238,779.51 79.21 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 215,553.96 53,201.93 0.00 162,352.03 75.32 10-534-501050 Parttime(wo Benefits)26,483.64 0.00 0.00 26,483.64 100.00 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 370.00 0.00 0.00 370.00 100.00 10-534-501095 Overtime Straight Pay 65.00 0.00 0.00 65.00 100.00 10-534-502010 Social Security 18,549.15 3,708.24 0.00 14,840.91 80.01 10-534-502020 Group Health Insurance 46,436.05 11,506.82 0.00 34,929.23 75.22 10-534-502030 Retirement 31,966.37 7,873.89 0.00 24,092.48 75.37 10-534-502040 Workers Compensation 2,012.43 0.00 0.00 2,012.43 100.00 10-534-502050 Life Insurance 423.01 96.20 0.00 326.81 77.26 10-534-502060 Long Term Disability 662.67 183.29 0.00 479.38 72.34 10-534-502070 Employee Assistance Prgm 104.77 24.32 0.00 80.45 76.79 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 342,627.05 76,594.69 0.00 266,032.36 77.64 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,000.00 186.09 0.00 813.91 81.39 10-534-512010 Printing 350.00 0.00 0.00 350.00 100.00 10-534-512020 Copies 15.00 0.00 0.00 15.00 100.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 106.76 0.00 793.24 88.14 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 2,014.20 0.00 0.00 2,014.20 100.00 E10 Materials & Supplies 4,544.20 292.85 0.00 4,251.35 93.56 10-534-520030 Dues And Publications 2,000.00 1,457.08 0.00 542.92 27.15 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 9,000.00 79.00 0.00 8,921.00 99.12 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 11,000.00 1,536.08 0.00 9,463.92 86.04 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,180.00 401.00 0.00 1,779.00 81.61 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 575.00 217.73 370.29 -13.02 -2.26 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 3,045.00 888.73 370.29 1,785.98 58.65 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 361,216.25 79,312.35 370.29 281,533.61 77.94 535 Public Works-Central Maintenan 10-535-501020 Salaries 319,547.63 78,767.03 0.00 240,780.60 75.35 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)7,400.00 0.00 0.00 7,400.00 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 8,273.33 0.00 -3,773.33 -83.85 10-535-501095 Overtime Straight Pay 500.00 609.82 0.00 -109.82 -21.96 10-535-502010 Social Security 25,393.99 6,370.39 0.00 19,023.60 74.91 10-535-502020 Group Health Insurance 58,302.46 17,135.74 0.00 41,166.72 70.61 10-535-502030 Retirement 48,033.05 12,972.15 0.00 35,060.90 72.99 10-535-502040 Workers Compensation 2,260.55 2,260.55 0.00 0.00 0.00 10-535-502050 Life Insurance 630.60 143.39 0.00 487.21 77.26 10-535-502060 Long Term Disability 989.73 273.31 0.00 716.42 72.39 10-535-502070 Employee Assistance Prgm 183.36 42.56 0.00 140.80 76.79 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 467,741.37 126,848.27 0.00 340,893.10 72.88 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 801.28 0.00 698.72 46.58 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 8,000.00 565.79 0.00 7,434.21 92.93 10-535-517010 Operational Supplies 7,000.00 1,724.12 0.00 5,275.88 75.37 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 16,640.00 3,091.19 0.00 13,548.81 81.42 10-535-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 535.85 0.00 1,464.15 73.21 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 535.85 0.00 1,964.15 78.57 10-535-531010 Electricity 7,560.00 1,122.31 0.00 6,437.69 85.15 10-535-533010 Natural Gas 8,400.00 2,017.44 0.00 6,382.56 75.98 10-535-534010 Telephone 220.00 106.80 108.00 5.20 2.36 10-535-535010 Water 1,400.00 228.52 0.00 1,171.48 83.68 E20 Utilities 17,580.00 3,475.07 108.00 13,996.93 79.62 10-535-540010 Building & Grounds Maint.10,000.00 4,094.48 25.00 5,880.52 58.81 10-535-541010 Veh & Equip Parts Etc 485,000.00 154,189.85 0.00 330,810.15 68.21 10-535-546010 Clothing Expense 5,500.00 1,104.23 -828.80 5,224.57 94.99 10-535-547010 Equipment Maintenance 3,000.00 0.00 0.00 3,000.00 100.00 10-535-547020 Maintenance Agreements 7,300.00 710.54 0.00 6,589.46 90.27 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 510,900.00 160,099.10 -803.80 351,604.70 68.82 10-535-572020 Purchase Of Equipment 17,500.00 16,515.00 0.00 985.00 5.63 E70 Capital Purchases 17,500.00 16,515.00 0.00 985.00 5.63 535 Public Works-Central Maintenan 1,032,861.37 310,564.48 -695.80 722,992.69 70.00 540 Public Works-Admin 10-540-501020 Salaries 202,195.50 49,850.15 0.00 152,345.35 75.35 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,467.96 3,531.58 0.00 11,936.38 77.17 10-540-502020 Group Health Insurance 34,432.33 7,619.45 0.00 26,812.88 77.87 10-540-502030 Retirement 29,924.93 7,377.84 0.00 22,547.09 75.35 10-540-502040 Workers Compensation 115.27 115.27 0.00 0.00 0.00 10-540-502050 Life Insurance 397.56 90.51 0.00 307.05 77.23 10-540-502060 Long Term Disability 530.48 145.95 0.00 384.53 72.49 10-540-502070 Employee Assistance Prgm 78.58 18.24 0.00 60.34 76.79 E05 Personnel Services 283,142.61 68,748.99 0.00 214,393.62 75.72 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 1.36 0.00 198.64 99.32 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 86,000.00 4,757.10 0.00 81,242.90 94.47 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-514040 Food 200.00 0.00 0.00 200.00 100.00 10-540-517010 Operational Supplies 1,300.00 0.00 0.00 1,300.00 100.00 E10 Materials & Supplies 89,000.00 4,758.46 0.00 84,241.54 94.65 10-540-520030 Dues And Publications 500.00 655.00 0.00 -155.00 -31.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,800.00 337.20 0.00 3,462.80 91.13 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 4,500.00 992.20 0.00 3,507.80 77.95 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 450.00 96.80 119.72 233.48 51.88 E25 Repairs & Maintenance 450.00 96.80 119.72 233.48 51.88 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 377,092.61 74,596.45 119.72 302,376.44 80.19 541 Public Works-Engineering 10-541-501020 Salaries 750,637.00 169,867.41 0.00 580,769.59 77.37 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 548.35 0.00 -148.35 -37.09 10-541-501095 Overtime Straight Pay 400.00 0.00 0.00 400.00 100.00 10-541-502010 Social Security 57,484.93 12,183.03 0.00 45,301.90 78.81 10-541-502020 Group Health Insurance 120,839.39 28,341.36 0.00 92,498.03 76.55 10-541-502030 Retirement 111,212.68 23,631.26 0.00 87,581.42 78.75 10-541-502040 Workers Compensation 3,639.97 3,639.97 0.00 0.00 0.00 10-541-502050 Life Insurance 1,474.68 300.78 0.00 1,173.90 79.60 10-541-502060 Long Term Disability 2,301.79 572.74 0.00 1,729.05 75.12 10-541-502070 Employee Assistance Prgm 314.32 72.95 0.00 241.37 76.79 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,048,704.76 239,157.85 0.00 809,546.91 77.19 10-541-511010 Advertising 1,000.00 172.75 0.00 827.25 82.73 10-541-511020 Postage 400.00 8.29 0.00 391.71 97.93 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 0.00 0.00 75.00 100.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 5,800.00 1,206.98 0.00 4,593.02 79.19 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 0.00 0.00 150.00 100.00 10-541-515040 First Aid Supplies 50.00 0.00 0.00 50.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-515070 Const & Inspect Supplies 2,000.00 268.71 0.00 1,731.29 86.56 10-541-515080 Surveying Supplies 2,000.00 52.08 0.00 1,947.92 97.40 10-541-517010 Operational Supplies 1,150.00 405.58 0.00 744.42 64.73 E10 Materials & Supplies 12,925.00 2,114.39 0.00 10,810.61 83.64 10-541-520030 Dues And Publications 4,000.00 1,920.00 0.00 2,080.00 52.00 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,000.00 0.00 0.00 3,000.00 100.00 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 4,000.00 33.00 0.00 3,967.00 99.18 10-541-522055 Stormwater Compliance 1,500.00 0.00 0.00 1,500.00 100.00 E15 Contractual Services 12,500.00 1,953.00 0.00 10,547.00 84.38 10-541-534010 Telephone 500.00 76.50 0.00 423.50 84.70 E20 Utilities 500.00 76.50 0.00 423.50 84.70 10-541-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-546010 Clothing Expense 1,000.00 0.00 0.00 1,000.00 100.00 10-541-547010 Equipment Maintenance 1,500.00 614.20 0.00 885.80 59.05 10-541-547020 Maintenance Agreements 12,400.00 304.58 6,354.45 5,740.97 46.30 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,900.00 1,878.78 6,354.45 7,666.77 48.22 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works-Engineering 1,090,529.76 245,180.52 6,354.45 838,994.79 76.93 542 Public Works-Street 10-542-501020 Salaries 1,093,516.20 268,931.77 0.00 824,584.43 75.41 10-542-501060 Seasonal Salaries 18,000.00 0.00 0.00 18,000.00 100.00 10-542-501070 Stand-by Plan 5,000.00 1,084.00 0.00 3,916.00 78.32 10-542-501090 Overtime 35,000.00 21,271.01 0.00 13,728.99 39.23 10-542-501095 Overtime Straight Pay 500.00 432.93 0.00 67.07 13.41 10-542-502010 Social Security 88,129.24 21,606.04 0.00 66,523.20 75.48 10-542-502020 Group Health Insurance 189,300.56 47,976.13 0.00 141,324.43 74.66 10-542-502030 Retirement 167,834.39 39,279.93 0.00 128,554.46 76.60 10-542-502040 Workers Compensation 18,752.09 18,752.09 0.00 0.00 0.00 10-542-502050 Life Insurance 2,157.00 488.41 0.00 1,668.59 77.36 10-542-502060 Long Term Disability 3,352.31 918.51 0.00 2,433.80 72.60 10-542-502070 Employee Assistance Prgm 667.42 154.90 0.00 512.52 76.79 10-542-503010 Awards Program 200.00 53.00 0.00 147.00 73.50 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,622,409.21 420,948.72 0.00 1,201,460.49 74.05 10-542-511010 Advertising 300.00 0.00 0.00 300.00 100.00 10-542-511020 Postage 150.00 0.47 0.00 149.53 99.69 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 351.54 0.00 1,248.46 78.03 10-542-514020 Chemicals 280,000.00 41,153.57 0.00 238,846.43 85.30 10-542-514030 Small Tools 9,000.00 2,163.52 0.00 6,836.48 75.96 10-542-514040 Food 2,000.00 240.69 0.00 1,759.31 87.97 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 364,556.22 61,925.38 0.00 302,630.84 83.01 10-542-515040 First Aid Supplies 500.00 26.78 0.00 473.22 94.64 10-542-515060 Weed Control 3,000.00 0.00 0.00 3,000.00 100.00 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 1,188.72 0.00 3,811.28 76.23 E10 Materials & Supplies 666,406.22 107,050.67 0.00 559,355.55 83.94 10-542-520030 Dues And Publications 600.00 625.00 0.00 -25.00 -4.17 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 3,000.00 664.00 0.00 2,336.00 77.87 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 19,000.00 1,604.10 2,750.00 14,645.90 77.08 10-542-523010 Equipment Rentlease 200.00 15.00 0.00 185.00 92.50 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 23,300.00 2,908.10 2,750.00 17,641.90 75.72 10-542-531010 Electricity 30,450.00 4,567.51 0.00 25,882.49 85.00 10-542-531020 Street Lights 650,000.00 104,305.40 0.00 545,694.60 83.95 10-542-533010 Natural Gas 17,000.00 2,713.31 0.00 14,286.69 84.04 10-542-534010 Telephone 580.00 24.00 72.00 484.00 83.45 10-542-535010 Water 7,000.00 880.88 0.00 6,119.12 87.42 E20 Utilities 705,030.00 112,491.10 72.00 592,466.90 84.03 10-542-540010 Building & Grounds Maint.12,000.00 6,562.09 25.00 5,412.91 45.11 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 18,000.00 3,913.70 0.00 14,086.30 78.26 10-542-542030 Signs & Marking Paint 36,000.00 3,519.45 0.00 32,480.55 90.22 10-542-546010 Clothing Expense 10,000.00 3,878.66 0.00 6,121.34 61.21 10-542-547010 Equipment Maintenance 3,200.00 257.92 0.00 2,942.08 91.94 10-542-547020 Maintenance Agreements 300.00 0.00 0.00 300.00 100.00 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 87,500.00 24,755.82 25.00 62,719.18 71.68 10-542-572010 Purchase Of Vehicles 228,733.00 0.00 29,510.00 199,223.00 87.10 10-542-572020 Purchase Of Equipment 316,267.00 316,267.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 37 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 545,000.00 316,267.00 29,510.00 199,223.00 36.55 542 Public Works-Street 3,649,645.43 984,421.41 32,357.00 2,632,867.02 72.14 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 22,750.00 8,212.42 0.00 14,537.58 63.90 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 258,459.28 258,459.28 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,007,265.64 1,007,265.64 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,288,474.92 1,273,937.34 0.00 14,537.58 1.13 700 Transfers & Subsidies 1,288,474.92 1,273,937.34 0.00 14,537.58 1.13 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhcleqp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhcleqp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhcleqp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhcleqp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Capvhcleqp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhcleqp-street 0.00 0.00 0.00 0.00 0.00 10-900-571090 Capvhcleqp-police 0.00 0.00 0.00 0.00 0.00 10-900-571100 Capvhcleqp-fire 0.00 0.00 0.00 0.00 0.00 10-900-571110 Capvhcleqp-Animal Control 0.00 0.00 0.00 0.00 0.00 10-900-571120 Capvhcleqp-central Maint 0.00 0.00 0.00 0.00 0.00 10-900-571130 Capvhcleqp-airport 0.00 0.00 0.00 0.00 0.00 10-900-571140 Capvhcleqp-contingency 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 900 CapitalVehicleEquipment 0.00 0.00 0.00 0.00 0.00 990 Capital Projects 10-990-575015 Police HVAC 0.00 0.00 0.00 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 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 396,891.29 111,793.66 265,338.60 19,759.03 4.98 10-990-577054 Wayfinding 124,354.97 26,850.00 85,004.97 12,500.00 10.05 10-990-577056 SOMO Sewer Extension 300,000.00 0.00 0.00 300,000.00 100.00 10-990-577058 Downtown Electric 12,000.00 0.00 12,000.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 300,000.00 0.00 0.00 300,000.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 1,133,246.26 138,643.66 362,343.57 632,259.03 55.79 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 38 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 990 Capital Projects 1,133,246.26 138,643.66 362,343.57 632,259.03 55.79 Expense Expense 33,690,189.65 9,128,962.70 1,371,280.26 23,189,946.69 68.83 GL - Trial Balance by Acct Type and Full Acct Number (02/03/2017 - 8:09 AM)Page 39 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: FY2016 General Fund Revenues 32,650,443.07$ FY2016 General Fund Expenditures (30,984,506.35)$ 1,665,936.72$ ESTIMATED FYE2016 FUND BALANCE 8,676,266.72$ FYE2016 ESTIMATED Fund Balance % of Adopted Budget 28.22% Reappropriations from FY2016 to FY2017 Remaining Funds from Sale of Old Fire Station #3 (111,788.00)$ MECO Design Contract for Downtown Electric (12,000.00)$ Remaining Funds for Compensation & Class Study (20,754.89)$ Upgrade for Food Inspection Software (1,474.00)$ Remaining balance for court softward project (5,563.24)$ SOMO Sewer Extension (300,000.00)$ Remaining Funds for Public Art (3,665.00)$ NRA Rental Façade (15,066.00)$ NSP Rehab Sales (350.00)$ (470,661.13)$ 2017 Adjustments/Supplementals FY2017 Supplemental Appropriations: Matching for professional services grant for Capital Area MPO (2,250.00)$ (2,250.00)$ FYE2017 ESTIMATED Unassigned Fund Balance 8,203,355.59$ FYE2017 ESTIMATED Fund Balance % of Adopted Budget 25.46% 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 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 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 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 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** (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 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 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 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 4,136.69 9/2016 Interest Received Aug-16 9/20/16 88,674.86 37,243.44 49,657.92 4,350.78 10/2016 Interest Received Sep-16 10/31/16 100,606.10 42,254.56 56,339.42 4,292.30 11/2016 Interest Received Oct-16 11/20/16 120,471.15 50,597.88 67,463.85 4,531.06 12/2016 Interest Received Nov-16 12/20/16 88,755.07 37,277.13 49,702.83 4,602.85 1/2017 Interest Received Dec-16 1/31/16 65,709.30 27,597.91 36,797.21 Total 6,297,335.73 2,644,881.02 3,623,795.48 average monthly amount for 4 cent lockbox fund 51,860.41$ **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 56.50%52.60%54.20%55.80%47.00% September 62.60%63.30%61.20%63.00%59.30% October 62.90%60.70%67.60%65.90%59.30% November 50.60%51.30%48.90%52.40%43.40% December 42.10%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: December 2016 Percent Change from December 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 52.9 53.0 119.01 116.23 62.98 61.58 -0.1 2.4 2.3 4.2 1.8 1.7 65.5 65.4 123.97 120.30 81.19 78.68 0.1 3.1 3.2 4.8 1.6 1.7 53191 32291 5045026 3742771 West North Central 44.1 44.4 87.99 86.52 38.80 38.42 -0.7 1.7 1.0 2.5 1.5 0.8 59.1 59.6 95.91 93.28 56.68 55.58 -0.8 2.8 2.0 3.5 1.5 0.7 4471 2663 352102 256849 Missouri 47.8 47.1 88.34 86.36 42.25 40.69 1.5 2.3 3.8 3.9 0.1 1.6 61.3 59.5 95.69 93.23 58.66 55.52 2.9 2.6 5.7 5.4 -0.2 2.7 1101 636 100276 71768 Kansas City, MO-KS 51.6 51.0 92.41 90.63 47.64 46.20 1.1 2.0 3.1 3.2 0.1 1.2 64.8 65.2 99.54 95.21 64.48 62.07 -0.6 4.5 3.9 5.4 1.4 0.8 293 230 32596 27634 St Louis, MO-IL 50.1 52.0 89.02 87.79 44.62 45.64 -3.6 1.4 -2.2 -1.3 0.9 -2.7 66.0 65.4 101.00 99.06 66.61 64.77 0.9 2.0 2.9 3.8 0.9 1.8 328 246 38178 32577 Columbia, MO+43.6 43.3 76.89 76.95 33.51 33.34 0.6 -0.1 0.5 -0.1 -0.6 -0.0 59.0 56.5 88.57 86.97 52.23 49.13 4.4 1.8 6.3 5.4 -0.9 3.5 38 29 3830 3080 Jefferson City, MO+42.1 45.1 73.61 73.48 30.99 33.13 -6.6 0.2 -6.4 -6.4 0.0 -6.6 58.2 55.9 81.51 78.22 47.43 43.76 4.0 4.2 8.4 8.4 0.0 4.0 15 11 1494 1063 Springfield, MO 47.0 46.3 74.06 73.78 34.79 34.15 1.5 0.4 1.9 1.8 -0.1 1.4 61.4 59.7 79.49 77.45 48.79 46.26 2.8 2.6 5.5 6.2 0.7 3.5 69 47 6205 4513 Branson, MO 49.6 40.4 100.39 98.35 49.74 39.72 22.7 2.1 25.2 25.2 -0.0 22.7 54.5 48.5 98.99 98.65 53.95 47.83 12.4 0.3 12.8 10.3 -2.2 9.9 142 29 12512 4151 Lake of the Ozarks+25.7 24.6 91.65 81.62 23.55 20.09 4.4 12.3 17.2 17.2 0.0 4.4 48.4 44.2 101.84 99.19 49.25 43.86 9.4 2.7 12.3 13.8 1.3 10.8 32 11 2615 1544 Joplin, MO 48.8 46.6 74.20 73.74 36.19 34.39 4.6 0.6 5.2 -2.7 -7.5 -3.3 60.2 55.9 79.10 76.01 47.58 42.50 7.6 4.1 12.0 2.2 -8.7 -1.8 30 23 2300 2011 Saint Joseph, MO+45.3 42.3 81.40 79.01 36.90 33.41 7.2 3.0 10.5 10.5 0.0 7.2 59.1 58.0 82.53 79.46 48.80 46.07 2.0 3.9 5.9 5.9 0.0 2.0 14 10 1291 999 A blank row indicates insufficient data.Source 2017 STR, Inc. RevPAR PropertiesADR Participation Occ % Current Month - December 2016 vs December 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 - December 2016 vs December 2015 Rooms Tab 3 - Help All data is processed by STR using both the current and historical sampling of hotels. For further questions about the methodology used to produce our reports, please email destin@str.com. Average Daily Rate (ADR) Room revenue divided by rooms sold, displayed as the average rental rate for a single room. Census (properties and rooms) The number of properties and rooms that exist in our database for the area(s) or segment(s) shown on the report. Contract Rooms Contract rooms are occupied at rates stipulated by contracts – such as for airline crews and permanent guests. Room allotments that do not require guaranteed use or payment should not be classified as contract. Rooms sold under such allotments should be classified as transient. Country A geographic area that has internationally recognized boundaries, an organized economy, and a sovereign government with external recognition. It is typically recognized by the International Organization for Standardization (ISO). Custom Segments Defined by a + at the end of the segment name. If a custom segment is based on a selected group of properties, new properties that come into the area will NOT automatically be added to this segment. The new property can be added alone as long as it has no more than five months of data. Once the property has six or more months of data it is considered an established property, requiring a two property change (add one/drop one or add two). Demand (Rooms Sold) The number of rooms sold or rented (excludes complimentary rooms). Exchange Rate The factor used to convert revenue from U.S. Dollars to the local currency. The exchange rate data is obtained from Oanda.com. Any aggregated number in the report (YTD, Running 3 month, Running 12 month) uses the exchange rate of each relative month when calculating the data. Group Rooms Group rooms are sold simultaneously in blocks of a minimum of ten rooms or more (e.g. group tours, domestic and international groups, association, convention and corporate groups). Index Index (Occupancy, ADR, RevPar) - Property performance divided by competitive set performance multiplied by 100. Internationally, indexes are also referred to as MPI – Market Penetration Index (Occupancy Index), ARI – Average Rate Index (ADR Index), and RGI – Revenue/RevPAR Generation Index (RevPAR Index). Market A geographic area within a country. Markets are defined by STR and STR Global. Occupancy (Occ) Rooms sold divided by rooms available multiplied by 100. Occupancy is always expressed as a percentage of rooms occupied. Percent Change Amount of growth - up, flat, or down - this period versus same period last year (month or year-to-date). Calculated as ((TY - LY) / LY) * 100. Revenue (Room Revenue) Total room revenue generated from the sale or rental of rooms. RevPAR (Revenue Per Available Room) Room revenue divided by rooms available. Sample or % Room Participants The percent of rooms from which STR receives data. Calculated as (Sample Rooms/Census Rooms)* "100" Sub-Market A geographic sub-area within a Market. Sub-markets are defined by STR and STR Global. Supply (Rooms Available) The number of rooms times the number of days in the period. Transient Rooms Transient rooms Include rooms occupied by those with reservations at rack, corporate, corporate negotiated, package, government, or foreign traveler rates. Also includes occupied rooms booked via third party web sites (exception: simultaneous bookings of ten or more rooms which should be defined as group). Twelve Month Moving Average Measures (Occ, ADR, RevPAR, Supply, Demand, Revenue) are calculated using the sum of the values of the given month and of the preceding eleven months. WD (Weekday) Average of Sunday through Thursday WE (Weekend) Average of Friday and Saturday Measures (Occ, ADR, RevPAR, Supply, Demand, Revenue) are calculated using the sum of the values from January 1 of the given year.