Based on the attached information,create and upload 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.

Also incorporate an outside academic source for full credit. Complete the excel spreadsheet with a short narrative discussing the overall plan.

Scenario altondance figttes and went length): - 383 home minor leagur hockey games (avelago allendance, 5,500} (3,5 hours/game) - 20 horre Division 1 college baskelball gamos (averago atlendance, 8, 500) (3hour/qame) - 6 Ringling Brohors Parrum \& Bilcy Circus performances (averagnallendanco, 7,500/performance) (? hours / performance) - 2 WhE events (average attendance, 8,500/event) (2.5 hours/event) - 1 college gradualion (projected attendance, 10,000) (4 hours/ event) - 3high school graduations (average attendance, 9,500/event) 44 hours/event) - 5 sold-out concerts (average attendance, 10,000/concert) (3 hours/event) - 8 half-house concerts (average attendance, 4,000/concert) (3houls/event) You have been asked to put together an estimated slaffing budget based on thic following formulas: - 7 usher (per 250 attendees) at \$8.00 hr - 1 usher supervisor (per 70 ushers) at $10,00 hr - 1 peer security guard \{per 300 attendees\}al 8.50 h: - I peer security supervisor (per 75 peer securily guards) al \$71.00 h - 1 ticket seller (per 1,500 altendees) at \$9,00 hr - 1 tickel taker (per 1,000 altendees) at $8.50hr - T evenl courdinatos \{per 3,000 allendecs\}al \$18.00 hi - I police officer (per 2,000 attendees) at \$30.00 hat - 1 EMT (per 3,000 altendees) at \$23.00 l Scenario altondance figttes and went length): - 383 home minor leagur hockey games (avelago allendance, 5,500} (3,5 hours/game) - 20 horre Division 1 college baskelball gamos (averago atlendance, 8, 500) (3hour/qame) - 6 Ringling Brohors Parrum \& Bilcy Circus performances (averagnallendanco, 7,500/performance) (? hours / performance) - 2 WhE events (average attendance, 8,500/event) (2.5 hours/event) - 1 college gradualion (projected attendance, 10,000) (4 hours/ event) - 3high school graduations (average attendance, 9,500/event) 44 hours/event) - 5 sold-out concerts (average attendance, 10,000/concert) (3 hours/event) - 8 half-house concerts (average attendance, 4,000/concert) (3houls/event) You have been asked to put together an estimated slaffing budget based on thic following formulas: - 7 usher (per 250 attendees) at \$8.00 hr - 1 usher supervisor (per 70 ushers) at $10,00 hr - 1 peer security guard \{per 300 attendees\}al 8.50 h: - I peer security supervisor (per 75 peer securily guards) al \$71.00 h - 1 ticket seller (per 1,500 altendees) at \$9,00 hr - 1 tickel taker (per 1,000 altendees) at $8.50hr - T evenl courdinatos \{per 3,000 allendecs\}al \$18.00 hi - I police officer (per 2,000 attendees) at \$30.00 hat - 1 EMT (per 3,000 altendees) at \$23.00 l