Group Ungroue Subtotal X Eht - Microsoft Exce File Home Insert Page Layout Formulas Data Review Connections Properties From From From From Other Existing Refresh A1 Sort Filter Text to Remove Data Access Web Test Sources Connections Altink Advanced Columns Duplicates Validation Analysis Get External Data Connections Sort & Filter Data Tools Outline 218 Show Deal 25 Mide Detail 150 G H K L M Protein Fiber C19 SUMPRODUCTICS:C14.ES:E14) A B D E F 1 A Diet Example 2 3 Calories 4 Breakfast Food Serving Unit Cost (8) 5 Bran cereal = cup 0.18 90 6 Dry cereal = cup 0.22 110 7 Oatmeal cup 0.10 100 8 Oat bran - cup 0.12 90 9 Egg - egg 0.10 75 10 Bacon - slice 0.09 35 11 Orange - orange 0.40 65 12 Milk - 2% cup 0.16 100 13 Orange juice cup 0.50 120 14 Wheat toast = slice 0.07 65 15 Nutritional Levels 420 16 Constraints 17 Nutritional Requirements 420 18 19 Cost Per Meal = $ 0.509 20 Decision Variable, C5:C14 Nutrient Contributions Fat Cholesterol Iron Calcium mg mg mg 0 0 6 20 2 0 4 48 2 0 2 12 2 0 3 8 5 270 1 30 3 8 0 0 0 0 1 52 4 12 0 250 0 0 0 3 1 0 1 26 9.99 14.90 5.02 400 3 4 5 6 7 2 1 9 1 3 25 22 5 2 3 4 0 0 1 0 0 3 12 20 30.00 5 400 20.00 12 Constraint value, 420, typed in cell F17 Solver Parameters objective cell SetObjective: To: Min Value of Decision variable cells Ey Changing Variable Cels: Subject to the Constraints: Add Change Include all constraints. Delete Best Al Load/Save Make Unconstrained variables Non-legative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Salver Problems, and select the Evolutionary engine for Solver problems that are non-smooth Help Solve Close Group Ungroue Subtotal X Eht - Microsoft Exce File Home Insert Page Layout Formulas Data Review Connections Properties From From From From Other Existing Refresh A1 Sort Filter Text to Remove Data Access Web Test Sources Connections Altink Advanced Columns Duplicates Validation Analysis Get External Data Connections Sort & Filter Data Tools Outline 218 Show Deal 25 Mide Detail 150 G H K L M Protein Fiber C19 SUMPRODUCTICS:C14.ES:E14) A B D E F 1 A Diet Example 2 3 Calories 4 Breakfast Food Serving Unit Cost (8) 5 Bran cereal = cup 0.18 90 6 Dry cereal = cup 0.22 110 7 Oatmeal cup 0.10 100 8 Oat bran - cup 0.12 90 9 Egg - egg 0.10 75 10 Bacon - slice 0.09 35 11 Orange - orange 0.40 65 12 Milk - 2% cup 0.16 100 13 Orange juice cup 0.50 120 14 Wheat toast = slice 0.07 65 15 Nutritional Levels 420 16 Constraints 17 Nutritional Requirements 420 18 19 Cost Per Meal = $ 0.509 20 Decision Variable, C5:C14 Nutrient Contributions Fat Cholesterol Iron Calcium mg mg mg 0 0 6 20 2 0 4 48 2 0 2 12 2 0 3 8 5 270 1 30 3 8 0 0 0 0 1 52 4 12 0 250 0 0 0 3 1 0 1 26 9.99 14.90 5.02 400 3 4 5 6 7 2 1 9 1 3 25 22 5 2 3 4 0 0 1 0 0 3 12 20 30.00 5 400 20.00 12 Constraint value, 420, typed in cell F17 Solver Parameters objective cell SetObjective: To: Min Value of Decision variable cells Ey Changing Variable Cels: Subject to the Constraints: Add Change Include all constraints. Delete Best Al Load/Save Make Unconstrained variables Non-legative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Salver Problems, and select the Evolutionary engine for Solver problems that are non-smooth Help Solve Close