Okaloosa County BOCC — April 28, 2016 — Agenda Packet — reading text

PAGE NUMBER: 22 DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11 TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 591001 BT−GENERAL FUND 6 /16 03/01/16 19 BUDGET−4 74,059.00 MARCH 2016 TOTAL BT−GENERAL FUND .00 74,059.00 .00 591201 BT−DEBT SERVICE FUND 6 /16 03/01/16 19 BUDGET−4 27,224.00 MARCH 2016 TOTAL BT−DEBT SERVICE FUND .00 27,224.00 .00 591301 BT−CAPITAL OUTLAY 6 /16 03/01/16 19 BUDGET−4 1,250.00 MARCH 2016 TOTAL BT−CAPITAL OUTLAY .00 1,250.00 .00 TOTAL 1ST TDT−BEACHES & PARKS −67,000.00 158,676.98 .00 Packet Pg. 141 RUN DATE 04/19/2016 TIME 11:46:10 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  SUNGARD PENTAMATION, INC. PAGE NUMBER: 23 DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11 TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1176 − SPECIAL ASSESSMENT ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549005 COMMISSIONS−TAX COLLECTOR 6 /16 03/11/16 24 000004 BENJAMIN F ANDER 212.19 2/16 TX ACH TOTAL COMMISSIONS−TAX COLLECTOR .00 212.19 .00 591201 BT−DEBT SERVICE FUND 6 /16 03/01/16 19 BUDGET−4 28,675.00 MARCH 2016 TOTAL BT−DEBT SERVICE FUND .00 28,675.00 .00 TOTAL SPECIAL ASSESSMENT .00 28,887.19 .00 Packet Pg. 142 RUN DATE 04/19/2016 TIME 11:46:10 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  SUNGARD PENTAMATION, INC. PAGE NUMBER: 24 DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11 TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1179 − 4TH TDT−C.C. CAPITAL ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549520 ADMINISTRATIVE CHARGES 6 /16 03/30/16 19 TDCSPLIT 2,615.48 REALLOCATE FEB 2016 TAX 6 /16 04/01/16 19 REVSPLIT −2,615.48 REVRSE TDCSPLT−WRONG PERD TOTAL ADMINISTRATIVE CHARGES .00 .00 .00 563790 OTHER IMPROVEMENTS 6 /16 03/03/16 21 V1603801 008408 GGI LLC D/B/A GE 13,228.24 .00 TO4 ROOF LEAK REMEDI 6 /16 03/10/16 21 V1603959 008408 GGI LLC D/B/A GE 1,020.00 .00 TO4 ROOF LEAK REMEDI 6 /16 03/17/16 21 V1605088 008408 GGI LLC D/B/A GE 540.00 .00 TO4 ROOF LEAK REMEDI TOTAL OTHER IMPROVEMENTS .00 14,788.24 .00 TOTAL 4TH TDT−C.C. CAPITAL .00 14,788.24 .00 Packet Pg. 143 RUN DATE 04/19/2016 TIME 11:46:10 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  SUNGARD PENTAMATION, INC. PAGE NUMBER: 25 DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11 TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 711542 − FDOT URBAN CORR 15 (O) ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534410 CS−PUBLIC TRANSPORTATION 6 /16 03/03/16 21 V1603836 21600008 MARUTI FLEET & M 29,339.42 .00 1/18/16 − 1/31/16 6 /16 03/10/16 21 V1603981 21600008 MARUTI FLEET & M 30,756.16 .00 2/1/16−2/29/16 TOTAL CS−PUBLIC TRANSPORTATION .00 60,095.58 .00 TOTAL FDOT URBAN CORR 15 (O) .00 60,095.58 .00 Packet Pg. 144 RUN DATE 04/19/2016 TIME 11:46:10 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  SUNGARD PENTAMATION, INC. PAGE NUMBER: 26 DATE: 04/19/2016 OKALOOSA COUNTY BOCC AUDIT11 TIME: 11:46:08 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’16’ and transact.period=’6’ and transact.fund=’104’ ACCOUNTING PERIOD: 7/16 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 711673 − FFWCC MARINE REEFS (C) ACCOUNT DATE T/C ENCUMBRANC REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 563753 ARTIFICIAL REEF 6 /16 03/03/16 13 67,000.00 BT−16−18 6 /16 03/03/16 11 60,000.00 BA−#85 TOTAL ARTIFICIAL REEF 127,000.00 .00 .00 TOTAL FFWCC MARINE REEFS (C) 127,000.00 .00 .00 TOTAL TOURIST DEVELOPMENT FUND 60,000.00 878,020.71 −51,114.68 TOTAL REPORT 60,000.00 878,020.71 −51,114.68 Packet Pg. 145 RUN DATE 04/19/2016 TIME 11:46:10 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING 3.n.a Attachment: III. n. Expenditure Transactions (5548 : Expenditure Transaction Report)  3.o Tourist Development Council Meeting: 04/28/16 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Information Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 5549) DOC ID: 5549 Reconciliation of Promotional Reserves Updated: 4/25/2016 2:18 PM by Aida Wilkinson Page 1 Packet Pg. 146  3.o.a TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: April 28, 2016 TO: Tourist Development Council FROM: Ed Schroeder, Tourist Development Department Director Charlotte Dunworth, Finance, Administration, & Compliance Manager SUBJECT: Monthly Reconciliation of Promotional Reserve Funds STATEMENT OF ISSUE: Providing the monthly reconciliation of the use of promotional reserve funds. Attachment: III. o. Promo Reserves (5549 : Reconciliation of Promotional Reserves) BACKGROUND: Per the adopted FY16 Strategic Marketing Plan: “Promotional Reserve funds may be appropriated in accordance with County approval authority and with concurrence of the TDC Chairman. A monthly reconciliation of the use of promotional