Develop a substitutable products spreadsheet model for the problem described below.

The Camera Shop is selling two popular models of digital cameras. The sales of these two cameras are not independent: if the price of one increases, the sales of the other increases. The store wishes to establish a pricing policy to maximize sales revenues from these two products. A study of price and sales shows the following relationships between the quantity sold $Q$ and price $P$ :

$Q1=195-0\mathrm{.}6P1+0\mathrm{.}25P2$

$Q2=301+0\mathrm{.}08P1-0\mathrm{.}5P2,$ where $Q1$ and $Q2$ represent quantity of model $1$ and model $2$ sold, $P1$ and $P2$ represent price of model $1$ and model $2.$

On the first sheet that you should rename to REVENUES develop formulas for quantities sold and revenue when the initial price of model $1$ camera is set to $$250$ and the initial price of model $2$ is $$310.$ Develop then a two$-$way data table to recalculate the sales revenue when price of model $1$ varies from $250$ to $500$ in increments of $$10,$ while price of model $2$ varies from $$260$ to $$500$ in increments of $$5.$

On the two$-$way data table $($created through the Data, What$-$if Excel options$)$ use conditional formatting and the max built$-$in function to highlight the best pricing of the two cameras.

On the sheet named Solver$\_$solution use Excel's Solver to find the "optimal pricing" of the two cameras; generate also the Solver's Answer Report. Each sheet should display your name, course and section number.

Would you recommend using the two$-$way data table or Solver to find the optimal pricing of the two cameras? Justify briefly your recommendation.