Zeplins, a 3,500 sq.ft. restaurant, has been in operation for over ten years now in the west end of Bradford. Over the past five years, their sales have been steadily increasing while the town has expanded in the east end. Samantha Smith, the owner of Zeplins, is considering purchasing a 1,400 sq.ft. unit in the east end to expand her business. She has reached out to you asking if you could help her understand how well this new location would do, as she would only consider opening the restaurant if it would bring in $5,000,000. She has provided you with the Travel Times between the New and Existing locations to each of Bradford's geographic areas, as well as providing some information pertaining to the demographics and spending habits of the population based on some secondary data she had purchased. You also know from talking with the city planner that the residential housing in the towns east end is set to grow by 10% over the next ten years. Question 15 (4 points) Using the provided information, complete this table. (copy and paste the table then fill in) Measurement Store j Sj (1,000's) Areas where residents live ( East End (i-1) West End Travel Times East End Zeplins (j=1,New) West End Zeplins (j=2, Existing) East End Zeplins (j=1,New) 1.4 4 5 3.5 11 4 Attractiveness West End Zeplins (j=2, Existing) Total East End Zeplins (j=1,New) Probability (Pij) West End Zeplins (j=2, Existing) Total Bradford Population (C;) 4,500 6,700 GeoDemographic Avg. Annual Fast Casual Expenditure $1,040.00 $1,400.00 Information (Bik) Total Area Spend on Burgers Eik East End Zeplins (j=1,New) Sales West End Zeplins (j=2, Existing) Market Share Total East End Zeplins (j=1,New) West End Zeplins (j=2, Existing) Total