Worked Example 9.
1
A daily diet requires a minimum of 600 mg of vitamin C, 360 mg of vitamin D, 40 mg of vitamin E.
The contents of these vitamins (per portion) in two food mixes, X and Y
Determine the number of portions of mixes X and Y which full the daily requirements at minimum c
Vit C (mg) Vit D (mg) Vit E (mg) Cost/ portion
One portion of X 20 10 4 5
One portion of Y 30 20 1 4
Minimum requirement 600 360 40
LP Formulation:
Decision Variables
x = optimum number of portion food mixes X
y = optimum number of portion food mixes Y
Objective Function
Minimize Cost: Z = 5x + 4y
Subject to Constraints
20x+30y >= 600 (minimum vitamin C)
10x+20y >=360 (minimum vitamin D)
4x+y >=40 (minimum vitamin E)
x,y >=0 (non negativity)
of vitamin E.
daily requirements at minimum cost!
Running Solver: Tab Data > Solve
LINEAR PROGRAMMING SOLUTION:
decision var. x y
Solution: 6 16
objective: Minimize Z = 94
constraints Left-side sign Right-side
vitamin C 600 >= 600
vitamin D 380 >= 360
vitamin E 40 >= 40
Answer:
Optimal Solution:
Food mixes X = 6
Food mixes Y = 16
Cost = 94
Objective Function
Solver: Tab Data > Solver
Objective Function
Decision Variables
Click on "Add" to insert
constraints
Check to make variables
nonnegative
After all parameters and
constraints have been
input click on "Solve"
Select Left-Side Column Choose sign Select Right-Side Column
Click "OK" to finish add/ Click "Add" to adding more
change Constraints constraints with different sign