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. Distribution Center Plant A B C D Atlanta $ 800 $1300 $400 $ 700 Tulsa $1100 $1400 $600 $1000 Springfield $ 600 $1200 $800 $ 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.

AutoSave Off H HW 5 Starting File(1) - Excel Search Joseph Crawford JC File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments Trebuchet MS 11 AP == Custom CIT ST TI TTY TA AY W o ab Wrap Text 5 3 Merge & Center Paste BIU A $ %, Insert Delete Format y Ideas Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas C4 X for A B C D E F G - H J L M N o P R Q S T U 1 Chip Manufacturer 2 3 Objective Function 4 Total Shipping Cost un Distribution Center B D Total Capacity