1. , . 8.6.
1:4 . 6:9 ( ). G6:G9 , 11:11 . F10 =(1:4;6:9).
. 8.6.
10:10
=(6:9)
=(6:9)
=(6:9)
=(06:9)
=(6:9) , .
F6:F9
=(6:6)
=(7:7)
=(8:8)
=(9:9) , .
2. / (Tools/Solver) (Solver), .8.7.
! (Solver Options) (Assume Linear Model).
.8.7.
3. (Solve) (. 8.8).
.8.8.
1. , .
2. MS Exscel .
3. .
1
(.8.15):
8.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" (, ), . :
|
|
, | |
, . . . 8.16 (. .) .
8.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 - (. .):
8.17
"" | "" | "" | "" | |
, , - , , . : 230 . . , 235 . . , 225 . . 240 . . . 150 . . 155 . . .
, , - .
, , 850, 640, 380 230 . 625, - 825, - 450 . , . .
|
|
6
(.8.18).
8.18
7
. , - , - :
= (300; 350; 150; 200)
= (400; 400; 200)
8
. , - , - :
= (20; 30; 40; 20)
= (40; 40; 20)
9
(. 8.19).
8.19
10
(. 8.20).
8.20
11
(. 8.21).
8.21
12
(. 8.22).
8.22
13
(. 8.23).
8.23
14
(. 8.24).
8.24
15
(. 8.25).
8.25
:
1. ?
2. ?
3. ?
4. ?
5. ?
6. MS Excel.
|
|
7. MS Excel.
8. MS Excel?
9. .
10. .