Solution-Formulate a lp model for problem

Formulate a lp model for problem

Assignment Help Business Management

Reference no: EM131044000

Question:

Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisin, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively, $2.50, $1.50, $2.00, $4,00 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:

	Raisins	Grain	Chocolate	Peanuts	Almonds
Vitamins	20	10	10	30	20
Minerals	7	4	6	9	3
Protein	4	2	1	10	2
Calories	450	160	500	300	500

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.

Formulate a LP model for this problem. Show your answer in below.
Implement your model in a spreadsheet and solve it. Submit your answer along with the spreadsheet which indicating the optimal solution.
In your own words, what's your recommendation for this company (i.e., what's the optimal solution)?

Reference no: EM131044000

Questions Cloud

Create a bootstrap page that has one column layout : Create a bootstrap page that has one column layout on smartphones, two column layouts on medium size devices and three columns on all other devices. Color each block using different background colors.

Describe an instance where you not have experience with gui : Describe an instance where you did not have an intuitive experience with a GUI. Recommend the key areas that could have been improved.

Putting creativity techniques into practice : Write a brief message to your instructor in which you outline an action plan for either developing your own creativity or fostering a greater level of creativity in your workplace. Be sure to include measurable goals. Some examples of measurable g..

Compare the cost of the truck to the cash flow records : Explain how Stephanie should convince her mother that it is inappropriate to call the bank manager and his wife for assistance in getting the loan approval?

Formulate a lp model for problem : Formulate a LP model for this problem. Show your answer in below. Implement your model in a spreadsheet and solve it. Submit your answer along with the spreadsheet which indicating the optimal solution. In your own words, what's your recommendation ..

Following trig function indicatng range and period : GRAPHS: Sketch the following trig function indicatng range and period T= 2π/freq

Describe the product or service offering : Evaluate the potential growth rate. Look for information on similar products or services to come up with a growth rate over three years; this may be adjusted in later revisions.

What total load will steel shore be able to carry : What total load will a AS 550 steel shore be able to carry if the outside diameter is 2.5 inches and a wall thickness of 0.154 inches

Comprehensive essay to a group of business people : Because price has such a profound impact on a firm's success, finding the right pricing strategy is crucial. Assume you are a marketing consultant write a comprehensive essay to a group of business people in the US Virgin Islands interested in kno..

User Account

All Pages

Formulate a lp model for problem

Reference no: EM131044000

Reference no: EM131044000

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Explain the organizational design of southwest airlines

Third party authorityif a principal hires an agent to

What number best represent your view

Compute the person-hours devoted to ibm''s team projects

Raise new partnerships with technology partners

Including your spss output

Explain why knowing also using the systems approach

Concept of assumption of cultural homogeneity

Perceived values of customer basehow should the perceived

Integrated marketing communications

Explain absolute- and relative-rating approaches

What do you think about multiple selveswhen you think about

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT