solve by using excel

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? 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