Question: Hi, I need help solving these in excel. Please show how solve using Excel Solver, and include what formulas go into the cells. Thank you!

Hi, I need help solving these in excel. PleaseHi, I need help solving these in excel. Please show how solve using Excel Solver, and include what formulas go into the cells. Thank you!

2. A large Canadian retailer has decided to build a new warehouse to simplify its transportation network. The major sources and markets of this retailer, rate of shipping from/to these locations, and the amount of their supply/demand are given in the following tables. Coordinates Sources Rate ($ per ton per KM) Supply (tons) Vancouver 10 1200 4.2 2.4 Calgary 250 20 100 350 90 1000 700 Edmonton 225 Winnipeg 1300 1.9 500 Markets Coordinates X Y Rate ($ per ton per KM) Demand (tons) 450 1.7 300 Saskatoon Toronto Montreal 1.1 1000 3500 3800 3200 8000 3.9 2200 1900 500 500 200 160 110 Ottawa Halifax 4.4 8.1 / a. Calculate where the warehouse should be located (find the X and Y coordinates of the warehouse) if the goal is minimizing the transportation costs. (10 points) b. Calculate the total cost of shipping from the suppliers to the warehouse, and from the warehouse to the markets assuming that: 1) all the supplies will be shipped to the warehouse; the amount of shipment from the warehouse is limited to the amount that satisfies the demand. (5 points) 2) the amount to ship from all the sources to the warehouse is limited to the amount that satisfies the demand. (5 points)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!