Develop a spreadsheet for calculating the total revenue for the Modern Electronics scenario in Problem 2. Design
Question:
Develop a spreadsheet for calculating the total revenue for the Modern Electronics scenario in Problem 2. Design it so that the price-demand function parameters can easily be changed.
Data from Problem 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 (N) and prices (P) of each model:
NA = 20 - 0.62PA + 0.30PB
NB = 29 + 0.10PA - 0.60PB
Step by Step Answer: