Question: solve one using excel solver add-in on an excel sheet, include A word document describing the steps you follow in detail. You should also include

solve one using excel solver add-in on an excel sheet, include A word document describing the steps you follow in detail. You should also include the excel document that includes the excel solver model.

Hi-V produces three types of canned juice drinks, A, B, and C, using fresh strawberries, grapes, and apples. The daily supply is limited to 200 tons of strawberries, 90 tons of grapes, and 150 tons of apples. The cost per ton of strawberries, grapes, and apples is $210, $110, and $100, respectively. Each ton makes 1500 lb of strawberry juice, 1200 lb of grape juice, and 1000 lb of apple juice. Drink A is a 1:1 mix of strawberry and apple juice. Drink B is 1:1:2 mix of strawberry, grape, and apple juice. Drink C is a 2:3 mix of grape and apple juice. All drinks are canned in 16-oz (1 lb) cans. The price per can is $1.15, $1.25, and $1.20 for drinks A, B, and C. Develop an LP model to determine the optimal production mix of the three drinks, and find the solution using AMPL, Solver, or TORA.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!