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:
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
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.© BrainMass Inc. brainmass.com October 1, 2022, 5:18 pm ad1c9bdddf
SOLUTION This solution is FREE courtesy of BrainMass!
I hope you are doing well. Please see my response attached. I have used Excel Solver to solve the problem. If you open up Solver, you will see all the constraints and objective functions that I have used. The cells in orange are the cells that are being guessed by Solver for optimal value. The objective function is we need to minimize the total shipping cost. There are several constraints that you can see in Solver.© BrainMass Inc. brainmass.com October 1, 2022, 5:18 pm ad1c9bdddf>