Improve decision making-using a database to clarify strategy

Assignment Help Business Management

Reference no: EM1342793

Improving Decision Making: Using a Database to Clarify Business Strategy

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.

Improving decision making: Using a database to clarify business strategy.
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.
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.
Attched, you will find a database for hotel reservation transactions developed in Microsoft Access. Illustrated below are some sample records from that database. Develop several reports in Access that provide information to help management make the business more competitive and profitable.

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?

Reference no: EM1342793

Questions Cloud

Dsecribe business policy and strategy : If a company has $1 million to spend on a new strategy and is considering market development versus product development, what determine factors would be most important to consider?

Theory of interest and decision-making concept : Explain the theory of interest and discuss the decision-making concept it applies to in analyzing cost and return on long-term investment.

Decision tree - explain a decision tree : Decision tree - Explain a decision tree and discuss how such a tool can be utilized to improve decision making

Relevant information for decision making : Identify at least three alternatives courses of action management could take with regard to the leftover T-shirts and which costs are sunk in this decision

Improve decision making-using a database to clarify strategy : Prepare 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?

Calculate total cost of renting or purchasing : What other factors should Dirt Bikes consider besides cost in determining whether to rent or buy the hardware and software

Show the steps in decision maing : Set managerial objectives and what do we want to achieve in the process? This activity may also be called recognizing the problem to solve.

Product to maximize baxters profits : Assume Baxter Manufacturing has 50,000 machine hours available and what would be the optimal production of each product to maximize Baxter's profits

Discuss financing risks and weighted means : Discuss financing risks and weighted means of decision making and show financing risks and weighted means of decision making

User Account

All Pages