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

Question 10 4 points Save Answe Friendly Manufacturing has three factories (1, 2, and 3) and three warehouses (A, B, and C). The table below shows the shipping costs between each factory (in dollars) and warehouse, the factory manufacturing capabilities (in 1000s), and the warehouse capacities (in 1000s). From To Production A B Capability Factory 1 $ 6.00 $ 5.00 $ 3.00 6 Factory 2 $ 8.00 $ 10.00 $ 8.00 8 Factory 3 $ 11.00 $ 14.00 $ 18.00 10 Capacity 7 12 5 What is the optimal solution to this tran ortation problem? a. none of the answers presented are optimal solutions. O b.X1A = 4; X1B = 1; X1c=1; X2A = 0; X2B = 6; X2C = 2; X3A = 3; X3B = 5; X3C = 2. O c. X1A = 0; X1B = 1; X10 = 5; X2A = 0; X2B = 8; X2C = 0; X3A = 7; X3B = 3; X3C = 0. O d. X1A = 1; X1B = 1; X1C = 4; X2A = 0; X2B = 8; X2C = 0; X3A = 6; X3B = 3; X3C = 1. O e.X1A = 1; X1B = 1; X1C = 4; X2A = 1; X2B = 5; X2C = 2; X3A = 6; X3B = 3; X3C = 1