Les Roches 2023-1 Program: Assessment title: EMIHM Assessment One (25%) Dear Students, Good Luck! Course name and No.: Type: S M 9214 Hospitality Real Estate and Investment Practical Please solve

the following problem on the shared Excel file "Assessment One Costa del Sol Hotel in Marbella Operator Projections" and kindly upload the excel file on Moodle when done. Please rename the file with your name. Problem 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: ● Revenue Info on Ratios: ● 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. Departmental Expenses 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. Wi-Fi 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. ● Rooms department expenses will increase 1.5% per year. F and B department expenses will increase 0.5% per year Wi-Fi 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 administrative expenses will decrease 0.3% per year. Sales and marketing will increase 0.4% per year. Property, operations, and maintenance 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: Complete the 2023 - 2026 figures on the shared Excel file using the above information. Good Luck/n