PLEASE USE SOLVER TO SOLVE THIS CASE. SHOW ANSWER THROUGH EXCEL

1. Suppose the U.S. Pharmaceutical Company has four factories supplying the warehouses of four major customers and its management wants to determine the minimum-cost shipping schedule for its monthly output to these customers. Factory supply, warehouse demands, and shipping costs per case for these drugs are shown in Exhibit 8.1. Exhibit 1 Data for U.S. Pharmaceutical Transportation Problem 35 36 Columbus St. Louis Denver Los Angeles Factory supply Indianapolis 25 60 15 Phoenix 55 30 25 25 6 New York 40 80 90 14 Atlanta 30 40 66 75 11 Destination 10 12 15 9 46 requirements 50 The transportation matrix for this example appears in Exhibit 1, where supply availability at each factory is shown in the far right column and the warehouse demands are shown in the bottom row. The shipping costs are shown in the middle mix. For example, the cost to ship one unit from the Indianapolis factory to the customer warehouse in Columbus is $25