12. , , ( Excel)?
1)
, , " ". : . , . . , , , . , W. . , . .
, , , :
- Vj ;
- Vj ;
- ;
- .
2)
, . : , . , .
a = 1 (), a = 0 - . , a. , . a = 0.5 .
, , :
- ;
- ;
- ;
- .
3)
. () :
, .. , i- j- . , .
, :
|
|
W , , , , .
: max Wij . . . , .
10 000 . . , 20 000 . . . , 500 . , . 80%, , 400 . - 50% . , (500 .), 300 ., , . , , ?
.
1 - , ,
2 - ,
3 - ,
4 - .
1 - ,
2 - .
1 | 2 | |||
1 | - 10 000 | -20 000 | -14000 | |
2 | - 10 500 | - 15 500 | -12500 | |
3 | - 10 900 | - 12 900 | -11700 | |
4 | - 25 800 | - 15 500 | -19620 | |
.
3, .
4)
:
| | max Wij |
1 | 2 | Max | ||
1 | ||||
2 | ||||
3 | ||||
4 | ||||
Max.
W=min{Max}=900
3, .
|
|
3, . - 12900 ..
.
, , : Xi ( Wij) .
W = max(-121, -168.75, -216.5, -264.25) = -121, .. 20 121 ..
.
. ()
, .. , i- j- . D , .
D, (-121) , 62 . .
max[-405.75, -270.5, -135.25, -143.25]=-135.25 , 40 , , 135.25 ..
.
. , . .
a 0 1 . a:
W= |
a=0.1 | a=0.2 | a=0.5 | a=0.8 | a=0.9 | ||
X1=20 | -84.4 | -47.0 | 206.4 | |||
X2=30 | -113.85 | -58.95 | 105.75 | 270.45 | 325.35 | |
X3=40 | -140.3 | -70.1 | 149.5 | 369.1 | 442.3 | |
X4=50 | -172.75 | -81.25 | 193.25 | 467.75 | 559.25 |
a =0.5 ( ) 50 193.25 . .
0.2 20 , 47 ..
32. .
- , . , : - , , ( ), , .
. , - , , - , . . .
() . . . , . , , . , . , - " ". .
|
|
, . : , . , . . ( ) . , , .
: , , , . , , , .