Description You have been commissioned to analyze the economic impact on the city of Cincinnati of the MLB All-Star Game. Specifically, the community wants to know the direct spending impact, the indirect spending impact, and the fiscal/tax impact. Cincinnati officials want to know whether it would be profitable to fund and bid for similar future events for the city. This event cost the city about million to host.

You created a survey administered it to 342 people around Great American Ball Park during the game, making an effort to obtain a random sample. Only 325 of the surveys were usable because of various errors by the respondents. You entered the data into a spreadsheet and are now ready to analyze the economic impact.

Included is an Excel file containing two spreadsheets: Survey1 and Key. Survey1 is the spreadsheet in which the data have been entered, and the Key spreadsheet describes and explains each column of data. Be sure to measure economic impact for all visitors, not just those who responded to the survey, since a survey is merely a sample of the target population. (Note: A few data entry or survey respondent errors may be included in the spreadsheet).

Based on discussions with the local organizing committee and Cincinnati government officials, you determine that:

• Great American Ball Park seats 42,059.
• The game was sold out.
• The city sales tax is and is collected on all goods and services except hotels.
• The city hotel occupancy tax is .
• Hotel capacity in the city is 35,000 rooms. The typical occupancy rate is .
• The average number of persons per room for large events such as this is 2.4 .
• Total spending by the local organizing committee was million, with of that amount coming from organizations outside of the city. This is in addition to the amount the city itself spent. Sponsors spent million in town activating their sponsorships.
• The spending multiplier for the city of Cincinnati is 1.6 (based on information from MIG, Inc.).
• Of spending inside Great American Ball Park (including tickets) for this event, 20% went to the city government (fiscal impact).

1 How many people attended the All-Star Game in total?

2 How many visitors (people who are not local residents) attended the All-Star Game?

3 How many visitors who attended the game were time-switchers?

4 How many visitors who attended the game were casual visitors?

5 How many visitors should be used in the calculation of the economic impact estimates?

6 What is the per-person spending per day by the "incremental" visitors for everything but lodging? (Use your result from Question 5.) What is the per-person spending for lodging per night stayed?

7 What is the average length of stay for incremental visitors in terms of days and nights?

8 What is the per-person spending per stay by the incremental visitors?

9 What direct economic impact, not accounting for any hotel capacity constraints, may exist? (Be sure to account for the new/incremental spending by the event organizer and the costs of hosting the event.) Those capacity constraints are addressed in Question 11.

10 What is the total economic impact?

11 Based on hotel capacity information, how many typical visitors did the event visitors crowd out?

12 What is the new direct and total economic impact, accounting for the crowding out?

13 What is the fiscal or tax impact of the event on the city?

Answer rating: 100% (QA)

Given the complexity and the amount of data required to answer these questions Ill guide you through the approach to each question and provide a stepb... View the full answer