Question
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 200, Camera...
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 200, Camera B Price: 300). 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 = 198 - 0.5PA + 0.25PB
NB = 305 + 0.07PA - 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 show how to solve using excel, thanks.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 200, Camera...
The Camera Shop sells two popular models of digital SLR cameras
(Camera A Price: 200, Camera B Price: 300). 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...
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 220, Camera...
The Camera Shop sells two popular models of digital SLR cameras
(Camera A Price: 220, Camera B Price: 300). 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...
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 200, Camera...
The Camera Shop sells two popular models of digital SLR cameras
(Camera A Price: 200, Camera B Price: 300). 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...
An electronics store sells 2 models of television. The sales of these two models, x and...
An electronics store sells 2 models of television. The sales of
these two models, x and y, are dependent, that is, if the price of
one increases, the demand for the other increases. A study is made
to find the relationship between the demand (D) and the price (P)
in order to maximize the revenue from the products. The result of
the study is shown below. Dx=476-0.54Px+0.22Py
Dy=601+0.12Px-0.54Py
A. construct a model for the total revenue and implement it on...
Jim's Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand for these...
Jim's Camera shop sells two high-end cameras, the Sky Eagle and
Horizon. The demand for these two cameras are as follows
(DS = demand for the Sky Eagle,
Ps is the selling price of the Sky Eagle,
DH is the demand for the Horizon and
PH is the selling price of the Horizon):
Ds = 230 - 0.5PS +
0.38PH
DH = 260 + 0.1Ps -
0.62PH
The store wishes to determine the selling price that maximizes
revenue for these...
Problem 13-5 Jim's Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand...
Problem 13-5
Jim's Camera shop sells two high-end cameras, the Sky Eagle and
Horizon. The demand for these two cameras are as follows
(DS = demand for the Sky Eagle, Ps is the selling
price of the Sky Eagle, DH is the demand for the Horizon
and PH is the selling price of the Horizon):
Ds = 230 - 0.5PS + 0.38PH
DH = 260 + 0.1Ps - 0.62PH
The store wishes to determine the selling price that maximizes
revenue...
Finch Cameras, Inc. manufactures two models of cameras. Model ZM has a zoom lens; Model DS...
Finch Cameras, Inc. manufactures two models of cameras. Model ZM
has a zoom lens; Model DS has a fixed lens. Finch uses an
activity-based costing system. The following are the relevant cost
data for the previous month:
Direct Cost per Unit
Model ZM
Model DS
Direct materials
$
20.5
$
10.5
Direct labor
29.0
13.0
Category
Estimated Cost
Cost
Driver
Use of Cost
Driver
Unit level
$
24,000
Number of units
ZM: 2,450 units; DS: 9,550
units
Batch...
Katch You (KY) has developed a new digital camera with an automatically triggered flash. This product...
Katch You (KY) has developed a new digital camera with an
automatically triggered flash. This product was introduced last
year and a follow-up survey has just been completed, giving rise to
the following regression equation:
Qx = – 120.1366 – 83.78Px + 0.09Y – 25.45Pc + 81.39Ps +
0.1824Ax
Where Qx is the quantity demanded; Px is the price per unit in
dollars; Y is the income per capita, Pc is the price per unit for
the camera’s case and...
A-Zone Media sells two models of e-readers. The budgeted price per unit for the wireless model...
A-Zone Media sells two models of e-readers. The budgeted price
per unit for the wireless model is $199 and the budgeted price per
unit for the wireless and cellular model is $430. The master budget
called for sales of 10,700 wireless models and 2,850 wireless and
cellular models during the current year. Actual results showed
sales of 8,200 wireless models, with a price of $235 per unit, and
4,450 wireless and cellular models, with a price of $540 per unit....
Ficcus Inc. manufactures two types of products, the Gx and the Tx models. The company operates...
Ficcus Inc. manufactures two types of products, the Gx and the
Tx models. The company operates five days per week and makes a net
profit of $125 on the Gx model, and $175 on the Tx model. The
models are manufactured in two main departments: production and
assembly. The production department has 58 skilled workers, each of
whom works 7 hours per day. The assembly department has 25 workers,
who also work a 7-hour shift. On an average, to produce...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 28 minutes ago
asked 28 minutes ago
asked 38 minutes ago
asked 39 minutes ago
asked 43 minutes ago
asked 44 minutes ago
asked 45 minutes ago
asked 45 minutes ago
asked 47 minutes ago
asked 54 minutes ago
asked 59 minutes ago
asked 1 hour ago