(d) If Cox Electric makes 12,000 units of the new product, what is the resulting profit (in dollars)? $ Need Help? Viowing Savod Wark Rovort to Last Rospanse [-/12 Points] CAMMBA4 10.E.003.MI.SA. Tutorial Exereise (a) Build a spreadsheet model to calculate the profit/loss for a given demand. What profit (in dollars) can be anticipated with a demand of 3,300 copies? (b) 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. (c) Use Goal Seek to determine the access price per copy (in dollars) that the publisher must charge to break even with a demand of 3,300 copies. (d) Consider the following scenarios. For each of these scenarios, the fixed cost remains $158,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