M N 0 P Q R T D G H One product Two Plant and Two Warehouses and Three Markets Example c2 c3 ci 4 3 4 5 Facility Warehousepi Ip2 W1 0 W2 51 Objective Function $740,000 2 2 1 2 This column captures the value of the left hand value of each constraint. Each cell has a embedded formula. 4 4 1 5 2 3 5 2 2 X_p1w2 x_p2w1 x_p2w2 X_w1c1 x_w1c2 X_w1c3 X_w2c1 X_w2c2 x_w2c3 0 ol 60000 50000 40000 50000 0 60000 0 1 x_p1w1 Decision Variables 140000 Constraints Capacity Constraint on P2 Flow Balance on W1 1 Flow Balance on W2 Satisfy Demand on C1 Satisfy Demand on C2 Satisfy Demand on C3 1 1 60000 0 60000 0 -1 -1 -1 = 1 -1 0 -1 1 1 1 1 50000 100000 50000 50000 100000 50000 1 1 In the Network design class, we discussed this simple network problem. This problem with two plants P1 and P2, two warehouses W1 and W2, and three markets C1, C2 and C3 network has been set up using Linear Programming Transportation Model in the MS Excel. The cost data has been provided as well. Plant 2 has an annual capacity of 60,000 units and the demand at C1, C2 and C3 is 50,000, 100,000, and 50,000 respectively. a)In the highlighted cell B8, where the result shows $740,000. Please explain the objective function is in the problem. How to set up this cell using the Excel function and cell reference shown in the above picture. Please spell out the excel function in detail. (Use this space to answer the question) b) In the high lighted Cell L15 where the result shows 60000, please explain what this cell means and how to set this cell using the Excel function and cell reference. Please spell out the excel function in detail. (Use this space to answer the question) M N 0 P Q R T D G H One product Two Plant and Two Warehouses and Three Markets Example c2 c3 ci 4 3 4 5 Facility Warehousepi Ip2 W1 0 W2 51 Objective Function $740,000 2 2 1 2 This column captures the value of the left hand value of each constraint. Each cell has a embedded formula. 4 4 1 5 2 3 5 2 2 X_p1w2 x_p2w1 x_p2w2 X_w1c1 x_w1c2 X_w1c3 X_w2c1 X_w2c2 x_w2c3 0 ol 60000 50000 40000 50000 0 60000 0 1 x_p1w1 Decision Variables 140000 Constraints Capacity Constraint on P2 Flow Balance on W1 1 Flow Balance on W2 Satisfy Demand on C1 Satisfy Demand on C2 Satisfy Demand on C3 1 1 60000 0 60000 0 -1 -1 -1 = 1 -1 0 -1 1 1 1 1 50000 100000 50000 50000 100000 50000 1 1 In the Network design class, we discussed this simple network problem. This problem with two plants P1 and P2, two warehouses W1 and W2, and three markets C1, C2 and C3 network has been set up using Linear Programming Transportation Model in the MS Excel. The cost data has been provided as well. Plant 2 has an annual capacity of 60,000 units and the demand at C1, C2 and C3 is 50,000, 100,000, and 50,000 respectively. a)In the highlighted cell B8, where the result shows $740,000. Please explain the objective function is in the problem. How to set up this cell using the Excel function and cell reference shown in the above picture. Please spell out the excel function in detail. (Use this space to answer the question) b) In the high lighted Cell L15 where the result shows 60000, please explain what this cell means and how to set this cell using the Excel function and cell reference. Please spell out the excel function in detail. (Use this space to answer the question)
