Solve Transportation Problem

Solve Transportation Problem-54
The model we are going to solve looks as follows in Excel. What is the overall measure of performance for these decisions? Explanation: The SUM functions calculate the total shipped from each factory (Total Out) to each customer (Total In).

Tags: Comment Faire Un Business PlanProblem Solving In Quadratic EquationEquality Rights EssayDescriptive Essay For Grade 8Reflective Essay On English 101College Term PapersSchwa EpenthesisCsu Chico Application EssayEssay On My Married Life

In this paper, we consider a class of transportation problems which arises in sample surveys and other areas of statistics.

The associated cost matrices of these transportation problems are of special structure.

The weighted Hungarian method proposed in the paper can be used for solving transportation problem.

Wiley Online Library requires cookies for authentication and use of other site features; therefore, cookies must be enabled to browse the site.

To learn more or modify/prevent the use of cookies, see our Cookie Policy and Privacy Policy.

uses cookies to personalize content, tailor ads and improve the user experience. Received 24 November 2015; accepted 1 March 2016; published 4 March 2016 1. There are m sources and n destinations, each represented by a node. The objective function minimizes the total cost of transportation (Z) between various sources and destinations. (2014) Advanced Vogel’s Approximation Method (AVAM): A New Approach to Determine Penalty Cost for Better Feasible Solution of Transportation Problem.Introduction Transportation problem is famous in operation research for its wide application in real life. The arcs represent the routes linking the sources and destinations. The constraint i in the first set of constraints ensures that the total units transported from the source i is less than or equal to its supply. International Journal of Engineering Research & Technology (IJERT), 3, 182-187.・ Phase 2: Finding an initial basic feasible solution. If there is no odd cost in the cost cells of the TT, keep on dividing all the cost cells by 2 (two) till obtaining at least an odd value in the cost cells. ・ Phase 3: Optimize the initial basic feasible solution which is obtained in Phase 2. [9] , Kasana & Kumar [10] , Kirca and Satir [11] , M. ・ Step-4: Form a new table which is to be known as allocation table (AT) by keeping the MOC in the respective cost cell/cells as it was/were, and subtract selected MOC only from each of the odd cost valued cells of the TT. Detailed information on how Wiley uses cookies can be found in our Privacy Policy.Formulate the Model | Trial and Error | Solve the Model Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost. Allocate this minimum of supply/ demand in the place of odd valued ACVs at first in the AT formed in Step-4. In case of same ACVs, select the ACV where minimum allocation can be made. Again in case of same allocation in the ACVs, choose the minimum cost cell which is corresponding to the cost cells of TT formed in Step-1 (i.e. (2012) The Impact of Transportation Cost on Potato Price: A Case Study of Potato Distribution in Bangladesh. For example, if we ship 100 units from Factory 1 to Customer 1, 200 units from Factory 2 to Customer 2, 100 units from Factory 3 to Customer 1 and 200 units from Factory 3 to Customer 3, Total Out equals Supply and Total In equals Demand. To find the optimal solution, execute the following steps. On the Data tab, in the Analyze group, click Solver. Check 'Make Unconstrained Variables Non-Negative' and select 'Simplex LP'.


Comments Solve Transportation Problem

The Latest from ©