Purchase Solution

Linear Programming

Not what you're looking for?

Ask Custom Question

Valley Fruit Products Company has contracted with apple growers in Ohio, Pennsylvania, and New York to purchase apples that the company then ships to its plants in Indiana and Georgia, where they are processed into apple juice. Each bushel of apples produces 2 gallons of apple juice. The juice is canned and bottled at the plants and shipped by rail and truck to warehouse/ distribution centers in Virginia, Kentucky, and Louisiana. The shipping cost per bushel from the farms to the plants and shipping costs per gallon from the plants to the distribution centers are summarized in the following tables:
Plant
Farm 4. Indiana 5. Georgia Supply (bushels)
1. Ohio .41 .57 24,000
2. Pennsylvania .37 .48 18,000
3. New York .51 .60 32,000
Plant Capacity 48,000 35,000

Distribution Center
Plant 6. Virginia 7. Kentucky 8. Louisiana
4. Indiana .22 .10 .20
5. Georgia .15 .16 .18
Demand (gal) 9,000 12,000 15,000

Formulate and solve a linear programming model to determine the optimal shipments from the farms to the plants and from the plants to the distribution centers in order to minimize total shipping costs.

Please include what program is used to solve this.

Purchase this Solution

Solution Summary

The solution does a superb job of laying out step by step explanation to the problem. The solution is very well explained and uses detailed steps to explain the answer. The solution can be followed by anyone with a basic understanding of the concepts. Overall, an excellent response.

Solution Preview

Hello,

I hope you are doing well. Please see my response attached. I have used Excel Solver to solve ...

Purchase this Solution


Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.