Assume you are working on budgeting for the room department of your hotel. Assume the hotel’s...

Assume you are working on budgeting for the room department of your hotel.
Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2016. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year.
Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $250,000 during 2016. For 2017, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2016.
Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2016. For 2017, this fixed cost will increase by 2% due to the expected increase in living expenses in this area.

What will be the budgeted ‘Room Revenue (Sales)’ for 2017?

What will be the budgeted ‘Guest Supplies’ expenses for 2017?

What will be the budgeted ‘Salaries’ expenses for 2017?

Solutions

Expert Solution

1. Computation of budgeted ‘Room Revenue (Sales)’ for 2017:

Budgeted Room Revenue for 2017 = Budgeted Room Revenue for 2016 + Increase in Revenue in 2017

Therefore, Budgeted Room Revenue for 2017 = $1,640,000 + 3.7% of $1,640,000 = $1,700,680.

2. Computation of budgeted ‘Guest Supplies’ expenses for 2017:

As the variable cost of Guest Supplies will remain same as percentage of the Room Revenue (Sales) as experienced in 2016 we will first calculate the Variable Cost as a percentage of sale in 2016 which will be as follows:

Variable Cost as a percentage of sale in 2016 = Variable Cost in 2016/Revenue in 2016 * 100

Therefore,Variable Cost as a percentage of sale in 2016 = $250,000/$1,640,000* 100 = 15.24%

Therefore, budgeted ‘Guest Supplies’ expenses for 2017 = $1,700,680 * 15.24% = $259,250

3. Computation of budgeted ‘Salaries’ expenses for 2017:

Budgeted ‘Salaries’ expenses for 2017 = Salary in 2016 + Budgeted Increase in salary expenses

Therefore,Budgeted ‘Salaries’ expenses for 2017 = $280,000 + 2% of $280,000 = $285,600

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

1. A 345-room hotel’s food and beverage department recorded food revenue of $3,460,397.5 and beverage revenue...

1. A 345-room hotel’s food and beverage department recorded food revenue of $3,460,397.5 and beverage revenue of $1,483,027.5. The cost of sales was 27.3% of F & B revenue, and the departmental expenses were 43.2% of F & B revenue. What is the gross profit percentage for the hotel’s F&B department? 2. Year 1 Year 2 Gross Room Rate (GRR) $245.00 Direct Costs (35% of GRR) $85.75 Net Room Rate (NRR) $159.25 Expenses-(Fixed) (FE) $60.00 Net Profit (NP) $99.25 Profit...

. Assume you are working for the US government. The president wants your department to study...

. Assume you are working for the US government. The president wants your department to study the clothing market. The US governments need to raise revenues from the Clothing market, and you are assigned to study the cotton shirt market. You have access to the previous data: - If P = 20 then ???? = 80. If P = 30 then ???? = 70. - If P = 20 then ???? = 25. If P= 30 then ???? = 40....

Assume you are working for the US government. The president wants your department to study the...

Assume you are working for the US government. The president wants your department to study the clothing market. The US governments need to raise revenues from the Clothing market, and you are assigned to study the cotton shirt market. You have access to the previous data: - If P = 20 then ???? = 80. If P = 30 then ???? = 70. - If P = 20 then ???? = 25. If P= 30 then ???? = 40. The...

What are the differences between a hotel’s right to refuse to provide a room to a...

What are the differences between a hotel’s right to refuse to provide a room to a would-be guest and a restaurant’s right to exclude? Draft a 250 - 300 word discussion explaining the your answer in detail.

Assume that you are working in a community health department. The department has some federal money...

Assume that you are working in a community health department. The department has some federal money that it wants to allocate to two health promotion programs from the following: Decrease in deaths from cardiovascular disease Decrease in deaths from breast cancer Decrease in teenage pregnancy Decrease in cigarette smoking Decrease in incidence of diabetes Decrease in motor vehicle accidents Decrease in osteoporosis and hip fractures among women Decrease in obesity Address the following questions: Identify the risk factors associated with...

"The Role of the Room Rate" Analyze the hotel market in your state and determine if...

"The Role of the Room Rate" Analyze the hotel market in your state and determine if the room rates for the majority of hotels is elastic or inelastic. Explain your rationale and identify contributing factors (e.g., tax rates, competition, etc.). Imagine opening a small hotel in the town in which you attend class, Briefly describe the hotel and determine how you would determine the proper room rate.

Case Study: Assume that the company, where you are working as ateam in Financial Department,...

Case Study: Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 650 000 unit per year at this price for a period of 4 years. Launching this project will require purchase of a $3 500 000 equipment that has residual value in four years of $500...

Question