Question: Please solve the following question using Excel linear programming with Solver. Answer given without excel screenshots aren't helpful and will be thumbs down as they
Please solve the following question using Excel linear programming with Solver.
Answer given without excel screenshots aren't helpful and will be thumbs down as they don't follow instructions in the question. 
3) 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: It is imperative that Paul ensures the children receive a minimum of 200 units of Vitamin A, 150 units of Vitamin B, and 150 units of Vitamin C. This requirement must be met even if it means purchasing more expensive Brand B yogurts, which cost $2.25 per unit compared to the $1.50 per unit of Brand A. Furthermore, there must be twice as many Brand B yogurts as Brand A yogurts, and currently, only 5 Brand A yogurts are available at the store. 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
