MS Excel 2016 A concert promoter reaches out to you as a consultant for a goal seeking advice. Below are the original values provided by the promoter. He/she would like you to provide in a scenario summary additional values for the costs involving the talent, venue rental, amplification, etc.. (See chart below). The original prices for the tickets sales is set at S35 per ticket: 35+450 $15, 750.00 1. For the merchandising, the price per items is $5 per item (450 items sold), for the food beverages S15 per item (450 items were sold) Calculate the total costs and the total of revenue. Find out the profit/loss Highlight the calculated cells in gold, accent 4, lighter 40% in the data table. Concert Budget Costs Venue: # seats 450 Talent Venue rental Amplification Lighting Ticketing Security Insurance Total Costs 5,000.00 $ 600.00 $ 400.00 $300.00 $ 250.00 $200.00 $150.00 6,900.00 Revenues Price Tickets 35 Ticket/Sales Merchandising Food and beverages Total Revenue $15,750.00 2,250.00 6,750.00 $24,750.00 Profit or Loss $17,850.00 2. Proceed by creating (all calculation must be visible) the scenario summary by changing the appropriate cells. The venue can be of 500, 600, 700 and 1,000 (in capacity) respectively. Adjust the cost for talents, venue rental, amplification, etc. accordingly. Decide of the number of merchandising, food and beverages you are forecasting will be sold These numbers should reflect the size of the crowd or the amount of tickets sold. Decide of the price of the tickets in each scenario. For the scenario summary, name the different scenarios: current values, medium venue, large venue and very large venue. Save the entire workbook with the name" Scenario Your Last Name+ Final CSC 2018