Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Paul has to buy two types of Yogurts - Brand A and Brand B for children. He knows the following regarding the Vitamins the yogurts
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
Brand B
It is imperative that Paul ensures the children receive a minimum of units of Vitamin A units of Vitamin B and units of Vitamin C This requirement must be met even if it means purchasing more expensive Brand B yogurts, which cost $ per unit compared to the $ per unit of Brand A Furthermore, there must be twice as many Brand B yogurts as Brand A yogurts, and currently, only 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. Please solve using Excel and use solver in Excel as well.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started