※ 引述《browine (ich?)》之铭言： : 软体: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 抱歉我还没用过规划求解 也好久没做这样的题目了 因此想请问5.6.二式为何不是 0.7x3-(x1+x2+x4)*0.3>=0 0.8x4-(x1+x2+x3)*0.2>=0 : 7.x2<=2x1 : 8.x1<=x3 : 9.x1+x2+x3+x4>=500 : 我也会跑excel的规划求解 : 但是我不会填储存格orz(两个变量的我会到了多变量我就挂了) 多变量的其实也就是两个array相乘对吧 我没做过不敢保证，但观念上就像是 {-0.3,-0.3,0.7,-0.3}*{x1,x2,x3,x4} : 5,6,7,9我不知道怎麽填到储存格 : 有没有人会教一下... : 谢谢 google EXCEL 规划求解 第一篇 http://yes.nctu.edu.tw/Lecture/PC/Office/Excel/Tutor/Solution/Example/Exam1/Index.htm 缩 http://kuso.cc/2U4I 不知有无帮助^^" --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 122.123.42.89