Question
In a state hospital, efforts are being made to determine a healthy meal menu for male patients aged 19-50 after surgery. Some nutrition rules have
In a state hospital, efforts are being made to determine a healthy meal menu for male patients aged 19-50 after surgery. Some nutrition rules have been determined for the menu. The menu should contain at least 5 units of iron, 30 g of protein and 140 g of calcium. Only 1 variety should be selected from the meat group. Total maximum 100 g. meat will be used. Only 2 varieties will be selected from the tomato, carrot and cabbage salad group, and a maximum of 50 grams of each variety will be used. Yogurt will definitely be included in the menu, and a maximum of 50 grams will be used. Only 1 type will be selected from the rice, bulgur and pasta group, maximum 100 g. will be used. Table of nutritional values of 9 foods is given below. Nutritional values are given on the basis of the amounts in 1 gram. How should the menu be created with minimum total cost? (Solver solution)
Protein | Calcium | İron | Cost(g/TL) | |
Beef Meat | 0,187 | 0,64 | 0,026 | 0,026 |
Chicken meat | 0,19 | 0,15 | 0,015 | 0,0073 |
Tomatoes | 0,008 | 0,07 | 0,006 | 0,003 |
Corrot | 0,01 | 0,35 | 0,009 | 0,0037 |
Cabbage | 0,005 | 0,43 | 0,007 | 0,00085 |
Yogurt | 0,032 | 1,2 | 0,001 | 0,0052 |
Rice | 0,067 | 0,1 | 0,009 | 0,0065 |
Bulgur | 0,125 | 0,4 | 0,035 | 0,0032 |
Pasta | 0,11 | 0,16 | 0,01 | 0,001 |
Step by Step Solution
3.52 Rating (159 Votes )
There are 3 Steps involved in it
Step: 1
Prepare an excel sheet as follows Go to Data Solver and add the following constraints and objectives ...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