1.0 Introduction1.1 Background of the StudyInformation System is an integrated set of components for collecting, storing, processing, and communicating information. Business firms, other organizations, and individuals in contemporary society rely on information systems to manage their operations, compete in the marketplace, supply services, and augment personal lives.

Its basis is the interaction between the user and the analyst. It is an open system that allows the inputs and facilitates the interaction with the user. It can be defined as a set of devices, procedures and operating systems designed around the user to produce information and communicate it to the user for planning, control and performance. It deals with the development, use and management of an organization's Information Technology infrastructure.Management Information System (MIS) is an organized approach to the study of the information needs of an organization’s management at every level in making operational, tactical, and strategic decisions. Its objective is to design and implement procedures, processes, and routines that provide suitably detailed reports in an accurate, consistent, and timely manner.

In a Management Information System (MIS), modern, computerized systems continuously gather relevant data, both from inside and outside an organization.This data is then processed, integrated, and stored in a centralized database (or warehouse) where it is constantly updated and made available to all who have the authority to access it, in a form that suits their purpose. Transaction Processing System automates the routine, day-to-day record-keeping tasks in an organization. It is also known as Operational Systems. Its flow of information through a system is based on thousands or even millions, of similar transactions, each of which represents an exchange of a quantity of something, usually a money value.

Other operational systems record orders received from customers, the numbers of items in stock, orders placed with suppliers, number of hours worked by employees, time and cost of mobile telephone calls made by subscribers and so on.A Hotel Management Information System (MIS) main purpose is to keep track of hotel guests. Have facilities for booking, making registrations and posting of bills and entering room hotel rates. It also represents the approach a company takes to gather information used to make business decisions.A Reservation System contains information about availability, rates, and related services, and through which reservations can be made.

The term commonly used within the travel industry refers to a hotel company's central reservation system (CRS). A Hotel is a commercial establishment providing lodging, meals, and other guest services. It must provide a range of amenities and services and adheres to a high standard of facility-wide cleanliness. It must also have a well-organized system. Lucky Bee Hotel (a taste of heaven) is a kind of hotel that has a traditional system which is manual.

It is a hotel that gives a Service type of business.The Lucky Bee Hotel was started by the owner, Mr. Frederick de Guzman, and his father. The Hotel was their old house and when they decided to transfer to another location, the owner decided to make it a business. The hotel started at the year 2009. They have created this business mainly because hotels have stability of income.

They also started this business to help other people. It is located at 829, F. Gomez St. Sta. Rosa Laguna.

It has different room types, such as Economy, Premium, Deluxe, and also it contains an Apartel.The Hotel has Four (4) floors. The highest floor contains their Apartel, third floor contains the Economy Room Type, and second floor has also the Economy and Premium Room type. And the first floor has the Deluxe Room types. The hotel has fifteen (15) rooms of Economy type, Five (5) rooms of Premium, Three (3) rooms of Deluxe and Seven (7) units of Apartel.

For their Room types, it has the typical hotel amenities such as, Hot and Cold Shower, Air-conditioning, Television Set, and Stereo. The only difference of the Room types is that the higher the amount to be paid has a larger space and bigger amenities. The Apartel of the hotel is most likely an Apartment, its payment is monthly unlike to the room types it has only a minimum of three (3) hours stay. It has also parking spaces. It contains four (4) departments; the Accounting Department, Security Department, Service Department and the Administration.

It has a number of twelve (12) to fifteen (15) employees per day.And every day the company has two (2) shifts that conclude it has seven (7) employees per shift. Their special service that they can offer is their foods and also their Apartel. Most of their System is done manually, specially their Reservation System.

And the owner is open for the changes to his company. Meaning developing their system they agreed to have a computer set to their hotel. The hotel does accept reservation through phone calls but they prefer walk-ins. The manual process of their room reservation starts as the customers arrived, park their vehicles and proceed to the hotel clerk.

At the cashier the customer will be asked such as, their names, type of the room, add-ons and etc, afterwards they are being assisted by one of the room boys to their respective room. The customers can also have extensions to their time; for the hotel has a maximum three (3) hours stay. As for the payment, the customers can pay before or after their stay.1.

2 Statement of the Problem1.2.1 General ProblemHow to organize the record keeping of information and improving the process of billing for Lucky Bee Hotel?1.2.2 Specific ProblemsSpecifically, the study aims to answer the following problems:1.

Does not show the availability of the rooms instantly.The current system of Lucky Bee Hotel has a slow process for it is done manually and does not show the available rooms instantly every transaction and during the peak hours, which is during night time.2. Computation of Customer’s BillsThe customer’s bills are also computed manually by the cashier that makes also the transaction slow and also lead to false computation of bills.3.

Generating of reportsThis specific problem of Lucky Bee Hotel is that the reports are kept only in the journal, as well as the journal are the one to be pass to the management which is unorganized.1.3 Objectives of the Study1.3.1 General Objective How to design and develop acomputer-based hotel information and billing system for Lucky Bee Hotel that will make the hotel information and billing system transaction faster and accurate.

1.3.2 Specific ObjectivesSpecifically, this study aims to:1. Develop a module that will show the availability of the rooms2.

Develop a module that will compute the customer’s bills for every transaction3. Develop a module that will keep the summarized records of the company1.4 Significance of the StudyThe output reservation system will be significant to the individual who is the employee, to the company who is the owner and also to the clients who is the customers of the company.To the employee; it will make their job easier and faster.

Also it will have an organized record of data. It will also lessen the mistakes that might be done. For the company, the owner will be more secured that every transaction is done properly and faster that will give them good services to their customers. The owner also will be secured that the computation of every transaction is accurate for it is all ready formatted to the system. Its benefits to the clients are that they will be assured that the services, such as the computation of their bills and privacy, are done honestly and it is in its excellent state.

Having also these computer-based systems avoid problems such as doubting to the job done by the staff. Also mistakes in managing informationand the computation for the payments will be prevented at the beginning of the transactions. Having good services will prevent complaints from the customers.1.5 Scope and Limitation Listed below are the major modules of the Proposed System to Lucky Bee Hotel with corresponding definition of its functions and features.The first module is the, Availability of the Rooms, in this module… * Shows a table of available rooms in different types of rooms The second module is the, Computation of Bills, in this module… * Keep the customer information organized * Updates (adding and cancellation) of customer’s transactions * Compute the payments of the customers per transactions * Keep track if the customer had paid a full amount or down payment * Computation of all transactions (Daily or Monthly)The third module is the, Reports, in this module… * A user log-in for the owner to have an access on the reports * Generates a summary report of the transactions for daily and monthly incomeListed below are the limitations of the Proposed System: * Does not show the exact time of each room being use