What is the optimal cost of transportation

Assignment Help Operation Management

Reference no: EM13995204

Problem 1

The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow).

177_Optimal cost of transportation.jpg

a) Write the mathematical formulation of the problem.

b) Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment.

c) Provide the solution obtained in the space provided. What is the optimal cost of transportation?

Problem 2

By including intermediary distribution centers X and Y as shown in the figure and using the given network, will the company save money in its transportation costs compared to the results obtained in problem 1? (Note: For any two given nodes, a directed arrow represents an existing route between the two nodes.)

986_Optimal cost of transportation1.jpg

a) Write the mathematical formulation of the problem.

b) Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment.

c) Provide the solution obtained in the space provided. What is the optimal cost of transportation? Will the transportation costs be reduced after the intermediate points have been included?

Reference no: EM13995204

Questions Cloud

What is the speed of the masses at given position : What is the overall mechanical energy of the system once m2 moves 0.8 m up the incline? What is the speed of the masses at that position?

Generating public and financial support : A citizens' group interested in generating public and financial support for a new university basketball arena has published a questionnaire in area newspaper. Readers return the questionnaire by mail.

The financial statements for the period ended : After the end of the reporting period, a contingency comes into existence. Under what circumstances, if any, should the contingency be reported in the financial statements for the period ended?

Based on the lags associated with fiscal and monetary policy : Based on the lags associated with fiscal and monetary policy, which one of the two tends to be more quickly implemented? Justify your answer in one paragraph.

What is the optimal cost of transportation : Write the mathematical formulation of the problem - What is the optimal cost of transportation? Will the transportation costs be reduced after the intermediate points have been included?

Hierarchies will predominate in physical capital intensive : It has been suggested that large, tall hierarchies will predominate in physical capital intensive industries, and these will typically have seniority-based promotion policies. By contrast, flat hierarchies will be seen in human capital intensive indu..

Compare the types of information found in the articles : Compare the types of information found in the articles from different levels and the value of the information from each level

Rapid turnover among employees beneficial to the firm : It is said that the current generation of workers will have a very small probability of being employed by the same firm throughout their work life. In previous generations it was common for people to have just one employer. Is a more rapid turnover a..

Connection in microscopic molecule density and air pressure : Use the fact that g2=GME/(RE+h)2 at the top of Mount Everest where h is its height, can you explain using some connection between microscopic molecule density and macroscopic air pressure- why we can't boil an egg up there.

User Account

All Pages