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 C:M on the worksheet Question 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 B:B on the worksheet Question 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
