Need help with this, can you put it in excel doc??

Scenario You have been hired as the assistant director of a new 15,000-seat arena in New City, Ohio. The venue will be a full-service, multipurpose 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 per game) 20 home Division 1 college basketball games (average attendance, 8,500; 3 hours per game) 5 Disney On Ice performances (average attendance, 6,500 per performance; 2 hours per performance) 1 The Original Harlem Globetrotters event (projected attendance, 8,000; 1.5 hours per show) 1 college graduation (projected attendance, 10,000; 4 hours per event) 3 high school graduations (average attendance, 9,500 per event; 4 hours per event) 5 sold-out concerts (average attendance, 10,000 per concert; 3 hours per event) 8 half-house concerts (average attendance, 4,000 per concert; 3 hours per event) You have been asked to put together an estimated staffing budget based on the following formulas: 1 usher (per 250 attendees) to be paid $9.00 an hour. 1 usher supervisor (per 10 ushers) to be paid $12.00 an hour. 1 peer security guard (per 300 attendees) to be paid $9.50 an hour. 1 peer security supervisor (per 15 peer security guards) to be paid $12.00 an hour. 1 ticket seller (per 1,500 attendees) to be paid $10.00 an hour. 1 ticket taker (per 1,000 attendees) to be paid $9.50 an hour. 1 event coordinator (per 3,000 attendees) to be paid $20.00 an hour. 1 police officer (per 2,000 attendees) to be paid $35.00 an hour. 1 EMT (per 3,000 attendees) to be paid $25.00 an hour. Assignment Based on the foregoing information, 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