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

  Write down the difference between contractionary and

what is the difference between contractionary and expansionary fiscal policies? which is more appropriate today?

  Whats marks marginal cost function

How much is his fixed cost? How much is his variable cost and at what level of production is his average cost minimum

  Techniques of discounted cash flow

You're advising a friend who has a decision to make regarding Social Security. He is about turn 62 years old, and is eligible for early Social Security benefits. His early benefits would amount to $677 each month.

  Effect of unethical behavior article analysis

Effect of Unethical Behavior Article Analysis

  Increase wages and reduce the marginal expense of labor

Minimum wage laws help low-wage workers because they simultaneously increase wages and reduce the marginal expense of labor. Analyze this statement

  Workings of private marketplace

Recognize three well-founded reasons supporting the potentially beneficial role for government intervention in the workings of private marketplace.

  An economy is faced by exhaustion of an important natural

An economy is faced by exhaustion of an important natural resource at a time when it is introducing improved technology.explain how these events will effect the economy production possibility curve.

  Describe what 1 economics of scale 2 economies of scope and

wal-mart is the largest corporation in the world. during 2012 it made about 425 billion in sales representing 1.9

  Method of estimating earnings called synthetic life time

Discuss the method of estimating earnings called Synthetic Life-time Earning

  The opportunity cost of a scholarship

A university had initially allocated £500k to lectureships and scholarships, each of which costs £50k and £10k respectively. Its trustees have later reduced the overall budget to £300k. Hence, the opportunity cost of a scholarship has:Select one or m..

  Suppose the federal government has balanced budgets

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ..

  A watchmaking firm operating in a competitive market

Suppose you are the manager of a watchmaking firm operating in a competitive market. Your cost of production is given by.C=100+2q2

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