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 Order
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
Thai traditional wholesale businesses, the inventory and warehouse models can reduce the total inventory and
warehouse cost to approximately 136.8 million baht.