FarmFresh Foods manufactures a snack mix called TrailTime byblending three ingredients: a dried fruit mixture, a nut mixture,and a cereal mixture. Information about the three ingredients (perounce) is shown below.
| Ingredient | Cost | Volume | Fat Grams | Calories |
| Dried Fruit | 0.40 | 1/4 cup | 0 | 160 |
| Nut Mix | 0.60 | 3/8 cup | 9 | 390 |
| Cereal Mix | 0.25 | 1 cup | 2 | 60 |
The company needs to develop a linear programming model whosesolution would tell them how many ounces of each mix to put intothe TrailTime blend. TrailTime is packaged in boxes that will holdbetween three and four cups. The blend should contain no more than1,100 calories and no more than 30 grams of fat. Dried fruit mustbe at least 25% of the volume (in cups) of the mixture, and nutsmust be no more than 20% of the weight (in ounces) of themixture.
Use Excel's Solver to obtain the optimal solution for thisproblem. In other words: what is the most cost effective way tocreate the TrailTime blend? What is the cost?
