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 Chicken breast-, Steak = (Type integers or decimals. Do not round.) cost, which is S Pulled pork sandwich =. Salmon filet = Rolled oats = Baked potato =. Nutrition bar = Nutrition Data Food Chicken breast Fat Carbohydrates Sodium Cost/ (grams) (grams) (grams) (grams) Serving Servings 8 2 15 3 15 27 EITIN 17.5 1 1 27 0 34 19 17 0 6 1 7 Steak Salmon filet Rolled oats Baked potato Pulled pork sandwich 26 Nutrition bar Serving of broccoli Serving of carrots Protein *** 39 51 38 7 5 20 2 1 Serving of broccoli = Serving of carrots = [ 6 11 19 5 9 18 3 2 2 $4.99 $8.99 $3.99 $5.15 $0.80 $1.50 $3.00 $0.50 $0.50 Max 5 1 3 5 5 5 1 5 2 - X

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

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 cost, which is S Chicken breast =, Steak, Pulled pork sandwich, Salmon filet-, Rolled oats, Baked potato =, Nutrition bar = Serving of broccoli = Serving of carrots = (Type integers or decimals. Do not round.) Nutrition Data Food Chicken breast Steak Pulled pork sandwich Salmon filet Rolled oats Baked potato Nutrition bar Serving of broccoli Serving of carrots Protein (grams) 39 51 26 38 7 5 20 2 1 Fat (grams) 8 15 15 17.5 1 0 19 0 1 Carbohydrates Sodium (grams) (grams) 6 2 3 11 27 19 1 5 27 34 17 6 7 9 18 3 2 2 Cost/ Max Serving Servings $4.99 5 $8.99 $3.99 $5.15 $0.80 $1.50 $3.00 $0.50 $0.50 1 3 5 5 5 1 5 2 - X

Expert Solution