Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Fruits&Nuts Blending Problem Fruits&Nuts produces Yummix, a snack that is a mixture of dried fruits, nuts and cereal. The following table includes the information

The Fruits&Nuts Blending Problem Fruits&Nuts produces Yummix, a snack that is a mixture of dried fruits, nuts and cereal. The following table includes the information about the calories, fat and cost of every item in the mix:

Dried Fruit

Nuts

Cereal

Calories (per ounce)

150

300

50

Trans Fat (grams per ounce)

2

8

1

Cost (per ounce)

Each Yummix pack must weigh exactly 10 ounces. The mix cannot contain more than 1500 calories, and cannot contain more than 30 grams of trans fat. Dried fruit must be at least of the weight of the mix. Cereals must be no more than of the weight of the mix. a) Formulate and solve an LP model in Excel that would tell Fruits&Nuts how many ounces of each item to include in each pack of Yummix, minimizing the cost of the mix.

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

Supply Chain Management Strategy Planning and Operation

Authors: Sunil Chopra, Peter Meindl

6th edition

133800202, 978-0133800203

More Books

Students also viewed these General Management questions

Question

What is a strategic alliance?

Answered: 1 week ago

Question

We are interviewing quite a few people, why should we hire you?

Answered: 1 week ago