Question: *Please include spreadsheets with formulas, if applicable* Multilever manufactures a snack mix called Trail-Mashup TM by blending three ingredients: a dried fruit mixture, a nut
*Please include spreadsheets with formulas, if applicable*
Multilever manufactures a snack mix called Trail-MashupTM by blending three ingredients: a dried fruit mixture, a nut mixture, and a cereal mixture. Information about the three ingredients (per ounce) is shown below.
| Ingredient | Cost | Volume (cups per Ounce) | Fat Grams | Calories |
| Dried Fruit | .35 | .5 Cup | 0 | 150 |
| Nut Mix | .50 | .35 Cup | 10 | 400 |
| Cereal Mix | .20 | 1 Cup | 1 | 50 |
The company needs to develop a linear programming model whose solution would tell them how many ounces of each mix to put into the Trail-MashupTM blend. Trail-MashupTM must be packaged in boxes that are 3 cups in size. The blend should contain 1000 calories, and no more than 25 grams of fat. Nuts must be more than 35% of the mixture. Dried Fruit must be more than 25%, but less than 50% of the mixture. Cereal must be less than 70% of the mixture.
- Write a linear programming model in the space below that meets these restrictions and minimizes the cost of the blend.
- What is the optimal mix (round to 2 decimal places), and minimum cost, of the ingredients?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
