The Crazy Nut Company wishes to market two special nut mixes during the holiday season. The Fancy Mix contains 0.5 pound of peanuts and 0.5 pound of cashews. The Deluxe Mix contains 0.6pound of peanuts, 0.2 pound of cashews and 0.15 pound of almonds. Fancy Mix sells for $12 per can and Deluxe Mix sells for $16 per can. The data pertinent to the raw ingredients appear in the table. The Crazy can sell all cans of either mix that it produces, but wants to keep the production quantity of Fancy Mix at least twice as many as Deluxe Mix. Formulate an LP model to determine how many of each mix to produce to maximize the total profit. Do not solve it. You can formulate as a spreadsheet model or an algebraic model. Define your decision variables (changing cells) clearly. Ingredient Amount Available (lb) Cost Per Pound (s) Peanuts 300 $1 Cashews 120 $3 Almonds 90 $4
The Crazy Nut Company wishes to market two special nut mixes during the holiday season. The Fancy Mix contains 0.5 pound of peanuts and 0.5 pound of cashews. The Deluxe Mix contains 0.6pound of peanuts, 0.2 pound of cashews and 0.15 pound of almonds. Fancy Mix sells for $12 per can and Deluxe Mix sells for $16 per can. The data pertinent to the raw ingredients appear in the table. The Crazy can sell all cans of either mix that it produces, but wants to keep the production quantity of Fancy Mix at least twice as many as Deluxe Mix. Formulate an LP model to determine how many of each mix to produce to maximize the total profit. Do not solve it. You can formulate as a spreadsheet model or an algebraic model. Define your decision variables (changing cells) clearly.
Ingredient |
Amount Available (lb) |
Cost Per Pound (s) |
Peanuts |
300 |
$1 |
Cashews |
120 |
$3 |
Almonds |
90 |
$4 |
Trending now
This is a popular solution!
Step by step
Solved in 3 steps