24

\fCH # 8 P 2 Obj fun Max Z =6*1+4*2 Variable Value Profit Sub to: Ass 1 Ass 2 X1 X2 Product 1 Product 2 6 X1 4 X2 10 7 10 3 Logical Model Max Z =6*1+4*2 10*1+10*2=0 CH # 8 P 6 Obj Fun Max Z= 400*X+100*y X Profit Subject to:X Max chair Labour Wood X = Chair Y = Table Y 400 100 Y 6 8 2 10 6 Logical Model Max Z= 400*X+100*y X=0 CH # 8 P 12 Obj Fun Minimize the cost X1 Ingradient 1 80 Variable Cost Requirement 1 2 3 X1 3 1 2 Min Cost = 80*1+50*2 X2 Ingradient 2 50 X2 1 1 6 Ingradient 1=X1 Ingradient 2=X2 Logical Model Min Cost = 80*1+50*2 3 x1 + 1 x2 6 1 x1 + 1 x2 4 2 x1 + 6 x2 12 x1,x2>=0 Microsoft Excel 16.0 Answer Report Worksheet: [prob test 6.xlsx]Ch 10, P 22 Report Created: 8/4/2017 10:06:27 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.016 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name $C$2 Max Z = 0.6x1+0.5x2 Original Value 230 Variable Cells Cell Name Original Value $B$8 Value Sausage Biscuit 300 $C$8 Value Ham Biscuit 100 Constraints Cell Name $D$12 Labour Usages $D$13 Flour Usages $D$14 Sausage Usages $D$15 Ham Usages Final Value 230 Final Value Integer 300 Contin 100 Contin Cell Value Formula 5.4 $D$12=0