Joey Transport \& Haulage Co. has four trips to complete. Unfortunately, the company's trucks are scattered at different parts of the state. Each truck must be assigned to complete one trip. The transportation miles required by truck for completing each trip are shown in Table. Joey Transport \& Haulage Co. wants to minimize the total distance (miles) needed to complete the four trips. What are the final assignments and minimum total miles? Use the Hungarian method or Excel Solver to solve this