FarmFresh Foods manufactures a snack mix called TrailTime by blending three ingredients: a dried fruit mixture,...

60.1K

Verified Solution

Question

Advance Math

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.

IngredientCostVolumeFat GramsCalories
Dried Fruit0.401/4 cup0160
Nut Mix0.603/8 cup9390
Cereal Mix0.251 cup260

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?

Answer & Explanation Solved by verified expert
3.7 Ratings (319 Votes)
Where Objective    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students