3-10 In this exercise, you will 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.

In MyMISLab, you will find a database for hotel reservation transactions developed in Microsoft Access with information about The President’s Inn in Cape May, New Jersey. At the Inn, 10 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 person per day. Guests staying for seven days or more receive a 10 percent discount on their daily room rates.

The owners currently use a manual reservation and bookkeeping system, which has caused many problems. Use the database to develop reports on average length of stay, average visitors per room, base revenue per room (i.e., length of visit multiplied by the daily rate), and strongest customer base. After answering these questions write a brief report about the Inn’s current business situation and suggest future strategies.