Objective Cell (Max) Variable Cells A. Cell SH$1 4 SIS14 $J$14 $K$14 Cell Name $L$15 Objective...

 

 

Transcribed Image Text:

Objective Cell (Max) Variable Cells A. Cell SH$1 4 SIS14 $J$14 $K$14 Cell Name $L$15 Objective Function Coefficients Constraints Cell a) b) c) use the answer and sensitivity reports below and interpret: The Objective Function Coefficient and final value The Decision Variables and final values The constraint values, status, and slack. Name Decision Variables Corn Decision Variables Sorghum Decision Variables Wheat. Decision Variables Hired Labor Name $L$18 Land Total $L$19 Hired Labor Total $L$20 Family Labor Total Original Value Original Value 0 0 0 0 0 Cell Value Final Value 80245.09804 900 500 Final Value Integer 0 Contin 549.0196078 Contin 0 Contin 900 Contin Formula Not 549.019608 $L$18<=SN$18 Binding $L$19<=$N$19 Binding $L$20<-SN$20 Binding Status Slack 450.980392 2 0 0 B. Please use the Sensitivity Report below and interpret: a) Reduced Cost b) Objective Coefficient c) Allowable Increase and Allowable Decrease d) Shadow Price e) Constraint R.H. Side Cell Name SH$14 Decision Variables c $I$14 Decision Variables s $J$14 Decision Variables w $K$14 Decision Variables hl Name Cell $L$18 Land Total $L$19 Hired Labor Total $L$20 Family Labor Total Final Value 0 549.0196078 0 900 Final Value 549.0196078 900 500 Reduced Cost -31.89117647 0 -10.20588235 Shadow Price 0 0 51.96078431 66.96078431 Objective Allowable Coefficient Increase 171 31.89117647 170.75 150.5 10.20588235 -15 1E+30 Constraint R.H. Side 1E+30 1000 900 500 DELL Allowable Increase Allowable Decrease 1E+30 10.84375 1E+30 51.96078431 Allowable Decrease 1E+30 450.9803922 1150 1150 900 1400 Objective Cell (Max) Variable Cells A. Cell SH$1 4 SIS14 $J$14 $K$14 Cell Name $L$15 Objective Function Coefficients Constraints Cell a) b) c) use the answer and sensitivity reports below and interpret: The Objective Function Coefficient and final value The Decision Variables and final values The constraint values, status, and slack. Name Decision Variables Corn Decision Variables Sorghum Decision Variables Wheat. Decision Variables Hired Labor Name $L$18 Land Total $L$19 Hired Labor Total $L$20 Family Labor Total Original Value Original Value 0 0 0 0 0 Cell Value Final Value 80245.09804 900 500 Final Value Integer 0 Contin 549.0196078 Contin 0 Contin 900 Contin Formula Not 549.019608 $L$18<=SN$18 Binding $L$19<=$N$19 Binding $L$20<-SN$20 Binding Status Slack 450.980392 2 0 0 B. Please use the Sensitivity Report below and interpret: a) Reduced Cost b) Objective Coefficient c) Allowable Increase and Allowable Decrease d) Shadow Price e) Constraint R.H. Side Cell Name SH$14 Decision Variables c $I$14 Decision Variables s $J$14 Decision Variables w $K$14 Decision Variables hl Name Cell $L$18 Land Total $L$19 Hired Labor Total $L$20 Family Labor Total Final Value 0 549.0196078 0 900 Final Value 549.0196078 900 500 Reduced Cost -31.89117647 0 -10.20588235 Shadow Price 0 0 51.96078431 66.96078431 Objective Allowable Coefficient Increase 171 31.89117647 170.75 150.5 10.20588235 -15 1E+30 Constraint R.H. Side 1E+30 1000 900 500 DELL Allowable Increase Allowable Decrease 1E+30 10.84375 1E+30 51.96078431 Allowable Decrease 1E+30 450.9803922 1150 1150 900 1400

Answer rating: 100% (QA)

solution a The objective function coefficients are ... View the full answer