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

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 พ.ย. 2024

ความคิดเห็น • 26

  • @MoeDar-r8h
    @MoeDar-r8h ปีที่แล้ว +2

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

  • @niccovestbohattesen2201
    @niccovestbohattesen2201 2 หลายเดือนก่อน +2

    We are six people from HA Esbjerg That really liked your video :)

    • @joshemman
      @joshemman  2 หลายเดือนก่อน +1

      Glad to hear. 🙏

  • @seifunegewo4460
    @seifunegewo4460 ปีที่แล้ว +1

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

  • @ishitasharma5909
    @ishitasharma5909 ปีที่แล้ว

    Gr8 vedio , covered all the doubts

  • @KartikeyaDutta
    @KartikeyaDutta ปีที่แล้ว +2

    Master at work

  • @joylm9108
    @joylm9108 ปีที่แล้ว

    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

  • @cococnk388
    @cococnk388 ปีที่แล้ว

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

    • @joshemman
      @joshemman  ปีที่แล้ว

      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/

  • @WhitleyBobcat
    @WhitleyBobcat 4 หลายเดือนก่อน +1

    Math Master

  • @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 11 หลายเดือนก่อน

      howwwww

  • @kakikeki
    @kakikeki 10 หลายเดือนก่อน

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

    • @joshemman
      @joshemman  10 หลายเดือนก่อน

      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 7 หลายเดือนก่อน

    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  7 หลายเดือนก่อน

      Is your objective to minimize shipments?

    • @dirk6908
      @dirk6908 7 หลายเดือนก่อน

      @@joshemman Yes it is

    • @joshemman
      @joshemman  7 หลายเดือนก่อน

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

    • @dirk6908
      @dirk6908 6 หลายเดือนก่อน

      @@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  6 หลายเดือนก่อน +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 11 หลายเดือนก่อน

    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  11 หลายเดือนก่อน

      See if this helps: th-cam.com/video/ABMPgSApdUw/w-d-xo.html