You have been hired as the assistant director of a new 10,000-seat arena in New

You have been hired as the assistant director of a new 10,000-seat arena in New City, Ohio. The venue will be a
full-service, multi-purpose arena with a projected event schedule that includes the following events (with
projected attendance figures and event length):
• 38 home minor league hockey games (average attendance, 5,500) (3.5 hours / game)
• 20 home Division 1 college basketball games (average attendance, 8,500) (3 hours / game)
• 5 Disney On Ice performances (average attendance, 6,500 per performance) (2.5 hours / performance)
• 6 Ringling Brothers Barnum & Bailey Circus performances (average attendance, 7,500 / performance) (2
hours / performance)
• 1 The Original Harlem Globetrotters event (projected attendance, 8,000) (1.5 hours / show)
• 2 WWE events (average attendance, 8,500 / event) (2.5 hours / event)
• 1 college graduation (projected attendance, 10,000) (4 hours / event)
• 3 high school graduations (average attendance, 9,500 / event) (4 hours / event)
• 5 sold-out concerts (average attendance, 10,000 / concert) (3 hours / event)
• 8 half-house concerts (average attendance, 4,000 / concert) (3 hours / event)
You have been asked to put together an estimated staffing budget based on the following formulas:
• 1 usher (per 250 attendees) at $8.00 hr
• 1 usher supervisor (per 10 ushers) at $10.00 hr
• 1 peer security guard (per 300 attendees) at 8.50 hr
• 1 peer security supervisor (per 15 peer security guards) at $11.00 hr
• 1 ticket seller (per 1,500 attendees) at $9.00 hr
• 1 ticket taker (per 1,000 attendees) at $8.50 hr
• 1 event coordinator (per 3,000 attendees) at $18.00 hr
• 1 police officer (per 2,000 attendees) at $30.00 hr
• 1 EMT (per 3,000 attendees) at $23.00 hr
Assignment
Based on the information above, create an Excel spreadsheet with appropriate formulas to serve as a template for
calculating your staffing expenses for each event. Use this tool to calculate the total projected event staff expenses
for each event type and then the event staffing budget for the first year of the new arena.