Input Analysis # of Events 100 You are the owner of a small business that manages the program, food, and Statistic Attendance Programs Food Merchandise merchandise sales at the Excel Center, where the...

PLEASE PROVIDE ANSWER AND FORMULA - THANK YOU.

Extracted text: Input Analysis # of Events 100 You are the owner of a small business that manages the program, food, and Statistic Attendance Programs Food Merchandise merchandise sales at the Excel Center, where the local professional basketball team Average Standard Deviation 95% Confidence Interval plays. In addition to basketball games, the Excel Center hosts dozens of events a year. Your company handles all sales made inside the arena. There are three major products you sell: programs, food, and merchandise. You have decided to build a spreadsheet model to help you analyze and project the profitability of future events. The "Event Profit" worksheet contains this model. You have randomly selected Product Type Programs Food Merchandise Correlation with Attendance sales and attendance data from a number of past events to help build your model. This data can be found on the "Past Events" worksheet. You will analyze this data in order to obtain appropriate values to develop the model. Complete the tasks to finish the model. Whenever possible, reference cells rather than hard-coding values in the cells of your worksheet. Attendance 18000 Product Type Programs Food Merchandise Sales Forecast Upper Limit for Sales Lower Limit for Sales What-If Analysis Attendance Forecast 15000 18000 21000 $50,000.00 $75,000.00 8 $100,000.00 $125,000.00 E $150,000.00 $175,000.00 $200,000.00 Questions Question 1: The sales for which product type are most highly correlated with attendance? Question 2: How likely is it that food sales would exceed $220,000 if attendance is 18000? Question 3: Which product generates the largest gross profit? Question 4: Which product will require the fewest employees? Question 5: Would the event be profitable with a 150,000 arena fee if 15000 people were in attendance?