Microsoft Excel Solver Integer/Binary Optimization Problem Four cargo ships will be used for shipping goods from one port to each of four other ports. Any ship can be used for making any one of these four trips. However, because of differences in the ships and cargoes, the total cost of loading, transporting, and unloading the goods for the different ship-port combinations varies considerably, as shown in the following table: Port 3 Port 1 Port 2 Port 4 Ship 1 $500 $400 $600 $700 Ship 2 $600 $600 $700 $500 Ship 3 $700 $500 $700 5600 Ship 4 $500 5400 $600 $600 Minimize the total shipping cost. You will be provided a Microsoft Excel workbook with the costs above already entered. Format this workbook nicely after finding the optimal solution. Step 2: A large publishing house dedicated to the publication of popular novels invites aspiring authors to suggest a plot in which Ship I cannot visit Port The Chief Editor is in his office: Chief Editor: Hello, Aspiring Author 1, what is your plot idea? Aspiring Author #1: The route to Port 1 from the home poet requires that the ship pass through a narrow canal. But, the week before sailing date, a foolish captain, despite high crosswinds and poor visibility, tries to sail a big cargo ship through the canal and it gets wedged sideways... Chief Editor: Shut up! I said "hovel." notiotic" No one would ever believe such a thing would ever happen! Your idea has no basis in sensible realism. Go away! Aspiring Author 11 leaves hurriedly Chief Editor: Hello, Aspiring Author 12, what is your plaida? Aspiring Author 12: The nation of registry of Ship lis on the verge of war with the nation where Port 1 is located. Diplomatic relations have broken down, and if Ship I enters that port, it will be torpedoed Chief Editor. Excellent plot! Exciting and plausible! Write your sovel! Solve the problem again with the additional construint that ship I cannot go to port 1. How much worse more expensive) is the optimal wer? Adopted from an exercise in Hillier, Frederick Sand Gerald J. Lieberman 2021. decision Research, 11 edition. New York, New York McGraw-Hill Education ITA