Problem 1 In the table below, the nutritional value of a group of foods and how much an adult needs each week are shown. Find the cheapest way to meet the minimum requirements each week. 1 2 3 4 5 . ● Food Bread Butter Cheese Cereal Diet Bar Weekly requirement Formulate Solve using Excel Solve using QAM Proteins (%) 8 25 12 8 550 Fats (%) 1 90 36 3 600 Carbohydrates (%) 55 75 50 2000 Cost in $ per 100g 0.25 0.5 1000 5265 1.2 0.6 1.5

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter6: Linear Systems
Section6.8: Linear Programming
Problem 4SC: If the cost of each Robust tablet increases to 75 c and the cost of each Vigortab increases to 80 c...
icon
Related questions
Question

5

Problem 1
In the table below, the nutritional value of a group of foods and how much an adult needs each week are shown. Find the cheapest way
to meet the minimum requirements each week.
1
2
3
4
5
.
Food
Bread
Butter
Cheese
Cereal
Diet Bar
Weekly requirement
Formulate
Solve using Excel
Solve using QAM
Proteins (%)
8
25
12
8
550
Fats (%)
1
90
36
3
600
Carbohydrates (%)
55
75
50
2000
Cost in $ per 100g
0.25
5265
0.5
1010
1.2
0.6
1.5
Transcribed Image Text:Problem 1 In the table below, the nutritional value of a group of foods and how much an adult needs each week are shown. Find the cheapest way to meet the minimum requirements each week. 1 2 3 4 5 . Food Bread Butter Cheese Cereal Diet Bar Weekly requirement Formulate Solve using Excel Solve using QAM Proteins (%) 8 25 12 8 550 Fats (%) 1 90 36 3 600 Carbohydrates (%) 55 75 50 2000 Cost in $ per 100g 0.25 5265 0.5 1010 1.2 0.6 1.5
Expert Solution
steps

Step by step

Solved in 4 steps with 17 images

Blurred answer
Recommended textbooks for you
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning