Solved: Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one

Question 0 Extra Problem. Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one of three warehouses. Huntco has four customers. The first customer requires 200 tons of sauce, the second customer requires 300 tons, the third customer requires 150 tons and the 4th customer requires 250 tons. Formulate a LP model to minimize the annual cost of meeting customer demands by determining the open warehouses and shipping plan. The capacity (in tons) of each plant is given in the following table. Trs_m.し200-300-200 The cost per ton of producing tomato sauce at each plant and shipping it to each warehouse is given in the table shown here tion Shipping Costs Pr Plant 1 Plant 2 Plant 3 Plant 4 T000 $500 5600 1200 $700 From 5700 500 The cost of shipping a ton of sauce from each warehouse to each customer is gliven in the table below: Shipping Costs to Customers for Huntco Proble Warehouse1 $40 $50 $40 Warehouse 3 380 $50 The annual fxed cost of operating each plant and warehouse is listed in this table. Annual Setup Cost Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 Warehouse 1 Warehouse 2 Warehouse 3

Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one of three warehouses. Huntco has four customers. The first customer requires 200 tons of sauce, the second customer requires 300 tons, the third customer requires 150 tons and the 4th customer requires 250 tons. Formulate a LP model to minimize the annual cost of meeting customer demands by determining the open warehouses and shipping plan. The capacity (in tons) of each plant is given in the following table. The cost per ton of producing tomato sauce at each plant and shipping it to each warehouse is given in the table shown here. The cost of shipping a ton of sauce from each warehouse to each customer is given in the table below: The annual fixed cost of operating each plant and warehouse is listed in this table.

Expert Answer

Note: The cost figures are not visible well. I have updated the model whatever I have read, if there happens to be any change, please change it in the model and run the solver.

———————–

Don't use plagiarized sources. Get Your Custom Essay on
Solved: Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay

Excel model

Solved: Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one 1Solved: Huntco produces tomato sauce at five different plants. The tomato sauce is stored at one 2

Final Result

From/ To WH 1 WH 2 WH 3
Plant 1 0 0 0
Plant 2 0 200 0
Plant 3 0 300 0
Plant 4 0 0 0
Plant 5 0 400 0
From/ To Cust 1 Cust 2 Cust 3 Cust 4
WH 1 0 0 0 0
WH 2 200 300 150 250
WH 3 0 0 0 0
Shipping Cost from Plant to WH 520000
Shipping Cost from WH to Customer 55000
Fixed Costs 145000
Total Cost 720000

Still stressed from student homework?
Get quality assistance from academic writers!