, , , , (, , ).
: , , , , .. , , : , - 80 (/), 480 () 130 (/). . , , , , 1.
1
(.) |
, , .
1,2,3,X4 .
- .
- , : F(x) = 3X1 + 42 + 3 + 4.
71 + 22 + 23 + 64 <= 80,
51 + 82 + 43 + 4 <= 480,
21+42 + + 84<=130,
1, 2,,4>=0.
- EXCEL, . " , , .
(Add-Ins) (Solver- ADD-in).
() :
1. .
2. , ( ).
3. .
4. .
5. .
6. ( ).
7. .
8.
(. . 1). . 1 .
A | B | C | D | E | F | G | H | |
1 | 2 | 3 | 4 | |||||
. | ||||||||
|
|
. 1.
1. ( ) = (1, 2, X3, 4) :, - F4.
2. . , . 2.
A | B | C | D | E | F | G | H | |
1 | 2 | 3 | 4 | |||||
. | ||||||||
<= | ||||||||
<= | ||||||||
<= |
. 2
3. ( 1 ):
F4.
(Insert Function).
M1. 1 2.
(Or select a category) (Math & Trig).
M1.
(SUMPRODUCT).
M1.
1 ( , , ) - $3:$3.
2 4:4.
. : F4 , .3.
.3. .
5. :
F4.
.
F7.
.
F8.
.
F9.
.
.
(Tools) => (Solver) (Solver Parameters).
, :
- (Set target cell)
- (By Changing cells)
- (Subject to the Constraints)
. . . , , . .
|
|
- . - , , . 200 . : , . , . .
6. ( ).
- .
- $F$4.
- : . :
- .
- : $3:$3.