Question: Consider The Bic Mac Attack Problem from the class slide. You may download the excel input from compass. Suppose you wish to select a nutritionally

Consider "The Bic Mac Attack" Problem from the class slide. You may download the excel input from compass. Suppose you wish to select a nutritionally complete diet consisting of foods taken from this menu at the least cost. Specifically, suppose you would like to design a diet that provides at least 100% of the U.S.RDA (recommended daily allowance) 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 provides at most 30% of its calories from fat. (Fact: 1 gram of fat contains 9 calories.) a.) Using Excel Solver, determine the least cost daily diet that satisfies all of the nutritional requirements mentioned above. (Hint: We also have to make sure that solver doesn't assign decimals to something that we must buy in whole units)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
