One-Potato, two-potato

One-Potato, two-potato - Microsoft Excel 8.0a Sensitivity...

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

View Full Document Right Arrow Icon
Microsoft Excel 8.0a Sensitivity Report Worksheet: [Book1]Sheet1 Report Created: 9/6/99 5:14:17 AM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $D$1Tons purchased P1 4.5 0 5 7 1 $E$15Tons purchased P2 3 0 6 1.5 3.5 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$2French fries Amount used 1.8 17.5 1.8 0.2 0.6 $C$2Hash Browns Amount use 1.2 7.5 1.2 0.2 0.6 $C$2Flakes Amount used (LHS 2.25 0 2.4 1.000E+030 0.15
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 9.0 Answer Report Worksheet: [One-Potato, two-potato.xls]Sheet1 Target Cell (Max) Cell Name Original Value Final Value $D$14 Maximize total profit P1 40.5 40.5 Adjustable Cells Cell Name Original Value Final Value $D$12 Tons purchased P1 4.5 4.5 $E$12 Tons purchased P2 3 3 Constraints Cell Name Cell Value Formula Status Slack $C$17 French fries Amount used (LHS) 1.8 $C$17<=$F$17 Binding 0 $C$18 Hash Browns Amount used (LHS) 1.2 $C$18<=$F$18 Binding 0 $C$19 Flakes Amount used (LHS) 2.25 $C$19<=$F$19 Not Binding 0.15
Background image of page 2
Microsoft Excel 9.0 Sensitivity Report
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/18/2011 for the course BUS 220 taught by Professor Drexel during the Fall '08 term at SUNY Stony Brook.

Page1 / 6

One-Potato, two-potato - Microsoft Excel 8.0a Sensitivity...

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

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