Question

The Radio Shop sells two popular models of portable sport radios: model A and model B....

The Radio Shop sells two popular models of portable sport radios: 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 increase, sales of the other will increase). The store wishes to establish a pricing policy to maximize revenue from the products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model (i.e. PA → Price of model A, NA  → Number of model A sold, etc.):

NA = 20 – 0.62PA + 0.30PB

NB = 29 + 0.10PA – 0.60PB

  1. Construct a spreadsheet model for the total revenue.
  2. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue.
  3. Use Solver to find the optimal prices.
  4. Write a Python code which takes the value of PA and PB and calculates the total revenue. Copy a screenshot of your code in your solution or share the link of your code.

Homework Answers

Answer #1

1)

Here the Cost is basically referring to the amount incurred by the company for attaining a finished product. Thus the raw material used for manufacturing the finished product is termed as production cost. Similarly, in order to implement a system in the organization, various costs are associated with it which depends on the level of the system and the company.

2)

a.

It is needed to construct the model for the total revenue. Revenue refers to the money which is actually received by the company during a specific period that involves deduction and discount.

It can be expressed by the formula given below:

3)

b.

Predicted revenue refers to the money a particular company is estimated to generate underlying a particular time periods. The forecast is usually made for annual, quarterly, and monthly periods. The revenue is projected by the company by making use of internal knowledge and a combination of research.

It is required to find the predicted revenue if is $18 and is $30. It can be computed with the appropriate formula in the spreadsheet given below:

The corresponding values are:

Hence, it is ascertained that the total revenue accounts for  $705.12

4)

Now, if the price changes where is $25 and is $50. It can be computed with the appropriate formula in the spreadsheet given below:

The corresponding values are:

Hence, it is ascertained that the total revenue accounts for $562.50

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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...
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...
AudioMart is a retailer of radios, stereos, and televisions. The store carries two portable sound systems...
AudioMart is a retailer of radios, stereos, and televisions. The store carries two portable sound systems that have radios, tape players, and speakers. System A, of slightly higher quality than System B, costs $20 more. With rare exceptions, the store also sells a headset when a system is sold. The headset can be used with either system. Variable-costing income statements for the three products follow: System A System B Headset Sales $ 45,000 $ 32,500 $ 8,000 Less: Variable expenses...
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 The store wishes to determine the selling price that maximizes revenue for these...
Problem 13-5 Jim's Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand...
Problem 13-5 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 The store wishes to determine the selling price that maximizes revenue...
Finch Cameras, Inc. manufactures two models of cameras. Model ZM has a zoom lens; Model DS...
Finch Cameras, Inc. manufactures two models of cameras. Model ZM has a zoom lens; Model DS has a fixed lens. Finch uses an activity-based costing system. The following are the relevant cost data for the previous month:     Direct Cost per Unit Model ZM Model DS Direct materials $ 20.5 $ 10.5 Direct labor 29.0 13.0     Category Estimated Cost Cost Driver Use of Cost Driver Unit level $ 24,000 Number of units ZM: 2,450 units; DS: 9,550 units Batch...
Your company manufactures two models of speakers, the Ultra Mini and the Big Stack. Demand for...
Your company manufactures two models of speakers, the Ultra Mini and the Big Stack. Demand for each depends partly on the price of the other. If one is expensive, then more people will buy the other. If p1 is the price of the Ultra Mini, and p2 is the price of the Big Stack, demand for the Ultra Mini is given by q1(p1, p2) = 100,000 − 800p1 + 10p2 where q1 represents the number of Ultra Minis that will...