Write a summary of the optimal solution

Write a summary of the optimal solution

Juice, Inc. produces and sells cranberry juice nationwide. They currently have five processing plants located around the country where cranberries are squashed and made into juice. These processing plants are located in the following five major cities: Los Angeles (LA), St. Paul (SP), Boston (B), Atlanta (A), and Dallas (D). Based on their plant technology, 1 ton of cranberries produces 75 gallons of cranberry juice.
Crancoop Inc. is a large cranberry cooperative that sells bulk cranberries to Juice, Inc. They have four large transfer stations located in the North (NOR), South (SOU), East (EAS), and Western (WES) United States. These transfer stations are where all the cranberries from each region’s farms are stored, and they represent the supply sources for each processing plant.
After processing the raw cranberries into juice, Juice, Inc. ships the juice to four cold storage facilities in the nation, where supermarkets get their supply of cranberry juice. The cold storage facilities are located in California (CAL), Minnesota (MN), New York (NY), and Florida (FL).
You have been hired as a consultant to determine the most efficient raw product-final product distribution network for Juice, Inc. You have been given the fol- lowing unit transportation costs, supply capacities, and demand levels:

Cranberries: ($/ton of bulk cranberries)

From/To LA SP B A D Supply

($/ton) (tons)

NOR

500

75

80

650

700

900

SOU

450

455

666

150

100

100

EAS

1,000

225

50

100

950

500

WES

120

350

1,100

1,150

450

700

Cranberry Juice ($/gallon of cranberry juice)

From/To CAL MN NY FL

LA

0.10

1.00

3.00

3.50

SP

1.00

0.05

1.25

2.35

B

2.50

0.75

0.35

1.45

A

3.00

1.10

0.80

0.55

D

0.90

1.05

2.00

0.95

Demand

60,000

20,000

40,000

30,000

a. Assuming the processing plants can handle unlimited amounts of cranberries, for- mulate an LP model that minimizes total distribution costs for transporting cran- berries to the plants and cranberry juice to the cold storage facilities. Show either the LP tableau, or mathematical representation of the model.

b. Using Solver, solve the problem in part a.

c. Write a summary of the optimal solution.

d. Write a summary of your sensitivity analysis with respect to objective function coefficients.

Order from us and get better grades. We are the service you have been looking for.