Question
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 a spreadsheet.
B. Develop a 2 way data table to estimate the optimal price of each of the two products in order to maximize the total revenue. Vary price of each product from $600 to $900 in increments of $50.
1. What is the maximum revenue?
2. What is the optimal price for model x?
3. What is the optimal price for model y?
Please show excel formulas.
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...
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...
Exercise 9-2 Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104....
Exercise 9-2 Edington Electronics Inc. produces and sells two
models of pocket calculators, XQ-103 and XQ-104. The calculators
sell for $14 and $28, respectively. Because of the intense
competition Edington faces, management budgets sales semiannually.
Its projections for the first 2 quarters of 2017 are as follows.
Unit Sales Product Quarter 1 Quarter 2 XQ-103 21,620 27,980 XQ-104
13,540 16,670 No changes in selling prices are anticipated. Prepare
a sales budget for the 2 quarters ending June 30, 2017. List...
3. A small manufacturing firm in Vatuwaqa produces two goods, X and Y for the domestic...
3. A small manufacturing firm in Vatuwaqa produces two goods, X
and Y for the domestic market.The selling price of Good X is $54
and Good Y is $52. The manager has estimated the total cost
function to be ?? = 3?^2 + 3?? + 2?^2 − 100. Compute the quantity
of the two goods the firm should produce in order to maximize
profits. Show all working.
4. A firm produces two goods, X and Y. The demand function for...
Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators...
Edington Electronics Inc. produces and sells two models of
pocket calculators, XQ-103 and XQ-104. The calculators sell for $15
and $25, respectively. Because of the intense competition Edington
faces, management budgets sales semiannually. Its projections for
the first 2 quarters of 2020 are as follows.
Unit Sales
Product
Quarter 1
Quarter 2
XQ-103
22,140
26,850
XQ-104
13,300
17,860
No changes in selling prices are anticipated.
Prepare a sales budget for the 2 quarters ending June 30, 2020.
List the products...
Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators...
Edington Electronics Inc. produces and sells two models of
pocket calculators, XQ-103 and XQ-104. The calculators sell for $14
and $25, respectively. Because of the intense competition Edington
faces, management budgets sales semiannually. Its projections for
the first 2 quarters of 2020 are as follows.
Unit Sales
Product
Quarter 1
Quarter 2
XQ-103
21,480
26,860
XQ-104
13,140
16,500
No changes in selling prices are anticipated.
Prepare a sales budget for the 2 quarters ending June 30, 2020.
List the products...
Kima Company manufactures and sells two models of a home appliance. The Standard model is a...
Kima Company manufactures and sells two models of a home
appliance. The Standard model is a basic appliance with mostly
manual features, while the Galaxy model is highly automated. The
appliances are produced to order, and there are no inventories at
the end of the year.
The cost accounting system at Kima allocates overhead to
products based on direct labor cost. Overhead in year 1, which just
ended, was $3,642,500. Other data for year 1 for the two products
follow:...
1. Suppose the equation p(x,y)=-2x^2+80x-3y^2+90+100 models profit when x represents the number of handmade chairs and...
1. Suppose the equation p(x,y)=-2x^2+80x-3y^2+90+100 models
profit when x represents the number of handmade chairs and y is the
number of handmade rockers produced per week.
(1) How many chairs and how many rockers will give the maximum
profit when there is not constraint?
(2) Due to an insufficient labor force they can only make a
total of 20 chairs and rockers per week (x + y = 20). So how many
chairs and how many rockers will give the...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 6 minutes ago
asked 17 minutes ago
asked 17 minutes ago
asked 26 minutes ago
asked 37 minutes ago
asked 42 minutes ago
asked 45 minutes ago
asked 48 minutes ago
asked 52 minutes ago
asked 57 minutes ago
asked 1 hour ago
asked 1 hour ago