LP excel model solution:

Optimal objective funcion value Z:

optimal decision variable values:

Silvio Snacks Inc, produces packaged snack foods. The table below shows the unit costs to ship a case from the plants where they are manufactured to the distributor's warehouses. The company would like to find the least cost plan to supply the warehouses from the two plants. Plants Warehouses Capacity 1 2 $14 $17 30,000 cases $10 $20 25,000 cases Demand 35,000 cases 20,000 cases Below is the complete LP Formulation for this linear programming problem. Create an Excel spreadsheet model and use Solver to find the optimal solution. Let X, -the # of cases shipped from Plant /to Warehouse for all i = {A, B) and/={1,2) (s0 XA1 = the # of cases shipped from Plant A to Warehouse 1, X - the # of cases shipped from Plant A to Warehouse 2, and so on) Minimize Z = $14X A1 + $17X 2 + $10X31 +$20X82 Subject to: 1XA1 + 1X2 530,000 cases Plant A Supply Constraint 1X31 + 1Xge 25,000 cases Plant B Supply Constraint 1XA1 +1X31 235,000 cases Warehouse 1 Demand Constr. 1X A2 + 1X22 220,000 cases Warehouse 2 Demand Constr. For all valid (i.) pairs X 20 cases Non-negativity Constraints