Online retailing companies such as Amazon need to have access to a huge network of inventories in various locations in order to ship their products in a timely fashion to their customers. In the last few years, due to the expansion of the services such as (Amazon Prime) and the introduction of new services (such as Amazon Prime Now), the importance of effectively selecting the location of new warehouses and/or choosing the right local warehouse to work with has dramatically increased.

Because of the emerging demand, Amazon decided to start new warehouses in the Gulf Coast. Based on their studies, four potential locations for warehouses have been identified, each of which having a specific capacity and also a specific average cost-per-unit for shipping to any of the five Gulf Coast states. The capacity of each warehouse and its operating cost, in addition to the average cost-per-unit for shipping a product to any of the states are given in the following table.

	TX	LA	MS	AL	FL	Ops Cost	Capacity
WH1	$2.00	$4.00	$3.00	$2.50	$1.50	$10,000	14,000
WH2	$3.00	$2.50	$3.75	$2.00	$1.75	$8,000	18,000
WH3	$2.75	$2.00	$3.25	$3.00	$4.00	$7,000	16,500
WH4	$1.25	$1.75	$4.00	$3.50	$3.00	$12,000	16,000

The average demand for each of the states is given in this table.

	TX	LA	MS	AL	FL
Demand	8,000 units	3,500 units	4,000 units	2,000 units	7,000 units

Question: Build a model in Excel and use Solver to find which warehouses should Amazon operate to meet demand in the most cost-effective manner.