Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 chicken

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Optimization Of Logistics And Supply Chain Systems Theory And Practice

Authors: Turkay Yildiz

1st Edition

1540716198, 978-1540716194

More Books

Students also viewed these General Management questions

Question

Does the organizations name resonate with people in the community?

Answered: 1 week ago