Please show steps in Excel using Goal Seek.

Please show formulas used in cells to calculate data.

Thank you!

A bakery sells its pies for $6.00 each. The bakery incurs a daily fixed cost of $500 which includes salaries and rental. The variable cost per pie is $2.50. Set up this problem in Excel as shown below. a) (10 points) Compute the number of pies (X) that must be baked daily in order to break even. Model the problem mathematically in Excel without using Goal Seek. b) (20 points) Use Goal Seek to compute the number of pies (X) that must be baked daily in order to achieve a profit of $700.00. Adjust the model and/or parameters from part a as necessary. Be sure to put your model for part b on a separate tab or in a separate workbook. c) (20 points) Use Goal Seek to compute the number of pies (X) that must be baked daily in order to break even if the variable cost per pie increases to $3.00. Adjust the model and/or parameters from part a as necessary. Be sure to put your model for part c in a separate workbook