Question

In: Statistics and Probability

Cash Money Records is considering publishing a new music album. The fixed cost of an album...

Cash Money Records is considering publishing a new music album. The fixed cost of an album preparation, studio time, and guest appearances is estimated to be $850,000. Variable costs are estimated to be $2 per album. The music label plans to sell access to the album for $10 each at various online marketplaces. (Report all Solutions on Excel documentation)

a. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 115,000 purchases of the album?

b. Use a data table to vary demand from 100,000 to 300,000 increments of 50,000 to assess the sensitivity of profit to demand.

c. Use Goal Seek to determine the access price per copy that the record company must charge to break even with a demand of 235,000 copies.

Solutions

Expert Solution

Fixed Cost = $850,000

Total Variable cost = Demand * 2

Total Cost = Fixed cost + Total variable cost

Revenue = 10* demand

Profit = Revenue - Total cost

a) Prepare the following sheet

get this

ans: The profit that can be anticipated with a demand of 115,000 purchases of the album is $70,000

b) Create the following data table

get this

select the data table and use data-->what if analysis---:data table

get this

c) set the demand at 235,000

Break event is when the profit=0

set the data--->what if analysis--->goal seek

get this

ans: the access price per copy that the record company must charge to break even with a demand of 235,000 copies is $6


Related Solutions

Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,400 copies? For subtractive...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $155,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $47. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 -...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49. (a) (b) JUST NEED HELP WITH C (c) Use Goal Seek to answer the following question. With a demand of 3,400 copies, what is the access price per...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $150,000. Variable processing costs are estimated to be $7 per book. The publisher plans to sell single-user access to the book for $49. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 -...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $170,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $45. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 -...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $170,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $45. Through a series of web-based experiments, Eastman has created a predictive model that estimates demand as a function of price. The predictive model is demand = 4,000 -...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46. (a) Build a spreadsheet model in Excel to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,500 copies? For subtractive...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed...
Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web-site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for $46. a.) Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3500 copies? b.) Use a data...
(IRR, Payback, and calculating a missing cash flow) Mode publishing is considering a new printing facility...
(IRR, Payback, and calculating a missing cash flow) Mode publishing is considering a new printing facility that will involve a large initial outlay and then result in a series of positive cash flows for four years. The estimated cash flows associated with this project are: Year Project Cash Value 0 ? 1 $810 Million 2 $350 Million 3 $280 Million 4 $450 Million If you know that the project has a regular payback of 2.9 years, what is the project's...
Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of...
Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of $3.66 million which will be depreciated straight-line to a zero book value over the 10-year life of the project. At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 21 percent. The project will require $45,000 of inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT