RANCANGAN SISTEM INPUT DATA PADA PROSES BUILD-UP DAN BREAKDOWN CHECKLIST KARGO DAN POS (STUDI KASUS TERMINAL KARGO BANDARA INTERNASIONAL JEND. AHMAD YANI)

Science and technology are basic needs in every field of life, one of which
is logistics which is included in the economic field. Warehousing activities in
logistics require the utilization of science and technology to assist the operation of
the warehousing management system, one of the warehousing management with
the concept of Temporary Storage (TPS) can be found at the cargo terminal of
Jenderal Ahmad Yani Semarang International Airport. Based on the author's
observations, almost all operations at TPS have implemented technology, but the
build-up and breakdown process of cargo and postal checklists still use a manual
system. The manual system has an impact on the company's operations such as
waste of paper and complicated data storage procedures (archives) and the potential
to lose data. Therefore, the author designed a system with the aim of providing
solutions to the use of excess paper (paperless) and facilitate the storage and search
of data.
The data collection technique used in this research is field observation. The
research uses a research and development (R&D) approach with a system design
method, namely waterfall, which consists of five stages. This data input system is
designed using Excel VBA macros with the help of features such as useforms and
tools. The resulting data input system can help shorten the workflow by doing a
checklist while saving (archiving) data and making it easier to find data if data is
needed at any time.

Keywords: data input system, Excel VBA macros, build-up and breakdown
checklist.