Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2022-07-21 packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, July 21, 2022 at 7:30 AM Virtual Meeting – WebEx Link: Call-In Participation Available at: 1-404-397-1516 Meeting Number: 2486 952 7704 Meeting Password: 1234 TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the April 18, 2022 and April 21, 2022 meetings 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. Consideration of Changing Part-time Building Services Worker to Full-time Building Services Worker – Captain Heislen 7. Temporarily Waiving Council Approval for Grant Applications that Require $25,000 or more of Ctiy Matching Funds – Ryan Moehlman 8. Public Comments 9. New Business 10. Old Business 11. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. https://jeffersoncity.webex.com/jeffersoncity/j.php?MTID=mf63f9680fb4ea6983a6ea9b69fb4a0d0 Minutes of Meeting Jefferson City Council Finance Committee Monday, April 18, 2022 Item 20 on the Second Regular Council Meeting Agenda (New City Council) 6:00 PM City Council Meeting The meeting was convened at 7:58 P.M. by the current Chair of the Committee, Councilmember Hensley for the purpose of election of officers. Members of the Committee were present by roll call: Present: Kemna, Lester, Wiseman, Spicer, and Hensley Absent: None Councilmember Hensley opened the floor for nominations of Chair and Vice- Chair. Chair – Councilmember W iseman nominated Councilmember Hensley as Chair. Councilmember Wiseman motioned to cease nominations and elect Councilmember Hensley by acclamation. Councilmember Spicer seconded the motion. Councilmember Hensley was elected unanimously. Vice-Chair – Councilmember Hensley nominated Councilmember Spicer as Vice-Chair. Councilmember Hensley motioned to cease nominations and elect Councilmember Spicer by acclamation. Councilmember Wiseman seconded the motion. Councilmember Spicer was elected unanimously. Determine Standard Meeting Schedule The City Council Finance Committee meets at 7:30 A.M. on the Thursday after the second City Council meeting of each month. Adjourn There being no further business brought before the Committee at this time, Councilmember Hensley moved for adjournment, seconded by Councilmember Spicer, and approved unanimously at 7:59 P.M. CITY OF JEFFERSON Finance Committee Meeting Thursday, April 21, 2022 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Hensley at 7:30 am. Roll call showed that Councilmen Hensley, Kemna, Lester, Spicer and Wiseman were in attendance. The next item on the agenda was the approval of the minutes of the January 20, 2022 meeting. A motion to approve was made by Councilman Kemna and seconded by Councilman Spicer. The minutes were approved unanimously. The next item on the agenda was a report by the Interim Finance Director, Shiela Pearre, covering the Financial Reports. Mrs. Pearre reviewed the Revenue Model, the March sales tax receipts, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by Interim Finance Director Shiela Pearre, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the 4 Cent Lockbox Fund, is $7,360,945. The average monthly amount collected for the 4 Cent Lockbox Fund is $53,908. A report comparing occupancy rates for 2022, 2021, 2020, 2019, 2018, 2017, and 2016 was included along with a report listing occupancy rates from other cities. The next item on the agenda was the Proposed FY2023 Budget Calendar presented by Ms. Mueller. A request was made by the Committee to change the proposed calendar so that: 1) the July 25th meeting includes the Mayor’s budget presentation; budget highlights; discussion of revenues; and the Five Year Financial Plan, and 2) that the July 28th meeting starts the Department presentations, which should be condensed to only two meetings instead of three. A motion to move the FY2022 Calendar to full Council with the requested changes was made by Councilman Hensley and seconded by Councilman Spicer. The motion passed unanimously. There were no public comments. There was no new business. There was no old business. A motion to adjourn was made by Councilwoman Wiseman and seconded by Councilman Spicer. The meeting adjourned at 8:33 am. As recorded by: Shelby Convery, Senior Accountant Memo To:Steve Crowell From:Shiela Pearre Date:July 7, 2022 Re:Sales Tax Revenues The City received the July 1% Sales Tax in the amount of $1,109,974 which is $20,178 less than projected for July. January through July overage is $509,745 (4.07%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection 1 Variance Nov-21 Jan-22 $1,023,976 $1,021,454 $2,523 Dec-21 Feb-22 $1,222,207 $956,778 $265,429 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $1,103,825 $1,087,131 $16,694 Feb-22 Apr-22 $1,000,444 $917,291 $83,153 Mar-22 May-22 $981,749 $848,048 $133,701 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $1,227,939 $1,199,514 $28,424 May-22 Jul-22 $1,109,974 $1,130,153 ($20,178) Jun-22 Aug-22 $958,297 Jul-22 & Apr-June 22 Qtrly Sep-22 $1,228,151 Aug-22 Oct-22 $1,071,005 Sep-22 Nov-22 $917,615 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $1,186,039 Total Overage/Shortfall $7,670,114 $12,521,475 $509,745 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G & H Receipt Actual Budget Period Receipts Projection 2 Variance Nov-21 Jan-22 $509,721 $ 432,354 $77,367 Dec-21 Feb-22 $589,318 $ 404,978 $184,339 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,222 $ 460,153 $74,069 Feb-22 Apr-22 $480,689 $ 388,264 $92,424 Mar-22 May-22 $475,930 $ 358,956 $116,975 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 507,722 $91,552 May-22 Jul-22 $547,456 $ 478,363 $69,093 Jun-22 Aug-22 $ 405,621 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 519,843 Aug-22 Oct-22 $ 453,327 Sep-22 Nov-22 $ 388,401 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 502,018 Total Overage/Shortfall $3,736,609 $5,300,000 $705,820 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection 3 Variance Nov-21 Jan-22 $509,721 $ 490,007 $19,714 Dec-21 Feb-22 $589,297 $ 458,981 $130,316 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $534,624 $ 521,514 $13,110 Feb-22 Apr-22 $480,688 $ 440,038 $40,650 Mar-22 May-22 $475,930 $ 406,822 $69,109 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $599,274 $ 575,425 $23,848 May-22 Jul-22 $547,054 $ 542,152 $4,903 Jun-22 Aug-22 $ 459,710 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 589,163 Aug-22 Oct-22 $ 513,778 Sep-22 Nov-22 $ 440,194 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 568,961 Total Overage/Shortfall $3,736,589 $6,006,745 $301,650 3Budgeted based on 3-year average percentage 1/4% Public Safety Tax Receipt Actual Budget Period Receipts Projection 4 Variance Nov-21 Jan-22 $0 $ 0 $0 Dec-21 Feb-22 $0 $ 0 $0 Jan-22 & Oct-Dec 21 Qtrly Mar-22 $0 $ 0 $0 Feb-22 Apr-22 $0 $ 0 $0 Mar-22 May-22 $0 $ 0 $0 Apr-22 & Jan-Mar 22 Qtrly Jun-22 $194,549 $ 266,532 ($71,984) May-22 Jul-22 $239,893 $ 228,643 $11,250 Jun-22 Aug-22 $ 204,799 Jul-22 & Apr-June 22 Qtrly Sep-22 $ 251,717 Aug-22 Oct-22 $ 228,870 Sep-22 Nov-22 $ 199,698 Oct-22 & Jul-Sept 22 Qtrly Dec-22 $ 253,074 Total Overage/Shortfall $434,442 $1,633,333 ($60,734) 4Budgeted based on 7 of 12 months - $2,800,000 annual collections - using General Fund FY2021 monthly collection percentages Period Reporting Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: JULY 2022 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 1,023,976 act.1,015,046 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 1,222,207 act.906,577 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 1,088,631 1,066,146 1,115,596 1,103,825 act.1,099,991 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 1,000,444 act.913,523 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 981,749 act.763,669 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,126,211 1,093,256 1,297,057 1,227,939 act.1,111,955 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 1,109,974 act.1,100,606 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 958,297 est.835,911 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,262,838 1,228,769 1,224,960 1,228,151 est.1,197,923 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 1,071,005 est.954,463 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 971,814 917,615 est.807,444 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,008,620 1,131,896 1,231,564 1,186,039 est.1,149,670 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $ 12,778,432 $7,670,114 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$5,361,107 Total Actual & Estimated $13,031,221 Less: Budget $12,521,475 Over (Under) Budget $509,745 1,023,976 2,246,183 3,350,008 4,350,452 5,332,201 6,560,139 7,670,114 1,021,454 1,978,232 3,065,363 3,982,653 4,830,701 6,030,216 7,160,368 8,118,666 9,346,817 10,417,822 11,335,437 12,521,475 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 4,500,000 5,000,000 5,500,000 6,000,000 6,500,000 7,000,000 7,500,000 8,000,000 8,500,000 9,000,000 9,500,000 10,000,000 10,500,000 11,000,000 11,500,000 12,000,000 12,500,000 13,000,000 13,500,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 Printed 7/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2022 Account Number 45/46-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 509,721 act.494,495 Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 589,318 act.441,430 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 534,222 act.534,319 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 480,689 act.437,358 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 475,930 act.373,052 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 599,274 act.542,927 May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 547,456 act.539,404 Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 405,621 est.407,127 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 519,843 est.579,706 Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 453,327 est.460,741 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 469,176 388,401 est.392,272 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 604,664 502,018 est.564,110 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $ 6,231,172 $3,736,609 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,269,211 Total Actual & Estimated $6,005,820 Less: Budget $5,300,000 Over (Under) Budget $705,820 509,721 1,099,039 1,633,261 2,113,949 2,589,880 3,189,154 3,736,609 432,354 837,332 1,297,485 1,685,749 2,044,704 2,552,426 3,030,789 3,436,410 3,956,253 4,409,581 4,797,982 5,300,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 Actu Bud Printed 7/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: JULY 2022 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 2022 Average Nov January 461,472 455,239 525,521 424,192 $525,690 513,808 483,288 509,721 act.494,500 Dec February 362,371 405,543 395,217 450,479 $427,689 458,324 473,676 589,297 act.441,077 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 $527,588 518,493 542,898 534,624 act.534,530 Feb April 512,738 431,353 411,020 457,060 $430,459 458,632 430,808 480,688 act.437,596 Mar May 308,030 322,957 340,162 340,708 $350,479 402,202 430,383 475,930 act.372,787 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 $554,065 537,107 626,235 599,274 act.542,936 May July 473,038 498,229 559,115 548,639 $481,406 560,720 547,152 547,054 act.539,406 Jun August 280,513 330,112 338,470 393,578 $372,405 443,965 487,128 459,710 est.407,109 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 $616,012 597,492 596,854 589,163 est.579,731 Aug October 442,370 435,416 425,497 423,387 $421,199 494,618 538,913 513,778 est.460,723 Sept November 330,393 310,506 307,305 374,484 $395,311 415,079 469,176 440,194 est.392,271 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 $495,452 558,134 604,664 568,961 est.564,114 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $ 6,231,173 $3,736,589 Estimated to Fiscal Year end (based on averages and on Budgeted amount)$2,571,806 Total Actual & Estimated $6,308,394 Less: Budget $6,006,745 Over (Under) Budget $301,650 509,721 1,099,018 1,633,642 2,114,330 2,590,261 3,189,534 3,736,589 490,007 948,988 1,470,502 1,910,540 2,317,362 2,892,787 3,434,939 3,894,649 4,483,812 4,997,590 5,437,783 6,006,745 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 5,850,000 6,100,000 6,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 Printed 7/7/2022 City of Jefferson, Mo. - Account Analysis Account Name Public Safety Rate:One-Quarter percent (1/4%)Receipt Month: JULY 2022 Account Number 55-100-400010 REPORTING PERIOD RECEIPT PERIOD 2022 Nov January 0 act. Dec February 0 act. Jan & Oct-Dec Qtrly March 0 act. Feb April 0 act. Mar May 0 act. Apr & Jan-Mar Qtrly June 194,549 act. May July 239,893 act. Jun August 204,799 est. Jul & Apr-Jun Qtrly September 251,717 est. Aug October 228,870 est. Sept November 199,698 est. Oct & Jul-Sept Qtrly December 253,074 est. Actual to Date $434,442 Estimated to Fiscal Year end (based on averages and on Budgete $1,138,158 Total Actual & Estimated $1,572,600 Less: Estimated Revenue $1,633,333 7 of 12 months - $2,800,000 annually Over (Under) Budget -$60,734 194,549 434,442 266,532 495,176 699,974 951,691 1,180,561 1,380,259 1,633,333 100,000 350,000 600,000 850,000 1,100,000 1,350,000 1,600,000 1,850,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 Printed 7/7/2022 Revenue Model Report For the Period Ending June 30, 2022 Data as of July 13, 2022 FY 2022 YTD Actual Projected Over/ Description Budget As of 7/13 (Under) Budget Sales Tax and Use Tax $12,521,475.39 $7,670,113.63 $509,745.32 Intergovernmental Taxes $2,512,000.00 $1,580,489.04 $46,606.58 Other Taxes $96,000.00 $49,997.04 ($4,281.69) Franchise & Utility Tax $6,450,000.00 $3,504,088.14 $29,595.57 Property Taxes $5,709,659.76 $5,794,228.58 $172,199.51 Intergovernmental $0.00 $3,801,625.50 $3,801,625.50 Charges for Services $3,000,478.08 $2,531,164.94 $50,580.44 Fees, Licenses, & Permits $1,066,437.50 $721,203.95 ($40,051.66) Fines & Forfeitures $580,000.00 $279,326.83 ($138,459.43) Contributions/Donations $383,616.57 $313,125.83 $85,167.00 Other Operating Revenues $164,281.57 $99,151.68 ($7,196.53) Interest Income $170,000.00 $100,825.77 $48,832.32 Other Non Operating Revenue $55,000.00 $177,855.06 $177,855.06 Operating Transfers In $26,400.00 $19,202.87 $3,249.99 Totals $32,735,348.87 $26,642,398.86 $4,735,467.96 FY2022Revenue Model Report (Detail)Remaining For the Period Ending June 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 7/13 As of 7/13 TOTAL (Under) Budget of FormulasSales Tax and Use Tax 10-100-400010 Sales Tax $12,521,475.39 $7,670,113.63 $5,361,107.08 $13,031,220.71 $509,745.32 $509,745.32 10-100-400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $12,521,475.39 $7,670,113.63 $5,361,107.08 $13,031,220.71 $509,745.32 $509,745.32Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $612,000.00 $306,481.64 $325,538.41 $632,020.05 $20,020.05 $20,020.05 10-100-403010 Gasoline Tax $1,250,000.00 $632,444.82 $652,579.13 $1,285,023.95 $35,023.95 $35,023.95 10-100-430080 Road & Bridge Tax $650,000.00 $641,562.58 $0.00 $641,562.58 ($8,437.42)($8,437.42) $2,512,000.00 $1,580,489.04 $978,117.54 $2,558,606.58 $46,606.58 $46,606.58Other Taxes 10-100-403020 Cig Tax $96,000.00 $49,997.04 $41,721.27 $91,718.31 ($4,281.69)($4,281.69) $96,000.00 $49,997.04 $41,721.27 $91,718.31 ($4,281.69)($4,281.69)Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $3,900,000.00 $1,872,914.70 $2,104,798.98 $3,977,713.68 $77,713.68 $77,713.68 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 $800,000.00 $864,709.68 $155,307.15 $1,020,016.83 $220,016.83 $220,016.83 10-100-410052 Telephone/Cell Utility $1,450,000.00 $624,429.95 $561,029.09 $1,185,459.04 ($264,540.96)($264,540.96) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $300,000.00 $142,033.81 $154,372.20 $296,406.01 ($3,593.99)($3,593.99) $6,450,000.00 $3,504,088.14 $2,975,507.43 $6,479,595.57 $29,595.57 $29,595.57Property Taxes 10-100-420010 Current Property Tax $4,985,000.00 $5,029,203.94 $23,864.15 $5,053,068.09 $68,068.09 $68,068.09 10-100-420020 Del Property Tax $60,000.00 $54,731.64 $16,559.11 $71,290.75 $11,290.75 $11,290.75 10-100-420040 Fin Institution Tax $30,000.00 $32,244.53 $0.00 $32,244.53 $2,244.53 $2,244.53 10-100-420050 Prop Tax Int & Penalties $27,000.00 $20,994.98 $10,840.97 $31,835.95 $4,835.95 $4,835.95 10-100-420055 Surtax Receipts - County Reimb $41,659.76 $54,399.28 $0.00 $54,399.28 $12,739.52 $12,739.52 10-100-420060 Surtax Receipts $500,000.00 $504,996.89 $2,359.75 $507,356.64 $7,356.64 $7,356.64 10-100-420080 Special Tax Rev $66,000.00 $97,657.32 $34,006.70 $131,664.02 $65,664.02 $65,664.02 $5,709,659.76 $5,794,228.58 $87,630.69 $5,881,859.27 $172,199.51 $172,199.51Intergovernmental 10-100-430010 Federal Grant $0.00 $3,793,290.50 $0.00 $3,793,290.50 $3,793,290.50 $3,793,290.50 10-100-430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-430060 Drug Forfeiture $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480020 NSP Rehab Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480025 HUD Program Income $0.00 $8,335.00 $0.00 $8,335.00 $8,335.00 $8,335.00 $0.00 $3,801,625.50 $0.00 $3,801,625.50 $3,801,625.50 $3,801,625.50Charges for Services 10-100-440010 Admin Charge Backs $1,614,977.00 $1,614,977.00 $0.00 $1,614,977.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $25,000.00 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $36,000.00 $21,202.50 $11,642.83 $32,845.33 ($3,154.67)($3,154.67) 10-100-440910 Fuel Charge - backs $13,000.00 $10,628.42 $5,866.19 $16,494.61 $3,494.61 $3,494.61 10-100-440920 Parts Charge backs $242,732.58 $179,596.24 $89,305.40 $268,901.64 $26,169.06 $26,169.06 10-100-440930 Labor Charge backs $273,719.72 $170,915.41 $96,675.07 $267,590.48 ($6,129.24)($6,129.24) 10-100-481020 Cole Cty Animal Rescue $116,645.39 $58,322.70 $58,322.69 $116,645.39 $0.00 $0.00 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 $12,000.00 $0.00 $12,000.00 $0.00 $0.00 10-100-481045 Rent-tower Sites $185,000.00 $137,990.54 $77,156.11 $215,146.65 $30,146.65 $30,146.65 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 $417,564.39 $276,014.88 $139,498.12 $415,513.00 ($2,051.39)($2,051.39) 10-100-481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00 10-100-481085 Cole Cty GIS Joint Coop $15,000.00 $12,785.00 $5,000.00 $17,785.00 $2,785.00 $2,785.00 10-100-481100 Sale Of Grave Sites $3,000.00 $1,251.00 $818.18 $2,069.18 ($930.82)($930.82) 10-100-481105 TIF Administration Fee $20,839.00 $10,230.00 $10,609.00 $20,839.00 $0.00 $0.00 10-100-481110 Long & Short $0.00 $241.25 $0.00 $241.25 $241.25 $241.25 $3,000,478.08 $2,531,164.94 $519,893.58 $3,051,058.52 $50,580.44 $50,580.44Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $72,000.00 $72,075.50 $2,194.27 $74,269.77 $2,269.77 $2,269.77 10-100-450020 Business Licenses $220,000.00 $165,488.68 $52,552.36 $218,041.04 ($1,958.96)($1,958.96) 10-100-450021 Home Occupation Permit $2,500.00 $1,045.00 $994.62 $2,039.62 ($460.38)($460.38) 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 $22,439.38 $0.00 $22,439.38 $14,439.38 $14,439.38 10-100-450045 Building Construct. Fees $421,687.50 $201,196.79 $168,240.96 $369,437.75 ($52,249.75)($52,249.75) 10-100-450050 Electrical Certificates $22,000.00 $26,034.00 $4,211.20 $30,245.20 $8,245.20 $8,245.20 10-100-450060 Electrical Permits $5,000.00 $4,938.43 $1,405.44 $6,343.87 $1,343.87 $1,343.87 10-100-450070 Plumbing Licenses $12,400.00 $13,410.00 $888.66 $14,298.66 $1,898.66 $1,898.66 10-100-450080 Plumbing Permits $10,000.00 $9,458.50 $2,320.49 $11,778.99 $1,778.99 $1,778.99 FY2022Revenue Model Report (Detail)Remaining For the Period Ending June 30, 2022 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 7/13 As of 7/13 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $1,765.00 $436.79 $2,201.79 $201.79 $201.79 10-100-450091 Day Care Inspection Fees $5,500.00 $2,810.00 $1,949.89 $4,759.89 ($740.11)($740.11) 10-100-450092 Food Inspection Fees $88,000.00 $90,808.50 ($2,188.65)$88,619.85 $619.85 $619.85 10-100-450100 Curb Cut Permits $1,000.00 $715.00 $362.14 $1,077.14 $77.14 $77.14 10-100-450110 Board Of Adj Fees $2,000.00 $2,800.00 $857.14 $3,657.14 $1,657.14 $1,657.14 10-100-450120 Sign Permits $6,900.00 $4,177.00 $2,833.27 $7,010.27 $110.27 $110.27 10-100-450130 Demolition Permits $3,000.00 $2,081.00 $1,288.06 $3,369.06 $369.06 $369.06 10-100-450150 Acc Rep Fees-police $8,000.00 $4,482.80 $2,721.90 $7,204.70 ($795.30)($795.30) 10-100-450160 Accrpt/blastg P-fire $1,150.00 $223.37 $696.28 $919.65 ($230.35)($230.35) 10-100-450170 Animal Redemption Fees $98,000.00 $58,109.00 $39,348.04 $97,457.04 ($542.96)($542.96) 10-100-450180 Animal Vaccinations Fees $5,200.00 $2,625.00 $1,499.67 $4,124.67 ($1,075.33)($1,075.33) 10-100-450185 Animal Cremation Fees $50,000.00 $20,728.00 $15,854.19 $36,582.19 ($13,417.81)($13,417.81) 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 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450230 Vacating Right Of Way $800.00 $463.00 $228.57 $691.57 ($108.43)($108.43) 10-100-450250 Rezoning Request $0.00 $3,660.00 $0.00 $3,660.00 $3,660.00 $3,660.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $8,635.00 $6,110.52 $14,745.52 ($5,254.48)($5,254.48) 10-100-450260 Non-refundable Plans/spec $1,300.00 $1,035.00 $376.06 $1,411.06 $111.06 $111.06 $1,066,437.50 $721,203.95 $305,181.89 $1,026,385.84 ($40,051.66)($40,051.66)Fines & Forfeitures 10-100-460010 Court Cost $51,000.00 $21,019.07 $13,958.29 $34,977.36 ($16,022.64)($16,022.64) 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $8,500.00 $3,503.14 $2,318.08 $5,821.22 ($2,678.78)($2,678.78) 10-100-460020 Jail Cost Recovery $1,000.00 $157.50 $0.00 $157.50 ($842.50)($842.50) 10-100-460025 Alcohol Offense Cost Rec $6,000.00 $3,815.09 $1,643.68 $5,458.77 ($541.23)($541.23) 10-100-460030 Pol Fines-traffic $490,000.00 $229,159.99 $138,159.78 $367,319.77 ($122,680.23)($122,680.23) 10-100-460090 Parking Fines $29,000.00 $25,930.00 $8,160.71 $34,090.71 $5,090.71 $5,090.71 10-100-460100 Bankcard Charges ($5,500.00)($4,257.96)($2,026.81)($6,284.77)($784.77)($784.77) $580,000.00 $279,326.83 $162,213.74 $441,540.57 ($138,459.43)($138,459.43)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 $10,828.57 $11,843.57 $0.00 $11,843.57 $1,015.00 $1,015.00 10-100-480080 Dare Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480090 Police K-9 Donations $0.00 $1,000.00 $0.00 $1,000.00 $1,000.00 $1,000.00 10-100-480165 Animal S Donations $21,000.00 $97,604.33 $6,547.67 $104,152.00 $83,152.00 $83,152.00 10-100-481055 Street Repair-Solid Waste Cntr $351,788.00 $202,677.93 $149,110.07 $351,788.00 $0.00 $0.00 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $383,616.57 $313,125.83 $155,657.74 $468,783.57 $85,167.00 $85,167.00 Other Operating Revenues 10-100-480010 Citizen Participation $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $82,921.21 $44,402.05 $19,134.86 $63,536.91 ($19,384.30)($19,384.30) 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 $17,000.00 $8,445.81 $7,228.20 $15,674.01 ($1,325.99)($1,325.99) 10-100-481077 Insurance Claims $44,360.36 $46,303.82 $11,570.31 $57,874.13 $13,513.77 $13,513.77 10-100-481078 Cafeteria Refunds $20,000.00 $0.00 $20,000.00 $20,000.00 $0.00 $0.00 $164,281.57 $99,151.68 $57,933.36 $157,085.04 ($7,196.53)($7,196.53)Interest Income 10-100-470010 Interest $170,000.00 $100,825.77 $118,006.55 $218,832.32 $48,832.32 $48,832.32 $170,000.00 $100,825.77 $118,006.55 $218,832.32 $48,832.32 $48,832.32Other Non Operating Revenue 10-100-485050 Sale Of Assets $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06 10-100-486020 Capital Contribution-Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $55,000.00 $177,855.06 $55,000.00 $232,855.06 $177,855.06 $177,855.06Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $19,202.87 $10,447.12 $29,649.99 $3,249.99 $3,249.99 10-100-490355 Transfer from CIT 'G'$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,400.00 $19,202.87 $10,447.12 $29,649.99 $3,249.99 $3,249.99 $32,735,348.87 $26,642,398.86 $10,828,417.97 $37,470,816.83 $4,735,467.96 $4,735,467.96 General Ledger Trial Balance by Acct Type and Full Acct Number User: spearre Printed: 07/13/22 07:29:53 Period 01 - 12 Fiscal Year 2022 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 48,825.00 0.00 17,100.00 25.94 10-110-501015 Salary-Prosecuting Attorney 34,999.92 26,249.94 0.00 8,749.98 25.00 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits)16,598.40 4,081.77 0.00 12,516.63 75.41 10-110-502010 Social Security 8,990.53 5,678.25 0.00 3,312.28 36.84 10-110-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-110-502040 Workers Compensation 71.59 71.59 0.00 0.00 0.00 E05 Personnel Services 126,585.44 84,906.55 0.00 41,678.89 32.93 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 7.26 0.00 92.74 92.74 10-110-512010 Printing 400.00 326.93 0.00 73.07 18.27 10-110-512020 Copies 100.00 2.04 0.00 97.96 97.96 10-110-513010 Office Supplies 2,050.00 1,607.10 0.00 442.90 21.60 10-110-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-110-514040 Food 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,650.00 1,943.33 0.00 706.67 26.67 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,250.00 873.26 0.00 376.74 30.14 10-110-520030 Dues And Publications 4,900.00 4,722.80 0.00 177.20 3.62 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,089.84 270.00 0.00 819.84 75.23 10-110-522020 Professional Services 100.00 0.00 0.00 100.00 100.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,339.84 5,866.06 0.00 1,473.78 20.08 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 120.00 86.04 28.68 5.28 4.40 E25 Repairs & Maintenance 120.00 86.04 28.68 5.28 4.40 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 136,695.28 92,801.98 28.68 43,864.62 32.09 120 City Clerk 10-120-501020 Salaries 54,908.25 38,000.86 0.00 16,907.39 30.79 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 4,200.48 2,645.74 0.00 1,554.74 37.01 10-120-502020 Group Health Insurance 12,676.22 8,350.93 0.00 4,325.29 34.12 10-120-502030 Retirement 7,577.34 5,244.10 0.00 2,333.24 30.79 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 62.42 46.15 0.00 16.27 26.07 10-120-502060 Long Term Disability 155.45 115.09 0.00 40.36 25.96 10-120-502070 Employee Assistance Prgm 21.84 15.33 0.00 6.51 29.81 E05 Personnel Services 79,651.99 54,468.19 0.00 25,183.80 31.62 10-120-511020 Postage 200.00 140.07 0.00 59.93 29.97 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 136.73 0.00 163.27 54.42 10-120-513010 Office Supplies 200.00 140.49 0.00 59.51 29.76 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 417.29 0.00 282.71 40.39 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 358.58 0.00 41.42 10.36 10-120-522020 Professional Services 200.00 39.00 0.00 161.00 80.50 10-120-529030 Election Expense 18,579.79 39,171.92 0.00 -20,592.13 -110.83 E15 Contractual Services 19,254.79 39,634.50 0.00 -20,379.71 -105.84 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 10,555.00 4,840.92 28.65 5,685.43 53.86 E25 Repairs & Maintenance 10,555.00 4,840.92 28.65 5,685.43 53.86 10-120-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 120 City Clerk 110,161.78 99,360.90 28.65 10,772.23 9.78 140 City Administrator 10-140-501020 Salaries 211,181.31 145,994.45 0.00 65,186.86 30.87 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 16,155.37 9,719.88 0.00 6,435.49 39.83 10-140-502020 Group Health Insurance 24,948.52 13,721.61 0.00 11,226.91 45.00 10-140-502030 Retirement 29,143.02 20,147.22 0.00 8,995.80 30.87 10-140-502040 Workers Compensation 201.22 201.22 0.00 0.00 0.00 10-140-502050 Life Insurance 89.35 62.75 0.00 26.60 29.77 10-140-502060 Long Term Disability 218.85 237.10 0.00 -18.25 -8.34 10-140-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 281,981.32 190,114.92 0.00 91,866.40 32.58 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 36.57 0.00 113.43 75.62 10-140-512010 Printing 100.00 80.00 0.00 20.00 20.00 10-140-512020 Copies 150.00 41.62 0.00 108.38 72.25 10-140-513010 Office Supplies 750.00 461.65 0.00 288.35 38.45 10-140-514017 COVID-19 0.00 4,934.00 0.00 -4,934.00 0.00 10-140-517010 Operational Supplies 678.74 122.73 0.00 556.01 81.92 E10 Materials & Supplies 1,828.74 5,676.57 0.00 -3,847.83 -210.41 10-140-520030 Dues And Publications 700.00 1,786.78 0.00 -1,086.78 -155.25 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 500.00 0.00 1,500.00 75.00 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 400.00 0.00 0.00 400.00 100.00 E15 Contractual Services 3,100.00 2,286.78 0.00 813.22 26.23 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 300.00 265.95 28.65 5.40 1.80 E25 Repairs & Maintenance 300.00 265.95 28.65 5.40 1.80 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 287,210.06 198,344.22 28.65 88,837.19 30.93 145 CDBG-CV Cole Co EMS Station 10-145-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-145-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-145-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-145-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-145-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-145-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-145-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-145-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 145 CDBG-CV Cole Co EMS Station 0.00 0.00 0.00 0.00 0.00 146 HPF-P Bruhn Revitalization 10-146-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-146-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-146-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-146-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-146-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-146-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-146-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-146-511020 Postage 0.00 64.24 0.00 -64.24 0.00 E10 Materials & Supplies 0.00 64.24 0.00 -64.24 0.00 10-146-522020 Professional Services 420.00 0.00 0.00 420.00 100.00 E15 Contractual Services 420.00 0.00 0.00 420.00 100.00 10-146-550068 Pass-Through Grants 674,580.00 0.00 0.00 674,580.00 100.00 E65 Other Non-Operating Expenses 674,580.00 0.00 0.00 674,580.00 100.00 146 HPF-P Bruhn Revitalization 675,000.00 64.24 0.00 674,935.76 99.99 147 CDBG-CV Transform Housing 10-147-501020 Salaries 31,760.00 0.00 0.00 31,760.00 100.00 10-147-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-147-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-147-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-147-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-147-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-147-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-147-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 31,760.00 0.00 0.00 31,760.00 100.00 10-147-520072 Subrecipient Reimbursements 544,000.00 0.00 0.00 544,000.00 100.00 E15 Contractual Services 544,000.00 0.00 0.00 544,000.00 100.00 147 CDBG-CV Transform Housing 575,760.00 0.00 0.00 575,760.00 100.00 148 CDBG-CV 10-148-501020 Salaries 48,187.00 36,638.43 0.00 11,548.57 23.97 10-148-502010 Social Security 0.00 2,392.47 0.00 -2,392.47 0.00 10-148-502020 Group Health Insurance 0.00 10,758.30 0.00 -10,758.30 0.00 10-148-502030 Retirement 0.00 5,056.14 0.00 -5,056.14 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 45.26 0.00 -45.26 0.00 10-148-502060 Long Term Disability 0.00 112.31 0.00 -112.31 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 48,187.00 55,002.91 0.00 -6,815.91 -14.14 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 2.12 0.00 -2.12 0.00 10-148-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-148-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 2.12 0.00 -2.12 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-522020 Professional Services 31,500.00 22,500.00 9,000.00 0.00 0.00 10-148-528025 CARES-Childcare Services 124,030.00 38,346.00 0.00 85,684.00 69.08 10-148-528035 CARES-ED For-Profit Business 103,359.00 95,829.18 0.00 7,529.82 7.29 10-148-528045 CARES-ED Microenterprise 103,359.00 35,369.14 0.00 67,989.86 65.78 E15 Contractual Services 362,248.00 192,044.32 9,000.00 161,203.68 44.50 148 CDBG-CV 410,435.00 247,049.35 9,000.00 154,385.65 37.62 149 Entitlement Grant 10-149-501020 Salaries 51,247.02 19,356.22 0.00 31,890.80 62.23 10-149-501023 CARES-Salaries 0.00 0.00 0.00 0.00 0.00 10-149-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,920.40 1,307.10 0.00 2,613.30 66.66 10-149-502011 CARES-Social Security 0.00 0.00 0.00 0.00 0.00 10-149-502020 Group Health Insurance 14,746.59 5,368.45 0.00 9,378.14 63.60 10-149-502024 CARES-Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502030 Retirement 7,072.09 2,671.10 0.00 4,400.99 62.23 10-149-502031 CARES-Retirement 0.00 0.00 0.00 0.00 0.00 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 10-149-502041 CARES-Workers Comp 0.00 0.00 0.00 0.00 0.00 10-149-502050 Life Insurance 60.59 24.58 0.00 36.01 59.43 10-149-502051 CARES-Life Insurance 0.00 0.00 0.00 0.00 0.00 10-149-502060 Long Term Disability 149.89 60.23 0.00 89.66 59.82 10-149-502061 CARES-Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-149-502070 Employee Assistance Program 21.84 23.01 0.00 -1.17 -5.36 10-149-502071 CARES-Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 77,305.45 28,897.72 0.00 48,407.73 62.62 10-149-511010 Advertising 1,880.00 126.00 0.00 1,754.00 93.30 10-149-511011 CARES-Advertising 0.00 0.00 0.00 0.00 0.00 10-149-511020 Postage 270.00 25.22 0.00 244.78 90.66 10-149-511022 CARES-Postage 0.00 0.00 0.00 0.00 0.00 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 295.00 0.00 0.00 295.00 100.00 10-149-513011 CARES-Office Supplies 0.00 0.00 0.00 0.00 0.00 10-149-517010 Operational Supplies 220.00 0.00 0.00 220.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-517011 CARES-Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 2,665.00 151.22 0.00 2,513.78 94.33 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,025.00 0.00 0.00 1,025.00 100.00 10-149-520071 CARES-Training and Education 0.00 0.00 0.00 0.00 0.00 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 0.00 2,615.00 0.00 -2,615.00 0.00 10-149-528012 Housing Rehab-Energy Efficienc 0.00 0.00 0.00 0.00 0.00 10-149-528020 Housing Assistance 363,643.35 56,157.00 0.00 307,486.35 84.56 10-149-528025 CARES-Childcare Services 0.00 0.00 0.00 0.00 0.00 10-149-528030 Public Improvement 313,000.00 0.00 0.00 313,000.00 100.00 10-149-528035 CARES-ED For-Profit Business 0.00 0.00 0.00 0.00 0.00 10-149-528040 Neighborhood Redevelopmnt 41,214.50 41,214.50 0.00 0.00 0.00 10-149-528045 CARES-ED Microenterprise 0.00 0.00 0.00 0.00 0.00 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 20,000.00 0.00 0.00 20,000.00 100.00 10-149-528080 Homeless Objectives 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 738,882.85 99,986.50 0.00 638,896.35 86.47 10-149-547020 Maintenance Agreements 361.00 515.58 158.00 -312.58 -86.59 E25 Repairs & Maintenance 361.00 515.58 158.00 -312.58 -86.59 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 819,214.30 129,551.02 158.00 689,505.28 84.17 150 City Attorney 10-150-501020 Salaries 229,698.16 159,780.84 0.00 69,917.32 30.44 10-150-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 17,571.91 11,809.99 0.00 5,761.92 32.79 10-150-502020 Group Health Insurance 33,887.26 21,611.16 0.00 12,276.10 36.23 10-150-502030 Retirement 31,698.35 21,703.70 0.00 9,994.65 31.53 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 274.18 190.10 0.00 84.08 30.67 10-150-502060 Long Term Disability 591.19 405.31 0.00 185.88 31.44 10-150-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 314,017.36 215,777.91 0.00 98,239.45 31.28 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 407.42 0.00 92.58 18.52 10-150-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-150-512020 Copies 50.00 5.68 0.00 44.32 88.64 10-150-513010 Office Supplies 3,369.00 2,101.82 0.00 1,267.18 37.61 10-150-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 4,019.00 2,514.92 0.00 1,504.08 37.42 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,200.00 4,915.63 2,153.30 4,131.07 36.88 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 7,000.00 3,917.30 0.00 3,082.70 44.04 10-150-520080 Tuition Reimbursement 1,869.00 1,869.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 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 10,000.00 2,490.00 0.00 7,510.00 75.10 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 10-150-525031 Special Litigation Expenses 0.00 85,143.90 0.00 -85,143.90 0.00 E15 Contractual Services 30,569.00 98,335.83 2,153.30 -69,920.13 -228.73 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 360.00 325.95 28.65 5.40 1.50 E25 Repairs & Maintenance 360.00 325.95 28.65 5.40 1.50 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 Attorney 348,965.36 316,954.61 2,181.95 29,828.80 8.55 160 Municipal Court 10-160-501010 Salary-elected Officals 34,999.92 26,249.94 0.00 8,749.98 25.00 10-160-501020 Salaries 118,610.12 82,138.52 0.00 36,471.60 30.75 10-160-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-160-501050 Parttime(wo Benefits)7,000.00 3,254.47 0.00 3,745.53 53.51 10-160-501090 Overtime 1,500.00 563.72 0.00 936.28 62.42 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,401.42 8,346.80 0.00 4,054.62 32.69 10-160-502020 Group Health Insurance 26,475.46 16,736.11 0.00 9,739.35 36.79 10-160-502030 Retirement 16,575.20 11,412.92 0.00 5,162.28 31.14 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 141.98 100.70 0.00 41.28 29.07 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502060 Long Term Disability 352.27 250.79 0.00 101.48 28.81 10-160-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 218,320.06 149,298.16 0.00 69,021.90 31.62 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,050.00 966.07 0.00 2,083.93 68.33 10-160-512010 Printing 400.00 0.00 0.00 400.00 100.00 10-160-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-160-513010 Office Supplies 4,000.00 505.76 0.00 3,494.24 87.36 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,450.00 1,471.83 0.00 5,978.17 80.24 10-160-520025 Security 10,000.00 6,919.71 0.00 3,080.29 30.80 10-160-520030 Dues And Publications 200.00 180.00 0.00 20.00 10.00 10-160-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-160-520070 Training And Education 1,500.00 695.00 0.00 805.00 53.67 10-160-522020 Professional Services 6,000.00 412.50 0.00 5,587.50 93.13 10-160-525005 Appointed Counsel 4,000.00 1,227.75 0.00 2,772.25 69.31 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 21,990.00 9,434.96 0.00 12,555.04 57.09 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 6,295.00 5,360.00 66.33 868.67 13.80 E25 Repairs & Maintenance 6,295.00 5,360.00 66.33 868.67 13.80 10-160-572020 Purchase Of Equipment 3,000.00 0.00 0.00 3,000.00 100.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 3,000.00 0.00 0.00 3,000.00 100.00 160 Municipal Court 257,055.06 165,564.95 66.33 91,423.78 35.57 170 Human Resources 10-170-501020 Salaries 223,180.43 154,509.11 0.00 68,671.32 30.77 10-170-501050 Parttime(wo Benefits)13,000.00 11,586.30 0.00 1,413.70 10.87 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 42.98 0.00 57.02 57.02 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 18,075.45 12,500.60 0.00 5,574.85 30.84 10-170-502020 Group Health Insurance 24,473.08 16,240.74 0.00 8,232.34 33.64 10-170-502030 Retirement 30,812.70 21,328.19 0.00 9,484.51 30.78 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 265.61 188.65 0.00 76.96 28.97 10-170-502060 Long Term Disability 566.96 399.32 0.00 167.64 29.57 10-170-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 310,865.44 217,167.60 0.00 93,697.84 30.14 10-170-511010 Advertising 0.00 99.75 0.00 -99.75 0.00 10-170-511020 Postage 300.00 147.88 0.00 152.12 50.71 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 289.82 0.00 210.18 42.04 10-170-513010 Office Supplies 900.00 300.27 0.00 599.73 66.64 10-170-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-170-517010 Operational Supplies 800.00 168.03 0.00 631.97 79.00 E10 Materials & Supplies 3,300.00 1,005.75 0.00 2,294.25 69.52 10-170-520030 Dues And Publications 1,000.00 467.00 0.00 533.00 53.30 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 909.78 0.00 2,590.22 74.01 10-170-520070 Training And Education 5,220.00 867.02 0.00 4,352.98 83.39 10-170-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 266.00 0.00 234.00 46.80 10-170-522020 Professional Services 32,500.00 9,913.56 19,000.00 3,586.44 11.04 10-170-529010 Special Events 800.00 67.40 0.00 732.60 91.58 10-170-529015 Human Relations Commission 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 44,020.00 12,490.76 19,000.00 12,529.24 28.46 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 21,186.77 16,104.56 28.65 5,053.56 23.85 E25 Repairs & Maintenance 21,186.77 16,104.56 28.65 5,053.56 23.85 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 379,372.21 246,768.67 19,028.65 113,574.89 29.94 180 Finance Department 10-180-501020 Salaries 586,557.91 361,857.16 0.00 224,700.75 38.31 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 47,143.35 27,225.80 0.00 19,917.55 42.25 10-180-502020 Group Health Insurance 103,286.70 55,559.05 0.00 47,727.65 46.21 10-180-502030 Retirement 85,042.90 45,803.64 0.00 39,239.26 46.14 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 746.95 425.85 0.00 321.10 42.99 10-180-502060 Long Term Disability 1,758.64 1,020.91 0.00 737.73 41.95 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502070 Employee Assistance Prgm 256.62 180.45 0.00 76.17 29.68 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 825,291.90 492,571.69 0.00 332,720.21 40.32 10-180-511010 Advertising 1,000.00 150.00 0.00 850.00 85.00 10-180-511020 Postage 10,000.00 6,476.47 0.00 3,523.53 35.24 10-180-511021 Mail Machine Cost 3,000.00 1,512.37 0.00 1,487.63 49.59 10-180-512010 Printing 3,300.00 771.97 0.00 2,528.03 76.61 10-180-512020 Copies 1,000.00 43.56 0.00 956.44 95.64 10-180-512021 Copy Machine Cost 190.00 -352.67 168.48 374.19 196.94 10-180-513010 Office Supplies 3,000.00 338.38 0.00 2,661.62 88.72 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 4,500.00 4,059.87 0.00 440.13 9.78 E10 Materials & Supplies 25,990.00 12,999.95 168.48 12,821.57 49.33 10-180-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-180-520020 Auditing Travel Expenses 0.00 0.00 0.00 0.00 0.00 10-180-520030 Dues And Publications 2,300.00 1,050.00 0.00 1,250.00 54.35 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 7,975.76 1,951.15 0.00 6,024.61 75.54 10-180-520080 Tuition Reimbursement 0.00 2,688.00 0.00 -2,688.00 0.00 10-180-522010 Audit 56,553.73 53,642.17 0.00 2,911.56 5.15 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 160.00 0.00 140.00 46.67 E15 Contractual Services 67,129.49 59,491.32 0.00 7,638.17 11.38 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,260.00 1,260.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,260.00 1,260.00 0.00 0.00 0.00 10-180-572020 Purchase Of Equipment 0.00 0.00 2,923.35 -2,923.35 0.00 E70 Capital Purchases 0.00 0.00 2,923.35 -2,923.35 0.00 180 Finance Department 919,671.39 566,322.96 3,091.83 350,256.60 38.08 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 36,967.43 35,758.52 0.00 1,208.91 3.27 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 6,000.00 0.00 0.00 6,000.00 100.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 42,967.43 35,758.52 0.00 7,208.91 16.78 10-185-514010 Gas 13,000.00 12,894.50 0.00 105.50 0.81 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 10-185-514015 Tornado 0.00 0.00 0.00 0.00 0.00 10-185-514016 Flooding 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 13,000.00 12,894.50 0.00 105.50 0.81 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 445,389.47 670,148.15 0.00 -224,758.68 -50.46 10-185-521020 Insurance Deductible 25,000.00 62,543.74 0.00 -37,543.74 -150.17 10-185-521030 Self Ins Prop & Casualty 40,000.00 34,531.05 0.00 5,468.95 13.67 10-185-521060 Drugalcohol screening 3,564.00 2,147.00 0.00 1,417.00 39.76 10-185-521070 Prov For Unsettled Claims 0.00 0.00 0.00 0.00 0.00 10-185-522015 TIF Prof Svcs 0.00 0.00 0.00 0.00 0.00 10-185-522020 Professional Services 44,104.18 44,100.00 10,500.00 -10,495.82 -23.80 10-185-522023 LCRA Reimbursement 0.00 0.00 0.00 0.00 0.00 10-185-522025 JCTV 0.00 0.00 0.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.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 0.00 0.00 47,000.00 100.00 10-185-527020 Economic Development 185,000.00 186,668.00 0.00 -1,668.00 -0.90 10-185-529010 Special Events 7,000.00 2,059.86 0.00 4,940.14 70.57 E15 Contractual Services 797,057.65 1,002,197.80 10,500.00 -215,640.15 -27.05 10-185-531010 Electricity 30,000.00 17,558.22 0.00 12,441.78 41.47 10-185-533010 Natural Gas 5,200.00 5,734.12 0.00 -534.12 -10.27 10-185-535010 Water 7,250.00 3,536.50 0.00 3,713.50 51.22 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 42,450.00 26,828.84 0.00 15,621.16 36.80 10-185-540010 Building & Grounds Maint.122,417.27 121,102.93 0.00 1,314.34 1.07 10-185-540015 Amtrak Station 8,000.00 1,383.66 0.00 6,616.34 82.70 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,060.00 1,212.00 0.00 848.00 41.17 E25 Repairs & Maintenance 157,477.27 148,698.59 0.00 8,778.68 5.57 10-185-550010 Miscellaneous 4,000.00 13,098.00 0.00 -9,098.00 -227.45 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-550040 Public Art 0.00 0.00 0.00 0.00 0.00 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 0.00 0.00 0.00 0.00 0.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 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 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 10-185-550095 Cap Ave Demos & Acquisitions 575,000.00 137,491.64 313,953.00 123,555.36 21.49 E30 Other Operating Expenses 589,000.00 160,589.64 313,953.00 114,457.36 19.43 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-572015 Vehicle Leasing 159,452.75 116,056.02 0.00 43,396.73 27.22 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 159,452.75 116,056.02 0.00 43,396.73 27.22 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,801,405.10 1,503,023.91 324,453.00 -26,071.81 -1.45 190 Information Technology Svcs 10-190-501020 Salaries 548,889.18 407,577.97 0.00 141,311.21 25.74 10-190-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits)0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 45,134.17 29,920.09 0.00 15,214.08 33.71 10-190-502020 Group Health Insurance 94,024.95 59,651.32 0.00 34,373.63 36.56 10-190-502030 Retirement 81,418.51 49,961.84 0.00 31,456.67 38.64 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 699.52 472.42 0.00 227.10 32.47 10-190-502060 Long Term Disability 1,688.08 1,139.85 0.00 548.23 32.48 10-190-502070 Employee Assistance Prgm 207.48 145.77 0.00 61.71 29.74 E05 Personnel Services 774,620.10 550,227.47 0.00 224,392.63 28.97 10-190-511010 Advertising 2,304.00 2,444.00 0.00 -140.00 -6.08 10-190-511020 Postage 115.00 110.87 0.00 4.13 3.59 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 0.39 0.00 19.61 98.05 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-513010 Office Supplies 900.00 471.64 0.00 428.36 47.60 10-190-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-190-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-190-514040 Food 0.00 0.00 0.00 0.00 0.00 10-190-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-190-517010 Operational Supplies 4,500.00 3,425.92 0.00 1,074.08 23.87 E10 Materials & Supplies 7,839.00 6,452.82 0.00 1,386.18 17.68 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 139.00 0.00 161.00 53.67 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 10,000.00 3,425.61 0.00 6,574.39 65.74 10-190-520080 Tuition Reimbursement 4,032.00 1,344.00 0.00 2,688.00 66.67 10-190-522020 Professional Services 44,195.71 250.00 39,900.00 4,045.71 9.15 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet T1 Web 23,000.00 15,206.64 0.00 7,793.36 33.88 10-190-522050 Service-remote Locations 0.00 0.00 0.00 0.00 0.00 10-190-522060 City Web Site 4,400.00 4,315.00 0.00 85.00 1.93 E15 Contractual Services 85,927.71 24,680.25 39,900.00 21,347.46 24.84 10-190-534010 Telephone 56,000.00 53,376.54 0.00 2,623.46 4.68 E20 Utilities 56,000.00 53,376.54 0.00 2,623.46 4.68 10-190-545010 Software Licensemaint 217,595.35 186,820.75 23,013.40 7,761.20 3.57 10-190-545020 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 Equipment Maintenance 2,000.00 759.98 0.00 1,240.02 62.00 10-190-547020 Maintenance Agreements 22,000.00 10,712.00 0.00 11,288.00 51.31 E25 Repairs & Maintenance 243,595.35 198,292.73 23,013.40 22,289.22 9.15 10-190-572020 Purchase Of Equipment 435.29 435.29 0.00 0.00 0.00 E70 Capital Purchases 435.29 435.29 0.00 0.00 0.00 190 Information Technology Svcs 1,168,417.45 833,465.10 62,913.40 272,038.95 23.28 300 Police Department 10-300-501020 Salaries 4,627,347.27 3,033,798.26 0.00 1,593,549.01 34.44 10-300-501030 Holiday Pay 169,853.79 77,278.58 0.00 92,575.21 54.50 10-300-501040 Part-time (wbenefits)34,764.59 0.00 0.00 34,764.59 100.00 10-300-501050 Parttime(wo Benefits)47,304.18 20,704.33 0.00 26,599.85 56.23 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 9,360.00 12,843.71 0.00 -3,483.71 -37.22 10-300-501090 Overtime 287,140.24 190,639.61 0.00 96,500.63 33.61 10-300-501095 Overtime Straight Pay 13,275.00 13,291.39 0.00 -16.39 -0.12 10-300-502010 Social Security 394,487.08 240,757.19 0.00 153,729.89 38.97 10-300-502020 Group Health Insurance 920,452.34 569,923.99 0.00 350,528.35 38.08 10-300-502030 Retirement 942,191.34 567,297.85 0.00 374,893.49 39.79 10-300-502040 Workers Compensation 75,085.94 75,085.91 0.00 0.03 0.00 10-300-502050 Life Insurance 5,495.76 3,524.45 0.00 1,971.31 35.87 10-300-502060 Long Term Disability 13,637.73 8,738.77 0.00 4,898.96 35.92 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502070 Employee Assistance Prgm 1,976.52 1,388.70 0.00 587.82 29.74 10-300-503010 Awards Program 4,233.00 4,233.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,546,604.78 4,819,505.74 0.00 2,727,099.04 36.14 10-300-511010 Advertising 5,665.00 5,890.50 0.00 -225.50 -3.98 10-300-511020 Postage 1,395.00 940.99 0.00 454.01 32.55 10-300-512010 Printing 5,952.00 4,205.99 0.00 1,746.01 29.33 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 634.90 79.99 0.00 554.91 87.40 10-300-513010 Office Supplies 15,670.50 15,603.88 322.43 -255.81 -1.63 10-300-514010 Gas 164,000.00 133,170.21 0.00 30,829.79 18.80 10-300-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-300-514040 Food 651.00 820.83 0.00 -169.83 -26.09 10-300-515040 First Aid Supplies 1,378.00 914.27 0.00 463.73 33.65 10-300-516010 Ammunition & Firearms Supplies 34,365.57 20,081.67 13,405.25 878.65 2.56 10-300-516020 Dare Program 0.00 90.00 0.00 -90.00 0.00 10-300-516030 Special Investigation 2,325.00 0.00 0.00 2,325.00 100.00 10-300-516040 Investigations (Grant)0.00 0.00 0.00 0.00 0.00 10-300-516050 Community Projects 12,750.00 12,750.00 0.00 0.00 0.00 10-300-517010 Operational Supplies 55,050.00 57,848.13 350.00 -3,148.13 -5.72 E10 Materials & Supplies 299,836.97 252,396.46 14,077.68 33,362.83 11.13 10-300-520030 Dues And Publications 5,400.00 4,917.40 0.00 482.60 8.94 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 75,900.00 54,520.49 0.00 21,379.51 28.17 10-300-520080 Tuition Reimbursement 5,625.00 0.00 0.00 5,625.00 100.00 10-300-520090 Recruitment 2,325.00 2,273.86 0.00 51.14 2.20 10-300-521040 Medical Claimsservices 6,510.00 6,239.20 0.00 270.80 4.16 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 16,082.00 15,362.68 0.00 719.32 4.47 10-300-522026 Drug Forfeiture - Justice 74,953.39 60,486.70 13,065.60 1,401.09 1.87 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 33,006.21 0.00 -33,006.21 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,046.00 1,319.22 0.00 726.78 35.52 E15 Contractual Services 188,841.39 178,125.76 13,065.60 -2,349.97 -1.24 10-300-531010 Electricity 32,140.00 23,160.88 0.00 8,979.12 27.94 10-300-533010 Natural Gas 1,116.00 714.35 0.00 401.65 35.99 10-300-534010 Telephone 24,101.00 15,724.25 0.00 8,376.75 34.76 10-300-535010 Water 3,348.00 2,059.31 0.00 1,288.69 38.49 E20 Utilities 60,705.00 41,658.79 0.00 19,046.21 31.38 10-300-540010 Building & Grounds Maint.49,700.00 50,535.08 0.00 -835.08 -1.68 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-541030 Vehicle Wash 9,752.00 7,588.80 0.00 2,163.20 22.18 10-300-544010 K-9 Operations 16,740.00 14,451.40 0.00 2,288.60 13.67 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 22,599.00 12,158.53 0.00 10,440.47 46.20 10-300-545010 Software Licensemaint 74,123.00 63,976.05 0.00 10,146.95 13.69 10-300-546010 Clothing Expense 51,687.00 14,698.77 37,859.55 -871.32 -1.69 10-300-546020 Uniform Cleaning 23,715.00 15,412.98 0.00 8,302.02 35.01 10-300-547010 Equipment Maintenance 10,000.00 2,747.23 0.00 7,252.77 72.53 10-300-547020 Maintenance Agreements 57,121.00 42,207.15 754.01 14,159.84 24.79 10-300-547030 Radio Maintenance 9,300.00 640.48 0.00 8,659.52 93.11 E25 Repairs & Maintenance 324,737.00 224,416.47 38,613.56 61,706.97 19.00 10-300-572010 Purchase Of Vehicles 88,833.60 85,439.52 0.00 3,394.08 3.82 10-300-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 65,930.10 0.00 65,930.10 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 53,192.80 0.00 46,750.00 6,442.80 12.11 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID 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 11,260.75 0.00 0.00 11,260.75 100.00 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 4,295.20 0.00 0.00 4,295.20 100.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software-morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software-jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software-prof Serv 0.00 0.00 0.00 0.00 0.00 10-300-572410 Project Mgmt Fees 0.00 0.00 0.00 0.00 0.00 10-300-572420 Contingency 0.00 0.00 0.00 0.00 0.00 10-300-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 223,512.45 85,439.52 112,680.10 25,392.83 11.36 300 Police Department 8,644,237.59 5,601,542.74 178,436.94 2,864,257.91 33.13 310 School Resource Officer GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-501020 Salaries 415,821.02 216,359.49 0.00 199,461.53 47.97 10-310-501030 Holiday Pay 15,984.81 4,459.23 0.00 11,525.58 72.10 10-310-501090 Overtime 45,106.00 29,951.60 0.00 15,154.40 33.60 10-310-501095 Overtime Straight Pay 1,311.00 2,627.53 0.00 -1,316.53 -100.42 10-310-502010 Social Security 36,584.05 18,020.86 0.00 18,563.19 50.74 10-310-502020 Group Health Insurance 94,284.62 46,145.47 0.00 48,139.15 51.06 10-310-502030 Retirement 90,862.34 48,145.66 0.00 42,716.68 47.01 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 504.29 258.44 0.00 245.85 48.75 10-310-502060 Long Term Disability 1,247.26 641.27 0.00 605.99 48.59 10-310-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 E05 Personnel Services 708,432.97 373,285.17 0.00 335,147.80 47.31 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 15,345.00 3,036.46 0.00 12,308.54 80.21 10-310-517010 Operational Supplies 5,995.00 5,394.23 0.00 600.77 10.02 E10 Materials & Supplies 21,340.00 8,430.69 0.00 12,909.31 60.49 10-310-520070 Training And Education 4,650.00 564.00 0.00 4,086.00 87.87 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 564.00 0.00 4,086.00 87.87 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 6,974.00 2,607.60 4,899.00 -532.60 -7.64 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 360.00 0.00 0.00 360.00 100.00 E25 Repairs & Maintenance 7,334.00 2,607.60 4,899.00 -172.60 -2.35 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 741,756.97 384,887.46 4,899.00 351,970.51 47.45 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 100,744.19 73,258.25 0.00 27,485.94 27.28 10-320-501030 Holiday Pay 3,802.78 0.00 0.00 3,802.78 100.00 10-320-501090 Overtime 29,776.88 16,617.68 0.00 13,159.20 44.19 10-320-501095 Overtime Straight Pay 0.00 428.36 0.00 -428.36 0.00 10-320-502010 Social Security 8,866.14 6,633.33 0.00 2,232.81 25.18 10-320-502020 Group Health Insurance 19,512.74 12,841.61 0.00 6,671.13 34.19 10-320-502030 Retirement 22,020.48 17,157.83 0.00 4,862.65 22.08 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 118.73 84.55 0.00 34.18 28.79 10-320-502060 Long Term Disability 293.76 209.04 0.00 84.72 28.84 10-320-502070 Employee Assistance Prgm 43.68 30.69 0.00 12.99 29.74 E05 Personnel Services 187,183.77 129,265.73 0.00 57,918.04 30.94 10-320-514010 Gas 7,000.00 6,582.57 0.00 417.43 5.96 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,906.00 10,729.05 0.00 3,176.95 22.85 10-320-517010 Operational Supplies 7,246.20 999.95 0.00 6,246.25 86.20 E10 Materials & Supplies 28,152.20 18,311.57 0.00 9,840.63 34.96 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 22,152.72 10,500.00 0.00 11,652.72 52.60 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 22,152.72 10,500.00 0.00 11,652.72 52.60 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G.237,488.69 158,077.30 0.00 79,411.39 33.44 330 Animal Control 10-330-501020 Salaries 363,190.92 215,333.59 0.00 147,857.33 40.71 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 8,600.00 5,660.60 0.00 2,939.40 34.18 10-330-501090 Overtime 2,000.00 5,473.40 0.00 -3,473.40 -173.67 10-330-501095 Overtime Straight Pay 0.00 17.55 0.00 -17.55 0.00 10-330-502010 Social Security 28,595.00 15,792.92 0.00 12,802.08 44.77 10-330-502020 Group Health Insurance 93,893.80 50,629.76 0.00 43,264.04 46.08 10-330-502030 Retirement 51,583.15 26,373.14 0.00 25,210.01 48.87 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 434.52 253.18 0.00 181.34 41.73 10-330-502060 Long Term Disability 1,077.61 622.14 0.00 455.47 42.27 10-330-502070 Employee Assistance Prgm 174.72 122.76 0.00 51.96 29.74 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 554,230.80 324,960.12 0.00 229,270.68 41.37 10-330-511010 Advertising 405.00 991.75 0.00 -586.75 -144.88 10-330-511020 Postage 152.00 157.12 0.00 -5.12 -3.37 10-330-512010 Printing 1,860.00 610.13 0.00 1,249.87 67.20 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 379.90 0.00 1,201.10 75.97 10-330-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-514040 Food 223.00 95.14 0.00 127.86 57.34 10-330-515040 First Aid Supplies 295.00 160.00 0.00 135.00 45.76 10-330-517010 Operational Supplies 12,016.00 3,406.11 0.00 8,609.89 71.65 E10 Materials & Supplies 16,532.00 5,800.15 0.00 10,731.85 64.92 10-330-520030 Dues And Publications 1,491.00 31.25 0.00 1,459.75 97.90 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 2,611.00 1,538.00 0.00 1,073.00 41.10 10-330-521040 Medical Claimsservices 432.00 1,298.60 0.00 -866.60 -200.60 10-330-522020 Professional Services 6,510.00 1,252.00 0.00 5,258.00 80.77 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 1,854.36 0.00 3,353.64 64.39 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 33,031.25 0.00 33,031.25 0.00 0.00 E15 Contractual Services 49,283.25 5,974.21 33,031.25 10,277.79 20.85 10-330-531010 Electricity 22,789.00 14,620.00 0.00 8,169.00 35.85 10-330-533010 Natural Gas 18,000.00 18,837.13 0.00 -837.13 -4.65 10-330-534010 Telephone 580.00 670.44 0.00 -90.44 -15.59 10-330-535010 Water 3,800.00 1,841.35 0.00 1,958.65 51.54 E20 Utilities 45,169.00 35,968.92 0.00 9,200.08 20.37 10-330-540010 Building & Grounds Maint.15,000.00 23,492.65 30.00 -8,522.65 -56.82 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 540.00 540.00 0.00 0.00 0.00 10-330-544040 Care Of Animals 49,290.00 30,552.87 0.00 18,737.13 38.01 10-330-544050 Animal Food 6,603.00 2,815.01 0.00 3,787.99 57.37 10-330-545010 Software Licensemaint 3,191.00 2,703.07 495.29 -7.36 -0.23 10-330-546010 Clothing Expense 2,325.00 957.20 0.00 1,367.80 58.83 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 837.00 836.17 0.00 0.83 0.10 10-330-547020 Maintenance Agreements 360.00 510.02 0.00 -150.02 -41.67 10-330-547030 Radio Maintenance 60.00 0.00 0.00 60.00 100.00 10-330-547040 Crematory Maint & Repair 1,750.00 61.20 0.00 1,688.80 96.50 E25 Repairs & Maintenance 79,956.00 62,468.19 525.29 16,962.52 21.21 10-330-572010 Purchase of Vehicles 25,523.00 25,523.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 4,600.00 4,600.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 30,123.00 30,123.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 775,294.05 465,294.59 33,556.54 276,442.92 35.66 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 390 9-1-1 Police 10-390-501020 Salaries 907,042.83 544,037.66 0.00 363,005.17 40.02 10-390-501030 Holiday Pay 31,748.70 22,801.48 0.00 8,947.22 28.18 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 22,814.00 30,908.77 0.00 -8,094.77 -35.48 10-390-501095 Overtime Straight Pay 500.00 1,206.05 0.00 -706.05 -141.21 10-390-502010 Social Security 73,601.07 43,514.28 0.00 30,086.79 40.88 10-390-502020 Group Health Insurance 217,337.41 117,407.48 0.00 99,929.93 45.98 10-390-502030 Retirement 134,427.26 82,472.23 0.00 51,955.03 38.65 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,093.34 650.88 0.00 442.46 40.47 10-390-502060 Long Term Disability 2,691.88 1,612.29 0.00 1,079.59 40.11 10-390-502070 Employee Assistance Prgm 464.10 326.07 0.00 138.03 29.74 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,394,440.55 847,657.15 0.00 546,783.40 39.21 10-390-511010 Advertising 928.00 1,288.50 0.00 -360.50 -38.85 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-390-517010 Operational Supplies 6,225.00 8,412.02 0.00 -2,187.02 -35.13 E10 Materials & Supplies 7,153.00 9,700.52 0.00 -2,547.52 -35.61 10-390-520030 Dues And Publications 558.00 0.00 0.00 558.00 100.00 10-390-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-390-520070 Training And Education 4,650.00 1,116.40 0.00 3,533.60 75.99 10-390-522020 Professional Services 3,000.00 2,297.83 0.00 702.17 23.41 10-390-523010 Equipment Rentlease 96,760.00 50,301.41 0.00 46,458.59 48.01 E15 Contractual Services 104,968.00 53,715.64 0.00 51,252.36 48.83 10-390-531010 Electricity 11,160.00 3,751.16 0.00 7,408.84 66.39 10-390-533010 Natural Gas 279.00 123.58 0.00 155.42 55.71 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 131.20 0.00 705.80 84.32 E20 Utilities 12,276.00 4,005.94 0.00 8,270.06 67.37 10-390-545010 Software Licensemaint 42,901.00 46,535.53 0.00 -3,634.53 -8.47 10-390-546010 Clothing Expense 5,580.00 88.11 0.00 5,491.89 98.42 10-390-546020 Uniform Cleaning 2,976.00 1,209.70 0.00 1,766.30 59.35 10-390-547010 Equipment Maintenance 6,700.00 5,341.01 1,043.62 315.37 4.71 10-390-547020 Maintenance Agreements 88,613.00 54,678.15 8,747.57 25,187.28 28.42 10-390-547030 Radio Maintenance 4,650.00 0.00 0.00 4,650.00 100.00 E25 Repairs & Maintenance 151,420.00 107,852.50 9,791.19 33,776.31 22.31 10-390-572020 Purchase Of Equipment 30,545.00 0.00 14,235.01 16,309.99 53.40 E70 Capital Purchases 30,545.00 0.00 14,235.01 16,309.99 53.40 390 9-1-1 Police 1,700,802.55 1,022,931.75 24,026.20 653,844.60 38.44 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 400 Fire Department 10-400-501020 Salaries 4,001,867.89 2,673,491.54 0.00 1,328,376.35 33.19 10-400-501030 Holiday Pay 329,190.84 303,924.46 0.00 25,266.38 7.68 10-400-501050 Parttime(wo Benefits)0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 38,000.00 22,688.85 0.00 15,311.15 40.29 10-400-501090 Overtime 45,000.00 71,716.31 0.00 -26,716.31 -59.37 10-400-501095 Overtime Straight Pay 40,000.00 63,436.40 0.00 -23,436.40 -58.59 10-400-502010 Social Security 67,074.57 44,471.57 0.00 22,603.00 33.70 10-400-502020 Group Health Insurance 857,281.66 543,438.63 0.00 313,843.03 36.61 10-400-502030 Retirement 2,168,347.96 1,494,616.96 0.00 673,731.00 31.07 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 4,724.64 3,271.81 0.00 1,452.83 30.75 10-400-502060 Long Term Disability 11,754.80 8,017.40 0.00 3,737.40 31.79 10-400-502070 Employee Assistance Prgm 1,659.84 1,166.19 0.00 493.65 29.74 10-400-503010 Awards Program 1,500.00 499.02 0.00 1,000.98 66.73 E05 Personnel Services 7,719,433.15 5,383,770.09 0.00 2,335,663.06 30.26 10-400-511010 Advertising 300.00 105.00 0.00 195.00 65.00 10-400-511020 Postage 139.50 143.83 0.00 -4.33 -3.10 10-400-512010 Printing 700.00 234.22 0.00 465.78 66.54 10-400-512020 Copies 46.50 0.00 0.00 46.50 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 819.32 0.00 575.68 41.27 10-400-514010 Gas 59,000.00 58,299.55 0.00 700.45 1.19 10-400-514017 COVID-19 8,481.00 10,069.27 0.00 -1,588.27 -18.73 10-400-514020 Chemicals 930.00 0.00 0.00 930.00 100.00 10-400-514030 Small Tools 6,000.00 3,060.27 0.00 2,939.73 49.00 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,046.00 1,091.25 0.00 954.75 46.66 10-400-517010 Operational Supplies 17,000.00 4,657.23 0.00 12,342.77 72.60 E10 Materials & Supplies 96,038.00 78,479.94 0.00 17,558.06 18.28 10-400-520030 Dues And Publications 3,373.65 3,362.10 0.00 11.55 0.34 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,427.51 18,319.78 0.00 14,107.73 43.51 10-400-520080 Tuition Reimbursement 7,045.00 5,376.00 0.00 1,669.00 23.69 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 40,000.00 33,440.00 0.00 6,560.00 16.40 10-400-522020 Professional Services 3,333.00 2,067.73 0.00 1,265.27 37.96 10-400-523010 Equipment Rentlease 186.00 0.00 0.00 186.00 100.00 10-400-524010 Trash Collections 93.00 0.00 0.00 93.00 100.00 10-400-529010 Special Events 6,510.00 1,485.25 0.00 5,024.75 77.19 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,605.00 0.00 895.00 35.80 E15 Contractual Services 95,468.16 65,655.86 0.00 29,812.30 31.23 10-400-531010 Electricity 35,000.00 21,147.18 0.00 13,852.82 39.58 10-400-533010 Natural Gas 17,670.00 18,826.96 0.00 -1,156.96 -6.55 10-400-534010 Telephone 25,984.20 16,687.02 0.00 9,297.18 35.78 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-535010 Water 12,000.00 7,363.15 0.00 4,636.85 38.64 E20 Utilities 90,654.20 64,024.31 0.00 26,629.89 29.38 10-400-540010 Building & Grounds Maint.98,455.49 64,593.73 13,286.43 20,575.33 20.90 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 96,004.91 77,768.81 0.00 18,236.10 18.99 10-400-546020 Uniform Cleaning 500.00 0.00 0.00 500.00 100.00 10-400-547010 Equipment Maintenance 20,667.24 4,989.73 2,470.00 13,207.51 63.91 10-400-547020 Maintenance Agreements 38,412.76 25,976.68 95.41 12,340.67 32.13 10-400-547030 Radio Maintenance 20,925.00 13,585.11 0.00 7,339.89 35.08 E25 Repairs & Maintenance 274,965.40 186,914.06 15,851.84 72,199.50 26.26 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles-Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 1,719.69 0.00 -1,719.69 0.00 10-400-572021 Purchase of Equipment-ONE TIME 24,640.00 0.00 22,310.00 2,330.00 9.46 10-400-572022 Fitness-ONE TIME 0.00 0.00 0.00 0.00 0.00 10-400-572060 Fire Grant Equipgear 0.00 0.00 0.00 0.00 0.00 10-400-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 10-400-575004 Fire Apparatus 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 24,640.00 1,719.69 22,310.00 610.31 2.48 400 Fire Department 8,301,198.91 5,780,563.95 38,161.84 2,482,473.12 29.90 401 Fire Museum 10-401-531010 Electricity 1,860.00 1,659.34 0.00 200.66 10.79 10-401-533010 Natural Gas 0.00 0.00 0.00 0.00 0.00 10-401-535010 Water 0.00 0.00 0.00 0.00 0.00 E20 Utilities 1,860.00 1,659.34 0.00 200.66 10.79 10-401-540010 Building & Grounds Maint.0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 401 Fire Museum 1,860.00 1,659.34 0.00 200.66 10.79 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm Serv Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-500-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-500-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-500-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-500-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 500 Public Works 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 10-520-501020 Salaries 233,614.13 152,347.62 0.00 81,266.51 34.79 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 17,871.48 11,075.64 0.00 6,795.84 38.03 10-520-502020 Group Health Insurance 31,670.84 26,571.21 0.00 5,099.63 16.10 10-520-502030 Retirement 32,238.75 19,375.25 0.00 12,863.50 39.90 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 275.40 180.58 0.00 94.82 34.43 10-520-502060 Long Term Disability 605.64 387.65 0.00 217.99 35.99 10-520-502070 Employee Assistance Prgm 87.36 46.02 0.00 41.34 47.32 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 316,560.50 210,180.87 0.00 106,379.63 33.60 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 130.82 0.00 -55.82 -74.43 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 429.55 0.00 420.45 49.46 10-520-514010 Gas 13,000.00 9,994.02 0.00 3,005.98 23.12 10-520-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 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 243.73 0.00 256.27 51.25 E10 Materials & Supplies 14,525.00 10,798.12 0.00 3,726.88 25.66 10-520-520030 Dues And Publications 1,200.00 931.70 0.00 268.30 22.36 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,800.00 25.00 0.00 1,775.00 98.61 10-520-522020 Professional Services 9,756.70 7,251.21 0.00 2,505.49 25.68 E15 Contractual Services 12,756.70 8,207.91 0.00 4,548.79 35.66 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 28,348.00 38,632.98 22.47 -10,307.45 -36.36 E25 Repairs & Maintenance 28,348.00 38,632.98 22.47 -10,307.45 -36.36 10-520-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 520 Plan & Protect Svcs-Admin 372,190.20 267,819.88 22.47 104,347.85 28.04 521 Plan & Protect Svcs-Planning 10-521-501020 Salaries 136,004.52 66,629.82 0.00 69,374.70 51.01 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 11,226.98 4,965.69 0.00 6,261.29 55.77 10-521-502020 Group Health Insurance 25,099.96 11,142.74 0.00 13,957.22 55.61 10-521-502030 Retirement 20,252.59 7,721.18 0.00 12,531.41 61.88 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 176.62 81.30 0.00 95.32 53.97 10-521-502060 Long Term Disability 435.33 202.19 0.00 233.14 53.55 10-521-502070 Employee Assistance Prgm 58.97 41.43 0.00 17.54 29.74 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 193,413.32 90,942.70 0.00 102,470.62 52.98 10-521-511010 Advertising 4,000.00 1,834.50 0.00 2,165.50 54.14 10-521-511020 Postage 500.00 81.06 0.00 418.94 83.79 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-513010 Office Supplies 800.00 160.14 0.00 639.86 79.98 10-521-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-521-514040 Food 200.00 0.00 0.00 200.00 100.00 10-521-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-521-517010 Operational Supplies 1,500.00 1,018.96 0.00 481.04 32.07 E10 Materials & Supplies 7,000.00 3,094.66 0.00 3,905.34 55.79 10-521-520030 Dues And Publications 14,329.49 874.00 0.00 13,455.49 93.90 10-521-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-521-520070 Training And Education 2,400.00 0.00 0.00 2,400.00 100.00 10-521-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 16,729.49 874.00 0.00 15,855.49 94.78 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,552.00 785.43 301.84 464.73 29.94 E25 Repairs & Maintenance 1,552.00 785.43 301.84 464.73 29.94 10-521-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 521 Plan & Protect Svcs-Planning 218,694.81 95,696.79 301.84 122,696.18 56.10 522 Plan & Protect Svcs-MPO 10-522-501020 Salaries 121,616.91 85,494.72 0.00 36,122.19 29.70 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,686.19 6,485.70 0.00 3,200.49 33.04 10-522-502020 Group Health Insurance 20,600.84 12,282.47 0.00 8,318.37 40.38 10-522-502030 Retirement 17,473.13 11,344.87 0.00 6,128.26 35.07 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 150.91 98.45 0.00 52.46 34.76 10-522-502060 Long Term Disability 374.46 244.07 0.00 130.39 34.82 10-522-502070 Employee Assistance Prgm 50.23 35.28 0.00 14.95 29.76 E05 Personnel Services 170,055.22 116,088.11 0.00 53,967.11 31.74 10-522-511010 Advertising 1,800.00 501.05 0.00 1,298.95 72.16 10-522-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-522-513010 Office Supplies 1,000.00 20.65 0.00 979.35 97.94 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 31.89 0.00 1,588.11 98.03 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 5,005.00 553.59 0.00 4,451.41 88.94 10-522-520030 Dues And Publications 1,500.00 120.00 0.00 1,380.00 92.00 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 4,500.00 20.00 0.00 4,480.00 99.56 10-522-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-522-522020 Professional Services 108,000.00 8,000.00 100,000.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 114,000.00 8,140.00 100,000.00 5,860.00 5.14 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,533.00 795.15 270.91 466.94 30.46 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 1,533.00 795.15 270.91 466.94 30.46 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 290,593.22 125,576.85 100,270.91 64,745.46 22.28 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 64,752.71 50,096.86 0.00 14,655.85 22.63 10-530-501050 Parttime (wo Benefits)0.00 0.00 0.00 0.00 0.00 10-530-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-530-502010 Social Security 4,953.58 3,744.87 0.00 1,208.71 24.40 10-530-502020 Group Health Insurance 12,101.67 7,334.62 0.00 4,767.05 39.39 10-530-502030 Retirement 8,935.87 6,913.38 0.00 2,022.49 22.63 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 77.72 60.82 0.00 16.90 21.74 10-530-502060 Long Term Disability 191.56 150.18 0.00 41.38 21.60 10-530-502070 Employee Assistance Prgm 32.76 15.33 0.00 17.43 53.21 E05 Personnel Services 91,103.95 68,374.14 0.00 22,729.81 24.95 10-530-511010 Advertising 45.00 761.50 0.00 -716.50 -1,592.22 10-530-511020 Postage 25.00 70.92 0.00 -45.92 -183.68 10-530-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-530-512020 Copies 0.00 1.16 0.00 -1.16 0.00 10-530-513010 Office Supplies 0.00 633.94 0.00 -633.94 0.00 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 2,805.37 3,069.24 0.00 -263.87 -9.41 E10 Materials & Supplies 2,875.37 4,536.76 0.00 -1,661.39 -57.78 10-530-520030 Dues And Publications 500.00 173.90 0.00 326.10 65.22 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,494.63 611.37 0.00 883.26 59.10 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-522020 Professional Services 240.00 0.00 0.00 240.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 5,000.00 0.00 0.00 5,000.00 100.00 10-530-524026 Household Hazardous Waste 31,300.00 11,763.93 0.00 19,536.07 62.42 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524029 Recycling Education 18,000.00 0.00 0.00 18,000.00 100.00 10-530-526060 Refund of Grant Proceeds 78,805.90 0.00 0.00 78,805.90 100.00 10-530-528085 Fair Housing Assistance Prog 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 135,340.53 12,549.20 0.00 122,791.33 90.73 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 361.00 0.00 0.00 361.00 100.00 E25 Repairs & Maintenance 361.00 0.00 0.00 361.00 100.00 10-530-550020 NRA-Residential 40,000.00 33,825.51 0.00 6,174.49 15.44 10-530-550030 NRA-Commercial Facade 19,500.00 12,000.00 0.00 7,500.00 38.46 10-530-550031 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 10-530-550032 NRA-Rental Facade 15,000.00 108.00 0.00 14,892.00 99.28 10-530-550033 HPF Grant-Structural Survey 0.00 0.00 0.00 0.00 0.00 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 60.00 0.00 440.00 88.00 10-530-550039 Historic Preservation Grant 23,000.00 10,016.33 2,750.00 10,233.67 44.49 10-530-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.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 10-530-550066 HPF-Historic Context 50,000.00 16.34 42,500.00 7,483.66 14.97 10-530-550067 HPF PBruhn Revitalization 0.00 0.00 0.00 0.00 0.00 10-530-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 171,000.00 66,042.51 48,000.00 56,957.49 33.31 530 Plan & Protect Svc-RedevGrant 400,680.85 151,502.61 48,000.00 201,178.24 50.21 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 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 188,759.82 130,648.69 0.00 58,111.13 30.79 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 0.00 0.00 0.00 0.00 0.00 10-532-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-532-502010 Social Security 14,440.13 9,063.13 0.00 5,377.00 37.24 10-532-502020 Group Health Insurance 37,936.86 25,202.79 0.00 12,734.07 33.57 10-532-502030 Retirement 26,048.86 18,029.47 0.00 8,019.39 30.79 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 223.99 159.75 0.00 64.24 28.68 10-532-502060 Long Term Disability 557.41 396.47 0.00 160.94 28.87 10-532-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 271,786.01 187,299.74 0.00 84,486.27 31.09 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 109.64 0.00 40.36 26.91 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-532-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-532-513010 Office Supplies 1,300.00 295.72 0.00 1,004.28 77.25 10-532-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 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 -58.23 0.00 1,058.23 105.82 E10 Materials & Supplies 2,625.00 347.13 0.00 2,277.87 86.78 10-532-520030 Dues And Publications 900.00 902.00 0.00 -2.00 -0.22 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 96.99 0.00 903.01 90.30 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 4,996.70 4,996.70 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 199,200.00 132,800.00 66,400.00 0.00 0.00 10-532-529010 Special Events 600.00 600.00 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 206,696.70 139,395.69 66,400.00 901.01 0.44 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 39,500.00 23,831.98 11,848.00 3,820.02 9.67 10-532-540065 Cemetery Restoration 0.00 0.00 0.00 0.00 0.00 10-532-541030 Vehicle Wash 1,290.00 1,284.00 0.00 6.00 0.47 10-532-546010 Clothing Expense 1,080.00 438.00 0.00 642.00 59.44 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 1,081.00 1,164.81 147.89 -231.70 -21.43 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 42,991.00 26,718.79 11,995.89 4,276.32 9.95 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 524,098.71 353,761.35 78,395.89 91,941.47 17.54 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 183,639.02 121,011.77 0.00 62,627.25 34.10 10-533-501050 Parttime(wo Benefits)20,000.00 13,196.64 0.00 6,803.36 34.02 10-533-501060 Seasonal Salaries 0.00 1,938.38 0.00 -1,938.38 0.00 10-533-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 15,578.39 9,997.88 0.00 5,580.51 35.82 10-533-502020 Group Health Insurance 35,121.60 21,627.11 0.00 13,494.49 38.42 10-533-502030 Retirement 25,342.19 16,699.53 0.00 8,642.66 34.10 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 198.90 133.94 0.00 64.96 32.66 10-533-502060 Long Term Disability 523.14 368.39 0.00 154.75 29.58 10-533-502070 Employee Assistance Prgm 76.44 53.70 0.00 22.74 29.75 E05 Personnel Services 282,737.06 187,284.72 0.00 95,452.34 33.76 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 2,300.00 889.20 0.00 1,410.80 61.34 10-533-512010 Printing 300.00 509.50 0.00 -209.50 -69.83 10-533-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-533-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-533-513010 Office Supplies 1,000.00 196.70 0.00 803.30 80.33 10-533-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-533-514030 Small Tools 125.00 0.00 0.00 125.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 1,168.64 0.00 181.36 13.43 E10 Materials & Supplies 5,190.00 2,764.04 0.00 2,425.96 46.74 10-533-520030 Dues And Publications 500.00 75.00 0.00 425.00 85.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 1,400.00 761.02 0.00 638.98 45.64 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 160.00 0.00 -160.00 0.00 10-533-522021 Abatement 10,000.00 17,702.87 0.00 -7,702.87 -77.03 10-533-522022 Demo 230,782.57 161,073.32 0.00 69,709.25 30.21 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 0.00 0.00 0.00 0.00 10-533-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-533-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-533-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 242,682.57 179,772.21 0.00 62,910.36 25.92 10-533-534010 Telephone 3,701.40 2,073.52 0.00 1,627.88 43.98 E20 Utilities 3,701.40 2,073.52 0.00 1,627.88 43.98 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-546010 Clothing Expense 1,280.00 446.28 0.00 833.72 65.13 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 1,183.00 938.04 233.15 11.81 1.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,763.00 1,654.32 233.15 875.53 31.69 10-533-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 533 PPS - Prop MaintCode Enforce 537,074.03 373,548.81 233.15 163,292.07 30.40 534 Plan & Protect Svcs-Bldg Regs 10-534-501020 Salaries 285,185.83 198,917.71 0.00 86,268.12 30.25 10-534-501050 Parttime(wo Benefits)15,900.00 0.00 0.00 15,900.00 100.00 10-534-501060 Seasonal Salaries 0.00 8,468.46 0.00 -8,468.46 0.00 10-534-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-534-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-534-502010 Social Security 23,033.07 14,382.90 0.00 8,650.17 37.56 10-534-502020 Group Health Insurance 67,522.51 47,999.72 0.00 19,522.79 28.91 10-534-502030 Retirement 39,355.64 27,450.72 0.00 11,904.92 30.25 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 345.17 243.90 0.00 101.27 29.34 10-534-502060 Long Term Disability 845.87 606.36 0.00 239.51 28.32 10-534-502070 Employee Assistance Prgm 109.20 92.07 0.00 17.13 15.69 10-534-503020 Unemployment Compensation 0.00 3,200.00 0.00 -3,200.00 0.00 E05 Personnel Services 437,053.36 306,117.91 0.00 130,935.45 29.96 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 505.68 0.00 594.32 54.03 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 231.19 0.00 668.81 74.31 10-534-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-534-514030 Small Tools 100.00 109.40 0.00 -9.40 -9.40 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 127.98 0.00 1,672.02 92.89 E10 Materials & Supplies 4,115.00 974.25 0.00 3,140.75 76.32 10-534-520030 Dues And Publications 3,000.00 419.00 0.00 2,581.00 86.03 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 8,000.00 3,776.03 0.00 4,223.97 52.80 10-534-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-534-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-534-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-534-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-534-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-534-529020 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 11,000.00 4,195.03 0.00 6,804.97 61.86 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-534010 Telephone 2,100.00 2,259.50 0.00 -159.50 -7.60 E20 Utilities 2,100.00 2,259.50 0.00 -159.50 -7.60 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 515.00 0.00 665.00 56.36 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 1,022.00 651.50 266.80 103.70 10.15 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,492.00 1,436.50 266.80 788.70 31.65 10-534-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 534 Plan & Protect Svcs-Bldg Regs 456,760.36 314,983.19 266.80 141,510.37 30.98 535 Public Works-Central Maintenan 10-535-501020 Salaries 371,172.19 256,950.16 0.00 114,222.03 30.77 10-535-501040 Part-time (wbenefits)0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits)4,000.00 575.59 0.00 3,424.41 85.61 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 4,500.00 3,476.32 0.00 1,023.68 22.75 10-535-501095 Overtime Straight Pay 500.00 184.87 0.00 315.13 63.03 10-535-502010 Social Security 29,083.17 19,098.47 0.00 9,984.70 34.33 10-535-502020 Group Health Insurance 85,350.94 51,551.40 0.00 33,799.54 39.60 10-535-502030 Retirement 51,911.76 35,964.47 0.00 15,947.29 30.72 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 445.54 315.00 0.00 130.54 29.30 10-535-502060 Long Term Disability 1,101.36 783.59 0.00 317.77 28.85 10-535-502070 Employee Assistance Prgm 152.88 107.40 0.00 45.48 29.75 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 552,687.20 373,476.63 0.00 179,210.57 32.43 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 467.70 0.00 1,032.30 68.82 10-535-514011 Gas, Oil, & Antifreeze 0.00 0.00 0.00 0.00 0.00 10-535-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-535-514030 Small Tools 7,000.00 4,664.55 0.00 2,335.45 33.36 10-535-517010 Operational Supplies 7,000.00 5,188.94 0.00 1,811.06 25.87 E10 Materials & Supplies 15,640.00 10,321.19 0.00 5,318.81 34.01 10-535-520030 Dues And Publications 350.00 185.00 0.00 165.00 47.14 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 2,000.00 184.00 0.00 1,816.00 90.80 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,850.00 369.00 0.00 2,481.00 87.05 10-535-531010 Electricity 6,560.00 3,117.67 0.00 3,442.33 52.47 10-535-533010 Natural Gas 3,000.00 2,682.78 0.00 317.22 10.57 10-535-534010 Telephone 220.00 212.38 0.00 7.62 3.46 10-535-535010 Water 1,442.00 745.89 0.00 696.11 48.27 E20 Utilities 11,222.00 6,758.72 0.00 4,463.28 39.77 10-535-540010 Building & Grounds Maint.10,000.00 15,149.08 17.50 -5,166.58 -51.67 10-535-541010 Veh & Equip Parts Etc 600,000.00 475,075.75 0.00 124,924.25 20.82 10-535-541015 Vehicle Hail Damage Repair 24,360.36 24,360.36 0.00 0.00 0.00 10-535-546010 Clothing Expense 5,500.00 5,699.70 0.00 -199.70 -3.63 10-535-547010 Equipment Maintenance 1,000.00 278.80 89.35 631.85 63.19 10-535-547020 Maintenance Agreements 17,251.00 12,309.77 89.35 4,851.88 28.13 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 658,211.36 532,873.46 196.20 125,141.70 19.01 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works-Central Maintenan 1,240,610.56 923,799.00 196.20 316,615.36 25.52 540 Public Works-Admin 10-540-501020 Salaries 229,814.59 159,079.33 0.00 70,735.26 30.78 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 17,580.82 12,148.41 0.00 5,432.41 30.90 10-540-502020 Group Health Insurance 21,189.53 13,655.68 0.00 7,533.85 35.55 10-540-502030 Retirement 31,714.41 21,952.98 0.00 9,761.43 30.78 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 272.95 195.15 0.00 77.80 28.50 10-540-502060 Long Term Disability 547.62 385.47 0.00 162.15 29.61 10-540-502070 Employee Assistance Prgm 65.52 46.02 0.00 19.50 29.76 E05 Personnel Services 301,404.67 207,682.27 0.00 93,722.40 31.10 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.53 0.00 199.47 99.74 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.11 0.00 99.89 99.89 10-540-513010 Office Supplies 1,000.00 489.98 0.00 510.02 51.00 10-540-514010 Gas 100,000.00 83,488.02 0.00 16,511.98 16.51 10-540-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-540-514040 Food 200.00 -141.87 0.00 341.87 170.94 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 102,000.00 83,836.77 0.00 18,163.23 17.81 10-540-520030 Dues And Publications 800.00 738.63 0.00 61.37 7.67 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-540-520070 Training And Education 3,000.00 0.00 0.00 3,000.00 100.00 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,000.00 738.63 0.00 3,261.37 81.53 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 305.00 206.89 88.93 9.18 3.01 E25 Repairs & Maintenance 305.00 206.89 88.93 9.18 3.01 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 407,709.67 292,464.56 88.93 115,156.18 28.24 541 Public Works-Engineering 10-541-501020 Salaries 844,425.89 595,941.00 0.00 248,484.89 29.43 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 1,308.05 0.00 -908.05 -227.01 10-541-501095 Overtime Straight Pay 0.00 23.62 0.00 -23.62 0.00 10-541-502010 Social Security 64,629.18 43,379.15 0.00 21,250.03 32.88 10-541-502020 Group Health Insurance 143,366.51 86,107.70 0.00 57,258.81 39.94 10-541-502030 Retirement 116,585.97 78,160.78 0.00 38,425.19 32.96 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 976.75 689.12 0.00 287.63 29.45 10-541-502060 Long Term Disability 2,422.05 1,665.12 0.00 756.93 31.25 10-541-502070 Employee Assistance Prgm 262.08 184.14 0.00 77.94 29.74 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,179,124.15 813,514.40 0.00 365,609.75 31.01 10-541-511010 Advertising 400.00 714.25 0.00 -314.25 -78.56 10-541-511020 Postage 400.00 63.34 0.00 336.66 84.17 10-541-512010 Printing 0.00 46.50 0.00 -46.50 0.00 10-541-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,650.00 1,040.83 0.00 609.17 36.92 10-541-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 520.10 0.00 -370.10 -246.73 10-541-515040 First Aid Supplies 50.00 110.51 0.00 -60.51 -121.02 10-541-515070 Const & Inspect Supplies 1,000.00 1,380.72 0.00 -380.72 -38.07 10-541-515080 Surveying Supplies 1,500.00 908.41 0.00 591.59 39.44 10-541-517010 Operational Supplies 4,350.00 3,518.93 0.00 831.07 19.11 E10 Materials & Supplies 9,700.00 8,303.59 0.00 1,396.41 14.40 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-520030 Dues And Publications 4,000.00 5,643.75 0.00 -1,643.75 -41.09 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 4,000.00 1,528.68 0.00 2,471.32 61.78 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 500.00 30.00 0.00 470.00 94.00 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,000.00 7,202.43 0.00 1,797.57 19.97 10-541-534010 Telephone 500.00 177.54 0.00 322.46 64.49 E20 Utilities 500.00 177.54 0.00 322.46 64.49 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,500.00 1,470.00 0.00 30.00 2.00 10-541-547010 Equipment Maintenance 1,000.00 1,170.00 0.00 -170.00 -17.00 10-541-547020 Maintenance Agreements 10,665.00 8,487.54 289.31 1,888.15 17.70 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 14,165.00 12,087.54 289.31 1,788.15 12.62 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,212,489.15 841,285.50 289.31 370,914.34 30.59 542 Public Works-Street 10-542-501020 Salaries 1,223,006.34 799,888.68 0.00 423,117.66 34.60 10-542-501024 Salaries-Stormwater 0.00 13,195.22 0.00 -13,195.22 0.00 10-542-501060 Seasonal Salaries 20,000.00 9,388.80 0.00 10,611.20 53.06 10-542-501070 Stand-by Plan 9,248.00 6,183.50 0.00 3,064.50 33.14 10-542-501090 Overtime 30,000.00 25,094.72 0.00 4,905.28 16.35 10-542-501095 Overtime Straight Pay 500.00 1,384.10 0.00 -884.10 -176.82 10-542-502010 Social Security 98,371.27 62,826.91 0.00 35,544.36 36.13 10-542-502020 Group Health Insurance 280,799.01 166,693.37 0.00 114,105.64 40.64 10-542-502030 Retirement 174,945.32 112,559.15 0.00 62,386.17 35.66 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,462.73 984.08 0.00 478.65 32.72 10-542-502060 Long Term Disability 3,575.74 2,401.00 0.00 1,174.74 32.85 10-542-502070 Employee Assistance Prgm 622.44 437.31 0.00 185.13 29.74 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,881,841.69 1,240,147.68 0.00 641,694.01 34.10 10-542-511010 Advertising 1,000.00 318.75 0.00 681.25 68.13 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-511020 Postage 150.00 21.20 0.00 128.80 85.87 10-542-512010 Printing 90.00 0.00 0.00 90.00 100.00 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 311.99 0.00 1,288.01 80.50 10-542-514017 COVID-19 0.00 199.64 0.00 -199.64 0.00 10-542-514020 Chemicals 300,000.00 289,641.60 0.00 10,358.40 3.45 10-542-514030 Small Tools 9,000.00 4,172.06 0.00 4,827.94 53.64 10-542-514040 Food 2,000.00 1,809.53 0.00 190.47 9.52 10-542-515010 Stormwater Material 73,647.86 0.00 0.00 73,647.86 100.00 10-542-515020 Street Materials 225,000.00 181,117.11 0.00 43,882.89 19.50 10-542-515040 First Aid Supplies 500.00 258.81 0.00 241.19 48.24 10-542-515060 Weed Control 1,500.00 814.97 0.00 685.03 45.67 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 5,661.42 0.00 -661.42 -13.23 E10 Materials & Supplies 619,697.86 484,327.08 0.00 135,370.78 21.84 10-542-520030 Dues And Publications 1,320.00 692.00 0.00 628.00 47.58 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,680.00 7,571.24 0.00 108.76 1.42 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,000.00 14,153.75 0.00 -153.75 -1.10 10-542-523010 Equipment Rentlease 200.00 218.02 0.00 -18.02 -9.01 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 23,200.00 22,635.01 0.00 564.99 2.44 10-542-531010 Electricity 24,364.00 14,669.18 0.00 9,694.82 39.79 10-542-531020 Street Lights 593,000.00 357,578.67 0.00 235,421.33 39.70 10-542-533010 Natural Gas 10,000.00 13,109.81 0.00 -3,109.81 -31.10 10-542-534010 Telephone 580.00 867.74 0.00 -287.74 -49.61 10-542-535010 Water 12,390.00 2,637.33 0.00 9,752.67 78.71 E20 Utilities 640,334.00 388,862.73 0.00 251,471.27 39.27 10-542-540010 Building & Grounds Maint.12,000.00 10,567.70 240.00 1,192.30 9.94 10-542-541030 Vehicle Wash 7,000.00 6,657.94 0.00 342.06 4.89 10-542-542010 Repairs - StopStreet Lights 35,000.00 25,735.24 0.00 9,264.76 26.47 10-542-542030 Signs & Marking Paint 50,000.00 48,609.42 498.20 892.38 1.78 10-542-546010 Clothing Expense 15,000.00 10,672.93 0.00 4,327.07 28.85 10-542-547010 Equipment Maintenance 3,200.00 4,321.75 0.00 -1,121.75 -35.05 10-542-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 123,560.00 106,924.98 738.20 15,896.82 12.87 10-542-572010 Purchase Of Vehicles 152,000.00 152,000.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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 35 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E70 Capital Purchases 152,000.00 152,000.00 0.00 0.00 0.00 542 Public Works-Street 3,440,633.55 2,394,897.48 738.20 1,044,997.87 30.37 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 5,863.77 0.00 9,136.23 60.91 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 113,316.60 113,316.60 0.00 0.00 0.00 10-700-590075 Transit Subsidy 187,072.59 187,072.59 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 315,389.19 306,252.96 0.00 9,136.23 2.90 700 Transfers & Subsidies 315,389.19 306,252.96 0.00 9,136.23 2.90 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 0.00 0.00 0.00 0.00 0.00 10-990-575015 Police HVAC 0.00 0.00 0.00 0.00 0.00 10-990-575022 Future Fire Stations 6,000.00 0.00 0.00 6,000.00 100.00 10-990-575023 Fire Station 4 Rehab 3,579.28 1,758.99 0.00 1,820.29 50.86 10-990-576007 Stormwater Improvements 0.00 0.00 0.00 0.00 0.00 10-990-576020 Pipe Lining 2019 0.00 0.00 0.00 0.00 0.00 10-990-576023 Norris Drive Culvert 243,750.00 203,409.56 40,340.44 0.00 0.00 10-990-576025 Douglas Davis Stormwater 124,019.00 0.00 124,019.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 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 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 36 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 73,835.29 35,058.50 30,319.00 8,457.79 11.45 10-990-577063 Clark Avenue 0.00 0.00 0.00 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-577071 MSP EDA Grant 3,099,595.00 0.00 0.00 3,099,595.00 100.00 10-990-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 3,551,578.57 240,227.05 194,678.44 3,116,673.08 87.75 990 Capital Projects 3,551,578.57 240,227.05 194,678.44 3,116,673.08 87.75 995 ARPA 10-995-501020 Salaries 87,700.27 87,700.27 0.00 0.00 0.00 10-995-502010 Social Security 6,468.51 6,468.51 0.00 0.00 0.00 10-995-502020 Group Health Insurance 17,740.61 17,740.61 0.00 0.00 0.00 10-995-502030 Retirement 11,417.41 11,417.41 0.00 0.00 0.00 10-995-502050 Life Insurance 92.36 92.36 0.00 0.00 0.00 10-995-502060 Long Term Disability 228.70 228.70 0.00 0.00 0.00 E05 Personnel Services 123,647.86 123,647.86 0.00 0.00 0.00 10-995-515010 Stormwater Materials 126,352.14 90,052.41 2,703.96 33,595.77 26.59 E10 Materials & Supplies 126,352.14 90,052.41 2,703.96 33,595.77 26.59 10-995-576007 Stormwater Improvements 540,917.60 0.00 0.00 540,917.60 100.00 E75 Capital Projects 540,917.60 0.00 0.00 540,917.60 100.00 995 ARPA 790,917.60 213,700.27 2,703.96 574,513.37 72.64 Expense Expense 42,051,422.22 24,709,745.34 1,126,245.76 16,215,431.12 38.56 GL - Trial Balance by Acct Type and Full Acct Number (07/13/2022 - 7:29 AM)Page 37 CITY OF JEFFERSON FISCAL YEAR 2021 - 2022 ESTIMATED FUND BALANCE FYE2021 UNASSIGNED FUND BALANCE (Audited)8,000,255.00$ Reappropriations from FY2021 to FY2022 MSP - EDA Grant matching portion (1,599,595.00)$ Future Fire Stations (6,000.00)$ Fire Station 4 Rehab (3,579.28)$ Downtown Streetscape (800.00)$ Ongoing Infrastructure/Facility Needs (63,760.11)$ Demolitions (210,782.57)$ Roof Repairs at Hyde Park (82,417.27)$ Vehicle Leasing (109,042.75)$ Springbrook Software Upgrade (12,136.25)$ Friend of the Animal Shelter grant for cat kennels (4,600.00)$ Bunker/Turnout Gear (18,634.03)$ Station 4 Renovation Lockers & Extractor (16,936.49)$ Ammunition and Firearms Supplies (34,365.57)$ Purchase of Animal Control Vehicle (25,523.00)$ Historic Preservation Grants for Surveys (38,400.00)$ Remaining FY21 HUD NSP grant funds (78,805.90)$ Contractual obligation from Allied & Cole County contracts (20,500.00)$ (2,325,878.22)$ 2022 Adjustments/Supplementals (Does not include other "Reserve" accounts as they are not "Unassigned" fund balance) FY2022 Supplemental Appropriations: Budget Amendments for Vehicle Leasing (50,410.00)$ Supplemental for Compensation Study Contract (28,500.00)$ Supplemental for Capitol Avenue Demos & Acquisitions (575,000.00)$ Supplemental for Juneteenth Holiday (78,131.66)$ (732,041.66)$ FYE2022 ESTIMATED Unassigned Fund Balance 4,942,335.12$ FYE2022 ESTIMATED Fund Balance % of Adopted Budget 14.38% 17% of FY2022 Adopted Budget ($34,370,541) = $5,842,992 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 6,844.11 5/2019 interest Received (50.75) CK# 1011 (4,867.50) CK# 1012 Apr-19 5/30/19 131,434.04 55,202.30 73,603.06 6,731.55 6/2019 interest Received 200.00 6/26/19 bank deposit May-19 6/20/19 134,504.89 56,492.05 75,322.74 7,065.89 7/2019 interest Received Jun-19 7/31/19 120,530.50 50,622.81 67,497.08 7,131.88 8/2019 interest Received Jul-19 8/20/19 117,844.99 49,494.90 65,993.19 7,014.55 9/2019 interest Received (2,136.63) CK# 1012 Aug-19 9/20/19 114,393.96 48,045.46 64,060.62 7,349.16 10/2019 interest Received Sep-19 10/31/19 125,692.73 52,790.95 70,387.93 7,179.27 11/2019 interest Received (737.50) CK# 1014 Oct-19 11/20/19 136,035.67 57,134.98 76,179.98 7,549.02 12/2019 interest Received Nov-19 12/20/19 98,690.15 41,449.86 55,266.49 7,603.34 1/2020 interest Received Dec-19 1/31/20 85,935.20 36,092.79 48,123.71 7,157.65 2/2020 interest Received (10,000.00) CK# 1015 (10,000.00) CK# 1016 (2,810.43) CK# 1017 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Jan-20 2/20/20 100,143.20 42,060.15 56,080.19 7,723.92 3/2020 interest Received Feb-20 3/31/20 111,144.21 46,680.58 62,240.76 7,575.08 4/2020 interest Received Mar-20 4/30/20 80,913.29 33,983.58 45,311.44 6,861.56 5/2020 interest Received (2,205.79) CK# 1018 Apr-20 5/30/20 60,499.04 25,409.60 33,879.46 2,527.02 6/2020 interest Received (6,500.00) CK# 1019 May-20 6/20/20 61,880.21 25,989.69 34,652.92 2,625.49 7/2020 interest Received Jun-20 7/31/20 94,499.61 39,689.84 52,919.78 2,644.87 8/2020 interest Received (5,967.50) CK# 1020 Jul-20 8/20/20 96,451.62 40,509.68 54,012.91 2,581.92 9/2020 interest Received Aug-20 9/20/20 67,013.43 28,145.64 37,527.52 2,687.74 10/2020 interest Received Sep-20 10/31/20 83,113.75 34,907.77 46,543.70 1,437.91 11/2020 interest Received Oct-20 11/20/20 78,606.00 33,014.52 44,019.36 272.79 12/2020 interest Received (1,937.50) CK# 1021 Nov-20 12/20/20 60,099.25 25,241.68 33,655.58 264.28 1/2021 interest Received Dec-20 1/31/21 65,475.65 27,499.77 36,666.37 188.91 2/2021 interest Received Jan-21 2/20/21 82,813.97 34,781.87 46,375.82 (1,705.00) CK# 1022 111.35 3/2021 interest Received Feb-21 3/31/21 77,646.44 32,611.50 43,482.01 108.55 4/2021 interest Received Mar-21 4/30/21 110,467.63 46,396.41 61,861.87 113.04 5/2021 interest Received Apr-21 5/30/21 114,792.54 48,212.87 64,283.82 110.52 6/2021 interest Received (1,472.50) CK# 1023 May-21 6/20/21 131,092.96 55,059.04 73,412.06 115.52 7/2021 interest Received Jun-21 7/31/21 132,627.36 55,703.49 74,271.32 116.66 8/2021 interest Received Jul-21 8/20/21 118,674.04 49,843.10 66,457.46 114.15 9/2021 interest Received Aug-21 9/20/21 103,990.65 43,676.07 58,234.76 118.82 10/2021 interest Received Sep-21 10/31/21 116,868.16 49,084.63 65,446.17 115.85 11/2021 interest Received (1,240.00) CK# 1024 Oct-21 11/20/21 142,704.05 59,935.70 79,914.27 121.00 12/2021 interest Received Nov-21 12/20/21 107,616.01 45,198.72 60,264.97 122.09 1/2022 interest Received Dec-21 1/31/21 80,860.10 33,961.24 45,281.66 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 111.01 2/2022 interest Received (1,790.00) CK# 1025 Jan-22 2/20/22 97,059.17 40,764.85 54,353.14 123.64 3/2022 interest Received Feb-22 3/20/22 99,315.44 41,712.48 55,616.65 120.85 4/2022 interest Received Mar-22 4/30/22 133,358.96 56,010.76 74,681.02 354.10 5/2022 Interest Received (3,006.25) CK# 1026 (2,031.25) CK# 1027 Apr-22 5/20/22 149,339.45 62,722.57 83,630.09 819.86 6/2022 interest Received May-22 6/20/22 149,890.31 62,953.93 83,938.57 Total 13,043,149.57 5,478,122.81 7,599,452.17 average monthly amount for 4 cent lockbox fund 54,508.68$ **Effective for 25 years starting May 1, 2011 2022 Occupancy 2021 Occupancy 2020 Occupancy 2019 Occupancy 2018 Occupancy 2017 Occupancy 2016 Occupancy January 35.70%37.70%47.30%49.40%48.10%48.70%51.30% February 42.10%37.80%55.50%58.00%53.40%56.80%58.60% March 50.40%48.20%41.60%58.00%57.60%62.20%59.80% April 56.80%55.10%34.90%63.10%61.70%62.40%67.20% May 55.30%52.90%42.10%60.90%64.60%63.80%64.90% June 54.20%55.00%60.50%63.20%70.40%64.00% July 47.70%53.40%58.80%60.30%65.90%58.20% August 43.80%46.20%59.00%56.80%61.50%56.50% September 48.20%48.20%63.40%59.90%64.50%62.60% October 51.60%45.30%63.80%65.60%66.50%62.90% November 43.50%34.60%50.30%54.80%51.50%50.60% December 32.60%30.30%44.90%46.00%40.80%42.10% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: May 2022 Percent Change from May 2021 Percent Change from YTD 2021 2022 2021 2022 2021 2022 2021 Occ ADR RevPAR Room Rev Room Avail Room Sold 2022 2021 2022 2021 2022 2021 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 65.1 59.1 149.91 118.26 97.53 69.88 10.1 26.8 39.6 42.6 2.2 12.5 59.9 51.1 142.82 106.75 85.50 54.56 17.1 33.8 56.7 62.0 3.4 21.1 61626 36833 5569116 4213606 West North Central 58.9 52.7 108.83 93.09 64.09 49.10 11.6 16.9 30.5 30.6 0.1 11.7 50.1 43.2 101.93 85.03 51.09 36.74 16.0 19.9 39.0 40.0 0.7 16.8 5032 3043 385561 291056 Missouri 59.8 54.8 117.66 99.95 70.33 54.79 9.0 17.7 28.4 28.8 0.4 9.4 51.9 45.5 109.01 89.50 56.60 40.72 14.1 21.8 39.0 40.2 0.8 15.1 1220 731 108529 81404 Kansas City, MO 63.3 54.3 115.87 95.55 73.39 51.91 16.6 21.3 41.4 42.8 1.0 17.8 55.7 44.5 109.97 87.48 61.26 38.95 25.1 25.7 57.3 61.1 2.5 28.2 327 272 35823 32227 Saint Louis, MO 61.7 55.8 122.39 100.83 75.49 56.22 10.6 21.4 34.3 37.0 2.0 12.8 54.7 46.2 111.17 88.85 60.80 41.01 18.5 25.1 48.3 50.4 1.4 20.2 375 281 41529 36240 Columbia, MO+64.8 60.5 107.91 89.63 69.92 54.19 7.2 20.4 29.0 29.0 0.0 7.2 57.0 49.3 98.05 79.00 55.87 38.96 15.5 24.1 43.4 45.1 1.2 16.9 39 31 4040 3336 Jefferson City, MO+55.3 52.7 110.55 96.60 61.14 50.95 4.9 14.4 20.0 20.0 0.0 4.9 48.0 46.3 103.24 88.68 49.61 41.06 3.8 16.4 20.8 20.8 0.0 3.8 16 14 1513 1391 Springfield, MO 70.0 71.0 101.40 90.04 71.01 63.89 -1.3 12.6 11.1 13.2 1.9 0.5 62.9 61.5 96.22 81.42 60.54 50.04 2.4 18.2 21.0 22.4 1.1 3.6 73 53 6589 5074 Branson, MO 43.0 44.6 152.44 129.48 65.62 57.76 -3.5 17.7 13.6 9.0 -4.0 -7.4 32.4 34.2 143.78 120.21 46.60 41.11 -5.2 19.6 13.3 10.0 -2.9 -8.0 166 44 13934 5641 Lake of the Ozarks+63.2 50.5 120.02 120.27 75.81 60.75 25.1 -0.2 24.8 20.4 -3.5 20.6 48.2 36.5 107.76 103.48 51.94 37.76 32.1 4.1 37.5 32.5 -3.7 27.3 39 7 2624 889 Joplin, MO 66.2 65.3 92.59 85.66 61.34 55.95 1.4 8.1 9.6 12.8 2.9 4.4 56.7 57.1 89.44 79.53 50.73 45.39 -0.6 12.5 11.8 15.0 2.9 2.3 35 25 2650 2175 Saint Joseph, MO+70.3 68.4 105.51 94.42 74.16 64.62 2.7 11.7 14.8 14.8 0.0 2.7 65.5 60.6 97.94 87.33 64.17 52.95 8.1 12.1 21.2 21.2 0.0 8.1 11 9 992 838 Independence, MO+60.9 58.8 95.87 85.56 58.34 50.30 3.5 12.0 16.0 23.7 6.7 10.4 53.3 49.1 92.49 79.37 49.31 39.00 8.5 16.5 26.4 34.9 6.7 15.8 21 15 1628 1422 A blank row indicates insufficient data. ADRRevPARADR Current Month - May 2022 vs May 2021 Occ % 2022 © CoStar Group. This STR Report is a publication of STR, LLC and STR Global, Ltd., CoStar Group companies, and is intended solely for use by paid subscribers. The information in the STR Report is provided on an “as is” and “as available” basis and should not be construed as investment, tax, accounting or legal advice. Reproduction or distribution of this STR 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 this STR Report, please contact us immediately. Source: 2022 STR, LLC / STR Global, Ltd. trading as "STR". Year to Date - May 2022 vs May 2021 Occ %RevPAR Rooms Participation Properties JCPD Form 206-3 Intra-Office Memorandum Jefferson City Police Department Memorandum TO: Chief Roger Schroeder FROM: Captain Deric J. Heislen SUBJECT: Full time building service worker DATE: 04-19-2022 Full time Building Service Worker (City Hall) With the retirement of the full-time building service worker some time ago City Hall has relied on part time cleaners, along with a third-party cleaning company for the general cleaning and custodial care of City Hall. Efforts were made to hire part time employees with no benefits that has not been successful. The third-party cleaning company that was hired to clean City Hall has not been successful either with numerous issues arising from their services. Justification: Having a full time Building Service Worker to provide cleaning and custodial care of primarily City Hall would ensure that the various miscellaneous tasks that were performed by former building service workers will be performed. Since hiring the third-party cleaning company in August of 2021 there have been over 40 issues that have arisen that could have been dealt with immediately. Currently the custodial staff assigned to the Police Department is having to supplement their duties when issues arise at City Hall. The salary for a Building Service Worker is $29,831.45-$44,747.17 annually. We are currently paying $3050 per month for the third-party cleaning company which equates to $36,600 annually. The approximate cost with benefits for hiring a full-time building service worker would be $38,780 (base salary x 30% for benefits). Remaining payments for cleaning service (June-October 2022) would increase to $3,100, if renewed for a second year.= $15,500 The FY22 annual cost with benefits for a FT Building Service Worker is $44,014.18. If the position is approved & occupied by August 8th, 2022, the estimated expense in FY22 (6 pay periods) would be = $10,157.12 The fiscal impact in FY22 would be an approximate savings of $5,342.88 Building Service Worker Bargaining Unit: General employees Class Code: 3103 CITY OF JEFFERSON Established Date: Mar 4, 2014 Revision Date: Jun 15, 2017 SALARY RANGE $14.34 - $21.51 Hourly $2,485.95 - $3,728.93 Monthly $29,831.45 - $44,747.17 Annually POSITION OVERVIEW: Provides cleaning and custodial care of City Hall, City Annex, Police Department and/or other City buildings and adjacent grounds, including cleaning, waste removal, replenishing of supplies, general building maintenance and various other responsibilities. JOB FUNCTIONS: Sweeps and mops floors; dusts offices, meeting rooms and other work areas; strips, waxes and polishes floors; polishes furniture; cleans and maintains rest rooms and replenishes supplies; collects and removes waste; and washes walls and windows. Checks heating, ventilating and air conditioning units for proper operation; performs minor maintenance on equipment and buildings; unclogs blocked sinks and toilets; maintains door locks and window glass; and reports the need for major repairs. Secures buildings; moves furniture and equipment; arranges tables and chairs for meetings; delivers supplies; and runs errands. Maintains grounds, sweeps sidewalks, shovels snow and ice, spreads salt, and removes litter around buildings. May cut grass, trim shrubs and rake leaves as needed. Coordinates maintenance priorities supplies. ABILITIES: Physical: Ability to move or lift furniture, supplies and equipment weighing 50+ pounds. Ability to push, pull, bend, stoop lift and reach. Ability to stand or walk for extended periods. Mental: Ability to remember and follow simple oral and written instructions and to follow daily routine without supervision. EDUCATION/EXPERIENCE QUALIFICATIONS: Requires a high school diploma or equivalent. OTHER: This job description is not intended to be all-inclusive. Employees may be expected to perform other duties as necessary for the effective operation of the department and the City. In addition, employees may be required to work additional or varying hours and typical or non-typical duties during emergency situations. PASSED AS AMENDED BILL NO. 2016-22 SPONSORED BY COUNCILMAN Branch ORDINANCE NO. 5 AN ORDINANCE AMENDING THE CODE OF THE CITY OF JEFFERSON, MISSOURI, PERTAINING TO GRANT APPLICATION AND ACCEPTENCE REQUIREMENTS TO ALLOW THE CITY ADMINISTRATOR TO APPROVE AND ACCEPT GRANTS WHICH DO NOT REQUIRE MORE THAN A $25,000.00 MATCH IN FUNDS BY THE CITY OF JEFFERSON; AND AMENDING THE FINANCIAL POLICY OF THE CITY OF JEFFERSON. BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS FOLLOWS: Section 1. Chapter 2 (Administration) Sec. 2-28 (Grants) of the Code of the City of Jefferson, Missouri, is amended as follows: Sec.2-28. Grants. A. Application. - .• ..•. -e: . ,!!! The City Administrator may approve all applications for grants which do not require more than a Twenty-Five Thousand Dollar($25,000) match of City Funds. Prior to application for any grant that requires the City to contribute matching funds of Twenty-Five Thousand Dollar ($25,000) or more, the Council shall approve by Resolution any the grant application filed on behalf of the City. B. Acceptance. 1.Upon award of the grant to the City, the City Administrator shall submit to the City Council for approval on the Consent Agenda a copy of the document awarding the grant and a memo which includes at least the following information: a.The name of the grantor; b.The amount of the grant; c.The purpose of the grant; d.Any matching requirements or future obligations tied to acceptance of the grant; e.CFDA#Catalog of Federal Domestic Assistance(CFDA)number: f.Grant Award#(if any): g.Revenue and Expense account to be amended. 2.Upon Approval of the Consent Agenda,the City Administrator may, on behalf of the City execute any documents necessary for accepting the grant and amend the budget to reflect the acceptance of Editor's note:Deleted language shown thus.Added language shown thus. Page 1 such revenue,and amend the budget to reflect equivalent expenses so as to accomplish the purpose of such funds. 3.If a grant,gift,or donation of twenty-five thousand dollars($25,000.00)or less is given to the City without application,the City Administrator,or his/her designee,may, on behalf of the City,accept such grant,gift,or donation, and shall amend the budget to reflect the acceptance of such revenue, and shall may amend the budget to reflect any equivalent expenses so as to accomplish the purpose of such funds. Section 2. Ordinance 15329 (Financial Policy Guidelines for City of Jefferson Missouri) is amended and replaced as follows: See exhibit A Financial Policy Guidelines For: City of Jefferson, Missouri Supersedes: Ordinance 15329 Review Responsibility: Finance Department Review Scheduled: Annually or as needed Approval Needed: City Council Adopted October 2^ 2091 2016 by Ordinance Editor's note:Deleted language shown thus.Added language shown thus. Page 2 PASSED AS AMENDED Financial Policy Guidelines City of Jefferson, Missouri October 20 '7011 2016 TABLE OF CONTENTS Introduction 3 Revenue Policies 3 Expenditure Policies 7 Financial Planning Policies 10 Purchasing Policies 13 Independent Audit Requirements 14 Glossary 14 Editor's note:Deleted language shown thus.Added language shown thus. Page 3 INTRODUCTION The City of Jefferson (City) has a variety of financial policies that can be found in many different sources, including, City Council ordinances, city code, personnel manual, budget documents, and comprehensive financial statements. The following financial policies have been developed based on the Government Finance Officers Association (GFOA) recommendations. GFOA recommends financial policies in the following areas be developed by professional staff and formally adopted: Revenue, Expenditure, and Financial Planning. These adopted policies will be used to frame policy initiatives and will be summarized in the budget document. These policies will be reviewed during the budget process. Professional staff will review to ensure continued relevance and to identify any gaps that should be addressed with new policies. The result of the review will be shared during the review of the proposed budget. The Charter of the City of Jefferson, Missouri, Article VII Financial Procedures, Section 7.1.7- Establishing Financial Procedures states, "The fiscal affairs of the city shall be the responsibility of the finance department. The head of the finance department shall be designated the fiscal officer of the city. Qualifications, duties and powers of the fiscal officer shall be set by ordinance." The adopted financial policies require compliance from all City Departments and Commissions within the City. Revenue Policies Understanding the revenue sources is essential to planning. The revenue policies seek to provide stability in order to avoid potential service disruptions caused by revenue shortfalls. The revenue policies are broken down into the following: a. Use of One-time Revenues—The City will discourage the use of one-time revenues for ongoing expenditures. b. Revenue Diversification—The City will encourage a diversity of revenue sources in order to improve the ability to handle fluctuations in individual sources. c. Uses of Unpredictable Revenue—The City will identify each major unpredictable revenue source and the aspects of the revenue source that make the revenue unpredictable. Editor's note:Deleted language shown thus.Added language shown thus. Page 4 PASSED AS AMENDED d. Fees and Charges—Fees and charges are reviewed annually in schedule Y of the City Code. 1. Use of One-Time Revenues Purpose: The one-time revenue policy provides guidance to minimize disruptive effects on services due to non-recurrence of these sources. Defined: One-Time revenues are revenues that cannot be relied on in future budget periods. One-time revenues may be available for more than one year(e.g., a three year grant), but are expected to be non-recurring. One-time revenues may be used for start-up costs, stabilization e.g., to cover expenditures that temporarily exceed revenues), early debt retirement, and capital purchases. Uses that add to the on-going expenditure base will be carefully reviewed and minimized, e.g., capital expenditures that significantly increase ongoing operating expenses without sustainable and offsetting long-term revenue plan. Examples of one-time revenues include: Infrequent sales of government assets Bond refunding savings Infrequent revenues from development Grants when the approval/authorization of the grant is reevaluated on a periodic basis, the money received is based on funding availability and/or performance. Attachment A is the internal policy and procedures that guide the City when applying for and accepting grants as well as the financial responsibilities after grant acceptance. Summary: Compliance will be reviewed periodically. 2.Revenue Diversification Purpose: The revenue diversification policy encourages a diversity of revenue sources in order to improve the ability to handle fluctuations in individual sources and to maintain needed services during periods of declining economic activity. An analysis of revenue sources will be conducted on a regular basis. The results of the analysis will be provided to the City Council for review with the City Council providing direction or action(s) required of the staff. Examples of what the analysis could include are: Editor's note:Deleted language shown thus.Added language shown thus. Page 5 Address the sensitivity of revenues to changes in rates Fairness of the tax or fee Administrative aspects of the revenue source Summary: Approach to implementing this policy will be reviewed periodically. Diversity of revenue sources can affect the relative tax burden on different stakeholders. 3.Use of Unpredictable Revenues Purpose: Unpredictable revenues cannot be relied on as to the level of revenue they will generate. Particularly with major revenue sources, it is important to consider how significant variation in revenue receipts will affect the City's outlook and ability to operate programs in the current and future budget periods. The City will identify each major unpredictable revenue source and the aspects of the revenue source that make the revenue unpredictable and how these revenues will be used. The City will identify the expected or normal degree of variation of the revenue source as well as identify in advance a set of tentative actions to be taken if one or more of the revenue sources generates higher or lower than projected. The tentative actions will be publicly discussed and used in budget decision making. Unpredictable revenues are often used to fund ongoing programs. The City's financial plan will take into account the unpredictable nature of the revenues identified. A specific allocation contingency plan may become increasingly necessary as the size of the predictability of the revenue sources increases. Examples of unpredictable revenues include: Intergovernmental revenues Interest income Sales taxes Revenues subject to future judicial rulings Property Taxes subject to assessed values as established by the County Assessors of Cole and Callaway Counties Summary: The tentative actions will be reviewed annually. 4.Charges and Fees Purpose: The charge and fee policy requires identification of both the cost of the program and the portion of the cost that will be recovered through fees and charges. Editor's note:Deleted language shown thus.Added language shown thus. Page 6 PASSED AS AMENDED Defined: Certain services provide a benefit to a particular group;the City will consider charges and fees on the direct recipients of those groups that receive benefits from such services. Policy: a) Consider applicable laws and statutes before the implementation of specific fees and charges, specifically Missouri's Hancock Amendment (Article X Sections 18-24). b) Identify the factors (affordability, pricing history, inflation, service delivery alternatives, and available efficiencies)to be taken into account when pricing. c) State whether the intention is to recover the full cost. If the full cost is not recovered, provide an explanation of the rationale for the deviation. d)Outline considerations that might influence pricing decisions. Examples include: the need to regulate demand, the desire to subsidize a certain product, competition with private businesses, economic development, elasticity of demand for the service, and visibility of the service to the community. e) How the charges and fees will be levied and collected will be considered. f) Calculate the full cost of providing the service in order to provide a basis for setting the charge or fee. This would include direct and indirect costs. Examples of indirect costs include: I. Payroll processing ii. Accounting services iii. Computer usage g)Associated costs of collection need to be addressed. h)Review and update charges and fees periodically. Some factors to include in the review could be: i. Impact of inflation ii. Cost increases iii. Adequacy of cost recovery iv. Use of services v. Competitiveness of current rates i) Utilize long-term forecasting in ensuring that charges and fees anticipate future costs in providing the service. j) Provide information on charges and fees to the public. Editor's note:Deleted language shown thus.Added language shown thus. Page 7 Summary: A suggested tool for calculating service cost is Activity Based Costing. This costing method assigns costs to the activities required to deliver a service and can be more accurate than traditionally costing methods. All fees and charges will be reviewed periodically. Stakeholders will be given the opportunity to provide input into formation of the policies. Charges and fees will be identified in other government documents, including planning and management reports. Reasons for not recovering full costs will be identified and explained. Expenditure Policies Prudent expenditure planning and accountability will ensure fiscal stability. The expenditure policies will be broken down into the following: a. Debt Capacity, Issuance, and Management—The City will specify appropriate uses for debt and identifies the maximum amount of debt and debt service that should be outstanding at any given time. b. Reserve or Stabilization Accounts—The City will maintain a prudent level of financial resources to protect against the need to reduce service levels or raise taxes and fees due to temporary revenue shortfalls or unpredicted one-time expenditures. c. Operating/Capital Expenditure Accountability—The City will compare actual expenditures to budgets periodically (e.g., quarterly) and decide on actions to bring the budget into balance, if necessary. 1. Debt Capacity, Issuance, and Management Purpose: Policies guiding the amount of debt that may be issued by the City will help ensure that outstanding and planned debt levels do not exceed an amount that can be supported by the existing and projected tax and revenue base. Policy: The City may issue general obligation bonds, revenue bonds, special obligation bonds, and short-term notes and leases in accordance with applicable laws. The City may issue refunding bonds for the purpose of refunding, extending or unifying the whole or any part of its valid outstanding revenue bonds. The City will limit long-term debt to only those capital projects that cannot be financed from current revenue or other available sources and are a high priority of the City Council. Editor's note:Deleted language shown thus.Added language shown thus. Page 8 PASSED AS AMENDED The City will follow a policy of full disclosure on every financial report and bond prospectus. When the City finances capital projects by issuing bonds, it will repay the bonds within a period not to exceed the expected useful life of the projects. The City will manage its budget and financial affairs in such a way so as to ensure continued high bond ratings. Bonds shall be issued in accordance with Missouri and Federal law. Two sections of the Missouri Constitution address debt limits for the City. Article VI, Sections 26(b) and (c) of the Missouri Constitution provides, with a vote of four-sevenths of qualified electors voting at a general municipal election day, primary or general election day or two-thirds for all other elections, a city may incur an indebtedness not to exceed in aggregate, 10 percent of the value of taxable tangible property of the City, for any purposes authorized in the charter of the city or by any general law of the State of Missouri. Article VI, Sections 26(d) and (e) of the Missouri Constitution provides, with a vote of four-sevenths of qualified electors voting at a general municipal election day, primary or general election day or two-thirds for all other elections, a city may become indebted an additional 10 percent of the value of taxable tangible property of the City for lawful purposes. Industrial revenue bonds will be issued upon City Council approval and for purposes allowed in Chapter 100 of the Revised Missouri Statutes. Revenue bond issuance requires the City to set aside assets which are treated as restricted assets to serve as security for the payment of debt service costs on outstanding revenue bonds, for replacement reserves, for contingencies and for the periodic accumulation of funds to pay semi-annual bond interest and annual principal due during the next fiscal year. The City has available to it several economic development incentives. Some of those incentives allow for the City to take on debt and the debt capacity may be affected by the use of those incentives. Economic Development tools will be considered in accordance with this policy and Chapter 25 Article XII of the City Code. 2. Reserve or Stabilization Accounts Purpose: To provide guidelines to the City Council and staff for establishing, maintaining and performing an annual review of the minimum and target fund balance reserves. Editor's note:Deleted language shown thus.Added language shown thus. Page 9 Background: A minimum General Fund reserve policy is generally considered a prudent and conservative fiscal policy to deal with unforeseen situations and long-term financial planning. Some examples of unforeseen situations include, but are not limited to: Unfunded Federal/State or other mandates Economic downturn Revenue shortfall Credit rating agencies continually monitor the levels of unassigned fund balance in a government's General fund when evaluating the government's creditworthiness and assigning a credit rating to a government's debt issuance. Policy: The City calculates an unreserved, undesignated General Fund balance at a minimum of 17%of operating expenditures as originally adopted for the General Fund budget. These funds will be used to avoid cash flow interruptions, generate interest income, and reduce need for short- term borrowing. All other funds, if they are not subsidized by other funds, shall maintain a minimum 10%fund balance. (e.g., Wastewater Fund, Parking Fund) The reserves shall be used when approved by formal City Council action. Some examples of situations when approval by formal City Council action is required include, but are not limited to: Large one-time cost. Unanticipated budgetary shortfall. To mitigate service impacts during a significant economic downturn in the economy or a significant and unexpected loss of revenue. Catastrophic event or natural disaster that threatens the safety of persons and property within the City. City sustains unexpected liabilities created by Federal, State, or other mandates out of the City's control. In any fiscal year the General Fund reserve balance is required to be used or is not achieved,the City Administrator and Finance Director shall present to the City Council a strategy to meet the fund balance reserve level within 2 fiscal years. Editor's note:Deleted language shown thus.Added language shown thus. Page 10 PASSED AS AMENDED Staff shall ensure that the provisions of this policy are effectively implemented. If it is determined that there is a conflict between this policy and other more specific governing policies involving the operating budget, this shall be brought to the attention of the City Administrator and the Finance Director who will determine the appropriate course of action. The Transit and Airport funds have historically been subsidized from the General Fund. The fiscal year ending balance in both funds is made available for Transit and Airport operations for the next fiscal year. The City will not calculate an unreserved, undesignated fund balance amount for these two funds until such time as there is not a subsidy from the General Fund. Generally, the City will strive to not have one fund subsidize another fund. Summary: Compliance to the Fund Balance Reserve Policy will be examined on an annual basis. 3. Operating/Capital Expenditure Accountability Purpose: To ensure mechanisms are in place to ensure compliance with the adopted budget while allowing the City to detect and correct significant deviation if it occurs. Policy: The Finance Director is responsible for maintaining a system of control to ensure that expenditures do not exceed budgetary appropriations. A report of the General Fund current year expenditures is provided on a monthly basis to the City Finance Committee/Council, which is also available to the public. All departments of the City have access to run a monthly budget vs. actual report at any time. The Finance Department will analyze the expenditure of each department on a quarterly basis and inform each Department Director whose expenditures appear to be exceeding the adopted budget. During preparation of mid-year projections,the Finance Department will notify all Department Directors and the City Administrator whose budgets are likely to be exceeded for further direction. Summary: A department will not exceed its approved overall budget without authorization from the City Administrator. The Director of each department will be held responsible and accountable for the'expenditures of his/her department.The Finance Director through timely reports and analysis, keep Department Directors and elected officials informed of any possible budget problems. Editor's note:Deleted language shown thus.Added language shown thus. Page 11 Financial Planning Policies Financial planning policies address both the need for a long-term view and the fundamental principle of a balanced budget. The financial planning policies will be broken down into the following: a. Balanced Budget—The City's policies define a balanced operating budget, commitment to a balanced budget under normal circumstances, and require disclosure when a deviation from a balanced operating budget is planned or when it occurs. b. Long-Range Planning—The City's policies support a financial planning process that assesses the long-term financial implications of current and proposed operating and capital budgets, budget policies, cash management and investment policies, programs and assumptions. c. Asset Inventory—The City's policies require an inventory and an assessment of the condition of all major capital assets. 1. Balanced Budget Purpose: To ensure mechanisms are in place to ensure compliance with the adopted budget while allowing the City to detect and correct significant deviation if it occurs. Policy: The Finance Director is responsible for maintaining a system of financial control to ensure that expenditures do not exceed budgetary appropriations. A report of the General Fund current year expenditures is provided on a monthly basis to the City Finance Committee/Council. All departments of the City have access to run a monthly budget vs. actual report at any time.The Finance Department will analyze the expenditure of each department on a quarterly basis and inform each Department Director whose expenditures appear to be exceeding the adopted budget. During preparation of mid-year projections, the Finance Department will notify all Department Directors and City Administrator whose budgets are likely to be exceeded for further direction. Summary: The Director of each department shall be held responsible and accountable for the expenditures of his/her department.The Finance Director through timely reports and analysis, keep Department Directors and elected officials informed of any possible budget problems. A department shall not exceed its approved budget without authorization from the City Administrator. Editor's note:Deleted language shown thus.Added language shown thus. Page 12 PASSED AS AMENDED 2. Long-Range Planning Purpose: To ensure the City assesses the long-term financial implications of current and proposed operating and capital budgets, budget policies, cash management and investment policies, programs and assumptions. Policy: The City will adopt a budget that includes a multi-year analysis. The multi-year analysis will establish assumptions for revenues, expenditures and changes to fund balance over a five year horizon. The assumptions will be evaluated periodically as part of the budget process. 3. Asset Inventory Purpose: The capital assets of a government and the condition of the capital assets are critical to the quality of services provided, and are important in determining whether the needs and priorities of the stakeholders can be met. Capital assets include major government facilities, infrastructure, equipment and networks that enable the delivery of public sector services. Policy: The Finance Director will be responsible for maintaining a central inventory control system. Capital assets are defined by the City Finance Director as assets with an estimated useful life in excess of one year with a threshold of$10,000. The capitalization threshold for infrastructure assets (e.g., roads, bridges, sidewalks, and similar items) is$10,000. Capital assets for all fund types are recorded at cost or estimated historical cost where cost could not be determined from available records. Donated fixed assets are recorded at their estimated fair value at the date of donation. The cost of normal maintenance and repairs that do not add to the value of the asset or materially extend the asset life are charged to operations as they occur and are not included in the capital assets. Renewals and betterment are capitalized over the remaining useful life of the related capital assets, as applicable. Major outlays for capital assets and improvements are capitalized in proprietary funds as projects are constructed. Interest incurred during construction is reflected in the capital value Editor's note:Deleted language shown thus.Added language shown thus. Page 13 of the asset. In addition, capital outlays for intangible assets are capitalized. Intangible assets include easements with an indefinite life which are therefore, not being amortized. Property, plant and equipment are depreciated using the straight line method over the following estimated useful lives: Buildings 10-50 years Improvements other than buildings 7-10 years Wastewater plant and system 40-50 years Machinery and equipment 3-20 years Furniture and fixtures 5-10 years Motor Vehicles 2-15 years Infrastructure: Streets and stormwater drainage 35 years Sidewalks and trails 30 years Street lighting 30 years Traffic signals 20 years The Finance Department capital asset inventory reports are distributed to each department near the end of the City's fiscal year with instructions to proceed with their inventory. The inventory reports are returned to the Finance Department as directed in the instructions. When a department has indicated an asset has been transferred to another department, a transfer sheet needs to be submitted to the Finance Department. When a department has indicated an asset has been deleted, a deletion form needs to be submitted to the Finance Department. All capital assets deleted must have been declared surplus by the City Council. Editor's note:Deleted language shown thus.Added language shown thus. Page 14 PASSED AS AMENDED On a yearly basis, or as needed, all departments shall submit to the purchasing agent reports showing any property to be declared surplus. The purchasing agent shall submit a report to the City Council informing them of the content of the departmental reports. Summary: Annually conduct an inventory of all existing assets. Evaluate existing assets to determine if they still provide the more appropriate method to deliver services. Allocate sufficient funds in the multi-year capital plan and annual operations budget for condition assessment, preventive maintenance, repair and replacement of capital assets in order to continue the provision of services that contribute to public health, safety, and quality of life of the public. Purchasing Policies Before the City makes any purchase or contract, or lets any contract for improvements,there shall be given ample opportunity for competitive bidding. Employees will be responsible for adhering to the City Purchasing Policy, approved by the City Council. The current City Purchasing Policy can be found in City Code, Chapter 26A{a++. Independent Audit Requirements City Charter, Section 3.10 requires the City Council to provide for an independent audit of all City accounts at least annually. The audit will be conducted by a certified public accountant or firm of accountants who have no personal interest, direct or indirect, in the fiscal affairs of the City government or any of its officers. A copy of the report prepared by a certified public accountant or firm of such accountants shall be kept in the city clerk's office and shall be open to public inspection. GLOSSARY Adopted Budget: Refers to the budget amount as originally approved by the City Council at the beginning of the fiscal year. Agency Fund: The City's agency fund is a clearing account for tax incremental financing. The agency is custodial in nature and does not involve measurement of results of operations. Editor's note:Deleted language shown thus.Added language shown thus. Page 15 Appropriation: The legal authorizations made by the City Council (who approve department budgets)to the departments, offices and agencies of the City, allowing the departments to make expenditures and incur obligations for specific purposes within the amounts approved. Balanced Budget: Annual financial plan in which expenses do not exceed revenues. Budget (Operation): A plan of financial operation embodying an estimate of proposed expenditures for a given period and the proposed means of financing them. Used without any modifier,the term usually indicates a financial plan for a single fiscal year. Capital Assets: Assets of significant value and having a useful life of several years. Capital Assets are also called Fixed Assets. Capital Outlays: Expenditures for the acquisition of capital assets. Capital Projects: Projects that purchase or construct capital assets. Typically a capital project encompasses a purchase of land and/or the construction of a building or facility. Capital Projects Fund: Capital projects funds account for the acquisition and construction of major capital facilities other than those financed by propriety funds and trust funds. Cash Management: Tracking and forecasting cash flow, and working with investment personnel to develop an investment plan. Maintaining cash accounts and controlling their disposition. Coordinating and controlling bank accounts. Debt: An obligation resulting from the borrowing of money or from the purchase of goods and services. Debt of governmental units includes bonds,time warrants, notes, and floating debt. Debt Service: The amount of money necessary to pay interest on an outstanding debt. Department: The Department is the primary unit in City operations. Each is managed by a Department Director. Departments are generally composed of divisions which share a common purpose or which perform similar duties. Enterprise Fund: Enterprise funds account for operations that are financed and operated in a manner similar to private enterprises, where the intent of the City is that the costs of providing goods and services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the city has decided that periodic determination of net income is appropriate for accountability purposes. The City of Jefferson uses enterprise funds to account for wastewater, airport, parking, and transit operations. Editor's note:Deleted language shown thus.Added language shown thus. Page 16 PASSED AS AMENDED Expenditures: Where accounts are kept on the accrual or modified accrual basis of accounting, the cost of goods received or services rendered whether cash payments have been made or not. When accounts are kept on a cash basis, expenditures are recognized only when the cash payments for the above are made. Expense: Charges incurred (whether paid immediately or unpaid)for operations, maintenance, interest or other charges. Fiscal Policy: A government's policy relating to budgeting of expenditures and revenues. Fiscal Year: A 12-month period of time to which the annual budget applies and at the end of which a governmental unit determines its financial position and the results of its operations. The City of Jefferson has a fiscal year of November 1st through the following October 31st. Fiduciary Funds: Fiduciarylunds are used to account for resources held for the benefit of parties outside the government. The Firefighter's Retirement plan is a fiduciary fund. Full Disclosure: Providing accurate and complete information material to a bond issue, which a potential investor would be likely to consider important in deciding whether to invest. Material facts that enable the investor to evaluate the credit quality of an issue. Fund: An independent fiscal accounting entity with a self-balancing set of accounts recording cash and/or other resources together with all related liabilities, obligations, reserves, and equities which are segregated for the purpose of carrying on specific activities or attaining certain objectives. Fund Balance: An accumulated excess of revenues over expenditures. Any amount left over after expenditures are subtracted from resources is then added to the beginning fund balance each year. Fund Type: All funds for the City of Jefferson are classified into six fund types: General, Special Revenue, Capital Projects, Enterprise, Internal Service, and Fiduciary and Agency. General Fund: The largest governmental fund,the General Fund accounts for most of the financial resources of the general government. General Fund revenues include property taxes, licenses and permits, local taxes, service charges, and other types of revenue. This fund usually includes most of the basic operating services, such as fire and police protection, finance, planning and protective services, public works, and general administration. Editor's note:Deleted languageshown thus.Added language shown thus. Page 17 General Obligation Bonds: Bonds which are secured by the full faith and credit of the issuer. General Obligation bonds issued by local units of government are secured by a pledge of the issuer's ad valorem taxing power. Governmental Funds: Governmental funds are used to account for governmental activities focusing on near-term inflows and outflows of spendable resources, as well as on balances of spendable resources available at the end of the City's fiscal year. The City maintains twelve individual governmental funds. Grant: A contribution of assets (usually cash) by a governmental unit or other organization to another. Typically,their contributions are made to local governments from state and federal governments and made for specified purposes. Industrial Revenue Bonds: Bonds issued to provide financial assistance to private-sector entities for the acquisition and construction of industrial and commercial facilities deemed to be in the public interest.The bonds are secured by the property financed and are payable solely from payments received on the underlying financing agreement. Upon repayment of the bonds, ownership of the acquired facilities transfers to the private-sector entity served by the bond issuance. Internal Service Fund: Internal Service funds account for the self-insurance workers compensation funds. Long-Term Debt: Debt with a maturity or more than one year after date of issuance. Outstanding: In general as used with respect to the principal of an issue, remaining unpaid. Proprietary Funds: Proprietary Funds are business-like funds.The City maintains two different types of proprietary funds, enterprise funds and internal service funds. Revenue Bond: A bond whose principle and interest are payable exclusively from earnings of an enterprise fund. Special Revenue Fund: Special revenue funds are used to account for specific revenues that are legally restricted to expenditures for particular purposes. The City of Jefferson uses Special Revenue Funds to account for Parks & Recreation, JC Veteran's Plaza Trust Fund, Police Training Fund, Lodging Tax Fund, City Hall Trust Fund, USS JC Submarine Trust, and Woodland Cemetery. Editor's note:Deleted language shown tis.Added language shown thus. Page 18 PASSED AS AMENDED Tax or Taxes: Compulsory charges levied by a governmental unit for the purpose of raising revenue. Tax revenues are used to pay for services or improvements provided for the general public benefit. I. RESPONSIBILITIES AFTER ACCEPTANCE A. Department Accepting Grant Funds 1. Once grant funds are accepted, the Director of the accepting department MUST designate a Grant Administrator for each accepted grant who will be responsible for the grant. The Department Director shall be accountable to the City Administrator for the actions of the appointed Grant Administrator. 2. The Grant Administrator MUST provide to the Accountant in the Finance Department the complete grant agreement. 3. The Grant Administrator MUST complete reimbursement requests on a regular basis—monthly requests are preferred, however requests should be no less than quarterly. This provision shall only apply in the case that grant money is actually spent during the above identified reporting period. Where there is no specific form for reimbursement required by the Grantee, the Grant Administrator shall use the attached "Request for Reimbursement" form attached as exhibit E. a) ALL PAYMENTS of grant funds received MUST be forwarded to the Accountant in the Finance Department for deposit. 4. At the time of each reimbursement request, the Grant Administrator MUST provide to the Accountant in the Finance Department the following documents: a) The reimbursement request form b) Supporting documentation for each item being requested for reimbursement. This should include but is not limited to the following: 1) General Ledger Detail Reports for accounts that the expenses were originally coded to 2) Copies of Invoices Editor's note:Deleted language shown thus.Added language shown thus. Page 19 3) Copies of Timesheets B. Finance Department 1. Once the grant funds are accepted, the Finance Department will complete a Budget Amendment to the accounts specified on the "Memo for Grant Acceptance". As no grant revenues are being recognized in the initial budget process, this step is necessary to not only recognize the revenue but to allocate additional budgeted funds to the appropriate expense accounts. 2. When the Finance Department receives the reimbursement requests with supporting documentation from the Grant Administrator, the Accountant will compare the supporting documents to the general ledger and update the Schedule of Expenditures of Federal Awards. 3. The finance department will notify the Department Director receiving the grant upon receipt of grant funds. II. Re-appropriation. A. It shall be the responsibility of the Grant Administrator to file a request for re- appropriation for any unspent multi-year grant funds which are unspent each year no later than January 1st of each year. The Grant Administrator shall utilize the "Re-Appropriation Form" attached herewith as exhibit F. B. The Finance Department shall notify each department of the re-appropriation requirement at least 15 days prior to the due date, however a failure of the Finance Department to comply with this section shall not relieve the Grant Administrator of their obligation to file the Re-appropriation. III. Gifts. Gifts to the City shall be treated the same as Grants. Attachment A Editor's note:Deleted language shown thus.Added language shown thus. Page 20 PASSED AS AMENDED Procedures for Applying For and Accepting Grants PLUS Responsibilities after Acceptance IV. APPLICATION A. The City Administrator may approve all applications for grants which do not require more than a Twenty-Five Thousand Dollar($25,000.00) match of City funds. B. _ . . Prior to application for any grant that requires the City to contribute matching fund of Twenty-Five Thousand Dollars ($25,000.00) or more, the Council MUST approve by resolution any grant application filed on behalf of the City. 1. The Department applying for the grant must complete a Resolution to be submitted to the Council. The Department may submit either the resolution required by the Grantor, or the "Resolution Grant Application Form", herein attached as Exhibit A. Exhibit A may be amended or modified as desired but shall contain at least information found within Exhibit A. 2. The Department shall also complete a Resolution Summary for submission to the Council. The summary shall be essentially in the form attached as Exhibit B. Exhibit B may be amended or modified as desired but shall contain at least information found within Exhibit B. 3. The Department applying for the grant must take necessary steps with the City Clerk to get the Resolution for Grant Application added to the Council Agenda. g: C. For any grant which does not require an application by the City, the Department shall upon notice of the awarding to the City of such grant, submit the grant to the City Council for acceptance, pursuant to Section II. V. ACCEPTANCE A. For Awards in excess of$7000 $25,000 1. Upon award of the grant to the City, the Council MUST approve on the Consent Agenda any grant funds being accepted on behalf of the City or in the Editor's note:Deleted language shown thus.Added language shown thus. Page 21 alternative the Council may approve a contract with the Grantor by ordinance. In either case, a), b), and c) below shall be applicable. a) The Department wishing to accept the grant funds must complete the Memo for Grant Acceptance Over ,000 $25,000", herein attached as Exhibit C, which should include at least the following information: 1) The name of the grantor 2) The amount of the grant 3) The purpose of the grant 4) Any matching requirements or future obligations tied to acceptance of the grant 5) The Catalog of Federal Domestic Assistance(CFDAI number 6) The grant award number (if any) 7) The revenue and expense accounts to be amended b) The Department wishing to accept the grant funds must forward to the Chief Accountant in the Finance Department the following documents: 1) A copy of the document awarding the grant 2) The completed "Memo for Grant Acceptance Over $27000 25,000" c) The Finance Department will review the "Memo for Grant Acceptance Over$2000 $25,000" to verify the account numbers to be amended are correct. They will then forward the following documents to the City Clerk to add the item to the Consent Agenda for the next regularly scheduled Council Meeting: 1) A copy of the document awarding the grant Editor's note:Deleted language shown thus.Added language shown thus. Page 22 PASSED AS AMENDED 2) The completed "Memo for Grant Acceptance Over $42,000 25,000" B. For Awards under$2,000 $25,000 1. Upon award of the grant to the City, the City Administrator MUST approve any grant funds being accepted on behalf of the City. a) The Department wishing to accept the grant funds must complete the Memo for Grant Acceptance Under ,090 $25,000", herein attached as Exhibit D,which should include at least the following information: 1) The name of the grantor 2) The amount of the grant 3) The purpose of the grant 4) Any matching requirements or future obligations tied to acceptance of the grant 5) The Catalog of Federal Domestic Assistance{CFDAI number 6) The grant award number(if any) 7) The revenue and expense accounts to be amended b) The Department wishing to accept the grant funds must forward to the Chief Accountant in the Finance Department the following documents: 1) A copy of the document awarding the grant 2) The completed "Memo for Grant Acceptance Under $2,000 25,000" Editor's note:Deleted language shown thus.Added language shown thus. Page 23 c) The Finance Department will review the "Memo for Grant Acceptance" to verify the account numbers to be amended are correct. They will then forward the following documents to the City Administrator for approval: 1) A copy of the document awarding the grant 2) The completed "Memo for Grant Acceptance Under $27000 25,000" Exhibit A RESOLUTION RS20 - A RESOLUTION AUTHORIZING THE CITY OF JEFFERSON TO APPLY FOR THE insert name of grant] GRANT. WHEREAS, the City of Jefferson has the opportunity to apply for the [insert name of grant] grant, and WHEREAS, the purpose of the grant is [explain purpose of the grant], and WHEREAS, the grant, if awarded, would provide up to $[amount of grant] for the City for the purpose stated above, and WHEREAS, the grant would require the City to [explain match or obligation] WHEREAS, receiving said grant would benefit the City. NOW THEREFORE BE IT RESOLVED, that the City Council of Jefferson City, Missouri supports and authorizes the City Administrator, or his designee to execute and submit the necessary application to obtain funding for the [insert name of grant] Grant. Adopted this day of 201-3 . Mayor Editor's note:Deleted language shown thus.Added language shown thus. Page 24 PASSED AS AMENDED ATTEST: APPROVED AS TO FORM: City Clerk City Counselor Exhibit B RESOLUTION SUMMARY RESOLUTION NO: SPONSOR: Councilman SUBJECT: Approving an application for the (insert name of grant) grant INTRODUCED: DEPARTMENT DIRECTOR(S): signature) CITY ADMINISTRATOR: signature) STAFF RECOMMENDATION: Approve ORIGIN OF REQUEST: name of department requesting grant] DEPARTMENT RESPONSIBLE: [name of department requesting grant] PERSON RESPONSIBLE: name of department director requesting grant] Background Information: The City desires to apply for the [name of the grant] grant, which is offered by [name of grantor]. The purpose of the grant is to [state purpose of the grant]. The amount applied for is $[amount of grant if known]. The [name of responsible department] Department will be responsible for filing for the grant and administering the grant if awarded. If awarded the City would use the funds for [state purpose/project for which the city would use the funds]. Editor's note:Deleted language shown thus.Added language shown thus. Page 25 The future obligations and/or matching requirement known at this time are [state matching requirements or future obligations]. If the grant is awarded Jo the City, the staff will return to the Council for acceptance of the grant. Fiscal Information: The application does no obligate the City to accept the fund and therefore this resolution has no fiscal impact. However if awarded and subsequently accepted by the City Council, the City could receive up to [state amount of grant]. Resolution Terms: The Resolution would authorize the City to apply for the [insert name] grant. Exhibit C Memorandum To: City Council From: City Administrator Re: Grant Acceptance Over $25,000 For: Consent Agenda Pursuant to Section 2-28 of the City Code, I request authority to accept the following Grant: The name of the grantor: The amount of the grant: The purpose of the grant: Any matching requirements or future obligations tied to acceptance of the grant: Editor's note:Deleted language shown thus.Added language shown thus. Page 26 PASSED AS AMENDED CFDA#: Grant Award#(if any): City Department Responsible: Employee assigned as Grant Administrator: Revenue account#to be amended: Expense account#to be amended: Please NOTE: Upon Approval of the Consent Agenda,the City Administrator may,on behalf of the city execute any documents necessary for accepting the grant and amend the budget to reflect the acceptance of such revenue,and amend the budget to reflect equivalent expenses so as to accomplish the purpose of such funds. For Finance Department Use only: Approved on the Consent Agenda this day of 20 Exhibit D Memorandum To: City Administrator From: [Insert Department Name] Re: Grant Acceptance under $25,000 For: Your Approval Pursuant to Section 2- 28 of the City Code, I request acceptance of the following Grant: The name of the grantor: Editor's note:Deleted language shown thus.Added language shown thus. Page 27 The amount of the grant: The purpose of the grant: Any matching requirements or future obligations tied to acceptance of the grant: CFDA#: Grant Award#(if any): City Department Responsible: Employee assigned as Grant Administrator: Revenue account#to be amended: Expense account#to be amended: Approved this day of 20 City Administrator Signature Editor's note:Deleted language shown thus.Added language shown thus. Page 28 PASSED AS AMENDED Section 3. This Ordinance shall be in full force and effect from and after the date of its passage and approval. Passed: o/l Approved: -wited26-ca. 2v aigmkt: tA/t e 7"-P? (4, Presiding Officer Mayor Carrie Tergin ATTEST: APPROVED AS TO FORM: City Clerk - . , =City Couns= • Editor's note:Deleted language shown thus.Added language shown thus. Page 29