1
1. ' . :
- 1,5%;
- 15 10*S/55 [];
- 20 15*S/60 [].
N / | ϲ | , , OS | ³, V | , ., S | , . | |
.. | ? | |||||
. | .. | . | . | . | . | |
? |
2. ³ ( 16 65), , .
3. ³ .
4. 1 2 3.
5. 1 : 450, 300.
6. 2 : OS>30 V<35 , 2, 4, 5, 7.
7. 2, 6, 7 -.
8. 2, 6.
9. 3 ( ).
2
1. :
Z1, < 100%;
Z = Z2, = 100%;
Z3, > 100%.
Z1 = S*D1/D; Z2 = Z1*(1+P1/100); Z3 = Z2+Z1*P2/100;
D - (25 );
D1 - ;
P - ;
1 = 3%; P2 = 10%.
ϲ | ʳ - D1 | , . S | ³ %, | , . Z | |
.. | 910,00 | ? | |||
.. | .. | .. | . | . | |
? |
2. ʳ ( 15 25), , .
3. ³ .
4. 1 2 3.
5. 1 : 500, 400.
6. 2 : D1<=23, >100 , 2, 3, 5, 6.
7. 2, 4, 6 -.
8. 2, 6.
|
|
9. 3 ( ).
3
1. , :
Z*B/(2*K), C < 3;
Z*B*3/(5*K), 3 <= < 5;
= Z*B*4/(5*K), 5 <= C < 8;
Z*/ C >= 8.
- | ϲ | 2 | -, | , | , . | |
, . Z | ʳ | |||||
.. | ? | |||||
. | .. | . | . | . | . | |
? |
2. ( 1 5), , .
3. ³ .
4. 1 2 3.
5. 1 : 10 5.
6. 2 : B<=5 C>5 , 2, 5, 6, 7.
7. 2, 3, 7 -.
8. 2, 6.
9. 3 ( ).
4
1. , (), (MAX) (MIN).
:
% < C, = "";
% ³ C, = "";
% = MIN, = " ";
% = MAX, = " "
̳ | , .. | ³, | |||
. . | % | ||||
232,1 | ? | ? | |||
. | . | . | . | ||
? | ? | ? | |||
? | |||||
̳ | ? | ||||
? |
2. ( 1 4), , .
3. ³ .
4. 1 2 3.
5. 1 ³ : 100 90.
6. 2 : ³ , 1, 3, 4, 6.
7. 1, 3, 4 -.
8. 1, 4.
9. 3 ( ).
5
1. . :
- 50%;
|
|
- 20 25 20%;
- 20% 25 - 30 .
/ | ϲ | , P | , , OS | , | , . | , . |
.. | ? | |||||
. | . | . | . | . | . | |
? |
2. ( , , 1) .
3. ³ .
4. 1 2 3.
5. 1 : 25.
6. 2 : P= OS £ 40, , 2, 3, 4, 6.
7. 2, 4, 5 -.
8. 2, 7.
9. 3 ( ).
6
1. , :
< , = 300;
>= < , = 200;
= , = 150.
ϲ F | , . ZP | , . D | ||
.. | 1395,20 | ? | ||
... | ... | ... | ... | ... |
? | ? | |||
? | ||||
? |
2. , ( 300 10000), .
3. ³ .
4. 1 2 3.
5. 1 : 500.
6. 2 : F ZP<400, , 2, 4, 5.
7. 2, 4, 5 -.
8. 1, 5.
9. 3 ( ).
7
1. , .
25% Z, K = 1;
S = 33% Z, K = 2;
50% Z, K > 2.
ϲ | ³ | , . Z | ʳ | , . S |
.. | 1595,00 | ? | ||
... | ... | ... | ... | ... |
? |
2. ʳ , ( 1 5), .
3. ³ .
4. 1 2 3.
5. 1 : 450, 200.
6. 2 : Z < 420 > 2, , 1, 3, 4, 5.
7. 1, 3, 5 -.
8. 1, 5.
9. 3 ( ).
|
|
8
1. () , :
|
(G*B)-0,15*(Z*K), (G*B)/(Z*K) >= 0,15
ϲ | 3 | ʳ G | 12, . | , . | ||
, . Z | ʳ ' | |||||
.. | 4,1 | ? | ||||
... | ... | ... | ... | ... | ... | |
? |
2. ʳ ' , ( 1 5), .
3. ³ .
4. 1 2 3.
5. 1 ʳ : 40, 30.
6. 2 : Z < 400 > 3, , 2, 3, 4, 7.
7. 2, 3, 7 -.
8. 2, 3.
9. 3 ( ).
9
1. :
|
(4*X)^2+3*X+45, > 10
, | , . F | ||
"" | ? | ||
... | ... | ... | |
? |
2. , ( 1 15), .
3. ³ .
4. 1 2 3.
5. 1 : 10, 3.
6. 2 : £ 10 F > 2500 , 1, 3, 4.
7. 1, 4 -.
8. 1, 3.
9. 3 ( ).
10
1. "". :
2,5 + S*T, <= 2;
F = 5,5 + S*T, 2 < <=4;
14 + S*T, > 4.
ϲ | ̳ | , / | ³ S | - , . F |
.. | 1,5 | 4,2 | ? | |
... | ... | ... | ... | |
? |
2. , ( 1,0 3,5), .
3. ³ .
4. 1 2 3.
5. 1 ³ : 4, 2. .
6. 2 : < 2,2 S > 2, , 1, 3, 4, 5.
7. 1, 4 -.
|
|
8. 1, 5.
9. 3 ( ).
11
1. ' .
:
- 2%;
- 20 2,5 % [];
- 25 3 % [].
ϲ | , OS | ³, V | , . S | , . | |
.. | ? | ||||
... | ... | ... | ... | ... | |
? |
2. , ( 15 40), .
3. ³ .
4. 1 2 3.
5. 1 : 25.
6. 2 : OS>25, V<35 , 1, 3, 4, 6.
7. 1, 3, 4 -.
8. 1, 5.
9. 3 ( ).
12
1. :
Z1, < 100%
Z = Z2, = 100%
Z3, > 100%.
Z1 = S*D1/D; Z2 = Z1*(1+P1/100); Z3 = Z2+Z1*P2/100;
D - (25 );
D1 - ;
P - ;
1 = 3%; P2 = 10%.
ϲ | ʳ - D1 | , . S | ³ % | , . Z | |
.. | ? | ||||
... | ... | ... | ... | ... | |
? |
2. , ( 1 5), .
3. ³ ' .
4. 1 2 3.
5. 1 ʳ : 20, 10.
6. 2 : D1 >=23, <100 , 1, 3, 5, 6.
7. 1, 4, 6 -.
8. 2, 6.
9. 3 ( ).
13
1. , , :
= = 80
= MN = 150
< = 120
>= < = 100
ϲ F | , . | , . | |
.. | 1089,54 | ? | |
... | ... | ... | ... |
? | |||
() | ? | ||
? | |||
̳ | ? |
2. ( 100 110), , .
3. ³ .
4. 1 2 3.
5. 1 : 120.
6. 2 : F ˔ >=100, , 1, 3, 4.
7. 1, 3, 4 -.
8. 2, 4.
9. 3 ( ).
14
1. % , :
|
|
0, <= 10
H = 5, 10 <= <= 20
7, > 20
S | ʳ | % H | |||
"" | 5500,00 . | ? | ? | ||
... | ... | ... | ... | ||
? |
2. ʳ ( 0 100), , .
3. ³ .
4. 1 2 3.
5. 1 : 9000, 5000.
6. 2 : S>=5000 K>16 , 2,4,6.
7. 2, 3, 6 -.
8. 2, 5..
9. 3 ( ).
15.
1. , -, :
7%, K=2
S = 10%, 2 < K <= 4
15%, K>=5
ϲ | ֳ 1 . | ʳ | , . S | ||
.. | 150,00 | ? | ? | ||
... | ... | ... | ... | ... | ... |
? | ? |
2. ʳ ( 1 12), , .
3. ³ .
4. 1 2 3.
5. 1 ʳ : 12, 6.
6. 2 : <50 K<=6 , 1,2,4,5.
7. 1, 5, 6 -.
8. 2, 6.
9. 3 ( ).
16
1. % :
3%, OS 11 20
OS = 5%, OS 21 30
7%, OS >30 .
N | ֳ . | (.) OS | % , U | |||
$450,23 | ? | ? | ? | |||
... | ... | ... | ... | |||
? |
2. 䳻 ( 0 40), , .
3. ³ .
4. 1 2 3.
5. 1 ֳ . : 900, 400.
6. 2 : N=2 OS>70 , : 1,3,6,7.
7. 1, 3, 6 -.
8. 1, 7.
9. 3 ( ).
3
. .
ϳ :
1.
2.
3. 1
4. 2
1. " "
:
.
1. ³ 1, .
2. "³ "
3. ( - )
4. "³ "
5. ѳ
6. . . , .
7. .
8. ,
9. 2
10. -
11.
12. :
ѳ
nte
13.
14.
15. , , .
16. . , , .
17. '
2. " "
:
. "³" (, , , , , .) ("", "", ""). ' . ' . " " .
1.
D | ||||
"" | ||||
ʳ | ֳ, | , | ||
...... | ||||
, 4 , .
2. .
3. , , , .
4. -
5.
6. , ,
7.
8. , ' :
,
,
ʳ ,
,
9.
10. ,
11.
12. , , .
1. Excel : Excel / . , . , . . - .: , 2004. - 294 .
2. Microsoft Office / .., .., .. .: , 2006. 264.
3. .., ⳺ .. : . .: , 2004. 448.
4. : . . / .. , .. , A.M. . - .: , 2003. - 788 .
5. .., .., .. : . : , 2008. 665.
6. . MS Excel : . - .: , 2000. - 83 .
7. . : , Excel. .: . , 2004, - 528.
̲
1. 3
1. , , 3
2. , , , , , Ȕ 6
3. , , , 8
2. 11
1. 12
2. 18
2. 19
3. 27
1. " " 27
2. " " 28
. 30