Submitted by: Submitted by avowed
Views: 1050
Words: 474
Pages: 2
Category: Business and Industry
Date Submitted: 02/11/2011 08:18 PM
PROBLEM:HOW TO DETERMINE BEST-SELLING PRODUCTS, RETAIL STORES, AND SALES TERRITORIES USING POINT-OF-SALE DATA. • REQUIRED BUSINESS SKILLS:Reservation Systems, Customer Analysis • REQUIRED SOFTWARE SKILLS:Database querying and reporting, database design • PROJECT NAME: Analyzing The President’s Inn Current Business Situation When analyzing the data within the Presidential Inn’s reservations
transactions database, valuable data can tell us a lot about the Inn’s current
business situation.Using access tools data can be manipulated into
meaningful and interpretable information that can be used as an aid in decision
making by management.The reservations transactions database contains
various data such as the guest’s name, number of guests, the arrival date, the
departure date, the room type and the exact room.From the data given it was
necessary to add fields to calculate base Income and length of stay.
Questions and Solutions: 1. Describe what the database information reveals about the current business situation. The database contained information regarding revenues in the month of
December, and when manipulating the data to find the base income per
room, it revealed that revenues throughout all of the room are only
amounted to $6,134 for the month.This may be due to the out of date
“manual reservation and bookkeeping system,” being used, having the
problem that families have been double booked in the same room.
Overall the current business situation is not a positive one and it could
be better, if they are only generating roughly $6,000 per month that
amounts to less than $80,000 a year and that is not enough revenue for
a hotel to stay in operation.
Nicole Teibel 2. Which specific business strategies might be pursued to increase room occupancy and revenue? The Database reveals that the Presidents Inn mainly has a customer
base of guests who are staying for short periods of time.You can tell
from the data that the hotel only has the capacity of 6...