|
| Costa del Sol Hotel in Marbella |
| The Manager of Costa del Sol Hotel in Marbella has asked you to prepare a budgeting forecast for the years 2023 - 2026. |
| You have acquired the following forecasted information: |
| General Info |
The occupancy rate is expected to increase 3% per year |
|
| The average rate is expected to increase 2€ in 2023, 3€ in 2024, 5€ in 2025 and 5€ in 2026 |
| Revenue Info on Ratios |
Food revenue is expected to increase 1% per year |
|
| Beverage revenue is expected to remain constant in 2023, decrease 1% in 2024 and another 1% during 2025, then it will remain constant until 2026 |
|
| Wifi Films and other revenue will remain constant in 2023, decrease 0.6% in 2024, then it will remain constant until 2026 |
|
| SPA revenue will increase 1% per year |
| Departmental Expenses Info on Ratios |
Rooms department expenses will increase 1.5% per year |
|
| F and B department expenses will increase 0.5% per year |
|
| Wifi Films and other revenue department expenses will increase 0.2% per year |
|
| Spa department expenses will increase 0.2% per year |
| Undistributed Operating Expenses Info on Ratios |
General and admistrative expenses will decrease 0.3% per year |
|
| Sales and marketing will increase 0.4% per year |
|
| Property, operations and maitenance will decrease 0.1% per year |
|
| Energy will increase 3% in 2023 and another 3% in 2024, then it will decrease 1% per year in the last 2 years |
| Required: |
| Completed the 2023 - 2026 figures using the above information. |
|
|
| Occupancy : +2% |
|
|
| Average Rate: +15€ |
|
|
| Food revenue +3% |
|
|
| Beverage Revenue +2% |
|
|
| Spa +1,5% |
|
|
| Golf Revenue +1,5% |
|
|
| Rooms Dep Expense:+1,5% |
|
|
| F&B Dep Expense:+1% |
|
|
| Spa Dep Expense -2% |
|
|
| Golf Dep Ex -1% |
|
|
| Admin & General: -0,3% |
|
|
| Sales & Marketing: +0,5% |
|
|
| P.O & Maintenance: -0,1% |
|
|
| NO CHANGE |
|
|
| FIND PEB FOR THE TWO YEARS |
|
|
| FIND LoS for the two years to be able to make a GOP of 1,2M€ |
Faridak3
AssessmentOne_CostadelSolHotelinMarbellaOperatorProjections.xlsx
