代写Event Staffing Budget Development & an Annual Operating Budget代做留学生SQL 程序

Event Staffing Budget Development & an Annual Operating Budget

Scenario

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)

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 

1. Based on the information above,

a. 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.

b. How many attendees do you welcome annually?

2. Analyze the attached annual operating budget. Look at the revenue streams, expense categories and the costs.

a. What is the yearly result of their operations?

b. How many events contribute to the overall rent revenue?

c. How do you understand Commissions as a revenue category?

d. What can you say about the food service? Are they profitable? Are they provided in-house or using an outside provider?  

e. On average, how much money do you make from concessions per event?