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.

• 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.

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

• 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.