Below Are Selection(s)

A. Answer Yes Or No

B. Answer Yes Or No

C. Answer Yes Or No

D. Vitamins, Minerals or Protein. Binding or Not-binding. Reduction Or Increase

Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively, $2.50, $1.50, $2.00, $3.50, and $3.00 per pound. The vitamin, mineral, and protein content of each of the ingredients (in grams per pound) is summarized in the following table along with the calories per pound of ingredient: Grain Vitamins Minerals Protein Calories Raisins 20 7 4 450 10 4 2 160 Chocolate 10 5 1 500 Peanuts 30 9 10 300 Almonds 20 3 1 500 The company would like to identify the least costly mix of these ingredients that provides at least 40 grams of vitamins, 15 grams of minerals, 10 grams of protein, and 600 calories per two pound package. Additionally, they want each ingredient to account for at least 5% and no more than 50% of the weight of the package. Use Solver to create a Sensitivity Report for above question and answer the following questions: a. Is the solution degenerate? Select b. Would the solution change if the price of raisins was $2.80 per pound? Select c. Would the solution change if the price of peanuts was $3.25 per pound? Select d. If you could relax one of the nutritional constraints which one would you choose? Why? The constraint on the Select v content of the mix is Select and would lead to a Select in the price of the mix if relaxed. e. Create a Spider Plot summarizing the impact on total cost of varying the cost per pound of each ingredient between 90% and 110% of its base case value in 2% increments. What does this chart reveal and what are the managerial implications? The input in the box below will not be graded, but may be reviewed and considered by your instructor