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 $9 per book. The publisher plans to sell single-user access to the book for $41.
Required:
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?