The MacDonald sells two popular packages of breakfast all day long: Mac A and Mac 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 (Q) and prices (P ) of each model: QA = 20 - 0.62PA + 0.3PBQB = 29 + 0.1PA - 0.6PBi . Construct a model for the total revenue and implement it on a spreadsheet. b. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. c. Use "Solver" to find the optimal prices.

Microeconomics: Private and Public Choice (MindTap Course List)
16th Edition
ISBN:9781305506893
Author:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Chapter7: Consumer Choice And Elasticity
Section: Chapter Questions
Problem 13CQ: Suppose Erin, the owner-manager of a local hotel projects the following demand for her rooms: a....
icon
Related questions
Question

The MacDonald sells two popular packages of breakfast all day long: Mac A and Mac 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 (Q) and prices (P ) of each model: QA = 20 - 0.62PA + 0.3PBQB = 29 + 0.1PA - 0.6PBi . Construct a model for the total revenue and implement it on a spreadsheet. b. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. c. Use "Solver" to find the optimal prices.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 17 images

Blurred answer
Knowledge Booster
Sales
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Microeconomics: Private and Public Choice (MindTa…
Microeconomics: Private and Public Choice (MindTa…
Economics
ISBN:
9781305506893
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning
Economics: Private and Public Choice (MindTap Cou…
Economics: Private and Public Choice (MindTap Cou…
Economics
ISBN:
9781305506725
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
ECON MICRO
ECON MICRO
Economics
ISBN:
9781337000536
Author:
William A. McEachern
Publisher:
Cengage Learning
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Essentials of Economics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Economics
ISBN:
9781337091992
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning