Problem 2 (50 pts): Sheet: Chips Problem Statement: Kaitlin Bates owns a company that produces medical-grade knee braces. She has three manufacturing plants (in Atlanta, Tulsa, and Springfield) that produce the braces which are then shipped to one of four distribution centers - A, B, C, or D. The three plants can produce 15, 22, and 15 truckloads of product each week, respectively. Distribution centers A & B need 12 truckloads of product each week and Distribution centers C&D need 13 truckloads of product each week. The shipping costs per truckload between the plants and distribution centers are given in the table. She needs to determine how much to ship from each plant to each distribution center, and would like to minimize total shipping costs. . . Plant Atlanta Tulsa Springfield A $ 800 $1100 $ 600 Distribution Center B $1300 $400 $1400 $600 $1200 $800 D $ 700 $1000 $ 900 Using the Chips Sheet and Excel Solver, determine the optimal number bathtubs that need to be sent between plants and distribution centers minimize cost Chip Manufacturer Objective Function Total Shipping Cost Decision Variables and Constraints Distribution Center Plant A B D Total Capacity Atlanta Tulsa Springfield Total Demand Data A Plant Atlanta Tulsa Springfield $800 $1,100 $600 Distribution Center B $1,300 $400 $1,400 $600 $1,200 $800 D $700 $1,000 $900