Question: Evolution Sails, a new sail maker in the industry, is trying to figure out where to place their regional Sail Lofts ( Customer Service, small

Evolution Sails, a new sail maker in the industry, is trying to figure out where to place their regional Sail Lofts (Customer Service, small repair, and Distribution Centers). The company has narrowed down their options to the different options that can be found in cells C2:M2 on the worksheet Question 4 Model. They would like to place their Sail Lofts in locations that allow the company to minimize the distance between the Sail Lofts and their customers, which can be found in cells B3:B50 on the worksheet Question 4 Model.Each Evolution Sail Loft has the capacity to serve up to eight customers. Identify where to place the Sail Lofts, which customers each Sail Loft services, and the total distance between the Sail Lofts and their customers. Please note that Evolution Sails wants to serve all customers in order to continue to build their reputation in the industry. They also want to provide speedy service and thus want to operate at least seven lofts. In order to limit fixed cost risks they don't want to open more than nine lofts.All of the distance data are provided on the worksheet Question 4 Model. Please note that due to the large number of decision variables you must use OpenSolver to solve this problem.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!