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.6P1 + 0.25P2

Q2 = 301 + 0.08P1 - 0.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.