16. Revenue with Substitutable Products. The Camera Shop sells two popular models of digital single lens reflex (DSLR) cameras. The sales of these products are not inde- pendent; if the price of one increases, the sales of the other increases. In economics. these two camera models are called substitutable products. The store wishes to estab- lish 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 price (P) of each model: NA 195 0.6PA + 0.25PB N = 301+0.08PA-0.5PB a. 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. Vary each price from $250 to $500 in incre- ments of $10.
16. Revenue with Substitutable Products. The Camera Shop sells two popular models of digital single lens reflex (DSLR) cameras. The sales of these products are not inde- pendent; if the price of one increases, the sales of the other increases. In economics. these two camera models are called substitutable products. The store wishes to estab- lish 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 price (P) of each model: NA 195 0.6PA + 0.25PB N = 301+0.08PA-0.5PB a. 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. Vary each price from $250 to $500 in incre- ments of $10.
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question

Transcribed Image Text:16. Revenue with Substitutable Products. The Camera Shop sells two popular models
of digital single lens reflex (DSLR) cameras. The sales of these products are not inde-
pendent; if the price of one increases, the sales of the other increases. In economics.
these two camera models are called substitutable products. The store wishes to estab-
lish 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 price
(P) of each model:
NA 195 0.6PA + 0.25PB
N = 301+0.08PA-0.5PB
a. 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. Vary each price from $250 to $500 in incre-
ments of $10.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Similar questions
Recommended textbooks for you


Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON

Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON


Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON

Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON

Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning

Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning

Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education