Implementing Inventory Malntenence And Analyze System For Manufrcturing Compeny

The main purpose of this project is to reduce time taken for monthly inventory report generating
and avoid human intervention with data in a secured environment. This project is to develop an
inventory solution system which includes several modules for implementations which are HFS
server inventory data gathering, Visual Basic Advance automate program, dynamic real time
repoft, and information protection. The issues with current inventory management process are
including not having standardized platform for report gathering, manual report fixing, delayed in
report generated and fragility of information leakage. As a result the idea to develop these
modules can be a crucial business tool system whereby focusing on inventory (finished goods) as
a primary purpose. HFS server is used as standard platform for inventory data gathering. The
modules Visual Basic Advance automate program is to solve human interference with data while
dynamic real time report is to solve time consumption in report preparation. The platform
involves are Microsoft Office Excel 2007 and Microsoft Office Access 2007. On top of that,
information protections which are really crucial in avoiding information leakage have been
emphasizing through implementation of password protection module in several area. In this
inventory solution system, there are three (3) areas which are been set up to have password
protection. The first area is for manufacturing's customers to drop their data, the second area is
for system analyst to use Visual Basic Advance automate program and the last area is for
manager to view the report. The succession to develop this project enables an effective work
environment in term of reduction in time spont to complete tasks and human intervention with
data