Examlex
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.
Manufacturing Business
This type of business produces goods from raw materials through a combination of manual labor and machines.
Finished Goods Inventory
Manufactured products that are complete and ready for sale but have not yet been sold to customers.
Ready For Sale
Inventory items that have completed the production process and are available for purchase by consumers.
Current Asset
A current asset is a resource owned by a company that is expected to be converted into cash, used, or consumed within one year or within the operating cycle of the business.
Q3: Refer to Exhibit 8.2. What values would
Q39: An investor has $500,000 to invest and
Q40: <br>Handel Manufacturing produces test stands for
Q57: The regression approach can be used in
Q60: In the figure above, Lourdita faces a
Q62: What is the soft constraint form
Q63: An oil company wants to create lube
Q72: Refer to Exhibit 3.3. What formula should
Q150: In an ad for insurance, the text
Q224: Travel insurance (which pays a traveler if