You are an events manager for a 10,000 seat arena. The venue is a multi-purpose

You are an events manager for a 10,000 seat arena. The venue is a multi-purpose arena with a main tenant of a division 1 college basketball team (men’s and women’s). Use the projected schedule, estimated hours, and hourly rates below to put together an estimated staffing budget in a spreadsheet.
Events that you will host this year:
18 home Division 1 men’s college basketball games (average 9500 people per game). Each game lasts 3 hours.
18 home Division 1 women’s college basketball games (average 4000 people per game). Each game lasts 3 hours.
6 Disney on Ice performances (average 5000 people per show). Each show lasts 2 hours.
1 Globetrotters game (average 4200 people) with the game lasting 3.5 hours.
2 WWE events (average 7500 people per show), each lasting 3 hours.
8 college graduations (average 8000 people per ceremony). Each ceremony lasting 3 hours.
23 touring concerts (average 8200 people per show). Each show lasting 4 hours.
Here are your staff and their rates:
1 usher per 250 guests at $12 per hour
1 security per 300 guests at $15 per hour
1 ticket taker per 1000 guests at $12 per hour
1 guest service per 2500 guests at $11 per hour
1 event coordinator per 3000 guests at $18 per hour
1 police officer per 2000 guests at $76 per hour
1 EMT per 1500 guests at $23 per hour
What to Complete
Create a staffing budget for this year in an excel spreadsheet.You can go into as much detail as you want for the budget.
In the excel spreadsheet, answer these questions:how much do you need to budget for each event for the year?
how much do you need to budget for staffing in total this year?
Submit the completed budget spreadsheet to this assignment.