Question: TireXR has plants at Node 1 and Node 2 producing tires at weekly rates of 2500 units and 3500 units respectively. The units are transported

TireXR has plants at Node 1 and Node 2 producing

TireXR has plants at Node 1 and Node 2 producing tires 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 dollars) and demands of the retailers are shown below. Node 3 4 1 5 4.2 2 5.5 4.5 Node = 5 demand = 1250 9.2 7.2 6 demand = 1500 8.5 8 7 demand = 2000 6.2 5.2 3 4 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. Question 1.1: Fill in the boxes in the partial Excel spreadsheet (provided in Moodle). Question 1.2: Find the optimal transport scheme. Question 1.3: Find the minimum total transport cost

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!

1. (35 marks) TireXR has plants at Node 1 and Node 2 producing tires at weekly rates of 2500 units and 3500 units respectively. The units are transported to one of the two warehouses at Node 3 and...

Please fill in the blank of question 1.1 that shown follow : TireXR has plants at Node 1 and Node 2 producing tires at weekly rates of 2500 units and 3500 units respectively. The units are...

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...

1. (35 marks) 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...

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...

1. (37.5 marks) A French company has two plants at Versailles and Rennes producing certain food product at weekly rates of 3000 units and 4500 units respectively. The units are transported to one of...

1. Find the optimal solution. 2.Find the minimum total transport cost. 3.Consider the unit transport cost from Lyon to Marseille. What is the highest cost it can increase to without changing the...

3. (24 marks) Firelands Electronic has plants at two locations manufacturing heat sinks to be used in computers. The monthly production levels of the plants at location 1 and location 2 are 10,000...

On June 1, 2011, bids were submitted for a construction project to build a new municipal building and fire station. The lowest bid was $5,130,000, submitted by the Shannon Construction Company....

Draw the stress-strain curve of steel and concrete. Label the curve and explain each labeled point of the curves.

Substantive procedures to examine the occurrence assertion for accounts payable include: Group of answer choices selecting a sample of vouchers and tracing them to the purchases journal. comparing...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...