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.
The Camera Shop sells two popular models of digital SLR cameras (Camera A
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.5PA + 0.35PB
NB = 300 + 0.06PA - 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 revenue occurs at Camera A price of $ -
Max revenue occurs at Camera B price of $ -
Trending now
This is a popular solution!
Step by step
Solved in 4 steps