Капутин Ю.Е. Горные компьютерные технологии и геостатистика
Подождите немного. Документ загружается.
31
,, ,&&(
9$&&$,&$ $ &'$
3%'$2
&'$* ), $ -$+'$
-$&&+ ,+# 0+ 2,'2.2 (*&+$ &%,%$$ % &$ $
'!&+ +'( '%$$ '2 0&$2 $ -&2&+ &)&$0%$ -1$'$. &$ ,
$* 0.2 *'$0&+$ %-$, - $-'(*,&$ &%'(%$) &'(#$)
, ' *&%'&$ ' '%$ $ %/ &)$ %'$0,
%-$".
! 5#.
#$$%& " '#()!&%$")
./22 & $$ 3 $&41$2 - -,&$. + $ -,%
* '(, ' ,*!&+ 1&% !&$2 $ &&! 0&(., -$&,
+/-5%. ;2 /$" &&! + ! +( $*,& ('$ +' -,& &$
%,!$& &$! -'(& ,&2 %(), & & -%$% %&0'(&+ *&0&$2
*-, &$) !&$" .2 0& &&+$, .%. &$ ,2*&+
&#&$ 1& $ * & ' -*&$) $2) !$*&$ --$2$2. $
$-'(*,&$$ $%&$,&$2 &&! -*&$) $" + --$2$2
%*+,2 & '$#% ,!&+ '2 1&%$ & $$ 3. & *&0&$
"0$, $ -$ &0' +0&+) & &$%. ,!&, 0 /$"
&&! + 0& & $*,& , &0' -%. $' /,&&+
*&&$ ( %$'(& ,*!&" 0&(.) %0, +, +," , 0&$
-,+) ' + %(.
, &&+) -'!&$2 ",$'(&+ '2 &$' % -&+) %(,:
1. )$ *&( %$'(&" 0&(. $ ,&(.
)%$$% $&$'(&+) *-, +, ,&+) -&2 '2 -$, &
%+" -$*,& 0 -% &'$0&$ , 3.
2. '!& +( 0$& %&0'(&+" -&1$'(&+" (&& *,+#&&+")
&&! +, 0+ -'$( "& ,'$2&$2 %(, ,& $ % & '!&+
$(2 %-$'(&+ !&$2 $ */(2 ,'+.
&.
7( $,.2 2 -: -$*,$'(&( $ $*,'0&$.
%&2 -$*,$'(&( ! +( '% $& & -%$%, '$ +
-,$'(& &$*,&+, ,&$ -,$'(& -&.
344%$,&( -(, '$ ,%+#&+ $ -,$'(&+ +
. - +0$. 3$ &+ '!&+ +( %$'(&" 0&(.
&+ & $$ 3.
$*,$'(&( $'(&" 4$%$ (9) +0& &$0$,2
-- %&" -&(. $" '&$2 $ $*'(0&$2. $&1$-+ -%$,&$2
9 )# $*,&+, & $) & $-'(*,&$ 0&+) ,&$"
-0&$ $ $*'(0$ +. 3$ -+ '!&+ +( )# $* 0&+ &
-,$'(&" $$ -'&$,&$2.
344%$,&( /&$2 -'22 2 -$: &%(.
-', $*,'0&$ $ !&$ -'*&+) %-&&, , %&1&. 0&(
-)!$ 1&%$ +( $ -$ '' $0%" % + $ .-. 2
0&( 1&% ,2*& %0,&&+ -,&$ )&'$0%$) $-+&$"
+.
3.
%+ '&+ *, && , *' -$*,,&&+),
&*&0$'(& '$0.2 '2 *'$0&+) &$%, $ ,& $*,&+ , '2).
$ +( &$%'(&+$ $'$ & 1&$,+$. +0& 0&( 1&%$
%-$'(&+) $ -$*,,&&+) * ,2*& 0&(. -'&$2 6,,
1& $ .-. $ %-&$ 2 &-2+$ (%,&&+$) $'$ &%'&+$ )$.
%" -) , % ,*&$. &-'&&" 0$ ),. " -$0$&
&$ '!&+ +( %&%$*$,&+ &%'(% ,*!&, & %++ $'$
-'&+ , $ ($ -2+) *.
- %2 ' 0"& - ),&$ , , &-,$&&+)
$ 1$2), %$) %% *,%$, & #&$ %, $'(, 6%,, &$*%
32
%0, '(&+) $'(&+) $'$ -'+ -". 3$ &-,$&&+
)+ '!&+ %! - $,(2 , -%. *( &)$
!&(. 3 (2 ), & -%+, / -') %0, -% $
&$% & '!& %-&$,( -') . .
0&( 1&%$ %-$'(&+) $ -$*,,&&+) * ,* $$ %
$$. +0& & ,+!2 ' ./$$ 1$4$:
5&1- '(&2 $2 : +/- 30%,
3 :+/- 20%,
3 :+/- 10%.
%2 0&( 1&%$ * &)$ '2 -$&2$2 &,&& #&$2
-'!&$$ - -% .
/
) - +" ,!&+" %&$0%$" - & -2!&$$ !$*&$
--$2$2. 7 0 & '.2 , -'+, ,%'.02 -'&$'(&+ $&,$1$$
, 0&$ % + &$%. % %% ) 2,'22 ,!&"#$ -%*',
'2 --$2$2 &$' 0 ,,$'(&+ $*&&$ ), 0 $*&&$ ,
%" ! --1$$ '. - *.
'$0$& ) *,$$ !&$2 , -'*& %-&&,
-$*,$'(&$ --$2$2, $*,'0&$2 %-&&, $ 1&+ & %&0& .
- %1$.. * $) -%*'" 1& – &$' &+" - '2 1&%$, $
,'$0$& & &)$2 - %&' 1&/$%.
! * 0 $&4'21$$ 1&+ $'(& ,($ . , ,&$. +0& &$
%'&&+ % 1$%'$0%$ %'&$2.
'+ %$& % -&+) &+) %-&$" )# $&4$,&+
-,&$$ %$,+) "-'!&$/-" $ ,$!&$$ $,+) 1& & ''+. +0&
&$ -%*( -,&$ 1& ,2&(. 80% $'$ ,+#. '(&, '$
! -$ %&,$,&" 1&% 1&+, -% -0$,, - %"&" ,
$&$'(& - $+" ,&( -$+'(&$.
2.4 "( 1 ""$& $( ",
"'.#$( '" "- %"()
" "
'2 , 0+ -,$'(& $-'(*,( $&+: “ ” $'$ -
“$&'$*,&&2 -”, &)$ -,$ %&$0%$ $',&$2 $
0$( )+ $ *+ / & -$*,,. *'
$,.2 &%+ '$ %$) 0,.
6"" 0 "!.
'$ %- -'!$' &2 1$ & 0 , &% - +0&+ 10%, , %&1
& -' 0$ 1.10 $ , 0 ! +( *-$&, %%
(
)
FW PV i
=
+
1
, (2.3)
: FW - /2 $(,
PV - &2#&22 $(,
i - & &%,% -1&.
'$ &($ ,'&+ & 0, 0* 2 $& 1.21 $, ..
(
)
(
)
FW PV i i
=
+
+
1 1 .
%&1 n ' )&&$2 $&
(
)
FW PV i
n
= +1 . (2.4)
7
1 0 /" $$ ! +( ,+-'&& , &
-2% '2 , & ,- “%'(% & & -'!$( & 0, 0+ 0* 5 '
-' 0$( 1.61 $ -$ &%,% -1& 10%?” '2 % 0 $-'(* 2
4 '
33
( )
PV
FW
i
n
=
+1
(2.5)
,$, -+ /$ *&0&$2 , 4 ' , + -' 0$ PV=1 $.
&2#&22 $( '2 $$ $&%,+) -'!"
-'!$, 0 !& , %&1 , 0&$ 5 ' , &% ,&$2 - 1 $.
+ ! 0$( ( *&2 &%,%$" -1& =10% ) &2#&.. $(
%! -'!, %! & . ,'$0$& -'!".
,+" :
( )
PV
1
1
1$
1 010
0 909$=
+
=
.
.
...........................................................................................
2+" :
( )
PV
5
5
1$
1 010
0 621$=
+
=
.
. ,
&2 ,'$0$& ,) ,+-' - PV= 3.790 $ .
/2 4 ' '2 0 &2#" $$ %$) !&+) ,&+)
,%', $ ,$:
( )
( )
PV FW
i
i i
n
n
=
+ −
+
1 1
1
(2.6)
0$, - " 4 ' $)&+ &&+ -+ / -$, -' 0$
( )
( )
PV =
+ −
+
=10
1 01 1
01 1 01
3 791$
5
5
.
.
. .
.
&
-'!$, 0 5 $ *&2 , &% &2 ( ,2=0 ) '2 -% -%$ $&$1+
,&$2, &%,%$" -1& = 10%. -'2 ,& ( %$ , ,$
,&+) !&+) -'!" - 1 $. - “ 5% ' -$2 ,*,/( %$?”
&2#&22 $( %$
PV1=-5 $.
&2#&22 $( -'!" - ,*, %$
( )
( )
P V
n
n
2
1 0
1 0 1 1
0 1 1 0 1
=
+ −
+
.
.
. .
(2.7)
5$ ,*,/&, % NPV ( 0$2 &2#&22 $( )
,& 0, ..
( )
( )
NPV PV PV
n
n
= + = − +
−
1 2
5$ 1$
110 1
010 110
.
. .
=0
% '2 5 ' NPV =-1.209 $ ,
'2 n= 6 ' NPV = -0.645 $ ,
'2 n= 7 ' NPV = -0.132 $
'2 n= 8 ' NPV = +0.335 $
%$ *, % ,*, %$ -$& ,& 7.25 '.
. 0%
-'!$, 0 & -% -% $&$1+ ,&$2 , & ,&$ 0
$0& 5 $. ' , 0&$ 10 ' * 0 ,&$2 !&
-' 02 -$+'( (-' -'+ &',) - 1 $ !&.
'$ -'!$( , &% 5 $, -$ -1& i 0* 10 ' + -' 0$ ,
,,$$ ,&&$ 2.4.
/2 $( ( , %&1 10 ' ) %" !&" 1 $ -$+'$ ,$
34
( )
FW A
i
i
m2
10
1 1
=
+ −
, (2.8)
Am – !&+" )
-1& i, -$ %" /$ $$ FW FW
1
2
=
,&+,
&*+,2 &" ,*, $&,$1$" (ROR). && ' 0 & -$& ,&
0.15 $'$ 15%. 3 ! ,'$0$& !& &"$ , ,$ &+ -1&, '$ -$,&2(
NPV & '., ..:
( )
( )
NPV
i i
= − +
−
+
=5 1
11 1
1
0
10
10
.
-$ i=0.15.
1 -$,&$2 /$) $" % &0'(& ,&$ &*+,2
$%&$,&$.
& ( Cash flow(CF))
3 $& &$2 % “0$+” ,)2/$ $'$ $)2/$ &,
%+ 1$% '$ . & --$2$$ , $' -$. 3 -&2$ 0$+,
' ./$ -+:
Gross revenue &+ )+
- Operating expense -$*,,&&+ *+
= Gross profit (taxable income) =''+" )
- Tax -'$
= Net profit =8$2 -$+'(
- Capital costs -5-$'(&+ ,'!&$2
= Cash flow =% &'$0&$
" -$ -$,& , '.2.2. && ' 0 , &0' -%
,%'+,2 200 $ , , %&1 1- / 100 $ . 0+ ,+-'&&+ '2 -,+) 6
'.
'$1 2.2. " -$ 0 -% &'$0&$.
+
0 1 2 3 4 5 6
$
170 200 230 260 290
-40 -50 -60 -70 -80
-200 -100
.
-30 -40 -50 -60 -70
CF
-200 -100 +100 +110 +120 +130 +140
$% ( DCF)
$& “$%&$,(” ,, “&"$ &2#&.. $(”.
-+ / -$ !& 0$( &2#&.. $( '2 %!
$&$,$ '(& -%. '$0$& NPV '2 n 0 $&$'(& -$'"
&+ ,*, %-,'!&$" = 15% ,&:
( )
NPV
CF
n
n
n
=
+1 015.
, (2.9)
n - -2%,+" .
% '2 -, NPV = -86.96,
'2 -2 NPV = +64.63, &+" $%&$,&&+" CF = 55.75 $
. 3 ,'$0$& -'2 -'&$'(& . %-,'!&$", % . !&
,'!$( , &0' -% -$ &&" & ,*, %-,'!&$" = 15%.
. ( DCFROR)
0+ CF $4$1$ .2 $ &%'(% '!&2.2, % -$&$.2 ,
,&$&$ $*1$&&+ 0$'&$2 & ,'!&&+" %-$'.
35
Gross revenue &+ )+
- Operating expense -$*,,&&+ *+
- Depreciation -$*1$2
= Gross profit (taxable income) =''2 -$+'(
- Tax -'$
= Profit =8$2 -$+'(
+ Depreciation +$*1$2
- Capital costs -5-$'(&+ ,'!&$2
= Cash flow =% &'$0&$
7( & !.2 *'$0&+ -+ 0 $*1$&&+)
0$'&$". && -$ -$&2, 0 $&,$1$$ $. % !$*&$ Y '
& '," 0&" $(.. !&+ $*1$&&+ 0$'&$2 ,&+
$$ 4&,, '&&+) & ,2 !$*&$ 4&,, ..
Dep=Inv/Y (2.10)
&.
0'(&+ %-,'!&$2 , 5-$ '&$" -% ,$'$ 100 $ & ',"
0&" $(.. %$ +" ) ,$ , -,+" - 80 $ ,.........,, 5-"
- 96 $ . $( ,,&& 1&& , -,+" - 30 $ ,........, , 5-" -
38 $ . '$ ,2 32%. 0 CF -$,& , '$1 2.3.
'$1 2.3. 0 CF 0 $*1$$
"( 0 1 2 3 4 5 2
$
80 84 88 92 96
440
--
-30 -32 -34 -36 -38
-170
-!
-20 -20 -20 -20 -20
-100
=& 1
30 32 34 36 38
170
-.
-9.6 -10.2 -10.9 -11.5 -12.2
-54.4
=& 2
20.4 21.8 23.1 24.5 25.8
115.6
+!
20 20 20 20 20
100
-
-100
-100
CF -100 40.4 41.8 43.1 44.5 45.8 115.6
&+" NPV 0 &+ $%&$,&$2 15% ,& 43.29 $ .
'$0$& DCFROR, %2 ' NPV ,&+ 0, ,, i=0.315.
- ( Depletion)
= ,''(1 $&'(&+) , ,*,/2 -1$'(&+" &' &
$/&$ & , 0&$ , % + --$2$2. !& 1&$( $(
!&$2, 0+ - $*$,( $ “%-,'!&$2” +0&+ - .
'(% , && ' 0 -1 &*+,2 & $*1$2, $/&$ ( depletion).
/, 2 - '2 0:
1. 7& $/&$ ( 7 )
2. 1&& $/&$ ( )
!& ,+-'&22 0 - $ , $ % $-'(*,&$.
-$&$2 , %+" %$'(& &$! &'$ --$2$2. 8/ ,
$-'(* 2 ," -.
'2 0, - -, - ( 7 ) &0' &,'$,. 0& . * .
. ,%'.0.2:
-*+ & -$&$ -, ,&&$, ,%'.02 &$'(&+ $ .
-*+ & *,% , '$0% $ %#"% ' !$,&$.
-1&& $/&$2 ( ) 0$+,2 , 3 -. -, #
- '$1 -'22 -1& !&$2 -'+ * $/&$ &, %+"
-$&22 % ,', ) --$2$2 ( -' ,+0$&$2 royalities ( '2&+
-'!$ * -,'&$ '$1&*$$, * %+) *,$$ *, )
& --$2$2 ) ) , -' 0&& , 0&$ &', .
$& % “Mining” ,%'.0 , 2 % &-,&&
$*,'0&$2 + $* & - -% + $ &-$,&$ & 2&$ &
36
' 50 $'( %( 9. % - -* , -1+ %$
+ $$, & ,-,+ &,$2 ,, & %+" ( - & +&%.
&%, , &%+) ' 02) , $. ,%'.0. -'&$'(&+ -1+.
0 -'+ * $/&$ ($. 2.4) *$ 2 & ,', ) -!$
- %1$$ $'$ (0 ,&*&0&) - & -' '' $0% *, * -' 0+"
%&1&.
+ ( -1&+ , ) ) &$&%,+ '2 *'$0&+) ,$,
$&'(&+) ,. %$ ( 22% ) ,, &,+ $ ''$0%$
, $&$ ( 5% ) - ,$. $ %&&-$'(&+ $'.
, - 0$+,2 &''2 -$+'( (,%'.02 ,
!&$2 * $%'.0&$ $ carry forward loss) '2 $' .
%&0'(&, & # 3 ,+$2 * %% &(# $* -1& $/&$2,
&"&& & - 1 $ 50 % &''" -$+'$., &"&&" & - 2.
$ &% 2.4. ) 0 -'+ * $/&$ &
% &'$0&$ 0 -'+ * $/&$ &
CF :
Gross revenue &+ )+
- Operating expense -$*,,&&+ *+
- Depreciation -$*1$2
- Depletion -' * $/&$ &
= Taxable income =''2 -$+'(
- Tax -'$
= Profit =8$2 -$+'(
+ Depreciation +$*1$2
+ Depletion +' * $/&$ &
- Capital costs -5-$'(&+ ,'!&$2
= Cash flow =% &'$0&$
' ./ - -$ -%*& -2% ,%'.0&$2 -'+ * $/&$
& () , 0+ CF .
& --$2$ $ !&+" ) -!$ 2&+)
1,500,000 $ . $*,,&&+ *+ ,'2. 700,000 $ , $*1$2 - 100,000
$ , &'$ - 32%. * '2 0 7 ,& 0. ,$'(&+" 0 CF :
) 1,500,000
- $*,,&&+ *+ -700,000
- $*1$2 -100,000
= ''2 -$+'( 0 700,00
' .
.%. 7 & ! +( 0$& ( *=0 ), -'22 . )$
,+( &$&(# *&0&$ $*:
. 50% ,'$0$&+ ''" -$+'$ 0
. 15% ,', ) ( ,*2 $* '$1+ )
&& ' 0:
. 0.5 ) 700,000 =350,000 $
"
50%
", ! 2-
% +#
1#
", !
+# 1#
37
. 0.15)1,500,000=225,000 $
%$ * '2 '(&"#$) 0, -$&22 =225,000 $. 0+
CF -' -$&$. ,$
Gross revenue 1,500,000
- Operating expense -700,000
- Depreciation -100,000
- Depletion -225,000
= Taxable income 475,000
- Tax -152,000
= Profit 323,000
+ Depreciation +100,000
+ Depletion +225,000
= Cash flow =648,000 $
' ! " (Net Smelter
Return)
'2 1,&+) '', 1&+, %% -,$', -$,22 & & %&1&+, &
0$+ ''+. :&, % . -'$ '' $0%$" *, * %&1&,
&*+,2 Net Smelter Return (NSR), *,$$ &$) 4%,, & '(%
1&+ & ''.
-'!$, 0 4$% -$*,$ %&1&, !/$" G -1&,
$. &" && %&1& !$2 CM 4 &, ''
CM
G
=
100
2000, (2.11)
2000 - %44$1$& -0 4 &, , &&+.
'(#$&, '' $0%$) $ 4$&$,0&+) *,, -'2 *
!/$"2 , %&1& '' - 1&, - '$% + &-$ , %0%$)
-,0&$%).
:& * && %&1&, !/ G% $ , ,&
CV
G
P=
100
2000 , (2.12)
P- 1& 1 4 & $.
, -&2&, 0 *,+ & *-'$( & --$2$. % .
1& * ,( '', !/$"2 , %&1&. '. -$*,, /, .
-$. $&$2 $) , ,&$&$, *, -'$ '(% * 0( '',
!/2 , %&1&. ! +( 3 ,$ 0 %$) -(.
1 ) 1&& &$!&$. ' 0 *, -'$ &$% * % ''
(*& ,&& -,/$% $ -$' ), !/2 , %&1&.
2 ) '(& &$!&$. !&$ '' , %&1& &(#2 &
*& ,&& 4$%$,&& '(& %'$0,. -1&, $'$ $1%$)
&1$"
3 ) 5$&1$2 $) 2-) ,.
-'& ' 0 “'(&” !&$ '' , %&1& (Ge) ,&
( )
uG
C
G
e
−=
100
, (2.13)
: - '2 , % -'0$, '' , %&1&
u - 4$%$,&& &$!&$ !&$2 '' , %&1& .
','(&, -'0$, *, %'$0, '' , %&1&
(
)
2000
100
uGC
M
e
−
= , 4 &,, (2.14)
& *, -'0$, '(% 0( +&0&" 1&+ '', $-'(* 2
%44$1$&, &*+,+" :&,+ %44$1$& (f). 5 -'$2 100%
+&0&" 1&+, %44$1$& = 1.0 ), -' 0+" * 1 && %&1&,
%$ *, ,&
GV M Pf
e
=
(2.15)
38
$ 0 *," 1&+ * %&1& (BSR) & 0$+,( %! *+
*, & -% , 0$% $ -! - %1$$, ..
(
)
TrPfMBSR
e
−
−
=
(2.16)
: r- *+ & 0$% ( 4$&$,&$ ) $ -! - %1$$
T- *+ & -% %&1&
8 , %&1& $2 & -'*&+) %-&&,. 3 2'(,
! +( 0& $'$ -'&$'(&+ ) $*,'0&$2 $) %-&&, (Y),
$'$ #4 * &$*,'0&$ $) , $* %&1& (X). '$ -$ *&0$(
Pe=(PF-r), 4 ' (2.16) -,$2 , ,+!&$
NSR M P T X Y
e
e
=
−
−
+
(2.17)
'0&+ '#&$2 & -% %&1& $ 4$&$,&$
+0& ! $&41$. *,$$$ * $ 1&. *&&$ ,& *
& 4$&$,&$ (e1) ! -$&$( ' ./$ 4+:
1. *&&$ & - &
2. &*$ $*&&$ & &, -&*&+) 1& $ *
3. &%$ $*&&$ * & &, - '$% +) $&%, $*&&$2
1& & , , -'$, $ .-.
4. *&&$, &,&& & -&* 1& & ''+
5. 5$&1$2 2-4 4.
*&&$ * & % %&1& (e2) ,2*& +0& 4$ 2
$'$ 3. -( !& --$( ,&&$ (2.17) 0 --%$,& $*&$2
*.
(
)
(
)
Y+X-eT-er-PfM=NSR
21e
±
±
(2.18)
5&%+ & -% %&1&, '!&+ ,%'.0( , 2 , -%+
-!$ $ -% -%$ & -,%$ 9 $ %&0'(&" -'+ *
-% . '.2.16. -0$'&+ , '&+ % %&% $ ,-+ '2
,$'2 %&%. '$ -2,'2.2 &,+ -'+, & -0$'&&+ ,
$-, %&%, +0& ,'22 -'&$'(& '#&$,
0$+,./ $).
8$2 1& %&1& &*+,2 “at-mine-revenue” $'$ AMR ,&
AMR
NSR
R
=
−
(2.19)
'$ *'$( AMR & $( '' , %&1& ( CV), -' 0$2
-1&&2 -' -
PP=100*AMR/CV , (2.20)
%2 +0& '2 1,&+) '', %''2 45 95%.
7+ & '' $0%$" -', %$ *, 2,'2.2 (*&+
4% , 1&% -&1$'(&" -$+'$ &, & -%.
3"'.4" # (4() *! ,"$' "
"! -'./ - "# "$. &'! '." ""! ( "!
%) "! ""() 1 ""$& ) &" $"!
" #'!, ""( "'.#/ ' "- "'/! & %"()
" " #.
3 ( 0% !
.
3.1 "%"" %"'"%& "! ,"$- "
"$./
3.1.1 " 1!
'2 *&$2 -'&" '$ !&$2 $ 1&%$ *-, +0&
&)$ ' ./$" & $&41$$, ,,&&" , %-(.:
-*#), - ,#), $..),:
39
1. %,!$&:
5$&+ (, ,+%
&&+ $&%'$&$$
&&+ -,&$2
$ )%$$%$ %,!$& (%!, ,+) %&,
$'$2, '$'$2, $4$2 $ ..)
2. -,)&&+ ,+% (%&,,  $ .-.)
5' %#"%$) 0% - ,+%
&&+ -,&$2
$ )%$$%$ ,+% ('$'$2, $4$2,
%&$% $ ..)
3. -,&&+ -*&+ ,+%
5' %#"%$) 0% - ,+%
&&+ -,&$2
$ )%$$%$ ,+% ('$'$2, $4$2,
%&$% $ ..).
'8-:
1. -4$2 -,)&$ !&$2
2. '$0%$ -'&+ $ **+ &&&$ %& , &+)
', *&, -0&+) '%, ('$ &)$), '$'$0%$) $
$4$0%$) &$1, %&$0%$) & #&$" $ .-.
3. '&+ -*&+) $*&, &&&$ %& , &%
,+%
4. '& -,&$2 -,)&$ $ &#" (%&,).
2 $&41$2 ,,$2 $* %$'(& ,&+) $0&$%,, +0&
&-,&& & --$2$$, , '0 -' 0$( &./$ &&+ $'$
*62&&$ - &-&2&+ ,-. >''(&, 0+ , "
0,,'$ '$, )# *&./$ !&$. 3 *&0$'(& %/
,2 +, '0 -$% +) &&+) $ $) $,% .
3.1.2 .% "
'2 ,, %," $&41$$ - .2 -1$'$+, ./$ +
$ 55 -0( & %-(. (-$# /" #$&%). ;#, '$ &$ .
( -" Microsoft Excel. 5'$0, +) &$%, *,$$
,&& & ,, $&41$$ ,&$ $ &'$0$2 %-(.,.
, 4$%$ /,'22 '$ -/(. $$"*, '$ %&.
%$ $ * ,&$ $ )&'$$ -$& $&%,+, %!2
$ ,$ -$ /, $ &%$. + *,$$ --0&$" -'(*,'2,
&'$0$2 &)$ ,&$2, - $ -+ +.
%, '2 ,, $)&" $&41$$ , %-(. &)$ $(:
• &'(&+ %-(.+ &,'&&+ -% Microsoft Office
• $$"* $'$ %& 4 0 $'$ '$*% % &
• $ "& $'$ ,% '2 %$ $ %$,&$2
4$0%$) 4"',
3.1.3 %/% 1!
, 0$',"/%," $&41$$ +0& -$*,$2 -/(.
-+ Microsoft Excel , ,$ '$1, 4 %+) ,, 4
4"', "&. )$2 $&41$2 $*,'%2 $* -,$0&+) '$0%$)
$',, ,&( %+) & ,+*+, &&$2. /, . 2 -):
• &41$2 ,,$2 , ,$, , % &
!$2 , -,$0&" % &1$$. 3 -) &%'(%
%2 &&, '$ . *&$2 & 0&(
%,'$4$1$,&&+" -&'.
• '$1+ ,,22 , 4, ,, ./ 4"'
$+ "&.
40
8/ , $-'(* . -,+" -). ' ,, $ -,%$ $&41$$
& -* 2 , +" 4 &-,&& , - Excel, *
,,$2 , "&. 5% -,$' '2 %! ,$ -,&$2 *.2 &%'(%
'(&+) '$1 :
1. %,!$&+:
9"' %$& (, ('. 3.1).
9"' $&%'$&$$ ('. 3.2).
9"'+ -,&$2, '$'$$, %!, $'$$
$ .-.('. 3.3, 3.4).
2. ,)&&+ ,+%$ (%&,+, &#$ $ .-.):
• 5' %#"%$) 0% - ,+%
('. 3.5)
&&+ -,&$2 $ $ )%$$%$ ,+%
('$'$2, $4$2, %&$% $ ..) – ('. 3.3, 3.4).
3. -,&&+ -*&+ ,+%$:
• 5' %#"%$) 0% - ,+%
('. 3.5).
&&+ -,&$2.
&&+ -,&$2 $ $ )%$$%$ ,+%
('$'$2, $4$2, %&$% $ ..) – ('. 3.3, 3.4).
'$1 3.1. 5$&+ (, %,!$&
%,!$&+*
(BHID)
X-%$&**
(XCOLLAR)
Y-%$& **
(YCOLLAR)
Z-%$&
(ZCOLLAR)
*- %,!$&+ ' 0# ,,$( , %, 4 $-'(*,&$ ,)
%, $ $,',, %+ $-'(*,&+ , -,$0&" % &1$$. '2 '0&$2
&$- '21$$ $ -' , / & *,( -'&$'(& 1$4,
-', , % & $-'(*,( -$&2 . -'(*,' %$,% &,
*,0&+) ,+%
**- $ "& $-'(* 2 &&2 $&1$2 %$&&+)
": X – &-,'& & %, Y – & ,. '$ , -,$0&" % &1$$
-$&2 2 $&1$2 ", &)$ -$,$ , ,,$
"&. 3 '2 $*&&$ $& ,, ./$) -'" '$1+.
'$1 3.2. &&+ $&%'$&$$
%,!$&+*
(BHID)
2&$ (2
0%$ ***
(AT)
*$ ***(BRG) $%'(&+"
'****(DIP)
*- %,!$&+ '!& +( $&%,+ , ,) 4"'). '$
-2& +" , $) '$1) & ,+%$ , , '$1
$&%'$&$$, & - '0&$. 0$2 &-,'&&" ,$%'(& ,&$*
**- 5!2 ,+% , " '$1 '!& $( -, . 0% * ,
(, .. AT1=0.
***- 3 ' $*22 0 360 , - 0," '%
,& &-,'&$2 (( Y). . '!& ,,$2 $$&&+" *$
--,%" & ,'$0$& &$& %'&&$2.
****- $%'(&+" ' $*22 0 ($*&'(&2 -'%() 90
, (,$%'( – ,&$*) $'$ -90 , (,$%'( – ,,)). 8 ,
-,$0&+) $') $ '+ $*2. ,$%'$, - -$ '.
&&$$ ' -,2( $&1$. ,+%$ & 4$% $ -$
&)$$ – -0$+,( '.
'+ , -,$0&" % &1$$ 0 $*2.2 , )/$& ). $
"& $-'(* $ ',+ ,'$0$&+ , ,$ 2$0&+) ", - '2