Business, 27.11.2019 20:31 khenalilovespandas

In this exercise, you will use database to analyze the reservation transactions for a hotel and use that information to fine-tune the hotel’s business strategy and marketing activities. this exercise encourages you to develop queries and reports in a database software to you make better use of transaction data to understand your business. the attached file hotel contains information about the president’s inn hotel in cape may, nj. at the inn, 10 rooms overlook side streets, 10 rooms have bay windows with 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 per person per day. guests staying for seven days or more receive a 10 percent discount on their daily room rates. use the database to develop reports on average length of stay per room type, average visitors per room type, base revenue per room (i. e., length of visit multiplied by the daily rate) during a specified period of time, and strongest customer base. you may use the query wizard and report wizard capabilities of access. from analyzing these data, you should be able to find ways of generating more revenue. write a brief report about the inn’s current business situation and suggest future strategies in the word document.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 23:00

James has set the goal of achieving all "a"s during this year of school.which term best describes this goal

Answers: 2

Answer

Business, 22.06.2019 03:30

Lindon company is the exclusive distributor for an automotive product that sells for $30.00 per unit and has a cm ratio of 30%. the company’s fixed expenses are $162,000 per year. the company plans to sell 20,200 units this year. required: 1. what are the variable expenses per unit? (round your "per unit" answer to 2 decimal places.) 2. what is the break-even point in unit sales and in dollar sales? 3. what amount of unit sales and dollar sales is required to attain a target profit of $72,000 per year? 4. assume that by using a more efficient shipper, the company is able to reduce its variable expenses by $3.00 per unit. what is the company’s new break-even point in unit sales and in dollar sales? what dollar sales is required to attain a target profit of $72,000?

Answers: 2

Answer

Business, 22.06.2019 21:00

Noah met an old friend at a coffee shop. he jotted down the friend's new phone number, but later that afternoon he could not find it or remember what he had done with it. a couple of days later, noah went back to the coffee shop, and while waiting in line, he suddenly remembered where he had put the phone number. this is an example of:

Answers: 1

Answer

Business, 22.06.2019 22:00

Brody corp. uses a process costing system in which direct materials are added at the beginning of the process and conversion costs are incurred uniformly throughout the process. beginning inventory for january consisted of 1,050 units that were 65% completed. 10,900 units were started into the process during january. on january 31, the inventory consisted of 500 units that were 50% completed. what would be the equivalent units for direct materials cost using the weighted average method?

Answers: 2

Answer

You know the right answer?

In this exercise, you will use database to analyze the reservation transactions for a hotel and use...

Questions