Question
In: Statistics and Probability
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 = 195 - 0.6PA + 0.25PB NB = 301 + 0.08PA - 0.5PB 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 $ . |
Solutions
Expert Solution
| put this formula: =$D3*(195-0.6*$D3+0.25*E$2)+E$2*(301+0.08*$D3-0.5*E$2) while changing values of A and B in D column and 2nd row, we get maximum value 84999 at 270,390 point |
Max profit occurs at Camera A price of $ =270
Max profit occurs at Camera B price of $ =330
below is excel output for corresponding A and B values represented in row and columns:
orchestra answered 1 year agoRelated Solutions
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 A 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: 230, Camera...
The Camera Shop sells two popular models of digital SLR cameras
(Camera A Price: 230, 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...
Go Camera manufactures and sells two types of cameras for cars and drones. These two models...
Go Camera manufactures and sells two types of cameras for cars
and drones. These two models are manufactured in separate
facilities and each facility is treated as profit center. Go Camera
serves as a supplier to car manufacturers as well as drone
manufacturers. The following table provides cost and price
information for each model:
Car Camera
Drone Camera
Selling Price
$70
$100
Variable Cost
$30
$35
Fixed Cost
$300,000
$ 600,000
Go Camera has a marketing department with cost $400,000...
Problem 10-16 (Some Useful Excel Functions for Modeling) The Camera Shop sells two popular models of...
Problem 10-16 (Some Useful Excel Functions for
Modeling)
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...
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
Find the prices that maximize revenue.
If required, round your answers to two...
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
= 215 - 0.6 Ps + 0.25
PH
DH
= 270 + 0.1 Ps - 0.55
PH
The store wishes to
determine the selling price that...
Camera Products Inc. produces two different products with the following monthly data for July: Digital Cameras...
Camera Products Inc. produces two different products with the
following monthly data for July:
Digital
Cameras
Tripods
Total
Selling price per unit
$300
$100
Variable cost per unit
$240
$ 60
Expected unit sales
28,000
7,000
35,000
Sales mix
80%
20%
100%
Fixed costs
$700,000
If the sales mix shifts to 85 percent cameras and 15 percent
tripods, what happens to the break-even point in units?
Brevard Company makes a single product. The company has monthly
fixed costs totaling $250,000...
A company that manufactures and sells consumer video cameras sells two versions of their popular hard...
A company that manufactures and sells consumer video cameras
sells two versions of their popular hard disk camera, a basic
camera for $500, and a deluxe version for $1200. About 55% of
customers select the basic camera. Of those, 30% purchase the
extended warranty for an additional $100. Of the people who buy
the deluxe version, 50% purchase the extended warranty. Complete
parts a through d below. a) Sketch the probability tree for total
purchases. Warranty 0.3 Basic and Warranty...
Digital cameras make up most of the? point-and-shoot camera market. One of the important features of...
Digital cameras make up most of the? point-and-shoot camera
market. One of the important features of a camera is battery life.
In a sample of 31? sub-compact cameras and 15 compact? cameras, the
mean and standard deviations? (respectively) are 240.65 and 114.22
shots? (subcompact) and 270 and 112.06 shots? (compact). Assume
that the population variances are equal across the samples.?? a. If
you want to test whether the battery lives differ across the
camera? types, what is the correct set...
The demand curve for cameras is Q=400-2P where P is the price of a camera and...
The demand curve for cameras is Q=400-2P where P is the price
of a camera and Q is the number of cameras sold per week. Answer
the following questions.
If the vendor has been selling 120 cameras per week, how much
revenue has she been collecting?
What is the price elasticity of demand for cameras?
Does the law of demand hold?
If the vendor wants to generate more revenue, should she raise
or lower the price of cameras?
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Please explain your view of the most difficult aspect of Customs Compliance?
- You are required to write an interactive program that prompts the user for seven (7) real...
- Describe in detail the five-forces model of industry competition. What causes each of the forces to...
- Java Programming. I'm writing this in an IDE called Eclipse. If you could also use comments...
- Scenario: You are a departmental manager in a large community hospital in an urban area. Your...
- Need to answer the following 3 questions from "The Sixties, AMerican Yawp" (just google, you will...
- Write a c++ program to load two column of numbers, do arithmetic operations to the data...
ADVERTISEMENT