8.3.1.
MS Excel . 8.4.
MS Excel , , (. 8.5).
8.4.
% | % | ||||||
A | B | C | D | E | F | G | H |
=D5-C5 | =E5*100/ D5+100 | =B5-C5 | =G5*100/ D5+100 | ||||
=D6-C6 | =E6*100/ D6+100 | =B6-C6 | =G6*100/ D6+100 | ||||
% | 16,38 | 16,5 | 16,35 | =D7-C7 | =E7*100/ D7+100 | =B7-C7 | =G7*100/ D7+100 |
=D8-C8 | =E8*100/ D8+100 | =B8-C8 | =G8*100/ D8+100 | ||||
% | 67,24 | 66,67 | 67,46 | =D9-C9 | =E9*100/ D9+100 | =B9-C9 | =G9*100/ D9+100 |
- | - | - | - | - | |||
=D11-C11 | =E11*100/ D11+100 | =B11-C11 | =G11*100/ D11+100 | ||||
- | - | - | - | - | |||
, - | =D13-C13 | =E13*100/ D13+100 | =B13-C13 | =G13*100/ D13+100 | |||
- | 24,36 | 25,25 | =D14-C14 | =E14*100/ D14+100 | =B14-C14 | =G14*100/ D14+100 | |
=D15-C15 | =E15*100/ D15+100 | =B15-C15 | =G15*100/ D15+100 |
8.3.2.
, - . .
. 8.5 , 400 . . 9500 10200 . ., 7,4 %; 800 . . 9700 10500 . ., 8,2 %; 500 . . 6700 7200 . ., 7,5 %.
8.5.
.
1. 5000. . 58000 63000 . 819 . .: 16,38∙5000/100 = 819.
2. 0,22 % 67,24 67,64 % 138,6 . ., 138,6 . .: 0,2263000/100 = 138,6
3. % 0,03 16,38 16,35 % 18,9 . .: 0,03∙63000/100 = 18,9. 819 - 138,6 + 18,9 = 699,3 . .
|
|
4. 70 . . 180 250 70 . .
5. 35 . .
6. 5 . . 10 15 . . 5 . .
: 699,3 + 70 + 35 = 799,3 ..
7. , , 300 . . 3000 3300 300 . .
: 799,3 300 = 499,3.
0,36 % 24,36 24 % 1,25 % 25,25 24 %. , 36 . 1. 25 . ,
(-0,36 ∙ 42500/100) = 153 . . (-1,25∙42500/100) = 531,3 . .
, 260 . . (7200 - 6940), 3,7 %. . , .
: . .