PLEASE SHOW STEPS TO SOLVE!

Google is analyzing the decision to launch a new Pixel launch. The development costs are estimated to be $2 million. Manufacturing costs for each phone are estimated to be $463. Google plans to sell each phone for $510.

a. What profit can be anticipated with a demand of 10,000 phones?

b. Use a Data Table to vary demand from 10,000 to 100,000 in increments of 10,000 to assess the sensitivity of profit to demand.

c. Use Goal Seek to determine the access price per phone that the publisher must charge to break even with a demand of 40,000 phones.