question 2 is priority also can you explain how it is done in excel

Al- 2 e, N - tatial laali anan) Figar NI Mr hthaalan - C | Table 1 Mies Data T 100 enga I, A 1 T 1 The Mama AN 213 ataramathitalams are w Audi med 15000 TMS ing Generelt pa seca These New Mededelity Ta Tweets MIN Table of with SA 35 15 Table 3 Minimum Travel Time between Potential and Existing Sites and Zones in Minutes A B Z 20 6 5 5 7 + 1 2 3 4 5 6 7 8 9 10 7 5 5 9 1 3 4 5 7 10 15 18 & 7 8 10 7 3 3 2 1 2 2 4 14 10 10 14 13 7 7 6 4 4 2 Y 10 8 10 12 9 5 4 3 2 4 2 2 1 4 3 9 9 12 Table 4 Relationship of Size of Store with Net Profit as a Percent of Sales Sales Area, Sq. Ft Net Profit (%) 10000 3.5 15000 3.0 20000 2.7 QUESTIONS 1. Explain the Huff model used in store location selection in retailing? What are the calculation steps of the Huff model? 2. Utilizing a spreadsheet version (MS-Excel) of the Huff location model (with 2=1.0). recommend a store size and location for AFL Assuming that AFI does not wish to consider a store that is smaller than 10,000 square feet, assess the store sizes (based on 5,000-square-foot increments) up to the maximum allowable sales area for each potential site. 3. What is the expected annual net profit and expected market share for the outlet you have recommended? Defend your recommendation 4. Try two other values of 1 (cg.0.5 and 4.0) to measure the sensitivity of customer travel propensity on your recommended location using MS-Excel. 5. What are the shortcomings of the Huff medel? 6. Which methods other than Huff model can be used in retail store location selection? For Huff model, see reference "Fitzsimmons, J. Fimmons, M. J. Service Management: Operations, Strategy. Information Technology. New York: McGraw-Hill." 3