“Villa Peńa Resort Reservation System”
“Villa Peńa Resort Reservation System”
In such the beginning of information technology making information maintenance and generation a lot easier, most hotels are now willing to invest in the technology to enjoy the benefits of a computer based information system where computers are used to produce desired information.
With the time consuming process brought by the existing system, a solution is then raised that will satisfy the user of the system in processing records, this is to adopt a computer based solution that will speed up the reservation process. Moreover, Technology in the form of computers, communication devices and labor saving mechanical equipment has had and will have a major effect on the way in which hotels are managed and operated.
The speed with information is accumulated, stored, manipulated and transferred is such that today most travelers expect that the hotel rooms they rent will allow them to be as productive as they are in the office or at home. The management task for a hotel consists of a number of processes like room reservation, room services , front desk , lodging, transport, food and beverages , security , staff management etc. these processes involve a lot of information which is created and shared between them and it is only imperative that there should exist a centralized information management system to effectively facilitate this information sharing for the smooth functioning of the hotel business.
This system will indeed help the hotel management and the esteemed staff members to manage and steer the hotel’s functionality and transactions to realize its maximum potential in addition to its competence in the hotel business field. Using systems, it contained a detailed study about how the inventory is managed, how is billing done, how is reservation done and what all a business activities are done to manage the business and making it more fruitful.
It also tells the files used by the company to do their work and gives the whole knowledge and information about the Hotel reservation. Furthermore analytical tools will be integrated with the system to enable managers perform analysis of the available data and make strategic decisions and create promotional offers based on customer preferences. The proposed Villa Peña Resort Reservation System will enables faster information processing regarding various business processes helping the staff to better serve their customer needs in lesser time aimed at enriched the overall customer experience.
One of these is Villa Peńa Resort, located in Partido Area. Villa Peńa Resort is established year 2000, owned and managed by Mrs. Lorna D. Peña located in Barangay Bagumbayan Pequeño town of Goa, Camarines Sur Philippines. It’s just two (2) hour’s drive from Naga City. The Multi Function Hall called the Royal Palace of the resort is magnificent, artistic, and above all elegant creations of human hand yet affordable and it can acquire up to 500 guests. The palace is fully air conditioned and equipped with standby generator system.
The Royal Palace is ideal for Weddings, anniversaries, Reunions, Seminars, Conferences and Conventions. Rates of Function Hall for Seminars –live-in with the minimum of 50 persons which rates 750 pesos up to 850 pesos (inclusive of foods and lodging).Venue is only 15,000 pesos for 5hours and Wedding packages costs 65,000 pesos only for 250 persons. Enjoy the first Class amenities that Villa Peña offers such as hotel rooms, function hall, for any type of occasions, restaurant, swimming pool, recreational facilities such as Billiard table, Vide-oke, cottages, massage and etc.
Other Features of the resort have 24/7 security Guards, Spacious Parking lots , Courteous and Hospitable Staff and Employees, standby life- guards to assist Swimmers and Standby Power generators. Hotel and Restaurant can also makes your Vacation enjoyable, and staying Villa Peńa hotel can treat you as your ‘’home away from home’’ the hotel have ten (10) fully air conditioned rooms. Each room has TV sets for entertainment and telephone lines.
Single bed de lux rates 1500 pesos good for two persons, Matrimonial suite costs for 2,000 pesos and Extra bed costs 200pesos with free breakfast and swimming for 2 persons. The hotel is open 24/7 so you can enjoy the first class accommodation of Villa Peńa hotel. You can also enjoy the special home-made dishes of the Villa Peña restaurant. Prices are affordable and therefore everyone can enjoy and experience the Villa Peńa Restaurant’s specialties. The resort has standard swimming pool that can accommodate up to 300 swimmers plus a kiddie pools suitably designed for kids to enjoy. Both pools are equipped with underwater lighting, skimmers and filters.
There are also open cottages, shower, locker and dressing rooms. Swimming pools for children and adult cost 40 pesos per head in daytime and 50 pesos per head for overnight. The garden landscaped and well manicured garden is perfect place for garden wedding or simply for family occasions. In connection with this, fast accurate and relevant hotel services have been a great demand in a progressive place. This is because many investors or travelers from faraway places seek to find comfort in terms of their accommodation and stay in their certain destination.
Because of the modern technology, hotel accommodation has gone into various level-up stages. There must be a system that will work out to make transactions fast, accurate and convenient to clients. This system will accept large scale of data without any inconveniences. Hassle-free for The customer and at the same time to the management where they can enjoy the chance of being free from complains when it comes to service provision in its most accurate way.
OBJECTIVES OF THE STUDY
This study aims to develop the Villa Peña Resort Reservation System.
1. To create an organized database system that will retrieve all successful resort reservation. 2. To make easier to find the availability rooms.
3. To be able to make a fast and complete service and information that provides your reservation..
SCOPE AND DELIMITATION
This study will focus only to the process of Villa Pena Resort Reservation System. It covers the registration of the guests, room accommodations rate, changing and cancelling of reservations, room type’s availability, hotel amenities and other offers. The system is expected to accept the demographic profile from customer’s such as names, address, contact number, room type, duration of stay. The system will then store the accepted data in a database for future usage. However, this study will not accept any kind of payments such as cash, cheque, and credit card.
RELATED AND LITERATURE AND STUDIES
LOCAL LITERATURE HAIN NA?
In developing an effective system, the primary factor considering is to develop a better understanding of the current system and its prevailing problems. This chapter explains how the current system work description of the researchers’ proposal, which aimed to solve the problems encountered by the current system , regarding the reservation . THE CURRENT SYSTEM
In its current operation, the reservation of Villa Pena Resort is not yet fully computerized because some processes are still using a manual method. The front desk needs to search, update and keep every clients record into a filing cabinet where document are stored. This method of record keeping is time consuming. Moreover, on the part of the Client some of reservation is using electronic spreadsheet. PROPOSED SYSTEM
The proposed system shall utilize a minimum of two computers. One computer will be assigned for the front disk and one is for the admin office. The system comprises an electronic database and shall reside on the computer assigned for the admin office. The front desk will log in as a user name in Villa Peña Resort Reservation System, where she can view the dashboard, the table information of every room’s status, the menu script such as reservation, reports.
If the front desk wants to add rooms and amenities reservation, she will perform the reservation process, while the manager will log in as admin name in Villa Peña reservation System, were he can view the dashboard and check the record The approved reservation and currently check-in customer’s is viewed in the table management. To approved reservation system the front desk have to ask the customer if the reservation is final. COST AND BENEFIT ANALYSIS
The computerization of the current system involved financial sustain or funding. It is very essential to have a distinct financial resources and cost analysis in developing system to reach a certain goal. This proposal will be finally implemented in Villa Peña Resort with a required funding in developing system. In the cost and benefits analysis, the system will more likely have higher cost than the manual system but the Villa Peña Resort only need a one-time high cost on the proposed system and will afford the needed maintenance expense only.
After the estimated cost and the system by now is developed, Villa Peña Resort can completely utilize the system. The system who will be benefited: (1) The Management, the Villa Peña Resort can be able to make a fast, accurate and complete services than existing manual system. (2) Front Desk Officer, the paper works will be minimize while all the transaction will be directly stored to the database and produce required reports.(3) Costumer, it would be easy, simple and efficient transaction.
Context Diagram of the Current System
Updated Recordschecking Records
Data Flow Diagram of the Current System
Context Diagram of the Proposed System
Data Flow Diagram of the Proposed System
The following are the system cost:
Table1. System Hardware cost:
Intel (R) CPU
[email protected] (CPU)
Hitachi HDS 721050dle630
Mouse & Keyboard
Delkin / i4tech model (OP-720)
ATATI IHAS124 C
System Model H61H-MR
Table 2. System Software Cost:
Microsoft Windows7 ultimate
Visual Basic 2008
MySQL 5.6(Open source)
Hardware requirement Cost P ________________________
Software requirement Cost P ________________________
The following specification must be met for the proposed system to be implemented Hardware Requirement:
The proposed system will required the following hardware:
Intel (R) CPU 2GB or higher
[email protected] or higher
2GB memory or higher
@cost 500GB or higher
To be able to run the proposed system the following list of software needed: Microsoft Windows 7 Ultimate
My SQL 5.6
Visual Basic 2008