Please use Excel. Thank you!

Problem 4. ABC Foods is in the process of expanding its distribution system. After some planned acquisitions, the company will have 10 distribution centers, with monthly volume requirements (in cartons) as listed below. Six of these sites will be able to support warehouses, in terms of the infrastructure available, and are designed by (W). Center Volume Center Volume Albuquerque (W) 3,200 Oklahoma City 3,500 Boise 2,500 Phoenix (W) 5,000 Dallas (W) 6,800 Salt Lake City 1,800 Denver (W) 4,000 San Antonio (W) 7,400 Houston (W) 9,600 Wichita 2,700 Because the properties have been acquired under different circumstances, they would have different characteristics if ABC Foods were to open warehouses at the sites. Their potential capacities (in cartons) and monthly operating costs are summarized in the following table: Warehouse Capacity Cost Albuquerque 16,000 $140,000 Dallas 20,000 $150,000 Denver 10,000 $100,000 Houston 10,000 $110,000 Phoenix 12,000 $125,000 San Antonio 10,000 $120,000 Formulate this cost minimization problem as an integer linear program and then solve it using SOLVER Use the information compiled in the table below) to show the cost per carton of shipping from each warehouse to any distribution center in the system. ABC Foods could open warehouses at any of the designated locations, but its criterion is to minimize total cost, including fixed operating costs and variable shipment costs. Alb From/To Boise Dallas Denver Houston Okla Phoenix Salt Wich SanA 47.0 32.0 22.0 Albuquerque 42.5 27.0 23.0 30.0 36.5 29.5 32.0 79.5 39.0 Dallas 12.5 10.5 50.0 63.0 13.5 17.0 Denver 21.0 39.0 42.0 51.5 31.5 40.5 26.0 24.0 47.5 Houston 42.5 91.0 31.0 12.5 23.0 51.5 72.0 58.0 10.0 Phoenix 49.0 23.0 52.0 50.0 32.5 58.0 40.50 49.0 50.0 San Antonio 36.5 47.5 83.5 13.5 32.0 66.5 10.0 24.0 50.0