In Bell Electronics Corporation, there is a corresponding form for every incoming or outgoing item (from the stock room). These forms serve as the basis of comparison when inspecting; that is, the amount of item that goes in or out must tally with those written in the forms. Afterwards, all the transactions will then be encoded manually in Microsoft Excel for future reference. In addition to the complexity of the process, the employee responsible on this task also needs to check the stocks once in a while so as to monitor which items are already getting below the allowable minimum quantity.
Because of the draining work, there were circumstances when the inventory record in the computer does not tally with the actual amount Of the available items. Another thing to consider in manual inventory is prone to errors since it is inevitable that the employee assigned to do the inventory loud commit mistakes. Due to the inefficiency of manual inventory, security is also being risked. If not properly monitored, theft and loss of items can actually take place. It is also time consuming to take note of several details each time an item is brought in and out of the stock room.
Since manual inventory consumes a lot of time and is susceptible to errors, it would be helpful to build a system that will automate the transactions from acquisition of the product description to updating the inventory database. Work efficiency of employees is defined as how productive they are in their work. The automated inventory system will improve employees’ work efficiency by automating routinely and time consuming tasks such as the time spent in taking down product information.