Problem #4 HELP

Problem #4 HELP - MicrosoftExcel12.0AnswerReport

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Problem #4 HELP - MicrosoftExcel12.0AnswerReport

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online