Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2019-11-21 packet
Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, November 21, 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 September 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. JCCVB Annual Budget Presentation – Diane Gillespie 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, September 19, 2019 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Mihalevich at 7:30 am. Roll call showed that Councilmen Mihalevich, Prather, Graham, and Hensley were in attendance. Councilwoman Wiseman joined the meeting at 7:35. Next the minutes of the June 20, 2019 meeting were reviewed. A motion to approve was made by Councilman Graham and seconded by Councilman Hensley. The minutes were approved unanimously. The next item discussed was taken up out of order – Item #8, Discuss sinking fund plan to support City-wide fleet requests. Finance Director, Margie Mueller, provided the Committee with the Government Finance Officers Association Best Practice for Fund Balance Guidelines for the General Fund and went over some sections within the Best Practice. The Committee members had discussions regarding fleet needs, what they viewed as appropriate use of General Fund Balance reserves above the required 17% minimum, and where it would be possible to get necessary funding from. The Committee then said they would like staff to review the County Law Enforcement sales tax to determine if the City of Jefferson would be eligible for any portion of the tax. In conjunction with this, the Committee would like to know about any other counties that passed a use tax that was tied to public safety. Additionally, the Committee would also like staff to review other options for revenue increases. Councilwoman Wiseman joined the meeting during this discussion. Councilman Graham left the meeting after this discussion. 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 September 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,625 917. The average monthly amount collected for the 4 Cent Lockbox Fund is $53,611. 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 by Ms. Mueller, regarding the audit services contract. The next item on the agenda was an update by City Counselor, Ryan Moehlman, regarding the Parks Special Obligation Bonds Series 2019. Mr. Moehlman discussed the draft ordinance that needs to appear before the City Council. Mr. Moehlman stated that the bonds would have a $500,000 repayment per year and City (non-parks) funds are not directly implicated, but if Parks sales tax is not available for the repayment as intended, then the General Fund would be responsible for the repayment. Mr. Moehlman also stated that the City Council has the ultimate appropriation authority over Parks sales tax funds, which is what Parks intends to use for repayment, so if the Parks Commission doesn’t budget enough for the repayment then the City Council can appropriate the funds from any funding source the City Council deems appropriate. Mayor Tergin asked if a policy or Memorandum of Understanding needs to be drafted and implemented to make sure that Parks finds the funds to make the debt service payments without relying on General Funds. Mr. Moehlman stated no policy is necessary and that he is personally very comfortable with the fact that Parks is going to be able to repay the bond with no issues. Parks Director, Todd Spalding, stated that the Parks revenue is sufficient to support the $500,000 annual debt service payment. A motion was made by Councilwoman Wiseman and seconded by Councilman Prather to move the ordinance to full Council. The motion passed unanimously. There was no new business to discuss. There was no old business to discuss. The motion to adjourn was made by Councilwoman Wiseman and seconded by Councilman Hensley. The meeting adjourned at 8:25 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:November 8, 2019 Re:Sales Tax Revenues The City received the November 1% Sales Tax in the amount of $818,656 which is $124,651 more than projected for November. January through November overage is $31,116 (0.27%) 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 $731,421 $ 704,912 $26,509 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $1,126,211 $ 1,090,066 $36,144 May-19 Jul-19 $979,846 $ 1,131,589 ($151,744) Jun-19 Aug-19 $770,155 $ 744,888 $25,267 Jul-19 & Apr-June 19 Qtrly Sep-19 $1,240,711 $ 1,196,290 $44,421 7/17 to 6/18 interest distribution adjustment Sep-19 $7,085 $ 0 $7,085 7/18 to 6/19 interest distribution adjustment Sep-19 $15,042 $ 0 $15,042 Aug-19 Oct-19 $875,539 $ 918,967 ($43,429) Sep-19 Nov-19 $818,656 $ 694,005 $124,651 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 1,169,382 Total Overage/Shortfall $10,502,994 $11,641,260 $31,116 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 $351,775 $ 302,764 $49,011 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $554,062 $ 468,191 $85,871 May-19 Jul-19 $481,405 $ 486,025 ($4,620) Jun-19 Aug-19 $372,416 $ 319,934 $52,482 Jul-19 & Apr-June 19 Qtrly Sep-19 $605,262 $ 513,814 $91,448 7/17 to 6/18 interest distribution adjustment Sep-19 $3,435 $ 0 $3,435 7/18 to 6/19 interest distribution adjustment Sep-19 $7,301 $ 0 $7,301 Aug-19 Oct-19 $421,199 $ 394,703 $26,496 Sep-19 Nov-19 $395,311 $ 298,080 $97,232 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 502,257 * BUDGET AMENDMENT DUE TO ORDINANCE 15775 $0 $ 490,329 ($490,329) Total Overage/Shortfall $5,103,756 $5,490,329 $115,685 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 $350,479 $ 317,903 $32,577 Apr-19 & Jan-Mar 19 Qtrly Jun-19 $554,065 $ 491,600 $62,464 May-19 Jul-19 $481,406 $ 510,327 ($28,921) Jun-19 Aug-19 $372,405 $ 335,931 $36,474 Jul-19 & Apr-June 19 Qtrly Sep-19 $605,269 $ 539,505 $65,764 7/17 to 6/18 interest distribution adjustment Sep-19 $3,440 $ 0 $3,440 7/18 to 6/19 interest distribution adjustment Sep-19 $7,303 $ 0 $7,303 Aug-19 Oct-19 $421,199 $ 414,438 $6,761 Sep-19 Nov-19 $375,311 $ 312,984 $62,328 Oct-19 & Jul-Sept 19 Qtrly Dec-19 $ 527,370 Total Overage/Shortfall $5,082,304 $5,250,000 $359,674 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 11/8/2019 Account Name General Fund Sales Tax Rate:One percent (1%)Receipt Month: OCTOBER 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 731,421 act.693,383 Apr & Jan-Mar Qtrly June 1,045,933 1,119,566 1,000,942 1,042,310 1,126,211 act.1,014,936 May July 963,280 1,012,207 1,154,051 1,117,038 979,846 act.1,059,066 Jun August 562,996 661,518 678,636 821,132 770,155 act.667,666 Jul & Apr-Jun Qtrly September 1,185,891 1,197,976 1,143,504 1,129,543 1,262,838 act.1,130,637 Aug October 918,839 903,829 883,215 879,331 875,539 act.900,850 Sept November 661,849 623,645 615,667 774,337 818,656 act.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 10,502,994 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,169,382 Total Actual & Estimated $ 11,672,376 Less: Budget 11,641,260 Over (Under) Budget $ 31,116 $ 1,071,917 $ 1,957,413 $ 3,046,044 $ 3,938,329 $ 4,669,750 $ 5,795,961 $ 6,775,806 $ 7,545,961 $ 8,808,799 $ 9,684,338 $ 10,502,994 $ 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 11/8/2019 Account Name Capital Imprs Sales Tax Rate:One-Half percent (½%)Receipt Month: OCTOBER 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 351,775 act.342,394 Apr & Jan-Mar Qtrly June 496,466 539,529 489,008 508,225 554,062 act.490,034 May July 473,120 498,229 559,119 548,625 481,405 act.516,592 Jun August 280,733 330,112 338,618 393,512 372,416 act.329,826 Jul & Apr-Jun Qtrly September 565,296 570,134 542,457 545,731 615,998 act.541,722 Aug October 442,371 435,416 425,493 423,478 421,199 act.431,389 Sept November 330,393 310,506 307,281 374,512 395,311 act.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 5,103,756 Estimated to Fiscal Year end (based on averages and on Budgeted amount)502,257 Total Actual & Estimated $ 5,606,014 Less: Budget 5,000,000 Over (Under) Budget $ 606,014 $ 525,696 $ 953,407 $ 1,481,121 $ 1,911,589 $ 2,263,364 $ 2,817,426 $ 3,298,831 $ 3,671,248 $ 4,287,246 $ 4,708,445 $ 5,103,756 $ 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 $ 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 City of Jefferson, Mo. - Account Analysis Printed 11/8/2019 Account Name Parks Sales Tax Rate:One-Half percent (½%)Receipt Month: OCTOBER 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 350,479 act.341,988 Apr & Jan-Mar Qtrly June 496,386 539,529 489,008 508,266 554,065 act.490,007 May July 473,038 498,229 559,115 548,639 481,406 act.516,562 Jun August 280,513 330,112 338,470 393,578 372,405 act.329,720 Jul & Apr-Jun Qtrly September 565,217 572,847 542,457 545,842 616,012 act.542,253 Aug October 442,370 435,416 425,497 423,387 421,199 act.431,353 Sept November 330,393 310,506 307,305 374,484 395,311 act.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 5,102,304 Estimated to Fiscal Year end (based on averages and on Budgeted amount)527,370 Total Actual & Estimated $ 5,629,674 Less: Budget 5,250,000 Over (Under) Budget $ 379,674 $ 525,690 $ 953,379 $ 1,480,967 $ 1,911,426 $ 2,261,905 $ 2,815,970 $ 3,297,376 $ 3,669,781 $ 4,285,793 $ 4,706,992 $ 5,102,304 $ 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 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 N o v e m b e r 1 3 , 2 0 1 9 . 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 1 / 1 3 / 1 9 (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 0 , 5 0 2 , 9 9 3 . 9 3 $ 3 1 , 1 1 5 . 6 2 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 , 0 6 8 , 3 1 3 . 4 6 $ 5 8 , 5 2 8 . 1 7 Ot h e r T a x e s $1 1 0 , 0 0 0 . 0 0 $ 8 9 , 3 7 8 . 9 2 ($ 1 1 , 2 5 9 . 4 3 ) 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 , 1 9 8 , 0 2 3 . 3 5 ($ 7 4 9 , 8 3 1 . 9 9 ) Pr o p e r t y T a x e s $5 , 4 3 2 , 3 9 9 . 0 0 $ 5 , 4 3 7 , 1 8 4 . 7 3 $ 1 1 , 9 0 7 . 3 4 In t e r g o v e r n m e n t a l $0 . 0 0 $ 1 9 9 , 1 7 4 . 2 1 $ 1 5 2 , 0 7 6 . 8 3 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 , 7 9 8 , 4 1 4 . 7 2 $ 3 7 , 1 9 8 . 0 0 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 $ 1 , 0 0 2 , 9 6 7 . 1 8 $ 1 2 4 , 0 7 1 . 7 6 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 0 4 , 5 4 9 . 1 7 $ 2 1 , 1 1 4 . 2 9 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 3 6 , 2 5 2 . 4 1 $ 1 2 9 , 7 3 2 . 3 4 In t e r e s t I n c o m e $1 5 2 , 9 2 6 . 5 4 $ 1 4 3 , 4 4 4 . 5 3 $ 5 , 4 5 6 . 7 7 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 1 , 0 0 7 . 3 2 $ 2 0 2 , 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 0 , 0 4 9 , 1 8 6 . 1 4 ($ 1 5 0 , 5 2 9 . 8 4 ) 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 11/13/19 As of 11/13/19 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,641,260.00 $10,480,866.74 $1,169,381.69 $11,650,248.43 $8,988.43 $8,988.43 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 $10,502,993.93 $1,169,381.69 $11,672,375.62 $31,115.62 $31,115.62 Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $590,000.00 $490,923.50 $94,048.18 $584,971.68 ($5,028.32)($5,028.32) 10‐100‐403010 Gasoline Tax $1,160,000.00 $967,509.27 $196,166.53 $1,163,675.80 $3,675.80 $3,675.80 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,068,313.46 $290,214.71 $2,358,528.17 $58,528.17 $58,528.17 Other Taxes 10‐100‐403020 Cig Tax $110,000.00 $89,378.92 $9,361.65 $98,740.57 ($11,259.43)($11,259.43) $110,000.00 $89,378.92 $9,361.65 $98,740.57 ($11,259.43)($11,259.43) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,060,000.00 $3,586,032.98 $261,817.79 $3,847,850.77 ($212,149.23)($212,149.23) 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 $864,144.06 $38,265.54 $902,409.60 ($17,590.40)($17,590.40) 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $1,507,470.08 $163,801.27 $1,671,271.35 ($378,728.65)($378,728.65) 10‐100‐410053 Telephone/Cell Audit $0.00 ($13,210.20)$15,210.20 $2,000.00 $2,000.00 $2,000.00 10‐100‐410060 Cable Franchise Fee $405,000.00 $253,586.43 $8,049.87 $261,636.30 ($143,363.70)($143,363.70) $7,435,000.00 $6,198,023.35 $487,144.66 $6,685,168.01 ($749,831.99)($749,831.99) 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 $49,173.92 $459.70 $49,633.62 $9,633.62 $9,633.62 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 $27,417.07 ($93.61)$27,323.46 ($676.54)($676.54) 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 $460,853.58 ($401.16)$460,452.42 ($4,547.58)($4,547.58) 10‐100‐420080 Special Tax Rev $41,000.00 $51,513.55 $7,156.69 $58,670.24 $17,670.24 $17,670.24 $5,432,399.00 $5,437,184.73 $7,121.61 $5,444,306.34 $11,907.34 $11,907.34 Intergovernmental 10‐100‐430010 Federal Grant $0.00 $114,816.87 $0.00 $114,816.87 $114,816.87 $114,816.87 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 $47,097.38 ($47,097.38)$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 $199,174.21 ($47,097.38)$152,076.83 $152,076.83 $152,076.83 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 $32,387.00 ($766.22)$31,620.78 $10,620.78 $10,620.78 10‐100‐440910 Fuel Charge ‐ backs $13,000.00 $9,536.59 $1,084.24 $10,620.83 ($2,379.17)($2,379.17) 10‐100‐440920 Parts Charge backs $185,000.00 $207,938.07 $16.92 $207,954.99 $22,954.99 $22,954.99 10‐100‐440930 Labor Charge backs $245,000.00 $243,597.16 $260.93 $243,858.09 ($1,141.91)($1,141.91) 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 $163,063.13 ($448.20)$162,614.93 $7,614.93 $7,614.93 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,798,414.72 $147.67 $2,798,562.39 $37,198.00 $37,198.00 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 $20,967.00 $0.00 $20,967.00 $12,967.00 $12,967.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 11/13/19 As of 11/13/19 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $1,310.00 ($33.97)$1,276.03 ($723.97)($723.97) 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 $88,973.12 ($2,654.17)$86,318.95 ($1,231.05)($1,231.05) 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,630.40 $17.09 $8,647.49 ($3,352.51)($3,352.51) 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 $47,070.00 $3,185.63 $50,255.63 $8,255.63 $8,255.63 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 $1,002,967.18 $514.58 $1,003,481.76 $124,071.76 $124,071.76 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 $267,354.73 $53,000.00 $320,354.73 ($1,893.65)($1,893.65) 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $336,434.88 $304,549.17 $53,000.00 $357,549.17 $21,114.29 $21,114.29 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 $80,070.87 ($230.48)$79,840.39 $34,840.39 $34,840.39 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 $15,931.71 $1,511.06 $17,442.77 ($2,557.23)($2,557.23) 10‐100‐481077 Insurance Claims $20,000.00 $43,169.98 $0.00 $43,169.98 $23,169.98 $23,169.98 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $117,800.64 $236,252.41 $11,280.57 $247,532.98 $129,732.34 $129,732.34 Interest Income 10‐100‐470010 Interest $152,926.54 $143,444.53 $14,938.78 $158,383.31 $5,456.77 $5,456.77 $152,926.54 $143,444.53 $14,938.78 $158,383.31 $5,456.77 $5,456.77 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $168,229.08 $371,007.32 $0.00 $371,007.32 $202,778.24 $202,778.24 $168,229.08 $371,007.32 $0.00 $371,007.32 $202,778.24 $202,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 $30,049,186.14 $1,996,008.55 $32,045,194.69 ($150,529.84)($150,529.84) CITY OF JEFFERSON FISCAL YEAR 2019 ESTIMATED FUND BALANCE FYE2018 UNASSIGNED FUND BALANCE (Audited)8,289,016.96$ 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)$ Snow Plow (75,000.00)$ (205,000.00)$ FYE2019 ESTIMATED Unassigned Fund Balance 5,630,437.49$ FYE2019 ESTIMATED Fund Balance % of Adopted Budget 17.16% 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 Total 9,813,532.05 4,121,683.45 5,772,592.28 average monthly amount for 4 cent lockbox fund 53,878.22$ **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 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: September 2019 Percent Change from September 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 67.4 68.0 131.93 131.18 88.91 89.16 -0.9 0.6 -0.3 1.7 2.0 1.2 67.6 67.6 131.92 130.58 89.18 88.27 0.0 1.0 1.0 3.0 2.0 2.0 56668 34725 5365638 4028960 West North Central 64.3 64.0 101.76 101.29 65.44 64.82 0.5 0.5 1.0 3.0 2.0 2.5 60.2 59.4 100.40 100.44 60.48 59.69 1.4 -0.0 1.3 3.4 2.0 3.4 4741 2903 374099 278889 Missouri 63.0 62.8 103.38 102.61 65.09 64.45 0.2 0.7 1.0 2.5 1.5 1.7 60.5 60.2 101.60 100.91 61.43 60.74 0.5 0.7 1.1 3.2 2.0 2.5 1149 690 106195 76662 Kansas City, MO-KS 64.2 64.8 102.69 105.08 65.97 68.10 -0.9 -2.3 -3.1 -0.3 2.9 2.0 63.8 63.8 104.64 104.71 66.77 66.75 0.1 -0.1 0.0 3.4 3.4 3.5 311 258 34293 30497 St Louis, MO-IL 71.2 70.7 111.37 108.73 79.34 76.90 0.7 2.4 3.2 5.4 2.2 2.9 66.4 66.9 107.86 106.03 71.64 70.94 -0.7 1.7 1.0 3.1 2.1 1.3 344 255 39989 33363 Columbia, MO+64.6 61.8 103.48 96.35 66.88 59.59 4.5 7.4 12.2 11.9 -0.3 4.2 59.0 57.2 89.29 88.19 52.71 50.46 3.2 1.2 4.5 7.3 2.7 6.0 40 31 4084 3376 Jefferson City, MO+63.4 60.1 89.12 84.54 56.46 50.79 5.4 5.4 11.2 22.7 10.4 16.4 58.3 59.1 89.59 85.25 52.26 50.42 -1.4 5.1 3.7 13.2 9.2 7.7 15 13 1393 1271 Springfield, MO 60.3 64.4 88.35 86.42 53.32 55.63 -6.2 2.2 -4.2 -1.7 2.5 -3.9 62.7 65.4 86.81 85.71 54.47 56.01 -4.0 1.3 -2.8 -1.0 1.8 -2.3 71 50 6405 4865 Branson, MO 48.0 51.5 105.76 102.91 50.78 52.98 -6.7 2.8 -4.2 -3.7 0.5 -6.3 48.9 47.7 107.02 107.16 52.37 51.08 2.7 -0.1 2.5 3.4 0.9 3.5 155 38 14655 5014 Lake of the Ozarks+53.5 53.7 107.87 112.98 57.71 60.73 -0.5 -4.5 -5.0 -2.6 2.5 2.0 51.2 48.6 108.90 110.32 55.80 53.63 5.4 -1.3 4.0 6.5 2.4 7.9 34 11 2624 1304 Joplin, MO 58.0 57.1 79.92 82.45 46.37 47.11 1.6 -3.1 -1.6 -1.6 0.0 1.6 58.5 57.4 81.89 83.97 47.90 48.24 1.8 -2.5 -0.7 -0.7 0.0 1.8 33 24 2477 2123 Saint Joseph, MO+83.1 65.2 92.23 88.85 76.64 57.94 27.4 3.8 32.3 8.1 -18.3 4.1 64.7 59.0 91.36 88.11 59.07 52.02 9.5 3.7 13.6 5.1 -7.5 1.3 11 8 992 787 Independence, MO+59.2 63.0 82.06 86.48 48.55 54.48 -6.1 -5.1 -10.9 -10.9 0.0 -6.1 57.5 58.5 83.75 84.34 48.12 49.33 -1.8 -0.7 -2.4 -2.4 0.0 -1.8 21 13 1631 1289 A blank row indicates insufficient data. ADRRevPARADR Current Month - September 2019 vs September 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 - September 2019 vs September 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 JCCVB 2020 Budget Acct #Line Item 2020 Budget Explanation of Account Codes Revenue 4100 Room Tax 519,160.00$ Monthly lodging tax revenues 4200 Interest Earning 1,800.00$ $150.00 per month 4300 Advertising Cooperative 71,356.00$ FY 20 MDT PMF 2,082.50$ AAA Midwest Traveler (Jan-May issue) FY 20 MDT PMF 774.00$ AAA World Kansas (Jan & May) FY 20 MDT PMF 290.00$ 417 Magazine (Apr) FY 20 MDT PMF 2,727.50$ Madden Insert Spring (April) FY 20 MDT PMF 2,062.50$ Best of the Midwest (Mar) FY 20 MDT PMF 1,000.00$ Group Travel Leader (Jan) FY 20 MDT PMF 780.00$ Louisville Magazine (May) FY 20 MDT PMF 2,890.00$ Missouri Life (Mar & Jun) FY 20 MDT PMF 650.00$ Show Me Missouri (Feb & May) FY 20 MDT PMF 2,727.50$ Madden Media Insert (Apr) FY 20 MDT PMF 2,437.50$ Midwest Living (May) FY 20 MDT PMF 1,000.00$ Rural Missouri (April) FY20 MDT PMF 1,400.00$ St Louis Magazine (May & June) FY 20 MDT PMF 325.00$ Show Me Missouri (Mar & Jun) FY20 MDT PMF 1,184.00$ Group Tour Magazine (June) FY 20 MDT PMF 4,000.00$ Trip Advisor Banners FY 20 MDT PMF 2,500.00$ Madden Facebook Targeting Ads (Feb - June) FY 20 MDT PMF 5,000.00$ Madden Media Content FY 20 MDT PMF 4,000.00$ Trip Advisor Banners FY 20 MDT PMF 3,000.00$ Porlier January - June FY 20 MDT PMF 3,000.00$ DDI January - June FY 21 MDT PMF 816.00$ Select Traveler FY 21 MDT PMF 780.00$ Louisville Magazine (Sep) FY 21 MDT PMF 1,000.00$ Rural Missouri (Jul) FY 21 MDT PMF 580.00$ 417 Magazine (Sept) FY 21 MDT PMF 1,012.50$ Missouri Tour Guide FY 21 MDT PMF 2,203.50$ Missouri Life (Jul & Nov) FY21 MDT PMF 1,400.00$ St Louis Magazine (July & Nov) FY21 MDT PMF 950.00$ Omaha Magazine (July) FY 21 MDT PMF 650.00$ Show Me Missouri (Oct) FY 21 MDT PMF 1,383.50$ Madden Media insert (Salute - July) FY 21 MDT PMF 2,500.00$ Madden Media Facebook Targeting Ads (Jul-Sep) FY 21 MDT PMF 2,500.00$ Madden Media Content (Sep & Oct) FY 21 MDT PMF 3,000.00$ Trip Advisor Banners (Jul - Dec) FY 21 MDT PMF 3,000.00$ Porlier July - Dec FY 21 MDT PMF 3,000.00$ DDI July - Dec FY21 MDT PMF 2,750.00$ Madden Media (potential July - Sept) 4350 Special Event 5,000.00$ 1,500.00$ Corvette Classic 2,500.00$ State Track hotel rebates 1,000.00$ Misc. events 4500 Revenue 18,500.00$ 12,500.00$ Eagles fundraiser 6,000.00$ Prison Break 4550 Prison Tour Ticket Sales 572,000.00$ 572,000.00$ Prison tour ticket sales 4560 MSP Museum Admission 28,000.00$ 28,000.00$ Museum admission 4700 Advertising Revenue 2,000.00$ 1,500.00$ MSP Hand fans 500.00$ Misc 4801 Jefferson City Promotional Item Sales 85,000.00$ 85,000.00$ CVB and MSP Promotional Items 4900 Miscellaneous Revenue 3,000.00$ 400.00$ Salute to America Lunches 2,600.00$ Misc. revenue Total Revenue 1,305,816.00$ Payroll Expenses 6100 Salaries and Wages 230,250.00$ 230,250.00$ CVB staff 6120 Retirement Benefits 4,400.00$ Additional Staff eligible)4,400.00$ Simple retirment plan 3% 6130 Payroll Taxes 20,000.00$ 20,000.00$ Includes medicare, federal and state employement taxes 6140 Insurance Benefits 42,200.00$ 42,200.00$ Anthem Blue Cross / ACCE Benefits Trust Total Payroll 296,850.00$ 23% Administrative and General Expenses 6200 Auditing and Accounting 21,325.00$ 15,000.00$ Monthly Accounting and Payroll services $1,250 per month 6,325.00$ Annual audit 6210 Building Rental 44,150.00$ 18,250.00$ $3,650 per month Jan-May 25,900.00$ $3,700 per month June - Dec. 6211 Building Maintenance 500.00$ 500.00$ Misc maintenance 6211 Building Utilities 3,200.00$ 3,200.00$ Over the alloted amount included in lease 6212 Cleaning Service 4,020.00$ 3,600.00$ Office cleaning services 420.00$ Trash service 6213 Security Monitoring 500.00$ 275.00$ Maintenance contract 225.00$ Misc. maintenance items 6220 Support/Software 17,163.00$ 12,503.00$ Simpleview conversion 4,660.00$ Computer support - IT service 6230 Consulting 500.00$ 500.00$ Legal services 6240 Dues and Subscriptions 1,582.00$ 200.00$ Miscellanous 740.00$ ACCE Annual membership 150.00$ Downtown Jefferson City 40.00$ Eastside Business Association 50.00$ Westside Business Association 410.00$ Jefferson City Chamber of Commerce 172.80$ News Tribune Annual Subscription 6245 Depreciation Expense 18,000.00$ 18,000.00$ $1,500. per month 6250 Office Equip Lease & Repair 5,000.00$ 900.00$ Marco copier service aggreement 2,273.00$ Additional copies and misc expenses 1,452.00$ Monthly payments - $121.00 375.00$ Telephone service contract 6260 Insurance Premiums 8,000.00$ 4,000.00$ Worker's Comp 1,238.00$ Director & Officers Liability 1,796.00$ Commercial Package/Umbrella 966.00$ Add'l insurance coverage 6270 Minor Office Furniture 500.00$ 500.00$ Misc.Expenses 6280 Misc. Expenses 4,335.00$ 40.00$ Annual Business License/Registration 1,200.00$ Holiday Luncheon (Diplomats, committees and staff) 120.00$ ACH Payroll processing charge 125.00$ Staff Holiday Party 100.00$ Salute to America Lunches 2,750.00$ Miscellanous (job advertisment, cards.,VIP gifts) 6300 Office Supplies 2,200.00$ 2,200.00$ General Office supplies 6310 Printing and Binding 1,500.00$ 1,500.00$ Printing projects and staff materials 6320 Telphone service 11,000.00$ 11,000.00$ monthly telephone charges 6330 Training and Education 2,240.00$ 240.00$ MACVB - 2 ppl @$120.00 700.00$ Gov.'s Conf. on Tourism 800.00$ JC Chamber leadership program 500.00$ Staff training and educational seminarsTotal Administrative and General Expenses 145,715.00$ 11.16% Marketing 6285 Promotional Items to sell 56,000.00$ $56,000.00 JC and MSP items to sell 6340 Travel Expenses 14,000.00$ 4,800.00$ Local and miscellanous travel 1,200.00$ Locations conference with MDT 1,500.00$ Connect Sports 1,300.00$ Nat'l Assn. of Sports Commissions 500.00$ Missouri Sports Exchange 800.00$ Travel South 500.00$ Missouri Bank Travel 700.00$ Working Women's Survival Show 800.00$ Heritage Clubs Internation (Omaha) 600.00$ Johnson County Garden Show 700.00$ Missouri Governor's Conf on Tourism 600.00$ MACVB Annual Conference 6520 Tradeshows Fees 12,958.00$ 4,500.00$ Connect Sports/Natl Assn of Sports Commission 315.00$ Missouri Sports Exchange 1,095.00$ Working Women's Survival Show 1,428.00$ Johnson County Garden Show 295.00$ Missouri Bank Travel Exchange 1,385.00$ Heritage Clubs International (Omaha) 1,095.00$ Travel South Domestic $295.00 Missouri Group Travel Exchange 350.00$ Missouri Event Summit 200.00$ MSAE Funfest 2,000.00$ Miscellanous Tradeshows 6360 MSP Misc Expenses 11,000.00$ 11,000.00$ Misc tour expenses 6361 MSP Salaries and Wages 273,249.09$ 273,249.09$ Salary, payroll taxes, insur. and ret. 6362 MSP Digital Marketing 36,657.50$ 262.50$ Website Hosting (MSP and Museum) 20.00$ Domain Name Reg (MSP and Museum) 9,375.00$ Madden Media SEM (monthly expense) FY 20 MDT PMF 8,000.00$ Trip Advisor Banners (Mar-June) FY 20 MDT PMF 5,000.00$ Madden Media Content FY 20 MDT PMF 2,500.00$ Madden Facebook Targeting Ads (Feb-June) FY 21 MDT PMF 2,500.00$ Madden Facebook (July-Sep) FY 21 MDT PMF 2,500.00$ Madden Media Content (Sept - Oct) FY 21 MDT PMF 4,000.00$ Trip Advisor Banner (July-August) FY21 MDT PMF 2,500.00$ Madden Facebook Targeting Ads (July-Sept) 6363 MSP Credit Card Fees 13,800.00$ 13,800.00$ Based on credit card sales and MSP ticket res. system 6364 MSP Janitorial Services 3,960.00$ 3,960.00$ Trash and portable pottie monthly service 6365 MSP Tour Insurance 5,650.00$ 5,650.00$ MSP tour insurance 6367 MSP Advertising 48,312.00$ 2,500.00$ MSP Brochure FY 20 MDT PMF 4,165.00$ AAA Midwest Traveler (Jan-May issue) FY 20 MDT PMF 1,548.00$ AAA World Kansas (Jan & May) FY 20 MDT PMF 580.00$ 417 Magazine (Apr) FY 20 MDT PMF 5,455.00$ Madden Media Insert Spring (Apr) FY 20 MDT PMF 2,062.50$ Best of the Midwest (Mar) FY 20 MDT PMF 2,000.00$ Group Travel Leader (Jan) FY 20 MDT PMF 2,890.00$ Missouri Life ( Mar) FY 20 MDT PMF 1,300.00$ Show Me Missouri (Mar & June) FY 20 MDT PMF 4,875.00$ Midwest Living (May) FY 20 MDT PMF 2,000.00$ Rural Missouri (Apr) FY 20 MDT PMF 2,368.00$ Group Tour Leader (June) FY 21 MDT PMF 2,890.00$ Missouri Life (Jul) FY 21 MDT PMF 816.00$ Select Traveler (Jul) FY 21 MDT PMF 2,000.00$ Rural Missouri (Jul) FY 21 MDT PMF 580.00$ 417 Magazine (Sept) FY 21 MDT PMF 1,012.50$ Missouri Tour Guide (Oct) FY21 MDT PMF 650.00$ Show Me Missouri (Oct ) FY21 MDT PMF 1,400.00$ St Louis Magazine (July) FY21 MDT PMF 1,900.00$ Omaha Magazine (July) 2,800.00$ St. Louis Magazine (Mar & May) 2,000.00$ Misc publications 520.00$ Day Trippin'Guide (Apr) 6368 MSP Utilities and Lawn Service 17,950.00$ 12,450.00$ Monthly utilities 5,500.00$ Lawn service 6369 MSP Capital Improvements -$ 6370 MSP Museum 5,000.00$ 5,000.00$ Museum expensess 6400 Graphic Design 4,000.00$ 4,000.00$ Miscellaneous (MSP and CVB projects) 6410 Outdoor Advertising 25,700.00$ FY 20 MDT PMF 6,000.00$ Porlier January - June FY 20 MDT PMF 6,000.00$ DDI January - June FY 21 MDT PMF 6,000.00$ Porlier July - Dec FY 21 MDT PMF 6,000.00$ DDI July - Dec 1,700.00$ LOTO Speedway 6430 Brochures and Printed Materials 9,000.00$ 9,000.00$ Misc. brochures 6440 Postage 8,000.00$ 8,000.00$ Monthly postage charges 6461 Marketing Memberships 5,335.00$ 400.00$ Society of Gov. Meeting Professionals 795.00$ National Assoc. of Sports Commissions 145.00$ Missouri Society of Assoc Executives 75.00$ Missouri Motion Media Association 225.00$ Missouri Travel Council $ 1,050.00 Missouri Association of Convention & Visitors Bureau 1,395.00$ Destination Marketing Intl. 750.00$ Missouri Hotel and Lodging Association 500.00$ Misc 6470 Print Advertising 31,703.00$ 6,008.00$ Missouri Travel Guide (January 2020 issue) FY 20 MDT PMF 2,062.50$ Best of the Midwest FY 20 MDT PMF 1,560.00$ Louisville Magazine (May) FY 20 MDT PMF 2,890.00$ Missouri Life (Jun) FY 21 MDT PMF 2,767.00$ Madden Media Insert (Salute -July ) FY 21 MDT PMF 580.00$ 417 Magazine (Nov) FY 21 MDT PMF 816.00$ Select Travel (July) FY 21 MDT PMF 1,560.00$ Louisville Magazine (Sept) FY 21 MDT PMF 1,517.00$ Missouri Life (Holiday - Nov) FY 21 MDT PMF 650.00$ Show Me Missouri (Holiday - Nov) FY21 MDT PMF 1,012.50$ Missouri Tour Guide (Oct) FY21 MDT PMF 1,900.00$ Omaha Magazine (July) FY21 MDT PMF 1,400.00$ St Louis Magazine (Nov) 1,400.00$ St Louis Magazine ( June) 580.00$ 417 Magazine (Salute - June) 5,000.00$ Misc. print advertisements 6490 Market Research 1,000.00$ 1,000.00$ survey incentives 6500 Promotion/Publicity 7,000.00$ $ 4,000.00 Miscellanous (cards, community events) 3,000.00$ Lunches with meeting planners/business and community leaders 6510 Sponsorships 42,000.00$ 5,000.00$ Salute to America 37,000.00$ Misc Event sponsorships 6530 Familiarization (FAM) Tour Expenses 3,000.00$ 3,000.00$ Event/Mtg Planners/Travel Writers visits 6540 Marketing Promo 6,000.00$ 1,700.00$ Misc Gift baskets 100.00$ MSAE and SGMP Holiday Baskets 50.00$ MSAE Holiday Dinner 4,150.00$ Misc. convention services 6545 Public Relations 5,000.00$ $5,000.00 misc. services 6550 Digital Marketing 31,380.00$ 280.00$ Annual Hosting 175.00$ Domain name registration 1,550.00$ Constant Contact Subscription 9,375.00$ Madden Media SEM (monthly expense) FY 20 MDT PMF 2,500.00$ Madden FACEbook Targeting Ads (Feb-June) FY20 MDT PMF 5,000.00$ Madden Media Content FY 21 MDT PMF 2,000.00$ Trip Advisor Banners (Nov-Dec) FY 21 MDT PMF 2,500.00$ Madden Media Content (Sept-Oct) FY 21 MDT PMF 2,500.00$ Madden Facebook Targeting Ads (July-Sep) FY21 MDT PMF 5,500.00$ Madden Media Digital (possiblity) 6560 Local Promotion 5,000.00$ 5,000.00$ Local events 6620 Special Events 5,000.00$ 600.00$ Corvette Classic 1,000.00$ Prison Break 3,400.00$ Misc. events 6630 CVB 20,000.00$ State Track Expenses 9,250.20$ JCHS Atkins Staduim 1,275.00$ Breakfast for officials 4,300.00$ D & K Transportation 1,630.00$ MSHSAA official rooms 800.00$ Refreshment/ice 500.00$ Holiday reception 2,244.80$ Misc 6640 Expenses 20,000.00$ AEC Fundraiser 2,600.00$ Petty cash 2,000.00$ Auction Merchandise 3,500.00$ Eagles 155.00$ Thank you ad State Track Expenses 600.00$ Refreshments 5,250.00$ Lunch for officials Sponsorships 4,600.00$ Misc. event sponsorships 295.00$ Misc. expenses 1,000.00$ Prison Break Total Marketing Expenses $ 727,654.59 56% Capital Expenses 6700 Office Furniture and Equipment 6710 Computer Hardware 2,000.00$ Total Capital Expenses 2,000.00$ 6800 MSP reserve for Preservation Projects 133,596.41$ Restricted funds for MSP preservation project Total Bureau Expenses 1,305,816.00$ Acct. #Line Item 2019 Budget Proposed 2020 Budget 2018-2019 Comparison %Change Revenue 4100 Room Tax 508,980.00$ 519,160.00$ 10,180.00$ 2.00% 4200 Interest Earning 1,800.00$ 1,800.00$ -$ 0.00% 4300 MDT MMG/MPD Coop 26,371.00$ 71,356.00$ 44,985.00$ 170.59% 4350 Special Events 5,000.00$ 5,000.00$ -$ 0.00% 4500 Fundraising Athletic Events Revenue 19,500.00$ 18,500.00$ (1,000.00)$ -5.13% 4550 Prison Tour Ticket Sales 572,000.00$ 572,000.00$ -$ 0.00% 4560 MSP Museum Admission 28,000.00$ 28,000.00$ -$ 0.00% 4700 Misc Advertising revenue 2,000.00$ 2,000.00$ -$ 0.00% 4801 Jefferson City Promotional Item Sales 87,210.00$ 85,000.00$ (2,210.00)$ -2.53% 4900 Miscellaneous Revenue 3,000.00$ 3,000.00$ -$ 0.00% Total Revenue 1,253,861.00$ 1,305,816.00$ 51,955.00$ 4.14% Payroll Expenses 6100 Salaries and Wages 225,900.00$ 230,250.00$ 4,350.00$ 1.93% 6120 Retirement Benefits 4,400.00$ 4,400.00$ -$ 0.00% 6130 Payroll Taxes 20,000.00$ 20,000.00$ -$ 0.00% 6140 Insurance Benefits 40,000.00$ 42,200.00$ 2,200.00$ 5.50% Total Payroll Expenses 290,300.00$ 296,850.00$ 6,550.00$ 2.26% Administrative and General Expenses 6200 Auditing and Accounting 21,325.00$ 21,325.00$ -$ 0.00% 6210 Building Rental 43,550.00$ 44,150.00$ 600.00$ 1.38% 6210 Building Maintenance 1,000.00$ 500.00$ (500.00)$ -50.00% 6211 Building Utilities 2,000.00$ 3,200.00$ 1,200.00$ 60.00% 6212 Cleaning Services 3,000.00$ 4,020.00$ 1,020.00$ 34.00% 6213 Security Monitoring 500.00$ 500.00$ -$ 0.00% 6220 Computer Support/Service 5,860.00$ 17,163.00$ 11,303.00$ 192.88% 6230 Consulting 500.00$ 500.00$ -$ 0.00% 6240 Dues and Subscriptions 1,582.00$ 1,582.00$ -$ 0.00% 6245 Depreciation Expense 13,500.00$ 18,000.00$ 4,500.00$ 33.33% 6250 Office Equip Lease & 5,000.00$ 5,000.00$ -$ 0.00% 6260 Insurance Premiums 8,000.00$ 8,000.00$ -$ 0.00% 6270 Minor Office Furniture 500.00$ 500.00$ -$ 0.00% 6280 Misc. Expenses 3,835.00$ 4,335.00$ 500.00$ 13.04% 6300 Office Supplies 2,200.00$ 2,200.00$ -$ 0.00% 6310 Printing and Binding 2,000.00$ 1,500.00$ (500.00)$ -25.00% 6320 Telephone and Fax 11,000.00$ 11,000.00$ -$ 0.00% 6330 Training and Education 2,240.00$ 2,240.00$ -$ 0.00% Total Administrative and General Expense 127,592.00$ 145,715.00$ 18,123.00$ 12.44% Marketing Expenses 6285 Promotional Items to sell 56,000.00$ 56,000.00$ -$ 0.00% 6340 Travel Expenses 14,000.00$ 14,000.00$ -$ 0.00% 6360 MSP Tour Expenses 11,000.00$ 11,000.00$ -$ 0.00% 6361 MSP Salaries and Wages 262,000.00$ 273,249.09$ 11,249.09$ 4.29% 6362 MSP Digital Marketing 26,832.50$ 36,657.50$ 9,825.00$ 36.62% 6363 MSP Credit Card Fees 35,000.00$ 13,800.00$ (21,200.00)$ -60.57% 6364 MSP Janitorial Services 3,960.00$ 3,960.00$ -$ 0.00% 6365 MSP Tour Insurance 5,000.00$ 5,650.00$ 650.00$ 13.00% 6367 MSP Advertising 27,887.50$ 48,312.00$ 20,424.50$ 73.24% 6368 MSP Utilites and Lawn service 17,950.00$ 17,950.00$ -$ 0.00% 6369 MSP Capital Improvements 15,000.00$ -$ (15,000.00)$ -100.00% 6370 MSP Museum 2,000.00$ 5,000.00$ 3,000.00$ 150.00% 6400 Graphic Design 5,000.00$ 4,000.00$ (1,000.00)$ -20.00% 6410 Outdoor Advertising 26,800.00$ 25,700.00$ (1,100.00)$ -4.10% 6430 Brochures/Printed Material 9,000.00$ 9,000.00$ -$ 0.00% 6440 Postage and Freight 7,000.00$ 8,000.00$ 1,000.00$ 14.29% 6461 Marketing Memberships 5,335.00$ 5,335.00$ -$ 0.00% 6470 Print Advertising 28,000.00$ 31,703.00$ 3,703.00$ 13.23% 6490 Marketing Research 5,000.00$ 1,000.00$ (4,000.00)$ -80.00% 6500 Promotion/Publicity 7,400.00$ 7,000.00$ (400.00)$ -5.41% 6510 Sponsorship 42,000.00$ 42,000.00$ -$ 0.00% 6520 Tradeshow Fees 13,383.00$ 12,958.00$ (425.00)$ -3.18% 6530 Familiarization tour expense 6,000.00$ 3,000.00$ (3,000.00)$ -50.00% 6540 Marketing Promo 6,000.00$ 6,000.00$ -$ 0.00% 6545 Public Relations 5,000.00$ 5,000.00$ -$ 0.00% 6550 Digital Marketing 28,000.00$ 31,380.00$ 3,380.00$ 12.07% 6560 Local Promotions 5,000.00$ 5,000.00$ -$ 0.00% 6620 Special Events 5,000.00$ 5,000.00$ -$ 0.00% 6630 Athletic Events Exp - CVB 20,000.00$ 20,000.00$ -$ 0.00% 6640 Athletic Events Committee Exp 20,000.00$ 20,000.00$ -$ 0.00% Total Marketing 720,548.00$ 727,654.59$ 7,106.59$ 0.99% Contracted Services 6610 Contracted Services & ExpTotal Contracted Services Capital Expenses 6710 Computer Hardware 2,000.00$ 2,000.00$ -$ 0.00% Total Capital Expenses 2,000.00$ 2,000.00$ $0.00 0.00% 6800 MSP reserve for Preservation projects 133,596.41$ $133,596.41 100.00% Total Bureau Expenses 1,140,440.00$ 1,305,816.00$ $165,376.00 12.66% Acct. #Line Item 2019 Budget Proposed 2020 Budget 2018-2019 Comparison %Change Revenue 4100 Room Tax 508,980.00$ 524,250.00$ 15,270.00$ 3.00% 4200 Interest Earning 1,800.00$ 1,800.00$ -$ 0.00% 4300 MDT MMG/MPD Coop 26,371.00$ 26,371.00$ -$ 0.00% 4350 Special Events 5,000.00$ 5,000.00$ -$ 0.00% 4500 Fundraising Athletic Events Revenue 19,500.00$ 19,500.00$ -$ 0.00% 4550 Prison Tour Ticket Sales 572,000.00$ 583,440.00$ 11,440.00$ 2.00% 4560 MSP Museum Admission 28,000.00$ 28,000.00$ -$ 0.00% 4700 Misc Advertising revenue 2,000.00$ 2,000.00$ -$ 0.00% 4801 Jefferson City Promotional Item Sales 87,210.00$ 88,000.00$ 790.00$ 0.91% 4900 Miscellaneous Revenue 3,000.00$ 3,000.00$ -$ 0.00% Total Revenue 1,253,861.00$ 1,281,361.00$ 27,500.00$ 2.19% Payroll Expenses 6100 Salaries and Wages 225,900.00$ 225,900.00$ -$ 0.00% 6120 Retirement Benefits 4,400.00$ 4,400.00$ -$ 0.00% 6130 Payroll Taxes 20,000.00$ 20,000.00$ -$ 0.00% 6140 Insurance Benefits 40,000.00$ 42,400.00$ 2,400.00$ 6.00% Total Payroll Expenses 290,300.00$ 292,700.00$ 2,400.00$ 0.83% Administrative and General Expenses 6200 Auditing and Accounting 21,325.00$ 21,325.00$ -$ 0.00% 6210 Building Rental 43,550.00$ 44,450.00$ 900.00$ 2.07% 6210 Building Maintenance 1,000.00$ 250.00$ (750.00)$ -75.00% 6211 Building Utilities 2,000.00$ 3,000.00$ 1,000.00$ 50.00% 6212 Cleaning Services 3,000.00$ 3,000.00$ -$ 0.00% 6213 Security Monitoring 500.00$ 500.00$ -$ 0.00% 6220 Computer Support/Service 5,860.00$ 0.00% 6230 Consulting 500.00$ 500.00$ -$ 0.00% 6240 Dues and Subscriptions 1,582.00$ 1,582.00$ -$ 0.00% 6245 Depreciation Expense 13,500.00$ 13,500.00$ -$ 0.00% 6250 Office Equip Lease & 5,000.00$ 5,000.00$ -$ 0.00% 6260 Insurance Premiums 8,000.00$ 8,000.00$ -$ 0.00% 6270 Minor Office Furniture 500.00$ 500.00$ -$ 0.00% 6280 Misc. Expenses 3,835.00$ 4,000.00$ 165.00$ 4.30% 6300 Office Supplies 2,200.00$ 2,000.00$ (200.00)$ -9.09% 6310 Printing and Binding 2,000.00$ 2,000.00$ -$ 0.00% 6320 Telephone and Fax 11,000.00$ 11,000.00$ -$ 0.00% 6330 Training and Education 2,240.00$ 2,240.00$ -$ 0.00% Total Administrative and General Expense 127,592.00$ 122,847.00$ (4,745.00)$ -3.86% Marketing Expenses 6285 Promotional Items to sell 56,000.00$ 56,000.00$ -$ 0.00% 6340 Travel Expenses 14,000.00$ 14,000.00$ -$ 0.00% 6360 MSP Tour Expenses 11,000.00$ 11,000.00$ -$ 0.00% 6361 MSP Salaries and Wages 262,000.00$ 262,000.00$ -$ 0.00% 6362 MSP Digital Marketing 26,832.50$ 31,657.50$ 4,825.00$ 17.98% 6363 MSP Credit Card Fees 35,000.00$ 35,000.00$ -$ 0.00% 6364 MSP Janitorial Services 3,960.00$ 4,000.00$ 40.00$ 1.01% 6365 MSP Tour Insurance 5,000.00$ 5,000.00$ -$ 0.00% 6367 MSP Advertising 27,887.50$ 30,718.50$ 2,831.00$ 10.15% 6368 MSP Utilites and Lawn service 17,950.00$ 10,000.00$ (7,950.00)$ -44.29% 6369 MSP Capital Improvements 15,000.00$ 15,000.00$ -$ 0.00% 6370 MSP Museum 2,000.00$ 2,000.00$ -$ 0.00% 6400 Graphic Design 5,000.00$ 5,000.00$ -$ 0.00% 6410 Outdoor Advertising 26,800.00$ 32,300.00$ 5,500.00$ 20.52% 6430 Brochures/Printed Material 9,000.00$ 9,000.00$ -$ 0.00% 6440 Postage and Freight 7,000.00$ 7,000.00$ -$ 0.00% 6461 Marketing Memberships 5,335.00$ 5,335.00$ -$ 0.00% 6470 Print Advertising 28,000.00$ 31,960.50$ 3,960.50$ 14.14% 6490 Marketing Research 5,000.00$ 5,000.00$ -$ 0.00% 6500 Promotion/Publicity 7,400.00$ 5,000.00$ (2,400.00)$ -32.43% 6510 Sponsorship 42,000.00$ 42,000.00$ -$ 0.00% 6520 Tradeshow Fees 13,383.00$ 13,500.00$ 117.00$ 0.87% 6530 Familiarization tour expense 6,000.00$ 6,000.00$ -$ 0.00% 6540 Marketing Promo 6,000.00$ 6,500.00$ 500.00$ 8.33% 6545 Public Relations 5,000.00$ 5,000.00$ -$ 0.00% 6550 Digital Marketing 28,000.00$ 28,800.00$ 800.00$ 2.86% 6560 Local Promotions 5,000.00$ 5,000.00$ -$ 0.00% 6620 Special Events 5,000.00$ 5,000.00$ -$ 0.00% 6630 Athletic Events Exp - CVB 20,000.00$ 20,000.00$ -$ 0.00% 6640 Athletic Events Committee Exp 20,000.00$ 20,000.00$ -$ 0.00% Total Marketing 720,548.00$ 728,771.50$ 8,223.50$ 1.14% Contracted Services 6610 Contracted Services & ExpTotal Contracted Services Capital Expenses 6710 Computer Hardware 2,000.00$ 2,000.00$ -$ 0.00% Total Capital Expenses 2,000.00$ 2,000.00$ $0.00 0.00% 6800 MSP reserve for Preservation projects $0.00 #DIV/0! Total Bureau Expenses 1,140,440.00$ 1,146,318.50$ $5,878.50 0.51% 135,042.50$