Okaloosa County BOCC — April 24, 2014 — III.b. Financial Update — reading text

Financial Update April 2014 FY 2013-14 AMENDED BUDGET: $36,713,969 Financial data as of 04/18/14 The adopted budget of $33,967,750 has been amended during the year to record BP grant funds for marketing, FDEP grant funds for Okaloosa Island dune walkovers, FDOT grant funds for seasonal transit service on Okaloosa Island and Destin, and reserve carryforwards. REVENUE ANALYSIS Reserves are the largest component of budgeted revenues because the budget reflects anticipated revenues as well as current cash on hand. Reserves/cash on hand is a budget “placeholder” and represents the accumulation of unspent prior year bed tax dollars; it’s not an actual source of incoming revenues for the year. Tourist development taxes comprise the largest part of actual annual revenue collections. Each percentage is anticipated to generate $2.4M, for a total of $12M in bed taxes. Lodging establishments remit bed tax collections to the tax collector by the 20th of each month for the preceding month. The tax collector reconciles and remits the revenues to the County by the 10th of the following month. Due to the timing of this process, the $2.0M in actual revenue only represents collections through February. Based on year-to-date receipts, tourist development tax revenues are on track to generate $13.4M this year, which is $1.4M or 11.5% more than budgeted. April 18, 2014 Tourist Development Department, Okaloosa County, FL Financial Update – April 2014 EXPENSE ANALYSIS Reserves are the largest component of budgeted expenses because budgeted expenses must equal budgeted revenues. The budgeted use/drawdown of reserves is reflected in the amount by which budgeted reserves expenses are less than budgeted reserves revenues: $21M reserve revenue – $15M reserve expenses = $6M budgeted use/drawdown for capital projects. Each percentage of the bed tax is required to be spent in a certain way per County Ordinance. April 18, 2014 Tourist Development Department, Okaloosa County, FL 2 of 6 Financial Update – April 2014 EXPENSES BY LEVEL OF TOURIST DEVELOPMENT TAX RESTRICTION FIRST PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive)  beach park facilities or beach improvements  beach & waterway maintenance, renourishment, restoration, enhancement, access  tourist destination facilities SECOND PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive)  visitor services, brochure distribution, communication and research  tourist bureau administration  lifeguard services and protection April 18, 2014 Tourist Development Department, Okaloosa County, FL 3 of 6 Financial Update – April 2014 THIRD PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive)  operations, maintenance, improvement of Visitor Welcome or Information Centers, Convention Center, and Tourist Destination Facilities  promotion of the Convention Center and Tourist Destination Facilities FOURTH PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive)  expansion, renovation, reconstruction of the convention center and outdoor venues April 18, 2014 Tourist Development Department, Okaloosa County, FL 4 of 6 Financial Update – April 2014 FIFTH PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive)  tourism promotion STRATEGIC MARKETING PLAN RevPAR Revenue per available room (RevPAR) is a widely used performance metric in the lodging industry. RevPar is a measurement for a point in time, so it is most appropriately used when comparing equivalent time periods (e.g. February 2014 to February 2013). However, since year-to-year comparison is not possible until twelve months of data are obtained, it is being presented here to establish benchmarks. RevPar = gross monthly receipts divided by days in month divided by number of units (data taken from Tax Collector’s monthly reports) April 18, 2014 Tourist Development Department, Okaloosa County, FL 5 of 6 Financial Update – April 2014 EXPENDITURE TRANSACTION ANALYSIS Pursuant to Florida Statutes 125.0104(4)(e), “The council shall continuously review expenditures… Expenditures which the council believes to be unauthorized shall be reported to the county governing board and the Department of Revenue”. One of the most comprehensive reports from the County’s accounting system is the Expenditure Transaction Analysis, which lists the fiscal period, date, transaction type, check number, vendor number, vendor name, dollar amount, and description for each tourist development tax expenditure transaction. This report is being provided to assist the TDC in identifying possibly unauthorized expenditures. The following pages provide transaction detail for the month of March 2014. April 18, 2014 Tourist Development Department, Okaloosa County, FL 6 of 6 SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 04/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 14:06:12 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534003 CS−CONSULTING 6 /14 03/06/14 21 V1403706 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING .00 3,166.67 .00 534018 CS−CHAMBER OF COMMERCE 6 /14 03/06/14 21 3817 002981 FWB CHAMBER OF C −5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 E1403670 002981 FWB CHAMBER OF C 5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 1403658 002241 DESTIN AREA CHAM 5,000.00 .00 OCT−DEC2013 6 /14 03/06/14 21 3817 002981 FWB CHAMBER OF C 5,000.00 .00 OCT−DEC2013 6 /14 03/27/14 21 1404261 002241 DESTIN AREA CHAM 5,000.00 .00 JUL13−SEP13 TOTAL CS−CHAMBER OF COMMERCE .00 15,000.00 .00 534500 CS−PERSONNEL 6 /14 03/06/14 21 1403694 21101150 LANDRUM STAFFING 904.40 .00 NIXON 2/15/14 6 /14 03/06/14 21 1403694 21101150 LANDRUM STAFFING 904.40 .00 NIXON 2/22/14 6 /14 03/20/14 21 1404021 21101150 LANDRUM STAFFING 1,006.16 .00 NIXON 3/1/14 6 /14 03/27/14 21 1404292 21101150 LANDRUM STAFFING 972.24 .00 NIXON 3/8/14 TOTAL CS−PERSONNEL .00 3,787.20 .00 545990 INSURANCE−OTHER 6 /14 03/03/14 19 BUDGET−5 62.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 62.00 .00 547002 PRINTING & BINDING 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 115.00 .00 SQ PRINTPRO LLC 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 115.00 .00 SQ PRINTPRO LLC TOTAL PRINTING & BINDING .00 230.00 .00 548001 PROMOTIONAL ACTIVITIES 6 /14 03/25/14 17 21401020−01 21400180 PARKSBYNATURE NE 15,000.00 12 MONTH AGREEMENT FOR PA TOTAL PROMOTIONAL ACTIVITIES .00 .00 15,000.00 548020 WEBSITE DEV & MAINTENANCE 6 /14 03/07/14 17 21400909−01 20900370 REVIVE MEDIA SER 3,051.00 WEBSITE/DATABASE SEO & MA 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 169.83 .00 NETWORK SOLUTIONS, LLC 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 269.84 .00 NETWORK SOLUTIONS, LLC 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 559.80 .00 NETWORK SOLUTIONS, LLC TOTAL WEBSITE DEV & MAINTENANCE .00 999.47 3,051.00 548040 PUBLIC RELATIONS 6 /14 03/25/14 21 V2140138 014799 BANK OF AMERICA 495.00 .00 PR NEWSWIRE ASSOCIATION TOTAL PUBLIC RELATIONS .00 495.00 .00 548042 FALL CAMPAIGN 6 /14 03/05/14 21 1403721 21300295 PETER A MAYER AD 431.25 .00 TO40MEDIA TOTAL FALL CAMPAIGN .00 431.25 .00 RUN DATE 04/18/2014 TIME 14:06:12 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 04/18/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 14:06:12 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548043 CHRISTMAS CAMPAIGN 548043 CHRISTMAS CAMPAIGN