Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entres for consumption by its clients. The entres are strictly monitored for
Nutri-Jenny is a weight-management center. It produces a wide variety of frozen entres for consumption by its clients. The entres are strictly monitored for nutritional content to ensure that the clients are eating a balanced diet. One new entre 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 entre to meet the nutritional requirements, while costing as little as possible. The nutritional information for each item and its cost are given in the accompanying table. The nutritional requirements for the entre are as follows: Beef Unit Cost (per ounce) $0.40 Gravy $0.35 $0.15 $0.18 Peas Carrots Roll $0.10 Nutritional Data (per ounce) Needed Maximum Calories 54 20 15 8 40 275 315 Fat Calories 19 15 0 0 10 Vitamin A (IU) 15 350 0 595 Vitamin C (mg) 0 1 3 1 0 5 Protein (9) 0 1 1 1 25 Click here for the Excel Data File (1) it must have between 275 and 315 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 595 IUs of vitamin A, 5 milligrams of vitamin C, and 25 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. Formulate and solve a linear programming model for this problem on a spreadsheet by using the Excel Solver. a. Determine the quantity of each food item used. Note: Round your answers to 2 decimal places. Beef Gravy Peas Carrots Roll b. Determine the total cost Note: Round your answer to 2 decimal places.. Total cost
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started