Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2019-05-23 NO meeting packet
Notice of CANCELLATION of Meeting CITY OF JEFFERSON Finance Committee Thursday, May 23, 2019 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room Memo To:Steve Crowell From:Shiela Pearre Date:May 7, 2019 Re:Sales Tax Revenues The City received the May 1% Sales Tax in the amount of $731,421 which is $26,509 more than projected for May. January through May shortage is $26,323 (0.23%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-18 Jan-19 $1,071,917 $ 998,455 $73,462 Dec-18 Feb-19 $885,496 $ 877,738 $7,758 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $1,088,631 $ 1,176,381 ($87,750) Feb-19 Apr-19 $892,285 $ 938,586 ($46,301) Mar-19 May-19 $731,421 $ 704,912 $26,509 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 1,090,066 May-19 Jul-19 $ 1,131,589 Jun-19 Aug-19 $ 744,888 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 1,196,290 Aug-19 Oct-19 $ 918,967 Sep-19 Nov-19 $ 694,005 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 1,169,382 Total Overage/Shortfall $4,669,750 $11,641,260 ($26,323) 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G Receipt Actual Budget Period Receipts Projection2 Variance Nov-18 Jan-19 $525,696 $ 428,843 $96,853 Dec-18 Feb-19 $427,711 $ 376,994 $50,717 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $527,714 $ 505,264 $22,450 Feb-19 Apr-19 $430,468 $ 403,129 $27,339 Mar-19 May-19 $351,775 $ 302,764 $49,011 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 468,191 May-19 Jul-19 $ 486,025 Jun-19 Aug-19 $ 319,934 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 513,814 Aug-19 Oct-19 $ 394,703 Sep-19 Nov-19 $ 298,080 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 502,257 * BUDGET AMENDMENT DUE TO ORDINANCE 15775 $0 $ 490,329 ($490,329) Total Overage/Shortfall $2,263,364 $5,490,329 ($243,960) 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-18 Jan-19 $525,690 $ 450,285 $75,404 Dec-18 Feb-19 $427,689 $ 395,844 $31,845 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $527,588 $ 530,527 ($2,939) Feb-19 Apr-19 $430,459 $ 423,286 $7,173 Mar-19 May-19 $350,479 $ 317,903 $32,577 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 491,600 May-19 Jul-19 $ 510,327 Jun-19 Aug-19 $ 335,931 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 539,505 Aug-19 Oct-19 $ 414,438 Sep-19 Nov-19 $ 312,984 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 527,370 Total Overage/Shortfall $2,261,905 $5,250,000 $144,060 3Budgeted based on 3-year average percentage * Original budget amendment due to Ordinance 1577 = $1,035,852 less FY18 overage of $490,329 Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 5/7/2019 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: MAY 2019 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 act.916,537 Dec February 727,437 812,670 806,789 927,290 885,496 act.812,803 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 1,088,631 act.1,084,976 Feb April 1,059,943 893,024 843,561 986,714 892,285 act.904,145 Mar May 618,854 648,305 687,741 709,248 731,421 act.693,383 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,090,066 est.1,014,936 May July 963,280 1,012,207 1,154,051 1,117,038 1,131,589 est.1,059,066 Jun August 562,996 661,518 678,636 821,132 744,888 est.667,666 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,196,290 est.1,130,637 Aug October 918,839 903,829 883,215 879,331 918,967 est.900,850 Sept November 661,849 623,645 615,667 774,337 694,005 est.665,316 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,169,382 est.1,096,782 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 4,669,750 Estimated to Fiscal Year end (based on averages and on Budgeted amount)6,945,187 Total Actual & Estimated $ 11,614,937 Less: Budget 11,641,260 Over (Under) Budget -$ 26,323 $ 1,071,917 $ 1,957,413 $ 3,046,044 $ 3,938,329 $ 4,669,750 $ 998,455 $ 1,876,193 $ 3,052,575 $ 3,991,161 $ 4,696,073 $ 5,786,139 $ 6,917,728 $ 7,662,616 $ 8,858,906 $ 9,777,873 $ 10,471,878 $ 11,641,260 $ 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$ 12,250,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 5/7/2019 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: MAY 2019 Account Number 45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 461,560 455,278 525,521 424,160 525,696 act.445,264 Dec February 362,597 405,543 402,964 444,476 427,711 act.402,011 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 act.516,175 Feb April 512,808 431,353 411,020 455,943 430,468 act.431,859 Mar May 308,247 322,957 340,162 340,740 351,755 act.342,394 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 468,191 est.490,034 May July 473,120 498,229 559,119 548,625 486,025 est.516,592 Jun August 280,733 330,112 338,618 393,512 319,934 est.329,826 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 513,814 est.541,722 Aug October 442,371 435,416 425,493 423,478 394,703 est.431,389 Sept November 330,393 310,506 307,281 374,512 298,080 est.329,478 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 502,257 est.531,426 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 2,263,344 Estimated to Fiscal Year end (based on averages and on Budgeted amount)2,983,005 Total Actual & Estimated $ 5,246,349 Less: Budget 5,000,000 Over (Under) Budget $ 246,349 $ 525,696 $ 953,407 $ 1,481,121 $ 1,911,589 $ 2,263,344 $ 428,843 $ 805,838 $ 1,311,101 $ 1,714,231 $ 2,016,995 $ 2,485,186 $ 2,971,211 $ 3,291,146 $ 3,804,960 $ 4,199,663 $ 4,497,743 $ 5,000,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 $ 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 City of Jefferson, Mo. - Account Analysis Printed 5/7/2019 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: MAY 2019 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 461,472 455,239 525,521 424,192 525,690 act.445,226 Dec February 362,371 405,543 395,217 450,479 427,689 act.401,434 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 527,588 act.516,368 Feb April 512,738 431,353 411,020 457,060 430,459 act.432,049 Mar May 308,030 322,957 340,162 340,708 350,479 act.341,988 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 491,600 est.490,007 May July 473,038 498,229 559,115 548,639 510,327 est.516,562 Jun August 280,513 330,112 338,470 393,578 335,931 est.329,720 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 539,505 est.542,253 Aug October 442,370 435,416 425,497 423,387 414,438 est.431,353 Sept November 330,393 310,506 307,305 374,484 312,984 est.329,434 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 527,370 est.531,381 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 2,261,905 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,132,155 Total Actual & Estimated $ 5,394,060 Less: Budget 5,250,000 Over (Under) Budget $ 144,060 $ 525,690 $ 953,379 $ 1,480,967 $ 1,911,426 $ 2,261,905 $ 450,285 $ 846,130 $ 1,376,657 $ 1,799,942 $ 2,117,845 $ 2,609,445 $ 3,119,772 $ 3,455,703 $ 3,995,208 $ 4,409,646 $ 4,722,630 $ 5,250,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 $ 5,350,000 $ 5,600,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 Re v e n u e Mo d e l Re p o r t Fo r th e Pe r i o d En d i n g Ap r i l 30 , 20 1 9 Da t a as of Ma y 7, 20 1 9 . FY 20 1 9 Y T D Ac t u a l P r o j e c t e d Ov e r / De s c r i p t i o n Bu d g e t As of 5/ 7 / 1 9 (U n d e r ) Bu d g e t Sa l e s Ta x an d Us e Ta x $1 1 , 6 4 1 , 2 6 0 . 0 0 $ 4 , 6 6 9 , 7 4 9 . 9 6 ($ 2 6 , 3 2 2 . 7 5 ) In t e r g o v e r n m e n t a l Ta x e s $2 , 3 0 0 , 0 0 0 . 0 0 $ 1 , 1 5 3 , 6 4 7 . 9 4 $ 4 5 , 0 5 1 . 5 0 Ot h e r Ta x e s $1 1 0 , 0 0 0 . 0 0 $ 3 8 , 9 8 7 . 4 8 ($ 5 , 0 2 9 . 5 8 ) Fr a n c h i s e & Ut i l i t y Ta x $7 , 4 3 5 , 0 0 0 . 0 0 $ 2 , 8 1 3 , 9 9 1 . 6 6 ($ 1 9 3 , 0 2 6 . 4 4 ) Pr o p e r t y Ta x e s $5 , 4 3 2 , 3 9 9 . 0 0 $ 5 , 3 2 0 , 3 1 3 . 7 0 $ 3 7 , 7 1 0 . 4 4 In t e r g o v e r n m e n t a l $0 . 0 0 $ 1 2 0 , 4 6 3 . 0 9 $ 7 3 , 3 6 5 . 7 1 Ch a r g e s fo r Se r v i c e s $2 , 7 6 1 , 3 6 4 . 3 9 $ 2 , 1 5 9 , 3 1 5 . 7 5 $ 1 6 , 6 3 1 . 6 4 Fe e s , Li c e n s e s , & Pe r m i t s $8 7 9 , 4 1 0 . 0 0 $ 4 0 1 , 8 5 3 . 4 0 $ 3 7 , 6 1 1 . 6 3 Fi n e s & Fo r f e i t u r e s $8 3 4 , 9 0 0 . 0 0 $ 3 7 2 , 5 5 9 . 9 5 ($ 6 6 , 8 1 6 . 3 8 ) Co n t r i b u t i o n s / D o n a t i o n s $3 3 4 , 3 6 4 . 8 8 $ 1 3 4 , 0 1 1 . 1 3 $ 1 3 , 7 7 0 . 4 3 Ot h e r Op e r a t i n g Re v e n u e s $9 5 , 0 0 0 . 0 0 $ 1 1 4 , 1 0 6 . 7 6 $ 7 5 , 7 8 6 . 5 6 In t e r e s t In c o m e $1 5 2 , 9 2 6 . 5 4 $ 6 9 , 6 5 3 . 3 4 $ 9 , 4 3 1 . 7 3 Ot h e r No n Op e r a t i n g Re v e n u e $1 0 4 , 3 6 5 . 0 0 $ 1 1 7 , 0 6 9 . 4 0 $ 3 2 , 7 0 4 . 4 0 Op e r a t i n g Tr a n s f e r s In $2 6 , 0 0 0 . 0 0 $9 , 5 3 0 . 0 1 $5 4 . 3 5 To t a l s $3 2 , 1 0 6 , 9 8 9 . 8 1 $ 1 7 , 4 9 5 , 2 5 3 . 5 7 $ 5 0 , 9 2 3 . 2 4 FY2019 Revenue Model Report (Detail)Remaining For the Period Ending April 30, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 5/7/19 As of 5/7/19 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,641,260.00 $4,669,749.96 $6,945,187.29 $11,614,937.25 ($26,322.75)($26,322.75) $11,641,260.00 $4,669,749.96 $6,945,187.29 $11,614,937.25 ($26,322.75) ($26,322.75) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $590,000.00 $180,012.74 $396,875.56 $576,888.30 ($13,111.70)($13,111.70) 10‐100‐403010 Gasoline Tax $1,160,000.00 $363,754.51 $794,528.00 $1,158,282.51 ($1,717.49)($1,717.49) 10‐100‐430080 Road & Bridge Tax $550,000.00 $609,880.69 $0.00 $609,880.69 $59,880.69 $59,880.69 $2,300,000.00 $1,153,647.94 $1,191,403.56 $2,345,051.50 $45,051.50 $45,051.50 Other Taxes 10‐100‐403020 Cig Tax $110,000.00 $38,987.48 $65,982.94 $104,970.42 ($5,029.58)($5,029.58) $110,000.00 $38,987.48 $65,982.94 $104,970.42 ($5,029.58)($5,029.58) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,060,000.00 $1,390,081.38 $2,648,951.65 $4,039,033.03 ($20,966.97)($20,966.97) 10‐100‐410021 Electric Utility‐AUDIT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐410030 Gas Utility License Tax $920,000.00 $613,388.17 $326,471.15 $939,859.32 $19,859.32 $19,859.32 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $729,508.69 $1,179,352.53 $1,908,861.22 ($141,138.78)($141,138.78) 10‐100‐410053 Telephone/Cell Audit $0.00 ($14,210.20)$15,210.20 $1,000.00 $1,000.00 $1,000.00 10‐100‐410060 Cable Franchise Fee $405,000.00 $95,223.62 $257,996.37 $353,219.99 ($51,780.01)($51,780.01) $7,435,000.00 $2,813,991.66 $4,427,981.90 $7,241,973.56 ($193,026.44)($193,026.44) Property Taxes 10‐100‐420010 Current Property Tax $4,760,000.00 $4,709,848.57 $77,909.19 $4,787,757.76 $27,757.76 $27,757.76 10‐100‐420020 Del Property Tax $40,000.00 $30,493.51 $21,564.69 $52,058.20 $12,058.20 $12,058.20 10‐100‐420040 Fin Institution Tax $44,000.00 $32,895.44 $0.00 $32,895.44 ($11,104.56)($11,104.56) 10‐100‐420050 Prop Tax Int & Penalties $28,000.00 $13,173.93 $16,097.60 $29,271.53 $1,271.53 $1,271.53 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 $458,199.86 $8,679.49 $466,879.35 $1,879.35 $1,879.35 10‐100‐420080 Special Tax Rev $41,000.00 $21,303.11 $25,544.76 $46,847.87 $5,847.87 $5,847.87 $5,432,399.00 $5,320,313.70 $149,795.74 $5,470,109.44 $37,710.44 $37,710.44 Intergovernmental 10‐100‐430010 Federal Grant $0.00 $68,537.56 $0.00 $68,537.56 $68,537.56 $68,537.56 10‐100‐430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480020 NSP Rehab Sales $0.00 $47,097.38 ($47,097.38)$0.00 $0.00 $0.00 10‐100‐480025 HUD Program Income $0.00 $4,828.15 $0.00 $4,828.15 $4,828.15 $4,828.15 $0.00 $120,463.09 ($47,097.38)$73,365.71 $73,365.71 $73,365.71 Charges for Services 10‐100‐440010 Admin Charge Backs $1,555,433.00 $1,558,195.00 $0.00 $1,558,195.00 $2,762.00 $2,762.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 $21,000.00 $18,502.00 $10,206.40 $28,708.40 $7,708.40 $7,708.40 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $3,978.93 $7,573.84 $11,552.77 ($1,447.23)($1,447.23) 10‐100‐440920 Parts Charge backs $185,000.00 $90,060.58 $95,478.88 $185,539.46 $539.46 $539.46 10‐100‐440930 Labor Charge backs $245,000.00 $110,627.96 $140,153.52 $250,781.48 $5,781.48 $5,781.48 10‐100‐481020 Cole Cty Animal Rescue $110,461.78 $55,208.40 $55,230.88 $110,439.28 ($22.50)($22.50) 10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481040 Rent Other $12,000.00 $0.00 $12,000.00 $12,000.00 $0.00 $0.00 10‐100‐481045 Rent‐tower Sites $155,000.00 $63,154.66 $94,544.14 $157,698.80 $2,698.80 $2,698.80 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 $384,123.31 $191,460.82 $192,061.62 $383,522.44 ($600.87)($600.87) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $30.00 $0.00 $30.00 $30.00 $30.00 10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $7,500.00 $9,350.00 $16,850.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $4,150.00 $1,251.00 $2,081.01 $3,332.01 ($817.99)($817.99) 10‐100‐481105 TIF Administration Fee $9,346.30 $9,346.30 $0.00 $9,346.30 $0.00 $0.00 10‐100‐481110 Long & Short $0.00 $0.10 $0.00 $0.10 $0.10 $0.10 $2,761,364.39 $2,159,315.75 $618,680.28 $2,777,996.03 $16,631.64 $16,631.64 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $66,000.00 $49,555.00 $19,879.85 $69,434.85 $3,434.85 $3,434.85 10‐100‐450020 Business Licenses $221,770.00 $98,577.83 $113,789.96 $212,367.79 ($9,402.21)($9,402.21) 10‐100‐450021 Home Occupation Permit $1,870.00 $1,155.00 $843.54 $1,998.54 $128.54 $128.54 10‐100‐450040 Abandoned Bldg. Regist. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐450041 Abandoned Bldg. Admin Fee $8,000.00 $4,248.00 $4,000.00 $8,248.00 $248.00 $248.00 10‐100‐450045 Building Construct. Fees $283,000.00 $122,979.57 $192,690.76 $315,670.33 $32,670.33 $32,670.33 10‐100‐450050 Electrical Certificates $20,000.00 $18,807.00 $2,794.87 $21,601.87 $1,601.87 $1,601.87 10‐100‐450060 Electrical Permits $2,600.00 $2,453.30 $1,550.67 $4,003.97 $1,403.97 $1,403.97 10‐100‐450070 Plumbing Licenses $11,000.00 $9,939.00 $1,913.88 $11,852.88 $852.88 $852.88 10‐100‐450080 Plumbing Permits $5,000.00 $5,694.00 $2,781.79 $8,475.79 $3,475.79 $3,475.79 FY2019 Revenue Model Report (Detail)Remaining For the Period Ending April 30, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 5/7/19 As of 5/7/19 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $135.00 $1,107.51 $1,242.51 ($757.49)($757.49) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $3,690.00 $3,458.88 $7,148.88 $148.88 $148.88 10‐100‐450092 Food Inspection Fees $87,550.00 $5,423.30 $82,722.13 $88,145.43 $595.43 $595.43 10‐100‐450100 Curb Cut Permits $850.00 $165.00 $653.35 $818.35 ($31.65)($31.65) 10‐100‐450110 Board Of Adj Fees $3,770.00 $2,800.00 $1,993.75 $4,793.75 $1,023.75 $1,023.75 10‐100‐450120 Sign Permits $6,300.00 $3,207.00 $3,102.74 $6,309.74 $9.74 $9.74 10‐100‐450130 Demolition Permits $1,600.00 $500.00 $974.63 $1,474.63 ($125.37)($125.37) 10‐100‐450150 Acc Rep Fees‐police $12,000.00 $4,433.40 $6,266.30 $10,699.70 ($1,300.30)($1,300.30) 10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $317.00 $837.70 $1,154.70 $104.70 $104.70 10‐100‐450170 Animal Redemption Fees $65,000.00 $29,829.00 $37,372.45 $67,201.45 $2,201.45 $2,201.45 10‐100‐450180 Animal Vaccinations Fees $5,000.00 $2,825.00 $2,568.92 $5,393.92 $393.92 $393.92 10‐100‐450185 Animal Cremation Fees $42,000.00 $21,880.00 $23,624.13 $45,504.13 $3,504.13 $3,504.13 10‐100‐450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐450190 Taxi Permits $0.00 $54.00 $0.00 $54.00 $54.00 $54.00 10‐100‐450230 Vacating Right Of Way $800.00 $272.00 $276.92 $548.92 ($251.08)($251.08) 10‐100‐450250 Rezoning Request $16,100.00 $0.00 $4,997.18 $4,997.18 ($11,102.82)($11,102.82) 10‐100‐450255 Planning & Zoning Review Fees $7,350.00 $11,629.00 $3,968.13 $15,597.13 $8,247.13 $8,247.13 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,285.00 $998.17 $2,283.17 $483.17 $483.17 $879,410.00 $401,853.40 $515,168.23 $917,021.63 $37,611.63 $37,611.63 Fines & Forfeitures 10‐100‐460010 Court Cost $74,000.00 $31,968.66 $35,675.32 $67,643.98 ($6,356.02)($6,356.02) 10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐460018 Inmate Security Fund $12,000.00 $5,288.10 $5,776.99 $11,065.09 ($934.91)($934.91) 10‐100‐460020 Jail Cost Recovery $1,500.00 $551.65 $666.96 $1,218.61 ($281.39)($281.39) 10‐100‐460025 Alcohol Offense Cost Rec $6,000.00 $2,046.79 $2,671.57 $4,718.36 ($1,281.64)($1,281.64) 10‐100‐460030 Pol Fines‐traffic $685,000.00 $305,180.32 $328,176.60 $633,356.92 ($51,643.08)($51,643.08) 10‐100‐460090 Parking Fines $60,000.00 $28,749.50 $24,954.32 $53,703.82 ($6,296.18)($6,296.18) 10‐100‐460100 Bankcard Charges ($3,600.00)($1,225.07)($2,398.08)($3,623.15)($23.15)($23.15) $834,900.00 $372,559.95 $395,523.67 $768,083.62 ($66,816.38)($66,816.38) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480070 Community Projects Donations $11,616.50 $12,366.50 $0.00 $12,366.50 $750.00 $750.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 $14,656.63 $0.00 $14,656.63 $14,656.63 $14,656.63 10‐100‐481055 Street Repair‐Solid Waste Cntr $322,248.38 $105,988.00 $214,124.18 $320,112.18 ($2,136.20)($2,136.20) 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $334,364.88 $134,011.13 $214,124.18 $348,135.31 $13,770.43 $13,770.43 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $74,279.21 $0.00 $74,279.21 $74,279.21 $74,279.21 10‐100‐481070 Miscellaneous $45,000.00 $19,558.64 $21,728.09 $41,286.73 ($3,713.27)($3,713.27) 10‐100‐481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481074 Revenue Share ‐ Purchasing Card $20,000.00 $6,078.08 $13,665.68 $19,743.76 ($256.24)($256.24) 10‐100‐481077 Insurance Claims $20,000.00 $14,190.83 $11,286.02 $25,476.85 $5,476.85 $5,476.85 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $95,000.00 $114,106.76 $56,679.80 $170,786.56 $75,786.56 $75,786.56 Interest Income 10‐100‐470010 Interest $152,926.54 $69,653.34 $92,704.93 $162,358.27 $9,431.73 $9,431.73 $152,926.54 $69,653.34 $92,704.93 $162,358.27 $9,431.73 $9,431.73 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $104,365.00 $117,069.40 $20,000.00 $137,069.40 $32,704.40 $32,704.40 $104,365.00 $117,069.40 $20,000.00 $137,069.40 $32,704.40 $32,704.40 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $9,530.01 $16,524.34 $26,054.35 $54.35 $54.35 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,000.00 $9,530.01 $16,524.34 $26,054.35 $54.35 $54.35 $32,106,989.81 $17,495,253.57 $14,662,659.48 $32,157,913.05 $50,923.24 $50,923.24 General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 05/09/19 11:42:11 Period 01 - 06 Fiscal Year 2019 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10 General Fund Expense Expense 110 Mayor & Council 10-110-501010 Salary-Elected Officials 65,925.00 32,400.00 0.00 33,525.00 50.85 10-110-501015 Salary-Prosecuting Attorney 34,999.92 17,499.96 0.00 17,499.96 50.00 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 7,720.76 3,557.42 0.00 4,163.34 53.92 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 208.54 208.54 0.00 0.00 0.00 E05 Personnel Services 108,854.22 53,665.92 0.00 55,188.30 50.70 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 40.00 0.00 60.00 60.00 10-110-512020 Copies 200.00 0.00 0.00 200.00 100.00 10-110-513010 Office Supplies 1,300.00 782.48 0.00 517.52 39.81 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 1,700.00 822.48 0.00 877.52 51.62 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,500.00 417.04 -949.90 2,032.86 135.52 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 900.00 180.00 0.00 720.00 80.00 10-110-522020 Professional Services 100.00 70.00 0.00 30.00 30.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 5,374.94 -949.90 3,074.96 41.00 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 80.00 37.86 37.92 4.22 5.28 E25 Repairs & Maintenance 80.00 37.86 37.92 4.22 5.28 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 118,134.22 59,901.20 -911.98 59,145.00 50.07 120 City Clerk 10-120-501020 Salaries 48,798.92 22,921.65 0.00 25,877.27 53.03 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 3,733.12 1,574.19 0.00 2,158.93 57.83 10-120-502020 Group Health Insurance 11,025.25 4,991.72 0.00 6,033.53 54.72 10-120-502030 Retirement 6,099.87 2,855.03 0.00 3,244.84 53.20 10-120-502040 Workers Compensation 46.14 46.14 0.00 0.00 0.00 10-120-502050 Life Insurance 76.38 29.63 0.00 46.75 61.21 10-120-502060 Long Term Disability 165.97 70.60 0.00 95.37 57.46 10-120-502070 Employee Assistance Prgm 27.24 12.78 0.00 14.46 53.08 E05 Personnel Services 69,972.89 32,501.74 0.00 37,471.15 53.55 10-120-511020 Postage 200.00 47.03 0.00 152.97 76.49 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 156.01 0.00 143.99 48.00 10-120-513010 Office Supplies 500.00 85.61 0.00 414.39 82.88 E10 Materials & Supplies 1,000.00 288.65 0.00 711.35 71.14 10-120-520030 Dues And Publications 275.00 15.00 0.00 260.00 94.55 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 205.00 0.00 795.00 79.50 10-120-522020 Professional Services 400.00 150.60 0.00 249.40 62.35 10-120-529030 Election Expense 20,000.00 16,959.71 0.00 3,040.29 15.20 E15 Contractual Services 21,675.00 17,330.31 0.00 4,344.69 20.04 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 380.00 37.92 37.92 304.16 80.04 E25 Repairs & Maintenance 380.00 37.92 37.92 304.16 80.04 10-120-572020 Purchase Of Equipment 7,745.00 0.00 0.00 7,745.00 100.00 E70 Capital Purchases 7,745.00 0.00 0.00 7,745.00 100.00 120 City Clerk 100,772.89 50,158.62 37.92 50,576.35 50.19 140 City Administrator 10-140-501020 Salaries 214,821.04 99,194.35 0.00 115,626.69 53.82 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-502010 Social Security 16,433.81 5,858.37 0.00 10,575.44 64.35 10-140-502020 Group Health Insurance 21,507.54 9,880.78 0.00 11,626.76 54.06 10-140-502030 Retirement 26,852.63 11,940.61 0.00 14,912.02 55.53 10-140-502040 Workers Compensation 184.99 184.99 0.00 0.00 0.00 10-140-502050 Life Insurance 138.56 53.73 0.00 84.83 61.22 10-140-502060 Long Term Disability 300.86 127.76 0.00 173.10 57.54 10-140-502070 Employee Assistance Prgm 54.48 25.58 0.00 28.90 53.05 E05 Personnel Services 280,293.91 127,266.17 0.00 153,027.74 54.60 10-140-511010 Advertising 500.00 0.00 0.00 500.00 100.00 10-140-511020 Postage 250.00 33.17 0.00 216.83 86.73 10-140-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-140-512020 Copies 250.00 57.98 0.00 192.02 76.81 10-140-513010 Office Supplies 750.00 37.35 0.00 712.65 95.02 10-140-517010 Operational Supplies 1,000.00 398.63 0.00 601.37 60.14 E10 Materials & Supplies 2,950.00 527.13 0.00 2,422.87 82.13 10-140-520030 Dues And Publications 800.00 208.69 0.00 591.31 73.91 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 1,639.00 0.00 361.00 18.05 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 500.00 18.60 0.00 481.40 96.28 E15 Contractual Services 3,300.00 1,866.29 0.00 1,433.71 43.45 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 235.00 38.40 37.92 158.68 67.52 E25 Repairs & Maintenance 235.00 38.40 37.92 158.68 67.52 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 286,778.91 129,697.99 37.92 157,043.00 54.76 149 Entitlement Grant 10-149-501020 Salaries 39,424.11 16,064.79 0.00 23,359.32 59.25 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,015.94 1,200.72 0.00 1,815.22 60.19 10-149-502020 Group Health Insurance 6,095.64 2,448.52 0.00 3,647.12 59.83 10-149-502030 Retirement 4,928.01 2,003.61 0.00 2,924.40 59.34 10-149-502040 Workers Compensation 74.27 74.27 0.00 0.00 0.00 10-149-502050 Life Insurance 62.91 19.86 0.00 43.05 68.43 10-149-502060 Long Term Disability 133.54 47.75 0.00 85.79 64.24 10-149-502070 Employee Assistance Program 27.24 12.78 0.00 14.46 53.08 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 53,761.66 21,872.30 0.00 31,889.36 59.32 10-149-511010 Advertising 1,500.00 318.25 0.00 1,181.75 78.78 10-149-511020 Postage 500.00 113.50 0.00 386.50 77.30 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 164.86 0.00 835.14 83.51 10-149-517010 Operational Supplies 525.00 0.00 0.00 525.00 100.00 E10 Materials & Supplies 3,525.00 596.61 0.00 2,928.39 83.07 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,000.00 503.00 0.00 1,497.00 74.85 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 25,000.00 498.00 0.00 24,502.00 98.01 10-149-528012 Housing Rehab-Energy Efficienc 27,000.00 4,200.00 0.00 22,800.00 84.44 10-149-528020 Housing Assistance 75,000.00 0.00 0.00 75,000.00 100.00 10-149-528030 Public Improvement 249,450.00 0.00 0.00 249,450.00 100.00 10-149-528040 Neighborhood Redevelopmnt 118,487.74 23,070.00 0.00 95,417.74 80.53 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 15,099.00 7,873.00 0.00 7,226.00 47.86 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 512,036.74 36,144.00 0.00 475,892.74 92.94 10-149-547020 Maintenance Agreements 150.00 59.45 64.05 26.50 17.67 E25 Repairs & Maintenance 150.00 59.45 64.05 26.50 17.67 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 10-149-577064 Broadway St 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 569,473.40 58,672.36 64.05 510,736.99 89.69 150 City Counselor 10-150-501020 Salaries 209,766.44 98,475.66 0.00 111,290.78 53.05 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,047.13 7,240.81 0.00 8,806.32 54.88 10-150-502020 Group Health Insurance 37,373.71 15,049.66 0.00 22,324.05 59.73 10-150-502030 Retirement 26,220.80 12,265.60 0.00 13,955.20 53.22 10-150-502040 Workers Compensation 212.20 212.20 0.00 0.00 0.00 10-150-502050 Life Insurance 328.03 127.09 0.00 200.94 61.26 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502060 Long Term Disability 631.34 267.08 0.00 364.26 57.70 10-150-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 290,661.37 133,676.46 0.00 156,984.91 54.01 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 600.00 103.81 0.00 496.19 82.70 10-150-512010 Printing 150.00 0.00 0.00 150.00 100.00 10-150-512020 Copies 100.00 0.11 0.00 99.89 99.89 10-150-513010 Office Supplies 1,800.00 661.94 0.00 1,138.06 63.23 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,650.00 765.86 0.00 1,884.14 71.10 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,500.00 5,280.24 3,430.98 2,788.78 24.25 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 752.62 0.00 4,247.38 84.95 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,000.00 0.00 0.00 2,000.00 100.00 10-150-522020 Professional Services 10,000.00 174.60 0.00 9,825.40 98.25 10-150-525030 Litigation Expenses 1,000.00 16.24 0.00 983.76 98.38 E15 Contractual Services 29,500.00 6,223.70 3,430.98 19,845.32 67.27 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 680.00 37.92 37.92 604.16 88.85 E25 Repairs & Maintenance 680.00 37.92 37.92 604.16 88.85 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 323,491.37 140,703.94 3,468.90 179,318.53 55.43 160 Municipal Court 10-160-501010 Salary-elected Officals 23,333.04 7,291.67 0.00 16,041.37 68.75 10-160-501020 Salaries 117,826.24 55,268.77 0.00 62,557.47 53.09 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)21,945.35 2,346.31 0.00 19,599.04 89.31 10-160-501090 Overtime 3,000.00 674.04 0.00 2,325.96 77.53 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 13,599.53 4,797.66 0.00 8,801.87 64.72 10-160-502020 Group Health Insurance 29,055.90 13,187.85 0.00 15,868.05 54.61 10-160-502030 Retirement 15,103.28 6,968.21 0.00 8,135.07 53.86 10-160-502040 Workers Compensation 318.71 318.71 0.00 0.00 0.00 10-160-502050 Life Insurance 186.29 72.41 0.00 113.88 61.13 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502060 Long Term Disability 400.74 170.36 0.00 230.38 57.49 10-160-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 E05 Personnel Services 224,850.80 91,134.35 0.00 133,716.45 59.47 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,800.00 1,584.58 0.00 2,215.42 58.30 10-160-512010 Printing 590.00 303.00 0.00 287.00 48.64 10-160-512020 Copies 500.00 22.75 0.00 477.25 95.45 10-160-513010 Office Supplies 5,500.00 1,591.90 0.00 3,908.10 71.06 E10 Materials & Supplies 10,390.00 3,502.23 0.00 6,887.77 66.29 10-160-520025 Security 11,500.00 4,281.89 -9,150.18 16,368.29 142.33 10-160-520030 Dues And Publications 350.00 60.00 0.00 290.00 82.86 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 2,000.00 300.00 0.00 1,700.00 85.00 10-160-522020 Professional Services 16,667.00 14,852.34 0.00 1,814.66 10.89 10-160-525005 Appointed Counsel 5,000.00 2,038.25 0.00 2,961.75 59.24 10-160-525010 Care Of Prisoners 500.00 0.00 0.00 500.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 36,057.00 21,532.48 -9,150.18 23,674.70 65.66 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 1,100.00 37.92 37.92 1,024.16 93.11 E25 Repairs & Maintenance 1,100.00 37.92 37.92 1,024.16 93.11 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-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 160 Municipal Court 272,397.80 116,206.98 -9,112.26 165,303.08 60.68 170 Human Resources 10-170-501020 Salaries 208,326.08 97,780.46 0.00 110,545.62 53.06 10-170-501050 Parttime(wo Benefits)43,468.81 4,736.25 0.00 38,732.56 89.10 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 19,285.25 7,710.60 0.00 11,574.65 60.02 10-170-502020 Group Health Insurance 21,024.20 11,371.96 0.00 9,652.24 45.91 10-170-502030 Retirement 26,078.26 12,178.75 0.00 13,899.51 53.30 10-170-502040 Workers Compensation 326.61 326.61 0.00 0.00 0.00 10-170-502050 Life Insurance 326.56 126.44 0.00 200.12 61.28 10-170-502060 Long Term Disability 621.30 262.67 0.00 358.63 57.72 10-170-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 10-170-503020 Unemployment Compensation 0.00 543.50 0.00 -543.50 0.00 E05 Personnel Services 319,838.79 135,075.60 0.00 184,763.19 57.77 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-511010 Advertising 0.00 50.00 0.00 -50.00 0.00 10-170-511020 Postage 300.00 47.62 0.00 252.38 84.13 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 248.22 0.00 251.78 50.36 10-170-513010 Office Supplies 1,000.00 179.05 0.00 820.95 82.10 10-170-517010 Operational Supplies 1,200.00 240.79 0.00 959.21 79.93 E10 Materials & Supplies 3,800.00 765.68 0.00 3,034.32 79.85 10-170-520030 Dues And Publications 1,468.00 672.00 0.00 796.00 54.22 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,313.19 0.00 2,186.81 62.48 10-170-520070 Training And Education 5,220.00 1,255.60 0.00 3,964.40 75.95 10-170-520080 Tuition Reimbursement 3,762.00 0.00 0.00 3,762.00 100.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 900.00 220.00 0.00 680.00 75.56 10-170-522020 Professional Services 5,000.00 308.88 0.00 4,691.12 93.82 10-170-529010 Special Events 500.00 0.00 0.00 500.00 100.00 10-170-529015 Human Relations Commission 5,000.00 0.00 0.00 5,000.00 100.00 E15 Contractual Services 25,350.00 3,769.67 0.00 21,580.33 85.13 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 237.00 37.92 37.92 161.16 68.00 E25 Repairs & Maintenance 237.00 37.92 37.92 161.16 68.00 10-170-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 170 Human Resources 349,225.79 139,648.87 37.92 209,539.00 60.00 180 Finance Department 10-180-501020 Salaries 647,655.83 270,578.36 0.00 377,077.47 58.22 10-180-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits)0.00 0.00 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 49,545.67 20,116.31 0.00 29,429.36 59.40 10-180-502020 Group Health Insurance 83,788.45 36,847.96 0.00 46,940.49 56.02 10-180-502030 Retirement 80,956.98 30,504.42 0.00 50,452.56 62.32 10-180-502040 Workers Compensation 490.46 490.46 0.00 0.00 0.00 10-180-502050 Life Insurance 1,026.69 345.86 0.00 680.83 66.31 10-180-502060 Long Term Disability 2,112.81 786.87 0.00 1,325.94 62.76 10-180-502070 Employee Assistance Prgm 320.07 150.26 0.00 169.81 53.05 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 865,896.96 359,820.50 0.00 506,076.46 58.45 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-511010 Advertising 1,000.00 50.75 0.00 949.25 94.93 10-180-511020 Postage 9,500.00 5,491.31 0.00 4,008.69 42.20 10-180-511021 Mail Machine Cost 2,600.00 1,581.02 0.00 1,018.98 39.19 10-180-512010 Printing 4,000.00 894.00 0.00 3,106.00 77.65 10-180-512020 Copies 1,500.00 739.79 0.00 760.21 50.68 10-180-512021 Copy Machine Cost 1,000.00 -994.68 227.46 1,767.22 176.72 10-180-513010 Office Supplies 4,000.00 248.32 0.00 3,751.68 93.79 10-180-517010 Operational Supplies 4,000.00 1,383.59 0.00 2,616.41 65.41 E10 Materials & Supplies 27,600.00 9,394.10 227.46 17,978.44 65.14 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 705.00 0.00 1,595.00 69.35 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 633.54 0.00 10,366.46 94.24 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 28,430.00 5,924.16 28,429.52 -5,923.68 -20.84 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 500.00 18.60 0.00 481.40 96.28 E15 Contractual Services 42,230.00 7,281.30 28,429.52 6,519.18 15.44 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,200.00 0.00 0.00 1,200.00 100.00 E25 Repairs & Maintenance 1,200.00 0.00 0.00 1,200.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 936,926.96 376,495.90 28,656.98 531,774.08 56.76 185 Non-Departmental 10-185-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-185-501021 Vacancy Savings 0.00 0.00 0.00 0.00 0.00 10-185-501022 Separation Incentive Prog Svgs 0.00 0.00 0.00 0.00 0.00 10-185-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-185-502021 Self Insurance-Group Health 0.00 0.00 0.00 0.00 0.00 10-185-502022 Wellness Assessment 41,214.80 39,589.29 0.00 1,625.51 3.94 10-185-502023 Self Insurance-Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 41,214.80 39,589.29 0.00 1,625.51 3.94 10-185-514010 Gas 13,000.00 4,761.91 0.00 8,238.09 63.37 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 13,000.00 4,761.91 0.00 8,238.09 63.37 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 310,142.01 236,922.10 0.00 73,219.91 23.61 10-185-521020 Insurance Deductible 23,000.00 24,230.74 0.00 -1,230.74 -5.35 10-185-521030 Self Ins Prop & Casualty 50,000.00 17,749.51 0.00 32,250.49 64.50 10-185-521060 Drugalcohol screening 4,364.00 1,890.75 0.00 2,473.25 56.67 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 659.75 0.00 -659.75 0.00 10-185-522020 Professional Services 29,199.50 12,629.49 12,499.98 4,070.03 13.94 10-185-522023 LCRA Reimbursement 259,000.00 26,296.49 0.00 232,703.51 89.85 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 47,000.00 23,071.12 0.00 23,928.88 50.91 10-185-527020 Economic Development 185,000.00 138,750.00 92,500.00 -46,250.00 -25.00 10-185-529010 Special Events 7,000.00 2,316.62 0.00 4,683.38 66.91 E15 Contractual Services 969,705.51 512,016.57 132,499.98 325,188.96 33.53 10-185-531010 Electricity 42,000.00 9,487.59 0.00 32,512.41 77.41 10-185-533010 Natural Gas 6,400.00 4,454.79 0.00 1,945.21 30.39 10-185-535010 Water 7,250.00 2,415.47 0.00 4,834.53 66.68 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 55,650.00 16,357.85 0.00 39,292.15 70.61 10-185-540010 Building & Grounds Maint.60,000.00 36,187.74 0.00 23,812.26 39.69 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 780.00 0.00 1,320.00 62.86 E25 Repairs & Maintenance 87,100.00 61,967.74 0.00 25,132.26 28.85 10-185-550010 Miscellaneous 5,000.00 3,543.42 0.00 1,456.58 29.13 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 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 3,000.00 600.00 0.00 2,400.00 80.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 1,000.00 500.00 0.00 500.00 50.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 15,000.00 0.00 0.00 15,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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 34,000.00 14,643.42 0.00 19,356.58 56.93 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,200,670.31 649,336.78 132,499.98 418,833.55 34.88 190 Information Technology Svcs 10-190-501020 Salaries 549,787.91 258,137.24 0.00 291,650.67 53.05 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 105.22 0.00 1,094.78 91.23 10-190-501095 Overtime Straight Pay 0.00 17.54 0.00 -17.54 0.00 10-190-502010 Social Security 42,150.58 19,031.89 0.00 23,118.69 54.85 10-190-502020 Group Health Insurance 81,985.65 37,192.19 0.00 44,793.46 54.64 10-190-502030 Retirement 68,873.49 32,167.53 0.00 36,705.96 53.29 10-190-502040 Workers Compensation 1,248.89 1,248.89 0.00 0.00 0.00 10-190-502050 Life Insurance 856.31 331.87 0.00 524.44 61.24 10-190-502060 Long Term Disability 1,821.86 773.57 0.00 1,048.29 57.54 10-190-502070 Employee Assistance Prgm 258.78 121.48 0.00 137.30 53.06 E05 Personnel Services 748,183.47 349,127.42 0.00 399,056.05 53.34 10-190-511010 Advertising 500.00 0.00 0.00 500.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 8.63 0.00 91.37 91.37 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 1,000.00 262.65 0.00 737.35 73.74 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 3,500.00 1,384.47 0.00 2,115.53 60.44 E10 Materials & Supplies 5,250.00 1,655.75 0.00 3,594.25 68.46 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 500.00 0.00 0.00 500.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 14,000.00 4,117.25 0.00 9,882.75 70.59 10-190-520080 Tuition Reimbursement 1,300.00 0.00 0.00 1,300.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-522020 Professional Services 14,000.00 13,397.55 0.00 602.45 4.30 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 14,000.00 10,808.05 0.00 3,191.95 22.80 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,000.00 0.00 0.00 4,000.00 100.00 E15 Contractual Services 47,800.00 28,322.85 0.00 19,477.15 40.75 10-190-534010 Telephone 58,000.00 22,813.27 0.00 35,186.73 60.67 E20 Utilities 58,000.00 22,813.27 0.00 35,186.73 60.67 10-190-545010 Software Licensemaint 135,000.00 106,722.28 1,939.00 26,338.72 19.51 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 26,000.00 12,763.18 0.00 13,236.82 50.91 E25 Repairs & Maintenance 167,000.00 119,485.46 1,939.00 45,575.54 27.29 10-190-572020 Purchase Of Equipment 0.00 8,625.96 0.00 -8,625.96 0.00 E70 Capital Purchases 0.00 8,625.96 0.00 -8,625.96 0.00 190 Information Technology Svcs 1,026,233.47 530,030.71 1,939.00 494,263.76 48.16 300 Police Department 10-300-501020 Salaries 4,450,913.63 2,028,732.19 0.00 2,422,181.44 54.42 10-300-501030 Holiday Pay 139,079.30 66,038.62 0.00 73,040.68 52.52 10-300-501040 Part-time (wbenefits)20,913.54 0.00 0.00 20,913.54 100.00 10-300-501050 Parttime(wo Benefits)66,208.36 26,768.79 0.00 39,439.57 59.57 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 2,016.00 0.00 2,984.00 59.68 10-300-501090 Overtime 306,966.63 155,759.10 0.00 151,207.53 49.26 10-300-501095 Overtime Straight Pay 8,665.74 7,759.47 0.00 906.27 10.46 10-300-502010 Social Security 377,653.38 166,972.40 0.00 210,680.98 55.79 10-300-502020 Group Health Insurance 834,518.57 350,574.93 0.00 483,943.64 57.99 10-300-502030 Retirement 848,446.67 385,216.40 0.00 463,230.27 54.60 10-300-502040 Workers Compensation 75,371.19 75,371.19 0.00 0.00 0.00 10-300-502050 Life Insurance 6,878.35 2,557.71 0.00 4,320.64 62.82 10-300-502060 Long Term Disability 14,854.34 6,048.89 0.00 8,805.45 59.28 10-300-502070 Employee Assistance Prgm 2,465.22 1,208.47 0.00 1,256.75 50.98 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 7,160,534.92 3,275,024.16 0.00 3,885,510.76 54.26 10-300-511010 Advertising 2,500.00 1,431.09 700.00 368.91 14.76 10-300-511020 Postage 1,500.00 706.21 0.00 793.79 52.92 10-300-512010 Printing 6,400.00 3,744.95 0.00 2,655.05 41.49 10-300-512020 Copies 100.00 0.67 0.00 99.33 99.33 10-300-512030 Photographic Supplies 2,000.00 2,710.90 0.00 -710.90 -35.55 10-300-513010 Office Supplies 15,650.00 11,364.67 0.00 4,285.33 27.38 10-300-514010 Gas 155,000.00 69,700.43 0.00 85,299.57 55.03 10-300-514040 Food 700.00 258.09 0.00 441.91 63.13 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-515040 First Aid Supplies 1,300.00 786.98 0.00 513.02 39.46 10-300-516010 Ammunition & Firearms Supplies 43,995.00 41,152.12 2,035.00 807.88 1.84 10-300-516020 Dare Program 16,500.00 500.00 0.00 16,000.00 96.97 10-300-516030 Special Investigation 2,500.00 122.25 0.00 2,377.75 95.11 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 12,366.50 11,807.10 0.00 559.40 4.52 10-300-517010 Operational Supplies 33,995.79 22,706.07 0.00 11,289.72 33.21 E10 Materials & Supplies 294,507.29 166,991.53 2,735.00 124,780.76 42.37 10-300-520030 Dues And Publications 4,600.00 4,451.50 0.00 148.50 3.23 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 70,600.00 40,670.06 0.00 29,929.94 42.39 10-300-520080 Tuition Reimbursement 7,000.00 9,339.00 0.00 -2,339.00 -33.41 10-300-520090 Recruitment 2,500.00 84.00 0.00 2,416.00 96.64 10-300-521040 Medical Claimsservices 7,000.00 3,111.34 0.00 3,888.66 55.55 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 15,500.00 12,142.03 0.00 3,357.97 21.66 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,946.07 0.00 -5,946.07 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 1,954.83 0.00 245.17 11.14 E15 Contractual Services 109,400.00 77,698.83 0.00 31,701.17 28.98 10-300-531010 Electricity 48,000.00 16,974.06 0.00 31,025.94 64.64 10-300-533010 Natural Gas 1,200.00 271.22 0.00 928.78 77.40 10-300-534010 Telephone 22,200.00 10,050.28 0.00 12,149.72 54.73 10-300-535010 Water 3,600.00 1,459.88 0.00 2,140.12 59.45 E20 Utilities 75,000.00 28,755.44 0.00 46,244.56 61.66 10-300-540010 Building & Grounds Maint.40,000.00 24,246.35 420.00 15,333.65 38.33 10-300-541030 Vehicle Wash 12,000.00 6,874.29 0.00 5,125.71 42.71 10-300-544010 K-9 Operations 18,500.00 5,303.57 0.00 13,196.43 71.33 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 24,300.00 6,801.37 0.00 17,498.63 72.01 10-300-545010 Software Licensemaint 62,000.00 50,000.00 9,500.00 2,500.00 4.03 10-300-546010 Clothing Expense 50,120.28 13,668.58 7,681.75 28,769.95 57.40 10-300-546020 Uniform Cleaning 23,000.00 11,833.01 0.00 11,166.99 48.55 10-300-547010 Equipment Maintenance 9,350.00 2,461.43 0.00 6,888.57 73.67 10-300-547020 Maintenance Agreements 45,000.00 9,778.70 2,758.48 32,462.82 72.14 10-300-547030 Radio Maintenance 10,000.00 4,961.66 0.00 5,038.34 50.38 E25 Repairs & Maintenance 294,270.28 135,928.96 20,360.23 137,981.09 46.89 10-300-572010 Purchase Of Vehicles 276,329.11 275,490.00 595.85 243.26 0.09 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 21,633.17 10,624.21 0.00 11,008.96 50.89 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 0.00 0.00 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 297,962.28 286,114.21 595.85 11,252.22 3.78 300 Police Department 8,231,674.77 3,970,513.13 23,691.08 4,237,470.56 51.48 310 School Resource Officer 10-310-501020 Salaries 386,137.87 159,704.00 0.00 226,433.87 58.64 10-310-501030 Holiday Pay 14,843.15 1,126.50 0.00 13,716.65 92.41 10-310-501090 Overtime 17,126.00 11,392.29 0.00 5,733.71 33.48 10-310-501095 Overtime Straight Pay 410.00 1,590.75 0.00 -1,180.75 -287.99 10-310-502010 Social Security 32,016.55 12,230.09 0.00 19,786.46 61.80 10-310-502020 Group Health Insurance 82,710.43 33,749.13 0.00 48,961.30 59.20 10-310-502030 Retirement 75,333.06 31,223.93 0.00 44,109.13 58.55 10-310-502040 Workers Compensation 5,129.35 5,129.35 0.00 0.00 0.00 10-310-502050 Life Insurance 613.22 207.36 0.00 405.86 66.19 10-310-502060 Long Term Disability 1,324.61 490.54 0.00 834.07 62.97 10-310-502070 Employee Assistance Prgm 217.92 102.30 0.00 115.62 53.06 E05 Personnel Services 615,862.16 256,946.24 0.00 358,915.92 58.28 10-310-517010 Operational Supplies 11,004.21 567.87 0.00 10,436.34 94.84 E10 Materials & Supplies 11,004.21 567.87 0.00 10,436.34 94.84 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-520070 Training And Education 5,000.00 994.62 0.00 4,005.38 80.11 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 5,000.00 994.62 0.00 4,005.38 80.11 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 9,278.22 188.65 0.00 9,089.57 97.97 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 9,278.22 188.65 0.00 9,089.57 97.97 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 641,144.59 258,697.38 0.00 382,447.21 59.65 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 94,620.00 44,275.70 0.00 50,344.30 53.21 10-320-501030 Holiday Pay 3,570.00 177.50 0.00 3,392.50 95.03 10-320-501090 Overtime 6,897.00 12,786.63 0.00 -5,889.63 -85.39 10-320-501095 Overtime Straight Pay 0.00 133.13 0.00 -133.13 0.00 10-320-502010 Social Security 8,039.16 4,157.54 0.00 3,881.62 48.28 10-320-502020 Group Health Insurance 21,543.04 9,581.64 0.00 11,961.40 55.52 10-320-502030 Retirement 18,915.66 10,302.99 0.00 8,612.67 45.53 10-320-502040 Workers Compensation 1,744.38 1,744.38 0.00 0.00 0.00 10-320-502050 Life Insurance 146.39 56.50 0.00 89.89 61.40 10-320-502060 Long Term Disability 315.55 133.55 0.00 182.00 57.68 10-320-502070 Employee Assistance Prgm 54.48 25.58 0.00 28.90 53.05 E05 Personnel Services 155,845.66 83,375.14 0.00 72,470.52 46.50 10-320-514010 Gas 6,000.00 2,642.19 0.00 3,357.81 55.96 10-320-516040 Investigations 14,350.00 12,704.33 0.00 1,645.67 11.47 10-320-517010 Operational Supplies 4,818.02 1,474.18 0.00 3,343.84 69.40 E10 Materials & Supplies 25,168.02 16,820.70 0.00 8,347.32 33.17 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,000.00 5,000.00 -7,500.00 20,500.00 113.89 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,000.00 5,000.00 -7,500.00 20,500.00 113.89 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.199,013.68 105,195.84 -7,500.00 101,317.84 50.91 330 Animal Control 10-330-501020 Salaries 346,830.48 163,014.94 0.00 183,815.54 53.00 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 2,028.00 0.00 2,280.00 52.92 10-330-501090 Overtime 1,709.00 618.08 0.00 1,090.92 63.83 10-330-501095 Overtime Straight Pay 500.00 0.00 0.00 500.00 100.00 10-330-502010 Social Security 27,031.08 11,960.40 0.00 15,070.68 55.75 10-330-502020 Group Health Insurance 71,563.22 32,606.66 0.00 38,956.56 54.44 10-330-502030 Retirement 44,168.44 20,635.43 0.00 23,533.01 53.28 10-330-502040 Workers Compensation 4,269.54 4,269.54 0.00 0.00 0.00 10-330-502050 Life Insurance 549.33 212.77 0.00 336.56 61.27 10-330-502060 Long Term Disability 1,177.24 501.27 0.00 675.97 57.42 10-330-502070 Employee Assistance Prgm 217.92 51.15 0.00 166.77 76.53 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 502,324.25 235,898.24 0.00 266,426.01 53.04 10-330-511010 Advertising 120.00 0.00 0.00 120.00 100.00 10-330-511020 Postage 100.00 52.74 0.00 47.26 47.26 10-330-512010 Printing 1,600.00 286.41 0.00 1,313.59 82.10 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,700.00 449.67 0.00 1,250.33 73.55 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-330-514040 Food 240.00 38.17 0.00 201.83 84.10 10-330-515040 First Aid Supplies 500.00 112.40 0.00 387.60 77.52 10-330-517010 Operational Supplies 11,900.00 4,537.99 0.00 7,362.01 61.87 E10 Materials & Supplies 16,160.00 5,477.38 0.00 10,682.62 66.11 10-330-520030 Dues And Publications 1,150.00 770.00 0.00 380.00 33.04 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 148.00 0.00 1,802.00 92.41 10-330-521040 Medical Claimsservices 464.00 0.00 0.00 464.00 100.00 10-330-522020 Professional Services 5,200.00 2,160.08 0.00 3,039.92 58.46 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 10-330-529068 Animal Shelter Donations 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 14,364.00 3,078.08 0.00 11,285.92 78.57 10-330-531010 Electricity 23,152.00 9,087.81 0.00 14,064.19 60.75 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-533010 Natural Gas 18,700.00 7,600.81 0.00 11,099.19 59.35 10-330-534010 Telephone 300.00 112.88 0.00 187.12 62.37 10-330-535010 Water 3,800.00 1,376.01 0.00 2,423.99 63.79 E20 Utilities 45,952.00 18,177.51 0.00 27,774.49 60.44 10-330-540010 Building & Grounds Maint.12,000.00 7,313.33 180.00 4,506.67 37.56 10-330-541020 Veh Maintenance 0.00 540.00 0.00 -540.00 0.00 10-330-541030 Vehicle Wash 540.00 0.00 0.00 540.00 100.00 10-330-544040 Care Of Animals 49,400.00 21,581.47 0.00 27,818.53 56.31 10-330-544050 Animal Food 5,000.00 1,760.18 0.00 3,239.82 64.80 10-330-545010 Software Licensemaint 3,125.36 2,706.98 438.84 -20.46 -0.65 10-330-546010 Clothing Expense 2,500.00 1,167.75 0.00 1,332.25 53.29 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 900.00 522.88 0.00 377.12 41.90 10-330-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 250.00 0.00 0.00 250.00 100.00 E25 Repairs & Maintenance 73,715.36 35,592.59 618.84 37,503.93 50.88 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-330-578069 Animal Shelter 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 652,515.61 298,223.80 618.84 353,672.97 54.20 390 9-1-1 Police 10-390-501020 Salaries 893,961.98 421,227.03 0.00 472,734.95 52.88 10-390-501030 Holiday Pay 31,165.19 17,588.02 0.00 13,577.17 43.57 10-390-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-390-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-390-501090 Overtime 15,814.00 9,803.74 0.00 6,010.26 38.01 10-390-501095 Overtime Straight Pay 500.00 126.29 0.00 373.71 74.74 10-390-502010 Social Security 72,020.25 32,403.70 0.00 39,616.55 55.01 10-390-502020 Group Health Insurance 176,657.52 84,429.93 0.00 92,227.59 52.21 10-390-502030 Retirement 119,725.16 55,853.23 0.00 63,871.93 53.35 10-390-502040 Workers Compensation 1,538.00 1,538.00 0.00 0.00 0.00 10-390-502050 Life Insurance 1,411.88 531.06 0.00 880.82 62.39 10-390-502060 Long Term Disability 3,033.44 1,254.98 0.00 1,778.46 58.63 10-390-502070 Employee Assistance Prgm 578.85 271.74 0.00 307.11 53.06 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,316,406.27 625,027.72 0.00 691,378.55 52.52 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 2,105.72 2,500.00 394.28 7.89 E10 Materials & Supplies 5,100.00 2,105.72 2,500.00 494.28 9.69 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-520030 Dues And Publications 600.00 184.00 0.00 416.00 69.33 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 1,434.80 0.00 3,565.20 71.30 10-390-522020 Professional Services 2,700.00 379.40 -1,739.68 4,060.28 150.38 10-390-523010 Equipment Rentlease 98,000.00 45,873.31 0.00 52,126.69 53.19 E15 Contractual Services 106,300.00 47,871.51 -1,739.68 60,168.17 56.60 10-390-531010 Electricity 12,000.00 3,824.06 0.00 8,175.94 68.13 10-390-533010 Natural Gas 300.00 84.90 0.00 215.10 71.70 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 900.00 0.00 0.00 900.00 100.00 E20 Utilities 13,200.00 3,908.96 0.00 9,291.04 70.39 10-390-545010 Software Licensemaint 29,251.00 29,251.00 0.00 0.00 0.00 10-390-546010 Clothing Expense 6,000.00 0.00 0.00 6,000.00 100.00 10-390-546020 Uniform Cleaning 2,700.00 1,655.54 0.00 1,044.46 38.68 10-390-547010 Equipment Maintenance 3,000.00 760.00 0.00 2,240.00 74.67 10-390-547020 Maintenance Agreements 49,535.98 23,920.38 0.00 25,615.60 51.71 10-390-547030 Radio Maintenance 5,000.00 0.00 0.00 5,000.00 100.00 E25 Repairs & Maintenance 95,486.98 55,586.92 0.00 39,900.06 41.79 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,536,493.25 734,500.83 760.32 801,232.10 52.15 400 Fire Department 10-400-501020 Salaries 3,896,472.91 1,780,199.13 0.00 2,116,273.78 54.31 10-400-501030 Holiday Pay 292,107.44 169,516.28 0.00 122,591.16 41.97 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 19,020.00 0.00 9,480.00 33.26 10-400-501090 Overtime 41,000.00 36,082.34 0.00 4,917.66 11.99 10-400-501095 Overtime Straight Pay 33,000.00 22,333.89 0.00 10,666.11 32.32 10-400-502010 Social Security 64,774.59 29,032.14 0.00 35,742.45 55.18 10-400-502020 Group Health Insurance 733,881.54 318,060.11 0.00 415,821.43 56.66 10-400-502030 Retirement 1,960,097.52 902,440.28 0.00 1,057,657.24 53.96 10-400-502040 Workers Compensation 152,968.09 152,968.09 0.00 0.00 0.00 10-400-502050 Life Insurance 6,051.95 2,276.89 0.00 3,775.06 62.38 10-400-502060 Long Term Disability 13,140.43 5,354.78 0.00 7,785.65 59.25 10-400-502070 Employee Assistance Prgm 2,070.24 971.88 0.00 1,098.36 53.05 10-400-503010 Awards Program 1,500.00 500.00 0.00 1,000.00 66.67 E05 Personnel Services 7,225,564.71 3,438,755.81 0.00 3,786,808.90 52.41 10-400-511010 Advertising 850.00 816.95 0.00 33.05 3.89 10-400-511020 Postage 200.00 69.04 0.00 130.96 65.48 10-400-512010 Printing 850.00 25.17 0.00 824.83 97.04 10-400-512020 Copies 50.00 0.00 0.00 50.00 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-513010 Office Supplies 1,500.00 792.44 0.00 707.56 47.17 10-400-514010 Gas 49,000.00 24,781.56 0.00 24,218.44 49.43 10-400-514020 Chemicals 1,500.00 53.47 0.00 1,446.53 96.44 10-400-514030 Small Tools 5,000.00 2,507.65 0.00 2,492.35 49.85 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 3,559.12 3,558.41 0.00 0.71 0.02 10-400-517010 Operational Supplies 13,157.00 5,378.67 503.00 7,275.33 55.30 E10 Materials & Supplies 75,666.12 37,983.36 503.00 37,179.76 49.14 10-400-520030 Dues And Publications 3,260.00 3,257.40 0.00 2.60 0.08 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 32,500.00 11,500.22 0.00 20,999.78 64.61 10-400-520080 Tuition Reimbursement 4,500.00 1,746.00 0.00 2,754.00 61.20 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 9,700.00 3,827.50 0.00 5,872.50 60.54 10-400-522020 Professional Services 43,500.00 500.00 0.00 43,000.00 98.85 10-400-523010 Equipment Rentlease 300.00 16.05 0.00 283.95 94.65 10-400-524010 Trash Collections 100.00 0.00 0.00 100.00 100.00 10-400-529010 Special Events 6,590.00 339.00 0.00 6,251.00 94.86 10-400-529040 Child Safety Seat Pass-through 2,500.00 700.00 0.00 1,800.00 72.00 E15 Contractual Services 102,950.00 21,886.17 0.00 81,063.83 78.74 10-400-531010 Electricity 32,000.00 11,029.83 0.00 20,970.17 65.53 10-400-533010 Natural Gas 19,000.00 14,499.16 0.00 4,500.84 23.69 10-400-534010 Telephone 22,000.00 9,518.38 0.00 12,481.62 56.73 10-400-535010 Water 17,000.00 8,224.35 0.00 8,775.65 51.62 E20 Utilities 90,000.00 43,271.72 0.00 46,728.28 51.92 10-400-540010 Building & Grounds Maint.98,000.00 24,640.38 14,074.00 59,285.62 60.50 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,500.00 30,254.66 -64,012.58 103,257.92 148.57 10-400-546020 Uniform Cleaning 300.00 0.00 0.00 300.00 100.00 10-400-547010 Equipment Maintenance 17,075.00 15,494.93 0.00 1,580.07 9.25 10-400-547020 Maintenance Agreements 25,000.00 9,816.19 -716.88 15,900.69 63.60 10-400-547030 Radio Maintenance 19,500.00 2,777.95 0.00 16,722.05 85.75 E25 Repairs & Maintenance 229,375.00 82,984.11 -50,655.46 197,046.35 85.91 10-400-572010 Purchase Of Vehicles 49,365.00 0.00 36,680.00 12,685.00 25.70 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 15,615.00 8,664.00 6,950.00 1.00 0.01 10-400-572021 Purchase of Equipment-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572022 Fitness-ONE TIME 178,345.00 29,537.80 119,302.10 29,505.10 16.54 10-400-572060 Fire Grant Equipgear 8,323.00 0.00 0.00 8,323.00 100.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 251,648.00 38,201.80 162,932.10 50,514.10 20.07 400 Fire Department 7,975,203.83 3,663,082.97 112,779.64 4,199,341.22 52.65 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 401 Fire Museum 10-401-531010 Electricity 2,200.00 216.11 0.00 1,983.89 90.18 10-401-533010 Natural Gas 0.00 350.81 0.00 -350.81 0.00 10-401-535010 Water 0.00 140.45 0.00 -140.45 0.00 E20 Utilities 2,200.00 707.37 0.00 1,492.63 67.85 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 2,200.00 707.37 0.00 1,492.63 67.85 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 181,798.44 78,625.48 0.00 103,172.96 56.75 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 13,907.58 5,941.17 0.00 7,966.41 57.28 10-520-502020 Group Health Insurance 21,927.17 8,584.89 0.00 13,342.28 60.85 10-520-502030 Retirement 22,724.80 9,790.07 0.00 12,934.73 56.92 10-520-502040 Workers Compensation 211.06 211.06 0.00 0.00 0.00 10-520-502050 Life Insurance 283.23 100.96 0.00 182.27 64.35 10-520-502060 Long Term Disability 546.15 208.61 0.00 337.54 61.80 10-520-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 241,480.15 103,500.60 0.00 137,979.55 57.14 10-520-511010 Advertising 250.00 0.00 0.00 250.00 100.00 10-520-511020 Postage 200.00 27.37 0.00 172.63 86.32 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 900.00 200.88 0.00 699.12 77.68 10-520-514010 Gas 11,000.00 4,787.89 0.00 6,212.11 56.47 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 500.00 252.51 0.00 247.49 49.50 E10 Materials & Supplies 12,850.00 5,268.65 0.00 7,581.35 59.00 10-520-520030 Dues And Publications 1,200.00 1,055.75 0.00 144.25 12.02 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 2,000.00 222.00 0.00 1,778.00 88.90 10-520-522020 Professional Services 5,000.00 470.99 5,000.00 -470.99 -9.42 E15 Contractual Services 8,200.00 1,748.74 5,000.00 1,451.26 17.70 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,079.00 55.62 23.90 999.48 92.63 E25 Repairs & Maintenance 1,079.00 55.62 23.90 999.48 92.63 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 (05/09/2019 - 11:42 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 520 Plan & Protect Svcs-Admin 263,609.15 110,573.61 5,023.90 148,011.64 56.15 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 135,810.96 63,740.28 0.00 72,070.68 53.07 10-521-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 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 10,389.54 4,563.08 0.00 5,826.46 56.08 10-521-502020 Group Health Insurance 29,147.19 13,861.73 0.00 15,285.46 52.44 10-521-502030 Retirement 16,976.37 7,689.64 0.00 9,286.73 54.70 10-521-502040 Workers Compensation 146.75 146.75 0.00 0.00 0.00 10-521-502050 Life Insurance 214.22 82.65 0.00 131.57 61.42 10-521-502060 Long Term Disability 460.13 195.79 0.00 264.34 57.45 10-521-502070 Employee Assistance Prgm 73.55 34.52 0.00 39.03 53.07 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 193,218.71 90,314.44 0.00 102,904.27 53.26 10-521-511010 Advertising 5,000.00 1,762.00 0.00 3,238.00 64.76 10-521-511020 Postage 1,000.00 350.97 0.00 649.03 64.90 10-521-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-521-512020 Copies 10.00 0.81 0.00 9.19 91.90 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Supplies 1,000.00 350.22 0.00 649.78 64.98 10-521-514040 Food 250.00 0.00 0.00 250.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 2,000.00 58.00 0.00 1,942.00 97.10 E10 Materials & Supplies 9,360.00 2,522.00 0.00 6,838.00 73.06 10-521-520030 Dues And Publications 14,800.00 662.50 0.00 14,137.50 95.52 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 588.16 0.00 1,911.84 76.47 10-521-520080 Tuition Reimbursement 873.00 0.00 0.00 873.00 100.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 18,173.00 1,250.66 0.00 16,922.34 93.12 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,121.00 450.96 383.42 286.62 25.57 E25 Repairs & Maintenance 1,121.00 450.96 383.42 286.62 25.57 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 521 Plan & Protect Svcs-Planning 221,872.71 94,538.06 383.42 126,951.23 57.22 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 119,716.57 56,179.50 0.00 63,537.07 53.07 10-522-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-522-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-522-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-522-502010 Social Security 9,158.32 4,264.02 0.00 4,894.30 53.44 10-522-502020 Group Health Insurance 17,239.64 7,822.83 0.00 9,416.81 54.62 10-522-502030 Retirement 14,964.57 6,997.13 0.00 7,967.44 53.24 10-522-502040 Workers Compensation 94.28 94.28 0.00 0.00 0.00 10-522-502050 Life Insurance 188.11 73.35 0.00 114.76 61.01 10-522-502060 Long Term Disability 405.14 172.72 0.00 232.42 57.37 10-522-502070 Employee Assistance Prgm 62.65 29.42 0.00 33.23 53.04 E05 Personnel Services 161,829.28 75,633.25 0.00 86,196.03 53.26 10-522-511010 Advertising 1,800.00 424.80 0.00 1,375.20 76.40 10-522-511020 Postage 200.00 4.04 0.00 195.96 97.98 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.07 0.00 9.93 99.30 10-522-513010 Office Supplies 1,000.00 129.52 0.00 870.48 87.05 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 0.00 0.00 1,620.00 100.00 E10 Materials & Supplies 5,005.00 558.43 0.00 4,446.57 88.84 10-522-520030 Dues And Publications 1,500.00 402.50 0.00 1,097.50 73.17 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 6,000.00 684.08 0.00 5,315.92 88.60 10-522-522020 Professional Services 96,393.31 53,765.44 42,619.87 8.00 0.01 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 103,893.31 54,852.02 42,619.87 6,421.42 6.18 10-522-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-522-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-522-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-522-547020 Maintenance Agreements 1,196.00 287.01 287.82 621.17 51.94 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,196.00 287.01 287.82 621.17 51.94 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs-MPO 271,923.59 131,330.71 42,907.69 97,685.19 35.92 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 79,153.41 37,162.20 0.00 41,991.21 53.05 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 6,055.24 2,652.64 0.00 3,402.60 56.19 10-530-502020 Group Health Insurance 9,632.67 4,301.75 0.00 5,330.92 55.34 10-530-502030 Retirement 9,894.18 4,628.66 0.00 5,265.52 53.22 10-530-502040 Workers Compensation 53.40 53.40 0.00 0.00 0.00 10-530-502050 Life Insurance 124.11 47.91 0.00 76.20 61.40 10-530-502060 Long Term Disability 266.46 113.26 0.00 153.20 57.49 10-530-502070 Employee Assistance Prgm 40.86 19.18 0.00 21.68 53.06 E05 Personnel Services 105,220.33 48,979.00 0.00 56,241.33 53.45 10-530-511010 Advertising 400.00 211.31 0.00 188.69 47.17 10-530-511020 Postage 700.00 96.09 0.00 603.91 86.27 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 129.00 0.00 171.00 57.00 10-530-517010 Operational Supplies 1,200.00 261.23 0.00 938.77 78.23 E10 Materials & Supplies 2,700.00 697.63 0.00 2,002.37 74.16 10-530-520030 Dues And Publications 1,250.00 118.98 0.00 1,131.02 90.48 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,500.00 1,819.21 0.00 680.79 27.23 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 39.92 18,800.00 -39.92 -0.21 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 2,000.00 69.03 0.00 1,930.97 96.55 10-530-524029 Recycling Education 9,000.00 14.00 0.00 8,986.00 99.84 10-530-528085 Fair Housing Assistance Prog 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 35,550.00 2,061.14 18,800.00 14,688.86 41.32 10-530-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-530-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-530-547020 Maintenance Agreements 179.00 60.83 47.80 70.37 39.31 E25 Repairs & Maintenance 179.00 60.83 47.80 70.37 39.31 10-530-550020 NRA-Residential 55,000.00 48,535.71 0.00 6,464.29 11.75 10-530-550030 NRA-Commercial Facade 19,500.00 16,412.88 0.00 3,087.12 15.83 10-530-550031 Historic Preservation Grant 23,000.00 4,750.00 15,000.00 3,250.00 14.13 10-530-550032 NRA-Rental Facade 15,500.00 66.00 0.00 15,434.00 99.57 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 79.04 0.00 420.96 84.19 10-530-550039 Historic Preservation Grant 50,000.00 4,905.00 25,095.00 20,000.00 40.00 10-530-550050 Neighb Stablization Prog 47,097.38 0.00 0.00 47,097.38 100.00 10-530-550055 HERO 0.00 0.00 0.00 0.00 0.00 10-530-550060 MSP 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 210,597.38 74,748.63 40,095.00 95,753.75 45.47 530 Plan & Protect Svc-RedevGrant 354,246.71 126,547.23 58,942.80 168,756.68 47.64 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs-Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs-Env Health 10-532-501020 Salaries 176,225.85 82,727.87 0.00 93,497.98 53.06 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 13,504.23 5,803.03 0.00 7,701.20 57.03 10-532-502020 Group Health Insurance 33,180.29 15,067.64 0.00 18,112.65 54.59 10-532-502030 Retirement 22,065.73 10,304.06 0.00 11,761.67 53.30 10-532-502040 Workers Compensation 3,450.70 3,450.70 0.00 0.00 0.00 10-532-502050 Life Insurance 275.40 106.57 0.00 168.83 61.30 10-532-502060 Long Term Disability 595.11 253.19 0.00 341.92 57.45 10-532-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 249,679.03 117,751.42 0.00 131,927.61 52.84 10-532-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-532-511020 Postage 200.00 52.36 0.00 147.64 73.82 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 598.90 0.00 701.10 53.93 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 755.14 0.00 244.86 24.49 E10 Materials & Supplies 2,735.00 1,406.40 0.00 1,328.60 48.58 10-532-520030 Dues And Publications 1,000.00 875.00 0.00 125.00 12.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 546.00 0.00 454.00 45.40 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 192,000.00 80,000.00 112,000.00 0.00 0.00 10-532-529010 Special Events 700.00 32.50 0.00 667.50 95.36 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 194,700.00 81,453.50 112,000.00 1,246.50 0.64 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 31,445.37 13,070.37 18,375.00 0.00 0.00 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 954.63 458.06 0.00 496.57 52.02 10-532-547010 Equipment Maintenance 80.00 0.00 0.00 80.00 100.00 10-532-547020 Maintenance Agreements 695.00 161.34 165.67 367.99 52.95 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 34,465.00 14,973.77 18,540.67 950.56 2.76 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 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 481,579.03 215,585.09 130,540.67 135,453.27 28.13 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 157,104.49 70,854.49 0.00 86,250.00 54.90 10-533-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-533-501060 Seasonal Salaries 32,240.85 11,090.37 0.00 21,150.48 65.60 10-533-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-533-501095 Overtime Straight Pay 260.00 0.00 0.00 260.00 100.00 10-533-502010 Social Security 14,876.53 5,846.51 0.00 9,030.02 60.70 10-533-502020 Group Health Insurance 28,549.93 12,730.96 0.00 15,818.97 55.41 10-533-502030 Retirement 19,820.56 8,827.54 0.00 10,993.02 55.46 10-533-502040 Workers Compensation 1,918.70 1,918.70 0.00 0.00 0.00 10-533-502050 Life Insurance 220.32 81.06 0.00 139.26 63.21 10-533-502060 Long Term Disability 531.22 216.48 0.00 314.74 59.25 10-533-502070 Employee Assistance Prgm 95.34 44.76 0.00 50.58 53.05 E05 Personnel Services 256,817.94 111,610.87 0.00 145,207.07 56.54 10-533-511010 Advertising 200.00 168.00 0.00 32.00 16.00 10-533-511020 Postage 2,300.00 605.34 0.00 1,694.66 73.68 10-533-512010 Printing 1,000.00 90.71 0.00 909.29 90.93 10-533-512020 Copies 15.00 0.07 0.00 14.93 99.53 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,200.00 152.76 0.00 1,047.24 87.27 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 653.95 0.00 696.05 51.56 E10 Materials & Supplies 6,230.00 1,670.83 0.00 4,559.17 73.18 10-533-520030 Dues And Publications 1,100.00 58.98 0.00 1,041.02 94.64 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-520070 Training And Education 1,000.00 0.00 0.00 1,000.00 100.00 10-533-520080 Tuition Reimbursement 5,562.00 3,060.00 0.00 2,502.00 44.98 10-533-522020 Professional Services 0.00 52.50 0.00 -52.50 0.00 10-533-522021 Abatement 15,000.00 7,590.00 0.00 7,410.00 49.40 10-533-522022 Demo 74,905.00 9,150.00 14,140.00 51,615.00 68.91 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 97,567.00 19,911.48 14,140.00 63,515.52 65.10 10-533-534010 Telephone 3,659.15 1,429.60 0.00 2,229.55 60.93 E20 Utilities 3,659.15 1,429.60 0.00 2,229.55 60.93 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 2,180.00 472.00 0.00 1,708.00 78.35 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 13,429.00 352.58 338.92 12,737.50 94.85 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,909.00 1,094.58 338.92 14,475.50 90.99 10-533-572020 Purchase Of Equipment 7,168.00 4,812.61 2,355.39 0.00 0.00 E70 Capital Purchases 7,168.00 4,812.61 2,355.39 0.00 0.00 533 PPS - Prop MaintCode Enforce 387,351.09 140,529.97 16,834.31 229,986.81 59.37 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 320,648.26 146,788.76 0.00 173,859.50 54.22 10-534-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.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 24,562.87 10,480.69 0.00 14,082.18 57.33 10-534-502020 Group Health Insurance 70,799.18 30,737.65 0.00 40,061.53 56.58 10-534-502030 Retirement 40,135.41 18,280.89 0.00 21,854.52 54.45 10-534-502040 Workers Compensation 4,097.43 4,097.43 0.00 0.00 0.00 10-534-502050 Life Insurance 504.53 190.27 0.00 314.26 62.29 10-534-502060 Long Term Disability 1,083.73 449.51 0.00 634.22 58.52 10-534-502070 Employee Assistance Prgm 163.44 76.72 0.00 86.72 53.06 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 462,429.85 211,101.92 0.00 251,327.93 54.35 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 898.32 0.00 201.68 18.33 10-534-512010 Printing 350.00 160.00 0.00 190.00 54.29 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 512.17 0.00 387.83 43.09 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 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-517010 Operational Supplies 2,000.00 885.09 0.00 1,114.91 55.75 E10 Materials & Supplies 4,630.00 2,455.58 0.00 2,174.42 46.96 10-534-520030 Dues And Publications 3,000.00 1,353.84 0.00 1,646.16 54.87 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 7,000.00 3,804.88 0.00 3,195.12 45.64 10-534-522020 Professional Services 0.00 1,579.11 0.00 -1,579.11 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 10,000.00 6,737.83 0.00 3,262.17 32.62 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 1,180.00 860.00 0.00 320.00 27.12 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,014.00 331.17 331.34 351.49 34.66 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,484.00 1,461.17 331.34 691.49 27.84 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 479,543.85 221,756.50 331.34 257,456.01 53.69 535 Public Works-Central Maintenan 10-535-501020 Salaries 346,408.71 162,563.58 0.00 183,845.13 53.07 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 487.50 0.00 6,912.50 93.41 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 14,145.61 0.00 -9,645.61 -214.35 10-535-501095 Overtime Straight Pay 500.00 398.91 0.00 101.09 20.22 10-535-502010 Social Security 27,448.87 13,037.53 0.00 14,411.34 52.50 10-535-502020 Group Health Insurance 73,150.39 33,281.35 0.00 39,869.04 54.50 10-535-502030 Retirement 43,926.09 22,063.36 0.00 21,862.73 49.77 10-535-502040 Workers Compensation 4,190.81 4,190.81 0.00 0.00 0.00 10-535-502050 Life Insurance 543.46 211.10 0.00 332.36 61.16 10-535-502060 Long Term Disability 1,175.53 499.53 0.00 676.00 57.51 10-535-502070 Employee Assistance Prgm 190.68 89.52 0.00 101.16 53.05 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 509,434.54 250,968.80 0.00 258,465.74 50.74 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 5.25 0.00 44.75 89.50 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-513010 Office Supplies 1,500.00 510.75 0.00 989.25 65.95 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 8,000.00 1,852.70 0.00 6,147.30 76.84 10-535-517010 Operational Supplies 7,000.00 2,410.68 0.00 4,589.32 65.56 E10 Materials & Supplies 16,640.00 4,779.38 0.00 11,860.62 71.28 10-535-520030 Dues And Publications 170.00 170.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 1,830.00 1,765.83 0.00 64.17 3.51 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 1,935.83 0.00 564.17 22.57 10-535-531010 Electricity 7,560.00 2,682.00 0.00 4,878.00 64.52 10-535-533010 Natural Gas 7,000.00 2,216.04 0.00 4,783.96 68.34 10-535-534010 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 Water 1,442.00 568.26 0.00 873.74 60.59 E20 Utilities 16,222.00 5,466.30 0.00 10,755.70 66.30 10-535-540010 Building & Grounds Maint.10,000.00 6,574.82 35.00 3,390.18 33.90 10-535-541010 Veh & Equip Parts Etc 500,000.00 272,318.20 0.00 227,681.80 45.54 10-535-546010 Clothing Expense 5,500.00 2,897.43 0.00 2,602.57 47.32 10-535-547010 Equipment Maintenance 3,000.00 364.24 79.53 2,556.23 85.21 10-535-547020 Maintenance Agreements 13,300.00 5,697.55 1,869.43 5,733.02 43.11 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 531,900.00 287,852.24 1,983.96 242,063.80 45.51 10-535-572020 Purchase Of Equipment 11,500.00 9,556.98 0.00 1,943.02 16.90 E70 Capital Purchases 11,500.00 9,556.98 0.00 1,943.02 16.90 535 Public Works-Central Maintenan 1,088,196.54 560,559.53 1,983.96 525,653.05 48.30 540 Public Works-Admin 10-540-501020 Salaries 214,516.68 100,685.16 0.00 113,831.52 53.06 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 16,410.53 7,372.95 0.00 9,037.58 55.07 10-540-502020 Group Health Insurance 30,866.53 12,733.68 0.00 18,132.85 58.75 10-540-502030 Retirement 26,814.59 12,540.54 0.00 14,274.05 53.23 10-540-502040 Workers Compensation 201.34 201.34 0.00 0.00 0.00 10-540-502050 Life Insurance 335.87 130.05 0.00 205.82 61.28 10-540-502060 Long Term Disability 600.49 253.76 0.00 346.73 57.74 10-540-502070 Employee Assistance Prgm 81.72 38.36 0.00 43.36 53.06 E05 Personnel Services 289,827.75 133,955.84 0.00 155,871.91 53.78 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 1.94 0.00 198.06 99.03 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.39 0.00 99.61 99.61 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 74,000.00 45,089.87 0.00 28,910.13 39.07 10-540-514040 Food 200.00 177.64 0.00 22.36 11.18 10-540-517010 Operational Supplies 1,300.00 0.00 0.00 1,300.00 100.00 E10 Materials & Supplies 77,000.00 45,269.84 0.00 31,730.16 41.21 10-540-520030 Dues And Publications 672.60 672.60 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,627.40 2,210.73 0.00 1,416.67 39.05 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 2,883.33 0.00 1,616.67 35.93 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 370.00 105.82 101.55 162.63 43.95 E25 Repairs & Maintenance 370.00 105.82 101.55 162.63 43.95 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 371,697.75 182,214.83 101.55 189,381.37 50.95 541 Public Works-Engineering 10-541-501020 Salaries 795,715.28 364,291.91 0.00 431,423.37 54.22 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 146.27 0.00 253.73 63.43 10-541-501095 Overtime Straight Pay 400.00 0.00 0.00 400.00 100.00 10-541-502010 Social Security 60,933.42 26,061.37 0.00 34,872.05 57.23 10-541-502020 Group Health Insurance 145,725.27 57,632.23 0.00 88,093.04 60.45 10-541-502030 Retirement 99,564.41 43,595.08 0.00 55,969.33 56.21 10-541-502040 Workers Compensation 5,314.04 5,314.04 0.00 0.00 0.00 10-541-502050 Life Insurance 1,245.05 468.90 0.00 776.15 62.34 10-541-502060 Long Term Disability 2,646.78 1,092.61 0.00 1,554.17 58.72 10-541-502070 Employee Assistance Prgm 326.88 153.46 0.00 173.42 53.05 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,112,271.13 498,755.87 0.00 613,515.26 55.16 10-541-511010 Advertising 1,000.00 299.25 0.00 700.75 70.08 10-541-511020 Postage 400.00 170.78 0.00 229.22 57.31 10-541-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-541-512020 Copies 75.00 0.04 0.00 74.96 99.95 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-513010 Office Supplies 5,800.00 1,328.52 0.00 4,471.48 77.09 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 13.98 0.00 136.02 90.68 10-541-515040 First Aid Supplies 50.00 59.21 0.00 -9.21 -18.42 10-541-515070 Const & Inspect Supplies 2,000.00 336.56 0.00 1,663.44 83.17 10-541-515080 Surveying Supplies 2,000.00 130.05 0.00 1,869.95 93.50 10-541-517010 Operational Supplies 2,000.00 1,030.25 0.00 969.75 48.49 E10 Materials & Supplies 13,775.00 3,368.64 0.00 10,406.36 75.55 10-541-520030 Dues And Publications 4,000.00 2,630.00 0.00 1,370.00 34.25 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 1,295.00 0.00 1,705.00 56.83 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 1,000.00 217.00 0.00 783.00 78.30 10-541-522055 Stormwater Compliance 1,500.00 0.00 0.00 1,500.00 100.00 E15 Contractual Services 9,500.00 4,142.00 0.00 5,358.00 56.40 10-541-534010 Telephone 500.00 203.85 0.00 296.15 59.23 E20 Utilities 500.00 203.85 0.00 296.15 59.23 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 1,061.23 0.00 -61.23 -6.12 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 12,400.00 7,365.50 302.52 4,731.98 38.16 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,400.00 10,001.73 302.52 5,095.75 33.09 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,151,446.13 516,472.09 302.52 634,671.52 55.12 542 Public Works-Street 10-542-501020 Salaries 1,224,247.92 581,018.40 0.00 643,229.52 52.54 10-542-501060 Seasonal Salaries 20,000.00 6,116.25 0.00 13,883.75 69.42 10-542-501070 Stand-by Plan 5,000.00 2,016.00 0.00 2,984.00 59.68 10-542-501090 Overtime 35,000.00 24,853.41 0.00 10,146.59 28.99 10-542-501095 Overtime Straight Pay 500.00 383.91 0.00 116.09 23.22 10-542-502010 Social Security 98,283.22 45,388.95 0.00 52,894.27 53.82 10-542-502020 Group Health Insurance 242,417.69 108,330.38 0.00 134,087.31 55.31 10-542-502030 Retirement 158,093.49 71,301.22 0.00 86,792.27 54.90 10-542-502040 Workers Compensation 38,193.00 38,193.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-502050 Life Insurance 1,833.55 723.57 0.00 1,109.98 60.54 10-542-502060 Long Term Disability 4,008.48 1,691.40 0.00 2,317.08 57.80 10-542-502070 Employee Assistance Prgm 776.34 364.46 0.00 411.88 53.05 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,828,553.69 880,380.95 0.00 948,172.74 51.85 10-542-511010 Advertising 1,000.00 265.70 0.00 734.30 73.43 10-542-511020 Postage 150.00 6.91 0.00 143.09 95.39 10-542-512010 Printing 90.00 40.00 0.00 50.00 55.56 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 1,247.96 0.00 352.04 22.00 10-542-514020 Chemicals 370,000.00 301,650.18 -301,059.54 369,409.36 99.84 10-542-514030 Small Tools 9,000.00 6,530.79 0.00 2,469.21 27.44 10-542-514040 Food 2,000.00 2,250.15 0.00 -250.15 -12.51 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 425,000.00 128,260.39 0.00 296,739.61 69.82 10-542-515040 First Aid Supplies 500.00 697.44 0.00 -197.44 -39.49 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 3,187.82 0.00 1,812.18 36.24 E10 Materials & Supplies 817,550.00 444,137.34 -301,059.54 674,472.20 82.50 10-542-520030 Dues And Publications 600.00 965.00 0.00 -365.00 -60.83 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 5,110.65 0.00 -2,110.65 -70.36 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 19,000.00 9,993.70 2,000.00 7,006.30 36.88 10-542-523010 Equipment Rentlease 200.00 586.25 0.00 -386.25 -193.13 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 1,000.00 0.00 0.00 1,000.00 100.00 E15 Contractual Services 23,800.00 16,655.60 2,000.00 5,144.40 21.62 10-542-531010 Electricity 28,364.00 11,326.71 0.00 17,037.29 60.07 10-542-531020 Street Lights 650,000.00 250,469.76 0.00 399,530.24 61.47 10-542-533010 Natural Gas 10,000.00 10,493.82 0.00 -493.82 -4.94 10-542-534010 Telephone 580.00 48.00 48.00 484.00 83.45 10-542-535010 Water 13,390.00 5,462.44 0.00 7,927.56 59.21 E20 Utilities 702,334.00 277,800.73 48.00 424,485.27 60.44 10-542-540010 Building & Grounds Maint.12,000.00 7,462.92 550.00 3,987.08 33.23 10-542-541030 Vehicle Wash 7,000.00 6,669.00 0.00 331.00 4.73 10-542-542010 Repairs - StopStreet Lights 30,000.00 15,111.78 0.00 14,888.22 49.63 10-542-542030 Signs & Marking Paint 40,000.00 38,942.53 0.00 1,057.47 2.64 10-542-546010 Clothing Expense 10,000.00 4,952.91 0.00 5,047.09 50.47 10-542-547010 Equipment Maintenance 3,200.00 1,786.51 0.00 1,413.49 44.17 10-542-547020 Maintenance Agreements 300.00 0.00 0.00 300.00 100.00 10-542-547030 Radio Maintenance 1,000.00 356.83 0.00 643.17 64.32 E25 Repairs & Maintenance 103,500.00 75,282.48 550.00 27,667.52 26.73 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-542-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-542-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-542-573050 Neighborhood Impr Projs 0.00 0.00 0.00 0.00 0.00 10-542-573060 Sidewalk Rep Program 0.00 0.00 0.00 0.00 0.00 10-542-573061 Street Crack Sealing 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 542 Public Works-Street 3,475,737.69 1,694,257.10 -298,461.54 2,079,942.13 59.84 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 6,310.48 0.00 8,689.52 57.93 10-700-590065 Trans to Self-Funded Hlth Ins 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 241,769.63 241,769.63 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,111,635.79 1,111,635.79 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,368,405.42 1,359,715.90 0.00 8,689.52 0.64 700 Transfers & Subsidies 1,368,405.42 1,359,715.90 0.00 8,689.52 0.64 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-575006 New Fire Station Number 2 1,116,086.98 403,551.34 324,035.08 388,500.56 34.81 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-576007 Stormwater Improvements 406,000.00 0.00 282,013.00 123,987.00 30.54 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 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 1,300.00 500.00 800.00 0.00 0.00 10-990-577060 Ongoing InfrastFacility Needs 354,182.55 1,971.25 74,908.86 277,302.44 78.29 10-990-577063 Clark Avenue 12,743.35 1,816.24 10,927.11 0.00 0.00 10-990-577064 Broadway St Sidewalk 0.00 0.00 0.00 0.00 0.00 10-990-577065 South Lincoln Street 0.00 0.00 0.00 0.00 0.00 10-990-577066 Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-990-590071 Mo Blvd1400-1800 Block 278,564.00 0.00 219,257.74 59,306.26 21.29 E75 Capital Projects 2,168,876.88 407,838.83 911,941.79 849,096.26 39.15 990 Capital Projects 2,168,876.88 407,838.83 911,941.79 849,096.26 39.15 Expense Expense 36,506,837.39 17,043,694.12 1,157,900.72 18,305,242.55 50.14 GL - Trial Balance by Acct Type and Full Acct Number (05/09/2019 - 11:42 AM)Page 34 CITY OF JEFFERSON FISCAL YEAR 2019 ESTIMATED FUND BALANCE FYE2018 UNASSIGNED FUND BALANCE (Unaudited)8,289,017.00$ Reappropriations from FY2018 to FY2019 Remaining Port Feasibility Study (4,199.50)$ LCRA Reimbursement (259,000.00)$ Police Clothing Expense (7,398.50)$ Purchase of Police Vehicles (122,828.56)$ Historic Preservation Grant (34,200.00)$ Neighborhood Stabilization Program (47,097.38)$ Demo (34,905.00)$ PPS Computer Software (7,168.00)$ Fire ‐ Fitness Equipment (16,213.00)$ New Fire Station 2 (1,159,086.98)$ Stormwater Improvements (406,000.00)$ Downtown Streetscape (1,300.00)$ Ongoing Infrastructure/Facility Needs (354,182.55)$ (2,453,579.47)$ 2019 Adjustments/Supplementals FY2019 Supplemental Appropriations: Salt/Chemicals for Snow Removal (130,000.00)$ Snow Plow (75,000.00)$ (205,000.00)$ FYE2019 ESTIMATED Unassigned Fund Balance 5,630,437.53$ FYE2019 ESTIMATED Fund Balance % of Adopted Budget 17.16% 17% of FY2019 Adopted Budget ($32,807,390) = $5,577,256 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/17 65,709.30 27,597.91 36,797.21 4,207.06 2/2017 Interest Received Jan-17 2/20/17 95,905.35 40,280.25 53,706.99 4,726.10 3/2017 Interest Received Feb-17 3/31/17 95,135.98 39,957.11 53,276.15 4,651.72 4/2017 Interest Received Mar-17 4/30/17 111,370.63 46,775.67 62,367.55 4,885.76 5/2017 Interest Received Apr-17 5/30/17 109,652.93 46,054.23 61,405.64 4,807.94 6/2017 Interest Received May-17 6/30/17 123,148.39 51,722.32 68,963.10 5,089.00 7/2017 Interest Received Jun-17 7/31/17 120,310.25 50,530.30 67,373.74 5,141.00 8/2017 Interest Received Jul-17 8/20/17 101,096.32 42,460.45 56,613.94 5,081.97 9/2017 Interest Received Aug-17 9/30/17 99,136.13 41,637.18 55,516.23 5,325.63 10/2017 Interest Received Sep-17 10/31/17 112,835.87 47,391.06 63,188.09 5,243.98 11/2017 Interest Received Oct-17 11/20/17 118,132.32 49,615.57 66,154.10 5,519.00 12/2017 Interest Received Nov-17 12/20/17 84,414.19 35,453.96 47,271.95 5,565.66 1/2018 interest Received Dec-17 1/31/18 64,644.90 27,150.86 36,201.14 5,076.25 2/2018 interest Received Jan-18 2/20/18 90,463.34 37,994.60 50,659.47 5,710.59 3/2018 interest Received Feb-18 3/31/18 72,376.53 30,398.14 40,530.86 5,580.76 4/2018 interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Mar-18 4/30/18 128,168.74 53,830.87 71,774.50 5,862.91 5/2018 interest Received Apr-18 5/30/18 115,538.43 48,526.14 64,701.52 5,744.27 6/2018 interest Received May-18 6/20/18 127,840.04 53,692.82 71,590.42 6,020.86 7/2018 interest Received Jun-18 7/31/18 108,499.02 45,569.59 60,759.45 6,145.34 8/2018 interest Received Jul-18 8/20/18 99,948.25 41,978.26 55,971.02 5,929.16 9/2018 interest Received Aug-18 9/20/18 92,260.57 38,749.44 51,665.92 6,303.93 10/2018 interest Received Sep-18 10/31/18 102,804.82 43,178.02 57,570.70 6,160.57 11/2018 interest Received Oct-18 11/20/18 130,250.45 54,705.19 72,940.25 6,496.60 12/2018 interest Received Nov-18 12/20/18 87,460.75 36,733.51 48,978.02 6,531.01 1/2019 interest Received (3,908.75) CK# 1008 Dec-18 1/31/19 70,508.84 29,613.71 39,484.95 5,949.48 2/2019 interest Received (2,623.75) CK# 1009 Jan-19 2/20/19 88,590.00 37,207.80 49,610.40 6,683.16 3/2019 interest Received Feb-19 3/31/19 99,690.19 41,869.88 55,826.51 6,537.39 4/2019 interest Received Mar-19 4/30/19 121,611.98 51,077.03 68,102.71 Total 8,947,518.96 3,757,957.95 5,320,445.40 average monthly amount for 4 cent lockbox fund 52,903.26$ **Effective for 25 years starting in 2011 2019 Occupancy 2018 Occupancy 2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy January 49.40%48.10%48.70%51.30%45.90%49.20%45.30% February 58.00%53.40%56.80%58.60%51.20%56.00%52.90% March 58.00%57.60%62.20%59.80%59.80%59.30%52.90% April 61.70%62.40%67.20%58.10%63.70%64.10% May 64.60%63.80%64.90%63.10%64.70%56.80% June 63.20%70.40%64.00%59.70%63.70%55.70% July 60.30%65.90%58.20%60.80%59.70%58.50% August 56.80%61.50%56.50%52.60%54.20%55.80% September 59.90%64.50%62.60%63.30%61.20%63.00% October 65.60%66.50%62.90%60.70%67.60%65.90% November 54.80%51.50%50.60%51.30%48.90%52.40% December 46.00%40.80%42.10%45.10%38.30%38.80% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: March 2019 Percent Change from March 2018 Percent Change from YTD 2018 2019 2018 2019 2018 2019 2018 Occ ADR RevPAR Room Rev Room Avail Room Sold 2019 2018 2019 2018 2019 2018 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 68.4 68.4 132.66 131.89 90.78 90.27 -0.0 0.6 0.6 2.6 2.0 2.0 61.8 61.5 129.02 127.65 79.68 78.54 0.4 1.1 1.5 3.5 2.0 2.4 54787 34115 5245049 3965052 West North Central 55.9 54.7 95.19 94.51 53.26 51.71 2.3 0.7 3.0 5.2 2.1 4.4 49.5 49.1 93.02 95.74 46.08 46.99 0.9 -2.8 -1.9 0.2 2.2 3.1 4596 2859 365600 274815 Missouri 60.7 59.9 99.35 97.63 60.31 58.48 1.3 1.8 3.1 5.6 2.4 3.7 51.3 51.2 95.77 94.03 49.13 48.11 0.2 1.8 2.1 4.6 2.4 2.7 1131 689 104648 76472 Kansas City, MO-KS 62.8 63.8 106.71 105.40 67.00 67.25 -1.6 1.3 -0.4 3.6 3.9 2.3 56.4 55.9 102.50 100.42 57.77 56.15 0.8 2.1 2.9 6.9 3.9 4.7 306 251 33825 29985 St Louis, MO-IL 67.4 68.7 104.56 100.08 70.44 68.76 -2.0 4.5 2.4 4.4 2.0 -0.0 56.5 58.3 100.80 97.56 57.00 56.84 -2.9 3.3 0.3 2.4 2.1 -0.9 341 257 39681 33426 Columbia, MO+57.8 56.8 86.20 87.49 49.84 49.71 1.8 -1.5 0.3 5.4 5.2 7.0 52.2 49.0 85.97 86.10 44.90 42.22 6.5 -0.1 6.3 11.9 5.3 12.1 40 31 4087 3379 Jefferson City, MO+58.0 57.5 83.19 79.61 48.24 45.78 0.8 4.5 5.4 14.6 8.8 9.7 55.1 53.0 81.84 80.91 45.09 42.85 4.0 1.2 5.2 11.3 5.7 10.0 16 13 1625 1271 Springfield, MO 70.5 70.2 89.91 85.76 63.40 60.25 0.4 4.8 5.2 6.4 1.1 1.5 56.3 58.4 83.40 81.13 47.00 47.38 -3.5 2.8 -0.8 1.0 1.8 -1.8 71 51 6357 4915 Branson, MO 48.6 46.2 98.57 102.37 47.91 47.29 5.2 -3.7 1.3 1.6 0.3 5.5 35.1 33.4 93.72 97.07 32.88 32.39 5.1 -3.4 1.5 2.1 0.6 5.8 140 35 13146 4735 Lake of the Ozarks+48.9 42.2 94.03 92.20 46.00 38.92 15.9 2.0 18.2 20.9 2.3 18.5 37.1 32.9 91.71 89.63 34.06 29.49 12.9 2.3 15.5 18.2 2.3 15.5 32 10 2533 1160 Joplin, MO 60.5 58.7 80.66 82.79 48.78 48.60 3.0 -2.6 0.4 0.4 0.0 3.0 51.4 52.5 80.00 81.69 41.12 42.85 -2.0 -2.1 -4.0 -4.0 0.0 -2.0 33 24 2477 2123 Saint Joseph, MO+61.4 58.5 91.44 87.82 56.12 51.39 4.9 4.1 9.2 4.4 -4.4 0.3 53.6 50.6 88.45 86.88 47.45 43.92 6.1 1.8 8.0 3.3 -4.4 1.5 12 11 1161 1107 Independence, MO+54.9 53.6 79.16 77.28 43.43 41.41 2.4 2.4 4.9 4.9 0.0 2.4 50.2 48.1 79.60 76.72 39.97 36.93 4.3 3.8 8.2 8.2 0.0 4.3 21 14 1631 1392 A blank row indicates insufficient data. ADRRevPARADR Current Month - March 2019 vs March 2018 Occ % The STR Destination Report is a publication of STR, Inc. and STR Global, Ltd., and is intended solely for use by paid subscribers. Reproduction or distribution of the STR Destination Report, in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to the STR Destination Report, please contact us immediately. Source: 2019 STR, Inc. / STR Global, Ltd. trading as "STR". Year to Date - March 2019 vs March 2018 Occ %RevPAR Rooms Participation Properties Tab 3 - Help Glossary: Frequently Asked Questions (FAQ): North America:International: 735 East Main Street, Hendersonville, TN 37075 USA Blue Fin Building, 110 Southwark Street, London SE1 0TA T : +1 615 824 8664 T : +44 (0) 20 7922 1930 industryinfo@str.com Asia Pacific: Thong Teck Building, 15 Scotts Road #08-12, 228 218 Singapore T: +64 6800 7850 apinfo@str.com For all STR definitions, please visit www.str.com/resources/glossary For the latest in industry news, visit HotelNewsNow.com. To learn more about the Hotel Data Conference, visit HotelDataConference.com. For all STR FAQs, please click here or visit www.str.com/resources/faq Please visit our website at www.str.com, or if you need additional assistance please reach out to our Customer Support team. destininfo@str.com