Forecasting Exercise.

You will complete a revenue forecast for the month of May.

The attached is a forecasting sheet for XYZ hotel for the month of May. It is now March, and your average booking window for Transient is $30$ to $45$ days out. Taking previous forecast as a starting point, please complete the forecast section based on the following assumptions:

Your forecast target for the month of May is to be at least $2\mathrm{.}2\%$ higher in revenue than your budget.

You just lost a big group for the month of May$(450$ Room nights at $$409$ ADR$).$ This will have a big impact on your revenue.$($ If you lost the group recently it means that this group was considered in your previous forecast. Make sure you reflect this loss in your forecast$)$

You have $100$ Room nights at $$320$ ADR in tentative $,$ that will become Definite by the end of March. This will help you mitigate some of the group loss.$($ assume this group was not considered in your previous forecast$)$

You just had a travel agent book your most expensive suite. $10$ Room nights for $$5000$ a night$($ This will belong in Retail segment$)$

Assuming there is no more group activity that will close between now and the end of may, What other changes should you make in transient to mitigate for the group loss and still achieve your targeted growth.

Please explain your numbers in detail and how you will achieve them$($ ex$.$ Launch promotions, packages, promote a discounted rate, etc$)$ Remember you are currently within your main booking window.$($ When you are within your booking window you can make the most impact$)$

$.$D: Keep in mind Budget does not change. This would be the plan or the goal your hotel wants to achieve.

Forecasts change monthly or weekly. Forecast is used to show the current direction your hotel is taking.

Please submit your detailed explanation to the numbers in a word document. Comment on your variance to Budget $,$ to previous forecast and actual $2013($ this means your variance to last year$)$

Submit your explanations on a separate word document in essay format. Make sure your work reflects your level as a Graduate student.

I have not included assumptions for last year ; therefore you are free to include your own assumptions, just make sure you explain them thoroughly.

Please submit both the excel sheet showing your forecast and the word document explaining your forecast.Example Freshwater green algae Charophytes Group $$