Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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)


ProteinCalciumİronCost(g/TL)
Beef Meat0,1870,640,0260,026
Chicken meat0,190,150,0150,0073
Tomatoes0,0080,070,0060,003
Corrot0,010,350,0090,0037
Cabbage0,0050,430,0070,00085
Yogurt0,0321,20,0010,0052
Rice0,0670,10,0090,0065
Bulgur0,1250,40,0350,0032
Pasta0,110,160,010,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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Statistics In Practice

Authors: Bruce Bowerman, Richard O'Connell

6th Edition

0073401838, 978-0073401836

More Books

Students also viewed these Mathematics questions