posted the question in 2 parts so that the image would be clear. so half on one pic half in the other

11.2.17 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 fine increases, sales of the other will increase). The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data of each model: NA = 17-0.58PA +0.39P No=29+0.11PA-06BPS Develop a spreadsheet for calculating the total revenue if PA=518 and Pa-$31. Design it so that the price-demand function parameters can easily be changed, Complete the spreadsheet below (Type Integers or decimal rounded to two decimal places as needed. Do not include the $ symbol in your answer.) A B D Model Parameters for QTY Sold 2 Model Price Constant Coeff Price A Coeff Price B Quantity Sold Revenue 3 Total Revenue Question Help 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 to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) it so that the price-demand function parameters can easily be changed symbol in your answers.) G Quantity Sold Revenue Total Revenue