Question: Please provide Excel worksheet on how to derive answer and I will rate the answer! Question 11 4 points Save An The following table provides

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

Question 11 4 points Save An 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 Suppose the Demand in Atlanta has now decreased to 150 units. What is the new optimal solution? O a. X1A = 100; X1B = 50; X10 = 150; X2A = 100; X2B = 200; X2C = 50. O b.X1A = 200; X1B = 50; X10 = 0; X2A = 0; X2B = 200; X2C = 150. c. X1A = 100; X1B = 200; X10 = 0; X2A = 100; X2B = 50; X2C = 150. d. X1A = 200; X1B = 100; X1C = 0; X2A = 0; X2B = 150; X2C = 200. e. none of the answers presented

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!