Maximo Open Forum

 View Only
Expand all | Collapse all

Min/Max/Reorder/Reserve

  • 1.  Min/Max/Reorder/Reserve

    Posted 05-30-2023 14:37

    I've previously saw and participated in a post regarding how Maximo reorders using the EOQ rather than calculating min/max on order/reserve and what to actually re-order. I do understand that in some instances an EOQ is used to obtain best price and/or shipping. We're finding it difficult to determine how much to actually order because there's no min/max, we use reserves and Maximo doesn't calculate what to actually order based on these things but instead just orders EOQ. 
    Has anyone come up with a method to quickly determine actual need? This is really time consuming requiring multiple reports and manual reviews before orders can be processed. It's my hope that IBM reconsiders the reorder process to, at the very least, offer options of ordering by EOQ or ordering based on min/max where on order and reserve quantities are taken into account with an actual quantity for order determined.


    #Procurement

    ------------------------------
    Gina Ordaz
    Idaho Milk Products
    ------------------------------


  • 2.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 09:24

    There are quite a few things to consider with regards to the EOQ for MRO. Some things to consider include the frequency of PMs requiring those parts, the number of CMs requiring the part, the lead time, the cost savings if purchasing in bulk, storage space, shelf-life, etc.  An analysis must be made regarding the effectiveness of the PM program which certainly impacts the calculations as well.  There are several other things to consider specific to your organization that may require additional guidance.



    ------------------------------
    Darrell Thomas
    Maximo Principal Consultant
    ------------------------------



  • 3.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 10:31

    Darrell

    I understand things that need taken into consideration but would hope there's a happy medium here. I've previously worked with Maximo where min/max was used with reserves, current balance, open orders, and reorder quantity was taken into account in calculating the quantity for order. This is one area that I really feel IBM took a step backwards.

     

    Thanks,

     

    Gina Ordaz

    Procurement Manager | Idaho Milk Products

    Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us

     

     






  • 4.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 10:27

    Might I also add that the reorder calculations matrix may also be applied to volumetric measures, so this is not specific to MRO parts.  It applies to raw materials as well.



    ------------------------------
    Darrell Thomas
    Maximo Principal Consultant
    ------------------------------



  • 5.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 10:34

    Darrell

    Our use of Maximo and reorders is not just for MRO parts. The reorder calculation matrix results in more work than it should.

     

    Thanks,

     

    Gina Ordaz

    Procurement Manager | Idaho Milk Products

    Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us

     

     






  • 6.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 12:00

    Gina,
    I think this is an interesting discussion with you and Darrell, and agree the Maximo product could use some additional functionality to support the supply chain and warehouse management capabilities.  Do you have some specific functionality that we could suggest to IBM to improve?  Maybe we could get enough support to get the changes implemented sooner rather than later?

    Appreciate your input, both of you!

    Larry



    ------------------------------
    Larry March
    Cohesive Solutions
    ------------------------------



  • 7.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 12:21

    Larry,

    What I'd like to see, and know is that when reorder is generated, Maximo considers the min/reorder point, outstanding order quantities, and reserves. When those are added together the difference between that total and the maximum should be what's ordered. Based on these discussions, there may be a need to select how an item is ordered either using the EOQ or the min/max method.

     

    Thanks,

     

    Gina Ordaz

    Procurement Manager | Idaho Milk Products

    Office 208-644-2889 | Cell 208-490-6198 |Email gordaz@idahomilk.us

     

     






  • 8.  RE: Min/Max/Reorder/Reserve

    Posted 05-31-2023 13:16

    Hi Gina,

    I've experimented with the database formulas from this post. It appears that you influence the reorder logic like this. Not sure how this would behave after upgrades. If IBM would refer in the reorder process using a formula like this, instead of Java class logic, customers could adapt to their needs. 
    http://maximoquest.blogspot.com/2018/08/power-of-maximo-formulas-build-logic-wo.html

    best regards, ruud



    ------------------------------
    ruud peters
    vanderlande
    ------------------------------



  • 9.  RE: Min/Max/Reorder/Reserve

    Posted 06-01-2023 10:21

    It appears as if there are additional things to consider that must be added to the calculation where data may or may not be included in the database.  For example, we have the reorder quantity, but does the order quantity factor the price break for MRO parts?  If not, should there be a distinction made?  Is the organization limited by space?  Are the reorder quantities truly based upon need, by the most reasonable price break, or by what one is able to store?  If in the case of MRO parts, is the PM generation and lead time aligned with the reorder and the individual lead time of the part to allow sufficient time for processing?  There still is a lot to be considered in the calculation, and in spite of all of our efforts to automate things, unfortunately, a significant amount of manual intervention is still necessary. 



    ------------------------------
    Darrell Thomas
    Maximo Principal Consultant
    ------------------------------



  • 10.  RE: Min/Max/Reorder/Reserve

    Posted 06-01-2023 11:56

    Unless something has changed recently, the EOQ in Maximo is treated as an Order Multiple rather than just a Minimum Order Quantity.  I have submitted RFEs in the past requesting a separate Order Multiple field but have been shot down.  So if your EOQ is 1000 and you have Reservations for 1200, Maximo may order 2000.  Again, I haven't tested it recently but that's the way it used to work.



    ------------------------------
    Julio Hernandez
    Ergonare, Inc.
    ------------------------------



  • 11.  RE: Min/Max/Reorder/Reserve

    Posted 06-01-2023 16:13

    Julio,

    It still works the same in V7.6.1.2.  Just tested it, with a hard reservation for 1200, it reordered 2000.

    Thanks for this, it was a new one for me.

    Larry March

    Cohesive Group



    ------------------------------
    Larry March
    Cohesive Solutions
    ------------------------------