Solve the problem, along with any sensitivity information that you feel to be relevant. Include the excel file with your model, the word file with your memo, and any notes regarding solution procedures that you want me to consider.

The Good-Nut Company sells dry-roasted nut mixes. The table below gives the price per bag and the ingredients in a 210 gram bag of its four best-selling nut mixes, along with current prices of a kilogram of each nut type.

The Good-Nut Company has the following stocks of bulk nuts in kg: 200 cashews, 100 brazils, 50 walnuts, 150 almonds, and an unlimited supply of peanuts. The Company cannot sell more than 800 bags of Cocktail Special in the current period. Recommend the best product mix to maximize profits. (Using Problem Solver is best way.)

Transcribed Image Text:

cashews peanuts brazils Walnuts Almonds Price per bag Product Cocktail special 60 30 30 $2.20 60 30 Deluxe mix 60 60 $2.50 90 Good-nut mix 60 $2.50 90 60 90 $2.20 Party special 120 S per kilogram 7.20 3.75 6.00 8.25 9.50