Smart Management Scheme for the Efficient Control of Industrial Inventory
- 1 Department of Industrial Engineering and Management (IEM), Khulna University of Engineering & Technology (KUET), Khulna, Bangladesh
- 2 Department of Industrial Engineering and Management (IEM), Khulna University of Engineering & Technology (KUET), Khulna, Bangladesh
Abstract
To fulfill the growing demand of industrial goods, companies are keeping more inventories as a business trick. As keeping inventory database management system is very costly, industrial companies are switching to the manual management system which is done with unfriendly report usually. This research investigates the influence of a database management system for industrial inventory and developed a system which will be very less costly to launch, more efficient and more reliable. Visual Basic 2017 has been used to develop the front-end of the software. SQL server has been used to create the back-end of the software. The system has an error of zero tolerance because the scheme of coding of the database and debugging the codes guarantees that the errors can be specified and solved within very less time. The system will reduce costs, number of errors and make the whole management more versatile. This database system has been developed also to determine the Economic Order Quantity (EOQ) and Reorder Level (ROL) and also to decrease the stock-outs. This inventory database management system is newly treated and can also be used for various vending under vendor managed inventory. This work will also help the researchers to compare the automated system of keeping inventory with a manual approach.
- Anthony, B., & Augustin, D. S. (2017). Intra-Firm Inventory Management Model with Transshipments. American Journal of Industrial and Business Management, 7, 15-26. https://doi.org/10.4236/ajibm.2017.71002
- Atieh, A. M., Kaylani, H., Al-Abdallat, Y., Qaderi, A., Ghoul, L., Jaradat, L., & Hdairis, I. (2016). Performance Improvement of Inventory Management System Processes by an Automated Warehouse Management System. Procedia CIRP, 41, 568-572. https://doi.org/10.1016/j.procir.2015.12.122
- Burja, C., & Burja, V. (2010). Analysis Model for Inventory Management. Annals of the University of Petrosani: Economics, 10, 43-50.
- Corbett, C. J. (2001). Stochastic Inventory Systems in a Supply Chain with Asymmetric Information: Cycle Stocks, Safety Stocks, and Consignment Stock. Operations Research, 49, 487-500. https://doi.org/10.1287/opre.49.4.487.11223
- Goonatilake, R., & Maldonado, S. C. (2018). Essentials of Novel Inventory Management Systems. Engineering Management Research, 7, 31-45.
- Haddara, M. (2014). ERP Selection: The SMART Way. Procedia Technology, 16, 394-403. https://doi.org/10.1016/j.protcy.2014.10.105
- Kang, Y., & Gershwin, S. B. (2005). Information Inaccuracy in Inventory Systems: Stock Loss and Stockout. IIE Transactions (Institute of Industrial Engineers), 37, 843-859. https://doi.org/10.1080/07408170590969861
- Kilic, H. S., Zaim, S., & Delen, D. (2015). Selecting “the Best” ERP System for SMEs Using a Combination of ANP and PROMETHEE Methods. Expert Systems with Applications, 42, 2343-2352. https://doi.org/10.1016/j.eswa.2014.10.034
- Miguel, Y. P., Andrés, G. H., Pablo, G. A., & Gabriel, G. S. (2011). Application to a Warehouse Environment of a Tracking System Based on RFID and Free Software. In T. Hollstein (Ed.), RFID Systech—7th European Workshop on Smart Objects: Systems, Technologies and Applications (pp. 1-7). Institute of Electrical and Electronics Engineers.
- Olsen, K. A., & Sætre, P. (2007). ERP for SMEs—Is Proprietary Software an Alternative? Business Process Management Journal, 13, 379-389. https://doi.org/10.1108/14637150710752290
- Park, Y. B., & Yoo, J. S. (2012). A Heuristic for the Inventory Management of Smart Vending Machine Systems. Journal of Industrial Engineering and Management, 5, 354-363. https://doi.org/10.3926/jiem.587
- Ravinchandra, K., Abdulla, R., & Thang, K. F. (2016). Smart Stock Management Control. International Journal of Applied Engineering Research, 11, 492-500.