Essay
An electronics store sells two 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 these products. The result of the study is shown below:
DX = 476 - 0.54 PX + 0.22 PY
DY = 601 + 0.12 PX - 0.54 PY 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 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.
Correct Answer:

Verified
a.
b. From the table shown ...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
b. From the table shown ...
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q11: The _ function allows the user to
Q14: The calculations of a cell can be
Q16: The arguments supplied to the IF function
Q19: Anna operates a consignment shop where she
Q21: The Gatson manufacturing company has estimated the
Q23: The Gatson manufacturing company has estimated the
Q24: . Reference - 7.1Use the influence diagram
Q30: Which of the following is true of
Q33: The SUM function in Excel<br>A)adds up all
Q45: The conceptual model<br>A)helps in organizing the data