[算表] solver 規劃求解問題

看板Office作者album1129 (不一樣!我比較帥!)時間13年前 (2013/03/19 02:55)推噓1(1推 0噓 0→)

留言1則, 1人參與討論串1/1

軟體:excel solver 版本:2010 小弟我這有個題目 Tune-well radio company produces three models A, B and C of radio in three production plants 1, 2 and 3. The available machine hours and labour hours per month in the three plants are given below. Plant Available machine hours Available labour hours 1 2400 4000 2 3000 5000 3 2000 2500 The amount of machine hours and labour hours required to produce one unit of each model of radio and the unit profits for each model are given below Model Required machine hours/unit Required labour hours/unit Profit($) A 3.0 4.0 15 B 2.0 4.5 10 C 2.5 3.0 13 Radio company wants to utilise equal percentage of available labour hours in each plant. Company policy is that between 20% and 40% of total production should be model A radios ,at least 30% of production should be model B radios and at most 25% of production should be model C radios. Company has outstanding monthly orders for 500 model A radios, 800 model B radios and 700 model C radios. 我列個9個未知數 plant 1生產的 model A1, B1, C1 plant 2生產的 model A2, B2, C2 plant 3生產的 model A3, B3, C3 Max: 15*(A1+A2+A3)+10*(B1+B2+B3)+13*(C1+C2+C3) 列了16個限制式 1) 3A1 + 2B1 + 2.5C1 <= 2400 2) 3A2 + 2B2 + 2.5C2 <= 3000 3) 3A3 + 2B3 + 2.5C3 <= 2000 4) 4A1 + 4.5B1 + 3C1 <= 4000 5) 4A2 + 4.5B2 + 3C2 <= 5000 6) 4A3 + 4.5B3 + 3C3 <= 2500 7) (4A1 + 4.5B1 + 3C1)/4000 = (4A2 + 4.5B2 + 3C2)/5000 8) (4A2 + 4.5B2 + 3C2)/5000 = (4A3 + 4.5B3 + 3C3)/2500 9) (4A3 + 4.5B3 + 3C3)/2500 = (4A1 + 4.5B1 + 3C1)/4000 10) (A1+A2+A3)/(A1+A2+A3+B1+B2+B3+C1+C2+C3)>= 0.2 11) (A1+A2+A3)/(A1+A2+A3+B1+B2+B3+C1+C2+C3)<= 0.4 12) (B1+B2+B3)/(A1+A2+A3+B1+B2+B3+C1+C2+C3)>= 0.3 13) (C1+C2+C3)/(A1+A2+A3+B1+B2+B3+C1+C2+C3)<= 0.25 14) A1+A2+A3 >= 500 15) B1+B2+B3 >= 800 16) C1+C2+C3 >= 700 用GRG可以求的出來但是用simplex LP卻顯示錯誤表示我這是非線性的無奈我需要影子價格但是我卻一直找不出錯誤阿?! 懇請各位前輩幫我看出哪裡錯誤了謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 27.32.124.18 ※ 編輯: album1129 來自: 27.32.124.18 (03/19 02:57) ※ 編輯: album1129 來自: 27.32.124.18 (03/19 03:11)