It does not have to be such a challenge, however. The best inventory management software can help automate, optimize and streamline your process so you always know what you have on hand.

Wheelwright, Steven C., and William Schmidt. "Scientific Glass Incorporated: Inventory Management, Spreadsheet Supplement (Brief Case)." Harvard Business School Spreadsheet Supplement 104-210, June ...