Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line 3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem.Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem 3.6 Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

You operate a luxury hotel in Baltimore that famous celebrities rent for extended periods. The daily price is per room is $1,950. Operating costs average $60,000 per day, regardless of the number of rooms rented. Construct a spreadsheet model to determine the profit if 60 rooms are rented. The manager has observed that the number of rooms rented during any given day varies between 50 and 80 (the total number of rooms available).

a.Use data tables to evaluate the profit for this range of unit rentals.

b.Suppose the manager is considering lowering or increasing the daily price by $100. How will profit be affected? (Hint: use a two-way data table).

Once upon a time a new hotel manager, whose staff was responsible for selling banquets and hotel packages, was highly motivated to take advantage of a year-end bonus program for managers. In order to win the bonus, he needed to bring in new business so he decided to initiate a contest for his sales agents. He announced that he would pay $100 to the agent who had brought in the most new clients by the end of the month. He then sat back in his chair to await the results and decide how he would spend his bonus money. While visions of bonuses danced through his head, his sales agents were busily belly-aching for the following reasons:

(1) They were used to working as a team and resented being encouraged to compete against each other.
(2) In the manager's last contest, a new sales agent had reportedly cheated and "stole" new clients from the old-timers.
(3) The winner of the last contest was paid the prize money several months late, only after she had "shaken" it out of the sales manager.
(4) One sales agent's position had been cut, so the agents felt they were already operating beyond full capacity and working extra hours.
(5) The sales manager had not endeared himself to the agents, and they felt he was just using them to get his bonus.
(6) The sales agents felt as if they were being manipulated and perceivd the $100 bonus as an insult.

Not surprisingly, then, the sales agents decided to ignore the contest. The sales manger was angry when he saw the low level of new business at the end of the month and concluded that the agents were lazy. He told them they were unprofessional and complained about them at staff meetings so that soon everyone in the organization had heard about their "laziness." Old-timers who knew better scratched their heads because they remembered how hard the sales agents used to work before the new manager was hired. Within a few months, some of the agents quit and went to work for a competitor.

Questions:

(1) Should this manager go back to school and learn about the theories of motivation? What mistakes did he make?

(2) Which motivation theories apply to this case? Explain your answer. Does Expectancy Theory apply, and if so, how (explain)? What about Reinforcement Theory or Self-Determination Theory? Be sure to explain your answers.

(3) What do you think the sales manager should have done to try to motivate his sales agents? Relate your motivational strategies to the theories that we have discussed in class.

A resort hotel administrator is assigned to conduct performance reviews of the 47 guest services representatives at the resort, and the length of time that the administrator typically spends doing each of these performance reviews is normally distributed with a mean of 63.9 minutes and a standard deviation of 18.4 minutes. The administrator is scheduled to meet with 7 guest service representatives today.

Standard Normal Distribution Table

a. What is the probability that the administrator will spend an average of less than one hour with each of the representatives?

Round to four decimal places if necessary

b. What is the probability that the administrator will spend a total of more than 7.5 hours with all 7 of the representatives?

Round to four decimal places if necessary

c. Within what range of values will the middle 99% of average times spent with each of the 7 representatives fall?

Range:

to

minutes

Round to one decimal place if necessary

d. What is the maximum total length of time the administrator would expect to spend with all 7 guest service representatives today, with a probability of 0.98?

minutes

Round to one decimal place if necessary

Use the SEM formula and show all work.

How satisfied are hotel managers with the computer systems their hotels use? A survey was sent to 400 managers in hotels of size 200 to 500 rooms in Chicago and Detroit. In all, 101 managers returned the survey. Two questions concerned their degree of satisfaction with the ease of use of their computer systems and with the level computer training they had received. The managers responded using a seven-point scale, with 1 meaning "not satisfied", and 4 meaning "moderately satisfied," and 7 meaning "very satisfied".

a. What do you think is the population for this study? What are the major shortcomings in the obtained data?

b. The mean response for satisfaction with ease of use was 5.396. Find the 95% confidence interval for the managers sampled. (Assume the sample SD = 1.75)

c. Provide an interpretation for your answer in part B.

d. For satisfaction with training, the mean response was 4.398. Assuming the sample SD is 1.75, find the 99% confidence interval for the managers sampled.

e. Provide an interpretation of your answer obtained for part D.

The file Hotel Prices contains the prices in British pounds (about US$ 1.52 as of July 2013) of a room at two-star, three-star, and four-star hotels in cities around the world in 2013.

e. Compute the covariance between the average price at two-star and three-star hotels, between two-star and four-star hotels, and between three-star and four-star hotels.

f. Compute the coefficient of correlation between the average price at two-star and three-star hotels, between two-star and four-star hotels, and between three-star and four-star hotels.

g. Which do you think is more valuable in expressing the relation-ship between the average price of a room at two-star, three-star, and four-star hotels—the covariance or the coefficient of cor-relation? Explain.

h. Based on (f), what conclusions can you reach about the relationship between the average price of a room at two-star, three-star, and four-star hotels?