jjjjjjjjjjjjjjjjjjjjjjjjj

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

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

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

View Full Document
Status Slack Binding 0 Not Binding 0
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

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}