WorksheetsP&L Summary Quiz
Total questions: 50
Worksheet time: 25mins
Summary Operating Statements are designed to
Provide management with information regarding the results of operations, and
Facilitate the comparison of such results among different lodging properties.
Provide management with information regarding the Expense of operations, and
Facilitate the comparison of such results among different lodging properties.
Provide management with information regarding the Revenue of operations, and
Facilitate the comparison of such results among different lodging properties.
Operating revenue include
Room, Food & Bev, Other Operated Dept
Room, Food & Bev, Spa & Recreation
Room, Food & Bev, Miscellaneous Income
Room, Food & Bev, Other Operated Dept, Miscellaneous Income
Dept Expenses include
Room, Food & Bev, Other Operated Dept
Room, Food & Bev, Other Operated Dept, Other Operated Dept, Miscellaneous Income
Room, Food & Bev, Other Operated Dept, Miscellaneous Income
Undistributed Opt Exp include
A&G, IT, S&M, Utilities
A&G, IT, S&M, POMEC
A&G, IT, S&M, POMEC, Utilities
A&G, IT, S&M
Which department belong to A&G?
Finance, Administration, Security
Finance, Administration, Security, Human Resource
Finance, Administration, Human Resource
Electricity will belong to which department?
A&G
Finance
Utilities
POMEC
Which department belong to Room division?
Front Office/Residence, House Keeping, & Transportation and Boutique
Front Office/Residence, House Keeping, & Boutique
Front Office/Residence, House Keeping, & Transportation
Front Office & House Keeping and Reservation
Which department is belonged to F&B division?
Restaurants
Kitchen
Boths
What is Micellaneous revenue?
space rental, commissions, and interest income
Paid out
Currency exchange
Retail
Spa will belong to which division?
Spa
Other Operated Dept
Room Dept
F&b Dept
Reservation will belong to which Division?
Room
F&B Dept
S&M
A&G
Kitchen will belong to which divison?
Kitchen
A&G
F&B
F&B Dept
Security will belong to which division
Human Resources
POMEC
A&G
IT
Structure of Operating Statement will include:
Financial ratio, Operating revenue, Dept Exp, Undistributied Operation Exp
Gross Operation Profit
EBITDA
All in above
How many categories of departmental expenses, each of which relates to an operated department revenue category
Three categories of departmental expenses: Room, F&B, OOD
Two categories of departmental expenses: Room, F&B
Four categories of departmental expenses: Room, F&B, OOD and Miscellaneous
Departmental expenses are separated into how many group?
Four groups: Cost of Sales, Cost of Other Revenue, Labor Costs and Related Expenses, Other Expenses
Three groups: Cost of Sales, Labor Costs and Related Expenses, Other Expenses
Three groups: Cost of Sales, Labor Costs and Related Expenses, Cost of Other Revenue
Four groups: Cost of Sales, Cost of Other Revenue, Labor Costs and Related Expenses, Fees
How to calculate Total Deprt Profit?
Total Departmental Profit = Profit of Room + Profit of F&B + Profit of OOD
Total Departmental Profit = Total Revenue of ((Rooms, FB, OOD & Miscellaneous) - Total Expenses of (Rooms, FB, OOD)
Total Departmental Profit = Total Operating Revenue - Total Departmental Expenses
All in above
What is Room Available
the number of Hotel rooms that are available for sale to guests which does not include house use or commercial rooms but includes rooms which are out of order and complimentary rooms
Room Avlb = Total room - HSE
Room available include out of order and complimentary rooms
All in above
What is Room Sold
Room Sold = Total room – HSE – OOD - COMP
Room Sold = Total room – OOD - COMP
Room Sold = Total room – HSE –COMP
Room Sold = Total room – OOD
Average Daily Rate (ADR)
the ADR reveals the average rate charged per sold room and is calculated by dividing total rooms revenue for a period by the number of rooms sold during that period. Complimentary rooms are not included in the denominator of the ADR calculation
the ADR shows the amount of revenue generated by one room, whether booked or not. There are two ways to calculate it
the ADR shows the amount of revenue generated by one room, whether booked or not. There are two ways to calculate it. You can either divide your total room revenue by the total number of available rooms
the ADR reveals the average rate charged per sold room and is calculated by dividing total rooms revenue for a period by the number of rooms available during that period. Complimentary rooms are not included in the denominator of the ADR calculation
Complimentary rooms are included in the denominator of the ADR calculation or Not?
Are not included
Are included
Occupancy (%)
An occupancy rate is measured by dividing the number of occupied rooms by the number of available rooms and multiplying by 100, showing the percentage of rooms occupied at a specific moment
Occ % = No of Occ room / Room Inventory
Occ % = No of Occ room / Room Sold
Rooms Revenue per Available Room (RevPAR)
RevPAR shows the amount of revenue generated by one room, whether booked or not. There are two ways to calculate it. You can either divide your total room revenue by the total number of available rooms OR multiply ADR by the occupancy rate.
RevPAR shows the amount of revenue generated by one room sold. You can either divide your total room revenue by the total number of Room sold
RevPAR shows the amount of revenue generated by one roominventory , whether booked or not. There are two ways to calculate it. You can either divide your total room revenue by the total number of available rooms OR multiply ADR by the occupancy rate.
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$
Room Available = 98
Room Available = 93
Room Available = 100
Room Available = 90
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$
Room Sold = 50
Room Sold = 52
Room Sold = 55
Room Sold = 60
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$
ADR=10,000 USD/50 = 200$
ADR=10,000 USD/58 = 172$
ADR=10,000 USD/60 = 167$
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$
Occupancy (%)= (55/98 = 56.1%
Occupancy (%)= (50+3)/98 = 54.08%
Occupancy (%)= (50/100 = 50%
Occupancy (%)= (60/100 = 60%
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$
RevPAR= 10,000/50 = 200$
RevPAR= 10,000/90 = 111.11$
RevPAR= 10,000/98 = 102.04$
RevPAR= 10,000/100 = 100$
What is GOP?
It is a KPI which refers to the Hotels profits after subtracting all of their operating expenses. It illustrates the level of operational profitability of a hotel
GOP Formula: Gross Operating Revenue – Gross Operating Expences
It is a KPI which refers to the Room revenue after subtracting all of their operating expenses. It illustrates the level of operational profitability of a hotel
GOP Formula: Operating Revenue of Room– Gross Operating Expences
It is a KPI which refers to the Room profits after subtracting all of their operating expenses. It illustrates the level of operational profitability of a hotel
GOP Formula: Gross Operating Room Revenue – Gross Room Expences
ADR - Why to use?
an important KPI that shows how full your hotel is. To understand how your hotel is performing in different periods & what to focus your marketing efforts
one of the essential performance indicators that basically shows how much money each room brings you. Monitor it throughout time and compare it to your competitors to make decisions about your pricing strategy
one of the most popular metrics in hospitality. It’s similar to ADR, but takes the unsold room into account, giving a more accurate picture. hoteliers have to aim at increasing their RevPAR since it reflects both the pricing for rooms and the ability to fill them
an important indicator for hotels managing multiple points of sale
to develop the revenue potential of all hotel departments and adjust the package offers as well as the entire upselling strategy
Occupancy (%) - Why to use?
an important KPI that shows how full your hotel is. To understand how your hotel is performing in different periods & what to focus your marketing efforts
one of the essential performance indicators that basically shows how much money each room brings you. Monitor it throughout time and compare it to your competitors to make decisions about your pricing strategy
one of the most popular metrics in hospitality. It’s similar to ADR, but takes the unsold room into account, giving a more accurate picture. hoteliers have to aim at increasing their RevPAR since it reflects both the pricing for rooms and the ability to fill them
an important indicator for hotels managing multiple points of sale
to develop the revenue potential of all hotel departments and adjust the package offers as well as the entire upselling strategy
RevPAR - Why to use?
an important KPI that shows how full your hotel is. To understand how your hotel is performing in different periods & what to focus your marketing efforts
one of the essential performance indicators that basically shows how much money each room brings you. Monitor it throughout time and compare it to your competitors to make decisions about your pricing strategy
one of the most popular metrics in hospitality. It’s similar to ADR, but takes the unsold room into account, giving a more accurate picture. hoteliers have to aim at increasing their RevPAR since it reflects both the pricing for rooms and the ability to fill them
an important indicator for hotels managing multiple points of sale
to develop the revenue potential of all hotel departments and adjust the package offers as well as the entire upselling strategy
Undistributed Operating Expenses are considered applicable to the entire
property & separated into how many categories:
5: A&G, POMEC, IT, HR, S&M
5: A&G, POMEC, IT, Utilities, S&M
4: A&G, POMEC, IT, S&M
4:Utilites, POMEC, IT, S&M
Which department belong to A&G?
Executive Office, Finance, HR, Security
Executive Office, Finance, HR
Executive Office, Finance, HR, Canteen
Executive Office, Finance, HR, Canteen and Laundry
What expenses will be included in Utilities?
Eletricity, Water, Diesel
Eletricity, Water
Eletricity only
Opera maintenance & support is 1000 USD per year. This expense should be belonged to which deparment?
IT
A&G
FO
POMEC
Laundry maintenance is 2000 USD per year. This expense should be belonged to which deparment?
HSK
A&G
Laundry
POMEC
Expense of electicity in May is 834 mil. This expense should be belonged to which deparment?
POMEC
A&G
Owner
Utilities
Expense of Sale trip in Korea is 2,000 USD. This expense should be belonged to which deparment?
A&G
Finance
S&M
Reservation
Buying 10 pcs of buggy bartery to replace the old of Residence's buggy. This expense should be belonged to which deparment?
Residence
POMEC
Finance
IT
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$. Profit of room = 85%, FB=40%, OOD = 25%. How much is Operating rev?
Operating Rev = 17,100$
Room Rev = 10,000$
Operating Rev = 17,000$
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$. Profit of room = 85%, FB=40%, OOD = 25%. How much is Room Exp?
Room Exp =1,500$
Room Exp =8,500$
Room Exp =10,00$
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$. Profit of room = 85%, FB=40%, OOD = 25%. How much is Operating Exp?
Operating EXP = 4,500$
Operating EXP = 4,575$
Operating EXP = 6,075$
Operating EXP = 3,075$
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$. Profit of room = 85%, FB=40%, OOD = 25%. Room Profit amount & Room profit %?
8,500 USD, 15%
8,500 USD, 85%
1,500 USD, 85%
1,500 USD, 15%
if you have a 100-room hotel and last night guest paid 50 rooms, 2 rooms – house use for GM & EAM, 3 complimentary rooms for S&M; 5 rooms OOD; Rooms: 10,000$, F&B: 5,000$, Spa 2,000$, paid out commission: 100$. Profit of room = 85%, FB=40%, OOD = 25%. F&B Profit amount & F&B profit %?
2,000 USD, 60%
2,000 USD, 40%
2,000 USD, 50%
2,000 USD, 30%
Operating Rev = 17,100$; Operating EXP = 6,075$, Operating Profit = 11,025$, Room Rev = 10,000$; F&B Rev = 5,000$. How much is OOD?
GOP= 11,025$
GOP= 17,100$
GOP= 15,000$
Operating Rev = 17,100$; Operating EXP = 6,075$, Operating Profit = 11,025$, Room Rev = 9,000$; F&B Rev = 4,000$. How much is OOD rev?
OOD = 2,100
OOD = 4,100
OOD = 4,101
OOD = 2,110
EBITDA là gì & ý nghĩa?
EBITDA - Earning before interest, taxes, depreciation and amortization
Ebitda có nghĩa là lợi nhuận trước thuế, khấu hao và lãi vay
EBITDA - Earning before interest, taxes, depreciation and amortization
Ebitda còn được xem là lợi nhuận hoạt động của công ty, doanh nghiệp
EBITDA - Earning before interest, taxes, depreciation and amortization
Ebitda là thước đo quan trọng nhất để xác định hiệu quả tài chính của công ty
Tất cả các câu trả lời trên
Ý nghĩa vai trò của EBITDA?
đánh giá hiệu quả kinh doanh của doanh nghiệp được chính xác hơn, từ đó phán đoán đúng về tiềm năng phát triển trong tương lai
đánh giá đúng về tiềm năng của mỗi công ty, từ đó đưa ra lựa chọn đầu tư đúng đắn nhất (loại trừ yếu tố thuế TNDN lớn)
EBITDA = Lợi nhuận sau thuế + Thuế + Lãi vay + Khấu hao
EBITDA = EBIT + Khấu hao
Ebitda bao gồm doanh thu trừ đi chi phí, ngoại trừ chi phí khấu hao, lãi vay và thuế thu nhập cá nhân. Chính vì vậy, nó là thước đo về lợi nhuận của công ty.
Cách tính phí quản lý - Management fee như thế nào?
Fees = fix % * Total Operation Revenue
Fees = fix % * Total Room Revenue
Fees = fix % * Total Operation Exp
Fees = fix % * Total Operation Profit
