軟體: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)