Question: Microsoft Excel 14.0 Sensitivity Report Variable Cells Cell Name $B$8 Output Single $C$8 Output Double $D$8 Output Triple Final Reduced Objective Allowable Allowable Value Cost
Microsoft Excel 14.0 Sensitivity Report Variable Cells Cell Name $B$8 Output Single $C$8 Output Double $D$8 Output Triple Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 35,82970353 0 1000 399,7992774 128,7072243 98,5316847 0 1900 1E+30 46,80262703 44,787129410 2700 736,1155036 8,707955496 0 9,512435015 3400 9,512435015 1E+30 244,48503580 0 47.40740741 282,0833333 $E$8 Output Quadruple $F$8 Output Demolished Constraints Shadow Price Final Value -7,10543E- 14 Constraint Allowable R.H. Side Increase Allowable Decrease Cell Name 215,821273 0 53,7037037 12,19444444 $G$9 Acre-Constraint Total Budget-Constraint $G$10 Total $G$11 Total $G$12 Total 15000 22,93101026 15000 244,4850358 0 300 1,06581E-14 419,7976676 0 3406,034483 15000 1E+30 55,51496417 34,12284223 90,84072198 1E+30 80,61683294 $G$13 Total $G$14 Total 80,61683294 0 0 -6,39488E- 14 601,7591682 0 54.78686834 60,68089517 + Objective Cell (Max) Cell Name $G$5 Z Original Value 343700 Final Value 343965,1539 Variable Cells Cell Name $B$8 Output Single $C$8 Output Double $D$8 Output Triple $E$8 Output Quadruple $F$8 Output Demolished Original Value 36 98 45 0 245 Final Value 35,82970353 98,5316847 44,78712941 0 244,4850358 Integer Contin Contin Contin Contin Contin Microsoft Excel 14.0 Sensitivity Report Variable Cells Cell Name $B$8 Output Single $C$8 Output Double $D$8 Output Triple Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 35,82970353 0 1000 399,7992774 128,7072243 98,5316847 0 1900 1E+30 46,80262703 44,787129410 2700 736,1155036 8,707955496 0 9,512435015 3400 9,512435015 1E+30 244,48503580 0 47.40740741 282,0833333 $E$8 Output Quadruple $F$8 Output Demolished Constraints Shadow Price Final Value -7,10543E- 14 Constraint Allowable R.H. Side Increase Allowable Decrease Cell Name 215,821273 0 53,7037037 12,19444444 $G$9 Acre-Constraint Total Budget-Constraint $G$10 Total $G$11 Total $G$12 Total 15000 22,93101026 15000 244,4850358 0 300 1,06581E-14 419,7976676 0 3406,034483 15000 1E+30 55,51496417 34,12284223 90,84072198 1E+30 80,61683294 $G$13 Total $G$14 Total 80,61683294 0 0 -6,39488E- 14 601,7591682 0 54.78686834 60,68089517 + Objective Cell (Max) Cell Name $G$5 Z Original Value 343700 Final Value 343965,1539 Variable Cells Cell Name $B$8 Output Single $C$8 Output Double $D$8 Output Triple $E$8 Output Quadruple $F$8 Output Demolished Original Value 36 98 45 0 245 Final Value 35,82970353 98,5316847 44,78712941 0 244,4850358 Integer Contin Contin Contin Contin Contin
Study Help