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