Chemical inventory system design framework