Construct model for the total revenue and implement

Assignment Help Business Economics

Reference no: EM131090454

Better Buy is having a sale this weekend on digital cameras. Its two most popular models are on sale but their sales are not independent. If the price of one increases, the sales of the other increases. In economics this is referred to as substitutable products. The store wants to establish a pricing policy to maximize revenue for these two cameras. A study of price and sales data shows the following relationships between the quantities sold (Q) and the price (P) of each model:

Q1 = 195 – 0.60P1 + 0.25P2

Q2 = 301 + 0.08P1 - 0.50P2

a. Construct a model for the total revenue and implement it on a spreadsheet.

b. Develop a 2-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Vary each price from $250 to $500 in increments of $10.

Reference no: EM131090454

Questions Cloud

Wireless service differently in the two market segments : The EarthCom Company prices its wireless service differently in the two market segments it serves even though the cost of adding a new customer is the same in each segment. Market research has shown that EarthCom can increase its profits by price-dis..

What can you learn from southwest air : Provide an overview of the hiring process at Southwest, What can you learn from Southwest Air? Do they really value their team? Is it difficult to obtain a job there? Do they practice what they preach?

Preliminary selection interviews via the web : Use the Internet to find employers who now do preliminary selection interviews via the Web. Do you think these interviews are useful? Why or why not? You should also include the pros and cons. How would you improve them?

Make sure to address consumption-disposable income : Suppose the government decreases taxes by 20 percent. Describe the effects to the equilibrium price level and GDP. Make sure to address consumption, disposable income, and aggregate demand in your answer.

Construct model for the total revenue and implement : Better Buy is having a sale this weekend on digital cameras. Its two most popular models are on sale but their sales are not independent. If the price of one increases, the sales of the other increases. In economics this is referred to as substitutab..

Company resources for personal : This week's conference is somewhat different than the others. Here are 3 questions that have been used in employment assessments. Each of them has a stated purpose, but consider the implications of the answer.

Describe in married relations in recent generations : What changes did Sanger describe in married relations in recent generations? What changes did Sanger hope would come about if unplanned pregnancies could be prevented? Do debates concerning birth control and unplanned pregnancies still occur in the U..

What does this imply about the inflation differential : Mexican interest rates are normally substantially higher than U.S. interest rates. a. What does this imply about the inflation differential (Mexico inflation minus U.S. inflation), assuming that the peso interest rate is the same in both countries? D..

Explain the role of the rba with respect to interest rates : Explain the role of the RBA with respect to interest rates and why it is necessary to have these controls. Suggest how Malcolm and Susan could potentially solve their dilemma

User Account

All Pages