How do I complete this on excel using Solver? A company needs to determine the best location for its new warehouses to serve four retail stores. The company has identified three potential warehouse locations. The goal is to minimize the total cost, including the fixed costs of opening warehouses and the transportation costs of serving the retail stores.

Data:

$$ Fixed Costs for Establishing Warehouses:

o Location $1$: $$30,000$

o Location $2$: $$25,000$

o Location $3$: $$20,000$

$$ Transportation Costs per Unit:

o To Retail Store $1$: $[$ $$4$ from Location $1,$ $$6$ from Location $2,$ $$9$ from Location $3]$

o To Retail Store $2$: $[$ $$5$ from Location $1,$ $$4$ from Location $2,$ $$7$ from Location $3]$

o To Retail Store $3$: $[$ $$8$ from Location $1,$ $$3$ from Location $2,$ $$4$ from Location $3]$

o To Retail Store $4$: $[$ $$6$ from Location $1,$ $$5$ from Location $2,$ $$8$ from Location $3]$

$$ Demand at Retail Stores:

o Retail Store $1$: $1000$ units

o Retail Store $2$: $1500$ units

o Retail Store $3$: $1200$ units

o Retail Store $4$: $1800$ units