Best-in-class system to manage serialized inventory with consumable quantity