Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My Public Portal
About
2018-04-12 NO meeting packet
Notice of CANCELLATION of Meeting CITY OF JEFFERSON Finance Committee Thursday, April 12, 2018 at 7:30 AM City Hall, 320 E. McCarty Street, Jefferson City, MO ~ Boone-Bancroft Room Memo To:Steve Crowell From:Shiela Pearre Date:April 7, 2018 Re:Sales Tax Revenues The City received the April 1% Sales Tax in the amount of $986,714 which is $24,301 more than projected for April. January through April overage is $13,765 (0.12%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection 1 Variance Nov-17 Jan-18 $884,259 $ 1,017,766 ($133,507) Dec-17 Feb-18 $927,290 $ 807,675 $119,615 Jan-18 & Oct-Dec 17 Qtrly Mar-18 $1,155,742 $ 1,152,386 $3,356 Feb-18 Apr-18 $986,714 $ 962,414 $24,301 Mar-18 May-18 $ 672,771 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 1,089,718 May-18 Jul-18 $ 1,077,018 Jun-18 Aug-18 $ 654,961 Jul-18 & Apr-June 18 Qtrly Sep-18 $ 1,213,930 Aug-18 Oct-18 $ 931,219 Sep-18 Nov-18 $ 654,277 Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 1,178,865 Total Overage/Shortfall $11,413,000 $13,765 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax G Receipt Actual Budget Period Receipts Projection 2 Variance Nov-17 Jan-18 $424,160 $ 445,880 ($21,720) Dec-17 Feb-18 $444,476 $ 353,840 $90,636 Jan-18 & Oct-Dec 17 Qtrly Mar-18 $575,894 $ 504,857 $71,037 Feb-18 Apr-18 $455,943 $ 421,631 $34,312 Mar-18 May-18 $ 294,739 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 477,402 May-18 Jul-18 $ 471,838 Jun-18 Aug-18 $ 286,937 Jul-18 & Apr-June 18 Qtrly Sep-18 $ 531,819 Aug-18 Oct-18 $ 407,964 Sep-18 Nov-18 $ 286,637 Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 516,457 BUDGET AMENDMENT DUE TO ORDINANCE 15775 $0 $ 1,035,852 ($1,035,852) Total Overage/Shortfall $6,035,852 ($861,587) 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection 3 Variance Nov-17 Jan-18 $424,192 $ 457,027 ($32,836) Dec-17 Feb-18 $450,479 $ 362,686 $87,793 Jan-18 & Oct-Dec 17 Qtrly Mar-18 $577,148 $ 517,478 $59,669 Feb-18 Apr-18 $457,060 $ 432,171 $24,888 Mar-18 May-18 $ 302,107 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $ 489,337 May-18 Jul-18 $ 483,634 Jun-18 Aug-18 $ 294,110 Jul-18 & Apr-June 18 Qtrly Sep-18 $ 545,115 Aug-18 Oct-18 $ 418,163 Sep-18 Nov-18 $ 293,803 Oct-18 & Jul-Sept 18 Qtrly Dec-18 $ 529,369 Total Overage/Shortfall $5,125,000 $139,516 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Account Name General Fund Sales Tax Receipt Month: APRIL 2018 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2013 2014 2015 2016 2017 2018 Average Nov January 764,659 741,056 944,619 929,179 1,083,570 884,259 act. 892,617 Dec February 703,181 789,830 727,437 812,670 806,789 927,290 act. 767,982 Jan & Oct-Dec Qtrly March 1,008,111 920,599 1,091,021 1,183,675 1,073,842 1,155,742 act. 1,055,450 Feb April 777,424 737,482 1,059,943 893,024 843,561 986,714 act. 862,287 Mar May 537,141 802,765 618,854 648,305 687,741 672,771 est. 658,961 Apr & Jan-Mar Qtrly June 1,023,015 865,930 1,045,933 1,119,566 1,000,942 1,089,718 est. 1,011,077 May July 872,436 1,048,754 963,280 1,012,207 1,154,051 1,077,018 est. 1,010,146 Jun August 546,351 614,048 562,996 661,518 678,636 654,961 est. 612,710 Jul & Apr-Jun Qtrly September 1,096,581 996,272 1,185,891 1,197,976 1,143,504 1,213,930 est. 1,124,045 Aug October 717,262 919,035 918,839 903,829 883,215 931,219 est. 868,436 Sept November 677,366 651,080 661,849 623,645 615,667 654,277 est. 645,921 Oct & Jul-Sept Qtrly December 932,387 1,015,322 1,075,638 1,016,682 1,149,946 1,178,865 est. 1,037,995 Actual to Date $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 $ 11,121,463 3,954,006 Estimated to Fiscal Year end (based on averages and on Budgeted amount)7,472,759 Total Actual & Estimated $ 11,426,765 Less: Budget 11,413,000 Over (Under) Budget $ 13,765 $ 884,259 $ 1,811,549 $ 2,967,291 $ 3,954,006 $ 1,017,766 $ 1,825,441 $ 2,977,827 $ 3,940,241 $ 4,613,012 $ 5,702,730 $ 6,779,748 $ 7,434,709 $ 8,648,639 $ 9,579,858 $ 10,234,135 $ 11,413,000 $ 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 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 Printed 4/6/2018 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Receipt Month: APRIL 2018 Account Number 45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2013 2014 2015 2016 2017 2018 Average Nov January 372,459 359,800 461,560 455,278 525,521 424,160 act. 434,923 Dec February 350,813 394,475 362,597 405,543 402,964 444,476 act. 383,278 Jan & Oct-Dec Qtrly March 475,110 423,641 511,685 563,056 506,597 575,894 act. 496,018 Feb April 372,340 348,172 512,808 431,353 411,020 455,943 act. 415,139 Mar May 266,422 399,863 308,247 322,957 340,162 294,739 est. 327,530 Apr & Jan-Mar Qtrly June 483,070 416,943 496,466 539,529 489,008 477,402 est. 485,003 May July 425,325 503,869 473,120 498,229 559,119 471,838 est. 491,932 Jun August 272,603 306,157 280,733 330,112 338,618 286,937 est. 305,645 Jul & Apr-Jun Qtrly September 521,260 484,992 565,296 570,134 542,457 531,819 est. 536,828 Aug October 357,619 430,185 442,371 435,416 425,493 407,964 est. 418,217 Sept November 323,871 324,697 330,393 310,506 307,281 286,637 est. 319,350 Oct & Jul-Sept Qtrly December 443,688 485,136 515,478 494,218 561,415 516,457 est. 499,987 Actual to Date $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 $ 5,409,655 1,900,472 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,273,793 Total Actual & Estimated $ 5,174,265 Less: Budget (Increased by $1,035,852 due to Ordinance 15775) 6,035,852 Over (Under) Budget -$ 861,587 $ 424,160 $ 868,636 $ 1,444,529 $ 1,900,472 $ 445,880 $ 799,720 $ 1,304,577 $ 1,726,207 $ 2,020,946 $ 2,498,348 $ 2,970,186 $ 3,257,123 $ 3,788,942 $ 4,196,906 $ 4,483,543 $ 6,035,852 $ 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 Printed 4/6/2018 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Receipt Month: APRIL 2018 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 2018 Average Nov January 405,730 372,447 359,708 461,472 455,239 525,521 424,192 act. 434,877 Dec February 308,456 350,714 393,562 362,371 405,543 395,217 450,479 act. 381,481 Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 577,148 act. 495,943 Feb April 409,353 372,242 348,076 512,738 431,353 411,020 457,060 act. 415,086 Mar May 263,822 266,456 398,085 308,030 322,957 340,162 302,107 est. 327,138 Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 489,337 est. 484,830 May July 389,006 425,194 503,790 473,038 498,229 559,115 483,634 est. 491,873 Jun August 278,072 272,321 305,930 280,513 330,112 338,470 294,110 est. 305,469 Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 545,115 est. 537,316 Aug October 366,846 357,482 430,093 442,370 435,416 425,497 418,163 est. 418,172 Sept November 306,831 323,768 324,481 330,393 310,506 307,305 293,803 est. 319,291 Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 561,445 529,369 est. 499,919 Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 $ 5,401,741 1,908,878 Estimated to Fiscal Year end (based on averages and on Budgeted amount)3,355,637 Total Actual & Estimated $ 5,264,516 Less: Budget 5,125,000 Over (Under) Budget $ 139,516 $ 424,192 $ 874,671 $ 1,451,818 $ 1,908,878 $ 457,027 $ 819,713 $ 1,337,191 $ 1,769,363 $ 2,071,470 $ 2,560,807 $ 3,044,441 $ 3,338,551 $ 3,883,666 $ 4,301,829 $ 4,595,631 $ 5,125,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 Printed 4/6/2018 Re v e n u e Mo d e l Re p o r t Fo r Pe r i o d En d i n g Ma r c h 31 , 20 1 8 Da t a as of Ap r i l 6, 20 1 8 FY 20 1 8 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/ 6 / 1 8 (U n d e r ) Bu d g e t Sa l e s Ta x an d Us e Ta x $1 1 , 4 1 3 , 0 0 0 . 0 0 $ 3 , 9 5 4 , 0 0 5 . 6 7 $ 1 3 , 7 6 4 . 7 5 In t e r g o v e r n m e n t a l Ta x e s $2 , 2 5 9 , 0 0 0 . 0 0 $ 4 1 6 , 6 9 9 . 5 7 $ 1 2 , 7 1 8 . 1 1 Ot h e r Ta x e s $1 1 5 , 0 0 0 . 0 0 $ 3 3 , 8 0 1 . 4 8 ($ 2 , 6 1 0 . 9 3 ) Fr a n c h i s e & Ut i l i t y Ta x $7 , 4 3 0 , 0 0 0 . 0 0 $ 2 , 5 8 5 , 8 1 0 . 8 8 $ 1 6 2 , 0 2 6 . 9 6 Pr o p e r t y Ta x e s $5 , 4 0 6 , 3 9 9 . 0 0 $ 5 , 2 4 4 , 8 0 3 . 3 8 ($ 8 , 2 8 3 . 6 2 ) In t e r g o v e r n m e n t a l $4 3 4 , 9 7 1 . 5 0 $ 2 1 4 , 0 5 2 . 9 6 ($ 2 0 0 , 0 1 5 . 9 2 ) Ch a r g e s fo r Se r v i c e s $2 , 7 6 4 , 8 3 1 . 6 9 $ 2 , 0 9 0 , 1 2 5 . 6 0 $ 6 6 , 7 8 9 . 7 2 Fe e s , Li c e n s e s , & Pe r m i t s $8 0 0 , 7 0 0 . 0 0 $ 4 2 4 , 5 5 5 . 6 6 $ 1 4 3 , 3 2 1 . 0 9 Fi n e s & Fo r f e i t u r e s $8 9 4 , 1 0 0 . 0 0 $ 3 4 2 , 6 3 0 . 5 8 ($ 4 3 , 7 0 3 . 7 3 ) Co n t r i b u t i o n s / D o n a t i o n s $3 1 3 , 7 1 2 . 5 0 $ 1 1 7 , 9 2 0 . 0 0 $ 1 4 , 0 7 0 . 0 0 Ot h e r Op e r a t i n g Re v e n u e s $8 4 , 0 0 0 . 0 0 $ 2 4 , 9 9 0 . 1 5 ($ 1 1 8 . 9 7 ) In t e r e s t In c o m e $1 2 1 , 0 6 2 . 3 9 $ 5 5 , 6 7 9 . 7 8 $ 2 0 , 1 3 5 . 5 9 Ot h e r No n Op e r a t i n g Re v e n u e $4 5 , 0 0 0 . 0 0 $ 3 1 , 3 4 3 . 4 0 $ 1 6 , 3 4 3 . 4 0 Op e r a t i n g Tr a n s f e r s In $2 4 , 0 2 4 . 0 0 $7 , 1 5 3 . 1 0 $2 2 4 . 6 3 To t a l s $3 2 , 1 0 5 , 8 0 1 . 0 8 $ 1 5 , 5 4 3 , 5 7 2 . 2 1 $ 1 9 4 , 6 6 1 . 0 8 FY2018 Revenue Model Report (Detail)Remaining For Period Ending March 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/6/18 As of 4/6/18 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,413,000.00 $3,954,005.67 $7,472,759.08 $11,426,764.75 $13,764.75 $13,764.75 $11,413,000.00 $3,954,005.67 $7,472,759.08 $11,426,764.75 $13,764.75 $13,764.75 Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $135,046.87 $432,988.80 $568,035.67 $6,035.67 $6,035.67 10‐100‐403010 Gasoline Tax $1,147,000.00 $281,652.70 $872,029.74 $1,153,682.44 $6,682.44 $6,682.44 10‐100‐430080 Road & Bridge Tax $550,000.00 $0.00 $550,000.00 $550,000.00 $0.00 $0.00 $2,259,000.00 $416,699.57 $1,855,018.54 $2,271,718.11 $12,718.11 $12,718.11 Other Taxes 10‐100‐403020 Cig Tax $115,000.00 $33,801.48 $78,587.59 $112,389.07 ($2,610.93)($2,610.93) $115,000.00 $33,801.48 $78,587.59 $112,389.07 ($2,610.93)($2,610.93) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $1,162,514.90 $2,902,022.71 $4,064,537.61 $14,537.61 $14,537.61 10‐100‐410021 Electric Utility‐AUDIT $0.00 $233,160.20 $0.00 $233,160.20 $233,160.20 $233,160.20 10‐100‐410030 Gas Utility License Tax $900,000.00 $501,904.26 $416,015.40 $917,919.66 $17,919.66 $17,919.66 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $604,016.72 $1,363,531.24 $1,967,547.96 ($82,452.04)($82,452.04) 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 $430,000.00 $99,425.00 $309,436.53 $408,861.53 ($21,138.47)($21,138.47) $7,430,000.00 $2,585,810.88 $5,006,216.08 $7,592,026.96 $162,026.96 $162,026.96 Property Taxes 10‐100‐420010 Current Property Tax $4,740,000.00 $4,648,247.15 $84,282.31 $4,732,529.46 ($7,470.54)($7,470.54) 10‐100‐420020 Del Property Tax $40,000.00 $7,462.29 $25,368.84 $32,831.13 ($7,168.87)($7,168.87) 10‐100‐420040 Fin Institution Tax $48,000.00 $37,276.50 $0.00 $37,276.50 ($10,723.50)($10,723.50) 10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $11,774.35 $17,601.32 $29,375.67 $4,375.67 $4,375.67 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 $469,000.00 $457,125.17 $6,911.30 $464,036.47 ($4,963.53)($4,963.53) 10‐100‐420080 Special Tax Rev $30,000.00 $28,518.64 $19,148.24 $47,666.88 $17,666.88 $17,666.88 $5,406,399.00 $5,244,803.38 $153,312.00 $5,398,115.38 ($8,283.62)($8,283.62) Intergovernmental 10‐100‐430010 Federal Grant $434,971.50 $166,955.58 $68,000.00 $234,955.58 ($200,015.92)($200,015.92) 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 $0.00 $0.00 $0.00 $0.00 $0.00 $434,971.50 $214,052.96 $20,902.62 $234,955.58 ($200,015.92)($200,015.92) Charges for Services 10‐100‐440010 Admin Charge Backs $1,589,556.00 $1,599,415.00 $0.00 $1,599,415.00 $9,859.00 $9,859.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 $26,000.00 $9,323.00 $14,914.89 $24,237.89 ($1,762.11)($1,762.11) 10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $4,016.38 $7,992.11 $12,008.49 ($1,991.51)($1,991.51) 10‐100‐440920 Parts Charge backs $185,000.00 $91,252.78 $124,896.54 $216,149.32 $31,149.32 $31,149.32 10‐100‐440930 Labor Charge backs $245,000.00 $89,830.47 $165,928.77 $255,759.24 $10,759.24 $10,759.24 10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $27,036.43 $81,108.75 $108,145.18 $0.18 $0.18 10‐100‐481030 Rent City Hall/Annex $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481040 Rent Other $0.00 $0.00 $12,000.00 $12,000.00 $12,000.00 $12,000.00 10‐100‐481045 Rent‐tower Sites $140,000.00 $56,024.77 $91,947.31 $147,972.08 $7,972.08 $7,972.08 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 $377,368.50 $155,890.27 $221,299.96 $377,190.23 ($178.27)($178.27) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $50.00 $0.00 $50.00 $50.00 $50.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,000.00 $816.00 $1,895.28 $2,711.28 ($1,288.72)($1,288.72) 10‐100‐481105 TIF Administration Fee $8,912.19 $230.00 $8,912.19 $9,142.19 $230.00 $230.00 10‐100‐481110 Long & Short $0.00 ($9.50)$0.00 ($9.50)($9.50)($9.50) $2,764,831.69 $2,090,125.60 $741,495.81 $2,831,621.41 $66,789.72 $66,789.72 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $59,000.00 $6,419.84 $46,510.94 $52,930.78 ($6,069.22)($6,069.22) 10‐100‐450020 Business Licenses $215,000.00 $90,384.25 $123,474.89 $213,859.14 ($1,140.86)($1,140.86) 10‐100‐450021 Home Occupation Permit $1,600.00 $1,060.00 $919.10 $1,979.10 $379.10 $379.10 10‐100‐450040 Abandoned Bldg. Regist. $0.00 $2,890.00 $0.00 $2,890.00 $2,890.00 $2,890.00 10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $151,010.30 ($8,050.44)$142,959.86 $136,459.86 $136,459.86 10‐100‐450045 Building Construct. Fees $245,000.00 $78,291.66 $174,134.20 $252,425.86 $7,425.86 $7,425.86 10‐100‐450050 Electrical Certificates $19,000.00 $17,202.00 $3,149.87 $20,351.87 $1,351.87 $1,351.87 10‐100‐450060 Electrical Permits $4,000.00 $777.50 $2,684.00 $3,461.50 ($538.50)($538.50) 10‐100‐450070 Plumbing Licenses $10,500.00 $10,305.00 $1,744.80 $12,049.80 $1,549.80 $1,549.80 10‐100‐450080 Plumbing Permits $3,600.00 $2,020.00 $2,279.52 $4,299.52 $699.52 $699.52 FY2018 Revenue Model Report (Detail)Remaining For Period Ending March 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 4/6/18 As of 4/6/18 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $867.00 $1,068.25 $1,935.25 ($64.75)($64.75) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $3,925.00 $4,016.34 $7,941.34 $941.34 $941.34 10‐100‐450092 Food Inspection Fees $85,000.00 $4,038.91 $80,684.21 $84,723.12 ($276.88)($276.88) 10‐100‐450100 Curb Cut Permits $800.00 $265.00 $499.43 $764.43 ($35.57)($35.57) 10‐100‐450110 Board Of Adj Fees $1,300.00 $210.00 $750.70 $960.70 ($339.30)($339.30) 10‐100‐450120 Sign Permits $6,000.00 $2,199.00 $3,660.31 $5,859.31 ($140.69)($140.69) 10‐100‐450130 Demolition Permits $900.00 $477.00 $554.68 $1,031.68 $131.68 $131.68 10‐100‐450150 Acc Rep Fees‐police $11,200.00 $5,110.20 $6,978.86 $12,089.06 $889.06 $889.06 10‐100‐450160 Accrpt/blastg P‐fire $900.00 $333.00 $687.29 $1,020.29 $120.29 $120.29 10‐100‐450170 Animal Redemption Fees $63,000.00 $20,560.00 $39,351.97 $59,911.97 ($3,088.03)($3,088.03) 10‐100‐450180 Animal Vaccinations Fees $4,800.00 $1,975.00 $2,786.55 $4,761.55 ($38.45)($38.45) 10‐100‐450185 Animal Cremation Fees $33,000.00 $15,950.00 $21,744.70 $37,694.70 $4,694.70 $4,694.70 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 $52.00 $0.00 $52.00 $52.00 $52.00 10‐100‐450230 Vacating Right Of Way $800.00 $532.00 $431.20 $963.20 $163.20 $163.20 10‐100‐450250 Rezoning Request $10,000.00 $2,884.00 $4,923.65 $7,807.65 ($2,192.35)($2,192.35) 10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $3,804.00 $3,464.79 $7,268.79 ($731.21)($731.21) 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,013.00 $1,015.63 $2,028.63 $228.63 $228.63 $800,700.00 $424,555.66 $519,465.43 $944,021.09 $143,321.09 $143,321.09 Fines & Forfeitures 10‐100‐460010 Court Cost $73,000.00 $30,046.35 $41,122.80 $71,169.15 ($1,830.85)($1,830.85) 10‐100‐460015 Court Restitutions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐460018 Inmate Security Fund $12,500.00 $4,980.41 $7,100.57 $12,080.98 ($419.02)($419.02) 10‐100‐460020 Jail Cost Recovery $2,000.00 $694.92 $971.91 $1,666.83 ($333.17)($333.17) 10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $1,600.41 $3,718.42 $5,318.83 ($2,181.17)($2,181.17) 10‐100‐460030 Pol Fines‐traffic $750,000.00 $262,464.97 $425,387.74 $687,852.71 ($62,147.29)($62,147.29) 10‐100‐460090 Parking Fines $53,000.00 $43,755.69 $31,966.04 $75,721.73 $22,721.73 $22,721.73 10‐100‐460100 Bankcard Charges ($3,900.00)($912.17)($2,501.80)($3,413.97)$486.03 $486.03 $894,100.00 $342,630.58 $507,765.69 $850,396.27 ($43,703.73)($43,703.73) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $1,546.00 $0.00 $1,546.00 $1,546.00 $1,546.00 10‐100‐480070 Community Projects Donations $350.00 $850.00 $0.00 $850.00 $500.00 $500.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 $11,524.00 $0.00 $11,524.00 $11,524.00 $11,524.00 10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $103,000.00 $209,862.50 $312,862.50 $0.00 $0.00 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $313,712.50 $117,920.00 $209,862.50 $327,782.50 $14,070.00 $14,070.00 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐481070 Miscellaneous $36,000.00 $13,727.55 $19,286.81 $33,014.36 ($2,985.64)($2,985.64) 10‐100‐481072 TIF Prof Svcs Deposit $0.00 $2,306.25 $0.00 $2,306.25 $2,306.25 $2,306.25 10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $6,379.04 $12,574.67 $18,953.71 $953.71 $953.71 10‐100‐481077 Insurance Claims $20,000.00 $2,577.31 $17,029.40 $19,606.71 ($393.29)($393.29) 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,000.00 $24,990.15 $58,890.88 $83,881.03 ($118.97)($118.97) Interest Income 10‐100‐470010 Interest $121,062.39 $55,679.78 $85,518.20 $141,197.98 $20,135.59 $20,135.59 $121,062.39 $55,679.78 $85,518.20 $141,197.98 $20,135.59 $20,135.59 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40 $45,000.00 $31,343.40 $30,000.00 $61,343.40 $16,343.40 $16,343.40 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $24,024.00 $7,153.10 $17,095.53 $24,248.63 $224.63 $224.63 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24,024.00 $7,153.10 $17,095.53 $24,248.63 $224.63 $224.63 $32,105,801.08 $15,543,572.21 $16,756,889.95 $32,300,462.16 $194,661.08 $194,661.08 CITY OF JEFFERSON FISCAL YEAR 2018 ESTIMATED FUND BALANCE FYE2017 UNASSIGNED FUND BALANCE (Estimated)9,221,164.08$ FYE2017 Estimated Fund Balance % of Adopted Budget 28.62% Reappropriations from FY2017 to FY2018 Port Feasibility Study (47,600.00)$ Stormwater repairs and improvements (750,000.00)$ Legal fees for Mo American Water Tariff Case (14,055.15)$ Downtown Streetscape Repair & Electric Project (637,800.00)$ New Fire Station #2 (still need $938K+) (1,221,035.00)$ Fire Dept building grounds & maintenance for Fire Station #2 (106,785.00)$ Computer Software for PPS (34,800.00)$ Ongoing Infrastructure/Facility Needs (276,715.20)$ Remaining NSP Program Income (47,097.38)$ Public Art (6,740.00)$ (3,142,627.73)$ 2018 Adjustments/Supplementals FY2018 Supplemental Appropriations: LCRA Reimbursement (gap financing for Capitol Ave properties) (259,000.00)$ Workers Compensation (300,000.00)$ Purchase of 1 Dump Truck (145,000.00)$ (704,000.00)$ FYE2018 ESTIMATED Unassigned Fund Balance 5,374,536.35$ FYE2018 ESTIMATED Fund Balance % of Adopted Budget 16.57% 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 Total 7,695,958.86 3,232,302.72 4,478,056.09 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** average monthly amount for 4 cent lockbox fund 51,924.54$ **Effective for 25 years starting in 2011 2018 Occupancy 2017 Occupancy 2016 Occupancy 2015 Occupancy 2014 Occupancy 2013 Occupancy 2012 Occupancy January 48.10%48.70%51.30%45.90%49.20%45.30%38.20% February 53.40%56.80%58.60%51.20%56.00%52.90%49.80% March 62.20%59.80%59.80%59.30%52.90%54.90% April 62.40%67.20%58.10%63.70%64.10%53.90% May 63.80%64.90%63.10%64.70%56.80%53.70% June 70.40%64.00%59.70%63.70%55.70%53.10% July 65.90%58.20%60.80%59.70%58.50%51.40% August 61.50%56.50%52.60%54.20%55.80%47.00% September 64.50%62.60%63.30%61.20%63.00%59.30% October 66.50%62.90%60.70%67.60%65.90%59.30% November 51.50%50.60%51.30%48.90%52.40%43.40% December 40.80%42.10%45.10%38.30%38.80%33.00% COMPARATIVE OCCUPANCY RATE Tab 2 - Multi-Segment Currency: USD - US Dollar Missouri Hotel & Lodging Association For the month of: February 2018 Percent Change from February 2017 Percent Change from YTD 2017 2018 2017 2018 2017 2018 2017 Occ ADR RevPAR Room Rev Room Avail Room Sold 2018 2017 2018 2017 2018 2017 Occ ADR RevPAR Room Rev Room Avail Room Sold Census Sample Census Sample United States 61.7 61.0 126.38 123.53 78.02 75.37 1.2 2.3 3.5 5.6 2.0 3.2 57.9 57.3 124.88 122.24 72.30 70.07 1.0 2.2 3.2 5.3 2.0 3.0 53865 33360 5140020 3863492 West North Central 49.6 49.6 100.83 92.19 50.04 45.70 0.1 9.4 9.5 12.1 2.4 2.5 46.1 46.2 96.35 90.80 44.41 41.91 -0.1 6.1 6.0 8.3 2.2 2.1 4501 2781 355670 267632 Missouri 50.7 52.0 93.43 92.67 47.41 48.17 -2.4 0.8 -1.6 0.8 2.4 -0.0 46.6 47.3 91.57 90.69 42.70 42.91 -1.4 1.0 -0.5 1.7 2.2 0.7 1078 659 99167 74307 Kansas City, MO-KS 55.4 57.7 99.74 97.85 55.25 56.42 -3.9 1.9 -2.1 -0.1 2.0 -2.0 51.5 53.2 97.48 95.87 50.17 50.99 -3.2 1.7 -1.6 -0.1 1.5 -1.7 295 239 32645 28420 St Louis, MO-IL 57.6 57.6 98.15 98.41 56.49 56.66 -0.0 -0.3 -0.3 1.7 2.0 1.9 52.8 52.9 95.78 95.34 50.61 50.40 -0.0 0.5 0.4 2.4 2.0 1.9 333 258 38886 34152 Columbia, MO+51.1 55.8 88.80 86.08 45.41 47.99 -8.3 3.2 -5.4 -0.8 4.8 -3.9 45.0 49.8 85.04 82.71 38.28 41.16 -9.5 2.8 -7.0 -2.5 4.8 -5.2 39 31 3886 3258 Jefferson City, MO+53.4 59.0 82.20 79.07 43.92 46.62 -9.4 4.0 -5.8 -5.8 0.0 -9.4 50.6 54.9 81.61 80.01 41.30 43.89 -7.8 2.0 -5.9 -5.9 0.0 -7.8 15 12 1494 1140 Springfield, MO 56.1 50.7 79.24 77.41 44.46 39.27 10.6 2.4 13.2 16.9 3.3 14.2 52.2 47.4 77.97 77.07 40.69 36.52 10.1 1.2 11.4 14.1 2.4 12.8 70 47 6288 4592 Branson, MO 30.4 29.4 90.77 89.94 27.56 26.45 3.2 0.9 4.2 5.4 1.1 4.4 25.2 23.9 89.59 88.61 22.55 21.15 5.5 1.1 6.6 7.9 1.2 6.7 108 25 9862 3740 Lake of the Ozarks+30.5 37.3 85.25 85.14 26.01 31.76 -18.2 0.1 -18.1 -20.1 -2.4 -20.2 28.2 32.8 88.33 84.90 24.94 27.84 -13.9 4.0 -10.4 -12.5 -2.4 -15.9 32 12 2542 1689 Joplin, MO 54.1 60.2 82.99 79.24 44.90 47.67 -10.1 4.7 -5.8 -1.1 5.0 -5.6 49.4 52.1 81.59 77.90 40.28 40.57 -5.2 4.7 -0.7 4.2 5.0 -0.5 31 24 2413 2124 Saint Joseph, MO+52.5 54.8 87.17 84.94 45.72 46.56 -4.3 2.6 -1.8 7.8 9.8 5.0 46.4 47.8 86.20 85.44 40.02 40.88 -3.0 0.9 -2.1 7.5 9.8 6.5 13 11 1214 1107 A blank row indicates insufficient data. Participation Occ % Current Month - February 2018 vs February 2017 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: 2018 STR, Inc. / STR Global, Ltd. trading as "STR". RevPARADROcc % Year to Date - February 2018 vs February 2017 RoomsRevPARPropertiesADR 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.