Question
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
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