Paul has to buy two types of Yogurts- Brand A and Brand B for children. He knows the following regarding the Vitamins the yogurts have: Vitamin A Vitamin B Vitamin C Brand A 10 15 15 Brand B 20 5 10 The price of Brand A is $1.25 and Price of Brand B is $1.50. Paul wants to make sure the children get at least 200 unit of Vitamin A, 150 unit of Vitamin B, and 150 unit of Vitamin C. Moreover, the number of Brand B has to be at least twice the number of Brand A yogurts and after going to the store if Paul finds out that only 5 of Brand A yogurt is available. Using linear programming find the minimum cost of buying the yogurts to provide the required units of vitamins. How many of each type of yogurt Paul should buy to keep the cost at the minimum.CAN YOU do it in Excel solver? Thank you
- Paul has to buy two types of Yogurts- Brand A and Brand B for children. He knows the following regarding the Vitamins the yogurts have:
|
|
Vitamin A |
Vitamin B |
Vitamin C |
|
Brand A |
10 |
15 |
15 |
|
Brand B |
20 |
5 |
10 |
The price of Brand A is $1.25 and Price of Brand B is $1.50.
Paul wants to make sure the children get at least 200 unit of Vitamin A, 150 unit of Vitamin B, and 150 unit of Vitamin C. Moreover, the number of Brand B has to be at least twice the number of Brand A yogurts and after going to the store if Paul finds out that only 5 of Brand A yogurt is available.
Using linear programming find the minimum cost of buying the yogurts to provide the required units of vitamins. How many of each type of yogurt Paul should buy to keep the cost at the minimum.CAN YOU do it in Excel solver?
Thank you
Linear programming is a mathematical technique that can optimize a system of linear constraints and a linear objective function. An objective function specifies the quantity that needs to be optimized, and the objective of linear programming is to determine the values of the variables that maximize or minimize the objective function. When a problem's objective is to maximize a specific value and the problem's constraints are defined by a linear system of inequalities, linear programming can be utilized to find a solution.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
