Ealtwan Publisking Company is considening publishing an electronic teatbook about spreadiseet appilcations for business, The fixed cost of manuscripk preparation, fentbook design, and web-site construction is estimaked to be $160,000. Varlable processing costs are estimated to be $5 per bock. The publaher plans to sell singleriter access to the book for s45, (a) build a spreadaheet model in Excel to calcilese the profityoss for a given demand. What profit can be anticipated with a demand of 3 , 500 cepies? for subtractive or negative numbers use a minua sye? (b) Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to test the sensitwity of profit to demand. Ereakeven occurs where profit goes frem a negative to a poshive vate, that is, breakeven is where total revenue - total cost yielding a profe of zero. in which interval of demand does breakeven occur? (i) Breakeven apoears in the merval of 3,600 to 3,800 copies. (G) Breakeven aspears in the interval of 4,000 to 4,200coples. (ui) Breakeven appears in the inserval of 4,200,404,400 coples: (iv) Breakeven appears in the interval of 4,400 to 4,600 copies. (c) Use Cos Seek to determine the ackess price per copy that the publiher must charge to break fven w th a demand of 3 , soo copies. If required, round your antwer to two decimal places (d) Convider the following scenarios: For each of thele scenarion, the fiand cost cemane \$160,000. Use Scenaris Manajee to penerate a summary report that gives the proft for each of these ncenanos. Which scenario