***PLEASE ANSWER PROBLEM IN EXCEL FORMAT AND PROVIDE FORMULAS AND SOLVER*** THANK YOU.

Problem 2: Tropicana Juice Company signed an agreement with cultivators in Seattle, Virginia and Florida to buy cranberries. Cranberries are transformed into juice at the farms and stored in refrigerated barrels. After that process, the juice is transported to two processing centers in which they package the cranberry juice into canned juice. The product is shipped to three food distribution centers. The transportation costs per ton from the cultivators to the processing centers and to the distribution centers, and the supply at the farms and demand at the distribution centers are summarized in the following tables: Processing Centers Cultivators Connecticut New York Supply (1,000 tons) $14 $23 $80 1. Seattle $20 $16 $120 2. Virginia $22 $28 $85 3. Florida Distribution Centers 6. Processing Centers 7. South Caroline 8. North Caroline Milwaukee 4. Seattle $25 $18 $28 5. Virginia $22 $17 $20 120 90 140 Demand (1,000 tons) a. Determine the optimal shipments from the cultivator processing centers to distribution centers to minimize total transportation costs. b. What would be the effect on the solution if the capacity at each plant were 40,000 tons