In this exercise, youll use database software to analyze the reservation transactions for a hotel and use

Question:

In this exercise, you’ll use database software to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel’s business strategy and marketing activities.

The Presidents’ Inn is a small three-story hotel on the Atlantic Ocean in Cape May, New Jersey, a popular northeastern U.S. resort. Ten rooms overlook side streets, 10 rooms have bay windows that offer limited views of the ocean, and the remaining 10 rooms in the front of the hotel face the ocean. Room rates are based on room choice, length of stay, and number of guests per room. Room rates are the same for one to four guests. Fifth and sixth guests must pay an additional $20 charge each per day. Guests staying for seven days or more receive a 10-percent discount on their daily room rates.

Business has grown steadily during the past 10 years. Now totally renovated, the inn uses a romantic weekend package to attract couples, a vacation package to attract young families, and a weekday discount package to attract business travelers. The owners currently use a manual reservation and bookkeeping system, which has caused many problems. Sometimes two families have been booked in the same room at the same time. Management does not have immediate data about the hotel’s daily operations and income.

In MyMISLab, you will find a database for hotel reservation transactions developed in Microsoft Access. A sample is shown below, but the Web site may have a more recent version of this database for this exercise.

Develop some reports that provide information to help management make the business more competitive and profitable. Your reports should answer the following questions:

• What is the average length of stay per room type?

• What is the average number of visitors per room type?

• What is the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time?

• What is the strongest customer base?

After answering these questions, write a brief report describing what the database information reveals about the current business situation. Which specific business strategies might be pursued to increase room occupancy and revenue? How could the database be improved to provide better information for strategic decisions?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Management Information Systems

ISBN: 9780132142564

12th Edition

Authors: Ken Laudon, Kenneth Laudon, Jane Laudon

Question Posted: