Question: ( 0 3 ) A diet problem: Determine the optimal selection of proportions of foods from the list of foods provided in the table below,
A diet problem: Determine the optimal selection of proportions of foods from the list of foods provided in the table below, by answering the following questions. Note that g stands for grams.
Let x x x x x and x be the optimal proportions units of foods from Bread, Milk, Cheese, Potato, Fish and Yogurt, respectively.
a Protein intake: the total protein intake should be less than or equal to g Write down a constraint mathematically for protein intake.
b Carbohydrate intake: required minimum is g Write down a constraint mathematically for carbohydrate intake.
c Fat intake: required minimum is g Write down a constraint mathematically for fat intake.
d Write down all the nonnegativity constraints.
e Additional Constraint Fish: the diet should contain at least units of fish. Write down a constraint mathematically to explain the requirement.
f Additional Constraint Milk: the diet should contain less than or equal to unit of milk. Write down a constraint mathematically to explain the requirement. g Total calorie intake: required minimum is calories. Write down a constraint mathematically for total calorie requirement.
h Objective function is the Total Cost: write down the objective function mathematically and indicate if it should be maximized or minimized.
i Solve the problem using the Simplex Method in MS Excel. Completely explain the solution obtained.
The cost of transportation per truck load from each of the six factories to each of the warehouses is given in the matrix below. Determine the optimal transportation plan using the Simplex Method in MS Excel. The Excel file with the dataset is available on Canvas for your convenience. You do not need to upload Excel output as a part of your answer. Clearly explain the answer obtained
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
