Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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. image text in transcribed

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 40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Pioneers Of Critical Accounting A Celebration Of The Life Of Tony Lowe

Authors: Jim Haslam, Prem Sikka

1st Edition

113754211X, 9781137542113

More Books

Students also viewed these Accounting questions