Do some Excel Work

1.1Background information The research is to be conducted at CHANIA bus ticket booking office located in Nairobi CBD. The ticket booking system is done manually using paper works and other manual procedures. In the actual case the client/customer/passenger pays a visit to the booking office. The booking office comprise of receptionists and cashiers who serve the customers. The firm also has an organizational structure. The number of people employed in this company is estimated to be 350 who include drivers and co driver’s .The current system operates manually in a way that each and every transaction is made through handy paper works and manual procedures. In a nutshell during enquiry the client interacts with the receptionist in the booking office who then checks the enquired details in terms of destination of travel, coach package (class of bus) distance coverage from the departure terminal to the destination terminal, estimated boarding hours, the condition of the bus to get on transit and the stipulated time of boarding. The receptionist then checks for the amount required to the ticket purchase regarding the client enquiry. After this enquiry the client is given delivery note indicating the price and details of the respective transit. The client then proceeds to the cashier to make payment, at the cashier desk the cashier checks and confirms the enquiry note details, eventually the customer makes payment which follows manual receipting and recording, The cashier records the customer details in record sheet here details are written manually on receipt book. The client is given a copy and the duplicate of the corresponding details left with the cashier for reference. 1.2 Problem statement For effective bus ticketing studies have shown that there is need to automate the booking process for passengers. Studies have shown that the manual booking process mostly during peak time (holidays) have adversely affected the passengers in terms of service. 1.6Objectives of the project  To provide a quick access of service  To ensure there is efficiency in the ticket booking process  To provide accessibility to the booking service to customers regardless of their locality  To automate the whole process of ticket booking and eliminate the manual system  To minimize the number of staff at the ticket box. The numbers of staff at the counter can be reduced after the online buying bus ticket system  1.3 purpose of the study The purpose of this study is to design an online booking system which will effect an efficient operation to the whole booking process 1.4 proposed solution In order to mitigate the challenges and shortcomings that arises from this manual booking system. This proposal intends to design an online booking system which will help to counteract the problems. The system basically involve login in with a user id through a web application which is both accessible through a personal computer or a smart phone. 1.5 justifications The proposed system makes it easier for a passenger or a client to interact with the system and eliminate the event of paying a visit to the booking office. Through the web application the user can log in to the website and interact with the system. Chania bus online booking system will be time saving and much convenient to both customers and the staff in service. The system will ensure efficiency and quality services