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 tulsa part particularly self-explanator

Professor's Overview of Module 10 The reading for this lesson (Bowe, sections "Tulsa" and first part of "Saipan" to the bottom of p. 184) brings us to the use and abuse of U.S. visa programs to bring workers into the United States, often from more un..

  Types of intellectual property

Many people struggle with the differences among the types of Intellectual Property. Research each of the following four topics independently.

  Determine the months of use necessary for two to break even

An engineering practitioner can lease a fully equipped computer and color printer system for$800 per month or purchase one for $8500 now and pay a $75 per month maintenance fee. If the nominal interest rate is 15% per year.

  Constant-value dollars and then-current dollars

A certain machine will have a cost of $25,000 (then $) six years from now. Find the PW of the machine if the real interest rate is 10% per year and the inflation rate is 5% per year using

  How might a recession impact the circular flow of income

How might a recession impact the circular flow of income

  Suppose you bought a ticket to a football game for 30 and

suppose you bought a ticket to a football game for 30 and that you place a 35 value on seeing the game. if you lose the

  The state of glottamora has 100 million remaining in its

the state of glottamora has 100 million remaining in its budget for the current year. one alternative is to give

  What is the shutdown point

What is the shutdown point? Give an example. How is the short-run defined in the production process? Please provide references if applicable.

  Government spending on social security-medicare

From 1950 to today, government spending on Social Security, Medicare, and Medicaid as a percentage of GDP has

  Governments are often justified, from an economic

1) Governments are often justified, from an economic perspective, as being able to correct market failures. Discuss what might cause market failures and whether or not each of the factors underlying market failure might also influence the abili..

  Hd inc manufactures high definition plasma screen

hd inc. manufactures high definition plasma screen television sets.nbsp they are thinking of manufacturing a new

  What is cineplexs best action and does it depend on amc move

This assignment problem from economics and it is focuses on Nash equilibrium or game theory, introduced by Prof. John Nash. A case study involving game theory in deciding dominant strategy for two competing multiplexes is given.

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