Question: please help with question 2a Problem 2. Mean Green Trucking has entered the third party logistics market. The executive team has requested assistance from the

Problem 2. Mean Green Trucking has entered the third party logistics market. The executive team has requested assistance from the LSCM 4560 class to determine the best location for their facility. They recently acquired a new account which has distribution centers at ten locations throughout the United States (see map below for the geographic region served). Your task is to determine the optimal location for a single Mean Green Trucking DC to serve these locations. The CEO wants to obtain the total cost for the optimal location coordinates and total cost for the optimal location. The distribution center will support customers at the following coordinates with corresponding rates and volumes: Your task is to compute the X and Y coordinates and the total cost for the optimal location. The analysis should appear on a worksheet titled "Problem 2". Your analysis must use Solver to calculate coordinates and the total cost for the optimal location. As a result, you will have columns with the distance from each customer and cost. Problem 2a: Management has decided that they would prefer to locate their distribution facility in St Louis, MO ( X=151,Y=79). How does the total cost associated with this location compare [what is the difference in total cost] to the optimal decision obtained in problem \#2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
