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


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

Deluxe rooms   66%
Standard rooms    34%

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

W/n- Computation of Contribution Margin Ratio
Room	ADR(a)	Variable Cost (b)	Contribution (c=a-b)	CM Ratio (c/a)
Standard	$394.50	$256.43	$138.07	35.00%
Deluxe	$631.20	$366.10	$265.10	42.00%

W/No Computation of Weighted Average Contribution Margin Ratio
Room	Sales mix % (a)	Contribution per Unit (b)	*Weighted average contribution Margin per Unit (ab)**	CM Ratio (c )	*Weighted average contribution Margin Ratio(ac)**
Standard	34%	138.07	46.94	35%	11.900%
Deluxe	66%	265.10	174.97	42%	27.720%

Weighted Average CM	221.91		39.620%

Computation of BEP Room Night

BEP= Fixed Cost/ Weighted Average CM per Unit

BEP= 252480/221.91= 1137.76

Computation of Room Revenue for Hotel to make target Income

BEP=( Fixed Cost+ Target Income )/ Weighted Average CM Ratio

BEP=(252480+50000)/39.62%= $763453

Computation of Room Revenue to be generated for Extra Cost

Extra Cost / CM Ratio

$5000/39.62%=$12620

ekkarill92 answered 2 years ago

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...

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...

Sox Shogun Hotel sold 2,000 rooms during the past month at an ADR of $70.00. During...

Sox Shogun Hotel sold 2,000 rooms during the past month at an ADR of $70.00. During this month, the ADR is increased by $7.00 and the total number of rooms sold is 1,900. What is the price elasticity of demand? What is the effect of the decrease in the #of rooms to the total room revenue for the Sox Shogun Hotel during this month? Group of answer choices $5,600 decrease $6,300 increase $6,300 decrease $5,600 increase

Glitz hotel, a 500-room hotel, rents hotel rooms for $120/night. At the current sales level of...

Glitz hotel, a 500-room hotel, rents hotel rooms for $120/night. At the current sales level of 400 rooms per night, Glitz currently makes a profit of $30/room: Per room Sales $120 Costs 90 Profit 30 It costs Glitz $90/night to maintain a room ($60 in depreciation, $25 in variable maintenance and $5 in fixed booking costs). Glitz has been approached by Conventions2000.com to purchase a block of 300 rooms for $80/room per night. If this special...

Sector hotel, a 500-room hotel, rents hotel rooms for $120/night. At the current sales level of...

Sector hotel, a 500-room hotel, rents hotel rooms for $120/night. At the current sales level of 400 rooms per night, Glitz currently makes a profit of $30/room: Per room Sales $120 Costs 90 Profit 30 It costs Sector $90/night to maintain a room ($60 in depreciation, $25 in variable maintenance and $5 in fixed booking costs). Sector has been approached by Conventions2000.com to purchase a block of 300 rooms for $80/room per night. If this special...

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 335-room hotel property recorded in 2004 a 66.6% occupancy and an ADR of $117.98. What...

A 335-room hotel property recorded in 2004 a 66.6% occupancy and an ADR of $117.98. What is the property’s franchise fee (1) on a per available room basis and (2) as a percentage of rooms revenue if the agreement required the hotel to pay a reservation fee of $7.65 per available room per month; a royalty fee of 5% of rooms revenue; an advertising fee of 2.3% of rooms revenue; and a frequent traveler program fee of $5.00 per occupied...

Question