Joe is an active 26-year-old male who lifts weights six days a week. He is looking to minimize the cost of consuming his favorite foods. Joe is trying to gain weight, or at least maintain his current body weight, so he is not concerned about calories. His personal trainer suggests at least 300 grams of protein, 95 grams of fat, 225 grams of carbohydrates, and no more than 110 grams of sodium per day. His favorite foods are all items that he is familiar with preparing, as shown in the accompanying data table. He is willing to consume multiple servings of each food per day to meet his requirements, although he cannot eat more than one steak per day and does not want to eat more than three pulled pork sandwiches a day. He needs to consume at least two servings of broccoli and one serving of carrots per day but is willing to eat two servings of carrots if necessary. Joe likes a certain brand of nutrition bars, but he would not eat more than one. Unless previously noted, he does not want more than five servings of any one food. How many servings of each food should he have in an optimal daily diet? Click the icon to view the nutrition data Find the optimal integer solution and enter the number of servings for each food below. This solution gives the Rolled oats. Baked potato = Salmon filet = Chicken breast-, Steak-Pulled pork sandwich = (Type integers or decimals. Do not round.) cost, which is S Nutrition bar = Serving of broccoli = Serving of carrots =

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

J 1

The solution gives the minimum or maximum

Food
Chicken breast
Steak
Pulled pork sandwich
Salmon filet
Rolled oats
Baked potato
Nutrition bar
Serving of broccoli
Serving of carrots
Protein
(grams)
40
49
25
39
9
4
20
2
1
Fat
(grams)
10
16
16
17.5
1
0
20
0
1
Carbohydrates
(grams)
2
3
27
1
27
34
17
6
7
Sodium
Cost/
(grams) Serving
6
$4.99
$8.99
$3.99
$5.15
$0.80
11
19
5
9
18
3
2
2
$1.50
$3.00
$0.50
$0.50
Max
Servings
5
1
3
5
5
5
1
2

Transcribed Image Text:Joe is an active 26-year-old male who lifts weights six days a week. He is looking to minimize the cost of consuming his favorite foods. Joe is trying to gain weight, or at least maintain his current body weight, so he is not concerned about calories. His personal trainer suggests at least 300 grams of protein, 95 grams of fat, 225 grams of carbohydrates, and no more than 110 grams of sodium per day. His favorite foods are all items that he is familiar with preparing, as shown in the accompanying data table. He is willing to consume multiple servings of each food per day to meet his requirements, although he cannot eat more than one steak per day and does not want to eat more than three pulled pork sandwiches a day. He needs to consume at least two servings of broccoli and one serving of carrots per day but is willing to eat two servings of carrots if necessary. Joe likes a certain brand of nutrition bars, but he would not eat more than one. Unless previously noted, he does not want more than five servings of any one food. How many servings of each food should he have in an optimal daily diet? Click the icon to view the nutrition data. Find the optimal integer solution and enter the number of servings for each food below. This solution gives the Salmon filet = [ Chicken breast =, Steak = , Pulled pork sandwich = (Type integers or decimals. Do not round.) Rolled oats = [ cost, which is S =, Baked potato =, Nutrition bar = Serving of broccoli = Serving of carrots =

Expert Solution