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: Minimize the total shipping cost. You will be provided a Microsoft Excel (B) 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 1. 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 port 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 "novel," not "idiotic"! No one would ever believe such a thing would ever happen! Your idea has no basis in sensible realism. Go away! Aspiring Author #1 leaves hurriedly. Chief Editor: Hello, Aspiring Author #2, what is your plot idea? Aspiring Author #2: The nation of registry of Ship 1 is on the verge of war with the nation where Port 1 is located. Diplomatic relations have broken down, and if Ship 1 enters that port, it will be torpedoed. Chief Editor: Excellent plot! Exciting and plausible! Write your novel! Solve the problem again with the additional constraint that ship 1 cannot go to port 1 . How much worse (more expensive) is the optimal