Problem 2. Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR)...

Problem 2.
Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.)

	ADR ($)	Variable Cost ($)
Standard rooms	461.20	299.78
Deluxe rooms	737.92	427.99


The Mock Hotel's fixed costs for a month is = =		295168
Sales mix (contribution of each room type to total room revenue) of the hotel is:

Deluxe rooms	77%
Standard rooms	23%

Required:
Using the information provided above, answer the following questions:
a. What is the break-even room nights (number) for the the hotel given the sales mix of the two room packages?
b. What must be the room revenue for the hotel to make a profit of $50,000 a month?
c. If the hotel is considering an advertisement campaign for its rooms with a cost $5,000, hom much in room revenue should be generated to cover this extra cost?

Expert Solution

The answer has been presented in the supporting sheet. For detailed answer refer to the supporting sheet.

ekkarill92 answered 1 year ago

Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and...

Ada Hotel sells two room tpes: standard rooms and deluxe rooms. Average daily rate (ADR) and variable costs (VC) of the two room types are provided in the table below: (Hint: Treat two room types as two different products.) ADR ($) Variable Cost ($) Standard rooms 394.50 256.43 Deluxe rooms 631.20 366.10 ...

In exercise 12, the following data on x = average daily hotel room rate and y...

In exercise 12, the following data on x = average daily hotel room rate and y = amount spent on entertainment (The Wall Street Journal, August 18, 2011) lead to the estimated regression equation ŷ = 17.49 + 1.0334x. For these data SSE = 1541.4. Click on the webfile logo to reference the data. a. Predict the amount spent on entertainment for a particular city that has a daily room rate of $89 (to 2 decimals). $ b. Develop a...

The city of Seattle sells an average of 30,000 hotel rooms per night. Currently, those rooms...

The city of Seattle sells an average of 30,000 hotel rooms per night. Currently, those rooms have an average tax of $90. The city proposed an additional tax of $10 per room to help finance a stadium. Economists believe that without the tax, the city would average an extra 4000 rooms per night due to the new stadium. But with the tax, the number of rooms sold would fall to 27,000 even with the stadium. Based on these numbers, would...

A hotel chain wants to estimate the average number of rooms rented daily in each month....

A hotel chain wants to estimate the average number of rooms rented daily in each month. The population of rooms rented daily is assumed to be normally distributed for each month with a standard deviation of 24 rooms. During January, a sample of 16 days has a sample mean of 48 rooms. This information is used to calculate an interval estimate for the population mean to be from 40 to 56 rooms. What is the level of confidence of this...

Exercise 1: (10 marks) Average daily hotel room rate (x) and amount spent on entertainment (y)...

Exercise 1: Average daily hotel room rate (x) and amount spent on entertainment (y) is given in the following table for different cities. a. Use these data to develop an estimated regression equation that could be used to predict the amount spent on entertainment for a given average daily hotel room rate. b. What is the value of sample correlation coefficient? c. Compute the coefficient of determination. What percentage of the variation in total amount spent on entertinment can be...

Problem 1 The King Hotel has 400 rooms. Each room rents for $62 per day and...

Problem 1 The King Hotel has 400 rooms. Each room rents for $62 per day and has a variable cost of $12 per day. The hotel’s monthly fixed costs are $450,000. (Assume that each month has 30 days.) Required: 1. Compute the breakeven point in rooms rented. 2. Compute the daily occupancy percentage that the hotel must have in order to break even. 3. Compute the total number of rooms that must be paid for and occupied per month to...

A hotel has 200 rooms and charges two different room rates: rL =$100/ night for...

A hotel has 200 rooms and charges two different room rates: rL = $100/ night for discount fares and rH = $500/ night targeting business travelers. Demand for the discounted rooms exceeds the 200 room hotel capacity.A. What is the Co (overage cost), in $?B.What is the Cu, underage cost, in $?C. What is the critical ratio (round to two digits)?D. Assuming the demand for high fare rooms has a Normal distribution with mean =50 and standard deviation =15, how...

A company sells two products: a standard model and a deluxe model. The standard model sells...

A company sells two products: a standard model and a deluxe model. The standard model sells for $50 and has a contribution margin ratio of 40%. The deluxe model sells for $100 and has a contribution margin ratio of 50%. Last year, the company sold 5000 standard units and 2500 deluxe units. There is $200,000 of cost that is “fixed” in the sense that it does not vary with the number of units produced. However, $100,000 of this cost is...

A researcher wished to compare the average daily hotel room rates between San Francisco and Los...

A researcher wished to compare the average daily hotel room rates between San Francisco and Los Angeles. The researcher obtained an SRS of 15 hotels in downtown San Francisco and found the sample mean ? ̅1=$156, with a standard deviation ?_1= $15. The researcher also obtained an independent SRS of 10 hotels in downtown Los Angeles and found the sample mean ? ̅_2= $143, with a standard deviation ?_2= $10. Let 1 and 2 represent the mean cost of the...

The average daily rate of a hotel in Canada as of August 2018 was $182.65. Assume...

The average daily rate of a hotel in Canada as of August 2018 was $182.65. Assume the average daily rate follows a normal distribution with a standard deviation of $25.70. Standard Normal Distribution Table a. What is the probability that the average daily rate of a Canadian hotel will be: (i) less than $175 P(X < 175)=P(X < 175)= (ii) more than $200 P(X > 200)=P(X > 200)= (iii) Between $150 and $190 P(150 < X < 190)=P(150 < X...

Question