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 |