Tunningley Services is establishing a new business to serve customers in the Ohio, Kentucky, and Indiana region around the Cincinnati Ohio area. The company has identified 15 key market areas and wants to establish regional offices to meet the goal of being able to travel to all key markets within 60 minutes. The data file Tunningley.xlsx provides travel times in minutes between each pair of cities.
a. Develop and solve an optimization model to find the minimum number of locations required to meet their goal.
b. Suppose they change the goal to 90 minutes. What would be the best solution?