The URL can be used to link to this page

Home My Public Portal About2019-04-18 packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, April 18, 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 March 21, 2019 meeting and the April 15, 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 7. New Business 8. Old Business 9. 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, March 21, 2019 MINUTES The meeting was called to order by the Finance Committee Vice-Chairman, Councilman Mihalevich at 7:32 am. Roll call showed that Councilmen Mihalevich, Graham, and Hensley were in attendance. Councilman Prather and Councilwoman Wiseman were not in attendance. Councilwoman Wiseman joined the meeting at 7:34 am. Next the minutes of the February 21, 2019 meeting was reviewed. A motion to approve was made by Councilman Hensley and seconded by Councilman Graham. 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 March sales tax receipts, year-to-date general ledger account information, and the current fund balance calculation. The next item on the agenda was a report by 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,183,296. The average monthly amount collected for the 4 Cent Lockbox Fund is $52,710. 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 an update on the Capitol Avenue Phase II by City Attorney, Ryan Moehlman. The next item on the agenda was an update on the Heartland Port by Councilman Mihalevich. Randy Allen and Missy Bonnot from the Jefferson City Chamber of Commerce also provided updates on the work being done on land conveyance and grants. The next item on the agenda was new business. Operations Division Director, Britt Smith provided an update on a snow plow that went down at the beginning of the winter and requested a supplemental appropriation to purchase a new snow plow. A motion was made by Councilman Graham and seconded by Councilman Hensley to move the supplemental appropriation request for $75,000, to purchase a new snow plow from the General Fund fund balance, to full council. The motion passed unanimously. The next item on the agenda was old business. Councilman Mihalevich requested an updated list of capital projects for consideration be presented at the next Finance Committee meeting. A motion was made by Councilwoman Wiseman and seconded by Councilman Graham to adjourn the meeting. The meeting adjourned at 8:10 am. As recorded by: Shiela Pearre, Chief Accountant Minutes of Meeting Jefferson City Council Committee on Finance Monday, April 15, 2019 Item 20 on the Second Regular Council Meeting Agenda (New City Council) 6:00 PM City Council Meeting City Hall - 320 E. McCarty Street City Council Chambers The meeting was convened at 7:50 P.M. by the current Chair of the Committee, Councilman Prather for the purpose of election of officers. Members of the Committee were noted present by roll call: Present: Graham, Hensley, Mihalevich, Prather, and Wiseman Absent: None Councilman Prather opened the floor for nominations of Chair and Vice-Chair. Chair – Councilman Graham nominated Councilman Mihalevich as Chair. Councilwoman Graham motioned to cease nominations and elect Councilman Mihalevich by acclamation. Councilman Prather seconded the motion. Councilman Mihalevich was elected unanimously. Vice-Chair – Councilman Mihalevich nominated Councilman Prather as Vice- Chair. Councilman Mihalevich motioned to cease nominations and elect Councilman Prather by acclamation. Councilwoman Wiseman seconded the motion. Councilman Prather was elected unanimously. There being no further business brought before the Committee at this time, Councilwoman Wiseman moved for adjournment, seconded by Councilman Prather, and approved unanimously at 7:53 P.M. Memo To:Steve Crowell From:Shiela Pearre Date:April 8, 2019 Re:Sales Tax Revenues The City received the April 1% Sales Tax in the amount of $892,285 which is $46,301 less than projected for April. January through April shortage is $52,832 (0.45%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-18 Jan-19 $1,071,917 $ 998,455 $73,462 Dec-18 Feb-19 $885,496 $ 877,738 $7,758 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $1,088,631 $ 1,176,381 ($87,750) Feb-19 Apr-19 $892,285 $ 938,586 ($46,301) Mar-19 May-19 $ 704,912 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 1,090,066 May-19 Jul-19 $ 1,131,589 Jun-19 Aug-19 $ 744,888 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 1,196,290 Aug-19 Oct-19 $ 918,967 Sep-19 Nov-19 $ 694,005 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 1,169,382 Total Overage/Shortfall $3,938,329 $11,641,260 ($52,832) 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G Receipt Actual Budget Period Receipts Projection2 Variance Nov-18 Jan-19 $525,696 $ 428,843 $96,853 Dec-18 Feb-19 $427,711 $ 376,994 $50,717 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $527,714 $ 505,264 $22,450 Feb-19 Apr-19 $430,468 $ 403,129 $27,339 Mar-19 May-19 $ 302,764 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 468,191 May-19 Jul-19 $ 486,025 Jun-19 Aug-19 $ 319,934 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 513,814 Aug-19 Oct-19 $ 394,703 Sep-19 Nov-19 $ 298,080 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 502,257 * BUDGET AMENDMENT DUE TO ORDINANCE 15775 $0 $ 490,329 ($490,329) Total Overage/Shortfall $1,911,589 $5,490,329 ($292,971) 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-18 Jan-19 $525,690 $ 450,285 $75,404 Dec-18 Feb-19 $427,689 $ 395,844 $31,845 Jan-19 & Oct-Dec 18 Qtrly Mar-19 $527,588 $ 530,527 ($2,939) Feb-19 Apr-19 $430,459 $ 423,286 $7,173 Mar-19 May-19 $ 317,903 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $ 491,600 May-19 Jul-19 $ 510,327 Jun-19 Aug-19 $ 335,931 Jul-19 & Apr-June 19 Qtrly Sep-19 $ 539,505 Aug-19 Oct-19 $ 414,438 Sep-19 Nov-19 $ 312,984 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 527,370 Total Overage/Shortfall $1,911,426 $5,250,000 $111,484 3Budgeted based on 3-year average percentage * Original budget amendment due to Ordinance 1577 = $1,035,852 less FY18 overage of $490,329 Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 4/8/2019 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: APRIL 2019 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 944,619 929,179 1,083,570 884,259 1,071,917 act.916,537 Dec February 727,437 812,670 806,789 927,290 885,496 act.812,803 Jan & Oct-Dec Qtrly March 1,091,021 1,183,675 1,073,842 1,155,742 1,088,631 act.1,084,976 Feb April 1,059,943 893,024 843,561 986,714 892,285 act.904,145 Mar May 618,854 648,305 687,741 709,248 704,912 est.693,383 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,090,066 est.1,014,936 May July 963,280 1,012,207 1,154,051 1,117,038 1,131,589 est.1,059,066 Jun August 562,996 661,518 678,636 821,132 744,888 est.667,666 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,196,290 est.1,130,637 Aug October 918,839 903,829 883,215 879,331 918,967 est.900,850 Sept November 661,849 623,645 615,667 774,337 694,005 est.665,316 Oct & Jul-Sept Qtrly December 1,075,638 1,016,682 1,333,160 1,043,108 1,169,382 est.1,096,782 Actual to Date $ 10,856,302 $ 11,002,277 $ 11,304,678 $ 11,470,052 3,938,329 Estimated to Fiscal Year end (based on averages and on Budgeted amount)7,650,099 Total Actual & Estimated $ 11,588,428 Less: Budget 11,641,260 Over (Under) Budget -$ 52,832 $ 1,071,917 $ 1,957,413 $ 3,046,044 $ 3,938,329 $ 998,455 $ 1,876,193 $ 3,052,575 $ 3,991,161 $ 4,696,073 $ 5,786,139 $ 6,917,728 $ 7,662,616 $ 8,858,906 $ 9,777,873 $ 10,471,878 $ 11,641,260 $ 500,000$ 750,000$ 1,000,000$ 1,250,000$ 1,500,000$ 1,750,000$ 2,000,000$ 2,250,000$ 2,500,000$ 2,750,000$ 3,000,000$ 3,250,000$ 3,500,000$ 3,750,000$ 4,000,000$ 4,250,000$ 4,500,000$ 4,750,000$ 5,000,000$ 5,250,000$ 5,500,000$ 5,750,000$ 6,000,000$ 6,250,000$ 6,500,000$ 6,750,000$ 7,000,000$ 7,250,000$ 7,500,000$ 7,750,000$ 8,000,000$ 8,250,000$ 8,500,000$ 8,750,000$ 9,000,000$ 9,250,000$ 9,500,000$ 9,750,000$ 10,000,000$ 10,250,000$ 10,500,000$ 10,750,000$ 11,000,000$ 11,250,000$ 11,500,000$ 11,750,000$ 12,000,000$ 12,250,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 4/8/2019 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: APRIL 2019 Account Number 45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 461,560 455,278 525,521 424,160 525,696 act.445,264 Dec February 362,597 405,543 402,964 444,476 427,711 act.402,011 Jan & Oct-Dec Qtrly March 511,685 563,056 506,597 575,894 527,714 act.516,175 Feb April 512,808 431,353 411,020 455,943 430,468 act.431,859 Mar May 308,247 322,957 340,162 340,740 302,764 est.342,394 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 468,191 est.490,034 May July 473,120 498,229 559,119 548,625 486,025 est.516,592 Jun August 280,733 330,112 338,618 393,512 319,934 est.329,826 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 513,814 est.541,722 Aug October 442,371 435,416 425,493 423,478 394,703 est.431,389 Sept November 330,393 310,506 307,281 374,512 298,080 est.329,478 Oct & Jul-Sept Qtrly December 515,478 494,218 652,070 510,228 502,257 est.531,426 Actual to Date $ 5,260,753 $ 5,356,330 $ 5,500,311 $ 5,545,522 1,911,589 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,285,769 Total Actual & Estimated $ 5,197,358 Less: Budget 5,000,000 Over (Under) Budget $ 197,358 $ 525,696 $ 953,407 $ 1,481,121 $ 1,911,589 $ 428,843 $ 805,838 $ 1,311,101 $ 1,714,231 $ 2,016,995 $ 2,485,186 $ 2,971,211 $ 3,291,146 $ 3,804,960 $ 4,199,663 $ 4,497,743 $ 5,000,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 4/8/2019 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: APRIL 2019 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2015 2016 2017 2018 2019 Average Nov January 461,472 455,239 525,521 424,192 525,690 act.445,226 Dec February 362,371 405,543 395,217 450,479 427,689 act.401,434 Jan & Oct-Dec Qtrly March 511,582 563,039 506,524 577,148 527,588 act.516,368 Feb April 512,738 431,353 411,020 457,060 430,459 act.432,049 Mar May 308,030 322,957 340,162 340,708 317,903 est.341,988 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 491,600 est.490,007 May July 473,038 498,229 559,115 548,639 510,327 est.516,562 Jun August 280,513 330,112 338,470 393,578 335,931 est.329,720 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 539,505 est.542,253 Aug October 442,370 435,416 425,497 423,387 414,438 est.431,353 Sept November 330,393 310,506 307,305 374,484 312,984 est.329,434 Oct & Jul-Sept Qtrly December 515,368 494,218 652,101 510,220 527,370 est.531,381 Actual to Date $ 5,259,477 $ 5,358,988 $ 5,492,397 $ 5,554,002 1,911,426 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,450,058 Total Actual & Estimated $ 5,361,484 Less: Budget 5,250,000 Over (Under) Budget $ 111,484 $ 525,690 $ 953,379 $ 1,480,967 $ 1,911,426 $ 450,285 $ 846,130 $ 1,376,657 $ 1,799,942 $ 2,117,845 $ 2,609,445 $ 3,119,772 $ 3,455,703 $ 3,995,208 $ 4,409,646 $ 4,722,630 $ 5,250,000 $ 100,000 $ 350,000 $ 600,000 $ 850,000 $ 1,100,000 $ 1,350,000 $ 1,600,000 $ 1,850,000 $ 2,100,000 $ 2,350,000 $ 2,600,000 $ 2,850,000 $ 3,100,000 $ 3,350,000 $ 3,600,000 $ 3,850,000 $ 4,100,000 $ 4,350,000 $ 4,600,000 $ 4,850,000 $ 5,100,000 $ 5,350,000 $ 5,600,000 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr- Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget Re v e n u e Mo d e l Re p o r t Fo r th e Pe r i o d En d i n g Ma r c h 31 , 20 1 9 Da t a as of Ap r i l 7, 20 1 9 . FY 20 1 9 Y T D Ac t u a l P r o j e c t e d Ov e r / De s c r i p t i o n Bu d g e t As of 4/ 7 / 1 9 (U n d e r ) Bu d g e t Sa l e s Ta x an d Us e Ta x $1 1 , 6 4 1 , 2 6 0 . 0 0 $ 3 , 9 3 8 , 3 2 9 . 3 0 ($ 5 2 , 8 3 1 . 6 7 ) In t e r g o v e r n m e n t a l Ta x e s $2 , 3 0 0 , 0 0 0 . 0 0 $ 4 1 1 , 5 5 8 . 3 9 ($ 4 , 0 1 5 . 2 0 ) Ot h e r Ta x e s $1 1 0 , 0 0 0 . 0 0 $ 3 1 , 0 3 2 . 8 8 ($ 3 , 7 8 9 . 1 2 ) Fr a n c h i s e & Ut i l i t y Ta x $7 , 4 3 5 , 0 0 0 . 0 0 $ 2 , 2 4 9 , 0 9 8 . 0 7 ($ 1 6 7 , 8 0 4 . 7 1 ) Pr o p e r t y Ta x e s $5 , 4 3 2 , 3 9 9 . 0 0 $ 5 , 2 8 2 , 5 9 5 . 1 8 $ 4 3 , 0 6 9 . 2 7 In t e r g o v e r n m e n t a l $0 . 0 0 $ 1 2 0 , 4 6 3 . 0 9 $ 7 3 , 3 6 5 . 7 1 Ch a r g e s fo r Se r v i c e s $2 , 7 6 1 , 3 6 4 . 3 9 $ 2 , 0 5 4 , 1 4 2 . 3 3 $ 1 4 , 3 0 9 . 3 8 Fe e s , Li c e n s e s , & Pe r m i t s $8 7 9 , 4 1 0 . 0 0 $ 3 3 9 , 0 2 0 . 6 6 $ 5 0 , 6 8 2 . 2 9 Fi n e s & Fo r f e i t u r e s $8 3 4 , 9 0 0 . 0 0 $ 3 2 1 , 1 7 5 . 2 9 ($ 4 9 , 1 1 4 . 7 5 ) Co n t r i b u t i o n s / D o n a t i o n s $3 3 4 , 3 6 4 . 8 8 $ 1 3 1 , 6 8 6 . 8 8 $ 1 1 , 4 4 6 . 1 8 Ot h e r Op e r a t i n g Re v e n u e s $9 5 , 0 0 0 . 0 0 $ 1 0 9 , 1 6 2 . 0 2 $ 7 9 , 9 3 3 . 1 5 In t e r e s t In c o m e $1 5 2 , 9 2 6 . 5 4 $ 5 4 , 1 2 0 . 1 3 $ 7 , 2 8 6 . 6 7 Ot h e r No n Op e r a t i n g Re v e n u e $1 0 4 , 3 6 5 . 0 0 $ 1 1 7 , 0 6 9 . 4 0 $ 3 2 , 7 0 4 . 4 0 Op e r a t i n g Tr a n s f e r s In $2 6 , 0 0 0 . 0 0 $9 , 5 3 0 . 0 1 $5 4 . 3 5 To t a l s $3 2 , 1 0 6 , 9 8 9 . 8 1 $ 1 5 , 1 6 8 , 9 8 3 . 6 3 $ 3 5 , 2 9 5 . 9 4 FY2019 Revenue Model Report (Detail)Remaining For the Period Ending March 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/7/19 As of 4/7/19 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,641,260.00 $3,938,329.30 $7,650,099.03 $11,588,428.33 ($52,831.67)($52,831.67) $11,641,260.00 $3,938,329.30 $7,650,099.03 $11,588,428.33 ($52,831.67) ($52,831.67) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $590,000.00 $130,512.79 $453,985.64 $584,498.43 ($5,501.57)($5,501.57) 10‐100‐403010 Gasoline Tax $1,160,000.00 $281,045.60 $880,440.77 $1,161,486.37 $1,486.37 $1,486.37 10‐100‐430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00 $2,300,000.00 $411,558.39 $1,884,426.41 $2,295,984.80 ($4,015.20)($4,015.20) Other Taxes 10‐100‐403020 Cig Tax $110,000.00 $31,032.88 $75,178.00 $106,210.88 ($3,789.12)($3,789.12) $110,000.00 $31,032.88 $75,178.00 $106,210.88 ($3,789.12)($3,789.12) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,060,000.00 $1,121,993.92 $2,911,647.76 $4,033,641.68 ($26,358.32)($26,358.32) 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 $479,146.61 $434,264.89 $913,411.50 ($6,588.50)($6,588.50) 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $572,192.32 $1,366,650.39 $1,938,842.71 ($111,157.29)($111,157.29) 10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$15,210.20 $0.00 $0.00 $0.00 10‐100‐410060 Cable Franchise Fee $405,000.00 $90,975.42 $290,323.98 $381,299.40 ($23,700.60)($23,700.60) $7,435,000.00 $2,249,098.07 $5,018,097.22 $7,267,195.29 ($167,804.71)($167,804.71) Property Taxes 10‐100‐420010 Current Property Tax $4,760,000.00 $4,687,433.08 $113,514.58 $4,800,947.66 $40,947.66 $40,947.66 10‐100‐420020 Del Property Tax $40,000.00 $28,159.37 $25,304.31 $53,463.68 $13,463.68 $13,463.68 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 $11,023.21 $18,687.50 $29,710.71 $1,710.71 $1,710.71 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 $447,431.69 $9,000.54 $456,432.23 ($8,567.77)($8,567.77) 10‐100‐420080 Special Tax Rev $41,000.00 $21,253.11 $26,366.16 $47,619.27 $6,619.27 $6,619.27 $5,432,399.00 $5,282,595.18 $192,873.09 $5,475,468.27 $43,069.27 $43,069.27 Intergovernmental 10‐100‐430010 Federal Grant $0.00 $68,537.56 $0.00 $68,537.56 $68,537.56 $68,537.56 10‐100‐430040 Local Grant $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480020 NSP Rehab Sales $0.00 $47,097.38 ($47,097.38)$0.00 $0.00 $0.00 10‐100‐480025 HUD Program Income $0.00 $4,828.15 $0.00 $4,828.15 $4,828.15 $4,828.15 $0.00 $120,463.09 ($47,097.38)$73,365.71 $73,365.71 $73,365.71 Charges for Services 10‐100‐440010 Admin Charge Backs $1,555,433.00 $1,558,195.00 $0.00 $1,558,195.00 $2,762.00 $2,762.00 10‐100‐440050 Emt Reimbursement $25,000.00 $0.00 $25,000.00 $25,000.00 $0.00 $0.00 10‐100‐440210 Street Cuts $21,000.00 $13,551.00 $11,982.10 $25,533.10 $4,533.10 $4,533.10 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $3,180.45 $8,591.07 $11,771.52 ($1,228.48)($1,228.48) 10‐100‐440920 Parts Charge backs $185,000.00 $90,044.38 $95,495.08 $185,539.46 $539.46 $539.46 10‐100‐440930 Labor Charge backs $245,000.00 $110,537.96 $140,243.52 $250,781.48 $5,781.48 $5,781.48 10‐100‐481020 Cole Cty Animal Rescue $110,461.78 $27,604.20 $82,846.32 $110,450.52 ($11.26)($11.26) 10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481040 Rent Other $12,000.00 $0.00 $12,000.00 $12,000.00 $0.00 $0.00 10‐100‐481045 Rent‐tower Sites $155,000.00 $58,895.29 $98,947.47 $157,842.76 $2,842.76 $2,842.76 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 $159,373.05 $224,071.89 $383,444.94 ($678.37)($678.37) 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 $6,250.00 $10,600.00 $16,850.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $4,150.00 $1,251.00 $2,407.69 $3,658.69 ($491.31)($491.31) 10‐100‐481105 TIF Administration Fee $9,346.30 $230.00 $9,346.30 $9,576.30 $230.00 $230.00 10‐100‐481110 Long & Short $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2,761,364.39 $2,054,142.33 $721,531.44 $2,775,673.77 $14,309.38 $14,309.38 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $66,000.00 $20,885.00 $56,431.51 $77,316.51 $11,316.51 $11,316.51 10‐100‐450020 Business Licenses $221,770.00 $95,036.54 $126,280.17 $221,316.71 ($453.29)($453.29) 10‐100‐450021 Home Occupation Permit $1,870.00 $990.00 $1,034.98 $2,024.98 $154.98 $154.98 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 $6,825.00 $4,666.67 $11,491.67 $3,491.67 $3,491.67 10‐100‐450045 Building Construct. Fees $283,000.00 $110,012.62 $203,593.43 $313,606.05 $30,606.05 $30,606.05 10‐100‐450050 Electrical Certificates $20,000.00 $18,597.00 $3,121.55 $21,718.55 $1,718.55 $1,718.55 10‐100‐450060 Electrical Permits $2,600.00 $2,125.80 $1,704.59 $3,830.39 $1,230.39 $1,230.39 10‐100‐450070 Plumbing Licenses $11,000.00 $9,180.00 $2,055.79 $11,235.79 $235.79 $235.79 10‐100‐450080 Plumbing Permits $5,000.00 $4,394.00 $3,203.74 $7,597.74 $2,597.74 $2,597.74 FY2019 Revenue Model Report (Detail)Remaining For the Period Ending March 31, 2019 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/7/19 As of 4/7/19 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $27.00 $1,107.51 $1,134.51 ($865.49)($865.49) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $3,140.00 $3,899.67 $7,039.67 $39.67 $39.67 10‐100‐450092 Food Inspection Fees $87,550.00 $4,718.30 $83,431.54 $88,149.84 $599.84 $599.84 10‐100‐450100 Curb Cut Permits $850.00 $110.00 $704.78 $814.78 ($35.22)($35.22) 10‐100‐450110 Board Of Adj Fees $3,770.00 $2,800.00 $2,501.25 $5,301.25 $1,531.25 $1,531.25 10‐100‐450120 Sign Permits $6,300.00 $2,212.00 $3,632.90 $5,844.90 ($455.10)($455.10) 10‐100‐450130 Demolition Permits $1,600.00 $400.00 $1,037.17 $1,437.17 ($162.83)($162.83) 10‐100‐450150 Acc Rep Fees‐police $12,000.00 $3,633.40 $7,214.91 $10,848.31 ($1,151.69)($1,151.69) 10‐100‐450160 Accrpt/blastg P‐fire $1,050.00 $314.00 $842.77 $1,156.77 $106.77 $106.77 10‐100‐450170 Animal Redemption Fees $65,000.00 $22,319.00 $41,315.98 $63,634.98 ($1,365.02)($1,365.02) 10‐100‐450180 Animal Vaccinations Fees $5,000.00 $2,200.00 $2,932.33 $5,132.33 $132.33 $132.33 10‐100‐450185 Animal Cremation Fees $42,000.00 $17,413.00 $27,456.23 $44,869.23 $2,869.23 $2,869.23 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 $272.00 $369.23 $641.23 ($158.77)($158.77) 10‐100‐450250 Rezoning Request $16,100.00 $0.00 $7,176.94 $7,176.94 ($8,923.06)($8,923.06) 10‐100‐450255 Planning & Zoning Review Fees $7,350.00 $10,149.00 $4,328.57 $14,477.57 $7,127.57 $7,127.57 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,240.00 $1,027.42 $2,267.42 $467.42 $467.42 $879,410.00 $339,020.66 $591,071.63 $930,092.29 $50,682.29 $50,682.29 Fines & Forfeitures 10‐100‐460010 Court Cost $74,000.00 $28,367.85 $41,518.13 $69,885.98 ($4,114.02)($4,114.02) 10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐460018 Inmate Security Fund $12,000.00 $4,698.23 $6,715.36 $11,413.59 ($586.41)($586.41) 10‐100‐460020 Jail Cost Recovery $1,500.00 $483.47 $1,085.11 $1,568.58 $68.58 $68.58 10‐100‐460025 Alcohol Offense Cost Rec $6,000.00 $2,004.34 $3,232.52 $5,236.86 ($763.14)($763.14) 10‐100‐460030 Pol Fines‐traffic $685,000.00 $270,038.47 $385,152.79 $655,191.26 ($29,808.74)($29,808.74) 10‐100‐460090 Parking Fines $60,000.00 $16,808.00 $29,304.12 $46,112.12 ($13,887.88)($13,887.88) 10‐100‐460100 Bankcard Charges ($3,600.00)($1,225.07)($2,398.08)($3,623.15)($23.15)($23.15) $834,900.00 $321,175.29 $464,609.96 $785,785.25 ($49,114.75)($49,114.75) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480070 Community Projects Donations $11,616.50 $11,616.50 $0.00 $11,616.50 $0.00 $0.00 10‐100‐480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00 10‐100‐480165 Animal S Donations $0.00 $13,082.38 $0.00 $13,082.38 $13,082.38 $13,082.38 10‐100‐481055 Street Repair‐Solid Waste Cntr $322,248.38 $105,988.00 $214,124.18 $320,112.18 ($2,136.20)($2,136.20) 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $334,364.88 $131,686.88 $214,124.18 $345,811.06 $11,446.18 $11,446.18 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 $18,770.63 $25,174.48 $43,945.11 ($1,054.89)($1,054.89) 10‐100‐481072 TIF Prof Svcs Deposit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481074 Revenue Share ‐ Purchasing Card $20,000.00 $6,078.08 $13,665.68 $19,743.76 ($256.24)($256.24) 10‐100‐481077 Insurance Claims $20,000.00 $10,034.10 $16,930.96 $26,965.06 $6,965.06 $6,965.06 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $95,000.00 $109,162.02 $65,771.13 $174,933.15 $79,933.15 $79,933.15 Interest Income 10‐100‐470010 Interest $152,926.54 $54,120.13 $106,093.08 $160,213.21 $7,286.67 $7,286.67 $152,926.54 $54,120.13 $106,093.08 $160,213.21 $7,286.67 $7,286.67 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $104,365.00 $117,069.40 $20,000.00 $137,069.40 $32,704.40 $32,704.40 $104,365.00 $117,069.40 $20,000.00 $137,069.40 $32,704.40 $32,704.40 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $26,000.00 $9,530.01 $16,524.34 $26,054.35 $54.35 $54.35 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,000.00 $9,530.01 $16,524.34 $26,054.35 $54.35 $54.35 $32,106,989.81 $15,168,983.63 $16,973,302.12 $32,142,285.75 $35,295.94 $35,295.94 CITY OF JEFFERSON FISCAL YEAR 2019 ESTIMATED FUND BALANCE FYE2018 UNASSIGNED FUND BALANCE (Unaudited)8,289,017.00$ Reappropriations from FY2018 to FY2019 Remaining Port Feasibility Study (4,199.50)$ LCRA Reimbursement (259,000.00)$ Police Clothing Expense (7,398.50)$ Purchase of Police Vehicles (122,828.56)$ Historic Preservation Grant (34,200.00)$ Neighborhood Stabilization Program (47,097.38)$ Demo (34,905.00)$ PPS Computer Software (7,168.00)$ Fire ‐ Fitness Equipment (16,213.00)$ New Fire Station 2 (1,159,086.98)$ Stormwater Improvements (406,000.00)$ Downtown Streetscape (1,300.00)$ Ongoing Infrastructure/Facility Needs (354,182.55)$ (2,453,579.47)$ 2019 Adjustments/Supplementals FY2019 Supplemental Appropriations: Salt/Chemicals for Snow Removal (130,000.00)$ (130,000.00)$ FYE2019 ESTIMATED Unassigned Fund Balance 5,705,437.53$ FYE2019 ESTIMATED Fund Balance % of Adopted Budget 17.39% 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 Total 8,947,518.96 3,757,957.95 5,245,805.30 average monthly amount for 4 cent lockbox fund 52,743.27$ **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 57.60%62.20%59.80%59.80%59.30%52.90% April 61.70%62.40%67.20%58.10%63.70%64.10% May 64.60%63.80%64.90%63.10%64.70%56.80% June 63.20%70.40%64.00%59.70%63.70%55.70% July 60.30%65.90%58.20%60.80%59.70%58.50% August 56.80%61.50%56.50%52.60%54.20%55.80% September 59.90%64.50%62.60%63.30%61.20%63.00% October 65.60%66.50%62.90%60.70%67.60%65.90% November 54.80%51.50%50.60%51.30%48.90%52.40% December 46.00%40.80%42.10%45.10%38.30%38.80% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: February 2019 Percent Change from February 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 62.2 61.7 128.94 126.56 80.15 78.13 0.7 1.9 2.6 4.8 2.1 2.8 58.3 57.9 126.72 125.00 73.82 72.35 0.7 1.4 2.0 4.1 2.1 2.7 54571 34002 5230148 3954086 West North Central 49.7 49.6 93.20 101.01 46.34 50.09 0.3 -7.7 -7.5 -5.5 2.1 2.4 46.1 46.1 91.59 96.49 42.25 44.47 0.1 -5.1 -5.0 -2.9 2.2 2.3 4556 2846 362205 273667 Missouri 50.4 50.5 95.21 93.43 48.02 47.22 -0.2 1.9 1.7 4.2 2.4 2.2 46.2 46.4 93.21 91.52 43.06 42.49 -0.5 1.9 1.4 3.8 2.4 1.9 1094 680 101532 75951 Kansas City, MO-KS 55.9 55.6 102.17 99.42 57.12 55.29 0.5 2.8 3.3 7.2 3.8 4.3 53.0 51.7 99.82 97.18 52.88 50.27 2.4 2.7 5.2 9.3 3.9 6.4 305 251 33623 29905 St Louis, MO-IL 56.1 57.5 101.18 98.19 56.78 56.46 -2.4 3.0 0.6 2.7 2.2 -0.3 50.9 52.8 98.18 95.84 49.96 50.57 -3.6 2.4 -1.2 0.9 2.2 -1.5 341 257 39725 33791 Columbia, MO+55.7 51.0 90.86 89.00 50.61 45.41 9.2 2.1 11.5 17.2 5.2 14.8 49.3 44.9 85.83 85.17 42.30 38.28 9.7 0.8 10.5 16.4 5.3 15.5 40 31 4087 3379 Jefferson City, MO+58.0 53.4 83.57 82.34 48.48 43.96 8.7 1.5 10.3 20.0 8.8 18.2 53.6 50.6 80.99 81.68 43.39 41.31 5.9 -0.8 5.0 9.4 4.2 10.3 16 12 1625 1140 Springfield, MO 51.7 56.1 79.69 78.95 41.16 44.25 -7.9 0.9 -7.0 -5.0 2.2 -5.8 48.8 52.0 78.42 77.78 38.30 40.48 -6.2 0.8 -5.4 -3.4 2.1 -4.2 71 51 6357 4915 Branson, MO 29.7 30.1 84.85 91.89 25.19 27.69 -1.5 -7.7 -9.0 -8.3 0.8 -0.7 26.0 24.7 87.61 90.35 22.74 22.29 5.2 -3.0 2.0 2.8 0.8 6.0 110 26 10444 3938 Lake of the Ozarks+33.0 30.0 89.55 85.73 29.54 25.74 9.9 4.5 14.8 15.1 0.3 10.2 30.6 27.9 89.62 87.52 27.46 24.37 10.0 2.4 12.7 13.0 0.3 10.4 30 10 2404 1160 Joplin, MO 52.7 53.9 80.76 82.43 42.55 44.41 -2.2 -2.0 -4.2 -4.2 0.0 -2.2 46.6 49.2 79.56 80.99 37.10 39.83 -5.2 -1.8 -6.8 -6.8 0.0 -5.2 33 24 2477 2123 Saint Joseph, MO+53.8 52.4 87.68 87.20 47.21 45.69 2.8 0.6 3.3 -1.2 -4.4 -1.7 49.6 46.4 86.51 86.25 42.90 40.00 6.9 0.3 7.2 2.6 -4.4 2.2 12 11 1161 1107 Independence, MO+48.3 46.9 76.69 76.63 37.02 35.94 2.9 0.1 3.0 3.0 0.0 2.9 47.8 45.3 79.84 76.36 38.15 34.57 5.5 4.6 10.3 10.3 0.0 5.5 21 14 1631 1392 A blank row indicates insufficient data. RevPAR PropertiesADR Participation Occ % Current Month - February 2019 vs February 2018 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". RevPARADROcc % Year to Date - February 2019 vs February 2018 Rooms 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 For all STR FAQs, please click here or visit www.str.com/resources/faq For the latest in industry news, visit HotelNewsNow.com. destininfo@str.com For all STR definitions, please visit www.str.com/resources/glossary To learn more about the Hotel Data Conference, visit HotelDataConference.com. apinfo@str.com Please visit our website at www.str.com, or if you need additional assistance please reach out to our Customer Support team. LIST OF CAPITAL PROJECTS FOR CONSIDERATION (ONE‐TIME FUNDING ‐ NO ONGOING PROJECTS) ITEMS SHADED GREEN COULD QUALIFY FOR SALES TAX G (OR H) FUNDING 408 Lafayette Federal Grant Reimbursement $80,000 Administratively‐Ordered Demolitions (1001 Washington, 827 E. High, 1323 Gordon Ct., 805 Monroe) $100,000 Administratively‐Ordered Demolitions (200 / 202 E. High) $400,000 Police Fleet Replacement $450,000 Gap Financing ‐ Capitol Ave Condemned Properties ‐ Phase 2 (6 to 8 properties) $500,000 City Hall ‐ security improvements, ADA improvements, Council chambers & large conference room improvements, improve City Hall campus and entrances, etc.$50,000+ Columbia Airport Terminal (placeholder) $50,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 Fire Station 1 Roof $63,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 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 $400,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 $3,000,000 River Port Investments $4,000,000 GRAND TOTAL $53,834,000 Fund Balance Projects April 2019 Apr 2019 w‐updates 4/16/2019 8:24 AM