Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Five Flags Center Fiscal Year 2014 Detailed Operating Budget
Masterpiece on the Mississippi Dubuque kital All- America City II 111! 2012 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Fiscal Year 2014 Detailed Operating Budget For the Five Flags Center DATE: April 5, 2013 Leisure Services Manager Marie Ware recommends City Council approval of the Fiscal Year 2014 Detailed Operating Budget for the Five Flags Center. I concur with the recommendation and respectfully request Mayor and City Council approval. /),2t Michael C. Van Milligen MCVM:jh Attachment cc: Barry Lindahl, City Attorney Cindy Steinhauser, Assistant City Manager Teri Goodmann, Assistant City Manager Marie L. Ware, Leisure Services Manager Jennifer Larson, Budget Director Masterpiece on the Mississippi TO: Michael C. Van Milligen, City Manager FROM: Marie L. Ware, Leisure Services Manager DATE: April 4, 2013 SUBJECT: Fiscal Year2014 Detailed Operating Budget For the Five Flags Center X INTRODUCTION The purpose of this memorandum is to request City Council to receive and file the detailed fiscal year 2014 Operating Budget for the Five Flags Center. BACKGROUND During the City's Fiscal Year 2013 budget process the Five Flags budget was adopted with a property tax support of $851,225. The contract we have with SMG to manage the facility states that a detailed budget will be submitted to the City in April prior to the July 1 beginning of the fiscal year. Attached is the detailed budget with the property tax support projected at $854,370. This budget reflects the actual 1.7% CPI - U for FY 2013 being used in the FY 2014 budget preparation. General Manager Joyce White has written (in the booklet), a memorandum to introduce the budget. General Manager Joyce White and Director of Finance /HR Don Howes will attend the meeting and be able to answer any questions the City Council might have. ACTION TO BE TAKEN The action step is that the City Council approve the detailed FY 2014 operating budget for the Five Flags Center submitted by SMG. Prepared by: MLW et cc: Joyce White, Five Flags Ken TeKippe, Finance Director FIVE ! RAGS CENTER Five Flags Center Dubuque, Iowa BUDGET FISCAL YEAR 2014 Managed By: Five Flags Civic Cente. 405 Main Street Dubuque, IA 52001 (563) 589 -4254 Memo To: Honorable Roy Buol, Mayor, City of Dubuque Mike VanMilligen, City Manager, City of Dubuque Marie Ware, Director, Leisure Services, City of Dubuque City Council Members, City of Dubuque Five Flags Commission Members From: Joyce White SMG General Manager Five Flags Center CC: Joe Romano SMG Regional Vice President HR Cook SMG Regional General Manager Date: 3/29/13 Re: FISCAL YEAR 2013 -2014 BUDGET Ladies and Gentlemen: Attached is the proposed FY 2014 operating budget for Five Flags Center. Contractually, the annual increase in Five Flags operating budget is tied to the CPI -U. Last year's FY13 budget was structured around a projected 2% increase in the CPI -U. However, the actual increase in the CPI -U for FY13 was only 17 %. Therefore, consistent with the actual CPI -U for FY13, the FY14 budget projects a 1.7% increase. Accordingly, management has designed the FY14 budget to reflect a Net Operating Loss of ($854,370), an increase of ($14,094) over the previous year's benchmark of ($840,276). Five Flags will be entering the fourth year of operation as a non -ice revenue producing facility and is continuing to redefine and create new business. With an increasing emphasis on non - profit users, last fiscal year, 59% of total programming was comprised by two categories — "Community Events" and "Performing arts" — traditionally low revenue generating programming. Accordingly, the FY 2014 operating budget conservatively projects a 1.6% increase in revenue and a 1.5% increase in operating expenses. Management will continue to seek new programming and explore multiple uses for the Five Flags Civic Center. Five Flags Center / SMG BUDGET - INDEX FYE 06/30/2014 Description Page INCOME STATEMENT 1 INCOME STATEMENT - MONTHLY 2 MONTHLY EVENT SUMMARY 3 OTHER INCOME SUMMARY 5 INDIRECT EXPENSES EXECUTIVE 6 FINANCE 7 MARKETING /SALES 8 OPERATIONS 9 SECURITY 11 EVENTS 12 BOX OFFICE 13 OVERHEAD 14 FOOD & BEVERAGE 15 ADDENDUM A - EVENT SUMMARY 16 ADDENDUM B - SALARIED WAGES 19 ADDENDUM C - HOURLY WAGES 20 Five Flags Center July 1, 2013 - June 30, 2014 Lead Income Statement Event Income Direct Event income Rental Income Service Income Service Expenses Total Direct Event Income FY 2014 Budget FY 2012 FY 2013 Total Actual Variance Actual /Forecast Variance 107,911 118,488 (10,577) 106,407 1,504 143,198 199,859 (56,661) 156,615 (13,417) (138,994) (213,853) 74,859 (149,958) 10,964 112,116 104,494 7,622 113,064 (948) Ancillary Income F & B Concessions 79,672 73,758 5,914 64,969 14,703 F & 13 Catering 2,411 4,643 (2,232) 1,342 1,069 Novelty Sales 5,224 5,540 (316) 5,125 99 Other Ancillary - (466) 466 0 Total Ancillary Income 87,307 83,475 3,832 71,436 15,871 Other Event Income Other Event Related Income - 0 0 0 0 Ticket Rebates (Per Event) 8,742 14,933 (6,191) 11,214 (2,472) Facility Fees 33,825 35,371 (1,546) 36,932 (3,107) Total Other Event Income 42,567 50,304 (7,737) 48,146 (5,579) Total Event Income 241,990 238,273 3,717 232,646 9,344 Other Operating Income 912 4,707 (3,795) 1,089 (177) Adjusted Gross Income 242,902 242,980 (78) 233,735 9,167 Operating Expenses Employee Salaries and Wages 595,498 551,508 43,990 578,847 16,651 Benefits 163,540 144,131 19,409 154,993 8,547 Less: Event Labor Allocations (98,942) (86,290) (12,652) (95,214) (3,728) Net Employee Wages and Benefits 660,096 609,349 50,747 638,626 21,470 Contracted Services 42,226 25,887 16,339 28,552 13,674 General and Administrative 45,641 59,941 (14,300) 63,241 (17,600) Operations 10,454 7,713 2,741 7,639 2,815 Repair & Maintenance 29,096 37,537 (8,441) 28,943 153 Supplies 23,010 13,611 9,399 20,587 2,423 Insurance 32,557 22,151 10,406 25,328 7,229 Utilities 171,823 162,282 9,541 169,021 2,802 Other 0 0 SMG Management Fees 93,965 90,849 3,116 92,531 1,434 Less: Expenses Allocated (11,596) (12,944) 1,348 (12,791) 1,195 Total Operating Expenses 1,097,272 1,016,376 80,896 1,061,677 35,595 Net Income (Loss) From Operations Other Income (Expenses) (854,370) (773,396) (80,974) (827,942) (26,428) (30,395) 30,395 (10,844) 10,844 Net Income After Other Income (Expenses) (854,370) (803,791) (50,579) (838,786) (15,584) Estimated FY 2014 Benchmark (854,560) Estimate 1.7% CPI -All Urban PeachtreeV2BudgetMasterFile FY2014.xis Lead Income Statement 1 Five Flags Center July 1. 2013 - June 30, 2014 Lead Income Statement - Monthly Event Income Direct Event Income Rental Income Service Income Service Expenses Total Direct Event Income Ancillary Income F & B Concessions F & B Catering Novelty Sales Other Ancillary Total Ancillary Income 2,475 2,175 9,850 5,210 24,985 5,810 8,100 8,510 19,481 8,220 7,095 6,000 107,911 1,760 1,300 7,375 11,775 26,529 21,903 18,229 12,349 7,354 16,891 11.148 6,585 143,198 (920) (690) (7,409) (22,930) (30,073) (14,394) (15,458) (9,002) (11,680) (12,466) (9,295) (4,677) (138,994) 3,315 2,785 9,816 (5,945) 21,441 13,319 10,872 11.857 15,155 12,645 8,948 7,908 112,116 549 1,478 5,991 21,677 9,939 1,382 7,801 11.270 2,454 12,199 1,569 3,364 79,672 451 85 437 776 46 241 40 250 85 2,411 2.205 - 1,374 692 310 643 - - - - 5,224 549 1,478 8,647 21,762 11,750 2.850 8,157 12.154 2,494 12,449 1,654 3,364 87.307 Other Event Income Other Event Related Income - - - - - - Ticket Rebates (Per Event) 415 550 1,915 25 1,873 1,882 176 795 504 309 298 - 8,742 Facility Fees 1,360 2,200 2,355 1.050 4,593 4,444 2.100 3,164 4,395 5,505 2,659 - 33,825 Total Other Event Income 1,775 2,750 4,270 1,075 6,466 6.326 2,276 3,959 4,899 5,814 2,957 - 42,567 Total Event Income 5,639 7,013 22,733 16,892 39,657 22,495 21,305 27.970 22,548 30,907 13,559 11,272 241,990 Other Operating Income 76 76 76 76 76 76 76 76 76 76 76 76 912 Adjusted Gross Income 5,715 7.089 22,809 16,968 39,733 22,571 21,381 28,046 22,624 30,983 13,635 11,348 242,902 Operating Expenses Employee Salaries and Wages 46,255 43,391 48,712 49,406 61,355 52,112 49,961 50,628 47,629 51,478 49,859 44,711 595,498 Benefits 13,237 12,902 13,525 13,606 15.007 13,924 13,672 13,750 13,398 13,849 13,660 13,010 163,540 Less: Event Labor Allocations (4,990) (2,126) (7,382) (7,983) (19,770) (10,613) (8,495) (9.162) (6,130) (10,123) (8,597) (3,569) (98,942) Net Employee Wages and Benefits 54,502 54,167 54,855 55 030 56,592 55.423 55.137 55,216 54,898 55,204 54,921 54,152 660,096 Contracted Services 3,519 3,519 3,519 3,519 3,519 3,519 3,519 3,519 3,519 3,519 3,519 3,517 42.226 General and Administrative 5.626 4,010 3.598 3.598 3,653 3,598 3.598 3,598 3,598 3,598 3.598 3,568 45,641 Operations 872 872 872 872 872 872 872 872 872 872 872 862 10.454 Repair & Maintenance 2,427 2,427 2,427 2,427 2 427 2.427 2,427 2,427 2,427 2,427 2 427 2,399 29,096 Supplies 1,920 1,920 1,920 1,920 1,920 1,920 1,920 1,920 1,920 1,920 1,920 1.890 23,010 Insurance 2.713 2,713 2,713 2,713 2,713 2,713 2.713 2,713 2,713 2,713 2.713 2,714 32,557 Utilities 14,318 14,318 14,318 14,318 14,318 14,318 14,318 14.318 14,318 14,318 14,318 14,325 171,823 Other - - - - - - - - - SMG Management Fees 7,830 7,830 7,830 7,830 7,830 7.830 7.830 7,830 7,830 7,830 7,830 7,835 93.965 Less- Expenses Allocated (585) (249) (865) (936) (2,317) (1,244) (996) (1,074) (718) (1,186) (1,008) (418) (11,596) Total Operating Expenses 93,143 91,527 91,186 91,291 91,527 91.376 91,339 91,339 91,376 91,215 91,110 90,844 1,097.272 Net Income (Loss) From Operations PeachtreeV2BudgetMasterFile FY2014.x!s (87,428) (84438) (68.378) (74.323) (51,794) (68.805) (69,958) (63,293) (68,752) (60.231) (77,475) (79,495) (854,370) Lead Income Statement Monthly 2 Five Flags Center July 1, 2013 - June 30, 2014 DIRECT EVENT DETAIL Event Date Event Category Attend. Actual Number of Perf. Event Days Gross Ticket Sales Total Rental Revenue Total Billable Services Total Service Expense Direct Event Income O F &B Concessior I Income F &B Catering Income Novelty Sales Income Total Ancillary Income Other Event Income Ticket Rebates Facility Fees Total Other Event Inc Total Event Income July Performing Arts - 711 1,433 7 28 15,000 2,475 1,760 (920) 3,315 549 - - 549 - 415 1,360 1,775 5,639 July Other -712 - - - - - - - _ - - _ - July Total August Performing Arts - 711 August Other - 712 1,433 7 2,200 4 28 15,000 2,475 19 18,000 2,175 1,760 (920) 5 549 549 1,300 (690) 2,785 1,478 1,478 415 60, ": i "(1,775 5,639 550 2,200 2,750 7,013 August " Total 2,200 ! 4 8,000 2,175 00 (690) '2,785 478 - 478 550s .2,20,0..,.,27 7,01 September Meetings - 708 2,065 3 - 3 - - 1,963 (1,059) 904 750 101 - 101 - - - - November Family Shows - 707 1,005 September Sporting Events - 709 - - 15,400 - - - - - _ _ - - - - _ - - 2 _ September Performing Arts - 711 1,785 10 (1,372) 7 - 850 2,487 (1,870) 1,467 - - - - - - - - 2,215 1,467 September Other - 712 - - 2,281 - - - - _ - - - 1,205 3 - - _ - 3,229 _ September Total " 6,450 14 " ' 11 80,525 9,850 7,375 - (7,409) 9,816 , ' ",5,991 451 2,205 8,647 , ! 1,915a " " ":; 2,355 " ".. 270 ," 22,733 Meetings - 708 545 2 - 2 - 2,600 4,975 (1,550) 6,025 199 85 - 284 - - - - - 6,309 October Sporting Events - 709 1,300 1 - 1 32,530 2,000 5,000 (4,690) 2,310 5,008 - - 5,008 - 25 1,050 1,075 - 8,393 October Performing Arts - 711 1,650 4 - 1 - 610 1,800 (1,360) 1,050 - - - - - - - - 3,600 1,050 October Other -712 900 4 - 4 - - - (15,330) (15,330) 16,470 - - 16,470 - - - - 2,400 1,140 October Total 4 9 32,530 ,210 775; 22,930) ,94 2' 77 21,762 0' 6,892 November Concerts - 704 - - - - - - - - - 750 - - - - - 750 November Family Shows - 707 3,550 3 3 56,165 15,400 13,975 (21,440) 7,935 3,432 - 1,374 4,806 - 1,828 2,832 4,660 17,401 November Meetings - 708 605 2 3 - 2,100 2,391 (1,372) 3,119 - 437 - 437 - - - - 3,556 November Sporting Events - 709 630 1 1 2,215 1,375 2,935 (2,036) 2,274 2,281 - - 2,281 - - 586 586 5,141 November Performing Arts - 711 1,205 3 3 4,693 1,310 3,229 (2,130) 2,409 115 - - 115 - 45 1,175 1,220 3,744 November Other -712 125 1 3 - 1,200 150 (210) 1,140 - - 8,100 - - - - 1,140 November Total 9,615 i 11 7 63,073 24,985 26,529 0,073) 21.441 9 437 1.374 750 1 73 6,466 39.657;' December Consumer / Public Shows - 703 - - - - - - - - - 750 - 750 - - - - 750 December Concerts - 704 2,832 3 2 141,913 3,300 16,008 (10,993) 8,315 1,245 - 692 1,937 - 1,419 2,794 4,213 14,465 December Entertainment - 706 - - - - - - - - - - - - - - - - _ December Meetings - 708 25 1 1 - - - - - - 26 - 26 - - - - 26 December Sporting Events - 709 - - - - - - - - - - - _ _ - - - _ December Performing Arts - 711 1,700 3 5 23,187 1,510 5,239 (2,861) 3,888 93 - 8,100 93 - 463 1,650 2,113 6,094 December Other -712 750 2 2 - 1,000 656 (540) 1,116 44 - - 44 - - - - 1,160 December Total 07 9 0 6 0 5 0 21.91 (14,394) 13 9 1.382 776 692 2,850 - 882 1,326 22.495 January Meetings - 708 25 1 1 - - - - - - 46 - 46 - - - - 46 January Sporting Events - 709 1,570 9 9 32,530 5,600 5,000 (4,690) 5,910 6,995 - - 6,995 - 160 1,275 1,435 14,340 January Trade Shows - 710 - - - - - - - - - - - - - - January Performing Arts - 711 250 6 6 2,000 - 929 (510) 419 - - - - 16 250 266 685 January Other - 712 1,125 2 4 15,000 2,400 4,414 (2,409) 4,405 525 - - 525 - - - - 4,930 January Total 4,170 19 22 55,250 8,100 + 18,229 (15,458) 10,872 7,801 46 310 8,157 - 176 2,100: 2,276 21,304 February Entertainment - 706 2,800 2 2 40,574 2,400 4,430 (5,069) 1,761 9,472 - 643 10,115 750 2,214 2,964 14,840 February Meetings - 708 25 1 1 - - - - - - 241 - 241 - - - - 241 February Sporting Events - 709 100 8 8 - 3,600 - - 3,600 - - - - - - - - 3,600 February Performing, Arts -711 980 2 2 3,635 1,310 2,400 (1,600) 2,110 35 - - 35 - 45 950 995 3,140 February Total 5,665 15' 15 59,209 8,510 12,349 ` (9,002) 11,857 11,270 241 643 12,154 795 ! 3,164 ', 3,959 27,970 March Entertainment - 706 338 1 1 320 3,050 1,130 (757) 3,423 13 - - 13 - - 320 320 3,756 March Meetings - 708 25 1 1 - - - - - - 40 - 40 - - - - 40 March Sporting Events - 709 100 8 8 - 3,600 - - 3,600 - - - - - - - - 3,600 March Performing Arts - 711 1,205 3 3 4,693 1,310 3,229 (2,130) 2,409 35 - - 35 - 45 1,175 1,220 3,664 March Other - 712 - - - - - - - - - - - _ - March Total 5,668 16' 15 66,199 19,481 ; 7,354 (11,680) 15,155 2,454 40 - 2,494 504 i 4,395 .; 4,899 22,548x; April Sporting Events - 709 1,470 1 1 32,530 2,000 5,000 (4,690) 2,310 6,995 - - 6,995 - 160 1,275 1,435 10.740 April Trade Shows - 710 - - - - - - - - - - - - - - - - April Performing Arts - 711 1,850 4 5 10,558 2,940 4,700 (2,460) 5,180 536 250 - 786 - 111 1,880 1,991 7,957 April " Total 7,437 17 12 91,500 8,220 16,891 (12,466) 12,645 12,199 250 - 12,449 - 309 5,505 ' 5,814 30,908! May Assemblies - 701 8,658 3 3 - 4,425 6,974 (6,343) 5,056 68 - 68 - - - - 5,124 May Entertainment - 706 2,380 4 3 24,340 2,020 3,345 (2,422) 2,943 1,501 - - 1,501 - 298 2,434 2,732 7.176 PeachtreeV2BudgetMasterFile FY2014.xIs Event Summary By Month 3 Five Flags Center July 1, 2013 - June 30, 2014 DIRECT EVENT DETAIL Event Date Event Category Attend. Actual Number of Perf Event Days Gross Ticket Sales Total Rental Revenue Total Billable Services Total Service Expense Direct Event Income II F &B Concession II Income F &B Catering Income Novelty Sales Income Total Ancillary Income Other Event Income Ticket Rebates Facility Fees Total Other Event Inc Total Event Income May Meetings - 708 25 1 1 - - - - - 85 - 85 - - - - 85 May Performing Arts - 711 225 1 1 1,058 650 829 (530) 949 - - - - - - 225 225 1,174 May To 11,288 9 8 25,398 7,095 11,148 (9,295) 8,948 1,569 85 1,654 - 298 ' 2,659 2,957. 13,559 June Entertainment - 706 - - - - - - - - - - - - - - - - - June Performing Arts - 711 135 6 6 2,000 - 929 (510) 419 - - - - - - - - 419 June Other - 712 - - - - - - - - - - - - - - - June Total 1,015 81 12 5,050 6,000 6,585 (4,677) 7,908 3 364 - 3,364 1.1,272: nd Total 64, 40 177 676,8: 4: 9 (138,994) 112 6 79,672 2,411 224. 8 07 8,742 '3 825 42,567 241,990 PeachtreeV2BudgetMasterFile FY2014.xIs Event Summary By Month 4 Five Flags Center July 1, 2013 - June 30, 2014 OTHER INCOME 900 Account Title Itemized Amounts / Descriptions Budget Bank Earned Interest $ 12 $ 12 Vending Machine Commissions $ - $ - ATM Commissions $ 500 $ 500 Miscellaneous Income $ 400 $ 400 900 July 1, 2013 - June 30, 2014 $ 912 PeachtreeV2BudgetMasterFile FY2014.xls Other Income Summary 5 Five Flags Center July 1, 2013 - June 30, 2014 EXECUTIVE DEPARTMENT 801 Account Title Budget Salaries Administration General Manager Administrative Assistant $ 100,383 15,633 $ 116,017 Bonus - Performance $ 22,084 $ 22,084 Auto Allowance $ 5,050 $ 5,050 Payroll Taxes $ 8,290 $ 8,290 Benefits $ 11,073 $ 11,073 401 (k) $ 1,959 $ 1,959 Worker Compensation Ins. $ 2,707 $ 2,707 Unemployment Taxes $ 623 $ 623 Other Contracted Services $ 19,226 $ 19,226 Corporate Travel $ 500 $ 500 Meals & Entertainment $ 100 $ 100 Meetings & Conventions $ 2,200 $ 2,200 Dues & Subscriptions $ 625 $ 625 Parking Expense $ 564 $ 564 Miscellaneous Operating Exp.. $ 150 $ 150 Telephone $ 1,200 $ 1,200 801 July 1, 2013 - June 30, 2014 $ 192,368 PeachtreeV2BudgetMasterFile FY2014.xls Executive Summary 6 Five Flags Center July 1, 2013 - June 30, 2014 FINANCE DEPARTMENT 802 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 59,857 $ 59,857 Bonus - Performance $ 6,584 $ 6,584 Auto Allowance $ 3,600 $ 3,600 Payroll Taxes $ 5,359 $ 5,359 Benefits $ 17,496 $ 17,496 401 (k) $ 1,168 $ 1,168 Worker Compensation Ins. $ 1,401 $ 1,401 Unemployment Taxes $ 340 $ 340 Contracted Services $ 2,070 $ 2,070 Bank Service Charges $ 1,200 $ 1,200 Meetings & Conventions $ 1,200 $ 1,200 Dues & Subscriptions $ 350 $ 350 Payroll Processing $ 3,790 $ 3,790 Miscellaneous Operating Exp.. Checks /Deposit Slips $ 600 Peachtree Acccounting Software 950 $ 1,550 802 July 1, 2013 - June 30, 2014 $ 105,965 PeachtreeV2BudgetMasterFile FY2014.xls Finance Summary 7 Five Flags Center July 1, 2013 - June 30, 2014 SALES DEPARTMENT 803 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 15,633 $ 15,633 Administrative: Part-Time $ - Payroll Taxes Salary $ 1,196 Hourly $ 1,196 Benefits Salary $ 3,553 Hourly $ 3.553 401 (k) $ - $ - Worker Compensation Ins. Salary $ 156 Hourly $ 156 Unemployment Taxes Salary $ 283 Hourly $ 283 Other Contracted Services Website: Licenceing /hosting / maintence /domain (365) $ 680 TM Messinger, SMG Booking w/ Publicity Add -on, Contracted Marketing Support 20,250 $ 20,930 Travel local travel $ 50 $ 50 Corporate Travel $ - $ - Meals & Entertainment $ - $ - Meetings & Conventions $ 750 $ 750 Dues & Subscriptions Chamber Memberships $ 881 Polstar Subscription / Venues Today 925 $ 1,806 Advertising See Marketing FY13 Budget wants $ 775 $ 775 Advertising Newspaper See Marketing FY13 Budget wants $ 5,172 $ 5.172 Advertising Website See Marketing FY13 Budget wants $ 845 Online /digital advertising $ 845 PR Activities See Marketing FY I3 Budget wants $ 1,500 $ 1.500 Printing Marketing $ 200 $ 200 Promotional See Marketing FY13 Budget wants $ 1,200 $ 1,200 Miscellaneous Operating Exp.. $ 300 $ 300 July 1, 2013 - June 30, 2014 803 $ 54,349 PeachtreeV2BudgetMasterFile FY2014.xls Sales Summary 8 Five Flags Center July 1, 2013 - June 30, 2014 OPERATIONS DEPARTMENT 805 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 142,690 $ 142,690 Custodial - Part-Time $ 19,141 $ 19,141 Payroll Taxes Salary $ 10,916 Hourly 1,464 $ 12,380 Benefits Salary $ 40,975 Hourly $ 40,975 401 (k) Salary $ 1,062 Hourly $ 1,062 Worker Compensation Ins. Salary $ 2,854 Hourly 383 $ 3,237 Unemployment Taxes Salary $ 1,020 Hourly 396 $ 1,417 Meetings & Conventions $ 4,500.00 $ 4,500 Dues & Subscriptions $ 50.00 $ 50 Employee Training $ 2,500.00 $ 2,500 Operating Supplies $ 600.00 $ 600 Sand & Salt $ 1,000.00 $ 1,000 Exterminating $ 900.00 $ 900 Cleaning $ 2,000.00 $ 2,000 Small Equipment $ 850 $ 850 Safety Equipment $ 3,000 $ 3,000 Miscellaneous Operating Exp.. $ 300.00 $ 300 General Building Repairs $ 300.00 $ 300 HVAC Systems $ 2,000 $ 2,000 Machinery & Equipment $ 400 $ 400 Other Repairs / Maintenance $ 200.00 $ 200 Bulbs & Lamps $ 3,000.00 $ 3,000 Fuel Propane $ 100.00 $ 100 Small Tools $ 200.00 $ 200 First Aid $ 100 $ 100 PeachtreeV2BudgetMasterFile FY2014.x1s Operations Summary 9 Five Flags Center July 1, 2013 - June 30, 2014 OPERATIONS DEPARTMENT 805 Account Title Itemized Amounts / Descriptions Budget Filters $ 3,000.00 $ 3,000 Part Mach & Equip 1 $ 200.00 $ 200 Paint $ 1,200.00 $ 1,200 Janitorial $ 800.00 $ 800 Janitorial Chemicals $ 1,000.00 $ 1,000 Janitorial Liners $ 1,600.00 $ 1,600 Janitorial Paper $ 2,490.00 $ 2,490 Uniforms $ 1,000.00 $ 1,000 Allocated Custodial $ (19,141) $ (19,141) Allocated Other Expenses $ (2,243) $ (2,243) 805 July 1, 2013 - June 30, 2014 $ 232,808 PeachtreeV2BudgetMasterFile FY2014.xls Operations Summary 10 Five Flags Center July 1, 2013 - June 30, 2014 SECURITY DEPARTMENT 806 Account Title Itemized Amounts / Descriptions Budget Security - Part-Time $ 5,798 $ 5,798 Payroll Taxes $ 444 $ 444 Worker Compensation Ins. $ 116 $ 116 Unemployment Taxes $ 120 $ 120 Allocated Security $ (5,798) $ (5,798) Allocated Other Expenses $ (680) $ (680) 806 July 1, 2013 - June 30, 2014 $ - PeachtreeV2BudgetMasterFile FY2014.xls Security Summary 11 Five Flags Center July 1, 2013 - June 30, 2014 EVENT MANAGEMENT DEPARTMENT 807 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 65,829 $ 65,829 Stagehands - Part -Time $ 30,443 $ 30,443 Ushers &Tckt. Takers - Part -Time $ 15,793 $ 15,793 Payroll Taxes Salary $ 5,036 Hourly 3,537 $ 8,573 Benefits Salary $ 17,491 Hourly $ 17,491 401 (k) Salary $ 1,028 Hourly $ 1,028 Worker Compensation Ins. Salary $ 1,317 Hourly 925 $ 2,241 Unemployment Taxes Salary $ 340 Hourly 957 $ 1,297 Equipment Rental $ 500 $ 500 Safety Equipment $ 200 $ 200 Miscellaneous Operating Exp.. $ 500 $ 500 Sound Equipment Maintenance $ 2,000 $ 2,000 Electrical Systems Followspot Ballast $ 750 $ 750 Rigging Maintenance Annual Inspections & Boom -Lifts $ 6,800 $ 6,800 General Building Supplies $ 500 $ 500 Audio Visual $ 600 $ 600 Bulbs & Lamps $ 2,600 $ 2,600 Theatrical $ 500 $ 500 Electrical $ 500 $ 500 Carpentry Misc. Lumber $ 500 $ 500 Small Tools $ 250 $ 250 Paint $ 800 $ 800 Uniforms Security uniform shirts $ 200 $ 200 Signage Theater Box Seats $ 400 $ 400 Allocated Stagehands $ (30,443) $ (30,443) Allocated Ushers &TktTkrs. $ (15,793) $ (15,793) Allocated Other Expenses $ (5,419) $ (5,419) 807 July 1, 2013 - June 30, 2014 $ 108,640 PeachtreeV2BudgetMasterFile FY2014.xls Event Management Summary 12 Five Flags Center July 1, 2013 - June 30, 2014 BOX OFFICE DEPARTMENT 808 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 35,128 $ 35,128 B.O. /Ticket Sellers - Part -Time $ 20,710 $ 20,710 Payroll Taxes Salary Hourly $ 2,687 1,584 $ 4,271 Benefits Salary Hourly $ 7,105 $ 7,105 401 (k) Salary Hourly $ 685 $ 685 Worker Compensation Ins. Salary Hourly $ 703 414 $ 1,117 Unemployment Taxes Salary Hourly $ 340 429 $ 769 Travel $ - $ - Meetings & Conventions $ - $ - Dues & Subscriptions Dubuque Jaycees $ 55 $ 163 INTIX $ 108 Credit card terminal Charges $ 500 $ 500 Credit Card Discounts $ 8,200 $ 8,200 Employee Training $ 140 $ 140 Miscellaneous Operating Exp.. $ 200 $ 200 Uniforms $ 200 $ 200 Allocated BO /Tkt Sellers $ (12,426) $ (12,426) Allocated Other Expenses $ (1,456) $ (1,456) 808 July 1, 2013 - June 30, 2014 $ 65,306 PeachtreeV2BudgetMasterFile FY2014.xls Box Office Summary 13 Five Flags Center July 1, 2013 - June 30, 2014 OVERHEAD DEPARTMENT 810 Account Title Itemized Amounts / Descriptions Budget Postage $ 750 $ 750 Trash Removal $ 1,404 $ 1,404 Maintenance Agreements ASCAP /BMI/SESAC Simplex Grinnell 3,300 7,346 $ 10,646 Laundry $ 120 $ 120 Boiler Insurance $ 1,030 $ 1,030 Fidelity Insurance $ 787 $ 787 General Liability Insurance $ 12,240 $ 12,240 Promoter Liability $ 1,600 $ 1,600 Property Insurance $ 14,500 $ 14,500 Surety Bond $ 800 $ 800 Other Insurance Performance Bond $ 1,600 $ 1,600 Electricity $ 119,153 $ 119,153 Heating Fuel $ 30,350 $ 30,350 Telephone $ 20,220 $ 20,220 Water & Sewage $ 900 $ 900 Management Fee Client $ 93,965 $ 93,965 810 July 1, 2013 - June 30, 2014 $ 310,065 PeachtreeV2BudgetMasterFile FY2014.xls Overhead Summary 14 Five Flags Center July 1, 2013 - June 30, 2014 FOOD & BEVERAGE DEPARTMENT 814 Account Title Itemized Amounts / Descriptions Budget Salaries Administration $ 15,800 $ 15,800 Administrative: Part -Time $ 15,340 $ 15,340 Payroll Taxes Salary Hourly $ 1,209 1,174 $ 2,382 Worker Compensation Ins. Salary Hourly $ 316 307 $ 623 Unemployment Taxes Salary Hourly $ 286 318 $ 603 Contracted Services $ - $ - Travel mileage $ 200 $ 200 Dues & Subscriptions cams club $ 80 $ 80 Licenses & Fees food, alcohol lic. $ 2,332 $ 2,332 Wireless Terminal Leasing $ 2,529 $ 2,529 Computer Expense go to my pc $ 120 $ 120 Employee Training training $ 750 $ 750 Laundry & Linen - F &B dry cleaning $ - $ - Repair & Maintenance -F &B repairs ex.. Neiland coffee cart, freezers $ 2,500 $ 2,500 Miscellaneous Operating Exp.. $ 500 $ 500 Kitchen Supplies co2 $ 150 1,000 $ 1,150 Allocated Administrative $ (15,340) $ (15,340) Allocated Other Expenses $ (1,798) $ (1,798) 814 July 1, 2013 - June 30, 2014 $ 27,771 PeachtreeV2BudgetMasterFile FY2014.xls Food & Beverage Summary 15 Five Flags Center July 1, 2013 -June 30, 2014 DIRECT EVENT DETAIL ADDENDUM A Event Date Event Name Attend. Actual Number of Perf. Event Days Gross Ticket Sales Total Rental Revenue Total Billable Services Total Service Expense Direct Event Income II F &B Concessio 11 Income F &B Catering Income Novelty Sales Income Total 11 Ancillary Income 11 Other Event income Ticket Rebates Facility Fees Total Other Event Tnc Total Event Income ul tt 5 Perl'orminc Arts - 71 I Rising Star Productions Total July 1,4 1,433 7 2S 15,000 15,000 August Performing Arts - 71 I Rising Star Productions Total Au 2.200 2,200 4 4 �t1 911 711 yet =t 8? (9819(88'2 12 ',-175 1,760 (926 475 1,760 (92(1) 3,315 3,315 54 549 19 18,000 2.175 1,300 19 18,000 2,175 1,300 (690) 2,785 1,478 (690) 2,785 1,478 549 549 415 1,360 1,775 5.639 415 1.360 1,775 5,639 1,478 550 2.200 2,750 7,013 1,478 2,200 2,750 7,013 September '3 'x81 186;::1:, Entertainment - 706 WWE Meetings - 708 City Meetings City Expo Spirit Lunch Performing Arts - 711 Arts Trek FBN Total September 2,600 1 1 80.525 9.000 2,925 (4,480) 7.445 5.991 350 2.205 8,546 25 1 1 1,625 1 1 415 1 1 1,650 135 6,450 4 6 14 80,525 October:'• Meetings - 708 City Meetings Tri -State Veterans Sporting Events - 709 Pinnacle Combat MMA Performing Arts - 711 Arts Trek Other - 712 Pool 'tournament Total Oc November Entertainment - 706 Dock Dogs Family Shows - 707 Sesame Street Meetings - 708 City Meetings DALMC Career Fair Sporting Events - 709 Loras Wrestling Performing Arts - 711 DSO Classical 2 DSO Youth Ensemble Other -712 Colts Youth Organization Total November Decemblrr. Concerts - 704 Christmas Concert Jim McDonough Meetings - 708 City Meetings PeachtreeV2BudgetMasterFile FY2014.xls 520 1 1 1 610 240 9.850 1,305 (895) 410 658 (164) 494 1,800 687 7.375 (1,360) (510) (7,409) 1,050 417 9,816 5,991 2,600 4,975 (1,550) 6,025 199 1,300 1 1 32,530 2,000 5,000 (4,690) 2,310 5,008 1,650 900 3,500 4 4 1 3,550 3 1 4 4 25 1 1 610 1,800 (1,360) 1,050 775 (15,330) (15,330) 16;170 (22,930 85 16 451 85 3,600 3,849 (2,885) 4,564 4,111 56,165 15,400 13.975 (21,440) 7,935 3,432 2,205 85 16 8,647 85 199 5,008 16.470 1,915 2,355 4,270 20,261 1,915 2,355 4,270 85 426 494 1,050 417 22,733 85 6,224 25 1,050 1,075 8,393 1,050 1,140 25 1,050 16,892 4,111 1,374 4,806 41 41 580 1 2 2.100 2,391 (1.372) 3,119 396 396 630 1 1 2,215 1,375 2,935 (2,036) 2,274 2,281 980 2 2 3,635 1.310 2,400 (1,600) 2,110 115 225 1 1 1,058 125 9,615 1,917 915 1 2 25 1 3 829 15301 299 1.2r_iri 150 (2101 1,140 8,675 - 1,828 2,832 4,660 17,401 41 3,515 2,281 586 586 5,141 115 45 950 995 3,220 17 63,073 24,985 529 (30 0731 21,441 9,939 437 1,374 11,750 1 111,713 2,500 12,018 (9,370) 5,148 1 30,200 800 3,990 (1,623) 3,167 Direct Event Detail 1,136 109 26 462 1,598 230 339 26 225 225 524 1,140 1,873 4,593 6,466 39,657 - 1,419 1,889 3,308 10,054 905 905 4,411 16 26 44 gratigil.r Five Flags Center July I, 2013 -June 30, 2014 DIRECT EVENT DETAIL ADDENDUM A Event Date Event Name Attend. Actual Number of Perf. Event Days Gross Ticket Sales Total Rental Revenue Total Billable Services Total Service Expense Direct Event Income 11 F &B Concession 11 Income F &B Catering Income Novelty Sales Income Total 11 Ancillary Income II Other Event Income Ticket Rebates Facility Fees Total Other Event Inc Total Event Income Performing Arts - 711 DSO Holiday Pops Other - 712 Jingle Bell Hop Night Storm Teen Dance Total December Entertainment - 706 Bixby's Rainforest Inflatable Meetings - 708 City Meetings Sporting Events - 709 Dubuque Soccer Club Pinnacle Combat MMA Performing Arts - 711 FBN Other - 712 Colts Youth Organization Custom 1 I,', ),w) C1 " "" Total January 1,700 3 500 1 250 1 5,307 0 1,200 25 1 1 5 23,187 1.510 5,239 (2,861) 3,888 93 10 1 93 - 463 1,650 2,113 6.094 400 219 (350) 269 - - - 600 437 (190) 847 44 - 44 165.100 e.810 'x1903 (14.3941 13.319 1382 776 692 2,850 5,720 100 7,886 100 8 8 - 31,00 - 1,470 1 1 32.530 2.000 5,000 250 6 6 2,000 125 1 1: nnn February " 1 7n Consumer / Public Shows - 703 Multicultural Center Taste of World Entertainment - 706 Championship Bull Riding Meetings - 708 City Meetings Sporting Events - 709 Dubuque Soccer Club Performing Arts - 711 DSO Classical 3 Other -712 Hogs Gone Wild Fanfest Total February 760 1 1 1200 'x n0 929 150 4,2r-1 18,2 (7,849) 137 3.600 (4,690) 2,310 (510) 419 (209) 1.141 (� flnn1 2',4. 1 1 281 6,995 525 7,501 46 46 310 310 591 46 6.995 525 8,157 269 891 1,882 4,444 6,326 22,495 575 575 1,303 46 3,600 160 1,275 1,435 10,740 16 250 266 685 176 2,100 2,276 1,141 3.789 212204 1,255 (133) 1,122 1,122 2,800 2 2 40,574 2,400 4,430 (5,069) 1,761 9,472 643 10,115 750 2,214 2,964 14,840 25 1 1 - - 241 241 241 100 8 8 - 3,600 3,600 - 3,600 980 2 2 3,635 1,310 2,400 (1,600) 2,110 35 - 35 45 950 995 3,140 1,000 5,665 15 1 15,000 15 59,209 March Consumer / Public Shows - 703 QueenB Golf Expo Entertainment - 706 HS Variety Show Family Shows - 707 Disney Live Meetings - 708 City Meetings Sporting Events - 709 Dubuque Soccer Club Performing Arts - 711 DSO Classical 4 DSO Youth Ensemble Total March 8.510 4.264 (2,200) 3.264 1,763 12.349 (9,002) 11.857 11.270 241 643 1,763 12,154 705 3.164 3,950 5.027 27,970 1,000 1 1 - 1,800 2,995 (2,016) 2,779 338 1 1 320 3,050 1,130 (757) 3,423 13 3,000 2 1 61,186 9,721 (6,777) 2,944 1,881 25 1 100 980 225 5,668 8 8 2 1 16 2 1 15 3,635 1,058 66.199 April Entertainment - 706 George Carden Circus PeachtreeV2BudgetMasterFile FY2014.xls 3,400 3 3,600 1,310 2,400 829 7,354 19,481 3,600 (1,600) 2,110 35 (530) 299 (11.680) 15.155 2,454 2 28,912 2,400 5,410 (3,905) 3,905 3,656 Direct Event Detail 13 1,881 40 40 35 40 2,494 2,779 320 320 3,756 459 2,900 3,359 8,184 40 3,600 45 504 950 995 225 225 4,395 4,899 3,140 524 22,548 3,656 33 1,850 1,883 9,444 17 Five Flags Center July 1, 2013 - June 30, 2014 DIRECT EVENT DETAIL Event Event Attend. Number Event Gross Date Name Actual of Days Ticket Perf. Sales Dancing With The Stars Sporting Events - 709 Pinnacle Combat MMA 1,470 Performing Arts - 711 Wahlert Musical 1,850 4 Other - 712 JDIFF 217 Total April 7,437 May; Assemblies HS Graduations 7,075 NICC Graduation 1,583 1 Entertainment - 706 Studio 5 -6 -7 -8 2,380 4 Meetings - 708 8 17 19,500 Total Rental enu 700 32,530 2, 3 ADDENDUM A Total Billable Services 1,489 Total Service Expense (1,185) Direct Event Income F &B ,oncessi IIIncome 1,004 1,023 2,000 5,000 (4,690) 940 4,700 (2,460) 5,180 180 292 (226) 246 2,310 6,995 12 91,500 8,220 16,891 (12,466) 12,645 Meetings 25 1 1 Performing As City rt - 711 eeti 3,150 1,275 4,920 2,054 24,340 2,020 3,345 DSO Youth Ensemble 225 1 1 1,058 Total May 11,288 9 8 25,398 June Conventions - 705 2014 National Holstein Convention 600 Sporting Events - 709 Rumble By The River 280 Performing Arts - 711 FBN 135 6 Total June 1,015 8 Total $ - 64,643 140 (4,650) 3,420 (1,693) 1,636 650 829 (530) 949 7,095 11,148 (9,295) 8,948 F &B Catering Income Novelty Sales Income 250 - (12) 12,199 250 68 1,569 85 85 Total II Ancillary Income II 1,023 Other Event Income Ticket Rebates Facility Total Fees Other Event Inc 500 505 Total Event Income 2,532 6,995 - 160 1,275 1,435 10,740 786 (12) 12,449 68 85 1,654 1,991 7,957 309 5,505 5,814 235 30,908 225 225 298 2,659 2,957 3,420 1,704 85 74 13,559 (3,066) 6,034 1,802 3,050 ,200 1,356 (1,101) 1,455 1,562 - 6 2,000 929 (510) 419 12 5,050 6,000 6,585 (4,677) 7,908 1-77 676,833 14# # # ## 143,198 (138,994) 112,116 1,562 3,017 - - 419 3,364 - - 3,364 - - - 11,272 79,672 2,411 5,224 87,307 - 8,742 33,825 42,567 241,990 PeachtreeV2BudgetMasterFile FY2014.xls Direct Event Detail 18 Five Flags Center FYE 6/30/2014 Addendum B Dept Name 1 Title Executive Finance Marketing Operations Event Services Box Office General Manager Administrative Asst Receptionist Subtotal Executive Director of Finance Accounting Manager P/R Clerk Subtotal Finance Marketing Events Coordinator Director of Sales Sales Manager Subtotal Marketing Administrative Salaries & Benefit Budget Summary Salary Benefits Taxes 401 K Auto Bonus Total 100,383 10,071 7,434 1,959 5,050 22,084 146,982 15,633 3,709 1,479 - 20,821 116,017 13,780 8,914 1,959 5,050 22,084 167,803 59,857 18,897 5,699 1,168 3,600 6,584 95,805 59,857 18,897 5,699 1,168 3,600 6,584 95,805 15,633 3,709 1,479 - - 20,821 15,633 3,709 1,479 - - - 20,821 Operations Manager 61,451 17,721 5,041 84,213 Operations Supervisor 46,887 18,319 3,927 375 69,508 HousekeeepinglSet -Up Svsr 34,353 7,789 2,968 687 45,797 3/4 Operations Crew Chief - - - - - Subtotal Operations 142,690 43,829 11,936 1,062 - - 199,517 Event Services Coordinator - Technical Director 65,829 18,807 5,376 Concessions Manager 15,800 316 1,494 Subtotal Event Services 81,629 19,123 6,871 1,028 1,028 91,040 17,611 108,651 Box Office Manager 35,128 7,808 3,027 685 46,648 Ticket Sellers (FT) Ticket Sellers (PT) Subtotal Boxoffice 35,128 7,808 3,027 685 - 46,648 Total All Departments 450,954 107,146 37,925 5,902 8,650 28,669 639,245 Salaried Wages 19 Five Flags Center Addendum C FYE 6/30/2014 1 Dept 1 Name Part -Time Wages & Benefit Budget Summary Reg. OT Avg. Hours Hours Rate Salary Benefits Taxes 401k Total Administration Receptionist 0 $ Marketing Intern $ 7.25 Subtotal Electricians Box Office Supervisor 695 $ 12.71 8,833 177 859 9,869 Ticket Sellers 1,110 $ 10.70 11,877 238 1,154 13,269 Ticket Sellers 0 - $ 9.66 - - - - Subtotal Engineers 20,710 414 2,013 23,138 Security Guards Open (Security Manager) salary - - - - Security Guards 520 - $ 11.15 5,798 116 564 6,478 Doug Paul - $ 12.13 - - - - Subtotal Security 5,798 116 564 6,478 Concessions Supervisor 251 $ 12.71 3,184 64 309 3,557 Bartender 276 $ 10.07 2,782 56 270 3,108 Stand Worker 1,019 $ 9.20 9,375 187 911 - 10,474 Subtotal Utility 15,340 307 1,491 - 17,138 Janitors /Custodial Crew Chief 1,578 $ 12.13 19,141 383 1,861 21,384 House Crew 0 $ 10.88 $ 9.66 Subtotal Custodial 19,141 383 1,861 21,384 Event Staff House Manager 638 $ 12.08 7,707 154 749 8,610 Usher- 2 862 $ 9.38 8,086 162 786 - 9,033 Ward 29 $ 19.59 568 11 55 635 Stage Hands 1,325 $ 12.02 15,927 319 1,548 - 17,793 Stage Hands 996 $ 10.88 10,836 217 1,053 - 12,107 Stage Hands 104 $ 9.66 1,005 20 98 1,122 Riggers 156 $ 13.51 2,108 42 205 - 2,355 Stage Hands - - - Subtotal Casual 46,236 925 4,494 - 51,655 Total Operations Labor 107,226 2,145 10,422 119,793 119,793 Hourly Wages 20