Determine how the publisher's profit will vary with the Scenarios provided $($Strong Sales, Break Even Sales, Weak Sales$).$You have been assigned to analyze the profitability of Elon Musk'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$).$

$10$ points

One$-$time royalty payment to Elon Musk

Paperback book demand will be $2\mathrm{.}5x$ the hard cover book demand

$*$Use Goal Seek to find the Break Even Hardcover Demand $($profit $0)$ of the original model and manually 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

Prof Forma Model

Total Sales $($demand $*$ sales price$)$

Total Variable costs $($demand $*$ variable costs$)$

Total Fixed costs $($there should be $3$ fixed costs above$)$

Profit $($Sales $-$ Variable Costs $-$ Fixed Costs$)$