Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entrées for consumption by its clients. The entrées are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entrée will be a beef sirloin tips dinner. It will consist of beef tips and gravy, plus some combination of peas, carrots, and a dinner roll. Nutri-Jenny would like to determine what quantity of each item to include in the entrée to meet the nutritional requirements, while costing as little as possible. The nutritional information for each item and its cost are given in the following table.

The nutritional requirements for the entrée are as follows:
(1) It must have between 280 and 320 calories, (2) calories from fat should be no more than 30 percent of the total number of calories, and (3) it must have at least 600 IUs of vitamin A, 10 milligrams of vitamin C, and 30 grams of protein. Furthermore, for practical reasons, it must include at least 2 ounces of beef, and it must have at least half an ounce of gravy per ounce of beef.
a. Formulate and solve a linear programming model for this problem on a spreadsheet. by using the Excel Solver.
b. Use Risk Solver Platform for Education to formulate and solve this model in a spreadsheet.
c. Formulate this same model algebraically?

Transcribed Image Text:

Calories Calories from Fat Vitamin A (per oz.) Protein (g, per oz.) Vitamin C (mg per oz.) Cost (per oz.) (per oz.) (IU per oz.) Item Beef tips 40¢ 35¢ 15¢ 18¢ 10¢ 54 20 15 19 15 Gravy Peas Carrots Dinner roll 15 3. 350 40 10 1