Problem #4 HELP

# Problem #4 HELP - MicrosoftExcel12.0AnswerReport...

This preview shows pages 1–3. Sign up to view the full content.

Microsoft Excel 12.0 Answer Report Worksheet: [Problem #4 HELP.xlsx]Sheet1 Report Created: 11/10/2010 10:26:35 PM Target Cell (Min) Cell Name Original Value Final Value \$E\$4 worker days d- 0 0 Adjustable Cells Cell Name Original Value Final Value \$B\$14 Corn Corn 0 0 \$B\$15 Wheat Corn 666.67 491.67 \$B\$16 Soybeans Corn 0 300 \$E\$4 worker days d- 0 0 \$F\$4 worker days d+ 666.67 1316.67 \$E\$5 prep costs d- 0 0 \$F\$5 prep costs d+ 0 0 \$E\$6 profit d- 78333.33 79333.33 \$F\$6 profit d+ 0 0 \$E\$7 excess labor d- 0 0 \$F\$7 excess labor d+ 666.67 1316.67 \$E\$8 acreage d- 333.33 208.33 \$F\$8 acreage d+ 0 0 \$E\$9 sales agreement d- 200 200 \$F\$9 sales agreement d+ 0 0 \$E\$10 sales agreement d- 0 8.33 \$F\$10 sales agreement d+ 166.67 0 \$E\$11 sales agreement d- 300 0 \$F\$11 sales agreement d+ 0 0 Constraints Cell Name Cell Value Formula Status Slack \$G\$4 worker days Constraint total 6000 \$G\$4=\$I\$4 Not Binding 0 \$G\$5 prep costs Constraint total 80000 \$G\$5=\$I\$5 Not Binding 0 \$G\$6 profit Constraint total 105000 \$G\$6=\$I\$6 Not Binding 0 \$G\$7 excess labor Constraint total 0 \$G\$7=\$I\$7 Not Binding 0 \$G\$8 acreage Constraint total 1000 \$G\$8=\$I\$8 Not Binding 0 \$G\$9 sales agreement Constraint total 200 \$G\$9=\$I\$9 Not Binding 0 \$G\$10 sales agreement Constraint total 500 \$G\$10=\$I\$10 Not Binding 0 \$G\$11 sales agreement Constraint total 300 \$G\$11=\$I\$11 Not Binding 0

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Microsoft Excel 12.0 Sensitivity Report Worksheet: [Problem #4 HELP.xlsx]Sheet1 Report Created: 11/10/2010 10:26:35 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$14 Corn Corn 0 0 0 1.00E+030 0 \$B\$15 Wheat Corn 491.67 0 0 0 0 \$B\$16 Soybeans Corn 300 0 0 0 0 \$E\$4 worker days d- 0 1 1 1.00E+030 1 \$F\$4 worker days d+ 1316.67 0 0 0 0 \$E\$5 prep costs d- 0 0 0 1.00E+030
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}