Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2021-10-21 packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, October 21, 2021 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO — Boone -Bancroft Room TENTATIVE AGENDA I. Call to Order 2. Roll Call 3. Approval of the minutes of the June 24, 2021 meeting 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. JCCVB Annual Budget Presentation — Diane Gillespie 7. Budget Amendment for Sales Tax H — Margie Mueller 8. Discuss Supplemental Appropriation for Self -Funded Health Insurance and Worker's Comp 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. CITY OF JEFFERSON Finance Committee Meeting Thursday, June 24, 2021 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, and Spicer were in attendance. Councilwoman Wiseman joined the meeting via conference call. Next the minutes of the May 20, 2021 meeting were reviewed. A motion to approve was made by Councilman Kemna and seconded by Councilman Lester. The minutes were approved unanimously. The next item on the agenda was a report by the Finance Director, Margie Mueller, covering the Financial Reports. Ms. Mueller reviewed the Revenue Model, the June sales tax receipts, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by Chief Accountant, Shiela Pearre, covering the Lodging Tax receipts to date. 4/7 of the Lodging tax collected during the timeframe where the rate has been 7%, less any expenses paid by the 4 Cent Lockbox Fund, is $6,731,026. The average monthly amount collected for the 4 Cent Lockbox Fund is $53,129. A report comparing occupancy rates for 2021, 2020, 2019, 2018, 2017, 2016, and 2015 was included along with a report listing occupancy rates from other cities. The next item on the agenda was a presentation by Ms. Mueller regarding the Worker's Compensation Escrow. Ms. Mueller explained the need for a new escrow agreement with the Division of Worker's Compensation along with the need to purchase a security to satisfy a new escrow agreeement. Ms. Mueller stated that there will need to be a supplemental appropriation in order to purchase the needed security. A motion was made to move the supplemental appropriation to full Council by Councilman Kemna and seconded by Councilman Lester. The motion passed unanimously. The next item on the agenda was a presentation by the Neighborhood Services Supervisor, Rachel Senzee. Ms. Senzee updated the Committee on several potential Community Development Block Grant opportunities that will be available in the near future. The next item on the agenda was new business. Councilman Lester inquired about how prepared the City is to handle Cyber Ransom issues. Ms. Mueller identified several things that ITS staff has done and continues to do to remain on top of this issue and any potential threat. There was no old business. The meeting adjourned at 8:12 am. As recorded by: Shiela Pearre, Chief Accountant �J To: Steve Crowell From: Shiela Pearre Date: October 7, 2021 Re: Sales Tax Revenues The City received the October 1% Sales Tax in the amount of $1,113,777 which is $106,188 more than projected for October. January through October overage is $486,435 (4.04%) in the General Fund. 1% General Sales Tax Reporting Receipt Actual Budget Period Period Receipts Projection' Variance Nov -20 Jan -21 $986,180 $1,036,079 ($49,899) Dec -20 Feb -21 $971,262 $923,552 $47,710 Jan -21 & Oct -Dec 20 Qtrly Mar -21 $1,100,217 $1,052,707 $47,510 interest adjustment Mar -21 $15,379 $0 $15,379 Feb -21 Apr -21 $878,640 $937,310 ($58,670) interest adjustment Apr -21 $17,139 $0 $17,139 Mar -21 May -21 $861,134 $818,352 $42,782 Apr -21 & Jan -Mar 21 Qtrly Jun -21 $1,297,057 $1,079,475 $217,582 May -21 Jul -21 $1,112,675 $1,125,057 ($12,382) Jun -21 Aug -21 $996,635 $901,488 $95,147 Jul -21 & Apr -June 21 Qtrly Sep -21 $1,224,960 $1,207,010 $17,950 Aug -21 Oct -21 $1,113,777 $1,007,589 $106,188 Sep -21 Nov -21 $845,949 Oct -21 & Jul -Sept 21 Qtrly Dec -21 $1,117,628 Total Overage/Shortfall $10,575,054 $12,052,196 $486,435 'Budgeted based on 3 -year average percentage 1/2% Capital Improvement Tax - Sales Tax G Reporting Receipt Actual Budget Period Period Receipts Projection Variance Nov -20 Jan -21 $483,288 $ 429,830 $53,458 Dec -20 Feb -21 $473,674 $ 383,147 $90,527 Jan -21 & Oct -Dec 20 Qtrly Mar -21 $542,308 $ 436,728 $105,580 interest adjustment Mar -21 $590 $0 $590 Feb -21 Apr -21 $430,804 $ 388,854 $41,950 Mar -21 May -21 $430,383 $ 339,503 $90,880 Apr -21 & Jan -Mar 21 Qtrly Jun -21 $626,235 $ 447,833 $178,401 May -21 Jul -21 $547,153 $ 466,743 $80,410 Jun -21 Aug -21 $487,128 $ 373,993 $113,134 Jul -21 & Apr -June 21 Qtrly Sep -21 $596,853 $ 500,743 $96,111 Aug -21 Oct -21 $538,917 $ 418,010 $120,907 Sep -21 Nov -21 $ 350,952 Oct -21 & Jul -Sept 21 Qtrly Dec -21 $ 463,662 Total Overage/Shortfall $5,157,333 $5,000,000 $971,947 2Budgeted based on 3 -year average percentage 1/2% Parks Sales Tax Reporting Receipt Actual Budget Period Period Receipts Projection Variance Nov -20 Jan -21 $483,288 $ 496,737 ($13,449) Dec -20 Feb -21 $473,676 $ 442,787 $30,889 Jan -21 & Oct -Dec 20 Qtrly Mar -21 $542,308 $ 504,709 $37,599 interest adjustment Mar -21 $590 $0 $590 Feb -21 Apr -21 $430,808 $ 449,384 ($18,576) Mar -21 May -21 $430,383 $ 392,351 $38,033 Apr -21 & Jan -Mar 21 Qtrly Jun -21 $626,235 $ 517,543 $108,692 May -21 Jul -21 $547,152 $ 539,397 $7,755 Jun -21 Aug -21 $487,128 $ 432,209 $54,919 Jul -21 & Apr -June 21 Qtrly Sep -21 $596,854 $ 578,688 $18,165 Aug -21 Oct -21 $538,913 $ 483,078 $55,835 Sep -21 Nov -21 $ 405,581 Oct -21 & Jul -Sept 21 Qtrly Dec -21 $ 535,835 Total Overage/Shortfall $5,157,334 $5,778,300 $320,450 3Budgeted based on 3 -year average percentage City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Rate: One percent (1%) Receipt Month: OCTOBER 2021 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2016 2010 2020 2021 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 1,049,305 986,180 act. 1,003,646 Dec February 727,437 812,670 806,789 927,290 885,496 942,049 971,262 act. 874,859 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 act. 1,113,607 Feb April 1,059,943 893,024 843,561 986,714 892,285 949,276 895,779 act. 912,972 Mar May 618,854 648,305 687,741 709,248 731,421 828,799 861,134 act. 721,103 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 act. 1,076,457 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 1,139,419 1,112,675 act. 1,080,512 Jun August 562,996 661,518 678,636 821,132 770,155 912,996 996,635 act. 768,887 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 act. 1,192,526 Aug October 918,839 903,829 883,215 879,331 875,539 1,020,452 1,113,777 act. 912,473 Sept November 661,849 623,645 615,667 774,337 818,656 856,748 845,949 est. 737,811 Oct & Jul -Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,008,620 1,131,896 1,117,628 est. 1,106,693 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 $ 12,219,110 $10,575,054 Estimated to Fiscal Year and (based on averages and on Budgeted amount) $1,963,577 Total Actual & Estimated $12,538,631 Less: Budget $12,052,196 Over (Under) Budget $486,435 13,000,000 12,500,000 12,000,000 11,500,000 11,000,000 10,500,000 10,000,000 9,500,000 9,000,000 8,500,000 8,000,000 7,500,000 7,000,000 6,500,000 6,000,000 5,500,000 5,000,000 4,500,000 4,000,000 3,500,000 3,000,000 2,500,000 2,000,000 1,500,000 1,000,000 500,000 YTD Actuals vs. YTD Budget Nov Dec Jan & Oct -Dec Feb Mar Apr & Jan -Mar May Jun Jul & Apr -Jun Aug .Sept Oct &.Jul -Sept Qtrly Qtrly Qtrly Qtrly REPORTING PERIOD 0 -Actual 0 -Budget Printed 10/7/2021 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate: One -Half percent (%%) Receipt Month: OCTOBER 2021 Account Number 45-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 Average Nov January 461,560 455,278 525,521 424,160 525,696 513,808 483,288 act. 488,89: Dec February 362,597 405,543 402,964 444,476 427,711 458,324 473,674 act. 427,802 Jan & Oct -Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 518,493 542,898 act. 538,351 Feb April 512,808 431,353 411,020 455,943 430,468 458,553 430,804 act. 437,461 Mar May 308,247 322,957 340,162 340,740 351,775 402,202 430,383 act. 351,561 Apr & Jan -Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 537,105 626,235 act. 525,58E May July 473,120 498,229 559,119 548,625 481,405 560,720 547,153 act. 529,62( Jun August 280,733 330,112 338,618 393,512 372,416 443,962 487,128 act. 375,722 Jul & Apr -Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 597,489 596,853 act. 574,36: Aug October 442,371 435,416 425,493 423,478 421,199 494,618 538,917 act. 440,041 Sept November 330,393 310,506 307,281 374,512 395,311 415,079 350,952 est. 360,53E Oct & Jul -Sept Qtrly December 515,478 494,218 652,070 510,228 495,454 558,134 463,662 est. 542,021 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 $ 5,958,488 $5,157,333 Estimated to Fiscal Year end (based on averages and on Budgeted amount) $814,614 Total Actual & Estimated $5,971,947 Less: Budget $5,000,000 Over (Under) Budget $971,947 YTD Actuals vs. YTD Budget 5,600,000 5,350,000 5,157,333 5,100,000 5,000,000 4,850,000 ,618,416 4 4,600,000 4,536,338 4,350,000 4,100,000 , 110 3,850,000 3,767,376 3,600,000 3,350,000 3,100,000 3 266,633 2,987,282 2,850,000 2,892,640 2,600,000 2,350,000 2,361,047 2,425,896 2,100,000 1,930,664 1,850,000 1 978-063 1,600,000 99,860 1,638,559 1,350,000 1,249,705 1,100,000 850,000 812,977 600,000 �429,.30 350,000 100,000 Nov Dec Jan & Oct -Dec Feb Mar Apr &Jan -Mar May Jun Jul & Apr -Jun Aug Sept Oct & Jul -Sept Qtrly Qtrly Qtrly Qtrly REPORTING PERIOD -11--Actual --w-Budget Printed 10/7/2021 Account Name Parks Sales Tax Account Number 21-210-400010 City of Jefferson, Mo. - Account Analysis Rate: One -Half percent (1/2%) Receipt Month: OCTOBER 2021 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 2021 Average Nov January 461,472 455,239 Dec February 362,371 405,543 Jan & Oct -Dec Qtrly March 511,582 563,039 Feb April 512,738 431,353 Mar May 308,030 322,957 Apr & Jan -Mar Otrly June 496,386 539,529 May July 473,038 498,229 Jun August 280,513 330,112 Jul & Apr -Jun Qtrly September 565,217 572,847 Aug October 442,370 435,416 Sept November 330,393 310,506 Oct & Jul -Sept Qtrly December 515,368 494,218 525,521 424,192 $525,690 513,808 483,288 act. 488,890 395,217 450,479 $427,689 458,324 473,676 act. 427,450 506,524 577,148 $527,588 518,493 542,898 act. 538,559 411,020 457,060 $430,459 458,632 430,808 act. 437,705 340,162 340,708 $350,479 402,202 430,383 act. 351,302 489,008 508,266 $554,065 537,107 626,235 act. 525,595 559,115 548,639 $481,406 560,720 547,152 act. 529,622 338,470 393,578 $372,405 443,965 487,128 act. 375,706 542,457 545,842 $616,012 597,492 596,854 act. 574,930 425,497 423,387 $421,199 494,618 538,913 act. 440,023 307,305 374,484 $395,311 415,079 405,581 est. 360,537 652,101 510,220 $495,452 558,134 535,835 est. 542,025 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 $ 5,958,575 $5,157,334 Estimated to Fiscal Year end (based on averages and on Budgeted amount) $941,417 Total Actual & Estimated $6,098,750 Less: Budget $5,778,300 Over (Under) Budget $320,450 6,100,000 5,850,000 5,600,000 5,350,000 5,100,000 4,850,000 4,600,000 4,350,000 4,100,000 3,850,000 3,600,000 3,350,000 3,100,000 2,850,000 2,600,000 2,350,000 2,100,000 1,850,000 1,600,000 1,350,000 1,100,000 850,000 600,000 350,000 100,000 YTD Actuals vs. YTD Budget Nov Dec Jan & Oct -Dec Feb Mar Apr & Jan -Mar May Jun Jul & Apr -Jun Aug Sept Oct & Jul -Sept Qtrly Qtrly Qtrly Qtrly REPORTING PERIOD ,300 -41--Actual tBudget Printed 10/7/2021 Revenue Model Report For the Period Ending September 30, 2021 Data as of October 7, 2021 FY 2021 YTD Actual Projected Over/ Description Budget As of 10/7/21 (Under) Budget Sales Tax and Use Tax $12,052,196.48 $10,575,054.30 $486,434.83 Intergovernmental Taxes $2,356,000.00 $1,987,774.06 $93,108.49 Other Taxes $100,000.00 $78,203.42 ($4,584.65) Franchise & Utility Tax $6,825,000.00 $5,087,258.25 ($654,740.98) Property Taxes $5,561,399.28 $5,799,073.68 $256,464.80 Intergovernmental $5,170.00 $4,753,793.86 $4,748,623.86 Charges for Services $2,852,676.10 $2,685,682.27 ($9,584.96) Fees, Licenses, & Permits $952,650.00 $989,353.93 $80,713.43 Fines & Forfeitures $607,900.00 $443,185.90 ($114,366.42) Contributions/Donations $374,849.43 $325,297.18 W $9,600.04 Other Operating Revenues $221,220.64 $334,329.42 $135,173.13 Interest Income $120,000.00 $138,105.11 $32,712.99 Other Non Operating Revenue $312,761.00 $93,892.13 $1,131.13 Operating Transfers In $1,625,995.00 $1,621,120.73 ($2,604.17) Totals $33,967,817.93 $34,912,124.24 $5,058,081.52 FY2021 Revenue Model Report (Detail) Remaining For the Period Ending September 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Budget As of 10/7/21 As of 10/7/21 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10-100-400010 Sales Tax $12,052,196.48 $10,542,536.97 $1,963,577.01 $12,506,113.98 $453,917.50 $453,917.50 10-100-400020 Sales Tax Interest $0.00 $32,517.33 $0.00 $32,517.33 $32,517.33 32 51733 $12,052,196.48 $10,575,054.30 $1,963,577.01 $12,538,631.31 $486,434.83 $486,434.83 Intergovernmental Taxes 10-100-401030 Motor Vehicle Sales Tax $596,000.00 $525,445.51 $154,875.97 $680,321.48 $84,321.48 $84,321.48 10-100-403010 Gasoline Tax $1,170,000.00 $855,891.64 $306,458.46 $1,162,350.10 ($7,649.90) ($7,649.90) 10-100-430080 Road & Bridge Tax $590,000.00 $606,436.91 $0.00 $606,436.91 $16,436.91 $16,436.91 $2,356,000.00 $1,987,774.06 $461,334.43 $2,449,108.49 $93,108.49 $93,108.49 Other Taxes 10-100-403020 Cig Tax $100,000.00 $78,203.42 $17,211.93 $95,415.35 ($4,584.65) ($4,584.65) $100,000.00 $78,203.42 $17,211.93 _ $95,415.35 ($4,584.65) ($4,584.65) Franchise & Utility Tax 10-100-410020 Electric Utility Lic Tax $4,000,000.00 $3,080,697.62 $699,788.87 $3,780,486.49 ($219,513.51) ($219,513.51) 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 $900,000.00 $749,293.32 $67,271.56 $816,564.88 ($83,435.12) ($83,435.12) 10-100-410052 Telephone/Cell Utility $1,600,000.00 $1,040,983.66 $240,962.98 $1,281,946.64 ($318,053.36) ($318,053.36) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $325,000.00 $216,283.65 $74,977.37 $291,261.02 ($33.738.98) ($33,738.98) $6,825,000.00 $5,087,258.25 $1,083,000.77 $6,170,259.02 ($654,740.98) ($654,740.98) Property Taxes 10-100-420010 Current Property Tax $4,875,000.00 $4,975,044.19 $3,257.22 $4,978,301.41 $103,301.41 $103,301.41 10-100-420020 Del Property Tax $47,000.00 $137,209.78 $929.45 $138,139.23 $91,139.23 $91,139.23 10-100-420040 Fin Institution Tax $30,000.00 $18,137.56 $0.00 $18,137.56 ($11,862.44) ($11,862.44) 10-100-420050 Prop Tax Int & Penalties $29,000.00 $29,711.96 $1,529.95 $31,241.91 $2,241.91 $2,241.91 10-100-420055 Surtax Receipts - CountyReimb $54,399.28 $54,399.28 $0.00 $54,399.28 $0.00 $0.00 10-100-420060 Surtax Receipts $470,000.00 $512,779.01 $16.51 $512,795.52 $42,795.52 $41,795.52 10-100-420080 Special Tax Rev $56,000.00 71 791.90 $13,057.26 $84,849.16 $28,849.16 $28,849.16 $5,561,399.28 $5,799,073.68 $18,790.40 $5,817,864.08 $256,464.80 $256,464.80 Intergovernmental 10-100-430010 Federal Grant $0.00 $4,471,750.22 $0.00 $4,471,750.22 $4,471,750.22 $4,471,750.22 10-100-430040 Local Grant $5,170.00 $16,426.36 $0.00 $16,426.36 $11,256.36 $11,256.36 10-100-430060 Drug Forfeiture $0.00 $230,629.28 $0.00 $230,629.28 $230,629.28 $230,629.28 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 $34,988.00 $0.00 $34,988.00 $34,988.00 $34,988.00 $5,170.00 $4,753,793.86 $0.00 $4,753,793.86 $4,748,623.86 $4,748,623.86 Charges for Services 10-100-440010 Admin Charge Backs $1,561,647.00 $1,561,647.00 i $0.00 $1,561,647.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 $30,000.00 $32,058.00 $3,221.64 $35,279.64 $5,279.64 $5,279.64 10-100-440910 Fuel Charge - backs $11,000.00 $7,970.81 $1,070.45 $9,041.26 ($1,958.74) ($1,958.74) 10-100-440920 Parts Charge backs $221,206.58 $192,607.42 $18,037.01 $210,644.43 ($10,562.15) ($10,562.15) 10-100-440930 Labor Charge backs $249,445.72 $200,046.48 $18,503.96 $218,550.44 ($30,895.28) ($30,895.28) 10-100-481020 Cole Cty Animal Rescue $115,034.90 $86,276.19 $28,758.73 $115,034.92 $0.02 $0.02 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 $1,000.00 $12,000.00 $13,000.00 $1,000.00 $1,000.00 10-100-481045 Rent -tower Sites $165,000.00 $183,843.92 $5,883.23 $189,727.15 $24,727.15 $24,72715 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 $399,676.18 $365,608.29 $33,383.85 $398,992.14 ($684.04) ($684.04) 10-100-481080 Sale Of Maps/GIS Data $0.00 $75.00 $0.00 $75.00 $75.00 $75.00 10-100-481085 Cole Cty GIs Joint Coop $15,000.00 $16,402.50 $1,250.00 $17,652.50 $2,652.50 $2,652.50 10-100-481100 Sale Of Grave Sites $2,085.00 $2,919.00 $0.00 $2,919.00 $834.00 $834.00 10-100-481105 TIF Administration Fee $20,580.72 $10,230.00 $10,300.00 $20,530.00 ($50.72) ($50.72) 10-100-481110 Long & Short $0.00 2.34 0.00 2.34 2.34 2.34 $2,852,676.10 $2,685,682.27 $157,408.87 $2,843,091.14 ($9,584.96) ($9,584.96) Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $70,000.00 $78,403.33 $277.24 $78,680.57 $8,680.57 $8,680.57 10-100-450020 Business Licenses $220,000.00 $210,671.49 $3,989.18 $214,660.67 ($5,339.33) ($5,339.33) 10-100-450021 Home Occupation Permit $1,800.00 $2,640.00 $286.36 $2,926.36 $1,126.36 $1,126.36 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 $7,830.00 $666.67 $8,496.67 $496.67 $496.67 10-100-450045 Building Construct. Fees $315,000.00 $345,419.26 $14,747.44 $360,166.70 $45,166.70 $45,166.70 10-100-450050 Electrical Certificates $22,000.00 $25,422.00 $774.24 $26,196.24 $4,196.24 $4,196.24 10-100-450060 Electrical Permits $4,400.00 $9,986.33 $383.50 $10,369.83 $5,969.83 $5,969.83 10-100-450070 Plumbing Licenses $12,400.00 $11,301.00 $348.89 $11,649.89 ($750.11) ($750.11) 10-100-450080 Plumbing Permits $8,000.00 $31,716.63 $1,343.46 $33,060.09 $25,060.09 $25,060.09 FY2021 Revenue Model Report (Detail) Remaining For the Period Ending September 30, 2021 YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Budget As of 10/7/21 As of 10/7/21 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $1,768.00 $673.79 $2,441.79 $441.79 $441.79 10-100-450091 Day Care Inspection Fees $6,400.00 $4,160.00 $210.28 $4,370.28 ($2,029.72) ($2,029.72) 10-100-450092 Food Inspection Fees $86,000.00 $92,084.24 ($2,574.22) $89,510.02 $3,510.02 $3,510.02 10-100-450100 Curb Cut Permits $1,000.00 $1,590.00 $134.43 $1,724.43 $724.43 $724.43 10-100-450110 Board Of Adj Fees $1,000.00 $1,600.00 $46.35 $1,646.35 $646.35 $646.35 10-100-450120 Sign Permits $6,900.00 $7,183.00 $759.06 $7,942.06 $1,042.06 $1,042.06 10-100-450130 Demolition Permits $1,800.00 $3,626.00 $152.11 $3,778.11 $1,978.11 $1,978.11 10-100-450150 Acc Rep Fees -police $9,000.00 $6,401.90 $839.15 $7,241.05 ($1,758.95) ($1,758.95) 10-100-450160 Accrpt/blastg P -fire $1,150.00 $1,595.75 $111.12 $1,706.87 $556.87 $556.87 10-100-450170 Animal Redemption Fees $98,000.00 $88,464.00 $10,664.57 $99,128.57 $1,128.57 $1,128.57 10-100-450180 Animal Vaccinations Fees $5,200.00 $4,345.00 $585.67 $4,930.67 ($269.33) ($269.33) 10-100-450185 Animal Cremation Fees $50,000.00 $36,368.00 $7,797.75 $44,165.75 ($5,834.25) ($5,834.25) 10-100-450186 Animal Boarding Fees $0.00 $1,420.00 $0.00 $1,420.00 $1,420.00 $1,420.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 $272.00 $66.67 $338.67 ($461.33) ($461.33) 10-100-450250 Rezoning Request $0.00 $200.00 $0.00 $200.00 $200.00 $200.00 10-100-450255 Planning & Zoning Review Fees $20,000.00 $14,081.00 $1,578.59 $15,659.59 ($4,340.41) ($4,340.41) 10-100-450260 Non-refundable Plans/spec $1,800.00 $805.00 $147.21 $952.21 847.79 847.79 $952,650.00 $989,353.93 $44,009.50 $1,033,363.43 $80,713.43 $80,713.43 Fines & Forfeitures 10-100-460010 Court Cost $57,000.00 $36,918.45 $4,968.42 $41,886.87 ($15,113.13) ($15,113.13) 10-100-460015 Court Restitutions $0.00 $215.00 $0.00 $215.00 $215.00 $215.00 10-100-460018 Inmate Security Fund $9,500.00 $6,139.22 $825.96 $6,965.18 ($2,534.82) ($2,534.82) 10-100-460020 Jail Cost Recovery $1,100.00 $51.10 $142.40 $193.50 ($906.50) ($906.50) 10-100-460025 Alcohol Offense Cost Rec $4,200.00 $6,171.22 $140.97 $6,312.19 $2,112.19 $2,111.19 10-100-460030 Pol Fines -traffic $500,000.00 $369,285.83 $42,928.90 $412,214.73 ($87,785.27) ($87,785.27) 10-100-460090 Parking Fines $40,000.00 $29,870.50 $1,639.26 $31,509.76 ($8,490.24) ($8,490.24) 10-100-460100 Bankcard Charges ($3,900.00) ($5,465.42) 298.23 ($5,763,65) ($1,863.65) ($1,863.65) $607,900.00 $443,185.90 $50,347.68 $493,533.58 ($114,366.42) ($114,366.42) Contributions/Donations 10-100-480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00,w $0.00 10-100-480070 Community Projects Donations $17,307.43 $17,427.43 $0.00 $17,427.43 $120.00 $120.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 $1,000.00 $1,000.00 $0.00 $1,000.00 $0.00 $0.00 10-100-480165 Animal S Donations $15,000.00 $23,233.11 $2,930.28 $26,163.39 $11,163.39 $11,163.39 10-100-481055 Street Repair -Solid Waste Cntr $341,542.00 $283,636.64 $56,222.01 $339,858.65 ($1,683.35) ($1,683.35) ilD-100-491095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 0.00 $0.00 $374,849.43 $325,297.18 $59,152.29 $384,449.47 $9,600.04 $9,600.04 Other Operating Revenues 10-100-480010 Citizen Participation $0.00 $333.28 $0.00 $333.28 $333.28 $333.28 10-100-480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-481070 Miscellaneous $71,027.45 $38,561.82 $8,842.69 $47,404.51 ($23,622.94) ($23,622.94) 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 $18,000.00 $12,707.92 $3,221.66 $15,929.58 ($2,070.42) ($2,070.42) 10-100-481077 Insurance Claims $122,193.19 $282,726.40 $0.00 $282,726.40 $160,533.21 $160,533.21 10-100-481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $221,220.64 $334,329.42 $22,064.35 $356,393.77 $135,173.13 $135,173.13 Interest Income 10-100-470010 Interest $120.000.00 $138.105.11 $14,607.88 $152.712.99 $32,712.99 $32,712.99 $120,000.00 $138,105.11 $14,607.88 $152,712.99 $32,712.99 $32,712.99 Other Non Operating Revenue 10-100-485050 Sale Of Assets $312,761.00 $93,892.13 $220,000.00 $313,892.13 $1,131.13 $1,131.13 10-100-486020 Capital Contribution -Developer $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $312,761.00 $93,892.13 $220,000.00 $313,892.13 $1,131.13 $1,131.13 Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,400.00 $21,525.73 $2,270.10 $23,795.83 ($2,604.17) ($2,604.17) 10-100-490355 Transfer fromCIT'G' $1,599,595.00 $1,599,595.00 $0.00 $1,599,595.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 .$1,625,995.00 $1,621,120.73 A$2,270.10 $1,623,390.83 ($2,604.17) ($2,604.17) $33,967,817.93 $34,912,124.24 $4,113,775.21 $39,025,899.45 $5,058,081.52 $5,058,081.52 General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 10/07/21 14:52:38 Period 01 - 11 Fiscal Year 2021 CITY F JEFFERSON JOHN _ CHRI TY MUNICIPAL IPAL BUILDIN 320 E McCarty 1 Jeff arson City, bbl D 65101-3193 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 60,300.00 0.00 5,625.00 8.53 10-110-501015 Salary -Prosecuting Attorney 34,999.92 32,083.26 0.00 2,916.66 8.33 10-110-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-110-501050 Parttime(wo Benefits) 16,598.40 5,769.54 0.00 10,828.86 65.24 10-110-502010 Social Security 8,990.53 7,106.89 0.00 1,883.64 20.95 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 105,331.28 0.00 21,254.16 16.79 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 100.00 12.74 0.00 87.26 87.26 10-110-512010 Printing 400.00 373.99 0.00 26.01 6.50 10-110-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-110-513010 Office Supplies 1,700.00 1,223.17 0.00 476.83 28.05 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,300.00 1,609.90 0.00 690.10 30.00 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 1,250.00 105.84 0.00 1,144.16 91.53 10-110-520030 Dues And Publications 4,900.00 4,707.90 0.00 192.10 3.92 10-110-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-110-520070 Training & Education 1,439.84 395.00 0.00 1,044.84 72.57 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,689.84 5,208.74 0.00 2,481.10 32.26 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 110.00 97.33 7.37 5.30 4.82 E25 Repairs & Maintenance 110.00 97.33 7.37 5.30 4.82 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) 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,685.28 112,247.25 7.37 24,430.66 17.87 120 City Clerk 10-120-501020 Salaries 50,739.72 45,400.21 0.00 5,339.51 10.52 10-120-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-120-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-120-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-120-502010 Social Security 3,881.59 3,142.50 0.00 739.09 19.04 10-120-502020 Group Health Insurance 11,559.58 9,933.39 0.00 1,626.19 14.07 10-120-502030 Retirement 6,494.68 5,811.30 0.00 683.38 10.52 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 61.20 53.40 0.00 7.80 12.75 10-120-502060 Long Term Disability 152.27 132.96 0.00 19.31 12.68 10-120-502070 Employee Assistance Prgm 21.84 20.63 0.00 1.21 5.54 E05 Personnel Services 72,960.87 64,544.38 0.00 8,416.49 11.54 10-120-511020 Postage 200.00 150.98 0.00 49.02 24.51 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 195.01 0.00 104.99 35.00 10-120-513010 Office Supplies 200.00 87.91 0.00 112.09 56.05 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 433.90 0.00 266.10 38.01 10-120-520030 Dues And Publications 75.00 80.00 0.00 -5.00 -6.67 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 380.00 0.00 20.00 5.00 10-120-522020 Professional Services 200.00 133.02 0.00 66.98 33.49 10-120-529030 Election Expense 18,579.79 31,356.39 0.00 -12,776.60 -68.77 E15 Contractual Services 19,254.79 31,949.41 0.00 -12,694.62 -65.93 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,195.00 5,926.19 7.37 4,261.44 41.80 E25 Repairs & Maintenance 10,195.00 5,926.19 7.37 4,261.44 41.80 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 103,110.66 102,853.88 7.37 249.41 0.24 140 City Administrator 10-140-501020 Salaries 205,266.52 181,165.86 0.00 24,100.66 11.74 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 (10/07/2021 - 2:52 PM) Page 2 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-140-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-140-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-140-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-140-502010 Social Security 15,702.89 11,681.59 0.00 4,021.30 25.61 10-140-502020 Group Health Insurance 22,748.28 18,939.78 0.00 3,808.50 16.74 10-140-502030 Retirement 26,274.11 23,189.18 0.00 3,084.93 11.74 10-140-502040 Workers Compensation 201.21 201.21 0.00 0.00 0.00 10-140-502050 Life Insurance 108.94 83.30 0.00 25.64 23.54 10-140-502060 Long Term Disability 270.01 223.71 0.00 46.30 17.15 10-140-502070 Employee Assistance Prgm 43.68 41.29 0.00 2.39 5.47 E05 Personnel Services 270,615.64 235,525.92 0.00 35,089.72 12.97 10-140-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-140-511020 Postage 150.00 66.76 0.00 83.24 55.49 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 24.25 0.00 125.75 83.83 10-140-513010 Office Supplies 750.00 388.13 0.00 361.87 48.25 10-140-514017 COVID-19 0.00 3,972.61 0.00 -3,972.61 0.00 10-140-517010 Operational Supplies 678.74 58.31 0.00 620.43 91.41 E10 Materials & Supplies 1,828.74 4,510.06 0.00 -2,681.32 -146.62 10-140-520030 Dues And Publications 700.00 483.70 0.00 216.30 30.90 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,000.00 1,559.00 0.00 441.00 22.05 10-140-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-140-520090 Recruitment 0.00 0.00 0.00 0.00 0.00 10-140-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-140-522020 Professional Services 400.00 81.01 0.00 318.99 79.75 E15 Contractual Services 3,100.00 2,123.71 0.00 976.29 31.49 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 290.00 277.25 7.37 5.38 1.86 E25 Repairs & Maintenance 290.00 277.25 7.37 5.38 1.86 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 275,834.38 242,436.94 7.37 33,390.07 12.11 148 CDBG-CV 10-148-501020 Salaries 82,687.00 0.00 0.00 82,687.00 100.00 10-148-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-148-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-148-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-148-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-148-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-148-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-148-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 82,687.00 0.00 0.00 82,687.00 100.00 10-148-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-148-511020 Postage 0.00 0.00 0.00 0.00 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 0.00 0.00 0.00 0.00 10-148-520070 Training and Education 0.00 0.00 0.00 0.00 0.00 10-148-528025 CARES -Childcare Services 124,030.00 0.00 0.00 124,030.00 100.00 10-148-528035 CARES -ED For -Profit Business 103,359.00 0.00 0.00 103,359.00 100.00 10-148-528045 CARES -ED Microenterprise 103,359.00 0.00 0.00 103,359.00 100.00 E15 Contractual Services 330,748.00 0.00 0.00 330,748.00 100.00 148 CDBG-CV 413,435.00 0.00 0.00 413,435.00 100.00 149 Entitlement Grant 0.00 111,304.73 46.57 10-149-528030 10-149-501020 Salaries 68,290.83 47,101.13 0.00 21,189.70 31.03 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 5,224.25 3,072.20 0.00 2,152.05 41.19 10-149-502020 Group Health Insurance 17,319.42 11,721.94 0.00 5,597.48 32.32 10-149-502030 Retirement 8,741.23 5,909.45 0.00 2,831.78 32.40 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 10-149-502050 Life Insurance 81.47 55.36 0.00 26.11 32.05 10-149-502060 Long Term Disability 202.57 137.04 0.00 65.53 32.35 10-149-502070 Employee Assistance Program 32.76 28.31 0.00 4.45 13.58 E05 Personnel Services 99,979.56 68,112.46 0.00 31,867.10 31.87 10-149-511010 Advertising 1,550.00 1,249.50 0.00 300.50 19.39 10-149-511020 Postage 240.00 68.04 0.00 171.96 71.65 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 210.00 83.26 0.00 126.74 60.35 10-149-517010 Operational Supplies 35.00 21.43 0.00 13.57 38.77 E10 Materials & Supplies 2,035.00 1,422.23 0.00 612.77 30.11 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 2,835.00 300.00 0.00 2,535.00 89.42 10-149-522020 Professional Services 40,000.00 3,555.00 31,500.00 4,945.00 12.36 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 9,908.44 4,749.00 0.00 5,159.44 52.07 10-149-528012 Housing Rehab -Energy Efficienc 13,490.00 108.00 0.00 13,382.00 99.20 10-149-528020 Housing Assistance 239,001.73 127,697.00 0.00 111,304.73 46.57 10-149-528030 Public Improvement 172,809.51 0.00 0.00 172,809.51 100.00 10-149-528040 Neighborhood Redevelopmnt 109,025.00 22,696.95 40,996.00 45,332.05 41.58 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 6,285.00 0.00 0.00 6,285.00 100.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-528080 Homeless Objectives 5,292.00 0.00 0.00 5,292.00 100.00 E15 Contractual Services 598,646.68 159,105.95 72,496.00 367,044.73 61.31 10-149-547020 Maintenance Agreements 328.00 128.78 0.00 199.22 60.74 E25 Repairs & Maintenance 328.00 128.78 0.00 199.22 60.74 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 700,989.24 228,769.42 72,496.00 399,723.82 57.02 150 City Attorney 10-150-501020 Salaries 218,180.70 196,968.46 0.00 21,212.24 9.72 10-150-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-150-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-150-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-150-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-150-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-150-502010 Social Security 16,690.82 14,422.14 0.00 2,268.68 13.59 10-150-502020 Group Health Insurance 35,000.04 26,201.58 0.00 8,798.46 25.14 10-150-502030 Retirement 27,927.13 23,509.92 0.00 4,417.21 15.82 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 271.73 231.20 0.00 40.53 14.92 10-150-502060 Long Term Disability 567.20 498.10 0.00 69.10 12.18 10-150-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 298,933.93 262,124.12 0.00 36,809.81 12.31 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 350.26 0.00 149.74 29.95 10-150-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-150-512020 Copies 50.00 0.60 0.00 49.40 98.80 10-150-513010 Office Supplies 1,500.00 1,343.08 0.00 156.92 10.46 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 2,150.00 1,693.94 0.00 456.06 21.21 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 9,331.00 6,572.37 844.44 1,914.19 20.51 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 4,831.00 3,565.64 0.00 1,265.36 26.19 10-150-520080 Tuition Reimbursement 3,738.00 4,672.50 0.00 -934.50 -25.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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-522020 Professional Services 10,000.00 7,429.25 0.00 2,570.75 25.71 10-150-525030 Litigation Expenses 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 28,400.00 22,239.76 844.44 5,315.80 18.72 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 350.00 337.25 7.37 5.38 1.54 E25 Repairs & Maintenance 350.00 337.25 7.37 5.38 1.54 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 329,833.93 286,395.07 851.81 42,587.05 12.91 160 Municipal Court 10-160-501010 Salary -elected Officals 24,791.57 21,874.95 0.00 2,916.62 11.76 10-160-501020 Salaries 116,693.73 101,856.19 0.00 14,837.54 12.71 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 4,831.44 0.00 2,168.56 30.98 10-160-501090 Overtime 1,500.00 667.05 0.00 832.95 55.53 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Security 12,254.81 9,596.67 0.00 2,658.14 21.69 10-160-502020 Group Health Insurance 25,245.37 21,210.96 0.00 4,034.41 15.98 10-160-502030 Retirement 15,128.80 12,122.64 0.00 3,006.16 19.87 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 141.98 121.65 0.00 20.33 14.32 10-160-502060 Long Term Disability 350.06 301.35 0.00 48.71 13.91 10-160-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 10-160-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 203,370.01 172,843.00 0.00 30,527.01 15.01 10-160-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-160-511020 Postage 3,550.00 2,223.36 0.00 1,326.64 37.37 10-160-512010 Printing 400.00 337.44 0.00 62.56 15.64 10-160-512020 Copies 0.00 0.95 0.00 -0.95 0.00 10-160-513010 Office Supplies 4,000.00 2,594.97 0.00 1,405.03 35.13 10-160-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 7,950.00 5,156.72 0.00 2,793.28 35.14 10-160-520025 Security 10,000.00 619.92 0.00 9,380.08 93.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 475.00 0.00 1,025.00 68.33 10-160-522020 Professional Services 16,208.35 14,278.89 0.00 1,929.46 11.90 10-160-525005 Appointed Counsel 4,000.00 798.00 0.00 3,202.00 80.05 10-160-525010 Care Of Prisoners 250.00 45.00 0.00 205.00 82.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 32,198.35 16,396.81 0.00 15,801.54 49.08 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,000.00 2,725.00 66.33 3,208.67 53.48 E25 Repairs & Maintenance 6,000.00 2,725.00 66.33 3,208.67 53.48 10-160-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-160-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 160 Municipal Court 249,518.36 197,121.53 66.33 52,330.50 20.97 170 Human Resources 10-170-501020 Salaries 216,706.40 191,677.42 0.00 25,028.98 11.55 10-170-501050 Parttime(wo Benefits) 13,000.00 14,268.14 0.00 -1,268.14 -9.75 10-170-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-170-501090 Overtime 100.00 229.47 0.00 -129.47 -129.47 10-170-501095 Overtime Straight Pay 0.00 55.63 0.00 -55.63 0.00 10-170-502010 Social Security 17,580.19 15,554.09 0.00 2,026.10 11.52 10-170-502020 Group Health Insurance 26,267.63 19,710.27 0.00 6,557.36 24.96 10-170-502030 Retirement 27,751.22 24,571.19 0.00 3,180.03 11.46 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 260.71 227.25 0.00 33.46 12.83 10-170-502060 Long Term Disability 560.59 485.58 0.00 75.01 13.38 10-170-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 10-170-503020 Unemployment Compensation 0.00 241.93 0.00 -241.93 0.00 E05 Personnel Services 302,617.95 267,408.59 0.00 35,209.36 11.63 10-170-511010 Advertising 0.00 49.00 0.00 -49.00 0.00 10-170-511020 Postage 300.00 128.22 0.00 171.78 57.26 10-170-512010 Printing 800.00 0.00 0.00 800.00 100.00 10-170-512020 Copies 500.00 341.45 0.00 158.55 31.71 10-170-513010 Office Supplies 1,000.00 425.98 0.00 574.02 57.40 10-170-514017 COVID-19 11,787.00 16,276.00 0.00 -4,489.00 -38.08 10-170-517010 Operational Supplies 800.00 68.04 0.00 731.96 91.50 E10 Materials & Supplies 15,187.00 17,288.69 0.00 -2,101.69 -13.84 10-170-520030 Dues And Publications 1,000.00 627.00 0.00 373.00 37.30 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 8,670.00 6,944.79 0.00 1,725.21 19.90 10-170-520070 Training And Education 5,220.00 323.00 0.00 4,897.00 93.81 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 900.00 252.75 0.00 647.25 71.92 10-170-522020 Professional Services 4.000.00 442.91 0.00 3.557.09 88.93 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-529010 Special Events 800.00 54.99 0.00 745.01 93.13 10-170-529015 Human Relations Commission 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 21,090.00 8,645.44 0.00 12,444.56 59.01 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 290.00 277.34 7.37 5.29 1.82 E25 Repairs & Maintenance 290.00 277.34 7.37 5.29 1.82 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 339,184.95 293,620.06 7.37 45,557.52 13.43 180 Finance Department 10-180-501020 Salaries 640,131.46 501,418.33 0.00 138,713.13 21.67 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 48,970.06 37,329.99 0.00 11,640.07 23.77 10-180-502020 Group Health Insurance 98,124.71 67,360.96 0.00 30,763.75 31.35 10-180-502030 Retirement 81,936.83 53,561.34 0.00 28,375.49 34.63 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 751.54 552.45 0.00 199.09 26.49 10-180-502060 Long Term Disability 1,849.71 1,306.18 0.00 543.53 29.38 10-180-502070 Employee Assistance Prgm 256.62 242.74 0.00 13.88 5.41 10-180-503020 Unemployment Compensation 0.00 188.70 0.00 -188.70 0.00 E05 Personnel Services 872,519.76 662,459.52 0.00 210,060.24 24.08 10-180-511010 Advertising 1,000.00 245.25 0.00 754.75 75.48 10-180-511020 Postage 10,000.00 6,251.64 0.00 3,748.36 37.48 10-180-511021 Mail Machine Cost 3,000.00 1,924.38 0.00 1,075.62 35.85 10-180-512010 Printing 3,300.00 1,057.11 0.00 2,242.89 67.97 10-180-512020 Copies 1,300.00 84.58 0.00 1,215.42 93.49 10-180-512021 Copy Machine Cost 200.00 -483.04 0.00 683.04 341.52 10-180-513010 Office Supplies 3,600.00 936.84 0.00 2,663.16 73.98 10-180-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-180-517010 Operational Supplies 3,600.00 4,501.63 0.00 -901.63 -25.05 E10 Materials & Supplies 26,000.00 14,518.39 0.00 11,481.61 44.16 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 2,115.00 0.00 185.00 8.04 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Trainim And Education 7.975.76 3.170.27 0.00 4.805.49 60.25 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 53,571.20 36,502.40 0.00 17,068.80 31.86 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 111.02 0.00 188.98 62.99 E15 Contractual Services 64,146.96 41,898.69 0.00 22,248.27 34.68 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 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 180 Finance Department 963,926.72 720,136.60 0.00 243,790.12 25.29 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 34,839.60 0.00 2,127.83 5.76 10-185-502023 Self Insurance -Retirees 0.00 0.00 0.00 0.00 0.00 10-185-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-185-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-185-504010 Employee Salary Guarantee Fund 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 36,967.43 34,839.60 0.00 2,127.83 5.76 10-185-514010 Gas 11,000.00 9,126.69 0.00 1,873.31 17.03 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 11,000.00 9,126.69 0.00 1,873.31 17.03 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 393,468.82 613,276.21 0.00 -219,807.39 -55.86 10-185-521020 Insurance Deductible 25,000.00 130,150.04 0.00 -105,150.04 -420.60 10-185-521030 Self Ins Prop & Casualty 40,000.00 28,540.90 0.00 11,459.10 28.65 10-185-521060 Drugalcohol screening 3,564.00 3,327.00 0.00 237.00 6.65 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 34,150.00 28,528.29 2,100.00 3,521.71 10.31 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-185-522035 Meeting Streaming & Recording 19,369.90 18,555.67 0.00 814.23 4.20 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 185,000.00 0.00 0.00 0.00 10-185-529010 Special Events 7,000.00 2,705.03 0.00 4,294.97 61.36 E15 Contractual Services 754,552.72 1,010,083.14 2,100.00 -257,630.42 -34.14 10-185-531010 Electricity 33,000.00 24,693.75 0.00 8,306.25 25.17 10-185-533010 Natural Gas 6,200.00 4,534.50 0.00 1,665.50 26.86 10-185-535010 Water 7,250.00 4,324.48 0.00 2,925.52 40.35 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 46,450.00 33,552.73 0.00 12,897.27 27.77 10-185-540010 Building & Grounds Maint. 40,000.00 37,704.34 0.00 2,295.66 5.74 10-185-540015 Amtrak Station 8,000.00 2,338.89 0.00 5,661.11 70.76 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 1,900.00 1,680.00 0.00 220.00 11.58 E25 Repairs & Maintenance 74,900.00 66,723.23 0.00 8,176.77 10.92 10-185-550010 Miscellaneous 4,000.00 1,098.00 0.00 2,902.00 72.55 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'1 PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 10-185-550035 Old Town Redev Committee 0.00 0.00 0.00 0.00 0.00 10-185-550036 Salute to America 10,000.00 10,000.00 0.00 0.00 0.00 10-185-550037 Historic Preservation Comm 0.00 0.00 0.00 0.00 0.00 10-185-550038 Civil War Reenactment Comm 0.00 0.00 0.00 0.00 0.00 10-185-550040 Public Art 0.00 3,500.00 0.00 -3,500.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 500.00 0.00 0.00 500.00 100.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 Neighborhd Improvement Progr 0.00 0.00 0.00 0.00 0.00 10-185-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 14,500.00 14,598.00 0.00 -98.00 -0.68 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 220,000.00 94,379.89 0.00 125,620.11 57.10 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 220,000.00 94,379.89 0.00 125,620.11 57.10 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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,158,370.15 1,263,303.28 2,100.00 -107,033.13 -9.24 190 Information Technology Svcs 10-190-501020 Salaries 571,790.67 505,405.59 0.00 66,385.08 11.61 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 82.10 0.00 1,117.90 93.16 10-190-501095 Overtime Straight Pay 0.00 451.59 0.00 -451.59 0.00 10-190-502010 Social Security 43,833.79 37,176.55 0.00 6,657.24 15.19 10-190-502020 Group Health Insurance 85,871.51 74,298.01 0.00 11,573.50 13.48 10-190-502030 Retirement 73,342.81 64,760.60 0.00 8,582.21 11.70 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 687.28 598.39 0.00 88.89 12.93 10-190-502060 Long Term Disability 1,660.17 1,444.63 0.00 215.54 12.98 10-190-502070 Employee Assistance Prgm 207.48 196.14 0.00 11.34 5.47 E05 Personnel Services 779,951.92 685,771.81 0.00 94,180.11 12.08 10-190-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-190-511020 Postage 50.00 31.82 0.00 18.18 36.36 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 4.22 0.00 15.78 78.90 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 407.43 0.00 492.57 54.73 10-190-514017 COVID-19 16,000.00 4,706.67 11,293.33 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 2,500.00 543.46 0.00 1,956.54 78.26 E10 Materials & Supplies 19,570.00 5,693.60 11,293.33 2,583.07 13.20 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 0.00 0.00 300.00 100.00 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 10,000.00 399.00 0.00 9,601.00 96.01 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 10,000.00 31.02 0.00 9,968.98 99.69 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet Tl Web 20,000.00 16,255.47 0.00 3,744.53 18.72 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 44,700.00 21,000.49 0.00 23,699.51 53.02 10-190-534010 Telephone 56,000.00 83,602.22 0.00 -27,602.22 -49.29 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Advertising Utilities 56,000.00 83,602.22 0.00 -27,602.22 -49.29 10-190-545010 1,395.00 Software Licensemaint 154,818.36 141,847.11 817.50 12,153.75 7.85 10-190-545020 4,064.55 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 0.00 Equipment Maintenance 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547020 1,027.05 Maintenance Agreements 23,000.00 22,357.14 0.00 642.86 2.80 E25 -3.18 Repairs & Maintenance 181,818.36 164,204.25 817.50 16,796.61 9.24 10-190-572020 10-300-514017 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Food Capital Purchases 0.00 0.00 0.00 0.00 0.00 190 1,378.00 Information Technology Svcs 1,082,040.28 960,272.37 12,110.83 109,657.08 10.13 300 50,084.43 Police Department 4,201.82 4.47 10-300-516020 Dare Program 15,345.00 10-300-501020 Salaries 4,458,095.92 3,846,138.23 0.00 611,957.69 13.73 10-300-501030 0.00 Holiday Pay 140,665.66 93,500.26 0.00 47,165.40 33.53 10-300-501040 0.00 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-300-501050 60.95 Parttime(wo Benefits) 57,058.36 30,610.08 0.00 26,448.28 46.35 10-300-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-300-501070 Stand-by Plan 5,000.00 3,794.81 0.00 1,205.19 24.10 10-300-501090 Overtime 290,776.18 230,714.93 0.00 60,061.25 20.66 10-300-501095 Overtime Straight Pay 13,275.00 15,283.70 0.00 -2,008.70 -15.13 10-300-502010 Social Security 384,177.46 303,497.95 0.00 80,679.51 21.00 10-300-502020 Group Health Insurance 838,663.85 689,140.80 0.00 149,523.05 17.83 10-300-502030 Retirement 881,575.31 709,777.93 0.00 171,797.38 19.49 10-300-502040 Workers Compensation 75,085.92 75,085.92 0.00 0.00 0.00 10-300-502050 Life Insurance 5,340.27 4,401.82 0.00 938.45 17.57 10-300-502060 Long Term Disability 13,356.47 10,905.90 0.00 2,450.57 18.35 10-300-502070 Employee Assistance Prgm 1,976.52 1,867.53 0.00 108.99 5.51 10-300-503010 Awards Program 4,786.00 0.00 4,786.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,169,832.92 6,014,719.86 4,786.00 1,150,327.06 16.04 10-300-511010 Advertising 5,665.00 5,158.00 0.00 507.00 8.95 10-300-511020 Postage 1,395.00 810.54 0.00 584.46 41.90 10-300-512010 Printing 4,152.00 4,064.55 0.00 87.45 2.11 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 1,860.00 832.95 0.00 1,027.05 55.22 10-300-513010 Office Supplies 15,670.50 16,168.37 0.00 -497.87 -3.18 10-300-514010 Gas 145,000.00 139,433.12 0.00 5,566.88 3.84 10-300-514017 COVID-19 0.00 339.16 0.00 -339.16 0.00 10-300-514040 Food 651.00 863.28 0.00 -212.28 -32.61 10-300-515040 First Aid Supplies 1,378.00 1,296.31 0.00 81.69 5.93 10-300-516010 Ammunition & Firearms Supplies 94,000.00 50,084.43 39,713.75 4,201.82 4.47 10-300-516020 Dare Program 15,345.00 16,721.60 0.00 -1,376.60 -8.97 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 17,307.43 6,759.33 0.00 10,548.10 60.95 10-300-517010 Operational Supplies 44,278.00 41,472.76 0.00 2,805.24 6.34 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Purchase Of Vehicles Materials & Supplies 349,026.93 284,004.40 39,713.75 25,308.78 7.25 10-300-520030 0.00 Dues And Publications 5,400.00 6,348.27 0.00 -948.27 -17.56 10-300-520050 205,050.34 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 0.00 Training And Education 75,800.00 61,863.56 0.00 13,936.44 18.39 10-300-520080 0.00 Tuition Reimbursement 11,625.00 19,774.44 0.00 -8,149.44 -70.10 10-300-520090 0.00 Recruitment 2,325.00 1,199.45 0.00 1,125.55 48.41 10-300-521040 Medical Claimsservices 6,510.00 9,041.10 0.00 -2,531.10 -38.88 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 14,415.00 20,594.69 0.00 -6,179.69 -42.87 10-300-522026 Drug Forfeiture - Justice 0.00 0.00 0.00 0.00 0.00 10-300-522027 Drug Forfeiture - Treasury 0.00 0.00 0.00 0.00 0.00 10-300-522028 Police Evidence Funds 0.00 0.00 0.00 0.00 0.00 10-300-523010 Equipment Rentlease 0.00 1,500.00 0.00 -1,500.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,267.28 0.00 778.72 38.06 E15 Contractual Services 118,121.00 121,588.79 0.00 -3,467.79 -2.94 10-300-531010 Electricity 44,640.00 31,489.37 0.00 13,150.63 29.46 10-300-533010 Natural Gas 1,116.00 428.11 0.00 687.89 61.64 10-300-534010 Telephone 24,101.00 15,055.62 0.00 9,045.38 37.53 10-300-535010 Water 3,348.00 2,682.39 0.00 665.61 19.88 E20 Utilities 73,205.00 49,655.49 0.00 23,549.51 32.17 10-300-540010 Building & Grounds Maint. 43,700.00 53,418.78 3,184.26 -12,903.04 -29.53 10-300-541030 Vehicle Wash 9,752.00 7,677.89 0.00 2,074.11 21.27 10-300-544010 K-9 Operations 19,540.00 11,447.56 1,012.00 7,080.44 36.24 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 26,142.35 0.00 -3,543.35 -15.68 10-300-545010 Software Licensemaint 64,843.00 64,841.25 0.00 1.75 0.00 10-300-546010 Clothing Expense 45,134.00 29,397.94 199.99 15,536.07 34.42 10-300-546020 Uniform Cleaning 23,715.00 24,641.79 0.00 -926.79 -3.91 10-300-547010 Equipment Maintenance 10,000.00 12,347.43 0.00 -2,347.43 -23.47 10-300-547020 Maintenance Agreements 55,344.11 35,849.89 8,537.01 10,957.21 19.80 10-300-547030 Radio Maintenance 9,300.00 8,238.71 141.90 919.39 9.89 E25 Repairs & Maintenance 303,927.11 274,003.59 13,075.16 16,848.36 5.54 10-300-572010 Purchase Of Vehicles 238,490.10 238,490.10 0.00 0.00 0.00 10-300-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-300-572020 Purchase Of Equipment 206,532.59 205,050.34 0.00 1,482.25 0.72 10-300-572070 MDT Year 2 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572075 LLEBG Annual Grant Equipment 6,249.00 6,249.00 0.00 0.00 0.00 10-300-572076 LLEBG Stimulus Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572078 BJA COVID Equipment 3,549.62 3,752.40 0.00 -202.78 -5.71 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 13 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-572085 Bullet Proof Vest Grant 21,149.25 11,177.00 0.00 9,972.25 47.15 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 Cry 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 Cry 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,166.00 0.00 0.00 4,166.00 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 Sery 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 480,136.56 464,718.84 0.00 15,417.72 3.21 300 Police Department 8,494,249.52 7,208,690.97 57,574.91 1,227,983.64 14.46 310 School Resource Officer 10-310-501020 Salaries 403,716.53 388,912.74 0.00 14,803.79 3.67 10-310-501030 Holiday Pay 15,519.25 2,889.00 0.00 12,630.25 81.38 10-310-501090 Overtime 45,106.00 64,021.38 0.00 -18,915.38 -41.94 10-310-501095 Overtime Straight Pay 1,311.00 748.18 0.00 562.82 42.93 10-310-502010 Social Security 35,622.44 32,605.67 0.00 3,016.77 8.47 10-310-502020 Group Health Insurance 89,658.24 71,257.15 0.00 18,401.09 20.52 10-310-502030 Retirement 85,214.46 77,329.67 0.00 7,884.79 9.25 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 489.60 408.60 0.00 81.00 16.54 10-310-502060 Long Term Disability 1,210.29 1,010.62 0.00 199.67 16.50 10-310-502070 Employee Assistance Prgm 174.72 165.18 0.00 9.54 5.46 E05 Personnel Services 684,575.39 645,901.05 0.00 38,674.34 5.65 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-516020 Dare Program 0.00 0.00 0.00 0.00 0.00 10-310-517010 Operational Supplies 6,994.46 6,248.40 0.00 746.06 10.67 E10 Materials & Supplies 6,994.46 6,248.40 0.00 746.06 10.67 10-310-520070 Training And Education 4,650.00 3,707.09 0.00 942.91 20.28 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 3,707.09 0.00 942.91 20.28 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 5,973.78 3,501.65 2,279.88 192.25 3.22 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 6,333.78 3,501.65 2,279.88 552.25 8.72 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 702,553.63 659,358.19 2,279.88 40,915.56 5.82 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 98,370.35 89,044.78 0.00 9,325.57 9.48 10-320-501030 Holiday Pay 3,714.24 551.65 0.00 3,162.59 85.15 10-320-501090 Overtime 48,735.36 12,843.31 0.00 35,892.05 73.65 10-320-501095 Overtime Straight Pay 0.00 364.89 0.00 -364.89 0.00 10-320-502010 Social Security 8,677.77 7,344.18 0.00 1,333.59 15.37 10-320-502020 Group Health Insurance 23,027.36 15,322.53 0.00 7,704.83 33.46 10-320-502030 Retirement 20,758.59 18,813.28 0.00 1,945.31 9.37 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 117.50 101.55 0.00 15.95 13.57 10-320-502060 Long Term Disability 289.60 251.28 0.00 38.32 13.23 10-320-502070 Employee Assistance Prgm 43.68 41.29 0.00 2.39 5.47 E05 Personnel Services 205,738.84 146,683.13 0.00 59,055.71 28.70 10-320-514010 Gas 6,000.00 4,211.83 0.00 1,788.17 29.80 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,905.36 12,076.93 0.00 1,828.43 13.15 10-320-517010 Operational Supplies 13,921.60 957.79 0.00 12,963.81 93.12 E10 Materials & Supplies 33,826.96 17,246.55 0.00 16,580.41 49.02 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 19,273.92 11,000.00 0.00 8,273.92 42.93 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 19,273.92 11,000.00 0.00 8,273.92 42.93 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 320 Dues And Publications M.U.S.T.A.N.G. 258,839.72 174,929.68 0.00 83,910.04 32.42 330 0.00 Animal Control 0.00 0.00 0.00 10-330-520070 Training And Education 10-330-501020 384.23 Salaries 355,286.75 262,822.90 0.00 92,463.85 26.03 10-330-501040 0.00 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 3,173.57 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 -669.75 Stand-by Plan 4,308.00 3,596.00 0.00 712.00 16.53 10-330-501090 10-330-529060 Overtime 1,709.00 4,423.65 0.00 -2,714.65 -158.84 10-330-501095 Adoption Voucher Program Overtime Straight Pay 0.00 42.20 0.00 -42.20 0.00 10-330-502010 0.00 Social Security 27,639.74 18,850.73 0.00 8,789.01 31.80 10-330-502020 16,965.99 Group Health Insurance 76,144.06 64,424.64 0.00 11,719.42 15.39 10-330-502030 0.00 Retirement 46,246.88 26,543.74 0.00 19,703.14 42.60 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 -3,181.87 Life Insurance 430.85 308.05 0.00 122.80 28.50 10-330-502060 Long Term Disability 1,064.88 762.81 0.00 302.07 28.37 10-330-502070 Employee Assistance Prgm 174.72 165.18 0.00 9.54 5.46 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 517,685.96 386,620.98 0.00 131,064.98 25.32 10-330-511010 Advertising 111.60 1,167.50 0.00 -1,055.90 -946.15 10-330-511020 Postage 110.00 139.31 0.00 -29.31 -26.65 10-330-512010 Printing 1,720.50 1,419.03 0.00 301.47 17.52 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,581.00 1,129.37 0.00 451.63 28.57 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 10-330-514040 Food 223.20 125.81 0.00 97.39 43.63 10-330-515040 First Aid Supplies 465.00 227.81 0.00 237.19 51.01 10-330-517010 Operational Supplies 12,015.60 9,226.56 0.00 2,789.04 23.21 E10 Materials & Supplies 16,226.90 13,435.39 0.00 2,791.51 17.20 10-330-520030 Dues And Publications 1,491.00 143.50 0.00 1,347.50 90.38 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 384.23 0.00 2,226.77 85.28 10-330-521040 Medical Claimsservices 431.52 658.27 0.00 -226.75 -52.55 10-330-522020 Professional Services 6,510.00 3,336.43 0.00 3,173.57 48.75 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 5,208.00 40,088.77 0.00 -34,880.77 -669.75 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 16,965.99 16,965.99 0.00 0.00 0.00 E15 Contractual Services 33,217.51 61,577.19 0.00 -28,359.68 -85.38 10-330-531010 Electricity 22,789.00 22,342.02 0.00 446.98 1.96 10-330-533010 Natural Gas 18,000.00 21,181.87 0.00 -3,181.87 -17.68 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-534010 Telephone 300.00 531.99 0.00 -231.99 -77.33 10-330-535010 Water 3,800.00 3,116.20 0.00 683.80 17.99 E20 Utilities 44,889.00 47,172.08 0.00 -2,283.08 -5.09 10-330-540010 Building & Grounds Maint. 12,600.00 28,377.26 90.00 -15,867.26 -125.93 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 43,480.00 36,457.92 0.00 7,022.08 16.15 10-330-544050 Animal Food 6,603.00 4,159.57 0.00 2,443.43 37.00 10-330-545010 Software Licensemaint 3,089.96 3,023.53 70.73 -4.30 -0.14 10-330-546010 Clothing Expense 2,325.00 1,220.64 0.00 1,104.36 47.50 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 837.00 14.99 0.00 822.01 98.21 10-330-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-330-547030 Radio Maintenance 232.50 0.00 0.00 232.50 100.00 10-330-547040 Crematory Maint & Repair 23,500.00 25,298.00 0.00 -1,798.00 -7.65 E25 Repairs & Maintenance 93,567.46 99,451.91 160.73 -6,045.18 -6.46 10-330-572010 Purchase of Vehicles 25,523.00 0.00 25,523.00 0.00 0.00 10-330-572020 Purchase Of Equipment 25,342.15 20,351.15 4,600.00 391.00 1.54 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 50,865.15 20,351.15 30,123.00 391.00 0.77 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 756,451.98 628,608.70 30,283.73 97,559.55 12.90 390 9-1-1 Police 10-390-501020 Salaries 889,827.83 810,047.33 0.00 79,780.50 8.97 10-390-501030 Holiday Pay 31,176.29 28,141.87 0.00 3,034.42 9.73 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 13,944.01 0.00 8,869.99 38.88 10-390-501095 Overtime Straight Pay 500.00 1,268.94 0.00 -768.94 -153.79 10-390-502010 Social Security 72,240.34 61,141.99 0.00 11,098.35 15.36 10-390-502020 Group Health Insurance 200,121.03 173,091.21 0.00 27,029.82 13.51 10-390-502030 Retirement 122,574.19 105,320.28 0.00 17,253.91 14.08 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,079.57 962.05 0.00 117.52 10.89 10-390-502060 Long Term Disability 2,665.08 2,369.52 0.00 295.56 11.09 10-390-502070 Employee Assistance Prgm 464.10 438.74 0.00 25.36 5.46 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,346,182.39 1,199,445.90 0.00 146,736.49 10.90 10-390-511010 Advertising 928.00 437.50 0.00 490.50 52.86 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 4,617.36 640.40 967.24 15.54 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E10 Materials & Supplies 7,153.00 5,054.86 640.40 1,457.74 20.38 10-390-520030 Dues And Publications 558.00 192.00 0.00 366.00 65.59 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 4,000.89 0.00 649.11 13.96 10-390-522020 Professional Services 3,000.00 2,551.94 0.00 448.06 14.94 10-390-523010 Equipment Rentlease 98,278.00 85,844.39 0.00 12,433.61 12.65 E15 Contractual Services 106,486.00 92,589.22 0.00 13,896.78 13.05 10-390-531010 Electricity 11,160.00 11,160.00 0.00 0.00 0.00 10-390-533010 Natural Gas 279.00 174.47 0.00 104.53 37.47 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 1,034.75 0.00 -197.75 -23.63 E20 Utilities 12,276.00 12,369.22 0.00 -93.22 -0.76 10-390-545010 Software Licensemaint 32,955.00 35,401.08 0.00 -2,446.08 -7.42 10-390-546010 Clothing Expense 5,580.00 2,684.96 0.00 2,895.04 51.88 10-390-546020 Uniform Cleaning 2,976.00 2,620.85 0.00 355.15 11.93 10-390-547010 Equipment Maintenance 2,790.00 534.14 0.00 2,255.86 80.86 10-390-547020 Maintenance Agreements 77,656.34 67,223.68 199.19 10,233.47 13.18 10-390-547030 Radio Maintenance 4,650.00 668.20 0.00 3,981.80 85.63 E25 Repairs & Maintenance 126,607.34 109,132.91 199.19 17,275.24 13.64 10-390-572020 Purchase Of Equipment 31,274.73 0.00 67,244.73 -35,970.00 -115.01 E70 Capital Purchases 31,274.73 0.00 67,244.73 -35,970.00 -115.01 390 9-1-1 Police 1,629,979.46 1,418,592.11 68,084.32 143,303.03 8.79 400 Fire Department 10-400-501020 Salaries 3,901,044.21 3,348,321.92 0.00 552,722.29 14.17 10-400-501030 Holiday Pay 293,571.79 273,127.69 0.00 20,444.10 6.96 10-400-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 Step-up Pay 35,000.00 28,162.33 0.00 6,837.67 19.54 10-400-501090 Overtime 41,000.00 56,278.79 0.00 -15,278.79 -37.27 10-400-501095 Overtime Straight Pay 33,000.00 77,662.69 0.00 -44,662.69 -135.34 10-400-502010 Social Security 65,414.80 53,709.11 0.00 11,705.69 17.89 10-400-502020 Group Health Insurance 786,688.12 663,648.08 0.00 123,040.04 15.64 10-400-502030 Retirement 2,062,410.10 1,743,362.92 0.00 319,047.18 15.47 10-400-502040 Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Life Insurance 4,669.56 3,966.02 0.00 703.54 15.07 10-400-502060 Long Term Disability 11,694.72 9,720.16 0.00 1,974.56 16.88 10-400-502070 Employee Assistance Prgm 1,659.84 1,569.14 0.00 90.70 5.46 10-400-503010 Awards Program 1,500.00 2,141.75 0.00 -641.75 -42.78 E05 Personnel Services 7,390,684.09 6,414,701.55 0.00 975,982.54 13.21 10-400-511010 Advertising 372.00 290.50 0.00 81.50 21.91 10-400-511020 Postage 139.50 96.88 0.00 42.62 30.55 10-400-512010 Printing 790.50 541.00 0.00 249.50 31.56 10-400-512020 Conies 46.50 0.00 0.00 46.50 100.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-512030 Purchase Of Vehicles Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 0.00 Office Supplies 1,395.00 1,160.89 0.00 234.11 16.78 10-400-514010 80,755.30 Gas 47,000.00 53,238.57 0.00 -6,238.57 -13.27 10-400-514017 0.00 COVID-19 112,500.00 66,058.66 8,481.00 37,960.34 33.74 10-400-514020 0.00 Chemicals 930.00 538.80 0.00 391.20 42.06 10-400-514030 0.00 Small Tools 5,000.00 4,769.53 0.00 230.47 4.61 10-400-514040 10-400-575004 Food 0.00 469.32 0.00 -469.32 0.00 10-400-515040 First Aid Supplies 2,046.00 676.97 0.00 1,369.03 66.91 10-400-517010 Operational Supplies 14,000.00 15,499.93 0.00 -1,499.93 -10.71 E10 Materials & Supplies 184,219.50 143,341.05 8,481.00 32,397.45 17.59 10-400-520030 Dues And Publications 3,373.65 2,549.98 0.00 823.67 24.41 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 25,863.94 0.00 6,563.57 20.24 10-400-520080 Tuition Reimbursement 8,545.00 6,780.00 0.00 1,765.00 20.66 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 34,131.60 0.00 5,868.40 14.67 10-400-522020 Professional Services 186.00 1,540.00 0.00 -1,354.00 -727.96 10-400-523010 Equipment Rentlease 186.00 47.00 0.00 139.00 74.73 10-400-524010 Trash Collections 93.00 137.76 0.00 -44.76 -48.13 10-400-529010 Special Events 7,250.00 4,602.35 2,655.00 -7.35 -0.10 10-400-529040 Child Safety Seat Pass-through 2,500.00 1,148.31 0.00 1,351.69 54.07 E15 Contractual Services 94,561.16 76,800.94 2,655.00 15,105.22 15.97 10-400-531010 Electricity 35,000.00 32,112.79 0.00 2,887.21 8.25 10-400-533010 Natural Gas 17,670.00 13,700.00 0.00 3,970.00 22.47 10-400-534010 Telephone 23,250.00 20,153.70 0.00 3,096.30 13.32 10-400-535010 Water 16,740.00 9,418.77 0.00 7,321.23 43.73 E20 Utilities 92,660.00 75,385.26 0.00 17,274.74 18.64 10-400-540010 Building & Grounds Maint. 199,166.53 171,262.64 21,610.96 6,292.93 3.16 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,703.50 50,124.72 0.00 19,578.78 28.09 10-400-546020 Uniform Cleaning 500.00 131.75 0.00 368.25 73.65 10-400-547010 Equipment Maintenance 19,927.24 16,951.79 0.00 2,975.45 14.93 10-400-547020 Maintenance Agreements 32,844.00 27,399.49 -1.10 5,445.61 16.58 10-400-547030 Radio Maintenance 20,925.00 20,505.95 0.00 419.05 2.00 E25 Repairs & Maintenance 343,066.27 286,376.34 21,609.86 35,080.07 10.23 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 107,000.00 80,755.30 15,000.00 11,244.70 10.51 10-400-572021 Purchase of Equipment -ONE TIME 24,640.00 0.00 0.00 24,640.00 100.00 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 131,640.00 80,755.30 15,000.00 35,884.70 27.26 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 400 Fire Department 8,236,831.02 7,077,360.44 47,745.86 1,111,724.72 13.50 401 Fire Museum 10-401-531010 Electricity 1,860.00 415.66 0.00 1,444.34 77.65 10-401-533010 Natural Gas 0.00 379.54 0.00 -379.54 0.00 10-401-535010 Water 0.00 164.04 0.00 -164.04 0.00 E20 Utilities 1,860.00 959.24 0.00 900.76 48.43 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 959.24 0.00 900.76 48.43 500 Public Works 10-500-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-500-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-500-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-500-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-500-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-500-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-500-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-500-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-500-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-500-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 EIO 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 Sery 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 187,342.17 193,422.40 0.00 -6,080.23 -3.25 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 14,331.68 14,533.73 0.00 -202.05 -1.41 10-520-502020 Group Health Insurance 27,393.78 24,032.06 0.00 3,361.72 12.27 10-520-502030 Retirement 23,979.80 21,891.50 0.00 2,088.30 8.71 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 225.22 223.00 0.00 2.22 0.99 10-520-502060 Long Term Disability 486.17 487.06 0.00 -0.89 -0.18 10-520-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 254,021.24 254,848.58 0.00 -827.34 -0.33 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 72.87 0.00 2.13 2.84 10-520-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-520-512020 Copies 0.00 0.07 0.00 -0.07 0.00 10-520-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-520-513010 Office Supplies 850.00 1,092.59 0.00 -242.59 -28.54 10-520-514010 Gas 11,000.00 10,646.30 0.00 353.70 3.22 10-520-514017 COVID-19 0.00 24,855.61 23,512.50 -48,368.11 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 577.43 0.00 -77.43 -15.49 E10 Materials & Supplies 12,525.00 37,244.87 23,512.50 -48,232.37 -385.09 10-520-520030 Dues And Publications 1,200.00 1,255.00 0.00 -55.00 -4.58 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 475.85 0.00 1,324.15 73.56 10-520-522020 Professional Services 4,000.00 388.00 7,771.72 -4,159.72 -103.99 E15 Contractual Services 7,000.00 2,118.85 7,771.72 -2,890.57 -41.29 10-520-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-520-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-520-547020 Maintenance Agreements 1,152.00 934.24 0.00 217.76 18.90 E25 Repairs & Maintenance 1.152.00 934.24 0.00 217.76 18.90 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 274,698.24 295,146.54 31,284.22 -51,732.52 -18.83 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 119,881.07 88,531.30 0.00 31,349.77 26.15 10-521-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-521-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-521-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-521-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-521-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-521-502010 Social Security 10,808.00 6,634.27 0.00 4,173.73 38.62 10-521-502020 Group Health Insurance 31,454.13 11,978.77 0.00 19,475.36 61.92 10-521-502030 Retirement 18,083.98 8,996.25 0.00 9,087.73 50.25 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 170.87 91.37 0.00 79.50 46.53 10-521-502060 Long Term Disability 422.38 226.81 0.00 195.57 46.30 10-521-502070 Employee Assistance Prgm 58.97 55.75 0.00 3.22 5.46 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 181,037.75 116,672.87 0.00 64,364.88 35.55 10-521-511010 Advertising 4,000.00 1,919.75 0.00 2,080.25 52.01 10-521-511020 Postage 500.00 135.63 0.00 364.37 72.87 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 10-521-513010 Office Supplies 800.00 333.41 0.00 466.59 58.32 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 560.43 0.00 939.57 62.64 E10 Materials & Supplies 7,000.00 2,949.22 0.00 4,050.78 57.87 10-521-520030 Dues And Publications 14,300.00 14,042.49 0.00 257.51 1.80 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 3,642.00 0.00 0.00 3,642.00 100.00 10-521-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-521-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 20,342.00 14,042.49 0.00 6,299.51 30.97 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,630.00 1,487.03 40.95 102.02 6.26 E25 Repairs & Maintenance 1,630.00 1,487.03 40.95 102.02 6.26 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 210,009.75 135,151.61 40.95 74,817.19 35.63 522 Plan & Protect Svcs -MPO 0.00 0.00 0.00 0.00 0.00 10-522-501020 Salaries 122,934.53 108,739.87 0.00 14,194.66 11.55 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,404.49 8,249.53 0.00 1,154.96 12.28 10-522-502020 Group Health Insurance 18,724.32 16,229.43 0.00 2,494.89 13.32 10-522-502030 Retirement 15,735.62 13,918.69 0.00 1,816.93 11.55 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 148.10 129.68 0.00 18.42 12.44 10-522-502060 Long Term Disability 365.96 321.43 0.00 44.53 12.17 10-522-502070 Employee Assistance Prgm 50.23 47.48 0.00 2.75 5.47 E05 Personnel Services 167,465.80 147,738.66 0.00 19,727.14 11.78 10-522-511010 Advertising 2,520.00 1,244.00 0.00 1,276.00 50.63 10-522-511020 Postage 200.00 107.61 0.00 92.39 46.20 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 275.49 0.00 724.51 72.45 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,000.00 21.13 0.00 978.87 97.89 E10 Materials & Supplies 5,105.00 1,648.23 0.00 3,456.77 67.71 10-522-520030 Dues And Publications 1,500.00 616.00 0.00 884.00 58.93 10-522-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-522-520070 Training And Education 6,000.00 37.50 0.00 5,962.50 99.38 10-522-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-522-522020 Professional Services 40,000.00 0.00 40,000.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 47,500.00 653.50 40,000.00 6,846.50 14.41 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 2,400.00 1,999.38 40.95 359.67 14.99 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,400.00 1,999.38 40.95 359.67 14.99 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 522 Plan & Protect Svcs -MPO 222,470.80 152,039.77 40,040.95 30,390.08 13.66 530 Plan & Protect Svc-RedevGrant 341.55 511.96 27.30 -197.71 -57.89 10-530-501020 Salaries 46,273.40 57,430.39 0.00 -11,156.99 -24.11 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 3,539.91 3,936.69 0.00 -396.78 -11.21 10-530-502020 Group Health Insurance 11,720.23 10,797.59 0.00 922.64 7.87 10-530-502030 Retirement 5,922.99 6,000.23 0.00 -77.24 -1.30 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 55.08 67.30 0.00 -12.22 -22.19 10-530-502060 Long Term Disability 137.82 165.98 0.00 -28.16 -20.43 10-530-502070 Employee Assistance Prgm 21.84 23.28 0.00 -1.44 -6.59 E05 Personnel Services 67,729.35 78,479.54 0.00 -10,750.19 -15.87 10-530-511010 Advertising 500.00 476.50 0.00 23.50 4.70 10-530-511020 Postage 150.00 47.94 0.00 102.06 68.04 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-530-513010 Office Supplies 500.00 362.27 0.00 137.73 27.55 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 500.00 1,066.21 0.00 -566.21 -113.24 E10 Materials & Supplies 1,700.00 1,952.92 0.00 -252.92 -14.88 10-530-520030 Dues And Publications 700.00 295.00 0.00 405.00 57.86 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 2,250.00 1,054.54 0.00 1,195.46 53.13 10-530-522020 Professional Services 250.00 0.00 0.00 250.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 19,800.00 6,046.00 0.00 13,754.00 69.46 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 1,000.00 980.60 0.00 19.40 1.94 10-530-524029 Recycling Education 9,000.00 0.00 0.00 9,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 400.00 0.00 0.00 400.00 100.00 E15 Contractual Services 112,205.90 8,376.14 0.00 103,829.76 92.54 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 341.55 511.96 27.30 -197.71 -57.89 E25 Repairs & Maintenance 341.55 511.96 27.30 -197.71 -57.89 10-530-550020 NRA -Residential 60,000.00 49,730.54 0.00 10,269.46 17.12 10-530-550030 NRA -Commercial Facade 10,000.00 7,451.25 0.00 2,548.75 25.49 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-550031 Historic Preservation Grant 23,000.00 0.00 0.00 23,000.00 100.00 10-530-550032 NRA -Rental Facade 15,000.00 0.00 0.00 15,000.00 100.00 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 250.00 0.00 0.00 250.00 100.00 10-530-550039 Historic Preservation Grant 23,000.00 0.00 0.00 23,000.00 100.00 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 0.00 0.00 50,000.00 100.00 10-530-550067 HPF-P Bruhn 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 181,250.00 57,181.79 0.00 124,068.21 68.45 530 Plan & Protect Svc-RedevGrant 363,226.80 146,502.35 27.30 216,697.15 59.66 531 Plan & Protect Svcs -Build Reg 10-531-501020 Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-531-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-531-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-531-502010 Social Security 0.00 0.00 0.00 0.00 0.00 10-531-502020 Group Health Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502030 Retirement 0.00 0.00 0.00 0.00 0.00 10-531-502040 Workers Compensation 0.00 0.00 0.00 0.00 0.00 10-531-502050 Life Insurance 0.00 0.00 0.00 0.00 0.00 10-531-502060 Long Term Disability 0.00 0.00 0.00 0.00 0.00 10-531-502070 Employee Assistance Prgm 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-531-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-531-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 183,296.93 162,085.06 0.00 21,211.87 11.57 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,022.21 11,274.50 0.00 2,747.71 19.60 10-532-502020 Group Health Insurance 34,954.14 29,890.17 0.00 5,063.97 14.49 10-532-502030 Retirement 23,462.01 20,746.81 0.00 2,715.20 11.57 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 219.10 191.55 0.00 27.55 12.57 10-532-502060 Long Term Disability 546.15 476.79 0.00 69.36 12.70 10-532-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 260,319.48 228,480.23 0.00 31,839.25 12.23 10-532-511010 Advertising 90.00 45.00 0.00 45.00 .50.00 10-532-511020 Postage 150.00 58.86 0.00 91.14 60.76 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 627.78 0.00 672.22 51.71 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 608.88 0.00 391.12 39.11 E10 Materials & Supplies 2,625.00 1,340.52 0.00 1,284.48 48.93 10-532-520030 Dues And Publications 900.00 628.00 0.00 272.00 30.22 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 1,000.00 75.00 0.00 925.00 92.50 10-532-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-532-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-532-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-532-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 10-532-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524026 Household Hazardous Waste 0.00 0.00 0.00 0.00 0.00 10-532-524027 INACTIVE - Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524028 Misc Recycling 0.00 0.00 0.00 0.00 0.00 10-532-524030 Compost Services 196,800.00 164,000.00 32,800.00 0.00 0.00 10-532-529010 Special Events 600.00 145.10 0.00 454.90 75.82 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 199,300.00 164,848.10 32,800.00 1,651.90 0.83 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 35,748.00 31,786.11 0.00 3,961.89 11.08 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 747.42 0.00 332.58 30.79 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 770.00 1,008.44 27.30 -265.74 -34.51 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 38,928.00 34,825.97 27.30 4,074.73 10.47 10-532-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-532-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 501,172.48 429,494.82 32,827.30 38,850.36 7.75 533 PPS - Prop MaintCode Enforce 10-533-501020 Salaries 171,566.26 152,799.34 0.00 18,766.92 10.94 10-533-501050 Parttime(wo Benefits) 30,000.00 19,534.13 0.00 10,465.87 34.89 10-533-501060 Seasonal Salaries 0.00 2,833.60 0.00 -2,833.60 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,419.82 12,791.18 0.00 2,628.64 17.05 10-533-502020 Group Health Insurance 31,986.67 26,618.43 0.00 5,368.24 16.78 10-533-502030 Retirement 21,960.48 19,558.42 0.00 2,402.06 10.94 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 181.40 163.57 0.00 17.83 9.83 10-533-502060 Long Term Disability 499.39 450.46 0.00 48.93 9.80 10-533-502070 Employee Assistance Prgm 76.44 72.26 0.00 4.18 5.47 E05 Personnel Services 273,947.84 237,078.77 0.00 36,869.07 13.46 10-533-511010 Advertising 100.00 168.00 0.00 -68.00 -68.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-533-511020 Postage 2,300.00 1,152.47 0.00 1,147.53 49.89 10-533-512010 Printing 300.00 0.00 0.00 300.00 100.00 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 783.69 0.00 216.31 21.63 10-533-514017 COVID-19 0.00 701.37 0.00 -701.37 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,209.25 0.00 140.75 10.43 E10 Materials & Supplies 5,190.00 4,014.78 0.00 1,175.22 22.64 10-533-520030 Dues And Publications 500.00 792.00 0.00 -292.00 -58.40 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 371.54 0.00 1,028.46 73.46 10-533-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-533-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-533-522021 Abatement 28,000.00 32,959.00 0.00 -4,959.00 -17.71 10-533-522022 Demo 407,849.00 175,683.77 17,649.00 214,516.23 52.60 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 437,749.00 209,806.31 17,649.00 210,293.69 48.04 10-533-534010 Telephone 3,701.40 2,535.76 0.00 1,165.64 31.49 E20 Utilities 3,701.40 2,535.76 0.00 1,165.64 31.49 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,280.00 680.53 0.00 599.47 46.83 10-533-547010 Equipment Maintenance 30.00 0.00 0.00 30.00 100.00 10-533-547020 Maintenance Agreements 13,587.00 1,040.21 27.30 12,519.49 92.14 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 15,167.00 1,990.74 27.30 13,148.96 86.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 735,755.24 455,426.36 17,676.30 262,652.58 35.70 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 307,746.07 216,411.84 0.00 91,334.23 29.68 10-534-501050 Parttime(wo Benefits) 0.00 195.00 0.00 -195.00 0.00 10-534-501060 Seasonal Salaries 0.00 13,403.70 0.00 -13,403.70 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 25,072.57 16,357.40 0.00 8,715.17 34.76 10-534-502020 Group Health Insurance 70,046.46 48,558.26 0.00 21,488.20 30.68 10-534-502030 Retirement 41,951.50 27,258.18 0.00 14,693.32 35.02 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-502050 Life Insurance 391.68 251.50 0.00 140.18 35.79 10-534-502060 Long Term Disability 968.67 622.52 0.00 346.15 35.73 10-534-502070 Employee Assistance Prgm 131.04 123.88 0.00 7.16 5.46 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 451,064.06 327,938.35 0.00 123,125.71 27.30 10-534-511010 Advertising 100.00 725.30 0.00 -625.30 -625.30 10-534-511020 Postage 1,100.00 660.86 0.00 439.14 39.92 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 128.85 0.00 771.15 85.68 10-534-514017 COVID-19 23,513.00 7,406.20 0.00 16,106.80 68.50 10-534-514030 Small Tools 100.00 48.98 0.00 51.02 51.02 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 1,066.00 0.00 734.00 40.78 E10 Materials & Supplies 27,628.00 10,036.19 0.00 17,591.81 63.67 10-534-520030 Dues And Publications 3,000.00 1,144.74 0.00 1,855.26 61.84 10-534-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-534-520070 Training And Education 5,000.00 2,172.20 0.00 2,827.80 56.56 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 8,000.00 3,316.94 0.00 4,683.06 58.54 10-534-534010 Telephone 1,200.00 2,580.98 0.00 -1,380.98 -115.08 E20 Utilities 1,200.00 2,580.98 0.00 -1,380.98 -115.08 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 636.26 0.00 543.74 46.08 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 16,050.00 844.86 40.95 15,164.19 94.48 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 17,520.00 1,751.12 40.95 15,727.93 89.77 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 505,412.06 345,623.58 40.95 159,747.53 31.61 535 Public Works -Central Maintenan 10-535-501020 Salaries 360,379.67 318,766.88 0.00 41,612.79 11.55 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 2,047.12 0.00 1,952.88 48.82 10-535-501070 Stand-bv Plan 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-501090 Overtime 4,500.00 3,893.25 0.00 606.75 13.48 10-535-501095 Overtime Straight Pay 500.00 336.39 0.00 163.61 32.72 10-535-502010 Social Security 28,257.55 23,481.88 0.00 4,775.67 16.90 10-535-502020 Group Health Insurance 78,239.06 67,499.19 0.00 10,739.87 13.73 10-535-502030 Retirement 46,768.60 41,343.65 0.00 5,424.95 11.60 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 436.97 381.15 0.00 55.82 12.77 10-535-502060 Long Term Disability 1,079.32 942.09 0.00 137.23 12.71 10-535-502070 Employee Assistance Prgm 152.88 144.51 0.00 8.37 5.47 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 528,783.41 463,305.47 0.00 65,477.94 12.38 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 2.00 0.00 48.00 96.00 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 804.62 0.00 695.38 46.36 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 1,902.29 0.00 5,097.71 72.82 10-535-517010 Operational Supplies 5,000.00 4,521.12 0.00 478.88 9.58 E10 Materials & Supplies 13,640.00 7,230.03 0.00 6,409.97 46.99 10-535-520030 Dues And Publications 350.00 180.00 0.00 170.00 48.57 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 0.00 0.00 2,000.00 100.00 10-535-521005 Tank Insurance 500.00 500.00 0.00 0.00 0.00 10-535-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-535-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-535-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 2,850.00 680.00 0.00 2,170.00 76.14 10-535-531010 Electricity 5,660.00 4,948.22 0.00 711.78 12.58 10-535-533010 Natural Gas 4,417.00 2,038.65 0.00 2,378.35 53.85 10-535-534010 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 Water 1,442.00 1,034.56 0.00 407.44 28.26 E20 Utilities 11,739.00 8,021.43 0.00 3,717.57 31.67 10-535-540010 Building & Grounds Maint. 14,983.00 19,467.81 0.00 -4,484.81 -29.93 10-535-541010 Veh & Equip Parts Etc 557,000.00 529,574.44 0.00 27,425.56 4.92 10-535-541015 Vehicle Hail Damage Repair 102,193.19 74,056.99 0.00 28,136.20 27.53 10-535-546010 Clothing Expense 5,500.00 7,746.36 0.00 -2,246.36 -40.84 10-535-547010 Equipment Maintenance 1,000.00 759.50 0.00 240.50 24.05 10-535-547020 Maintenance Agreements 13,120.00 16,480.91 89.35 -3,450.26 -26.30 10-535-547030 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 Repairs & Maintenance 693,896.19 648,086.01 89.35 45,720.83 6.59 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 535 Public Works -Central Maintenan 1,250,908.60 1,127,322.94 89.35 123,496.31 9.87 540 Public Works -Admin 10-540-501020 Salaries 223,146.93 197,354.04 0.00 25,792.89 11.56 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,070.74 14,736.96 0.00 2,333.78 13.67 10-540-502020 Group Health Insurance 28,540.74 17,995.90 0.00 10,544.84 36.95 10-540-502030 Retirement 28,562.81 25,261.38 0.00 3,301.43 11.56 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 268.06 233.55 0.00 34.51 12.87 10-540-502060 Long Term Disability 541.50 469.02 0.00 72.48 13.39 10-540-502070 Employee Assistance Prgm 65.52 61.93 0.00 3.59 5.48 E05 Personnel Services 298,415.53 256,332.01 0.00 42,083.52 14.10 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 0.00 0.00 200.00 100.00 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.00 0.00 100.00 100.00 10-540-513010 Office Supplies 1,000.00 0.00 0.00 1,000.00 100.00 10-540-514010 Gas 80,000.00 78,103.66 0.00 1,896.34 2.37 10-540-514017 COVID-19 0.00 2,628.56 0.00 -2,628.56 0.00 10-540-514040 Food 200.00 1,134.51 0.00 -934.51 -467.26 10-540-517010 Operational Supplies 300.00 0.00 0.00 300.00 100.00 E10 Materials & Supplies 82,000.00 81,866.73 0.00 133.27 0.16 10-540-520030 Dues And Publications 849.39 849.39 0.00 0.00 0.00 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 2,800.61 523.00 0.00 2,277.61 81.33 10-540-522020 Professional Services 200.00 0.00 0.00 200.00 100.00 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 3,850.00 1,372.39 0.00 2,477.61 64.35 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 400.00 258.29 13.65 128.06 32.02 E25 Repairs & Maintenance 400.00 258.29 13.65 128.06 32.02 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 384,665.53 339,829.42 13.65 44,822.46 11.65 541 Public Works -Engineering 10-541-501020 Salaries 831,670.27 705,942.76 0.00 125,727.51 15.12 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 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 400.00 1,501.07 0.00 -1,101.07 -275.27 10-541-501095 Overtime Straight Pay 0.00 252.25 0.00 -252.25 0.00 10-541-502010 Social Security 63,653.38 50,578.37 0.00 13,075.01 20.54 10-541-502020 Group Health Insurance 136,643.93 111,108.72 0.00 25,535.21 18.69 10-541-502030 Retirement 106,504.99 88,436.83 0.00 18,068.16 16.96 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 998.78 813.23 0.00 185.55 18.58 10-541-502060 Long Term Disability 2,416.91 2,010.57 0.00 406.34 16.81 10-541-502070 Employee Assistance Prgm 262.08 247.76 0.00 14.32 5.46 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,148,606.06 966,947.28 0.00 181,658.78 15.82 10-541-511010 Advertising 400.00 325.00 0.00 75.00 18.75 10-541-511020 Postage 350.00 70.53 0.00 279.47 79.85 10-541-512010 Printing 0.00 87.00 0.00 -87.00 0.00 10-541-512020 Copies 50.00 0.11 0.00 49.89 99.78 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 4,000.00 801.92 0.00 3,198.08 79.95 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 26.97 0.00 123.03 82.02 10-541-515040 First Aid Supplies 150.00 64.29 0.00 85.71 57.14 10-541-515070 Const & Inspect Supplies 1,000.00 377.95 0.00 622.05 62.21 10-541-515080 Surveying Supplies 1,500.00 279.89 0.00 1,220.11 81.34 10-541-517010 Operational Supplies 1,900.00 867.58 0.00 1,032.42 54.34 E10 Materials & Supplies 9,700.00 2,901.24 0.00 6,798.76 70.09 10-541-520030 Dues And Publications 4,000.00 3,271.00 0.00 729.00 18.23 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,120.94 0.00 2,879.06 71.98 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 63.00 0.00 437.00 87.40 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 9,000.00 4,454.94 0.00 4,545.06 50.50 10-541-534010 Telephone 500.00 440.66 0.00 59.34 11.87 E20 Utilities 500.00 440.66 0.00 59.34 11.87 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,822.01 0.00 -322.01 -21.47 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 9,800.00 9,258.09 40.95 500.96 5.11 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 13,300.00 12,655.10 40.95 603.95 4.54 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-572020 Advertising Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 150.00 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 137.00 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 0.00 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 1,225.13 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 0.00 Public Works -Engineering 1,181,106.06 987,399.22 40.95 193,665.89 16.40 542 10-542-514030 Public Works -Street 9,000.00 8,479.55 0.00 520.45 5.78 10-542-501020 Food Salaries 1,263,093.87 1,124,445.42 0.00 138,648.45 10.98 10-542-501060 88.40 Seasonal Salaries 20,000.00 28,276.40 0.00 -8,276.40 -41.38 10-542-501070 392,559.60 Stand-by Plan 5,000.00 3,720.00 0.00 1,280.00 25.60 10-542-501090 0.00 Overtime 30,000.00 17,142.66 0.00 12,857.34 42.86 10-542-501095 Overtime Straight Pay 500.00 489.74 0.00 10.26 2.05 10-542-502010 200.00 Social Security 100,872.43 85,409.92 0.00 15,462.51 15.33 10-542-502020 26.52 Group Health Insurance 271,017.18 230,951.54 0.00 40,065.64 14.78 10-542-502030 10-542-520030 Retirement 166,220.01 145,399.67 0.00 20,820.34 12.53 10-542-502040 INACTIVE - Mtgs & Conferences Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 7,680.00 Life Insurance 1,518.37 1,317.45 0.00 200.92 13.23 10-542-502060 0.00 Long Term Disability 3,711.17 3,220.33 0.00 490.84 13.23 10-542-502070 0.00 Employee Assistance Prgm 622.44 588.42 0.00 34.02 5.47 10-542-503010 125.00 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,901,866.31 1,680,072.39 0.00 221,793.92 11.66 10-542-511010 Advertising 1,000.00 744.80 0.00 255.20 25.52 10-542-511020 Postage 150.00 4.20 0.00 145.80 97.20 10-542-512010 Printing 90.00 137.00 0.00 -47.00 -52.22 10-542-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-542-513010 Office Supplies 1,600.00 374.87 0.00 1,225.13 76.57 10-542-514017 COVID-19 0.00 2,596.60 0.00 -2,596.60 0.00 10-542-514020 Chemicals 382,599.10 357,573.70 40,652.22 -15,626.82 -4.08 10-542-514030 Small Tools 9,000.00 8,479.55 0.00 520.45 5.78 10-542-514040 Food 2,195.04 2,226.78 0.00 -31.74 -1.45 10-542-515010 Stormwater Material 88.40 88.40 0.00 0.00 0.00 10-542-515020 Street Materials 395,117.46 392,559.60 0.00 2,557.86 0.65 10-542-515040 First Aid Supplies 500.00 107.54 0.00 392.46 78.49 10-542-515060 Weed Control 1,500.00 904.00 0.00 596.00 39.73 10-542-515070 Const & Inspect Supplies 200.00 0.00 0.00 200.00 100.00 10-542-517010 Operational Supplies 5,000.00 3,673.87 0.00 1,326.13 26.52 E10 Materials & Supplies 799,050.00 769,470.91 40,652.22 -11,073.13 -1.39 10-542-520030 Dues And Publications 1,320.00 835.00 0.00 485.00 36.74 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 2,916.00 0.00 4,764.00 62.03 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,000.00 12,977.47 0.00 1,022.53 7.30 10-542-523010 Equipment Rentlease 200.00 75.00 0.00 125.00 62.50 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 16,803.47 0.00 6,396.53 27.57 10-542-531010 Electricity 28,364.00 20,496.76 0.00 7,867.24 27.74 10-542-531020 Street Lights 610,000.00 496,354.56 0.00 113,645.44 18.63 10-542-533010 Natural Gas 10,000.00 9,840.32 0.00 159.68 1.60 10-542-534010 Telephone 580.00 1,036.28 8.00 -464.28 -80.05 10-542-535010 Water 13,390.00 4,244.55 0.00 9,145.45 68.30 E20 Utilities 662,334.00 531,972.47 8.00 130,353.53 19.68 10-542-540010 Building & Grounds Maint. 12,000.00 15,121.60 90.00 -3,211.60 -26.76 10-542-541030 Vehicle Wash 7,000.00 6,624.00 0.00 376.00 5.37 10-542-542010 Repairs - StopStreet Lights 30,000.00 19,147.79 0.00 10,852.21 36.17 10-542-542030 Signs & Marking Paint 51,800.00 53,260.90 498.20 -1,959.10 -3.78 10-542-546010 Clothing Expense 15,000.00 10,114.08 0.00 4,885.92 32.57 10-542-547010 Equipment Maintenance 3,140.00 265.00 0.00 2,875.00 91.56 10-542-547020 Maintenance Agreements 360.00 360.00 0.00 0.00 0.00 10-542-547030 Radio Maintenance 1,000.00 252.64 0.00 747.36 74.74 E25 Repairs & Maintenance 120,300.00 105,146.01 588.20 14,565.79 12.11 10-542-572010 Purchase Of Vehicles 13,000.00 13,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 E70 Capital Purchases 13,000.00 13,000.00 0.00 0.00 0.00 542 Public Works -Street 3,519,750.31 3,116,465.25 41,248.42 362,036.64 10.29 700 Transfers & Subsidies 10-700-590050 Transfer To Tif Fund 15,000.00 2,206.26 0.00 12,793.74 85.29 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 155,658.00 155,658.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 79,111.25 79,111.25 0.00 0.00 0.00 10-700-590075 Transit Subsidy 579,709.76 579,709.76 0.00 0.00 0.00 10-700-590080 Transfer To Amb Sery 0.00 0.00 0.00 0.00 0.00 E80 Transfers Out 829,479.01 816,685.27 0.00 12,793.74 1.54 700 Transfers & Subsidies 829,479.01 816,685.27 0.00 12,793.74 1.54 900 CapitalVehicleEquipment 10-900-571010 Capvehclequip-city Admin 0.00 0.00 0.00 0.00 0.00 10-900-571020 Capvhclegp-code Enf-adm 0.00 0.00 0.00 0.00 0.00 10-900-571030 Capvhclegp-bldg Regs 0.00 0.00 0.00 0.00 0.00 10-900-571040 Capvhclegp-envir Health 0.00 0.00 0.00 0.00 0.00 10-900-571050 Capvhclegp-p & Transp-adm 0.00 0.00 0.00 0.00 0.00 10-900-571060 Canvhclean-nub Works-adm 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 31,702.50 25,702.50 0.00 6,000.00 18.93 10-990-575023 Fire Station 4 Rehab 348,252.57 329,290.17 13,831.07 5,131.33 1.47 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 0.00 0.00 243,750.00 100.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 Wayfmding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 103,937.70 37,538.59 2,639.00 63,760.11 61.34 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 B1vd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 3,828,037.77 392,531.26 16,470.07 3,419,036.44 89.32 990 Capital Projects 3,828,037.77 392,531.26 16,470.07 3,419,036.44 89.32 995 ARPA 10-995-501020 Salaries 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 0.00 0.00 0.00 0.00 0.00 10-995-515010 Stormwater Materials 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 995 ARPA 0.00 0.00 0.00 0.00 0.00 Expense Expense 39,640,386.93 30,315,274.12 473,423.56 8,851,689.25 22.33 GL - Trial Balance by Acct Type and Full Acct Number (10/07/2021 - 2:52 PM) Page 35 CITY OF JEFFERSON FISCAL YEAR 2021 ESTIMATED FUND BALANCE FYE2020 UNASSIGNED FUND BALANCE (Audited) $ 6,845,662.00 Reappropriations from FY2020 to FY2021 Replace six hail damaged police vehicles $ (202,860.00) Fire Station #5 pavement replacement $ (24,166.53) 519 E. Capitol Avenue Demolition $ (87,849.00) HUD Neighborhood Stabilization Program $ (78,805.90) Springbrook Software Upgrade $ (9,818.36) Future Fire Stations $ (31,702.50) Fire Station #4 Rehab $ (348,252.57) Downtown Streetscape $ (800.00) Ongoing Infrastructure/Facility Needs $ (103,937.70) Remaining balance of Friends of JC Animal Shelter Grant $ (4,370.00) $ (892,562.56) 2021 Adjustments/Supplementals FY2021 Supplemental Appropriations: Budget Amendments to Utilize CARES Grant $ (163,800.00) Supplemental for Animal Shelter dishwashers & kennel doors $ (16,965.99) Supplemental for Police and Fire Department Radios $ (235,000.00) Supplemental for Street Chemicals $ (80,000.00) Supplemental for Fire Station #3 Roof Replacement $ (85,000.00) Supplemental for 422 E. High St Demolition $ (14,367.00) Cash Received from SEMA - Debris Removal and Disposal (75%) $ 498,834.74 Cash Received from SEMA -Emergency Protective Measures (75%) $ 134,718.74 Supplemental for Abatements $ (15,000.00) Supplemental for Demolitions $ (300,000.00) Cash Received from SEMA - Emergency Protective Measures (25%) $ 44,906.25 Supplemental for Worker's Comp Security $ (155,658.00) $ (387,331.26) FYE2021 ESTIMATED Unassigned Fund Balance $ 5,565,768.18 FYE2021 ESTIMATED Fund Balance % of Adopted Budget 16.94% 17% of FY2021 Adopted Budget ($32,860,062) = $5,586,211 NOTE: Cash Received from American Rescue Plan Act $ 3,793,290.50 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 Feb -12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 Mar -12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 (8.11) Apr -12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 (7.25) May -12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 (7.25) Jun -12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 (7.25) 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 (7.25) 987.59 (7.50) Sep -12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 (7.00) Oct -12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 1,166.54 (7.50) Nov -12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) 1,185.18 (7.33) Dec -12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 (7.35) Jan -13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 (8.28) Feb -13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 (8.28) Mar -13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 (7.37) Apr -13 5/20/13 100,022.48 42,009.44 56,012.59 Interest Received 4/2012 Interest Received 5/2012 Interest Received 5/2012 Service Charge 6/2012 Interest Received 6/2012 Service Charge 7/2012 Interest Received 7/2012 Service Charge 8/2012 Interest Received 8/2012 Service Charge 9/2012 Interest Received 9/2012 Service Charge 10/2012 Interest Received 10/2012 Service Charge 11/2012 Interest Received 11/2012 Service Charge JCCVB 3/7 Check Deposited in Error 12/2012 Interest Received 12/2012 Service Charge Correction of Deposit Error 1/2013 Interest Received 1/2013 Service Charge 2/2013 Interest Received 2/2013 Service Charge 3/2013 Interest Received 3/2013 Service Charge 4/2013 Interest Received 4/2013 Service Charge 5/2013 Interest Received 5/2013 Service Charge Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 1,450.30 (8.56) (10,000.00) May -13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 (8.45) (1,187.09) Jun -13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 (8.45) (33.25) (15,000.00) (10,000.00) Jul -13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 (8.79) (5,000.00) Aug -13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 (8.45) (3,000.00) Sep -13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 (8.45) Oct -13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 (8.28) Nov -13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 (8.28) Dec -13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 (8.28) Jan -14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) 2,078.72 (8.45) Feb -14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 (8.28) Mar -14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 (8.29) Apr -14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 (8.29) May -14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 (8.29) Jun -14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 (8.29) Jul -14 8/20/141 98,901.39 1 41,538.58 55,384.78 2,459.73 6/2013 Interest Received 6/2013 Service Charge Ck #50 - C H Johnson Consulting 7/2013 Interest Received 7/2013 Service Charge Ck #1001 - C H Johnson Consulting 8/2013 Interest Received 8/2013 Service Charge Ck #1002 - City of Jefferson - RFP Ad Ck #1003 - C H Johnson Consulting Ck #1004 - C H Johnson Consulting 9/2013 Interest Received 9/2013 Service Charge Ck #1005 - C H Johnson Consulting 10/2013 Interest Received 10/2013 Service Charge Ck #1006 - C H Johnson Consulting 11/2013 Interest Received 11/2013 Service Charge 12/2013 Interest Received 12/2013 Service Charge 1/2014 Interest Received 1/2014 Service Charge 2/2014 Interest Received 2/2014 Service Charge Ck #1007 - C H Johnson Consulting 3/2014 Interest Received 3/2014 Service Charge 4/2014 Interest Received 4/2014 Service Charge 5/2014 Interest Received 5/2014 Service Charge 6/2014 Interest Received 6/2014 Service Charge 7/2014 Interest Received 7/2014 Service Charge 8/2014 Interest Received 8/2014 Service Charge 9/2014 Interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** (8.29) Aug -14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 (8.29) Sep -14 10/20/14 112,370.02 47,195.41 62,927.21 2,586.87 (8.29) Oct -14 11/20/14 116,992.89 49,137.01 65,516.02 2,736.57 (14.65) Nov -14 12/20/14 72,761.33 30,559.76 40,746.34 2,798.53 (8.29) Dec -14 1/20/15 60,394.73 25,365.79 33,821.05 2,575.56 (8.29) Jan -15 2/20/15 85,741.83 36,011.57 48,015.42 2,935.34 (8.29) Feb -15 3/20/15 84,317.61 35,413.40 47,217.86 2,911.14 (10.54) Mar -15 4/20/15 114,789.97 48,211.79 64,282.38 3,049.41 (8.29) Apr -15 5/20/15 102,479.43 43,041.36 57,388.48 3,046.67 (8.29) May -15 6/20/15 116,174.48 48,793.28 65,057.71 3,217.49 (8.29) Jun -15 7/31/15 97,379.11 40,899.23 54,532.30 3,287.90 (10.67) Jul -15 8/20/15 102,541.78 43,067.55 57,423.40 3,307.41 (8.58) Aug -15 9/20/15 81,248.87 34,124.53 45,499.37 3,476.74 (8.29) Sep -15 10/20/15 102,709.81 43,138.12 57,517.49 3,421.47 (8.00) Oct -15 12/1/15 107,837.70 45,291.83 60,389.11 3,605.14 (8.29) Nov -15 12/31/15 67,119.58 28,190.22 37,586.96 Sep -15 1,908.92 801.75 1,069.00 3,666.35 (8.29) Dec -15 1/31/16 66,959.22 28,122.88 37,497.16 3,478.72 (8.49) Jan -16 2/20/161 83,239.99 1 34,960.80 1 46,614.39 9/2014 Service Charge 10/2014 Interest Received 10/2014 Service Charge 11/2014 Interest Received 11/2014 Service Charge 12/2014 Interest Received 12/2014 Service Charge 1/2015 Interest Received 1/2015 Service Charge 2/2015 Interest Received 2/2015 Service Charge 3/2015 Interest Received 3/2015 Service Charge 4/2015 Interest Received 4/2015 Service Charge 5/2015 Interest Received 5/2015 Service Charge 6/2015 Interest Received 6/2015 Service Charge 7/2015 Interest Received 7/2015 Service Charge 8/2015 Interest Received 8/2015 Service Charge 9/2015 Interest Received 9/2015 Service Charge 10/2015 Interest Received 10/2015 Service Charge 11/2015 Interest Received 11/2015 Service Charge 12/2015 Interest Received 12/2015 Service Charge late pays 1/2016 Interest Received 1/2016 Service Charge 2/2016 Interest Received 2/2016 Service Charge Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 3,786.20 (8.28) Feb -16 3/20/16 97,559.96 40,975.18 54,633.58 3,718.19 (8.27) Mar -16 4/29/16 101,134.20 42,476.36 56,635.16 3,914.86 (8.26) Apr -16 5/20/16 140,992.87 59,217.01 78,956.01 3,905.43 May -16 6/20/16 112,152.91 47,104.22 62,805.63 3,985.42 Jun -16 7/31/16 106,704.37 44,815.83 59,754.44 4,207.43 Jul -16 8/20/16 96,811.40 40,660.79 54,214.38 4,136.69 Aug -16 9/20/16 88,674.86 37,243.44 49,657.92 4,350.78 Sep -16 10/31/16 100,606.10 42,254.56 56,339.42 4,292.30 Oct -16 11/20/16 120,471.15 50,597.88 67,463.85 4,531.06 Nov -16 12/20/16 88,755.07 37,277.13 49,702.83 4,602.85 Dec -16 1/31/17 65,709.30 27,597.91 36,797.21 4,207.06 Jan -17 2/20/17 95,905.35 40,280.25 53,706.99 4,726.10 Feb -17 3/31/17 95,135.98 39,957.11 53,276.15 4,651.72 Mar -17 4/30/17 111,370.63 46,775.67 62,367.55 4,885.76 Apr -17 5/30/17 109,652.93 46,054.23 61,405.64 4,807.94 May -17 6/30/17 123,148.39 51,722.32 68,963.10 5,089.00 Jun -17 7/31/17 120,310.25 50,530.30 67,373.74 5,141.00 Jul -17 8/20/17 101,096.32 42,460.45 56,613.94 5,081.97 Aug -17 9/30/17 99,136.13 41,637.18 55,516.23 5,325.63 Sep -17 10/31/17 112,835.87 47,391.06 63,188.09 5,243.98 Oct -17 11/20/17 118,132.32 49,615.57 66,154.10 5,519.00 Nov -17 12/20/17 84,414.19 35,453.96 47,271.95 5,565.66 Dec -17 1/31/18 64,644.90 27,150.86 36,201.14 5,076.25 Jan -18 2/20/18 90,463.34 37,994.60 50,659.47 5,710.59 Feb -18 3/31/18 72,376.53 30,398.14 40,530.86 5,580.76 3/2016 Interest Received 3/2016 Service Charge 4/2016 Interest Received 4/2016 Service Charge 5/2016 Interest Received 5/2016 Service Charge 6/2016 Interest Received 7/2016 Interest Received 8/2016 Interest Received 9/2016 Interest Received 10/2016 Interest Received 11/2016 Interest Received 12/2016 Interest Received 1/2017 Interest Received 2/2017 Interest Received 3/2017 Interest Received 4/2017 Interest Received 5/2017 Interest Received 6/2017 Interest Received 7/2017 Interest Received 8/2017 Interest Received 9/2017 Interest Received 10/2017 Interest Received 11/2017 Interest Received 12/2017 Interest Received 1/2018 interest Received 2/2018 interest Received 3/2018 interest Received 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 Apr -18 5/30/18 115,538.43 48,526.14 64,701.52 5,744.27 May -18 6/20/18 127,840.04 53,692.82 71,590.42 6,020.86 Jun -18 7/31/18 108,499.02 45,569.59 60,759.45 6,145.34 Jul -18 8/20/18 99,948.25 41,978.26 55,971.02 5,929.16 Aug -18 9/20/18 92,260.57 38,749.44 51,665.92 6,303.93 Sep -18 10/31/18 102,804.82 43,178.02 57,570.70 6,160.57 Oct -18 11/20/18 130,250.45 54,705.19 72,940.25 6,496.60 Nov -18 12/20/18 87,460.75 36,733.51 48,978.02 6,531.01 (3,908.75) Dec -18 1/31/19 70,508.84 29,613.71 39,484.95 5,949.48 (2,623.75) Jan -19 2/20/19 88,590.00 37,207.80 49,610.40 6,683.16 Feb -19 3/31/19 99,690.19 41,869.88 55,826.51 6,537.39 Mar -19 4/30/19 121,611.98 51,077.03 68,102.71 6,844.11 (50.75) (4,867.50) Apr -19 5/30/19 131,434.04 55,202.30 73,603.06 6,731.55 200.00 May -19 6/20/19 134,504.89 56,492.05 75,322.74 7,065.89 Jun -19 7/31/19 120,530.50 50,622.81 67,497.08 7,131.88 Jul -19 8/20/19 117,844.99 49,494.90 65,993.19 7,014.55 (2,136.63) Aug -19 9/20/19 114,393.96 48,045.46 64,060.62 7,349.16 Sep -19 10/31/19 125,692.73 52,790.95 70,387.93 7,179.27 (737.50) Oct -19 11/20/19 136,035.67 57,134.98 76,179.98 7,549.02 Nov -19 12/20/19 98,690.15 41,449.86 55,266.49 7,603.34 Dec -19 1/31/20 85,935.20 36,092.79 48,123.71 7,157.65 (10,000.00) (10,000.00) (2,810.43) 5/2018 interest Received 6/2018 interest Received 7/2018 interest Received 8/2018 interest Received 9/2018 interest Received 10/2018 interest Received 11/2018 interest Received 12/2018 interest Received 1/2019 interest Received CK# 1008 2/2019 interest Received CK# 1009 3/2019 interest Received 4/2019 interest Received 5/2019 interest Received CK# 1011 CK# 1012 6/2019 interest Received 6/26/19 bank deposit 7/2019 interest Received 8/2019 interest Received 9/2019 interest Received CK# 1012 10/2019 interest Received 11/2019 interest Received CK# 1014 12/2019 interest Received 1/2020 interest Received 2/2020 interest Received CK# 1015 CK# 1016 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 Feb -20 3/31/20 111,144.21 46,680.58 62,240.76 7,575.08 Mar -20 4/30/20 80,913.29 33,983.58 45,311.44 6,861.56 (2,205.79) Apr -20 5/30/20 60,499.04 25,409.60 33,879.46 2,527.02 (6,500.00) May -20 6/20/20 61,880.21 25,989.69 34,652.92 2,625.49 Jun -20 7/31/20 94,499.61 39,689.84 52,919.78 2,644.87 (5,967.50) Jul -20 8/20/20 96,451.62 40,509.68 54,012.91 2,581.92 Aug -20 9/20/20 67,013.43 28,145.64 37,527.52 2,687.74 Sep -20 10/31/20 83,113.75 34,907.77 46,543.70 1,437.91 Oct -20 11/20/20 78,606.00 33,014.52 44,019.36 272.79 (1,937.50) Nov -20 12/20/20 60,099.25 25,241.68 33,655.58 264.28 Dec -20 1/31/21 65,475.65 27,499.77 36,666.37 188.91 Jan -21 2/20/21 82,813.97 34,781.87 46,375.82 (1,705.00) 111.35 Feb -21 3/31/21 77,646.44 32,611.50 43,482.01 108.55 Mar -21 4/30/21 110,467.63 46,396.41 61,861.87 113.04 Apr -21 5/30/21 114,792.54 48,212.87 64,283.82 110.52 (1,472.50) May -21 6/20/21 131,092.96 55,059.04 73,412.06 115.52 Jun -21 7/31/21 132,627.36 55,703.49 74,271.32 116.66 Jul -21 8/20/21 118,674.04 49,843.10 66,457.46 114.15 Aug -21 9/20/21 103,990.65 43,676.07 58,234.76 Total 11,966,137.92 5,025,777.93 7,002,385.91 3/2020 interest Received 4/2020 interest Received 5/2020 interest Received CK# 1018 6/2020 interest Received CK# 1019 7/2020 interest Received 8/2020 interest Received CK# 1020 9/2020 interest Received 10/2020 interest Received 11/2020 interest Received 12/2020 interest Received CK# 1021 1/2021 interest Received 2/2021 interest Received CK# 1022 3/2021 interest Received 4/2021 interest Received 5/2021 interest Received 6/2021 interest Received CK# 1023 7/2021 interest Received 8/2021 interest Received 9/2021 interest Received average monthly amount for 4 cent lockbox fund $ 53,608.30 **Effective for 25 years starting in 2011 2021 Occupancy January 37.70% February 37.80% March 48.20% April 55.10% May 52.90% June 54.20% July 47.70% August 42.10% September 64.60% October 60.50% November 53.40% December 60.30% COMPARATIVE OCCUPANCY RATE 2020 Occupancy 2019 Occupancy 2018 Occupancy 47.30% 49.40% 48.10% 55.50% 58.00% 53.40% 41.60% 58.00% 57.60% 34.90% 63.10% 61.70% 42.10% 60.90% 64.60% 55.00% 60.50% 63.20% 53.40% 58.80% 60.30% 46.20% 59.00% 56.80% 48.20% 63.40% 59.90% 45.30% 63.80% 65.60% 34.60% 50.30% 54.80% 30.30% 44.90% 46.00% 2017 Occupancy 48.70% 56.80% 62.20% 62.40% 63.80% 70.40% 65.90% 61.50% 64.50% 66.50% 51.50% 40.80% 2016 Occupancy 51.30% 58.60% 59.80% 67.20% 64.90% 64.00% 58.20% 56.50% 62.60% 62.90% 50.60% 42.10% 2015 Occupancy 45.90% 51.20% 59.80% 58.10% 63.10% 59.70% 60.80% 52.60% 63.30% 60.70% 51.30% 45.10% Tab 2 - Multi -Segment Missouri Hotel R Lodging Association For the month of: July 2021 Occ % ADR RevPAR Percent Change from July 2020 Room Room Room !1 2020 2021 2020 2021 2020 Oct ADR R -PAR Rev Avall Sold Currency: USD - US Dollar Participation Properties Rooms Census Sample Census Sample 60897 36367 5495370 4145017 West North Central 11 65.3 46.81 108.45 8T521 70.80 40.921 39.6 23.9 73.0 76.9 2.2 42.81 1 49.4 37.71 92.85 84.661 45.89 31.921 31.1 9.7 43.8 48.3 3.1 35.211 5021 30171 386190 289358 -0.0 37.6 Branson, MO 63.5 44.0 135.86 133.92 86.29 58.90 44.4 1.4 46.5 41.7 -3.3 39.6 Lake of the Ozarks+ 71.7 55.9 145.93 140.81 104.64 78.77 28.2 3.6 32.8 32.8 0.0 28.2 Joplin, MO Missouri 11 63.2 44.41 110.47 89.651 69.81 39.801 42.4 23.2 75.4 78.7 1.9 45.0 1 50,7 37.21 96.13 87.131 48.76 32.391 36.4 10.3 50.5 55.2 3.1 40.61 1 1211 7081 108623 79112 Kansas City, VIO 65.70 40.241 31.5 24.1 63.3 69.5 3.8 36.6 L Saint Louis, MO 65.3 39.5 11111.55 81.51 68.39 32.23 55.0 36.9 112.2 1118.9 3.2 59.9 50.8 37.7 96.27 87.55 48.95 33.03 34.8 10.0 48.2 54.3 4.2 40.4 362 266 40889 34833 Columbia, MO- 66.9 43.8 91.82 72.97 61.44 31.97 52.7 25.8 92.2 91.5 -0.3 52.2 Jefferson City, MO+ 47.7 53.2 94.19 78.56 44.97 41.80 -10.3 19.9 7.6 16.9 8.7 -2.5 Springfield, MO 73.9 53.7 96.01 76.29 70.96 40.97 37.6 25.9 73.2 73.2 -0.0 37.6 Branson, MO 63.5 44.0 135.86 133.92 86.29 58.90 44.4 1.4 46.5 41.7 -3.3 39.6 Lake of the Ozarks+ 71.7 55.9 145.93 140.81 104.64 78.77 28.2 3.6 32.8 32.8 0.0 28.2 Joplin, MO 65.9 54.8 92.25 76.41 60.77 41.84 20.3 20.7 45.3 49.5 2.9 23.8 Saint Joseph, MO+ 71.8 69.5 106.84 87.99 76.73 61.14 3.4 21.4 25.5 25.5 0.0 3.4 Independence, MO+ 69.0 52.5 95.14 76.66 65.70 40.241 31.5 24.1 63.3 69.5 3.8 36.6 54.4 39.0 82.35 77.26 44.80 30.17 39.3 6.6 48.5 47.4 -0.7 38.3 47.6 46.9 90.63 82.95 43.17 38.87 1.7 9.3 11.1 20.7 8.7 10.5 65.5 43.2 86.15 75.29 56.39 32.51 51.6 14.4 73.4 72.6 -0.4 50.9 43.1 23.5 125.96 115.76 54.31 27.19 83.6 8.8 99.7 99.2 -0.3 83.0 45.8 32.9 119.17 112.00 54.57 36.88 39.1 6.4 48.0 49.0 0.7 40.0 60.3 43.9 83.28 74.62 50.20 32.76 37.3 11.6 53.2 53.9 0.4 37.9 64.5 55.5 92.82 86.30 59.90 47.88 16.3 7.5 25.1 25.1 0.0 16.3 53.9 43.71 82.87 73.481 44.68 32.091 23.5 12.8 39.2 42.5 2.4 26.4 39 31 4040 3336 16 14 1513 1391 72 50 6468 4841 166 38 14467 4752 40 10 2720 1207 35 24 2650 2113 11 9 992 838 21 141 1628 1320 A blank row indicates insufficient data. 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 prohibNed 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: 2021 STR, LLC / STR Global, Ltd. trading as "STR". 0 Costar Realty Information, Inc. Glossary: For all STIR definitions, please visit www.str.com/data-insights/resources/glossary Frequently Asked Questions (FAQ): For all STIR FAQs, please click here or visit http://www.str.com/data-insights/resources/FAQ For additional support, please contact your regional office. For the latest in industry news, visit HotelNewsNow.com. To learn more about the Hotel Data Conference, visit Hotel DataConference.com. JCCVB 2022 Budget Acct #I Line Item 1 2022 Budget I lExplanation of Account Codes Revenue 4100 Room Tax $ 492,475.00 Monthly lodging tax revenues 4200 Interest Earning $ 1,560.00 $130.00 per month 4300 MDT MMG Advertising Coop $ 139,815.00 Reimbursed quarterly 4350 Special Event $ 3,500.00 $ 2,500.00 State Track hotel rebates $ 1,500.00 Misc revenue 4500 AEC Fundraising Events $ 10,000.00 $ 8,000.00 AEC winter fundraiser $ 2,000.00 Misc revenue 4550 Prison Tour Ticket Sales $ 542,640.00 $ 542,640.00 Prison tour ticket sales 4560 MSP Museum Admission $ 26,000.00 $ 26,000.00 Museum admission 4700 Advertising Revenue $ 2,000.00 $ 1500.00 MSP Hand fans $ 500.00 Misc 4801 Item Sales $ 80,000.00 $ 80,000.00 CVB and MSP Promotional Items 4900 Misc. Revenue $ 5,000.00 $ 5,000.00 Misc. revenue Total Revenue $ 1,302,990.00 Payroll Expenses 6100 Salaries and Wages $ 270,000.00 $ 270,000.00 Staff salaries 6120 Retirement Benefits $ 3,900.00 $ 3,900.00 Simple retirment plan 3% 6130 Payroll Taxes $ 21,000.00 $ 21,000.00 6140 Insurance Benefits $ 31,500.00 $ 31,500.00 Total Payroll $ 326,400.00 25% Administrative and General Expenses 6200 Auditing and Accounting $ 22,725.00 $ 15,000.00 Monthly Accounting and Payroll services $1,250 per month $ 7,725.00 Annual audit 6210 Building Rental $ 48,000.00 $ 48,000.00 $4000 per month 6211 Building Maintenance $ 500.00 $ 500.00 Misc maintenance 6211 IBuilding Utilities $ 3,000.00 $ 3,000.00 Over the alloted amount included in lease 6212 Cleaning Service $ 3,200.00 $ 2,880.00 Office cleaning services $ 320.00 Trash service 6213 ISecurity Monitoring $ 500.00 $ 275.00 Maintenance contract $ 225.00 Misc. maintenance items 6220 Computer Support/Software $ 19,500.00 $ 8,004.00 Simpleview monthly expense $ 11,496.00 Computer support - IT service 6230 Consulting $ 500.00 $ 500.00 Legal services 6240 Dues and Subscriptions $ 2,000.00 $ 437.00 Miscellanous $ 740.00 ACCE Annual membership $ 150.00 Downtown Jefferson City $ 40.00 Eastside Business Association $ 50.00 Westside Business Association $ 410.00 Jefferson City Chamber of Commerce $ 173.00 News Tribune Annual Subscription 6245 Depreciation Expense $ 18,000.00 $ 18,000.00 $1,500. per month 6250 Office Equip Lease & Repair $ 3,891.00 $ 3,216.00 1 Monthly payments - $268 $ 375.00lephone service contract $ 300.00tisc 6260 Insurance Premiums $ 8,000.00 $ 3,500.00 Worker's Comp $ 1,368.00 Director & Officers Liability $ 1,796.00 Commercial Package/Umbrella $ 1,336.00 Add'I insurance coverage 6270 Minor Office Furniture $ 500.00 $ 500.00 Misc.Expenses 6280 Misc. Expenses $ 5,000.00 $ 40.00 Annual Business License/Registration $ 1,200.00 Holiday Luncheons $ 120.00 ACH Payroll processing charge $ 125.00 Staff Holiday Party $ 100.00 Salute to America Lunches $ 3,415.00 Misc. 6300 Office Supplies $ 2,000.00 $ 2,000.00 General Office supplies 6310 Printing and Binding $ 1,200.00 $ 1,200.00 Printing projects and staff materials 6320 Telphone service $ 11,000.00 $ 11,000.00 monthly telephone charges 6330 Training and Education $ 4,100.00 $ 240.00 MACVB - 2 ppl @$120.00 $ 700.00 Gov.'s Conf. on Tourism $ 800.00 JC Chamber leadership program $ 1,860.00 Marketing conferences $ 500.00 Staff training and educational seminars Total Administrative and General Expenses $ 153,616.00 11.79% Marketing Expenses 6285 Promotional Items to sell $ 50,000.00 $ 50,000.00 JC and MSP items to sell 6340 Travel Expenses $ 7,000.00 $ 2,100.00 Local and miscellanous travel $ 1,500.00 Connect Sports $ 1,300.00 Nat'l Assn. of Sports Commissions $ 800.00 Heritage Clubs Internationl $ 700.00 Missouri Governor's Conf on Tourism $ 600.00 MACVB Annual Conference 6520 Tradeshows Fees $ 5,000.00 $ 1,385.00 Heritage Clubs International (Iowa) $ 1,000.00 Southest Tourism Society (virtual) $ 1,000.00 Heartland Travel Showcase (virtual) $ 350.00 Missouri Event Summit (JC) $ 200.00 MSAE Funfest $ 1,065.00 Miscellanous Tradeshows 6360 MSP Misc Expenses $ 9,000.00 $ 9,000.00 Misc tour expenses 6361 MSP Salaries and Wages $ 291,500.00 $ 291,500.00 Salaries, payroll taxes, insur. and ret. 6362 MSP Digital Marketing $ 93,758.00 $ 263.00 Website Hosting (MSP and Museum) $ 20.00 Domain Name Reg (MSP and Museum) $ 9,375.00 Madden Media SEM (monthly expense) $ 1,050.00 Missouri Life -March or April $ 1,700.00 Fort Worth Magazine $ 15,350.00 YouTube March/June and July/Sept $ 5,000.00 Facebook $ 5,000.00 Hustonia $ 6,000.00 St Louis Post Dispatch $ 50,000.00 Discover Channel 6363 MSP Credit Card Fees $ 3,000.00 $ 3,000.00 Based on credit card sales and MSP ticket res. system 6364 MSP Janitorial Services $ 3,877.00 $ 3,877.00 Trash and portable pottie monthly service 6365 MSP Tour Insurance $ 5,650.00 $ 5,650.00 MSP tour insurance 6367 MSP Advertising $ 71,159.50 $ 2,500.00 MSP Brochures $ 5,056.00 Missouri Life Magazine (March -May, June, $ 3,000.00 Show Me Missouri (Mar,June, August, November) $ 1,792.50 Inside Columbia (June -August) $ 7,275.00 KC Magazine (May, June, August, Sept) $ 7,563.00 417 Magazine (April, June ) $ 8,100.00 St Louis Magazine (Mar, May, Sept, Dec) $ 9,737.00 Missouri Travel Guide (January 22 issue) $ 9,894.00 Rural Missouri (April and June) $ 16,242.00 Missouri Vacation Guide (Madden Spring/summer) 6368 MSP Utilities and Lawn Service $ 17,000.00 $ 12,000.00 Monthly utilities $ 5,000.00 Lawn service 6369 MSP Capital Improvements $ - 6370 MSP Museum $ 2,000.00 $ 2,000.00 Museum expensess 6400 Graphic Design $ 8,000.00 $ 8,000.00 Miscellaneous (MSP and CVB projects) 6410 Outdoor Advertising $24,000.00 $ 12,000.00 Porlier January - December $ 12,000.00 DDI January - December 6430 Brochures and Printed Materials $ 9,000.00 $ 9,000.00 Misc. brochures 6440 Postage $ 7,210.00 $ 7,210.00 Monthly postage charges 6461 Marketing Memberships $ 4,290.00 $ 795.00 National Assoc. of Sports Commissions $ 145.00 Missouri Society of Assoc Executives $ 75.00 Missouri Motion Media Association $ 225.00 Missouri Travel Council $ 1,050.00 Missouri Assn. of Convention & Visitors Bureau $ 1,000.00 Missouri Hotel and Lodging Association $ 1,000.00 Misc 6470 Print Advertising $ 49,260.50 $ 1,792.50 Inside Columbia (March-June) $ 3,363.00 417 Magazine (Sept) $ 7,275.00 KC Magazine (April, May, July, August) $ 3,730.00 Feast Magazine (April, June) $ 9,420.00 Select Traveler (April, May, June) $ 13,680.00 Group Travel Leader (April, May, June) $ 10,000.00 Misc 6490 Market Research $ 1,000.00 $ 1,000.00 Survey incentives 6500 Promotion/Publicity $ 9,000.00 $ 4,000.00 Miscellanous (cards, community events) $ 5,000.00 Lunches with meeting planners/business and community leaders 6510 Sponsorships $ 36,000.00 $ 5,000.00 Salute to America $ 31,000.00 Misc Event sponsorships 6530 Familiarization (FAM) Tour Expenses $ 3,000.00 $ 3,000.00 Event/Mtg Planners/Travel Writers visits 6540 Marketing Promo $ 6,000.00 $ 2,000.00 Misc promo items $ 4,000.00 Misc. convention services 6545 Public Relations $ 5,000.00 $ 5,000.00 Misc. services 6550 Digital Marketing $ 36,115.00 $ 280.00 Annual Hosting $ 170.00 Domain name registration $ 1,550.00 Constant Contact Subscription $ 240.00 Facebook (Spring/summer events) $ 400.00 Select Traveler $ 600.00 Group Travel Leader $ 3,150.00 Missouri Life Magazine $ 1,000.00 KC Magazine (April) $ 1,000.00 417 Magazine (April) $ 1,250.00 Facebook - Special events - boosts $ 2,500.00 St. Louis Magazine (April) $ 4,250.00 The Mystery Hour video $ 9,375.00 Madden Media SEM (monthly expense) $ 10,350.00 Facebook (March - June) 6560 Local Promotion $ 4,000.00 $ 4,000.00 Local events 6620 Special Events $ 3,000.00 $ 3,000.00 Misc. events 6630 lAthletic Events Expenses - CVB $ 20,000.00 State Track Expenses $ 9,250.20 JCHS Atkins Staduim - State Track $ 1,275.00 Breakfast for officials - State Track $ 4,300.00 Shuttle service - State Track $ 1,630.00 MSHSAA official rooms $ 800.00 Hospitality (ice) - State Track $ 500.00 Holiday reception $ 2,244.80 Misc. expenses 6640 Athletic Events Committee Expenses $ 12,000.00 $ 600.00 Hospitality refreshment - State Track $ 5,250.00 Lunch for officials - State Track $ 4,600.00 Misc. event sponsorships $ 550.00 Misc. expenses $ 1,000.00 Prison Break Total Marketing Expenses $ 795,820.00 61° Capital Expenses 6700 Office Furniture and Equipment 6710 Computer Hardware $ 3,000.00 Office computer hardware Total Capital Expenses $ 3,000.00 6800 MSP reserve for Preservation Projects $ 104,792.12 Restricted funds for MSP preservation project 5001 Transfer from Reserve ($80,638.12) As needed Total Bureau Expenses $ 1,302,990.00 Acct.# Line Item 2021 Budget Proposed 2022 Budget 2021-2022 Comparison % +/- Revenue 4100 Room Tax $ 482,819.00 $ 492,475.00 $ 9,656.00 2.00% 4200 Interest Earning $ 1,800.00 $ 1,560.00 $ (240.00) -13.33% 4300 MDT MMG/MPD Coop $ 15,000.00 $ 139,815.00 $ 124,815.00 832.10% 4350 Special Events $ 3,500.00 $ 3,500.00 $ - 0.00% 4500 Fundraising Athletic Events Rev $ 10,000.00 $ 10,000.00 $ - 0.00% 4550 Prison Tour Ticket Sales $ 532,000.00 $ 542,640.00 $ 10,640.00 2.00% 4560 MSP Museum Admission $ 26,000.00 $ 26,000.00 $ - 0.00% 4700 Misc Advertising revenue $ 2,000.00 $ 2,000.00 $ - 0.00% 4801 JC Promotional Item Sales $ 79,000.00 $ 80,000.00 $ 1,000.00 1.27% 4900 Miscellaneous Revenue $ 3,000.00 $ 5,000.00 $ 2,000.00 66.67% Total Revenue $ 1,155,119.00 $ 1,302,990.00 $ 147,871.00 12.80% Payroll Expenses 6100 Salaries and Wages $ 242,600.00 $ 270,000.00 $ 27,400.00 14.71% 6120 Retirement Benefits $ 3,400.00 $ 3,900.00 $ 500.00 14.71% 6130 Payroll Taxes $ 20,000.00 $ 21,000.00 $ 1,000.00 5.00% 6140 Insurance Benefits $ 52,000.00 $ 31,500.00 $ (20,500.00) -39.42% Total Payroll Expenses $ 318,000.00 $ 326,400.00 $ 8,400.00 2.64% Administrative and General Expenses 6200 Auditing and Accounting $ 21,630.00 $ 22,725.00 $ 1,095.00 5.06% 6210 Building Rental $ 45,750.00 $ 48,000.00 $ 2,250.00 4.92% 6210 Building Maintenance $ 500.00 $ 500.00 $ - 0.00% 6211 Building Utilities $ 3,200.00 $ 3,000.00 $ (200.00) -40.00% 6212 Cleaning Services $ 3,200.00 $ 3,200.00 $ - 0.00% 6213 Security Monitoring $ 500.00 $ 500.00 $ - 0.00% 6220 Computer Support/Service $ 19,500.00 $ 19,500.00 $ - 0.00% 6230 Consulting $ 500.00 $ 500.00 $ - 0.00% 6240 Dues and Subscriptions $ 2,000.00 $ 2,000.00 $ - 0.00% 6245 Depreciation Expense $ 18,000.00 $ 18,000.00 $ - 0.00% 6250 Office Equip Lease & Repair $ 3,891.00 $ 3,891.00 $ - 0.00% 6260 Insurance Premiums $ 8,700.00 $ 8,000.00 $ (700.00) -8.05% 6270 Minor Office Furniture $ 500.00 $ 500.00 $ - 0.00% 6280 Misc. Expenses $ 5,000.00 $ 5,000.00 $ - 0.00% 6300 Office Supplies $ 2,000.00 $ 2,000.00 $ - 0.00% 6310 Printing and Binding $ 1,200.00 $ 1,200.00 $ - 0.00% 6320 Telephone and Fax $ 11,000.00 $ 11,000.00 $ - 0.00% 6330 Training and Education $ 2,240.00 $ 4,100.00 $ 1,860.00 83.04% Total Administrative and General Expense $ 149,311.00 $ 153,616.00 $ 4,305.00 2.88% Marketing Expenses 6285 Promotional Items to sell $ 50,000.00 $ 50,000.00 $ - 0.00% 6340 Travel Expenses $ 8,400.00 $ 7,000.00 $ (1,400.00)1 16.67% 6360 MSP Tour Expenses $ 9,000.00 $ 9,000.00 $ - 1 0.00% 6361 MSP Salaries and Wages $ 275,500.00 $ 291,500.00 $ 16,000.00 5.81% 6362 MSP Digital Marketing $ 31,658.00 $ 93,758.00 $ 62,100.00 196.16% 6363 MSP Credit Card Fees $ 4,020.00 $ 3,000.00 $ (1,020.00) -25.37% 6364 MSP Janitorial Services $ 3,960.00 $ 3,877.00 $ (83.00) -2.10% 6365 MSP Tour Insurance $ 5,650.00 $ 5,650.00 $ - 0.00% 6367 MSP Advertising $ 34,625.00 $ 71,159.50 $ 36,534.50 646.63% 6368 MSP Utilites and Lawn service $ 17,950.00 $ 17,000.00 $ (950.00) -5.29% 6369 MSP Capital Improvements $ - 6370 MSP Museum $ 2,000.00 $ 2,000.00 $ - 0.00% 6400 Graphic/Creative Design $ 3,000.00 $ 8,000.00 $ 5,000.00 166.67% 6410 Outdoor Advertising $ 30,000.00 $ 24,000.00 $ (6,000.00) -20.00% 6430 Brochures/Printed Material $ 11,000.00 $ 9,000.00 $ (2,000.00) -18.18% 6440 Postage and Freight $ 91000.00 $ 7,210.00 $ (1,790.00) -19.89% 6461 Marketing Memberships $ 5,335.00 $ 4,290.00 $ (1,045.00) -19.59% 6470 Print Advertising $ 21,741.00 $ 49,260.50 $ 27,519.50 126.58% 6490 Market Research $ 1,000.00 $ 1,000.00 $ - 0.00% 6500 Promotion/Publicity $ 5,000.00 $ 9,000.00 $ 4,000.00 80.00% 6510 Sponsorship $ 38,000.00 $ 36,000.00 $ (2,000.00) -5.26% 6520 Tradeshow Fees $ 5,935.00 $ 5,000.00 $ (935.00) -15.75% 6530 Familiarization tour expense $ 3,000.00 $ 3,000.00 $ - 0.00% 6540 Marketing Promo $ 6,000.00 $ 6,000.00 $ - 0.00% 6545 Public Relations $ 5,000.00 $ 5,000.00 $ - 0.00% 6550 Digital Marketing $ 26,380.00 $ 36,115.00 $ 9,735.00 36.90% 6560 Local Promotions $ 5,000.00 $ 4,000.00 $ (1,000.00) -20.00% 6620 Special Events $ 3,000.00 $ 3,000.00 $ - 0.00% 6630 Athletic Events Exp - CVB $ 20,000.00 $ 20,000.00 $ - 0.00% 6640 Athletic Events Committee Exp $ 12,000.00 $ 12,000.00 $ - 0.00% Total Marketing $ 653,154.00 $ 795,820.00 $ 142,666.00 21.84% Contracted Services 6610 lContracted Services & Exp Total Contracted Services Capital Expenses 6710 Computer Hardware $ 3,000.00 $ 3,000.00 $ - Total Capital Expenses $ 3,000.00 $ 3,000.00 $ - 6800 MSP Preservation projects $ 111,767.00 $ 104,792.88 5001 Transfer from Reserve ($80,113) -$80,638.12 Total Bureau Expenses $ 1,155,119.00 $ 1,302,990.76 BILL SUMMARY BILL NO: SPONSOR: Councilman Hensley SUBJECT: Amending the 2021-2022 Budget for Sales Tax H DATE INTRODUCED: DEPARTMENT DIRECTOR(S): Margie Mueller CITY ADMINISTRATOR: Steve Crowell STAFF RECOMMENDATION: Approve SUMMARY: This bill amends the 2021-2022 budget by recognizing the revenues and expenditures for Capital Improvements Sales Tax H. Qualified voters of the City of Jefferson approved the extension of the existing one-half percent city Capital Improvements Sales Tax on August 3, 2021. This tax will become effective April 1, 2022 with an expiration date of March 1, 2027. ORIGIN OF REQUEST: Department of Finance and ITS DEPARTMENT RESPONSIBLE: Department of Finance and ITS PERSON RESPONSIBLE: Margie Mueller BACKGROUND INFORMATION: This is the eighth ieration of the Capital Improvement Plan (CIP) sales tax. Each tax has a five-year sunset. The current CIP sales tax entitled "G" sunsets on March 31, 2022. Sales Tax "H" will become effective April 1, 2022 with an expiration date of March 31, 2027. The revenue generated from Sales Tax H and the projected expenditures from Sales Tax H were not included in the FY2022 adopted budget. Due to the short timeframe between the approval of the ballot measure on August 3, 2021 and the adoption of the FY2022 budget, there was not sufficient time for staff discussion to determine the timing of necessary funding requirements for approved projects. FISCAL INFORMATION: Sales Tax H is estimated to generate $5.6 million per year. This budget amendment is for a half-year ($2,800,000). BILL NO. 2021-xxx SPONSORED BY COUNCILMAN Hensley ORDINANCE NO. AN ORDINANCE OF THE CITY OF JEFFERSON, MISSOURI, AMENDING THE FISCAL YEAR 2022 BUDGET OF THE CITY OF JEFFERSON, MISSOURI, BY APPROPRIATING ADDITIONAL FUNDS WITHIN THE CAPITAL IMPROVEMENTS SALES TAX H 22-27 FUND. BE IT ENACTED BY THE COUNCIL OF THE CITY OF JEFFERSON, MISSOURI, AS FOLLOWS: Section 1. There is hereby a budget amendment within the Capital Improvements Sales Tax H 22-27 Fund in the amount of $2,800,000 as indicated on Exhibit A, attached hereto. Section 2. This Ordinance shall be in full force and effect from and after the date of its passage and approval. Passed: Approved: Presiding Officer ATTEST: Mayor Carrie Tergin APPROVED AS TO FORM: City Clerk City Counselor CERTIFICATION BY MAYOR Pursuant to Article VII, Section 7.1(5.) Of the Charter of the City of Jefferson, Missouri, I hereby certify that the sums appropriated in the ordinance are available in the various funds to meet the requirements of this bill. Mayor Bill 2021-xxx Exhibit A BUDGET AMENDMENT FISCAL YEAR 2021-2022 BUDGET Capital Improvements Sales Tax H 22-27 Fund: Revenue 46-100-400010 Sales Tax $2,800,000 Expenditures Public Works Department: 46-990-577020 City/County Cooperative Projects $550,000 46-990-577031 Overlay Program $690,000 46-990-590070 Transit — Matching Funds $ 45,000 46-990-590075 Airport — Matching Funds $ 45,000 46-990-577106 Miscellaneous Neighborhood Sidewalks $ 60,000 46-990-576007 Stormwater $232,000 46-990-577062 Local Roadway Studies/Grant Matching $ 30,000 Fire Department: 46-990-575007 Available Funds for New Fire Station Number 6 $ 49,295 46-990-575004 Fire Apparatus $222,955 46-990-575002 Fire Equipment Replacement $ 18,750 Police Department: 46-990-575020 Communications Equipment Upgrade $269,000 Parks, Recreation and Forestry Department: 46-990-574003 Trails Replace, Reconstruct, Acquire & Develop $ 61,600 46-990-574027 Recreation Facilities Improvements & Renovation $ 42,000 46-990-574027 Park Building & Grounds Improvements $112,000 46-990-574061 Sie Acquisition & Facility Development $ 33,600 46-990-574062 Playgrounds Development & Replacement $ 30,800 Information Technology/GIS Department: 46-990-578051 Computer Network Equipment & Software $ 56,000 Contingency: 46-990-578063 Contingency $252,000