Question

In: Accounting

Hotel Sport is in the suburb of large metropolitan area near a sports complex that has...

Hotel Sport is in the suburb of large metropolitan area near a sports complex that has a stadium suitable for baseball and soccer games. The 250-room independent hotel is a select-service property in the mid-range category. Its rate structure is simple:

Rack                                         $190

Weekend                                 $159

Low season/Government    $140

Groups (of 15+)                     $130

Best available rate                 $120

Late August is traditionally a slow season in the hotel and business picks up in September after area businesses and government offices are back in full gear. The sell rate in late August is the $140 low season rate. For the weekend of August 20 to 22 the forecasted occupancy is around 130 rooms. The reservations on the book are 90 guaranteed and 25 non-guaranteed reservations. The hotel expects 15 walk-ins.

Questions

  1. It is July 29. What rate should the revenue manager approve to quote for reservation inquiries for the weekend of August 20–22?

  1. Now it is July 30. One day later: The Major League Soccer Franchise of the city had just clinched a spot in the playoffs and the first game in the elimination round will be against a team from California, the L. A. Galaxy. They have the world’s most famous superstar, David Beckham, in its lineup on August 21. All the hotels in the city are filling up fast and phones with reservation inquiries are ringing off the hook at the Sport.

What rate should the revenue manager approve to quote now for group reservation inquiries for the weekend of August 20–22? Are there any stay control measures that should be considered?

Solutions

Expert Solution

Total No. of Rooms= 250

The rate structure is

Rack                                         $190

Weekend                                 $159

Low season/Government    $140

Groups (of 15+)                     $130

Best available rate                 $120

Avg rate= $ (190+159+140+130+120)/5= $ 147.8

For the weekend of August 20 to 22 the forecasted occupancy is around 130 rooms. The reservations on the book are 90 guaranteed and 25 non-guaranteed reservations. The hotel expects 15 walk-ins.

July 29- The revenue manager should approve weekend rate ie. $ 159 as the questions says Aug 20 to Aug 22 is weekend and expected occupancy is more than 50%.

July 30- On July 30, the revenue manager should quote highest rate i.e $ 190 as They have the world’s most famous superstar, David Beckham, in its lineup on August 21. All the hotels in the city are filling up fast and phones with reservation inquiries are ringing off the hook at the Sport.

The hotel should take guaranteed bookings only as its quite a possiblilty that all the rooms will be filled up fast and there would be 100% occupancy on the given dates. Non guaranteed bookings should be avoided. Minimum booking days should be told.


Related Solutions

Ana Carillo and Associates is a medium-sized company located near a large metropolitan area in the...
Ana Carillo and Associates is a medium-sized company located near a large metropolitan area in the Midwest. The company manufactures cabinets of mahogany, oak, and other fine woods for use in expensive homes, restaurants, and hotels. Although some of the work is custom, many of the cabinets are a standard size. One such non-custom model is called Luxury Base Frame. Normal production is 1,000 units. Each unit has a direct labor hour standard of 5 hours. Overhead is applied to...
Cowen’s, a large department store located in a metropolitan area, has been experiencing difficulty in estimating...
Cowen’s, a large department store located in a metropolitan area, has been experiencing difficulty in estimating its bad debts. The company has decided to prepare an aging schedule for its outstanding accounts receivable and estimate bad debts by the due dates of its receivables. This analysis discloses the following information: Balance Age of Receivable Estimated Percentage Uncollectible $191,000 Under 30 days 0.8% 118,000 30-60 days 2.0% 73,000 61-120 days 5.0% 41,000 121-240 days 20.0% 25,000 241-360 days 35.0% 19,000 Over...
B. Jane Botosan operates a Hostelworld in an area near Amsterdam. Depreciation on the hotel is...
B. Jane Botosan operates a Hostelworld in an area near Amsterdam. Depreciation on the hotel is $60,000 per year. Jane employs a maintenance person at an annual salary of $41,000 and a cleaning person at an annual salary of $24,000. Real estate taxes are $10,000 per year. The rooms rent at an average price of $60 per person per night including breakfast. Other costs are laundry and cleaning service at a cost of $10 per person per night and the...
A survey is conducted to estimate the average household income in a large metropolitan area. A...
A survey is conducted to estimate the average household income in a large metropolitan area. A random sample of 150 households in this area yielded an average household income of $55,000 with a standard deviation of $13,200. Construct a 95% confidence interval for the mean household income in this area. (Choose the BEST answer)
. A sample of 500 respondents was selected in a large metropolitan area to study consumer...
. A sample of 500 respondents was selected in a large metropolitan area to study consumer behavior, with the following results shown through the contingency table: Gender Enjoy Shopping for Male Female Total Clothing Yes 136 224 360 No 104 36 140 Total 240 260 500 a. Find the probability of selecting a male respondent.                                 (2) b. What is the probability that selected respondent is a female who enjoys shopping for clothing?(2) c. What is the probability, if a person is...
Daisy Tree Partnership owns and operates two apartment complexes in the metropolitan area. The first complex...
Daisy Tree Partnership owns and operates two apartment complexes in the metropolitan area. The first complex was contributed to the partnership by partner L. The other two partners (M and N) contributed cash which, together with borrowed funds, was used to purchase the second complex. The three partners share partnership income, loss, gain and deduction equally. The tax basis and book value of the partnership’s assets at the end of the current year are as follows: Tax Book Cash and...
Those insured by this health plan are employed mostly by large companies in the metropolitan area,...
Those insured by this health plan are employed mostly by large companies in the metropolitan area, and these companies pay for their employees’ health insurance. The health plan leaders and the employers both recognize that their business model depends on their success in addressing behavioral risk factors that play a critical role in the prevention and management of chronic diseases, the containment of health care costs, and the enhancement of employee productivity. In your new role, you are asked to...
Researchers doing a study of incomes in a large metropolitan area want to determine if residents...
Researchers doing a study of incomes in a large metropolitan area want to determine if residents in Suburban District 1 have different mean income from residents in Suburban District 2. They collected the data and found the following sample means and variances. Use these data to conduct a hypothesis test of their research question, using α = .05. Suburban District 1 Suburban District 1 Sample Size 50 49 Sample Mean 1 = 34,270 2 = 32,780 Sample Variance = 8740...
In a certain school district in a large metropolitan area, the SAT scores over that past...
In a certain school district in a large metropolitan area, the SAT scores over that past five years are normally distributed with a mean of 1538. Furthermore, P30 is 1384. What is the P99P99 score for this population?
. Suppose that banana prices at supermarkets in a particular large metropolitan area follow a normaldistribution...
. Suppose that banana prices at supermarkets in a particular large metropolitan area follow a normaldistribution with mean µ= 58.6 cents per pound and standard deviation σ= 4.3 cents per pound. For parts (a) through (c), what is the probability that the price of bananas at a random supermarket will be: (a)  below 55 cents per pound? (b)  above 65 cents per pound?   (c)  Between 57 and 62 cents per pound? (d) Below 57 cents or above 62 cents per pound? (d)  What is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT