Answered step by step
Verified Expert Solution
Link Copied!

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 126.58.5
Brand B 125.510.5
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. Please solve using Excel and use solver in Excel as well.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Project Management

Authors: Timothy Kloppenborg

3rd edition

1285433351, 978-1285433356

More Books

Students also viewed these General Management questions

Question

Write short note on Indus valley civilisation.

Answered: 1 week ago

Question

What is causing my tooth ahe ?

Answered: 1 week ago