Examlex
Project 3.1 − The Diet Problem: Ordering Meals from McDonald's
Based on: Robert A.Bosch,"Big Mac Attack: The Diet Problem revisited,Eating at McDonald's," OR/MS Today,
August 1993,pp 30-31.
Tina Simpson is a new fourth-grade teacher at Forest Ridge Elementary.The first teacher workshop for the upcoming school year is next Monday and by majority vote,McDonald's was selected as the food of choice.As the new person,Tina is tasked with developing the meal for the workshop.McDonald's has graciously offered to deliver whatever food Tina decides to order,along with a variety of condiments applicable to whatever is ordered.Rather than offer a menu choice,Tina has decided to simply order the same meal for each person in the workshop.
To get started,Tina took a trip to McDonald's and obtained their published information on the nutritional content of their food.That data is summarized in the table below.
Tina wants the meal to be nutritionally complete.The National Research Council publishes their Recommended Daily Allowances.In this publication,they contend that a diet in this case the meal)should provide at least 100 percent of the U.S.RDA of numerous nutrients.The specific amount of the RDA depends on such factors as age,weight and gender.In addition,the council recommends daily sodium and cholesterol intakes be kept to at most 2.4 grams of sodium and 300 milligrams of cholesterol.Further,at most 30 percent of the calories consumed should come from fat,and at most 10 percent from saturated fat.Each gram of fat contains 9 calories.
Based on the above information,Tina wants to design a least-cost meal that provides at least 100% of the U.S.RDA of vitamins A,C,B1,B2,niacin,calcium,and iron;supplies at least 55 grams of protein;contains at most 3 grams of sodium;and contains at most 30 percent of its calories from fat.Only those foods list in the table above are available for the meal.
Formulate the LP model for Tina's problem.Develop a spreadsheet model of the problem and use Excel Solver to determine the least-cost meal that meets all the stated requirements.
What is the recommended meal? Is this meal reasonable? If not,modify the model to obtain what you believe to be a reasonable meal that meets the stated requirements.
Exchange Programs
Organized programs that allow individuals, typically students, to study or work abroad.
Global Leadership Competencies
The skills and abilities required to effectively lead and manage across different cultures and international borders.
Flexibility
Flexibility in the context of work refers to the ability and willingness to adapt to change, including changes in job roles, work hours, and workplace location.
Multicultural Experiences
Interactions and engagements that expose individuals to cultures other than their own, promoting understanding and diversity.
Q7: The regression residuals are computed as<br><br><br>A)
Q17: In the European Union, the Fourth and
Q20: Why do we create a scatter plot
Q20: According to the deductive approach to accounting
Q28: The EU 4th and 7th Directives require<br>A)
Q31: The company would like to build a
Q35: Research and development costs<br>A) are generally written
Q36: Cash flow statements<br>A) are required by the
Q55: Refer to Exhibit 10.1.Suppose that for a
Q65: An office supply company is attempting