lp problem

Project Description:

tuckered outfitters 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 ingredients:

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 2-pound package. additionally, they want each ingredient to account for at least 5% and no more than 50% of the weight of the package.

a) formulate an lp model for this problem. define the decision variables, formulate the objective function and formulate the constraints (5 points).

b) implement your model in a spreadsheet and solve it. solver. provide the spreadsheet and state what the optimal solution is (5 points).
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 6
1 Current viewersl
872 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.6
    490 Jobs 297 Reviews
    $30 in 0 Day
  • 4.4
    60 Jobs 42 Reviews
    $0 in 0 Day
  • 4.6
    648 Jobs 468 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day