Just three quick questions!

Please provide excel screenshots with formulas, or if it's easier to send me a completed google sheets file, feel free to do so! :)

11.2 - Modern Electronics 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 following relationships between the quantity sold (M)and prices (P) of each model:~A = 20 - 0.62PA + 0.30PB^p= 29 + 0.10PA- 0.60PB

a. Construct a mathematical model for the total revenue.

b. What is the predicted revenue if PA = $18 andP3= $30?

A B C D E F G H L K Modern Electronics a. Total Revenue = Model Parameters for Qty Sold QTY SOLD REVENUE PRICE Constant Price A Price B TOTAL REV 8 b A 18.00 20.00 -0.62 0.30 CA CO 9 B 30.00 29.00 0.10 -0.60 10 11 12A B C D E F G H 1 New Product Sales Increase Per Year Inc SP Per Year Per Unit VC Per Unit FC 6% $0.50 3% 8% Year Sales Volume Selling Price Unit Var Cost Fixed Cost Total Rev Total Costs Total Profit 80,000 $ 12.00 $ 3.00 $ 400,000.00 10 11 NPV 12 13 Discount Rate 4% 14 15A C D E F G H K 1 Minimart L M What is the total profit when demand equals the quantities listed below? Number of copies 25 purchased demand total profit 5 Purchase Cost $ 1.50 10 Sales Price $ 4.00 15 7 20 8 Demand 9 10 Number Sold 11 Number Left Over YOU DON'T HAVE TO PERFORM WHAT-IF ANALYSIS! 12 13 Total Cost 14 Total Revenue 15 16 Total Profit 17 18 19 20 21