scholarly journals Developing Palm Oil Inventory Control System Using Ms Excel Macro

2021 ◽  
Vol 5 (1) ◽  
pp. 51-55
Author(s):  
Siti Zubaidah Ismail ◽  
Abdulsalam Khaled Abdullah Al-Hadi
Keyword(s):  
Control System ◽  
User Interface ◽  
Inventory Control ◽  
Palm Oil ◽  
Research Study ◽  
Management Team ◽  
Microsoft Excel ◽  
Application System ◽  
Administration System ◽  
Oil Sector

The palm oil sector is just one of the popular sectors in Malaysia that offer one of the highest exports to Malaysia's economy. This study handles the research study of inventory control for Malaysian palm oil plantation. The existing inventory control cannot be running smoothly when the inventory are managed in different user interface systems which is by utilizing manual inventory control like Microsoft Excel and handwriting documents. Data collection was gathered with the targeted respondents, they are core members of the management team who have a great experience as well as understanding of their inventory system. In order to make PSS inventory control much easier as well as organized, an inventory application system is developed utilizing MS Excel Macro. The outcomes of this research study are a computerized supply control system that beneficial, crucial, and also much better substitute for a hand-operated administration system and quick handling.

scholarly journals PRODUCT – SERVICE SYSTEM INVENTORY CONTROL FOR MALAYSIAN PALM OIL AGRIBUSINESS

2019 ◽  
Vol 3 ◽  
pp. 9-16
Author(s):  
Nina Iwani A Zailaini ◽  
Siti Zubaidah Ismail
Keyword(s):  
Inventory Control ◽  
Palm Oil ◽  
Service System ◽  
Microsoft Excel ◽  
Product Service System ◽  
Application System ◽  
Product Service ◽  
Plantation Company ◽  
Managing System ◽  
Control Tool

This research deals with the study of Product – Service System (PSS) and inventory control for Malaysian palm oil plantation company. PSS is a managing system that combining product and service in one system. PSS is essential to provide better environmental impart, improve competitiveness and to help the company satisfy the demand from customer. However, PSS could not be running smoothly when the inventory of product and service are managed in separate interface systems, which is by using manual inventory control like Microsoft Excel and handwriting documentation. In order to make PSS inventory control easier and systematic, an inventory application system is developed. This research is focusing on developing a PSS inventory control tool which could help in decision and calculation making for product and service of palm oil plantation.

Sistem Informasi Pengendalian Persediaan Barang Menggunakan Metode Economic Order Quantity (EOQ)

IJAcc ◽  
2020 ◽  
Vol 1 (2) ◽  
pp. 132-139
Author(s):  
Erna Astriyani ◽  
Desy Apriani ◽  
Meri Mayang Sari
Keyword(s):  
Control System ◽  
System Design ◽  
Inventory Control ◽  
Economic Order Quantity ◽  
Economic Order ◽  
Control System Design ◽  
Order Quantity ◽  
Microsoft Excel ◽  
Total Cost ◽  
Control Information

The system that is currently running in recording inventory at PT Berlina Tbk Tangerang is considered ineffective and efficient because it still uses paper and the process of inputting and recapping goods data is semi-computerized in Microsoft Excel. which causes problems, namely too much stock of goods so that it increases the load in the warehouse and too little stock of goods which results in an exhaustion of stock in the warehouse. To solve this problem, we need an inventory control information system. The method of analysis uses the EOQ (Economic Order Quantity) method. For the system design process using sublime as the writing language and programming PHP, and XAMPP as localhost, the database uses MySQL. This study aims to design an inventory control system in the HRD department at PT Berlina Tbk Tangerang, and to make it easier for the HRD Department to input and create inventory reports. With this research, it can produce an inventory control system design that is more effective and efficient and can find out the storage costs in the warehouse. From the calculation of the EOQ method, it is found that it is 20% smaller than the previous storage and the total cost of ordering in a year is 2x orders. Thus, it means that there is a very real difference between the inventory policies implemented by the company and the EOQ method.

Sistem Informasi Pengendalian Persediaan Barang Menggunakan Metode Economic Order Quantity (EOQ)

IJAcc ◽  
2020 ◽  
Vol 1 (2) ◽  
pp. 132-139
Author(s):  
Erna Astriyani ◽  
Desy Apriani ◽  
Meri Mayang Sari
Keyword(s):  
Control System ◽  
System Design ◽  
Inventory Control ◽  
Economic Order Quantity ◽  
Economic Order ◽  
Control System Design ◽  
Order Quantity ◽  
Microsoft Excel ◽  
Total Cost ◽  
Control Information

The system that is currently running in recording inventory at PT Berlina Tbk Tangerang is considered ineffective and efficient because it still uses paper and the process of inputting and recapping goods data is semi-computerized in Microsoft Excel. which causes problems, namely too much stock of goods so that it increases the load in the warehouse and too little stock of goods which results in an exhaustion of stock in the warehouse. To solve this problem, we need an inventory control information system. The method of analysis uses the EOQ (Economic Order Quantity) method. For the system design process using sublime as the writing language and programming PHP, and XAMPP as localhost, the database uses MySQL. This study aims to design an inventory control system in the HRD department at PT Berlina Tbk Tangerang, and to make it easier for the HRD Department to input and create inventory reports. With this research, it can produce an inventory control system design that is more effective and efficient and can find out the storage costs in the warehouse. From the calculation of the EOQ method, it is found that it is 20% smaller than the previous storage and the total cost of ordering in a year is 2x orders. Thus, it means that there is a very real difference between the inventory policies implemented by the company and the EOQ method.

Implementation of an Inventory Control System for a Computer Center Using QR Codes on Android Mobile Devices

2017 ◽  
Vol 7 (11) ◽  
pp. 50
Author(s):  
Gustavo Poot Tah ◽  
Erika Llanes Castro ◽  
José Luis López Martínez ◽  
Victor Chi Pech
Keyword(s):  
Control System ◽  
Inventory Control ◽  
Mobile Devices ◽  
Mobile Application ◽  
Free Software ◽  
Qr Codes ◽  
Design And Development ◽  
Computer Center

This paper presents the design and development of a mobile application that uses QR codes for the inventory control of a computer center. This application was developed to support the administration of the computer center of the Multidisciplinary Unit Tizimin, with the aim to reduce costs and time of searching for articles when making an inventory, by leveraging the capabilities of smartphones and tablets. The implementation of the system was carried out using free software.

Multi-objective particle swarm optimisation approach for production-inventory control systems

2018 ◽  
Vol 13 (4) ◽  
pp. 1037-1056 ◽  
Author(s):  
Huthaifa AL-Khazraji ◽  
Colin Cole ◽  
William Guo
Keyword(s):  
Control System ◽  
Control Systems ◽  
Inventory Control ◽  
Dynamic Performance ◽  
Particle Swarm ◽  
Particle Swarm Optimisation ◽  
Inventory Level ◽  
Content Type ◽  
Multi Objective ◽  
Production Inventory

Purpose This paper aims to optimise the dynamic performance of production–inventory control systems in terms of minimisation variance ratio between the order rate and the consumption, and minimisation the integral of absolute error between the actual and the target level of inventory by incorporating the Pareto optimality into particle swarm optimisation (PSO). Design/method/approach The production–inventory control system is modelled and optimised via control theory and simulations. The dynamics of a production–inventory control system are modelled through continuous time differential equations and Laplace transformations. The simulation design is conducted by using the state–space model of the system. The results of multi-objective particle swarm optimisation (MOPSO) are compared with published results obtained from weighted genetic algorithm (WGA) optimisation. Findings The results obtained from the MOPSO optimisation process ensure that the performance is systematically better than the WGA in terms of reducing the order variability (bullwhip effect) and improving the inventory responsiveness (customer service level) under the same operational conditions. Research limitations/implications This research is limited to optimising the dynamics of a single product, single-retailer single-manufacturer process with zero desired inventory level. Originality/value PSO is widely used and popular in many industrial applications. This research shows a unique application of PSO in optimising the dynamic performance of production–inventory control systems.

Sign in / Sign up

Export Citation Format

Share Document