A B C D E F G H K M N O P Q R S U 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: Problem 1 3 Report Created: 10/2/2018 3:17:52 PM 5 Changing Cells This is the Sensitivity Report for a standard Final Reduced Objective Allowable Allowable product mix problem. The objective is to Cell Name Value Cost Coefficient Increase Decrease determine the profit-maximizing number of each 00 $B$4 Product 1 0 30 110 30 E+30 product to make, per production period, subject 9 $C$4 Product 2 58 150 50 70 to 3 resource constraints. The objective function 10 $D$4 Product 3 0 13 100 13 1E+30 coefficients represent unit profit in dollars. 11 SE$4 Product 4 27 0 200 75 30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $G$8 Labor, Hours 1,000 7.5 1,000 1,250 170 17 $G$9 Machine 1, Hours 200 10.0 200 175 150 18 $G$10 Machine 2, Hours 300 15.0 300 20 10 19 $G$11 Sheet Metal, Feet 3,500 0.0 5000 1E+30 1,500 20 21 22 23 24 25 26 IN 28 29 33 34 Instructions Questions 1-6 Question 7 Question 8 Question 9 +