1. k- i- :
CAki = + b1LAki + d, k= 1... 6, i= 1...4; (7)
= 20 ./ - ;
b1 = 5 ./ - ;
LAki - k- i- , ( 13);
d = 26 ./- .
(7) 14.
14
Cki, ./ | |||||
D1 | D2 | D3 | D4 | ||
A1 | |||||
A2 | |||||
A3 | |||||
A4 | |||||
A5 | |||||
A6 |
2. k- j- :
Ckj = + b1Lkj + c1,k=1...6, j = 1...2, (8)
Lkj - k- j- , ( 1);
c1 = 18 ./.- .
(8) 15.
15
CBki, ./ | ||||
B1 | B2 | |||
A1 | ||||
A2 | ||||
A3 | ||||
A4 | ||||
A5 | ||||
A6 | ||||
i-o j- :
Cij = b2Lij + c2, i = 1...4, j = 1...2, (9)
b2 = 2 ./ - ;
Lij i-o j- , ( 2);
2 = 12 ./. - .
(9) 16.
16
Cij, ./ | |||
B1 | B2 | ||
D1 | |||
D2 | |||
D3 | |||
D4 |
(2) .
|
|
:
A1 + 2 + 3 + A4 + A5 + A6 = 70+75+80+85+90+95=495.
:
1 +2 = 100+370=470.
: .
(1) :
= 526X11+211X12+236X13+231X14+421X21+176X22+241X23+196X24+226X31+
+171X32+236X33+216X34+146X41+146X42+191X43+221X44+446X51+161X52+286X53++646X54+746X61+506X62+176X63+316X64+180Y11+264Y12+384Y13+432Y14+114Y21+
+216Y22+318Y23+420Y24+158Z11+338Z12+108Z21+188Z22+318Z31+123Z32+528Z41+
+378Z42+738Z51+633Z52+948Z61+888Z62→min.
1 (3), , :
Y11+Y21+Y31+Y41+Z11 + Z21+Z31+Z41 +Z51 +Z61= 100,
Y12+Y22+Y32+Y42+Z12 + Z22 +Z32 +Z42 +Z52 +Z62 = 370.
2 (4), , :
Y11 + Y12 + Y13 +Y14= X11 + X21 + X31 + X41 + X51 + X61,
Y21 + Y22 + Y23+Y24= X12 + X22 + X32 + X42 + X52 + X62,
Y31 + Y32 + Y33+Y34= X13 + X23 + X33 + X43 + X53 + X63,
Y41 + Y42 + Y43+Y44= X14 + X24 + X34 + X44 + X54 + X64,
3 (5), , :
X11 + X21 + X31 + X41 + X51 + X61≤40,
X12 + X22 + X32 + X42 + X52 + X62 ≤45,
X13 + X23 + X33 + X43 + X53 + X63≤55,
X14 + X24 + X34 + X44 + X54 + X64≤60.
4 (6), , :
X11+X12+X13+X14+Z11 + Z12≤70,
X21+X22+X23+X24+Z21 + Z22≤75,
X31+X32+X33+X34+Z31 + Z32≤80,
X41+X42+X43+X44+Z41 + Z42≤85,
X51+X52+X53+X54+Z51 + Z52≤90,
X61+X62+X63+X64+Z61 + Z62≤95.
MSExcel .
1 MSExcel , .
1) :
k (k = 1... 6) D8:I8, Bj (j = 1... 2) 9:10, Di (i = 1...4) J8:M8;
Lkj D9:I10, Lij - J9:M10, Lki D11:I14.
2) :
ki, (k = 1...6, i = 1... 4) , k- i- , D25:I28;
Yij, (i = 1... 4, j = 1... 2) , i-o j- , - J23:M24;
Zkj, (k = 1...6, j = 1...2) , k- j- , - D23:I24.
3) :
ki (k = 1...6, i = 1...4) 1 k- i- (7) D18:I21;
|
|
ij (i = 1...4, j = 1...2) 1 i-o j- (9) J16:M17;
CBkj (k = 1...6, j = 1...2) 1 k- j- (10) D16:I17;
k- i- ki ki D34:I37;
i-o j- ij Yij J32:M33;
k- j- kj Zkj D32:I33;
( 9:10) , ( N23:N24), O23:024;
, ( J25:M25), , ( N25:N28), J29:M289;
( J8:M8) , ( J25:M25), O25:O28;
( D8:I8) , ( D29:I29), D30:I30.
4) P6 (1) D23:I24;J23:M24;D25:I28.
5) :
1: O23:024 ;
2: J29:M29 ;
3: O25:O28 ;
4: D30:I30 .
, , 143670 .
1 MSExcel
1 1 (70 ), 1 . 2 1 (30 ) 2 (45 ), 2 . 3 2 (80 ), 3 . 4 2 (45 ) D1 (40 ). 5 B2 (45 ) D2 (45 ). 6 D3 (55 ) D4 (15 ), 6 ( 17).
17
, | |||||||
1 | 2 | 3 | 4 | 5 | 6 | ||
1 | |||||||
2 | |||||||
D1 | |||||||
D2 | |||||||
D3 | |||||||
D4 | |||||||
D1 2 (40 ), D2 - 2 (45 ), D3 - 2 (55 ), D4 - 2 (15 )( 18).
|
|
18
, | |||||
D1 | D2 | D3 | D4 | ||
1 | |||||
2 | |||||
2 .
2 -
, 1 1 (70 ) 2(30 ); 2 - 2(45 ), 3(80 ), 4(45 ), 5(45 ) D1(40 ), D2(45 ), D3(55 ), D4(15 ).
, , , .