1. A concert promoter wants to produce a show. He needs to decide what venue to use because that will determine costs, revenues, profit or loss, and what talent to contract for. In this exercise, we'll use the Scenario Manager to compare four sets of numbers: small, medium, large and very large and their associated costs and revenues, assuming each show sells out. Create four scenarios as follows: (6 points) Small Venue Medium venue Large venue Very Large venu # of seats 600 800 1500 5000 Talent 6000 7500 12000 25000 Venue rental 1000 1250 4500 12500 Lightning 250 350 700 1250 Security 450 550 950 1500 Ticket price 30 35 50 50 2. Create a scenario summary, using Profit or loss as a result. (5 points)