In: Statistics and Probability
The Hyundai dealer at Muscat needs to decide on how to ship new automobiles from two ports (Sohar and Muscat) to four of their agencies in Muscat, Sohar, Nizwa and Salalah. The following table summarizes the transportation costs incurred per automobile (in OMR).
Muscat |
Sohar |
Nizwa |
Salalah |
Capacity |
|
Muscat |
20 |
80 |
60 |
150 |
200 |
Sohar |
70 |
20 |
50 |
200 |
100 |
Demand |
100 |
80 |
40 |
60 |
All four agencies expressed interest in increasing their demand for new cars; however, the company can only accommodate one demand increase, which agency would you recommend? Justify your answer
The decision variables are:
xMM = # of orders from Muscat to Muscat
xMSO = # of orders from Muscat to Sohar
xMN = # of orders from Muscat to Nizwa
xMSA = # of orders from Muscat to Salalah
xSM = # of orders from Sohar to Muscat
xSSO = # of orders from Sohar to Sohar
xSN = # of orders from Sohar to Nizwa
xSSA = # of orders from Sohar to Salalah
The objective function is:
Min = 20xMM + 80xMSO + 60xMN + 150xMSA + 70xSM + 20xSSO + 50xSN + 200xSSA
The Shipping plan is:
Muscat | Sohar | Nizwa | Salalah | Capacity | |
Muscat | 100 | 0 | 20 | 60 | 180 |
Sohar | 0 | 80 | 20 | 0 | 100 |
Demand | 100 | 80 | 40 | 60 |
The total cost is:
Total Cost | 14800 |
From the output, we can say that the company should change the orders for Muscat ti 180 and Sohar should be the same as 100.
The demand should be increased for Muscat as it has the highest number of orders.