PLEASE, SOLVE THE PROBLEM USING EXCEL SOLVER!!!

The MidSouth Trucking Company based in Nashville has eight trucks located throughout the East

and Midwest that have delivered their loads and are available for shipments. Through their Inter$-$

net logistics site MidSouth has received shipping requests from $12$ customers. The following table

shows the mileage for a truck to travel to a customer location, pick up the load, and deliver it$.$

Determine the optimal assignment of trucks to customers that will minimize the total mileage.

In Problem $66,$ assume that the customers have the following truck capacity percentage loads:

Determine the optimal assignment of trucks to customers that will minimize total mileage while

also achieving at least an average truck load capacity of $85\%.$ Does this load capacity require$-$

ment significantly increase the total mileage?