Sage 100

 View Only
  • 1.  OLD MRP

    Posted 11-22-2022 16:36
    Client is wondering why MRP is suggesting POs be created so that product ARRIVES when Reorder Point is hit, rather than being CREATED when Reorder Point is hit.

    Is this incorrect in MRP, or is that how it is supposed to work?

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------


  • 2.  RE: OLD MRP

    Posted 11-22-2022 16:53
    I'm not an mrp expert however I image a lead time needs to be factored in whether manufacturing or ordering

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: OLD MRP

    Posted 11-22-2022 16:56
    See, I KIND of feel that way, but I also feel like you take lead times into account when you determine your Reorder Point in the first place, so this is kind of like double-dipping.  Otherwise you'd just leave your Reorder Pt at 0 all the time.

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 4.  RE: OLD MRP

    Posted 11-22-2022 17:15
    If the reorder point is 0 then the reorder report doesn't show the need to reorder until the quantity on hand is 0.

    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 5.  RE: OLD MRP

    Posted 11-23-2022 09:50
    MRP does work the way you described and that is common in other systems I have used.  You could say this is incorrect and that it should suggest the order when the reorder point is hit but I doubt Sage will change it.

    FWIW here is the spiel I give clients:  Reorder points are best used for items where the demand is not forecasted and where demand visibility is limited.  An example would be a retail or web store where there are random customers who make purchases - there is a sales history that can be used to calculate the reorder point but no recurring customers who have future deliveries on order.  In theory if there is enough quantity in the reorder point to cover historical demand for the product lead time plus one week for cushion MRP isn't needed.  Just use the reorder report, order when something falls below the reorder point and it will arrive before you run out.

    When there is a forecast or demand visibility in the form of orders scheduled for future deliveries MRP "time phases" the supplies and demands and as you said recommends PO delivery when the quantity goes below the reorder point.  This usually causes extra inventory to be on hand.  For situations like this the reorder point can be used for a "safety stock" to provide some cushion for unexpected demand but not to cover the entire lead time of the item.  That usually means the reorder point is lower because the purpose has changed.

    I also tell clients that reorder points are not "set it and forget it" no matter how they are used.  They should be reviewed and updated regularly or excess inventory will result.  If I had a nickel for every time someone said "MRP told me to order 500 of those and I have only sold 5 this year" when that sale caused the on-hand to drop below the reorder point that was set 10 years ago....

    I hope all that helps, let me know if there is anything I can clarify.

    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------



  • 6.  RE: OLD MRP

    Posted 11-23-2022 10:30
    @Bernie Lehman - thanks for the detailed explanation.  One thing I found kind of odd in MRP is that when I put in a couple of test orders to bring it down to exactly the reorder point, it didn't trigger a PO - but the Reorder Report seems to trigger right on the Reorder Pt, IIRC.  MRP waited until it went UNDER the Reorder Pt.​

    ------------------------------
    Beth Bowers
    (269) 358-0989
    ------------------------------



  • 7.  RE: OLD MRP

    Posted 11-23-2022 11:08
    That is interesting - must be the logic for the Reorder Report is if the reorder point <> 0 then it triggers at the reorder point.  MRP does wait until the quantity goes below the reorder point.  Nice and consistent......

    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------