The port of Lajitas has three loading docks. The distance between docks 1 and 2 is 100 meters, the distance between docks 1 and 3 is 150 meters, and the distance between docks 2 and 3 is 50 meters. Three tankers currently a tsea are coming into Lajitas. It is necessary to assign a dock for each tanker. Also, only one tanker can anchor in a given dock. Currently, ships 2 and 3 are empty and have no cargo. However, ship 1 has cargo that must be loaded onto the other two ships. 60 tons must be transferred from ship 1 to ship 2, and 80 tons must be transferred from ship 1 to ship 3. Formulate and solve an optimization problem with binary decision variables (where 1 means an assignment and 0 means no assignment) that will assign ships to docks so that the product of tonnage moved times distance is minimized. There are 12 nonzero terms in the objective function.
Hints: be careful with the objective function. Only include the nonzero terms. Each of the 12 nonzero terms in the objective function is a quadratic term, or the product of two variables.
Please list dec variables, constraints, and objective function for excel solver