n , m (, , ). i- (i {1, 2,..., n}) i j- (j {1, 2,..., m}). bj (j {1,2,..., }) . i i- (i {1, 2,..., n}).
, , , , .
: i- .
:
(4)
Ƨ :
(5)
x1,x2,,xn ≥ 0 (6)
MS Excel .
, : , , , , , , (n = 7), , , (m = 3).
: 1 = 2060, 2= 2430, 3= 3600, 4= 890, 5= 140, 6= 230, 7 = 650. .
: b1 = 100, b2= 70, b3 = 400.
c MS Excel .
/ | |||||||
.
:
20601+24302+36003+8904+140X5+230X6+650X7=Fmin ( ).
{611+2202+2303+154+8X5+11X6+2X7 >= 100
{121+1722+2903+4 +X5+2X6+6X7 >=70
{4201+2124 +26X5+38X6+155X7 >=400
x1,x2,,xn ≥ 0, n=7
.
:
1. A1:I1, A2:A7, B4, I4, J4.
|
|
2. : : 1 = 2060, c2 = 2430, c3 = 3600, c4 = 890, c5 = 140, c6 = 230, c7 = 650.
3. I2 : = (B2:2;B3:H3), (4).
4. 5:7 , .
6.4
5. J5:J7 , : b1=100, b2= 70 b3 = 400.
6. I5 : =($B$2:$H$2;5:5), (5).
7. , I5, I6 I7.
8. MS Office Excel (pc. 6.4).
: .