Monitoring System Using GPS for Logistic’s Key Performance Indicator
Volume 4, Issue 6, Page No 32-37, 2019
Author’s Name: Abba Suganda Girsanga), Triadi Prabowo
View Affiliations
Computer Science Department, BINUS Graduate Program-Master of Computer Science, Bina Nusantara University, 11480 Jakarta, Indonesia
a)Author to whom correspondence should be addressed. E-mail: gandagirsang@yahoo.com
Adv. Sci. Technol. Eng. Syst. J. 4(6), 32-37 (2019); DOI: 10.25046/aj040604
Keywords: Kpi, Logistic, Gps, Tracking, Transporter
Export Citations
Transportation vendors are important for distribution companies to deliver goods or products. Operational problems of logistic process in transportation vendors’ activities are difficult to track and monitor directly in the field, such as driver’s position, the delivery, and so forth. These problems result in the difficulty to measure the performance of vendors’ activities. The aim of this research is to develop a system which covers monitoring and tracking of their logistic process operation problems. The system is built based on Android integrated with GPS and GSM. This system is also equipped with the ability to recapitulate the performance of transportation vendors in running activities of logistic operation. The performance is measured from some important components in logistic process. They are task asssment, on-time delivery, completed administration and availabilty. The result of this system is capable to show the vendor transportation’s key performance indicator (KPI) and minimalize bureaucratic problems.
Received: 24 July 2019, Accepted: 22 October 2019, Published Online: 22 November 2019
1. Introduction
The rapid growth of information technology has brought many changes to various business aspects, including logistics. Modern technologies such as GPS (Global Positioning System) and RFID (Radio Frequency Identification) can be used to change semi-manual process to systematic process [1]-[3]. Implementation of these technologies in logistic business sector enhances the performance of logistic process operation [4]. A survey shows that logistic company needs transparency in logistic process operation and more security [5]. GPS (Global Positioning System) is currently the most promising technology for acquiring position information in a field [6]-[9].
Manufacturers that process raw materials into ready-to-use product need logistic to transport their goods to other factories or their suppliers. Then, logistic operations provide transportation service of goods to desired locations (customer included) or warehousing. There are companies which keep their logistic function is part of the companies operation/business process and others keep their logistic function by using vendor transporters (outsourcing logistic) [10]-[12]. Both of them have advantages and disadvantages. Outsourcing logistic function has a high risk of loss competencies which may lead to high cost [13], 14] and hard to monitor their operation and management. Many researches look into logistic function outsource issues but few addressed so far about in-house logistic provider issues [10], [15], [16].
KPI (key performance indicator) in logistic business sector is mainly used to measure and show gaps between fundamental logistic process while delivering goods and the expected performance proposed by the company [17], [18]. Real-time data play a crucial part in this case, because obtaining information and giving feedback to correspondents can be done more quickly (between operators and courier). Implementation of websocket may help achieve that, because its behavior provides full-duplex, communication channel that operates through a single connection which builds scalable and real-time application [19] .
We found empirical findings based on some cases in company. However, in this paper, a cement company, PT. XYZ, is used as a reference. This company uses outsourcing logistic function (vendor transporter). It is facing some issues, such as the incapability of the to complete given assignments, goods not delivered on time, incomplete documents, and availability of fleet difficult to maintain and ready to use. This study proposes a new approach to implementing fleet-management and vendor performance evaluation (KPI). Monitoring application based on node.js platform and android as its client is implemented in this case. It is expected to minimize the risk of outsourcing its logistic provider such as monitoring transporter movement and recording the whole trip data, which is later used to evaluate the transporter’s performance in doing logistic functions, and capable to evaluate vendor transporter KPI.
The study provides a system of performance for companies which use logistic transporters based on tour records of their drivers. This system is built based on four indicators obtained from the activities of the drivers.
2. Proposed Method
The proposed method is mainly aimed to identify the criteria which should be considered in vendor transporter work performance (KPI) evaluation aspect. We include relevant KPI aspects such as task assignment, manageable delivery time, completed administration and fleet availability management and its system design to achieve related aspects.
2.1. System design
Many technique designs are proposed to develop the system. Figure 1 indicates the scheme of our framework to implement monitoring logistic operation system, which is integrated with GPS (global positioning system) to monitor fleet movement in an on-going delivery process. By using device (smartphone) on each transporter, a real-time communication between transporter and head officer (HO) can be done. It look like using emitting data transaction through websocket [20]. It is to achieve full-duplex communication between client and server.
Figure 1: Proposed framework scheme
Three main actors in logistic function operation, which are HO (head officer), vendor transporter, and transporter (driver), are involved in the evaluation of vendor transporter KPI. Internal staff as head officer handles all data transactions between headquarter (HQ) and client (in this case vendor transporter and driver). The design steps can be described as follows. First, head officer input the required trip data (task assignment) which will be assigned to selected vendor. Then, it is processed by vendor and given to transporter (driver). All activities recorded in application device is bundled into one production data including the history of transporter position using GPS emitted from the device. It becomes an output to trip data history. Then, the trip data will be processed by head officer to assess or evaluate KPI of vendor transporter within each evaluation period time.
There are some steps to develop real-time monitoring and tracking system.
Business Requirement Analysis. This phase gathers information regarding business process from process business by interview with related job description required to obtain the requirements.
User Requirement Analysis. This phase is to obtain information from process owner regarding the new proposed model.
Evaluation analysis. Based on requirements analysis, the best method is chosen and transformed into suitable aspects evaluation.
Prototyping. This step is conducted in the architectural design and development of products or services. In this case, the requirements are transformed into an application to understand the system method or concepts.
Implementation. In this phase, the new proposed method is implemented which is customized based on existing business model and solving the current problem.
Reporting (Documentation). Reporting or documentation is taken to track which parts of model is proven to be successful or failed as the solution of the problems.
2.2. The Interview
One of the techniques to obtain information and data in this research is using interview [21]. The discussion of process logistic and performance is done with all stakeholders related to the KPI. Some questions used are listed below.
- What is the SOP (standard operational procedure) of logistic function in your company?
- What issues are faced by your company with the current SOP?
- How can the master data be obtained?
- What is going to happen if customers reject the delivery?
- What is going to happen if fleets or vehicles get trouble on delivery?
- Can vendor reject delivery orders?
- Can transporter vendor track their driver on their own or only based on your company’s monitoring function?
- What is the expectation of this proposed system?
- What is the KPI aspect you want to evaluate?
Table 1: KPI aspect evaluation
Aspects | Description | Grade |
Task assignment (TA) | Vendor capable to complete given DO | 25% |
On-Time Delivery (OTD) | Vendor capable to deliver goods on-time | 25% |
Completed Administration (CA) | Vendor capable to submit` required document | 25% |
Availability (A) | Vendor capable to make fleet ready in use (delivery order given) | 25% |
Total | 100% |
2.3. KPI Evaluation
The proposed system is developed based on vendor transporter’s KPI assessment. This KPI evaluation is important for PT. XYZ to make decisions whether to continue outsourcing the logistic with selected vendor or terminate the vendor and replace with a new one. The discussions and interviews were conducted by the authors with relevant parties to formulate KPI. As the results, there are four aspects as shown in Table 1. These aspects are formulated to evaluate KPI based on user requirements and the issues of outsourcing logistic functions. The four aspects have the same percentage because they are considered as having the same importance.
The four aspects on Table 1 are built based on the variables as shown in Eq (1), Eq. (2), Eq. (3) and Eq.(4).
Task Assignment (TA). Variable TA is derived from assignment (delivery order) completed by vendor divided by total assignment given per evaluation period as shown Eq. (1).
On-Time Delivery Target (OTD). Variable OTD is derived from completed delivery expectation (by customer) divided by total assignment given per evaluation period as shown Eq. (2).
Completed Administration (CA). Variable CA is derived from vendor capability to submit required document or return document to PT. XYZ as shown Eq. (3).
Availability (A). Variable A is derived from total accepted assignment or delivery order given by internal staff of PT. XYZ, and vendor must provide fleet based on contract while outsourcing permission as shown Eq. (4).
3. Results and Discussion
In the requirement analysis phase, user is able to set up fleet profile, fleet type, license number, and owner of the fleet. He / she can set up feature of transporter data registered under the vendor. Some features can be developed such as the capability to monitor and track location which allows user to use navigation to the destination place noted in delivery note document with Google Maps, delivery order allocation which allows user to set up delivery order dynamically and specifically, the function of Auto-Grab which allows user to grab delivery order along the way in specific radius near loading plant point, the function of Auto-Rejected when the transporter gets limit to order capacity per day, and emergency feature which allows transporter and operator (head officer) to communicate through application message system real-time (using websocket).
Figure 2 shows the proposed business process in logistic operation. The process starts with creating delivery order, then HO determines maps of transporter routes. After mapping transporter routes, driver will confirm the given task to accept or reject delivery order (DO). If transporter accepts the DO, he / she gets delivery number (usually called delivery note). After the transporter has the route, then it will be sent to customer. Once customer accepts the order, then customer will sign receipt document. However, if the customer rejects, the document will be returned back to HO.
Figure 3 shows the flow of the proposed system that can be adjusted dynamically to the defined KPI aspects. It is based on empirical findings in manufacture or company which outsources their logistic provider. There are four main data characteristics flow as: User request report, in which users will request through HTTP to get the report; in this case, the calculation is done in four aspects of KPI previously mentioned. Next is collect data, which is the data source from the delivery process or operational logistics processes that have been running. Data is stored on a local database that is directly integrated with the system and the database residing on the ERP system. The next is data processing, in which data obtained either through the ERP or local database provisioned in the development of this application is processed through back-end. This request will end to the user in the form of report. After getting the result, reports that have been processed will be displayed on the application interface to be viewed by the user who performs data request to be used as consideration or decision making from the user. Figure 4, Figure 5, Figure 6, Figure 7, and figure 8 show the KPI result report based on selected aspect and period. The proposed KPI calculates the overall KPI grade or score based on recorded activity data done in evaluation period time which include task assignment, on-time delivery target, completed administration and availability. The formula of the overall KPI is shown in Eq. (5).
Figure 2: Proposed business process in manufacturer
Figure 3: Flow system to evaluate KPI based on defined aspects
The Eq. (5) is calculated is based on Eq. (1), Eq.(2), Eq.(3) and Eq.(4). The result of Eq. (1) is be shown in Figure.4
Figure 4 the sample data of task assignment
The result of Eq. (2) can be shown on Figure 5
Figure 5 the sample data of On-Time Delivery Target.
The result of Eq. (3) can be shown on Figure 6
Figure 6 the sample data of completed administration
The result of Eq. (4) can be shown on Figure 7
Figure 7 the sample data of availability.
Figure 9: Monitoring data sample
This system uses the plugin cordova background geolocation to monitor and track module for implementing the system as shown in Figure 9 [22]. It logs all the required data to monitor transporter movements, such as device id, uuid, timestamp, latitude, longitude, accuracy, and activity (on_foot or stay still). Figure 10 shows the GPS (global positioning system) or GNSS (Global navigation satellite system) which allows users to determine location (geo positioning) from satellite signal reception [23]. As table 2 indicates, the authors performed the trial using the proposed system in transporter while doing delivery. Trial done on Oct 2019 shows fleet movement with registered trip ID and recorded date of trial This system has a unique system which makes the process efficient and transparent. This system is also very useful for company PT XYZ for monitoring the drivers’ activities. It can alsorate the transportation vendor. This system is able to evaluate the KPI of transportation vendor at PT. XYZ, which is influential in decision-making for contract extension between transportation vendors and PT. XYZ.
Figure 10: Monitoring process of logistic function
Table 2: Data sample result using monitoring system on transporter fleet
4. Conclusion
This paper has presented a new approach based on empirical findings and trial in a cement manufacturer outsourcing logistic service. KPI evaluation based on real-time data monitoring is important to determine transporter performance and solution to the issues by outsourcing logistic process function.
This approach will be applied to studies of t logistic business process resulting in KPI evaluation.
- K. R. Trivedi and P. M. Dhiren, “Integration of GPS and GSM for the Weather Monitoring System,” Bulletin of Electrical Engineering and Informatics, vol. 1, no. 3, pp. 209-212, 2012.
- D. Liu, X. Cao, X. Zhou, and M. Zhang, “Cold Chain Logistics Information Monitoring Platform Based on Internet of Vehicles,” in 2019 International Conference on Intelligent Transportation, Big Data & Smart City (ICITBS), 2019, pp. 348–351.
- S. Fazel and J. Javad, “A Highly Efficient and Linear Class AB Power Amplifier for RFID Application,” Bulletin of Electrical Engineering and Informatics, vol. 4, no. 2, pp. 147-154, 2015.
- M. R. Kaloop, E. Elbeltagi, J. W. Hu, and A. Elrefai, “Recent advances of structures monitoring and evaluation using GPS-time series monitoring systems: A review,” ISPRS Int. J. Geo-Information, vol. 6, no. 12, p. 382, 2017.
- C. Kandel, M. Klumpp and T. Keusgen, “GPS based Track and Trace for Transparent and Sustainable Global Supply Chains,” in 17th International Conference on Concurrent Enterprising, Aachen, Germany, 2011.
- K. R. Prasanna and M. Hemalatha, “RFID GPS and GSM based logistics vehicle load balancing and tracking mechanism,” Procedia Engineering, vol. 30, pp. 726-729, 2012.
- M. Bottero, C. B. Dalla and F. P. Deflorio, “Wireless sensor networks for traffic monitoring in a logistic centre,” ransportation Research Part C: Emerging Technologies, vol. 26, pp. 99-124, 2013.
- X. M. Guo, L. S. Chen, M. Chen and C. L. Peng, “Design of real-time ECG monitoring system based on smart-phone,” Application Research of Computers, vol. 6, p. 55, 2010.
- Y. Yan, X. Hao and W. Wang, “Location-Based Services and Privacy Protection under Mobile Cloud Computing,” Bulletin of Electrical Engineering and Informatics, vol. 4, no. 4, pp. 345-354, 2015.
- R. Wilding and R. Juriado, “Customer perceptions on logistics outsourcing in the European consumer goods industry,” International Journal of Physical Distribution & Logistics Management, vol. 34, no. 8, pp. 628-644, 2004.
- M. Kiliç, A. Günsel, and H. G. Çekmecelı̇oğlu, “The Effects of Outsourcing in Logistics Services to Competitive Advantage,” Eur. J. Multidiscip. Stud., vol. 1, no. 4, pp. 233–242, 2016.
- S. Zailani, M. R. Shaharudin, K. Razmi, and M. Iranmanesh, “Influential factors and performance of logistics outsourcing practices: an evidence of malaysian companies,” Rev. Manag. Sci., vol. 11, no. 1, pp. 53–93, 2017.
- B. Quelin and F. Duhamel, “Bringing together strategic outsourcing and corporate strategy: Outsourcing motives and risks,” European management journal, vol. 21, no. 5, pp. 647-661, 2003.
- M. Abdur Razzaque and S. C. Chang, “Outsourcing of logistics functions: a literature survey,” International Journal of Physical Distribution & Logistics Management, vol. 2, pp. 89-107, 1998.
- D. Pyza, R. Jachimowski, I. Jacyna-Golda, and K. Lewczuk, “Performance of equipment and means of internal transport and efficiency of implementation of warehouse processes,” Procedia Eng., vol. 187, pp. 706–711, 2017.
- K. Moons, G. Waeyenbergh, and L. Pintelon, “Measuring the logistics performance of internal hospital supply chains–a literature study,” Omega, vol. 82, pp. 205–217, 2019.
- D. Radović and Ž. Stević, “Evaluation and selection of KPI in transport using SWARA method,” Int. J. Transp. Logist., vol. 18, no. 44, pp. 60–68, 2018.
- A. Weber and R. Thomas, “Key performance indicators,” Measuring and Managing the Maintenance Function, 2005.
- Y.-H. Zhao, “Evaluation model of third-party logistics customer service quality based on KPI,” Logistics Sci-Tech, 2009.
- V. Pimentel and B. G. Nickerson, “Communicating and Displaying Real-Time Data with WebSocket,” IEEE Internet Computing, vol. 16, no. 4, pp. 45-53, 2012.
- R. Opdenakker, “Advantages and disadvantages of four interview techniques in qualitative research.,” Forum Qualitative Sozialforschung/Forum: Qualitative Social Research, vol. 7, no. 4, 2006.
- T. Software, “The most sophisticated background location-tracking &,” 2015. [Online]. Available: https://github.com/transistorsoft/cordova-background-geolocation-lt.
- D. Abha, H. Shah, K. Shah and M. Vala, “Global Positioning System for Object Tracking,” International Journal of Computer Applications, vol. 109, no. 8, pp. 40-45, 2015.