Paris Supreme has plants at Node 1 and Node 2 producing tires for trucks at weekly rates of 2500 units and 3500 units respectively. The units are transported to one of the two warehouses at Node 3 and Node 4, and then to retailers at Node 5, Node 6 and Node 7. The transport costs per unit (in euros) and demands of the retailers are shown below. The objective is to find the cheapest transport scheme. Let xij be the number of units to be transported from Node i to Node j. Solve the LP problem using Excel and answer the following questions on Moodle. Paris Supreme has plants at Node 1 and Node 2 producing tires for trucks at weekly rates of 2500 units and 3500 units respectively. The units are transported to one of the two warehouses at Node 3 and Node 4, and then to retailers at Node 5, Node 6 and Node 7. The transport costs per unit (in euros) and demands of the retailers are shown below. The objective is to find the cheapest transport scheme. Let xij be the number of units to be transported from Node i to Node j. Solve the LP problem using Excel and answer the following questions on Moodle