Case 4 Vision Corp

Case 4 Vision Corp - 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: [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
Background image of page 1

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

View Full DocumentRight Arrow Icon
$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
Background image of page 2
Microsoft Excel 8.0a Limits 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.

Page1 / 9

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 Right Arrow Icon
Ask a homework question - tutors are online