Why do you want to use EOQ? EOQ was never meant to be used for MRO inventory. I would recommend using inventory turns as a true measure of how effective your inventory strategy is. Of course, do not use the value of critical spares in the calculation.
------------------------------
Andrew Gager CAMA, CMRP, CPIM, CRL, CSSGB
CEO / President
Wake Forest NC
------------------------------