.
7.1.
: . . : I II. 7 9 . I II . 7.1.
, 1 . , 3 . : 4000 .. 3000 .. . , ?
7.1 -
, ( ) | , | ||
I | |||
II |
1. :
1) : x1 , x2 ;
2) ( ): x1 x2 :
F = 4000x2 + 3000x1,
x2 x1 , F:
F = 4000x2 + 3000x1 → max;
3) :
) , ..
x2 ≥ 0, x1 ≥ 0;
) , . .:
2x2 + 3x1 ≤ 7,
3x2 + 2x1 ≤ 9
:
x1 - x2 ≤ 1,
x1 ≤ 3.
, :
- :
- F = 4000x2+3000x1 →max
- :
2x2 + 3x1 ≤ 7,
3x2 + 2x1 ≤ 9,
x1 - x2 ≤ 1,
x1 ≤ 3,
x1 ≥ 0, x2 ≥ 0.
2. MS Excel : , . 7.2. x1 x2 3 4 . 6 :
= 4000*4 + 3000*3.
8:D11.
. 7.2. MS Excel
3. : , ( . 7.3). . 7.47.7.
|
|
. 7.3.
. 7.4.
(. 7.5): ; , ; . , , . , , . , .
. 7.5.
(. 7.6): . , , .
. 7.6.
(. 7.7): , , , ; , ; .
. 7.7.
7.2.
1 2 A, B, C, D, 7.2.
, A, B, C, D 7.3.
1 1 320 .., 1 2350 .. 1 2.
7.2 -
70 % 40 % | |
30 50 % 25 % 65 % D |
7.3 -
, | , | , ../ | ||||
A | B | C | D | |||
1. .
:
- xA1, xB1, xC1, xD1 A, B, C, D, 1;
- xA2, xB2, xC2, xD2 A, B, C, D, 2;
- i- .
:
F = 320(xA1+ xB1+ xC1+ xD1)+350(xA2+ xB2+ xC2+xD2)-40y1-50y2-60y3→max
:
) (.. 7.3):
|
|
xA1 ≤ 0,7 (xA1+ xB1+ xC1+ xD1),
xB1 ≤ 0,4 (xA1+ xB1+ xC1+ xD1),
xB2 ≤ 0,5 (xA2+ xB2+ xC2+xD2),
xB2 ≥ 0,3 (xA2+ xB2+ xC2+xD2),
xC2 ≥ 0,25 (xA2+ xB2+ xC2+xD2),
xD2 ≤ 0,65 (xA2+ xB2+ xC2+xD2),
) (.. 7.4):
xA1+xA2 ≤ 0,3y1+0,2y2+0,15y3,
xB1+xB2 ≤ 0,2y1+0,3y2+0,15y3,
xC1+xC2 ≤ 0,15y1+0,1y2+0,4y3,
xD1+xD2 ≤ 0,35y1+0,4y2+0,3y3,
) :
xi1 ≥ 0, xi2 ≥ 0, ;
0 ≤ y1 ≤ 1200,
0 ≤ y2 ≤ 2500,
0 ≤ y3 ≤ 3100.
2. MS Excel. . 7.8 . 7.4.
7.4 - ,
D11 | =320*(C5:C8)+350*(D5:D8)-40*F5-50*F6-60*F7 | |
14 | =C5-0,7*(C5:C8) | |
15 | =C6-0,4*(C6:C9) | |
16 | =C7-0,5*(C7:C10) | |
17 | =0,3*(D5:D8)-D6 | |
18 | =0,25*(D6:D9)-D7 | |
19 | =D8-0,65*(D5:D8) | |
20 | =(C5:D5)-0,3*$F$5-0,2*$F$6-0,15*$F$7 | |
21 | =(C6:D6)-0,2*$F$5-0,3*$F$6-0,15*$F$7 | |
22 | =(C7:D7)-0,15*$F$5-0,1*$F$6-0,4*$F$7 | |
23 | =(C8:D8)-0,35*$F$5-0,4*$F$6-0,3*$F$7 |
. 7.8.
3. . 7.9. .
. 7.9.
4. , .. , . 7.10.
. 7.10.