Computer Program Development for Unloading Containers to The Warehouse

Year 2020, Volume: 1 Issue: 1, 15 - 31, 29.12.2020

Kriangkrai Bandasak Saowanit Lekhavat

Abstract

The research aims to develop and create a computer program capable of managing inbound low-priority containers that take up lots of spaces in the unloaded area that are unnecessary for production. This makes it impossible to utilize high-priority inbound containers. Hence, it grows increasingly harder to continue the production lines due to shortages of inputs. As the consequence expenses such as demurrage and unloading costs. The contribution of this study is to apply heuristics technique that are First Come, First Served (FCFS) and Early Due Date (EDD) to accommodate continuous production without waiting for necessary inputs by using Microsoft Excel VBA to develop the algorithm for incoming containers. The outcome of this study reveals that after implementing the program, it helped to reduce the planning time of containers up to 99.5%. According to data obtained from March 2020, the framework successfully mitigates the issue of a lack of inputs that are still loaded in the port. Furthermore, additional expenses are reduced up to 86.6%, with demurrage downed by 87.9%, as well as increasing the unloading capacity by 31%. Finally, this framework proves to be resilient and flexible against changes in production plans.

Keywords

Operation Management, Heuristics, VBA

References

• Baker, K. R. and Trietsch, D. (2013) Principles of sequencing and scheduling, John Wiley & Sons.
• Butdee, S. and Tangchaidee, K. (2010) 'Algorithm of an optimization route for collaborative 2 swarm robots', 201IEEE International Conference on Industrial Engineering and Engineering Management, 2010. IEEE, 1962-1966.
• Hevner, A. R., March, S. T., Park, J. and Ram, S. (2004) 'Design science in information systems research', MIS quarterly, 75-105.
• Klomperee, J. (2000) 'Improvement of port operation, service efficiency and competitiveness, in order to meet the logistical needs of clients: a case study of Bangkok port container terminals'.
• Lumjuan, N., Wicheer, J., Leelapat, P., Choochote, W. and Somboon, P. (2014) 'Identification and characterisation of Aedes aegypti aldehyde dehydrogenases involved in pyrethroid metabolism', PloS one, 9, e102746.
• Phaophuree, W. (2011) 'Heuristic Algorithm for Fuel Vehicle Routing Problem with Multiple Products, Multiple Fleet Sizes and Multiple Compartments'.
• Phatapipong, P., Sachakamol, P. and Treerattrakoon, A. (2018) 'Production Scheduling using Hybrid Heuristics Method: A Case Study of Ready-Mixed Concrete Plant'.
• Charlotte, W. (2011) 'The importance of warehouse management', Worlifts Blog, 27 August. Available at: https://www.worlifts.co.uk/blog/the-importance-of-warehouse-management/ (Accessed: 6 May 2020)