Answer with formulas including scenario manager.

We learned how to use the Scenario Manager to view the results of a model you will build to determine the profitability based on the scenarios below. You have been assigned to analyze the profitability of Bill Clinton's autobiography. The following assumptions have been made: Determine how the publisher's profit will vary with the Scenarios provided (Strong Sales, Break Even Sales, Weak Sales). 15 points \begin{tabular}{l|r|} \hline One-time royalty payment to Bill Clinton & $8,000,000 \\ \hline Fixed cost of producing the hard cover version of the book & $1,000,000 \\ \hline Variable cost of producing EACH hard cover version of the book & $6.00 \\ \hline Sale price of EACH hard cover book & $15.00 \\ \hline Hard cover book demand & 1,000,000 \\ \hline Fixed cost of producing the paperback version of the book & $250,000 \\ \hline Variable cost of producing EACH paperback version of the book & $2.00 \\ \hline Sale price of EACH paperback book & $4.00 \\ \hline Paperback book demand will be double the hard cover book demand & \\ \hline \end{tabular} Scenarios Strong Sales Hardcover Break Even Sales* Demand Hardcover Paperback Weak Sales Variable Cost Variable Cost *Use Goal Seek to find the Break Even Hardcover Demand (profit =0 ) and enter this number in the Hardcover Demand box above, these are the same variable costs that are in the original pro forma assumptions. Build a model below (Sales, Variable Costs, Fixed Costs, Profit) and run each Scenario