Exercise 2 SGB company has three plants in Jeddah, Riyadh and Dammam. SGB has four major distribution centers in Quassim, Dhahran, Tabuk and Mekkah. The table hereinafter presents the costs of each transportation way. SGB company, need to know the optimal solution according to the provided data. Supply Wareh ouse Quassim 147 $ 241 $ 451 $ 400 T Mekkah 552 $ 312 $ Jeddah Riyadh Dammam Demand Destinations Dhahran Tabuk 121$ 344 $ 153 $ 102 $ 364 $ 557 $ 450 T 550 T 450 T 450 T 750 T 250 T Required: 1. Check if the transportation problem is balanced or no 2. Formulate the problem according to the data provided above. 3. Represent the network representation of the current problem 4 The SGB company seeks to minimize the total shipping costs of transporting goods from the three warehouses to the four destinations: a. Determine the optimum solution using excel solver b. Now, manually: 1. Apply the Northwest-corner method to find the BFS ii. Apply the Least-cost method to find the BFS iii. Apply the Vogel approximation method to find the BFS iv. Compare the three BFS V. Apply the Simplex method to find the optimum solution Exercise 2 SGB company has three plants in Jeddah, Riyadh and Dammam. SGB has four major distribution centers in Quassim, Dhahran, Tabuk and Mekkah. The table hereinafter presents the costs of each transportation way. SGB company, need to know the optimal solution according to the provided data. Supply Wareh ouse Quassim 147 $ 241 $ 451 $ 400 T Mekkah 552 $ 312 $ Jeddah Riyadh Dammam Demand Destinations Dhahran Tabuk 121$ 344 $ 153 $ 102 $ 364 $ 557 $ 450 T 550 T 450 T 450 T 750 T 250 T Required: 1. Check if the transportation problem is balanced or no 2. Formulate the problem according to the data provided above. 3. Represent the network representation of the current problem 4 The SGB company seeks to minimize the total shipping costs of transporting goods from the three warehouses to the four destinations: a. Determine the optimum solution using excel solver b. Now, manually: 1. Apply the Northwest-corner method to find the BFS ii. Apply the Least-cost method to find the BFS iii. Apply the Vogel approximation method to find the BFS iv. Compare the three BFS V. Apply the Simplex method to find the optimum solution