An electronics store sells two popular models of wireless headphones, model A and model B. The sales of these products are not independent of each other (in economics, we call these substitutable products because if the price of one Increases, sales of the other will increase). The store wishes to establish a pricing policy maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model: NA = 23-0.67PA +0.39P8 Ns 27.0.11PA-0.57P3 Develop a spreadsheet for calculating the total revenue if PA = $20 and P3 = $33. Design it so that the price-demand function parameters can easily be changed. Complete the spreadsheet below. (Type integers or decimals rounded to two decimal places as needed. Do not include the $ symbol in your answers.) B D G Model Parameters for OTY Sold 2 Model Price Constant Coeff Price A Coeff Price B Quantity Sold Revenue 3 A B Total Revenue An electronics store sells two popular models of wireless headphones, model A and model B. The sales of these products are not independent of each other (in economics, we call these substitutable products because if the price of one Increases, sales of the other will increase). The store wishes to establish a pricing policy maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model: NA = 23-0.67PA +0.39P8 Ns 27.0.11PA-0.57P3 Develop a spreadsheet for calculating the total revenue if PA = $20 and P3 = $33. Design it so that the price-demand function parameters can easily be changed. Complete the spreadsheet below. (Type integers or decimals rounded to two decimal places as needed. Do not include the $ symbol in your answers.) B D G Model Parameters for OTY Sold 2 Model Price Constant Coeff Price A Coeff Price B Quantity Sold Revenue 3 A B Total Revenue