A company produces three types of canned juices: A, B, and C, using fresh strawberries, grapes, and
Question:
A company produces three types of canned juices: A, B, and C, using fresh strawberries, grapes, and apples. The daily supply is limited to 200 tons of strawberries, 100 tons of grapes and 150 tons of apples. The cost per ton of strawberries, grapes, and apples is $200, $100, and $90, respectively. Each ton produces 1,500 lbs. of strawberry juice, 1,200 lbs. of grape juice, and 1,000 lbs. of apple juice. Drink A is a 1:1 mix of strawberry and grape juice. Drink B is a 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 1 pound cans. The price per can is $1.15, $1.25, and $1.2 for drinks A, B, and C, respectively.
Solve the model using the Excel Solver and report the optimal quantities of your decision variables and profit (include a snapshot of your Excel solution)
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young