Solve Transshipment in Excel | Network Flow | Plant - Warehouse - Distribution Centre

Поділитися
Вставка
  • Опубліковано 26 лип 2024

КОМЕНТАРІ • 24

  • @user-xl2bg2vr1d
    @user-xl2bg2vr1d Рік тому +1

    I like the format how you solve the problem. It is neat and clear! :)

  • @KartikeyaDutta
    @KartikeyaDutta Рік тому +2

    Master at work

  • @ishitasharma5909
    @ishitasharma5909 7 місяців тому

    Gr8 vedio , covered all the doubts

  • @seifunegewo4460
    @seifunegewo4460 Рік тому +1

    Please, I like your on linear programming problem. Upload more on operation research Assignment problem solutions

  • @WhitleyBobcat
    @WhitleyBobcat 16 днів тому +1

    Math Master

  • @cococnk388
    @cococnk388 10 місяців тому

    Thanks Emmanuel great video, do you have a dataset on transport data, that can help create dashboards and do transshipment analysis?

    • @joshemman
      @joshemman  10 місяців тому

      No I do not, but you can check this statcan page: www144.statcan.gc.ca/tdih-cdit/index-eng.htm
      Or contact the owner of blogs like this blog.enterprisedna.co/power-bi-sample-dashboard-using-logistics-data/

  • @joylm9108
    @joylm9108 8 місяців тому

    Why did you label the capacities at the demand and supply node net supply? Why did you also make the demand nodes a negative number when you didn’t do same in the transportation problem in the previous problem? Please reply. Thank you

  • @shubhanshupradhan7145
    @shubhanshupradhan7145 Рік тому

    Joshua- How to solve the problem if WH1 & WH2 has a pre-defined storage capacity in the contraint?

    • @joshemman
      @joshemman  Рік тому +1

      Suppose WH1 is constrained to handle no more than 500 units.
      In Solver, Click Add,
      For the LHS, select the cell G6 (see 0:59)
      For the sign, select “

    • @shubhanshupradhan7145
      @shubhanshupradhan7145 Рік тому

      @@joshemman The changing variables from plant to warehouse is not changing after applying limit contraint for the warehouses.
      If possible, could you please share your email so that I can share the question(has few more constraints) & my excel ?
      Thanks!

    • @joshemman
      @joshemman  Рік тому

      @@shubhanshupradhan7145 You can find my email in the ABOUT section or just search online.

    • @shubhanshupradhan7145
      @shubhanshupradhan7145 Рік тому

      @@joshemman Apologies, I am unable to find the email id. Kindly share it.

    • @hijjazdanial8499
      @hijjazdanial8499 7 місяців тому

      howwwww

  • @kakikeki
    @kakikeki 6 місяців тому

    hi, in unbalanced transshipment problem, can u explain why not putting dummy?

    • @joshemman
      @joshemman  6 місяців тому

      If you use ≤ for Supply, you only need dummy if Demand is greater than Supply.
      But if you use = for all constraints, you will need dummy whenever Supply ≠ Demand.

  • @dirk6908
    @dirk6908 2 місяці тому

    Dear Joshua, how could you minimize the amount of shipments being made in this situation if transshipment is not allowed and demand is being met?

    • @joshemman
      @joshemman  2 місяці тому

      Is your objective to minimize shipments?

    • @dirk6908
      @dirk6908 2 місяці тому

      @@joshemman Yes it is

    • @joshemman
      @joshemman  2 місяці тому

      @@dirk6908 if transshipment is not allowed, then you might have a basic transportation problem. How exactly is the problem worded?

    • @dirk6908
      @dirk6908 2 місяці тому

      @@joshemman The problem is worded as follows: Now imagine that management decides that shunting is not allowed. Management’s new objective is to satisfy the demand with a minimum total number of trains (under the assumption that a single train can contain any number of rail cars).

    • @joshemman
      @joshemman  2 місяці тому +1

      @@dirk6908 It sounds like you want to minimize the number of arcs (branches) used. Since each arc is associated with a decision variable, say Xi, then a binary model could work with objective like:
      Min ∑Xi
      where each X= 0 or 1.

  • @mdjulhasmondol7277
    @mdjulhasmondol7277 7 місяців тому

    Please let me anyone know what constraints should I use if Wholeseller 2 directly sell 30 units to the customers instaed of sending those 30 units to the Distributions center? @joshua emmanuel

    • @joshemman
      @joshemman  7 місяців тому

      See if this helps: ua-cam.com/video/ABMPgSApdUw/v-deo.html