The Presidents' Inn is a three-story hotel on the Atlantic Ocean in Cape May, NJ, a popular Northeastern U.S. resort. Ten rooms overlook side streets, ten rooms have bay windows that offer limited views of the ocean, and the remaining ten 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% discount on their daily room rates.
Business has grown steadily over the past ten years. Now totally renovated, the hotel 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 bed and breakfast's daily operations and income.
Use the information provided in this description and in the database tables on the Laudon Web site for Chapter 3 below to develop reports that would provide information to help management make the business more competitive and profitable. The database and related queries should be designed to make it easy to identify the information, such as the average length of stay per room type, the average number of visitors per room type, and the base income per room (i.e., length of visit multiplied by the daily rate) during a specified period of time.
After identifying the above information, write a brief report describing what your database information tells you about your current business situation. For example, what is your strongest customer base? What specific business strategies might you pursue to increase room occupancy and revenue?
Data Management experienced professional and experienced database programmer. Please see PMB for more details. You should not pay more than $100 for this work.
8 freelancere byder i gennemsnit $257 for dette job
Hello, I'm ready to start developing right away. My price is for a full software solution and not just reports. I have experience in creating large scale access databases for businesses. Please see my personal message.