3- There is a music festival in Amsterdam, and a hotel requires your assistance in pricing its rooms for two distinct groups. We need to set prices for Group 1, who can attend the festival, and for Group 2, who will arrive in town after the festival. The demand functions for these two groups are as follows: Group 1: g = 10,000 100P Group 2: q = 5,000 200P The cost for each room is $20. Use Solver (GRG nonlinear option) to determine the optimal prices for these two groups, calculate the maximum profit, and estimate how many people will book the hotel at these found prices. B3 X v fx A B C D E F G H J K High demand q = 2000 - 300p 2 Low demand q = 1000 - 400p 3 Post-festive Prcie 4 pre-festival Price post-festival Demand pre-festival Demand Total number of bookes room 8 Post-festival Rev 10 Pre-festival Rev 11 12 Total revenue 13 Cost 14 Profit 15 16 17