PLS USE EXCEL SOLVER

1. Super-Host Party Foods produces a variety of ready-to-serve foods. Among their products are three types of nut mixes as follows: Percentage by weight Nut Mix Pecans Cashews Almonds Peanuts Cocktails Plus 20 40 30 10 Nuts A' Plenty 10 35 30 25 Bar Mix 0 15 25 60 Profit margins on the three different mixes are as follows: Nut Mix Cocktails Plus Nuts A' Plenty Bar Mix Profit margin, PHP/pound 39.00 32.00 20.00 For the next month, the quantities available from suppliers of the different types of nuts are as follows: Type of nut Pecans Cashews Almonds Peanuts Pounds available 2,800 9,500 12,000 2,000 How much of each of the three different nut mixes should be produced next month, and how much of each type of nut should Super-Host order from its suppliers