is estimated to be $$155,000.$ Variable processing costs are estimated to be $$6$ per book. The publisher plans to sell single$-$user access to the book for $$47.$

$($a$)$ 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,200$ copies?

For subtractive or negative numbers use a minus sign.

$

breakeven is where total revenue $=$ total cost yielding a profit of zero. In which interval of demand does breakeven occur?

$($i$)$ Breakeven appears in the interval of $3,200$ to $3,400$ copies.

$($ii$)$ Breakeven appears in the interval of $3,600$ to $3,800$ copies.

$($iii$)$ Breakeven appears in the interval of $3,800$ to $4,000$ copies.

$($iv$)$ Breakeven appears in the interval of $4,000$ to $4,200$ copies.

$($c$)$ Use Goal Seek to answer the following question. With a demand of $3,200$ copies, what is the access price per copy that the publisher must charge to break even?

If required, round your answers to two decimal places.

$