Joey Transport & Haulage Co. has four trips to complete. Unfortunately, the companys 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 problem. Travelling Miles Trip 1 Trip 2 Trip 3 Trip 4 Trip 1 Trip 2 Trip 3 Trip 4 Truck 1 11 5 9 16 Truck 1 Truck 2 3 10 6 5 Truck 2 Truck 3 12 3 8 9 Truck 3 Truck 4 4 4 10 13 Truck 4 Total Travelling Miles

Please answer with the screenshots of excel solver too by using hungarian method

please use hungarian method

Total Travelling Miles