*EXCEL PLEASE*

19. MediTransport ships medical supplies from three distribution facilities to six different clinics. The below tables show the freight rates between various sites in the network, as well as mileage capacity at each of the manufacturers. Using the solver tool, analyze the network. What is the optimal distribution of shipments to minimize freight cost? Freight Rates To From Denton Richardson Mesquite Garland Dennison Sherman Mckinney 90.00 $ 33.00 $ 41.00 $ 60.00 77.00 70.00 Plano S 73.00 S 80.00 S 57.00 S 34.00 S 45.00 S 92.00 Allen 55.00 S 66.00 S 99.00 S 84.00 S 31.00 S 30.00 Demand Denton 130 Supply Richardson 120 Mckinney 200 Mesquite 130 Garland 120 Plano 400 Dennison 130 Allen 150 Sherman 120