How would you approach designing a software solution for inventory management in a manufacturing environment at Challenge Manufacturing?