Stock handling and analyzing system for multi-purpose Co-operative society, Eheliyagoda

Abstract

The multi-purpose co-operative society is one of the largest business bodies around the area which has number of regional shops (around 40) throughout the division which are controlled by the head office situated at Eheliyagoda. This multi-purpose co-operative society offers large verities of consuming goods to fulfill the needs of the consumers around the area. In order to cope with this particular customer demand, a specific stock handling mechanism is needed. This stock handling mechanism should be run by the main store complex as the base under the co-operative supervision of a store manager and the head office authorities while regional shops playing an important role.

With the existing manual stock handling procedure, it is difficult to maintain the stock details and to communicate between the store complex, head office and the regional shops. As an example, if a regional shop manager wants to tally the consumer demand information, he/she needs to do it manually and needs to come to the main store complex in order to handover the consumer demand information and then the store keeper has to carry his/her reports to the head office. In this context proper application is needed to integrate the regional shop manager, store keeper and the head office authorities in stock handling procedure. After receiving the customer demand report, the head office authorities need to look for the suppliers from whom that particular goods can be bought for a fair price. This is also a time wasting and exhausting task. In this context, they need an effective mechanism to call prices for the required goods hence they can decide the optimal supplier to be reached which means this system can help the co-operative society to build a strong links with external suppliers..

Methodology

In order to cope with above mentioned short comings, a proposed system has come up with two solutions. The first one is the desktop software application which helps the internal parties (regional shop managers, store manager, head office authorities) to integrate each other for effective stock handling procedure. The other solution is the web application which helps to call prices from the external suppliers and ultimate to build some strong links with external parties.

Data collection, Result and Discussion

The data collection was done by an advanced discussion and a smooth study. nThe advanced discussion covered the entire process flow of multi-purpose co-operative society, Eheliyagoda. The authorities have pointed out the weak links/vacuums which are generally can be seen their process flow. That was really a complex one comparing to a general scope of a final year project of a bachelor’s degree. The fact that has been pointed out by them was the requirement of an effective procedure of stock handling. There are specific forms can be seen in order to use in their stock handling process flow. These forms helped greatly to draft the Skelton of the system and carry it on.

According to the drafted system, four roles can be understood. They are;

I. II. III. IV.

Regional shop managers. Store keeper. Head office authorities. External suppliers.

The proposed system comprises with a desktop application to integrate regional shop manager, store keeper and the head office and the web application integrate the firma and the external suppliers in order to call prices. Java, PHP, CSS3, HTML5, javascript have been used to develop the system. Apart from that, NetBeans was the Integrated Development Environment while notepad++ has been used as the text editor.