查看完整版本 : 線性規劃(LP) 2

ryan468 2015-9-21 08:11 PM

線性規劃(LP) 2

[size=12.0pt][size=12.0pt]Hello,各位好,又係我呀[/size][/size]
[size=12.0pt][size=12.0pt]上次嗰題我應該解決左[/size][/size]但係今次哩題我真係無從入手,有無師兄可以幫忙解答下
[size=12.0pt][size=12.0pt]個a問究竟應該點列出黎[/size][/size]:smile_24:

[font="][size=12.0pt]Tuckered Qutfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips,Peanuts, and Almonds costing, respectively, $2.50, $1.50, $2.00, $3.50 and$3.00 per pound. The vitamin, mineral and protein content of each of the ingredients (in grams per pound) is summarized in the following table along with the calories per pound of ingredient:[/size][/font]
[table][tr][td=1,1,103]  

  [/td][td=1,1,103]  
[align=center][b][font="][size=12.0pt]Raisins[/size][/font][/b][/align]
  [/td][td=1,1,103]  
[align=center][b][font="][size=12.0pt]Grains[/size][/font][/b][/align]
  [/td][td=1,1,103]  
[align=center][b][font="][size=12.0pt]Chocolate[/size][/font][/b][/align]
  [/td][td=1,1,103]  
[align=center][b][font="][size=12.0pt]Peanuts[/size][/font][/b][/align]
  [/td][td=1,1,103]  
[align=center][b][font="][size=12.0pt]Almonds[/size][/font][/b][/align]
  [/td][/tr] [tr][td=1,1,103]  [font="][size=12.0pt]Vitamins[/size][/font]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]20[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]10[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]10[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]30[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]20[/size][/font][/align]
  [/td][/tr] [tr][td=1,1,103]  [font="][size=12.0pt]Minerals[/size][/font]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]7[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]4[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]5[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]9[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]3[/size][/font][/align]
  [/td][/tr] [tr][td=1,1,103]  [font="][size=12.0pt]Protein[/size][/font]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]4[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]2[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]1[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]10[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]1[/size][/font][/align]
  [/td][/tr] [tr][td=1,1,103]  [font="][size=12.0pt]Calories[/size][/font]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]450[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]160[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]500[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]300[/size][/font][/align]
  [/td][td=1,1,103]  
[align=center][font="][size=12.0pt]500[/size][/font][/align]
  [/td][/tr][/table]
[font="][size=12.0pt] [/size][/font]
[font="][size=12.0pt]The company would like to identify the least costly mix of these ingredients that provides at least 40 grams of vitamins, 15 grams of minerals, 10 grams of protein, and 600 calories per [color=#ff0000]2-pound[/color] package. Additionally, they want each ingredient to account for at least 5% and no more than 50% of the weight of the package.[/size][/font]
[font="][size=12.0pt]a.[/size][/font][font="][size=12.0pt]Formulate an LP model for this problem[/size][/font][font="][size=12.0pt].[/size][/font][font="][size=12.0pt][/size][/font]

[[i] 本帖最後由 ryan468 於 2015-9-21 08:21 PM 編輯 [/i]]

boyson 2015-10-7 11:23 AM

用excel solver會幫到你

教學上youtube睇
頁: [1]
查看完整版本: 線性規劃(LP) 2