Please provide Excel worksheet on how to derive answer and I will rate the answer!

Question 23 4 points Save A The following table provides shipping costs from each of two regional warehouses to each of three destinations. The supplies available and the demands are also given in the table. TO FROM Houston New Orleans Atlanta Supply (units) Dallas $6 $7 $9 300 Hunstville $8 $7 $6 350 Demand 200 250 200 What is the optimal solution to this transportation problem? O a. X1A = 200; X1B = 100; X10 = 0; X2A = 50; X2B = 100; X2C = 250. O b. X1A = 175; X1B = 75; X1C = 0; X2A = 100; X2B = 100; X2C = 275. c. none of the answers presented d. X1A = 0; X1B = 100; X1c = 200; X2A = 150; X2B = 150; X2C =0. O e. X1A = 200; X1B = 100; X1c=0; X2A = 0; X2B = 150; X2C = 200