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 = 4000 - 6p where p is the price of the e-book.
a. Update your spreadsheet model constructed for Problem 3 to take into account this demand function.
b. Use Goal Seek to calculate the price that results in breakeven.
c. Use a data table that varies price from $50 to $400 in increments of $25 to find the price that maximizes profit.