Loading...
HomeMy WebLinkAbout2006-05-24 STAFF REPORTS 1A CITY OF PALM SPRINGS CITY FUNDING FOR TOURISM RELATED ACTIVITIES FY 05/06 Activity Funding Bureau of Tourism 1,481,616 Convention/VisitorsAuthority 1,100,000 Convention Center Operations Cost Suppport 2,150,583 Debt Service 3,456,745 Expansion Debt Service 2,000,000 Total Convention Center Costs 7,607,328 Event Funding International Film Festival 350,000 Miss Teen USA 75,000 Mrs. America 25,000 Senior Softball World Series 35,000 Easter Bowl Tennis 15,000 Festival of Lights 54,000 Total Event Funding 554,000 TOTAL FUNDING $10,742,844 TOT Budgeted Revenues $14,040,000 0��2�12b0(o icM I�r'l l l t The Bureau of Tourism is the official AGENDA destination marketing organization 1. Budget Overview for tine City of Palm Springs,California, 2. Stakeholder Repot promoting the City to tourists and the media, 3�. Financial Analysis& thus increasing the City's exposure as a world-class year-round leisure destination Budget Increase Request and'increasing the transient occupancy tax. (2007-2008 and beyond) 4. 2006-2007 Special Projects IACVB% Fropnscd 06/07 Industry A.crngc FSBT Budget Mark B llitizer Tota[Dirco ._ d36U 55% Promotions Executive Director T.(,IUbo. 35.8% 36% Fahn Springs Bureau oc,Toryism E.xpens Tom]OtU. 17.6% 9% e`61/J4ZOC> Budge[overview 2005/06 2006/07 Ad,misfig-Media $394,000 $430,408 �.r Trade/Travel Sl,o,vs — $99,300 $10268 ,5_9 I�4.4�/® Pronmtion UIC -- _— $ ,004 $68,004 ✓ Pronvrom,Germany $49,020 M,020 The percentage of total TOT PumiOurization Tups 546,300 56,203 emrz—e Pr a city devotes to fund a &Rc odncrion $S,000 $17,000 Can,r.,ur dSer,iee $49,638 $25,000 CVB/Tourism Bureau 0ffT.Sngplias $7,760 $4,700 Postage&Dclrvory 646800 $54,500 Wage&Bc.efw $579,815 $593,806 VaIt11''ftbL��= l',11V.��'fil4ttir' i Michael Green Pcrcentao-e of total TOT President Pahn Springs Hospitality Associations returned to Palm Springs Member of Planning,Budget,and joint Bureau of Tourism in Advisory Committee on Tourism 2005-2006 Member of PSBT Marketing Committee Owner,Triangle Inn Palm Springs 2 ��1411`' 'fVDl��r' U�AlVW,7l'f 6bl��r Overall PaLn Springs Historical Occupariev/Rate/Rev Par +/-/ Race +/-^/ RcvPar +/I V, 1997 62.7 +1.7 592.06 +6 $57.73 +5.2 RE, R FROM HE 1998 63.8�--+1.9 $97.17 +3.4 $61.98 17.1 1999 64.8 +1.6 $106.33 +9.6 $69.02 +11.4 STAKEHOLDERS TT-�T ^T T C 2000 --64.3 -2.2 Ml 40 +4.6 _970.59 +2.3 S^`�'A➢L�u�.i IOLDERS 2001 59.6 -7.6 $113.83 +22 $66.69 -5.5 2002 61.4 +4.8 F108�49 4T $66.56 0.2 2003 5].7 -6.1 $111.89 +3.1 $6 V.61 3.0 2004 61.5 6.2 $1L3.48 +1.5 $69.79 +5.0 -L0 2005 61.6 $118.59 +3.8 $73.10 +2,8 L-rdi- Cafifordia Lodging Indust,Performance (Overall Palm Springs Historical Occupancy ✓ d-.Cn/�iri/n ^ 2000/01-2004/05 ......a..m� ava n:vw�..a ...,..,. oconpancy Ram 3.45-K 2000/01 5,145Yn - 2002/03 50.73% 2003/04 48.69%^ p$!in-A Spwia gs..... .. •_611.5%: 2004/05 49.55% x1ahn Springs (per zc4enzJ City fngu,r )...�9.Mo/) 3 �r:rinlT Aftab Dada FINANCIAL ANALYSIS Board Member,Pahn Springs & 1-Tospitality Association BUDGET INCREASE Mcmzber of Platming,Budget,and Joint REQUEST." Advisory Committee on Tourism Member of PSBT Budget Committee General Mi anaget,Min Springs Hilton �o.o Vnl r5nl .�a lrn ., 1991-1992 $7,133,293 $1,611,❑8 22.6%� i' ive_-i�na -- .lii1nsra _ — nu^e V. a Viri. .o�JptiS,") � - �55•. 1991 PSBT Budget ooi-nms g/�a A.isu c�3aa Jas ❑n°. b $1,611,118 iav5-wn5 19,0s,162 $1,510.115 _ I (I Constuner Price 1rdex pmrurvie vnvuw�3a rLAnrxM i5r. LL, IN 11�11511N )L u-- 19G 19fi°.-- $2,395,384.69 (48%increase) �9 i S4 . 3J�n F_n01 oI1,L0ld'ti' SI,G8QNi3 l5'�"� __1;11111,,, 2006 PSBT Budget ^_utu]mn .I?.I'_g31! 31,9^R95 IPi b $1,481,516 ?O1�i 20W SI . 19 " SI I°3". 30Uh-20U5 :,I^1?f411N,Glt ➢,481,+O,SIG 51G 11.A% 2.9',6 of he 20I),1/2005 city❑odget..I,yarropriatW to the e5U'r moo r.....Pim 11/1e 1114) zs.¢iasS M,p 4 �� I1r'ibL Vy>W[,1�7IJribh Forunula: 25"/1 of incremental TOT gain 5437,408 , 25"/" = $109,352 02/03T�OT .1. 03/04TOT + 01/05TOT —3 = $12,587,2031nandvv.aq (TOT Guru) (Lmmas a in Budget) 2007/2008 Budget: 04/05TOT - bcaalnnadc= i,mmmcnrd TOT gain $1,481,516 + $109,352 = $1,593,668 +tmkno vn CPI $J3,024,611 - $12,587,203= $437,408 (06/07 (25'I/"TOT (07/08 +unknoml CPl Budget) Gain) Budget) �i.+114i1�I,'i ID1tir' 41,�1!''%l 4X6'17� 2008/2009 Budget: THE REQUEST ($1,593,668+CPI) 1 25%TOT Gan, = $?,77,??? +anlmown CPI (mino n"a11) 2007—2008 Tomsm Budget vicreases by incremental TOT gain and the CPT. •el 10 1111 nrnrvn llnr l,n Jovm Lwlni,ill,.ouu llw $109,352 + CPT 5 Matk Bellinger 2006-2007 Executive Director Paint Springs Bureau ofTouristn SPECIAL PROJECTS Special Project#1 $4 259 Print and Electronic Media ]Full Page— Four-Color Ad Year Total Print Media Bay Via Magazine 10e8/1999 $636,992 1996 2003/2004 SS313,869 $6,540 2006/2007 S•130,408 Full Page — FouT-Color Ad Via Magazine 2006 6 2006 Ads THE REQUEST -,611 include additional Call-to-action Project#1-Increased Print&Electronic➢Media for ➢racl6ng & R.OI pufposes $150,000 s, Vu\li,ta?h`dbl�� V'�\f!M Lil)rfbls'�:� Special Project#2 THE REQUEST Public Relations Efforts ,,,a o;,w� Project#2—Increased Public Rel.rllons Efforts u Oonu.muvo.,,,Sn",....... ,,,Lvm n n, I",,g.c,on,e. ecPre n,l'.,Ln Spn vspee;lie nuke aitL u co u,nn n,vLes` $36,000 7 V,dl! ` %ria117; VNAIfh 47 Ibr7o Special Project#3 Trade &c Travel Shows THE REQUEST Increase visibility of new booth "ur—up"noon, Project#3—Increased Booth Visibiloy ht:m�oalot,l.Titto-,m Sbo.t. At Trade Shows :.�Crenm a'9nne"fur pcln,Spru4sn pale $9�,000 21116/091mdubova `� /JI /11 V�l`i?1 l�f{I tt��• SNJ,I":sl�I,'fll1tl�� Special Project#4 THE REQUEST Ongoing Consumer Research L n„nra.,m"oobe t„�td to cowTmt....-1„o bi*9.m Project#4—Ongoing Consumer Research R—.,b min ot,.I ot 20115/2006 oo—b,oMtio-11, $35,000 remsmd m cr[cen.vly musure 111—nutlslwS do". 8 ,a THE REQUEST 2006—2007 Peojects THANKS ! funded at an additional $230,000 Palm Springs Convention Center Proposed Budget 2006 -2007 Budget Actual/ Projected Budget Variance Q/a Change 01/01/05- 07/01/05- 07/01/06- 06/30/06 06/30/06 06/30/07 Event Income Direct Event Income Rental 593,959 713,826 783,679 190,000 32% Services 179,911 325,590 326,809 147,000 82% Total Direct Event Income 773,870 '1,039,4'17 '1,110.488 337,000 44% Ancillaiy Income AN 29,543 37,750 38,048 9,000 MIX) Concessions& Bar '16,489 18,243 41,786 25,000 152% Catei ing 331,763 589,380 589,904 258,000 78% Novelty 300 - - - 0% Parking 33,335 31,111 32,532 (1,000) -3% Other Ancillary 15,336 70,231 55,140 40,000 261`%i Total Ancillary Income 426,756 746,714 757,410 331,000 784f s Total Event Income 1,200,626 1,786,131 1,867,898 667,000 56% Outside Catei Ing 50,000 50,000 50,000 - cl% Other Operating Income 87,424 84,932 89,370 2,000 2% Pre-Opening Marketing Funds - 136,087 - - Ad)usted Gross Income 1,338,050 2,057,150 2,007,768 670,000 5u% a Inchrect Expenses Employee Wages and Benefits 1,840,632 1,830,684 1,997,771 167,000 9% a Contracted Services 315,860 289,374 357,498 42,000 13% s Operations '17,170 47,729 19,850 3,000 17% Repairs and Maintenance 49,600 51,675 50,550 1,000 2% Supplies 33,440 35,550 41,000 8,000 94% s Insurance 1,872 13,000 14,400 13,000 694% Utilities 535,200 722,874 810,900 276,000 52% ° Marketing and Public Relation 201,261 267,688 248,206 47,000 23% ° General and Administrative 158,015 '148,957 '128,893 (29,000) -18% 10 SMG Management Fee 185,000 '184,998 '188,700 4,000 2% Total Indirect Expenses 3,338,050 3,692,529 3,857,768 520,000 16% Net Income(Lass) from Operations (2,000,000) (1,535,379) (1,850,000) 150,000 -8% Capital Budget Expenditure - Acct# 112-55-2080-43240 (2,000,000) (1,535,379) (1,850,000) 150,000 -8% Estimated 20% Increase Acct# 112-55-2080-49000(Insur) 124,647 124,647 149,580 Acct#11:2-55-2080-49030(MVR) 23,436 23,436 28,128 Acct#112-55-2080-43200(Landscape) - 13,391 16,800 Budget(Summary) P , Palm Springs Convention Center Budget Notes of Variance 2006 - 2007 44% increase in direct event revenue based on currently signed and outstanding conbacts plus expected repeat events not yet under contr act 337,000 2 78% increase in ancillary revenue mainly from catering and telecommunications growth 331,000 3 Overall 505A increase in revenue 670,000 4 Employee Wage and Benefits Less than 5% increase in wages and benefit costs plus addntional operations staff to support increased event load plus Director of Sales position increase 157,000 5 Contract Services $15k increase the result of reclassification of internet services from G&A Category, remaining $271k contract maintenance for new mechanical equipment which is no longer maintained under construction contract after first vear'. 42,000 6 Supplies Additional requirements to support increased event load and increased square footage 8,000 7 Insurance Addition of SMG general liability coverage 13.000 8 Utilities Increase proportionate with increased space and mechanical equipment plus 25% SCE rate hike 276,000 9 Marketing and Public Relations Increased requirements to attain current and future increased revenue targets 47,000 10 General&Administrative $20k reduction in internet services, $5k reduction in cost plus $15k from reclassification to Contract Services, r'emamrng $10k reduction from reduced training and cost saving measures from consolidating administrative function into one central location. (29,000) rr Management Fee Increase based on terms of contract. 4,000 Insiginificant variances in Operations& Repairs& Maintenance 2,000 Overall increase in operating costs 520,000 Net reduction in budget from 05/06 150,000 Palm Springs Convention Center 5 Year Capital Improvement Plan 2006-2007 1 * FFE shortfall (convention chairs &tables) $ 100,000.00 2 * Lobby furniture $ 80,000.00 3 Convert Robertshaw HVAC controls to Alerton System $ 96,000.00 4 * Bathroom repairs/remodel $ 150,000.00 5 Networking diagnostic tool $ 3,630.00 6 Cooling Tower#2 Rebuild $ 30,000.00 7 Cooling Tower#1 Rebuild $ 30,000.00 8 Trash Compactor $ 35,000.00 9 Mesquite A/B Window Coverings/Shutters $ 42,000.00 10 Boardroom renovations & repairs $ 48,000.00 1'I Air Wall rehabilitation/re-fabric $ 250,000.00 12 Chiller replacement $ 260,000.00 13 Install compatible lighting fixtures to blend with expansion $ 490,000.00 14 Airmagnet Enterprise WLAN security system $ 30,000.00 15 Computer workstations $ 13,000.00 $ 1,231,630.00 2007.2008 1 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 3 * Ceiling Tile Replacement to match Expansion $ 7,500.00 4 Gold support renewal on Dell servers $ 3,000.00 5 Ice harvester rebuild $ 25,000.00 6 Replace exhibit hall carpet $ 290,000.00 $ 410,500.00 2008-2009 1 FFE Annual Equipment Replacement $ 75,000.00 21 Computer Workstation Replacements $ 10,000.00 3 Network copier scanner upgrade/replacement $ 20,000.00 4 Network server upgrade/addition $ 20,000.00 $ 125,000.00 2009-2010 1 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 $ 85,000.00 2010-2011 1 FIFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 $ 85,000.00 Note: * expansion related Updated 05-16-06 Palm Springs Bureau of Tourism (Consolidated) Proposed Budget 2006-2007 Actual I Budget Projected Budget Variance % Change 07/0'U05- 07/01/05- 07/0'1/06- 06/30/06 06/30/06 06/30/07 Income Advertising Wall Advertising 34,355 36,830 38,298 4,000 12% Brochure Advertising 36,025 33,648 34,150 (2,000) -6% Website Advertising Link 6,000 5,649 7,027 1,000 17% Website Advertising Banner - - - - WebsiteAdvertising Display Ad 16,605 28,492 42,913 26,000 157% Website Discount Coupon - - - - Adverflsing 92,985 104,619 122,388 29,000 31% 1 Gift Shop Gift Shop Merchandise 94,540 103,498 102,900 6,000 Cost of Goods Sold 51,997 58,917 56,595 (5,000) Net Gift Shop 42,543 44,581 46,305 4,000 9% s Other Operating Income 80,735 180,796 12,499 (68,000) -84% 3 Total Income 216,263 329,996 181,191 (35,000) -16% Expenses Marketing Adveitising 426,400 528,731 448,208 22,000 5% 4 Direct Mail - 64,903 71,500 72,000 5 General Marketing '122,186 189,689 47,872 (74,000) -61% s International Marketing 117,024 115,477 117,024 - Public Relations 2,190 14,959 19,900 18,000 822% Trade& Travel Shows 61,200 89,048 59,334 28,000 46% a Earn Trips 46,800 37646 56,203 9,000 19% s Total Marketing 775,800 1,040,454 850,041 75,000 10% General Employee Wages and Benefits 578,815 514,682 593,806 15,000 3% 10 Contracted Services 89,894 84,890 69,960 (20,000) -22% " General and Administrative 192,839 93,308 87,357 (105,000) -54% 12 SMG Management Fee - - - Operations 5,500 - - (6,000) -100% 13 Repairs and Maintenance 3,915 7,577 7,163 3,000 77% Supplies 7,760 4,055 4,700 (3,000) -39% 15 Insurance 13,946 13,946 16,728 3,000 22% 16 Utilities 29,310 28,644 32,952 4,000 14% Total General 921,979 747,102 812,667 104,000 -11% Total Expenses 1,697,779 1,787,556 (1,662,707) (35,000) -2% Net Income(Loss)from Operations (1,481,516) (1,457,560) (1,481,516) 0% Capital Budget Expenditures 23,956 Net Income (Loss) (1,481,516) ('1,481,516) (1,481,516) 0% Palm Springs Bureau of Tourism Budget Notes of Variance 2006 -20011 1 Advertising Expansion of Website Advertising Campaign 29,000 2 Gift Shop Income Expected increase in cuests 4,000 3 Other Operating Income Visitors Guide Advertising of$79k in 05-06 budget Occurs on an 18 month cycle and will not appear again until fall 07-08. This is offset by the additional of$10k in revenue for providing marketing services to the Convention Center. (68,000) Overall change in revenue (35,000) 4 Advertising Increase in advertising media 22,000 5 Direct Mail Increase from costs that were reclassified from G&A 72,000 6 General Marketing Reductions in Promotions and Video (74,000) Public Relations Increase from costs thatweie reclassified from G&A 18,000 8 Trade &Travel Shows Increase from tradeshow related travel costs that were reclassified from G&A 28,000 8 Fain Trips Increase in Fam Trips 9,000 11 Employee Wage and Benefits $19K increase for Marketing Services to PSCC, Annual increase Wages 3 5%, Benefits 5%, Offset by$14k decrease in part-time wages from closure of retail operations at Uptown Visitor's Center 15,000 11 Contract Services Reclassification of contracted marketinq services to General Marketinq category (20,000) 12 General &Administrative Postage& Delivery for advertising materials. Travel Expenses, and Printing & Reproduction have been reclassified from G&A to Marketing to more accurately reflect their true purpose This has caused a $94.5k reduction in G&A (and corresponding increase in Marketing)from last year's budget due to this reclassification. Remaining $10.5k reduction is result of savings realized in Office Printing from consolidating letterhead for two locations and elimation of some training semmars and publication subscriptions. (105,000) 73 Operations Elimination of one time purchase in 05-06 of security camera equipment (6,000) 94 Repairs and Maintenance Increase from ?? 3,000 15 Supplies Reduction to reflect actual cost incurred in 05-06 plus 10% (3,000) 16 Insurance Anticipated increase in City Allocation for Insurance 3,000 17 Utilities Increase based on 25% SCE rate hike adjusted downward slightly based on actual 05-06 kwh consumption 4,000 Insiginificant variances (1,000) Overall change in operating costs (35,000) Net change in budget from 05106 Jones Aq other Co-op Will MEMEMEMEMEMEM •dnt Publications --------_ _ -- tra" tmel .rNes . 111 ' -fhdrives destinations jdi�I4N, _-_-_tlUectbn/ wime—winl--____-- .. .. --S.S.aGFin ® Greabmys -------- Palm Springs Bureau of Tourism Advertising Plan 2006-2007 MEDIUM CIRCI JULY AUG SEPT OCT NOV DEC JAN FEB MARCH APRIL MAY JUNE TOTALS Recommend Group Tours-Co-op- Leads Generated INTERNATIONAL TRAVEL American Journal- 5,000 travel Germany planner - ON-LINE_ a e - ag.- ✓acationtun.com Trip -onely Planet IRON Trip Advisor -rommers rave am darketplace-E-mail 350,000 online online destinations online onhne online arc 575,000 Marketplace-E-mail 575,00 Joshua Tree °odcast 'wo podcast SUBTOTAL 303,000 $40,000 a Palm Springs Bureau of Tourism Advertising Plan 2006-2007 MEDIUM CIRCI JULY AUG SEPT OCT NOV DEC JAN FEB MARCH APRIL MAY JUNE TOTALS C'y)'a-bi-P'A-+rt PlanetOUT&Gay.com 281,000 on line Bannerlemail Gay Travelenca Banner online PNN Outlook(Canada) Destinations Gay Chicago 20,000 Salt Lake Metro 10,000 Columbia Fun Maps Metro Weekly 15,500 Calif Planner Next NY 50,000 _avender 30,000 or 31,000 ub-total $ 70,000 BUDGET RECAP TOTALS 4EOIATOTAL $0 f0 $0 $0 $0 80so SO $0 SO $0 $0 S 413,000 DONITINGtNCY SPENDING S 17,408 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ S 17,408 - S 430,408 Budget $430,408 2003 tCVB Organizational & Financial Profile—IACVB =oundadOn WMA Check --Out Tax Rates On average, hotel Chef{-ollt tax raids are abOUI. 12.2 Pcrcent. A sionill[a!lt 73i lib i {n Ci',% �0) Of Uh Ia: rC':rei iii'L` IS !sually Z';e\%OteCi t €c`�.tr�B. Average hotel rOOm tc:;eS are somelvhat iIIQller in 11 GeSlnailOnS represented by Id€yCf t. oS. This iinuing is iOi,SES�-,ns with .hat of past studies, I 13.1% 13.1% i 12.2% '12.3% 11.7% '12.1% I f All Less Than $5130.OD0- $1,COD,000- S2,000.000- 95,000,000- $10.000,CDD Respondents c5nn Min51999,999 54.999,99959,999,.�i99 - or More - Budgw Categories Roo. I,N Collections & Usc The char below shows the various allocations of the collected Room Tax. As one can see, CVB Funding is the most prominent use of the Room Tax. -�.A% 3$.$% 37.2% j 25.7% 24.4% Conv Cntr Operations, C;rB Other Visitor arenas and Other Nan-Visitor Construction, Funding Related Sports Facilities Related Purposes or Debt Sere Purposes 1 �+v 1 _ ofQ 1 1I BUREAU OF TOURISMf' - Overall Palm Springs Historical Occupancy/Rate/Rev Par 1997-November 2005 % +/- % Rate +/- % RevPar +/1 % 1997 62.7 +4.7 $92.06 +6 $57.73 +5.2 1998 63.8 +1.8 $97.17 +3.4 $61.98 +7.4 1999 64.8 +1.6 $106.53 +9.6 $69.02 +11.4 2000 64.3 -2.2 $111.40 +4.6 $70.59 +2.3 2001 58.6 -7.6 $113.83 +2.2 $66.69 -5.5 2002 61.4 +4.8 $108.49 -4.7 $66.56 -0.2 2003 57.7 -6.1 $111.89 +3.1 $64.61 -3.0 2004 61.5 6.2 $113.48 +1.5 $69.79 +8.0 2005* 61.6 -1.0 $118.59 +3.8 $73.10 +2.8 2006 C'affforinica Loidginly Industry Perforrnanicra,lc Room Occulpancy Percentage All Roam Ratc 2004 AMA U/1.1 Che 2 0 U r, if. 011 I I F L'Llj 11 l"; :,-.v If i ni Il ji 01 j I 1:1 h j I D . . . .... .. . cl ul L..,..;.. 6 2 7 i :1 1 uj ll I il IJ L 0 1 :1[1-,i I, ... ....... ... II1tmra j j j LI "I Ic". it Ill[]I:11 IM; ......73.v ......... 47 i I f LT:fT rj SYi,, RI v 7 3 -1 ............... . (3 ..... ... r1 I A 11:-J i-I l;I L '.L------ ............. .l Ci ;7 il17, ....... -i d!'5 ... N h I-) L)j 1 . ......... ii2"'Jo ... ........ 7'1 1 1 f . r,.,.. ... 2 3 %TvPW 'D I-cl i rvg-c-3 F- B'J 01 ol-I 5 2462. �.cnnm. vx -i-onsurner ynce Index Calculator ,Tag- 1 of 2 Bdnk of Minneapolis He I'm at: Hfime > Economic Research 9L Data > Dala > U.S. Dim > CPI Calculator Economic 'What is adollar worth? Research tir & Data .__ The Consumer Price Index (CPI) is a measure of , the average change in prices over time in a market ,,,,Expand All basket of goods and services. Collapse ,601 G Research Archive w Consumer Price Index and Inflation Rates Z913- i . Consumer Price Index and Inflation Rates fEstimate, T800- p Special '.Studies . Bureau of Labor Statistics - regional and commodity/service • Banking and group indexes Policy Studies + How the C1�4_is used to make these calculations • Staff Directions: Enter years as 4 digits (i.e. 1913) through 2006. Enter Subscriptions dollar amount without commas or$ sign in box on first line. Click Oratsh Calculate button to compute dollar amount shown on second lone. y Seminars I( If in 1997 (year) d •G' PI ��-. I bought goods or services for 1,6Z171EA0 FY f d then in 2006 (year) the same goods or services would cost $ 2305334.69 _ - Calculate Reso¢ t�. �!%✓"1 Pt 111 i i 0t /d Notes: l�r ft 7 i • Limited to years from 1913 to 2006. • Data from consume¢' price indexes for all major expenditure class items. . An estimate for 200E is based on the change in the CPI from fourth quarter 2004 to fourth quarter 2005. . Base year is chained; 1982-1984 = 100 • 3avaScript-enabled browsers only. How the CPI is used to make these calculations, • What would an item or service purchased in 2006 be worth in 19?? dollars? Example: 1-he CPI is used to calculate how prices have changed over the years. Let's say you have $7 in your pocket to purchase some goods and services today. I-low much money would you have needed in 1950 to buy the same amount of goods and services? 1 krttf://waodrosv.rnpls.frU.fed.tis/researchdata/us/c:ilc/ 5/7/2006 Year TOT PSRT % of TOT 1991-1992 $7,133,293 $1,611,118 22.6% 1992-1993 $7,040,031 $1,406,569 20.0% 1993-1994 $7,207,109 $1,356,841 18.8% 1994-1995 $7,647,158 $153445335 17.6% 1995-1996 $8,341,137 $1,400,228 16.8% 1996-1997 $9,092,342 $1,2925313 14.2% 1997-1998 $9,675,462 $1,510,058 15.6% 1998-1999 $10,900,934 $1,460,819 13.4% 1999-2000 $11,742,588 $1,48,1516 12.6% 2000-2001 $115681,444 $1,622,853 13.9% 2001-2002 $12,046,053 $1,677,000 13.9% 2002-2003 $12,420,344 $1,728,516 13.9% 2003-2004 $12,3175882 $1,511,516 12.3% 2004-2005 $1330245611 $1,481,000 11.4% 2005-2006 $1,481,000 2.7% of the 2004/2005 City Budget was appropriated to the PSBT Palm Springs Bureau of Tourism (Consolidated) Proposed Budget 2006-2007 Actual/ Budget Projected Budget Variance % Change 07/01/05- 07/01/05- 07/01/06- 06/30/06 06/30/06 06/30/07 Income Advertising Wall Advertising 34,355 36,830 38,298 4,000 12% Brochure Advertising 36,025 33,648 34,150 (2,000) -6% Website Advertising Link 6,000 5,649 7,027 1,000 17% Website Advertising Banner - - - - WebsiteAdvertisingDisplayAd '16,605 28,492 42,913 26,000 157% Website Discount Coupon - - - - Advertising 92,985 104,619 122,388 29,000 31% Gift Shop Gift Shop Merchandise 94,540 103,498 102,900 8,000 Cost of Goods Sold 51,997 58,917 56,595 (5,000) Net Gift Shop 42,543 44,581 46,305 4,000 9% 2 Other Operating Income 80,735 180,796 12,499 (68,000) -84% 6 Total Income 216,263 329,996 181,191 (35,000) -16% Expenses Marketing Advertising 426,400 528,731 448,208 22,000 5% a Direct Mail - 64,903 71,500 72,000 5 General Marketing 122,186 189,689 47,872 (74,000) -61% 6 International Marketing 117,024 115,477 117,024 - Public Relations 2,190 14,959 19,900 18,000 822% 7 Trade&Travel Shows 61,200 89,048 89,334 28,000 46% $ Fam Trips 46,800 37,646 56,203 9,000 19% e Total Marketing 775,800 1,040,454 850,041 75,000 10% General Employee Wages and Benefits 578,815 514,682 593,806 15,000 3% 10 Contracted Services 89,894 84,890 69,960 (20,000) -22% " General and Administrative 192,839 93,308 87,357 (105,000) -54% 12 SMG Management Fee - - - Operations 5,500 - - (6,000) -100% rs Repairs and Maintenance 3,915 7,577 7,163 3,000 77% 14 Supplies 7,760 4,055 4,700 (3,000) -39% 1s Insurance 13,946 13,946 16,728 3,000 22% 16 Utilities 29,310 28,644 32,952 4,000 14% 17 Total General 921,979 747,102 812,667 104,000 -11% Total Expenses 1,697,779 1,787,556 (1,662,707) (35,000) -2% Net Income (Loss)from Operations (1,481,516) (1,457,560) (1,481,516) 0% Capital Budget Expenditures 23,956 Net Income (Loss) (1,481,516) (1,481,516) (1,481,516) 0% 5/16/2006 at 7:51 AM F\USERMACCT\BUDGERTOUR&VIC\06-07\TOUR&VIC Budget 06-07 xis /� Item No. A 1 .A. Palm Springs Bureau of Tourism Budget Notes of Variance 2006 - 2007 1 Advertising Expansion of Website Adverttisina Campaign 29,000 2 Gift Shop Income Expected increase in guests 4,000 3 Other Operating Income Visitois Guide Advertising of$791k in 05-06 budget occurs on an 18 month cycle and will not appear again until fall 07-08.This is offset by the additional of$10k in revenue foi provicling marketing services to the Convention Center. (68,000) Overall change in revenue (35,000) Advertising Increase in advertisinq media 22,000 Direct Mail Increase from costs that were reclassified from G&A 72,000 s General Marketing Reductions In Promotions and Video (74,000) 7 Public Relations Inaeasefrom coststhatwere reclassified from G&A 18,000 e Trade&Travel Shows Increase from tradeshow related travel costs that were reclassified from G&A 28,000 Fain Trips Increase in Fam Trips 9,000 10 Employee Wage and Benefits $10K increase for Marketing Services to PSCC, Annual increase Wages 3.5%, Benefits 5%, Offset by$14k decrease in part-time wages from closure of retail operations at Uptown Vrsitoi's Center 15,000 r' Contract Services Reclassification of contracted marketinq services to General Maiketrncl cateclory (20,000) 12 General &Administrative Postage& Delivery for advertising materials, Travel Expenses, and Printing & Reproduction have been reclassified fiom G&A to Marketing to more accurately reflect their true pur pose.This has caused a $94.5k reduction in G&A (and corresponding increase in Marketing)from last year's budget due to this reclassification Remaining $10.51k leduction is result of savings realized in Office Printing from consolidating letterhead for two locations and elimation of some training seminars and publication subscriptions (105,000) 13 Operations Elimination of one time purchase in 05-06 of security camera equipment (6,000) iA Repairs and Maintenance Increase from ?? 3,000 rs Supplies Reduction to reflect actual cost incurred in 05-06 plus 10% (3,000) 11 Insurance Anticipated increase in CitV Allocation for Insurance 3,000 17 Utilities Increase based on 25% SCE late hike adjusted downward slightly based on actual 05-06 kwh consumption 4,000 Insiginificant variances (1,000) Overall change in operating casts (35,000) Net change in budget from 05106 Palin Springs Convention Center Proposed Budget 2006 -2007 Budget Actual / Piolected Budget Variance `X,Change 07/01/05- 07/01/05- 07/01/06- 06/30/06 06/30/06 06/30/07 Event Income Direct Event Income Rental 593,959 713,826 783,679 190,000 32% Services 179,911 325,590 326,809 141,000 82% Total Duect Event Income 773,870 1.039,417 1,110,488 337,000 44% Anallaiy Income A/V 29,543 37,750 38,048 9,000 30'%a Concessions& Bat 16,489 18,243 41,786 25,000 1521A Catei ing 331,753 589,380 589,904 258,000 78% Novelty 300 - - - 0% Parking 33,335 31,111 32,532 ('1,000) -3% Other Ancillary 15,336 70,231 55,140 40,000 261%, Total Ancillary Income 426,756 746,714 757,410 331,000 780/„ Total Event Income 1,200,626 1,786,13-1 1,867,898 667,000 56°/a Outside Catering 50,000 50,000 50,000 - 0% Other Operating Income 87,424 84,932 89,870 2,000 2% Pre-Opening Marketing Funds - 136,087 - - Adlusted Gross Income 1,338,050 2,057,150 2,007,768 670,000 50% a Indirect Expenses Employee Wages and Benefits 1,840,632 1,830,684 1,997,771 157,000 9%. ° Contracted Services 315,860 289,374 357,498 42,000 '13% s Operations 17,170 47,729 19,850 3,000 17% Repairs and Maintenance 49,600 51,675 60550 1,000 2% Supplies 33,440 35,550 41,000 8,000 24/a ° Insurance 1,872 13,000 14,400 13,000 694% Utilities 536,200 722,874 810,900 276,000 590�u ° Maii<eting and Public Pelotion 201,261 267,688 248,206 47,000 23% s General and Administrative 158,015 '148,957 128,893 (29,000) -18% 10 SMG Management Fee 185,000 '184,998 188,700 4,000 2% Total Indirect Expenses 3,338,050 3,592,529 3,657,768 520,000 16% Net Income(Loss)from Operations (2,000,000) (1,535,379) (1,850,000) 160,000 Capital Budget Expenditure - Acct#112-55-2080-43240 (2,000,000) (1,535,379) (1,850,000) 160,000 -8% Estimated 20%, Increase Acct#112-55-2080-49000(Insur) 124,647 124,647 149,580 Acct#112-55-2080-49030(MVR) 23,436 23,436 28,128 Acct#112-55-2080-43200(Landscape) - 13,391 16,800 5/15/2006 at 3 20 PM Budget(Summary) Page:34 F:\USERS\ACCT\BUDGET\PSCC\0607\PSCC Budget 06-07.xls Palm Springs Convention Center Budget Notes of Variance 2006 - 2007 44% increase in direct event revenue based on cuuently signed and outstanding contacts plus expected repeat events not yet uncler contract 337.000 78% increase in ancillary revenue mainly from catering and telecommunications growth. 331,000 3 Overall 50% increase in revenue 670,000 4 Employee Wage and Benefits Less than 5% increase in wages and benefit costs plus addldional operations staff to support increased event load plus Drrertor of Sales position increase 157,000 5 Contract Services $151< increase the result of reclassification of inteunet services from G&A Category, remaining $271k contract maintenance for new mechanical equipment which is no longer' maintained under construction contract after' fu st veal. 42,000 G Supplies Additional requirements to support increased event load and increased square footage 8,000 Insurance Addition of SMG general liability coverage 13.000 8 Utilities Increase proportionate with increased space and mechanical egwpment plus 25% SCE rate hike 276,000 9 Marketing and Public Relations Increased requirements to attain current and future increased revenue targets 47,000 10 General &Administrative $20k reduction in internet seances, $5k reduction in cost plus$15k from reclassification to Contract Seivices, remaining $10k reduction from reduced training and cost saving measures from consolidating administrative function into one central location (29,000) 11 Management Fee Increase based on terms of contract. 4,000 Insiginificant variances in Opel'ations& Repairs& Maintenance 2,000 Overall increase in operating costs 520,000 Net reduction in budget from 05106 150,000 Palm Springs Convention Center 5 Year Capital Improvement Plan 2006-2007 1 FFE shortfall (convention chairs &tables) $ 100,000.00 2 Lobby furniture $ 80,000,00 3 Convert Robertshaw HVAC controls to Alerton System $ 96,000.00 4 Bathroom repairs/remodel $ 150,000.00 5 Networking diagnostic tool $ 3,630.00 6 Cooling Tower#2 Rebuild $ 30,000.00 7 Cooling Tower#1 Rebuild $ 30,000.00 8 Trash Compactor $ 35,000.00 9 Mesquite A/B Window Coverings/Shutters $ 42,000.00 10 Boardroom renovations & repairs $ 48,000.00 ill Air Wall rehabilitation/re-fabric $ 250,000.00 12 Chiller replacement $ 260,000.00 13 Install compatible lighting fixtures to blend with expansion $ 490,000.00 14 Airmagnet Enterprise WLAN security system $ 30,000.00 15 Computer workstations $ 13,000.00 $ 1,231,630.00 2007••2008 1 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 3 * Ceiling Tile Replacement to match Expansion $ 7,500.00 4 Gold support renewal on Dell servers $ 3,000.00 5 Ice harvester rebuild $ 25,000.00 6 Replace exhibit hall carpet $ 290,000.00 $ 410,500.00 2008••2009 11 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 3 Network copier scanner upgrade/replacement $ 20,000.00 4 Network server upgrade/addition $ 20,000.00 $ 125,000.00 2009••2010 1 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 $ 85,000.00 2010••2011 11 FFE Annual Equipment Replacement $ 75,000.00 2 Computer Workstation Replacements $ 10,000.00 $ 85,000.00 Note: * expansion related Updated 05-16-06