Queen's Inn Case Study
The Queen`s Inn _Assignment 1
The table of information supplied, regarding the business activities of the Queen’s Inn, located on the Atlantic Ocean in St. John’s, Newfoundland, revealed much information. The following report will discuss the current business situation and will be followed by recommendations for change. These proposed changes will mainly deal with changes to the Inn’s present business strategies that will insure future profitability. Also reviewed will be modifications to the supplied database to enhance its efficiency and usefulness.
Currently, the Inn is performing relatively well, however, based on historical data within the supplied database, …show more content…
However, this information alone is very misleading. Three additional reports, “Room Type Occupancy”, “Base Income per Room”, and “Avg Income per Room Type per Night”, shed much light on exactly where its strengths lie. For instance, occupancy for the 3 Room Types show that the 10 Ocean view rooms have a 100% occupancy rate, while the 10 Bay view rooms rate at 80% and the 10 Side view at only 40%. As well, base income shows the Ocean view rooms account for well over half of the total income and average $254 per room per night while the Bay view and Side Street view average $155 and $127 respectively. As for who is renting these rooms, it can be speculated that it would be mostly couples taking advantage of the Romantic Weekend Getaways. Typically speaking, those seeking business and family accommodations would opt for less expensive rooms. In terms of future business, based on this information, emphasis on this sector of potential customers would be very …show more content…
The first of these recommendations is the investment in a computerized reservation and bookkeeping software that is tailored to this type of business. Aside from this, the supplied Access database could be modified to supply like information for strategic decisions. Information can be inputted through drop down menus and records added through completion of standard forms requesting detailed information upon Guest reservation and or check in. This inputted information will feed and update a modified table that will gather and save the information that will be vital for future decisions. In addition to the database fields already in the table, other information needs to be collected. Information related to discounts given will show if package style discounts are working. Fields identifying extra charges, such as extra guest charges, are important information. One step further would be to have these types of discounts and additional charges located in a table by themselves so that they can be changed and modified without changing historical data (the present income information within the database does not specify what discounts or charges may or may not have been applied). These tables can be accessed
The table of information supplied, regarding the business activities of the Queen’s Inn, located on the Atlantic Ocean in St. John’s, Newfoundland, revealed much information. The following report will discuss the current business situation and will be followed by recommendations for change. These proposed changes will mainly deal with changes to the Inn’s present business strategies that will insure future profitability. Also reviewed will be modifications to the supplied database to enhance its efficiency and usefulness.
Currently, the Inn is performing relatively well, however, based on historical data within the supplied database, …show more content…
However, this information alone is very misleading. Three additional reports, “Room Type Occupancy”, “Base Income per Room”, and “Avg Income per Room Type per Night”, shed much light on exactly where its strengths lie. For instance, occupancy for the 3 Room Types show that the 10 Ocean view rooms have a 100% occupancy rate, while the 10 Bay view rooms rate at 80% and the 10 Side view at only 40%. As well, base income shows the Ocean view rooms account for well over half of the total income and average $254 per room per night while the Bay view and Side Street view average $155 and $127 respectively. As for who is renting these rooms, it can be speculated that it would be mostly couples taking advantage of the Romantic Weekend Getaways. Typically speaking, those seeking business and family accommodations would opt for less expensive rooms. In terms of future business, based on this information, emphasis on this sector of potential customers would be very …show more content…
The first of these recommendations is the investment in a computerized reservation and bookkeeping software that is tailored to this type of business. Aside from this, the supplied Access database could be modified to supply like information for strategic decisions. Information can be inputted through drop down menus and records added through completion of standard forms requesting detailed information upon Guest reservation and or check in. This inputted information will feed and update a modified table that will gather and save the information that will be vital for future decisions. In addition to the database fields already in the table, other information needs to be collected. Information related to discounts given will show if package style discounts are working. Fields identifying extra charges, such as extra guest charges, are important information. One step further would be to have these types of discounts and additional charges located in a table by themselves so that they can be changed and modified without changing historical data (the present income information within the database does not specify what discounts or charges may or may not have been applied). These tables can be accessed