Question 2 (a) Three cargo ships shown will be used for shipping goods from Dubai port to three other ports of Oman (Sohar, Khasab, Duqm). Any ship can be used for making any one of these trips. Because of the differences in the ships and cargos, the total cost (in RO) of loading, transporting, and unloading the goods for the different ship- port combinations varies as shown in the following Table 2. Table 2 Port Ship Sohar Khasab Duqm 1 4000 6000 7000 2 6000 7000 5000 3 5000 7000 6000 The objective of the above problem is to assign the ships to different ports in such a way as to minimize the total cost for all shipments. Develop a Spreadsheet Model of the above problem and produce optimal solution using Solver tool. Save the Excel model and Solver solution, and upload your file on the link provided on the Moodle page of the course. {9}