Please solve the following problem using excel. What market (city) would you chose to start a new fake nails saloon? How does your conclusion changes when you consider number of users, vs. number of installations vs $. What else would you need to take into account in order to arrive at an informed conclusion?

SEGMENT SIZE EXERCISE (USE EXCEL) WHERE WOULD YOU START A FAKE NAIL SALOON AND HOW MANY FAKE NAILS INSTALLATIONS DO YOU EXPECT TO DO IN EACH MARKET? FACTS: - THE POPULATION OF ATLANTA IS 471K, OF MILWAUKEE 579K AND OF PHOENIX 731K, - ABOUT 10\% OF THE WOMEN IN ATLANTA USE FAKE NAILS; 8% IN MILWAUKEE AND 4% IN PHOENIX - FREQUENT USERS GET A REDO ABOUT 8.5 TIMES PER YEAR, WHILE INFREQUENT USERS ABOUT 1.5 - ASSUME THAT FFREQUENT USERS ARE ABOUT 33\% IN ATLANTA; 20% IN MILWAUKEE AND 10% IN PHOENIX; - HOW WILL CHANGE YOUR CONCLUSION KNOWING THAT THE AVERAGE PRICE PER FAKE NAIL INSTALLATION IS \$50 IN ATLANTA, \$40 IN MILWAUKEE AND \$75 IN PHOENIX