The next problems deal with problem $6-32$ from Homework #$10.$ Recall that this transshipment problem concerns a fruit company who contracts with farms, plants, and distribution centers. They want to determine the optimal shipments from farms to plants to distribution centers to minimize total transportation costs. The screenshot of the Excel worksheet for this problem is:

$2024-02-04163928.$png

The variables to be entered into the $$By Changing Variable Cells$$ box in the Excel solver are:

Group of answer choices

B$6$:C$8$

C$14$:E$15$

B$6$:C$8,$ C$14$:E$15$

I$6$:J$9,$ J$14$:L$15$