1) . . 40.
2) , .
1 ;
2 .
Z = 27,38 * 1 +37,8 * 2. (6)
40
(..) | |||
- (..) | S1 | 24/30=0.8 | 24/30=0.8 |
S2 | 21/50=0.42 | 21/25=0.84 | |
S3 | 18/20=0.9 | 18/40=0.45 | |
(..) | 0,8+0,42+0,9=2,12 | 0,8+0,84+0,45=2,09 | |
(..) | |||
(..) | 30+2,12=32,12 | 40+2,09=42,09 | |
(.) | 59,5 | 79,89 | |
(..) | 59,5-32,12=27,38 | 79,89-42,09=37,8 |
3) . , . .
. . , ..
1 >= 0,
X 2 >= 0. (7)
. .
S1. 30 30 ,
1 / 30 + 2 / 30 <= 1. (8)
S2. 50 25 ,
1 / 50 + 2 / 25 <= 1. (9)
S3. 20 40 ,
1 / 20 + 2 / 40 <= 1. (10)
(3) (5) :
(11)
(11),
(12)
, (6) (7) (12). 1 2, (6) (7) (12).
1. 3:4 (. 41 . 42) 1 2.
, 1 1 .
2. 3:F5 (12).
3. 6-8 :
) 8 8 Z;
) D8 .
=4*8+4*8, =(4:4;8:8) (=SUMPRODUCT(4:4;8:8)).
4. 9-13 (12):
) 11 (12).
=(4:4;E3:F3) (=SUMPRODUCT(4:4;E3:F3)).
A13 =($4:$4;E5:F5)
(=SUMPRODUCT($4:$4;E5:F5)).
|
|
2.5. F11:F13 (12).
41
A | B | C | D | E | F | |
1 | 2 | S1 | ||||
S2 | ||||||
S3 | ||||||
27,38 | 37,8 | 65,18 | ||||
42
A | B | C | D | E | F | ||||
1 | 2 | S1 | |||||||
S2 | |||||||||
S3 | |||||||||
27,38 | 37,8 | =(B4:C4;B8:C8) | |||||||
=(B$4:C$4;E3:F3) | |||||||||
=(B$4:C$4;E4:F4) | |||||||||
=(B$4:C$4;E5:F5) | |||||||||
OpenOffice.org Calc 9-13 .
=SUMPRODUCT(B$4:C$4;E3:F3) | ||
=SUMPRODUCT(B$4:C$4;E4:F4) | ||
=SUMPRODUCT(B$4:C$4;E5:F5) |
1. . . (. 12).
2. ( ) D8
3.
() ()
4. ( ) 4:4.
5. , . ( ).
6. :
4:4 ³ 0
11:13 £ F11:F13.
4:4 = ( )
(), .
6. (). (. 43).
Excel Microsoft Office
OpenOffice.org Calc
. 12
43
A | B | C | D | E | F | |
1 | 2 | S1 | ||||
S2 | ||||||
S3 | ||||||
27,38 | 37,8 | 1029,8 | ||||
|
|