5. Conclusion
This research deals with the problems of high inventory and warehouse costs for the case study of 10 Thai traditional wholesale businesses of consumer products that bear high cost. The wholesale businesses of consumer products consist of a few hundred suppliers and almost fifty thousand of SKUs (Stock Keeping Units), which are hard to manage in terms of inventory and warehousing. Thai traditional purchasing has been decided more through feeling than facts. Clearly, general purchasing theory can be considered facts, such as Economic Ordern Quantity (EOQ); however, it is not applied directly for executing because it only required intangible data and purchasing execution also required the period order quantity (POQ) with suppliers. We have created the inventory and warehouse model by using forecasting model, re-layout warehouse, new inventory model, and marketing strategy to reduce cost in wholesale businesses. Therefore, the integration of all segments is a single window management in Excel, and then it is considered the best way for executing business. In the case study of 10 Thai traditional wholesale businesses, the inventory and warehouse models can reduce the total inventory and warehouse cost to approximately 136.8 million baht.