: "", "" "" 400, 350 250 , : , , , 200, 250, 100, 200 100 .
. , . 1.
1
"" | ||||||
"" | ||||||
"" | ||||||
. .
A G - .
: A2 - , B2 - , C2 - , D2 - , E2 - , F2 - , G2 - .
: A3 - "", B3 =(C3:G3), B4 B5, C3:G3 - 1.
: A4 - "", C4:G4 - 1.
: A5 "", C5:G5 1.
.
: A7 , B7 , C7 =(C3:C5), G .
.
: A9 B9 - , C9 - 200, D9 - 250, E9 - 100, F9 - 200, G9 - 100.
: A10 , B10 , C10:G10 - .
: A11 - "", B11 400, C11 1, D11 7, E11 4, F11 6, G11 - 8.
: A12 "", B12 350, C12 2, D12 4, E12 4, F12 3, G12 - 5.
: A13 - , B13 - 250, C13 3, D13 3, E13 5, F13 2, G13 - 4
.
: A15 - , B15 =(C15:G15), C15 =C3*C11+C4*C12+C5*C13, G .
- . - . : ; ; .
2
B15 | - | |
3:G5 | ||
:5<=11:13 | . | |
C7:G7>=C9:G9 | . | |
:G5>=0 |
|
|
1.
1
1
:
1. . ( 2).
2
2. ( ). 2.
a) ,
b) B15, ,
c) C3:G5, ( 3),
3
d) , ;
e) ( 4) :
4
3. 5.
5
4. . 6 , .
6
D4, D5, G4, G5 ( 7)
7