PART 2:
The General Manager of The Cougar Hotel would like you to take the balances for 20X7 and
20X8 and;
1. Prepare a comparative Summary Operating Statement that is in compliance with the USALI 11th Edition (i.e. make sure it is in the correct format, use the template found in the Income Statement module or in the “Other Course Resources” folder).
2. Once the Summary Operating Statement has been completed, perform a vertical and
horizontal analysis of the statement.
THE COUGAR HOTEL 20X7 20X8
Administrative and General 1,426,678 1,460,830
Beverage Revenue 1,333,039 1,337,700
Building Wall Rent Received 250,000
Cell Tower Rent Received 500,000
Food and Beverage 3,999,116 4,122,300
Food and Beverage Expenses 4,265,724 4,340,000
Gain on Sale of Equipment 150,000
Inforamation and Telecommunications Systems 281,813 267,225
Insurance 264,200 285,040
Loss on Sale of Equipment 200,000
Management Fees 528,399 534,450
Miscellaneous Income 447,213 385,000
Property and Other Taxes 704,532 694,785
Property Operating and Maintenance 563,626 623,525
Recreation Department 440,333 450,450
Recreation Department Expenses 577,937 567,000
Replacement Reserve 1,409,065 1,425,200
Room Revenue 10,733,112 10,815,000
Rooms Department Expenses 2,992,887 3,010,000
Sales and Marketing 1,268,158 1,371,755
Spa Expenses 385,291 378,000
Spa Revenue 660,499 704,550
Utilities 792,599 748,230
CHECK FIGURES:
These are totals that you can use to check and see if your math is correct and also check if you have figures placed correctly.
20X7 20X8
Total Departmental Profit 9,391,473 9,520,000
Gross Operating Profit 5,058,599 5,048,435
EBITDA Less Replacement Reserve 2,452,403 2,508,960
