Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2020-10-22 packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, October 22, 2020 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO — City Council Chambers Virtual Meeting — WebEx Link: https://j effersoncity.webex.com/j effersoncity_/i .php?MTID=m572bfc 1 c86f3 7c75de5fbO3 dddf8O2b9 Call -In Participation Available at: 1-404-397-1516 Meeting Number: 146 0319707 Meeting Password: 1234 TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the July 23, 2020 and September 2, 2020 meetings 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. Update on FEMA & CARES Act Reimbursements — Margie Mueller 8. New Business 9. Old Business 10. Adjournment NOTES Individuals should contact the ADA Coordinator at (5 73) 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, July 23, 2020 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Hensley at 7:30 am. Roll call showed that Councilmen Hensley, Graham, Kemna, Lester, and Councilwoman Wiseman were in attendance. Next the minutes of the May 21, 2020 and June 15, 2020 meetings were reviewed. A motion to approve was made by Councilman Graham and seconded by Councilwoman Wiseman. 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 July 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,206,250. The average monthly amount collected for the 4 Cent Lockbox Fund is $53,703. A report comparing occupancy rates for 2020, 2019, 2018, 2017, 2016, 2015, and 2014 was included along with a report listing occupancy rates from other cities. The next item on the agenda was a presentation by the Fraternal Order of Police. Councilwoman Wiseman left the meeting at 8:35 am. The next item on the agenda was a presentation of Potential City Funding Requests from the CARES Act by City Administrator, Steve Crowell. Mr. Crowell provided a staff report and detailed information on potential projects for CARES Act Funding. Mr. Crowell informed the Committee that this list is of potential requests the City may make of the County, once the County has a program in place to administer the CARES Act Funds. The next item on the agenda was for Dissolution of the High Street TIF presented by Associate City Attorney, Bryan Wolford. The redevelopment plan for the High Street TIF has been completed and the redevelopment projects costs have been paid, so staff is requesting the termination and dissolution of the High Street Tax Increment Financing District. A motion to move this item to the full Council was made by Councilman Graham and seconded by Councilman Lester. The motion was approved unanimously. Under new business, Ms. Mueller informed the Committee that there was a rate study kickoff for Wastewater. She also updated the Committee on the fact that the refmancing of the Build America Bonds, that the Council recently voted on, had received very favorable interest rates and will be saving approximately $1.4M over the remaining life of the bonds. There was no old business to discuss. The meeting adjourned at 9:00 am. As recorded by: Shiela Pearre, Chief Accountant CITY OF JEFFERSON Finance Committee Special Meeting Wednesday, September 2, 2020 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Hensley at 7:30 am. Roll call showed that Councilmen Hensley, Graham, Kemna, Lester, and Councilwoman Wiseman were in attendance. The next item on the agenda was a presentation on Fire Station 4 Rehab by Fire Chief, Matt Schofield. Chief Schofield provided a brief summary on the potential rehab items that staff is interested in and made a request to use the remaining Fire Station 2 funds as seed money to start the bid process on the rehab project. A motion was made by Councilwoman Wiseman and seconded by Councilman Graham to move to full Council the request to reallocate the remaining Fire Station 2 funds to the rehab project. The motion was approved unanimously. There was no new business to discuss. There was no old business to discuss. The meeting adjourned at 7:42 am. As recorded by: Shiela Pearre, Chief Accountant r � • To: Steve Crowell From: Shiela Pearre Date: October 7, 2020 Re: Sales Tax Revenues The City received the October 1% Sales Tax in the amount of $1,020,452 which is $106,237 more than projected for October. January through October overage is $294,796 (2.48%) in the General Fund. 1% General Sales Tax Reporting Receipt Actual Budget Period Period Receipts Projection' Variance Nov -19 Jan -20 $1,049,305 $ 1,053,408 ($4,103) Dec -19 Feb -20 $935,342 $ 907,800 $27,542 7/19 to 12/19 interest distribution adjustment Feb -20 $6,707 $ 0 $6,707 Jan -20 & Oct -Dec 19 Qtrly Mar -20 $1,066,146 $ 1,149,910 ($83,764) Feb -20 Apr -20 $949,276 $ 943,489 $5,786 Mar -20 May -20 $828,799 $ 737,589 $91,210 Apr -20 & Jan -Mar 20 Qtrly Jun -20 $1,093,256 $ 1,098,360 ($5,105) May -20 Jul -20 $1,139,419 $ 1,126,594 $12,825 Jun -20 Aug -20 $912,996 $ 786,630 $126,366 Jul -20 & Apr -June 20 Qtrly Sep -20 $1,222,419 $ 1,217,674 $4,744 7/19 to 12/19 interest distribution adjustment Sep -20 $6,350 $ 0 $6,350 Aug -20 Oct -20 $1,020,452 $ 914,214 $106,237 Sep -20 Nov -20 $ 765,399 Oct -20 & Jul -Sept 20 Qtrly Dec -20 $ 1,173,016 Total Overage/Shortfall $10,230,466 $11,874,085 $294,796 '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 -19 Jan -20 $513,808 $ 443,575 $70,234 Dec -19 Feb -20 $455,062 $ 382,261 $72,801 7/19 to 12/19 interest distribution adjustment Feb -20 $3,262 $ 0 $3,262 Jan -20 & Oct -Dec 19 Qtrly Mar -20 $518,493 $ 484,210 $34,283 Feb -20 Apr -20 $458,553 $ 397,289 $61,264 Mar -20 May -20 $402,202 $ 310,588 $91,614 Apr -20 & Jan -Mar 20 Qtrly Jun -20 $537,105 $ 462,503 $74,602 May -20 Jul -20 $560,720 $ 474,392 $86,328 Jun -20 Aug -20 $443,962 $ 331,238 $112,724 Jul -20 & Apr -June 20 Qtrly Sep -20 $594,392 $ 512,744 $81,648 7/19 to 12/19 interest distribution adjustment Sep -20 $3,097 $ 0 $3,097 Aug -20 Oct -20 $494,618 $ 384,962 $109,656 Sep -20 Nov -20 $ 322,298 Oct -20 & Jul -Sept 20 Qtrly Dec -20 $ 493,939 Total Overage/Shortfall $4,985,275 $5,000,000 $801,513 2Budgeted based on 3 -year average percentage 1/2% Parks Sales Tax Reporting Receipt Actual Budget Period Period Receipts Projection Variance Nov -19 Jan -20 $513,808 $ 502,570 $11,238 Dec -19 Feb -20 $455,062 $ 433,102 $21,960 7/19 to 12/19 interest distribution adjustment Feb -20 $3,262 $ 0 $3,262 Jan -20 & Oct -Dec 19 Qtrly Mar -20 $518,493 $ 548,610 ($30,117) Feb -20 Apr -20 $458,632 $ 450,129 $8,504 Mar -20 May -20 $402,202 $ 351,896 $50,306 Apr -20 & Jan -Mar 20 Qtrly Jun -20 $537,107 $ 524,016 $13,091 May -20 Jul -20 $560,720 $ 537,486 $23,234 Jun -20 Aug -20 $443,965 $ 375,293 $68,672 Jul -20 & Apr -June 20 Qtrly Sep -20 $594,395 $ 580,939 $13,456 7/19 to 12/19 interest distribution adjustment Sep -20 $3,097 $ 0 $3,097 Aug -20 Oct -20 $494,618 $ 436,162 $58,456 Sep -20 Nov -20 $ 365,164 Oct -20 & Jul -Sept 20 Qtrly Dec -20 $ 559,633 Total Overage/Shortfall $4,985,362 $5,665,000 $245,159 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 2020 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 Average Nov January 944,619 929,179 1,083,570 884,259 $1,071,917 1,049,305 act. 982,709 Dec February 727,437 812,670 806,789 927,290 $885,496 942,049 act. 831,936 Jan & Oct -Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 $1,088,631 1,066,146 act. 1,118,582 Feb April 1,059,943 893,024 843,561 986,714 $892,285 949,276 act. 935,106 Mar May 618,854 648,305 687,741 709,248 $731,421 828,799 act. 679,114 Apr & Jan -Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 $1,126,211 1,093,256 act. 1,066,992 May July 963,280 1,012,207 1,154,051 1,117,038 $979,846 1,139,419 act. 1,045,284 Jun August 562,996 661,518 678,636 821,132 $770,155 912,996 act. 698,887 Jul & Apr -Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 $1,262,838 1,228,769 act. 1,183,950 Aug October 918,839 903,829 883,215 879,331 $875,539 1,020,452 act. 892,151 Sept November 661,849 623,645 615,667 774,337 $818,656 765,399 est. 698,831 Oct & Jul -Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 $1,008,620 1,173,016 est. 1,095,442 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 $ 11,511,614 10,230,466 Estimated to Fiscal Year end (based on averages and on Budgeted amount) 1,938,415 Total Actual & Estimated $ 12,168,881 Less: Budget 11,874,085 Over (Under) Budget $ 294,796 $ 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 Printed 10/7/2020 -Actual -Budget $ 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- Feb Mar Apr & Jan- May Jun Jul & Apr -Jun Aug Sept Oct & Jul - Dec Qtrly Mar Qtrly Qtrly Sept Qtrly REPORTING PERIOD 100,000 tActual -w-Budget Printed 10/7/2020 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Rate: One -Half percent (%%) Receipt Month: OCTOBER 2020 Account Number 45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 Average Nov January 461,560 455,278 525,521 424,160 $525,696 513,808 act. 478,443 Dec February 362,597 405,543 402,964 444,476 $427,711 458,324 act. 408,658 Jan & Oct -Dec Qtrly March 511,685 563,056 506,597 575,894 $527,714 518,493 act. 536,989 Feb April 512,808 431,353 411,020 455,943 $430,468 458,553 act. 448,318 Mar May 308,247 322,957 340,162 340,740 $351,775 402,202 act. 332,776 Apr & Jan -Mar Qtrly June 496,466 539,529 489,008 508,225 $554,062 537,105 act. 517,458 May July 473,120 498,229 559,119 548,625 $481,405 560,720 act. 512,100 Jun August 280,733 330,112 338,618 393,512 $372,416 443,962 act. 343,078 Jul & Apr -Jun Qtrly September 565,296 570,134 542,457 545,731 $615,998 597,489 act. 567,923 Aug October 442,371 435,416 425,493 423,478 $421,199 494,618 act. 429,591 Sept November 330,393 310,506 307,281 374,512 $395,311 322,298 est. 343,601 Oct & Jul -Sept Qtrly December 515,478 494,218 652,070 510,228 $495,454 493,939 est. 533,490 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 $ 5,599,211 4,985,275 Estimated to Fiscal Year end (based on averages and on Budgeted amount) 816,238 Total Actual & Estimated $ 5,801,513 Less: Budget 5,000,000 Over (Under) Budget $ 801,513 $ 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- Feb Mar Apr & Jan- May Jun Jul & Apr -Jun Aug Sept Oct & Jul - Dec Qtrly Mar Qtrly Qtrly Sept Qtrly REPORTING PERIOD 100,000 tActual -w-Budget Printed 10/7/2020 Account Name Parks Sales Tax Account Number 21-210-400010 City of Jefferson, Mo. - Account Analysis Rate: One -Half percent (%%) Receipt Month: OCTOBER 2020 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 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 Qtrly 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 act. 478,423 395,217 450,479 $427,689 458,324 act. 408,260 506,524 577,148 $527,588 518,493 act. 537,176 411,020 457,060 $430,459 458,632 act. 448,526 340,162 340,708 $350,479 402,202 act. 332,467 489,008 508,266 $554,065 537,107 act. 517,451 559,115 548,639 $481,406 560,720 act. 512,085 338,470 393,578 $372,405 443,965 act. 343,015 542,457 545,842 $616,012 597,492 act. 568,475 425,497 423,387 $421,199 494,618 act. 429,574 307,305 374,484 $395,311 365,164 est. 343,600 652,101 510,220 $495,452 559,633 est. 533,472 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 $ 5,597,755 4,985,362 Estimated to Fiscal Year end (based on averages and on Budgeted amount) 924,797 Total Actual & Estimated $ 5,910,159 Less: Budget 5,665,000 Over (Under) Budget $ 245,159 $ 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- Feb Mar Apr & Jan- May Jun Jul & Apr -Jun Aug Sept Oct & Jul - Dec Qtrly Mar Qtrly Qtrly Sept Qtrly REPORTING PERIOD -Actual -Budget Printed 10/7/2020 Revenue Model Report For the Period Ending September 30, 2020 Data as of October 8, 2020 FY 2020 YTD Actual Projected Over/ Description Budget As of 10/8/20 (Under) Budget Sales Tax and Use Tax $11,874,085.20 $10,230,466.25 $294,796.01 Intergovernmental Taxes $2,322,500.00 $1,833,530.34 ($46,446.69) Other Taxes $106,000.00 $80,119.28 ($7,990.98) Franchise & Utility Tax $7,205,000.00 $5,235,592.98 ($803,497.50) Property Taxes $5,466,399.00 $5,565,952.71 $116,042.46 Intergovernmental $2,925.00 $171,024.79 $168,099.79 Charges for Services $2,875,130.04 $2,714,786.34 $10,927.94 Fees, Licenses, & Permits $902,520.00 $1,149,466.41 $297,124.94 Fines & Forfeitures $766,600.00 $384,869.41 ($319,319.66) Contributions/Donations $342,659.56 $225,539.53 $20,778.47 Other Operating Revenues $220,102.76 $170,657.37 ($17,072.75) Interest Income $160,002.04 $103,675.41 ($41,499.01) Other Non Operating Revenue $55,000.00 $45,752.46 $10,752.46 Operating Transfers In $26,000.00 $18,522.86 ($3,039.09) Totals $32,324,923.60 $27,929,956.14 ($320,343.61) FY2020 Admin Charge Backs or $1,555,757.00 $1,555,757.00 $0.00 $1,555,757.00 $0.00 $0.00 Revenue Model Report (Detail) $25,000.00 $25,000.00 Remaining $25,000.00 $0.00 $0.00 For the Period Ending September 30, 2020 $27,000.00 YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification 10-100-440910 Description Budget As of 10/8/20 As of 10/8/20 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax Parts Charge backs $244,000.00 $214,293.13 $34,846.62 $249,139.75 $5,139.75 10-100-400010 Sales Tax $11,874,085.20 $10,217,409.31 $1,938,414.96 $12,155,824.27 $281,739.07 $281,739.07 10-100-400020 Sales Tax Interest $0.00 $13,056.94 $0.00 $13,056.94 $13,056.94 $13,056.94 $0.03 10-100-481030 $11,874,085.20 $10,230,466.25 $1,938,414.96 $12,168,881.21 $294,796.01 $294,796.01 Intergovernmental Taxes Rent Other $12,000.00 $800.00 $12,000.00 $12,800.00 $800.00 10-100-401030 Motor Vehicle Sales Tax $591,500.00 $438,171.56 $142,259.34 $580,430.90 ($11,069.10) ($11,069.10) 10-100-403010 Gasoline Tax $1,161,000.00 $805,944.99 $300,263.63 $1,106,208.62 ($54,791.38) ($54,791.38) 10-100-430080 Road & Bridge Tax $570,000.00 $589,413.79 $0.00 $589,413.79 $19,413.79 $19,413.79 ($48.07) 10-100-481080 $2,322,500.00 $1,833,530.34 $442,522.97 $2,276,053.31 ($46,446.69) ($46,446.69) Other Taxes 10-100-481085 Cole Cty GIS Joint Coop $16,850.00 $13,750.00 $3,100.00 $16,850.00 $0.00 -100-403020 Cig Tax. $106,000.00 $80,119.28 $17,889.74 $98,009.02 ($7,990.98) ($7,990.98) ($2,694.88) 10-100-481105 $106,000.00 $80,119.28 $17,889.74 _ $98,009.02 + ($7,990.98) ($7,990.98) Franchise & Utility Tax Long & Short $0.00 $10.35 $0.00 $10.35 $10.35 10-100-410020 Electric Utility Lic Tax $4,100,000.00 $3,080,386.36 $722,115.44 $3,802,501.80 ($297,498.20) ($297,498.20) 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 $950,000.00 $725,450.36 $73,253.73 $798,704.09 ($151,295.91) ($151,295.91) 10-100-410052 Telephone/Cell Utility $1,800,000.00 $1,201,195.76 $292,161.80 $1,493,357.56 ($306,642.44) ($306,642.44) 10-100-410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-410060 Cable Franchise Fee $355,000.00 $228,560.50 $78,378.54 $306,939.04 ($48,060.96) ($48,060.96) 10-100-450041 Abandoned Bldg. Admin Fee $7,205,000.00 $5,235,592.98 $1,165,909.52 $6,401,502.50 ($803,497.50) ($803,497.50) Property Taxes Building Construct. Fees $260,000.00 $533,050.84 $18,644.44 $551,695.28 $291,695.28 $291,695.28 10-100-420010 Current Property Tax $4,790,000.00 $4,871,022.42 $3,371.42 $4,874,393.84 $84,393.84 $84,393.84 10-100-420020 Del Property Tax $45,000.00 $53,430.93 ($420.71) $53,010.22 $8,010.22 $8,010.22 10-100-420040 Fin Institution Tax $33,000.00 $29,796.21 $0.00 $29,796.21 ($3,203.79) ($3,203.79) 10-100-420050 Prop Tax Int & Penalties $29,000.00 $27,798.62 $1,685.76 $29,484.38 $484.38 $484.38 10-100-420055 Surtax Receipts - CountyReimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10-100-420060 Surtax Receipts $467,000.00 $473,453.33 $1,176.08 $474,629.41 $7,629.41 $7,629.41 10-100-420080 Special Tax Rev $48,000.00 $56,051.92 $10,676.21 $66,728.13 $18,728.13 $18,728.13 $5,466,399.00 $5,565,952.71 $16,488.75 $5,582,441.46 $116,042.46 $116,042.46 Intergovernmental 10-100-430010 Federal Grant $0.00 $41,777.49 $0.00 $41,777.49 $41,777.49 $41,777.49 10-100-430040 Local Grant $2,925.00 $2,925.00 $0.00 $2,925.00 $0.00 $0.00 10-100-430060 Drug Forfeiture $0.00 $69,224.92 $0.00 $69,224.92 $69,224.92 $69,224.92 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 $57,097.38 $0.00 $57,097.38 $57,097.38 $5ZO97.38 $2,925.00 $171,024.79 $0.00 $171,024.79 $168,099.79 $168,099.79 Charges for Services 10-100-440010 Admin Charge Backs or $1,555,757.00 $1,555,757.00 $0.00 $1,555,757.00 $0.00 $0.00 10-100-440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10-100-440210 Street Cuts $27,000.00 $36,009.00 $2,662.84 $38,671.84 $11,671.84 $11,671.84 10-100-440910 Fuel Charge - backs $12,000.00 $6,550.37 $1,319.74 $7,870.11 ($4,129.89) ($4,129.89) 10-100-440920 Parts Charge backs $244,000.00 $214,293.13 $34,846.62 $249,139.75 $5,139.75 $5,139.75 10-100-440930 Labor Charge backs $275,000.00 $204,821.27 $43,534.83 $248,356.10 ($26,643.90) ($26,643.90) 10-100-481020 Cole Cty Animal Rescue $112,229.12 $84,171.87 $28,057.28 $112,229.15 $0.03 $0.03 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 $800.00 $12,000.00 $12,800.00 $800.00 $800.00 10-100-481045 Rent -tower Sites $156,000.00 $179,776.31 $3,036.40 $182,812.71 $26,812.71 $26,812.71 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 $389,991.81 $357,366.92 $32,576.82 $389,943.74 ($48.07) ($48.07) 10-100-481080 Sale Of Maps/GIS Data $0.00 $10.00 $0.00 $10.00 $10.00 $10.00 10-100-481085 Cole Cty GIS Joint Coop $16,850.00 $13,750.00 $3,100.00 $16,850.00 $0.00 $0.00 10-100-481100 Sale Of Grave Sites $4,500.00 $1,668.00 $137.12 $1,805.12 ($2,694.88) ($2,694.88) 10-100-481105 TIF Administration Fee $19,802.11 $9,802.12 $10,000.00 $19,802.12 $0.01 $0.01 10-100-481110 Long & Short $0.00 $10.35 $0.00 $10.35 $10.35 $10.35 $2,875,130.04 $2,714,786.34 $171,271.64 $2,886,057.98 $10,927.94 $10,927.94 Fees, Licenses, & Permits 10-100-450010 Liquor Licenses $68,000.00 $71,675.42 $1,082.16 $72,757.58 $4,757.58 $4,757.58 10-100-450020 Business Licenses $215,000.00 $213,908.39 $6,642.52 $220,550.91 $5,550.91 $5,550.91 10-100-450021 Home Occupation Permit $2,000.00 $2,035.00 $161.43 $2,196.43 $196.43 $196.43 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 ($418.00) $666.67 $248.67 ($7,751.33) ($7,751.33) 10-100-450045 Building Construct. Fees $260,000.00 $533,050.84 $18,644.44 $551,695.28 $291,695.28 $291,695.28 10-100-450050 Electrical Certificates $22,000.00 $20,808.00 $560.07 $21,368.07 ($631.93) ($631.93) 10-100-450060 Electrical Permits $4,000.00 $9,530.80 $448.19 $9,978.99 $5,978.99 $5,978.99 10-100-450070 Plumbing Licenses $12,000.00 $11,295.00 $245.88 $11,540.88 ($459.12) ($459.12) 10-100-450080 Plumbing Permits $5,800.00 $8,282.50 $1,125.54 $9,408.04 $3,608.04 $3,608.04 FY2020 Revenue Model Report (Detail) Remaining For the Period Ending September 30, 2020 YTD Actual Estimated Revenues Actual & Estimated Projected Over/ Verification Description Budget As of 10/8/20 As of 10/8/20 TOTAL (Under) Budget of Formulas 10-100-450090 Other Lic & Permits $2,000.00 $824.00 $597.55 $1,421.55 ($578.45) ($578.45) 10-100-450091 Day Care Inspection Fees $7,300.00 $5,195.00 $292.59 $5,487.59 ($1,812.41) ($1,812.41) 10-100-450092 Food Inspection Fees $87,550.00 $90,431.95 ($2,195.62) $88,236.33 $686.33 $686.33 10-100-450100 Curb Cut Permits $850.00 $2,355.00 $166.36 $2,521.36 $1,671.36 $1,671.36 10-100-450110 Board Of Adj Fees $3,770.00 $2,800.00 $361.14 $3,161.14 ($608.86) ($608.86) 10-100-450120 Sign Permits $6,300.00 $6,444.00 $753.12 $7,197.12 $897.12 $897.12 10-100-450130 Demolition Permits $1,600.00 $6,500.00 $306.88 $6,806.88 $5,206.88 $5,206.88 10-100-450150 Acc Rep Fees -police $11,500.00 $6,578.80 $1,044.25 $7,623.05 ($3,876.95) ($3,876.95) 10-100-450160 Accrpt/blastg P -fire $1,050.00 $440.31 $2.03 $442.34 ($607.66) ($607.66) 10-100-450170 Animal Redemption Fees $108,000.00 $87,309.60 $13,066.44 $100,376.04 ($7,623.96) ($7,623.96) 10-100-450180 Animal Vaccinations Fees $5,200.00 $3,800.00 $578.72 $4,378.72 ($821.28) ($821.28) 10-100-450185 Animal Cremation Fees $45,000.00 $47,941.00 $3,795.09 $51,736.09 $6,736.09 $6,736.09 10-100-450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-450190 Taxi Permits $0.00 $27.00 $0.00 $27.00 $27.00 $27.00 10-100-450230 Vacating Right Of Way $800.00 $816.00 $36.96 $852.96 $52.96 $52.96 10-100-450250 Rezoning Request $0.00 $720.00 $0.00 $720.00 $720.00 $720.00 10-100-450255 Planning & Zoning Review Fees $23,000.00 $15,925.80 $1,653.06 $17,578.86 ($5,421.14) ($5,421.14) 10-100-450260 Non-refundable Plans/spec $1,800.00 $1,190.00 $143.06 $1,333.06 466.94 466.94 $902,520.00 $1,149,466.41 $50,178.53 $1,199,644.94 $297,124.94 $297,124.94 Fines & Forfeitures 10-100-460010 Court Cost $69,000.00 $33,633.75 $6,380.39 $40,014.14 ($28,985.86) ($28,985.86) 10-100-460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10-100-460018 Inmate Security Fund $11,500.00 $5,612.58 $1,049.39 $6,661.97 ($4,838.03) ($4,838.03) 10-100-460020 Jail Cost Recovery $1,500.00 $272.81 $170.93 $443.74 ($1,056.26) ($1,056.26) 10-100-460025 Alcohol Offense Cost Rec $4,200.00 $5,035.39 $516.01 $5,551.40 $1,351.40 $1,351.40 10-100-460030 Pol Fines -traffic $630,000.00 $330,464.54 $52,836.04 $383,300.58 ($246,699.42) ($246,699.42) 10-100-460090 Parking Fines $54,000.00 $16,572.50 $2,009.95 $18,582.45 ($35,417.55) ($35,417.55) 10-100-460100 Bankcard Charges ($3,600.00) ($6,722.16) 551.77 ($7,273.93) ($3,673.93) ($3,673.93) $766,600.00 $384,869.41 $62,410.93 $447,280.34 ($319,319.66) ($319,319.66) Contributions/Donations 10-100-480055 1C Fire Museum $0.00 $0.00 $0.00 $0.00 IV $O.OIiW $0.00 10-100-480070 Community Projects Donations $9,615.56 $15,153.05 $0.00 $15,153.05 $5,537.49 $5,537.49 10-100-480080 Dare Donations $450.00 $450.00 $0.00 $450.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 $0.00 $17,893.11 $0.00 $17,893.11 $17,893.11 $17,893.11 10-100-481055 Street Repair -Solid Waste Cntr $331,594.00 $191,043.37 $137,898.50 $328,941.87 ($2,652.13) ($2,652.13) 10-100-481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $342,659.56 $225,539.53 $137,898.50 $363,438.03 $20,778.47 $20,778.47 Other Operating Revenues 10-100-480010 Citizen Participation $0.00 $322.57 $0.00 $322.57 $322.57 $322.57 10-100-480011 Police Evidence Funds $0.00 $65,581.18 $0.00 $65,581.18 $65,581.18 $65,581.18 10-100-481070 Miscellaneous $53,000.00 $65,934.94 $4,510.59 $70,445.53 $17,445.53 $17,445.53 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 $19,000.00 $12,516.01 $2,998.65 $15,514.66 ($3,485.34) ($3,485.34) 10-100-481077 Insurance Claims $138,102.76 $26,302.67 $14,863.39 $41,166.06 ($96,936.70) ($96,936.70) 10-100-481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $220,102.76 $170,657.37 $32,372.64 $203,030.01 ($17,072.75) ($17,072.75) Interest Income 10-100-470010 nterest $160.002.04 $103,675.41 $14,827.62 $118,503.03 ($41,499.01) ($41,499.01) $160,002.04 $103,675.41 $14,827.62 $118,503.03 ($41,499.01) ($41,499.01) Other Non Operating Revenue_ 10-100-485050 Sale Of Assets $55,000.00 $38,594.46 $20,000.00 $58,594.46 $3,594.46 $3,594.46 10-100-486020 Capital Contribution -Developer $0.00 $7,158.00 $0.00 $7,158.00 $7,158.00 $7,158.00 $55,000.00 $45,752.46 $20,000.00 $65,752.46 $10,752.46 $10,752.46 Operating Transfers In 10-100-490240 Trsfr From Lodging Tax $26,000.00 $18,522.86 $4,438.05 $22,960.91 ($3,039.09) ($3,039.09) 10-100-490630 Transfer from Self Funded HlthIns $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,000.00 $18,522.86 $4,438.05 $22,960.91 ($3,039.09) ($3,039.09) $32,324,923.60 $27,929,956.14 $4,074,623.85 $32,004,579.99 ($320,343.61) ($320,343.61) General Ledger Trial Balance by Acct Type and Full Acct Number User: mmueller Printed: 10/05/20 09:19:38 Period 01 - 11 Fiscal Year 2020 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,750.00 0.00 5,175.00 7.85 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) 13,934.05 5,525.57 0.00 8,408.48 60.34 10-110-502010 Social Security 8,786.71 7,060.79 0.00 1,725.92 19.64 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 123,717.27 105,491.21 0.00 18,226.06 14.73 10-110-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-110-511020 Postage 70.00 17.25 0.00 52.75 75.36 10-110-512010 Printing 325.00 295.00 0.00 30.00 9.23 10-110-512020 Copies 30.00 8.69 0.00 21.31 71.03 10-110-513010 Office Supplies 695.00 672.73 0.00 22.27 3.20 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 1,120.00 993.67 0.00 126.33 11.28 10-110-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-110-520025 Security 890.00 559.44 0.00 330.56 37.14 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,939.84 1,789.67 0.00 150.17 7.74 10-110-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-110-529010 Special Events 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,729.84 7,057.01 0.00 672.83 8.70 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 88.00 81.84 0.00 6.16 7.00 E25 Repairs & Maintenance 88.00 81.84 0.00 6.16 7.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 1 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-110-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 110 Mayor & Council 132,655. L 1 113,623.73 0.00 19,031.38 14.35 120 City Clerk 10-120-501020 Salaries 49,774.86 44,246.66 0.00 5,528.20 11.11 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,807.78 3,022.23 0.00 785.55 20.63 10-120-502020 Group Health Insurance 11,509.33 9,804.99 0.00 1,704.34 14.81 10-120-502030 Retirement 6,072.53 5,398.16 0.00 674.37 11.11 10-120-502040 Workers Compensation 49.99 49.99 0.00 0.00 0.00 10-120-502050 Life Insurance 59.98 52.63 0.00 7.35 12.25 10-120-502060 Long Term Disability 149.33 130.95 0.00 18.38 12.31 10-120-502070 Employee Assistance Prgm 28.06 20.15 0.00 7.91 28.19 E05 Personnel Services 71,451.86 62,725.76 0.00 8,726.10 12.21 10-120-511020 Postage 200.00 168.76 0.00 31.24 15.62 10-120-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-120-512020 Copies 300.00 267.00 0.00 33.00 11.00 10-120-513010 Office Supplies 200.00 122.88 0.00 77.12 38.56 10-120-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 700.00 558.64 0.00 141.36 20.19 10-120-520030 Dues And Publications 75.00 65.00 0.00 10.00 13.33 10-120-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-120-520070 Training And Education 400.00 350.00 0.00 50.00 12.50 10-120-522020 Professional Services 200.00 179.53 0.00 20.47 10.24 10-120-529030 Election Expense 18,579.79 25,496.42 0.00 -6,916.63 -37.23 E15 Contractual Services 19,254.79 26,090.95 0.00 -6,836.16 -35.50 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 4,228.00 9,563.48 0.00 -5,335.48 -126.19 E25 Repairs & Maintenance 4,228.00 9,563.48 0.00 -5,335.48 -126.19 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 95,634.65 98,938.83 0.00 -3,304.18 -3.46 140 City Administrator 10-140-501020 Salaries 215,571.09 181,920.09 0.00 33,651.00 15.61 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/05/2020 - 9:19 AM) 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 16,491.19 12,050.42 0.00 4,440.77 26.93 10-140-502020 Group Health Insurance 22,787.32 19,340.88 0.00 3,446.44 15.12 10-140-502030 Retirement 26,299.67 22,194.30 0.00 4,105.37 15.61 10-140-502040 Workers Compensation 201.21 201.21 0.00 0.00 0.00 10-140-502050 Life Insurance 107.71 93.96 0.00 13.75 12.77 10-140-502060 Long Term Disability 267.81 233.03 0.00 34.78 12.99 10-140-502070 Employee Assistance Prgm 56.12 40.31 0.00 15.81 28.17 E05 Personnel Services 281,782.12 236,074.20 0.00 45,707.92 16.22 10-140-511010 Advertising 45.00 0.00 0.00 45.00 100.00 10-140-511020 Postage 150.00 59.95 0.00 90.05 60.03 10-140-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-140-512020 Copies 150.00 49.93 0.00 100.07 66.71 10-140-513010 Office Supplies 595.00 239.53 0.00 355.47 59.74 10-140-514017 COVID-19 0.00 2,654.78 0.00 -2,654.78 0.00 10-140-517010 Operational Supplies 678.74 0.00 0.00 678.74 100.00 E10 Materials & Supplies 1,718.74 3,004.19 0.00 -1,285.45 -74.79 10-140-520030 Dues And Publications 700.00 433.70 0.00 266.30 38.04 10-140-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-140-520070 Training And Education 2,110.00 2,102.00 0.00 8.00 0.38 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 76.64 0.00 323.36 80.84 E15 Contractual Services 3,210.00 2,612.34 0.00 597.66 18.62 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 268.00 266.64 0.00 1.36 0.51 E25 Repairs & Maintenance 268.00 266.64 0.00 1.36 0.51 10-140-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 140 City Administrator 286,978.86 241,957.37 0.00 45,021.49 15.69 149 Entitlement Grant 10-149-501020 Salaries 60,104.36 51,233.88 0.00 8,870.48 14.76 10-149-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-149-502010 Social Security 3,373.98 3,468.44 0.00 -94.46 -2.80 10-149-502020 Group Health Insurance 14,611.44 12,935.10 0.00 1,676.34 11.47 10-149-502030 Retirement 5,380.73 4,874.60 0.00 506.13 9.41 10-149-502040 Workers Compensation 87.03 87.03 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 3 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-149-502050 Life Insurance 53.24 60.84 0.00 -7.60 -14.27 10-149-502060 Long Term Disability 131.82 151.65 0.00 -19.83 -15.04 10-149-502070 Employee Assistance Program 28.06 20.15 0.00 7.91 28.19 E05 Personnel Services 83,770.66 72,831.69 0.00 10,938.97 13.06 10-149-511010 Advertising 1,884.50 2,060.00 0.00 -175.50 -9.31 10-149-511020 Postage 500.00 329.00 0.00 171.00 34.20 10-149-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-149-513010 Office Supplies 1,000.00 267.00 0.00 733.00 73.30 10-149-517010 Operational Supplies 525.00 0.00 0.00 525.00 100.00 E10 Materials & Supplies 3,909.50 2,656.00 0.00 1,253.50 32.06 10-149-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-149-520070 Training And Education 1,615.50 37.35 0.00 1,578.15 97.69 10-149-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-149-528010 Housing Rehabilitation 0.00 0.00 0.00 0.00 0.00 10-149-528011 Housing Rehab -Code Deficiency 31,100.00 31,253.50 0.00 -153.50 -0.49 10-149-528012 Housing Rehab -Energy Efficient 20,900.00 0.00 0.00 20,900.00 100.00 10-149-528020 Housing Assistance 131,600.00 132,615.00 0.00 -1,015.00 -0.77 10-149-528030 Public Improvement 319,774.25 131,486.17 2,645.83 185,642.25 58.05 10-149-528040 Neighborhood Redevelopmnt 100,000.00 14,000.00 21,100.00 64,900.00 64.90 10-149-528050 Neighborhood Facility 0.00 0.00 0.00 0.00 0.00 10-149-528060 Economic Development 0.00 0.00 0.00 0.00 0.00 10-149-528070 Emergency Assistance 5,000.00 0.00 0.00 5,000.00 100.00 10-149-528080 Homeless Objectives 13,322.83 0.00 0.00 13,322.83 100.00 E15 Contractual Services 623,312.58 309,392.02 23,745.83 290,174.73 46.55 10-149-547020 Maintenance Agreements 150.00 117.12 10.65 22.23 14.82 E25 Repairs & Maintenance 150.00 117.12 10.65 22.23 14.82 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 711,142.74 384,996.83 23,756.48 302,389.43 42.52 150 City Attorney 10-150-501020 Salaries 213,931.99 184,788.05 0.00 29,143.94 13.62 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,365.80 13,346.74 0.00 3,019.06 18.45 10-150-502020 Groun Health Insurance 34.764.83 27.282.43 0.00 7.482.40 21.52 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 4 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-150-502030 Retirement 26,099.70 20,846.52 0.00 5,253.18 20.13 10-150-502040 Workers Compensation 230.79 230.79 0.00 0.00 0.00 10-150-502050 Life Insurance 257.04 209.01 0.00 48.03 18.69 10-150-502060 Long Term Disability 445.29 448.47 0.00 -3.18 -0.71 10-150-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-150-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 292,179.62 247,212.50 0.00 44,967.12 15.39 10-150-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-150-511020 Postage 500.00 162.95 0.00 337.05 67.41 10-150-512010 Printing 300.00 271.88 0.00 28.12 9.37 10-150-512020 Copies 50.00 9.60 0.00 40.40 80.80 10-150-513010 Office Supplies 2,800.00 1,229.46 0.00 1,570.54 56.09 10-150-514017 COVID-19 0.00 2,024.60 0.00 -2,024.60 0.00 10-150-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 3,650.00 3,698.49 0.00 -48.49 -1.33 10-150-520020 Auditing Travel Expense 0.00 0.00 0.00 0.00 0.00 10-150-520030 Dues And Publications 11,200.00 6,685.86 2,483.58 2,030.56 18.13 10-150-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-150-520070 Training And Education 5,000.00 330.00 0.00 4,670.00 93.40 10-150-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-150-520095 Relocation Fees 0.00 0.00 0.00 0.00 0.00 10-150-521010 Malpractice Insurance 0.00 0.00 0.00 0.00 0.00 10-150-522020 Professional Services 24,000.00 13,186.28 0.00 10,813.72 45.06 10-150-525030 Litigation Expenses 500.00 220.00 0.00 280.00 56.00 E15 Contractual Services 40,700.00 20,422.14 2,483.58 17,794.28 43.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 568.00 322.01 0.00 245.99 43.31 E25 Repairs & Maintenance 568.00 322.01 0.00 245.99 43.31 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 337,097.62 271,655.14 2,483.58 62,958.90 18.68 160 Municipal Court 10-160-501010 Salary -elected Officals 34,999.92 32,083.26 0.00 2,916.66 8.33 10-160-501020 Salaries 120,182.91 104,603.56 0.00 15,579.35 12.96 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 5,420.60 0.00 1,579.40 22.56 10-160-501090 Overtime 1,500.00 872.03 0.00 627.97 41.86 10-160-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-160-502010 Social Securitv 12.521.74 10.548.10 0.00 1.973.64 15.76 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 5 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-160-502020 Group Health Insurance 30,420.85 20,886.16 0.00 9,534.69 31.34 10-160-502030 Retirement 14,845.31 9,218.11 0.00 5,627.20 37.91 10-160-502040 Workers Compensation 198.17 198.17 0.00 0.00 0.00 10-160-502050 Life Insurance 146.88 118.91 0.00 27.97 19.04 10-160-502060 Long Term Disability 360.59 292.76 0.00 67.83 18.81 10-160-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-160-503020 Unemployment Compensation 0.00 67.83 0.00 -67.83 0.00 E05 Personnel Services 222,260.55 184,369.98 0.00 37,890.57 17.05 10-160-511010 Advertising 50.00 50.00 0.00 0.00 0.00 10-160-511020 Postage 3,550.00 2,138.45 0.00 1,411.55 39.76 10-160-512010 Printing 443.77 308.00 0.00 135.77 30.59 10-160-512020 Copies 0.07 0.07 0.00 0.00 0.00 10-160-513010 Office Supplies 5,250.00 1,433.50 0.00 3,816.50 72.70 10-160-514017 COVID-19 0.00 341.55 0.00 -341.55 0.00 E10 Materials & Supplies 9,293.84 4,271.57 0.00 5,022.27 54.04 10-160-520025 Security 10,000.00 7,759.66 0.00 2,240.34 22.40 10-160-520030 Dues And Publications 250.00 120.00 0.00 130.00 52.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 300.00 0.00 1,200.00 80.00 10-160-522020 Professional Services 11,420.00 2,973.86 439.41 8,006.73 70.11 10-160-525005 Appointed Counsel 4,000.00 2,677.32 0.00 1,322.68 33.07 10-160-525010 Care Of Prisoners 250.00 0.00 0.00 250.00 100.00 10-160-525030 Litigation Expenses 40.00 0.00 0.00 40.00 100.00 E15 Contractual Services 27,460.00 13,830.84 439.41 13,189.75 48.03 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 2,388.00 5,495.96 0.00 -3,107.96 -130.15 E25 Repairs & Maintenance 2,388.00 5,495.96 0.00 -3,107.96 -130.15 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 261,402.39 207,968.35 439.41 52,994.63 20.27 170 Human Resources 10-170-501020 Salaries 212,474.64 188,801.07 0.00 23,673.57 11.14 10-170-501050 Parttime(wo Benefits) 13,000.00 13,717.43 0.00 -717.43 -5.52 10-170-501060 Seasonal Salaries 20,000.00 0.00 0.00 20,000.00 100.00 10-170-501090 Overtime 100.00 0.00 0.00 100.00 100.00 10-170-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-170-502010 Social Security 18,786.46 15,216.47 0.00 3,569.99 19.00 10-170-502020 Group Health Insurance 26,241.76 22,240.52 0.00 4,001.24 15.25 10-170-502030 Retirement 25.934.11 23.033.83 0.00 2.900.28 11.18 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 6 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-170-502040 Workers Compensation 325.69 325.69 0.00 0.00 0.00 10-170-502050 Life Insurance 255.82 224.20 0.00 31.62 12.36 10-170-502060 Long Term Disability 554.47 482.61 0.00 71.86 12.96 10-170-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-170-503020 Unemployment Compensation 0.00 162.00 0.00 -162.00 0.00 E05 Personnel Services 317,757.13 264,264.31 0.00 53,492.82 16.83 10-170-511010 Advertising 0.00 49.00 0.00 -49.00 0.00 10-170-511020 Postage 150.00 515.75 0.00 -365.75 -243.83 10-170-512010 Printing 740.00 0.00 0.00 740.00 100.00 10-170-512020 Copies 500.00 469.13 0.00 30.87 6.17 10-170-513010 Office Supplies 1,000.00 181.51 0.00 818.49 81.85 10-170-514017 COVID-19 0.00 4,789.00 0.00 -4,789.00 0.00 10-170-517010 Operational Supplies 800.00 81.30 0.00 718.70 89.84 E10 Materials & Supplies 3,190.00 6,085.69 0.00 -2,895.69 -90.77 10-170-520030 Dues And Publications 1,000.00 452.00 0.00 548.00 54.80 10-170-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-170-520060 Wellness Program 3,500.00 1,430.95 0.00 2,069.05 59.12 10-170-520070 Training And Education 5,220.00 3,787.80 0.00 1,432.20 27.44 10-170-520080 Tuition Reimbursement 3,690.00 100.00 0.00 3,590.00 97.29 10-170-521060 Drugalcohol Screening 0.00 0.00 0.00 0.00 0.00 10-170-521065 Background Checks 500.00 140.00 0.00 360.00 72.00 10-170-522020 Professional Services 4,000.00 1,191.30 0.00 2,808.70 70.22 10-170-529010 Special Events 800.00 294.13 0.00 505.87 63.23 10-170-529015 Human Relations Commission 500.00 420.00 0.00 80.00 16.00 E15 Contractual Services 19,210.00 7,816.18 0.00 11,393.82 59.31 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 268.00 260.96 0.00 7.04 2.63 E25 Repairs & Maintenance 268.00 260.96 0.00 7.04 2.63 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 340,425.13 278,427.14 0.00 61,997.99 18.21 180 Finance Department 10-180-501020 Salaries 649,002.72 505,364.22 0.00 143,638.50 22.13 10-180-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-180-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-180-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-180-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-180-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-180-502010 Social Security 49,648.71 37,304.50 0.00 12,344.21 24.86 10-180-502020 GrOUD Health Insurance 99.910.43 74.876.32 0.00 25.034.11 25.06 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 7 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-180-502030 Retirement 79,178.33 53,530.48 0.00 25,647.85 32.39 10-180-502040 Workers Compensation 498.83 498.83 0.00 0.00 0.00 10-180-502050 Life Insurance 807.47 583.69 0.00 223.78 27.71 10-180-502060 Long Term Disability 1,878.11 1,418.66 0.00 459.45 24.46 10-180-502070 Employee Assistance Prgm 329.71 236.84 0.00 92.87 28.17 10-180-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 881,254.31 673,813.54 0.00 207,440.77 23.54 10-180-511010 Advertising 1,000.00 277.75 0.00 722.25 72.23 10-180-511020 Postage 10,000.00 8,453.55 0.00 1,546.45 15.46 10-180-511021 Mail Machine Cost 3,000.00 2,158.53 0.00 841.47 28.05 10-180-512010 Printing 3,300.00 2,738.63 0.00 561.37 17.01 10-180-512020 Copies 1,300.00 346.54 0.00 953.46 73.34 10-180-512021 Copy Machine Cost 200.00 713.16 0.00 -513.16 -256.58 10-180-513010 Office Supplies 3,600.00 346.50 0.00 3,253.50 90.38 10-180-514017 COVID-19 0.00 3,370.92 0.00 -3,370.92 0.00 10-180-517010 Operational Supplies 3,600.00 1,457.48 0.00 2,142.52 59.51 E10 Materials & Supplies 26,000.00 19,863.06 0.00 6,136.94 23.60 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,155.00 0.00 145.00 6.30 10-180-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-180-520070 Training And Education 7,975.76 1,540.68 0.00 6,435.08 80.68 10-180-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-180-522010 Audit 38,214.82 51,215.73 0.00 -13,000.91 -34.02 10-180-522015 Budget Expense 0.00 0.00 0.00 0.00 0.00 10-180-522020 Professional Services 300.00 181.28 0.00 118.72 39.57 E15 Contractual Services 48,790.58 55,092.69 0.00 -6,302.11 -12.92 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,251.61 0.00 8.39 0.67 E25 Repairs & Maintenance 1,260.00 1,251.61 0.00 8.39 0.67 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 957,304.89 750,020.90 0.00 207,283.99 21.65 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 39.589.29 36.967.43 0.00 2.621.86 6.62 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 8 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 39,589.29 36,967.43 0.00 2,621.86 6.62 10-185-514010 Gas 12,000.00 6,550.37 0.00 5,449.63 45.41 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 58,567.55 0.00 -58,567.55 0.00 10-185-514016 Flooding 0.00 1,326.14 0.00 -1,326.14 0.00 E10 Materials & Supplies 12,000.00 66,444.06 0.00 -54,444.06 -453.70 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 366,004.61 561,027.92 0.00 -195,023.31 -53.28 10-185-521020 Insurance Deductible 30,000.00 28,593.15 0.00 1,406.85 4.69 10-185-521030 Self Ins Prop & Casualty 40,000.00 77,571.49 0.00 -37,571.49 -93.93 10-185-521060 Drugalcohol screening 3,564.00 2,665.80 0.00 898.20 25.20 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 30,685.00 28,601.63 2,083.33 0.04 0.00 10-185-522023 LCRA Reimbursement 229,700.65 229,700.65 0.00 0.00 0.00 10-185-522025 JCTV 55,000.00 27,500.00 27,500.00 0.00 0.00 10-185-522035 Meeting Streaming & Recording 0.00 0.00 0.00 0.00 0.00 10-185-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-185-526030 Assessment Charge 47,000.00 92,240.48 0.00 -45,240.48 -96.26 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 4,782.36 0.00 2,217.64 31.68 E15 Contractual Services 993,954.26 1,237,683.48 29,583.33 -273,312.55 -27.50 10-185-531010 Electricity 33,000.00 25,449.77 0.00 7,550.23 22.88 10-185-533010 Natural Gas 6,200.00 4,074.32 0.00 2,125.68 34.29 10-185-535010 Water 7,250.00 5,633.36 0.00 1,616.64 22.30 10-185-535020 Downtown Irrigation 0.00 0.00 0.00 0.00 0.00 E20 Utilities 46,450.00 35,157.45 0.00 11,292.55 24.31 10-185-540010 Building & Grounds Maint. 42,925.00 35,207.63 3,005.00 4,712.37 10.98 10-185-540015 Amtrak Station 13,000.00 12,941.70 0.00 58.30 0.45 10-185-540020 Tree & Landscape Maint 25,000.00 25,000.00 0.00 0.00 0.00 10-185-547020 Maintenance Agreements 2,100.00 1,560.00 0.00 540.00 25.71 E25 Repairs & Maintenance 83,025.00 74,709.33 3,005.00 5,310.67 6.40 10-185-550010 Miscellaneous 5,000.00 1,149.92 0.00 3,850.08 77.00 10-185-550015 Bad Debt Expense 0.00 0.00 0.00 0.00 0.00 10-185-550020 Neighborhood Reinvestment 0.00 0.00 0.00 0.00 0.00 10-185-550025 Contingency 0.00 0.00 0.00 0.00 0.00 10-185-550026 Addt'l PositionsEquipment 0.00 0.00 0.00 0.00 0.00 10-185-550030 Old Town Projects 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 9 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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-550040 Public Art 500.00 307.00 0.00 193.00 38.60 10-185-550041 ALPLA Settlement 0.00 0.00 0.00 0.00 0.00 10-185-550042 Jefferson Day Celebration 1,000.00 0.00 0.00 1,000.00 100.00 10-185-550043 JC Fire Museum 0.00 0.00 0.00 0.00 0.00 10-185-550044 Bicentennial Event 0.00 0.00 0.00 0.00 0.00 10-185-550045 Conference Center 0.00 0.00 0.00 0.00 0.00 10-185-550050 Neighb Stablization Prog 0.00 0.00 0.00 0.00 0.00 10-185-550060 MSP 0.00 0.00 0.00 0.00 0.00 10-185-550070 Energy Grant Expenditures 0.00 0.00 0.00 0.00 0.00 10-185-550080 NeighborhdImprovement 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 16,500.00 11,456.92 0.00 5,043.08 30.56 10-185-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-185-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-185-578073 Council Infrastructure Proj 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 10-185-580080 Note Principal 0.00 0.00 0.00 0.00 0.00 10-185-580090 Note Interest 0.00 0.00 0.00 0.00 0.00 E90 Debt Service 0.00 0.00 0.00 0.00 0.00 185 Non -Departmental 1,191,518.55 1,462,418.67 32,588.33 -303,488.45 -25.47 190 Information Technology Svcs 10-190-501020 Salaries 560,680.59 498,289.07 0.00 62,391.52 11.13 10-190-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-190-501050 Parttime(wo benefits) 0.00 0.00 0.00 0.00 0.00 10-190-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-190-501090 Overtime 1,200.00 0.00 0.00 1,200.00 100.00 10-190-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-190-502010 Social Security 42,983.86 36,530.35 0.00 6,453.51 15.01 10-190-502020 Group Health Insurance 85,587.16 72,751.09 0.00 12,836.07 15.00 10-190-502030 Retirement 68,549.43 60,791.26 0.00 7,758.17 11.32 10-190-502040 Workers Compensation 1,358.21 1,358.21 0.00 0.00 0.00 10-190-502050 Life Insurance 671.67 590.41 0.00 81.26 12.10 10-190-502060 Long Term Disability 1,633.80 1,428.78 0.00 205.02 12.55 10-190-502070 Employee Assistance Prgm 266.57 191.51 0.00 75.06 28.16 E05 Personnel Services 762,931.29 671,930.68 0.00 91,000.61 11.93 10-190-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-190-511020 Postage 50.00 0.00 0.00 50.00 100.00 10-190-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-190-512020 Copies 20.00 9.51 0.00 10.49 52.45 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 10 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-190-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-190-513010 Office Supplies 900.00 422.47 0.00 477.53 53.06 10-190-514017 COVID-19 0.00 316.86 0.00 -316.86 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 2,188.81 0.00 311.19 12.45 E10 Materials & Supplies 3,570.00 2,937.65 0.00 632.35 17.71 10-190-520010 Mileage Expense 0.00 0.00 0.00 0.00 0.00 10-190-520030 Dues And Publications 300.00 124.99 0.00 175.01 58.34 10-190-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-190-520070 Training And Education 1,849.50 1,243.90 0.00 605.60 32.74 10-190-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 10-190-522020 Professional Services 10,000.00 77.53 5,250.00 4,672.47 46.72 10-190-522030 Services - Prof Training 0.00 0.00 0.00 0.00 0.00 10-190-522040 Service-internet Tl Web 18,800.00 17,392.71 0.00 1,407.29 7.49 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 35,349.50 23,154.13 5,250.00 6,945.37 19.65 10-190-534010 Telephone 70,000.00 62,849.46 0.00 7,150.54 10.22 E20 Utilities 70,000.00 62,849.46 0.00 7,150.54 10.22 10-190-545010 Software Licensemaint 237,200.00 176,623.83 70,157.00 -9,580.83 -4.04 10-190-545020 Citywide Wiringnetwork 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547010 Equipment Maintenance 2,000.00 0.00 0.00 2,000.00 100.00 10-190-547020 Maintenance Agreements 23,000.00 17,180.30 0.00 5,819.70 25.30 E25 Repairs & Maintenance 264,200.00 193,804.13 70,157.00 238.87 0.09 10-190-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 190 Information Technology Svcs 1,136,050.79 954,676.05 75,407.00 105,967.74 9.33 300 Police Department 10-300-501020 Salaries 4,398,889.08 3,869,986.44 0.00 528,902.64 12.02 10-300-501030 Holiday Pay 136,093.81 96,687.02 0.00 39,406.79 28.96 10-300-501040 Part-time (wbenefits) 33,090.22 0.00 0.00 33,090.22 100.00 10-300-501050 Parttime(wo Benefits) 66,208.36 48,795.15 0.00 17,413.21 26.30 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,828.00 0.00 1,172.00 23.44 10-300-501090 Overtime 356,162.71 213,004.74 0.00 143,157.97 40.19 10-300-501095 Overtime Straight Pay 14,000.00 12,300.48 0.00 1,699.52 12.14 10-300-502010 Social Security 374,784.70 308,439.17 0.00 66,345.53 17.70 10-300-502020 Group Health Insurance 830,255.11 677,906.77 0.00 152,348.34 18.35 10-300-502030 Retirement 847,484.81 712,106.46 0.00 135,378.35 15.97 10-300-502040 Workers Compensation 75,085.92 75,085.92 0.00 0.00 0.00 10-300-502050 Life Insurance 5,574.10 4,472.22 0.00 1,101.88 19.77 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 11 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-502060 Long Term Disability 13,176.12 11,058.66 0.00 2,117.46 16.07 10-300-502070 Employee Assistance Prgm 2,539.43 1,824.39 0.00 715.04 28.16 10-300-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 10-300-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 7,158,344.37 6,035,495.42 0.00 1,122,848.95 15.69 10-300-511010 Advertising 5,325.00 4,411.97 0.00 913.03 17.15 10-300-511020 Postage 1,395.00 1,370.62 0.00 24.38 1.75 10-300-512010 Printing 5,952.00 5,890.75 0.00 61.25 1.03 10-300-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-300-512030 Photographic Supplies 860.00 466.97 0.00 393.03 45.70 10-300-513010 Office Supplies 9,770.50 9,917.97 567.09 -714.56 -7.31 10-300-514010 Gas 148,800.00 100,300.83 0.00 48,499.17 32.59 10-300-514017 COVID-19 0.00 1,236.39 0.00 -1,236.39 0.00 10-300-514040 Food 1,001.00 1,256.31 0.00 -255.31 -25.51 10-300-515040 First Aid Supplies 1,209.00 1,491.16 0.00 -282.16 -23.34 10-300-516010 Ammunition & Firearms Supplies 49,465.35 49,852.80 2,945.50 -3,332.95 -6.74 10-300-516020 Dare Program 15,795.00 1,498.42 0.00 14,296.58 90.51 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 9,615.56 2,500.00 0.00 7,115.56 74.00 10-300-517010 Operational Supplies 40,038.54 31,060.28 5,142.99 3,835.27 9.58 E10 Materials & Supplies 291,551.95 211,254.47 8,655.58 71,641.90 24.57 10-300-520030 Dues And Publications 5,522.00 5,479.90 0.00 42.10 0.76 10-300-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-300-520070 Training And Education 71,008.00 40,092.47 0.00 30,915.53 43.54 10-300-520080 Tuition Reimbursement 11,925.00 13,845.00 0.00 -1,920.00 -16.10 10-300-520090 Recruitment 325.00 456.58 0.00 -131.58 -40.49 10-300-521040 Medical Claimsservices 5,510.00 5,101.50 0.00 408.50 7.41 10-300-521050 Medical Services 0.00 0.00 0.00 0.00 0.00 10-300-522020 Professional Services 13,915.00 13,052.36 0.00 862.64 6.20 10-300-522026 Drug Forfeiture - Justice 15,000.00 15,000.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 38,829.70 0.00 -38,829.70 0.00 10-300-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-300-523030 Building Lease 0.00 0.00 0.00 0.00 0.00 10-300-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-300-525020 Sober Driver Program 0.00 0.00 0.00 0.00 0.00 10-300-525050 Police Reserve 0.00 0.00 0.00 0.00 0.00 10-300-529010 Special Events 1,696.00 991.90 0.00 704.10 41.52 E15 Contractual Services 124,901.00 132,849.41 0.00 -7,948.41 -6.36 10-300-531010 Electricity 44,640.00 38,425.46 0.00 6,214.54 13.92 10-300-533010 Natural Gas 1,116.00 816.25 0.00 299.75 26.86 10-300-534010 Telephone 22,405.56 19,434.24 0.00 2,971.32 13.26 10-300-535010 Water 3,348.00 2,677.46 0.00 670.54 20.03 E20 Utilities 71,509.56 61,353.41 0.00 10,156.15 14.20 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 12 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-300-540010 Building & Grounds Maint. 50,700.00 50,134.39 5,539.85 -4,974.24 -9.81 10-300-541030 Vehicle Wash 9,000.00 9,194.50 0.00 -194.50 -2.16 10-300-544010 K-9 Operations 17,740.00 8,194.92 5,919.99 3,625.09 20.43 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 25,162.79 0.00 -2,563.79 -11.34 10-300-545010 Software Licensemaint 54,764.01 54,757.00 0.00 7.01 0.01 10-300-546010 Clothing Expense 40,327.56 23,241.07 2,060.99 15,025.50 37.26 10-300-546020 Uniform Cleaning 21,715.00 18,512.31 0.00 3,202.69 14.75 10-300-547010 Equipment Maintenance 13,025.50 13,500.49 0.00 -474.99 -3.65 10-300-547020 Maintenance Agreements 59,140.00 41,015.61 74.65 18,049.74 30.52 10-300-547030 Radio Maintenance 4,970.00 6,040.12 0.00 -1,070.12 -21.53 E25 Repairs & Maintenance 293,981.07 249,753.20 13,595.48 30,632.39 10.42 10-300-572010 Purchase Of Vehicles 0.00 0.00 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 17,544.00 8,772.00 37,761.00 -28,989.00 -165.24 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,940.20 6,940.20 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 37,268.00 24,843.42 0.00 12,424.58 33.34 10-300-572080 DEA Equipment Grant 0.00 0.00 0.00 0.00 0.00 10-300-572085 Bullet Proof Vest Grant 24,633.62 12,942.66 0.00 11,690.96 47.46 10-300-572100 MDT Year 3 Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572110 Jcpd Mdt Equipment 0.00 0.00 0.00 0.00 0.00 10-300-572120 Cole Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572130 Osage B Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572140 Camden Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572150 Callaway Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572160 Fulton Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572170 Eldon Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572180 Miller Cty Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572190 Camdenton Cty Mtd 0.00 0.00 0.00 0.00 0.00 10-300-572200 Lake Ozark Mdt Equip 0.00 0.00 0.00 0.00 0.00 10-300-572210 Cole Co Reimbursable Grant Exp 4,626.80 4,626.80 0.00 0.00 0.00 10-300-572310 Software-camdnmilob 0.00 0.00 0.00 0.00 0.00 10-300-572320 Software -morgan Cty 0.00 0.00 0.00 0.00 0.00 10-300-572330 Software jcpdcole Cty 0.00 0.00 0.00 0.00 0.00 10-300-572340 Software-colboone Cty 0.00 0.00 0.00 0.00 0.00 10-300-572350 Software-fultncallaway 0.00 0.00 0.00 0.00 0.00 10-300-572360 Software-vpnfirewl 0.00 0.00 0.00 0.00 0.00 10-300-572370 Software -prof 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 91,012.62 58,125.08 37,761.00 -4,873.46 -5.35 300 Police Department 8,031,300.57 6,748,830.99 60,012.06 1,222,457.52 15.22 Page 13 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 310 School Resource Officer 10-310-501020 Salaries 395,805.07 353,817.30 0.00 41,987.77 10.61 10-310-501030 Holiday Pay 15,214.96 3,822.35 0.00 11,392.61 74.88 10-310-501090 Overtime 35,126.00 40,939.79 0.00 -5,813.79 -16.55 10-310-501095 Overtime Straight Pay 586.00 783.90 0.00 -197.90 -33.77 10-310-502010 Social Security 34,175.00 28,291.15 0.00 5,883.85 17.22 10-310-502020 Group Health Insurance 89,435.68 75,813.04 0.00 13,622.64 15.23 10-310-502030 Retirement 80,858.50 72,284.71 0.00 8,573.79 10.60 10-310-502040 Workers Compensation 6,552.86 6,552.86 0.00 0.00 0.00 10-310-502050 Life Insurance 481.03 421.22 0.00 59.81 12.43 10-310-502060 Long Term Disability 1,187.04 1,041.00 0.00 146.04 12.30 10-310-502070 Employee Assistance Prgm 224.48 161.28 0.00 63.20 28.15 E05 Personnel Services 659,646.62 583,928.60 0.00 75,718.02 11.48 10-310-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-310-517010 Operational Supplies 10,233.92 4,404.74 0.00 5,829.18 56.96 E10 Materials & Supplies 10,233.92 4,404.74 0.00 5,829.18 56.96 10-310-520070 Training And Education 4,650.00 1,234.65 0.00 3,415.35 73.45 10-310-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 4,650.00 1,234.65 0.00 3,415.35 73.45 10-310-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-546010 Clothing Expense 9,473.78 2,801.56 2,576.00 4,096.22 43.24 10-310-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-310-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 9,473.78 2,801.56 2,576.00 4,096.22 43.24 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 684,004.32 592,369.55 2,576.00 89,058.77 13.02 320 M.U.S.T.A.N.G. 10-320-501020 Salaries 96,476.83 88,186.42 0.00 8,290.41 8.59 10-320-501030 Holiday Pay 3,641.42 361.96 0.00 3,279.46 90.06 10-320-501090 Overtime 28,552.09 21,020.91 0.00 7,531.18 26.38 10-320-501095 Overtime Straight Pay 0.00 268.32 0.00 -268.32 0.00 10-320-502010 Social Security 8,527.34 8,028.30 0.00 499.04 5.85 10-320-502020 Group Health Insurance 22,276.30 18,232.96 0.00 4,043.34 18.15 10-320-502030 Retirement 20,175.81 19,880.62 0.00 295.19 1.46 10-320-502040 Workers Compensation 2,004.39 2,004.39 0.00 0.00 0.00 10-320-502050 Life Insurance 115.06 100.87 0.00 14.19 12.33 10-320-502060 Long Term Disability 283.97 248.94 0.00 35.03 12.34 10-320-502070 Employee Assistance Prgm 56.12 40.31 0.00 15.81 28.17 E05 Personnel Services 182,109.33 158,374.00 0.00 23,735.33 13.03 10-320-514010 Gas 5.580.00 4.093.28 0.00 1.486.72 26.64 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 14 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-320-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-320-516040 Investigations 13,905.36 10,638.48 0.00 3,266.88 23.49 10-320-517010 Operational Supplies 12,274.60 364.25 0.00 11,910.35 97.03 E10 Materials & Supplies 31,759.96 15,096.01 0.00 16,663.95 52.47 10-320-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-320-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-320-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-320-522025 Drug Forfeiture - MUSTANG 0.00 0.00 0.00 0.00 0.00 10-320-523010 Equipment Rentlease 17,160.00 12,000.00 0.00 5,160.00 30.07 10-320-523020 Building Lease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 17,160.00 12,000.00 0.00 5,160.00 30.07 10-320-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-320-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-320-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 320 M.U.S.T.A.N.G. 231,029.29 185,470.01 0.00 45,559.28 19.72 330 Animal Control 10-330-501020 Salaries 353,755.38 306,138.50 0.00 47,616.88 13.46 10-330-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-330-501050 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-330-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-330-501070 Stand-by Plan 4,308.00 3,840.00 0.00 468.00 10.86 10-330-501090 Overtime 1,709.00 10,643.63 0.00 -8,934.63 -522.80 10-330-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-330-502010 Social Security 27,522.59 23,200.43 0.00 4,322.16 15.70 10-330-502020 Group Health Insurance 75,516.45 59,559.76 0.00 15,956.69 21.13 10-330-502030 Retirement 43,892.23 33,142.67 0.00 10,749.56 24.49 10-330-502040 Workers Compensation 4,681.08 4,681.08 0.00 0.00 0.00 10-330-502050 Life Insurance 429.62 340.72 0.00 88.90 20.69 10-330-502060 Long Term Disability 1,059.25 840.78 0.00 218.47 20.62 10-330-502070 Employee Assistance Prgm 224.48 161.28 0.00 63.20 28.15 10-330-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 513,098.08 442,548.85 0.00 70,549.23 13.75 10-330-511010 Advertising 936.60 625.00 0.00 311.60 33.27 10-330-511020 Postage 213.00 223.65 0.00 -10.65 -5.00 10-330-512010 Printing 1,720.50 1,806.62 0.00 -86.12 -5.01 10-330-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-330-513010 Office Supplies 1,411.00 783.53 0.00 627.47 44.47 10-330-514017 COVID-19 0.00 74.93 0.00 -74.93 0.00 10-330-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 15 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-330-514040 Food 223.20 121.02 0.00 102.18 45.78 10-330-515040 First Aid Supplies 465.00 140.88 0.00 324.12 69.70 10-330-517010 Operational Supplies 9,690.60 8,500.40 0.00 1,190.20 12.28 E10 Materials & Supplies 14,659.90 12,276.03 0.00 2,383.87 16.26 10-330-520030 Dues And Publications 1,166.00 1,165.25 0.00 0.75 0.06 10-330-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-330-520070 Training And Education 1,813.50 2,236.14 0.00 -422.64 -23.31 10-330-521040 Medical Claimsservices 431.52 1,021.50 0.00 -589.98 -136.72 10-330-522020 Professional Services 5,010.00 3,136.00 0.00 1,874.00 37.41 10-330-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-330-529045 Veterinary Services 3,206.24 1,918.33 0.00 1,287.91 40.17 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 13,314.50 157.18 13,314.50 -157.18 -1.18 E15 Contractual Services 24,941.76 9,634.40 13,314.50 1,992.86 7.99 10-330-531010 Electricity 19,152.00 22,575.11 0.00 -3,423.11 -17.87 10-330-533010 Natural Gas 15,700.00 17,469.58 0.00 -1,769.58 -11.27 10-330-534010 Telephone 300.00 377.51 0.00 -77.51 -25.84 10-330-535010 Water 3,800.00 3,628.35 0.00 171.65 4.52 E20 Utilities 38,952.00 44,050.55 0.00 -5,098.55 -13.09 10-330-540010 Building & Grounds Maint. 17,600.00 33,841.03 60.00 -16,301.03 -92.62 10-330-541020 Veh Maintenance 0.00 0.00 0.00 0.00 0.00 10-330-541030 Vehicle Wash 541.76 541.76 0.00 0.00 0.00 10-330-544040 Care Of Animals 48,290.00 41,621.98 0.00 6,668.02 13.81 10-330-544050 Animal Food 5,703.00 3,525.03 0.00 2,177.97 38.19 10-330-545010 Software Licensemaint 3,172.00 3,107.76 73.14 -8.90 -0.28 10-330-546010 Clothing Expense 2,325.00 2,620.46 0.00 -295.46 -12.71 10-330-546020 Uniform Cleaning 0.00 0.00 0.00 0.00 0.00 10-330-547010 Equipment Maintenance 49.81 0.00 0.00 49.81 100.00 10-330-547020 Maintenance Agreements 2,600.00 2,304.00 0.00 296.00 11.38 10-330-547030 Radio Maintenance 232.50 90.44 0.00 142.06 61.10 E25 Repairs & Maintenance 80,514.07 87,652.46 133.14 -7,271.53 -9.03 10-330-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-330-572020 Purchase Of Equipment 28,486.60 24,116.60 0.00 4,370.00 15.34 10-330-573030 Purchimprov Landbuildin 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 28,486.60 24,116.60 0.00 4,370.00 15.34 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 700,652.41 620,278.89 13,447.64 66,925.88 9.55 390 9-1-1 Police GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 16 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-390-501020 Salaries 896,855.55 773,189.18 0.00 123,666.37 13.79 10-390-501030 Holiday Pay 31,505.21 26,907.70 0.00 4,597.51 14.59 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 41,938.14 0.00 -19,124.14 -83.83 10-390-501095 Overtime Straight Pay 500.00 2,294.37 0.00 -1,794.37 -358.87 10-390-502010 Social Security 72,803.12 61,233.61 0.00 11,569.51 15.89 10-390-502020 Group Health Insurance 196,184.53 158,771.49 0.00 37,413.04 19.07 10-390-502030 Retirement 117,893.93 97,842.55 0.00 20,051.38 17.01 10-390-502040 Workers Compensation 2,719.96 2,719.96 0.00 0.00 0.00 10-390-502050 Life Insurance 1,112.80 902.62 0.00 210.18 18.89 10-390-502060 Long Term Disability 2,707.70 2,228.60 0.00 479.10 17.69 10-390-502070 Employee Assistance Prgm 596.28 428.39 0.00 167.89 28.16 10-390-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,345,693.08 1,168,456.61 0.00 177,236.47 13.17 10-390-511010 Advertising 93.00 845.25 0.00 -752.25 -808.87 10-390-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-390-514017 COVID-19 0.00 10.44 0.00 -10.44 0.00 10-390-517010 Operational Supplies 5,394.00 5,165.30 0.00 228.70 4.24 E10 Materials & Supplies 5,487.00 6,020.99 0.00 -533.99 -9.73 10-390-520030 Dues And Publications 558.00 308.99 0.00 249.01 44.63 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 2,344.49 0.00 2,305.51 49.58 10-390-522020 Professional Services 2,511.00 4,955.23 0.00 -2,444.23 -97.34 10-390-523010 Equipment Rentlease 85,560.00 90,421.62 0.00 -4,861.62 -5.68 E15 Contractual Services 93,279.00 98,030.33 0.00 -4,751.33 -5.09 10-390-531010 Electricity 11,160.00 3,991.22 0.00 7,168.78 64.24 10-390-533010 Natural Gas 279.00 89.00 0.00 190.00 68.10 10-390-534010 Telephone 0.00 0.00 0.00 0.00 0.00 10-390-535010 Water 837.00 609.97 0.00 227.03 27.12 E20 Utilities 12,276.00 4,690.19 0.00 7,585.81 61.79 10-390-545010 Software Licensemaint 30,236.16 32,284.00 0.00 -2,047.84 -6.77 10-390-546010 Clothing Expense 5,580.00 7,198.40 0.00 -1,618.40 -29.00 10-390-546020 Uniform Cleaning 2,976.00 2,778.35 0.00 197.65 6.64 10-390-547010 Equipment Maintenance 2,790.00 5,240.52 0.00 -2,450.52 -87.83 10-390-547020 Maintenance Agreements 57,000.00 82,240.73 0.00 -25,240.73 -44.28 10-390-547030 Radio Maintenance 4,650.00 1,105.99 0.00 3,544.01 76.22 E25 Repairs & Maintenance 103,232.16 130,847.99 0.00 -27,615.83 -26.75 10-390-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 390 9-1-1 Police 1,559,967.24 1,408,046.11 0.00 151,921.13 9.74 400 Fire Department GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 17 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-400-501020 Dues And Publications Salaries 3,931,958.32 3,447,538.58 0.00 484,419.74 12.32 10-400-501030 INACTIVE - Mtgs & Conferences 0.00 Holiday Pay 294,561.33 284,205.29 0.00 10,356.04 3.52 10-400-501050 0.00 0.00 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-400-501080 0.00 4,215.01 Step-up Pay 28,500.00 33,597.37 0.00 -5,097.37 -17.89 10-400-501090 582.00 9.63 Overtime 41,000.00 62,181.33 0.00 -21,181.33 -51.66 10-400-501095 0.00 10-400-521040 Overtime Straight Pay 33,000.00 34,967.20 0.00 -1,967.20 -5.96 10-400-502010 10-400-522020 Social Security 65,375.80 55,115.30 0.00 10,260.50 15.69 10-400-502020 Group Health Insurance 766,446.12 633,585.18 0.00 132,860.94 17.33 10-400-502030 10-400-524010 Retirement 2,020,017.53 1,742,007.00 0.00 278,010.53 13.76 10-400-502040 Special Events Workers Compensation 153,030.95 153,030.95 0.00 0.00 0.00 10-400-502050 Child Safety Seat Pass-through 2,700.00 Life Insurance 4,670.78 3,996.32 0.00 674.46 14.44 10-400-502060 83,958.50 50,624.06 Long Term Disability 11,615.57 9,810.38 0.00 1,805.19 15.54 10-400-502070 31,742.93 0.00 Employee Assistance Prgm 2,132.56 1,531.08 0.00 601.48 28.20 10-400-503010 0.00 5,994.91 Awards Program 1,500.00 1,238.67 0.00 261.33 17.42 E05 18.56 10-400-535010 Personnel Services 7,353,808.96 6,462,804.65 0.00 891,004.31 12.12 10-400-511010 Advertising 372.00 373.69 0.00 -1.69 -0.45 10-400-511020 Postage 139.50 97.22 0.00 42.28 30.31 10-400-512010 Printing 790.50 335.75 0.00 454.75 57.53 10-400-512020 Copies 46.50 0.00 0.00 46.50 100.00 10-400-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-400-513010 Office Supplies 1,395.00 1,190.99 0.00 204.01 14.62 10-400-514010 Gas 51,150.00 34,848.07 0.00 16,301.93 31.87 10-400-514017 COVID-19 0.00 20,990.13 21,094.44 -42,084.57 0.00 10-400-514020 Chemicals 930.00 512.50 0.00 417.50 44.89 10-400-514030 Small Tools 4,650.00 5,284.87 0.00 -634.87 -13.65 10-400-514040 Food 0.00 0.00 0.00 0.00 0.00 10-400-515040 First Aid Supplies 2,046.00 19.88 0.00 2,026.12 99.03 10-400-517010 Operational Supplies 13,476.00 8,653.43 0.00 4,822.57 35.79 E10 Materials & Supplies 74,995.50 72,306.53 21,094.44 -18,405.47 -24.54 10-400-520030 Dues And Publications 2,673.50 1,745.02 0.00 928.48 34.73 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 30,225.00 26,009.99 0.00 4,215.01 13.95 10-400-520080 Tuition Reimbursement 6,045.00 5,463.00 0.00 582.00 9.63 10-400-520085 Traing-Home Land Security 0.00 0.00 0.00 0.00 0.00 10-400-521040 Medical Claimsservices 35,340.00 9,978.50 23,812.50 1,549.00 4.38 10-400-522020 Professional Services 186.00 0.00 0.00 186.00 100.00 10-400-523010 Equipment Rentlease 186.00 40.00 0.00 146.00 78.49 10-400-524010 Trash Collections 93.00 218.34 0.00 -125.34 -134.77 10-400-529010 Special Events 6,510.00 5,464.21 0.00 1,045.79 16.06 10-400-529040 Child Safety Seat Pass-through 2,700.00 1,705.00 0.00 995.00 36.85 E15 Contractual Services 83,958.50 50,624.06 23,812.50 9,521.94 11.34 10-400-531010 Electricity 30,690.00 31,742.93 0.00 -1,052.93 -3.43 10-400-533010 Natural Gas 17,670.00 11,675.09 0.00 5,994.91 33.93 10-400-534010 Telephone 23,250.00 18,935.76 0.00 4,314.24 18.56 10-400-535010 Water 16,740.00 9,307.99 0.00 7,432.01 44.40 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 18 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E20 Utilities 88,350.00 71,661.77 0.00 16,688.23 18.89 10-400-540010 Building & Grounds Maint. 90,510.91 34,112.59 54,848.67 1,549.65 1.71 10-400-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-400-546010 Clothing Expense 69,703.50 57,827.49 0.00 11,876.01 17.04 10-400-546020 Uniform Cleaning 186.00 405.35 0.00 -219.35 -117.93 10-400-547010 Equipment Maintenance 15,462.15 11,796.85 0.00 3,665.30 23.70 10-400-547020 Maintenance Agreements 35,757.54 28,905.95 -1,276.49 8,128.08 22.73 10-400-547030 Radio Maintenance 20,925.00 16,548.33 5,328.37 -951.70 -4.55 E25 Repairs & Maintenance 232,545.10 149,596.56 58,900.55 24,047.99 10.34 10-400-572010 Purchase Of Vehicles 0.00 0.00 0.00 0.00 0.00 10-400-572011 Purchase of Vehicles -Lease Pmt 0.00 0.00 0.00 0.00 0.00 10-400-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 10-400-572021 Purchase of Equipment -ONE TIME 22,474.09 21,899.86 0.00 574.23 2.56 10-400-572022 Fitness -ONE TIME 10,746.36 10,746.36 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 33,220.45 32,646.22 0.00 574.23 1.73 400 Fire Department 7,866,878.51 6,839,639.79 103,807.49 923,431.23 11.74 401 Fire Museum 10-401-531010 Electricity 1,274.35 702.05 0.00 572.30 44.91 10-401-533010 Natural Gas 389.02 445.54 0.00 -56.52 -14.53 10-401-535010 Water 196.63 242.08 0.00 -45.45 -23.11 E20 Utilities 1,860.00 1,389.67 0.00 470.33 25.29 10-401-540010 Building & Grounds Maint. 0.00 148.39 0.00 -148.39 0.00 E25 Repairs & Maintenance 0.00 148.39 0.00 -148.39 0.00 401 Fire Museum 1,860.00 1,538.06 0.00 321.94 17.31 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 Advertisine 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 19 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-500-511020 Postage 0.00 0.00 0.00 0.00 0.00 10-500-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-500-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-500-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-500-514040 Food 0.00 0.00 0.00 0.00 0.00 10-500-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-500-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-500-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-500-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-500-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-500-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-500-527010 Comm 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 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 183,686.46 163,224.86 0.00 20,461.60 11.14 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,052.01 11,992.91 0.00 2,059.10 14.65 10-520-502020 Group Health Insurance 27,276.96 23,194.31 0.00 4,082.65 14.97 10-520-502030 Retirement 22,409.75 19,913.48 0.00 2,496.27 11.14 10-520-502040 Workers Compensation 196.90 196.90 0.00 0.00 0.00 10-520-502050 Life Insurance 217.87 193.30 0.00 24.57 11.28 10-520-502060 Long Term Disability 475.65 417.92 0.00 57.73 12.14 10-520-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 10-520-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 248,399.78 219,194.17 0.00 29,205.61 11.76 10-520-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-520-511020 Postage 75.00 8.50 0.00 66.50 88.67 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 Photoaranhic Sullies 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 20 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-520-513010 Office Supplies 850.00 319.41 0.00 530.59 62.42 10-520-514010 Gas 11,000.00 8,019.62 0.00 2,980.38 27.09 10-520-514017 COVID-19 0.00 901.41 0.00 -901.41 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 231.55 0.00 268.45 53.69 E10 Materials & Supplies 12,525.00 9,480.56 0.00 3,044.44 24.31 10-520-520030 Dues And Publications 1,259.30 1,146.50 0.00 112.80 8.96 10-520-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-520-520070 Training And Education 1,540.70 443.33 0.00 1,097.37 71.23 10-520-522020 Professional Services 21,742.38 12,387.58 10,000.00 -645.20 -2.97 E15 Contractual Services 24,542.38 13,977.41 10,000.00 564.97 2.30 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 826.00 783.20 5.32 37.48 4.54 E25 Repairs & Maintenance 826.00 783.20 5.32 37.48 4.54 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 286,293.16 243,435.34 10,005.32 32,852.50 11.48 521 Plan & Protect Svcs -Planning 10-521-501020 Salaries 138,518.99 123,872.91 0.00 14,646.08 10.57 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,596.70 8,989.77 0.00 1,606.93 15.16 10-521-502020 Group Health Insurance 31,325.80 26,674.59 0.00 4,651.21 14.85 10-521-502030 Retirement 16,899.32 15,112.63 0.00 1,786.69 10.57 10-521-502040 Workers Compensation 158.35 158.35 0.00 0.00 0.00 10-521-502050 Life Insurance 167.57 147.00 0.00 20.57 12.28 10-521-502060 Long Term Disability 414.25 363.19 0.00 51.06 12.33 10-521-502070 Employee Assistance Prgm 75.76 54.44 0.00 21.32 28.14 10-521-503010 Awards Program 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 198,156.74 175,372.88 0.00 22,783.86 11.50 10-521-511010 Advertising 4,500.00 794.50 0.00 3,705.50 82.34 10-521-511020 Postage 900.00 95.80 0.00 804.20 89.36 10-521-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-521-512020 Copies 0.00 4.76 0.00 -4.76 0.00 10-521-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-521-513010 Office Sunolies 800.00 530.11 0.00 269.89 33.74 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 21 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-521-547020 Maintenance Agreements 1,400.00 1,652.90 68.61 -321.51 -22.97 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 2,500.00 1,137.83 0.00 1,362.17 54.49 E10 Materials & Supplies 8,900.00 2,563.00 0.00 6,337.00 71.20 10-521-520030 Dues And Publications 14,300.00 14,329.49 0.00 -29.49 -0.21 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 450.00 0.00 1,950.00 81.25 10-521-520080 Tuition Reimbursement 873.00 855.00 0.00 18.00 2.06 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 17,573.00 15,634.49 0.00 1,938.51 11.03 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,400.00 1,652.90 68.61 -321.51 -22.97 E25 Repairs & Maintenance 1,400.00 1,652.90 68.61 -321.51 -22.97 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 226,029.74 195,223.27 68.61 30,737.86 13.60 522 Plan & Protect Svcs -MPO 10-522-501020 Salaries 122,107.26 96,737.39 0.00 25,369.87 20.78 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,341.21 7,325.84 0.00 2,015.37 21.58 10-522-502020 Group Health Insurance 17,996.06 14,324.41 0.00 3,671.65 20.40 10-522-502030 Retirement 14,897.09 10,515.91 0.00 4,381.18 29.41 10-522-502040 Workers Compensation 102.55 102.55 0.00 0.00 0.00 10-522-502050 Life Insurance 147.74 114.16 0.00 33.58 22.73 10-522-502060 Long Term Disability 364.74 282.95 0.00 81.79 22.42 10-522-502070 Employee Assistance Prgm 64.54 46.38 0.00 18.16 28.14 E05 Personnel Services 165,021.19 129,449.59 0.00 35,571.60 21.56 10-522-511010 Advertising 1,800.00 547.50 0.00 1,252.50 69.58 10-522-511020 Postage 200.00 1.15 0.00 198.85 99.43 10-522-512010 Printing 125.00 0.00 0.00 125.00 100.00 10-522-512020 Copies 10.00 0.70 0.00 9.30 93.00 10-522-513010 Office Supplies 1,000.00 256.16 0.00 743.84 74.38 10-522-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-522-514040 Food 250.00 0.00 0.00 250.00 100.00 10-522-517010 Operational Supplies 1,620.00 1,165.55 0.00 454.45 28.05 E10 Materials & SUDOlies 5.005.00 1.971.06 0.00 3.033.94 60.62 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 22 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-522-520030 Dues And Publications 1,500.00 471.00 0.00 1,029.00 68.60 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 12.50 0.00 5,987.50 99.79 10-522-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-522-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,500.00 483.50 0.00 7,016.50 93.55 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,075.00 1,400.00 59.24 615.76 29.68 10-522-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,075.00 1,400.00 59.24 615.76 29.68 10-522-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 522 Plan & Protect Svcs -MPO 179,601.19 133,304.15 59.24 46,237.80 25.74 530 Plan & Protect Svc-RedevGrant 10-530-501020 Salaries 59,979.00 44,261.06 0.00 15,717.94 26.21 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 6,175.19 2,909.54 0.00 3,265.65 52.88 10-530-502020 Group Health Insurance 9,710.69 8,919.29 0.00 791.40 8.15 10-530-502030 Retirement 9,848.01 3,408.28 0.00 6,439.73 65.39 10-530-502040 Workers Compensation 58.08 58.08 0.00 0.00 0.00 10-530-502050 Life Insurance 96.70 47.82 0.00 48.88 50.55 10-530-502060 Long Term Disability 239.90 117.81 0.00 122.09 50.89 10-530-502070 Employee Assistance Prgm 42.09 30.23 0.00 11.86 28.18 E05 Personnel Services 86,149.66 59,752.11 0.00 26,397.55 30.64 10-530-511010 Advertising 405.00 964.50 0.00 -559.50 -138.15 10-530-511020 Postage 515.50 597.20 0.00 -81.70 -15.85 10-530-512010 Printing 50.00 0.00 0.00 50.00 100.00 10-530-512020 Copies 0.00 2.15 0.00 -2.15 0.00 10-530-513010 Office Supplies 796.84 746.84 0.00 50.00 6.27 10-530-514017 COVID-19 0.00 0.00 0.00 0.00 0.00 10-530-517010 Operational Supplies 500.00 310.54 0.00 189.46 37.89 E10 Materials & Supplies 2,267.34 2,621.23 0.00 -353.89 -15.61 10-530-520030 Dues And Publications 700.00 700.97 0.00 -0.97 -0.14 10-530-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-530-520070 Training And Education 1,132.66 123.91 0.00 1,008.75 89.06 10-530-522020 Professional Services 402.00 0.00 0.00 402.00 100.00 10-530-524020 Recycle Collectprocess 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 23 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-530-524024 Mid -Mo Solid Wast Mgmt Dist 0.00 0.00 0.00 0.00 0.00 10-530-524025 Glass Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524026 Household Hazardous Waste 18,800.00 0.00 0.00 18,800.00 100.00 10-530-524027 Portable Recycling 0.00 0.00 0.00 0.00 0.00 10-530-524028 Misc Recycling 1,000.00 289.89 0.00 710.11 71.01 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 110,240.56 1,114.77 0.00 109,125.79 98.99 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 508.00 421.09 21.50 65.41 12.88 E25 Repairs & Maintenance 508.00 421.09 21.50 65.41 12.88 10-530-550020 NRA -Residential 29,379.77 29,379.57 0.00 0.20 0.00 10-530-550030 NRA -Commercial Facade 20,000.00 19,447.65 0.00 552.35 2.76 10-530-550031 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.00 10-530-550032 NRA -Rental Facade 0.00 0.00 0.00 0.00 0.00 10-530-550033 HPF Grant -Structural Survey 72,000.00 70,127.59 5,872.41 -4,000.00 -5.56 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 151.17 0.00 98.83 39.53 10-530-550039 Historic Preservation Grant 0.00 0.00 0.00 0.00 0.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-550090 Hazard Mitigation 0.00 0.00 0.00 0.00 0.00 E30 Other Operating Expenses 121,629.77 119,105.98 5,872.41 -3,348.62 -2.75 530 Plan & Protect Svc-RedevGrant 320,795.33 183,015.18 5,893.91 131,886.24 41.11 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 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 24 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-512010 Printing 0.00 0.00 0.00 0.00 0.00 10-531-512020 Copies 0.00 0.00 0.00 0.00 0.00 10-531-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-531-513010 Office Supplies 0.00 0.00 0.00 0.00 0.00 10-531-514030 Small Tools 0.00 0.00 0.00 0.00 0.00 10-531-515040 First Aid Supplies 0.00 0.00 0.00 0.00 0.00 10-531-517010 Operational Supplies 0.00 0.00 0.00 0.00 0.00 E10 Materials & Supplies 0.00 0.00 0.00 0.00 0.00 10-531-520030 Dues And Publications 0.00 0.00 0.00 0.00 0.00 10-531-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-531-520070 Training And Education 0.00 0.00 0.00 0.00 0.00 10-531-522020 Professional Services 0.00 0.00 0.00 0.00 0.00 10-531-522021 Abatement 0.00 0.00 0.00 0.00 0.00 10-531-522022 Demo 0.00 0.00 0.00 0.00 0.00 10-531-522070 Legal Services 0.00 0.00 0.00 0.00 0.00 10-531-523010 Equipment Rentlease 0.00 0.00 0.00 0.00 0.00 10-531-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 0.00 0.00 0.00 0.00 0.00 10-531-534010 Telephone 0.00 0.00 0.00 0.00 0.00 E20 Utilities 0.00 0.00 0.00 0.00 0.00 10-531-541030 Vehicle Wash 0.00 0.00 0.00 0.00 0.00 10-531-546010 Clothing Expense 0.00 0.00 0.00 0.00 0.00 10-531-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-547020 Maintenance Agreements 0.00 0.00 0.00 0.00 0.00 10-531-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 0.00 0.00 0.00 0.00 0.00 10-531-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 531 Plan & Protect Svcs -Build Reg 0.00 0.00 0.00 0.00 0.00 532 Plan & Protect Svcs -Env Health 10-532-501020 Salaries 179,725.82 159,713.74 0.00 20,012.08 11.13 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 13,749.02 11,198.52 0.00 2,550.50 18.55 10-532-502020 Group Health Insurance 34,764.83 29,652.43 0.00 5,112.40 14.71 10-532-502030 Retirement 21,926.55 19,485.08 0.00 2,441.47 11.13 10-532-502040 Workers Compensation 3,753.42 3,753.42 0.00 0.00 0.00 10-532-502050 Life Insurance 215.42 188.51 0.00 26.91 12.49 10-532-502060 Long Term Disability 535.62 469.73 0.00 65.89 12.30 10-532-502070 Emnlovee Assistance Prem 84.18 60.49 0.00 23.69 28.14 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 25 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-532-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 254,754.86 224,521.92 0.00 30,232.94 11.87 10-532-511010 Advertising 90.00 0.00 0.00 90.00 100.00 10-532-511020 Postage 150.00 56.65 0.00 93.35 62.23 10-532-512010 Printing 20.00 0.00 0.00 20.00 100.00 10-532-512020 Copies 0.00 0.25 0.00 -0.25 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 865.77 0.00 434.23 33.40 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 748.57 0.00 251.43 25.14 E10 Materials & Supplies 2,625.00 1,671.24 0.00 953.76 36.33 10-532-520030 Dues And Publications 900.00 620.00 0.00 280.00 31.11 10-532-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-532-520070 Training And Education 310.00 310.00 0.00 0.00 0.00 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 194,400.00 162,000.00 32,400.00 0.00 0.00 10-532-529010 Special Events 62.13 62.13 0.00 0.00 0.00 10-532-529020 Historic Preservation Com 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 195,672.13 162,992.13 32,400.00 280.00 0.14 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 34,000.00 27,866.73 5,512.00 621.27 1.83 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 805.57 405.57 0.00 400.00 49.65 10-532-547010 Equipment Maintenance 40.00 0.00 0.00 40.00 100.00 10-532-547020 Maintenance Agreements 750.00 707.50 21.50 21.00 2.80 10-532-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 36,885.57 30,263.80 5,533.50 1,088.27 2.95 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 489,937.56 419,449.09 37,933.50 32,554.97 6.64 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 26 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 533 Telephone PPS - Prop MaintCode Enforce 3,142.00 0.00 559.40 15.11 E20 10-533-501020 3,701.40 Salaries 163,223.07 148,520.05 0.00 14,703.02 9.01 10-533-501050 270.00 Parttime(wo Benefits) 0.00 0.00 0.00 0.00 0.00 10-533-501060 0.00 Seasonal Salaries 30,000.00 32,759.42 0.00 -2,759.42 -9.20 10-533-501090 0.00 Overtime 0.00 0.00 0.00 0.00 0.00 10-533-501095 0.00 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-533-502010 Social Security 14,781.57 13,314.42 0.00 1,467.15 9.93 10-533-502020 Group Health Insurance 32,001.37 27,139.81 0.00 4,861.56 15.19 10-533-502030 Retirement 19,913.21 18,119.38 0.00 1,793.83 9.01 10-533-502040 Workers Compensation 2,257.38 2,257.38 0.00 0.00 0.00 10-533-502050 Life Insurance 177.60 155.83 0.00 21.77 12.26 10-533-502060 Long Term Disability 489.48 429.16 0.00 60.32 12.32 10-533-502070 Employee Assistance Prgm 98.21 70.57 0.00 27.64 28.14 E05 Personnel Services 262,941.89 242,766.02 0.00 20,175.87 7.67 10-533-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-533-511020 Postage 1,800.51 1,362.25 0.00 438.26 24.34 10-533-512010 Printing 300.00 225.00 0.00 75.00 25.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 847.43 506.13 0.00 341.30 40.27 10-533-514017 COVID-19 29.52 29.52 0.00 0.00 0.00 10-533-514030 Small Tools 72.56 0.00 0.00 72.56 100.00 10-533-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-533-517010 Operational Supplies 1,525.49 1,525.49 0.00 0.00 0.00 E10 Materials & Supplies 4,690.51 3,648.39 0.00 1,042.12 22.22 10-533-520030 Dues And Publications 593.34 593.34 0.00 0.00 0.00 10-533-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-533-520070 Training And Education 607.95 607.95 0.00 0.00 0.00 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 27,699.53 27,632.58 0.00 66.95 0.24 10-533-522022 Demo 316,015.00 227,988.31 12,780.00 75,246.69 23.81 10-533-522031 Dangerous Bldg Escrow Expenses 0.00 640.14 24,000.00 -24,640.14 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 344,915.82 257,462.32 36,780.00 50,673.50 14.69 10-533-534010 Telephone 3,701.40 3,142.00 0.00 559.40 15.11 E20 Utilities 3,701.40 3,142.00 0.00 559.40 15.11 10-533-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-533-546010 Clothing Expense 1,200.00 285.79 0.00 914.21 76.18 10-533-547010 Equipment Maintenance 0.00 0.00 0.00 0.00 0.00 10-533-547020 Maintenance Agreements 14,657.20 14,609.68 47.52 0.00 0.00 10-533-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 27 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E25 Repairs & Maintenance 16,127.20 15,165.47 47.52 914.21 5.67 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 632,376.82 522,184.20 36,827.52 73,365.10 11.60 534 Plan & Protect Svcs -Bldg Regs 10-534-501020 Salaries 319,227.85 283,840.93 0.00 35,386.92 11.09 10-534-501050 Parttime(wo Benefits) 0.00 1,430.00 0.00 -1,430.00 0.00 10-534-501060 Seasonal Salaries 0.00 0.00 0.00 0.00 0.00 10-534-501090 Overtime 0.00 6,506.57 0.00 -6,506.57 0.00 10-534-501095 Overtime Straight Pay 0.00 29.10 0.00 -29.10 0.00 10-534-502010 Social Security 24,489.78 20,961.04 0.00 3,528.74 14.41 10-534-502020 Group Health Insurance 71,448.27 59,047.80 0.00 12,400.47 17.36 10-534-502030 Retirement 39,055.60 33,906.07 0.00 5,149.53 13.19 10-534-502040 Workers Compensation 4,756.07 4,756.07 0.00 0.00 0.00 10-534-502050 Life Insurance 384.34 322.85 0.00 61.49 16.00 10-534-502060 Long Term Disability 951.29 798.21 0.00 153.08 16.09 10-534-502070 Employee Assistance Prgm 168.36 158.06 0.00 10.30 6.12 10-534-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 460,481.56 411,756.70 0.00 48,724.86 10.58 10-534-511010 Advertising 100.00 0.00 0.00 100.00 100.00 10-534-511020 Postage 1,100.00 513.60 0.00 586.40 53.31 10-534-512010 Printing 100.00 0.00 0.00 100.00 100.00 10-534-512020 Copies 0.00 0.22 0.00 -0.22 0.00 10-534-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-534-513010 Office Supplies 900.00 406.09 0.00 493.91 54.88 10-534-514017 COVID-19 0.00 10.75 0.00 -10.75 0.00 10-534-514030 Small Tools 100.00 0.00 0.00 100.00 100.00 10-534-515040 First Aid Supplies 15.00 0.00 0.00 15.00 100.00 10-534-517010 Operational Supplies 1,800.00 2,040.63 0.00 -240.63 -13.37 E10 Materials & Supplies 4,115.00 2,971.29 0.00 1,143.71 27.79 10-534-520030 Dues And Publications 3,000.00 3,064.95 0.00 -64.95 -2.17 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 4,002.28 0.00 997.72 19.95 10-534-522020 Professional Services 0.00 1,571.96 0.00 -1,571.96 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 8,639.19 0.00 -639.19 -7.99 10-534-534010 Telephone 900.00 187.00 0.00 713.00 79.22 E20 Utilities 900.00 187.00 0.00 713.00 79.22 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 28 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-534-541030 Vehicle Wash 270.00 270.00 0.00 0.00 0.00 10-534-546010 Clothing Expense 1,180.00 986.00 0.00 194.00 16.44 10-534-547010 Equipment Maintenance 20.00 0.00 0.00 20.00 100.00 10-534-547020 Maintenance Agreements 800.00 930.94 32.25 -163.19 -20.40 10-534-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 2,270.00 2,186.94 32.25 50.81 2.24 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 475,766.56 425,741.12 32.25 49,993.19 10.51 535 Public Works -Central Maintenan 10-535-501020 Salaries 353,324.68 315,294.06 0.00 38,030.62 10.76 10-535-501040 Part-time (wbenefits) 0.00 0.00 0.00 0.00 0.00 10-535-501050 Parttime(wo Benefits) 2,104.60 0.00 0.00 2,104.60 100.00 10-535-501070 Stand-by Plan 0.00 0.00 0.00 0.00 0.00 10-535-501090 Overtime 6,237.07 6,237.07 0.00 0.00 0.00 10-535-501095 Overtime Straight Pay 658.33 658.33 0.00 0.00 0.00 10-535-502010 Social Security 27,717.84 23,429.51 0.00 4,288.33 15.47 10-535-502020 Group Health Insurance 76,549.23 66,738.06 0.00 9,811.17 12.82 10-535-502030 Retirement 43,715.61 39,140.69 0.00 4,574.92 10.47 10-535-502040 Workers Compensation 4,469.36 4,469.36 0.00 0.00 0.00 10-535-502050 Life Insurance 428.50 375.68 0.00 52.82 12.33 10-535-502060 Long Term Disability 1,058.03 927.94 0.00 130.09 12.30 10-535-502070 Employee Assistance Prgm 196.42 103.99 0.00 92.43 47.06 10-535-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 516,459.67 457,374.69 0.00 59,084.98 11.44 10-535-511010 Advertising 80.00 0.00 0.00 80.00 100.00 10-535-511020 Postage 50.00 1.45 0.00 48.55 97.10 10-535-512020 Copies 10.00 0.00 0.00 10.00 100.00 10-535-513010 Office Supplies 1,500.00 456.74 0.00 1,043.26 69.55 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 6,181.95 0.00 818.05 11.69 10-535-517010 Operational Supplies 7,000.00 6,888.18 0.00 111.82 1.60 E10 Materials & Supplies 15,640.00 13,528.32 0.00 2,111.68 13.50 10-535-520030 Dues And Publications 350.00 175.00 0.00 175.00 50.00 10-535-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-535-520070 Training And Education 1,650.00 -74.95 0.00 1,724.95 104.54 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,500.00 600.05 0.00 1,899.95 76.00 10-535-531010 Electricity 7,560.00 5,658.00 0.00 1,902.00 25.16 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 29 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-535-533010 Advertising Natural Gas 3,800.00 1,751.49 0.00 2,048.51 53.91 10-535-534010 200.00 Telephone 220.00 0.00 0.00 220.00 100.00 10-535-535010 0.00 Water 1,442.00 1,081.97 0.00 360.03 24.97 E20 0.00 Utilities 13,022.00 8,491.46 0.00 4,530.54 34.79 10-535-540010 964.00 Building & Grounds Maint. 10,000.00 8,500.75 0.00 1,499.25 14.99 10-535-541010 22.46 Veh & Equip Parts Etc 557,000.00 558,792.39 0.00 -1,792.39 -0.32 10-535-541015 10-540-514040 Vehicle Hail Damage Repair 118,102.76 15,909.57 0.00 102,193.19 86.53 10-535-546010 Operational Supplies Clothing Expense 7,200.00 7,263.38 0.00 -63.38 -0.88 10-535-547010 73,300.00 Equipment Maintenance 1,000.00 390.47 0.00 609.53 60.95 10-535-547020 671.40 Maintenance Agreements 13,300.00 10,272.93 0.00 3,027.07 22.76 10-535-547030 0.00 Radio Maintenance 100.00 0.00 0.00 100.00 100.00 E25 2,398.33 Repairs & Maintenance 706,702.76 601,129.49 0.00 105,573.27 14.94 10-535-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 0.00 Capital Purchases 0.00 0.00 0.00 0.00 0.00 535 Public Works -Central Maintenan 1,254,324.43 1,081,124.01 0.00 173,200.42 13.81 540 Public Works -Admin 10-540-501020 Salaries 218,788.95 194,409.97 0.00 24,378.98 11.14 10-540-501090 Overtime 0.00 0.00 0.00 0.00 0.00 10-540-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-540-502010 Social Security 16,737.35 14,326.07 0.00 2,411.28 14.41 10-540-502020 Group Health Insurance 28,006.51 23,837.89 0.00 4,168.62 14.88 10-540-502030 Retirement 26,692.25 23,718.02 0.00 2,974.23 11.14 10-540-502040 Workers Compensation 219.23 219.23 0.00 0.00 0.00 10-540-502050 Life Insurance 263.16 230.53 0.00 32.63 12.40 10-540-502060 Long Term Disability 535.62 466.17 0.00 69.45 12.97 10-540-502070 Employee Assistance Prgm 84.18 60.49 0.00 23.69 28.14 E05 Personnel Services 291,327.25 257,268.37 0.00 34,058.88 11.69 10-540-511010 Advertising 0.00 0.00 0.00 0.00 0.00 10-540-511020 Postage 200.00 7.85 0.00 192.15 96.08 10-540-512010 Printing 200.00 0.00 0.00 200.00 100.00 10-540-512020 Copies 100.00 0.07 0.00 99.93 99.93 10-540-513010 Office Supplies 1,000.00 36.00 0.00 964.00 96.40 10-540-514010 Gas 71,300.00 55,283.28 0.00 16,016.72 22.46 10-540-514017 COVID-19 0.00 1,294.94 0.00 -1,294.94 0.00 10-540-514040 Food 200.00 187.04 0.00 12.96 6.48 10-540-517010 Operational Supplies 300.00 191.95 0.00 108.05 36.02 E10 Materials & Supplies 73,300.00 57,001.13 0.00 16,298.87 22.24 10-540-520030 Dues And Publications 800.00 671.40 0.00 128.60 16.08 10-540-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-540-520070 Training And Education 3,000.00 601.67 0.00 2,398.33 79.94 10-540-522020 Professional Services 3,200.00 2,742.38 0.00 457.62 14.30 10-540-527010 Comm Sery Projects 0.00 0.00 0.00 0.00 0.00 E15 Contractual Services 7,000.00 4,015.45 0.00 2,984.55 42.64 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 30 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 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 250.00 229.65 10.75 9.60 3.84 E25 Repairs & Maintenance 250.00 229.65 10.75 9.60 3.84 10-540-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 540 Public Works -Admin 371,877.25 318,514.60 10.75 53,351.90 14.35 541 Public Works -Engineering 10-541-501020 Salaries 815,326.68 724,675.70 0.00 90,650.98 11.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 10-541-501080 Step-up Pay 0.00 0.00 0.00 0.00 0.00 10-541-501090 Overtime 536.26 844.00 0.00 -307.74 -57.39 10-541-501095 Overtime Straight Pay 0.00 0.00 0.00 0.00 0.00 10-541-502010 Social Security 62,413.51 52,157.05 0.00 10,256.46 16.43 10-541-502020 Group Health Insurance 125,084.78 114,870.90 0.00 10,213.88 8.17 10-541-502030 Retirement 99,535.28 88,513.34 0.00 11,021.94 11.07 10-541-502040 Workers Compensation 6,055.72 6,055.72 0.00 0.00 0.00 10-541-502050 Life Insurance 982.87 855.34 0.00 127.53 12.98 10-541-502060 Long Term Disability 2,392.68 2,071.48 0.00 321.20 13.42 10-541-502070 Employee Assistance Prgm 336.72 241.90 0.00 94.82 28.16 10-541-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,112,664.50 990,285.43 0.00 122,379.07 11.00 10-541-511010 Advertising 687.75 687.75 0.00 0.00 0.00 10-541-511020 Postage 375.31 264.30 0.00 111.01 29.58 10-541-512010 Printing 53.19 53.19 0.00 0.00 0.00 10-541-512020 Copies 0.47 0.47 0.00 0.00 0.00 10-541-512030 Photographic Supplies 0.00 0.00 0.00 0.00 0.00 10-541-513010 Office Supplies 1,989.77 1,535.42 0.00 454.35 22.83 10-541-514017 COVID-19 0.00 46.40 0.00 -46.40 0.00 10-541-514030 Small Tools 200.00 0.00 0.00 200.00 100.00 10-541-514040 Food 150.00 23.37 0.00 126.63 84.42 10-541-515040 First Aid Supplies 115.72 115.72 0.00 0.00 0.00 10-541-515070 Const & Inspect Supplies 1,000.00 363.67 0.00 636.33 63.63 10-541-515080 Surveying Supplies 1,500.00 610.15 0.00 889.85 59.32 10-541-517010 Operational Supplies 3,785.36 3,774.43 0.00 10.93 0.29 E10 Materials & Supplies 9,857.57 7,474.87 0.00 2,382.70 24.17 10-541-520030 Dues And Publications 4,000.00 2,799.35 0.00 1,200.65 30.02 10-541-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-541-520070 Training And Education 3,365.43 1,142.65 0.00 2,222.78 66.05 10-541-520080 Tuition Reimbursement 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 31 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-541-541030 Vehicle Wash 1,000.00 960.00 0.00 40.00 4.00 10-541-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-541-522020 Professional Services 500.00 123.00 0.00 377.00 75.40 10-541-522055 Stormwater Compliance 500.00 0.00 0.00 500.00 100.00 E15 Contractual Services 8,365.43 4,065.00 0.00 4,300.43 51.41 10-541-534010 Telephone 500.00 386.15 0.00 113.85 22.77 E20 Utilities 500.00 386.15 0.00 113.85 22.77 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,409.56 0.00 90.44 6.03 10-541-547010 Equipment Maintenance 1,000.00 615.00 0.00 385.00 38.50 10-541-547020 Maintenance Agreements 9,652.00 8,514.26 26.82 1,110.92 11.51 10-541-547030 Radio Maintenance 0.00 0.00 0.00 0.00 0.00 E25 Repairs & Maintenance 13,152.00 11,498.82 26.82 1,626.36 12.37 10-541-572010 Purchase of Vehicles 0.00 0.00 0.00 0.00 0.00 10-541-572020 Purchase Of Equipment 0.00 0.00 0.00 0.00 0.00 E70 Capital Purchases 0.00 0.00 0.00 0.00 0.00 10-541-576031 Misc Stormwater Projects 0.00 0.00 0.00 0.00 0.00 10-541-576035 SidewalkGreenway-JCMG 0.00 0.00 0.00 0.00 0.00 E75 Capital Projects 0.00 0.00 0.00 0.00 0.00 541 Public Works -Engineering 1,144,539.50 1,013,710.27 26.82 130,802.41 11.43 542 Public Works -Street 10-542-501020 Salaries 1,232,199.83 1,098,382.42 0.00 133,817.41 10.86 10-542-501060 Seasonal Salaries 20,000.00 15,221.76 0.00 4,778.24 23.89 10-542-501070 Stand-by Plan 5,000.00 3,796.00 0.00 1,204.00 24.08 10-542-501090 Overtime 29,308.44 24,496.76 0.00 4,811.68 16.42 10-542-501095 Overtime Straight Pay 1,191.56 1,191.56 0.00 0.00 0.00 10-542-502010 Social Security 98,509.04 83,620.34 0.00 14,888.70 15.11 10-542-502020 Group Health Insurance 257,026.73 227,242.81 0.00 29,783.92 11.59 10-542-502030 Retirement 154,659.38 137,456.26 0.00 17,203.12 11.12 10-542-502040 Workers Compensation 39,110.84 39,110.84 0.00 0.00 0.00 10-542-502050 Life Insurance 1,471.55 1,302.42 0.00 169.13 11.49 10-542-502060 Long Term Disability 3,590.24 3,172.69 0.00 417.55 11.63 10-542-502070 Employee Assistance Prgm 799.71 574.54 0.00 225.17 28.16 10-542-503010 Awards Program 200.00 0.00 0.00 200.00 100.00 10-542-503020 Unemployment Compensation 0.00 0.00 0.00 0.00 0.00 E05 Personnel Services 1,843,067.32 1,635,568.40 0.00 207,498.92 11.26 10-542-511010 Advertising 926.97 311.50 0.00 615.47 66.40 10-542-511020 Postage 150.00 18.05 0.00 131.95 87.97 10-542-512010 Printing 163.03 163.03 0.00 0.00 0.00 10-542-512020 Copies 10.00 0.53 0.00 9.47 94.70 10-542-513010 Office Supplies 1,600.00 737.42 0.00 862.58 53.91 10-542-514017 COVID-19 0.00 2.331.37 0.00 -2.331.37 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 32 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-542-514020 Chemicals 344,445.29 344,445.29 0.00 0.00 0.00 10-542-514030 Small Tools 9,000.00 7,577.36 0.00 1,422.64 15.81 10-542-514040 Food 2,000.00 1,634.23 0.00 365.77 18.29 10-542-515010 Stormwater Material 0.00 0.00 0.00 0.00 0.00 10-542-515020 Street Materials 354,895.71 313,348.52 8,082.43 33,464.76 9.43 10-542-515040 First Aid Supplies 500.00 0.00 0.00 500.00 100.00 10-542-515060 Weed Control 1,500.00 1,312.00 0.00 188.00 12.53 10-542-515070 Const & Inspect Supplies 200.00 185.71 0.00 14.29 7.15 10-542-517010 Operational Supplies 5,000.00 5,254.85 0.00 -254.85 -5.10 E10 Materials & Supplies 720,391.00 677,319.86 8,082.43 34,988.71 4.86 10-542-520030 Dues And Publications 1,320.00 931.50 0.00 388.50 29.43 10-542-520050 INACTIVE - Mtgs & Conferences 0.00 0.00 0.00 0.00 0.00 10-542-520070 Training And Education 7,040.97 5,234.75 0.00 1,806.22 25.65 10-542-521040 Medical Claimsservices 0.00 0.00 0.00 0.00 0.00 10-542-522020 Professional Services 14,000.00 12,230.35 1,000.00 769.65 5.50 10-542-523010 Equipment Rentlease 200.00 165.00 0.00 35.00 17.50 10-542-524010 Trash Collections 0.00 0.00 0.00 0.00 0.00 10-542-529070 Street Light Installation 639.03 639.03 0.00 0.00 0.00 E15 Contractual Services 23,200.00 19,200.63 1,000.00 2,999.37 12.93 10-542-531010 Electricity 24,734.35 20,982.06 0.00 3,752.29 15.17 10-542-531020 Street Lights 589,589.40 495,473.90 0.00 94,115.50 15.96 10-542-533010 Natural Gas 10,000.00 9,311.97 0.00 688.03 6.88 10-542-534010 Telephone 580.00 658.39 8.00 -86.39 -14.89 10-542-535010 Water 13,390.00 4,567.92 0.00 8,822.08 65.89 E20 Utilities 638,293.75 530,994.24 8.00 107,291.51 16.81 10-542-540010 Building & Grounds Maint. 12,000.00 9,395.51 250.00 2,354.49 19.62 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,704.45 0.00 10,295.55 34.32 10-542-542030 Signs & Marking Paint 62,114.41 61,676.17 498.20 -59.96 -0.10 10-542-546010 Clothing Expense 15,000.00 11,636.77 0.00 3,363.23 22.42 10-542-547010 Equipment Maintenance 3,200.00 110.45 0.00 3,089.55 96.55 10-542-547020 Maintenance Agreements 300.00 8.13 0.00 291.87 97.29 10-542-547030 Radio Maintenance 1,000.00 0.00 0.00 1,000.00 100.00 E25 Repairs & Maintenance 130,614.41 109,155.48 748.20 20,710.73 15.86 10-542-572010 Purchase Of Vehicles 85,120.28 85,105.78 0.00 14.50 0.02 10-542-572020 Purchase Of Equipment 7,555.84 7,555.84 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 92,676.12 92,661.62 0.00 14.50 0.02 542 Public Works -Street 3,448,242.60 3,064,900.23 9,838.63 373,503.74 10.83 700 Transfers & Subsidies GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 33 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable 10-700-590050 Transfer To Tif Fund 15,000.00 2,267.04 0.00 12,732.96 84.89 10-700-590065 Trans to Self -Funded H1thIns 0.00 0.00 0.00 0.00 0.00 10-700-590066 Trans to Workers Comp 0.00 0.00 0.00 0.00 0.00 10-700-590070 Airport Subsidy 250,488.56 250,488.56 0.00 0.00 0.00 10-700-590075 Transit Subsidy 1,147,753.33 1,147,753.33 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 1,413,241.89 1,400,508.93 0.00 12,732.96 0.90 700 Transfers & Subsidies 1,413,241.89 1,400,508.93 0.00 12,732.96 0.90 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 Capvhclegp-pub Works-adm 0.00 0.00 0.00 0.00 0.00 10-900-571070 Capvhcleqp-engineering 0.00 0.00 0.00 0.00 0.00 10-900-571080 Capvhclegp-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 3,424.50 3,424.50 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 34,172.50 997.50 0.00 33,175.00 97.08 10-990-575023 Fire Station 4 Rehab 348,252.57 0.00 0.00 348,252.57 100.00 10-990-576007 Stormwater Improvements 0.00 0.00 -240.00 240.00 0.00 10-990-576020 Pipe Lining 2019 110,000.00 110,000.00 0.00 0.00 0.00 10-990-577042 Mo Blvd Sidewalks 0.00 0.00 0.00 0.00 0.00 10-990-577044 Water Street @ Lohman Landing 0.00 0.00 0.00 0.00 0.00 10-990-577045 Clay Street Plaza 0.00 0.00 0.00 0.00 0.00 10-990-577046 Hwy 54 & Stadium Interchange 0.00 0.00 0.00 0.00 0.00 10-990-577054 Wayfinding 0.00 0.00 0.00 0.00 0.00 10-990-577056 SOMO Sewer Extension 0.00 0.00 0.00 0.00 0.00 10-990-577058 Downtown Streetscape 800.00 0.00 0.00 800.00 100.00 10-990-577060 Ongoing InfrastFacility Needs 285,084.20 69,826.50 112,520.00 102,737.70 36.04 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-590071 Mo Blvd1400-1800 Block 0.00 0.00 0.00 0.00 0.00 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 34 Sort Level Description Budget YTD Actual Encumbered Remaining Budget % UncollectedAvailable E75 Capital Projects 781,733.77 184,248.50 112,280.00 485,205.27 62.07 990 Capital Projects 781,733.77 184,248.50 112,280.00 485,205.27 62.07 Expense Expense 35,550,662.87 30,346,215.30 527,494.54 4,676,953.03 13.16 GL - Trial Balance by Acct Type and Full Acct Number (10/05/2020 - 9:19 AM) Page 35 CITY OF JEFFERSON FISCAL YEAR 2020 ESTIMATED FUND BALANCE FYE2019 UNASSIGNED FUND BALANCE (Audited) $ 7,181,863.13 Reappropriations from FY2019 to FY2020 Unused intern funding used to fund FY20 intern program $ (21,000.00) Purchase of snow plow $ (85,091.28) Structural Survey $ (15,000.00) Neighborhood Stabilization Program $ (47,097.38) LCRA Reimbursement $ (179,343.05) New Fire Station 2 - remaining funds to Fire Station 4 Rehab $ (348,252.57) Future Fire Stations $ (34,172.50) Pipe Lining 2019 $ (110,000.00) Downtown Streetscape $ (800.00) Ongoing Infrastructure/Facility Needs $ (279,500.47) Building Permit Process Review $ (5,000.00) $ (1,125,257.25) 2020 Adjustments/Supplementals FY2020 Supplemental Appropriations: Demolition for 200/202 E. High St $ (300,000.00) Update Software and Port Authority grant match $ (112,685.00) SWAT vests $ (15,000.00) Animal Shelter kennel door flaps $ (13,314.50) LCRA Gap Financing $ (50,357.60) HUD Neighborhood Stabilization Program $ (78,805.90) $ (570,163.00) FYE2020 ESTIMATED Unassigned Fund Balance $ 5,486,442.88 FYE2020 ESTIMATED Fund Balance % of Adopted Budget 16.66% 17% of FY2020 Adopted Budget ($32,930,481) = $5,598,182 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/201 67,013.43 1 28,145.64 37,527.52 Total 1 1 10,806,737.68 1 4,538,829.84 6,352,595.36 average monthly amount for 4 cent lockbox fund **Effective for 25 years starting in 2011 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 53,555.51 COMPARATIVE OCCUPANCY RATE 2016 Occupancy 2020 Occupancy 2019 Occupancy 2018 Occupancy 2017 Occupancy January 47.30% 49.40% 48.10% 48.70% February 55.50% 58.00% 53.40% 56.80% March 41.60% 58.00% 57.60% 62.20% April 34.90% 63.10% 61.70% 62.40% May 42.10% 60.90% 64.60% 63.80% June 55.00% 60.50% 63.20% 70.40% July 53.40% 58.80% 60.30% 65.90% August 46.20% 59.00% 56.80% 61.50% September 63.40% 59.90% 64.50% October 63.80% 65.60% 66.50% November 50.30% 54.80% 51.50% December 44.90% 46.00% 40.80% 2016 Occupancy 2015 Occupancy 2014 Occupancy 51.30% 45.90% 49.20% 58.60% 51.20% 56.00% 59.80% 59.80% 59.30% 67.20% 58.10% 63.70% 64.90% 63.10% 64.70% 64.00% 59.70% 63.70% 58.20% 60.80% 59.70% 56.50% 52.60% 54.20% 62.60% 63.30% 61.20% 62.90% 60.70% 67.60% 50.60% 51.30% 48.90% 42.10% 45.10% 38.30% Tab 2 - Multi -Segment Missouri Hotel R Lodging Association For the month of: August 2020 United States Currency: USD - US Dollar Participation Properties Rooms Census Sample Census Sample 56546 34816 5192267 3874705 West North Central 11 47.6 67.81 88.28 104.961 42.06 71.14 -29.7 -15.9 40:9 40.2 1.2 -28.91 39.1 59.61 85.27 100.241 33.38 59.70 -34.3 -14.9 44.1 -44.1 -0.1 -34.3 1 4770 29341 377109 281188 3.7 -16.8 Branson, MO 35.1 48.7 133.13 119.27 46.77 58.04 -27.8 11.6 -19.4 -18.6 1.0 -27.1 Lake of the Ozarks+ 54.1 61.7 133.11 123.74 71.96 76.30 -12.3 7.6 -5.7 -5.7 0.0 -12.3 Joplin, MO Missouri 11 42.3 63.71 87.75 103.221 37.12 65.80 -33.6 -15.0 43.6 43.3 0.5 -33.31 38.0 59.91 87.52 101.341 33.29 60.72 -36.5 -13.6 45.2 45.8 -1.2 -37.31 1 1150 6911 106328 76680 Kansas MO 41.5 71.5 -17.0 -9.4 -24.8 77.36 0.0 -17.0 6.64 70.48 St Louis, IL 39.3 82.23 108.85 32.36 44.6 -24.5 58.2 58.4 0.5 44.9 38.1 65.7 87.36 107.20 33.25 42.1 -18.5 52.8 53.9 2.3 43.4 342 250 39588 32983 Columbia, MO+ 48.1 60.5 74.18 84.31 35.67 50.98 -20.5 -12.0 -30.0 -30.0 -0.0 -20.5 Jefferson City, MO+ 46.2 58.9 75.86 86.84 35.07 51.16 -21.5 -12.6 -31.4 -31.5 -0.1 -21.6 Springfield, MO 51.1 63.7 74.46 85.94 38.02 54.73 -19.8 -13.4 -30.5 -27.9 3.7 -16.8 Branson, MO 35.1 48.7 133.13 119.27 46.77 58.04 -27.8 11.6 -19.4 -18.6 1.0 -27.1 Lake of the Ozarks+ 54.1 61.7 133.11 123.74 71.96 76.30 -12.3 7.6 -5.7 -5.7 0.0 -12.3 Joplin, MO 48.7 61.6 72.74 90.31 35.41 55.66 -21.0 -19.5 -36.4 -33.9 4.0 -17.9 Saint Joseph, MO+ 75.3 78.6 88.98 94.87 66.96 74.58 4.3 -6.2 -10.2 -10.2 0.0 4.3 Independence, MO+ 48.5 58.41 75.01 82.771 36.37 48.36 -17.0 -9.4 -24.8 -24.8 0.0 -17.0 40.2 58.2 76.43 87.77 30.73 51.10 -30.9 -12.9 -39.9 40.1 -0.5 -31.3 46.8 57.7 81.65 89.70 38.22 51.74 -18.8 -9.0 -26.1 -25.3 1.1 -17.9 43.7 63.0 75.56 86.64 33.05 54.57 -30.6 -12.8 -39.4 -37.7 2.9 -28.5 26.5 48.2 118.37 107.94 31.35 52.00 -45.0 9.7 -39.7 -40.5 -1.3 -45.7 35.9 49.9 116.22 109.32 41.75 54.60 -28.1 6.3 -23.5 -24.1 -0.7 -28.6 44.5 58.5 74.33 82.13 33.09 48.07 -23.9 -9.5 -31.2 -28.4 4.0 -20.9 58.0 61.9 86.70 91.70 50.26 56.78 -6.4 -5.4 -11.5 -22.9 -12.9 -18.5 44.3 57.3 73.53 82.571 32.60 47.30 -22.6 -10.9 -31.1 -32.6 -2.1 -24.3 39 31 4054 3376 15 13 1392 1270 73 51 6594 5000 154 40 14682 5133 34 11 2624 1304 34 25 2575 2221 11 9 992 838 21 141 1631 1352 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 prohibited and subject to legal action. If you have received this report and are NOT a subscriber to this STR Report, please contact us immediately. Source: 2020 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. Acct.# Line Item 2020 Budget Proposed 2021 Budget 2020-2021 Comparison Revenue 4100 Room Tax $ 519,160.00 $ 482,819.00 $ (36,341.00) -7.00% 4200 Interest Earning $ 1,800.00 $ 1,800.00 $ - 0.00% 4300 MDT MMG/MPD $ 71,356.00 $ 15,000.00 $ (56,356.00) -78.98% 4350 Special Events $ 5,000.00 $ 3,500.00 $ (1,500.00) -30.00% 4500 Fundraising Athletic $ 18,500.00 $ 10,000.00 $ (8,500.00) -45.95% 4550 Prison Tour Ticket $ 572,000.00 $ 532,000.00 $ (40,000.00) -6.99% 4560 MSP Museum $ 28,000.00 $ 26,000.00 $ (2,000.00) -7.14% 4700 Misc Advertising $ 2,000.00 $ 2,000.00 $ - 0.00% 4801 JC Promotional Item $ 85,000.00 $ 79,000.00 $ (6,000.00) -7.06% 4900 Miscellaneous $ 3,000.00 $ 3,000.00 $ - 0.00% Total Revenue $ 1,305,816.00 $ 1,155,119.00 $ (150,697.00) -11.54% Payroll Expenses 6100 Salaries and Wages $ 230,250.00 $ 242,600.00 $ 12,350.00 5.36% 6120 Retirement Benefits $ 4,400.00 $ 3,400.00 $ (1,000.00) -22.73% 6130 Payroll Taxes $ 20,000.00 $ 20,000.00 $ - 0.00% 6140 Insurance Benefits $ 42,200.00 $ 52,000.00 $ 9,800.00 23.22% Total Payroll Expenses $ 296,850.00 $ 318,000.00 $ 21,150.00 7.12% Administrative and General Expenses 6200 Auditing and Account $ 21,325.00 $ 21,630.00 $ 305.00 1.43% 6210 Building Rental $ 44,150.00 $ 45,750.00 $ 1,600.00 3.62% 6210 Building Maintenanc( $ 500.00 $ 500.00 $ - 0.00% 6211 Building Utilities $ 3,200.00 $ 3,200.00 $ - 0.00% 6212 Cleaning Services $ 4,020.00 $ 3,200.00 $ (820.00) -20.40% 6213 Security Monitoring $ 500.00 $ 500.00 $ - 0.00% 6220 Computer $ 17,163.00 $ 19,500.00 $ 2,337.00 13.62% 6230 Consulting $ 500.00 $ 500.00 $ - 0.00% 6240 Dues and $ 1,582.00 $ 2,000.00 $ 418.00 26.42% 6245 Depreciation $ 18,000.00 $ 18,000.00 $ - 0.00% 6250 Office Equip Lease & $ 5,000.00 $ 3,891.00 $ (1,109.00) -22.18% 6260 Insurance Premiums $ 8,000.00 $ 8,700.00 $ 700.00 8.75% 6270 Minor Office $ 500.00 $ 500.00 $ - 0.00% 6280 Misc. Expenses $ 4,335.00 $ 5,000.00 $ 665.00 15.34% 6300 Office Supplies $ 2,200.00 $ 2,000.00 $ (200.00) -9.09% 6310 Printing and Binding $ 1,500.00 $ 1,200.00 $ (300.00) -20.00% 6320 Telephone and Fax $ 11,000.00 $ 11,000.00 $ - 0.00% 6330 Training and $ 2,240.00 $ 2,240.00 $ - 0.00% Total Administrative and 1 $ 145,715.00 1 $ 149,311.00 1 $ 3,596.00 1 2.47% Marketing Expenses 6285 Promotional Items $ 56,000.00 $ 50,000.00 $ (6,000.00) -10.71% 6340 Travel Expenses $ 14,000.00 $ 8,400.00 $ (5,600.00) -40.00% 6360 MSP Tour Expenses $ 11,000.00 $ 9,000.00 $ (2,000.00) -18.18% 6361 MSP Salaries and $ 273,249.09 $ 275,500.00 $ 2,250.91 0.82% 6362 MSP Digital $ 36,657.50 $ 31,658.00 $ (4,999.50) -13.64% 6363 MSP Credit Card Fees $ 13,800.00 $ 4,020.00 $ (9,780.00) -70.87% 6364 MSP Janitorial $ 3,960.00 $ 3,960.00 $ - 0.00% 6365 MSP Tour Insurance $ 5,650.00 $ 5,650.00 $ - 0.00% 6367 MSP Advertising $ 48,312.00 $ 34,625.00 $ (13,687.00) -28.33% 6368 MSP Utilites and $ 17,950.00 $ 17,950.00 $ - 0.00% 6369 MSP Capital $0.00 $0.00 $0.00 0.00% 6370 MSP Museum $ 5,000.00 $ 2,000.00 $ (3,000.00) -60.00% 6400 Graphic Design $ 4,000.00 $ 3,000.00 $ (1,000.00) -25.00% 6410 Outdoor Advertising $ 25,700.00 $ 30,000.00 $ 4,300.00 16.73% 6430 Brochures/Printed $ 9,000.00 $ 11,000.00 $ 2,000.00 22.22% 6440 Postage and Freight $ 8,000.00 $ 9,000.00 $ 1,000.00 12.50% 6461 Marketing $ 5,335.00 $ 5,335.00 $ - 0.00% 6470 Print Advertising $ 31,703.00 $ 21,741.00 $ (9,962.00) -31.42% 6490 Market Research $ 1,000.00 $ 1,000.00 $ - 0.00% 6500 Promotion/Publicity $ 7,000.00 $ 5,000.00 $ (2,000.00) -28.57% 6510 Sponsorship $ 42,000.00 $ 38,000.00 $ (4,000.00) -9.52% 6520 Tradeshow Fees $ 12,958.00 $ 5,935.00 $ (7,023.00) -54.20% 6530 Familiarization tour $ 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 $ 31,380.00 $ 26,380.00 $ (5,000.00) -15.93% 6560 Local Promotions $ 5,000.00 $ 5,000.00 $ - 0.00% 6620 Special Events $ 5,000.00 $ 3,000.00 $ (2,000.00) -40.00% 6630 Athletic Events Exp - $ 20,000.00 $ 20,000.00 $ - 0.00% 6640 Athletic Events $ 20,000.00 $ 12,000.00 $ (8,000.00) -40.00% Total Marketing $ 727,654.59 $ 653,154.00 $ (74,500.59) -10.24% Contracted Services 6610 Contracted Services Total Contracted Capital Expenses 6710 Computer Hardware $ 2,000.00 $ 3,000.00 $ 1,000.00 50.00% Total Capital Expenses $ 2,000.00 $ 3,000.00 $ 1,000.00 6800 MSP Preservation $ 133,596.41 $ 111,767.00 5001 Transfer from Reserve ($80,113.00) Total Bureau Expenses $ 1,305,816.00 $ 1,155,119.00 -$150,697.00 -11.54% JCCVB 2021 Budget Acct # Line Item 2021 Budget Explanation of Account Codes Revenue 4100 Room Tax $ 482,819.00 Monthly lodging tax revenues 4200 Interest Earning $ 1,800.00 $45.00 per month 4300 Advertising Coop $ 15,000.00 4350 Special Event $ 3,500.00 $ 2500.00 State Track hotel rebates $ 1,500.00 Misc revenue 4500 Events Revenue $ 10,000.00 $ 6,000.00 Prison Break $ 4,000.00 Misc revenue 4550 Prison Tour Ticket Sales $ 532,000.00 $ 532,000.00 Prison tour ticket sales 4560 MSP Museum Admission $ 26,000.00 $ 26,000.00 Museum admission 4700 Advertising Revenue $ 2,000.00 $ 1,500.00 MSP Hand fans $ 500.00 Misc 4801 Promotional Item Sales $ 79,000.00 $ 79,000.00 CVB and MSP Promotional Items 4900 Misc. Revenue $ 3,000.00 $ 3,000.00 Misc. revenue Total Revenue $ 1,155,119.00 Payroll Expenses 6100 ISalaries and Wages $ 242,600.00 $ 242,600.00 CVB staff salary 6120 Retirement Benefits $ 3,400.00 Additional Staff eligible) $ 3,400.00 Simple retirment plan 3% 6130 Payroll Taxes $ 20,000.00 $ 20,000.00 Includes medicare, federal and state employement taxes 6140 Insurance Benefits $ 52,000.00 $ 52,000.00 Anthem Blue Cross / ACCE Benefits Trust Total Payroll $ 318,000.00 28% Administrative and General Expenses 6200 Auditing and Accounting $ 21,630.00 $ 15,000.00 Monthly Accounting and Payroll services $1,250 per month $ 6,630.00 Annual audit 6210 Building Rental $ 45,750.00 $ 18,625.00 $3,725 per month Jan -May $ 27,125.00 $3,875per month June - Dec. 6211 Building Maintenance $ 500.00 $ 500.00 Misc maintenance 6211 Building Utilities $ 3,200.00 $ 3,200.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 Security Monitoring $ 500.00 $ 275.00 Maintenance contract $ 225.00 Misc. maintenance items 6220 Support/Software $ 19,500.00 8004 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 Monthly payments - $268 $ 375.00 Telephone service contract $ 300.00 Misc 6260 Insurance Premiums $ 8,700.00 $ 4,000.00 Worker's Comp $ 1,368.00 Director & Officers Liability $ 1,796.00 Commercial Package/Umbrella $ 1,536.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 Luncheon (Diplomats, committees and staff) $ 120.00 ACH Payroll processing charge $ 125.00 Staff Holiday Party $ 100.00 Salute to America Lunches $ 3,415.00 Miscellanous (job advertisment, cards.,VIP gifts) 6300 lOffice 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 $ 2,240.00 $ 240.00 MACVB - 2 ppl @$120.00 $ 700.00 Gov.'s Conf. on Tourism $ 800.00 JC Chamber leadership program $ 500.00 Staff training and educational seminars Administrative and General $ 149,311.00 12.93% Marketing Expenses 6285 Promotional Items to sell $ 50,000.00 $50,000.00 JC and MSP items to sell 6340 Travel Expenses $ 8,400.00 $ 3,500.00 Local and miscellanous travel $ 1,500.00 Connect Sports $ 1,300.00 Nat'l Assn. of Sports Commissions $ 800.00 Heritage Clubs Internation (Iowa) $ 700.00 Missouri Governor's Conf on Tourism $ 600.00 MACVB Annual Conference 6520 Tradeshows Fees $ 5,935.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 $ 2,000.00 Miscellanous Tradeshows 6360 MSP Misc Expenses $ 9,000.00 $ 9,000.00 Misc tour expenses 6361 MSP Salaries and Wages $ 275,500.00 $ 275,500.00 Salary, payroll taxes, insur. and ret. 6362 MSP Digital Marketing $ 31,658.00 $ 263.00 Website Hosting (MSP and Museum) $ 20.00 Domain Name Reg (MSP and Museum) $ 9,375.00 Madden Media SEM (monthly expense) $ 5,000.00 Madden Media Content (April) $ 12,000.00 Trip Advisor Banners (monthly Mar - August) $ 5,000.00 Madden Media/Facebook 6363 MSP Credit Card Fees $ 4,020.00 $ 4,020.00 Based on credit card sales and MSP ticket res. system 6364 MSP Janitorial Services $ 3,960.00 $ 3,960.00 Trash and portable pottie monthly service 6365 MSP Tour Insurance $ 5,650.00 $ 5,650.00 MSP tour insurance 6367 MSP Advertising $ 34,625.00 $ 2,500.00 MSP Brochures $ 1,160.00 417 Magazine (April and Sept) $ 4,057.00 AAA Midwest Traveler (Feb amd May) $ 1,548.00 AAA Explore (Feb and May) $ 2,062.50 Best of the Midwest (March) $ 2,000.00 Group Travel Leader (January) $ 4,254.50 Madden Media Insert (April) $ 4,875.00 Midwest Living (May) $ 2,025.00 Missouri Tour Guide -PTM $ 4,000.00 Rural Missouri (April and July) $ 816.00 Select Traveler (July) $ 1,500.00 Show Me Missouri (Mar and June) $ 2,100.00 St Louis Magazine (Mar and May) $ 1,727.00 Misc publications 6368 MSP Utilities and Lawn Service $ 17,950.00 $ 12,500.00 Monthly utilities $ 5,450.00 Lawn service 6369 MSP Capital Improvements $ - 6370 MSP Museum $ 2,000.00 $ 2,000.00 Museum expensess 6400 Graphic Design $ 3,000.00 $ 3,000.00 Miscellaneous (MSP and CVB projects) 6410 Outdoor Advertising $ 30,000.00 $ 12,000.00 Porlier January -December $ 12,000.00 DDI January- December $ 6,000.00 add'I billboards 6430 Brochures and Printed IMaterials $ 11,000.00 $ 11,000.00 Misc. brochures 6440 Postage $ 9,000.00 $ 9,000.00 Monthly postage charges 6461 Marketing Memberships $ 5,335.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 $ 750.00 Missouri Hotel and Lodging Association $ 2,295.00 Misc 6470 Print Advertising $ 21,741.00 $ 6,008.00 Missouri Travel Guide (January 2022 issue) $ 2,062.50 Best of the Midwest $ 4,254.50 Madden Media Insert (Salute -July ) $ 816.00 Select Travel (July) $ 1,500.00 Show Me Missouri (Holiday - Nov) $ 2,100.00 St Louis Magazine (Jul) $ 5,000.00 Misc. print advertisements 6490 Market Research $ 1,000.00 $ 1,000.00 survey incentives 6500 Promotion/Publicity $ 5,000.00 $ 3,000.00 Miscellanous (cards, community events) $ 2,000.00 Lunches with meeting planners/business and community 6510 Sponsorships $ 38,000.00 $ 5,000.00 Salute to America $ 33,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 $ 26,380.00 $ 280.00 jAnnual Hosting $ 175.00 Domain name registration $ 1,550.00 Constant Contact Subscription $ 9,375.00 Madden Media SEM (monthly expense) $ 5,000.00 Madden Media Content $ 10,000.00 Misc. projects 6560 Local Promotion $ 5,000.00 $ 5,000.00 Local events 6620 Special Events $ 3,000.00 $ 600.00 Corvette Classic $ 1,000.00 Prison Break $ 1,400.00 Misc. events 6630 Athletic Events Expenses - JCVB $ 20,000.00 State Track Expenses $ 9,250.20 JCHS Atkins Staduim $ 1,275.00 Breakfast for officials $ 4,300.00 D & K Transportation $ 1,630.00 MSHSAA official rooms $ 800.00 Refreshment/ice $ 500.00 Holiday reception $ 2,244.80 Misc 6640 Athletic Events Committee JExpenses $ 12,000.00 State Track Expenses $ 600.00 Refreshments $ 5,250.00 Lunch for officials Sponsorships $ 4,600.00 Misc. event sponsorships $ 550.00 lMisc. expenses $ 1,000.00 JPrison Break Expenses $ 653,154.00 57% Capital Expenses 6700 JEquipment 6710 lComputer Hardware $ 3,000.00 Total Capital Expenses $ 3,000.00 6800 MSP reserve tor Preservation Projects $ 111,767.00 Restricted funds for MSP preservation project 5001 Transfer from Reserve ($80,113.00)1 1 Total Bureau Expenses $ 1,155,119.00 SUMMARY OF FEMA PROJECTS DISASTER 2019 - 4451DR-MO REIMBURSED PROJECTS ARE HIGHLIGHTED IN GREEN Mosquito Abatement Project Not Allowed Hibernia Pavitt Building and Airport Road Maintenance Shop received insurance proceeds that exceeded FEMA claims Summary of FEMA projects at 9-23-2020 10/12/2020 Wastewater General Fund Estimated 75% Airport Fund Damage Approx. Cost in FEMA Project # Category Name FEMA System Reimbursement 113200 325274 A Debris Removal and Disposal $1,182,895.17 $887,171.38 113147 325275 B Emergency Protective Measures $265,101.22 $198,825.92 113147 3252$3 -B Mesquite Abatement $1g,000.00 $7,5A0-96 116158 335263 B Biosolids / Sludge $91,216.43 $68,412.32 113219 325277 E City Vehicles Repair and Replacement $13,513.00 $10,134.75 133435 373866 G Prison Wall & Fence $150,346.00 $112,759.50 113399 325278 E Airport Terminal $56,461.50 $42,346.13 113402 325279 E Airport Control Tower $13,309.79 $9,982.34 113402 329968 E Hibernia Pavitt Building (airport) $0.00 $0.00 113402 329971 E Airport Road Maintenance Shop $0.00 $0.00 113389 325281 F Wastewater Plant UV System $66,609.31 $49,956.98 115739 334931 F Wastewater Plant Discharge Backup Pumps $115,460.00 $86,595.00 115128 330993 G Airport Fence $69,064.55 $51,798.41 115128 335032 G Highway 54 Pump Station Fence $1,180.00 $885.00 146774 Z Management Costs - Pending Formulation $17,852.17 $17,852.17 $2,043,009.14 $1,536,719.90 REIMBURSED PROJECTS ARE HIGHLIGHTED IN GREEN Mosquito Abatement Project Not Allowed Hibernia Pavitt Building and Airport Road Maintenance Shop received insurance proceeds that exceeded FEMA claims Summary of FEMA projects at 9-23-2020 10/12/2020 $637,171.38 $250,000.00 $198,825.92 $10,134.75 $112,759.50 $17,852.17 $68,412.32 $42,346.13 $9,982.34 $0.00 $0.00 $49,956.98 $86,595.00 $51,798.41 $885.00 $976,743.71 $250,000.00 $104,126.88 $205,849.31 Wastewater General Fund Parks Fund Airport Fund Fund $637,171.38 $250,000.00 $198,825.92 $10,134.75 $112,759.50 $17,852.17 $68,412.32 $42,346.13 $9,982.34 $0.00 $0.00 $49,956.98 $86,595.00 $51,798.41 $885.00 $976,743.71 $250,000.00 $104,126.88 $205,849.31