In: Operations Management
Weez All Nuts, Inc. determined that their cocktail nut mix should have the following minimum requirements in the 1 lb. can they sell for $3.99. At least 10% Brazil nuts. Brazil nuts cost $2.50 a pound. A maximum of 50% pecans at $1.40 a pound. At least 20% pistachios at $2.25 a pound, A maximum of 40% cashews at $2.00 a pound. The can costs $0.10 Find the proportion of these nuts by weight to maximize profit. What is the profit that will be made per can if it is sold at a retail store for $3.00 a can.
LP model:
| Decision variables: Let a,b,c,d represent the lbs of brazil nuts, pecans, pistachios, and cashews used respectively in 1 lb of the cocktail nut mix. | |
| constraints: | |
| a,b,c,d>=0 | non negativity |
| a>=10%(a+b+c+d) | Brazil nuts |
| b<=50%(a+b+c+d) | pecans |
| c>=20%(a+b+c+d) | pistachios |
| d<=40%(a+b+c+d) | cashews |
| (a+b+c+d)=1 | total weight |
| Objective Function: | |
| Maximize Profit | |
| Profit = [3.99(a+b+c+d)]-[2.50a+1.40b+2.25c+2d+0.10] |
excel model:

solver solution:

What is the profit that will be made per can if it is sold at a retail store for $3.00 a can:

|
What is the profit that will be made per can if it is sold at a retail store for $3.00 a can. |
|
if the price is $3.00 a can Profit per can = $1.10 |