Gorman Construction Company $($GCC$)$ has construction sites located throughout a three$-$county area and the costs associated with transportation activities are substantial and involve transporting personnel, equipment, and supplies from the office to the different construction sites. GCC would like to determine the route that will minimize the total travel distance betweer the office $($located at node $1)$ and the construction site located at node $6.$

Note: Nodes $2,3,4,$ and $5$ are transshipment nodes.

Formulate the problem

Set up and solve the problem in Excel using Solver