Please show your work in Excel

A local firm is a seller of consumer products, with most products sourced from international firms. To clear customs, the local firm operates at two international seaports, one in Seattle, WA and the other in Charleston, SC. From these two seaports, the firm will ship items to one of three distribution centers in Las Vegas, NV, Atlanta, GA, or Dallas, TX. There is no demand at the distribution centers, but all customer orders must go through one of the three distribution centers. When a customer orders a product, the item is transported from a distribution center to one of four regional receiving centers before being delivered to the customer. The following table provides the capacities of the facilities and the shipping cost per unit to each facility. 1. Create a network distribution map. 2. Create an Excel template for the transshipment problem. 3. Use Solver to optimize the shipping plan which minimizes total cost. 4. Develop a report which includes a table with each route used, units shipped on each route, and total cost for units shipped on each route. 5. Briefly discuss why some routes are not used by analyzing the sensitivity report