Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

helpppp [1 Points] Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design,

helpppp
image text in transcribed
[1 Points] 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 $145,000. Variable processing costs are estimated to be $5 per book. The publisher plans to sell single-user access to the book for $43. 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,0006p, where p is the price of the e-book. (a) Construct an appropriate spreadsheot model for calculating the profit/oss at a given single-user accoss price taking into account the above demand function. What is the profit estimated by your model for the given costs and single user access price (in dollars). 5 (b) Use Goal Seek to calculate the price (in doliars) that results in breakeven. (Round your answer to the nearest cent.) (c) Use a data table that varies price from $50 to $400 in increments of $25 to find the price (in deilars) that maximizes profit

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Risk Modeling Evaluation Handbook Rethinking Financial Risk Management Methodologies In The Global Capital Markets

Authors: Greg Gregoriou, Christian Hoppe, Carsten Wehn

1st Edition

0071663703, 978-0071663700

More Books

Students also viewed these Finance questions

Question

7. Identify four antecedents that influence intercultural contact.

Answered: 1 week ago

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago