demonstration problems in excel

demonstration problems in excel - Wyndor Glass Page 1...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Wyndor Glass Page 1 Wyndor Glass Decision Decision Variables Unit price 100 200 Total Sales Sales Plant Resource rate Used Resources Available Res. Plant 1 1 100 Plant 2 2 200 Plant 3 1 1 150 Green: Decision Variables Yelow: Data Red: Function Values Wyndor Glass Page 2 Slacks 100 200 150 Toy Example Decision Variables Unit price 1 2 Total Sales Sales Plant Resource rate Used ResoAvailable RSlacks Plant 1 1 1 1 Plant 2 1 1 1 Plant 3 1 1 1.5 1.5 Green: Decision Variables Yelow: Data Red: Function Values AirFlight a-time b-time t-time m-time 1 9.91 16.74 2 13.6 15.56 3 14.77 20.4 4 17.91 19.16 5 19.32 23.44 6 21.78 26.9 7 24.58 26.78 8 26.03 35.68 9 31.35 33.88 10 33.38 40.75 delta Base-Station x1 x2 Cell-Phone Localization 1 2 1 3 1 4 1 1 1 2 3 4 Reference Points 0.04 0.64 2.44 0.75 7.58 0.95 0.94 0.52 0.87 3.61 0.90 4.31 0.24 0.35 5.49 1.44 2.07 1.01 0.93 0.91 0.59 1.21 1.14 74.89 0.85 0.39 1.13 5.73 0.91 2.55 0.51 0.46 2.11 2.19 1.83 1.89 0.27 0.55 2.71 1.20 3.61 1.34 0.43 0.46 2.52 1.88 2.08 1.62 0.47 0.18 3.98 3.19 1.12 1.04 0.09 0.83 1.44 0.66 27.02 1.16 0.57 0.83 1.00 1.15 2.83 4.60 0.03 0.53 3.55 0.82 4.51 0.86 0.11 0.02 73.99 1.27 1.03 0.57 0.25 0.83 1.33 0.80 10.71 1.70 0.85 0.81 0.72 1.46 1.33 17.37 0.73 0.06 1.87 12.98 0.71 1.04 0.89 0.24 1.17 14.38 0.73 1.70 0.00 0.00 0.00 0.00 Test Point 0.35 0.46 2.99 1.58 2.41 1.40-2.99-1.58-2.41-1.40 0.00 0.03 0.00 0.16 2.99 1.61 2.41 1.56-2.99-1.55-2.41-1.24 0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 0.00 0.10 0.20 0.30 0.40 0.50 0.60 0.70 0.80 0.90 1.00 Column D y 0.19 Green: decision variabls Red: function values Yelow: data u1 u2 v1 v2 e 0.33 0.28-0.82-0.36 1 0.41 0.14-0.80 0.03 1 0.60 0.51-0.01-0.69 1 0.58 0.36-0.52-0.34 1 0.35-0.19-0.78-0.40 1 0.98 0.01-0.19 0.14 1 0.41 0.72-0.82-0.14 1 0.60 0.50-0.82-0.36 1 0.78-0.14-0.28-0....
View Full Document

This note was uploaded on 06/16/2010 for the course MS&E 211 taught by Professor Yinyuye during the Fall '07 term at Stanford.

Page1 / 32

demonstration problems in excel - Wyndor Glass Page 1...

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

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