Huotco produces tomato sauce at five different plants. The capacity (in tons) of each plant is given in Table 40. The tomato sauce is stored at one of three warehouses. The per-ton cost (in hundreds of dollars) of producing tomato sauce at each plant and shipping it to each warehouse is giveen in Table 41. Huntco has four customers. The cost of shipping a ton of sauce from each warehouse to each customer is as given in Table 42. Each customer must be delivered the amount (in tons) of sauce given in Table 43 TABLE 41 TABLE 40 Wadse 2 a Wa We Plant Plant1 12 10 2 3 Plant 2 7 7 Plant 3 6 300 200 300 200 400 Plant 4 Plant TABLE 42 TABLE 43 Costomer 1 Customer 2 Castomer 3 Castomer Castomer 1 2 3 Warehouse1 40 80 90 50 Warehouse 2 70 70 60 80 250 Demand 200 300 150 Warehouse 3 80 30 50 60 (a) Build a linear programming model which will provide a transportation schedule that minimizes the cost of meeting the customers demands. Clearly state the decision variables, objective function and constraints. Solve the linear programing model using Excel. (b) Consider that Table 43 provides the annual demand of each customer. The information about the fixed annual cost of operating each plant and warehouse (in thousands) is given in Table 44. Build a mathematical model which will provide a transportation schedule that minimizes the cost of meeting the customers demands. Clearly state the decision variables, objective function and constraints. Solve the mathematical model using Excel TABLE 44 Fard AC e T ) Facility Plant 35 Plant 2 45 Plant 3 Plant 4 Plant Warehouse Warchouse 2 40 40 30 40 Warehouse 3 30 Huotco produces tomato sauce at five different plants. The capacity (in tons) of each plant is given in Table 40. The tomato sauce is stored at one of three warehouses. The per-ton cost (in hundreds of dollars) of producing tomato sauce at each plant and shipping it to each warehouse is giveen in Table 41. Huntco has four customers. The cost of shipping a ton of sauce from each warehouse to each customer is as given in Table 42. Each customer must be delivered the amount (in tons) of sauce given in Table 43 TABLE 41 TABLE 40 Wadse 2 a Wa We Plant Plant1 12 10 2 3 Plant 2 7 7 Plant 3 6 300 200 300 200 400 Plant 4 Plant TABLE 42 TABLE 43 Costomer 1 Customer 2 Castomer 3 Castomer Castomer 1 2 3 Warehouse1 40 80 90 50 Warehouse 2 70 70 60 80 250 Demand 200 300 150 Warehouse 3 80 30 50 60 (a) Build a linear programming model which will provide a transportation schedule that minimizes the cost of meeting the customers demands. Clearly state the decision variables, objective function and constraints. Solve the linear programing model using Excel. (b) Consider that Table 43 provides the annual demand of each customer. The information about the fixed annual cost of operating each plant and warehouse (in thousands) is given in Table 44. Build a mathematical model which will provide a transportation schedule that minimizes the cost of meeting the customers demands. Clearly state the decision variables, objective function and constraints. Solve the mathematical model using Excel TABLE 44 Fard AC e T ) Facility Plant 35 Plant 2 45 Plant 3 Plant 4 Plant Warehouse Warchouse 2 40 40 30 40 Warehouse 3 30
