SPREADSHEET APPLICATION FOR TRACKING AND IMPROVING HOSTEL SERVICES

Abstract

The paper presents an application which is developed for employees of hostel and enables importing and storing information about room bookings. Central part of the application is control model for business performance analysis. The application is developed in MS Excel, while the procedures are created in VBA (Visual Basic for Application) programming language. The main goal of the paper is analysis and automation of business process in SAN Art Hostel and creation of the model that will improve system control and consequently improve business results. Main problems, detected by current state analysis, were lack of database for service tracking and fact that all financial calculations are conducted with calculator or with pen and paper. In order to improve business performances we identified the Key Performance Indicators (KPI), which will be observed quarterly. KPI monitoring should enable managers to distinguish imperfections of their business and to realize which business processes can be improved.