Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SOLVE IT IN EXCEL ONLLYY DO NOT TELL ME JUST THE EXPLANATION.. I NEED THE SOLUTION IN EXCEL WITH PICTURES OF IT INCLUDING THE FORMULA
SOLVE IT IN EXCEL ONLLYY DO NOT TELL ME JUST THE EXPLANATION.. I NEED THE SOLUTION IN EXCEL WITH PICTURES OF IT INCLUDING THE FORMULA YOU USE!! and do not forget to add the additional constraints as shown in the Q5
Consider the diet problem summarized in the following table. In this table, different food items available in a Mac Donalds restaurant are displayed in column A. Column B contains the selling prices of these food items (in dollars), and columns C, D, E and F contain their calories, protein contents (in grams), fat contents (in grams) and sodium contents (in milligrams), respectively. Columns G, H, I, J, K,L and M display various vitamin and mineral contents of the said food items (in % of Required Daily Allowances - RDA). Given that a "healthy" daily diet must contain, i) at least 55 grams of protein; ii) at most 3000 milligrams of sodium; iii) at least 100%RDA of vitamin A; iv at least 100%RDA of vitamin C; v) at least 100% RDA of vitamin B1; vi) at least 100% RDA of vitamin B2; vii) at least 100% RDA of Niacin; viii) at least 100% RDA of Calcium; ix) at least 100% RDA of Iron; and that in such a healthy diet, x) no more than 30% of all calories should come from fat (1 gram of fat contains 9 calories); which food items (and how many) should be selected for daily consumption, in order to optimize various objectives, while satisfying the above constraints. * This problem is based on the article "Big Mac Attack Revisited", by E. Erkut, which appeared in OR/MS Today, pp. 50-52, June 1994. 5. (20 pts) Analysing the Excel Solver results, comment on including additional constraints to develop a "reasonable" diet, such as, - Either Egg McMuffin or Wheaties (for breakfast); - One order of French fries with each burger; - At least three drinks (milk or juice); - One milk with each Wheaties; - No more than two Wheaties; - In addition to any milk taken with Wheaties, at least two more drinks (milk or juice); - At least one salad; - No more packages of honey than the number of chickenStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started