1. What is the optimal objective function value (i.e. what is the minimum cost to ship the products from the manufacturing facilities to the demand location)?

Consider a company with manufacturing facilities in cities A, B, and C and warehouses in cities D, E, and F. Products produced at the manufacturing facilities are shipped to the warehouses for distribution. The supplies at the manufacturing facilities and the demand at the warehouses are as shown in the table below, along with the unit item shipping costs to the demand points. Solve the problem using Excel solver to answer questions 1 through 5 Below: To Supply Shipments: From D E F A 11 100 B $ $ $ 10 $ 12 $ 14 $ 13 $ 8 $ 12 $ 10 300 C 13 250 Demand 130 250 270 Question 2 3 pts If Xij represents the quantity of products shipped from manufacturing facility i to demand point j. What is the value of XBE? Question 3 3 pts If Xij represents the quantity of products shipped from manufacturing facility i to demand point j. What is the value of XCD? Question 4 2 pts What is the total cost of shipping from facility C to demand point F? Question 5 2 pts If Xij represents the quantity of products shipped from manufacturing facility i to demand point j. What is the value of XBF in the optimal solution? Question 6 2 pts If Xij represents the quantity of products shipped from manufacturing facility i to demand point j. What is the value of XBE - Xaf in the optimal solution