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