An electronics store sells two popular models of wireless

Last updated: 4/12/2023

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 to maximize revenue from these products A study of price and sales data shows the followin relationships between the quantity sold N and prices P of each model NA 15 0 66PA 0 27PB Ng 26 0 12PA 0 51PB Develop a spreadsheet for calculating the total revenue if PA 18 and PB 35 Design it so that the price demand function parameters can easily be changed Complete the spreadsheet below Type integers or decimals Round the quantities to the nearest integer as needed Do not include the symbol in your answers B C Model Parameters for QTY Sold A D E F G Constant 2 Model 3 A 4 B 5 Price Coeff Price A Coeff Price B m Quantity Sold Total Revenue Revenue