Preview

Sasa

Good Essays
Open Document
Open Document
533 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Sasa
Introduction

The Transportation Problem
(Demand Does Not Equal Supply and Vice Versa)

Linear programming is a mathematical method that is used to apportion resources in as efficient a way as possible. It is used to conserve valuable assets and save money. It is sometimes referred to as LP.

The transportation method of linear programming is the specific application of LP that addresses transportation problems. Solving transportation problems is one of the most common uses of linear programming. It is also one of the most important, particularly in business settings. It often deals with the efficient and cost-effective physical allocation of products. However, they can also deal with things like employee placement. Such problems are sometimes referred to as assignment problems.

The function of the transportation method is not only to ensure that products are shipped cost-effectively. By making sure that products are shipping efficiently, the transportation method also ensures that customer needs are being met and shipping locations are operating at peak productivity.

To this point the transportation method has required that the supply and demand be equal: the rim requirements for the columns. This is unlikely; most real problems are of the so called unbalanced type, where supply and demand are unequal. In such cases there is the inequality.

Objective:

To be able to produce an Excel Program that can solve problem about Transportation Method in which demand does not equal supply and vice versa.

Scope and Limitation:

The Excel program that is made is not fully automatic operated. This program needs some manual operation in the beginning of the program and some parts upon replying the queries. The program can only calculate with a maximum of; three variance of supply and a dummy, and three variance of demand and a dummy. The program shows the total cost and solution for improvement.

The Program:

You May Also Find These Documents Helpful

  • Good Essays

    The problem basically consists of finding the optimum set of routes that represent the lowest possible total cost and/or total travel time. The plant is dealing with the repositioning of trucks to serve its supply demand and determining a number of transportation units that optimally balance supply requirements against the cost of maintaining the transportation units. In order to increase truck utilization and achieve better performance, the plant has to adequately and efficiently ensure the scheduling of a steady supply of hogs.…

    • 1274 Words
    • 6 Pages
    Good Essays
  • Good Essays

    ECO 550 FINAL EXAM

    • 1177 Words
    • 4 Pages

    9. The integer programming model for a transportation problem has constraints for supply at each source and demand at each destination.…

    • 1177 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Busn312 Hw3A

    • 727 Words
    • 3 Pages

    Linear programming problems have a.|linear objective functions, non-linear constraints.| b.|non-linear objective functions, non-linear constraints.| c.|non-linear objective functions, linear constraints.| d.|linear objective functions, linear constraints.| ____C 7. The first step in formulating a linear programming problem is a.|Identify any upper or lower bounds on the decision variables.| b.|State the constraints as linear combinations of the decision variables.| c.|Understand the problem.| d.|Identify the decision variables.| e.|State the objective…

    • 727 Words
    • 3 Pages
    Satisfactory Essays
  • Better Essays

    Acme

    • 1450 Words
    • 8 Pages

    Linear programming is the “several related mathematical techniques used to allocate limited resources among competing demands in an optimal way” (Jacobs & Chase, 2013, appendix…

    • 1450 Words
    • 8 Pages
    Better Essays
  • Good Essays

    Case 36

    • 637 Words
    • 3 Pages

    There is a total capacity (rail carloads) of 14 that is available to serve a total demand (rail carloads sold) of 15. With this mentioned, there is an unbalanced capacity and demand. To solve for the proper shipping route, we will have to include a dummy variable equal to 1, which is the difference between capacity and demand. This means one customer will receive a shortage of 1 rail car of grain. In addition, we need to meet certain requirements (constrains) that limit the capacity from origin (outbound) as well as (inbound) constraints at destinations. Not to mention, we also have two processing centers (hubs) constraints.…

    • 637 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    The Syllabus on Info 3010

    • 2401 Words
    • 10 Pages

    This course introduces students to the use of the computer as a business modeling tool. The overarching goal is to teach students to use computers to analyze models and data for integrated decision making across multiple domains including finance, marketing, accounting, strategy, and operations. The course proceeds in several parts: 1) Data Modeling - building on INFO 1010 and MATH 1140, the course will review data modeling in Excel; 2) Deterministic Modeling - the course will cover decision-making under uncertainty using optimization models such as linear programming. Problems such as portfolio optimization, transportation, assignment, set-covering, and scheduling are covered and the concepts of problem formulation and sensitivity analysis are introduced; 3) Spreadsheet Automation - concepts for programming in Excel will be introduced; and 4) Probabilistic Modeling decision making in an environment of uncertainty is covered using simulation and the principles of decision analysis. Students will also learn to choose the appropriate probability distribution for a given problem.…

    • 2401 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    Mat 540 Quiz 4

    • 1474 Words
    • 6 Pages

    The standard form for the computer solution of a linear programming problem requires all variables to be to the right and all numerical values to be to the left of the inequality or equality sign…

    • 1474 Words
    • 6 Pages
    Satisfactory Essays
  • Powerful Essays

    Transportation is a service offered via transportation infrastructure (with capacity), a movement of passengers and goods from one place to another. The term Transportation planning refer to use system and analytical tools to analyze,…

    • 3691 Words
    • 15 Pages
    Powerful Essays
  • Satisfactory Essays

    Quiz 4

    • 1484 Words
    • 11 Pages

    In formulating a typical diet problem using a linear programming model, we would expect most of the constraints to be related to calories.…

    • 1484 Words
    • 11 Pages
    Satisfactory Essays
  • Good Essays

    DMO Session B12

    • 1077 Words
    • 12 Pages

    Transshipment problem is a special type of transportation problem involving intermediate nodes. These problems in which a shipment may move through intermediate nodes before reaching a particular destination node. It can be converted to larger transportation problems and solved by a special transportation program. It can also be solved by general purpose linear programming codes.…

    • 1077 Words
    • 12 Pages
    Good Essays
  • Good Essays

    supply at each source and the demand at each destination are limited to one unit each.…

    • 3035 Words
    • 13 Pages
    Good Essays
  • Powerful Essays

    Ans : Linear Programming is a mathematical technique useful for allocation of scarce or limited resources to several competing activities on the basis of given criterion of optimality.…

    • 1244 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    Protac

    • 827 Words
    • 4 Pages

    1. 2. 3. 4. 5. Solver y programación lineal El modelo Optimización Informes en excel Ejercicios…

    • 827 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    Quantitative Technique

    • 1209 Words
    • 5 Pages

    ``Linear programming is one of the most frequently and successfully employed Operations Research techniques to managerial and business decisions.’’ Elucidate this statement with some examples.…

    • 1209 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Presensattion

    • 2146 Words
    • 9 Pages

    However, there are many computer packages (including The Management Scientist) that contain separate computer codes for these models which take advantage of their network structure. © 2008 Thomson South-Western. All Rights Reserved Slide 3 Transportation Problem…

    • 2146 Words
    • 9 Pages
    Satisfactory Essays