An electronics store sells two popular models of wireless headphones, model A and model B. The sales of these products are not independent of each other (in economics, we call these substitutable products because if the price of one increases, sales of the other will increase). 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 = 25 -0.62PA+0.38P3 Ng = 26 +0.12PA-0.66PB Develop a spreadsheet for calculating the total revenue if PA = $17 and PB = $28. Design it so that the price-demand function parameters can easily be changed. Complete the spreadsheet below. (Type integers or decimals. Round the quantities to the nearest integer as needed. Do not include the $ symbol in your answers.) Model Parameters for QTY Sold Constant Model Price Coeff Price A Coeff Price B Quantity Sold Revenue io Total Revenue rt

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question
An electronics store sells two popular models of wireless headphones, model A and model B. The sales of these products are not independent of each other (in
economics, we call these substitutable products because if the price of one increases, sales of the other will increase). 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 = 25 - 0.62PA+0.38P8
Ng = 26 +0.12PA-0.66PB
Develop a spreadsheet for calculating the total revenue if PA = $17 and PB = $28. Design it so that the price-demand function parameters can easily be changed.
Complete the spreadsheet below.
(Type integers or decimals. Round the quantities to the nearest integer as needed. Do not include the $ symbol in your answers.)
Model Parameters for QTY Sold
Constant
Model
Price
Coeff Price A
Coeff Price B
Quantity Sold
Revenue
3.
io
B.
Total Revenue
rt
EBA
Clear all
Check answer
Help me solve this
View an example
Get more help-
Transcribed Image Text:An electronics store sells two popular models of wireless headphones, model A and model B. The sales of these products are not independent of each other (in economics, we call these substitutable products because if the price of one increases, sales of the other will increase). 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 = 25 - 0.62PA+0.38P8 Ng = 26 +0.12PA-0.66PB Develop a spreadsheet for calculating the total revenue if PA = $17 and PB = $28. Design it so that the price-demand function parameters can easily be changed. Complete the spreadsheet below. (Type integers or decimals. Round the quantities to the nearest integer as needed. Do not include the $ symbol in your answers.) Model Parameters for QTY Sold Constant Model Price Coeff Price A Coeff Price B Quantity Sold Revenue 3. io B. Total Revenue rt EBA Clear all Check answer Help me solve this View an example Get more help-
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,