Creating an Inventory Management System using VBA for a small Vietnamese enterprise

Inventory control is an essential activity for product-based companies like company A – a small manufacturer of fabricated metal products in Vietnam. The company’s inventory control practices are currently based on mere human’s estimation, without theoretical base and depends on inefficient manual processes to manage their inventories. Based on Inventory Management theories: Just-In-Time (JIT) and Materials Requirements Planning (MRP) as foundation knowledge, the thesis project examined the company’s inventory activities and developed a computer-based inventory solution. Constructive action research approach was conducted via virtual meetings and discussions with the company to investigate their current inventory control practices and to construct a suitable inventory solution; and thus, the project created an Inventory System using VBA-Excel spreadsheets to help replace current manual inventory work. The application solution will be publicly shared to other small businesses which do not have sufficient resources to implement an inventory software system