Company produces three types of canned juice drinks

Assignment Help Operation Management

Reference no: EM131738571

A company 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, 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 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 grape 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 1 lb cans. The price per can is $1.15, $1.25, and $1.2 for drinks A, B, and C respectively.

a) Solve the model using Excel Solver and report the optimal amounts of your decision variables and the profit (include a snapshot of your Excel solution)

Reference no: EM131738571

Questions Cloud

Calculate depreciation expense for the first year : Using straight-line depreciation, calculate depreciation expense for the first year, which ends on December 31

Calculate depreciation expense for final year of service : On June 1, Aaron Company purchased equipment at a cost of $120,000, Using straight-line depreciation, calculate depreciation expense for the final year

Review the annual report : Review the annual report, paying particular attention to the financial statements and the notes to the financial statements

What is the direct labor budget for january through june : Company applies manufacturing overhead to production at the rate of $7 per direct labor hour. What is the direct labor budget for January through June

Company produces three types of canned juice drinks : A company produces three types of canned juice drinks: A, B, and C, using fresh strawberries, grapes and apples.

What is present value of each project : What is present value of each project at each of Al' s potential costs of capital and which project is acceptable at each

What type of entity did mr bolleni operate : Your client, Edward Bolleni, CPA has recently left his Big Four position and is "out on his own". What type of entity, if any, did Mr. Bolleni operate in 2017

Which generic strategy would they be pursuing : The firm decides to pursue these customers, which generic strategy would they be pursuing?

Many varieties of certified organic ice cream flavors : Ice Scream has expanded its product offerings from basic chocolate and vanilla flavors to include many varieties of certified organic ice cream flavors.

User Account

All Pages