Chapter 32: Analyzing Data Using Goal Seeking and Solver
3232
A set of linear equations may have one solution, no solution, or an infinite number of solutions.
Minimizing shipping costs
This example involves finding alternative options for shipping materials, while keeping
total shipping costs at a minimum (see Figure 32.12). A company has warehouses in Los
Angeles, St. Louis, and Boston. Retail outlets throughout the United States place orders,
which the company then ships from one of the warehouses. The company wants to meet
the product needs of all six retail outlets from available inventory and keep total shipping
charges as low as possible.FIGURE 32.12
This worksheet determines the least expensive way to ship products from warehouses to
retail outlets.