please USE excel and show formula !

Note: Use Excel to solve each of the problems listed below. 1. The owner of XYZ, Inc., hopes to expand the present operation by adding one new outlet. She has studied three locations. Each would have the same labor and materials costs (food, serving containers, napkins, etc.) of $3.50 per sandwich. Sandwiches sell for $6 each in all locations. Rent and equipment costs (all fixed costs) would be $5,000 per month for Location A, $5,500 for location B, and $6,000 for Location C. Required: a. Determine the volume (Q) necessary for each location to realize a monthly profit of $15,000. Rounded to the nearest whole number. b. If expected sales (in units) at A, B, and C are 22,000 per month, 24,000 per month, and 26,000 units per month, respectively, which location would yield the highest profits. Hint: You would need to compute the profit for each location first before you selected the "best" location