In: Statistics and Probability
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 copy that the publisher must charge to break even? |
If required, round your answers to two decimal places. |
The answer is $51.1176471
Okay, let us use goal seek to answer this question.
Part 1 - Setting up the model in excel:
Part 2 - Applying goal seek
(i)
(ii)
Part 3 - The Solutiion
Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!