All Member Open Forum

 View Only

  • 1.  MIN-MAX Calculation

    Posted 10-13-2023 08:52 AM

    Hello Everyone,

    Hope this meets you all well.

    Please I require some help with inventory min-max calculations.

    Does anyone have any realistic excel formulas for calculating min-max for inventory?

    I have all the inventory usages from previous 3 years, but I need an active formula for min-max values.

    I appreciate any help offered.



    ------------------------------
    Tammy Karibo
    Reliability Engineer
    Enerflex
    Abu Dhabi
    ------------------------------


  • 2.  RE: MIN-MAX Calculation

    Posted 02-22-2024 08:08 PM
    Edited by Glenn Simmonds 02-22-2024 08:30 PM

    There are several good resources for this:

    Chapter 5 of Maintenance and Reliability Best Practices 3rd edition by Ramesh Gulati

    Chapter 4 of Cover your Assets by Dr John L Ross Jr

    the entire book Smart Inventory Solutions 2nd edition by Phillip Slater

    You have to really understand exactly what type of inventory you're talking about because min-max might not be the right strategy at all. Each of these texts will help you break down your inventory into the proper segments to help perform the analysis to set a proper stocking level.

    Good luck.

    Glenn Simmonds



    ------------------------------
    Glenn Simmonds
    Senior Manager - Corporate Machine Reliability

    Sabert Corporation
    ------------------------------

    Original Message


  • 3.  RE: MIN-MAX Calculation

    Posted 02-23-2024 12:24 AM

    Do you want to design an excel spreadsheet that will track min-max or you want an inventory application software that will track it??



    ------------------------------
    [Segun]
    [B.tech, MEM]
    [QA/QC & Parts Person]
    [British Columbia]
    [adedejiaderibigbe@yahoo.co.uk]
    ------------------------------

    Original Message


Related Content