Re-create the spreadsheet shown

Assignment Help Microeconomics
Reference no: EM13880865

The accompanying spreadsheet depicts the pricing options (cells C10 and C18) for a best seller that is released in hardback and as an e-book. The demand curve for the hardback version is described by the equation: Q = 80 - 2.4P + 2PE, where PE denotes the e-book price. In turn, the demand curve for the e-book is given by: QE = 80 - 4PE. (Both quantities are denominated in thousands of units.) Note that lowering the e-book price by $1.00 increases e-book sales by 4 thousand units but also reduces hardbook sales by 2 thousand books. In short, each additional e-book sold replaces .5 hardback sales.

The profit cells are calculated based on the economic facts noted earlier in the chapter. (1) Revenues for the e-book are split 70-30 between book publisher and online seller. The marginal cost of producing and delivering additional e-books is essentially zero. (2) Revenues for the print book are split 50-50 between the book publisher and the book retailer. The publisher incurs $3.50 per hardback in production and related costs. (3) For both book types, the publisher pays a 15 percent author royalty based on total retail revenue.

a. Re-create the spreadsheet shown. If e-books did not exist (set PE = $20 so that QE is 0), what is the publisher's profit-maximizing hardback price?

b. Before 2010 when Amazon was free to set the e-book price, what price should Amazon have set? In response, what is the publisher's profit- maximizing price for the hardback?

c. Alternatively, if the publisher sets both book prices, what are the optimal prices? Why does the publisher prefer a higher e-book price than the online seller?

d. Suppose that each e-book sale replaces one hardback sale. This cannibalization rate is described by the hardback demand curve:
Q = 40 - 2.4P + 4PE. Using this demand curve, re-answer the questions in parts (b) and (c). Confirm that this worsens the pricing

 

 

A

B

C

D

E

F

G

H

I

1

 

 

 

 

 

 

 

 

 

2

 

Pricing Print Books and E-books

 

 

 

3

 

 

 

 

 

 

 

 

 

4

 

 

 

 

 

 

 

 

 

5

 

Book Publisher

Q = 80 - 2.4P + 2Pe

 

 

 

 

6

 

 

 

 

 

 

 

 

 

7

 

 

Print Books

E-Books

 

Total

 

8

 

 

Price

Quantity

Profit

Profit

 

Profit

 

9

 

 

 

 

 

 

 

 

 

10

 

 

$25.00

60.00

$315

$0

 

$315

 

11

 

 

 

 

 

 

 

 

 

12

 

 

 

 

 

 

Combined Profit

 

13

 

E Book Seller

Qe = 80 - 4Pe

 

 

$315

 

14

 

 

 

 

 

 

 

15

 

 

E-Books

 

 

 

 

16

 

 

Price

Quantity

Revenue

Profit

 

 

 

17

 

 

 

 

 

 

 

 

 

18

 

 

$20.00

0.00

$0

$0

 

 

 

19

 

 

 

 

 

 

 

 

 

conflict between publisher and online seller. In this case, which would the publisher prefer: (1) the time when e-books didn't exist, or (2) the young e-book market when Amazon set prices?

Reference no: EM13880865

Questions Cloud

What is the yield to call for these bonds : Atlantis Fisheries issues zero coupon bonds on the market at a price of $421 per bond. These are callable in 7 years at a call price of $640. Using semi annual compounding, what is the yield to call for these bonds?
What must the coupon rate be on the companys bonds : Ghost Rider Corporation has bonds on the market with 11 years to maturity, a YTM of 6.8 percent, and a current price of $929. What must the coupon rate be on the company’s bonds?
What is the portfolios expected return : A portfolio is invested 15 percent in Stock G, 55 percent in Stock J, and 30 percent in Stock K. The expected returns on these stocks are 8 percent, 14 percent, and 18 percent, respectively. What is the portfolio’s expected return? How do you interpr..
About the bond valuation : An investor has two bonds in his portfolio that both have a face value of $1,000 and pay a 8% annual coupon. Bond L matures in 11 years, while Bond S matures in 1 year. What will the value of the Bond S be if the going interest rate is 5%? Why does t..
Re-create the spreadsheet shown : Re-create the spreadsheet shown. If e-books did not exist (set PE = $20 so that QE is 0), what is the publisher's profit-maximizing hardback price?
What methods would you suggest for pre-attentive processing : What is meant by pre-attentive? What methods would you suggest for pre-attentive processing that could still be ADA compliant?
Classic retirement problem : This is a classic retirement problem. A time line will help in solving it. Your friend is celebrating her 40th birthday today and wants to start saving for her anticipated retirement at age 65. What amount must she deposit annually now to be able to ..
What is the projected dividend : Momsen Corp. is experiencing rapid growth. Dividends are expected to grow at 26 percent per year during the next three years, 16 percent over the following year, and then 4 percent per year indefinitely. The required return on this stock is 10 percen..
The medical expense insurance-like organizations : The medical expense insurance-like organizations that eventually came to be called Blue Cross plans were initially run by

Reviews

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd