Please use Excel, show your workings if using solver

18. Mary Beth Olsen, owner of a pizza shop, is planning to expand her operation by adding one additional pizza shop. She has narrowed her choices to three locations. Labor and materials costs per pizza for all three locations are $3.70. The selling price per pizza is $5.80 each for all three locations. The fixed costs in the form of rent and equipment are $6,000 per month for Location A, $6,550 per month for Location B, and \$7,200 per month for Location C (all in U.S. dollars): a. What should be the sales volume at each location to realize a monthly profit of $8,500 ? b. If forecasted pizza sales per month at Locations A,B, and C are $19,500,$21,200, and $24,200, respectively, determine the profit for each of the three locations. c. At what range of sales volume would each location be profitable