NEED CLEAR HELP ON PUTTING THIS IN EXCEL.... WITH PROBLEM SOLVER ALSO

S11.36. A sports apparel company has received an order for a college basketball team's national championship T-shirt. The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico, and Haiti. The shirts are shipped from the factories to companies in the United States that silk-screen the shirts before they are shipped to distribution centers. Following are the production and transportation costs ($/shirt) from the T-shirt factories to the silk-screen companies to the distribution centers, plus the supply of T-shirts at the factories and demand for the shirts at the distribution centers. SILK-SCREEN COMPANIES T-SHIRT FACTORY 4. MIAMI 5. ATLANTA 6. HOUSTON SUPPLY (1000) 1. Mexico $4 $6 $3 18 2. Puerto Rico 3 5 5 15 3. Haiti 2 4 4 23 DISTRIBUTION CENTERS SILK-SCREEN COMPANY 7. NEW YORK 8. ST. LOUIS 9. LOS ANGELES 4. Miami $ 5 $ 7 $ 9 5. Atlanta 7 6 10 6. Houston 8 6 8 Demand (1000) 20 12 20 Determine the optimal shipments that will minimize total production and transportation costs for the apparel company. F G H J K M N Shipped 0 Shipping Costs (5): Silk-Screen Companies Factory Miami Atlanta Houston Mexico 4 6 3 Puerto Rico 3 5 5 Haiti 2 4 4 Shipping Costs (5): Shipped Sik Screen Companies Miami Atlanta Houston New York 5 7 8 B D 1 Homework S11-36 2. 3 4 Silk Screen Companies 5 Factory Miami Atlanta Houston Sugby 6 Mexico 0 0 18 18 7 Puerto Rico 11 0 0 15 8 Haiti 23 0 0 23 9 Shipped 34 0 18 10 11 12 Distribution Centers 13 Silk Screen Companies New York St. Louis Los Angeles el 14 Miami 20 0 14 15 Atlanta 0 0 0 16 Houston 0 12 6 17 Demand 20 12 20 18 Shipped 19 20 Transshment Rows: 21 Miami 22 Atlanta 23 Houston 24 25 Cost 26 27 28 29 30 31 32 33 Distribution Centers St. Louis Los Angeles 7 9 6 10 6 a