The URL can be used to link to this page

Home My Public Portal About2018-09-20 packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, September 20, 2018 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 May 24, 2018 meeting 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. Available Sewer Service Charge 7. Discussion of Possible Funding for Ongoing Infrastructure/Facility Needs 8. New Business 9. Old Business 10. 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, May 24, 2018 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Prather at 7:32 am. Roll call showed that Councilmen Prather, Mihalevich, Graham, and Hensley, along with Councilwoman Wiseman were in attendance. Next the minutes of the March 8, 2018 and April 16, 2018 meetings were reviewed. A motion to approve was made by Councilman Mihalevich and seconded by Councilwoman Wiseman. The minutes were approved unanimously. The next item on the agenda was a report by the Finance Director, Margie Mueller, covering the Financial Reports. Ms. Mueller reviewed the Revenue Model, the May 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 $4,555,411. The average monthly amount collected for the 4 Cent Lockbox Fund is $52,161. A report comparing occupancy rates for 2018, 2017, 2016, 2015, 2014, 2013 and 2012 was included along with a report listing occupancy rates from other cities. The next item on the agenda was an update on the Municipal Court Bid from City Counselor, Ryan Moehlman. Mr. Moehlman made a request for $80,000 of additional funding for this project. A motion to move the request to full Council was made by Councilman Graham and seconded by Councilman Mihalevich. The motion was approved unanimously. There was no new business to discuss. The next item on the agenda was old business. Councilman Prather brought up the Bill regarding out of state motor vehicle tax that would extend the date this tax would be terminated. Ms. Mueller said the FY2019 budget will be modified accordingly. A motion was made by Councilwoman Wiseman and seconded by Councilman Graham to adjourn the meeting. The meeting adjourned at 8:17 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:September 7, 2018 Re:Sales Tax Revenues The City received the September 1% Sales Tax in the amount of $1,129,543 which is $84,387 less than projected for September. January through September overage is $124,636 (1.09%) 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 $709,248 $ 672,771 $36,477 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $1,042,310 $ 1,089,718 ($47,408) May-18 Jul-18 $1,117,038 $ 1,077,018 $40,020 Jun-18 Aug-18 $821,132 $ 654,961 $166,170 Jul-18 & Apr-June 18 Qtrly Sep-18 $1,129,543 $ 1,213,930 ($84,387) 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 $124,636 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 $340,740 $ 294,739 $46,001 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $508,225 $ 477,402 $30,823 May-18 Jul-18 $548,625 $ 471,838 $76,787 Jun-18 Aug-18 $393,512 $ 286,937 $106,575 Jul-18 & Apr-June 18 Qtrly Sep-18 $545,731 $ 531,819 $13,912 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 ($587,490) 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 $340,708 $ 302,107 $38,601 Apr-18 & Jan-Mar 18 Qtrly Jun-18 $508,266 $ 489,337 $18,929 May-18 Jul-18 $548,639 $ 483,634 $65,005 Jun-18 Aug-18 $393,578 $ 294,110 $99,467 Jul-18 & Apr-June 18 Qtrly Sep-18 $545,842 $ 545,115 $728 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 $362,245 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: AUGUST 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 709,248 act. 658,961 Apr & Jan-Mar Qtrly June 1,023,015 865,930 1,045,933 1,119,566 1,000,942 1,042,310 act. 1,011,077 May July 872,436 1,048,754 963,280 1,012,207 1,154,051 1,117,038 act. 1,010,146 Jun August 546,351 614,048 562,996 661,518 678,636 821,132 act. 612,710 Jul & Apr-Jun Qtrly September 1,096,581 996,272 1,185,891 1,197,976 1,143,504 1,129,543 act. 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 8,773,276 Estimated to Fiscal Year end (based on averages and on Budgeted amount)2,764,361 Total Actual & Estimated $ 11,537,636 Less: Budget 11,413,000 Over (Under) Budget $ 124,636 $ 884,259 $ 1,811,549 $ 2,967,291 $ 3,954,006 $ 4,663,254 $ 5,705,564 $ 6,822,601 $ 7,643,733 $ 8,773,276 $ 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 9/7/2018 City of Jefferson, Mo. - Account Analysis Account Name Capital Imprs Sales Tax Receipt Month: AUGUST 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 340,740 act. 327,530 Apr & Jan-Mar Qtrly June 483,070 416,943 496,466 539,529 489,008 508,225 act. 485,003 May July 425,325 503,869 473,120 498,229 559,119 548,625 act. 491,932 Jun August 272,603 306,157 280,733 330,112 338,618 393,512 act. 305,645 Jul & Apr-Jun Qtrly September 521,260 484,992 565,296 570,134 542,457 545,731 act. 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 4,237,305 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,211,058 Total Actual & Estimated $ 5,448,362 Less: Budget (Increased by $1,035,852 due to Ordinance 15775) 6,035,852 Over (Under) Budget -$ 587,490 $ 424,160 $ 868,636 $ 1,444,529 $ 1,900,472 $ 2,241,212 $ 2,749,437 $ 3,298,062 $ 3,691,574 $ 4,237,305 $ 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 9/7/2018 City of Jefferson, Mo. - Account Analysis Account Name Parks Sales Tax Receipt Month: AUGUST 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 340,708 act. 327,138 Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 508,266 act. 484,830 May July 389,006 425,194 503,790 473,038 498,229 559,115 548,639 act. 491,873 Jun August 278,072 272,321 305,930 280,513 330,112 338,470 393,578 act. 305,469 Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 545,842 act. 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 4,245,910 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,241,334 Total Actual & Estimated $ 5,487,245 Less: Budget 5,125,000 Over (Under) Budget $ 362,245 $ 424,192 $ 874,671 $ 1,451,818 $ 1,908,878 $ 2,249,586 $ 2,757,852 $ 3,306,491 $ 3,700,068 $ 4,245,910 $ 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 9/7/2018 Re v e n u e Mo d e l Re p o r t Fo r th e Pe r i o d En d i n g Au g u s t 31 , 20 1 8 Da t a as of Se p t e m b e r 7, 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 9/ 7 / 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 $ 8 , 7 7 3 , 2 7 5 . 8 3 $ 1 2 4 , 6 3 6 . 4 0 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 $ 1 , 7 2 8 , 3 5 6 . 6 8 $ 5 3 , 8 3 6 . 5 0 Ot h e r Ta x e s $1 1 5 , 0 0 0 . 0 0 $ 7 9 , 2 7 2 . 8 0 ($ 6 , 3 3 6 . 0 6 ) 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 $ 5 , 6 8 1 , 4 0 8 . 7 5 $ 2 0 0 , 6 5 9 . 2 1 Pr o p e r t y Ta x e s $5 , 4 0 6 , 3 9 9 . 0 0 $ 5 , 4 3 4 , 3 7 6 . 9 4 $ 5 8 , 4 7 1 . 6 5 In t e r g o v e r n m e n t a l $4 3 6 , 4 7 9 . 5 0 $ 1 6 7 , 1 9 2 . 9 8 ($ 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 , 6 5 5 , 2 7 4 . 6 8 $ 8 6 , 6 5 2 . 0 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 $ 9 5 8 , 0 7 5 . 3 7 $ 1 6 2 , 2 8 3 . 8 1 Fi n e s & Fo r f e i t u r e s $8 9 4 , 1 0 0 . 0 0 $ 6 5 6 , 6 3 7 . 1 2 ($ 8 8 , 9 2 8 . 2 8 ) Co n t r i b u t i o n s / D o n a t i o n s $3 1 4 , 4 6 2 . 5 0 $ 1 9 8 , 2 9 8 . 0 0 $ 1 6 , 4 4 8 . 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 $ 8 1 , 4 1 4 . 6 6 $ 3 0 , 9 9 6 . 9 9 In t e r e s t In c o m e $1 2 1 , 0 6 2 . 3 9 $ 1 2 9 , 4 5 9 . 0 5 $ 4 1 , 6 0 9 . 3 2 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 , 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 $2 0 , 2 0 0 . 5 2 $1 7 0 . 8 9 To t a l s $3 2 , 1 0 8 , 0 5 9 . 0 8 $ 2 6 , 5 9 4 , 5 8 6 . 7 8 $ 4 8 1 , 8 2 7 . 9 4 FY2018 Revenue Model Report (Detail)Remaining For the Period Ending August 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 9/7/18 As of 9/7/18 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,413,000.00 $8,773,275.83 $2,764,360.57 $11,537,636.40 $124,636.40 $124,636.40 $11,413,000.00 $8,773,275.83 $2,764,360.57 $11,537,636.40 $124,636.40 $124,636.40 Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $562,000.00 $400,025.09 $187,594.87 $587,619.96 $25,619.96 $25,619.96 10‐100‐403010 Gasoline Tax $1,147,000.00 $758,539.03 $396,884.95 $1,155,423.98 $8,423.98 $8,423.98 10‐100‐430080 Road & Bridge Tax $550,000.00 $569,792.56 $0.00 $569,792.56 $19,792.56 $19,792.56 $2,259,000.00 $1,728,356.68 $584,479.82 $2,312,836.50 $53,836.50 $53,836.50 Other Taxes 10‐100‐403020 Cig Tax $115,000.00 $79,272.80 $29,391.14 $108,663.94 ($6,336.06)($6,336.06) $115,000.00 $79,272.80 $29,391.14 $108,663.94 ($6,336.06)($6,336.06) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,050,000.00 $2,973,502.01 $1,226,036.16 $4,199,538.17 $149,538.17 $149,538.17 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 $856,170.05 $104,243.45 $960,413.50 $60,413.50 $60,413.50 10‐100‐410052 Telephone/Cell Utility $2,050,000.00 $1,364,002.62 $498,773.62 $1,862,776.24 ($187,223.76)($187,223.76) 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 $269,784.07 $104,987.03 $374,771.10 ($55,228.90)($55,228.90) $7,430,000.00 $5,681,408.75 $1,949,250.46 $7,630,659.21 $200,659.21 $200,659.21 Property Taxes 10‐100‐420010 Current Property Tax $4,740,000.00 $4,752,433.51 $8,543.44 $4,760,976.95 $20,976.95 $20,976.95 10‐100‐420020 Del Property Tax $40,000.00 $29,763.21 $7,896.44 $37,659.65 ($2,340.35)($2,340.35) 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 $27,613.51 $5,274.94 $32,888.45 $7,888.45 $7,888.45 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 $466,073.02 $1,431.51 $467,504.53 ($1,495.47)($1,495.47) 10‐100‐420080 Special Tax Rev $30,000.00 $66,817.91 $7,347.39 $74,165.30 $44,165.30 $44,165.30 $5,406,399.00 $5,434,376.94 $30,493.71 $5,464,870.65 $58,471.65 $58,471.65 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 $1,508.00 $237.40 $1,270.60 $1,508.00 $0.00 $0.00 10‐100‐480020 NSP Rehab Sales $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10‐100‐480025 HUD Program Income $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $436,479.50 $167,192.98 $69,270.60 $236,463.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 $20,909.00 $4,646.01 $25,555.01 ($444.99)($444.99) 10‐100‐440910 Fuel Charge ‐ backs $14,000.00 $8,845.72 $2,398.60 $11,244.32 ($2,755.68)($2,755.68) 10‐100‐440920 Parts Charge backs $185,000.00 $201,770.10 $29,410.12 $231,180.22 $46,180.22 $46,180.22 10‐100‐440930 Labor Charge backs $245,000.00 $205,794.15 $37,647.25 $243,441.40 ($1,558.60)($1,558.60) 10‐100‐481020 Cole Cty Animal Rescue $108,145.00 $81,109.29 $27,036.25 $108,145.54 $0.54 $0.54 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 $149,022.11 $14,857.72 $163,879.83 $23,879.83 $23,879.83 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 $313,664.62 $63,228.56 $376,893.18 ($475.32)($475.32) 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $60.00 $0.00 $60.00 $60.00 $60.00 10‐100‐481085 Cole Cty GIS Joint Coop $16,850.00 $12,500.00 $4,350.00 $16,850.00 $0.00 $0.00 10‐100‐481100 Sale Of Grave Sites $4,000.00 $3,282.00 $634.53 $3,916.53 ($83.47)($83.47) 10‐100‐481105 TIF Administration Fee $8,912.19 $8,912.19 $0.00 $8,912.19 $0.00 $0.00 10‐100‐481110 Long & Short $0.00 ($9.50)$0.00 ($9.50)($9.50)($9.50) $2,764,831.69 $2,655,274.68 $196,209.03 $2,851,483.71 $86,652.02 $86,652.02 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $59,000.00 $64,950.59 $1,358.81 $66,309.40 $7,309.40 $7,309.40 10‐100‐450020 Business Licenses $215,000.00 $198,412.11 $12,887.99 $211,300.10 ($3,699.90)($3,699.90) 10‐100‐450021 Home Occupation Permit $1,600.00 $1,967.00 $149.10 $2,116.10 $516.10 $516.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 ($100,000.00)$51,010.30 $44,510.30 $44,510.30 10‐100‐450045 Building Construct. Fees $245,000.00 $275,580.43 $59,343.34 $334,923.77 $89,923.77 $89,923.77 10‐100‐450050 Electrical Certificates $19,000.00 $20,913.00 $673.74 $21,586.74 $2,586.74 $2,586.74 10‐100‐450060 Electrical Permits $4,000.00 $2,487.99 $1,448.90 $3,936.89 ($63.11)($63.11) 10‐100‐450070 Plumbing Licenses $10,500.00 $12,582.00 $452.46 $13,034.46 $2,534.46 $2,534.46 10‐100‐450080 Plumbing Permits $3,600.00 $4,403.50 $713.25 $5,116.75 $1,516.75 $1,516.75 FY2018 Revenue Model Report (Detail)Remaining For the Period Ending August 31, 2018 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 9/7/18 As of 9/7/18 TOTAL (Under) Budget of Formulas 10‐100‐450090 Other Lic & Permits $2,000.00 $841.00 $723.34 $1,564.34 ($435.66)($435.66) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $6,570.00 $1,673.20 $8,243.20 $1,243.20 $1,243.20 10‐100‐450092 Food Inspection Fees $85,000.00 $89,263.57 ($2,329.58)$86,933.99 $1,933.99 $1,933.99 10‐100‐450100 Curb Cut Permits $800.00 $2,980.00 $121.49 $3,101.49 $2,301.49 $2,301.49 10‐100‐450110 Board Of Adj Fees $1,300.00 $1,430.00 $400.88 $1,830.88 $530.88 $530.88 10‐100‐450120 Sign Permits $6,000.00 $4,545.00 $813.92 $5,358.92 ($641.08)($641.08) 10‐100‐450130 Demolition Permits $900.00 $836.00 $165.83 $1,001.83 $101.83 $101.83 10‐100‐450150 Acc Rep Fees‐police $11,200.00 $9,864.60 $2,139.41 $12,004.01 $804.01 $804.01 10‐100‐450160 Accrpt/blastg P‐fire $900.00 $369.00 $464.35 $833.35 ($66.65)($66.65) 10‐100‐450170 Animal Redemption Fees $63,000.00 $51,498.28 $12,634.06 $64,132.34 $1,132.34 $1,132.34 10‐100‐450180 Animal Vaccinations Fees $4,800.00 $4,100.00 $909.03 $5,009.03 $209.03 $209.03 10‐100‐450185 Animal Cremation Fees $33,000.00 $33,739.00 $7,922.26 $41,661.26 $8,661.26 $8,661.26 10‐100‐450186 Animal Boarding Fees $0.00 $320.00 $0.00 $320.00 $320.00 $320.00 10‐100‐450190 Taxi Permits $0.00 $79.00 $0.00 $79.00 $79.00 $79.00 10‐100‐450230 Vacating Right Of Way $800.00 $532.00 $61.70 $593.70 ($206.30)($206.30) 10‐100‐450250 Rezoning Request $10,000.00 $4,783.00 $1,259.09 $6,042.09 ($3,957.91)($3,957.91) 10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $9,925.00 $811.40 $10,736.40 $2,736.40 $2,736.40 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,203.00 $110.47 $1,313.47 ($486.53)($486.53) $800,700.00 $958,075.37 $4,908.44 $962,983.81 $162,283.81 $162,283.81 Fines & Forfeitures 10‐100‐460010 Court Cost $73,000.00 $57,617.14 $13,298.24 $70,915.38 ($2,084.62)($2,084.62) 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 $9,528.72 $2,203.42 $11,732.14 ($767.86)($767.86) 10‐100‐460020 Jail Cost Recovery $2,000.00 $1,789.57 $172.40 $1,961.97 ($38.03)($38.03) 10‐100‐460025 Alcohol Offense Cost Rec $7,500.00 $3,509.42 $1,221.95 $4,731.37 ($2,768.63)($2,768.63) 10‐100‐460030 Pol Fines‐traffic $750,000.00 $525,012.99 $123,468.45 $648,481.44 ($101,518.56)($101,518.56) 10‐100‐460090 Parking Fines $53,000.00 $61,802.24 $8,994.90 $70,797.14 $17,797.14 $17,797.14 10‐100‐460100 Bankcard Charges ($3,900.00)($2,622.96)($824.76)($3,447.72)$452.28 $452.28 $894,100.00 $656,637.12 $148,534.60 $805,171.72 ($88,928.28)($88,928.28) 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 $1,100.00 $1,100.00 $0.00 $1,100.00 $0.00 $0.00 10‐100‐480080 Dare Donations $0.00 $500.00 $0.00 $500.00 $500.00 $500.00 10‐100‐480090 Police K‐9 Donations $500.00 $500.00 $0.00 $500.00 $0.00 $0.00 10‐100‐480165 Animal S Donations $0.00 $14,402.00 $0.00 $14,402.00 $14,402.00 $14,402.00 10‐100‐481055 Street Repair‐Solid Waste Cntr $312,862.50 $180,250.00 $132,612.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 $314,462.50 $198,298.00 $132,612.50 $330,910.50 $16,448.00 $16,448.00 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $22,882.36 $0.00 $22,882.36 $22,882.36 $22,882.36 10‐100‐481070 Miscellaneous $36,000.00 $22,662.66 $8,011.59 $30,674.25 ($5,325.75)($5,325.75) 10‐100‐481072 TIF Prof Svcs Deposit $0.00 $3,712.50 $0.00 $3,712.50 $3,712.50 $3,712.50 10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $15,361.57 $4,232.63 $19,594.20 $1,594.20 $1,594.20 10‐100‐481077 Insurance Claims $20,000.00 $16,795.57 $11,338.12 $28,133.69 $8,133.69 $8,133.69 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,000.00 $81,414.66 $33,582.33 $114,996.99 $30,996.99 $30,996.99 Interest Income 10‐100‐470010 Interest $121,062.39 $129,459.05 $33,212.66 $162,671.71 $41,609.32 $41,609.32 $121,062.39 $129,459.05 $33,212.66 $162,671.71 $41,609.32 $41,609.32 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $45,000.00 $31,343.40 $15,000.00 $46,343.40 $1,343.40 $1,343.40 $45,000.00 $31,343.40 $15,000.00 $46,343.40 $1,343.40 $1,343.40 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $24,024.00 $20,200.52 $3,994.37 $24,194.89 $170.89 $170.89 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $24,024.00 $20,200.52 $3,994.37 $24,194.89 $170.89 $170.89 $32,108,059.08 $26,594,586.78 $5,995,300.24 $32,589,887.02 $481,827.94 $481,827.94 CITY OF JEFFERSON FISCAL YEAR 2018 ESTIMATED FUND BALANCE FYE2017 UNASSIGNED FUND BALANCE (Audited)9,231,503.12$ FYE2017 Estimated Fund Balance % of Adopted Budget 28.65% 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 (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)$ CAMPO Grant ‐ City share of $150,000 contract (4,500.00)$ (3,147,127.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,380,375.39$ FYE2018 ESTIMATED Fund Balance % of Adopted Budget 16.58% 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 Total 8,275,953.34 3,475,900.40 4,832,207.14 average monthly amount for 4 cent lockbox fund 52,665.16$ **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 57.60%62.20%59.80%59.80%59.30%52.90%54.90% April 61.70%62.40%67.20%58.10%63.70%64.10%53.90% May 64.60%63.80%64.90%63.10%64.70%56.80%53.70% June 63.20%70.40%64.00%59.70%63.70%55.70%53.10% July 60.30%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: July 2018 Percent Change from July 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 73.6 73.7 133.44 130.84 98.17 96.43 -0.2 2.0 1.8 3.9 2.1 1.9 67.1 66.5 130.06 126.70 87.22 84.29 0.8 2.6 3.5 5.6 2.0 2.9 55764 33555 5261778 3902687 West North Central 68.1 68.8 103.61 103.16 70.59 71.02 -1.0 0.4 -0.6 1.8 2.4 1.4 57.8 58.1 99.20 97.19 57.29 56.46 -0.6 2.1 1.5 3.7 2.2 1.6 4689 2824 367885 272372 Missouri 67.7 70.8 103.89 102.91 70.38 72.87 -4.3 0.9 -3.4 -0.8 2.7 -1.7 59.6 61.5 99.62 98.57 59.33 60.62 -3.2 1.1 -2.1 0.3 2.4 -0.8 1141 680 104575 76232 Kansas City, MO-KS 69.6 74.2 106.82 105.09 74.35 77.99 -6.2 1.6 -4.7 -0.9 3.9 -2.6 63.1 67.0 104.31 102.64 65.86 68.74 -5.7 1.6 -4.2 -1.5 2.8 -3.1 303 248 33353 29580 St Louis, MO-IL 71.3 74.0 108.15 108.10 77.13 79.95 -3.6 0.0 -3.5 -2.1 1.5 -2.1 65.7 66.7 104.62 104.56 68.73 69.79 -1.6 0.1 -1.5 -0.1 1.5 -0.1 336 257 39144 33741 Columbia, MO+60.3 69.4 85.81 86.81 51.78 60.20 -13.0 -1.2 -14.0 -5.0 10.5 -3.9 56.6 62.1 87.89 86.40 49.77 53.67 -8.9 1.7 -7.3 -1.3 6.4 -3.0 40 32 4096 3468 Jefferson City, MO+60.3 65.0 74.96 75.91 45.18 49.35 -7.3 -1.2 -8.5 -8.5 0.0 -7.3 58.4 62.1 80.31 79.23 46.89 49.18 -5.9 1.4 -4.6 -4.6 0.0 -5.9 15 12 1494 1140 Springfield, MO 74.0 73.2 87.28 82.36 64.56 60.25 1.1 6.0 7.1 10.6 3.3 4.4 65.8 63.1 85.53 82.08 56.29 51.80 4.3 4.2 8.7 11.6 2.7 7.1 70 49 6287 4712 Branson, MO 69.8 73.4 116.91 116.52 81.65 85.58 -4.9 0.3 -4.6 -3.7 0.9 -4.0 48.4 50.9 106.13 102.21 51.40 52.01 -4.8 3.8 -1.2 0.3 1.5 -3.4 150 34 13931 4564 Lake of the Ozarks+65.5 66.3 127.72 123.32 83.63 81.77 -1.3 3.6 2.3 2.0 -0.2 -1.5 46.5 49.7 107.32 104.05 49.92 51.74 -6.5 3.1 -3.5 -5.1 -1.7 -8.0 36 13 2706 1733 Joplin, MO 62.2 69.9 86.36 88.00 53.74 61.49 -10.9 -1.9 -12.6 -8.3 4.9 -6.6 57.8 63.3 83.23 81.43 48.07 51.56 -8.8 2.2 -6.8 -2.2 4.9 -4.3 32 24 2445 2123 Saint Joseph, MO+61.5 61.1 89.30 88.42 54.95 54.04 0.7 1.0 1.7 1.7 0.0 0.7 57.6 59.4 87.83 86.96 50.57 51.64 -3.0 1.0 -2.1 6.0 8.2 4.9 13 10 1214 1056 Independence, MO+67.3 74.1 92.40 89.26 62.16 66.16 -9.2 3.5 -6.1 -0.6 5.8 -4.0 57.0 62.2 83.29 84.17 47.51 52.34 -8.3 -1.1 -9.2 -4.0 5.8 -3.0 21 13 1631 1314 A blank row indicates insufficient data. 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 - July 2018 vs July 2017 RoomsRevPARPropertiesADR Participation Occ % Current Month - July 2018 vs July 2017 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. SEWER SERVICE CHARGES BACKGROUND The City Code Sec. 29-140 (attached) describes how sewer service charges are levied. The charges are levied against every residential, commercial, industrial and government establishment connected to public sewers and against all such establishments which are not connected to public sewers but for which sewer service is available. Sewer service is considered available if a sewer is within one hundred fifty (150) feet of any part of the property on which a residential, commercial, industrial or governmental establishment exists. The sewer service charge consists of a monthly fixed minimum charge plus a charge based upon the cubic feet of water used per month. ISSUE It appears that our billing practices are in conflict with the City Code. The City has never charged the fixed minimum charge per month to vacant establishments or abandoned establishments that have sewer service available to them. DISCUSSION We consulted with our bond counsel, Piper Jaffray Company, to determine what, if any, effect this may have on our sewer bond covenants. The bond documents describe reasonable charges for all services and state that none of the facilities or services provided by the system will be furnished to any user without a reasonable charge. The intent is to protect the bondholders by assuring that the operation of the system generates revenues to pay back those bondholders. The bond ordinance language prevents the City from exempting users from reasonable sewer charges. In other words, the City could not incent a business to come to town by offering “free” sewer service. Basically, the bond documents refer to “users” of the service and allows the City the flexibility to define reasonable charges. Bond counsel said he could certainly make a case for billing establishments that are not connected but for which sewer service is available, in that there is a certain level of fixed costs to be recovered regardless of whether such connection “used” the system. It is up to the City to define “users” and then levy reasonable charges to those users. The City Code is more restrictive than the bond ordinances by indicating that if the sewer service is available, establishments are to be charged even if they are not connected or using the service. The definition of an “establishment” is a building or structure, so this does not include vacant lots. OPTIONS Option #1: Implement the City Code as currently adopted and bill the minimum monthly charge to vacant or abandoned establishments that have sewer service available to them, even if they are not “using” the service. The fixed minimum charge per month is currently $11.33. The best estimate at this time of the number of properties affected is around 100 (derived from active abandoned properties list). Option #2: Change the City Code to more narrowly define those that are subject to sewer service charges so that only those connected and using the service are charged for sewer services. This aligns with our current billing practices. Rev. 08/21/2018 2941 DIVISION 2. SERVICE CHARGES Sec. 29-140. Generally. Sewer service charges are hereby levied, according to the rate recommendation documented in the 1983 Burns and McDonnell rate study and hereby incorporated by reference as Appendix 1, against every residential, commercial, industrial and governmental establishment connected to public sewers and against all such establishments which are not connected to public sewers but for which sewer service is available. Sewer service shall be considered available if a sewer, which ultimately discharges into the city treatment works, is within one hundred fifty (150) feet of any part of the property on which a residential, commercial, industrial or governmental establishment exists. The proceeds of such charges so derived will be used for the purpose of operation, maintaining and replacing the sewer system and equipment, and for the purpose of retiring the debt for the public wastewater treatment works. Code 1977, § 32-53; Ord. No. 9519, 10-6-80; Ord. No. 10090, § 1(32-53), 10-31-83; Ord. No. 13257, § 1, 9-4-2001) Sec. 29-141. Rates and surcharges. A. All residential, commercial, industrial and governmental establishments shall be charged for sewer service in accordance with the following rate table. The sewer service charge shall consist of a monthly fixed minimum charge plus a charge based upon the cubic feet of water used per month. The charges shall become effective on the dates listed in the table, and shall be applicable through the subsequent years until changed. RATE TABLE I EFFECTIVE DATE FIXED MINIMUM CHARGE VOLUME PER MONTH CHARGE PER 100 CU. FT. June 1, 2010 $ 7.48 $ 2.36 June 1, 2011 7.85 2.48 January 1, 2012 8.35 2.48 June 1, 2012 8.75 2.60 June 1, 2013 9.16 2.73 June 1, 2014 9.59 2.87 June 1, 2015 10.14 3.04 June 1, 2016 10.72 3.22 June 1, 2017 11.33 3.42 Ord. No. 13155, §1, 1-2-2001; Ord. 14754, §1, 12-20-2010; Ord. 14904, §1, 12-19-2011) B. A surcharge rate is established for any wastewater discharged into the city treatment works which contains more than three hundred (300) milligrams per liter of suspended solids, or more than two hundred fifty (250) milligrams per liter biochemical oxygen demand as defined and determined by analytical methods published in Standard Methods for the Examination of Water and Wastewater. Surcharges for suspended solids and BOD shall be paid at the rates established in Rate Table II, and shall be paid in addition to the normally established rates listed in Rate Table I. The charges shall become effective on the dates listed in the table, and shall be applicable through the subsequent year. The rate Rev. 08/21/2018 2942 effective on November 1, 1987, shall be effective thereafter until changed. RATE TABLE II BOD Surcharge Rate SS Surcharge Rate Effective Date Per Pound Per Pound November 1, 1983 $0.072 $0.13 November 1, 1984 $0.080 $0.14 November 1, 1985 $0.089 $0.155 November 1, 1986 $0.097 $0.168 November 1, 1987 $0.106 $0.185 Code 1977, § § 32-54(a); Ord. No. 9519, 10-6-80; Ord. No. 9647, § 1, 7-6-81; Ord. No. 10090, § 1(32- 54(a), (c)), 10-31-83; Ord. No. 10312, § 1, 10-29-84; Ord. No. 14557, §1, 7-6-2009) Sec. 29-142. Additional charge for users outside city. All users outside the corporate limits of the city shall be required to pay an additional charge for use of that part of the system which serves their respective area, and shall be triple the fixed rate . The additional revenue derived from this charge shall be applied to the debt service portion of the sewer budget. Code 1977, § § 32-55(d); Ord. No. 9647, § 2, 7-6-81) Sec. 29-143. Basis for computation. A. Sewer service charges for residential establishments having an average monthly water consumption for the months of January, February and March of one thousand five hundred (1,500) cubic feet or less shall be billed monthly for the twelve-month period beginning in June of each year on the basis of said average monthly water consumption for the immediately preceding months of January, February and March. If a residential establishment is served by a Water District that provides the City with water usage data, which is not based on a calendar month, the City may use the data that most closely approximates usage in the months of January, February, and March, rather than the residential establishment’s actual usage for January, February, and March, in determining monthly water consumption. B. Sewer service charges for all residential establishments having an average monthly water consumption for the months of January, February and March of more than one thousand five hundred (1,500) cubic feet and sewer service charges for all commercial or industrial establishments and governmental establishments shall be billed monthly for the twelve -month period beginning in June of each year on the basis of actual quantity of monthly water consumption of such establishments. If a residential establishment is served by a Water District that provides the City with water usage data, which is not based on a calendar month, the City may use the data that most closely approximates usage in the months of January, February, and March, rather than the residential establishment’s actual usage for January, February, and March, in determining monthly water consumption. Ord. No. 13497, §1, 2-3-2003) C. When a residential establishment is initially occupied and such establishment has no previous record of water consumption, or if a change of occupancy occurs in a residential establishment, the sewer service charge shall be billed monthly on the basis of the actual monthly water consumption until such time as the rate of charges for such establishment may be determined under the provisions of subsections (A) and (B) Rev. 08/21/2018 2943 of this section; provided, however, that in the event the initial or new occupant of such residential establishment has previously established a record of water consumption under the provisions of this division, the rate of charges for such establishment may be based on such previous record until such time as the rate of charge for such establishment may be determined under the provisions of subsections (A) and (B) of this section. Code 1977, § 32-55(a) - (c); Ord. No. 9519, 10-6-80) D. For those residences served by a Water District where a residential establishment is initially occupied and such establishment has no previous record of water consumption, or if a change of occupancy occurs in a residential establishment, the City may bill the residence for its monthly sewer service charges based upon the average monthly charges from the last rate study performed by the City, for a residence with 3 members or the actual number of members in a residence if the user provides the same. If, at the time of the next rate study, it is determined that the residential establishment has not paid the correct amount based on actual water usage, the residential establishment will be refunded any overpayment or be billed for any underpayment. E. For those residences served by a private water service the City may bill the residence for its monthly sewer service charges based upon the average monthly charges from the last rate study performed by the City, for a residence with 3 members or the actual number of members in a residence if the user provides the same. If such user can provide proof of the actual amount of water used , the City shall bill based upon actual waters usage. Ord. 14408, §1, 9-15-2008) Sec. 29-144. Measurement of water consumption. A. The metered water consumption records of the Capital City Water Compa ny, or its successor, as shown by its monthly water bills, shall be used to determine the amount of water consumption of all residential, commercial or industrial establishments and governmental establishments supplied with water by the Capital City Water Company, or its successor, for the purpose of computing sewer service charges under the provisions of this division. B. All residential, commercial or industrial, and governmental establishments supplied with water from sources other than the Capital City Water Company, or its successor, shall furnish evidence satisfactory to the city, of the monthly quantity of water consumption by such establishments from such other sources and in such cases the monthly sewer service charges shall be based upon such evidence ; otherwise the city shall estimate the monthly water consumption of such establishments, and such computation shall constitute the basis for the monthly sewer service charge for such establishments. Code 1977, § 32-56; Ord. No. 9519, 10-6-80) Sec. 29-145. Adjustments. A. Low Usage. When any residential, commercial or industrial, or governmental establishment, using in excess of one thousand five hundred (1,500) cubic feet of water per month, furnishes the city with evidence satisfactory to the city that such establishment actually discharged into the public sewers in the preceding calendar year less than ninety (90) percent of the water used by such establishment, the city may adjust the sewer service charges of such establishment for the next subsequent calendar year by computing same either on the basis of water discharged into the public sewers or by flat rate rather than on the amount of water consumption of such establishment. Code 1977, § 32-57; Ord. No. 9519, 10-6-80) B. Flooding. When any residential, commercial industrial, or governmental establishment furnishes the city Rev. 08/21/2018 2944 with evidence that it has been inundated or had a sewer backup caused by area flooding lasting more than fourteen (14) consecutive days after Januar y 1, 1995, the city may adjust any bill on a pro -rated basis for the time sewer service was not available. The establishment must demonstrate that it has or will take steps to prevent sewer back flows due to flooding. Any request for adjustment must be filed within one year of the bill sought to be adjusted. Ord. No. 12416, § 1, 2-19-96) Sec. 29-146. Billing and collection procedures. A. All sewer service charges shall be paid to the city, or its authorized agent, at the location or locations designated by the city. B. Every Sewer bill shall be due on the 15th of the month. Any portion of said bill which is not paid by the 20th day of the month shall be assessed a late charge of five percent (5%) on all outstanding amounts. Ord. 13205, §1, 6-4-2001; Ord. No. 14668, §1, 5-17-2010; Ord. No. 15334, §1, 10-20-2014) C. Sewer services shall be deemed to be furnished to both the occupant and owner of all residential, commercial or industrial, and governmental establishments receiving sewer service, and the occupant and owner of such establishments shall be severally and jointly liable to the city for payment of the charges for such service rendered on or to premises upon which such establishments are located. If any bill for such service is not paid within fifteen (15) days from the date of such bill, the city may sue the occupant, the owner, or both, of the establishments receiving such service, or for which such service has been made available, and receive any sums due for such services plus a reasonable attorney's fees to be fixed by the court and the costs of such suit. Such suit shall be instituted by the city counselor upon the order of the mayor of the city. In addition, the city may use such other means now or hereafter available to it under the statutes of Missouri and the ordinances of the city to effect the collection of any bill for sewer service remaining unpaid upon the expiration of fifteen (15) days from the date of such bill. D. In the event either the occupant or owner of property which receives sewer service furnished by the City has reason to dispute the amount or nature of any bill, the recipient shall be permitted to make payment under protest, provided that the recipient of service provide to the city at the time of payment the following information: 1. The period of time for which the service is disputed 2. The reason for the dispute 3. The requested remedy Nothing contained herein shall in any way forgive or avoid any payment to the City as outlined in this chapter for sewer services. Upon receipt of any such payment under protest, the Department of Public Works shall respond in writing to the recipient of the service with a response to their complaint and a copy shall be forwarded to the city administrator, the chairman of the Public Works Committee, the City Council, and a reply shall be forthcoming within a reasonable amount of time. Code 1977, § §§ 32-54(b), 32-58, 32-59; Ord. No. 9519, 10-6-80; Ord. No. 10090, § 1(32-54(b)), 10-31- 83) State law reference - Chapter 250, RSMo. § 250.140, 250.234; Chapter 204, RSMo. § 204.455 Rev. 08/21/2018 2945 Sec. 29-147. Annual review and revision. The city shall review annually the schedules of rates for sewer service charges, and revise the rates, if necessary, to generate adequate revenues to pay the costs of operation and maintenance, to promptly pay the principal of and interest on all bonds issued by the city which by their terms are payable solely from the revenues of the treatment works, and to maintain any special accounts created and established by the bond ordinance pursuant to which the bonds are issued. Code 1977, § 32-61; Ord. No. 9519, 10-6-80; Ord. No. 10090, § 1(32-61), 10-31-83) Sec. 29-148. Collection agent. The city may contract, for a stated period of time and for a stated consideration and under such terms and conditions agreeable to the city, with any person for the preparation, mailing and collection, or for the mailing or collection, of bills for sewer service charges. Code 1977, § 32-63; Ord. No. 9519, 10-6-80) Section 29-149. Security Deposit A. Each sewer service customer beginning or restarting service after December 31, 2006 shall be required to make a security deposit as a condition of receiving sewer service. B. Customers requesting service to a one-family dwelling or a one-family unit of a larger residential building, when the customer owns said dwelling or unit, shall deposit $50.00 before receiving sewer service. C. Customers requesting service to a one-family dwelling or a one-family unit of a larger residential building, when the customer does not own said dwelling or unit, shall deposit $50.00 before receiving sewer service. D. Customer requesting service for all dwellings which are not a one -family dwelling or one-family unit of a larger residential building shall deposit $50.00 before receiving sewer service. E. Service deposits may be transferred or applied to a new residence or business location if the customer moves. Adjustment shall be made if the amount of deposit is inadequate or excessive. F. The City of Jefferson may require an additional security deposit as a condition of continued service, if in an unauthorized manner, the customer interferes with or diverts the sewer service situated on or about or delivered to the customer’s premises. Said amount not be in excess of twice the amount identified in Section 29-149 (B) of the Code of the City of Jefferson, Missouri if service is to be continued to a one- family dwelling or a one-family unit of a larger residential building, or twice the amount identified in section 29-149 (C) of the Code of the City of Jefferson, Missouri if service is to be continued to a dwelling which is not a one-family dwelling or a one-family unit of a larger residential building. G. The City of Jefferson may require an additional security deposit from any customer giving false information to access sewer service. Said amount not to be in excess of twice the amount identified in section 29-149 (B) of the Code of the City of Jefferson, Missouri if service is for a one-family dwelling or a one-family unit of a larger residential building, or twice the amount identified in section 29 -149 (C) of the Code of the City of Jefferson, Missouri if service is for a dwelling which is not a one -family dwelling or a one-family unit of a larger residential building. H. Upon termination of service the deposit shall be credited to the final bill and the balance, if any, shall be returned to the customer. I. No customer receiving service at the time of enactment of this ordinance who is current on his or her Rev. 08/21/2018 2946 monthly bill shall be required to post a security deposit for the customer’s current dwelling if said dwelling is receiving sewer services at the time of enactment of this ordinance and so long as the customer remains current on the customer’s monthly service charges for sewer services provided to the customer’s dwelling. If said customer requests sewer services for any other dwelling or location other than the customer’s current dwelling or location, that costumer shall be considered a new customer and subject to the security deposit requirement. J. If any customer not required to post a security deposit due to the provisions of subsection (J) herein becomes more than 60 days in arrears on any payment to City, that customer shall immediately become subject to the security deposit requirement and shall post the appropriate deposit within 30 days of the date the account becomes in arrears. K. The City Administrator may review the amounts listed herein and adjust the amounts for inflation on an annual basis if he or she deems the same necessary in his or her sole desecration. Ord. 14130, §1, 12-4-2006; Ord. 15013, §1, 9-17-2012 ) Sec. 29-150. Limitation on New or Transferred accounts. No person shall be allowed to open a new sewer account or transfer a sewer account from another residence if that person, or any persons residing in the residence for which the new or transferred account has been requested, has any outstanding debt or fee owed to the City. Ord. 14214, §1, 6-18-2007) Sec. 29-151. Charge for Notice of Intent to disconnect. . Any residential, commercial, industrial, or governmental establishments which has received a notice of intent to disconnect water service which has been personally delivered to the establishment shall be charged a service fee, which shall be accessed as $10. (Ord. No. 14668, §2, 5-17-2010; Ord. No. 15821 §1, 08-20-2018) Ord. No. 14829, §16, 8-1-2011; Ord. No. 15540, 7-26-2016) Rev. 08/21/2018 2947 NOTES 1. Cross references - Definitions and rules of construction generally, § 1-2; buildings and building regulations, Ch. 8; health and sanitation, Ch. 15. State law reference - Sewers generally, RSMo. § 88.832 et seq. ONGOING INFRASTRUCTURE/FACILITY NEEDS ACCOUNT 10‐990‐577060 11/1/2016 FY2017 Original Budget 300,000.00$ 6/15/2017 MECO Engineering ‐ recommendation for a generator for City Hall (11,500.00)$ 9/20/2017 Project No. 32150 ‐ 2017 Mill and Overlay ‐ Police Station Parking Area (11,784.80)$ BALANCE AT FY2017 YEAR‐END 276,715.20$ 11/1/2017 Reappropriate remaining FY17 balance to FY18 276,715.20$ 11/1/2017 FY2018 Original Budget 200,000.00$ 1/5/2018 Central Missouri Plumbing ‐ Install 3" Backflow Preventer at Police Station (6,591.00)$ 6/7/2018 Christy Building Standby Power (99,694.40)$ 6/15/2018 HVAC Unit Replacement at City Hall (16,247.25)$ 7/17/2018 Upgrade the Control System for City Hall HVAC (encumbered) (16,893.00)$ BALANCE AT 9/12/2018 337,289.55$