Preview

Modi

Good Essays
Open Document
Open Document
848 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Modi
Transportation Problems
Transportation is considered as a “special case” of LP

Reasons? it can be formulated using LP technique so is its solution

Here, we attempt to firstly define what are them and then studying their solution methods:

Transportation Problem
We have seen a sample of transportation problem on slide 29 in lecture 2

Here, we study its alternative solution method

Consider the following transportation tableau
Review of Transportation Problem
A Transportation Example (2 of 3) Model Summary and Computer Solution with Excel
Transportation Tableau
We know how to formulate it using LP technique
Refer to lecture 2 note
Here, we study its solution by firstly attempting to determine its initial tableau
Just like the first simplex tableau!

Solution to a transportation problem

Initial tableau

Optimal solution

Important Notes

Tutorials initial tableau
Three different ways:
Northwest corner method
The Minimum cell cost method
Vogel’s approximation method (VAM)

Now, are these initial tableaus given us an Optimal solution?
Northwest corner method
Steps:
assign largest possible allocation to the cell in the upper left-hand corner of the tableau
Repeat step 1 until all allocations have been assigned
Stop. Initial tableau is obtained

Example
Northeast corner
Initial tableau of NW corner method
Repeat the above steps, we have the following tableau.
Stop. Since all allocated have been assigned
The Minimum cell cost method
Here, we use the following steps:
Steps:
Step 1 Find the cell that has the least cost
Step 2: Assign as much as allocation to this cell
Step 3: Block those cells that cannot be allocated
Step 4: Repeat above steps until all allocation have been assigned.

Example:
Step 1 Find the cell that has the least cost Step 2: Assign as much as allocation to this cell
Step 3: Block those cells that cannot be allocated Step 4: Repeat above steps until all allocation have been

You May Also Find These Documents Helpful

  • Satisfactory Essays

    D. Helga can slide cells to the four boxes or double-click properties to choose from a list of pivot table options.…

    • 985 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Health & Safety

    • 792 Words
    • 4 Pages

    Going through this list – explain how they might be applied to this example to provide potential solutions.…

    • 792 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Test Physic 1401

    • 1086 Words
    • 5 Pages

    More than four problems from Section II can be attempted. However, points will be awarded for only the best four answers.…

    • 1086 Words
    • 5 Pages
    Good Essays
  • Good Essays

    ECET 370 Week 5 Lab 5

    • 650 Words
    • 3 Pages

    This work of ECET 370 Week 5 Lab 5 shows the solutions to the following problems:…

    • 650 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Week 10 Assignment 4

    • 714 Words
    • 3 Pages

    2. Solving the problem by using Solver of M S Excel, the answer report is given below:…

    • 714 Words
    • 3 Pages
    Good Essays
  • Good Essays

    range B9:F9 and calculate the apartment complex totals in the range G5:G8. In cell G9, enter a grand…

    • 369 Words
    • 2 Pages
    Good Essays
  • Good Essays

    a. Using solver to solve the embedded model in the Excel sheet or by trying different values for h the optimum value will be obtained as “h=4”…

    • 956 Words
    • 4 Pages
    Good Essays
  • Good Essays

    After completing the formula in cell D3, copy the formula to cells D4 and D5.…

    • 571 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Electro Inc

    • 1148 Words
    • 5 Pages

    This relates to the budgeting problem, how to reasonably distribute the production within restrict of total 120,000 EWUs, this can either calculate by solver using Excel or list two equations. The basic principle is…

    • 1148 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Assignment

    • 287 Words
    • 2 Pages

    Your solution to the above problems, making sure to include all mathematical work, and an explanation for each step…

    • 287 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The objective function of the manager is to minimize the total transportation cost for all shipments. Therefore, the objective function is the sum of the individual shipping costs…

    • 2044 Words
    • 9 Pages
    Satisfactory Essays
  • Better Essays

    Goal: Create an Excel spreadsheet to allocate costs using the direct method and the stepdown…

    • 1247 Words
    • 5 Pages
    Better Essays
  • Better Essays

    stateline shipping

    • 1099 Words
    • 4 Pages

    This Case Problem, Stateline Shipping and Transport Company, is based on a girl named Rachel Sundusky who is a manager of the South-Atlantic office for Stateline Shipping and Transport (Taylor, 2010). Rachel is negotiating a contract with Polychem an industrial use chemical company (Taylor, 2010). Polychem has six sites that it would like for Stateline to pick up waste from (Taylor, 2010). Polychem would then like for Stateline to transport the waste for disposal to one of three sites (Taylor, 2010). Polychem has agreed to handle all of the waste at all sites therefore Stateline needs only transport the materials and incur costs for the same (Taylor, 2010). Rachel would like to see what the less costly shipping routes are (Taylor, 2010). Rachel will need all of the pertinent information, i.e. cost per unit, cost per trip, and total shipment cost in order to be able to give an accurate proposal to Polychem (Taylor, 2010). For this assignment the instructor determined we should only complete part one. Therefore the model below works out Rachel’s route costs not optimal routes.…

    • 1099 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    Goal: Create an Excel spreadsheet to allocate costs using the direct method and the step-down method. Use the results to answer questions about your findings.…

    • 464 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    linear programming

    • 354 Words
    • 2 Pages

    Spreadsheet Modeling and Excel Solver A mathematical model implemented in a spreadsheet is called a spreadsheet model. Major spreadsheet packages come with a built-in optimization tool called Solver. Now we demonstrate how to use Excel spreadsheet modeling and Solver to find the optimal solution of optimization problems. If the model has two variables, the graphical method can be used to solve the model. Very few real world problems involve only two variables. For problems with more than two variables, we need to use complex techniques and tedious calculations to find the optimal solution. The spreadsheet and solver approach makes solving optimization problems a fairly simple task and it is more useful for students who do not have strong mathematics background. The first step is to organize the spreadsheet to represent the model. We use separate cells to represent decision variables, create a formula in a cell to represent the objective function and create a formula in a cell for each constraint left hand side. Once the model is implemented in a spreadsheet, next step is to use the Solver to find the solution. In the Solver, we need to identify the locations (cells) of objective function, decision variables, nature of the objective function (maximize/minimize) and constraints. Example One (Linear model): Investment Problem Our first example illustrates how to allocate money to different bonds to maximize the total return (Ragsdale 2011, p. 121). A trust office at the Blacksburg National Bank needs to determine how to invest $100,000 in following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax-Free A B C D E 9.5% 8.0% 9.0% 9.0% 9.0% Long Short Long Long Short High Low Low High High Yes Yes No Yes No The officer wants to invest at least 50% of the money in short term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments, and at least 40% of the total return should be…

    • 354 Words
    • 2 Pages
    Satisfactory Essays