Home Insert Draw Design Layout References Mailings Review View Help MGMT 430 Week 2 - Discussion 3 2 Input Information 3 Variable 1 Variable 2 (type) Available 40 4 5 6 Constraint 1 Constraint 2 Constraint 3 Used 400 30.0 13.1 30 8 Profit per Unit 9 Output 10 ) Information 11 Variables 12 Total Profit Total Profit= 42.3 18. 5 60.8 B C 1 Microsoft Excel Sensitivity Report D E F G 4 Adjustable Cells Allowable Decrease 6 Cell 7 $B$11 8 $C$11 Name Variables Variable 1 Variables Variable 2 Final Reduced Objective Allowable Value Cost Coefficient increase 85 0.0 46 0.0 34 0.5 2.333333333 10 Constraints Allowable 12 Cell 13 $D SA 14 $D 56 15 $0 $6 110 Final Shadow Constraint Allowable Varie Price RH. Side Ince 40. 0 05 30. 0 1.3 13.1 00 12 1.076923077 Narre Constraint 1 Used Constraint 2 Used Constraint 3 Used 7 4.666666667 1E+30 1 of 304 words LE Home Insert Draw Design Layout References Mailings Review View Help MGMT 430 Week 2 - Discussion 3 2 Input Information 3 Variable 1 Variable 2 (type) Available 40 4 5 6 Constraint 1 Constraint 2 Constraint 3 Used 400 30.0 13.1 30 8 Profit per Unit 9 Output 10 ) Information 11 Variables 12 Total Profit Total Profit= 42.3 18. 5 60.8 B C 1 Microsoft Excel Sensitivity Report D E F G 4 Adjustable Cells Allowable Decrease 6 Cell 7 $B$11 8 $C$11 Name Variables Variable 1 Variables Variable 2 Final Reduced Objective Allowable Value Cost Coefficient increase 85 0.0 46 0.0 34 0.5 2.333333333 10 Constraints Allowable 12 Cell 13 $D SA 14 $D 56 15 $0 $6 110 Final Shadow Constraint Allowable Varie Price RH. Side Ince 40. 0 05 30. 0 1.3 13.1 00 12 1.076923077 Narre Constraint 1 Used Constraint 2 Used Constraint 3 Used 7 4.666666667 1E+30 1 of 304 words LE