please answer question 4 thanks

3. E-book Profit/Loss. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for \$46, LO 1,LO2,LO3 a. Create an influence diagram to calculate the profit/loss. b. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,500 copies? c. Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to assess the sensitivity of profit to demand. 4. E-book Profit/Loss (revisited). Consider the Profit/Loss problem presented in problem 3. LO 5, LO 6 a. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,500 copies. b. Consider the following scenarios: For each of these scenarios, the fixed cost remains $160,000. Use Scenario Manager to generate a summary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Which scenario yields the lowest profit? 3. E-book Profit/Loss. Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet applications for business. The fixed cost of manuscript preparation, textbook design, and web site construction is estimated to be $160,000. Variable processing costs are estimated to be $6 per book. The publisher plans to sell single-user access to the book for \$46, LO 1,LO2,LO3 a. Create an influence diagram to calculate the profit/loss. b. Build a spreadsheet model to calculate the profit/loss for a given demand. What profit can be anticipated with a demand of 3,500 copies? c. Use a data table to vary demand from 1,000 to 6,000 in increments of 200 to assess the sensitivity of profit to demand. 4. E-book Profit/Loss (revisited). Consider the Profit/Loss problem presented in problem 3. LO 5, LO 6 a. Use Goal Seek to determine the access price per copy that the publisher must charge to break even with a demand of 3,500 copies. b. Consider the following scenarios: For each of these scenarios, the fixed cost remains $160,000. Use Scenario Manager to generate a summary report that gives the profit for each of these scenarios. Which scenario yields the highest profit? Which scenario yields the lowest profit