Okaloosa County BOCC — August 28, 2014

Tourist Development Council 1540 Miracle Strip Parkway Fort Walton Beach, FL 32548 Regular Meeting http://www.okaloosafl.com ~ Agenda ~ Thursday, August 28, 2014 2:00 PM Emerald Coast Convention Center Council Members & Staff Dale E. Peterson Chairman Thomas Rice Vice-Chairman Thom Gossom Owner, Best Gurl, Inc. - Mktg & Comm. Firm Joe Guidry Manager, Ramada Plaza Beach & RV Resorts Rachel Joyce General Manager, Hampton Inn Martin Owen Regional Sales & Marketing Director, Wyndham Vac Honorable Kelly Windes Commissioner District 5 Honorable Tuffy Dixon City of Destin Representative Honorable Charles Rigdon City of FWB Representative Ed Schroeder Director, Tourist Development Department Lynn Hoshihara TDD Attorney Greg Stewart TDD Attorney Pledge of Allegiance and Welcome (Dale Peterson - Chairman) Public Comments Related to Current Agenda (3 minutes each) Councilmember's Minute I. Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale Peterson) a. Tourist Development Council - Regular Meeting - Jun 26, 2014 2:00 PM II. Director's Update (Ed Schroeder) a. Month End Lodging Reports from Smith Travel Research - June & July b. Film Commission Reports - June & July c. Visitor Center Top 10 States - June & July d. Airport Enplanements & Deplanements - June & July III. Financial Update (Charlotte Dunworth) a. Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June b. Financial Update - August Tourist Development Council Page 1 Printed 8/25/2014 Regular Meeting Agenda August 28, 2014 c. FY15 Budget Update d. Promotional Reserves Update IV. Marketing Update (Kendra Moore-Nixon) a. Visitor Profile Survey (UWF HAAS Center) b. Agency Update V. Sales Update (Ed Schroeder) a. ECCC Sales Marketing Reports b. Group Sales Marketing Reports VI. New Business (Dale Peterson) a. Destin Seafood Festival Request for Funding (Kathy & Mike Eller) VII. Next TDC Meeting (Dale Peterson) a. Thursday September 18, 2:00 p.m. Emerald Coast Convention Center (Tentative) VIII. Public Comment (3 minutes each) IX. Adjourn Tourist Development Council Page 2 Printed 8/25/2014  1.a Okaloosa County Tourist Development Department 1540 Miracle Strip Parkway Ft. Walton Beach, FL 32548 Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale Regular Meeting http://www.okaloosafl.com ~ Minutes ~ Thursday, June 26, 2014 2:00 PM Emerald Coast Convention Center Council Members & Staff Attendee Name Title Status Arrived Departed Chairman, Dale E. Peterson Present - - Dale E. Peterson Vacations Vice-Chairman, Present Thomas Rice - - Magnolia Grill Rachel Joyce Hampton Inn FWB Present - - Daniel Empson Harry T’s Restaurant Resigned - - Thom Gossom Best Gurl, Inc. Present - - Joe Guidry Ramada Plaza Resort Present - - Tuffy Dixon Destin Councilman Present - - Charles Rigdon FWB Councilman Present - - Kelly Windes Commissioner District 5 Present - - Ed Schroeder TDD Director Present - - Lynn Hoshihara TDD Attorney Present - - Chairman Dale Peterson called the meeting to order at 2:00 p.m. with the Pledge of Allegiance. Public Comments Related to Current Agenda The chairman opened the floor to public comment related to the current agenda without response. Mr. Peterson requested the first agenda item in “New Business” - Okaloosa County Sheriff’s Office request for TDC Funding - be brought before the Council before the “Director’s Update.” Councilmember’s Minute (Dale Peterson – Chairman) Joe Guidry thanked everyone for going in the right direction with promoting tourism in Okaloosa County and commented they are having the best year in history. I. Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale Peterson) a. May 29, 2014 TDC Meeting Minutes Okaloosa County Tourist Development Department Page 1 of 6 June 26, 2014 Packet Pg. 3  1.a Note: Mr. Peterson added the court reporter’s version of last month’s meeting minutes was too lengthy as well as expensive, so going forward the minutes will revert to the Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale normal process. Motion to Approve the May 29, 2014 TDC Meeting Minutes RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Rice SECONDER: Guidry AYES: Gossom, Rigdon, Windes, Dixon, Joyce, Peterson b. June 16, 2014 TDC Selection Committee Meeting Minutes Mr. Peterson summarized the meeting process that recommended to the Board of County Commissioners the selection of Martin Owen as the Tourist Development Council member replacement for Dan Empson. Motion to Approve the June 16, 2014 TDC Selection Committee Meeting Minutes RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Rice SECONDER: Guidry AYES: Gossom, Rigdon, Windes, Dixon, Joyce, Peterson Item VIII-a. Discussion – New Business Mr. Peterson asked that an item in the New Business section relating to the Okaloosa County Sheriff’s Office Request for TDC Funding be discussed at this time. a. Sheriff Larry Ashley requested $350K from TDC funds for additional beach control and marine control officers for services pertaining to the safety of tourists. b. Mr. Peterson asked for public comment related to the Okaloosa County Sheriff’s Office request for TDC funds: Bruce Craul / Chief Operating Officer of Harborwalk Hospitality & VP - Emerald Coast Florida Restaurant & Lodging Association stated his opposition to TDC funding of this request. Dan Martin / Sales & Marketing Director - Pelican Beach Resort – Destin stated his opposition to using TDC funds for this request. John Hall / Tourist Industry Business Consultant stated his opposition to using TDC funds for any municipal purposes (Fire Dept., Police, etc.) and requested the money be used solely for promoting tourism. Lino Maldonado / VP – ResortQuest by Wyndham stated his opposition to using TDC funds for this request and offered recommendations for better use of these funds. Okaloosa County Tourist Development Department Page 2 of 6 June 26, 2014 Packet Pg. 4  1.a Martin Owen / Regional Marketing Director - ResortQuest by Wyndham stated his opposition to using TDC funds for this request and commented these funds should only Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale be used for commercial needs to promote tourism. c. Mr. Peterson asked for comments from council members related to the Okaloosa County Sheriff’s Office request for TDC funds. Comments from the Council members related to this matter included concerns about cutting other projects from the budget, limits to spending for promoting tourism, insuring security to tourists, and clarification of TDC member responsibilities. Motion to Oppose the Okaloosa County Sheriff’s Office Request for $350K of TDC Funds for Additional Beach and Marine Control Officers in Destin RESULT: MOTION APPROVED [6 – 2] MOVER: Joyce SECONDER: Rice AYES: Guidry, Rigdon, Dixon, Peterson NAYES: Gossom, Windes II. Director’s Update (Ed Schroeder) a. May Month End Lodging Reports from Smith Travel Research b. May Film Commission Monthly Report c. Destin Chamber of Commerce Resolution – Welcome Signs d. Introduction of New TDD Marketing Manager – Kendra Moore e. Visitors Guide Selection Committee – “Life’s A Beach” Negotiations Motion to Approve the TDD Visitors Guide Selection Committee’s Choice to Enter into Negotiations with “Life’s A Beach” to Produce the 2015 TDD Visitors Guide RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Dixon SECONDER: Windes AYES: Gossom, Guidry, Rigdon, Rice, Peterson, Joyce III. Financial Update (Charlotte Dunworth) a. April Month End Tax Revenue Report from the Okaloosa County Tax Collector b. June Financial Update Motion to Approve the April Month End Financial Report As Provided RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Rice SECONDER: Rigdon AYES: Gossom, Guidry, Windes, Dixon, Joyce, Peterson Okaloosa County Tourist Development Department Page 3 of 6 June 26, 2014 Packet Pg. 5  1.a IV. Marketing Update (Kendra Moore) a. Special Events Funding – Quarterly Update Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale b. Online Advertising Results, Website & Social Media Tutorial, TV Ads Presentation, Press Kits (Michelle Clark) V. Sales Team Update (Ed Schroeder) a. Sales & Marketing Reports b. Local Events Calendar c. Convention Center Events Calendar VI. Beaches Update (Jim Trifilio) a. Partnership with Eglin AFB for Construction of Artificial Reefs Project Presentation Mr. Trifilio commented on the funding and opportunities to partner with Eglin AFB and surrounding counties in helping to construct artificial reefs. VII. Old Business (Dale Peterson) No Report VIII. New Business (Dale Peterson) a. Okaloosa County Sheriff’s Office Request for TDC Funding Mr. Peterson asked for this item to be addressed earlier in the meeting, and Sheriff Ashley’s request for funding was denied. b. TDT Ordinance Amendment – Aquarium & Museum Funding (Ed Schroeder & Charlotte Dunworth) Mr. Patrick Berry, Gulfarium General Manager, relayed his concerns regarding the language pertaining to the funding of publicly owned and operated not-for-profit organizations only, penalizing the for-profit Gulfarium. The Gulfarium helps to promote tourism through entertainment for all ages. He asked for information regarding application for TDC funding if the process is changed. Ms. Hoshihara stated F.S. 125.0104 includes the not-for-profit organizational funding stipulation. Further discussion between the TDC Council and the TDD continued regarding who and what is included in funding opportunities for public aquariums and museums in the tourist tax district, currently the Destin History & Fishing Museum and the Fort Walton Beach Indian Cultural Center Museum. Okaloosa County Tourist Development Department Page 4 of 6 June 26, 2014 Packet Pg. 6  1.a Motion to Recommend the BOCC Approve the TDT Ordinance Amendment to Include Aquarium & Museum Funding as Provided Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Guidry SECONDER: Rice AYES: Gossom, Rigdon, Windes, Peterson, Dixon, Joyce c. Interlocal Agreement for Beach Safety & Lifeguard Services Renewal (Ed Schroeder) Motion to Recommend Destin Fire Control District Contract Renewal Approval of the Interlocal Agreement for Beach Safety & Lifeguard Services in the next Fiscal Year RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Dixon SECONDER: Rice AYES: Gossom, Guidry, Rigdon, Windes, Peterson, Joyce Motion to Recommend the Equitable Reallocation of Destin and Okaloosa Island Beach Safety & Lifeguard Services Funding for Presentation to the BOCC by County Staff RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Windes SECONDER: Dixon AYES: Gossom, Guidry, Rigdon, Peterson, Rice, Joyce d. Destin Chamber of Commerce Contract Renewal (Ed Schroeder) e. Fort Walton Beach Chamber of Commerce Contract Renewal (Ed Schroeder) f. Cable Television Promotional Opportunities (Ed Schroeder) Motion to Approve a Budget Not To Exceed $15K for Funding of the Cable Television Promotional Opportunities As Presented RESULT: MOTION APPROVED [7-1] MOVER: Rigdon SECONDER: Rice AYES: Guidry, Windes, Peterson, Dixon, Joyce NAYES: Gossom Mr. Schroeder said the fishing show pilot would be branded as our show, and would include sweepstakes for families to win a trip to the Emerald Coast each month. The winning families would be filmed while here. The show would feature a local restaurant serving the catch, as well as the family fishing trip aboard the “Reeling Script” boat. Okaloosa County Tourist Development Department Page 5 of 6 June 26, 2014 Packet Pg. 7  1.a Motion to Fund $6,200 of the Sportsman Network TV Pilot as Presented with an Option for the TDC to be the Primary Sponsor Minutes Acceptance: Minutes of Jun 26, 2014 2:00 PM (Consider Okaloosa County Tourist Development Council Meeting Minutes (Dale RESULT: MOTION APPROVED [6-2] MOVER: Windes SECONDER: Rice AYES: Guidry, Rigdon, Dixon, Peterson NAYES: Joyce, Gossom IX. Next TDC Meeting (Dale Peterson) a. Thursday August 28, 2:00 p.m. Emerald Coast Convention Center (Tentative) X. Public Comment (3 minutes each) Rebecca Sherry / Condo Alliance of Okaloosa Island commented on the recommendations for lifeguard and museum funding. XI. Adjourn Chairman Peterson adjourned the meeting at 4:21 p.m. Motion to Adjourn the Meeting at 4:21 p.m. RESULT: MOTION APPROVED [UNANIMOUS] MOVER: Rice SECONDER: Gossom AYES: Guidry, Rigdon, Windes, Peterson, Dixon, Joyce APPROVED: APPROVED: By: By: Name: Dale E. Peterson Name: Ed Schroeder Title: Chairman Title: Director, Tourist Development Dept. Date: Date: Okaloosa County Tourist Development Department Page 6 of 6 June 26, 2014 Packet Pg. 8  2.a Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3200) DOC ID: 3200 Month End Lodging Reports from Smith Travel Research - June & July Updated: 8/22/2014 4:02 PM by Aida Wilkinson Page 1 Packet Pg. 9  2.a.1 ADR 2004-2013 Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Emerald Coast Lodging Average Annual Daily Hotel Lodging Rate 2004 -2013 $150 $130 $117.48 $119.87 $122.13 $117.40 $113.04 $106.63 $109.91 $106.15 $110 $97.00 $89.62 $90 $70 $50 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 10  2.a.1 AVERAGE DAILY RATE Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Room revenue divided by rooms sold, displayed as the average rental rate for a single room. $250.00 Emerald Coast Average Daily Hotel Lodging Rate $230.00 $210.00 $181.81 $190.00 $167.91 $170.00 $126.51 $134.71 $150.00 $130.00 $117.62 $110.00 $83.66 $90.00 $76.69 $70.00 $50.00 $30.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2010 $71.93 $77.30 $110.14 $120.62 $128.40 $157.45 $147.47 $113.41 $102.78 $93.78 $77.43 $73.12 2011 $72.53 $75.67 $113.41 $124.73 $133.68 $163.26 $171.81 $128.14 $108.94 $102.81 $82.93 $78.59 2012 $74.09 $78.97 $122.63 $134.92 $144.46 $175.64 $182.75 $139.44 $112.62 $107.88 $84.78 $80.21 2013 $77.21 $80.89 $129.99 $133.54 $145.91 $178.07 $189.08 $142.25 $115.38 $107.60 $86.35 $79.34 2014 $76.69 $83.66 $117.62 $126.51 $134.71 $167.91 $181.81 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 11  OCCUPANCY 2.a.1 Occupancy is a percentage of rooms occupied. Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Emerald Coast Hotel Lodging Occupancy 100% January - December 87.90% 90% 82.70% 80% 73.30% 70% 65.00% 60.70% 60% 50% 46.10% 40% 30% 31.22% 20% 10% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD* 2010 30.20% 40.10% 52.80% 57.10% 53.20% 65.30% 64.70% 48.60% 43.30% 41.60% 32.30% 27.90% 46.43% 2011 28.86% 43.14% 58.10% 59.60% 59.33% 75.38% 80.90% 58.70% 48.93% 46.80% 33.39% 27.61% 52.70% 2012 30.12% 46.41% 64.60% 64.97% 67.65% 80.01% 85.02% 60.26% 49.72% 49.30% 37.42% 29.77% 55.71% 2013 33.10% 46.86% 64.25% 61.50% 68.81% 81.31% 84.02% 63.66% 51.91% 44.31% 36.56% 30.83% 55.65% 2014 31.22% 46.10% 60.70% 65.00% 73.30% 82.70% 87.90% *YTD = Year to Date Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 12  REVPAR 2.a.1 Room revenue divided by rooms available. Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Revenue Per Available Hotel Room $170 $159.88 $138.89 $130 $98.78 $82.28 $90 $71.41 $50 $38.56 $23.94 $10 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2010 $21.72 $30.98 $58.13 $68.87 $68.31 $102.89 $95.44 $55.12 $44.52 $39.00 $24.90 $20.38 2011 $20.93 $32.64 $65.90 $74.34 $79.31 $123.06 $138.92 $75.17 $53.31 $48.16 $27.69 $21.70 2012 $22.32 $29.13 $79.22 $87.65 $97.73 $140.53 $155.37 $84.03 $56.00 $53.14 $31.73 $23.88 2013 $25.56 $37.91 $83.52 $82.13 $100.41 $144.78 $158.86 $90.56 $59.90 $47.68 $31.56 $24.46 2014 $23.94 $38.56 $71.41 $82.28 $98.78 $138.89 $159.88 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 13  2.a.1 ADR 2004-2013 Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Emerald Coast Lodging Average Annual Daily Hotel Lodging Rate 2004 -2013 $150 $130 $117.48 $119.87 $122.13 $117.40 $113.04 $106.63 $109.91 $106.15 $110 $97.00 $89.62 $90 $70 $50 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 14  2.a.1 AVERAGE DAILY RATE Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Room revenue divided by rooms sold, displayed as the average rental rate for a single room. $250.00 Emerald Coast Average Daily Hotel Lodging Rate $230.00 $210.00 $190.00 $167.91 $170.00 $126.51 $134.71 $150.00 $130.00 $117.62 $110.00 $83.66 $90.00 $76.69 $70.00 $50.00 $30.00 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2010 $71.93 $77.30 $110.14 $120.62 $128.40 $157.45 $147.47 $113.41 $102.78 $93.78 $77.43 $73.12 2011 $72.53 $75.67 $113.41 $124.73 $133.68 $163.26 $171.81 $128.14 $108.94 $102.81 $82.93 $78.59 2012 $74.09 $78.97 $122.63 $134.92 $144.46 $175.64 $182.75 $139.44 $112.62 $107.88 $84.78 $80.21 2013 $77.21 $80.89 $129.99 $133.54 $145.91 $178.07 $189.08 $142.25 $115.38 $107.60 $86.35 $79.34 2014 $76.69 $83.66 $117.62 $126.51 $134.71 $167.91 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 15  OCCUPANCY 2.a.1 Occupancy is a percentage of rooms occupied. Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Emerald Coast Hotel Lodging Occupancy 100% January - December 90% 82.70% 80% 73.30% 70% 65.00% 60.70% 60% 50% 46.10% 40% 30% 31.22% 20% 10% Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD* 2010 30.20% 40.10% 52.80% 57.10% 53.20% 65.30% 64.70% 48.60% 43.30% 41.60% 32.30% 27.90% 46.43% 2011 28.86% 43.14% 58.10% 59.60% 59.33% 75.38% 80.90% 58.70% 48.93% 46.80% 33.39% 27.61% 52.70% 2012 30.12% 46.41% 64.60% 64.97% 67.65% 80.01% 85.02% 60.26% 49.72% 49.30% 37.42% 29.77% 55.71% 2013 33.10% 46.86% 64.25% 61.50% 68.81% 81.31% 84.02% 63.66% 51.91% 44.31% 36.56% 30.83% 55.65% 2014 31.22% 46.10% 60.70% 65.00% 73.30% 82.70% *YTD = Year to Date Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 16  REVPAR 2.a.1 Room revenue divided by rooms available. Attachment: II.a. STR (3200 : Month End Lodging Reports from Smith Travel Research - Revenue Per Available Hotel Room $170 $138.89 $130 $98.78 $82.28 $90 $71.41 $50 $38.56 $23.94 $10 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2010 $21.72 $30.98 $58.13 $68.87 $68.31 $102.89 $95.44 $55.12 $44.52 $39.00 $24.90 $20.38 2011 $20.93 $32.64 $65.90 $74.34 $79.31 $123.06 $138.92 $75.17 $53.31 $48.16 $27.69 $21.70 2012 $22.32 $29.13 $79.22 $87.65 $97.73 $140.53 $155.37 $84.03 $56.00 $53.14 $31.73 $23.88 2013 $25.56 $37.91 $83.52 $82.13 $100.41 $144.78 $158.86 $90.56 $59.90 $47.68 $31.56 $24.46 2014 $23.94 $38.56 $71.41 $82.28 $98.78 $138.89 Source: Smith Travel Research, Inc. Republication or Other Re-Use of this Data without the express written permission of STR is strictly prohibited. Packet Pg. 17  2.b Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3201) DOC ID: 3201 Film Commission Reports - June & July Updated: 8/22/2014 4:07 PM by Aida Wilkinson Page 1 Packet Pg. 18  2.b.1 July 2014 Film Commission Report July Leads: 19 E. J. Dupre Special Effects Classes begin E.J. Dupre Turning An Actor into a Zombie class July issue S.L.A.V.E magazine issued (E.J. Dupre) Voice Acting taught by Kevin Gaddie Attachment: II.b. Film_Commission & SEO Reports (3201 : Film Commission Reports - June & July) United States Air Force Recruiting Video not yet reported Local production company (Revive Media), local crew, local location Tiny House Nation (back story) $2,000 Local crew, local location Royal Caribbean web series $3,500 Local production company (Color Earth), local crew Grand Opening Destin Commons video $3,000 Local producer (Johnny C Alexander), local location “Yellow Dog” independent feature film $2,000 Local production company (S.B. Video) Economic Con commercial $1,500 Local producer (E.J. Dupre) NHRA shoot $3,000 Local production company (S.B. Video) Gulf Coast Energy Network Synergy Solutions Reality TV Local producer (S.B. Video), local locations $3,000 IBM Partnerworld conference and IBM Impact conference $1,000 Local crew (Lau) Gary Finch Outdoors Fishing Tournament and Event at Dockside Local locations not yet reported Audio trailer for audio book “Dark Numbers” Local talent (K. Gaddie), local production company (Revive) not yet reported Voice over for “Lost Souls” trailer Local talent (K. Gaddie), local production company not yet reported “Too Good For Radio” national podcast Local talent (K. Gaddie), local crew not yet reported Podcast series “Steamboy 3” Local talent (K. Gaddie) not yet reported “Lost Souls” Independent Feature trailed released July 2014 Economic Impact: $ 191,600 (includes adjustments from February, March and April $85,200) Study conducted by the Florida Legislature and released in 2014 shows the monies spent on production has an ROI of 5.6 Packet Pg. 19  2.b.1 June 2014 Film Commission Report June Leads: 12 Film Commissioner attended 2014 Producer’s Guild of America Produced By Conference in Los Angeles (Warner Brothers Studios) Production Services Association (PSA) of Northwest Florida monthly meeting Production Services Association (PSA) held Special Event “Working Show Biz” Attachment: II.b. Film_Commission & SEO Reports (3201 : Film Commission Reports - June & July) Expedia.com FWB/Destin Destination DVD (3 yrs on website) $5,000 Local locations, local vendors, local travel, local accommodations Ft. Walton Medical Center video production (20 episodes/5days) $10,000 Local location, local production company (Revive Media), local crew National Geographic IMAX 3D movie $3,000 Local production company (Revive), local crew (Deckert), local Equipment Fox Sports with Jay Blake background piece $1,500 Local crew “Fantastic Four” and “Jurassic World” feature films $5,000 Extras (Gaddie, Wise +) “Fighting Gracies” Mixed Martial Arts Reality Show $3,000 Local crew (Deckert, Baker, Rakoczy) Royal Caribbean web series not yet reported Local production company (Color Earth), local crew Discovery Channel Canada Daily Planet “Tanked” $3,000 Local production company (SB Video), local crew IBM Partnerworld conference and IBM Impact conference not yet reported Local crew (Lau) Blue Angels Flight Surgeon Documentary $3,000 Local production company (SB Video), local crew Beau Rivage billboard shoot $4,000 Local crew (Rakoczy) Blaze Fest production $2,000 Local production company, local crew, local location “Fudpuckers” promotional video $1,000 Local producer (Johnny C. Alexander) Florida Department of Transportation live stream event $7,000 Local production company (SB Video), local crew (3 crews) with 4 Governors Destin Charity Foundation Wine Auction $15,000 Local production company (SB Video. RJ Murdock), crew, live stream Videos (12-15) for PMI $10,000 Local production company (SB Video, RJ Murdock), local crew not yet reported TDC Tourism Commercial aired “Limo Ride” and “Tanzania: A Journey Within” local films released Album “Masikizinew with New Earth” full length album released June 2014 Economic Impact: $ 406,000 Study conducted by the Florida Legislature and released in 2014 shows the monies spent on production has an ROI of 5.6 Packet Pg. 20  2.b.1 Gail, Below is your June SEO report, which has been streamlined to save your valuable time. We are still tracking all information from previous reports, so if you have any questions please do not hesitate to call your Revive Media SEO team member. Film Emerald Coast’s Keyword Rankings We have put your keyword rankings into a table so they are easier to read. Below are keyword rankings for Attachment: II.b. Film_Commission & SEO Reports (3201 : Film Commission Reports - June & July) the search engines Google, Bing andYahoo. Keyword Phrase Ranking okaloosa county film commission 1 film production fort walton beach 1 film production destin 2 Film Emerald Coast’s Highlights These stats compare June 2014 to June 2013. · The percentage of new users visiting your site on their mobile devices has increased by 373%. · 51% of your total sessions are a result of Google’s Organic results. · The average amount of time visitors spent viewing a specified page or set of pages has increased by 16%. · The top five cities that are visiting your website are: Fort Walton Beach, Atlanta, Pensacola, New Orleans, Crestview, and Destin. This Month’s Goals · florida film production - primary focus · film commission florida - primary focus · gulf coast film production - primary focus · northwest florida film production This month we would like to expand content and target the primary keyword on your Home page. This will help with the page rank and increase the return traffic from visitors. Our goal for your site is to attract new potential visitors to your site and convert them to become returning visitors to your business. If you have any questions, please do not hesitate to call the Revive team. Your SEO Team Member Revive Media Services revivemediaservices.com 850-362-0001 Packet Pg. 21  2.b.1 Gail, I hope you had a great trip to Tribeca at the end of last month! Below is your May SEO report, which has been streamlined to save your valuable time. We are still tracking all information from previous reports, so if you have any questions please do not hesitate to call your Revive Media SEO team member. Attachment: II.b. Film_Commission & SEO Reports (3201 : Film Commission Reports - June & July) Film Emerald Coast’s Keyword Rankings We have put your keyword rankings into a table so they are easier to read. Below are keyword rankings for the search engines Google, Bing and Yahoo. Keyword Phrase Ranking okaloosa county film commission 1 film production destin 2 film production fort walton beach 2 Film Emerald Coast’s Highlights These stats compare May 2014 to May 2013. · 47% of your total sessions are a result of Google’s Organic results. · The average visit duration has increased by 41%. · Your bounce rate has improved by 16%, which means users are navigating to additional pages of your site for more information on your services. · Your top referral is Florida’s Emerald Coast. · The top three pages of your site are (in order of most pageviews and excluding the homepage): Talent Agencies, About Us, and Contact page. · The top five states visiting your site (excluding Florida) are: Georgia, Louisiana, Texas, Alabama, and New York. This Month’s Goals · florida film production - primary focus · film commission florida - primary focus · gulf coast film production - primary focus · northwest florida film production This month we will continue to create News posts that highlight different completed projects from the Emerald Coast as well as your recent trip to the Tribecca Film Festival. We will continue to watch Facebook for different posts that might be interesting and informational for the News feed. We also want to make sure your website is targeting the keyword phrases correctly so we will evaluate the website and make any suggested changes. If you have any questions, please do not hesitate to call the Revive team. Your SEO Team Member Revive Media Services revivemediaservices.com 850-362-0001 Packet Pg. 22  2.c Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3202) DOC ID: 3202 Visitor Center Top 10 States - June & July Updated: 8/22/2014 4:10 PM by Aida Wilkinson Page 1 Packet Pg. 23  2.c.1 WELCOME CENTER TOP 10 STATES/COUNTRIES FOR JULY 2014 Attachment: II.c. WELCOME CENTER (3202 : Visitor Center Top 10 States - June & July) TOTAL VISITORS = 3,051 4.36% IN 133 4.95% GA 151 5.60% KY 171 5.67% LA 173 5.77% MO 176 5.97% FL 182 6.13% OH 187 8.16% TN 249 8.36% AL 255 13.14% TX 401 0 50 100 150 200 250 300 350 400 450 Packet Pg. 24  2.c.1 WELCOME CENTER TOP 10 STATES/COUNTRIES FOR JUNE 2014 Attachment: II.c. WELCOME CENTER (3202 : Visitor Center Top 10 States - June & July) TOTAL VISITORS = 2,482 FL 4.92% 122 IL 5.00% 124 AR 5.24% 130 AL 5.40% 134 GA 5.48% 136 OH 6.77% 168 KY 6.85% 170 TX 8.34% 207 TN 9.39% 233 MO 12.53% 311 0 50 100 150 200 250 300 350 Packet Pg. 25  2.d Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3203) DOC ID: 3203 Airport Enplanements & Deplanements - June & July Updated: 8/22/2014 4:12 PM by Aida Wilkinson Page 1 Packet Pg. 26  2.d.1 Northwest Florida Regional Airport (VPS) Enplanements Airline Breakdown Change Month AMER Delta United USAir TOTALS June Enpl Depl Totals Attachment: II.d. Okaloosa Regional Airport (3203 : Airport Enplanements & Deplanements - June & July) -2.336% January 4,579 11,186 2,580 3,307 21,652 2014 37,568 37,807 75,375 February 5,238 11,943 2,250 3,430 22,861 2013 38,219 38,959 77,178 -2% March 6,117 18,940 3,218 5,551 33,826 April 5,886 17,228 2,634 5,662 31,410 May 7,249 19,761 3,948 6,105 37,063 June 8,745 19,548 4,940 4,521 37,754 July 8,872 18,978 4,895 4,823 37,568 August September October November December TOTALS 46,686 117,584 24,465 33,399 222,134 Deplanements Month AMER Delta United USAir TOTALS January 4,525 11,170 2,638 3,473 21,806 February 5,024 12,154 2,319 3,643 23,140 March 6,066 18,519 3,309 5,809 33,703 April 6,098 17,590 2,690 5,853 32,231 May 7,171 19,292 3,928 6,105 36,496 June 8,947 19,340 5,024 4,814 38,125 July 9,150 18,979 4,834 4,844 37,807 August September October November December TOTALS 46,981 117,044 24,742 34,541 223,308 1. American Eagle Provides non-stop service to Dallas, TX (DFW). (800) 433-7300 2. ASA Connection to Atlanta Service may be provided by Delta, Delta Connection carrier Atlantic Southeast Airlines or Comair. (800) 221-1212 3. Delta Provides nonstop service daily to Cincinnati, OH (CVG) and Atlanta, GA (ATL) 4. Continental Express Jet provides nonstop service to Tampa, FL (TPA) and Houston TX (IAH). (800) 523-3273 5. Northwest Airlines Provides non-stop daily jet service to Memphis, TN. (800) 225-2525 6. US Airways Provides non-stop daily service to Charlotte, NC (CLT). (800) 428-4322 Packet Pg. 27  2.d.1 Northwest Florida Regional Airport (VPS) Enplanements Airline Breakdown Change Enpl Attachment: II.d. Okaloosa Regional Airport (3203 : Airport Enplanements & Deplanements - June & July) Month AMER Delta United USAir TOTALS June Depl Totals -1.190% January 4,579 11,186 2,580 3,307 21,652 2014 37,754 38,125 75,879 February 5,238 11,943 2,250 3,430 22,861 2013 37,212 37,775 74,987 1% March 6,117 18,940 3,218 5,551 33,826 April 5,886 17,228 2,634 5,662 31,410 May 7,249 19,761 3,948 6,105 37,063 June 8,745 19,548 4,940 4,521 37,754 July August September October November December TOTALS 37,814 98,606 19,570 28,576 184,566 Deplanements Month AMER Delta United USAir TOTALS January 4,525 11,170 2,638 3,473 21,806 February 5,024 12,154 2,319 3,643 23,140 March 6,066 18,519 3,309 5,809 33,703 April 6,098 17,590 2,690 5,853 32,231 May 7,171 19,292 3,928 6,105 36,496 June 8,947 19,340 5,024 4,814 38,125 July August September October November December TOTALS 37,831 98,065 19,908 29,697 185,501 1. American Eagle Provides non-stop service to Dallas, TX (DFW). (800) 433-7300 2. ASA Connection to Atlanta Service may be provided by Delta, Delta Connection carrier Atlantic Southeast Airlines or Comair. (800) 221-1212 3. Delta Provides nonstop service daily to Cincinnati, OH (CVG) and Atlanta, GA (ATL) 4. Continental Express Jet provides nonstop service to Tampa, FL (TPA) and Houston TX (IAH). (800) 523-3273 5. Northwest Airlines Provides non-stop daily jet service to Memphis, TN. (800) 225-2525 6. US Airways Provides non-stop daily service to Charlotte, NC (CLT). (800) 428-4322 Packet Pg. 28  3.a Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3204) DOC ID: 3204 Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June Updated: 8/22/2014 4:16 PM by Aida Wilkinson Page 1 Packet Pg. 29  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June) Okaloosa County Tax Collector Tourist Development Tax June Tax Revenue Report Fiscal Year 2013-2014 Benjamin F. Anderson Prepared by: Okaloosa County Tax Collector Joshua Allen Director of Field Services Packet Pg. 30  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Total Historical TDT Collections and Percentage Breakdown FY 2009 - Current % (+/-) % (+/-) % (+/-) Cum (+/-) Month FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 2011-2012 2012-2013 2013-2014 2013-2014 October $478,148.95 $522,443.42 $521,660.33 $598,158.00 14.49% $609,091.44 1.83% $680,330.93 11.70% 11.70% November $206,354.05 $210,704.19 $213,947.00 $239,511.00 11.95% $259,606.95 8.39% $273,038.26 5.17% 9.75% December $203,215.30 $235,157.23 $217,922.30 $289,595.00 32.89% $288,498.30 -0.38% $291,672.28 1.10% 7.59% January $277,999.51 $285,996.44 $256,775.00 $297,124.03 15.71% $298,995.38 0.63% $332,035.87 11.05% 8.30% February $386,604.93 $376,473.90 $365,490.00 $437,614.00 19.73% $395,790.00 -9.56% $430,183.30 8.69% 8.38% March $755,427.84 $727,272.00 $768,790.00 $1,028,053.00 33.72% $1,118,616.08 8.81% $1,009,474.61 -9.76% 1.55% April $792,139.00 $779,028.05 $847,476.00 $987,462.61 16.52% $905,964.12 -8.25% $1,038,269.24 14.60% 4.60% May $986,600.37 $955,032.36 $1,079,025.00 $1,296,974.20 20.20% $1,264,606.99 -2.50% $1,441,156.49 13.96% 6.90% June $2,091,522.22 $1,730,975.65 $2,290,684.30 $2,755,441.00 20.29% $2,797,225.80 1.52% $2,909,098.89 4.00% 5.88% July $2,245,536.10 $1,483,002.44 $2,749,706.99 $2,755,052.00 0.19% $2,897,646.65 5.18% August $1,169,781.00 $756,365.51 $1,225,204.88 $1,421,408.96 16.01% $1,588,763.04 11.77% September $800,409.00 $700,746.00 $1,028,530.00 $1,067,149.50 3.75% $1,098,414.84 2.93% Total $10,393,738.27 $8,763,197.19 $11,565,211.80 $13,173,543.30 13.91% $13,523,219.59 2.65% $8,405,259.87 Amounts for September 2013 through current reported by the Okaloosa County Tax Collector's Office. All amounts prior to September 2013 reported by the Okaloosa County Clerk of Courts. Page 1 Packet Pg. 31  Total TDT Collections in Thousands $300 $600 $900 $0 $1,200 $1,500 $1,800 $2,100 $2,400 $2,700 $3,000 $3,300 598.2 609.1 Oct FY 2012 680.3 239.5 259.6 Nov 273.0 289.6 288.5 Dec 291.7 297.1 299.0 Jan FY 2003 332.0 437.6 395.8 Feb 430.2 FY 12 1,028.1 1,118.6 Mar FY 13 Month Page 2 Page 2 1,009.5 987.5 FY 14 906.0 Apr FY 2012 - 2014 1,038.3 1,297.0 1,264.6 May Total Monthly TDT Collections 1,441.2 2,755.4 2,797.2 Jun 2,909.1 2,755.1 2,897.6 Jul 0.0 1,421.4 1,588.8 Aug 0.0 1,067.1 1,098.4 Sep 0.0 3.a.1 Packet Pg. 32 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Collector - TDT Rental Receipts and Amount Remitted by Rental Type / Tax Area June 2014 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Rental Type Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Condo $37,801,969.45 $907,930.19 $36,894,039.26 $1,844,701.96 $348.47 $4,989.43 $1,550.76 ($8,611.69) $1,842,978.93 $1,787,689.57 $55,289.37 Hotel / Motel $12,224,925.02 $829,832.22 $11,395,092.80 $569,754.64 $0.00 $0.00 ($971.59) $568,783.05 $551,719.56 $17,063.49 Single Family Dwelling $7,466,435.38 $14,933.26 $7,451,502.12 $372,575.11 $1,968.62 $211.99 ($1,777.11) $372,978.61 $361,789.25 $11,189.36 Other $2,509,062.44 $13,023.61 $2,496,038.83 $124,801.94 $0.00 $0.00 ($443.64) $124,358.30 $120,627.55 $3,730.75 Total $60,002,392.29 $1,765,719.28 $58,236,673.01 $2,911,833.65 $348.47 $6,958.05 $1,762.75 ($11,804.03) $2,909,098.89 $2,821,825.92 $87,272.97 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Tax Area Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Destin $40,917,350.49 $547,874.41 $40,369,476.08 $2,018,473.80 $348.47 $2,513.35 $219.17 ($7,896.55) $2,013,658.24 $1,953,248.50 $60,409.75 Okaloosa Island $17,202,478.07 $1,053,761.50 $16,148,716.57 $807,435.83 $4,444.70 $1,543.58 ($3,516.64) $809,907.47 $785,610.24 $24,297.22 Fort Walton Beach $1,882,563.73 $164,083.37 $1,718,480.36 $85,924.02 $0.00 $0.00 ($390.84) $85,533.18 $82,967.18 $2,566.00 Total $60,002,392.29 $1,765,719.28 $58,236,673.01 $2,911,833.65 $348.47 $6,958.05 $1,762.75 ($11,804.03) $2,909,098.89 $2,821,825.92 $87,272.97 Page 3 Packet Pg. 33  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Percentage of Gross Rental, Taxable Rental, and Number of Units by Rental Type June 2014 Gross Rental Taxable Rental Rental Type % % Number of Units % Receipts Receipts Condo $37,801,969.45 63.00% $36,894,039.26 63.35% 6,163 56.80% Hotel / Motel $12,224,925.02 20.37% $11,395,092.80 19.57% 3,174 29.25% Single Family Dwelling $7,466,435.38 12.44% $7,451,502.12 12.80% 617 5.69% Other $2,509,062.44 4.18% $2,496,038.83 4.29% 896 8.26% Total $60,002,392.29 100.00% $58,236,673.01 100.00% 10,850 100.00% Gross Rental by Taxable Rental by Number of Units by Rental Type Rental Type Rental Type Other Other Other 4.18% 4.29% 8.26% Single Single Single Family Family Family Dwelling Dwelling Dwelling 12.44% 12.80% 5.69% Condo Condo Hotel / Condo Hotel / Hotel / 63.35% 56.80% Motel 63.00% Motel Motel 20.37% 19.57% 29.25% Page 4 Packet Pg. 34  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Percentage of Gross Rental, Taxable Rental, and Number of Units by Tax Area June 2014 Gross Rental Taxable Rental Tax Area % % Number of Units % Receipts Receipts Destin $40,917,350.49 68.19% $40,369,476.08 69.32% 6,425 59.22% Okaloosa Island $17,202,478.07 28.67% $16,148,716.57 27.73% 3,556 32.77% Fort Walton Beach $1,882,563.73 3.14% $1,718,480.36 2.95% 869 8.01% Total $60,002,392.29 100.00% $58,236,673.01 100.00% 10,850 100.00% Gross Rental by Taxable Rental by Number of Units by Tax Area Tax Area Tax Area Fort Fort Fort Walton Walton Walton Beach Beach Beach 3.14% 2.95% 8.01% Okaloosa Okaloosa Island Island Okaloosa 28.67% 27.73% Island Destin Destin Destin 32.77% 59.22% 68.19% 69.32% Page 5 Packet Pg. 35  3.a.1 Year to Date Percentage of Gross Rental Receipts by Rental Type / Tax Area FY 2014 YEAR TO DATE Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June) RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Condo $ 8,308,588.62 3,149,452.93 3,326,087.76 4,415,501.80 5,518,014.66 11,749,179.84 12,171,284.49 17,451,703.96 37,801,969.45 $ 103,891,783.51 Hotel / Motel $ 3,348,581.10 1,885,569.12 1,741,863.00 1,891,012.04 2,705,840.91 5,997,349.68 6,755,617.68 8,477,981.92 12,224,925.02 $ 45,028,740.47 Single Family Dwelling $ 1,659,015.03 422,191.52 831,184.74 598,208.19 562,811.81 2,926,211.93 2,509,020.74 3,420,775.22 7,466,435.38 $ 20,395,854.56 Other $ 1,173,994.87 568,409.91 441,243.91 498,587.48 493,781.76 1,050,611.37 1,097,239.28 1,532,255.03 2,509,062.44 $ 9,365,186.05 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ 7,403,309.51 $ 9,280,449.14 $ 21,723,352.82 $ 22,533,162.19 $ 30,882,716.13 $ 60,002,392.29 $ - $ - $ - $ 178,681,564.59 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Destin $ 9,041,836.21 3,128,561.42 4,035,429.68 4,204,816.97 5,396,131.05 14,051,185.46 12,943,687.84 20,893,182.61 40,917,350.49 $ 114,612,181.73 Okaloosa Island $ 4,782,376.77 2,439,165.73 448,250.98 2,673,998.99 3,376,325.34 6,556,599.39 8,327,420.62 8,523,149.95 17,202,478.07 $ 54,329,765.84 Fort Walton Beach $ 665,966.64 457,896.33 1,856,698.75 524,493.55 507,992.75 1,115,567.97 1,262,053.73 1,466,383.57 1,882,563.73 $ 9,739,617.02 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ 7,403,309.51 $ 9,280,449.14 $ 21,723,352.82 $ 22,533,162.19 $ 30,882,716.13 $ 60,002,392.29 $ - $ - $ - $ 178,681,564.59 Year to Date Year to Date Gross Rental by Gross Rental by Rental Type Tax Area Other 5.24% Fort Walton Beach 5.45% Single Family Dwelling 11.41% Okaloosa Island 30.41% Condo 58.14% Destin Hotel / Motel 64.14% 25.20% Page 6 Packet Pg. 36  3.a.1 Year to Date Percentage of Taxable Rental Receipts by Rental Type / Tax Area FY 2014 YEAR TO DATE Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June) RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Condo $ 7,753,638.68 2,767,247.54 2,977,548.25 4,024,762.68 5,139,266.41 10,907,638.94 11,287,364.90 16,724,577.65 36,894,039.26 $ 98,476,084.31 Hotel / Motel $ 3,236,954.32 1,808,528.67 1,683,568.14 1,706,148.98 2,458,408.45 5,506,739.63 5,925,582.76 7,316,394.11 11,395,092.80 $ 41,037,417.86 Single Family Dwelling $ 1,657,382.07 410,716.06 808,135.01 586,909.06 552,954.25 2,855,469.68 2,498,216.69 3,403,084.30 7,451,502.12 $ 20,224,369.24 Other $ 1,005,684.24 500,853.91 368,512.49 364,790.48 485,812.76 965,586.82 1,022,823.28 1,453,388.73 2,496,038.83 $ 8,663,491.54 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ 6,682,611.20 $ 8,636,441.87 $ 20,235,435.07 $ 20,733,987.63 $ 28,897,444.79 $ 58,236,673.01 $ - $ - $ - $ 168,401,362.95 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Destin $ 8,708,099.23 2,912,346.67 3,793,057.43 3,977,389.80 5,153,970.82 13,356,682.21 12,563,643.59 20,476,233.21 40,369,476.08 $ 111,310,899.04 Okaloosa Island $ 4,414,625.83 2,217,756.25 352,210.39 2,359,525.59 3,019,281.25 963,397.41 7,200,528.74 7,229,149.30 16,148,716.57 $ 43,905,191.33 Fort Walton Beach $ 530,934.25 357,243.26 1,692,496.07 345,695.81 463,189.80 5,915,355.45 969,815.30 1,192,062.28 1,718,480.36 $ 13,185,272.58 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ 6,682,611.20 $ 8,636,441.87 $ 20,235,435.07 $ 20,733,987.63 $ 28,897,444.79 $ 58,236,673.01 $ - $ - $ - $ 168,401,362.95 Year to Date Year to Date Taxable Rental by Taxable Rental by Rental Type Tax Area Other 5.14% Fort Walton Beach Single Family Dwelling 7.83% 12.01% Okaloosa Island 26.07% Condo 58.48% Hotel / Motel Destin 24.37% 66.10% Page 7 Packet Pg. 37  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Total TDT Collections and Percentage Breakdown FY 2014 TOTAL MONTH FIRST % SECOND % THIRD % FOURTH % FIFTH % COLLECTIONS October $ 680,330.93 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 November $ 273,038.26 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 December $ 291,672.28 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 January $ 332,035.87 $ 66,407.17 $ 66,407.17 $ 66,407.17 $ 66,407.17 $ 66,407.17 February $ 430,183.30 $ 86,036.66 $ 86,036.66 $ 86,036.66 $ 86,036.66 $ 86,036.66 March $ 1,009,474.61 $ 201,894.92 $ 201,894.92 $ 201,894.92 $ 201,894.92 $ 201,894.92 April $ 1,038,269.24 $ 207,653.85 $ 207,653.85 $ 207,653.85 $ 207,653.85 $ 207,653.85 May $ 1,441,156.49 $ 288,231.30 $ 288,231.30 $ 288,231.30 $ 288,231.30 $ 288,231.30 June $ 2,909,098.89 $ 581,819.78 $ 581,819.78 $ 581,819.78 $ 581,819.78 $ 581,819.78 July $ - $ - $ - $ - $ - $ - August $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - Total $ 8,405,259.87 $ 1,681,051.97 $ 1,681,051.97 $ 1,681,051.97 $ 1,681,051.97 $ 1,681,051.97 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 38 Packet Pg. 39 3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Collector - May & June)  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Total Historical TDT Collections and Percentage Breakdown FY 2009 - Current % (+/-) % (+/-) % (+/-) Cum (+/-) Month FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 2011-2012 2012-2013 2013-2014 2013-2014 October $478,148.95 $522,443.42 $521,660.33 $598,158.00 14.49% $609,091.44 1.83% $680,330.93 11.70% 11.70% November $206,354.05 $210,704.19 $213,947.00 $239,511.00 11.95% $259,606.95 8.39% $273,038.26 5.17% 9.75% December $203,215.30 $235,157.23 $217,922.30 $289,595.00 32.89% $288,498.30 -0.38% $291,672.28 1.10% 7.59% January $277,999.51 $285,996.44 $256,775.00 $297,124.03 15.71% $298,995.38 0.63% $332,035.87 11.05% 8.30% February $386,604.93 $376,473.90 $365,490.00 $437,614.00 19.73% $395,790.00 -9.56% $430,183.30 8.69% 8.38% March $755,427.84 $727,272.00 $768,790.00 $1,028,053.00 33.72% $1,118,616.08 8.81% $1,009,474.61 -9.76% 1.55% April $792,139.00 $779,028.05 $847,476.00 $987,462.61 16.52% $905,964.12 -8.25% $1,038,269.24 14.60% 4.60% May $986,600.37 $955,032.36 $1,079,025.00 $1,296,974.20 20.20% $1,264,606.99 -2.50% $1,441,156.49 13.96% 6.90% June $2,091,522.22 $1,730,975.65 $2,290,684.30 $2,755,441.00 20.29% $2,797,225.80 1.52% July $2,245,536.10 $1,483,002.44 $2,749,706.99 $2,755,052.00 0.19% $2,897,646.65 5.18% August $1,169,781.00 $756,365.51 $1,225,204.88 $1,421,408.96 16.01% $1,588,763.04 11.77% September $800,409.00 $700,746.00 $1,028,530.00 $1,067,149.50 3.75% $1,098,414.84 2.93% Total $10,393,738.27 $8,763,197.19 $11,565,211.80 $13,173,543.30 13.91% $13,523,219.59 2.65% $5,496,160.98 Amounts for September 2013 through current reported by the Okaloosa County Tax Collector's Office. All amounts prior to September 2013 reported by the Okaloosa County Clerk of Courts. Page 1 Packet Pg. 40  Total TDT Collections in Thousands $300 $600 $900 $0 $1,200 $1,500 $1,800 $2,100 $2,400 $2,700 $3,000 $3,300 598.2 609.1 Oct FY 2012 680.3 239.5 259.6 Nov 273.0 289.6 288.5 Dec 291.7 297.1 299.0 Jan FY 2003 332.0 437.6 395.8 Feb 430.2 FY 12 1,028.1 1,118.6 Mar FY 13 Month Page 2 Page 2 1,009.5 987.5 FY 14 906.0 Apr FY 2012 - 2014 1,038.3 1,297.0 1,264.6 May Total Monthly TDT Collections 1,441.2 2,755.4 2,797.2 Jun 0.0 2,755.1 2,897.6 Jul 0.0 1,421.4 1,588.8 Aug 0.0 1,067.1 1,098.4 Sep 0.0 3.a.1 Packet Pg. 41 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax TDT Rental Receipts and Amount Remitted by Rental Type / Tax Area May 2014 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Rental Type Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Condo $17,451,703.96 $727,126.31 $16,724,577.65 $836,228.88 $0.05 $2,410.50 $502.90 ($4,749.00) $834,393.33 $809,361.53 $25,031.80 Hotel / Motel $8,477,981.92 $1,161,587.81 $7,316,394.11 $365,819.71 $0.00 $0.00 ($963.96) $364,855.75 $353,910.07 $10,945.67 Single Family Dwelling $3,420,775.22 $17,690.92 $3,403,084.30 $170,154.22 $230.86 $6.92 ($863.24) $169,528.76 $164,442.89 $5,085.87 Other $1,532,255.03 $78,866.30 $1,453,388.73 $72,669.44 $0.00 $0.00 ($290.78) $72,378.66 $70,207.30 $2,171.36 Total $30,882,716.13 $1,985,271.34 $28,897,444.79 $1,444,872.24 $0.05 $2,641.36 $509.82 ($6,866.98) $1,441,156.49 $1,397,921.79 $43,234.70 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Tax Area Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Destin $20,893,182.61 $416,949.40 $20,476,233.21 $1,023,811.66 $0.05 $1,186.06 $355.75 ($4,784.48) $1,020,569.04 $989,951.97 $30,617.07 Okaloosa Island $8,523,149.95 $1,294,000.65 $7,229,149.30 $361,457.47 $1,455.30 $154.07 ($1,702.83) $361,364.01 $350,523.08 $10,840.92 Fort Walton Beach $1,466,383.57 $574,321.29 $1,192,062.28 $59,603.11 $0.00 $0.00 ($379.67) $59,223.44 $57,446.73 $1,776.71 Total $30,882,716.13 $2,285,271.34 $28,897,444.79 $1,444,872.24 $0.05 $2,641.36 $509.82 ($6,866.98) $1,441,156.49 $1,397,921.79 $43,234.70 Page 3 Packet Pg. 42  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Percentage of Gross Rental, Taxable Rental, and Number of Units by Rental Type May 2014 Gross Rental Taxable Rental Rental Type % % Number of Units % Receipts Receipts Condo $17,451,703.96 56.51% $16,724,577.65 57.88% 6,126 56.70% Hotel / Motel $8,477,981.92 27.45% $7,316,394.11 25.32% 3,174 29.38% Single Family Dwelling $3,420,775.22 11.08% $3,403,084.30 11.78% 610 5.65% Other $1,532,255.03 4.96% $1,453,388.73 5.03% 894 8.27% Total $30,882,716.13 100.00% $28,897,444.79 100.00% 10,804 100.00% Gross Rental by Taxable Rental by Number of Units by Rental Type Rental Type Rental Type Other Other Other 4.96% 5.03% 8.27% Single Single Single Family Family Family Dwelling Dwelling Dwelling 11.08% 11.78% 5.65% Condo Condo Condo Hotel / 56.51% Hotel / 57.88% Hotel / 56.70% Motel Motel Motel 27.45% 25.32% 29.38% Page 4 Packet Pg. 43  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Percentage of Gross Rental, Taxable Rental, and Number of Units by Tax Area May 2014 Gross Rental Taxable Rental Tax Area % % Number of Units % Receipts Receipts Destin $20,893,182.61 67.65% $20,476,233.21 70.86% 6,399 59.23% Okaloosa Island $8,523,149.95 27.60% $7,229,149.30 25.02% 3,536 32.73% Fort Walton Beach $1,466,383.57 4.75% $1,192,062.28 4.13% 869 8.04% Total $30,882,716.13 100.00% $28,897,444.79 100.00% 10,804 100.00% Gross Rental by Taxable Rental by Number of Units by Tax Area Tax Area Tax Area Fort Fort Fort Walton Walton Walton Beach Beach Beach 4.75% 4.13% 8.04% Okaloosa Okaloosa Island Island Okaloosa 27.60% 25.02% Island Destin Destin Destin 32.73% 59.23% 67.65% 70.86% Page 5 Packet Pg. 44  3.a.1 Year to Date Percentage of Gross Rental Receipts Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax by Rental Type / Tax Area FY 2014 YEAR TO DATE RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Condo $ 8,308,588.62 3,149,452.93 3,326,087.76 4,415,501.80 5,518,014.66 11,749,179.84 12,171,284.49 17,451,703.96 $ 66,089,814.06 Hotel / Motel $ 3,348,581.10 1,885,569.12 1,741,863.00 1,891,012.04 2,705,840.91 5,997,349.68 6,755,617.68 8,477,981.92 $ 32,803,815.45 Single Family Dwelling $ 1,659,015.03 422,191.52 831,184.74 598,208.19 562,811.81 2,926,211.93 2,509,020.74 3,420,775.22 $ 12,929,419.18 Other $ 1,173,994.87 568,409.91 441,243.91 498,587.48 493,781.76 1,050,611.37 1,097,239.28 1,532,255.03 $ 6,856,123.61 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ 7,403,309.51 $ 9,280,449.14 $ 21,723,352.82 $ 22,533,162.19 $ 30,882,716.13 $ - $ - $ - $ - $ 118,679,172.30 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Destin $ 9,041,836.21 3,128,561.42 4,035,429.68 4,204,816.97 5,396,131.05 14,051,185.46 12,943,687.84 20,893,182.61 $ 73,694,831.24 Okaloosa Island $ 4,782,376.77 2,439,165.73 448,250.98 2,673,998.99 3,376,325.34 6,556,599.39 8,327,420.62 8,523,149.95 $ 37,127,287.77 Fort Walton Beach $ 665,966.64 457,896.33 1,856,698.75 524,493.55 507,992.75 1,115,567.97 1,262,053.73 1,466,383.57 $ 7,857,053.29 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ 7,403,309.51 $ 9,280,449.14 $ 21,723,352.82 $ 22,533,162.19 $ 30,882,716.13 $ - $ - $ - $ - $ 118,679,172.30 Year to Date Year to Date Gross Rental by Gross Rental by Rental Type Tax Area Other 5.78% Fort Walton Beach 6.62% Single Family Dwelling 10.89% Okaloosa Island 31.28% Condo 55.69% Destin 62.10% Hotel / Motel 27.64% Page 6 Packet Pg. 45  3.a.1 Year to Date Percentage of Taxable Rental Receipts Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax by Rental Type / Tax Area FY 2014 YEAR TO DATE RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Condo $ 7,753,638.68 2,767,247.54 2,977,548.25 4,024,762.68 5,139,266.41 10,907,638.94 11,287,364.90 16,724,577.65 $ 61,582,045.05 Hotel / Motel $ 3,236,954.32 1,808,528.67 1,683,568.14 1,706,148.98 2,458,408.45 5,506,739.63 5,925,582.76 7,316,394.11 $ 29,642,325.06 Single Family Dwelling $ 1,657,382.07 410,716.06 808,135.01 586,909.06 552,954.25 2,855,469.68 2,498,216.69 3,403,084.30 $ 12,772,867.12 Other $ 1,005,684.24 500,853.91 368,512.49 364,790.48 485,812.76 965,586.82 1,022,823.28 1,453,388.73 $ 6,167,452.71 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ 6,682,611.20 $ 8,636,441.87 $ 20,235,435.07 $ 20,733,987.63 $ 28,897,444.79 $ - $ - $ - $ - $ 110,164,689.94 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Destin $ 8,708,099.23 2,912,346.67 3,793,057.43 3,977,389.80 5,153,970.82 13,356,682.21 12,563,643.59 20,476,233.21 $ 70,941,422.96 Okaloosa Island $ 4,414,625.83 2,217,756.25 352,210.39 2,359,525.59 3,019,281.25 963,397.41 7,200,528.74 7,229,149.30 $ 27,756,474.76 Fort Walton Beach $ 530,934.25 357,243.26 1,692,496.07 345,695.81 463,189.80 5,915,355.45 969,815.30 1,192,062.28 $ 11,466,792.22 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ 6,682,611.20 $ 8,636,441.87 $ 20,235,435.07 $ 20,733,987.63 $ 28,897,444.79 $ - $ - $ - $ - $ 110,164,689.94 Year to Date Year to Date Taxable Rental by Taxable Rental by Rental Type Tax Area Other 5.60% Fort Walton Beach Single Family Dwelling 10.41% 11.59% Okaloosa Island Condo 25.20% 55.90% Destin Hotel / Motel 64.40% 26.91% Page 7 Packet Pg. 46  3.a.1 Attachment: III.a. TDT Reports OCTC (Jun 14) (3204 : Month End Tax Revenue Reports from Okaloosa Tax Total TDT Collections and Percentage Breakdown FY 2014 TOTAL MONTH FIRST % SECOND % THIRD % FOURTH % FIFTH % COLLECTIONS October $ 680,330.93 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 November $ 273,038.26 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 December $ 291,672.28 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 January $ 332,035.87 $ 66,407.17 $ 66,407.17 $ 66,407.17 $ 66,407.17 $ 66,407.17 February $ 430,183.30 $ 86,036.66 $ 86,036.66 $ 86,036.66 $ 86,036.66 $ 86,036.66 March $ 1,009,474.61 $ 201,894.92 $ 201,894.92 $ 201,894.92 $ 201,894.92 $ 201,894.92 April $ 1,038,269.24 $ 207,653.85 $ 207,653.85 $ 207,653.85 $ 207,653.85 $ 207,653.85 May $ 1,441,156.49 $ 288,231.30 $ 288,231.30 $ 288,231.30 $ 288,231.30 $ 288,231.30 June $ - $ - $ - $ - $ - $ - July $ - $ - $ - $ - $ - $ - August $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - Total $ 5,496,160.98 $ 1,099,232.20 $ 1,099,232.20 $ 1,099,232.20 $ 1,099,232.20 $ 1,099,232.20 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8 Packet Pg. 47  3.b Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Update Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3205) DOC ID: 3205 Financial Update - August Updated: 8/22/2014 4:20 PM by Aida Wilkinson Page 1 Packet Pg. 48  3.b.1 Financial Update August 2014 FY 2013-14 AMENDED BUDGET: $36,823,319 Financial data as of 08/19/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 restoration, FDOT grant funds for seasonal transit service on Okaloosa Island and Destin, FDEP grant funds for Okaloosa Island dune walkovers, and reserve carryforwards. REVENUE ANALYSIS Attachment: III.b. Financial Update (3205 : Financial Update - August) 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 th remit bed tax collections to the tax collector by the 20 of each month for the preceding month. The tax th collector reconciles and remits the revenues to the County by the 10 of the following month. Due to the timing of this process, $8.4M in actual revenue represents collections through June. Based on these receipts, tourist development tax revenues are on track to generate $13.9M this year, which is $1.9M or 16.2% more than budgeted and $415K or 3.1% more than prior year collections. August 21, 2014 Packet Tourist Development Department, Okaloosa County, FL Pg. 49 Financial Update – August 2014 3.b.1 EXPENSE ANALYSIS Attachment: III.b. Financial Update (3205 : Financial Update - August) 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. August 21, 2014 Tourist Development Department, Okaloosa County, FL 2 of 6 Packet Pg. 50 Financial Update – August 2014 3.b.1 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 Attachment: III.b. Financial Update (3205 : Financial Update - August) 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 August 21, 2014 Tourist Development Department, Okaloosa County, FL 3 of 6 Packet Pg. 51 Financial Update – August 2014 3.b.1 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 Attachment: III.b. Financial Update (3205 : Financial Update - August) FOURTH PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive) • expansion, renovation, reconstruction of the convention center and outdoor venues August 21, 2014 Tourist Development Department, Okaloosa County, FL 4 of 6 Packet Pg. 52 Financial Update – August 2014 3.b.1 FIFTH PERCENTAGE (These permissible uses are intended to be representative, not all-inclusive) • tourism promotion Attachment: III.b. Financial Update (3205 : Financial Update - August) 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) August 21, 2014 Tourist Development Department, Okaloosa County, FL 5 of 6 Packet Pg. 53 Financial Update – August 2014 3.b.1 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 months of June & July 2014. TDC Recommendation to BCC Attachment: III.b. Financial Update (3205 : Financial Update - August) Approve the financial update as presented. August 21, 2014 Tourist Development Department, Okaloosa County, FL 6 of 6 Packet Pg. 54  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/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 10/14 07/02/14 21 V1406819 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING .00 3,166.67 .00 534018 CS−CHAMBER OF COMMERCE 10/14 07/10/14 21 1406947 002241 DESTIN AREA CHAM 5,000.00 .00 APR−JUN2014 TDD TOTAL CS−CHAMBER OF COMMERCE .00 5,000.00 .00 534500 CS−PERSONNEL 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 121.24 .00 LATIMER 6/15/14 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 237.30 .00 THATCHER 6/8/14 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 549.91 .00 WARDLOW 6/15/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 69.28 .00 LISHEFSKI 6/22/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 692.80 .00 WARDLOW 6/22/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 6/21/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 108.00 .00 HALSEY 6/21/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 252.70 .00 NIXON 6/28/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 138.56 .00 WARDLOW 6/29/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 207.84 .00 LISHEFSKI 6/29/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 237.30 .00 THATCHER 6/22/14 TOTAL CS−PERSONNEL .00 3,678.93 .00 540002 TRAVEL OUT−OF−COUNTY 10/14 07/17/14 21 V1407147 21200456 GAIL MORGAN 1,664.36 .00 LOS ANGELES CA TOTAL TRAVEL OUT−OF−COUNTY .00 1,664.36 .00 540005 TRAVEL LODGING EXPENSES 10/14 07/17/14 21 V1407147 21200456 GAIL MORGAN 1,494.43 .00 LOS ANGELES CA TOTAL TRAVEL LODGING EXPENSES .00 1,494.43 .00 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 62.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 62.00 .00 547002 PRINTING & BINDING 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 740.00 .00 OFFICE DEPOT #1099 TOTAL PRINTING & BINDING .00 740.00 .00 548003 TRADE SHOW FEES 10/14 07/31/14 21 V1407429 21200456 GAIL MORGAN 2,000.00 .00 REGISTRATION TOTAL TRADE SHOW FEES .00 2,000.00 .00 548010 AGENCY BASE SVCS−MONTHLY 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 1,522.47 .00 TRAVEL HARD COST 10/14 07/10/14 21 1407009 21300295 PETER A MAYER AD 2,350.25 .00 TRAVEL HARD COST Packet Pg. 55 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 3.b.1 RUN DATE 08/20/2014 TIME 09:51:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548010 AGENCY BASE SVCS−MONTHLY (cont’d) 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS TOTAL AGENCY BASE SVCS−MONTHLY .00 95,035.22 .00 548011 AGENCY SVCS−OTHER 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 21,965.00 .00 TO98 MEDIA PLANNING TOTAL AGENCY SVCS−OTHER .00 21,965.00 .00 548020 WEBSITE DEV & MAINTENANCE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 19.00 .00 SERVERSTADIUM.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 19.00 .00 SERVERSTADIUM.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 339.00 .00 GETTY IMAGES TOTAL WEBSITE DEV & MAINTENANCE .00 377.00 .00 548042 FALL CAMPAIGN 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 6,078.43 .00 TO62 SOUTHERN LIVING 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 71,102.50 .00 TO113 JAN−SEP PRINT TOTAL FALL CAMPAIGN .00 77,180.93 .00 548043 CHRISTMAS CAMPAIGN 10/14 07/14/14 19 CORJBB 20,000.00 CORRECT #1403121 10/14 07/14/14 19 CORJBB −20,000.00 CORRECT #1403121 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD −6,078.44 .00 TO75INTERACTIVE MEDIA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 6,078.43 .00 TO75 S LIVING CO−OP 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 10,664.28 .00 TO75 DEC13 S LIVING TOTAL CHRISTMAS CAMPAIGN .00 10,664.27 .00 548046 SUMMER CAMPAIGN 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 3,010.00 .00 TO113 JAN−SEP PRINT TOTAL SUMMER CAMPAIGN .00 3,010.00 .00 548047 NON−SEASONAL 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 5,000.00 .00 TO139JAN−SEP PRINT 10/14 07/24/14 21 1407297 21300295 PETER A MAYER AD 25,134.20 .00 TO113 JAN−SEP PRINT TOTAL NON−SEASONAL .00 30,134.20 .00 548051 CAMPAIGN PRODUCTION 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 3,153.00 .00 TO133 BRAND CAMPAIGN TOTAL CAMPAIGN PRODUCTION .00 3,153.00 .00 549906 BACKGROUND CHECKS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET TOTAL BACKGROUND CHECKS .00 24.00 .00 Packet Pg. 56 TOTAL 5TH TDT−TOURISM PROMOTION .00 259,350.01 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 3 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549906 BACKGROUND CHECKS Packet Pg. 57 3.b.1 RUN DATE 08/20/2014 TIME 09:51:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 4 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 10/14 07/09/14 22 13,898.32 PAYROLL CHARGES 10/14 07/23/14 22 14,444.00 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 28,342.32 .00 512020 SALARIES/WAGES−PART−TIME 10/14 07/09/14 22 1,168.21 PAYROLL CHARGES 10/14 07/15/14 13 −3,296.00 BT−CA−14−31 10/14 07/23/14 22 1,162.28 PAYROLL CHARGES TOTAL SALARIES/WAGES−PART−TIME −3,296.00 2,330.49 .00 521000 FICA TAXES 10/14 07/09/14 22 1,125.15 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 1,166.44 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 2,291.59 .00 522000 RETIREMENT CONTRIBUTIONS 10/14 07/09/14 22 1,774.12 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 1,863.80 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 3,637.92 .00 523000 LIFE & HEALTH INSURANCE 10/14 07/09/14 22 50.00 PAYROLL CHARGES 10/14 07/09/14 22 1,450.00 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 60.60 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 11.55 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 11.50 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 50.00 PAYROLL CHARGES 10/14 07/23/14 22 1,450.00 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 60.60 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 11.50 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 11.55 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 3,167.30 .00 523012 CONTRA L&H INS (REBATE) 10/14 07/09/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI 10/14 07/23/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −160.00 .00 524000 WORKERS’ COMPENSATION 10/14 07/01/14 19 BUDGET−3 151.00 JULY 14 TOTAL WORKERS’ COMPENSATION .00 151.00 .00 525000 UNEMPLOYMENT COMPENSATION 10/14 07/15/14 13 3,296.00 BT−CA−14−31 Packet Pg. 58 TOTAL UNEMPLOYMENT COMPENSATION 3,296.00 .00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:03 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 5 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 531001 PS−ATTORNEY−OTHER 531001 PS−ATTORNEY−OTHER 10/14 07/17/14 21 V1407148 010277 NABORS,GIBLIN & 4,019.53 .00 ZIMMERMAN TOTAL PS−ATTORNEY−OTHER .00 4,019.53 .00 534001 CS−GENERAL FUND ADMIN 10/14 07/01/14 19 BUDGET−1 33,248.00 GEN FUND ADMINISTRATION TOTAL CS−GENERAL FUND ADMIN .00 33,248.00 .00 540002 TRAVEL OUT−OF−COUNTY 10/14 07/02/14 21 1406778 EMP00278 CHARLOTTE DUNWOR 75.00 .00 DAYTNA BCH 6/16−18/14 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 385.00 .00 UNITED 0167463333172 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 401.00 .00 DELTA AIR 0062361285480 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 401.00 .00 DELTA AIR 0062361394370 TOTAL TRAVEL OUT−OF−COUNTY .00 1,262.00 .00 540005 TRAVEL LODGING EXPENSES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 126.60 .00 SHORES AT DAYTONA 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 149.00 .00 WALDORF ASTORIA BOCA R 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 149.00 .00 WALDORF ASTORIA BOCA R TOTAL TRAVEL LODGING EXPENSES .00 424.60 .00 541010 COMMUNICATIONS SERVICE 10/14 07/10/14 21 1406941 002790 COX COMMUNICATIO 8.50 .00 TDD 10/14 07/31/14 21 1407355 001337 AT&T CORP 101.17 .00 TDD TOTAL COMMUNICATIONS SERVICE .00 109.67 .00 541011 CELLULAR PHONES/PAGERS 10/14 07/09/14 19 MOBILEDV −10.00 7/10/14 MOBILE DEVICE 10/14 07/10/14 21 1407042 20900128 VERIZON WIRELESS 238.40 .00 5/24−6/23/14 TDD 10/14 07/17/14 20 1401229 20900128 VERIZON WIRELESS −277.84 .00 9/24−10/23/13 TDD 10/14 07/23/14 19 MOBILEDV −10.00 7/24/14 MOBILE DEVICE 10/14 07/25/14 19 CORJDC 277.84 RECLASS STALEDATED CHCKS 10/14 07/31/14 21 1407470 20900128 VERIZON WIRELESS 120.03 .00 6/8−7/7/14 TDD TOTAL CELLULAR PHONES/PAGERS .00 338.43 .00 542001 POSTAGE/FREIGHT CHARGES 10/14 07/02/14 21 1406787 000362 FEDERAL EXPRESS 1,180.92 .00 148498911 TDD 10/14 07/31/14 21 1407382 000362 FEDERAL EXPRESS 14.71 .00 148498911 TDD TOTAL POSTAGE/FREIGHT CHARGES .00 1,195.63 .00 544620 R/L−BUILDINGS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 690.00 .00 A STORAGE SOLUTIONS OF DE TOTAL R/L−BUILDINGS .00 690.00 .00 Packet Pg. 59 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 434.00 GENERAL LIABILITY 3.b.1 RUN DATE 08/20/2014 TIME 09:51:04 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 6 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 545990 INSURANCE−OTHER (cont’d) TOTAL INSURANCE−OTHER .00 434.00 .00 546640 RM−EQUIPMENT 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 115.00 .00 COPY PRODUCTS COMPANY−FT TOTAL RM−EQUIPMENT .00 115.00 .00 546644 RM−VEHICLES−FLEET 10/14 08/12/14 19 FLT BILL 373.32 JULY 14 FLEET BILL TOTAL RM−VEHICLES−FLEET .00 373.32 .00 549900 MISCELLANEOUS CHARGES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 90.00 .00 THE TROPHY CENTER INC. TOTAL MISCELLANEOUS CHARGES .00 90.00 .00 549901 LEGAL ADVERTISING 10/14 07/10/14 21 1406974 21201551 HALIFAX MEDIA GR 74.10 .00 2028429 TDD TOTAL LEGAL ADVERTISING .00 74.10 .00 549905 MOTOR VEHICLE REPORTS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 47.07 .00 ACCUFACTS PRE EMPLOYMENT TOTAL MOTOR VEHICLE REPORTS .00 47.07 .00 549906 BACKGROUND CHECKS 10/14 07/10/14 21 V1406954 011218 DRUG FREE WORKPL 111.00 .00 TDD 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 24.95 .00 TALX CORPORATION TOTAL BACKGROUND CHECKS .00 183.95 .00 551001 OFFICE SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 171.70 .00 STAPLS3145393726000 TOTAL OFFICE SUPPLIES .00 171.70 .00 552010 FLEET FUEL 10/14 07/29/14 21 2872 014799 BANK OF AMERICA 50.36 .00 PILOT 00000919 10/14 07/29/14 21 2872 014799 BANK OF AMERICA 70.75 .00 MACCLENNY CITGO 10/14 07/29/14 21 2872 014799 BANK OF AMERICA −50.36 .00 PILOT 00000919 10/14 07/29/14 21 2872 014799 BANK OF AMERICA −70.75 .00 MACCLENNY CITGO 10/14 08/07/14 19 CORJFB −73.75 RECLASS 10/14 08/12/14 19 FLT BILL 257.24 JULY 14 FLEET BILL TOTAL FLEET FUEL .00 183.49 .00 552014 GASOLINE & SPECIAL FUELS 10/14 07/29/14 11 .00 ESTABLISH FOR CREDIT CARD Packet Pg. 60 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 50.36 .00 PILOT 00000919 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 70.75 .00 MACCLENNY CITGO 3.b.1 RUN DATE 08/20/2014 TIME 09:51:04 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 7 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 552014 GASOLINE & SPECIAL FUELS (cont’d) 10/14 08/07/14 19 CORJFB 73.75 RECLASS TOTAL GASOLINE & SPECIAL FUELS .00 194.86 .00 552800 COMPUTER SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 50.00 .00 CVSPHARMACY #4440 Q03 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 103.20 .00 GIGAPARTS (INTERNET) 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 303.97 .00 STAPLS3145393726000 TOTAL COMPUTER SUPPLIES .00 457.17 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 35.00 .00 FLORIDA LEAGUE OF CITIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 49.00 .00 CTC CONSTANTCONTACT.COM TOTAL BOOK/PUB/SUB/MEMBERSHIPS .00 84.00 .00 555001 TRAINING/EDUCATION EXPENS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 399.00 .00 VISIT FLORIDA SERVICE CEN 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 399.00 .00 VISIT FLORIDA SERVICE CEN TOTAL TRAINING/EDUCATION EXPENS .00 798.00 .00 581210 DESTIN FIRE DEPARTMENT 10/14 07/17/14 21 1407104 010851 DESTIN FIRE CONT 58,326.88 .00 JUNE2014 TOTAL DESTIN FIRE DEPARTMENT .00 58,326.88 .00 591001 BT−GENERAL FUND 10/14 07/01/14 19 BUDGET−4 45,961.00 JULY 2014 TOTAL BT−GENERAL FUND .00 45,961.00 .00 TOTAL 2ND TDT−ADMINISTRATION .00 188,543.02 .00 Packet Pg. 61 3.b.1 RUN DATE 08/20/2014 TIME 09:51:04 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 8 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 10/14 07/09/14 22 5,389.60 PAYROLL CHARGES 10/14 07/23/14 22 6,653.20 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 12,042.80 .00 521000 FICA TAXES 10/14 07/09/14 22 390.29 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 486.95 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 877.24 .00 522000 RETIREMENT CONTRIBUTIONS 10/14 07/09/14 22 397.21 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 490.34 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 887.55 .00 523000 LIFE & HEALTH INSURANCE 10/14 07/09/14 22 1,087.50 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 36.36 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 6.93 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 6.90 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 1,087.50 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 36.36 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 6.90 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 6.93 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 2,275.38 .00 523012 CONTRA L&H INS (REBATE) 10/14 07/09/14 19 REBATE −60.00 INSURANCE REBATE ALLOCATI 10/14 07/23/14 19 REBATE −60.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −120.00 .00 524000 WORKERS’ COMPENSATION 10/14 07/01/14 19 BUDGET−3 47.00 JULY 14 TOTAL WORKERS’ COMPENSATION .00 47.00 .00 540001 TRAVEL IN−COUNTY 10/14 07/24/14 13 −1,900.00 BT−CA−14−32 TOTAL TRAVEL IN−COUNTY −1,900.00 .00 .00 540002 TRAVEL OUT−OF−COUNTY 10/14 07/02/14 21 1406841 EMP00269 APRIL SARVER 102.78 .00 PORTLND OR 6/12−15/14 10/14 07/17/14 21 1407120 20300910 LINDSAY B GOWING 104.00 .00 PITTSBRG 5/31−6/6/14 10/14 07/24/14 13 −186.00 BT−CA−14−32 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 5.00 .00 TRIMET TVM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 25.00 .00 AMERICAN AI 0010268521736 Packet Pg. 62 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 25.00 .00 AMERICAN AI 0010268685555 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 250.00 .00 DELTA AIR 0062363418159 3.b.1 RUN DATE 08/20/2014 TIME 09:51:04 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 9 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 540002 TRAVEL OUT−OF−COUNTY (cont’d) 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 474.00 .00 AMERICAN AI 0017459370335 TOTAL TRAVEL OUT−OF−COUNTY −186.00 985.78 .00 540005 TRAVEL LODGING EXPENSES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 700.74 .00 HILTON HOTELS TOTAL TRAVEL LODGING EXPENSES .00 700.74 .00 541011 CELLULAR PHONES/PAGERS 10/14 07/10/14 21 1407042 20900128 VERIZON WIRELESS 80.02 .00 5/24−6/23/14 TDD 10/14 07/17/14 21 1407203 20900128 VERIZON WIRELESS 99.20 .00 5/24−6/23/14 ECCC 10/14 07/24/14 13 400.00 BT−CA−14−32 10/14 07/31/14 21 1407470 20900128 VERIZON WIRELESS 80.02 .00 6/8−7/7/14 TDD TOTAL CELLULAR PHONES/PAGERS 400.00 259.24 .00 542001 POSTAGE/FREIGHT CHARGES 10/14 07/24/14 13 −400.00 BT−CA−14−32 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 466.36 .00 HARGROVE INC TOTAL POSTAGE/FREIGHT CHARGES −400.00 466.36 .00 544620 R/L−BUILDINGS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 210.00 .00 A STORAGE SOLUTIONS OF DE TOTAL R/L−BUILDINGS .00 210.00 .00 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 60.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 60.00 .00 548001 PROMOTIONAL ACTIVITIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 248.80 .00 EPROMOS PROMOTIONAL PR 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 809.75 .00 FAVORFAVOR LLC TOTAL PROMOTIONAL ACTIVITIES .00 1,058.55 .00 548002 EVENT PROMOTIONAL ACTIVTY 10/14 07/10/14 21 1406995 21201439 LIFE’S A BEACH P 760.00 .00 FLYER DESIGN 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA −84.76 .00 SQ CREATIVE CELEBRATIONS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 11.00 .00 DOLRTREE 3577 00035774 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 27.88 .00 TOM THUMB #58 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 43.00 .00 SOUTHERN STAR DOLPHIN CRU 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 90.50 .00 PANERA BREAD #902 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 105.43 .00 WM SUPERCENTER #3439 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 120.84 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 139.48 .00 WAL−MART #0919 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 139.98 .00 FEDEXOFFICE 00015917 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 261.54 .00 ENTERPRISE RENT−A−CAR Packet Pg. 63 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 262.12 .00 IMAGE PRINTING & DIGITAL 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 322.60 .00 WM SUPERCENTER #1362 3.b.1 RUN DATE 08/20/2014 TIME 09:51:04 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 10 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548002 EVENT PROMOTIONAL ACTIVTY (cont’d) 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 404.80 .00 MARINA CAFE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 465.00 .00 HEROMAN SERVICES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 820.97 .00 SQ BARRIOS CELEBRATIONS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 923.00 .00 SQ CREATIVE CELEBRATIONS TOTAL EVENT PROMOTIONAL ACTIVTY .00 4,813.38 .00 548003 TRADE SHOW FEES 10/14 07/02/14 21 1406848 21001779 SMALL MARKET MEE 1,495.00 .00 REGISTRATION 10/14 07/10/14 21 1406938 21001821 COLLINSON & COMP 3,150.00 .00 REGISTRATION 10/14 07/17/14 21 1407170 21001779 SMALL MARKET MEE 5,000.00 .00 P/O 21401443 TOTAL TRADE SHOW FEES .00 9,645.00 .00 548010 AGENCY BASE SVCS−MONTHLY 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 1,522.46 .00 TRAVEL HARD COST 10/14 07/10/14 21 1407009 21300295 PETER A MAYER AD 2,350.25 .00 TRAVEL HARD COST 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 18,232.50 .00 BASE SVCS TOTAL AGENCY BASE SVCS−MONTHLY .00 95,035.21 .00 548011 AGENCY SVCS−OTHER 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 1,782.50 .00 TO88CO−OP,GRPS,MEDIA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 3,622.50 .00 TO88 CO−OP,GRPS,MEDIA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 8,337.50 .00 TO88CO−OP,GRPS MEDIA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 13,627.50 .00 TO88CO−OP,GRPS,MEDIA TOTAL AGENCY SVCS−OTHER .00 27,370.00 .00 548020 WEBSITE DEV & MAINTENANCE 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 431.25 .00 TO138 LEISURE WEBSITE 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 948.75 .00 TO140 ECOTOURISM TOTAL WEBSITE DEV & MAINTENANCE .00 1,380.00 .00 548048 GROUP & CONVEN CAMPAIGN 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 1,772.50 .00 TO120JAN−DEC PRINT14 10/14 07/17/14 21 21401443−01 21001779 SMALL MARKET MEE .00 −5,000.00 CHANGE ORDER − 3 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 249.00 .00 TO122 JAN−DEC GROUPS 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 500.00 .00 TO122JAN DALLAS BRIDA 10/14 07/17/14 21 1407159 21300295 PETER A MAYER AD 495.00 .00 TO124 MAY SPORTS EVNT 10/14 07/31/14 21 00245700 21300295 PETER A MAYER AD 11,357.50 .00 TO120R JAN−DEC PRINT 10/14 07/31/14 21 00245700 21300295 PETER A MAYER AD −11,357.50 .00 TO120R JAN−DEC PRINT 10/14 07/31/14 21 1407436 21300295 PETER A MAYER AD 11,357.50 .00 TO120R JAN−DEC PRINT TOTAL GROUP & CONVEN CAMPAIGN .00 14,374.00 −5,000.00 Packet Pg. 64 548049 BRANDING 3.b.1 RUN DATE 08/20/2014 TIME 09:51:05 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 11 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548049 BRANDING 10/14 07/02/14 21 1406832 21300295 PETER A MAYER AD 4,485.00 .00 TO132 BRAND CAMPAIGN TOTAL BRANDING .00 4,485.00 .00 548050 SPONSORSHIPS 10/14 07/02/14 21 21401084−01 1406820 20700043 MUSICAL ECHOES 1,271.79 −6,800.00 SPECIAL EVENT AND SPONSOR TOTAL SPONSORSHIPS .00 1,271.79 −6,800.00 548070 ADVERTISING 10/14 07/02/14 21 21401253−01 1406764 21001821 COLLINSON & COMP 24,549.00 −24,549.00 FULL PAGE AD INSERTION VF 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 1,025.34 .00 CLEAR CHANNEL OUTDOOR TOTAL ADVERTISING .00 25,574.34 −24,549.00 549906 BACKGROUND CHECKS 10/14 07/10/14 21 V1406954 011218 DRUG FREE WORKPL 37.00 .00 TDD TOTAL BACKGROUND CHECKS .00 37.00 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 55.00 .00 CTC CONSTANTCONTACT.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 55.00 .00 CTC CONSTANTCONTACT.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 195.00 .00 RCMA TOTAL BOOK/PUB/SUB/MEMBERSHIPS .00 305.00 .00 555001 TRAINING/EDUCATION EXPENS 10/14 07/17/14 21 1407171 21400265 SOUTHEAST TOURIS 1,120.00 .00 REGISTRATION TOTAL TRAINING/EDUCATION EXPENS .00 1,120.00 .00 564703 COMPUTER EQUIPMENT 10/14 07/16/14 11 .00 ESTABLISHED PER CD 10/14 07/23/14 17 21401665−01 009744 DELL MARKETING L 1,665.40 TABLET/LAPTOP COMPUTER, D 10/14 07/23/14 17 21401665−02 009744 DELL MARKETING L 209.98 TABLET DOCK − DAO (332−23 10/14 07/23/14 17 21401665−03 009744 DELL MARKETING L 119.98 CUS, KYBD, MSE, US, WRLES 10/14 07/23/14 17 21401665−04 009744 DELL MARKETING L 89.98 TARGUS RUGGED MAX PRO CAS 10/14 07/24/14 13 2,086.00 BT−CA−14−32 TOTAL COMPUTER EQUIPMENT 2,086.00 .00 2,085.34 TOTAL 3RD TDT−C.C. PROMOTIONS .00 205,161.36 −34,263.66 Packet Pg. 65 3.b.1 RUN DATE 08/20/2014 TIME 09:51:05 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 12 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 10/14 07/09/14 22 26,888.67 PAYROLL CHARGES 10/14 07/23/14 22 23,110.68 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 49,999.35 .00 512020 SALARIES/WAGES−PART−TIME 10/14 07/09/14 22 642.92 PAYROLL CHARGES 10/14 07/23/14 22 1,129.93 PAYROLL CHARGES TOTAL SALARIES/WAGES−PART−TIME .00 1,772.85 .00 514010 OVERTIME 10/14 07/09/14 22 1,641.60 PAYROLL CHARGES 10/14 07/23/14 22 271.32 PAYROLL CHARGES TOTAL OVERTIME .00 1,912.92 .00 521000 FICA TAXES 10/14 07/09/14 22 2,158.27 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 1,801.67 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 3,959.94 .00 522000 RETIREMENT CONTRIBUTIONS 10/14 07/09/14 22 2,372.24 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 1,851.59 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 4,223.83 .00 523000 LIFE & HEALTH INSURANCE 10/14 07/09/14 22 350.00 PAYROLL CHARGES 10/14 07/09/14 22 3,262.50 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 169.68 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 36.96 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 36.80 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 2,900.00 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 350.00 PAYROLL CHARGES 10/14 07/23/14 22 157.56 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 34.50 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 34.65 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 7,332.65 .00 523012 CONTRA L&H INS (REBATE) 10/14 07/09/14 19 REBATE −180.00 INSURANCE REBATE ALLOCATI 10/14 07/23/14 19 REBATE −160.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −340.00 .00 524000 WORKERS’ COMPENSATION 10/14 07/01/14 19 BUDGET−3 1,342.00 JULY 14 Packet Pg. 66 TOTAL WORKERS’ COMPENSATION .00 1,342.00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:05 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 13 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534001 CS−GENERAL FUND ADMIN 534001 CS−GENERAL FUND ADMIN 10/14 07/01/14 19 BUDGET−1 14,686.00 GEN FUND ADMINISTRATION TOTAL CS−GENERAL FUND ADMIN .00 14,686.00 .00 540002 TRAVEL OUT−OF−COUNTY 10/14 07/10/14 21 1406992 20201306 WILLIAM G LEAMAN 448.08 .00 AMELIA ISLD 1/5−8/14 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 25.00 .00 DELTA AIR 0068242335897 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 33.29 .00 HERTZ RENT−A−CAR TOTAL TRAVEL OUT−OF−COUNTY .00 506.37 .00 541010 COMMUNICATIONS SERVICE 10/14 07/02/14 21 1406769 002790 COX COMMUNICATIO 70.08 .00 ECCC TOTAL COMMUNICATIONS SERVICE .00 70.08 .00 541011 CELLULAR PHONES/PAGERS 10/14 07/09/14 19 MOBILEDV −15.00 7/10/14 MOBILE DEVICE 10/14 07/17/14 21 1407203 20900128 VERIZON WIRELESS 318.84 .00 5/24−6/23/14 ECCC 10/14 07/17/14 20 1401220 20900128 VERIZON WIRELESS −228.20 .00 7/24−8/23/13 TDD 10/14 07/17/14 20 1401222 20900128 VERIZON WIRELESS −228.02 .00 8/24−9/23/13 CONV 10/14 07/17/14 20 1401232 20900128 VERIZON WIRELESS −228.16 .00 9/24−10/23/13 CONV 10/14 07/23/14 19 MOBILEDV −15.00 7/24/14 MOBILE DEVICE 10/14 07/25/14 19 CORJDC 684.38 RECLASS STALEDATED CHCKS TOTAL CELLULAR PHONES/PAGERS .00 288.84 .00 542001 POSTAGE/FREIGHT CHARGES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 7.20 .00 UPS 2955H38MHKE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 11.88 .00 UPS 1Z69Y20V0398782693 TOTAL POSTAGE/FREIGHT CHARGES .00 19.08 .00 544640 R/L−EQUIPMENT 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 136.50 .00 CULLIGAN WATER SOLUTIO TOTAL R/L−EQUIPMENT .00 136.50 .00 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 5,219.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 5,219.00 .00 547002 PRINTING & BINDING 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 47.74 .00 IMAGE PRINTING & DIGITAL 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 73.79 .00 COASTAL BUSINESS PRODUCTS TOTAL PRINTING & BINDING .00 121.53 .00 549122 BANK CHARGES 10/14 07/23/14 19 BK CHGS 145.64 518089424342749 Packet Pg. 67 10/14 07/24/14 19 CC AMEX 328.98 JUNE 2014 AMER EXPRESS TOTAL BANK CHARGES .00 474.62 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:05 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 14 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549122 BANK CHARGES (cont’d) 549900 MISCELLANEOUS CHARGES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 25.00 .00 FDEP PAYMENT SYSTEM TOTAL MISCELLANEOUS CHARGES .00 25.00 .00 549906 BACKGROUND CHECKS 10/14 07/10/14 21 V1406954 011218 DRUG FREE WORKPL 37.00 .00 TDD TOTAL BACKGROUND CHECKS .00 37.00 .00 551001 OFFICE SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 9.96 .00 OFFICE DEPOT #206 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 11.37 .00 STAPLES 00118828 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 27.67 .00 OFFICE DEPOT #1214 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 32.94 .00 STAPLES 00118828 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 35.08 .00 OFFICE DEPOT #206 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 51.87 .00 OFFICE DEPOT #1214 TOTAL OFFICE SUPPLIES .00 168.89 .00 552800 COMPUTER SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 12.50 .00 STAPLES 00118828 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 46.57 .00 OFFICE DEPOT #1214 TOTAL COMPUTER SUPPLIES .00 59.07 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 10/14 07/24/14 13 1,000.00 BT−CA−14−32 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 455.00 .00 IAAM INC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 455.00 .00 IAAM INC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 485.00 .00 PROF CONV MGMT ASSN TOTAL BOOK/PUB/SUB/MEMBERSHIPS 1,000.00 1,395.00 .00 555001 TRAINING/EDUCATION EXPENS 10/14 07/24/14 13 −1,000.00 BT−CA−14−32 TOTAL TRAINING/EDUCATION EXPENS −1,000.00 .00 .00 TOTAL 3RD TDT−C.C. ADMIN .00 93,410.52 .00 Packet Pg. 68 3.b.1 RUN DATE 08/20/2014 TIME 09:51:05 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 15 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534200 CS−SECURITY 10/14 07/17/14 21 1407100 21200786 CUTLASS SECURITY 887.00 .00 6/19−27/14 ECCC 10/14 07/24/14 21 1407242 21200786 CUTLASS SECURITY 2,131.50 .00 6/30−7/5/14 CONV CTR TOTAL CS−SECURITY .00 3,018.50 .00 534500 CS−PERSONNEL 10/14 07/02/14 21 V1406809 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 6/15/14 10/14 07/02/14 21 1406813 21101150 LANDRUM STAFFING 395.40 .00 MCCLELLAND 5/3/14 10/14 07/02/14 21 1406813 21101150 LANDRUM STAFFING 467.89 .00 KEIGANS 5/3/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 125.92 .00 FUSCO 6/15/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 212.49 .00 NICHOLS 6/15/14 10/14 07/10/14 21 V1406988 009350 KELLY SERVICES,I 495.81 .00 ALVIS 6/8−15/14 10/14 07/17/14 21 1407141 21101150 LANDRUM STAFFING 39.54 .00 MITCHELL 6/28/14 10/14 07/17/14 21 V1407139 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 6/22/14 10/14 07/17/14 21 V1407139 009350 KELLY SERVICES,I 1,552.20 .00 CONV CTR 6/22/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 67.90 .00 CONV CTR 6/22/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 733.32 .00 CONV CTR 6/22/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 1,575.28 .00 CONV CTR 6/15/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 1,636.39 .00 CONV CTR 4/13/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 6/29/14 10/14 07/24/14 21 V1407270 009350 KELLY SERVICES,I 499.75 .00 ALVIS 6/29/14 10/14 07/24/14 21 1407296 20900514 TAMPA SERVICE CO 960.78 .00 CONV CTR 6/29/14 10/14 07/24/14 13 15,000.00 BT−CA−14−32 10/14 07/31/14 21 V1407412 009350 KELLY SERVICES,I 84.75 .00 DEDICKE 7/13/14 10/14 07/31/14 21 V1407412 009350 KELLY SERVICES,I 198.35 .00 WOLFENDEN 7/6/14 10/14 07/31/14 21 V1407412 009350 KELLY SERVICES,I 389.57 .00 ALVIS 7/13/14 TOTAL CS−PERSONNEL 15,000.00 9,860.38 .00 534751 CS−RIGGING/PRODUCTION 10/14 07/24/14 13 −3,000.00 BT−CA−14−32 TOTAL CS−RIGGING/PRODUCTION −3,000.00 .00 .00 534754 CS−SHOW DECORATIONS 10/14 07/24/14 13 10,000.00 BT−CA−14−32 TOTAL CS−SHOW DECORATIONS 10,000.00 .00 .00 534757 CS−ENTERTAINMENT 10/14 07/24/14 13 −10,000.00 BT−CA−14−32 10/14 07/24/14 13 −15,000.00 BT−CA−14−32 TOTAL CS−ENTERTAINMENT −25,000.00 .00 .00 544640 R/L−EQUIPMENT 10/14 07/17/14 21 21401558−01 1407188 20801842 BRENDON GRIMES D 2,070.00 −2,070.00 RENT 40’ OF 12" BOX TRUSS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 553.61 .00 DISPOSAL SERVICES, LLC TOTAL R/L−EQUIPMENT .00 2,623.61 −2,070.00 Packet Pg. 69 549900 MISCELLANEOUS CHARGES 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 16 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549900 MISCELLANEOUS CHARGES 10/14 07/02/14 21 V1406776 006052 DON W HOWARD CLE 69.50 .00 1601378 TDD 10/14 07/14/14 19 AJEJBC 700.00 TRNSF PAY TO 19829833 10/14 07/24/14 13 3,000.00 BT−CA−14−32 TOTAL MISCELLANEOUS CHARGES 3,000.00 769.50 .00 552751 C.C. SPECIAL EVENTS 10/14 07/17/14 20 21400222−01 1401120 20401432 ATLANTA RIGGING −309.88 309.88 MOTOR CONTROL ASSEMBLY (P 10/14 07/17/14 20 21400222−02 1401120 20401432 ATLANTA RIGGING −334.00 334.00 50’ SINGLE PHASE MOTOR CA 10/14 07/25/14 19 CORJDC 643.88 RECLASS STALEDATED CHCKS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 20.00 .00 THE SOUND COUNCIL, LLC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 66.00 .00 BATTERY WAREHOUSE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 125.00 .00 THE SOUND COUNCIL, LLC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 130.26 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 151.07 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 162.12 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 201.28 .00 LIGHT THEATRICS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 222.06 .00 PRO SOUND 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 224.35 .00 SAPSIS RIGGING INC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 312.77 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 314.18 .00 ARAMARK EMERALD CAAST CON 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 350.00 .00 LIVESTREAM TOTAL C.C. SPECIAL EVENTS .00 2,279.09 643.88 564751 C.C. SPECIAL EVENTS 10/14 07/03/14 17 21401592−01 GM000344 PANHANDLE ALARM .00 RELOCATE EXISTING CAMERA 10/14 07/03/14 17 21401592−02 GM000344 PANHANDLE ALARM .00 INSTALL NEW BOSCH AUTODOM 10/14 07/03/14 17 21401592−03 GM000344 PANHANDLE ALARM .00 CONNECT BOTH CAMERAS TO E 10/14 07/03/14 17 21401592−04 GM000344 PANHANDLE ALARM 3,911.06 LINE ITEM 1−3 TOTAL COST 10/14 07/17/14 20 21400130−01 1401120 20401432 ATLANTA RIGGING −3,546.00 3,546.00 CM LODESTAR MODEL F HOIST 10/14 07/17/14 20 21400130−02 1401120 20401432 ATLANTA RIGGING −75.64 75.64 SWIVEL HOOK MODELS AA−F 10/14 07/17/14 20 21400130−03 1401120 20401432 ATLANTA RIGGING −109.20 109.20 MOTOR WIRING PACKAGE − SI 10/14 07/17/14 20 21400130−04 1401120 20401432 ATLANTA RIGGING −790.40 790.40 STAR GRADE CHAIN 1/4" PER 10/14 07/17/14 20 21400130−05 1401120 20401432 ATLANTA RIGGING −148.26 148.26 CHAIN CAPTURE SYSTEM FOR 10/14 07/17/14 20 21400130−06 1401120 20401432 ATLANTA RIGGING −157.42 157.42 FREIGHT 10/14 07/25/14 19 CORJDC 4,826.92 RECLASS STALEDATED CHCKS TOTAL C.C. SPECIAL EVENTS .00 .00 8,737.98 TOTAL 3RD TDT−C.C. OPERATIONS .00 18,551.08 7,311.86 Packet Pg. 70 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 17 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 10/14 07/09/14 22 3,990.90 PAYROLL CHARGES 10/14 07/23/14 22 3,930.40 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 7,921.30 .00 521000 FICA TAXES 10/14 07/09/14 22 303.12 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 298.49 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 601.61 .00 522000 RETIREMENT CONTRIBUTIONS 10/14 07/09/14 22 294.13 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 289.67 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 583.80 .00 523000 LIFE & HEALTH INSURANCE 10/14 07/09/14 22 362.50 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 12.12 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 2.31 PAYROLL CHARGES−FRINGE 10/14 07/09/14 22 2.30 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 362.50 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 12.12 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 2.30 PAYROLL CHARGES−FRINGE 10/14 07/23/14 22 2.31 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 758.46 .00 523012 CONTRA L&H INS (REBATE) 10/14 07/09/14 19 REBATE −20.00 INSURANCE REBATE ALLOCATI 10/14 07/23/14 19 REBATE −20.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00 524000 WORKERS’ COMPENSATION 10/14 07/01/14 19 BUDGET−3 25.00 JULY 14 TOTAL WORKERS’ COMPENSATION .00 25.00 .00 531002 PS−OTHER ATTORNEY SVCS 10/14 07/17/14 21 V1407148 010277 NABORS,GIBLIN & 40.49 .00 SANDMAN TOTAL PS−OTHER ATTORNEY SVCS .00 40.49 .00 531100 PS−CONSULTANT 10/14 07/17/14 21 1407182 013714 TAYLOR ENGINEERI 5,467.00 .00 TO8 ANCHORING BUOYS 10/14 07/17/14 21 1407072 20700177 ALCALDE & FAY LT 1,667.00 .00 JUNE2014 10/14 07/31/14 21 1407349 20700177 ALCALDE & FAY LT 1,667.00 .00 JULY2014 RETAINER TOTAL PS−CONSULTANT .00 8,801.00 .00 Packet Pg. 71 534010 CS−PARKS CLEANING 10/14 07/17/14 21 V1407135 000428 HORIZONS OF OKAL 9,743.80 .00 JUNE2014 MOBILE CREW 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 18 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534010 CS−PARKS CLEANING (cont’d) TOTAL CS−PARKS CLEANING .00 9,743.80 .00 534109 CS−BEACH CLEANING−DESTIN 10/14 07/25/14 19 AJEJDF 4,852.05 ROLLOFF FEES TOTAL CS−BEACH CLEANING−DESTIN .00 4,852.05 .00 534110 CS−BEACH CLEAN−OK ISLAND 10/14 07/25/14 19 AJEJDF 1,494.57 ROLLOFF FEES TOTAL CS−BEACH CLEAN−OK ISLAND .00 1,494.57 .00 534111 CS−TURTLE WATCH PROGRAM 10/14 07/10/14 21 1406966 010554 GEORGE W GRAY 7,833.33 .00 TURTLE MONITORING TOTAL CS−TURTLE WATCH PROGRAM .00 7,833.33 .00 534500 CS−PERSONNEL 10/14 07/24/14 11 .00 ESTABLISH PER CD TOTAL CS−PERSONNEL .00 .00 .00 541011 CELLULAR PHONES/PAGERS 10/14 07/10/14 21 1407042 20900128 VERIZON WIRELESS 59.60 .00 5/24−6/23/14 TDD 10/14 07/31/14 21 1407470 20900128 VERIZON WIRELESS 40.01 .00 6/8−7/7/14 TDD TOTAL CELLULAR PHONES/PAGERS .00 99.61 .00 545990 INSURANCE−OTHER 10/14 07/01/14 19 BUDGET−5 43.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 43.00 .00 549906 BACKGROUND CHECKS 10/14 07/02/14 21 1406790 006534 FLORIDA DEPT OF 40.50 .00 TDD TOTAL BACKGROUND CHECKS .00 40.50 .00 563490 OTHER IMPROVEMENTS 10/14 07/16/14 13 −109,350.00 BT−14−43 10/14 07/17/14 21 1407182 013714 TAYLOR ENGINEERI 1,356.00 .00 TO9 OKAL ISL DUNE W/O 10/14 07/17/14 21 1407182 013714 TAYLOR ENGINEERI 4,045.00 .00 TO1 GREENSHORES PH1 TOTAL OTHER IMPROVEMENTS −109,350.00 5,401.00 .00 563753 ARTIFICIAL REEF 10/14 07/17/14 21 1407182 013714 TAYLOR ENGINEERI 1,027.50 .00 TO5 ARTIFICIAL REEF TOTAL ARTIFICIAL REEF .00 1,027.50 .00 581702 CITY OF DESTIN 10/14 07/31/14 21 V1407365 004710 CITY OF DESTIN 139,348.00 .00 W DESTIN BCH RESTORE TOTAL CITY OF DESTIN .00 139,348.00 .00 Packet Pg. 72 591001 BT−GENERAL FUND 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 19 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 591001 BT−GENERAL FUND 10/14 07/01/14 19 BUDGET−4 39,915.00 JULY 2014 10/14 07/16/14 13 138,300.00 BT−14−44 10/14 07/18/14 19 AJEJCG 138,300.00 BUDGET TRANSFER TOTAL BT−GENERAL FUND 138,300.00 178,215.00 .00 591201 BT−DEBT SERVICE FUND 10/14 07/01/14 19 BUDGET−4 27,101.00 JULY 2014 TOTAL BT−DEBT SERVICE FUND .00 27,101.00 .00 599010 RESERVE/CASH CARRYFORWARD 10/14 07/16/14 13 −138,300.00 BT−14−44 TOTAL RESERVE/CASH CARRYFORWARD −138,300.00 .00 .00 TOTAL 1ST TDT−BEACHES & PARKS −109,350.00 393,891.02 .00 Packet Pg. 73 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 20 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1176 − SPECIAL ASSESSMENT ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534003 CS−CONSULTING 10/14 07/24/14 21 1407342 21000287 WILLDAN FINANCIA 1,050.00 .00 SPEC DIST ADM2014/15 TOTAL CS−CONSULTING .00 1,050.00 .00 549004 COMMISSIONS−PROP APPRAISE 10/14 07/10/14 21 V1407020 004028 SMITH TIMOTHY P 1,418.84 .00 OKAL BCH RESTORE MSBU TOTAL COMMISSIONS−PROP APPRAISE .00 1,418.84 .00 549005 COMMISSIONS−TAX COLLECTOR 10/14 07/18/14 24 000004 BENJAMIN F ANDER 1.13 6/14 ACH TOTAL COMMISSIONS−TAX COLLECTOR .00 1.13 .00 591201 BT−DEBT SERVICE FUND 10/14 07/01/14 19 BUDGET−4 29,167.00 JULY 2014 TOTAL BT−DEBT SERVICE FUND .00 29,167.00 .00 TOTAL SPECIAL ASSESSMENT .00 31,636.97 .00 Packet Pg. 74 3.b.1 RUN DATE 08/20/2014 TIME 09:51:06 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 21 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534500 CS−PERSONNEL 10/14 07/17/14 20 1401173 20800182 LABOR READY SOUT −225.28 .00 CONV CTR 10/26/13 10/14 07/17/14 20 1401173 20800182 LABOR READY SOUT −225.28 .00 CONV CTR 11/1/13 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 434.56 .00 CONV CTR 6/15/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 628.08 .00 CONV CTR 6/22/14 10/14 07/17/14 21 1407155 20900514 TAMPA SERVICE CO 325.92 .00 CONV CTR 4/13/14 10/14 07/24/14 21 1407296 20900514 TAMPA SERVICE CO 638.26 .00 CONV CTR 6/29/14 10/14 07/25/14 19 CORJDC 450.56 RECLASS STALEDATED CHCKS TOTAL CS−PERSONNEL .00 2,026.82 .00 534607 CS−LAWN SERVICE 10/14 07/24/14 21 1407326 20501188 TRUGREEN COMPANI 745.00 .00 CONV CTR6052052247 TOTAL CS−LAWN SERVICE .00 745.00 .00 534900 CS−OTHER 10/14 07/02/14 21 1406748 21300706 AUS FLORIDA GROU 242.95 .00 792423935 CONV CTR 10/14 07/17/14 21 1407075 21300706 AUS FLORIDA GROU 242.95 .00 792423935 TDD 10/14 07/24/14 21 1407219 21300706 AUS FLORIDA GROU 242.95 .00 792423935TDD TOTAL CS−OTHER .00 728.85 .00 543001 UTILITIES−ELECTRIC 10/14 07/10/14 21 1406973 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 10/14 07/10/14 21 1406973 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 10/14 07/10/14 21 1406973 000387 GULF POWER COMPA 723.02 .00 1540 HIGHWAY 98 E 10/14 07/10/14 21 1406973 000387 GULF POWER COMPA 3,126.52 .00 1250 MIRACLE STRIP PKWY 10/14 07/17/14 21 1407129 000387 GULF POWER COMPA 23.05 .00 1250 MIRACLE STRIP PKWY 10/14 07/17/14 21 1407129 000387 GULF POWER COMPA 20,404.13 .00 1250 MIRACLE STRIP PKWY 10/14 08/07/14 21 1407712 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 10/14 08/07/14 21 1407712 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 10/14 08/07/14 21 1407712 000387 GULF POWER COMPA 854.91 .00 1540 HIGHWAY 98 E 10/14 08/07/14 21 1407712 000387 GULF POWER COMPA 3,126.52 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−ELECTRIC .00 28,344.31 .00 543002 UTILITIES−WATER 10/14 07/10/14 21 1406973 000387 GULF POWER COMPA 156.74 .00 1250 MIRACLE STRIP PKWY 10/14 08/07/14 21 1407712 000387 GULF POWER COMPA 220.45 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−WATER .00 377.19 .00 543004 UTILITIES−GARBAGE 10/14 07/10/14 21 1407057 006405 WASTE MANAGEMENT 240.55 .00 797092222331 TDD 10/14 07/10/14 21 1406912 20502035 ALLIED SERVICES 208.19 .00 ECCC 10/14 07/17/14 21 1407209 006405 WASTE MANAGEMENT 1,979.39 .00 800745522337 CONV CTR TOTAL UTILITIES−GARBAGE .00 2,428.13 .00 543005 UTILITIES−GAS Packet Pg. 75 10/14 07/17/14 21 1407154 003198 OKALOOSA GAS DIS 263.48 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−GAS .00 263.48 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 22 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 543005 UTILITIES−GAS (cont’d) 543010 UTILITIES−WATER & SEWER 10/14 07/16/14 19 W&S PMTS 74.90 485295−533830 10/14 07/16/14 19 W&S PMTS 4,975.09 901365−295770 TOTAL UTILITIES−WATER & SEWER .00 5,049.99 .00 544640 R/L−EQUIPMENT 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 825.28 .00 SUNBELT RENTALS INC PCG TOTAL R/L−EQUIPMENT .00 825.28 .00 546620 RM−FACILITIES 10/14 07/02/14 21 21401227−01 1406805 20801767 HY−TECH LANDSCAP 13,800.00 −13,800.00 PROVIDE ALL LABOR & MATER 10/14 07/10/14 21 1406945 001527 CRESTVIEW READY 472.00 .00 2500 R25−57 FIBER 10/14 07/17/14 21 21401443−01 21001779 SMALL MARKET MEE .00 .00 2014 BREAKFAST DAY 2 SPON 10/14 07/17/14 20 1401246 20701398 ZEE COMPANY INC −305.00 .00 NOV2013 BILLING 10/14 07/23/14 17 21401663−01 20500319 BEL−MAC ROOFING 2,400.00 REPAIR LEAKING ROOF PANEL 10/14 07/24/14 21 1407264 014586 HILLER SYSTEMS I 54.00 .00 ECCC 10/14 07/25/14 19 CORJDC 305.00 RECLASS STALEDATED CHCKS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 29.88 .00 CRESTVIEW WHOLESALE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 29.96 .00 CRESTVIEW WHOLESALE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 50.09 .00 CRESTVIEW WHOLESALE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 27.74 .00 HOLLYWOOD PAINT & COLOR 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 67.86 .00 HOLLYWOOD PAINT & COLOR 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 83.15 .00 1000BULBS.COM 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 225.00 .00 BRYAN PEST CONTROL 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 450.00 .00 HEROMAN SERVICES 10/14 07/31/14 21 1407406 014586 HILLER SYSTEMS I 110.50 .00 TDD TOTAL RM−FACILITIES .00 15,400.18 −11,400.00 546640 RM−EQUIPMENT 10/14 07/17/14 20 1401182 21300731 MOWREY ELEVATOR −125.00 .00 CONV CTR 10/14 07/25/14 19 CORJDC 125.00 RECLASS STALEDATED CHCKS 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 27.00 .00 OK TIRE STORE OF FWB 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 104.95 .00 TTCO MOBILE SVC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 118.84 .00 WISE EQUIPMENT SALES & 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 153.75 .00 SUNBELT RENTALS #268 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 187.16 .00 DEES PAPER COMPANY INC 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 387.50 .00 MOWERY ELEVATOR COMPANY O 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 637.90 .00 PR CHEMICAL & PAPER SUPPL 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 756.40 .00 JEFCO AIR CONDITIONING & 10/14 07/31/14 21 1407430 21300731 MOWREY ELEVATOR 125.00 .00 ECCC TOTAL RM−EQUIPMENT .00 2,498.50 .00 546644 RM−VEHICLES−FLEET Packet Pg. 76 10/14 08/12/14 19 FLT BILL 206.35 JULY 14 FLEET BILL TOTAL RM−VEHICLES−FLEET .00 206.35 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 23 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 546644 RM−VEHICLES−FLEET (cont’d) 548001 PROMOTIONAL ACTIVITIES 10/14 07/17/14 21 21401443−01 21001779 SMALL MARKET MEE .00 .00 CHANGE ORDER − 2 TOTAL PROMOTIONAL ACTIVITIES .00 .00 .00 552010 FLEET FUEL 10/14 08/12/14 19 FLT BILL 99.50 JULY 14 FLEET BILL TOTAL FLEET FUEL .00 99.50 .00 552700 JANITORIAL SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 165.54 .00 STEWART’S PACKAGING, INC. 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 486.35 .00 SUPREME PAPER SUPPLIES 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 608.96 .00 SUPREME PAPER SUPPLIES TOTAL JANITORIAL SUPPLIES .00 1,260.85 .00 552751 C.C. SPECIAL EVENTS 10/14 07/17/14 21 21401443−01 21001779 SMALL MARKET MEE .00 .00 CHANGE ORDER − 1 10/14 07/17/14 17 21401643−01 20201404 EXECUTIVE OFFICE 5,113.80 CHAIR, MANAGERIAL, BLACK, 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 12.98 .00 RACETRACK ACE HARDWARE 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 23.76 .00 LOWES #00479 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 28.70 .00 GATLIN LUMBER AND SUPPLY 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 88.33 .00 LOWES #00479 10/14 07/29/14 21 V2140238 014799 BANK OF AMERICA 104.93 .00 LOWES #00479 TOTAL C.C. SPECIAL EVENTS .00 258.70 5,113.80 562790 OTHER CONSTRUCTION 10/14 07/10/14 21 001WELCOME 21400154 GENESIS CEI SERV 1,350.00 .00 TO1 WELCOME/VISITOR 10/14 07/10/14 21 001WELCOME 21400154 GENESIS CEI SERV −1,350.00 .00 TO1 WELCOME/VISITOR 10/14 07/10/14 21 001WELCOME 21400154 GENESIS CEI SERV .00 .00 TO1 WELCOME/VISITOR 10/14 07/10/14 21 V1406965 008408 GGI LLC D/B/A GE 1,350.00 .00 TO#1 WELCOME/VISITOR 10/14 07/17/14 21 1407073 21400262 AMERITECH ENTERP 26,090.00 .00 REROOF WELCOME CTR 10/14 07/17/14 21 1407073 21400262 AMERITECH ENTERP 45,850.00 .00 REROOF WELCOME CTR TOTAL OTHER CONSTRUCTION .00 73,290.00 .00 TOTAL 3RD TDT−C.C. MAINTENANCE .00 133,803.13 −6,286.20 Packet Pg. 77 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 24 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1179 − 4TH TDT−C.C. CAPITAL ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 563710 OUTDOOR EXHIBITION PAD 10/14 07/10/14 21 1406967 006087 GULF ATLANTIC CO 102,744.02 .00 MARLER RAMP OUTDOOR 10/14 07/10/14 17 21401619−01 014452 HARRIS FENCE INS 6,865.00 PROVIDE ALL LABOR & MATER 10/14 07/24/14 21 E1407255 002982 FORT WALTON CONC 768.00 .00 2500 PSI/FIBER TOTAL OUTDOOR EXHIBITION PAD .00 103,512.02 6,865.00 563790 OTHER IMPROVEMENTS 10/14 07/17/14 21 1407132 014984 HDR ENGINEERING 1,357.88 .00 TO67 MARLER BOAT RAMP 10/14 07/17/14 21 1407132 014984 HDR ENGINEERING 2,795.75 .00 TO67 MARLER BOAT RAMP TOTAL OTHER IMPROVEMENTS .00 4,153.63 .00 TOTAL 4TH TDT−C.C. CAPITAL .00 107,665.65 6,865.00 Packet Pg. 78 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 25 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 711242 − FDOT URBAN CORR 12 (O) ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 547002 PRINTING & BINDING 10/14 07/02/14 21 21401470−01 1406845 21300007 INTERMOUNTAIN CO 424.35 −424.35 8" X 10.50 RIDE GUIDE, MA TOTAL PRINTING & BINDING .00 424.35 −424.35 TOTAL FDOT URBAN CORR 12 (O) .00 424.35 −424.35 Packet Pg. 79 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **July Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 26 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:51:03 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’10’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 711470 − FDEP DUNE WALKOVERS (C) ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 563790 OTHER IMPROVEMENTS 10/14 07/16/14 11 109,350.00 BT−14−43 10/14 07/16/14 13 109,350.00 BA−#117 TOTAL OTHER IMPROVEMENTS 218,700.00 .00 .00 TOTAL FDEP DUNE WALKOVERS (C) 218,700.00 .00 .00 TOTAL TOURIST DEVELOPMENT FUND 109,350.00 1,432,437.11 −26,797.35 TOTAL REPORT 109,350.00 1,432,437.11 −26,797.35 Packet Pg. 80 3.b.1 RUN DATE 08/20/2014 TIME 09:51:07 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 1 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/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 9 /14 06/05/14 21 V1406106 21200456 GAIL MORGAN 3,166.67 .00 FILM COMMISSION SVCS TOTAL CS−CONSULTING .00 3,166.67 .00 534018 CS−CHAMBER OF COMMERCE 9 /14 06/25/14 20 E1403670 002981 FWB CHAMBER OF C −5,000.00 .00 OCT−DEC2013 9 /14 06/25/14 20 E1404771 002981 FWB CHAMBER OF C −5,000.00 .00 JAN−MAR2014 TOTAL CS−CHAMBER OF COMMERCE .00 −10,000.00 .00 534500 CS−PERSONNEL 9 /14 06/05/14 21 1406101 21101150 LANDRUM STAFFING 230.40 .00 HALSEY 5/17/14 9 /14 06/05/14 21 V1406100 009350 KELLY SERVICES,I 329.08 .00 LISHEFSKI 5/11/14 9 /14 06/05/14 21 V1406100 009350 KELLY SERVICES,I 372.90 .00 THATCHER 5/11/14 9 /14 06/05/14 21 V1406100 009350 KELLY SERVICES,I 415.68 .00 WARDLOW 5/18/14 9 /14 06/05/14 21 V1406100 009350 KELLY SERVICES,I 692.80 .00 WARDLOW 5/11/14 9 /14 06/12/14 21 V1406254 009350 KELLY SERVICES,I 415.68 .00 LATIMER 5/25/14 9 /14 06/12/14 21 V1406254 009350 KELLY SERVICES,I 692.80 .00 WARDLOW 5/25/14 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 5/24/14 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 5/17/14 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 100.80 .00 HALSEY 5/31/14 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 5/31/14 9 /14 06/18/14 21 1406433 21101150 LANDRUM STAFFING 100.80 .00 HALSEY 6/7/14 9 /14 06/18/14 21 V1406431 009350 KELLY SERVICES,I 554.24 .00 WARDLOW 6/1/14 9 /14 06/18/14 21 1406433 21101150 LANDRUM STAFFING 955.28 .00 NIXON 4/26/14 9 /14 06/18/14 21 1406433 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 6/7/14 9 /14 06/23/14 19 COR9CD 1,222.73 RECLASS 9 /14 06/25/14 21 V1406574 009350 KELLY SERVICES,I 121.24 .00 LATIMER 6/8/14 9 /14 06/25/14 21 V1406574 009350 KELLY SERVICES,I 554.24 .00 WARDLOW 6/8/14 9 /14 06/25/14 21 1406576 21101150 LANDRUM STAFFING 1,064.00 .00 NIXON 6/14/14 TOTAL CS−PERSONNEL .00 12,078.67 .00 545990 INSURANCE−OTHER 9 /14 06/03/14 19 BUDGET−5 62.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 62.00 .00 548001 PROMOTIONAL ACTIVITIES 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 3.00 .00 DOLRTREE 3577 00035774 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 4.00 .00 DOLLAR−GENERAL #7232 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 12.97 .00 JOANN FABRIC #0816 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 13.44 .00 WM SUPERCENTER #944 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 77.59 .00 PARTY CITY #295 TOTAL PROMOTIONAL ACTIVITIES .00 111.00 .00 548010 AGENCY BASE SVCS−MONTHLY 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 174.74 .00 APRIL CHGS Packet Pg. 81 TOTAL AGENCY BASE SVCS−MONTHLY .00 174.74 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:22 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 2 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548020 WEBSITE DEV & MAINTENANCE 548020 WEBSITE DEV & MAINTENANCE 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 478.83 .00 TO17 WEBSITE HOSTING 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 486.33 .00 TI17 WEBSITE HOSTING 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 19.00 .00 DIGITAL FORTRESS, INC. 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 239.85 .00 NETWORK SOLUTIONS, LLC TOTAL WEBSITE DEV & MAINTENANCE .00 1,224.01 .00 548040 PUBLIC RELATIONS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 150.00 .00 CASS DATA & MAILING SERVI TOTAL PUBLIC RELATIONS .00 150.00 .00 548042 FALL CAMPAIGN 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 1.34 .00 TO115 MEDIA 2014 TOTAL FALL CAMPAIGN .00 1.34 .00 548043 CHRISTMAS CAMPAIGN 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 1,868.75 .00 TO46 CHRISTMAS MEDIA 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 640.00 .00 TO75R CHRISTMAS 2013 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 970.00 .00 TO75 INTERACTIVE MEDI TOTAL CHRISTMAS CAMPAIGN .00 3,478.75 .00 548044 SNOWBIRD CAMPAIGN 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 2.08 .00 TO115 MEDIA 2014 TOTAL SNOWBIRD CAMPAIGN .00 2.08 .00 548045 SPRING CAMPAIGN 9 /14 06/06/14 19 COR9AA −2,850.39 RECLASS SPRING CAMPAIGN TOTAL SPRING CAMPAIGN .00 −2,850.39 .00 548046 SUMMER CAMPAIGN 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 497.93 .00 TO115 MEDIA 2014 9 /14 06/06/14 19 COR9AA 2,850.39 RECLASS SPRING CAMPAIGN 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 77,454.00 .00 TO113R LEISURE E25 TOTAL SUMMER CAMPAIGN .00 80,802.32 .00 548047 NON−SEASONAL 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 42.73 .00 TO115 MEDIA 2014 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 23,438.80 .00 TO115 LEISURE ONLINE 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 2,488.00 .00 TO113 LEISURE E25 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 26,557.45 .00 TO113R LEISURE E25 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 52,063.32 .00 TO115FY14LEISURE O/LI TOTAL NON−SEASONAL .00 104,590.30 .00 548049 BRANDING Packet Pg. 82 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 862.50 .00 TO123BRAND RADIO TOTAL BRANDING .00 862.50 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 3 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1151 − 5TH TDT−TOURISM PROMOTION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548049 BRANDING (cont’d) 548051 CAMPAIGN PRODUCTION 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 289.57 .00 TO135 OUTSIDE EXPENSE TOTAL CAMPAIGN PRODUCTION .00 289.57 .00 549906 BACKGROUND CHECKS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 24.00 .00 FDLE CCHINET TOTAL BACKGROUND CHECKS .00 48.00 .00 TOTAL 5TH TDT−TOURISM PROMOTION .00 194,191.56 .00 Packet Pg. 83 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 4 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 9 /14 06/11/14 22 12,179.44 PAYROLL CHARGES 9 /14 06/25/14 22 12,325.10 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 24,504.54 .00 512020 SALARIES/WAGES−PART−TIME 9 /14 06/11/14 22 319.71 PAYROLL CHARGES 9 /14 06/25/14 22 314.24 PAYROLL CHARGES TOTAL SALARIES/WAGES−PART−TIME .00 633.95 .00 521000 FICA TAXES 9 /14 06/11/14 22 928.74 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 939.46 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 1,868.20 .00 522000 RETIREMENT CONTRIBUTIONS 9 /14 06/11/14 22 1,456.52 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 1,466.26 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 2,922.78 .00 523000 LIFE & HEALTH INSURANCE 9 /14 06/11/14 22 1,450.00 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 60.60 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 11.55 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 11.50 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 50.00 PAYROLL CHARGES 9 /14 06/25/14 22 1,450.00 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 60.60 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 11.55 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 11.50 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 50.00 PAYROLL CHARGES TOTAL LIFE & HEALTH INSURANCE .00 3,167.30 .00 523012 CONTRA L&H INS (REBATE) 9 /14 06/12/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI 9 /14 06/26/14 19 REBATE −80.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −160.00 .00 524000 WORKERS’ COMPENSATION 9 /14 06/03/14 19 BUDGET−3 151.00 JUNE 2014 TOTAL WORKERS’ COMPENSATION .00 151.00 .00 525000 UNEMPLOYMENT COMPENSATION 9 /14 06/13/14 11 .00 ESTABLISH PER BILLING 9 /14 06/13/14 19 UNEMP 3,295.50 D OBYRNE Packet Pg. 84 TOTAL UNEMPLOYMENT COMPENSATION .00 3,295.50 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 5 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 531001 PS−ATTORNEY−OTHER 531001 PS−ATTORNEY−OTHER 9 /14 06/19/14 21 V1406444 010277 NABORS,GIBLIN & 4,485.75 .00 ZIMMERMAN 9 /14 06/25/14 21 V1406584 010277 NABORS,GIBLIN & 11,117.64 .00 ZIMMERMAN TOTAL PS−ATTORNEY−OTHER .00 15,603.39 .00 531552 PS−COMM & RESEARCH 9 /14 06/11/14 18 21400590−01 21100370 SMITH TRAVEL RES −2,295.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21400590−01 1406298 21100370 SMITH TRAVEL RES 8,249.64 −20,350.00 SMITH TRAVEL RESEARCH REP TOTAL PS−COMM & RESEARCH .00 8,249.64 −22,645.00 534001 CS−GENERAL FUND ADMIN 9 /14 06/03/14 19 BUDGET−1 33,248.00 GEN FUND ADMINISTRATION TOTAL CS−GENERAL FUND ADMIN .00 33,248.00 .00 534500 CS−PERSONNEL 9 /14 06/12/14 21 V1406254 009350 KELLY SERVICES,I 692.80 .00 WARDLOW 3/30/14 9 /14 06/23/14 19 COR9CD −1,222.73 RECLASS TOTAL CS−PERSONNEL .00 −529.93 .00 540001 TRAVEL IN−COUNTY 9 /14 06/12/14 21 1406355 EMP00207 AIDA WILKINSON 15.68 .00 FWB/NCVILE/EXRCISE TOTAL TRAVEL IN−COUNTY .00 15.68 .00 541010 COMMUNICATIONS SERVICE 9 /14 06/05/14 21 1406055 002790 COX COMMUNICATIO 8.50 .00 TDD 9 /14 06/05/14 21 1406038 001337 AT&T CORP 84.55 .00 TDD 9 /14 06/25/14 21 1406513 001337 AT&T CORP 110.07 .00 TDD TOTAL COMMUNICATIONS SERVICE .00 203.12 .00 541011 CELLULAR PHONES/PAGERS 9 /14 06/05/14 21 1406145 20900128 VERIZON WIRELESS 200.05 .00 4/8−5/7/14 TDD 9 /14 06/12/14 19 MOBILEDV −10.00 6/12/14 MOBILE DEVICE 9 /14 06/12/14 21 1406335 20900128 VERIZON WIRELESS 238.40 .00 4/24−5/23/14 TDD 9 /14 06/25/14 21 1406622 20900128 VERIZON WIRELESS 76.17 .00 5/8−6/7/14 TDD 9 /14 06/25/14 13 2,951.00 BT−CA−14−28 9 /14 06/26/14 19 MOBILEDV −10.00 6/26/14 MOBILE DEVICE TOTAL CELLULAR PHONES/PAGERS 2,951.00 494.62 .00 542001 POSTAGE/FREIGHT CHARGES 9 /14 06/12/14 21 1406214 000362 FEDERAL EXPRESS 179.46 .00 148498911 TDD TOTAL POSTAGE/FREIGHT CHARGES .00 179.46 .00 544620 R/L−BUILDINGS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 690.00 .00 A STORAGE SOLUTIONS OF DE Packet Pg. 85 TOTAL R/L−BUILDINGS .00 690.00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 6 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 544640 R/L−EQUIPMENT 544640 R/L−EQUIPMENT 9 /14 06/25/14 21 1406596 015019 PITNEY BOWES GLO 1,116.00 .00 MAR−JUN 2014 9 /14 06/25/14 13 363.00 BT−CA−14−28 TOTAL R/L−EQUIPMENT 363.00 1,116.00 .00 545990 INSURANCE−OTHER 9 /14 06/03/14 19 BUDGET−5 434.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 434.00 .00 546644 RM−VEHICLES−FLEET 9 /14 07/14/14 19 FLT BILL 95.16 JUNE 14 FLEET BILL TOTAL RM−VEHICLES−FLEET .00 95.16 .00 547002 PRINTING & BINDING 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 379.94 .00 COAST TO COAST COMPUTE TOTAL PRINTING & BINDING .00 379.94 .00 549900 MISCELLANEOUS CHARGES 9 /14 06/25/14 21 1406543 21400245 DESTIN REPORTING 625.75 .00 TDD TOTAL MISCELLANEOUS CHARGES .00 625.75 .00 549901 LEGAL ADVERTISING 9 /14 06/12/14 21 1406233 21201551 HALIFAX MEDIA GR 39.20 .00 TDD/34646889 LEG6084 TOTAL LEGAL ADVERTISING .00 39.20 .00 549905 MOTOR VEHICLE REPORTS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 15.69 .00 ACCUFACTS PRE EMPLOYMENT TOTAL MOTOR VEHICLE REPORTS .00 15.69 .00 551001 OFFICE SUPPLIES 9 /14 06/25/14 13 −3,314.00 BT−CA−14−28 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 25.49 .00 STAPLES 00118828 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 89.15 .00 STAPLS3145364454000 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 486.40 .00 COPY PRODUCTS COMPANY PEN TOTAL OFFICE SUPPLIES −3,314.00 601.04 .00 552010 FLEET FUEL 9 /14 07/14/14 19 FLT BILL 350.01 JUNE 14 FLEET BILL TOTAL FLEET FUEL .00 350.01 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 9 /14 06/12/14 21 1406346 013788 FLORIDA TOURISM 1,020.84 .00 JUL−SEP2014 MBRSHP TOTAL BOOK/PUB/SUB/MEMBERSHIPS .00 1,020.84 .00 Packet Pg. 86 581210 DESTIN FIRE DEPARTMENT 9 /14 06/12/14 21 1406200 010851 DESTIN FIRE CONT 58,326.88 .00 BS/LIFEGUARD APR2014 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 7 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1152 − 2ND TDT−ADMINISTRATION ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 581210 DESTIN FIRE DEPARTMENT (cont’d) 9 /14 06/19/14 21 1406395 010851 DESTIN FIRE CONT 58,326.88 .00 MAY2014 TOTAL DESTIN FIRE DEPARTMENT .00 116,653.76 .00 591001 BT−GENERAL FUND 9 /14 06/03/14 19 BUDGET−4 45,961.00 JUNE 2014 TOTAL BT−GENERAL FUND .00 45,961.00 .00 TOTAL 2ND TDT−ADMINISTRATION .00 261,829.64 −22,645.00 Packet Pg. 87 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 8 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1158 − BP & FCNC COUNCIL FY11 ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548001 PROMOTIONAL ACTIVITIES 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 298.66 .00 TO115 MEDIA 2014 TOTAL PROMOTIONAL ACTIVITIES .00 298.66 .00 TOTAL BP & FCNC COUNCIL FY11 .00 298.66 .00 Packet Pg. 88 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 9 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 9 /14 06/11/14 22 5,389.60 PAYROLL CHARGES 9 /14 06/25/14 22 5,389.60 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 10,779.20 .00 521000 FICA TAXES 9 /14 06/11/14 22 390.29 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 390.29 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 780.58 .00 522000 RETIREMENT CONTRIBUTIONS 9 /14 06/11/14 22 374.58 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 374.58 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 749.16 .00 523000 LIFE & HEALTH INSURANCE 9 /14 06/11/14 22 1,087.50 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 36.36 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 6.93 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 6.90 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 1,087.50 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 36.36 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 6.93 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 6.90 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 2,275.38 .00 523012 CONTRA L&H INS (REBATE) 9 /14 06/12/14 19 REBATE −60.00 INSURANCE REBATE ALLOCATI 9 /14 06/26/14 19 REBATE −60.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −120.00 .00 524000 WORKERS’ COMPENSATION 9 /14 06/03/14 19 BUDGET−3 47.00 JUNE 2014 TOTAL WORKERS’ COMPENSATION .00 47.00 .00 540002 TRAVEL OUT−OF−COUNTY 9 /14 06/05/14 21 1406122 EMP00269 APRIL SARVER 86.00 .00 WASH DC 5/14−16/14 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 15.92 .00 TAXI MAGIC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 17.84 .00 DC TAXI J708 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 21.00 .00 RPS NW FL REGIONAL AP EGL 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 25.00 .00 DELTA AIR 0068241429958 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 25.00 .00 DELTA AIR 0068240398877 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 25.00 .00 AMERICAN AI 0010266667973 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 36.00 .00 RPS PENSACOLA REGIONAL AP 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 348.00 .00 DELTA AIR 0062359951842 Packet Pg. 89 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 348.50 .00 DELTA AIR 0062360524287 TOTAL TRAVEL OUT−OF−COUNTY .00 948.26 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:23 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 10 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 540002 TRAVEL OUT−OF−COUNTY (cont’d) 540005 TRAVEL LODGING EXPENSES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 458.46 .00 ADOBA ECO HOTEL − RAPID 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 661.82 .00 EMBASSY SUITES CNV CTR TOTAL TRAVEL LODGING EXPENSES .00 1,120.28 .00 541011 CELLULAR PHONES/PAGERS 9 /14 06/05/14 21 1406145 20900128 VERIZON WIRELESS 80.02 .00 4/8−5/7/14 TDD 9 /14 06/12/14 21 1406335 20900128 VERIZON WIRELESS 80.02 .00 4/24−5/23/14 TDD 9 /14 06/12/14 21 1406337 20900128 VERIZON WIRELESS 99.20 .00 4/24−5/23/14 CONV CTR 9 /14 06/25/14 21 1406622 20900128 VERIZON WIRELESS 80.02 .00 5/8−6/7/14 TDD TOTAL CELLULAR PHONES/PAGERS .00 339.26 .00 542001 POSTAGE/FREIGHT CHARGES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 378.69 .00 HARGROVE INC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 387.05 .00 HARGROVE INC TOTAL POSTAGE/FREIGHT CHARGES .00 765.74 .00 544620 R/L−BUILDINGS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 210.00 .00 A STORAGE SOLUTIONS OF DE TOTAL R/L−BUILDINGS .00 210.00 .00 545990 INSURANCE−OTHER 9 /14 06/03/14 19 BUDGET−5 60.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 60.00 .00 547002 PRINTING & BINDING 9 /14 06/19/14 21 21401422−01 1406465 21400218 ROGERS PRINTING 2,499.00 −2,499.00 FLOOR PLAN BROCHURE (TO I 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 112.50 .00 MEDLEY PRINTING INC 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 115.00 .00 SQ PRINTPRO LLC TOTAL PRINTING & BINDING .00 2,726.50 −2,499.00 548001 PROMOTIONAL ACTIVITIES 9 /14 06/19/14 21 1406494 013788 FLORIDA TOURISM 2,385.50 .00 ADVANCE PAYMENT 9 /14 06/23/14 21 21401362−01 013788 FLORIDA TOURISM .00 −272.35 8.5 X 11 BROCHURE SLOT AT 9 /14 06/23/14 21 21401362−02 013788 FLORIDA TOURISM .00 −272.35 8.5 X 11 BROCHURE SLOT AT 9 /14 06/23/14 21 21401362−03 013788 FLORIDA TOURISM .00 −236.25 11 X 14 TRANSPARENCY SLOT 9 /14 06/23/14 21 21401362−04 013788 FLORIDA TOURISM .00 −472.50 30 X 20 TRANSPARENCY SLOT 9 /14 06/23/14 21 21401362−05 013788 FLORIDA TOURISM .00 −272.35 8.5 X 11 BROCHURE SLOT AT 9 /14 06/23/14 21 21401362−06 013788 FLORIDA TOURISM .00 −272.35 8.5 X 11 BROCHURE SLOT AT 9 /14 06/23/14 21 21401362−07 013788 FLORIDA TOURISM .00 −272.35 8.5 X 11 BROCHURE SLOT AT 9 /14 06/23/14 21 21401362−08 013788 FLORIDA TOURISM .00 −315.00 41 X 26 TRANSPARENCY SLOT 9 /14 06/25/14 21 21401145−01 1406611 21100996 STAPLES ADVANTAG 1,398.83 −2,625.00 WATERPROOF PHONE BAG WITH 9 /14 06/25/14 21 21401145−02 1406611 21100996 STAPLES ADVANTAG 839.30 −1,575.00 MULTI−COLOR BEACH BALLS W Packet Pg. 90 9 /14 06/25/14 21 21401145−03 1406611 21100996 STAPLES ADVANTAG 83.93 −157.50 FREIGHT −PHONE BAG 9 /14 06/25/14 21 21401145−04 1406611 21100996 STAPLES ADVANTAG 53.30 −100.02 FREIGHT− BEACH BALL 3.b.1 RUN DATE 08/20/2014 TIME 09:50:24 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 11 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548001 PROMOTIONAL ACTIVITIES (cont’d) 9 /14 06/25/14 21 21401145−05 1406611 21100996 STAPLES ADVANTAG 26.64 −50.00 ART WORK PHONE BAG 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 43.54 .00 ULINE SHIP SUPPLIES TOTAL PROMOTIONAL ACTIVITIES .00 4,831.04 −6,893.02 548002 EVENT PROMOTIONAL ACTIVTY 9 /14 06/10/14 17 21401421−01 20801842 BRENDON GRIMES D 65.95 CHANGE ORDER − 1 9 /14 06/10/14 17 21401421−02 20801842 BRENDON GRIMES D 520.95 CHANGE ORDER − 1 9 /14 06/10/14 17 21401421−03 20801842 BRENDON GRIMES D 520.95 CHANGE ORDER − 1 9 /14 06/10/14 17 21401421−04 20801842 BRENDON GRIMES D 34.95 CHANGE ORDER − 1 9 /14 06/10/14 17 21401466−01 21400226 TERRE L CARR D/B 1,375.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401466−02 21400226 TERRE L CARR D/B 475.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401466−03 21400226 TERRE L CARR D/B 100.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401466−04 21400226 TERRE L CARR D/B 25.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401435−01 21400222 JENNIFER CHAPARR 2,000.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401398−01 21400216 SAND ODYSSEY 930.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401397−01 21400215 GLEN E GUARIN 800.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401439−01 21001211 NATIONWIDE TENTS 2,000.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401439−02 21001211 NATIONWIDE TENTS 1,200.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401439−03 21001211 NATIONWIDE TENTS 600.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−01 21200115 APPLAUSE PRODUCT 400.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−02 21200115 APPLAUSE PRODUCT 240.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−03 21200115 APPLAUSE PRODUCT 240.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−04 21200115 APPLAUSE PRODUCT 456.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−08 21200115 APPLAUSE PRODUCT 351.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−12 21200115 APPLAUSE PRODUCT 300.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−13 21200115 APPLAUSE PRODUCT 72.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−14 21200115 APPLAUSE PRODUCT 162.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−15 21200115 APPLAUSE PRODUCT 21.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−18 21200115 APPLAUSE PRODUCT 1,200.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−19 21200115 APPLAUSE PRODUCT 600.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−20 21200115 APPLAUSE PRODUCT 1,620.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−21 21200115 APPLAUSE PRODUCT 140.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−22 21200115 APPLAUSE PRODUCT 420.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−23 21200115 APPLAUSE PRODUCT 200.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−24 21200115 APPLAUSE PRODUCT 200.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−29 21200115 APPLAUSE PRODUCT 500.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−30 21200115 APPLAUSE PRODUCT 200.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−31 21200115 APPLAUSE PRODUCT 100.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−33 21200115 APPLAUSE PRODUCT 75.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−34 21200115 APPLAUSE PRODUCT 140.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−35 21200115 APPLAUSE PRODUCT 260.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−36 21200115 APPLAUSE PRODUCT 75.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−37 21200115 APPLAUSE PRODUCT 700.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−38 21200115 APPLAUSE PRODUCT 150.00 CHANGE ORDER − 1 Packet Pg. 91 9 /14 06/10/14 17 21401423−39 21200115 APPLAUSE PRODUCT 875.00 CHANGE ORDER − 1 9 /14 06/10/14 17 21401423−40 21200115 APPLAUSE PRODUCT 2,036.37 CHANGE ORDER − 1 3.b.1 RUN DATE 08/20/2014 TIME 09:50:25 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 12 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548002 EVENT PROMOTIONAL ACTIVTY (cont’d) 9 /14 06/11/14 17 21401472−01 21400228 JAMES B DYESS D/ 450.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401439−01 1406269 21001211 NATIONWIDE TENTS 2,000.00 −2,000.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401439−02 1406269 21001211 NATIONWIDE TENTS 1,200.00 −1,200.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401439−03 1406269 21001211 NATIONWIDE TENTS 600.00 −600.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401466−01 1406193 21400226 TERRE L CARR D/B 1,375.00 −1,375.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401466−02 1406193 21400226 TERRE L CARR D/B 475.00 −475.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401466−03 1406193 21400226 TERRE L CARR D/B 100.00 −100.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401466−04 1406193 21400226 TERRE L CARR D/B 25.00 −25.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401472−01 1406249 21400228 JAMES B DYESS D/ 450.00 −450.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−01 1406296 21200115 APPLAUSE PRODUCT 400.00 −400.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−02 1406296 21200115 APPLAUSE PRODUCT 240.00 −240.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−03 1406296 21200115 APPLAUSE PRODUCT 240.00 −240.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−04 1406296 21200115 APPLAUSE PRODUCT 456.00 −456.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−08 1406296 21200115 APPLAUSE PRODUCT 351.00 −351.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−12 1406296 21200115 APPLAUSE PRODUCT 300.00 −300.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−13 1406296 21200115 APPLAUSE PRODUCT 72.00 −72.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−14 1406296 21200115 APPLAUSE PRODUCT 162.00 −162.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−15 1406296 21200115 APPLAUSE PRODUCT 21.00 −21.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−18 1406296 21200115 APPLAUSE PRODUCT 1,200.00 −1,200.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−19 1406296 21200115 APPLAUSE PRODUCT 600.00 −600.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−20 1406296 21200115 APPLAUSE PRODUCT 1,620.00 −1,620.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−21 1406296 21200115 APPLAUSE PRODUCT 140.00 −140.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−22 1406296 21200115 APPLAUSE PRODUCT 420.00 −420.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−23 1406296 21200115 APPLAUSE PRODUCT 200.00 −200.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−24 1406296 21200115 APPLAUSE PRODUCT 200.00 −200.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−29 1406296 21200115 APPLAUSE PRODUCT 500.00 −500.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−30 1406296 21200115 APPLAUSE PRODUCT 200.00 −200.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−31 1406296 21200115 APPLAUSE PRODUCT 100.00 −100.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−33 1406296 21200115 APPLAUSE PRODUCT 75.00 −75.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−34 1406296 21200115 APPLAUSE PRODUCT 140.00 −140.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−35 1406296 21200115 APPLAUSE PRODUCT 260.00 −260.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−36 1406296 21200115 APPLAUSE PRODUCT 75.00 −75.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−37 1406296 21200115 APPLAUSE PRODUCT 700.00 −700.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−38 1406296 21200115 APPLAUSE PRODUCT 150.00 −150.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−39 1406296 21200115 APPLAUSE PRODUCT 875.00 −875.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401423−40 1406296 21200115 APPLAUSE PRODUCT 2,036.37 −2,036.37 CHANGE ORDER − 1 9 /14 06/12/14 21 21401315−01 1406163 21400211 ALEX LAU FILM PR 1,350.00 −1,350.00 PHOTOGRAPHER FOR GRAND OP 9 /14 06/12/14 21 21401397−01 1406180 21400215 GLEN E GUARIN 800.00 −800.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401435−01 1406165 21400222 JENNIFER CHAPARR 2,000.00 −2,000.00 CHANGE ORDER − 1 9 /14 06/13/14 20 21401397−01 1406180 21400215 GLEN E GUARIN −800.00 800.00 CHANGE ORDER − 1 9 /14 06/19/14 21 1406396 21400237 RICHARD SMITH 800.00 .00 CREATE PLAZA LOGO 9 /14 06/19/14 21 21401397−01 V1406413 21400215 GLEN E GUARIN 800.00 −800.00 CHANGE ORDER − 1 9 /14 06/19/14 21 21401398−01 1406467 21400216 SAND ODYSSEY 930.00 −930.00 CHANGE ORDER − 1 9 /14 06/19/14 21 21401421−01 1406487 20801842 BRENDON GRIMES D 65.95 −65.95 CHANGE ORDER − 1 Packet Pg. 92 9 /14 06/19/14 21 21401421−02 1406487 20801842 BRENDON GRIMES D 520.95 −520.95 CHANGE ORDER − 1 9 /14 06/19/14 21 21401421−03 1406487 20801842 BRENDON GRIMES D 520.95 −520.95 CHANGE ORDER − 1 3.b.1 RUN DATE 08/20/2014 TIME 09:50:25 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 13 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548002 EVENT PROMOTIONAL ACTIVTY (cont’d) 9 /14 06/19/14 21 21401421−04 1406487 20801842 BRENDON GRIMES D 34.95 −34.95 CHANGE ORDER − 1 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 24.00 .00 TARGET 00007401 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 29.40 .00 USPS 11225009533008616 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 33.94 .00 JOANN FABRIC #0816 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 50.28 .00 WM SUPERCENTER #3439 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 241.43 .00 IMAGE PRINTING & DIGITAL 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 716.22 .00 IMAGE PRINTING & DIGITAL 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 784.87 .00 4IMPRINT TOTAL EVENT PROMOTIONAL ACTIVTY .00 26,861.31 −1,350.00 548003 TRADE SHOW FEES 9 /14 06/05/14 21 1406032 20101467 AMERICAN BUS ASS 1,345.00 .00 REGISTRATION 9 /14 06/12/14 21 1406224 21100354 GROUP LEADERS OF 1,195.00 .00 REGISTRATION 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 225.00 .00 BARTIZAN 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 1,175.00 .00 ALABAMA MOTORCOACH ASSO TOTAL TRADE SHOW FEES .00 3,940.00 .00 548010 AGENCY BASE SVCS−MONTHLY 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 174.74 .00 APRIL CHGS TOTAL AGENCY BASE SVCS−MONTHLY .00 174.74 .00 548048 GROUP & CONVEN CAMPAIGN 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 275.00 .00 TO124 JAN−DEC PRINTS 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 406.61 .00 TO115 MEDIA 2014 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 1,168.00 .00 TO119 JAN−DEC PRINT 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 1,293.75 .00 TO99 CREATIVE SVCS 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 1,359.15 .00 TO122 TRAVL MEDIA 9 /14 06/05/14 21 1406117 21300295 PETER A MAYER AD 2,695.00 .00 TO119 JAN−DEC PRINTS 9 /14 06/11/14 17 21401443−01 21001779 SMALL MARKET MEE 5,000.00 CHANGE ORDER − 3 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 5,500.00 .00 TO120JAN−DEC PRINT14 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 5,500.00 .00 TO96JAN−DEC GROUPS TOTAL GROUP & CONVEN CAMPAIGN .00 18,197.51 5,000.00 548049 BRANDING 9 /14 06/12/14 21 1406283 21300295 PETER A MAYER AD 35,000.00 .00 TO132 TV SPOTS 9 /14 06/18/14 21 1406454 21300295 PETER A MAYER AD 23,000.00 .00 TO132BRAND CAMPAIGN 9 /14 06/18/14 21 1406454 21300295 PETER A MAYER AD 42,130.00 .00 TO132BRAND CAMPAIGN TOTAL BRANDING .00 100,130.00 .00 548050 SPONSORSHIPS 9 /14 06/12/14 21 21400002−01 V1406242 000428 HORIZONS OF OKAL 9,000.00 −9,000.00 CHANGE ORDER − 1 TOTAL SPONSORSHIPS .00 9,000.00 −9,000.00 548070 ADVERTISING Packet Pg. 93 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 595.00 .00 MULTIVIEW INC TOTAL ADVERTISING .00 595.00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 14 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1172 − 3RD TDT−C.C. PROMOTIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 548070 ADVERTISING (cont’d) 554001 BOOK/PUB/SUB/MEMBERSHIPS 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 55.00 .00 CTC CONSTANTCONTACT.COM 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 55.00 .00 CTC CONSTANTCONTACT.COM TOTAL BOOK/PUB/SUB/MEMBERSHIPS .00 110.00 .00 TOTAL 3RD TDT−C.C. PROMOTIONS .00 184,520.96 −14,742.02 Packet Pg. 94 3.b.1 RUN DATE 08/20/2014 TIME 09:50:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 15 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 9 /14 06/11/14 22 24,247.13 PAYROLL CHARGES 9 /14 06/25/14 22 23,596.04 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 47,843.17 .00 512020 SALARIES/WAGES−PART−TIME 9 /14 06/11/14 22 793.06 PAYROLL CHARGES 9 /14 06/25/14 22 985.42 PAYROLL CHARGES TOTAL SALARIES/WAGES−PART−TIME .00 1,778.48 .00 514010 OVERTIME 9 /14 06/11/14 22 442.60 PAYROLL CHARGES 9 /14 06/25/14 22 310.93 PAYROLL CHARGES TOTAL OVERTIME .00 753.53 .00 521000 FICA TAXES 9 /14 06/11/14 22 1,878.25 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 1,833.08 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 3,711.33 .00 522000 RETIREMENT CONTRIBUTIONS 9 /14 06/06/14 19 RET ADJ 99.72 AHERN−DROP 9 /14 06/11/14 22 1,898.44 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 1,857.01 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 3,855.17 .00 523000 LIFE & HEALTH INSURANCE 9 /14 06/11/14 22 3,262.50 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 181.80 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 39.27 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 39.10 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 400.00 PAYROLL CHARGES 9 /14 06/25/14 22 3,262.50 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 181.80 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 39.27 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 39.10 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 400.00 PAYROLL CHARGES TOTAL LIFE & HEALTH INSURANCE .00 7,845.34 .00 523012 CONTRA L&H INS (REBATE) 9 /14 06/12/14 19 REBATE −180.00 INSURANCE REBATE ALLOCATI 9 /14 06/26/14 19 REBATE −180.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −360.00 .00 524000 WORKERS’ COMPENSATION Packet Pg. 95 9 /14 06/03/14 19 BUDGET−3 1,342.00 JUNE 2014 TOTAL WORKERS’ COMPENSATION .00 1,342.00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 16 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 524000 WORKERS’ COMPENSATION (cont’d) 534001 CS−GENERAL FUND ADMIN 9 /14 06/03/14 19 BUDGET−1 14,686.00 GEN FUND ADMINISTRATION TOTAL CS−GENERAL FUND ADMIN .00 14,686.00 .00 541010 COMMUNICATIONS SERVICE 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 143.63 .00 WWW.NEWEGG.COM TOTAL COMMUNICATIONS SERVICE .00 143.63 .00 541011 CELLULAR PHONES/PAGERS 9 /14 06/12/14 19 MOBILEDV −15.00 6/12/14 MOBILE DEVICE 9 /14 06/12/14 21 1406337 20900128 VERIZON WIRELESS 318.84 .00 4/24−5/23/14 CONV CTR 9 /14 06/26/14 19 MOBILEDV −15.00 6/26/14 MOBILE DEVICE TOTAL CELLULAR PHONES/PAGERS .00 288.84 .00 544640 R/L−EQUIPMENT 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 93.00 .00 CULLIGAN WATER SOLUTIO 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 168.00 .00 CULLIGAN WATER SOLUTIONS TOTAL R/L−EQUIPMENT .00 261.00 .00 545990 INSURANCE−OTHER 9 /14 06/03/14 19 BUDGET−5 5,219.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 5,219.00 .00 547002 PRINTING & BINDING 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 32.45 .00 FEDEXOFFICE 00015917 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 110.35 .00 COASTAL BUSINESS PRODUCTS TOTAL PRINTING & BINDING .00 142.80 .00 549122 BANK CHARGES 9 /14 06/10/14 19 BK CHGS 7,381.81 518089424342749 9 /14 07/18/14 19 COR9GA −7,211.14 CORRECT 6/10 BK CHHS 9 /14 07/24/14 19 CC AMEX 17.52 JAN AMER EXPRESS 9 /14 07/24/14 19 CC AMEX 68.80 FEB 2014 AMER EXPRESS 9 /14 07/24/14 19 CC AMEX 93.49 MAR 2014 AMER EXPRESS 9 /14 07/24/14 19 CC AMEX 170.05 APR 2014 AMER EXPRESS 9 /14 07/24/14 19 CC AMEX 93.33 MAY 2014 AMER EXPRESS TOTAL BANK CHARGES .00 613.86 .00 549905 MOTOR VEHICLE REPORTS 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 15.69 .00 ACCUFACTS PRE EMPLOYMENT 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 15.69 .00 ACCUFACTS PRE EMPLOYMENT TOTAL MOTOR VEHICLE REPORTS .00 31.38 .00 Packet Pg. 96 551001 OFFICE SUPPLIES 9 /14 06/25/14 13 −1,000.00 BT−CA−14−28 3.b.1 RUN DATE 08/20/2014 TIME 09:50:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 17 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1173 − 3RD TDT−C.C. ADMIN ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 551001 OFFICE SUPPLIES (cont’d) 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 14.47 .00 OFFICE DEPOT #206 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 15.29 .00 OFFICE DEPOT #1214 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 58.74 .00 STAPLES 00118828 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 167.50 .00 OFFICE DEPOT #1214 TOTAL OFFICE SUPPLIES −1,000.00 256.00 .00 552800 COMPUTER SUPPLIES 9 /14 06/25/14 13 −1,000.00 BT−CA−14−28 9 /14 06/25/14 13 363.00 BT−CA−14−28 9 /14 06/25/14 13 2,000.00 BT−CA−14−28 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 76.53 .00 OFFICE DEPOT #206 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 123.45 .00 OFFICE DEPOT #1214 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 199.79 .00 STAPLES 00118828 TOTAL COMPUTER SUPPLIES 1,363.00 399.77 .00 552801 COMPUTER SOFTWARE 9 /14 06/25/14 13 578.00 BT−CA−14−28 TOTAL COMPUTER SOFTWARE 578.00 .00 .00 554001 BOOK/PUB/SUB/MEMBERSHIPS 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 400.00 .00 FLORIDA RESTAURANT ASSOCI 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 455.00 .00 IAAM INC TOTAL BOOK/PUB/SUB/MEMBERSHIPS .00 855.00 .00 564703 COMPUTER EQUIPMENT 9 /14 06/25/14 13 −941.00 BT−CA−14−28 TOTAL COMPUTER EQUIPMENT −941.00 .00 .00 TOTAL 3RD TDT−C.C. ADMIN .00 89,666.30 .00 Packet Pg. 97 3.b.1 RUN DATE 08/20/2014 TIME 09:50:26 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 18 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534200 CS−SECURITY 9 /14 06/05/14 21 21401183−01 1406112 001265 SHERIFF’S POSSE 845.50 −1,282.50 PROVIDE SECURITY AT THE E 9 /14 06/05/14 21 21401286−01 1406112 001265 SHERIFF’S POSSE 104.50 −133.00 PROVIDE SECURITY AT ECCC 9 /14 06/06/14 17 21401463−01 001265 SHERIFF’S POSSE 1,567.50 PROVIDE SECURITY AT THE E 9 /14 06/18/14 21 1406392 21200786 CUTLASS SECURITY 1,030.00 .00 5/21−31/2014 ECCC 9 /14 06/25/14 21 1406603 20302532 SECURITAS SECURI 288.00 .00 ECCC 9 /14 06/25/14 21 1406538 21200786 CUTLASS SECURITY 1,377.00 .00 6/2−14/14 ECCC 9 /14 06/25/14 13 18,610.00 BT−CA−14−28 TOTAL CS−SECURITY 18,610.00 3,645.00 152.00 534500 CS−PERSONNEL 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 105.44 .00 MCCLELLAND 5/24/14 9 /14 06/12/14 21 V1406254 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 5/18/14 9 /14 06/12/14 21 1406257 21101150 LANDRUM STAFFING 474.48 .00 KEIGANS 5/24/14 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 964.18 .00 CONV CTR 5/18/14 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 1,032.08 .00 CPNV CTR 5/25/14 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 1,235.78 .00 CONV CTR 5/11/14 9 /14 06/18/14 21 V1406431 009350 KELLY SERVICES,I 283.35 .00 WOLFENDEN 5/25/14 9 /14 06/25/14 21 1406576 21101150 LANDRUM STAFFING 13.18 .00 KEIGANS 5/31/14 9 /14 06/25/14 21 V1406574 009350 KELLY SERVICES,I 78.70 .00 NICHOLS 6/8/14 9 /14 06/25/14 21 V1406574 009350 KELLY SERVICES,I 125.92 .00 FORTE 5/25/14 9 /14 06/25/14 21 V1406574 009350 KELLY SERVICES,I 141.68 .00 WOLFENDEN 6/1/14 9 /14 06/25/14 21 1406576 21101150 LANDRUM STAFFING 168.05 .00 KEIGANS 5/31/14 9 /14 06/25/14 21 1406576 21101150 LANDRUM STAFFING 263.60 .00 MCCLELLAND 6/7/14 9 /14 06/25/14 21 1406594 20900514 TAMPA SERVICE CO 862.33 .00 CONV CTR 6/1/14 9 /14 06/25/14 21 1406594 20900514 TAMPA SERVICE CO 1,317.26 .00 CONV CTR 6/8/14 TOTAL CS−PERSONNEL .00 7,207.71 .00 534751 CS−RIGGING/PRODUCTION 9 /14 06/25/14 13 7,248.00 BT−CA−14−28 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 350.00 .00 TSC PRODUCTIONS TOTAL CS−RIGGING/PRODUCTION 7,248.00 350.00 .00 534757 CS−ENTERTAINMENT 9 /14 06/09/14 17 21401472−01 21400228 JAMES B DYESS D/ 450.00 ACOUSTIC GUITARIST TO PER 9 /14 06/10/14 18 21401397−01 21400215 GLEN E GUARIN −800.00 CHANGE ORDER − 1 9 /14 06/11/14 18 21401472−01 21400228 JAMES B DYESS D/ −450.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401472−01 060914 21400228 JAMES B DYESS D/ .00 .00 ACOUSTIC GUITARIST TO PER 9 /14 06/12/14 21 21401397−01 4 PC BAND 21400215 GLEN E GUARIN .00 .00 CABO ROCK BAND TO PERFORM 9 /14 06/25/14 13 −35,544.00 BT−CA−14−28 TOTAL CS−ENTERTAINMENT −35,544.00 .00 −800.00 540002 TRAVEL OUT−OF−COUNTY 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 25.00 .00 DELTA AIR 0068242242755 TOTAL TRAVEL OUT−OF−COUNTY .00 25.00 .00 Packet Pg. 98 544640 R/L−EQUIPMENT 3.b.1 RUN DATE 08/20/2014 TIME 09:50:27 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 19 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 544640 R/L−EQUIPMENT 9 /14 06/04/14 17 21401439−01 21001211 NATIONWIDE TENTS 2,000.00 CONCRETE BALLAST 9 /14 06/04/14 17 21401439−03 21001211 NATIONWIDE TENTS 600.00 TRANSPORT FEES 9 /14 06/04/14 17 21401439−02 21001211 NATIONWIDE TENTS 1,200.00 LULL RENTAL (NEEDED FOR T 9 /14 06/10/14 18 21401439−01 21001211 NATIONWIDE TENTS −2,000.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401439−02 21001211 NATIONWIDE TENTS −1,200.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401439−03 21001211 NATIONWIDE TENTS −600.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−01 21200115 APPLAUSE PRODUCT −400.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−02 21200115 APPLAUSE PRODUCT −240.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−03 21200115 APPLAUSE PRODUCT −240.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−04 21200115 APPLAUSE PRODUCT −456.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−05 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−06 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−07 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−08 21200115 APPLAUSE PRODUCT −351.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−09 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−10 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−11 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−12 21200115 APPLAUSE PRODUCT −300.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−13 21200115 APPLAUSE PRODUCT −72.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−14 21200115 APPLAUSE PRODUCT −162.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−15 21200115 APPLAUSE PRODUCT −21.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−16 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−17 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−18 21200115 APPLAUSE PRODUCT −1,200.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−19 21200115 APPLAUSE PRODUCT −600.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−20 21200115 APPLAUSE PRODUCT −1,620.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−21 21200115 APPLAUSE PRODUCT −140.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−22 21200115 APPLAUSE PRODUCT −420.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−23 21200115 APPLAUSE PRODUCT −200.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−24 21200115 APPLAUSE PRODUCT −200.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−25 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−26 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−27 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−28 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−29 21200115 APPLAUSE PRODUCT −500.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−30 21200115 APPLAUSE PRODUCT −200.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−31 21200115 APPLAUSE PRODUCT −100.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−32 21200115 APPLAUSE PRODUCT .00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−33 21200115 APPLAUSE PRODUCT −75.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−34 21200115 APPLAUSE PRODUCT −140.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−35 21200115 APPLAUSE PRODUCT −260.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−36 21200115 APPLAUSE PRODUCT −75.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−37 21200115 APPLAUSE PRODUCT −700.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−38 21200115 APPLAUSE PRODUCT −150.00 CHANGE ORDER − 1 Packet Pg. 99 9 /14 06/10/14 18 21401423−39 21200115 APPLAUSE PRODUCT −875.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401423−40 21200115 APPLAUSE PRODUCT −2,036.37 CHANGE ORDER − 1 3.b.1 RUN DATE 08/20/2014 TIME 09:50:27 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 20 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 544640 R/L−EQUIPMENT (cont’d) 9 /14 06/12/14 21 21401439−02 13205 21001211 NATIONWIDE TENTS .00 .00 LULL RENTAL (NEEDED FOR T 9 /14 06/12/14 21 21401439−03 13205 21001211 NATIONWIDE TENTS .00 .00 TRANSPORT FEES 9 /14 06/12/14 21 21401423−01 2261 21200115 APPLAUSE PRODUCT .00 .00 12’X12’ MAHOGANY PERGOLA 9 /14 06/12/14 21 21401423−02 2261 21200115 APPLAUSE PRODUCT .00 .00 WHITE CHIFFON PANEL 12’L 9 /14 06/12/14 21 21401423−03 2261 21200115 APPLAUSE PRODUCT .00 .00 5’ SQUARE TABLES 9 /14 06/12/14 21 21401423−04 2261 21200115 APPLAUSE PRODUCT .00 .00 120’X120’ LINEN − TURQUOI 9 /14 06/12/14 21 21401423−05 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI CHAIRS 9 /14 06/12/14 21 21401423−06 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI CUSHION 9 /14 06/12/14 21 21401423−07 2261 21200115 APPLAUSE PRODUCT .00 .00 72" ROUNDS − PROVIDED BY 9 /14 06/12/14 21 21401423−08 2261 21200115 APPLAUSE PRODUCT .00 .00 132" ROUND LINEN − TURQUO 9 /14 06/12/14 21 21401423−09 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI CHAIR ( 9 /14 06/12/14 21 21401423−10 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI CUSHION 9 /14 06/12/14 21 21401423−11 2261 21200115 APPLAUSE PRODUCT .00 .00 24" ROUND TABLE − NATURAL 9 /14 06/12/14 21 21401423−12 2261 21200115 APPLAUSE PRODUCT .00 .00 SPANDEX LINEN − WHITE 9 /14 06/12/14 21 21401423−13 2261 21200115 APPLAUSE PRODUCT .00 .00 30" ROUND TABLE − HIGHBOY 9 /14 06/12/14 21 21401423−14 2261 21200115 APPLAUSE PRODUCT .00 .00 132" ROUND LINEN − CAMEL 9 /14 06/12/14 21 21401423−15 2261 21200115 APPLAUSE PRODUCT .00 .00 SASHE − TURQUOISE SATIN 9 /14 06/12/14 21 21401423−16 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI BARSTOO 9 /14 06/12/14 21 21401423−17 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY CHIAVARI CUSHION 9 /14 06/12/14 21 21401423−18 2261 21200115 APPLAUSE PRODUCT .00 .00 6−PIECE SQUARE RATTAN LOU 9 /14 06/12/14 21 21401423−19 2261 21200115 APPLAUSE PRODUCT .00 .00 4−PIECE CURVED RATTAN LOU 9 /14 06/12/14 21 21401423−20 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY FOOD STATIONS (1 9 /14 06/12/14 21 21401423−21 2261 21200115 APPLAUSE PRODUCT .00 .00 WINDOW MENU BOARD (INCLUD 9 /14 06/12/14 21 21401423−22 2261 21200115 APPLAUSE PRODUCT .00 .00 12" CRYSTAL BALL CHANDELI 9 /14 06/12/14 21 21401423−23 2261 21200115 APPLAUSE PRODUCT .00 .00 RIGGING PACKAGE − BASIC ( 9 /14 06/12/14 21 21401423−24 2261 21200115 APPLAUSE PRODUCT .00 .00 CABLING PACKAGE − SMALL ( 9 /14 06/12/14 21 21401423−25 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY BAR − 14’ SINGLE 9 /14 06/12/14 21 21401423−26 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY BACK BAR ISLAND 9 /14 06/12/14 21 21401423−27 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY 8’ SURROUND BAR 9 /14 06/12/14 21 21401423−28 2261 21200115 APPLAUSE PRODUCT .00 .00 MAHOGANY BACK BAR ISLAND 9 /14 06/12/14 21 21401423−29 2261 21200115 APPLAUSE PRODUCT .00 .00 25’ STRING LIGHT (WHITE S 9 /14 06/12/14 21 21401423−30 2261 21200115 APPLAUSE PRODUCT .00 .00 RIGGING PACKAGE − BASIC ( 9 /14 06/12/14 21 21401423−31 2261 21200115 APPLAUSE PRODUCT .00 .00 MAGIC GADGET DIMMER (2000 9 /14 06/12/14 21 21401423−32 2261 21200115 APPLAUSE PRODUCT .00 .00 2−MAN POWERED SCISSOR LIF 9 /14 06/12/14 21 21401423−33 2261 21200115 APPLAUSE PRODUCT .00 .00 LABOR ON JUNE 8, 2014 − L 9 /14 06/12/14 21 21401423−34 2261 21200115 APPLAUSE PRODUCT .00 .00 PRODUCTION TECH−RIG IN TE 9 /14 06/12/14 21 21401423−35 2261 21200115 APPLAUSE PRODUCT .00 .00 TECH−RIGGER−RIG IN TENT − 9 /14 06/12/14 21 21401423−36 2261 21200115 APPLAUSE PRODUCT .00 .00 LABOR ON JUNE 9, 2014 − L 9 /14 06/12/14 21 21401423−37 2261 21200115 APPLAUSE PRODUCT .00 .00 PRODUCTION TECH−SETUP − 4 9 /14 06/12/14 21 21401423−38 2261 21200115 APPLAUSE PRODUCT .00 .00 LOCAL PICKUP − 2 HRS 9 /14 06/12/14 21 21401423−39 2261 21200115 APPLAUSE PRODUCT .00 .00 PRODUCTION TECH−STRIKE − 9 /14 06/12/14 21 21401423−40 2261 21200115 APPLAUSE PRODUCT .00 .00 SERVICE CHARGE 9 /14 06/12/14 21 21401439−01 13205 21001211 NATIONWIDE TENTS .00 .00 CONCRETE BALLAST Packet Pg. 100 9 /14 06/25/14 17 21401558−01 20801842 BRENDON GRIMES D 2,070.00 RENT 40’ OF 12" BOX TRUSS TOTAL R/L−EQUIPMENT .00 .00 −9,663.37 3.b.1 RUN DATE 08/20/2014 TIME 09:50:28 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 21 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549900 MISCELLANEOUS CHARGES 549900 MISCELLANEOUS CHARGES 9 /14 06/09/14 17 21401474−01 010500 OKALOOSA ISLAND 5,670.00 LEVEL 3 FIREWATCH FOR MAS 9 /14 06/25/14 13 9,686.00 BT−CA−14−28 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 107.31 .00 BANGKOK CLEANERS TOTAL MISCELLANEOUS CHARGES 9,686.00 107.31 5,670.00 552751 C.C. SPECIAL EVENTS 9 /14 06/03/14 17 21401435−01 21400222 JENNIFER CHAPARR 2,000.00 WILL CREATE A 3D CHALK AR 9 /14 06/06/14 17 21401466−01 21400226 TERRE L CARR D/B 1,375.00 13 ROUND / 12 SQUARE ARRA 9 /14 06/06/14 17 21401466−02 21400226 TERRE L CARR D/B 475.00 SMALL CENTERPIECES FOR HI 9 /14 06/06/14 17 21401466−03 21400226 TERRE L CARR D/B 100.00 LARGE SHOWY CENTERPIECE F 9 /14 06/06/14 17 21401466−04 21400226 TERRE L CARR D/B 25.00 DELIVERY CHARGE 9 /14 06/10/14 18 21401421−01 20801842 BRENDON GRIMES D −65.95 CHANGE ORDER − 1 9 /14 06/10/14 18 21401421−02 20801842 BRENDON GRIMES D −520.95 CHANGE ORDER − 1 9 /14 06/10/14 18 21401421−03 20801842 BRENDON GRIMES D −520.95 CHANGE ORDER − 1 9 /14 06/10/14 18 21401421−04 20801842 BRENDON GRIMES D −34.95 CHANGE ORDER − 1 9 /14 06/10/14 18 21401466−01 21400226 TERRE L CARR D/B −1,375.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401466−02 21400226 TERRE L CARR D/B −475.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401466−03 21400226 TERRE L CARR D/B −100.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401466−04 21400226 TERRE L CARR D/B −25.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401435−01 21400222 JENNIFER CHAPARR −2,000.00 CHANGE ORDER − 1 9 /14 06/10/14 18 21401398−01 21400216 SAND ODYSSEY −930.00 CHANGE ORDER − 1 9 /14 06/12/14 21 21401466−01 201405056 21400226 TERRE L CARR D/B .00 .00 13 ROUND / 12 SQUARE ARRA 9 /14 06/12/14 21 21401466−02 201405056 21400226 TERRE L CARR D/B .00 .00 SMALL CENTERPIECES FOR HI 9 /14 06/12/14 21 21401466−03 201405056 21400226 TERRE L CARR D/B .00 .00 LARGE SHOWY CENTERPIECE F 9 /14 06/12/14 21 21401466−04 201405056 21400226 TERRE L CARR D/B .00 .00 DELIVERY CHARGE 9 /14 06/12/14 21 21401435−01 2218 21400222 JENNIFER CHAPARR .00 .00 WILL CREATE A 3D CHALK AR 9 /14 06/19/14 21 21401398−01 446 21400216 SAND ODYSSEY .00 .00 WILL CREATE A SAND SCULPT 9 /14 06/19/14 21 21401421−01 2323 20801842 BRENDON GRIMES D .00 .00 CUSTOM STEEL GOBO, ’B’ SI 9 /14 06/19/14 21 21401421−02 2323 20801842 BRENDON GRIMES D .00 .00 CUSTOM GLASS GOBO, ORIGIN 9 /14 06/19/14 21 21401421−03 2323 20801842 BRENDON GRIMES D .00 .00 CUSTOM GLASS GOBO, ORIGIN 9 /14 06/19/14 21 21401421−04 2323 20801842 BRENDON GRIMES D .00 .00 SHIPPING AND HANDLING 9 /14 06/25/14 21 21401349−01 1406597 21300682 PRO SOUND & VIDE 1,396.72 −1,396.72 18" GOOSENECK CONDENSER M 9 /14 06/25/14 21 21401349−02 1406597 21300682 PRO SOUND & VIDE 406.64 −406.64 DESKTOP MICROPHONE BASE S 9 /14 06/25/14 21 21401349−03 1406597 21300682 PRO SOUND & VIDE 49.59 −49.59 SHIPPING 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 33.00 .00 BATTERY WAREHOUSE 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 35.98 .00 PROMUSICGROUP,LLC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 39.92 .00 LOWES #00479 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 56.96 .00 AMAZON MKTPLACE PMTS 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 96.93 .00 ULINE SHIP SUPPLIES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 152.82 .00 STAGELIGHTINGSTORE 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 269.23 .00 LIVESTREAM TOTAL C.C. SPECIAL EVENTS .00 2,537.79 −3,925.75 Packet Pg. 101 564751 C.C. SPECIAL EVENTS 9 /14 06/05/14 21 21401249−01 1406049 20502055 CITY ELECTRIC SU 2,981.74 −2,910.00 WEATHER RESISTANT POWER D 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 22 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1174 − 3RD TDT−C.C. OPERATIONS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 564751 C.C. SPECIAL EVENTS (cont’d) 9 /14 06/05/14 17 21401453−01 21001485 UNIVERSAL MEDIA 5,479.00 HIGH DEFINITION P/T/Z COL 9 /14 06/05/14 17 21401453−02 21001485 UNIVERSAL MEDIA 1,399.00 HIGH DEFINITION & STANDAR 9 /14 06/05/14 17 21401453−03 21001485 UNIVERSAL MEDIA 45.00 FREIGHT 9 /14 06/12/14 21 21401368−01 1406285 21300682 PRO SOUND & VIDE 2,310.00 −2,310.00 4 INPUT VIDEO AND RGB SCA 9 /14 06/12/14 21 21401368−02 1406285 21300682 PRO SOUND & VIDE 46.20 −46.20 FREIGHT TOTAL C.C. SPECIAL EVENTS .00 5,337.94 1,656.80 TOTAL 3RD TDT−C.C. OPERATIONS .00 19,210.75 −6,910.32 Packet Pg. 102 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 23 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 512010 SALARIES/WAGES−FULL−TIME 9 /14 06/11/14 22 3,990.90 PAYROLL CHARGES 9 /14 06/25/14 22 3,946.90 PAYROLL CHARGES TOTAL SALARIES/WAGES−FULL−TIME .00 7,937.80 .00 521000 FICA TAXES 9 /14 06/11/14 22 303.12 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 299.75 PAYROLL CHARGES−FRINGE TOTAL FICA TAXES .00 602.87 .00 522000 RETIREMENT CONTRIBUTIONS 9 /14 06/11/14 22 277.36 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 274.30 PAYROLL CHARGES−FRINGE TOTAL RETIREMENT CONTRIBUTIONS .00 551.66 .00 523000 LIFE & HEALTH INSURANCE 9 /14 06/11/14 22 362.50 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 12.12 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 2.31 PAYROLL CHARGES−FRINGE 9 /14 06/11/14 22 2.30 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 362.50 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 12.12 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 2.31 PAYROLL CHARGES−FRINGE 9 /14 06/25/14 22 2.30 PAYROLL CHARGES−FRINGE TOTAL LIFE & HEALTH INSURANCE .00 758.46 .00 523012 CONTRA L&H INS (REBATE) 9 /14 06/12/14 19 REBATE −20.00 INSURANCE REBATE ALLOCATI 9 /14 06/26/14 19 REBATE −20.00 INSURANCE REBATE ALLOCATI TOTAL CONTRA L&H INS (REBATE) .00 −40.00 .00 524000 WORKERS’ COMPENSATION 9 /14 06/03/14 19 BUDGET−3 25.00 JUNE 2014 TOTAL WORKERS’ COMPENSATION .00 25.00 .00 531002 PS−OTHER ATTORNEY SVCS 9 /14 06/19/14 21 V1406444 010277 NABORS,GIBLIN & 1,617.38 .00 SANDMAN LLC 9 /14 06/25/14 21 V1406584 010277 NABORS,GIBLIN & 4,579.00 .00 SANDMAN LLC 9 /14 06/25/14 13 15,587.00 BT−CA−14−28 TOTAL PS−OTHER ATTORNEY SVCS 15,587.00 6,196.38 .00 531100 PS−CONSULTANT 9 /14 06/05/14 21 1406030 20700177 ALCALDE & FAY LT 1,667.00 .00 MAY2014 RETAINER TOTAL PS−CONSULTANT .00 1,667.00 .00 Packet Pg. 103 531500 PS−ENGINEERING 9 /14 06/25/14 13 −4,511.00 BT−CA−14−28 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 24 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 531500 PS−ENGINEERING (cont’d) TOTAL PS−ENGINEERING −4,511.00 .00 .00 534010 CS−PARKS CLEANING 9 /14 06/05/14 21 V1406094 000428 HORIZONS OF OKAL 8,703.20 .00 APRIL14 MOBILE CREW 9 /14 06/19/14 21 V1406427 000428 HORIZONS OF OKAL 9,838.40 .00 MAY14 MOBILE CREW 9 /14 06/25/14 13 −11,076.00 BT−CA−14−28 TOTAL CS−PARKS CLEANING −11,076.00 18,541.60 .00 534109 CS−BEACH CLEANING−DESTIN 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 859.90 .00 DISPOAL COST APR2014 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 1,398.00 .00 DESTIN FEB27/28 2014 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 25,088.00 .00 DESTIN APR2014 9 /14 07/14/14 19 COR9FB −8,001.13 CORRECT AJE9CG 9 /14 07/14/14 19 COR9FB −10,398.02 CORRECT AJE9CG TOTAL CS−BEACH CLEANING−DESTIN .00 8,946.75 .00 534110 CS−BEACH CLEAN−OK ISLAND 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 622.68 .00 DISPOAL COST APR2014 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 1,007.00 .00 OKAL ISL FEB27/28 201 9 /14 06/25/14 21 1406602 20500470 SANDMAN LLC 17,698.50 .00 OKAL ISL APR2014 9 /14 07/14/14 19 COR9FB −5,793.93 CORRECT AJE9CG 9 /14 07/14/14 19 COR9FB −7,529.60 CORRECT AJE9CG TOTAL CS−BEACH CLEAN−OK ISLAND .00 6,004.65 .00 534111 CS−TURTLE WATCH PROGRAM 9 /14 06/05/14 21 1406080 010554 GEORGE W GRAY 7,833.33 .00 TURTLE WATCH TOTAL CS−TURTLE WATCH PROGRAM .00 7,833.33 .00 540002 TRAVEL OUT−OF−COUNTY 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 14.00 .00 RPS PENSACOLA REGIONAL AP TOTAL TRAVEL OUT−OF−COUNTY .00 14.00 .00 540005 TRAVEL LODGING EXPENSES 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 209.00 .00 MARRIOTT 337A0 TAMPA AP TOTAL TRAVEL LODGING EXPENSES .00 209.00 .00 541011 CELLULAR PHONES/PAGERS 9 /14 06/05/14 21 1406145 20900128 VERIZON WIRELESS 40.01 .00 4/8−5/7/14 TDD 9 /14 06/12/14 21 1406335 20900128 VERIZON WIRELESS 59.60 .00 4/24−5/23/14 TDD 9 /14 06/25/14 21 1406622 20900128 VERIZON WIRELESS 40.01 .00 5/8−6/7/14 TDD TOTAL CELLULAR PHONES/PAGERS .00 139.62 .00 545990 INSURANCE−OTHER Packet Pg. 104 9 /14 06/03/14 19 BUDGET−5 43.00 GENERAL LIABILITY TOTAL INSURANCE−OTHER .00 43.00 .00 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 25 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1175 − 1ST TDT−BEACHES & PARKS ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549900 MISCELLANEOUS CHARGES 549900 MISCELLANEOUS CHARGES 9 /14 06/19/14 21 V1406397 006052 DON W HOWARD CLE 18.50 .00 1596661 PUB SAF TOTAL MISCELLANEOUS CHARGES .00 18.50 .00 552800 COMPUTER SUPPLIES 9 /14 06/05/14 21 21401003−01 1406062 009744 DELL MARKETING L 233.99 −233.99 DELL ULTRASHARP 23 MONITO TOTAL COMPUTER SUPPLIES .00 233.99 −233.99 563490 OTHER IMPROVEMENTS 9 /14 06/05/14 21 1406136 013714 TAYLOR ENGINEERI 13,934.29 .00 TO1GREENSHORES PH1 TOTAL OTHER IMPROVEMENTS .00 13,934.29 .00 591001 BT−GENERAL FUND 9 /14 06/03/14 19 BUDGET−4 39,915.00 JUNE 2014 9 /14 07/14/14 19 COR9FB 13,795.06 CORRECT AJE9CG 9 /14 07/14/14 19 COR9FB 17,927.62 CORRECT AJE9CG TOTAL BT−GENERAL FUND .00 71,637.68 .00 591201 BT−DEBT SERVICE FUND 9 /14 06/03/14 19 BUDGET−4 27,101.00 JUNE 2014 TOTAL BT−DEBT SERVICE FUND .00 27,101.00 .00 591430 BT−SOLID WASTE 9 /14 06/23/14 11 .00 ESTABLISH PER JKG FOR JE 9 /14 06/23/14 19 AJE9CG 3,502.29 TRNSF BEACH CLEANING 9 /14 06/23/14 19 AJE9CG 1,320.70 TRNSF BEACH CLEANING 9 /14 06/23/14 19 AJE9CG 31,722.68 TRNSF BEACH CLEANING 9 /14 07/14/14 19 COR9FB −31,722.68 CORRECT AJE9CG TOTAL BT−SOLID WASTE .00 4,822.99 .00 TOTAL 1ST TDT−BEACHES & PARKS .00 177,179.57 −233.99 Packet Pg. 105 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 26 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1176 − SPECIAL ASSESSMENT ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 549005 COMMISSIONS−TAX COLLECTOR 9 /14 06/18/14 24 000004 BENJAMIN F ANDER 154.51 6/14 ACH TOTAL COMMISSIONS−TAX COLLECTOR .00 154.51 .00 591201 BT−DEBT SERVICE FUND 9 /14 06/03/14 19 BUDGET−4 29,167.00 JUNE 2014 TOTAL BT−DEBT SERVICE FUND .00 29,167.00 .00 TOTAL SPECIAL ASSESSMENT .00 29,321.51 .00 Packet Pg. 106 3.b.1 RUN DATE 08/20/2014 TIME 09:50:29 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 27 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 534500 CS−PERSONNEL 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 325.92 .00 CONV CTR 5/11/14 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 434.56 .00 CONV CTR 5/25/14 9 /14 06/12/14 21 1406280 20900514 TAMPA SERVICE CO 658.63 .00 CONV CTR 5/18/14 9 /14 06/25/14 21 1406594 20900514 TAMPA SERVICE CO 420.98 .00 CONV CTR 6/1/14 9 /14 06/25/14 21 1406594 20900514 TAMPA SERVICE CO 719.74 .00 CONV CTR 6/8/14 TOTAL CS−PERSONNEL .00 2,559.83 .00 534550 CS−UNIFORMS 9 /14 06/12/14 13 −8,000.00 BT−CA−14−26 TOTAL CS−UNIFORMS −8,000.00 .00 .00 534607 CS−LAWN SERVICE 9 /14 06/12/14 21 1406322 20501188 TRUGREEN COMPANI 82.08 .00 CONV CTR 5/21/14 9 /14 06/12/14 21 1406322 20501188 TRUGREEN COMPANI 588.15 .00 CONV CTR 5/21/14 9 /14 06/25/14 21 1406618 20501188 TRUGREEN COMPANI 54.00 .00 ECCC 9 /14 06/25/14 21 1406618 20501188 TRUGREEN COMPANI 58.00 .00 ECCC TOTAL CS−LAWN SERVICE .00 782.23 .00 534900 CS−OTHER 9 /14 06/12/14 13 8,000.00 BT−CA−14−26 9 /14 06/12/14 21 1406170 21300706 AUS FLORIDA GROU 242.95 .00 792423935 TDD 9 /14 06/18/14 21 1406362 21300706 AUS FLORIDA GROU 242.95 .00 792423935TDD 9 /14 06/25/14 21 1406510 21300706 AUS FLORIDA GROU 242.95 .00 792423935 TDD 9 /14 06/25/14 21 1406510 21300706 AUS FLORIDA GROU 242.95 .00 792423935 TDD TOTAL CS−OTHER 8,000.00 971.80 .00 543001 UTILITIES−ELECTRIC 9 /14 06/05/14 21 1406088 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 9 /14 06/05/14 21 1406088 000387 GULF POWER COMPA 21.54 .00 1250 MIRACLE STRIP PKWY 9 /14 06/05/14 21 1406088 000387 GULF POWER COMPA 633.68 .00 1540 HIGHWAY 98 E 9 /14 06/05/14 21 1406088 000387 GULF POWER COMPA 3,126.52 .00 1250 MIRACLE STRIP PKWY 9 /14 06/12/14 21 1406231 000387 GULF POWER COMPA 16,755.78 .00 1250 MIRACLE STRIP PKWY 9 /14 06/25/14 21 1406567 000387 GULF POWER COMPA 23.05 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−ELECTRIC .00 20,582.11 .00 543002 UTILITIES−WATER 9 /14 06/05/14 21 1406088 000387 GULF POWER COMPA 188.13 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−WATER .00 188.13 .00 543004 UTILITIES−GARBAGE 9 /14 06/05/14 21 1406153 006405 WASTE MANAGEMENT 240.68 .00 792096422334 TDD 9 /14 06/12/14 21 1406164 20502035 ALLIED SERVICES 207.66 .00 ECCC 9 /14 06/25/14 21 1406628 006405 WASTE MANAGEMENT 698.33 .00 795734322337 TDD Packet Pg. 107 TOTAL UTILITIES−GARBAGE .00 1,146.67 .00 543005 UTILITIES−GAS 3.b.1 RUN DATE 08/20/2014 TIME 09:50:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 28 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 543005 UTILITIES−GAS 9 /14 06/12/14 21 1406278 003198 OKALOOSA GAS DIS 451.39 .00 1250 MIRACLE STRIP PKWY TOTAL UTILITIES−GAS .00 451.39 .00 546620 RM−FACILITIES 9 /14 06/04/14 18 21401443−01 21001779 SMALL MARKET MEE −5,000.00 CHANGE ORDER − 1 9 /14 06/04/14 18 21401443−01 21001779 SMALL MARKET MEE .00 CHANGE ORDER − 2 9 /14 06/04/14 17 21401442−01 20201254 EDGE PAINTING IN 2,350.00 PROVIDE ALL MATERIALS AND 9 /14 06/04/14 17 21401443−01 21001779 SMALL MARKET MEE 5,000.00 2014 BREAKFAST DAY 2 SPON 9 /14 06/11/14 18 21401443−01 21001779 SMALL MARKET MEE .00 CHANGE ORDER − 3 9 /14 06/12/14 21 21401251−01 1406209 20201254 EDGE PAINTING IN 14,430.00 −14,430.00 REPAIR/RECOAT WALLS 9 /14 06/17/14 17 21401519−01 20500319 BEL−MAC ROOFING 3,500.00 PROVIDE ALL MATERIALS AND 9 /14 06/19/14 21 21401251−01 1406400 20201254 EDGE PAINTING IN 14,430.00 −14,430.00 REPAIR/RECOAT WALLS 9 /14 06/25/14 21 1406633 20701398 ZEE COMPANY INC 305.00 .00 JUNE2014 9 /14 06/25/14 21 21401239−01 1406633 20701398 ZEE COMPANY INC 1,622.86 −1,600.00 PROVIDE COMPONENT, ALL LA 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 2.99 .00 RADIOSHACK COR00188904 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 24.81 .00 EWING IRRIGATION PRD 134 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 27.74 .00 HOLLYWOOD PAINT & COLOR 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 65.66 .00 EWING IRRIGATION PRD 134 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 75.00 .00 STATE OF FL DBPR 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 83.94 .00 HD SUPPLY FACILITIES MTNC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 93.63 .00 SPRINKLERWAREHOUSE. 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 128.17 .00 1000BULBS.COM 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 172.35 .00 ATLANTA LIGHT BULBS INC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 450.00 .00 HEROMAN SERVICES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 693.60 .00 ELECTRIC MOTOR REPAIR 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 693.60 .00 ELECTRIC MOTOR REPAIR 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 999.99 .00 HOTSHOTS TOTAL RM−FACILITIES .00 34,299.34 −24,610.00 546640 RM−EQUIPMENT 9 /14 06/12/14 21 V1406211 015440 EMERGENCY SYSTEM 233.33 .00 CONV CTR 9 /14 06/18/14 21 1406442 21300731 MOWREY ELEVATOR 125.00 .00 ECCC 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 410.25 .00 SYSTEMS SPECIALISTS INC TOTAL RM−EQUIPMENT .00 768.58 .00 546644 RM−VEHICLES−FLEET 9 /14 07/14/14 19 FLT BILL 206.45 JUNE 14 FLEET BILL TOTAL RM−VEHICLES−FLEET .00 206.45 .00 548001 PROMOTIONAL ACTIVITIES 9 /14 06/04/14 11 .00 ESTABLISH FOR PO 9 /14 06/04/14 17 21401443−01 21001779 SMALL MARKET MEE 5,000.00 CHANGE ORDER − 2 9 /14 06/11/14 18 21401443−01 21001779 SMALL MARKET MEE −5,000.00 CHANGE ORDER − 3 Packet Pg. 108 TOTAL PROMOTIONAL ACTIVITIES .00 .00 .00 552010 FLEET FUEL 3.b.1 RUN DATE 08/20/2014 TIME 09:50:30 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 29 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1177 − 3RD TDT−C.C. MAINTENANCE ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 552010 FLEET FUEL 9 /14 07/14/14 19 FLT BILL 174.50 JUNE 14 FLEET BILL TOTAL FLEET FUEL .00 174.50 .00 552500 TOOLS & SMALL IMPLEMENTS 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 5.61 .00 GATLIN LUMBER AND SUPPLY 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 15.19 .00 GATLIN LUMBER AND SUPPLY TOTAL TOOLS & SMALL IMPLEMENTS .00 20.80 .00 552700 JANITORIAL SUPPLIES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 631.08 .00 SUPREME PAPER SUPPLIES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 663.27 .00 SUPREME PAPER SUPPLIES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 760.34 .00 SUPREME PAPER SUPPLIES TOTAL JANITORIAL SUPPLIES .00 2,054.69 .00 552751 C.C. SPECIAL EVENTS 9 /14 06/04/14 17 21401443−01 21001779 SMALL MARKET MEE 5,000.00 CHANGE ORDER − 1 9 /14 06/04/14 18 21401443−01 21001779 SMALL MARKET MEE −5,000.00 CHANGE ORDER − 2 9 /14 06/11/14 18 21401443−01 21001779 SMALL MARKET MEE .00 CHANGE ORDER − 3 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA −8.64 .00 JOHNSTONE SUPPLY OF FT WA 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 8.64 .00 JOHNSTONE SUPPLY OF FT WA 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 107.89 .00 GATLIN LUMBER AND SUPPLY TOTAL C.C. SPECIAL EVENTS .00 107.89 .00 552990 OTHER SUPPLIES 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 82.42 .00 LOWES #00479 TOTAL OTHER SUPPLIES .00 82.42 .00 562790 OTHER CONSTRUCTION 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 169.77 .00 SHERWIN WILLIAMS #2094 9 /14 06/30/14 21 V2140212 014799 BANK OF AMERICA 310.44 .00 SHERWIN WILLIAMS #2094 TOTAL OTHER CONSTRUCTION .00 480.21 .00 TOTAL 3RD TDT−C.C. MAINTENANCE .00 64,877.04 −24,610.00 Packet Pg. 109 3.b.1 RUN DATE 08/20/2014 TIME 09:50:31 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 30 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 1179 − 4TH TDT−C.C. CAPITAL ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 562752 PORTE COCHERE 9 /14 06/12/14 21 V1406222 008408 GGI LLC D/B/A GE 216.52 .00 FINAL −PROF SVCS TOTAL PORTE COCHERE .00 216.52 .00 563710 OUTDOOR EXHIBITION PAD 9 /14 06/19/14 21 21401165−01 1406417 000385 GULF POWER COMPA 6,619.00 −6,619.00 ELECTRICAL WORK FOR BORIN 9 /14 06/27/14 17 21401567−01 007839 AAA ECONOMY FENC 16,460.00 PROVIDE ALL LABOR & MATER 9 /14 06/27/14 21 V2140212 014799 BANK OF AMERICA 376.90 .00 WOERNER LANDSCAPE SOUR TOTAL OUTDOOR EXHIBITION PAD .00 6,995.90 9,841.00 563790 OTHER IMPROVEMENTS 9 /14 06/25/14 21 1406514 012182 ATKINS 99.40 .00 TO3 MARLER PK IMPROS TOTAL OTHER IMPROVEMENTS .00 99.40 .00 TOTAL 4TH TDT−C.C. CAPITAL .00 7,311.82 9,841.00 Packet Pg. 110 3.b.1 RUN DATE 08/20/2014 TIME 09:50:31 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  **June Transactions** SUNGARD PENTAMATION, INC. PAGE NUMBER: 31 DATE: 08/20/2014 OKALOOSA COUNTY BOCC AUDIT11 TIME: 09:50:22 EXPENDITURE TRANSACTION ANALYSIS SELECTION CRITERIA: transact.yr=’14’ and transact.period=’9’ and transact.fund=’104’ ACCOUNTING PERIOD: 11/14 FUND − 104 − TOURIST DEVELOPMENT FUND DEPARTMENT − 711242 − FDOT URBAN CORR 12 (O) ACCOUNT DATE T/C ENCUMBR REFERENCE VENDOR BUDGET EXPENDITURES ENCUMBRANCES DESCRIPTION 547002 PRINTING & BINDING 9 /14 06/06/14 17 21401470−01 21300007 INTERMOUNTAIN CO 424.35 8" X 10.50 RIDE GUIDE, MA TOTAL PRINTING & BINDING .00 .00 424.35 TOTAL FDOT URBAN CORR 12 (O) .00 .00 424.35 TOTAL TOURIST DEVELOPMENT FUND .00 1,028,407.81 −58,875.98 TOTAL REPORT .00 1,028,407.81 −58,875.98 Packet Pg. 111 3.b.1 RUN DATE 08/20/2014 TIME 09:50:31 SUNGARD PENTAMATION, INC. − FINANCIAL ACCOUNTING Attachment: III.b. Financial Update (3205 : Financial Update - August)  3.c Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Update Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3206) DOC ID: 3206 FY15 Budget Update Updated: 8/22/2014 4:37 PM by Aida Wilkinson Page 1 Packet Pg. 112  3.c.1 TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: May 29, 2014 TO: Tourist Development Council FROM: Ed Schroeder, Tourist Development Department Director Charlotte Dunworth, Finance, Administration, & Compliance Manager SUBJECT: FY 2014-15 Budget Update Background A budget meeting was held on May 8 to educate the TDC on various entities receiving tourist development tax dollars and how those dollars are spent, as well as to allow the TDC to reach consensus on desired priorities and funding levels for FY 2014-15. The proposed FY 2014-15 Tourist Development Department budget was presented to the TDC on May 29, and subsequently presented to Attachment: III.c. FY15 Budget Update (3206 : FY15 Budget Update) the County Administrator on June 5 and Board of County Commissioners on August 12. Discussion Two significant decisions have been made since the budget was reviewed by the TDC in May: 1. Horizons will be solely responsible for beach park bathroom cleaning next year at an annually contracted amount of $138,549. 2. Public Works will perform beach cleaning and raking at an annual interfund transfer amount of $283,308 including one-time equipment purchases. Visual representation of the proposed FY15 budget: Packet Pg. 113  3.c.1 The BCC will hold public hearings on the FY15 budget on September 4 & 15. The TDC will review the final BCC-adopted budget on September 18 (tentative). TDC Recommendation to BCC For informational purposes only; no recommendation needed. Attachment: III.c. FY15 Budget Update (3206 : FY15 Budget Update) Packet Pg. 114  3.d Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Update Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3207) DOC ID: 3207 Promotional Reserves Update Updated: 8/22/2014 4:42 PM by Aida Wilkinson Page 1 Packet Pg. 115  3.d.1 TOURIST DEVELOPMENT DEPARTMENT MEMORANDUM DATE: August 28, 2014 TO: Tourist Development Council FROM: Ed Schroeder, Tourist Development Department Director Charlotte Dunworth, Finance, Administration, & Compliance Manager SUBJECT: Promotional Reserves Update Background Per the Revised Strategic Marketing Plan adopted by BCC 5/6/14: “Promotional Reserve funds are budgeted for promotional opportunities that may arise which were unknown when developing the SMP. Attachment: III.d. Promo Reserves Update (3207 : Promotional Reserves Update) To the greatest extent possible, such opportunities will be presented to the TDC for recommendation to the BCC for approval in advance. However, these funds may be appropriated in accordance with County approval authority and with concurrence of the TDC Chairman if an opportunity would be lost due to the timing of regular TDC and BCC meetings. In such case, the TDC and BCC will be apprised of the use of these dollars at their next regularly scheduled meetings”. Discussion Promotional reserves have been used on several occasions since the June TDC meeting. The TDC is hereby being apprised, for informational purposes only, of the following uses which have already occurred: A. $9,500 for advertising with Funway Holidays International Inc. in order to reach the UK market. The Funway marketing plan is based on a consortium of eight Florida CVBs contributing to the campaign, and many of our competitors have already jumped on board (Cocoa Beach, Sarasota, Bradenton, Daytona and Pensacola). There were only 3 available slots, so the opportunity may have been lost if TDC and BCC approvals were obtained in advance. This time-sensitive opportunity was vetted with the TDC Chairman, and approved in accordance with County approval authority. This use of promotional reserves was presented to the BCC on August 19. (TO 145) B. $18,895 for a social media sweepstakes, email opt-in button on the website in conjunction with visitors guide requests, and development of three pop-up banners for use at trade shows. The pop-up banners are needed for a trade show being attended in early September. This use of promotional reserves was approved in accordance with County approval authority and presented to the BCC on August 19. (TO 144) C. $1,000 for American Bus Association digital advertising included in the original Strategic Marketing Plan adopted in November 2013, but omitted from groups-targeted task orders and removed from the revised Strategic Marketing Plan although digital banners had already run in February/March 2014. This use of promotional reserves will be presented to the BCC on September 2. (TO 124 revised) D. $9,000 of FY14 promotional reserves and $13,500 of FY15 promotional reserves to fly aerial banners at Alabama and Auburn home football games and the NASCAR race at Talladega. Reserves are being identified by fiscal year due to the timing of football games. Since the first football game is Aug 30, a purchase order has been issued in accordance with County approval authority. This use of promotional reserves will be presented to the BCC on September 2. E. $95 for ECCC listing in Convention South’s 2014 Directory of Meeting Sites in the South as well as website listing. A half-page magazine ad is included in the Strategic Marketing Plan, but the directory listing is not specifically identified. To meet the directory deadline, payment has been made via credit card. This use of promotional reserves will be presented to BCC on September 2. F. TDC Recommendation to BCC For informational purposes only; no recommendation needed. Packet Pg. 116  3.d.1 A recommendation from the TDC is hereby being requested for the following uses of promotional reserves, as these activities have not yet occurred: A. $3,503 to edit the previously developed couples tv ad to make it fall-oriented by adding in a new voiceover and including specific fall festivals happening in the area. This use of promotional reserves will be presented to the BCC on September 2. (TO 132 revised) B. $1,413 to edit the previously developed fall seasonal radio ad to make it current and include specific fall festivals happening in the area. This use of promotional reserves will be presented to the BCC on September 2. (TO 133 revised) TDC Recommendation to BCC Approve the use of promotional reserves as identified for radio and tv edits for the fall season. Attachment: III.d. Promo Reserves Update (3207 : Promotional Reserves Update) Packet Pg. 117  4.a Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Presentation Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3208) DOC ID: 3208 Visitor Profile Survey (UWF HAAS Center) Updated: 8/22/2014 4:45 PM by Aida Wilkinson Page 1 Packet Pg. 118  4.a.1 Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Emerald Coast Visitor Profile Survey EMERALD COAST CONVENTION AND VISITORS BUREAU: AUGUST 28, 2014 Packet Pg. 119  4.a.1 Table of Contents Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS 1. Research Purpose 2. Research Methodology 3. Key Findings 4. Economic Impact of Overnight Visitors Packet Pg. 120  4.a.1 Research Purpose Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS 1. To identify certain demographic characteristics of visitors to the Emerald Coast 2. To estimate party size and length of stay by accommodation type 3. To estimate the spending patterns of these visitors 4. To more accurately estimate unique visitors to the Emerald Coast Packet Pg. 121  4.a.1 Research Methodology Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS How are we collecting data? • Survey professionals spend 16 hrs/week conducting intercept surveys • Data collection methods randomized- different locations, days of the week and time of day Survey Responses • 638 visitors participated in the survey between March and May 2014 • More than 2,000 adults were asked to participate, resulting in a 32% response rate Packet Pg. 122  Key Findings What is the Demographic Profile of Visitors? 4.a.1 Packet Pg. 123 Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS  4.a.1 Age Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Distribution of Age Distribution of Survey Participants Visitors & 30% Party 25% 20% o Flat age distribution 15% indicates a diverse sample 10% o 47% under 35 5% 0% o 15% of all party Under 18 18 - 25 26 - 35 36 - 45 46 - 55 56+ members were Members of Party Surveyed under 18 (10% of all participants) Packet Pg. 124  4.a.1 Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Household Household Income Distribution of Survey Participants Income 25.0% 20.0% 15.0% o Approximately 55% of sample reported a 10.0% household income of 5.0% over $60k a year 0.0% < $40,000 $40K - $60K - $75K - $100K - > $150K Unwilling $60K $75K $100K $150K to respond Packet Pg. 125  4.a.1 Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Origins of Visitors o 18.5% of visitors come from Florida o Followed by GA (8.2%), LA (6.0%) and TX (5.2%) o CA, NY and MO also show up in the bottom of the Top 10 Origin States o 3% of sample reported visiting from outside the continental US, including Canada, Puerto Rico, England and Argentina Packet Pg. 126  4.a.1 Transportation & Lodging Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Where did you stay during How did you travel to the your trip to the Emerald Emerald Coast? Coast? Transportation Type Location of Lodging 2% 0% 2% 6% 1% 10% 19% 49% 9% 87% 15% Destin Fort Walton Beach Boat Car Other Plane RV Day Trip Only Okaloosa Island Staying overnight outside the area Unsure Packet Pg. 127  4.a.1 Party Size and Length of Stay Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Party Size Length of Stay Table 2. Distribution of Party Size Table 7. Length of Stay Party Size Percent Range Percent One 11.2% < 3 days 8.5% Two 46.2% 3 - 5 days 42.8% Three 17.5% 6 - 7 days 21.4% Four 8.6% 8 - 10 days 6.2% Five 8.3% 11 - 14 days 8.0% Six 3.1% 15 - 30 days 9.6% Seven 2.4% 31 - 60 days 2.8% Eight 0.8% > 60 days 0.7% Nine 0.6% Type of Lodging Avg Days Ten 1.3% Condo 12.4 Average Party Size 2.9 Hotels 4.7 Median Party Size 2.0 House Rental 21.1 Packet Pg. 128  4.a.1 Visitors Purpose and Activities Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Why are people visiting the Emerald Coast? • 80% travel to the area for vacation • Another 9% are here to visit family or friends • Business (3.6%), shopping (2.2%) and part of a group (1.9%) were also listed as reasons What activities do visitors participate in while in the area? • 92.5% of respondents go to the beach; 22.2% participate in fishing; and 12.2% partake in water sports • 67.4% take advantage of Emerald Coast’s shopping destinations Packet Pg. 129  4.a.1 Key Findings Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS What are the spending patterns of visitors to the Emerald Coast? Packet Pg. 130  4.a.1 Average Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Spending Average Spending Per-Person, Per-Night Emerald Coast Patterns Expenditure Type Okaloosa Okaloosa % o More than a 1/3 of spending is allocated Accommodations $54.02 36.8% to Accommodations Food & Beverage $25.09 17.1% o Visitors also spend a significant portion Entertainment $18.49 12.6% on Shopping 26.7% o Transportation costs Shopping $39.21 26.7% are less significant for visitors to travel Transportation $7.90 5.4% to Okaloosa, at only 5.4% Miscellaneous $2.27 1.5% Packet Pg. 131  4.a.1 What is the differences in spending pattern between visitors with various types of lodging? Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS PER-NIGHT, PER-PERSON by Lodging Type of Lodging Accommodations Food Entertainment Shopping Transportation Misc. Total Campground/RV $21.50 $28.57 $23.78 $39.64 $14.91 $1.07 $129.47 Condo $65.17 $23.79 $18.66 $44.06 $6.90 $1.99 $160.57 Hotel $54.78 $30.85 $21.94 $36.31 $9.52 $2.71 $156.11 House Rental $38.49 $17.07 $7.14 $44.98 $4.97 $1.31 $113.96 Friends/Family $3.54 $18.27 $8.02 $27.27 $8.09 $2.05 $67.24 Packet Pg. 132  4.a.1 Based on the data, what is the estimated number of unique visitors during the Spring Quarter? Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Number of Unique Visitors to the Emerald Coast, Spring Quarter 2014 Distribution of Bed Tax Q2 Avg. Nightly Party Length of Type Revenue Total Nights Visitors Bed Tax 2014 Rate Size Stay (Days) Condo 57% $1,867,956 $37,359,119 $124.84 299,256 3.04 12.44 73,130 Hotel/Motel 29% $943,041 $18,860,813 $109.32 172,528 2.76 4.70 101,315 House Rental 15% $489,003 $9,780,069 $85.87 113,894 4.88 21.12 26,316 Total Unique Visitors: 200,761* *Does not include visitors to the area that stay with friends/family or at a campground /RV park. Packet Pg. 133  Key Findings How satisfied are visitors to the Emerald Coast? 4.a.1 Packet Pg. 134 Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS  4.a.1 Satisfaction & Visitors Who Plan To Return to the Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Return Emerald Coast in the Next Twelve Months Potential o Approximately 52% were first time 31% 35% visitors, 48% repeat guests to the Emerald Coast o Nearly half make multiple trips to the area annually o 88.8% were very satisfied with trip, 34% another 10.2% satisfied Don't Know No Yes o 99.7% said they’d refer the area to family or friends Packet Pg. 135  4.a.1 Economic Impacts Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS What are the economic impacts of overnight visitors to the Emerald Coast? Packet Pg. 136  4.a.1 Total Attachment: IV.a. Visitor Profile Presentation (3208 : Visitor Profile Survey (UWF HAAS Economic Total Economic Impacts Associated with Impact Emerald Coast Tourism March 2013 - February 2014 o Impacts only take Total Value into account Impact Type Employment Labor Income Output Fiscal Impact Added overnight visitors to the area Overnight Visitors to 8,896 $251 million $445 million $805 million $178 million the Emerald Coast o Calculations are based on bed tax Tourism-Related data collected Construction 283 $12 million $15 million $30 million $5 million between March 2013 and February 2014 Total 9,179 $263 million $460 million $835 million $183 million o $28,652 in labor income per job supported Packet Pg. 137  4.b Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Presentation Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3209) DOC ID: 3209 Agency Update Updated: 8/22/2014 4:46 PM by Aida Wilkinson Page 1 Packet Pg. 138  August 28, 2014 AGENCY REPORT 4.b.1 Packet Pg. 139 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  4.b.1 Packet Pg. 140 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update) 2  Fall Print 4.b.1 Packet Pg. 141 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Fall Outdoor Boards 4.b.1 Packet Pg. 142 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Fall Online Banners 4.b.1 Packet Pg. 143 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  EmeraldCoasting.com 4.b.1 Packet Pg. 144 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  4.b.1 Radio Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update) https://www.youtube.com/watch?v=AW MzE2xqsFQ&list=UUIwK9OrHwB- tdCMh6eBAOZA Let’s Go #Emerald Coasting Packet Pg. 145  4.b.1 Fall TV Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update) https://www.youtube.co m/watch?v=1grPeqWEL ms&list=UUIwK9OrHwB- tdCMh6eBAOZA Packet Pg. 146  4.b.1 Packet Pg. 147 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Social 4.b.1 Packet Pg. 148 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Christmas Online Banners 4.b.1 Packet Pg. 149 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Christmas Landing Page 4.b.1 Packet Pg. 150 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Snowbird Online Banners 4.b.1 Packet Pg. 151 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  EmeraldCoasting.com 4.b.1 Packet Pg. 152 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update)  Thank You 4.b.1 Packet Pg. 153 Attachment: IV.b. TDC_Presentation_8.28.14 (3209 : Agency Update) 15  5.a Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3210) DOC ID: 3210 ECCC Sales Marketing Reports Updated: 8/22/2014 4:49 PM by Aida Wilkinson Page 1 Packet Pg. 154  5.a.1 Sales Marketing Report July 2014 Tisha Maraj CMP, Sales Marketing Manager Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) PROPOSALS & Letters of Intent ISSUED Number ECCC Projected Comments Aramark F&B Company Event Dates Accom Req of Revenue New/Repeat Value Attendees 100 Black Men Leadership Summit 12/12-14/2014 $3,500.00 New Yes $15,000.00 200 Total ECCC Projected Revenue $3,500.00 $15,000.00 Leads Generated to Partners Company Event Total Room Nights Miller-Coors Company Meeting 1150 Total Room Nights Packet Pg. 155  5.a.1 Sales Marketing Report July 2014 Tisha Maraj CMP, Sales Marketing Manager Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) Site Inspections Tours Provided Company/person Event Jennifer Bafundo Wedding Brandon Williams Conference John Elamad Prayer Servcie Janet Marie Bridal Expo Garret Grubbs Sherwood Baptist Leads - Reactive Company/Person Event Action Outcome 96 MDG, Eglin Holiday Party Email, phone Space on hold Briana Batts Wedding Email, phone negotiating Pooja Patel Wedding Email, phone looking at dates Paula Dell-Beasley Dance Competition Email, phone Dates Lois Anderson Wedding Email, Phone negotiating Gulf Coast Accessory Show Expo Emails planning stages Ian Garrison Concert Email, phone negotiating Byanna Cobbs Wedding/Reception Email, phone holding dates Leads - Proactive Company/Person Event Action Outcome Emails to some of CMCA Leads Various my contacts Building relationships Tallahasse Corporations Various Web searchs Research Packet Pg. 156  5.a.1 Sales Marketing Report July 2014 Tisha Maraj CMP, Sales Marketing Manager Contracts Issued Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) ECCC Projected Comments Aramark Number of Company Event Dates Revenue New/Repeat F&B Value Attendees Jennifer Bafundo Wedding Reception 3/21/2015 $1,500.00 New $8,000.00 300 Pirate's Bay Conod Assoc Meeting 9/20/2014 $150.00 Repeat $0.00 60 TBS Comics Game Workshop 1/29-30/2016 $1,500.00 Repeat $500.00 100 Lambert Vet Supply Workshop 9/20/2015 $500.00 New $1,000.00 40 CVB Meeting Board Meeting 8/28/2014 $0.00 Repeat $0.00 50 Jmark Fisher Seminar 9/16/2014 $200.00 Repeat $50.00 120 Lara Robiduex Party 9/12/2014 $300.00 New $900.00 60 Total ECCC Revenue Projected $4,150.00 F&B Total $10,450.00 Packet Pg. 157  5.a.1 Sales Marketing Report July 2014 Tisha Maraj CMP, Sales Marketing Manager Lost/Denied Business Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) ECCC Projected Comments Number of Company Event Dates Revenue New/Repeat Attendees Chose not to have Fire & Ice Dance Competition 7/27&28/2014 $8,000.00 event at all 800 Odysey Management Chose not to have Service Boat Show 3/10-15/2015 $15,000.00 event at all 500 Total ECCC Revenue Lost $23,000.00 Marketing / Public Relations / Tradeshows Call with SDR to review call leads PM Calls Call with Ungerbock to Review Sales Goals Reports Call with Ungerbock to Review CRM Call with Kevin at Knowland Group Tourism Committee Packet Pg. 158  5.a.1 Sales Marketing Report July 1, 2014 - July 31, 2014 April Sarver, Sales Marketing Coordinator PROPOSALS ISSUED Number ECCC Projected Comments Aramark Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) Company Event Dates Accom Req of Revenue New/Repeat F&B Value Attendees Marriage Retreat Franklyn Ave Baptist Scenario 1 08/19-21/2016 $ 15,490.00 New Y $21,000.00 700 Marriage Retreat Franklyn Ave Baptist Scenario 2 08/19-21/2017 $ 15,205.00 New Y $0.00 700 Club Flight Level College Fair 10/24/2014 $ 6,554.00 New n $15,000.00 1500 Lakeview Center Families First Conf 05/04-05/2014 $ 7,905.00 New y $2,400.00 400 Total ECCC Projected Revenue $ 45,154.00 Leads Generated to Partners Company Event Total Room Nights Total Room Nights 0 Site Inspections Tours Provided Company/person Event Club Flight/Savier College Fair Carper AF Ball 1 Packet Pg. 159  5.a.1 Sales Marketing Report July 1, 2014 - July 31, 2014 April Sarver, Sales Marketing Coordinator Leads *reactive Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) Company/Person Event Source Action Outcome not approved by Charles Rados IOS5 Instructor methology web corresponded via email commander Savier Stephens College Fair Phone Proposal, Tour Contract found a possible Sara Glessenkamp Cvw Prom 2015 Email availability holding Michelle Wedding Phone Spoke and emailed considering Jeremy Gavida Holiday Party Phone Spoke and Emailed Elena Aldridge Conference Phone Spoke and emailed Proposal Tyresa Johnson Birthday for Husband Phone Spoke and emailed Considering Sherry AAPM Annual Conference Phone Spoke and emailed Date not avail Justin Tranchita Comedy Phone Spoke and emailed considering have not heard Amanda Mcdaniels Wedding Web Emailed back Considering Aug Shalone Convention Phone Emailed and spoke 2016 1st choice not avial, holding Bobbie / Applied res Holiday Party Phone Emailed and spoke 2nd choice wants to bring nadela 1st bday web Emailed and spoke own food pricing was an issue and did not show up for Kristen Paige 21st bday web Emailed and spoke her tour niceville c/o 75 no response samantha and sheila reunion web emailed both from either 2 Packet Pg. 160  5.a.1 Sales Marketing Report July 1, 2014 - July 31, 2014 April Sarver, Sales Marketing Coordinator Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) MTI Sound and This was a sales Andrew / Festival Lighting Web Emailed tactic considering, but wants to bring Rosa Escobar Quinceanera Walk in Spoke and emailed own food Tammy Weding Web Emailed Date not avail David Extreme Spirit Cheer Phone Emailed and spoke Date not avail have not heard Angelia Wedding web emailed back Prospects *proactive Company/Person Event Source Action Outcome no recponse, removed as Niceville Emailed and called, second option Samantha Homecoming Lost Business date became available from calendar Conditions Reached out to just be became more sure she was not able favorable, went Dawn / BAE Holiday Party Lost Business to have holiday party to contract 3 Packet Pg. 161  5.a.1 Sales Marketing Report July 1, 2014 - July 31, 2014 April Sarver, Sales Marketing Coordinator Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) Contracts Issued ECCC Projected Comments Aramark F&B Number of Company Event Dates Revenue New/Repeat Value Attendees Club Flight Level College Fair 10/24-25/2014 $5,474.00 New $15,000.00 1500 Gulf Coast Wedding Gulf Coast Wedding Expo Expo 11/16/2014 $2,341.00 Repeat $0.00 500 BAE Holiday Party 12/6/2014 $850.00 Repeat $7,700.00 220 Total ECCC Revenue Projected $8,665.00 F&B Total $22,700.00 Lost/Denied Business ECCC Projected Comments Number of Company Event Dates Revenue New/Repeat Attendees Worked with client for months and they ultimately decided against Building Homes for Heros Fund Raiser Banquet 10/4/2014 $2,800.00 event. 600 canceled due to not being prepared (rescheduled Gulf Coast Wedding Gulf Coast Wedding 9/28/2014 $2,998.00 later) 500 Total ECCC Revenue Lost $5,798.00 4 Packet Pg. 162  5.a.1 Sales Marketing Report July 1, 2014 - July 31, 2014 April Sarver, Sales Marketing Coordinator Marketing / Public Relations / Tradeshows 1. Sent Constant Contact Newsletter Attachment: V.a. ECCC Sales Report July 2014 (3210 : ECCC Sales Marketing Reports) 2. Attended ECPro Luncheon 3. Participated in FB and Twitter Posts 4. Hotel Meeting w/ Four Points 5. Attended Uncle Bucks Grand Opening 6. Attended FWB Chamber FF Breakfast 7. Apr Accredidation Study Group 8. Tradeshow Collaboration for 2015 shows 9. Many Catering meetings regarding changes, sales & processes 5 Packet Pg. 163  5.b Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Report Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3211) DOC ID: 3211 Group Sales Marketing Reports Updated: 8/22/2014 4:51 PM by Aida Wilkinson Page 1 Packet Pg. 164  5.b.1 Packet Pg. 165 Attachment: V.b. Group Sales Marketing Reports (3211 : Group Sales Marketing Reports)  5.b.1 Packet Pg. 166 Attachment: V.b. Group Sales Marketing Reports (3211 : Group Sales Marketing Reports)  5.b.1 Packet Pg. 167 Attachment: V.b. Group Sales Marketing Reports (3211 : Group Sales Marketing Reports)  5.b.1 Packet Pg. 168 Attachment: V.b. Group Sales Marketing Reports (3211 : Group Sales Marketing Reports)  6.a Tourist Development Council Meeting: 08/28/14 02:00 PM 1540 Miracle Strip Parkway Department: Tourist Development Council Fort Walton Beach, FL 32548 Category: Update Prepared By: Aida Wilkinson SCHEDULED Initiator: Aida Wilkinson Sponsors: TDC ITEM (ID # 3212) DOC ID: 3212 Destin Seafood Festival Request for Funding (Kathy & Mike Eller) Updated: 8/22/2014 4:55 PM by Aida Wilkinson Page 1 Packet Pg. 169  6.a.1 Packet Pg. 170 Attachment: VI.a. Destin Seafood Festival (3212 : Destin Seafood Festival Request for Funding (Kathy & Mike Eller))