Problem 5 Flynn's Boot Company from Example 8.7 from your book has experienced tremendous growth due to their boots being prominently exposed to a large audience during an awards ceremony. As such, they have opened two new retail outlets and one new warehouse. With the new data given below, determine the most cost effective means for delivering their boots to market using Excel's Solver function. Weekly pacity Weekly Demand Warehouse (CI) Customer (D) 27,800 Atlanta Fort Worth Billy Bob DudeWear 8,000 20,000 40,000 30,000 35,000 Tucson Slickers 13,500 33,000 Nashville Total 125,000 CJ's BigD MusicCity Total 15,000 20,000 117,300 Cost to ship one pair of boots from Warehouse i to Customer j (Tij) Slickers CJ'S BillyBob DudeWear $2.00 $3.00 BigD $1.90 MusicCity $2.00 $3.50 $1.50 $5.00 $1.75 $2.25 $4.00 $0.50 $4.00 Atlanta Fort Worth Tucson Nashville $2.50 $1.00 $3.00 $1.25 $1.00 $6.00 $6.00 $0.25 $4.50 $2.35 $2.00 $5.00 Objective Function: Minimize Total Shipping Costs