number 19 - Microsoft Excel 12.0 Answer Report Worksheet:...

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

View Full Document Right Arrow Icon
Microsoft Excel 12.0 Answer Report Worksheet: [number 19.xlsx]Sheet1 Report Created: 11/29/2010 11:02:29 PM Target Cell (Min) Cell Name Original Value Final Value $B$18 Total variance = Allied Electronics 0.0354 0.0354 Adjustable Cells Cell Name Original Value Final Value $E$6 X1 = Proportion 0.128 0.128 $E$7 X2 = Proportion 0.628 0.628 $E$8 X3 = Proportion 0.245 0.245 Constraints Cell Name Cell Value Formula $B$17 Total portfolio return = Allied Electronics 0.11 $B$17>=$B$9 $B$19 Total proportion invested = Allied Electronics 1.00 $B$19=$E$9
Background image of page 1

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

View Full DocumentRight Arrow Icon
Status Slack Binding 0 Not Binding 0
Background image of page 2
Microsoft Excel 12.0 Sensitivity Report Worksheet: [number 19.xlsx]Sheet1 Report Created: 11/29/2010 11:02:29 PM Adjustable Cells Final Reduced Cell Name Value Gradient $E$6 X1 = Proportion 0.128 0.000 $E$7 X2 = Proportion 0.628 0.000 $E$8 X3 = Proportion 0.245 0.000 Constraints Final Lagrange Cell Name Value Multiplier $B$17 Total portfolio return = Allied Electronics 0.11 0.57
Background image of page 3

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

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

This note was uploaded on 09/01/2011 for the course BIT 2406 at Virginia Tech.

Page1 / 5

number 19 - Microsoft Excel 12.0 Answer Report Worksheet:...

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

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