Question: Consider Example of the Pear Company assuming the following supplies and demands:
Use Excel's Solver (or other linear programming code) to determine the optimal solution.
Example: Consider the example of Pear Tablets. The company has decided to place a warehouse in Sacramento to be used as a transshipment node and has expanded the Chicago facility to also allow for transshipments. Suppose that in addition to being transshipment nodes, both Chicago and Sacramento are also demand nodes. The new network is pictured in Figure. Note that several of the old routes have been eliminated in the new configuration.
