A Case Study of Decision Support System and Warehouse Management System Integration

A Case Study of Decision Support System and Warehouse Management System Integration

Alparslan Sari, Ismail Butun
DOI: 10.4018/978-1-7998-7468-3.ch006
(Individual Chapters)
No Current Special Offers


A warehouse is an indispensable part of the logistics. A warehouse management system (WMS) is designed to improve efficiency in warehouses to increase their throughput and potential. The rise of IoT and its commercialization enabled ‘smart things' to be widely adopted by hobbyists and companies. Cheap sensors and smart devices triggered better automation opportunities. Many devices and sensors that are being deployed in the industry and warehousing are affected by this trend. A well-designed WMS is needed to connect devices and humans in a heterogenous warehouse environment. This chapter introduces a prototype of a WMS powered by a decision support system (DSS) based on real-life requirements. In order to have fast, reliable, and efficient decision making in warehousing, the importance of employing DSS in the WMS is emphasized. Warehouse-related IoT technology is briefly introduced, and its security considerations are discussed thoroughly. The main contribution of this chapter is to show how warehouse operations can be modeled in business process model notation and executed in a DSS.
Chapter Preview


Logistic is one of the major powerhouses to advance human civilization from the old times to the modern age. Many civilizations collapsed due to famine and lack of resources in the past. However, the improvement in logistics enabled resource sharing between nations in a cost-efficient manner and the industrial revolution enabled large-scale production with low cost. The Internet was a game-changer for traditional commerce where customers needed to go to stores for shopping. Rapid development in e-commerce triggered storage problems for produced products as well as for raw materials. Therefore, industrialization and logistics contributed to human welfare to help fight against famine and prevent the collapse of civilizations in the modern age. Industrial mass production helped to reduce the purchase cost and bring improvement in logistics - distribution of these products made them available in the global market at a fair price. A warehouse is an integral piece in the supply chain concept to store and forward goods. Many warehouses are being used for storing goods or processing the products in a custom manner like repackaging and bundling/knitting etc. The performance of the warehouse operations affects the overall productivity and cost for all stakeholders. The whole supply chain is tightly coupled with warehouse operations. In warehouse operations, repacking/preparing an order can be considered a labor-intensive and high-cost operation. In order to overcome this tedious manual-intensive labor, Amazon Inc. built semi-autonomous warehouses, which utilize almost 200,000 robots in operation within its warehouses in the US1. Amazon Inc. also cut jobs to replace manual work with automation and robot workers to optimize warehouse operations2. Amazon Inc. tries to increase the efficiency and throughput in warehouses with the power of automation. Any performance issues or complications in warehouse operations may result in congestion and delays in logistics, which causes financial loss, reputation loss, and reducing customer satisfaction, and affect the overall standing of an enterprise and other unwanted conditions.

The fundamental of warehousing is to provide essential services such as receiving shipments (inbound), storing, pick & pack process and sending (outbound) shipments. The pick and pack process is usually considered the most manual-intensive process in warehouse operations and it gets complex based on many different parameters such as working with many customers, managing a mix of large inventory (please see Figure 1). Major issues are inbound shipment scheduling, item processing in the warehouse (cleaning, repackaging, bundling, etc.), outbound shipment scheduling, optimizing financial cost, reconciliation process between customers.

The end-to-end warehouse process starts with a third-party logistics company transporting the delivery with a truck that docks the warehouse. Warehouse operators need to empty the truck at a given time. Based on the warehouse capacity, there are a limited number of docks available. If there is any slowness, all docks can be occupied with trucks and new truck arrivals cause congestion. Once the trucks are being emptied, operators need to store these products in a temporary space. If there is no sorting automation available that will fasten the overall process, operators manually sort the goods based on the customer then store them in a designated zone for these products which are assigned by WMS. These will prevent possible fragmentation of customer goods in the warehouse and will speed up the overall process. Also, the order picking process can be considered a highly time-consuming activity and a bottleneck in warehouse operations. To improve the operational efficiency and optimize the order picking process efficient location management is needed. Location management should be tightly coupled with inventory management (product location and storage location). Most of the time, products need to be processed per customer request then shipped to the final destination. The final destination could be another warehouse or an individual. These warehousing workflows briefly show us the need for efficient warehouse management systems with a decision support capability.

Figure 1.

The abstract view of warehouse operations and interactions.


Key Terms in this Chapter

DSS: A decision support system is software responsible for making decisions based on collected data and environmental inputs to support human operators. It could be fully automated or semi-automated (human input required to make decisions).

Denial-of-Service (DoS): A class of attack in which the targeted network or system disconnects and seizures the intended mode of operation.

WMS: A warehouse management system is a software package that is used to track the inventory life cycle in a warehouse or between warehouses and/or distribution centers (or an individual). It helps improve the warehouse operations like receiving a shipment, storing the product, preparing a product, or shipping away a product accurately and efficiently. It optimizes the warehouse operations and increases throughput.

Event: An expected or unexpected happening related to systems that are in operation.

ERP: Enterprise resource planning is a software package used for business process management. It helps in collecting, analyzing, and storing data as well as assisting business activities.

RFID: Radio-frequency identification uses electromagnetic fields to communicate between a radio transmitter and receiver. The data transmitted is used for identification and mostly used for inventory management and item tracking.

Anomaly: An abnormal behavior of the system or user.

Intrusion: An event in which an unauthorized user gathers a piece of information or an access right that he/she is not allowed to.

Security Risk Assessment: Identifying the vulnerabilities of a system along with the possible worst-case scenarios as well as the evaluation of total property losses in case of such events.

Sensors: These are responsible for collecting evidence regarding events.

Complete Chapter List

Search this Book: