, : , , . , .. , .
:
;
;
, , , ;
.
, :
N ;
;
.
:
,
, ;
, ( );
.
:
:
:
1) :
,
.
2) ( ):
3) :
,
a b t.
, N
.
, . , . EXCEL Solver ( ). .
, ,
.
. 1 , () .
. 4.9.1 ( ) ( ) . . 4.9.2. . 4.9.3 .
|
|
. 4.9.1.
: | |||||||||||||||
1 | -1,25% | 0,00% | 4,43% | -12,12% | 32,41% | -5,21% | -17,58% | 14,00% | |||||||
2 | -15,56% | 0,00% | 72,11% | 10,86% | 22,76% | 1,12% | 6,67% | -8,33% | |||||||
3 | 11,24% | 0,00% | 19,79% | 17,39% | -4,07% | 4,25% | -25,93% | -9,00% | |||||||
4 | 0,00% | 0,00% | 2,30% | 1,12% | 0,00% | 0,00% | 16,56% | 0,00% | |||||||
5 | -0,85% | 14,89% | 33,59% | -27,09% | 0,12% | 23,29% | -4,41% | 2,62% | |||||||
6 | 47,37% | -11,90% | -9,46% | 4,48% | 22,00% | -4,92% | -3,33% | -8,66% | |||||||
: | |||||||||||||||
1 | 0,00% | -3,46% | -10,00% | 30,00% | 1,23% | -8,97% | -1,45% | ||||||||
2 | 1,14% | 3,45% | 5,20% | -7,65% | -13,21% | 2,76% | 8,52% | ||||||||
3 | 23,08% | 10,60% | 0,98% | 0,00% | 12,34% | 0,00% | -34,00% | ||||||||
4 | 0,00% | 5,76% | 1,54% | -0,70% | 0,00% | -1,46% | -12,51% | ||||||||
5 | 0,32% | 13,40% | 4,70% | 0,00% | -23,51% | 9,43% | 3,01% | ||||||||
6 | -3,77% | -1,20% | 0,00% | 32,10% | 17,30% | 2,01% | -1,92% | ||||||||
. 4.9.2.
1 | 1,47% | 14,18% |
2 | 5,99% | 20,72% |
3 | 1,78% | 15,85% |
4 | 0,84% | 5,76% |
5 | 3,30% | 15,45% |
6 | 5,34% | 16,93% |
4 %, 8 %. Excel Solver , . , ( ) ( ). . 4.9.4.
. 4.9.3.
1 | 0,06 | 0,01 | -0,30 | 0,06 | 0,41 |
2 | 0,15 | 0,08 | 0,50 | -0,37 | |
3 | 0,08 | 0,01 | 0,14 | ||
4 | -0,03 | -0,11 | |||
5 | -0,40 | ||||
6 |
. 4.9.4.
: | 8% | 4% |
1 | 0% | 0% |
2 | 26% | 20% |
3 | 0% | 0% |
4 | 10% | 24% |
5 | 19% | 18% |
6 | 45% | 38% |
4,68% | 4% | |
8% | 6,65% |
|
|
. , , .