Question: 5. The table on the Problem 5 worksheet presents 4 foods (8 oz. steak; 1 oz cheese, 1 apple and 8 oz of milk) and

5. The table on the Problem 5 worksheet presents 4 foods (8 oz. steak; 1 oz cheese, 1 apple and 8 oz of milk) and the nutritional characteristics (calories, fat, protein and carbohydrates) for each food. The cost of each food is also shown in the table. The objective is to minimize the cost of a meal prepared from these 4 foods, subject to the constraints listed on the worksheet. Use SOLVER to determine the quantity of each food to include in a meal to minimize cost subject to the constraints listed on the worksheet. What is the value of the objective function (cost, $'s)? B C F Protein, grams Carbs, grams Food Steak, 8 oz. Cheese, 1 02 Apple Milk, 8 oz D Calories Fat, grams 692 51 110 9 81 1 150 8 57 6 G H Cost/ unit, $'s Maximum Units of food 0 10 1 0.25 22 0.5 12 0.2 Objective 1 1.5 4 2 8 1 1 Steak, 8 oz. Cheese, 1 oz Apple Milk, 8 oz 1 1 1 Constraints: Calories: 1600 >= 1200 Protein: > 100 grams Carbs: 45 grams Fat: 100 grams Maximum units No. 1 NO. 2 NO. 3 No.4 No. +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Kosar Manufacturing has collected the following information on one of its major products. Most efficient production rate = 2,000 + X units per period Production change costs = $20 per unit of change...

The table on the Problem 5 worksheet presents 4 foods (8 oz. steak; I oz cheese, 1 apple and 8 oz of milk) and the nutritional characteristics (calories, fat, protein and carbohydrates) for each...

Interpreting the sensitivity report Your friend's diet requires that all the food your friend eats come from one of the four basic food groups (chocolate cake, ice cream, soda, and cheesecake). At...

Item_Name Menu_Category Protein Total_Fat Total_Carbs Fiber Weight_Watchers Calories Apple Slices Snacks and Sides 0 0 4 0 0 15 Bacon, Egg & Cheese Bagel Breakfast 30 32 57 3 17 630 Bacon, Egg &...

31% 2:25 PM Sun Mar 26 . . . Monassar - BIO217- AllDaily Open in Books Q .j Done 8 of 18 Water (g) A-RAE(mcg) B1 (mg) B2 (mg) B3 (mg) B6 (mg) Day Meal Item Sun 02- 0.0 0.0 Snack water, tap (USDA)...

Fiber Intake Compared to Standard Instructions: Use the Bar Graph Report to record the following information in Table 1 below: 0 Record your actual fiber consumption, found in the Value column of the...

S w 9B10D015 O PY SUNSET GRILL AT BLUE Jason Melhuish wrote this case under the supervision of Professors Dina Ribbink and John Haywood-Farmer solely to provide material for class discussion. The...

Hi! I need help calculating some revenue gained and grossprofit gained. Must show show work in excel! Answers need to be in cell K60, K61, U60, U61, AE 60, A61. You might find additional help in case...

Introduction Wyatt Abbenhaus has been weightlifting and eating a high protein diet. Below is Wyatt's profile and what he ate for a day. He entered his profile information and food intake into Diet &...

Your friends diet requires that all the food your friend eats come from one of the four "basic food groups" (chocolate cake, ice cream, soda, and cheesecake). At present, the following four foods are...

Number 11.33. Please help me ons. 11.33. A pendulum of length I is rigidity fixed on an axle AA'. The supports S and S' are attached to a plat- form P that is rotating with an angular velocity w, as...

3. (This option requires you to be able to differentiate exponential functions and hence will be easier if you have completed SIT194 and SIT291). Eigenvectors can be used to solve systems of...

Which statement is true? 3 6 average cost of capital. The cost of preferred stock is unaffected by the issuer's tax rate. Preferred stock is generally the cheapest source of capital for a firm. The...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...