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

Answer rating: 100% (QA)

Prepare an excel sheet as follows Go to Data Solver and add the following constraints and objectives ... View the full answer