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 19-0.64PA+0.22PB NB=34+0.12PA-0.54PB 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.) A 2 Model 3 A 4 B 5 B Price с Model Parameters for QTY Sold Constant D E F G Coeff Price A Coeff Price B Quantity Sold Revenue Total Revenue

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 19-0.64PA+0.22PB NB=34+0.12PA-0.54PB 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.) A 2 Model 3 A 4 B 5 B Price с Model Parameters for QTY Sold Constant D E F G Coeff Price A Coeff Price B Quantity Sold Revenue Total Revenue

Managerial Economics: A Problem Solving Approach

5th Edition

ISBN:9781337106665

Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Publisher:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor

Chapter12: More Realistic And Complex Pricing

Section: Chapter Questions

Problem 9MC: After running a promotional campaign, the owners of a local hardware store decided to decrease the...

See similar textbooks

Similar questions

(Calculating Price Elasticity of Demand) Suppose that 50 units of a good are demanded at a price of Si per unit. A reduction in price to $0.20 results in an increase in quantity demanded to 70 units. Using the midpoint formula, show that these data yield a price elasticity of 0.25. By what percentage would a 10 percent rise in the price reduce the quantity demanded, assuming price elasticity remains constant along the demand curve?
If automobiles and gasoline are complements, then their cross-elasticity coefficient is a. strictly greater than 1. b. positive. c. equal to zero. d. negative.
Estimates presented in Exhibit 5 show that Android users have a higher price elasticity of demand for apps in the Google Play Store than do iPhone users in the Apple App Store. Why might Android users tend to be more sensitive to app prices than iPhone users? What categories or types of apps (for example, games/social media) do you think have the highest price elasticities?
In an attempt to increase revenues and profits, a firm is considering a 4 percent increase in price and an 11 percent increase in advertising. If the price elasticity of demand is 1.5 and the advertising elasticity of demand is +0.6, would you expect an increase or decrease in total revenues?
Suppose Erin, the owner-manager of a local hotel projects the following demand for her rooms: a. Calculate the price elasticity of demand between 90 and 110. b. Is the price elasticity of demand between 90 and 110 elastic, unit elastic, or inelastic? c. Will Erins total revenue rise if she increases the price from 90 to 110? d. Calculate the price elasticity of demand between 110 and 130. e. Is the price elasticity of demand between 110 and 130 elastic, unit elastic, or inelastic? f. Will Erins total revenue rise if she increases the price from 110 to 130?
Prove that price elasticity of demand is not the same as the slope of a demand curve.
Plot the price and quantity data given in the demand schedule of exercise 1. Put price on the vertical axis and quantity on the horizontal axis. Indicate the price elasticity value at each quantity demanded. Explain why the elasticity value gets smaller as you move down the demand curve.
The Stopdecay Company sells an electric toothbrush for $25. Its sales have averaged 8,000 units per month over the past year. Recently, its closest competitor, Decayfigh ter, reduced the price of its electric toothbrush from $35 to $30. As a result, Stopde cays sales declined by 1,500 units per month. What is the arc cross elasticity of demand between Stopdecays toothbrush and Decayfighters toothbrush? What does this indicate about the relationship between the two products? If Stopdecay knows that the arc price elasticity of demand for its toothbrush is 1.5, what price would Stopdecay have to charge to sell the same number of units as it did before the Decayfighter price cut? Assume that Decayfighter holds the price of its toothbrush constant at $30. What is Stopdecays average monthly total revenue from the sale of electric toothbrushes before and after the price change determined in part (b)? Is the result in part (c) necessarily desirable? What other factors would have to be taken into consideration?
Suppose Sally buys exactly five bars of English toffee each week, regardless of whether the toffee bars are regularly priced at 1 or on sale for 0.50. Based on this information, what is Sallys price elasticity of demand for English toffee in this price range? a. 0 b. 1 c. Infinity d. Cannot be determined.
Suppose that your demand schedule for pizza is as follows: a. Use the midpoint method to calculate your price elasticity of demand as the price of pizza increases from 8 to 10 if (i) your income is 20,000 and (ii) your income is 24,000. b. Calculate your income elasticity of demand as your income increases from 20,000 to 24,000 if (i) the price is 12 and (ii) the price is 16.
If a decrease in the price of movie tickets increases the total revenue of movie theaters, this is evidence that demand is a. price elastic. b. price inelastic. c. unit elastic with respect to price. d. perfectly inelastic.