MOBILE INTEGRATED STOCK AND RESTAURANT MANAGEMENT SYSTEM

Abstract

Asiri hotel and restaurant located on Thudella of Ja-Ela. It was established on 2002 under registration of Sri Lanka Hotel cooperation. It is one of the well reputed, and leading hotel and restaurant in Sri Lanka. The Asiri hotel and restaurant is providing better service for customer with catering different kind of foods and beverages with maximizing satisfaction of the customer. The management of the hotel is managing Restaurant and bar using manual procedures. At the moment more than thousands of customers had served by the Asiri hotel. Every day hundreds of customers are visiting to this restaurant and bar because of the different kind of menus and loyalty service. The management of the hotel cannot handle day to day transactions using the manual system. Because of manual system is not supporting to track requirement of the restaurant such as groceries, food portions, and beverage. Also the management has to face a lot of difficulties to ready the restaurant for the business of the days ahead, serve many no of customers at same time without delay, preparing different kind of reports. Apart from that, customers' demand, waiters encounter a lot of difficulties, especially when catering meals from kitchen to tables and beverages from bar to tables. There is no proper system to manage transaction details of each customer. Those problems cause the customer to wait for a long period of time for served ordering menus or beverages. Before deploying this solution, they did not have a methodology for the tracking or follow up of day to day transactions such as orders, payments, incentive calculations, tax calculations etc... There are 35 employees working in the hotel and some of them are working as the waiters. In the existing process management cannot monitor how much of customers are handled by the waiters separately. Therefore they couldn't calculate incentive against customer service for the waiters. As a solution for above matters restaurant management system is proposed. This system facilitate to manage stock with handling Good received note, Good return notes, damage management, stock adjustment, recipe management, place orders by using computers or mobile phones, generate different kind of reports and many more feature. After analyzing all problems by following software engineering methodology, mobile application technology and windows application technology are used to develop a solution. This system required wireless network facilities, computers, android smart phones, Barcode scanners, printers. After that database of the system, Windows Communication Foundation service are installed in main server and windows application installed on client computers. Mobile application installed on android based smart phone based on users requirements. User training and instructions were given to the users to work with the system. After installing this system, management got valuable achievements from the business and employee management. The management able to monitor stock and sales of the restaurant properly by referring reports which generated by the system. Order serving time, rate of wastage are minimized and accuracy of the transactions, customer satisfaction, employee satisfactions are maximized by this solution. This system uses C# as main programming language for windows application and Windows Communication Foundation service, and Java as main programming language of android application, MS SQL server for database, RDLC and crystal report as reporting tool.