this is a solver question

QPP, a large Canadian retailer, has decided to build a new warehouse to simplify its transportation network. The major sources and markets of QPP, rate of shipping from/to these locations, and the amount of their supply/demand are given as follows: QPP.xlsx 3 Calculate where the warehouse should be located (nd the X and Y coordinates of the warehouse) if the goal is minimizing the transportation costs. Mention the X coordinate here. Note: Perform your analysis on the original model. In other words, the changes from one question do not carry over to the next questions. For the QPP question, calculate the total cost of shipping from the suppliers to the warehouse, and from the warehouse to the markets if all the supplies will be shipped to the warehouse; the amount of shipment from the warehouse is limited to the amount that satises the demand. For the QPP question, calculate the total cost of shipping from the suppliers to the warehouse, and from the warehouse to the markets if the amount to ship from all the sources to the warehouse is limited to the amount that satises the demand. Coordinates Sources Rate (ri) Ton (Si) X (di) Y Vancouver 10 20 4.2 3200 Calgary 250 100 2.4 1000 Edmonton 225 350 2.3 700 Winnipeg 1300 90 1.9 700 Coordinates Markets Rate (Ri) Ton (Mi) X (Di) Y Saskatoon 1000 450 1.7 300 Toronto 3500 80 1.1 2200 Montreal 3800 200 3.9 1900 Ottawa 3200 160 4.4 500 Halifax 8000 110 8.1 500\f