Milford Lumber Company ships construction materials from three wood-processing plants to three retail stores. The shipping cost, monthly production capacities, and monthly demand for framing lumber are given below. Set up a spreadsheet to solve this transportation problem. Find the solution that minimizes total distribution costs. See Supplementary Chapter C for a discussion of how to do this and using Excel Solver.

Transcribed Image Text:

Store B $3.1 $2.6 $2.9 600 Plant Store A $4.5 $5.1 $4.1 250 Store C $2.0 $3.8 $4.0 1.50 Capacity 280 460 300 Demand