Need assistance in confirming that my answers/graphs are correct.

Can you please show s/s of excel inputs (Qd, P, etc.) and also graphical outputs.

Name Bid Elizabeth 380 1. [8 Points] Using the WTP data, create a table and graph of each of the following: Taylor 340 (a) The demand curve for tickets to "dinner with Mrs. Krueger". (3 points) Olivia 314 Kate 292 (b) The revenue curve for ticket sales to the dinner. (2 points) Abigail 276 (c) The marginal revenue curve for ticket sales to the dinner. (3 points) Frank 264 Umberto 256 Assume that the goal of HCGDI is to maximize revenue from tickets sales to event and there are Danielle 250 no constraints on how many tickets they can sell. Lauren 244 Zack 236 2. [4 points] What price should HCGDI charge its members? How many members do you expect Renee 228 will buy a ticket to the event, and how much revenue will be earned? Benjamin 220 Nathan 212 3. [4 points] Suppose that Mrs. Krueger would only pay for 10 seats at Gennaro for HCGDI Harrison 204 members at the event. Isabelle 194 Maria 184 (a) How would your price recommendation change? Explain why. (1 point) Georgia 170 Sarah 154 (b) Suppose HCGDI had the opportunity to pay for the right to sell an 11th seat at the event William 138 (in addition to the 10 seats sponsored by Mrs. Krueger that it already planned to sell) Victoria 124 and that Gennaro sets the cost of an extra 11th seat at $180. Should the club pay for it? Jack 112 Please explain why or why not. (3 points) Paige 100 Xiomarre 90 4. [4 points] Suppose Mrs. Krueger stipulates that at least 20 tickets must be sold in order for her Yazmin 80 to host the event. Assume she will pay for all 20 (or more) seats at Gennaro. Quentin 66 Caitlyn 50 (a) How would your price recommendation change? Explain why. (2 points) (b) Is this stipulation good or bad for HCGDI's revenue from the event? Explain why. (2 points)