Loading...
HomeMy Public PortalAbout2020-01-23 packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, January 23, 2020, 2019 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room TENTATIVE AGENDA 1. Call to Order 2. Roll Call 3. Approval of the minutes of the December 19, 2019 meeting 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. List of Capital Projects for Consideration – Steve Crowell 7. Authorization to Approve Merit Pay or Pay-for-Performance Compensation Increase up to 5% for a Specified Number of Employees – Steve Crowell 8. Local Preference Ordinance Language 9. New Business 10. Old Business 11. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, December 19, 2019 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Mihalevich at 7:33 am. Roll call showed that Councilmen Mihalevich, Prather and Hensley were in attendance. Councilman Graham and Councilwoman Wiseman were not in attendance. Councilman Graham joined the meeting at 7:37 am. Next the minutes of the November 21, 2019 meeting were reviewed. A motion to approve was made by Councilman Hensley and seconded by Councilman Prather. 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 December 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 $5,855,214. The average monthly amount collected for the 4 Cent Lockbox Fund is $54,095. A report comparing occupancy rates for 2019, 2018, 2017, 2016, 2015, 2014, and 2013 was included along with a report listing occupancy rates from other cities. The next item on the agenda was a request by Ms. Mueller to terminate sales tax funds 42 and 43 within the general ledger and roll any remaining money to the same projects within sales tax fund 45. A motion was made by Councilman Graham to move this item to full Council for approval and the motion was seconded by Councilman Prather. The motion passed unanimously. There was no new business to discuss. There was no old business to discuss. The meeting adjourned at 8:07 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:January 7, 2020 Re:Sales Tax Revenues The City received the January 1% Sales Tax in the amount of $1,049,305 which is $4,103 less than projected for January. January shortage is $4,103 (0.03%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-19 Jan-20 $1,049,305 $ 1,053,408 ($4,103) Dec-19 Feb-20 $ 907,800 Jan-20 & Oct-Dec 19 Qtrly Mar-20 $ 1,149,910 Feb-20 Apr-20 $ 943,489 Mar-20 May-20 $ 737,589 Apr-20 & Jan-Mar 20 Qtrly Jun-20 $ 1,098,360 May-20 Jul-20 $ 1,126,594 Jun-20 Aug-20 $ 786,630 Jul-20 & Apr-June 20 Qtrly Sep-20 $ 1,217,674 Aug-20 Oct-20 $ 914,214 Sep-20 Nov-20 $ 765,399 Oct-20 & Jul-Sept 20 Qtrly Dec-20 $ 1,173,016 Total Overage/Shortfall $1,049,305 $11,874,085 ($4,103) 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G Receipt Actual Budget Period Receipts Projection2 Variance Nov-19 Jan-20 $513,808 $ 443,575 $70,234 Dec-19 Feb-20 $ 382,261 Jan-20 & Oct-Dec 19 Qtrly Mar-20 $ 484,210 Feb-20 Apr-20 $ 397,289 Mar-20 May-20 $ 310,588 Apr-20 & Jan-Mar 20 Qtrly Jun-20 $ 462,503 May-20 Jul-20 $ 474,392 Jun-20 Aug-20 $ 331,238 Jul-20 & Apr-June 20 Qtrly Sep-20 $ 512,744 Aug-20 Oct-20 $ 384,962 Sep-20 Nov-20 $ 322,298 Oct-20 & Jul-Sept 20 Qtrly Dec-20 $ 493,939 Total Overage/Shortfall $513,808 $5,000,000 $70,234 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-19 Jan-20 $513,808 $ 502,570 $11,238 Dec-19 Feb-20 $ 433,102 Jan-20 & Oct-Dec 19 Qtrly Mar-20 $ 548,610 Feb-20 Apr-20 $ 450,129 Mar-20 May-20 $ 351,896 Apr-20 & Jan-Mar 20 Qtrly Jun-20 $ 524,016 May-20 Jul-20 $ 537,486 Jun-20 Aug-20 $ 375,293 Jul-20 & Apr-June 20 Qtrly Sep-20 $ 580,939 Aug-20 Oct-20 $ 436,162 Sep-20 Nov-20 $ 365,164 Oct-20 & Jul-Sept 20 Qtrly Dec-20 $ 559,633 Total Overage/Shortfall $513,808 $5,665,000 $11,238 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 1/8/2020 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: JANUARY 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 907,800 est.831,936 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 $1,088,631 1,149,910 est.1,118,582 Feb April 1,059,943 893,024 843,561 986,714 $892,285 943,489 est.935,106 Mar May 618,854 648,305 687,741 709,248 $731,421 737,589 est.679,114 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 $1,126,211 1,098,360 est.1,066,992 May July 963,280 1,012,207 1,154,051 1,117,038 $979,846 1,126,594 est.1,045,284 Jun August 562,996 661,518 678,636 821,132 $770,155 786,630 est.698,887 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 $1,262,838 1,217,674 est.1,183,950 Aug October 918,839 903,829 883,215 879,331 $875,539 914,214 est.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 1,049,305 Estimated to Fiscal Year end (based on averages and on Budgeted amount)10,820,677 Total Actual & Estimated $ 11,869,982 Less: Budget 11,874,085 Over (Under) Budget -$ 4,103 $ 1,049,305 $ 1,053,408 $ 1,961,208 $ 3,111,118 $ 4,054,608 $ 4,792,197 $ 5,890,557 $ 7,017,152 $ 7,803,782 $ 9,021,456 $ 9,935,670 $ 10,701,070 $ 11,874,085 $ 500,000 $ 1,000,000 $ 1,500,000 $ 2,000,000 $ 2,500,000 $ 3,000,000 $ 3,500,000 $ 4,000,000 $ 4,500,000 $ 5,000,000 $ 5,500,000 $ 6,000,000 $ 6,500,000 $ 7,000,000 $ 7,500,000 $ 8,000,000 $ 8,500,000 $ 9,000,000 $ 9,500,000 $ 10,000,000 $ 10,500,000 $ 11,000,000 $ 11,500,000 $ 12,000,000 $ 12,500,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 1/8/2020 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: JANUARY 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 382,261 est.408,658 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 $527,714 484,210 est.536,989 Feb April 512,808 431,353 411,020 455,943 $430,468 397,289 est.448,318 Mar May 308,247 322,957 340,162 340,740 $351,775 310,588 est.332,776 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 $554,062 462,503 est.517,458 May July 473,120 498,229 559,119 548,625 $481,405 474,392 est.512,100 Jun August 280,733 330,112 338,618 393,512 $372,416 331,238 est.343,078 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 $615,998 512,744 est.567,923 Aug October 442,371 435,416 425,493 423,478 $421,199 384,962 est.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 513,808 Estimated to Fiscal Year end (based on averages and on Budgeted amount)4,556,425 Total Actual & Estimated $ 5,070,234 Less: Budget 5,000,000 Over (Under) Budget $ 70,234 $ 513,808 $ 443,575 $ 825,835 $ 1,310,045 $ 1,707,335 $ 2,017,923 $ 2,480,426 $ 2,954,818 $ 3,286,056 $ 3,798,800 $ 4,183,762 $ 4,506,061 $ 5,000,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 1/8/2020 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: JANUARY 2020 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 2020 Average Nov January 461,472 455,239 525,521 424,192 $525,690 513,808 act.478,423 Dec February 362,371 405,543 395,217 450,479 $427,689 433,102 est.408,260 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 $527,588 548,610 est.537,176 Feb April 512,738 431,353 411,020 457,060 $430,459 450,129 est.448,526 Mar May 308,030 322,957 340,162 340,708 $350,479 351,896 est.332,467 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 $554,065 524,016 est.517,451 May July 473,038 498,229 559,115 548,639 $481,406 537,486 est.512,085 Jun August 280,513 330,112 338,470 393,578 $372,405 375,293 est.343,015 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 $616,012 580,939 est.568,475 Aug October 442,370 435,416 425,497 423,387 $421,199 436,162 est.429,574 Sept November 330,393 310,506 307,305 374,484 $395,311 365,164 est.343,600 Oct & Jul-Sept Qtrly December 515,368 494,218 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 513,808 Estimated to Fiscal Year end (based on averages and on Budgeted amount)5,162,430 Total Actual & Estimated $ 5,676,238 Less: Budget 5,665,000 Over (Under) Budget $ 11,238 $ 513,808 $ 502,570 $ 935,672 $ 1,484,282 $ 1,934,410 $ 2,286,306 $ 2,810,322 $ 3,347,809 $ 3,723,101 $ 4,304,041 $ 4,740,203 $ 5,105,367 $ 5,665,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 $ 5,600,000 $ 5,850,000 $ 6,100,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Re v e n u e Mo d e l Re p o r t Fo r   t h e   P e r i o d   E n d i n g   O c t o b e r   3 1 ,   2 0 1 9 Da t a   a s   o f   J a n u a r y   9 ,   2 0 2 0 . FY   2 0 1 9 Y T D   A c t u a l P r o j e c t e d   O v e r / De s c r i p t i o n Bu d g e t As   o f   1 / 9 / 2 0 (U n d e r )   B u d g e t Sa l e s   T a x   a n d   U s e   T a x $1 1 , 6 4 1 , 2 6 0 . 0 0 $ 1 1 , 5 1 1 , 6 1 4 . 4 2 ($ 1 2 9 , 6 4 5 . 5 8 ) In t e r g o v e r n m e n t a l   T a x e s $2 , 3 0 0 , 0 0 0 . 0 0 $ 2 , 3 6 4 , 3 8 9 . 0 6 $ 6 4 , 3 8 9 . 0 6 Ot h e r   T a x e s $1 1 0 , 0 0 0 . 0 0 $ 9 8 , 6 1 8 . 2 4 ($ 1 1 , 3 8 1 . 7 6 ) Fr a n c h i s e   &   U t i l i t y   T a x $7 , 4 3 5 , 0 0 0 . 0 0 $ 6 , 6 9 5 , 2 5 5 . 2 9 ($ 7 3 9 , 7 4 4 . 7 1 ) Pr o p e r t y   T a x e s $5 , 4 3 2 , 3 9 9 . 0 0 $ 5 , 4 4 7 , 7 6 5 . 8 7 $ 1 5 , 3 6 6 . 8 7 In t e r g o v e r n m e n t a l $0 . 0 0 $ 1 0 5 , 7 9 7 . 5 2 $ 1 0 5 , 7 9 7 . 5 2 Ch a r g e s   f o r   S e r v i c e s $2 , 7 6 1 , 3 6 4 . 3 9 $ 2 , 8 0 0 , 2 7 8 . 2 4 $ 3 8 , 9 1 3 . 8 5 Fe e s ,   L i c e n s e s ,   &   P e r m i t s $8 7 9 , 4 1 0 . 0 0 $ 9 9 9 , 2 8 7 . 9 7 $ 1 1 9 , 8 7 7 . 9 7 Fi n e s   &   F o r f e i t u r e s $8 3 4 , 9 0 0 . 0 0 $ 6 7 0 , 6 3 1 . 9 4 ($ 1 6 4 , 2 6 8 . 0 6 ) Co n t r i b u t i o n s / D o n a t i o n s $3 3 6 , 4 3 4 . 8 8 $ 3 5 9 , 1 3 2 . 9 9 $ 2 2 , 6 9 8 . 1 1 Ot h e r   O p e r a t i n g   R e v e n u e s $1 1 7 , 8 0 0 . 6 4 $ 2 6 6 , 1 1 7 . 4 5 $ 1 4 8 , 3 1 6 . 8 1 In t e r e s t   I n c o m e $1 5 2 , 9 2 6 . 5 4 $ 1 5 2 , 9 3 6 . 1 4 $ 9 . 6 0 Ot h e r   N o n   O p e r a t i n g   R e v e n u e $1 6 8 , 2 2 9 . 0 8 $ 3 7 4 , 0 0 7 . 3 2 $ 2 0 5 , 7 7 8 . 2 4 Op e r a t i n g   T r a n s f e r s   I n $2 6 , 0 0 0 . 0 0 $2 6 , 8 5 0 . 2 7 $8 5 0 . 2 7 To t a l s $3 2 , 1 9 5 , 7 2 4 . 5 3 $ 3 1 , 8 7 2 , 6 8 2 . 7 2 ($ 3 2 3 , 0 4 1 . 8 1 ) FY2019 Revenue Model Report (Detail)Remaining For the Period Ending October 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification  Description Budget As of 1/9/20 As of 1/9/20 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,641,260.00 $11,489,487.23 $0.00 $11,489,487.23 ($151,772.77)($151,772.77) 10‐100‐400020 Sales Tax Interest $0.00 $22,127.19 $0.00 $22,127.19 $22,127.19 $22,127.19 $11,641,260.00 $11,511,614.42 $0.00 $11,511,614.42 ($129,645.58) ($129,645.58) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $590,000.00 $587,899.01 $0.00 $587,899.01 ($2,100.99)($2,100.99) 10‐100‐403010 Gasoline Tax $1,160,000.00 $1,166,609.36 $0.00 $1,166,609.36 $6,609.36 $6,609.36 10‐100‐430080 Road & Bridge Tax $550,000.00 $609,880.69 $0.00 $609,880.69 $59,880.69 $59,880.69 $2,300,000.00 $2,364,389.06 $0.00 $2,364,389.06 $64,389.06 $64,389.06 Other Taxes 10‐100‐403020 Cig Tax $110,000.00 $98,618.24 $0.00 $98,618.24 ($11,381.76)($11,381.76) $110,000.00 $98,618.24 $0.00 $98,618.24 ($11,381.76)($11,381.76) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,060,000.00 $3,845,884.61 $0.00 $3,845,884.61 ($214,115.39)($214,115.39) 10‐100‐410021 Electric Utility‐AUDIT $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐410030 Gas Utility License Tax $920,000.00 $897,698.98 $0.00 $897,698.98 ($22,301.02)($22,301.02) 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $1,629,366.04 $0.00 $1,629,366.04 ($420,633.96)($420,633.96) 10‐100‐410053 Telephone/Cell Audit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐410060 Cable Franchise Fee $405,000.00 $322,305.66 $0.00 $322,305.66 ($82,694.34)($82,694.34) $7,435,000.00 $6,695,255.29 $0.00 $6,695,255.29 ($739,744.71)($739,744.71) Property Taxes 10‐100‐420010 Current Property Tax $4,760,000.00 $4,760,931.89 $0.00 $4,760,931.89 $931.89 $931.89 10‐100‐420020 Del Property Tax $40,000.00 $53,676.04 $0.00 $53,676.04 $13,676.04 $13,676.04 10‐100‐420040 Fin Institution Tax $44,000.00 $32,895.44 $0.00 $32,895.44 ($11,104.56)($11,104.56) 10‐100‐420050 Prop Tax Int & Penalties $28,000.00 $29,312.52 $0.00 $29,312.52 $1,312.52 $1,312.52 10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10‐100‐420060 Surtax Receipts $465,000.00 $462,017.11 $0.00 $462,017.11 ($2,982.89)($2,982.89) 10‐100‐420080 Special Tax Rev $41,000.00 $54,533.59 $0.00 $54,533.59 $13,533.59 $13,533.59 $5,432,399.00 $5,447,765.87 $0.00 $5,447,765.87 $15,366.87 $15,366.87 Intergovernmental 10‐100‐430010 Federal  Grant $0.00 $68,537.56 $0.00 $68,537.56 $68,537.56 $68,537.56 10‐100‐430040 Local  Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐430060 Drug Forfeiture $0.00 $12,431.81 $0.00 $12,431.81 $12,431.81 $12,431.81 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 $24,828.15 $0.00 $24,828.15 $24,828.15 $24,828.15 $0.00 $105,797.52 $0.00 $105,797.52 $105,797.52 $105,797.52 Charges for Services 10‐100‐440010 Admin Charge Backs $1,555,433.00 $1,558,195.00 $0.00 $1,558,195.00 $2,762.00 $2,762.00 10‐100‐440050 Emt Reimbursement $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10‐100‐440210 Street Cuts $21,000.00 $34,162.00 $0.00 $34,162.00 $13,162.00 $13,162.00 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $10,294.44 $0.00 $10,294.44 ($2,705.56)($2,705.56) 10‐100‐440920 Parts Charge backs $185,000.00 $208,435.26 $0.00 $208,435.26 $23,435.26 $23,435.26 10‐100‐440930 Labor Charge backs $245,000.00 $244,542.16 $0.00 $244,542.16 ($457.84)($457.84) 10‐100‐481020 Cole Cty Animal Rescue $110,461.78 $110,416.80 $0.00 $110,416.80 ($44.98)($44.98) 10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481040 Rent Other $12,000.00 $12,000.00 $0.00 $12,000.00 $0.00 $0.00 10‐100‐481045 Rent‐tower Sites $155,000.00 $160,951.61 $0.00 $160,951.61 $5,951.61 $5,951.61 10‐100‐481065 Parking Spot Maintenance $25,000.00 $25,000.00 $0.00 $25,000.00 $0.00 $0.00 10‐100‐481075 Cole Cty 911 Reimb $384,123.31 $383,987.44 $0.00 $383,987.44 ($135.87)($135.87) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $30.00 $0.00 $30.00 $30.00 $30.00 10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $15,000.00 $0.00 $15,000.00 ($1,850.00)($1,850.00) 10‐100‐481100 Sale Of Grave Sites $4,150.00 $2,919.00 $0.00 $2,919.00 ($1,231.00)($1,231.00) 10‐100‐481105 TIF Administration Fee $9,346.30 $9,346.30 $0.00 $9,346.30 $0.00 $0.00 10‐100‐481110 Long & Short $0.00 ($1.77)$0.00 ($1.77)($1.77)($1.77) $2,761,364.39 $2,800,278.24 $0.00 $2,800,278.24 $38,913.85 $38,913.85 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $66,000.00 $70,110.00 $0.00 $70,110.00 $4,110.00 $4,110.00 10‐100‐450020 Business Licenses $221,770.00 $220,706.18 $0.00 $220,706.18 ($1,063.82)($1,063.82) 10‐100‐450021 Home Occupation Permit $1,870.00 $1,925.00 $0.00 $1,925.00 $55.00 $55.00 10‐100‐450040 Abandoned Bldg. Regist. $0.00 $2,740.00 $0.00 $2,740.00 $2,740.00 $2,740.00 10‐100‐450041 Abandoned Bldg. Admin Fee $8,000.00 $15,910.00 $0.00 $15,910.00 $7,910.00 $7,910.00 10‐100‐450045 Building Construct. Fees $283,000.00 $358,099.37 $0.00 $358,099.37 $75,099.37 $75,099.37 10‐100‐450050 Electrical Certificates $20,000.00 $21,681.00 $0.00 $21,681.00 $1,681.00 $1,681.00 10‐100‐450060 Electrical Permits $2,600.00 $5,274.68 $0.00 $5,274.68 $2,674.68 $2,674.68 10‐100‐450070 Plumbing Licenses $11,000.00 $12,168.00 $0.00 $12,168.00 $1,168.00 $1,168.00 10‐100‐450080 Plumbing Permits $5,000.00 $13,271.37 $0.00 $13,271.37 $8,271.37 $8,271.37 FY2019 Revenue Model Report (Detail)Remaining For the Period Ending October 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification  Description Budget As of 1/9/20 As of 1/9/20 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $1,310.00 $0.00 $1,310.00 ($690.00)($690.00) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $6,365.00 $0.00 $6,365.00 ($635.00)($635.00) 10‐100‐450092 Food Inspection Fees $87,550.00 $86,096.91 $0.00 $86,096.91 ($1,453.09)($1,453.09) 10‐100‐450100 Curb Cut Permits $850.00 $985.00 $0.00 $985.00 $135.00 $135.00 10‐100‐450110 Board Of Adj Fees $3,770.00 $4,000.00 $0.00 $4,000.00 $230.00 $230.00 10‐100‐450120 Sign Permits $6,300.00 $9,037.00 $0.00 $9,037.00 $2,737.00 $2,737.00 10‐100‐450130 Demolition Permits $1,600.00 $3,000.00 $0.00 $3,000.00 $1,400.00 $1,400.00 10‐100‐450150 Acc Rep Fees‐police $12,000.00 $8,675.40 $0.00 $8,675.40 ($3,324.60)($3,324.60) 10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $1,143.66 $0.00 $1,143.66 $93.66 $93.66 10‐100‐450170 Animal Redemption Fees $65,000.00 $75,859.00 $0.00 $75,859.00 $10,859.00 $10,859.00 10‐100‐450180 Animal Vaccinations Fees $5,000.00 $5,300.00 $0.00 $5,300.00 $300.00 $300.00 10‐100‐450185 Animal Cremation Fees $42,000.00 $51,279.00 $0.00 $51,279.00 $9,279.00 $9,279.00 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 $135.00 $0.00 $135.00 $135.00 $135.00 10‐100‐450230 Vacating Right Of Way $800.00 $816.00 $0.00 $816.00 $16.00 $16.00 10‐100‐450250 Rezoning Request $16,100.00 $740.40 $0.00 $740.40 ($15,359.60)($15,359.60) 10‐100‐450255 Planning & Zoning Review Fees $7,350.00 $21,345.00 $0.00 $21,345.00 $13,995.00 $13,995.00 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,315.00 $0.00 $1,315.00 ($485.00)($485.00) $879,410.00 $999,287.97 $0.00 $999,287.97 $119,877.97 $119,877.97 Fines & Forfeitures 10‐100‐460010 Court Cost $74,000.00 $58,380.45 $0.00 $58,380.45 ($15,619.55)($15,619.55) 10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐460018 Inmate Security Fund $12,000.00 $9,650.85 $0.00 $9,650.85 ($2,349.15)($2,349.15) 10‐100‐460020 Jail Cost Recovery $1,500.00 $1,387.52 $0.00 $1,387.52 ($112.48)($112.48) 10‐100‐460025 Alcohol Offense Cost Rec $6,000.00 $3,903.63 $0.00 $3,903.63 ($2,096.37)($2,096.37) 10‐100‐460030 Pol Fines‐traffic $685,000.00 $559,470.25 $0.00 $559,470.25 ($125,529.75)($125,529.75) 10‐100‐460090 Parking Fines $60,000.00 $41,665.00 $0.00 $41,665.00 ($18,335.00)($18,335.00) 10‐100‐460100 Bankcard Charges ($3,600.00)($3,825.76)$0.00 ($3,825.76)($225.76)($225.76) $834,900.00 $670,631.94 $0.00 $670,631.94 ($164,268.06)($164,268.06) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480070 Community Projects Donations $12,366.50 $12,366.50 $0.00 $12,366.50 $0.00 $0.00 10‐100‐480080 Dare Donations $0.00 $800.00 $0.00 $800.00 $800.00 $800.00 10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00 10‐100‐480165 Animal S Donations $1,320.00 $23,527.94 $0.00 $23,527.94 $22,207.94 $22,207.94 10‐100‐481055 Street Repair‐Solid Waste Cntr $322,248.38 $321,938.55 $0.00 $321,938.55 ($309.83)($309.83) 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $336,434.88 $359,132.99 $0.00 $359,132.99 $22,698.11 $22,698.11 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $74,279.21 $0.00 $74,279.21 $74,279.21 $74,279.21 10‐100‐481070 Miscellaneous $45,000.00 $83,185.08 $0.00 $83,185.08 $38,185.08 $38,185.08 10‐100‐481072 TIF Prof Svcs Deposit $22,800.64 $22,800.64 $0.00 $22,800.64 $0.00 $0.00 10‐100‐481074 Revenue Share ‐ Purchasing Card $20,000.00 $17,644.54 $0.00 $17,644.54 ($2,355.46)($2,355.46) 10‐100‐481077 Insurance Claims $20,000.00 $46,796.48 $0.00 $46,796.48 $26,796.48 $26,796.48 10‐100‐481078 Cafeteria Refunds $10,000.00 $21,411.50 $0.00 $21,411.50 $11,411.50 $11,411.50 $117,800.64 $266,117.45 $0.00 $266,117.45 $148,316.81 $148,316.81 Interest Income 10‐100‐470010 Interest $152,926.54 $152,936.14 $0.00 $152,936.14 $9.60 $9.60 $152,926.54 $152,936.14 $0.00 $152,936.14 $9.60 $9.60 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $168,229.08 $374,007.32 $0.00 $374,007.32 $205,778.24 $205,778.24 $168,229.08 $374,007.32 $0.00 $374,007.32 $205,778.24 $205,778.24 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $26,850.27 $0.00 $26,850.27 $850.27 $850.27 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,000.00 $26,850.27 $0.00 $26,850.27 $850.27 $850.27 $32,195,724.53 $31,872,682.72 $0.00 $31,872,682.72 ($323,041.81)($323,041.81) Re v e n u e Mo d e l Re p o r t Fo r   t h e   P e r i o d   E n d i n g   D e c e m b e r   3 1 ,   2 0 1 9 Da t a   a s   o f   J a n u a r y   1 3 ,   2 0 2 0 . FY   2 0 2 0 Y T D   A c t u a l P r o j e c t e d   O v e r / De s c r i p t i o n Bu d g e t As   o f   1 / 1 3 / 2 0 (U n d e r )   B u d g e t Sa l e s   T a x   a n d   U s e   T a x $1 1 , 8 7 4 , 0 8 5 . 2 0 $ 1 , 0 4 9 , 3 0 5 . 0 9 ($ 4 , 1 0 3 . 2 7 ) In t e r g o v e r n m e n t a l   T a x e s $2 , 3 2 2 , 5 0 0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 Ot h e r   T a x e s $1 0 6 , 0 0 0 . 0 0 $ 6 , 9 5 4 . 6 4 ($ 1 , 2 9 9 . 7 8 ) Fr a n c h i s e   &   U t i l i t y   T a x $7 , 2 0 5 , 0 0 0 . 0 0 $ 4 2 2 , 6 8 7 . 3 1 ($ 5 2 , 5 5 1 . 9 1 ) Pr o p e r t y   T a x e s $5 , 4 6 6 , 3 9 9 . 0 0 $ 7 5 4 , 9 3 0 . 4 6 ($ 1 4 6 , 0 3 6 . 9 5 ) In t e r g o v e r n m e n t a l $0 . 0 0 $ 0 . 0 0 $ 0 . 0 0 Ch a r g e s   f o r   S e r v i c e s $2 , 8 7 5 , 1 3 0 . 0 4 $ 1 , 6 6 2 , 2 4 0 . 6 7 ($ 5 , 2 7 7 . 7 3 ) Fe e s ,   L i c e n s e s ,   &   P e r m i t s $9 0 2 , 5 2 0 . 0 0 $ 1 9 2 , 5 0 0 . 2 2 $ 4 9 , 3 9 0 . 2 0 Fi n e s   &   F o r f e i t u r e s $7 6 6 , 6 0 0 . 0 0 $ 7 5 , 6 2 1 . 9 4 ($ 3 1 , 9 2 7 . 0 7 ) Co n t r i b u t i o n s / D o n a t i o n s $3 4 2 , 2 0 9 . 5 6 $ 4 7 , 9 5 3 . 7 0 $ 1 0 , 4 3 9 . 6 4 Ot h e r   O p e r a t i n g   R e v e n u e s $1 0 2 , 0 0 0 . 0 0 $ 9 , 0 3 3 . 7 1 ($ 7 , 5 6 0 . 7 8 ) In t e r e s t   I n c o m e $1 6 0 , 0 0 2 . 0 4 ($ 1 2 4 . 0 6 ) ( $ 1 2 4 . 0 6 ) Ot h e r   N o n   O p e r a t i n g   R e v e n u e $5 5 , 0 0 0 . 0 0 $ 1 8 , 1 8 7 . 7 5 ($ 8 1 2 . 2 5 ) Op e r a t i n g   T r a n s f e r s   I n $2 6 , 0 0 0 . 0 0 $2 , 7 2 0 . 7 1 $1 9 1 . 0 7 To t a l s $3 2 , 2 0 3 , 4 4 5 . 8 4 $ 4 , 2 4 2 , 0 1 2 . 1 4 ($ 1 8 9 , 6 7 2 . 9 0 ) FY2020 Revenue Model Report (Detail)Remaining For the Period Ending December 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification  Description Budget As of 1/13/20 As of 1/13/20 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,874,085.20 $1,049,305.09 $10,820,676.84 $11,869,981.93 ($4,103.27)($4,103.27) 10‐100‐400020 Sales Tax Interest $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11,874,085.20 $1,049,305.09 $10,820,676.84 $11,869,981.93 ($4,103.27) ($4,103.27) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $591,500.00 $0.00 $591,500.00 $591,500.00 $0.00 $0.00 10‐100‐403010 Gasoline Tax $1,161,000.00 $0.00 $1,161,000.00 $1,161,000.00 $0.00 $0.00 10‐100‐430080 Road & Bridge Tax $570,000.00 $0.00 $570,000.00 $570,000.00 $0.00 $0.00 $2,322,500.00 $0.00 $2,322,500.00 $2,322,500.00 $0.00 $0.00 Other Taxes 10‐100‐403020 Cig Tax $106,000.00 $6,954.64 $97,745.58 $104,700.22 ($1,299.78)($1,299.78) $106,000.00 $6,954.64 $97,745.58 $104,700.22 ($1,299.78)($1,299.78) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,100,000.00 $232,184.53 $3,848,433.27 $4,080,617.80 ($19,382.20)($19,382.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 $71,414.51 $885,433.93 $956,848.44 $6,848.44 $6,848.44 10‐100‐410052 Telephone/Cell Utility $1,800,000.00 $116,596.99 $1,648,337.80 $1,764,934.79 ($35,065.21)($35,065.21) 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 $2,491.28 $347,555.78 $350,047.06 ($4,952.94)($4,952.94) $7,205,000.00 $422,687.31 $6,729,760.78 $7,152,448.09 ($52,551.91)($52,551.91) Property Taxes 10‐100‐420010 Current Property Tax $4,790,000.00 $610,514.32 $4,045,678.28 $4,656,192.60 ($133,807.40)($133,807.40) 10‐100‐420020 Del Property Tax $45,000.00 $12,768.88 $35,075.86 $47,844.74 $2,844.74 $2,844.74 10‐100‐420040 Fin Institution Tax $33,000.00 $29,352.90 $0.00 $29,352.90 ($3,647.10)($3,647.10) 10‐100‐420050 Prop Tax Int & Penalties $29,000.00 $6,083.81 $26,879.58 $32,963.39 $3,963.39 $3,963.39 10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10‐100‐420060 Surtax Receipts $467,000.00 $41,811.27 $409,476.63 $451,287.90 ($15,712.10)($15,712.10) 10‐100‐420080 Special Tax Rev $48,000.00 $0.00 $48,321.26 $48,321.26 $321.26 $321.26 $5,466,399.00 $754,930.46 $4,565,431.59 $5,320,362.05 ($146,036.95)($146,036.95) Intergovernmental 10‐100‐430010 Federal  Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐430040 Local  Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐430060 Drug Forfeiture $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480020 NSP Rehab Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Charges for Services 10‐100‐440010 Admin Charge Backs $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 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10‐100‐440210 Street Cuts $27,000.00 $5,144.00 $22,826.65 $27,970.65 $970.65 $970.65 10‐100‐440910 Fuel Charge ‐ backs $12,000.00 $829.44 $10,140.44 $10,969.88 ($1,030.12)($1,030.12) 10‐100‐440920 Parts Charge backs $244,000.00 $202.53 $243,320.75 $243,523.28 ($476.72)($476.72) 10‐100‐440930 Labor Charge backs $275,000.00 $675.00 $273,664.78 $274,339.78 ($660.22)($660.22) 10‐100‐481020 Cole Cty Animal Rescue $112,229.12 $0.00 $112,229.12 $112,229.12 $0.00 $0.00 10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481040 Rent Other $12,000.00 $0.00 $12,000.00 $12,000.00 $0.00 $0.00 10‐100‐481045 Rent‐tower Sites $156,000.00 $7,540.14 $146,103.70 $153,643.84 ($2,356.16)($2,356.16) 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 $64,175.54 $324,993.19 $389,168.73 ($823.08)($823.08) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $2,500.00 $14,350.00 $16,850.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $4,500.00 $417.00 $3,180.90 $3,597.90 ($902.10)($902.10) 10‐100‐481105 TIF Administration Fee $19,802.11 $0.00 $19,802.11 $19,802.11 $0.00 $0.00 10‐100‐481110 Long & Short $0.00 $0.02 $0.00 $0.02 $0.02 $0.02 $2,875,130.04 $1,662,240.67 $1,207,611.64 $2,869,852.31 ($5,277.73)($5,277.73) Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $68,000.00 $1,546.67 $67,335.76 $68,882.43 $882.43 $882.43 10‐100‐450020 Business Licenses $215,000.00 $58,680.93 $160,038.88 $218,719.81 $3,719.81 $3,719.81 10‐100‐450021 Home Occupation Permit $2,000.00 $165.00 $1,768.86 $1,933.86 ($66.14)($66.14) 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 $2,682.00 $6,666.67 $9,348.67 $1,348.67 $1,348.67 10‐100‐450045 Building Construct. Fees $260,000.00 $88,919.42 $212,968.56 $301,887.98 $41,887.98 $41,887.98 10‐100‐450050 Electrical Certificates $22,000.00 $4,665.00 $17,867.66 $22,532.66 $532.66 $532.66 10‐100‐450060 Electrical Permits $4,000.00 $633.40 $3,514.96 $4,148.36 $148.36 $148.36 10‐100‐450070 Plumbing Licenses $12,000.00 $2,409.00 $9,986.79 $12,395.79 $395.79 $395.79 10‐100‐450080 Plumbing Permits $5,800.00 $1,522.50 $5,069.66 $6,592.16 $792.16 $792.16 FY2020 Revenue Model Report (Detail)Remaining For the Period Ending December 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification  Description Budget As of 1/13/20 As of 1/13/20 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $0.00 $1,953.99 $1,953.99 ($46.01)($46.01) 10‐100‐450091 Day Care Inspection Fees $7,300.00 $1,245.00 $5,929.63 $7,174.63 ($125.37)($125.37) 10‐100‐450092 Food Inspection Fees $87,550.00 $3,832.53 $84,205.29 $88,037.82 $487.82 $487.82 10‐100‐450100 Curb Cut Permits $850.00 $760.00 $808.17 $1,568.17 $718.17 $718.17 10‐100‐450110 Board Of Adj Fees $3,770.00 $0.00 $3,232.69 $3,232.69 ($537.31)($537.31) 10‐100‐450120 Sign Permits $6,300.00 $1,575.00 $5,818.89 $7,393.89 $1,093.89 $1,093.89 10‐100‐450130 Demolition Permits $1,600.00 $1,300.00 $1,525.79 $2,825.79 $1,225.79 $1,225.79 10‐100‐450150 Acc Rep Fees‐police $11,500.00 $1,235.00 $9,737.13 $10,972.13 ($527.87)($527.87) 10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $147.77 $1,039.56 $1,187.33 $137.33 $137.33 10‐100‐450170 Animal Redemption Fees $108,000.00 $13,690.00 $94,831.79 $108,521.79 $521.79 $521.79 10‐100‐450180 Animal Vaccinations Fees $5,200.00 $925.00 $4,323.40 $5,248.40 $48.40 $48.40 10‐100‐450185 Animal Cremation Fees $45,000.00 $3,547.00 $38,462.22 $42,009.22 ($2,990.78)($2,990.78) 10‐100‐450186 Animal Boarding Fees $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐450190 Taxi Permits $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐450230 Vacating Right Of Way $800.00 $544.00 $691.58 $1,235.58 $435.58 $435.58 10‐100‐450250 Rezoning Request $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐450255 Planning & Zoning Review Fees $23,000.00 $2,075.00 $19,900.64 $21,975.64 ($1,024.36)($1,024.36) 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $400.00 $1,731.42 $2,131.42 $331.42 $331.42 $902,520.00 $192,500.22 $759,409.98 $951,910.20 $49,390.20 $49,390.20 Fines & Forfeitures 10‐100‐460010 Court Cost $69,000.00 $9,986.10 $58,493.78 $68,479.88 ($520.12)($520.12) 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 $1,066.87 $9,756.10 $10,822.97 ($677.03)($677.03) 10‐100‐460020 Jail Cost Recovery $1,500.00 $80.07 $1,368.11 $1,448.18 ($51.82)($51.82) 10‐100‐460025 Alcohol Offense Cost Rec $4,200.00 $672.36 $3,424.05 $4,096.41 ($103.59)($103.59) 10‐100‐460030 Pol Fines‐traffic $630,000.00 $61,946.66 $539,677.51 $601,624.17 ($28,375.83)($28,375.83) 10‐100‐460090 Parking Fines $54,000.00 $2,320.50 $49,763.52 $52,084.02 ($1,915.98)($1,915.98) 10‐100‐460100 Bankcard Charges ($3,600.00)($450.62)($3,432.08)($3,882.70)($282.70)($282.70) $766,600.00 $75,621.94 $659,050.99 $734,672.93 ($31,927.07)($31,927.07) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480070 Community Projects Donations $9,615.56 $15,153.05 $0.00 $15,153.05 $5,537.49 $5,537.49 10‐100‐480080 Dare Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480090 Police K‐9 Donations $1,000.00 $0.00 $1,000.00 $1,000.00 $0.00 $0.00 10‐100‐480165 Animal S Donations $0.00 $5,508.74 $0.00 $5,508.74 $5,508.74 $5,508.74 10‐100‐481055 Street Repair‐Solid Waste Cntr $331,594.00 $27,291.91 $303,695.50 $330,987.41 ($606.59)($606.59) 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $342,209.56 $47,953.70 $304,695.50 $352,649.20 $10,439.64 $10,439.64 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481070 Miscellaneous $53,000.00 $6,228.42 $37,873.94 $44,102.36 ($8,897.64)($8,897.64) 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 $749.35 $17,623.46 $18,372.81 ($627.19)($627.19) 10‐100‐481077 Insurance Claims $20,000.00 $2,055.94 $19,908.11 $21,964.05 $1,964.05 $1,964.05 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $102,000.00 $9,033.71 $85,405.51 $94,439.22 ($7,560.78)($7,560.78) Interest Income 10‐100‐470010 Interest $160,002.04 ($124.06)$160,002.04 $159,877.98 ($124.06)($124.06) $160,002.04 ($124.06)$160,002.04 $159,877.98 ($124.06)($124.06) Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $55,000.00 $18,187.75 $36,000.00 $54,187.75 ($812.25)($812.25) $55,000.00 $18,187.75 $36,000.00 $54,187.75 ($812.25)($812.25) Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $2,720.71 $23,470.36 $26,191.07 $191.07 $191.07 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,000.00 $2,720.71 $23,470.36 $26,191.07 $191.07 $191.07 $32,203,445.84 $4,242,012.14 $27,771,760.80 $32,013,772.94 ($189,672.90)($189,672.90) CITY OF JEFFERSON FISCAL YEAR 2019 ESTIMATED FUND BALANCE FYE2018 UNASSIGNED FUND BALANCE (Audited) 8,289,016.96$        FYE2019 GENERAL FUND ACTIVITY Unaudited FY2019 Total General Fund Revenues 33,074,656.82$      Unaudited FY2019 Total General Fund Expenditures (34,934,392.29)$     (1,859,735.47)$       FYE2019 ESTIMATED GENERAL FUND BALANCE (Unaudited)6,429,281.49$        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 (351,677.07)$          Future Fire Stations (34,172.50)$            Pipe Lining 2019 (110,000.00)$          Downtown Streetscape (800.00)$                  Ongoing Infrastructure/Facility Needs (279,500.47)$          (1,123,681.75)$       2020 Adjustments/Supplementals FY2020 Supplemental Appropriations: Demolition for 200/202 E. High St (300,000.00)$          (300,000.00)$          FYE2019 ESTIMATED Unassigned Fund Balance 5,005,599.74$        FYE2019 ESTIMATED Fund Balance % of Adopted Budget 15.26% 17% of FY2019 Adopted Budget ($32,807,390) = $5,577,256 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** May-11 6/20/11 91,258.41 38,328.53 51,104.71 Jun-11 7/20/11 101,479.82 42,621.54 56,828.68 Jul-11 8/20/11 88,392.47 37,124.82 49,499.80 Aug-11 9/20/11 73,144.02 30,720.48 40,960.66 Sep-11 10/20/11 103,618.61 43,519.80 58,026.44 Oct-11 11/20/11 105,531.99 44,323.44 59,097.91 Nov-11 12/20/11 66,556.88 27,953.89 37,271.85 Dec-11 1/20/12 52,204.97 21,926.07 29,234.80 Jan-12 2/20/12 65,645.72 27,571.20 36,761.61 566.37 Interest Received Feb-12 3/20/12 85,143.89 35,760.45 47,680.56 383.96 4/2012 Interest Received Mar-12 4/20/12 81,904.23 34,399.77 45,866.38 636.05 5/2012 Interest Received (8.11) 5/2012 Service Charge Apr-12 5/20/12 103,406.71 43,430.82 57,907.76 685.97 6/2012 Interest Received (7.25) 6/2012 Service Charge May-12 6/20/12 89,713.24 37,679.58 50,239.40 785.01 7/2012 Interest Received (7.25) 7/2012 Service Charge Jun-12 7/20/12 86,753.72 36,436.56 48,582.08 832.99 8/2012 Interest Received (7.25) 8/2012 Service Charge Jul-12 8/20/12 89,904.69 37,759.97 50,346.63 Aug-12 9/20/12 76,708.71 32,217.66 42,956.88 887.55 9/2012 Interest Received (7.25) 9/2012 Service Charge 987.59 10/2012 Interest Received (7.50) 10/2012 Service Charge Sep-12 10/20/12 109,335.16 45,920.77 61,227.69 1,011.18 11/2012 Interest Received (7.00) 11/2012 Service Charge Oct-12 11/20/12 109,059.34 45,804.92 61,073.23 45,804.92 JCCVB 3/7 Check Deposited in Error 1,166.54 12/2012 Interest Received (7.50) 12/2012 Service Charge Nov-12 12/20/12 69,756.75 29,297.84 39,063.77 (45,804.92) Correction of Deposit Error 1,185.18 1/2013 Interest Received (7.33) 1/2013 Service Charge Dec-12 1/20/13 55,126.67 23,153.20 30,870.94 1,108.23 2/2013 Interest Received (7.35) 2/2013 Service Charge Jan-13 2/20/13 84,295.92 35,404.29 47,205.71 1,271.02 3/2013 Interest Received (8.28) 3/2013 Service Charge Feb-13 3/20/13 84,199.16 35,363.65 47,151.53 1,297.26 4/2013 Interest Received (8.28) 4/2013 Service Charge Mar-13 4/20/13 98,008.06 41,163.39 54,884.51 1,413.79 5/2013 Interest Received (7.37) 5/2013 Service Charge Apr-13 5/20/13 100,022.48 42,009.44 56,012.59 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 1,450.30 6/2013 Interest Received (8.56) 6/2013 Service Charge (10,000.00) Ck #50 - C H Johnson Consulting May-13 6/20/13 97,602.44 40,993.02 54,657.37 1,570.41 7/2013 Interest Received (8.45) 7/2013 Service Charge (1,187.09) Ck #1001 - C H Johnson Consulting Jun-13 7/20/13 92,796.57 38,974.56 51,966.08 1,620.41 8/2013 Interest Received (8.45) 8/2013 Service Charge (33.25) Ck #1002 - City of Jefferson - RFP Ad (15,000.00) Ck #1003 - C H Johnson Consulting (10,000.00) Ck #1004 - C H Johnson Consulting Jul-13 8/20/13 93,352.06 39,207.87 52,277.15 1,606.48 9/2013 Interest Received (8.79) 9/2013 Service Charge (5,000.00) Ck #1005 - C H Johnson Consulting Aug-13 9/20/13 89,778.97 37,707.17 50,276.22 1,726.08 10/2013 Interest Received (8.45) 10/2013 Service Charge (3,000.00) Ck #1006 - C H Johnson Consulting Sep-13 10/20/13 108,879.17 45,729.25 60,972.34 1,728.36 11/2013 Interest Received (8.45) 11/2013 Service Charge Oct-13 11/20/13 120,248.83 50,504.51 67,339.34 1,864.47 12/2013 Interest Received (8.28) 12/2013 Service Charge Nov-13 12/20/13 84,253.54 35,386.49 47,181.98 1,918.75 1/2014 Interest Received (8.28) 1/2014 Service Charge Dec-13 1/20/14 63,745.74 26,773.21 35,697.61 1,807.90 2/2014 Interest Received (8.28) 2/2014 Service Charge Jan-14 2/20/14 92,051.62 38,661.68 51,548.91 (1,562.61) Ck #1007 - C H Johnson Consulting 2,078.72 3/2014 Interest Received (8.45) 3/2014 Service Charge Feb-14 3/20/14 80,825.68 33,946.79 45,262.38 2,052.68 4/2014 Interest Received (8.28) 4/2014 Service Charge Mar-14 4/30/14 106,553.94 44,752.65 59,670.21 2,198.76 5/2014 Interest Received (8.29) 5/2014 Service Charge Apr-14 5/20/14 104,278.69 43,797.05 58,396.07 2,203.13 6/2014 Interest Received (8.29) 6/2014 Service Charge May-14 6/20/14 116,059.44 48,744.96 64,993.29 2,391.04 7/2014 Interest Received (8.29) 7/2014 Service Charge Jun-14 7/20/14 104,333.69 43,820.15 58,426.87 2,457.38 8/2014 Interest Received (8.29) 8/2014 Service Charge Jul-14 8/20/14 98,901.39 41,538.58 55,384.78 2,459.73 9/2014 Interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** (8.29) 9/2014 Service Charge Aug-14 9/20/14 75,962.88 31,904.41 42,539.21 2,593.43 10/2014 Interest Received (8.29) 10/2014 Service Charge Sep-14 10/20/14 112,370.02 47,195.41 62,927.21 2,586.87 11/2014 Interest Received (8.29) 11/2014 Service Charge Oct-14 11/20/14 116,992.89 49,137.01 65,516.02 2,736.57 12/2014 Interest Received (14.65) 12/2014 Service Charge Nov-14 12/20/14 72,761.33 30,559.76 40,746.34 2,798.53 1/2015 Interest Received (8.29) 1/2015 Service Charge Dec-14 1/20/15 60,394.73 25,365.79 33,821.05 2,575.56 2/2015 Interest Received (8.29) 2/2015 Service Charge Jan-15 2/20/15 85,741.83 36,011.57 48,015.42 2,935.34 3/2015 Interest Received (8.29) 3/2015 Service Charge Feb-15 3/20/15 84,317.61 35,413.40 47,217.86 2,911.14 4/2015 Interest Received (10.54) 4/2015 Service Charge Mar-15 4/20/15 114,789.97 48,211.79 64,282.38 3,049.41 5/2015 Interest Received (8.29) 5/2015 Service Charge Apr-15 5/20/15 102,479.43 43,041.36 57,388.48 3,046.67 6/2015 Interest Received (8.29) 6/2015 Service Charge May-15 6/20/15 116,174.48 48,793.28 65,057.71 3,217.49 7/2015 Interest Received (8.29) 7/2015 Service Charge Jun-15 7/31/15 97,379.11 40,899.23 54,532.30 3,287.90 8/2015 Interest Received (10.67) 8/2015 Service Charge Jul-15 8/20/15 102,541.78 43,067.55 57,423.40 3,307.41 9/2015 Interest Received (8.58) 9/2015 Service Charge Aug-15 9/20/15 81,248.87 34,124.53 45,499.37 3,476.74 10/2015 Interest Received (8.29) 10/2015 Service Charge Sep-15 10/20/15 102,709.81 43,138.12 57,517.49 3,421.47 11/2015 Interest Received (8.00) 11/2015 Service Charge Oct-15 12/1/15 107,837.70 45,291.83 60,389.11 3,605.14 12/2015 Interest Received (8.29) 12/2015 Service Charge Nov-15 12/31/15 67,119.58 28,190.22 37,586.96 Sep-15 1,908.92 801.75 1,069.00 late pays 3,666.35 1/2016 Interest Received (8.29) 1/2016 Service Charge Dec-15 1/31/16 66,959.22 28,122.88 37,497.16 3,478.72 2/2016 Interest Received (8.49) 2/2016 Service Charge Jan-16 2/20/16 83,239.99 34,960.80 46,614.39 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 3,786.20 3/2016 Interest Received (8.28) 3/2016 Service Charge Feb-16 3/20/16 97,559.96 40,975.18 54,633.58 3,718.19 4/2016 Interest Received (8.27) 4/2016 Service Charge Mar-16 4/29/16 101,134.20 42,476.36 56,635.16 3,914.86 5/2016 Interest Received (8.26) 5/2016 Service Charge Apr-16 5/20/16 140,992.87 59,217.01 78,956.01 3,905.43 6/2016 Interest Received May-16 6/20/16 112,152.91 47,104.22 62,805.63 3,985.42 7/2016 Interest Received Jun-16 7/31/16 106,704.37 44,815.83 59,754.44 4,207.43 8/2016 Interest Received Jul-16 8/20/16 96,811.40 40,660.79 54,214.38 4,136.69 9/2016 Interest Received Aug-16 9/20/16 88,674.86 37,243.44 49,657.92 4,350.78 10/2016 Interest Received Sep-16 10/31/16 100,606.10 42,254.56 56,339.42 4,292.30 11/2016 Interest Received Oct-16 11/20/16 120,471.15 50,597.88 67,463.85 4,531.06 12/2016 Interest Received Nov-16 12/20/16 88,755.07 37,277.13 49,702.83 4,602.85 1/2017 Interest Received Dec-16 1/31/17 65,709.30 27,597.91 36,797.21 4,207.06 2/2017 Interest Received Jan-17 2/20/17 95,905.35 40,280.25 53,706.99 4,726.10 3/2017 Interest Received Feb-17 3/31/17 95,135.98 39,957.11 53,276.15 4,651.72 4/2017 Interest Received Mar-17 4/30/17 111,370.63 46,775.67 62,367.55 4,885.76 5/2017 Interest Received Apr-17 5/30/17 109,652.93 46,054.23 61,405.64 4,807.94 6/2017 Interest Received May-17 6/30/17 123,148.39 51,722.32 68,963.10 5,089.00 7/2017 Interest Received Jun-17 7/31/17 120,310.25 50,530.30 67,373.74 5,141.00 8/2017 Interest Received Jul-17 8/20/17 101,096.32 42,460.45 56,613.94 5,081.97 9/2017 Interest Received Aug-17 9/30/17 99,136.13 41,637.18 55,516.23 5,325.63 10/2017 Interest Received Sep-17 10/31/17 112,835.87 47,391.06 63,188.09 5,243.98 11/2017 Interest Received Oct-17 11/20/17 118,132.32 49,615.57 66,154.10 5,519.00 12/2017 Interest Received Nov-17 12/20/17 84,414.19 35,453.96 47,271.95 5,565.66 1/2018 interest Received Dec-17 1/31/18 64,644.90 27,150.86 36,201.14 5,076.25 2/2018 interest Received Jan-18 2/20/18 90,463.34 37,994.60 50,659.47 5,710.59 3/2018 interest Received Feb-18 3/31/18 72,376.53 30,398.14 40,530.86 5,580.76 4/2018 interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** Mar-18 4/30/18 128,168.74 53,830.87 71,774.50 5,862.91 5/2018 interest Received Apr-18 5/30/18 115,538.43 48,526.14 64,701.52 5,744.27 6/2018 interest Received May-18 6/20/18 127,840.04 53,692.82 71,590.42 6,020.86 7/2018 interest Received Jun-18 7/31/18 108,499.02 45,569.59 60,759.45 6,145.34 8/2018 interest Received Jul-18 8/20/18 99,948.25 41,978.26 55,971.02 5,929.16 9/2018 interest Received Aug-18 9/20/18 92,260.57 38,749.44 51,665.92 6,303.93 10/2018 interest Received Sep-18 10/31/18 102,804.82 43,178.02 57,570.70 6,160.57 11/2018 interest Received Oct-18 11/20/18 130,250.45 54,705.19 72,940.25 6,496.60 12/2018 interest Received Nov-18 12/20/18 87,460.75 36,733.51 48,978.02 6,531.01 1/2019 interest Received (3,908.75) CK# 1008 Dec-18 1/31/19 70,508.84 29,613.71 39,484.95 5,949.48 2/2019 interest Received (2,623.75) CK# 1009 Jan-19 2/20/19 88,590.00 37,207.80 49,610.40 6,683.16 3/2019 interest Received Feb-19 3/31/19 99,690.19 41,869.88 55,826.51 6,537.39 4/2019 interest Received Mar-19 4/30/19 121,611.98 51,077.03 68,102.71 6,844.11 5/2019 interest Received (50.75) CK# 1011 (4,867.50) CK# 1012 Apr-19 5/30/19 131,434.04 55,202.30 73,603.06 6,731.55 6/2019 interest Received 200.00 6/26/19 bank deposit May-19 6/20/19 134,504.89 56,492.05 75,322.74 7,065.89 7/2019 interest Received Jun-19 7/31/19 120,530.50 50,622.81 67,497.08 7,131.88 8/2019 interest Received Jul-19 8/20/19 117,844.99 49,494.90 65,993.19 7,014.55 9/2019 interest Received (2,136.63) CK# 1012 Aug-19 9/20/19 114,393.96 48,045.46 64,060.62 7,349.16 10/2019 interest Received Sep-19 10/31/19 125,692.73 52,790.95 70,387.93 7,179.27 11/2019 interest Received (737.50) CK# 1014 Oct-19 11/20/19 136,035.67 57,134.98 76,179.98 7,549.02 12/2019 interest Received Nov-19 12/20/19 98,690.15 41,449.86 55,266.49 Total 10,048,257.87 4,220,268.29 5,918,029.54 average monthly amount for 4 cent lockbox fund 54,106.00$ **Effective for 25 years starting in 2011 2019 Occupancy 2018 Occupancy 2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy January 49.40%48.10%48.70%51.30%45.90%49.20%45.30% February 58.00%53.40%56.80%58.60%51.20%56.00%52.90% March 58.00%57.60%62.20%59.80%59.80%59.30%52.90% April 63.10%61.70%62.40%67.20%58.10%63.70%64.10% May 60.90%64.60%63.80%64.90%63.10%64.70%56.80% June 60.50%63.20%70.40%64.00%59.70%63.70%55.70% July 58.80%60.30%65.90%58.20%60.80%59.70%58.50% August 59.00%56.80%61.50%56.50%52.60%54.20%55.80% September 63.40%59.90%64.50%62.60%63.30%61.20%63.00% October 63.80%65.60%66.50%62.90%60.70%67.60%65.90% November 54.80%51.50%50.60%51.30%48.90%52.40% December 46.00%40.80%42.10%45.10%38.30%38.80% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: October 2019 Percent Change from October 2018 Percent Change from YTD 2018 2019 2018 2019 2018 2019 2018 Occ ADR RevPAR Room Rev Room Avail Room Sold 2019 2018 2019 2018 2019 2018 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 69.3 69.8 133.34 133.98 92.35 93.52 -0.8 -0.5 -1.2 0.8 2.1 1.3 67.8 67.8 132.07 130.95 89.50 88.81 -0.1 0.9 0.8 2.8 2.0 1.9 56509 34823 5361641 4035086 West North Central 63.2 62.7 100.75 100.03 63.66 62.71 0.8 0.7 1.5 3.5 2.0 2.8 60.5 59.8 100.41 100.37 60.74 59.97 1.2 0.0 1.3 3.4 2.0 3.3 4718 2915 373379 279305 Missouri 64.6 63.1 104.98 103.76 67.84 65.43 2.5 1.2 3.7 4.4 0.7 3.2 60.8 60.5 101.93 101.18 62.01 61.18 0.6 0.7 1.4 3.3 1.9 2.5 1148 691 105482 76666 Kansas City, MO-KS 70.4 68.3 111.32 112.33 78.35 76.69 3.1 -0.9 2.2 6.2 3.9 7.1 64.5 64.2 105.38 105.55 67.95 67.79 0.4 -0.2 0.2 3.7 3.4 3.8 315 260 34679 30806 St Louis, MO-IL 69.0 67.5 110.91 108.73 76.52 73.40 2.2 2.0 4.2 4.4 0.1 2.3 66.7 66.9 108.12 106.24 72.06 71.12 -0.4 1.8 1.3 3.2 1.9 1.4 341 253 39104 33038 Columbia, MO+61.3 59.3 98.60 98.44 60.42 58.43 3.2 0.2 3.4 3.1 -0.3 2.9 59.2 57.4 90.29 89.30 53.48 51.29 3.1 1.1 4.3 6.8 2.4 5.6 40 31 4084 3376 Jefferson City, MO+63.8 68.0 92.56 87.56 59.06 59.55 -6.2 5.7 -0.8 9.4 10.3 3.5 58.9 60.0 89.93 85.52 52.96 51.35 -1.9 5.2 3.1 12.7 9.3 7.2 15 13 1392 1270 Springfield, MO 63.8 66.5 90.15 88.14 57.54 58.65 -4.1 2.3 -1.9 2.0 4.0 -0.2 62.8 65.5 87.09 85.96 54.71 56.28 -4.1 1.3 -2.8 -0.8 2.0 -2.1 72 52 6497 5055 Branson, MO 54.1 54.8 105.44 102.38 57.04 56.05 -1.2 3.0 1.8 2.3 0.5 -0.7 49.5 48.4 106.84 106.58 52.88 51.62 2.2 0.2 2.4 3.3 0.8 3.0 155 37 14655 4855 Lake of the Ozarks+48.3 45.4 99.99 100.47 48.25 45.62 6.3 -0.5 5.8 5.0 -0.7 5.5 50.3 48.3 108.18 109.33 54.46 52.78 4.3 -1.1 3.2 5.3 2.0 6.4 34 11 2624 1304 Joplin, MO 63.5 58.8 80.61 80.42 51.20 47.28 8.0 0.2 8.3 8.3 0.0 8.0 59.0 57.6 81.75 83.60 48.24 48.14 2.5 -2.2 0.2 0.2 0.0 2.5 33 24 2477 2123 Saint Joseph, MO+80.0 61.9 93.33 90.06 74.67 55.73 29.3 3.6 34.0 9.5 -18.3 5.6 66.1 59.3 91.57 88.32 60.49 52.40 11.3 3.7 15.4 5.5 -8.6 1.8 11 9 992 838 Independence, MO+64.0 58.9 87.43 85.63 55.96 50.47 8.6 2.1 10.9 10.9 0.0 8.6 58.1 58.5 84.17 84.47 48.92 49.45 -0.7 -0.4 -1.1 -1.1 0.0 -0.7 21 13 1631 1289 A blank row indicates insufficient data. ADRRevPARADR Current Month - October 2019 vs October 2018 Occ % The STR Destination Report is a publication of STR, Inc. and STR Global, Ltd., and is intended solely for use by paid subscribers. Reproduction or distribution of the STR Destination Report , in whole or part, without written permission is prohibited and subject to legal action. If you have received this report and are NOT a subscriber to the STR Destination Report , please contact us immediately. Source: 2019 STR, Inc. / STR Global, Ltd. trading as "STR". Year to Date - October 2019 vs October 2018 Occ %RevPAR Rooms Participation Properties Tab 3 - Help Glossary: Frequently Asked Questions (FAQ): North America:International: 735 East Main Street, Hendersonville, TN 37075 USA Blue Fin Building, 110 Southwark Street, London SE1 0TA T : +1 615 824 8664 T : +44 (0) 20 7922 1930 industryinfo@str.com Asia Pacific: Thong Teck Building, 15 Scotts Road #08-12, 228 218 Singapore T: +64 6800 7850 apinfo@str.com For all STR definitions, please visit www.str.com/resources/glossary For the latest in industry news, visit HotelNewsNow.com. To learn more about the Hotel Data Conference, visit HotelDataConference.com. For all STR FAQs, please click here or visit www.str.com/resources/faq Please visit our website at www.str.com, or if you need additional assistance please reach out to our Customer Support team. destininfo@str.com LIST OF CAPITAL PROJECTS FOR CONSIDERATION (ONE‐TIME FUNDING ‐ NO ONGOING PROJECTS) ITEMS SHADED PINK ARE PRIORITY  ITEMS HIGHLIGHTED IN YELLOW ARE CHANGES OR ADDITIONS SINCE LAST VERSION ITEMS SHADED GREEN COULD QUALIFY FOR SALES TAX G (OR H) FUNDING Microsoft Office 2019 upgrade and email upgrade to Exchange Online $87,000 Springbrook software ‐ upgrade to supported version $20,000 City Hall ‐ replace carpeting in Chamber, purchase elected official and staff chairs and replace  carpeting in Boone‐Bancroft Room $41,000 Gap Financing ‐ Capitol Ave Condemned Properties ‐ Phase 2 (6 to 8 properties) $282,000 Fire Station 1 Roof $105,000 Roof on City Annex (Municipal Court / Fire Administration) $40,000 408 Lafayette Federal Grant Reimbursement (funds can be reallocated to Neighborhood  Stabilization Programs uses, such as sidewalks)$80,000 Administratively‐Ordered Demolitions (1001 Washington, 827 E. High, 422 E. High) $100,000 Administratively‐Ordered Demolitions (200 / 202 E. High) $300,000 Police Fleet Replacement $450,000 Street Sweeper $250,000 Parking Garage ‐ gap financing $1,500,000 Create archive system by scanning building permit drawing files, site plans, deeds, easements, and  other important city documents and link to Springbrook or MidMoGIS $25,000 + Public Works Street Equipment (useful life upgrade) $2,000,000 Downtown and Event wireless $500,000 Parking for Municipal Court Relocation $300,000 Fire Response ATV (Gator with brush unit) $38,000 Mobile and Portable Two‐way Emergency Radios $178,000 MSP Infrastructure $2,000,000 Police Building Renovation $7,900,000 Creek Trail Roundabout $1,800,000 West High Street Bridge Repair $1,000,000+ Fire Station 4 Remodel $400,000 Upgrade Communication/Radio Infrastructure (Fire)$150,000 NFPA 3000 Ballistic Protection for Fire Fighters $80,000 Stormwater Projects ‐ $2 million Annually $2,000,000 Overlay Additions $1,000,000 Neighborhood Sidewalk Repair $1,000,000 Country Club Drive / Hwy 179 / Mall ‐ design and engineer costs $300,000 Country Club Drive / Hwy 179 / Mall ‐ construction costs $3,200,000 Two‐waying Monroe Street ‐ design and engineer costs $300,000 Two‐waying Monroe Street ‐ construction costs $2,700,000 Fire Station (Mission Drive)$3,500,000+ Implementation of Southside Plan:  Phase I Short Term to 7 years projects US‐50 Corridor Urban  Boulevard Improvements, Beautification, & Neighborhood Gateways $2,000,000 Implementation of Southside Plan:  Dunklin Street Improvements and Public Plaza within Core of  Business District $2,000,000 Airport Terminal Improvements ‐ design & construction bathrooms & remodeling $2,000,000 Airport hangar $300,000 Hyde Park Training Tower (burn building replacement) $800,000+ Body Cameras and related hardware/software for Police Dept $500,000 Event Safety Improvements $1,500,000 Downtown Event Support (e.g. public restrooms & water fountains) $500,000 Economic Development Project 2017‐1 $600,000 Airport Tower $4,500,000 Central Maintenance facility relocation / Transit facility replacement $3,000,000 MoDOT/Governor's transportation cost share projects (50:50) $2,000,000 River Port Investments $4,000,000 GRAND TOTAL $47,276,000 Fund Balance Projects November 2019 Nov 2019 1/16/2020  11:47 AM Section 135.380 Local Vendor Preference. [Ord. No. 16-030 §2, 5-9-2016] A. It is the policy of St. Charles County to consider the residual benefits to the St. Charles County economy where the purchase or a component of the purchase has a local source. The County may give preference to all commodities manufactured, mined, produced, or grown within St. Charles County, and to products and services provided by, firms, corporations, or individuals doing business in St. Charles County. "Preference" shall be permitted where products and/or services are of equal or better quality and the difference in the price is negligible. B. Notwithstanding the provisions of Subsection (A) above, the County solicits and will consider quotations/bids/proposals from all interested and qualified vendors. Preference for a local source must be provided to and approved by the Director of Finance. C. Products manufactured in the United States may be given preference if price, quality and other considerations are equal. City of Ashland, Mo. 7.010 Preference To Be given to Ashland and Missouri Products 1. In making purchases the City, or any department or employee thereof shall give preference to all commodities manufactured, mined, produced or grown within the state of Missouri and to all firms, corporations or individuals doing business as Missouri firms, corporations or individuals, when quality is equal or better and delivered price is the same or less. 2. In making purchases the City, or any department or employee thereof shall give preference to all commodities manufactured, mined, produced or grown within the City of Ashland and to all firms, corporations or individuals whose place of business is located within the city limits of Ashland when quality is equal or better and delivered price is not more than ten percent (10%) higher. To be considered as having a place of business within the city limits, the firm, corporation or individual must be able to demonstrate a substantial and continuing business presence within the city. CITY OF OLIVETTE RESOLUTION NO. 48 A RESOLUTION TO ESTABLISH A LOCAL VENDOR PREFERENCE POLICY FOR THE CITY OF OLIVETTE WHEREAS, the Olivette City Council believes that a system of reasonable local business preferences for public contracts and improvement projects will promote the local economy, increase local job opportunities, generate additional municipal tax revenues, and so benefit the public interest, health, safety, and welfare; and WHEREAS, the Council accordingly desires to establish a local business preference policy for the City of Olivette to purchase equipment, material, and supplies from local business, and to hire local contractors to perform public contracts and improvement projects, as provided herein; NOW, THEREFORE, BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF OLIVETTE, MISSOURI AS FOLLOWS: Section 1. Definitions. As used in this section: Local business shall mean a business firm with fixed offices or locally taxable distribution points within the boundaries of the City of Olivette which hold a current business license with an Olivette business address which is not a post office box. Section 2. Award of Contracts for Materials and Supplies. Subject to the limitations contained in this section, in the evaluation of bids or proposals for the award of all contracts for the purchase or lease of supplies, materials, equipment or other personal property, a local business shall, upon written application noted on the space provided on City bid or proposal documents, there shall be extended a five (5%) percent preference for local businesses. The awarding officer, or recommending officer, as applicable, shall consider the quality offered and its conformity with the specifications, the delivery and discount terms and conditions, the service reputation of the bidder, and other information and data required to prove the lowest responsible bidder. Section 3. Award of Contracts for Labor. Subject to the limitations contained in this section, in the evaluation of any contract or hiring of any labor for public contract work, preference shall be given to contractors, mechanics, artisans or other laborers of any class, who shall be a local business as defined herein, provided that the labor, quality and price of the work shall be equal to that of others who would be considered for the award of the contract. Section 4. Award of Personal Service Contracts. Subject to the limitations contained in this section, in the evaluation of a contract for the performance of personal services, upon written application noted on the space provided on the City bid or proposal documents, there shall be extended a five (5%) percent preference for local businesses defined in this section, provided however, that all such contracts shall be awarded on the basis of demonstrated competence and on the professional qualifications necessary for the satisfactory performance of the services required. Section 5. Exemptions. The following contracts are exempt from the provisions of this policy: 1. Contracts to the extent to which application of the provisions of this section would be prohibited by State or Federal law or regulation or would result in what the awarding authority finds to be an unacceptable loss of government revenue or funding. 2. Contracts funded in whole or in part from donations and gifts to the City to the extent the provisions would conflict with any special conditions attached to the gifts or donations, provided the gift and the special conditions have been approved and accepted pursuant to the donations policy of the City. 3. Contracts resulting from exigent emergency conditions where any delay in completion or performance of the contract would jeopardize public health, safety or welfare of the citizens of the City, or where in the judgment of the City Manager or his/her designee the operational effectiveness or a significant City function would be seriously threatened if the contract were not entered into expeditiously. 4. Contracts with any single or sole source supplier for supplies, material, equipment or other personal property. Section 6. This resolution shall take effect from and after its adoption. ADOPTED THIS 10TH DAY OFJANUARY, 2006 _____________________________________ MAYOR DEBORAH ZOOLE-ISRAELI ATTEST: _______________________________ MYRA G. BENNETT CITY CLERK