DIGITALIZING STOCK TAKING PROCESSES IN WAREHOUSE MANAGEMENT SYSTEM

Öz

The aim of this study is to develop a stock-taking flow diagram and a stock-taking software to digitalize current, paper-based stock-taking process. Existing process can be defined as a manual process basically. Only office programs are used during the process. The process is not capable of satisfying existing needs as it is cumbersome and error-prone. With the study, first, the current stock-taking process, the actors involved in the process, the duties and authorities of the actors, and the information that the actors will need while performing their duties are defined. Work-flow processes are developed according to the scope of the requested stock-taking process. The stock-taking software is coded in C# programming language in accordance with the prepared workflow processes. User interfaces and report pages are built in Angular. The developed software has a flexible structure suitable for partial and full stock-taking. For the software to be used, the necessary data must be included in the existing database. During the development of the software, which will digitalize the stocktaking process, System Development Life Cycle steps are followed. As a result, the digitalization of the stock-taking process is achieved with the development of the software. The software ensures that problems such as data losses, erroneous registration, and similar problems caused using paper-based process are eliminated; it enables the stock-taking process to be monitored digitally, performed faster and more reliable.

Anahtar Kelimeler

• Inventory Management
• Stock-taking
• Digitalization

DEPO YÖNETİM SİSTEMİNDE SAYIM SÜREÇLERİNİN DİJİTALLEŞTİRİLMESİ

Öz

Bu çalışmanın amacı, mevcut kâğıt kullanımına dayalı stok sayım sürecini dijitalleştirmek için bir stok sayım akış diagram ve yazılımı geliştirmektir. Mevcut süreç temelde manuel bir süreç olarak tanımlanabilir. Sayım süreci boyunca sadece ofis programları kullanılmaktadır. Bu süreç, hantal ve hataya açık olduğu için mevcut ihtiyaçları karşılama yeteneğine sahip değildir. Çalışma ile öncelikle mevcut sayım süreci, sürece dahil olan aktörler, aktörlerin görevleri ve yetkileri ile aktörlerin görevlerini yerine getirirken ihtiyaç duyacakları bilgiler tanımlanmıştır. Talep edilen stok sayımı sürecinin kapsamına göre iş akış süreçleri geliştirilmiştir. Stok sayımı yazılımı, hazırlanan iş akışı süreçlerine uygun olarak C# programlama dilinde kodlanmıştır. Kullanıcı arayüzleri ve rapor ekranları Angular'da oluşturulmuştur. Geliştirilen yazılım, kısmi ve tam stok almaya uygun esnek bir yapıya sahiptir. Yazılımın kullanılabilmesi için gerekli verilerin mevcut veritabanında yer alması gerekmektedir. Stok sayımı sürecinin dijitalleştirilmesini sağlayan bu yazılımın geliştirilmesi sırasında Sistem Geliştirme Yaşam Döngüsü adımları takip edilmiştir. Sonuç olarak, yazılımın geliştirilmesi ile stok sayımı sürecinin dijitalleşmesi sağlanmıştır. Yazılım, kağıt tabanlı işlem kullanımından kaynaklanan veri kayıpları, hatalı kayıt ve benzeri sorunların ortadan kaldırılmasını sağlamış; stok sayımı süreci dijital olarak izlenebilir hale getirmiş, daha hızlı ve daha güvenilir bir şekilde gerçekleştirebilmesini sağlamıştır.

Anahtar Kelimeler

• Envanter Yönetimi
• Stok Sayımı
• Dijitalleşme

Kaynakça

1. Balavishnu, M., Viswanathan, D., Chitradevi, K., Mohana Priya, V., & Rajkumar, N. (2021). Stock Management System. International Journal of Scientific Research in Computer Science, Engineering and Information Technology IJSRCSEIT, 7(2), 342–347.
2. Beul, M., Droeschel, D., Nieuwenhuisen, M., Quenzel, J., Houben, S., & Behnke, S. (2018). Fast autonomous flight in warehouses for inventory applications. IEEE Robotics and Automation Letters, 3(4), 3121–3128. https://doi.org/10. 1109/LRA.2018.2849833
3. Boncuk, E. (2006). Yazılım Gereksinim Analizi | Elif Boncuk’s Blog. https://elifboncuk.dev/2011/02/06/yazilim-gereksinim-analizi/
4. da Silva, E. A. B., & Mendonça, G. V. (2005). Digital Image Processing. In W.-K. CHEN (Ed.), The Electrical Engineering Handbook (pp. 891–910). Academic Press. https://doi.org/https://doi.org/10.1016/B978-012170960-0/50064-5
5. Drobek, K., Szostak, B., & Królikowski, W. (2018). Stocktaking methods of facilities in a state of ruin. Biblioteka Politechniki Lubelskiej, 17(4), 5–15.
6. Geetha, D., Kulkarni, V. N., Kulkarni, S., Gaitonde, V. N., & Kotturshettar, B. B. (2020). Simulation study and analysis of inventory stock taking in manufacturing industry. IOP Conference Series: Materials Science and Engineering, 872(1). https://doi.org/10.1088/1757-899X/872/1/012071
7. Giones, F., & Brem, A. (2017). From toys to tools: The co-evolution of technological and entrepreneurial developments in the drone industry. Business Horizons, 60(6), 875–884. https://doi.org/10.1016/j.bushor.2017.08.001
8. Hamilton, T. (2022). Difference Between Verification and Validation with Example. https://www.guru99.com/verification-v-s-validation-in-a-software-testing.html

9. Juviler, J. (2021). Web Service vs. API. https://blog.hubspot.com/website/web-services-vs-api
10. Kalinov, I., Petrovsky, A., Ilin, V., Pristanskiy, E., Kurenkov, M., Ramzhaev, V., Idrisov, I., & Tsetserukou, D. (2020). WareVision: CNN Barcode Detection-Based UAV Trajectory Optimization for Autonomous Warehouse Stocktaking. IEEE Robotics and Automation Letters, 5(4), 6647–6653. https://doi.org/10. 1109/LRA.2020.3010733
11. Kalinov, I., Trinitatova, D., & Tsetserukou, D. (2021). WareVR: Virtual Reality Interface for Supervision of Autonomous Robotic System Aimed at Warehouse Stocktaking. ArXiv Preprint ArXiv:2110.11052. http://arxiv.org/abs/2110.11052
12. Kaplanoğlu, M. (2021). İhtiyaç Belirleme Çalışmaları (İhtiyaç Analizi). https://remcdbcrb.org/ihtiyac-belirleme-calismalari-ihtiyac-analizi/
13. Kejriwal, N., Garg, S., & Kumar, S. (2015). Product counting using images with application to robot-based retail stock assessment. IEEE Conference on Technologies for Practical Robot Applications, TePRA, 2015-Augus(June 2018). https://doi.org/ 10.1109/ TePRA.2015.7219676
14. Kumar, S. A., & Suresh, N. (2009). Materials management. In Operations Management (pp. 161–190). New Delhi : New Age International.
15. Mariana, B. (2008). Inventory Evaluation At Stocktaking. Annals of the University of Oradea, Economic Science Series, 17(3), 948–953. http://esc-web.lib.cbs.dk/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=bth&AN=48176427&site=ehost-live&scope=site
16. Maurer, M., Pestana, J., Fraundorfer, F., & Bischof, H. (2018). Towards an Autonomous Vision-based Inventory Drone. 2018 IEEE/RSJ International Conference on Intelligent Robots and Systems.
17. Morenza-Cinos, M., Casamayor-Pujol, V., & Pous, R. (2019). Stock visibility for retail using an RFID robot. International Journal of Physical Distribution and Logistics Management, 49(10), 1020–1042. https://doi.org/10.1108/IJPDLM-03-2018-0151
18. Morenza-Cinos, M., Casamayor-Pujol, V., & Pous, R. (2019). Stock visibility for retail using an RFID robot. International Journal of Physical Distribution and Logistics Management, 49(10), 1020–1042. https://doi.org/10.1108/IJPDLM-03-2018-0151
19. Mudita Rathore. (2021). How ASP.Net Web API Works. https://www.csharpcorner.com/UploadFile/2b481f/working-of-Asp-Net-web-api/
20. Mülla, M. (2019, October 14). Some guidelines for stock-taking | Grant Thornton. https://www.grantthornton.ee/en/insights1/some-guidelines-for-stock-taking/
21. Mustaquim, M. M., & Nyström, T. (2015). A System Development Life Cycle for Persuasive Design for Sustainability. In T. MacTavish & S. Basapur (Eds.), 10th International Conference on Persuasive Technology, PERSUASIVE 2015 (pp. 217–228).
22. OECD. (2019). Going Digital: Shaping Policies, Improving Lives. https://doi.org/10.1787/9789264312012-en
23. Pan, J. (2006). Softawre Testing. Dependable Embedded Systems, 5 (1999), 1–9.
24. Peisheng, T., Ronggui, D., & Yubin, Z. (2020). A stereoscopic warehouse stocktaking method based on machine vision. Journal of Physics: Conference Series, 1627(1). https://doi.org/10.1088/1742-6596/1627/1/012015
25. Rajasekar, D., Bengal, W., & Bengal, W. (2020). Annual physical inventory stock taking lead time reduction a case study. International Journal of Management, IT & Engineering, 10(11), 70–88.
26. Scarf, H. E. (2002). Inventory Theory. Operations Research, 50(1), 186–191. https://doi.org/10.4271/580217
27. Schwarz, L. (2019). Inventory Cycle Counting 101: Best Practices & Benefits. Netsuite.Com. https://www.netsuite.com/portal/resource /articles/ inventory-management /using- inventory- control-software-for-cycle-counting.shtml
28. Tecim, V. (2015). Sistem Geliştirme Yaşam Döngüsü. http://www.deu.edu.tr/userweb/ vahap.tecim/dosyalar/sgyd.pdf
29. Triff, M. (2017). Automatic Inventory Identification through Image Recognition by. Saint Mary’s University.
30. Walter, L., Denter, N. M., & Kebel, J. (2022). A review on digitalization trends in patent information databases and interrogation tools. World Patent Information, 69 (Mart), 102–107. https://doi.org/10.1016/j.wpi.2022.102107
31. Xiao-dong, T., & Jing-yu, Z. (2021). A visual auxiliary inventory counting system for the automated stereoscopic warehouse. Proc. SPIE 11930, International Conference on Mechanical Engineering, Measurement Control, and Instrumentation.
32. Yilmaz, G., Ungan, E., & Demirors, O. (2011). Yazılım Gereksinim Dokümanı Kalitesinin İşlevsel Büyüklük Ölçümüne Etkisi. 5. ULUSAL YAZILIM MÜHENDİSLİĞİ SEMPOZYUMU, 26-28 Eylül, 78–84.
33. Zhou, Y. W., Zhong, Y., & Li, J. (2012). An uncooperative order model for items with trade credit, inventory-dependent demand and limited displayed-shelf space. European Journal of Operational Research, 223(1), 76–85. https://doi.org/10.1016/j.ejor.2012.06.012
34. Zhu, W., Meng, X., Peng, X., Cao, J., & Raynal, M. (2019). Time-Efficient RFID-Based Stocktaking with a Coarse-Grained Inventory List. 2018 IEEE/ACM 26th International Symposium on Quality of Service, IWQoS 2018, 1–6. https://doi.org/10.1109/IWQoS.2018.8624125