Computerized satellite canteen sales and inventory system

Abstract

Computerized Satellite Canteen Sales and Inventory System is designed to handle data management of sales and inventory of the satellite canteen which is composed of four based location canteens, the Elementary building, High school building, Mary Thomas building and Engineering Building in Central Philippine University. The present system was done manually, from the common way of ordering of products then line up to pay without receipt (mano-mano system). Transactions are not fully monitored and that would result for questionable and delayed reports. It takes time to inventory the purchased products from each canteen. The canteen coordinator could not come up or finish the inventory within the deadline, to be passed for the Vice President of Finance and Enterprise. During peak hours canteen staff has difficulty to cater their customers. The proposed system is intended to solve the current problem of the system. The proposed systems will fully monitored transactions from purchasing of products from the supplier and consignor up to the selling of products to customers. Products are manageable in which consignor products and non-consignor has different databases. Product list are easy to retrieve through its barcode number or product code and product description. It can also generate accurate, reliable, and just in time reports. With this proposed system, the Vice President of Finance and Enter price can have the inventory reports at any time. The system can generate barcodes through the barcoding form. The barcode scanner will provide fast and efficient service for the costumer. Products are automatically tied up to pricing and pricing are automatically calculated based on preset percentage. This may result in more volume of costumer that canteen provides its services in short period of time. For data security, the proposed system has two different users; the canteen coordinator and bookkeeper which would access everything in the system and the canteen staff which composed of canteen cashier and work student has a limited accessibility of the system. Accessibility may determine through user authentication. Through the study and different existing systems researchers are able to formulate and design the Computerized Satellite Canteen Sales and Inventory System; this proposed system is a remedy for the problem being encountered daily in each canteen in satellite canteen. This will provide efficacy, efficiency, and accuracy to the daily operations as well as to save time and effort in monitoring each canteens development.