Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B Price: 310). The sales of these products are

The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera B Price: 310). The sales of these products are not independent of each other, but rather if the price of one increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. 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 (N) and prices (P) of each model: NA = 196 - 0.5PA + 0.35PB NB = 301 + 0.06PA - 0.6PB Construct a model for the total revenue and implement it on a spreadsheet. 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 increments of $10. Max profit occurs at Camera A price of $ . Max profit occurs at Camera B price of $ . Please include excel directions on how to find this information

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

Understanding And Managing Public Organizations

Authors: Hal G. Rainey

4th Edition

047040292X, 978-0470402924

More Books

Students also viewed these General Management questions