The URL can be used to link to this page

Home My Public Portal About2017-11-09 packet Notice of Meeting and Tentative Agenda CITY OF JEFFERSON Finance Committee Thursday, November 9, 2017 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 October 12, 2017 4. Financial Reports a. Sales Tax Report b. Revenue Model Report c. Expense Report d. Fund Balance Report 5. Lodging Tax Report 6. JCCVB Annual Budget Presentation – Diane Gillespie 7. Transient Lodging - License/Tax preferences – Diane Gillespie 8. Discussion of Refinancing Build America Wastewater Bonds – Margie Mueller 9. New Business 10. Old Business 11. Adjournment NOTES Individuals should contact the ADA Coordinator at (573) 634-6570 to request accommodations or alternative formats as required under the Americans with Disabilities Act. Please allow three business days to process the request. CITY OF JEFFERSON Finance Committee Meeting Thursday, October 12, 2017 MINUTES The meeting was called to order by the Finance Committee Chairman, Councilman Mihalevich at 7:32 am. Roll call showed that Councilmen Mihalevich, Hussey, Prather and Graham were in attendance. Councilman Henry was not in attendance during roll call, but joined the meeting at 8:52 am. Next the minutes of the September 14, 2017 meeting were reviewed. A motion to approve was made by Councilman Graham and seconded by Councilman Hussey. 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 October 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,141,609. The average monthly amount collected for the 4 Cent Lockbox Fund is $52,022. A report comparing occupancy rates for 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 a discussion lead by Director of Planning and Protective Services, Sonny Sanders, regarding Property Code Enforcement Software. A motion was made by Councilman Hussey and seconded by Councilman Prather to move a supplemental appropriation to full Council to fund the software. The motion passed unanimously. The next item on the agenda was a discussion lead by Fire Chief, Matt Schofield, regarding Fire Station #2. A motion was made by Councilman Hussey and seconded by Councilman Graham to move a supplemental appropriation to full Council to partially fund Fire Station #2. The motion passed unanimously. The next item on the agenda was a discussion lead by Ms. Mueller, regarding the updated five-year forecast. The next item on the agenda was new business. City Administrator, Steve Crowell, informed the committee that the City had been awarded the Certificate of Achievement for Excellence in Financial Reporting (CAFR) Award and the Popular Annual Financial Reporting (PAFR) Award from the Government Finance Officers Association for fiscal year 2016. There was no old business to discuss. The meeting adjourned at 9:40 am. As recorded by: Shiela Pearre, Chief Accountant Memo To:Steve Crowell From:Shiela Pearre Date:November 8, 2017 Re:Sales Tax Revenues The City received the November 1% Sales Tax in the amount of $615,667 which is $69,026 less than projected for November. January thru November shortfall is $229,749 (2.03%) in the General Fund. 1% General Sales Tax Receipt Actual Budget Period Receipts Projection1 Variance Nov-16 Jan-17 $1,083,570 $924,504 $159,066 Dec-16 Feb-17 $806,789 $823,770 ($16,981) Jan-17 & Oct-Dec 16 Qtrly Mar-17 $1,073,842 $1,129,724 ($55,882) Feb-17 Apr-17 $843,561 $951,232 ($107,670) Mar-17 May-17 $687,741 $731,839 ($44,098) Apr-17 & Jan-Mar 17 Qtrly Jun-17 $1,000,942 $1,071,788 ($70,847) May-17 Jul-17 $1,154,051 $1,069,247 $84,804 Jun-17 Aug-17 $678,636 $650,040 $28,597 Jul-17 & Apr-June 17 Qtrly Sep-17 $1,143,504 $1,195,077 ($51,574) Aug-17 Oct-17 $883,215 $969,353 ($86,138) Sep-17 Nov-17 $615,667 $684,693 ($69,026) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $1,098,734 Total Overage/Shortfall $11,300,000 ($229,749) 1Budgeted based on 3-year average percentage 1/2% Capital Improvement Tax - Sales Tax F & G combined Receipt Actual Budget Period Receipts Projection2 Variance Nov-16 Jan-17 $525,521 $396,801 $128,721 Dec-16 Feb-17 $402,964 $353,565 $49,399 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,597 $484,882 $21,715 Feb-17 Apr-17 $411,020 $408,272 $2,748 Mar-17 May-17 $340,162 $314,108 $26,054 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $460,015 $28,993 May-17 Jul-17 $559,119 $458,924 $100,195 Jun-17 Aug-17 $338,618 $278,999 $59,618 Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $512,931 $29,525 Aug-17 Oct-17 $425,493 $416,050 $9,443 Sep-17 Nov-17 $307,281 $411,938 ($104,657) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $353,515 Total Overage/Shortfall $4,850,000 $351,756 2Budgeted based on 3-year average percentage 1/2% Parks Sales Tax Receipt Actual Budget Period Receipts Projection3 Variance Nov-16 Jan-17 $525,521 $415,075 $110,446 Dec-16 Feb-17 $395,217 $369,848 $25,369 Jan-17 & Oct-Dec 16 Qtrly Mar-17 $506,524 $507,213 ($689) Feb-17 Apr-17 $411,020 $427,075 ($16,055) Mar-17 May-17 $340,162 $328,574 $11,587 Apr-17 & Jan-Mar 17 Qtrly Jun-17 $489,008 $481,201 $7,807 May-17 Jul-17 $559,115 $480,060 $79,055 Jun-17 Aug-17 $338,470 $291,848 $46,622 Jul-17 & Apr-June 17 Qtrly Sep-17 $542,457 $536,554 $5,903 Aug-17 Oct-17 $425,497 $435,211 ($9,714) Sep-17 Nov-17 $307,305 $430,909 ($123,604) Oct-17 & Jul-Sept 17 Qtrly Dec-17 $369,796 Total Overage/Shortfall $5,073,365 $136,727 3Budgeted based on 3-year average percentage Period Reporting Period Reporting Period Reporting City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name General Fund Sales Tax Receipt Month: NOVEMBER 2017 Account Number 10-100-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 843,061 764,659 741,056 944,619 929,179 1,083,570 act.844,515 Dec February 619,287 703,181 789,830 727,437 812,670 806,789 act.730,481 Jan & Oct-Dec Qtrly March 992,559 1,008,111 920,599 1,091,021 1,183,675 1,073,842 act.1,039,193 Feb April 852,653 777,424 737,482 1,059,943 893,024 843,561 act.864,105 Mar May 530,069 537,141 802,765 618,854 648,305 687,741 act.627,427 Apr & Jan-Mar Qtrly June 1,028,514 1,023,015 865,930 1,045,933 1,119,566 1,000,942 act.1,016,592 May July 797,785 872,436 1,048,754 963,280 1,012,207 1,154,051 act.938,892 Jun August 557,032 546,351 614,048 562,996 661,518 678,636 act.588,389 Jul & Apr-Jun Qtrly September 1,069,414 1,096,581 996,272 1,185,891 1,197,976 1,143,504 act.1,109,227 Aug October 769,129 717,262 919,035 918,839 903,829 883,215 act.845,619 Sept November 615,421 677,366 651,080 661,849 623,645 615,667 act.645,872 Oct & Jul-Sept Qtrly December 982,684 932,387 1,015,322 1,075,638 1,016,682 1,098,734 est.1,004,542 Actual to Date $ 9,657,608 $ 9,655,913 $ 10,102,175 $ 10,856,302 $ 11,002,277 9,971,518 Estimated to Fiscal Year end (based on averages and on Budgeted amount)1,098,734 Total Actual & Estimated $ 11,070,251 Less: Budget 11,300,000 Over (Under) Budget -$ 229,749 $ 1,083,570 $ 1,890,359 $ 2,964,201 $ 3,807,762 $ 4,495,504 $ 5,496,445 $ 6,650,496 $ 7,329,132 $ 8,472,636 $ 9,355,851 $ 9,971,518 $ 924,504 $ 1,748,274 $ 2,877,998 $ 3,829,230 $ 4,561,069 $ 5,632,857 $ 6,702,104 $ 7,352,144 $ 8,547,221 $ 9,516,574 $ 10,201,266 $ 11,300,000 $ 0 $ 500,000 $ 1,000,000 $ 1,500,000 $ 2,000,000 $ 2,500,000 $ 3,000,000 $ 3,500,000 $ 4,000,000 $ 4,500,000 $ 5,000,000 $ 5,500,000 $ 6,000,000 $ 6,500,000 $ 7,000,000 $ 7,500,000 $ 8,000,000 $ 8,500,000 $ 9,000,000 $ 9,500,000 $ 10,000,000 $ 10,500,000 $ 11,000,000 $ 11,500,000 $ 12,000,000 Nov Dec Jan & Oct-Dec Qtrly Feb Mar Apr & Jan-Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul-Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name Capital Imprs Sales Tax Receipt Month: NOVEMBER 2017 Account Number 44-100-400010/45-100-440010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 412,434 372,459 359,800 461,560 455,278 525,521 act.412,306 Dec February 308,567 350,813 394,475 362,597 405,543 402,964 act.364,399 Jan & Oct-Dec Qtrly March 466,856 475,110 423,641 511,685 563,056 506,597 act.488,070 Feb April 409,365 372,340 348,172 512,808 431,353 411,020 act.414,808 Mar May 263,902 266,422 399,863 308,247 322,957 340,162 act.312,278 Apr & Jan-Mar Qtrly June 494,757 483,070 416,943 496,466 539,529 489,008 act.486,153 May July 389,423 425,325 503,869 473,120 498,229 559,119 act.457,993 Jun August 278,231 272,603 306,157 280,733 330,112 338,618 act.293,567 Jul & Apr-Jun Qtrly September 504,307 521,260 484,992 565,296 570,134 542,457 act.529,198 Aug October 367,366 357,619 430,185 442,371 435,416 425,493 act.406,591 Sept November 306,968 323,871 324,697 330,393 310,506 307,281 act.319,287 Oct & Jul-Sept Qtrly December 469,095 443,688 485,136 515,478 494,218 353,515 est.481,523 Actual to Date $ 4,671,272 $ 4,664,580 $ 4,877,931 $ 5,260,753 $ 5,356,330 4,848,240 Estimated to Fiscal Year end (based on averages and on Budgeted amount)353,515 Total Actual & Estimated $ 5,201,756 Less: Budget 4,850,000 Over (Under) Budget $ 351,756 $ 525,521 $ 928,485 $ 1,435,082 $ 1,846,103 $ 2,186,264 $ 2,675,273 $ 3,234,392 $ 3,573,009 $ 4,115,466 $ 4,540,959 $ 4,848,240 $ 396,801 $ 750,365 $ 1,235,247 $ 1,643,519 $ 1,957,627 $ 2,417,642 $ 2,876,567 $ 3,155,566 $ 3,668,497 $ 4,084,547 $ 4,496,485 $ 4,850,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 Nov Dec Jan & Oct- Dec Qtrly Feb Mar Apr & Jan- Mar Qtrly May Jun Jul & Apr-Jun Qtrly Aug Sept Oct & Jul- Sept Qtrly REPORTING PERIOD YTD Actuals vs. YTD Budget Actual Budget City of Jefferson, Mo. - Account Analysis Printed 11/8/2017 Account Name Parks Sales Tax Receipt Month: NOVEMBER 2017 Account Number 21-210-400010 Prior 5 years Monthly REPORTING PERIOD RECEIPT PERIOD 2012 2013 2014 2015 2016 2017 Average Nov January 405,730 372,447 359,708 461,472 455,239 525,521 act.410,919 Dec February 308,456 350,714 393,562 362,371 405,543 395,217 act.364,129 Jan & Oct-Dec Qtrly March 466,713 475,026 423,546 511,582 563,039 506,524 act.487,981 Feb April 409,353 372,242 348,076 512,738 431,353 411,020 act.414,752 Mar May 263,822 266,456 398,085 308,030 322,957 340,162 act.311,870 Apr & Jan-Mar Qtrly June 494,733 482,382 416,845 496,386 539,529 489,008 act.485,975 May July 389,006 425,194 503,790 473,038 498,229 559,115 act.457,851 Jun August 278,072 272,321 305,930 280,513 330,112 338,470 act.293,390 Jul & Apr-Jun Qtrly September 505,913 521,155 484,904 565,217 572,847 542,457 act.530,007 Aug October 366,846 357,482 430,093 442,370 435,416 425,497 act.406,441 Sept November 306,831 323,768 324,481 330,393 310,506 307,305 act.319,196 Oct & Jul-Sept Qtrly December 468,924 443,569 484,999 515,368 494,218 369,796 est.481,415 Actual to Date $ 4,664,400 $ 4,662,755 $ 4,874,018 $ 5,259,477 $ 5,358,988 4,840,296 Estimated to Fiscal Year end (based on averages and on Budgeted amount)369,796 Total Actual & Estimated $ 5,210,092 Less: Budget 5,073,365 Over (Under) Budget $ 136,727 $ 525,521 $ 920,739 $ 1,427,263 $ 1,838,283 $ 2,178,445 $ 2,667,453 $ 3,226,568 $ 3,565,038 $ 4,107,495 $ 4,532,991 $ 4,840,296 $ 415,075 $ 784,923 $ 1,292,136 $ 1,719,211 $ 2,047,785 $ 2,528,986 $ 3,009,046 $ 3,300,895 $ 3,837,449 $ 4,272,660 $ 4,703,569 $ 5,073,365 $ 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 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 Oc t o b e r 31 , 20 1 7 Da t a as of No v e m b e r 6, 20 1 7 FY 20 1 7 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 11 / 6 / 1 7 (U n d e r ) Bu d g e t Sa l e s Ta x an d Us e Ta x $1 1 , 3 0 0 , 0 0 0 . 0 0 $ 9 , 9 7 1 , 5 1 7 . 6 8 ($ 2 2 9 , 7 4 8 . 8 0 ) In t e r g o v e r n m e n t a l Ta x e s $2 , 2 2 0 , 0 0 0 . 0 0 $ 2 , 0 6 4 , 5 1 2 . 4 6 $ 1 2 0 , 0 2 7 . 8 2 Ot h e r Ta x e s $1 1 6 , 0 0 0 . 0 0 $ 1 0 4 , 7 1 7 . 0 0 ($ 1 , 3 8 3 . 6 3 ) Fr a n c h i s e & Ut i l i t y Ta x $7 , 5 0 0 , 0 0 0 . 0 0 $ 6 , 5 9 0 , 5 7 8 . 6 9 ($ 4 0 9 , 5 6 4 . 2 5 ) Pr o p e r t y Ta x e s $5 , 2 7 4 , 6 9 9 . 0 0 $ 5 , 4 1 4 , 2 4 9 . 0 0 $ 1 3 9 , 9 7 1 . 9 1 In t e r g o v e r n m e n t a l $6 6 , 9 8 1 . 5 4 $ 7 4 , 7 4 1 . 6 3 $ 7 , 7 6 0 . 0 9 Ch a r g e s fo r Se r v i c e s $2 , 7 1 5 , 9 9 3 . 6 5 $ 2 , 7 3 6 , 8 5 8 . 0 5 $ 6 2 , 6 1 1 . 4 0 Fe e s , Li c e n s e s , & Pe r m i t s $7 0 8 , 4 0 0 . 0 0 $ 9 8 6 , 7 6 5 . 8 2 $ 2 7 6 , 1 1 9 . 8 6 Fi n e s & Fo r f e i t u r e s $1 , 0 0 9 , 1 0 0 . 0 0 $ 8 0 6 , 7 6 7 . 4 7 ($ 2 0 2 , 3 3 2 . 5 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 , 0 5 1 . 6 5 $ 2 8 2 , 1 3 4 . 0 8 $ 1 9 , 0 8 2 . 4 3 Ot h e r Op e r a t i n g Re v e n u e s $8 4 , 1 8 1 . 2 5 $ 1 7 9 , 5 0 0 . 0 5 $ 1 0 6 , 4 4 0 . 4 3 In t e r e s t In c o m e $1 1 0 , 0 0 0 . 0 0 $ 1 6 2 , 1 4 3 . 3 6 $ 6 0 , 6 0 6 . 4 7 Ot h e r No n Op e r a t i n g Re v e n u e $5 4 , 0 0 0 . 0 0 $ 1 2 3 , 2 1 5 . 4 8 $ 6 9 , 2 1 5 . 4 8 Op e r a t i n g Tr a n s f e r s In $23 , 8 0 0 . 0 0 $24 , 8 7 0 . 5 6 $1, 0 7 0 . 5 6 To t a l s $3 1 , 4 9 6 , 2 0 7 . 0 9 $ 2 9 , 5 2 2 , 5 7 1 . 3 3 $ 1 9 , 8 7 7 . 2 4 FY2017 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 11/6/17 As of 11/6/17 TOTAL (Under) Budget of Formulas Sales Tax and Use Tax 10‐100‐400010 Sales Tax $11,300,000.00 $9,971,517.68 $1,098,733.52 $11,070,251.20 ($229,748.80)($229,748.80) $11,300,000.00 $9,971,517.68 $1,098,733.52 $11,070,251.20 ($229,748.80) ($229,748.80) Intergovernmental Taxes 10‐100‐401030 Motor Vehicle Sales Tax $550,000.00 $479,852.71 $82,358.66 $562,211.37 $12,211.37 $12,211.37 10‐100‐403010 Gasoline Tax $1,120,000.00 $971,137.97 $193,156.70 $1,164,294.67 $44,294.67 $44,294.67 10‐100‐430080 Road & Bridge Tax $550,000.00 $613,521.78 $0.00 $613,521.78 $63,521.78 $63,521.78 $2,220,000.00 $2,064,512.46 $275,515.36 $2,340,027.82 $120,027.82 $120,027.82 Other Taxes 10‐100‐403020 Cig Tax $116,000.00 $104,717.00 $9,899.37 $114,616.37 ($1,383.63)($1,383.63) $116,000.00 $104,717.00 $9,899.37 $114,616.37 ($1,383.63)($1,383.63) Franchise & Utility Tax 10‐100‐410020 Electric Utility Lic Tax $4,000,000.00 $3,645,744.85 $262,915.46 $3,908,660.31 ($91,339.69)($91,339.69) 10‐100‐410030 Gas Utility License Tax $1,000,000.00 $752,821.01 $43,257.23 $796,078.24 ($203,921.76)($203,921.76) 10‐100‐410052 Telephone/Cell Utility $2,070,000.00 $1,819,165.63 $167,873.72 $1,987,039.35 ($82,960.65)($82,960.65) 10‐100‐410053 Telephone/Cell Audit $0.00 ($15,210.20)$16,210.20 $1,000.00 $1,000.00 $1,000.00 10‐100‐410060 Cable Franchise Fee $430,000.00 $388,057.40 $9,600.45 $397,657.85 ($32,342.15)($32,342.15) $7,500,000.00 $6,590,578.69 $499,857.06 $7,090,435.75 ($409,564.25)($409,564.25) Property Taxes 10‐100‐420010 Current Property Tax $4,617,300.00 $4,720,215.86 $0.00 $4,720,215.86 $102,915.86 $102,915.86 10‐100‐420020 Del Property Tax $46,000.00 $43,546.50 ($1,178.57)$42,367.93 ($3,632.07)($3,632.07) 10‐100‐420040 Fin Institution Tax $42,000.00 $53,460.77 $0.00 $53,460.77 $11,460.77 $11,460.77 10‐100‐420050 Prop Tax Int & Penalties $25,000.00 $25,561.56 $0.00 $25,561.56 $561.56 $561.56 10‐100‐420055 Surtax Receipts ‐ County Reimb $54,399.00 $54,399.28 $0.00 $54,399.28 $0.28 $0.28 10‐100‐420060 Surtax Receipts $465,000.00 $464,993.27 $107.77 $465,101.04 $101.04 $101.04 10‐100‐420080 Special Tax Rev $25,000.00 $52,071.76 $1,492.71 $53,564.47 $28,564.47 $28,564.47 $5,274,699.00 $5,414,249.00 $421.91 $5,414,670.91 $139,971.91 $139,971.91 Intergovernmental 10‐100‐430040 Local Grant $5,040.00 $5,040.09 $0.00 $5,040.09 $0.09 $0.09 10‐100‐480020 NSP Rehab Sales $61,941.54 $62,291.54 $0.00 $62,291.54 $350.00 $350.00 10‐100‐480025 HUD Program Income $0.00 $7,410.00 $0.00 $7,410.00 $7,410.00 $7,410.00 $66,981.54 $74,741.63 $0.00 $74,741.63 $7,760.09 $7,760.09 Charges for Services 10‐100‐440010 Admin Charge Backs $1,556,063.00 $1,556,063.00 $0.00 $1,556,063.00 $0.00 $0.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 $28,000.00 $19,880.00 $865.67 $20,745.67 ($7,254.33)($7,254.33) 10‐100‐440910 Fuel Charge ‐ backs $11,000.00 $8,729.20 $0.00 $8,729.20 ($2,270.80)($2,270.80) 10‐100‐440920 Parts Charge backs $185,000.00 $180,537.64 $17,742.57 $198,280.21 $13,280.21 $13,280.21 10‐100‐440930 Labor Charge backs $240,000.00 $209,414.48 $20,862.43 $230,276.91 ($9,723.09)($9,723.09) 10‐100‐481020 Cole Cty Animal Rescue $105,508.00 $105,508.04 $0.00 $105,508.04 $0.04 $0.04 10‐100‐481030 Rent City Hall/Annex $35,000.00 $35,000.00 $0.00 $35,000.00 $0.00 $0.00 10‐100‐481040 Rent Other $0.00 $12,000.00 $0.00 $12,000.00 $12,000.00 $12,000.00 10‐100‐481045 Rent‐tower Sites $104,000.00 $148,078.17 $2,276.32 $150,354.49 $46,354.49 $46,354.49 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 $366,423.91 $369,684.77 $0.00 $369,684.77 $3,260.86 $3,260.86 10‐100‐481080 Sale Of Maps/GIS Data $0.00 $30.00 $0.00 $30.00 $30.00 $30.00 10‐100‐481085 Cole Cty GIS Joint Coop $15,000.00 $26,100.00 $0.00 $26,100.00 $11,100.00 $11,100.00 10‐100‐481100 Sale Of Grave Sites $4,000.00 $7,344.00 $0.00 $7,344.00 $3,344.00 $3,344.00 10‐100‐481105 TIF Administration Fee $15,998.74 $8,498.75 $0.00 $8,498.75 ($7,499.99)($7,499.99) 10‐100‐481110 Long & Short $0.00 ($10.00)$0.00 ($10.00)($10.00)($10.00) $2,715,993.65 $2,736,858.05 $41,747.00 $2,778,605.05 $62,611.40 $62,611.40 Fees, Licenses, & Permits 10‐100‐450010 Liquor Licenses $66,000.00 $64,965.58 $0.00 $64,965.58 ($1,034.42)($1,034.42) 10‐100‐450020 Business Licenses $215,000.00 $219,287.68 $0.00 $219,287.68 $4,287.68 $4,287.68 10‐100‐450021 Home Occupation Permit $1,600.00 $1,695.98 $0.00 $1,695.98 $95.98 $95.98 10‐100‐450040 Abandoned Bldg. Regist. $0.00 $7,775.00 $0.00 $7,775.00 $7,775.00 $7,775.00 10‐100‐450041 Abandoned Bldg. Admin Fee $6,500.00 $102,430.00 $0.00 $102,430.00 $95,930.00 $95,930.00 10‐100‐450045 Building Construct. Fees $150,000.00 $309,019.70 $0.00 $309,019.70 $159,019.70 $159,019.70 10‐100‐450050 Electrical Certificates $19,000.00 $19,797.00 $0.00 $19,797.00 $797.00 $797.00 10‐100‐450060 Electrical Permits $4,000.00 $2,619.34 $0.00 $2,619.34 ($1,380.66)($1,380.66) 10‐100‐450070 Plumbing Licenses $10,500.00 $10,596.00 $0.00 $10,596.00 $96.00 $96.00 10‐100‐450080 Plumbing Permits $4,000.00 $4,595.75 $0.00 $4,595.75 $595.75 $595.75 10‐100‐450090 Other Lic & Permits $2,000.00 $1,783.00 $0.00 $1,783.00 ($217.00)($217.00) 10‐100‐450091 Day Care Inspection Fees $7,000.00 $6,035.00 $0.00 $6,035.00 ($965.00)($965.00) FY2017 Revenue Model Report (Detail)Remaining For Period Ending October 31, 2017 YTD Actual Estimated Revenues Actual & Estimated Projected Over/Verification Description Budget As of 11/6/17 As of 11/6/17 TOTAL (Under) Budget of Formulas 10‐100‐450092 Food Inspection Fees $85,000.00 $88,292.49 ($3,167.99)$85,124.50 $124.50 $124.50 10‐100‐450100 Curb Cut Permits $800.00 $1,163.00 $0.00 $1,163.00 $363.00 $363.00 10‐100‐450110 Board Of Adj Fees $1,300.00 $2,730.00 $0.00 $2,730.00 $1,430.00 $1,430.00 10‐100‐450120 Sign Permits $5,100.00 $6,291.00 $0.00 $6,291.00 $1,191.00 $1,191.00 10‐100‐450130 Demolition Permits $900.00 $795.00 $0.00 $795.00 ($105.00)($105.00) 10‐100‐450150 Acc Rep Fees‐police $11,200.00 $11,376.70 $109.29 $11,485.99 $285.99 $285.99 10‐100‐450160 Accrpt/blastg P‐fire $900.00 $1,842.00 $0.00 $1,842.00 $942.00 $942.00 10‐100‐450170 Animal Redemption Fees $60,000.00 $65,795.00 $0.00 $65,795.00 $5,795.00 $5,795.00 10‐100‐450180 Animal Vaccinations Fees $4,300.00 $4,825.00 $0.00 $4,825.00 $525.00 $525.00 10‐100‐450185 Animal Cremation Fees $30,000.00 $37,085.00 $812.74 $37,897.74 $7,897.74 $7,897.74 10‐100‐450186 Animal Boarding Fees $0.00 $930.00 $0.00 $930.00 $930.00 $930.00 10‐100‐450190 Taxi Permits $700.00 $338.00 $0.00 $338.00 ($362.00)($362.00) 10‐100‐450230 Vacating Right Of Way $800.00 $1,596.00 $0.00 $1,596.00 $796.00 $796.00 10‐100‐450250 Rezoning Request $12,000.00 $5,003.60 $0.00 $5,003.60 ($6,996.40)($6,996.40) 10‐100‐450255 Planning & Zoning Review Fees $8,000.00 $7,048.00 $0.00 $7,048.00 ($952.00)($952.00) 10‐100‐450260 Non‐refundable Plans/spec $1,800.00 $1,055.00 $0.00 $1,055.00 ($745.00)($745.00) $708,400.00 $986,765.82 ($2,245.96)$984,519.86 $276,119.86 $276,119.86 Fines & Forfeitures 10‐100‐460010 Court Cost $75,500.00 $73,101.50 $0.00 $73,101.50 ($2,398.50)($2,398.50) 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 $12,105.14 $0.00 $12,105.14 ($394.86)($394.86) 10‐100‐460020 Jail Cost Recovery $4,000.00 $1,589.66 $0.00 $1,589.66 ($2,410.34)($2,410.34) 10‐100‐460025 Alcohol Offense Cost Rec $8,000.00 $5,638.40 $0.00 $5,638.40 ($2,361.60)($2,361.60) 10‐100‐460030 Pol Fines‐traffic $860,000.00 $686,234.78 $0.00 $686,234.78 ($173,765.22)($173,765.22) 10‐100‐460090 Parking Fines $53,000.00 $31,193.89 $0.00 $31,193.89 ($21,806.11)($21,806.11) 10‐100‐460100 Bankcard Charges ($3,900.00)($3,095.90)$0.00 ($3,095.90)$804.10 $804.10 $1,009,100.00 $806,767.47 $0.00 $806,767.47 ($202,332.53)($202,332.53) Contributions/Donations 10‐100‐480055 JC Fire Museum $0.00 $3,296.00 $0.00 $3,296.00 $3,296.00 $3,296.00 10‐100‐480070 Community Projects Donations $10,301.65 $10,301.65 $0.00 $10,301.65 $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 $15,286.43 $0.00 $15,286.43 $15,286.43 $15,286.43 10‐100‐481055 Street Repair‐Solid Waste Cntr $302,250.00 $252,250.00 $50,000.00 $302,250.00 $0.00 $0.00 10‐100‐481095 Cemetery Donations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $313,051.65 $282,134.08 $50,000.00 $332,134.08 $19,082.43 $19,082.43 Other Operating Revenues 10‐100‐480011 Police Evidence Funds $0.00 $10,457.83 $0.00 $10,457.83 $10,457.83 $10,457.83 10‐100‐481070 Miscellaneous $35,000.00 $54,918.45 $325.49 $55,243.94 $20,243.94 $20,243.94 10‐100‐481072 TIF Prof Svcs Deposit $1,181.25 $86,196.29 $0.00 $86,196.29 $85,015.04 $85,015.04 10‐100‐481074 Revenue Share ‐ Purchasing Card $18,000.00 $16,532.97 $796.14 $17,329.11 ($670.89)($670.89) 10‐100‐481077 Insurance Claims $20,000.00 $11,394.51 $0.00 $11,394.51 ($8,605.49)($8,605.49) 10‐100‐481078 Cafeteria Refunds $10,000.00 $0.00 $10,000.00 $10,000.00 $0.00 $0.00 $84,181.25 $179,500.05 $11,121.63 $190,621.68 $106,440.43 $106,440.43 Interest Income 10‐100‐470010 Interest $110,000.00 $162,143.36 $8,463.11 $170,606.47 $60,606.47 $60,606.47 $110,000.00 $162,143.36 $8,463.11 $170,606.47 $60,606.47 $60,606.47 Other Non Operating Revenue 10‐100‐485050 Sale Of Assets $54,000.00 $123,215.48 $0.00 $123,215.48 $69,215.48 $69,215.48 $54,000.00 $123,215.48 $0.00 $123,215.48 $69,215.48 $69,215.48 Operating Transfers In 10‐100‐490240 Trsfr From Lodging Tax $23,800.00 $24,870.56 $0.00 $24,870.56 $1,070.56 $1,070.56 10‐100‐490630 Transfer from Self Funded Hlth Ins $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $23,800.00 $24,870.56 $0.00 $24,870.56 $1,070.56 $1,070.56 $31,496,207.09 $29,522,571.33 $1,993,513.00 $31,516,084.33 $19,877.24 $19,877.24 CITY OF JEFFERSON FISCAL YEAR 2017 ESTIMATED FUND BALANCE FYE2016 UNASSIGNED FUND BALANCE (Audited)8,844,970.00$ FYE2016 Fund Balance % of Adopted Budget 28.77% Reappropriations from FY2016 to FY2017 Remaining Funds from Sale of Old Fire Station #3 (111,788.00)$ MECO Design Contract for Downtown Electric (12,000.00)$ Remaining Funds for Compensation & Class Study (20,754.89)$ Upgrade for Food Inspection Software (1,474.00)$ Remaining balance for court softward project (5,563.24)$ SOMO Sewer Extension (300,000.00)$ Remaining Funds for Public Art (3,665.00)$ NRA Rental Façade (15,066.00)$ NSP Rehab Sales (350.00)$ (470,661.13)$ 2017 Adjustments/Supplementals FY2017 Supplemental Appropriations: Matching for professional services grant for Capital Area MPO (2,250.00)$ Fire Apparatus Lease Payoff (1,163,313.93)$ Professional Legal Services (Buescher case) (17,000.00)$ Columbia Regional Airport air service guarantee participation (100,000.00)$ Port Feasibility Study (47,600.00)$ Design of South Lincoln Street slope stabilization (61,800.00)$ Stormwater repairs and improvements (750,000.00)$ Legal fees for Mo American Water Tariff Case (20,000.00)$ Lincoln Street Project (338,694.60)$ (2,500,658.53)$ 2017 Release of Restricted Funds ‐ Parks Multipurpose Building 1,500,000.00$ FYE2017 ESTIMATED Unassigned Fund Balance 7,373,650.34$ FYE2017 ESTIMATED Fund Balance % of Adopted Budget 22.89% 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 1,450.30 6/2013 Interest Received Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** (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 (8.29) 9/2014 Service Charge Aug‐14 9/20/14 75,962.88 31,904.41 42,539.21 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 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 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 Tax Period Due Date to City Total Lodging Tax JCCVB (3/7) JCCVB/Tourism Fund (4/7)** 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 Total 7,265,927.58 3,051,689.59 4,210,123.09 average monthly amount for 4 cent lockbox fund 52,165.63$ **Effective for 25 years starting in 2011 20 1 7 Oc c u p a n c y 2 0 1 6 Oc c u p a n c y 2 0 1 5 Oc c u p a n c y 2 0 1 4 Oc c u p a n c y 2 0 1 3 Oc c u p a n c y 2 0 1 2 Occupancy Ja n u a r y 4 8 . 7 0 % 5 1 . 3 0 % 4 5 . 9 0 % 4 9 . 2 0 % 4 5 . 3 0 % 3 8 . 2 0 % Fe b r u a r y 5 6 . 8 0 % 5 8 . 6 0 % 5 1 . 2 0 % 5 6 . 0 0 % 5 2 . 9 0 % 4 9 . 8 0 % Ma r c h 6 2 . 2 0 % 5 9 . 8 0 % 5 9 . 8 0 % 5 9 . 3 0 % 5 2 . 9 0 % 5 4 . 9 0 % Ap r i l 6 2 . 4 0 % 6 7 . 2 0 % 5 8 . 1 0 % 6 3 . 7 0 % 6 4 . 1 0 % 5 3 . 9 0 % Ma y 6 3 . 8 0 % 6 4 . 9 0 % 6 3 . 1 0 % 6 4 . 7 0 % 5 6 . 8 0 % 5 3 . 7 0 % Ju n e 7 0 . 4 0 % 6 4 . 0 0 % 5 9 . 7 0 % 6 3 . 7 0 % 5 5 . 7 0 % 5 3 . 1 0 % Ju l y 6 5 . 9 0 % 5 8 . 2 0 % 6 0 . 8 0 % 5 9 . 7 0 % 5 8 . 5 0 % 5 1 . 4 0 % Au g u s t 6 1 . 5 0 % 5 6 . 5 0 % 5 2 . 6 0 % 5 4 . 2 0 % 5 5 . 8 0 % 4 7 . 0 0 % Se p t e m b e r 6 4 . 5 0 % 6 2 . 6 0 % 6 3 . 3 0 % 6 1 . 2 0 % 6 3 . 0 0 % 5 9 . 3 0 % Oc t o b e r 6 2 . 9 0 % 6 0 . 7 0 % 6 7 . 6 0 % 6 5 . 9 0 % 5 9 . 3 0 % No v e m b e r 5 0 . 6 0 % 5 1 . 3 0 % 4 8 . 9 0 % 5 2 . 4 0 % 4 3 . 4 0 % De c e m b e r 4 2 . 1 0 % 4 5 . 1 0 % 3 8 . 3 0 % 3 8 . 8 0 % 3 3 . 0 0 % CO M P A R A T I V E OC C U P A N C Y RA T E Ta b 2 - M u l t i - S e g m e n t Currency: USD - US Dollar Mi s s o u r i H o t e l & L o d g i n g A s s o c i a t i o n Fo r t h e m o n t h o f : S e p t e m b e r 2 0 1 7 Pe r c e n t C h a n g e f r o m S e p t e m b e r 2 0 1 6 Pe r c e n t C h a n g e f r o m Y T D 2 0 1 6 20 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 O c c A D R R e v P A R Ro o m Re v Ro o m Av a i l Ro o m So l d 20 1 7 2 0 1 6 2 0 1 7 2 0 1 6 2 0 1 7 2 0 1 6 O c c A D R R e v P A R Ro o m Re v Room AvailRoom Sold Census S a m p l e C e n s u s S a m p l e Un i t e d S t a t e s 6 9 . 7 6 8 . 7 1 2 8 . 5 2 1 2 7 . 2 6 8 9 . 5 4 8 7 . 4 4 1 . 4 1 . 0 2 . 4 4 . 4 1 . 9 3 . 3 6 7 . 4 6 7 . 0 1 2 7 . 1 4 1 2 4 . 6 5 8 5 . 7 0 8 3 . 5 0 0 . 6 2 . 0 2 . 6 4 . 5 1 . 8 2 . 5 5 4 9 9 7 3 3 0 8 6 5 1 7 4 3 3 1 3 824963 We s t N o r t h C e n t r a l 6 4 . 2 6 7 . 0 1 0 0 . 4 3 1 0 0 . 6 9 6 4 . 4 4 6 7 . 4 3 - 4 . 2 - 0 . 3 - 4 . 4 - 2 . 9 1 . 6 - 2 . 7 5 9 . 9 6 0 . 8 9 8 . 3 6 9 6 . 9 0 5 8 . 9 3 5 8 . 9 2 - 1 . 5 1 . 5 0 . 0 1 . 3 1 . 3 - 0 . 2 4 6 2 1 2 7 6 8 360617 2 6 5 1 6 6 Mi s s o u r i 6 5 . 5 6 7 . 0 1 0 3 . 0 0 9 9 . 3 4 6 7 . 5 0 6 6 . 5 3 - 2 . 1 3 . 7 1 . 5 2 . 5 1 . 0 - 1 . 1 6 2 . 5 6 2 . 7 1 0 0 . 0 3 9 6 . 1 2 6 2 . 4 9 6 0 . 2 6 - 0 . 3 4 . 1 3 . 7 4 . 1 0 . 4 0 . 1 1 1 1 8 6 5 5 1 0 2 0 9 9 7 3 2 3 0 Ka n s a s C i t y , M O - K S 6 8 . 7 6 9 . 8 1 0 6 . 5 2 1 0 1 . 0 1 7 3 . 1 4 7 0 . 4 6 - 1 . 6 5 . 5 3 . 8 2 . 4 - 1 . 3 - 2 . 9 6 7 . 7 6 6 . 0 1 0 4 . 4 4 9 9 . 5 4 7 0 . 6 7 6 5 . 6 7 2 . 6 4 . 9 7 . 6 5 . 5 - 2 . 0 0 . 5 2 9 1 2 3 3 3 2 2 0 5 2 7 8 3 7 St L o u i s , M O - I L 7 0 . 1 7 3 . 2 1 1 0 . 0 7 1 0 7 . 0 3 7 7 . 1 2 7 8 . 3 7 - 4 . 3 2 . 8 - 1 . 6 0 . 2 1 . 8 - 2 . 6 6 7 . 4 6 8 . 0 1 0 6 . 0 3 1 0 1 . 9 9 7 1 . 5 1 6 9 . 3 6 - 0 . 8 4 . 0 3 . 1 4 . 6 1 . 5 0 . 6 3 3 0 2 5 1 3 8 7 0 9 3 3313 Co l u m b i a , M O + 6 3 . 8 6 2 . 8 1 0 5 . 5 2 9 8 . 2 1 6 7 . 3 5 6 1 . 7 0 1 . 6 7 . 4 9 . 2 7 . 8 - 1 . 3 0 . 3 6 3 . 0 6 1 . 3 8 9 . 2 8 8 7 . 6 4 5 6 . 2 1 5 3 . 7 3 2 . 7 1 . 9 4 . 6 1 . 3 - 3 . 2 - 0 . 6 3 8 3 0 3 8 0 4 3 1 7 6 Je f f e r s o n C i t y , M O + 6 4 . 5 6 4 . 9 8 2 . 9 2 7 8 . 1 4 5 3 . 4 6 5 0 . 7 5 - 0 . 7 6 . 1 5 . 4 5 . 4 0 . 0 - 0 . 7 6 2 . 0 6 2 . 9 7 9 . 9 3 7 7 . 9 7 4 9 . 5 4 4 9 . 0 1 - 1 . 4 2 . 5 1 . 1 1 . 1 0 . 0 - 1 . 4 1 5 1 2 1 4 9 4 1 1 4 0 Sp r i n g f i e l d , M O 6 8 . 2 6 2 . 6 8 5 . 6 5 8 0 . 2 3 5 8 . 4 4 5 0 . 2 5 8 . 9 6 . 8 1 6 . 3 1 6 . 3 - 0 . 0 8 . 9 6 4 . 5 6 2 . 8 8 3 . 5 7 8 0 . 2 8 5 3 . 9 1 5 0 . 4 3 2 . 7 4 . 1 6 . 9 6 . 8 - 0 . 1 2 . 6 6 8 4 6 6 0 8 6 4 4 1 6 Br a n s o n , M O 5 5 . 8 6 0 . 0 1 0 3 . 2 3 9 6 . 5 9 5 7 . 5 7 5 7 . 9 6 - 7 . 1 6 . 9 - 0 . 7 - 0 . 4 0 . 3 - 6 . 8 5 1 . 8 5 2 . 7 1 0 2 . 1 0 9 9 . 1 3 5 2 . 8 4 5 2 . 2 1 - 1 . 7 3 . 0 1 . 2 1 . 4 0 . 1 - 1 . 6 1 5 0 3 2 1 3 5 5 1 4 2 2 9 La k e o f t h e O z a r k s + 5 8 . 2 5 9 . 4 1 0 7 . 9 8 1 0 8 . 1 4 6 2 . 8 8 6 4 . 2 5 - 2 . 0 - 0 . 1 - 2 . 1 - 4 . 3 - 2 . 2 - 4 . 2 5 1 . 5 5 1 . 2 1 0 5 . 6 8 1 0 4 . 6 9 5 4 . 4 6 5 3 . 6 4 0 . 6 0 . 9 1 . 5 0 . 5 - 1 . 0 - 0 . 4 3 6 1 2 2712 1 6 8 9 Jo p l i n , M O 6 3 . 9 6 1 . 1 8 1 . 4 9 7 7 . 9 4 5 2 . 0 6 4 7 . 6 2 4 . 6 4 . 5 9 . 3 9 . 2 - 0 . 1 4 . 5 6 3 . 7 6 1 . 6 8 2 . 6 9 8 0 . 0 1 5 2 . 6 4 4 9 . 3 1 3 . 3 3 . 3 6 . 7 6 . 7 - 0 . 1 3 . 2 3 0 2 3 2 2 9 8 2 0 0 9 Sa i n t J o s e p h , M O + 6 2 . 2 7 0 . 0 8 8 . 2 1 8 7 . 4 0 5 4 . 9 0 6 1 . 2 1 - 1 1 . 1 0 . 9 - 1 0 . 3 - 1 . 5 9 . 8 - 2 . 4 6 0 . 2 6 2 . 3 8 9 . 1 2 8 4 . 7 6 5 3 . 6 1 5 2 . 8 4 - 3 . 5 5 . 1 1 . 4 4 . 8 3 . 3 - 0 . 4 1 3 1 1 1 2 1 4 1 1 07 A b l a n k r o w i n d i c a t e s i n s u f f i c i e n t d a t a . Participation Oc c % Cu r r e n t M o n t h - S e p t e m b e r 2 0 1 7 v s S e p t e m b e r 2 0 1 6 Th e S T R D e s t i n a t i o n R e p o r t i s a p u b l i c a t i o n o f S T R , I n c . a n d S T R G l o b a l , L t d . , a n d i s i n t e n d e d s o l e l y f o r u s e b y p a i d s u b s c r i b e rs . R e p r o d u c t i o n o r d i s t r i b u t i o n o f t h e S T R D e s t i n a t i o n R e p o r t , i n w h o l e o r p a r t , w i t h o u t w r i t t e n p e r m i s s i o n i s p r o h i b i t e d a n d su b j e c t t o l e g a l a c t i o n . I f y o u h a v e r e c e i v e d t h i s r e p o r t a n d a r e N O T a s u b s c r i b e r t o t h e S T R D e s t i n a t i o n Re p o r t , p l e a s e c o n t a c t u s i m m e d i a t e l y . S o u r c e : 2 0 1 7 S T R , I n c . / S T R G l o b a l , L t d . t r a d i n g a s " S T R " . Re v P A R AD R Oc c % Ye a r t o D a t e - S e p t e m b e r 2 0 1 7 v s S e p t e m b e r 2 0 1 6 Rooms Re v P A R Properties AD R Ta b 3 ‐ He l p Gl o s s a r y : Fr e q u e n t l y A s k e d Q u e s t i o n s ( F A Q ) : No r t h A m e r i c a : I n t e r n a t i o n a l : 73 5 E a s t M a i n S t r e e t , H e n d e r s o n v i l l e , T N 3 7 0 7 5 U S A B l u e F i n B u i l d i n g , 1 1 0 S o u t h w a r k S t r e e t , L o n d o n S E 1 0 T A T : + 1 6 1 5 8 2 4 8 6 6 4 T : + 4 4 ( 0 ) 2 0 7 9 2 2 1 9 3 0 ho t e l i n f o @ s t r . c o m As i a P a c i f i c : Th o n g T e c k B u i l d i n g , 1 5 S c o t t s R o a d # 0 8 - 1 2 , 2 2 8 2 1 8 S i n g a p o r e T: + 6 4 6 8 0 0 7 8 5 0 Fo r a l l S T R F A Q s , p l e a s e c l i c k h e r e o r v i s i t w w w . s t r . c o m / r e s o u r c e s / f a q Fo r t h e l a t e s t i n i n d u s t r y n e w s , v i s i t H o t e l N e w s N o w . c o m . su p p o r t @ s t r . c o m Fo r a l l S T R d e f i n i t i o n s , p l e a s e v i s i t w w w . s t r . c o m / r e s o u r c e s / g l o s s a r y To l e a r n m o r e a b o u t t h e H o t e l D a t a C o n f e r e n c e , v i s i t H o t e l D a t a C o n f e r e n c e . c o m . ap i n f o @ s t r . c o m Pl e a s e v i s i t o u r w e b s i t e a t w w w . s t r . c o m , o r i f y o u n e e d a d d i t i o n a l a s s i s t a n c e p l e a s e r e a c h o u t t o o u r C u s t o m e r S u p p o r t t e a m . JCCVB 2018 Budget CVB Board Approved November 6, 2017 Acct # Line Item 2018 Budget Explanation of Account Codes Revenue 4100 Room Tax (3% increase)499,000.00$ Monthly lodging tax revenues 4200 Interest Earning 1,200.00$ $100.00 per month 4300 Advertising Cooperative 15,873.00$ FY18 MDT PMF 625.00$ Missouri Life Print (Mar ‐$1250) FY18 MDT PMF $1,084.00 St. Louis Magzine Print (Mar 7 & May $1,084 per issue) FY18 MDT PMF 680.00$ AAA Midwest Traveler(May $1360) FYI18 MDT PMF 200.00$ AAA World KS (May $400) FY18 MDT PMF 2,728.00$ Madden Media Spring /Summer ($5,455) FY18 MDT PMF 2,000.00$ Rural Missouri Print (Mar $1000 and June$1000) FY18 MDT PMF 1,250.00$ Missouri Life Digital (Mar $2,500) FY18 MDT PMF 1,250.00$ TripAdvisor Sponsorship (Jan‐June $2,500) FY19 MDT PMF (pending) 6,056.00$ Mics. Print and digital 4350 Special Events 5,000.00$ 1,500.00$ Corvette Classic 2,500.00$ State Track hotel rebates 1,000.00$ Misc. events 4500 Fundraising Athletic Events Revenue 17,700.00$ 13,000.00$ Eagles fundraiser 1,200.00$ Sports Trivia Fundraiser 3,500.00$ Prison Break 4550 Prison Tour Ticket Sales 535,500.00$ 535,500.00$ Prison tour ticket sales 4560 MSP Museum Admission 26,000.00$ 26,000.00$ museum admission 4600 Grant Support ‐$ Page 1 JCCVB 2018 Budget CVB Board Approved November 6, 2017 4700 Advertising Revenue 2,000.00$ 1,500.00$ MSP Hand fans 500.00$ Misc 4801 Jefferson City Promotional Item Sales 85,500.00$ 85,500.00$ CVB and MSP Promotional Items 4900 Miscellaneous Revenue 6,000.00$ 400.00$ Salute to America Lunches 5,600.00$ Misc. revenue Total Revenue 1,193,773.00$ Payroll Expenses 6100 Salaries and Wages 219,100.00$ (3% increase in salaries) 219,100.00$ CVB Staff 6110 Temporary/Part Time Wages 6120 Retirement Benefits 4,400.00$ 4,400.00$ Simple Retirment Plan 3% 6130 Payroll Taxes 20,000.00$ 20,000.00$ includes Medicare, federal and state employement taxes 6140 Insurance Benefits 37,500.00$ 37,500.00$ Anthem Blue Cross / ACCE Benefits Trust Total Payroll 281,000.00$ 24% Page 2 JCCVB 2018 Budget CVB Board Approved November 6, 2017 Administrative and General Expenses 6200 Auditing and Accounting 21,000.00$ 15,000.00$ Monthly Accounting and Payroll services $1,250 per month 6,000.00$ Annual audit 6210 Building Rental 42,950.00$ 17,750.00$ $3,550 per month Jan‐May 25,200.00$ $3,600 per month June ‐ Dec. 6210 Building Maintenance 1,000.00$ 1,000.00$ 6211 Building Utilities 2,000.00$ 2,000.00$ (over the alloted amount included in lease 6212 Cleaning Service 2,580.00$ 2,580.00$ office cleaning services 6213 Security Monitoring 275.00$ 275.00$ Maintenance contract 6220 Computer Support/Software 4,900.00$ 1,200.00$ Infotrac annual support 3,700.00$ Computer support ‐ IT service 6230 Consulting 500.00$ 500.00$ Legal services 6240 Dues and Subscriptions 1,582.80$ 200.00$ Miscellanous 550.00$ ACCE Annual membership 150.00$ Downtown Jefferson City 40.00$ Eastside Business Association 50.00$ Westside Business Association 420.00$ Jefferson City Chamber of Commerce Page 3 JCCVB 2018 Budget CVB Board Approved November 6, 2017 172.80$ News Tribune Annual Subscription 6245 Depreciation Expense 13,500.00$ $1,125. per month 6250 Office Equip Lease & Repair 4,899.00$ 900.00$ Marco (KOPI) service aggreement 2,000.00$ additional copies and misc expenses 1,624.00$ monthly payments ‐ $135.58 375.00$ Telephone service contract 6260 Insurance Premiums 6,595.00$ 2,545.00$ Worker's Comp 1,250.00$ Director & Officers Liability 1,800.00$ Commercial Package/Umbrella 1,000.00$ Add'l insurance coverage 6270 Minor Office Furniture 500.00$ 500.00$ Misc. Expenses 6280 Misc. Expenses 3,640.00$ 20.00$ Annual Business License/Registration 700.00$ Holiday Luncheon ‐ Diplomats & Comm 120.00$ ACH Payroll processing charge 200.00$ Staff Holiday Party 100.00$ Salute to America Lunches 2,500.00$ Miscellanous (job advertisment, cards.,VIP gifts) 6290 Parking 6300 Office Supplies 2,200.00$ General Office supplies 6310 Printing and Binding 2,500.00$ printing projects and staff materials 6320 Telphone service 9,000.00$ monthly telephone charges 6330 Training and Education 2,240.00$ 240.00$ MACVB ‐ 2 ppl @120.00 Page 4 JCCVB 2018 Budget CVB Board Approved November 6, 2017 700.00$ Gov.'s Conf. on Tourism 800.00$ JC Chamber Leadership program 500.00$ staff training and educational seminars Total Administrative and General Expenses 121,861.80$ 10.21% Marketing 6285 Promotional Items to sell 55,000.00$ JC and MSP items to sell 6340 Travel Expenses 12,900.00$ 6,000.00$ Local and miscellanous travel 1,400.00$ Locations conference with MDT 900.00$ Connect Sports 600.00$ Travel South 500.00$ QCCA Flower Show 1,000.00$ National Sports Commission 800.00$ Missouri Governor's Conf on Tourism 500.00$ Missouri Bank Travel 700.00$ MACVB Annual Conference 500.00$ Working Women's Survival Show 6520 Tradeshows Fees 9,848.00$ 995.00$ AAA Great Vacations 1,198.00$ KC Garden Show MDT sponsors Travel South Domestic ‐ Branson 500.00$ QCCA Flower & Garden Show, Rock Island, IL 295.00$ Missouri Bank Travel Exchange 1,150.00$ Working Women's Survival Show 1,360.00$ Heritage Int'l. 350.00$ Missouri Event Summit 4,000.00$ Connect Sports/NASC 4,000.00$ Miscellanous Tradeshow 6361 MSP Salaries and Wages 258,500.00$ Page 5 JCCVB 2018 Budget CVB Board Approved November 6, 2017 258,500.00$ salary, payroll taxes, insur. and ret. 6362 MSP Digital Marketing 23,682.00$ 287.00$ Website Hosting (MSP and Museum) 2 year contract 2018 and 2019 20.00$ Domain Name Reg (MSP and Museum) 9,000.00$ SEM Internet marketing 2,375.00$ Facebook advertising FY18 MDT PMF 2,500.00$ Missouri Life Digital (Mar) FY18 MDT PMF 1,250.00$ TripAdvisor (Jan‐June) FY19 MDT PMF (pending) 1,250.00$ digital campaign 5,000.00$ Website upgrades 2,000.00$ Misc. 6363 MSP Credit Card Fees 35,000.00$ 35,000.00$ Based on credit card sales and MSP ticket res. system 6364 MSP Janitorial Services 3,960.00$ 3,000.00$ Handy Jon/ Allied Waste monthly services 960.00$ MO Dept of Corrections 6365 MSP Tour Insurance 2,500.00$ 2,500.00$ MSP tour insurance 6366 MSP Misc Expense 11,000.00$ 11,000.00$ Misc tour operating expenses 6367 MSP Advertising 25,644.00$ 2,500.00$ MSP Brochure FY18 MDT PMF 1,250.00$ Misouri Life 1st quarter (Mar issue) FY18 MDT PMF 2,168.00$ St. Louis Magazine (Mar and May issue each $1,084.) FY18 MDT PMF 1,360.00$ AAA Midwest Traveler (May Issue) FY18 MDT PMF 400.00$ AAA World KS FY18 MDT PMF 2,000.00$ Rural Missouri (Mar issue) FY18 MDT PMF 5,455.00$ Madden Media Spring/Summer Insert Page 6 JCCVB 2018 Budget CVB Board Approved November 6, 2017 FY19 MDT PMF (pending) 3,511.00$ Print advertisment 7,000.00$ Misc. advertising projects 6368 MSP Utilities and Lawn Service 16,950.00$ 12,450.00$ Monthly utilities 4,500.00$ 6 months lawn service 6369 MSP Capital Improvements 15,000.00$ 15,000.00$ capital improvements 6370 MSP Museum 2,000.00$ 2,000.00$ museum expensess 6400 Graphic Design 5,000.00$ 5,000.00$ Miscellaneous (MSP and CVB projects) 6410 Outdoor Advertising 26,400.00$ 12,000.00$ Porlier Outdoor Advertising 2 billboards 12,000.00$ DDI Media 2 billboards Jan‐June $2,400.00 new graphics for billboards 6420 Wayfinding Signage 6430 Brochures and Printed Materials 9,000.00$ 9,000.00$ misc. brochures 6440 Postage 9,000.00$ 9,000.00$ Postage charges 6461 Marketing Memberships 5,835.00$ 400.00$ Society of Gov. Meeting Professionals 795.00$ National Assoc. of Sports Commissions 145.00$ Missouri Society of Assoc Executives 75.00$ Missouri Motion Media Association 225.00$ Missouri Travel Council $ 1,050.00 Missouri Association of Convention & Visitors Bureau 1,395.00$ Destination Marketing Intl. Page 7 JCCVB 2018 Budget CVB Board Approved November 6, 2017 750.00$ Missouri Hotel and Lodging Association 1,000.00$ Misc 6470 Print Advertising 27,051.00$ 6,100.00$ Missouri Travel Guide (January 2017 issue) FY 18 MDT PMF 2,000.00$ Rural Missouri (June issue) FY19 MDT PMF 3,851.00$ Print advertisment 2,600.00$ Show Me Missouri (Feb, May, Oct, Nov) 12,500.00$ Misc. print advertisements 6490 Market Research 5,000.00$ $5,000.00 MDT Platform Development 6500 Promotion/Publicity 5,400.00$ $ 1,360.00 Miscellanous(flowers for building, cards, community events) 3,000.00$ Lunches with meeting planners/business and community leaders 800.00$ cookies for convention services and "Thank You" 240.00$ AEC tickets for CVB Staff 6510 Sponsorships 42,000.00$ 5,000.00$ Salute to America 37,000.00$ Misc Event sponsorships 6530 Familiarization (FAM) Tour Expenses 6,000.00$ 6,000.00$ Event/Mtg Planners/Travel Writers visits 6540 Marketing Promo 5,000.00$ 1,730.00$ Misc Gift baskets 100.00$ MSAE and SGMP Holiday Baskets 50.00$ MSAE Holiday Dinner 120.00$ MTC Capitol Days (4 people) Page 8 JCCVB 2018 Budget CVB Board Approved November 6, 2017 3,000.00$ Misc. convention services 3,000.00$ Video producation 6545 Public Relations 5,000.00$ 5,000.00$ 6550 Digital Marketing 27,887.00$ 287.00$ Annual Hosting (2 year contract 2018 and 2019) 175.00$ Domain name registration 1,800.00$ Constant Contact Subscription 9,000.00$ SEM Internet Marketing ‐ Madden Media 1,875.00$ FACE book advertising FY18 MDT PMF 1,250.00$ TripAdvisor (Jan‐June) FY19 MDT PMF (pending) $3,500.00 Digital campaign $5,000.00 Website upgrades $5,000.00 misc. 6560 Local Promotion 5,000.00$ 5,000.00$ Local events 6620 Special Events 5,000.00$ 600.00$ Corvette Classic 1,000.00$ Prison Break 3,400.00$ Misc. 6630 Athletic Events Expenses ‐ CVB 18,705.00$ State Track Expenses 9,000.00$ JCHS Atkins Staduim 1,275.00$ Breakfast for officials 3,100.00$ D & K Transportation 1,630.00$ MSHSAA official rooms 900.00$ Refreshment/ice 500.00$ Holiday reception Cross Country Expenses 1,500.00$ Elks Lodge Breakfast for officials 600.00$ Shuttle service 200.00$ Misc expenses Page 9 JCCVB 2018 Budget CVB Board Approved November 6, 2017 6640 Athletic Events Committee Expenses 19,969.00$ AEC Fundraiser 2,900.00$ Petty Cash 2,000.00$ Auction Merchandise 3,500.00$ Eagles 400.00$ insurance for Eagles fundraiser 150.00$ Thank you Ad State Track Expenses 600.00$ Refreshments 5,250.00$ Lunch for officials Cross Country Expenses 1,100.00$ Lunch for officials 850.00$ Ice 1,500.00$ Prison Break Sponsorships 1,600.00$ misc. event sponsorships 119.00$ Misc. expenses Total Marketing Expenses 699,231.00$ 59% 6610 Contracted Services and Expenses Contracted Services and Expenses 6700 Capital Expenses Office Furniture and Equipment 6710 Computer Hardware 2,000.00$ 6800 Total Capital Expenses 2,000.00$ Page 10 JCCVB 2018 Budget CVB Board Approved November 6, 2017 MSP reserve for Preservation Projects 89,680.20$ 89,680.20$ restricted funds for CVB/MSP projects Total Bureau Expenses 1,193,773.00$ Page 11 Acct.#Line Item 2017Budget Proposed 2018 Budget 2017‐2018 Comparison %Change Revenue 4100 Room Tax 484,500.00$ 499,000.00$ 14,500.00$ 2.99% 4200 Interest Earning 540.00$ 1,200.00$ 660.00$ 122.22% 4300 MDT PMF Coop 36,799.29$ 15,873.00$ (20,926.29)$ ‐56.87% 4350 Special Events 5,000.00$ 5,000.00$ ‐$ 0.00% 4500 Fundraising Athletic Events Revenue 23,200.00$ 17,700.00$ (5,500.00)$ ‐23.71% 4550 Prison Tour Ticket Sales 500,000.00$ 535,500.00$ 35,500.00$ 7.10% 4560 MSP Museum Admission 15,000.00$ 26,000.00$ 11,000.00$ 73.33% 4600 Grant Support 4700 Misc Advertising revenue 2,000.00$ 2,000.00$ ‐$ 0.00% 4801 Jefferson City Promotional Item Sales 80,000.00$ 85,500.00$ 5,500.00$ 6.88% 4900 Miscellaneous Revenue 6,440.00$ 6,000.00$ (440.00)$ ‐6.83% 4950 Jefferson City Outdoors ‐$ Total Revenue 1,153,479.29$ 1,193,773.00$ 40,293.71$ 3.49% Payroll Expenses 6100 Salaries and Wages 233,800.00$ 219,100.00$ (14,700.00)$ ‐6.29% 6110 Temporary/Part‐ Time Wages 1,500.00$ (1,500.00)$ ‐100.00% 6120 Retirement Benefits 4,600.00$ 4,400.00$ (200.00)$ ‐4.35% 6130 Payroll Taxes 20,000.00$ 20,000.00$ ‐$ 0.00% 6140 Insurance Benefits 31,500.00$ 37,500.00$ 6,000.00$ 19.05% Total Payroll Expenses 291,400.00$ 281,000.00$ (10,400.00)$ ‐3.57% Administrative and General Expenses 6200 Auditing and Account 21,000.00$ 21,000.00$ ‐$ 0.00% 6210 Building Rental 42,350.00$ 42,950.00$ 600.00$ 1.42% 6210 Building Maintenance 1,000.00$ 1,000.00$ ‐$ 0.00% 6211 Building Utilities 2,000.00$ 2,000.00$ ‐$ 0.00% 6212 Cleaning Services 2,580.00$ 2,580.00$ ‐$ 0.00% 6213 Security Monitoring 275.00$ 275.00$ ‐$ 0.00% 6220 Computer Support/Service 6,000.00$ 4,900.00$ (1,100.00)$ ‐18.33% 6230 Consulting 500.00$ 500.00$ ‐$ 0.00% 6240 Dues and Subscriptions 1,762.80$ 1,582.80$ (180.00)$ ‐10.21% 6245 Depreciation Expense 9,420.00$ 13,500.00$ 4,080.00$ 43.31% 6250 Office Equip Lease & Repair 4,326.16$ 4,899.00$ 572.84$ 13.24% 6260 Insurance Premiums 5,123.00$ 6,595.00$ 1,472.00$ 28.73% 6270 Minor Office Furniture 500.00$ 500.00$ ‐$ 0.00% 6280 Misc. Expenses 3,540.00$ 3,640.00$ 100.00$ 2.82% 6290 Parking Fee 1,440.00$ (1,440.00)$ ‐100.00% 6300 Office Supplies 2,000.00$ 2,200.00$ 200.00$ 10.00% 6310 Printing and Binding 2,500.00$ 2,500.00$ ‐$ 0.00% 6320 Telephone and Fax 9,000.00$ 9,000.00$ ‐$ 0.00% 6330 Training and Education 2,240.00$ 2,240.00$ ‐$ 0.00% Total Administrative and General Expense 117,556.96$ 121,861.80$ 4,304.84$ 3.53% Marketing Expenses 6285 Promotional Items to sell 55,000.00$ 55,000.00$ ‐$ 0.00% 6340 Travel Expenses 13,144.58$ 12,900.00$ (244.58)$ ‐1.86% 6360 MSP Tour Expenses 16,000.00$ 11,000.00$ (5,000.00)$ ‐31.25% 6361 MSP Salaries and Wages 167,700.00$ 258,500.00$ 90,800.00$ 54.14% 6362 MSP Digital Marketing 20,074.16$ 23,682.00$ 3,607.84$ 17.97% 6363 MSP Credit Card Fees 35,000.00$ 35,000.00$ ‐$ 0.00% 6364 MSP Janitorial Services 3,000.00$ 3,960.00$ 960.00$ 32.00% 6365 MSP Tour Insurance 3,500.00$ 2,500.00$ (1,000.00)$ ‐28.57% 6367 MSP Advertising 24,864.50$ 25,644.00$ 779.50$ 3.13% 6368 MSP Utilites and Lawn service 16,950.00$ 16,950.00$ ‐$ 0.00% 6369 MSP Capital Improvements 25,000.00$ 15,000.00$ (10,000.00)$ ‐40.00% 6370 MSP Museum 2,000.00$ 2,000.00$ ‐$ 0.00% 6400 Graphic Design 6,000.00$ 5,000.00$ (1,000.00)$ ‐16.67% 6410 Outdoor Advertising 43,900.00$ 26,400.00$ (17,500.00)$ ‐39.86% 6420 Wayfinding Signage ‐$ 6430 Brochures/Printed Material 9,000.00$ 9,000.00$ ‐$ 0.00% 6440 Postage and Freight 9,000.00$ 9,000.00$ ‐$ 0.00% 6461 Marketing Memberships 5,515.00$ 5,835.00$ 320.00$ 5.80% 6470 Print Advertising 34,633.75$ 27,051.00$ (7,582.75)$ ‐21.89% 6490 Marketing Research 5,000.00$ 5,000.00$ ‐$ 0.00% 6500 Promotion/Publicity 5,400.00$ 5,400.00$ ‐$ 0.00% 6510 Sponsorship 33,000.00$ 42,000.00$ 9,000.00$ 27.27% 6520 Tradeshow Fees 11,085.00$ 9,848.00$ (1,237.00)$ ‐11.16% 6530 Familiarization tour expense 6,000.00$ 6,000.00$ ‐$ 0.00% 6540 Marketing Promo 4,970.00$ 5,000.00$ 30.00$ 0.60% 6545 Public Relations 10,000.00$ 5,000.00$ (5,000.00)$ ‐50.00% 6550 Digital Marketing 24,546.66$ 27,887.00$ 3,340.34$ 13.61% 6560 Local Promotions 5,000.00$ 5,000.00$ ‐$ 0.00% 6620 Special Events 6,600.00$ 5,000.00$ (1,600.00)$ ‐24.24% 6630 Athletic Events Exp ‐ CVB 18,105.00$ 18,705.00$ 600.00$ 3.31% 6640 Athletic Events Committee Exp 16,824.00$ 19,969.00$ 3,145.00$ 18.69% Total Marketing 636,812.65$ 699,231.00$ 62,418.35$ 9.80% Contracted Services 6610 Contracted Services & Exp ‐$ Total Contracted Services ‐$ Capital Expenses 6710 Computer Hardware 2,000.00$ 2,000.00$ ‐$ 0.00% Total Capital Expenses 2,000.00$ 2,000.00$ $0.00 0.00% 6800 MSP reserve for Preservation projects 105,709.68$ 89,680.20$ ‐$16,029.48 ‐17.87% Total Bureau Expenses 1,153,479.29$ 1,193,773.00$ $40,293.71 3.38% BUILD AMERICA BONDS AND CROSSOVER REFUNDING Build America Bonds are taxable municipal bonds that carry special tax credits and federal subsidies for either the bond issuer or the bondholder. The purpose of Build America Bonds, commonly referred to as BABs, was to reduce the cost of borrowing for state and local government issuers and governmental agencies. The program was only open to new issue capital expenditure bonds issued before January 1, 2011. There are two types of Build America Bonds: "Tax Credit BABs" and "Direct Payment BABs." The Direct Payment bonds provide a subsidy of 35% of the interest, paid to the issuer. The Tax Credit bonds provides a refundable tax credit directly to the bondholders. While the bondholder is the recipient of the tax credit through Tax Credit bond, and the bond issuer is the recipient of the tax subsidy through Direct Payment bond, both options reduce the cost of borrowing for the issuer in comparison to traditional taxable corporate bonds; in many cases, it is more cost effective than issuing traditional tax‐exempt bonds. The City of Jefferson’s Build American Bonds are Direct Payment. We were to get a 35% federal subsidy on these bonds. However, the subsidy has been cut due to federal sequestration to roughly a 28% subsidy. Governmental entities considering an advance refunding of their Build America Bonds can achieve a better economic result by using a crossover refunding. A crossover refunding is similar to a net cash refunding, except that the escrow will pay interest on the new refunding bonds until the call date (known as the Crossover Date). In order to maintain the federal subsidy on Build America Bonds through their optional redemption date, any advance refunding much be completed as a crossover refunding. IMPORTANT UPDATE: The Proposed Tax Cuts and Jobs Act H.R. 1 just introduced in the U.S. House on November 2, 2017, would drastically curtail tax‐exempt financing used by States and municipalities. It also severely restricts advance refunding bonds. The Tax Bill’s changes would apply to all tax‐exempt debt issued after 2017, and therefore potentially impacts refinancing or remarketing of existing tax‐exempt debt as well as financings for new projects. These proposals were unexpected by the municipal finance community and are inconsistent with assurances previous provided by congressional leadership. The legislation is on an extremely accelerated time schedule with a final vote scheduled to occur prior to Thanksgiving. CITY OF JEFFERSON CITY,MISSOURI SEWERAGE SYSTEM REFUNDING REVENUE BONDS SERIES 2018 Calendar of Events September 28,2017 DATE EVENT December 4,2017 Resolution authorizing Piper Jaffray as Financial Advisor and Gilmore &Bell as Bond Counsel to prepare a Preliminary Official Statement (POS) and a Noticeof Bond Sale (NOS) December 19,2017 Distribute near complete drafts of Preliminary Official Statement (POS) and Bond Documents January 2,2018 Resolution approving the POS and NOS in substantially final form and authorizing the competitive sale of the Bonds January 3,2018 Comments due on drafts of POS and Bond Documents January 8,2018 Distribute revised drafts of POS and Bond Documents January 9,2018 Send POS and Credit Package to Standard &Poor's January 16,2018 First reading of Bond Ordinance January 17,2018 Rating Agency call January 23,2018 Receive bond rating February 5,2018 Bond Sale (11:00 a.m.CDT) Council Meeting Accept lowest and best bid for Bonds Approve Final reading of Bond Ordinance February 9,2018 Prepare Final Official Statement Prepare and Distribute Closing Memorandum February 27,2018 Bond Closing Piperjaffray*