Case 4 Vision Corp

# Case 4 Vision Corp - Microsoft Excel 8.0a Sensitivity...

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

Microsoft Excel 8.0a Sensitivity Report Worksheet: [CASE1 1997 solution.xls]Sheet1 Report Created: 05/28/2002 8:20:57 AM Adjustable Cells Final Reduced Cell Name Value Gradient \$I\$8 x111 0 -0.81 \$I\$9 x211 117.65 0 \$I\$10 x311 500 0 \$I\$11 x411 0 -1.91 \$I\$12 x112 0 -1.11 \$I\$13 x212 0 -0.5 \$I\$14 x312 200 0 \$I\$15 x412 0 -2.41 \$I\$16 x113 0 -1.11 \$I\$17 x213 0 -0.8 \$I\$18 x313 300 0 \$I\$19 x413 0 -2.11 \$I\$20 x121 200 0 \$I\$21 x221 0 -1.07 \$I\$22 x321 0 -2.07 \$I\$23 x421 0 -0.1 \$I\$24 x122 400 0 \$I\$25 x222 0 -1.27 \$I\$26 x322 0 -1.77 \$I\$27 x422 0 -0.3 \$I\$28 x123 200 0 \$I\$29 x223 0 -1.57 \$I\$30 x323 0 -1.77 \$I\$31 x423 282.6 0 \$I\$32 x131 0 -1.87 \$I\$33 x231 182.35 0 \$I\$34 x331 0 -2.14 \$I\$35 x431 200 0 \$I\$36 x132 0 -1.67 \$I\$37 x232 300 0 \$I\$38 x332 0 -1.64 \$I\$39 x432 62.88 0 \$I\$40 x133 0 -1.97 \$I\$41 x233 0 -0.6 \$I\$42 x333 0 -1.94 \$I\$43 x433 17.4 0 Constraints Final Lagrange Cell Name Value Multiplier \$M\$10 Labor 4352.94 0 \$M\$11 Machine hours 10000 0.01 \$M\$22 Labor 4071.7 0 \$M\$23 Machine hours 8143.4 0 \$M\$34 Labor 2949.48 0

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

View Full Document
\$M\$35 Machine hours 6000 0.09 \$M\$58 Shipping 1382.6 0 \$M\$57 Material 3500 0.57 \$M\$45 Demand TOYco prod 1 200 2.17 \$M\$46 Demand TOYco prod 2 300 0.3 \$M\$47 Demand TOYco prod 3 500 2.24 \$M\$48 Demand TOYco prod 4 200 3.1 \$M\$49 Demand GMtoy prod 1 400 0.87 \$M\$50 Demand GMtoy prod 2 300 0.2 \$M\$51 Demand GMtoy prod 3 200 1.64 \$M\$52 Demand GMtoy prod 4 62.88 0 \$M\$53 Demand FRDtoy prod 1 200 1.37 \$M\$54 Demand FRDtoy prod 2 0 0 \$M\$55 Demand FRDtoy prod 3 300 3.14 \$M\$56 Demand FRDtoy prod 4 300 1.2
Microsoft Excel 8.0a Limits Report

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.

## Case 4 Vision Corp - Microsoft Excel 8.0a Sensitivity...

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

View Full Document
Ask a homework question - tutors are online