軟體:Microsoft office
版本:2003
the southfork feed company makes a feed mix from ingredients-oats
,corn,soybeans,and a vitamin supplement.The company has 300 pounds of
oats,400 pounds of corn,200 pounds of soybeans,and 100 pounds of vitamin
supplement available for the mix.The company has the following requirement
for mix:
1.at least 30% of the mix must be soybeans.
2.at least 20% of the mix must be the vitamin supplement.
3.the ratio of corn to oats cannot exceed 2 to 1.
4.the amount of oats cannot exceed the amount of soybeans.
5.the mix must be at least 500 pounds.
a pound of oats costs$0.5;a pound of corn,$1.2;a pound of soybeans,$0.6;and a
pound of vitamin supplement,$2.The feed company wants to know the number of
pounds of each ingredient to put in the mix in order to minimize cost.
題目我寫的出來目標函數跟限制式
X1=oats的數量
x2=corn的數量
x3=soybeans的數量
x4=vitamin supplement的數量
目標函數
min Z=0.5X1+1.2X2+0.6X3+2X4
限制式
1.x1<=300
2.x2<=400
3.x3<=200
4.x4<=100
5.0.7x1-0.3x2-0.3x3-0.4x4>=0
6.-0.2x1-0.2x2-0.3x3+0.8x4>=0
7.x2<=2x1
8.x1<=x3
9.x1+x2+x3+x4>=500
我也會跑excel的規劃求解
但是我不會填儲存格orz(兩個變量的我會到了多變量我就掛了)
5,6,7,9我不知道怎麼填到儲存格
有沒有人會教一下...
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 218.166.9.44
※ 編輯: browine 來自: 218.166.9.44 (11/04 21:09)