2.Consider a distribution planning problem with5warehouses (W1 to W5) and 10retailers (R1 to R10). Warehouse capacity is2000,3000,3000,2000,and 3200 respectively for W1 to W5. Retailer demands are (from R1 to R10):850,600, 850, 1900, 3100, 250, 350, 400,900,1400. The unit shipping costs (in dollars) between the warehouses and retailers is given in the table below. Determine the optimum distribution plan that will minimize the total cost (formulate and solve, e.g., using Excel solver).

4.Suppose in problem 2 a warehouse can supply at most 4 retailers. Develop a formulation. Dont worry about solving this one.

6.For problem 4, suppose now that for W1 and W2 there is a choice of having either a small capacity warehouse (capacity=90,000) for $3.5M or a large capacity warehouse (capacity=180,000) for $6M (note, the previous sized warehouse given in problem 2 for W1 and W2 is no longer available). Everything else is the same. Develop the appropriateformulation(no need tosolve).

SOLVE ONLY Q6 the other are for refrence