Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HOTEL INVENTORY 149 Fill in the grey columns with your forecast. DAYS OF MONTH 31 We are in the last days of February and these

image text in transcribedimage text in transcribed

HOTEL INVENTORY 149 Fill in the grey columns with your forecast. DAYS OF MONTH 31 We are in the last days of February and these data correspond to March. Hotel room inventory 149 Days of the month 31 We are about to start the new month of March 2020. The situation of the hotel in shown in "Proyection data". Answer the questions that appear in the box below, including the correspondent formulas in the cells. What is the % of occupancy and RevPar that the hotel did obtain Iast year in the given month? %OCCREVPAR To achieve the existing revenue budget objective given, what ADR should we achieve in the pending rooms to be sold for the rest of the month? Comparing last year results and the current year budget, what is the \% of revenue growth stablished in the budget when we compare both data? \% OCC ADR ROOMS REV. What is the % of completion of the given revenue budget that is expected, according to your forecast? Would you reach, exceed or fail to achieve the objective? If your answer is yes, explain the main aspects that should have been taken into account to apply such a change of strategy and its main repercussions. HOTEL INVENTORY 149 Fill in the grey columns with your forecast. DAYS OF MONTH 31 We are in the last days of February and these data correspond to March. Hotel room inventory 149 Days of the month 31 We are about to start the new month of March 2020. The situation of the hotel in shown in "Proyection data". Answer the questions that appear in the box below, including the correspondent formulas in the cells. What is the % of occupancy and RevPar that the hotel did obtain Iast year in the given month? %OCCREVPAR To achieve the existing revenue budget objective given, what ADR should we achieve in the pending rooms to be sold for the rest of the month? Comparing last year results and the current year budget, what is the \% of revenue growth stablished in the budget when we compare both data? \% OCC ADR ROOMS REV. What is the % of completion of the given revenue budget that is expected, according to your forecast? Would you reach, exceed or fail to achieve the objective? If your answer is yes, explain the main aspects that should have been taken into account to apply such a change of strategy and its main repercussions

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions