{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# 12 - Microsoft Excel 12.0 Answer Report Worksheet[12]Sheet1...

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

Microsoft Excel 12.0 Answer Report Worksheet: [12.xlsx]Sheet1 Report Created: 11/11/2010 11:15:37 AM Target Cell (Min) Cell Name Original Value Final Value \$E\$4 overtime d+ 0 0 Adjustable Cells Cell Name Original Value Final Value \$D\$4 overtime d- 0 0 \$E\$4 overtime d+ 0 0 \$D\$5 profit d- 135 135 \$E\$5 profit d+ 0 0 \$D\$6 demand d- 499 499 \$E\$6 demand d+ 0 0 \$D\$7 demand d- 399 399 \$E\$7 demand d+ 0 0 \$D\$8 underulitization d- 0 0 \$E\$8 underulitization d+ 0 0 \$B\$12 Newsprint Newsprint 0 0 \$B\$13 Wrapping paper Newsprint 660 660 Constraints Cell Name Cell Value Formula Status Slack \$F\$4 overtime Constraint total 5280 \$F\$4=\$H\$4 Not Binding 0 \$F\$5 profit Constraint total 300 \$F\$5=\$H\$5 Not Binding 0 \$F\$6 demand Constraint total 500 \$F\$6=\$H\$6 Not Binding 0 \$F\$7 demand Constraint total 400 \$F\$7=\$H\$7 Not Binding 0 \$F\$8 underulitization Constraint total 0 \$F\$8=\$H\$8 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: [12.xlsx]Sheet1 Report Created: 11/11/2010 11:15:37 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$D\$4 overtime d- 0 0 0 0 0 \$E\$4 overtime d+ 0 1 1 1.00E+030 1 \$D\$5 profit d- 135 0 0 0 0
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 6

12 - Microsoft Excel 12.0 Answer Report Worksheet[12]Sheet1...

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

View Full Document
Ask a homework question - tutors are online