hospitality management assignment

profileuryeol
hosp4040.xlsx

Sheet1

Summary Operating Statement
Current Period
Rooms Available 127,750 This is the daily number of rooms in a hotel times the period (Daily, Monthly, Yearly)
Rooms Sold 91,980 This is the daily number of available rooms times the occupancy period
Occupancy % 72% Rooms Sold divided by Rooms Available
ADR 185.00 Room Revenue divided by rooms sold
Rooms RevPAR 133.20 Room Revenue divided by rooms available
Operating Revenue $
Rooms 17,016,300 60.0% Total Room Revenue. Percentage = Room Revenue divided by Total Operating Revenue
Food & Beverage 9,926,175 35.0% Total Food & Beverage Revenue. Percentage = Food & Beverage Revenue divided by Total Operating Revenue
Other Operated Departments 1,418,025 5.0% Total Other Operatating Department Revenue. Percentage = Other Operated departments divided by Total Operating Revenue
Total Operating Revenue 28,360,500 100.0% Sum of Rooms, Food & Beverage, Other Operating Depts, and Miscellaneous Income
Departmental Expenses $ %
Rooms 10,113,040 59.4% Total Rooms Expense. Percentage = Rooms Expense / Room Revenue
Food & Beverage 1,009,329 10.2% Total Food & Beverage Expense. Percentage = Food & Beverage Expense Expense / Food & Beverage Revenue
Other Operated Departments 976,223 68.8% Total Other Operated Departments Expense. Percentage = Total Operating Expense / Food & Beverage Revenue
Total Departmental Expenses 12,098,592 42.7% Sum of Rooms, Food & Beverage, and Other Opertating Depts. Percentage = Total Departmental Expenses divided by Total Operating Revenue
Total Departmental Profit 16,261,908 57.3% Total Operating Revenue minus Total Departmental Expenses
Undistibuted Operating Expenses $ %
Administrative and General 1,501,630 5.3% Total Aministrative & General Expense. Percentage = Total Administrative & General Expense divided by Total Operating Revenue
Information and Telecommunications 1,018,025 3.6% Total Information and Telecommunications Expense. Percentage = Total Information and Telecommunications Expense divided by Total Operating Revenue
Sales & Marketing 1,118,025 3.9% Total Sales & Marketing Expense. Percentage = Total Sales & Marketing Expense divided by Total Operating Revenue
Property Operation and Maintenance 1,278,987 4.5% Total Property Operation and Maintenance Expense. Percentage = Total Property Operation and Maintenance Expense divided by Total Operating Revenue
Utilities 1,387,435 4.9% Total Utilities Expense. Percentage = Total Utilities Expense divided by Total Operating Revenue
Total Undistributed Operating Expenses 6,304,102 22.2% Sum of Administrative & General, Information and Telecommunication, Sales and Marketing, Property Operation & Maintenance, and Utilities. Percentage = Total Undistributed Operating Expense / Total Operating Revenue
Gross Operating Profit 9,957,806 35.1% Total Departmental Profit minus Total Undistributed Operating Expense. Percentage = Gross Operating Profit divided by Total Operating Revenue
Mangement Fees 992,618 3.5% Total Management Fees. Percentage = Management Fees divided by Total Operating Revenue
Income Before Non-Operating Income and Expenses (NOI) 8,965,188 31.6% Gross Operating Profit. Percentage = Income before Non-Operating Income divided by Total Operating Revenue
Property Taxes 750,815 2.6% Total Property Taxes. Percentage = Total Property Taxes divided by Total Operating Revenue
Insurance 1,001,630 3.5% Total Insurance. Percentage = Total Insurance divided by Total Operating Revenue
Interest Expense 1,110,050 3.9% Total Interest Expense. Percentage = Total Interest Expense divided by Total Operating Revenue
Depreciation and Amorization 850,815 3.0% Total Depreciation and Amorization. Percentage = Total Depreciation and Amorization divided by Total Operating Revenue
Net Profit 5,511,113 19.4% Income before Non-Operating Income minus property taxes, Insurance, Interest Expense, and depreciation and Amorization
Percentage = Net Profit divided by Total Operating Income

Sheet3

Summary Operating Statement
Independent Soft brand Core brand
Rooms Available 127,750 127,750 127,750
Rooms Sold 91,980 121,362 121,362
Occupancy % 72% 95% 95%
ADR 185.00 192.00 192.00
Rooms RevPAR 133.20
Operating Revenue $
Rooms 17,016,300 60.0% 23,301,504 23,301,504
Food & Beverage 9,926,175 35.0% 9,926,175
Other Operated Departments 1,418,025 5.0%
Total Operating Revenue 28,360,500 100.0%
Departmental Expenses $ %
Rooms 10,113,040 59.4%
Food & Beverage 1,009,329 10.2%
Other Operated Departments 976,223 68.8%
Total Departmental Expenses 12,098,592 42.7%
Total Departmental Profit 16,261,908 57.3%
Undistibuted Operating Expenses $ %
Administrative and General 1,501,630 5.3%
Information and Telecommunications 1,018,025 3.6%
Sales & Marketing 1,118,025 3.9%
Property Operation and Maintenance 1,278,987 4.5%
Utilities 1,387,435 4.9%
Total Undistributed Operating Expenses 6,304,102 22.2%
Gross Operating Profit 9,957,806 35.1%
Mangement Fees 992,618 3.5%
Income Before Non-Operating Income and Expenses (NOI) 8,965,188 31.6%
Property Taxes 750,815 2.6%
Insurance 1,001,630 3.5%
Interest Expense 1,110,050 3.9%
Depreciation and Amorization 850,815 3.0%
Net Profit 5,511,113 19.4%