27
, bi | ||||
, .-. | a11 =0,1 | a12= 0,2 | a13 =0,4 | b1= 1100 |
, 2 | a21 = 0,05 | a22 = 0,02 | a23=0,02 | b2 =120 |
, . | a31 = 3 | a32 = 1 | a33 =2 | b3 =3000 |
, . | C1 = 3 | C2 = 5 | C3= 4 | |
, . | X1=? | X2=? | X3 =? |
:
- , , , .
.: =2*$$2+2.
.: =D2*E2.
. 30000 . . 75 . 䳿: - :
- = $F$11;
- = 30000;
- = $$2.
:
2. , , .
:
G6: =F6*B6*!$B$4
H6: =F6*C6*!$B$5
I6: =F6*D6*!$B$6
J6: =F6*E6*!$B$7
K6: =(G6:J6)
L6: =F6*!$B$9
M: =F6*!$B$15
N: =F6*!$B$17
O: =(L6:N6)
Q: =P6/F6
R: =K6-O6
S: =R6/F6
T: =P6*S6
ֳ : 6 8.
P6 P8 : - . $$6. 볭, ( $$6). . :
$$6<=!$$11,
$Q$6<=!$$13,
$P$6=int,
$$6>=0.
ϳ .
$$7. 볭, ( $$7). . :
$$7<=!$$11,
$Q$7<=!SB$13,
$P$7=int,
$$7>=0.
ϳ .
$$8. 볭, ( $$8). . :
$$8<=!$$11,
|
|
$Q$8<=!$$13,
$P$8=int,
$$8>=0.
ϳ .
T9 =(T6:T8)
ʳ, | |||||
1 | 2 | ||||
25% | 20% | 45% | 10% | 1,0 | |
50% | 27% | 13% | 10% | 0,6 | |
63% | 18% | 9% | 10% | 0,3 | |
, . | ||||
1 | 2 | |||
80,00 | 52,00 | 99,00 | 6,00 | 237,00 |
96,00 | 42,12 | 17,16 | 3,60 | 158,88 |
60,48 | 14,04 | 5,94 | 1,80 | 82,26 |
, 1 | , | , | , . | |||||
. | ||||||||
150,00 | 25,00 | 13,00 | 188,00 | 49,00 | 49,00 | 156 800,00 | ||
90,00 | 15,00 | 7,80 | 112,80 | 46,08 | 76,80 | 193 536,00 | ||
45,00 | 7,50 | 3,90 | 56,40 | 25,86 | 86,20 | 108 612,00 | ||
193 536,00 |
- MS Excel .
6 . :
=(B6*B7;C6*C7;D6*D7).
:
- 6; - $B$7:$D$7;
:
:
$B$7 <= ($E$3-$C$3*$C$7-$D$3*$D$7)/$B$3
$B$7 <= ($E$4-$C$4*$C$7-$D$4*$D$7)/$B$4
$B$7 <= ($E$5-$C$5*$C$7-$D$5*$D$7)/$B$5
:
$C$7 <= ($E$3-$B$3*$B$7-$D$3*$D$7)/$C$3
$C$7 <= ($E$4-$B$4*$B$7-$D$4*$D$7)/$C$4
$C$7 <= ($E$5-$B$5*$B$7-$D$5*$D$7)/$C$5
:
$D$7 <= ($E$3-$B$3*$B$7-$C$3*$C$7)/$D$3
$D$7 <= ($E$4-$B$4*$B$7-$C$4*$C$7)/$D$4
$D$7 <= ($E$5-$B$5*$B$7-$C$5*$C$7)/$D$5
䒺:
$B$7:$D$7 >= 0
:
, . 15000.
: ' , .