A computer manufacturing company wants to develop a monthly plan for shipping finished products from throe of its manufacturing facilities to three regional warehouses Data on transportation costs (n dollars per unit), capacities, and requirements are given below (CLO4) Plant A 6.55 B 4.25 C 8.14 Requirement 8000 1 Warehouse 2 582 662 b) How many constraints are there in this problem? 526 2000 a) How many variables are involved in the LP formulation? 3 Capacities 172 3.74 4.19 3000 4000 6000 3000 variables d constraints 12:55 PM c) Suppose that we use the variable Xij as the quantity shipped from plant i to warehouse j, what is the constraint corresponding to Plant B? X21+ X22. X13+ d) Suppose that we use the variable Xij as the quantity shipped from plant i to warehouse j, what is the constraint corresponding to Warehouse 37 X23 X23+ X33 e) Use ExcelQM to solve the problem. What is the optimal total cost of shipping products from manufacturing facilities to warehouses ? 1) Use ExcelQM to solve the problem What is the optimal quantity to be shipped from plant B to the first warehouse