Question
The Radio Shop sells two popular models of portable sport radios: model A and model B. The sales of these products are not independent of
The Radio Shop sells two popular models of portable sport radios: model A and model B. The sales of these products are not independent of each other (in econom- ics, 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 maxi- mize 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
a. Construct a model for the total revenue and imple- ment it on a spreadsheet. b. Develop a two-way data table to estimate the opti- mal prices for each product in order to maximize the total revenue. c. Use Solver to find the optimal prices.
Please help me understand how to do part a especially. I have looked at other examples of the problem and I cannot seem to do the data table at all. Attached is a view of my excel sheet.
A B D E F G H -0.62 0.3 20 0.1 -0.6 29 49 Price B 1 5a) 2 Model A 3 Slope A 4 Slope B 5 Intercept 6 Model B 7 Slope A 8 Slope B 9 Intercept 10 11 Model 12 13 Revenue 14 Price A 15 Price B 16 Quantity sold: A 17 Quantity sold: B 18 Total Revenue 19 20 21 22 23 24 25 26 Price A 1 1 20 29 49 5 10 15 20 25 30 35 10 15 20 25 30 35 40Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started