All Member Open Forum

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
------------------------------

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
------------------------------

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]
------------------------------