Problem 4 in Chapter 11 posed the following situation: The demand for airline travel is quite sensitive to price. Typically, there is an inverse relationship between demand and price; when price decreases, demand increases, and vice versa. One major airline has found that when the price (P) for a round trip between Chicago and Los Angeles is $600, the demand (D) is 500 passengers per day. When the price is reduced to $400, demand is 1,200 passengers per day. You were asked to develop an appropriate model. Implement the model on a spreadsheet and use nonlinear optimization with Solver to find the optimal price to maximize revenue.

please show in excel using Solver