Transportation Problem Solution of Example 6.1 Variables x11x12 x13x14x21 x22 x23 X24 x31 x32 x33 x34 Operator Value Values 00 0 45 42 78 0 0 38 0 47 10 Heuristic 304900 Objective Coeff 250 420 380280 1280 990 144015201550 142016601730 LP Min 297800 st LHS RHS Constraint 1 1 1 11 45 45 Constraint 2 1 1 1 1 120 120 Constraint 3 1 1 1 1 95 95 Constraint 4 1 1 1 80 80 Constraint 5 1 1 1 78 78 Constraint 6 1 1 1 = 47 47 Constraint 7 1 1 1 55 55 Fig 6-3 Solution of Pear's Transportation Problem Using Excel SolverTransportation Problem Fig 6-3 Solution of Pear’s Transportation Problem Using Excel Solver Solution of Example 6.1 Variables x11 x12 x13 x14 x21 x22 x23 x24 x31 x32 x33 x34 Operator Value Values 0 0 0 45 42 78 0 0 38 0 47 10 Heuristic 304900 Objective Coeff 250 420 380 280 1280 990 1440 1520 1550 1420 1660 1730 LP Min 297800 st LHS RHS Constraint 1 1 1 1 1 = 45 45 Constraint 2 1 1 1 1 = 120 120 Constraint 3 1 1 1 1 = 95 95 Constraint 4 1 1 1 = 80 80 Constraint 5 1 1 1 = 78 78 Constraint 6 1 1 1 = 47 47 Constraint 7 1 1 1 = 55 55