Kanchua Nut Company example

Kanchua Nut Company example - hazel 499.9925 0...

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

View Full Document Right Arrow Icon
Microsoft Excel 11.0 Answer Report Worksheet: [Kanchua Nut Company.2005example.xls]Sheet1 Report Created: 9/27/2005 12:08:47 PM Target Cell (Max) Cell Name Original Value Final Value $B$16 Max Profit 0 101.9235673052 Adjustable Cells Cell Name Original Value Final Value $C$15 Dec. Var. peanuts 0 1499.99250004 $D$15 Dec. Var. cashews 0 0 $E$15 Dec. Var. hazel 0 499.9925000375 $F$15 Dec. Var. brasil 0 1000 Constraints Cell Name Cell Value Formula Status Slack $C$19 avail. hazel LHS 499.9925000375 $C$19<=$E$19 Not Binding 500.0075 $C$20 avail. brasil LHS 1000 $C$20<=$E$20 Binding 0 $C$21 mix comp.1 LHS 0 $C$21<=$E$21 Binding 0 $C$22 mix comp.2 LHS 0 $C$22<=$E$22 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 11.0 Sensitivity Report Worksheet: [Kanchua Nut Company.2005example.xls]Sheet1 Report Created: 9/27/2005 12:08:47 PM Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$15 Dec. Var. peanuts 1499.9925 0 0.2423076923 0.0653846154 0.0679493846 $D$15 Dec. Var. cashews 0 -0.15 0.0923076923 0.15 1.0000E+030 $E$15 Dec. Var.
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: hazel 499.9925 0 -0.3076923077 0.0653846154 0.2038501923 $F$15 Dec. Var. brasil 1000 0 -0.1076923077 1.0000E+030 0.1019235673 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $C$19 avail. hazel LHS 499.9925 1000 1.0000E+030 500.0075 $C$20 avail. brasil LHS 1000 0.1019235673 1000 1000.0300003 1000 $C$21 mix comp.1 LHS 0 0.4846153846 0 1.0000E+030 749.99625 $C$22 mix comp.2 LHS 0 0.0980764327 333.33 333.34 Kanchua Nut Company DATA peanuts cashews hazel brasil RHS avail. hazel 1 &lt;= 1000 avail. brasil 1 &lt;= 1000 mix comp.1 0.5 0.5-0.5-0.5 &lt;= mix comp.2-0.66667 0.33333 &lt;= price/pound 0.25 0.4 0.8 0.6 price/can 0.5 cost/can 0.1 MODEL peanuts cashews hazel brasil Dec. Var. 1499.9925 499.9925 1000 Max Profit 101.92357 Constraints LHS RHS avail. hazel 499.9925 &lt;= 1000 avail. brasil 1000 &lt;= 1000 mix comp.1 0 &lt;= mix comp.2 0 &lt;=...
View Full Document

Page1 / 3

Kanchua Nut Company example - hazel 499.9925 0...

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