QUESTION #$1$: Problem $14$ page $21($Breakeven point for a textbook$).$ In addition to parts $($a$)$ to $($d$),$ add part $($f$)$: Use a data table and the X$-$Y chart in Excel to create a

graph of the breakeven analysis for Eastman Publishing Co$.$ when the product volume $($i$.$e$.$ expected demand$)$ varies from $1000$ to $7000$ in increment of $500($i$.$e$.1000,1500,$

$2000,$ etc.$).$ Also, use the Goal Seek function to check your answer of part $($a$).$

Problem $14$

Breakeven Point for a Textbook. Eastman Publishing Company is considering pub$-$

lishing a paperback textbook on spreadsheet applications for business. The fixed cost

of manuscript preparation, textbook design, and production setup is estimated to be

$$160,000.$ Variable production and material costs are estimated to be $$6$ per book. The

publisher plans to sell the text to college and university bookstores for $$46$ each. LO $4$

a$.$ What is the breakeven point?

b$.$ What profit or loss can be anticipated with a demand of $3800$ copies?

c$.$ With a demand of $3800$ copies, what is the minimum price per copy that the pub$-$

lisher must charge to break even?

d$.$ If the publisher believes that the price per copy could be increased to $$50\mathrm{.}95$ and

not affect the anticipated demand of $3800$ copies, what action would you recom$-$

mend? What profit or loss can be anticipated?

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT

PLEASE USE EXCEL SOLVER AND PASTE A SCREENSHOT