The Camera Shop sells two popular models of digital SLR cameras. The sales of these products are not independent; if the price of one increases, the sales of the other increases. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and price (P) of each model.

N_A = 155 0.6P_A + 0.45P_B

N_B = 312 + 0.08P_A 0.6P_B

(a) =

Construct a model for the total revenue and implement it on a spreadsheet. What is the profit (in dollars) predicted by your model when the price of model A is

P_A = $290

and the price of model B is

P_B = $350.

(b)

Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Vary each price from $250 to $500 in increments of $10.

P_A=

P_B=