1. , . 2.6.
. 2.6.
1:4 . 6:9 ( ). G6:G9 , 11:11 . F10 =(1:4; 6:9).
10:10
=(6:9)
=(6:9)
=(6:9)
=(D6:D9)
=(6:9), , .
F6:F9
=(6:6)
=(7:7)
=(8:8)
=(9:9), , .
2. / (Tools/Solver) (Solver), . 2.7.
! (Solver Options) (Assume Linear Model).
. 2.7.
3. (Solve) (. 2.8).
. 2.8.
1. .
2. MS Exscel .
3. .
1
(. 2.15).
2.15
1 | 2 | 3 | 4 | ||
1 | |||||
2 | |||||
A3 | |||||
2
, . 100, 150 50 c. . . 75, 80, 60 85 . . 1 . . :
, .
3
120, 110 130 . 1, 2, , 4 5. 80, 60, 70, 100 50.
, .
4
Royal Wedgetoun Pottery (, ). , . :
|
|
, | |
, . . . 2.16 (. .) :
2.16
1,20 | 1,30 | 1,10 | |
1,40 | 1,30 | 1,50 | |
1,10 | 1,00 | 1,30 |
, , 3000 , 2000 .
, , , . .
, , . , , ?
5
Orange Computer , . , , , , , , . , , . , , - , . . 2.17 - (. .):
2.17
, , - , , . : 230 . . , 235 . . , 225 . . 240 . . . 150 . . 155 . . .
, , - .
, , 850, 640, 380 230 . 625, - 825, 450 . , . .
|
|
6
(. 2.18).
2.18
7
. , , :
= (300; 350; 150; 200)
= (400; 400; 200)
8
. , , :
= (20; 30; 40; 20)
= (40; 40; 20)
9
(. 2.19):
2.19
10
(. 2.20):
2.20
11
(. 2.21):
2.21
12
(. 2.22):
2.22
13
(. 2.23):
2.23
14
(. 2.24):
2.24
15
(. 2.25):
2.25
1. ?
2. ?
3. ?
4. ?
5. ?
6. MS Excel.
|
|
7. MS Excel.
8. MS Excel?
9. .
10. .