Formulate an lp to answer question

Assignment Help Business Management

Reference no: EM132094001

After consulting with nutritionists, we decree that a satisfactory diet has at least 2000 kcal of energy, 55 g of protein, and 800 mg of calcium (vitamins and iron are supplied by pills). We have decided to impose variety by having a limit on the number of servings/day for each of our six foods.

What is the least cost satisfactory diet?

a) Formulate an LP to answer this question.

b) Solve this model using Excel Solver. Provide:

I. The optimal solution and the optimal objective function value.

II. Answer and Sensitivity reports.

III. What are the binding constraints?

IV. What are the shadow prices corresponding to energy, protein and calcium constraints?

Reference no: EM132094001

Questions Cloud

Design and implement two classes that define progression : A numeric progression is a sequence of numbers, where each number depends on one or more of previous numbers.

Some additional context for the feasibility analysis : Feasibility Analysis: The purpose of this analysis is whether or not to add more or less resources in a business model.

Would you approve the proposed strategy : Post a polished and integrated analysis that answers this question: If you were on the board of directors at The Weather Company in 2013

Which command do you use to restart server core : You approach one of your servers running Server Core and see a completely blank desktop except for the mouse pointer.

Formulate an lp to answer question : We have decided to impose variety by having a limit on the number of servings/day for each of our six foods. What is the least cost satisfactory diet?

Accounting procedures and busines decisions : How do Amazon's financial and strategic priorities affect accounting procedures and busines decisions? How might that affect business success?

Accounting website search page : Select one of the wbsites listed under the Accounting Website Search page and give a summary of information provided on the site

What would your plans and steps for intervention include : Create a PowerPoint presentation to illustrate your plan of action. What would your plans and steps for intervention include

Describe how team dynamics impact performance : Describe how team dynamics impact performance. Provide specific examples of what operations managers do.

User Account

All Pages