Reference no: EM133201795
Problem:
Prepare Income (Profit & Loss) statement for Greenfield Hotel for financial year 2020. Greenfield Hotel has following income & expenses. All income & expenses for the year 2020 are in million dollars.
REVENUE:
|
Particulars
|
Particulars
|
Amount (in million dollars)
|
|
Rooms
|
|
|
|
|
Total rooms occupied
|
60
|
|
|
Lodging revenue
|
105
|
|
|
Cancellation / No show
|
2 (Considered as Revenue)
|
|
|
OTA rooms
|
5
|
|
|
|
|
|
|
|
|
|
Food & Beverage
|
|
|
|
|
Food
|
65
|
|
|
Beverage
|
30
|
|
|
Other
|
3
|
|
Miscellaneous
|
|
|
|
|
Events
|
15
|
|
|
Conferences
|
10
|
|
|
Spa
|
8
|
|
|
Parking
|
6
|
|
|
Other
|
3
|
|
Total Revenue
|
|
252
|
|
|
|
|
EXPENSES:
|
Particulars
|
Particulars
|
Amount (in million dollars)
|
|
Operating Expenses
|
|
|
|
|
Guest served
|
300
|
|
|
Housekeeping Laundry
|
12
|
|
|
Food Cost
|
9
|
|
|
Beverage Cost
|
5
|
|
|
Cleaning
|
4
|
|
|
Events
|
7
|
|
|
Conferences
|
6
|
|
|
Parking
|
2
|
|
|
Other
|
1
|
|
Miscellaneous Expenses
|
|
|
|
|
Administration & General
|
4
|
|
|
Payroll (Attendant)
|
50
|
|
|
Marketing & Distribution
|
3
|
|
|
Utilities
|
2
|
|
Total operating & miscellaneous expenses
|
|
105
|
|
Fixed Charges
|
|
|
|
|
Lease
|
40
|
|
|
Management Fees
|
8
|
|
|
Depreciation
|
4
|
|
|
Other
|
1
|
|
|
Interest
|
2
|
|
Total Expenses
|
|
160
|
|
Taxes @ 30%
|
|
|
NOTE
Questions:
Calculate gross profit of Hotel Greenfield
Calculate net profit of Hotel Greenfield
Calculate taxes @ 30 percent
Calculate earnings before interest, taxes & depreciation
Calculate Room Revenue as a percentage of total revenue
Calculate Food & Beverage revenue as a percentage of total revenue
Calculate Miscellaneous revenue as a percentage of total revenue
Find the CPOR (Attendant) cost per Occupied room) according to the PNL.
Find the food cost per guest as per the PNL.
Differentiate and separate between assets and liability as per below table.
PREPARE A TABLE FOR ASSETS AND LIABILITES UNDER EXCEL.
|
Good will
|
|
Accounts receivable
|
|
Prepaid Expenses
|
|
Royalty
|
|
Accounts payable
|
|
Accrued expenses
|
|
Inventory
|
|
Investment
|
|
Cash in hand
|
|
Suppliers / Vendors
|
|
Wages payable
|
|
Deferred Revenue
|
|
Business Credit card
|
|
Loan payment Amount.
|