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

Year 2023, , 144 - 155, 31.12.2023

Mustafa Volkan Güngör , Çiğdem Tarhan

https://doi.org/10.46238/jobda.1403185

Abstract

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.

Keywords

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

Ethical Statement

Bu çalışma, birinci yazarın ikinci yazar danışmanlığında hazırladığı “Depo Yönetim Sisteminde Sayım Süreçlerinin Dijitalleştirilmesi” başlıklı yüksek lisans tezinden üretilmiştir.

DIGITALIZING STOCK TAKING PROCESSES IN WAREHOUSE MANAGEMENT SYSTEM

Abstract

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.

Keywords

Inventory Management, Stock-taking, Digitalization

References

• 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.
• 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
• Boncuk, E. (2006). Yazılım Gereksinim Analizi | Elif Boncuk’s Blog. https://elifboncuk.dev/2011/02/06/yazilim-gereksinim-analizi/
• 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
• Drobek, K., Szostak, B., & Królikowski, W. (2018). Stocktaking methods of facilities in a state of ruin. Biblioteka Politechniki Lubelskiej, 17(4), 5–15.
• 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
• 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
• Hamilton, T. (2022). Difference Between Verification and Validation with Example. https://www.guru99.com/verification-v-s-validation-in-a-software-testing.html
• Juviler, J. (2021). Web Service vs. API. https://blog.hubspot.com/website/web-services-vs-api
• 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
• 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
• Kaplanoğlu, M. (2021). İhtiyaç Belirleme Çalışmaları (İhtiyaç Analizi). https://remcdbcrb.org/ihtiyac-belirleme-calismalari-ihtiyac-analizi/
• 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
• Kumar, S. A., & Suresh, N. (2009). Materials management. In Operations Management (pp. 161–190). New Delhi : New Age International.
• 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
• 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.
• 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
• 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
• Mudita Rathore. (2021). How ASP.Net Web API Works. https://www.csharpcorner.com/UploadFile/2b481f/working-of-Asp-Net-web-api/
• Mülla, M. (2019, October 14). Some guidelines for stock-taking | Grant Thornton. https://www.grantthornton.ee/en/insights1/some-guidelines-for-stock-taking/
• 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).
• OECD. (2019). Going Digital: Shaping Policies, Improving Lives. https://doi.org/10.1787/9789264312012-en
• Pan, J. (2006). Softawre Testing. Dependable Embedded Systems, 5 (1999), 1–9.
• 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
• 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.
• Scarf, H. E. (2002). Inventory Theory. Operations Research, 50(1), 186–191. https://doi.org/10.4271/580217
• 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
• Tecim, V. (2015). Sistem Geliştirme Yaşam Döngüsü. http://www.deu.edu.tr/userweb/ vahap.tecim/dosyalar/sgyd.pdf
• Triff, M. (2017). Automatic Inventory Identification through Image Recognition by. Saint Mary’s University.
• 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
• 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.
• 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.
• 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
• 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